comparison flys-backend/doc/schema/oracle-spatial.sql @ 5028:a5f438895a38 dami

SCHEMA CHANGE: removed catchements from schema and geo-importer (obsolete)
author Tom Gottfried <tom.gottfried@intevation.de>
date Tue, 19 Feb 2013 19:24:36 +0100
parents 9ef49f3b0304
children 57a845da72bd
comparison
equal deleted inserted replaced
5026:bdef4c74d675 5028:a5f438895a38
146 CREATE OR REPLACE TRIGGER dem_trigger BEFORE INSERT ON dem FOR each ROW 146 CREATE OR REPLACE TRIGGER dem_trigger BEFORE INSERT ON dem FOR each ROW
147 BEGIN 147 BEGIN
148 SELECT DEM_ID_SEQ.nextval INTO :new.id FROM dual; 148 SELECT DEM_ID_SEQ.nextval INTO :new.id FROM dual;
149 END; 149 END;
150 / 150 /
151
152
153 -- Hydrologie/Einzugsgebiete/EZG.shp
154 CREATE SEQUENCE CATCHMENT_ID_SEQ;
155 CREATE TABLE catchment(
156 OGR_FID NUMBER(38),
157 GEOM MDSYS.SDO_GEOMETRY,
158 river_id NUMBER(38) REFERENCES rivers(id) ON DELETE CASCADE,
159 area NUMBER(19,5),
160 name VARCHAR2(255),
161 path VARCHAR(256),
162 ID NUMBER PRIMARY KEY NOT NULL
163 );
164 INSERT INTO USER_SDO_GEOM_METADATA VALUES ('CATCHMENT', 'GEOM', MDSYS.SDO_DIM_ARRAY(MDSYS.SDO_DIM_ELEMENT('X',3282450,3912240,0.001),MDSYS.SDO_DIM_ELEMENT('Y',5248260,6100130,0.001),MDSYS.SDO_DIM_ELEMENT('Z',-100000,100000,0.002)), 31467);
165
166 CREATE TRIGGER catchment_trigger BEFORE INSERT ON catchment FOR each ROW
167 BEGIN
168 SELECT CATCHMENT_ID_SEQ.nextval INTO :new.id FROM dual;
169 END;
170 /
171 --CREATE INDEX catchment_spatial_idx ON catchment(GEOM) indextype IS MDSYS.SPATIAL_INDEX parameters ('LAYER_GTYPE=polygon');
172 151
173 --Static lookup tables for Hochwasserschutzanlagen 152 --Static lookup tables for Hochwasserschutzanlagen
174 CREATE TABLE hws_kinds ( 153 CREATE TABLE hws_kinds (
175 id NUMBER PRIMARY KEY NOT NULL, 154 id NUMBER PRIMARY KEY NOT NULL,
176 kind VARCHAR(64) NOT NULL 155 kind VARCHAR(64) NOT NULL

http://dive4elements.wald.intevation.org