Changeset 253 for trunk/import
- Timestamp:
- 02/01/13 17:09:36 (11 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
trunk/import/pp_definition_ORACLE.sql
r244 r253 12 12 kreis integer, 13 13 gemeinde integer NOT NULL, 14 gemeindename character varying(80),14 gemeindename varchar2(80), 15 15 anz_gemarkg integer, 16 CONSTRAINT ALKIS_KEY _0 PRIMARY KEY (land, gemeinde)16 CONSTRAINT ALKIS_KEYPP_0 PRIMARY KEY (land, gemeinde) 17 17 ); 18 CREATE UNIQUE INDEX ALKIS_KEY_1 ON pp_gemeinde (gid); 19 SELECT AddGeometryColumn('pp_gemeinde','the_geom','25832','MULTIPOLYGON',2); 20 CREATE INDEX ALKIS_KEY_2 ON PP_GEMEINDE(THE_GEOM) INDEXTYPE IS MDSYS.SPATIAL_INDEX PARALLEL; 21 SELECT AddGeometryColumn('pp_gemeinde','simple_geom','25832','MULTIPOLYGON',2); 22 CREATE INDEX ALKIS_KEY_3 ON PP_GEMEINDE(SIMPLE_GEOM) INDEXTYPE IS MDSYS.SPATIAL_INDEX PARALLEL; 18 CREATE UNIQUE INDEX ALKIS_KEYPP_1 ON pp_gemeinde (gid); 19 20 --TODO SELECT AddGeometryColumn('pp_gemeinde','the_geom','25832','MULTIPOLYGON',2); 21 22 CREATE INDEX ALKIS_KEYPP_2 ON PP_GEMEINDE(THE_GEOM) INDEXTYPE IS MDSYS.SPATIAL_INDEX PARALLEL; 23 24 --TODO SELECT AddGeometryColumn('pp_gemeinde','simple_geom','25832','MULTIPOLYGON',2); 25 26 CREATE INDEX ALKIS_KEYPP_3 ON PP_GEMEINDE(SIMPLE_GEOM) INDEXTYPE IS MDSYS.SPATIAL_INDEX PARALLEL; 23 27 COMMENT ON TABLE pp_gemeinde IS 'Post-Processing: Gemeinde'; 24 28 COMMENT ON COLUMN pp_gemeinde.gemeinde IS 'Gemeindenummer'; … … 36 40 gemeinde integer NOT NULL, 37 41 gemarkung integer NOT NULL, 38 gemarkungsname character varying(80),42 gemarkungsname varchar2(80), 39 43 anz_flur integer, 40 CONSTRAINT ALKIS_KEY _4 PRIMARY KEY (land, gemarkung)44 CONSTRAINT ALKIS_KEYPP_4 PRIMARY KEY (land, gemarkung) 41 45 ); 42 CREATE UNIQUE INDEX ALKIS_KEY _5 ON pp_gemarkung (gid);43 SELECT AddGeometryColumn('pp_gemarkung','the_geom','25832','MULTIPOLYGON',2);44 CREATE INDEX ALKIS_KEY _6 ON PP_GEMARKUNG(THE_GEOM) INDEXTYPE IS MDSYS.SPATIAL_INDEX PARALLEL;45 SELECT AddGeometryColumn('pp_gemarkung','simple_geom','25832','MULTIPOLYGON',2);46 CREATE INDEX ALKIS_KEY _7 ON PP_GEMARKUNG(SIMPLE_GEOM) INDEXTYPE IS MDSYS.SPATIAL_INDEX PARALLEL;46 CREATE UNIQUE INDEX ALKIS_KEYPP_5 ON pp_gemarkung (gid); 47 --TODO SELECT AddGeometryColumn('pp_gemarkung','the_geom','25832','MULTIPOLYGON',2); 48 CREATE INDEX ALKIS_KEYPP_6 ON PP_GEMARKUNG(THE_GEOM) INDEXTYPE IS MDSYS.SPATIAL_INDEX PARALLEL; 49 --TODO SELECT AddGeometryColumn('pp_gemarkung','simple_geom','25832','MULTIPOLYGON',2); 50 CREATE INDEX ALKIS_KEYPP_7 ON PP_GEMARKUNG(SIMPLE_GEOM) INDEXTYPE IS MDSYS.SPATIAL_INDEX PARALLEL; 47 51 COMMENT ON TABLE pp_gemarkung IS 'Post-Processing: Gemarkung. u.a. liegt in welcher Gemeinde'; 48 52 COMMENT ON COLUMN pp_gemarkung.gemeinde IS 'Gemeindenummer'; … … 62 66 flurnummer integer NOT NULL, 63 67 anz_fs integer, 64 CONSTRAINT ALKIS_KEY _8 PRIMARY KEY (land, gemarkung, flurnummer)68 CONSTRAINT ALKIS_KEYPP_8 PRIMARY KEY (land, gemarkung, flurnummer) 65 69 ); 66 CREATE UNIQUE INDEX ALKIS_KEY _9 ON pp_flur (gid);67 SELECT AddGeometryColumn('pp_flur','the_geom','25832','MULTIPOLYGON',2);68 CREATE INDEX ALKIS_KEY _10 ON PP_FLUR(THE_GEOM) INDEXTYPE IS MDSYS.SPATIAL_INDEX PARALLEL;70 CREATE UNIQUE INDEX ALKIS_KEYPP_9 ON pp_flur (gid); 71 --TODO SELECT AddGeometryColumn('pp_flur','the_geom','25832','MULTIPOLYGON',2); 72 CREATE INDEX ALKIS_KEYPP_10 ON PP_FLUR(THE_GEOM) INDEXTYPE IS MDSYS.SPATIAL_INDEX PARALLEL; 69 73 COMMENT ON TABLE pp_flur IS 'Post-Processing: Flur'; 70 74 COMMENT ON COLUMN pp_flur.gemarkung IS 'Gemarkungsnummer'; … … 79 83 kreis integer, 80 84 gemeinde integer, 81 person character varying(16),85 person varchar2(16), 82 86 buchtyp integer, 83 CONSTRAINT ALKIS_KEY _11 PRIMARY KEY (gemeinde, person)87 CONSTRAINT ALKIS_KEYPP_11 PRIMARY KEY (gemeinde, person) 84 88 ); 85 89 COMMENT ON TABLE gemeinde_person IS 'Person ist EigentÃŒmer von mindestens einem FlurstÃŒck in der Gemeinde'; … … 87 91 COMMENT ON COLUMN gemeinde_person.buchtyp IS 'Typ der Buchung 1=direkt, 2=Recht einer Buchungsstele an andere Buchungsstelle'; 88 92 COMMENT ON COLUMN gemeinde_person.person IS 'gml_id von Person'; 89 CREATE INDEX ALKIS_KEY _12 ON gemeinde_person (person, gemeinde);93 CREATE INDEX ALKIS_KEYPP_12 ON gemeinde_person (person, gemeinde); 90 94 91 95 DELETE FROM user_sdo_geom_metadata WHERE upper(table_name)='PP_FLURSTUECK_NR'; … … 95 99 gid integer, 96 100 fsgml character(16), 97 fsnum character varying(10),98 CONSTRAINT ALKIS_KEY _13 PRIMARY KEY (gid)101 fsnum varchar2(10), 102 CONSTRAINT ALKIS_KEYPP_13 PRIMARY KEY (gid) 99 103 ); 100 104 SELECT AddGeometryColumn('pp_flurstueck_nr','the_geom','25832','POINT',2); 101 CREATE INDEX ALKIS_KEY _14 ON PP_FLURSTUECK_NR(THE_GEOM) INDEXTYPE IS MDSYS.SPATIAL_INDEX PARALLEL;102 CREATE INDEX ALKIS_KEY _15 ON pp_flurstueck_nr(fsgml);105 CREATE INDEX ALKIS_KEYPP_14 ON PP_FLURSTUECK_NR(THE_GEOM) INDEXTYPE IS MDSYS.SPATIAL_INDEX PARALLEL; 106 CREATE INDEX ALKIS_KEYPP_15 ON pp_flurstueck_nr(fsgml); 103 107 COMMENT ON TABLE pp_flurstueck_nr IS 'Post-Processing: Position der FlurstÃŒcksnummer in der Karte'; 104 108 COMMENT ON COLUMN pp_flurstueck_nr.fsgml IS 'gml_id des zugehörigen FlurstÃŒcks-Objektes';
Note: See TracChangeset
for help on using the changeset viewer.