Changeset 253 for trunk


Ignore:
Timestamp:
02/01/13 17:09:36 (7 years ago)
Author:
astrid.emde
Message:

ORACLE Syntax zur Geometriespaletenerstellung noch anpassen

File:
1 edited

Legend:

Unmodified
Added
Removed
  • trunk/import/pp_definition_ORACLE.sql

    r244 r253  
    1212    kreis               integer, 
    1313    gemeinde            integer NOT NULL, 
    14     gemeindename        character varying(80), 
     14    gemeindename        varchar2(80), 
    1515    anz_gemarkg         integer, 
    16     CONSTRAINT ALKIS_KEY_0 PRIMARY KEY (land, gemeinde) 
     16    CONSTRAINT ALKIS_KEYPP_0 PRIMARY KEY (land, gemeinde) 
    1717  ); 
    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; 
     18CREATE UNIQUE INDEX ALKIS_KEYPP_1 ON pp_gemeinde (gid); 
     19 
     20--TODO SELECT AddGeometryColumn('pp_gemeinde','the_geom','25832','MULTIPOLYGON',2); 
     21 
     22CREATE 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 
     26CREATE INDEX ALKIS_KEYPP_3 ON PP_GEMEINDE(SIMPLE_GEOM) INDEXTYPE IS MDSYS.SPATIAL_INDEX PARALLEL; 
    2327  COMMENT ON TABLE  pp_gemeinde                IS 'Post-Processing: Gemeinde'; 
    2428  COMMENT ON COLUMN pp_gemeinde.gemeinde       IS 'Gemeindenummer'; 
     
    3640    gemeinde            integer NOT NULL, 
    3741    gemarkung           integer NOT NULL, 
    38     gemarkungsname      character varying(80), 
     42    gemarkungsname      varchar2(80), 
    3943    anz_flur            integer, 
    40     CONSTRAINT ALKIS_KEY_4 PRIMARY KEY (land, gemarkung) 
     44    CONSTRAINT ALKIS_KEYPP_4 PRIMARY KEY (land, gemarkung) 
    4145  ); 
    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; 
     46CREATE UNIQUE INDEX ALKIS_KEYPP_5 ON pp_gemarkung (gid); 
     47--TODO SELECT AddGeometryColumn('pp_gemarkung','the_geom','25832','MULTIPOLYGON',2); 
     48CREATE 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); 
     50CREATE INDEX ALKIS_KEYPP_7 ON PP_GEMARKUNG(SIMPLE_GEOM) INDEXTYPE IS MDSYS.SPATIAL_INDEX PARALLEL; 
    4751COMMENT ON TABLE  pp_gemarkung               IS 'Post-Processing: Gemarkung. u.a. liegt in welcher Gemeinde'; 
    4852COMMENT ON COLUMN pp_gemarkung.gemeinde      IS 'Gemeindenummer'; 
     
    6266    flurnummer          integer NOT NULL, 
    6367    anz_fs              integer, 
    64     CONSTRAINT ALKIS_KEY_8 PRIMARY KEY (land, gemarkung, flurnummer) 
     68    CONSTRAINT ALKIS_KEYPP_8 PRIMARY KEY (land, gemarkung, flurnummer) 
    6569  ); 
    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; 
     70CREATE UNIQUE INDEX ALKIS_KEYPP_9 ON pp_flur (gid); 
     71--TODO SELECT AddGeometryColumn('pp_flur','the_geom','25832','MULTIPOLYGON',2); 
     72CREATE INDEX ALKIS_KEYPP_10 ON PP_FLUR(THE_GEOM) INDEXTYPE IS MDSYS.SPATIAL_INDEX PARALLEL; 
    6973COMMENT ON TABLE  pp_flur                IS 'Post-Processing: Flur'; 
    7074COMMENT ON COLUMN pp_flur.gemarkung      IS 'Gemarkungsnummer'; 
     
    7983    kreis               integer, 
    8084    gemeinde            integer, 
    81     person              character varying(16), 
     85    person              varchar2(16), 
    8286    buchtyp             integer, 
    83     CONSTRAINT ALKIS_KEY_11 PRIMARY KEY (gemeinde, person) 
     87    CONSTRAINT ALKIS_KEYPP_11 PRIMARY KEY (gemeinde, person) 
    8488  ); 
    8589COMMENT ON TABLE  gemeinde_person            IS 'Person ist EigentÃŒmer von mindestens einem FlurstÃŒck in der Gemeinde'; 
     
    8791COMMENT ON COLUMN gemeinde_person.buchtyp    IS 'Typ der Buchung 1=direkt, 2=Recht einer Buchungsstele an andere Buchungsstelle'; 
    8892COMMENT ON COLUMN gemeinde_person.person     IS 'gml_id von Person'; 
    89 CREATE INDEX ALKIS_KEY_12  ON gemeinde_person (person, gemeinde); 
     93CREATE INDEX ALKIS_KEYPP_12  ON gemeinde_person (person, gemeinde); 
    9094   
    9195DELETE FROM user_sdo_geom_metadata WHERE upper(table_name)='PP_FLURSTUECK_NR'; 
     
    9599    gid         integer, 
    96100    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) 
    99103  ); 
    100104SELECT 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); 
     105CREATE INDEX ALKIS_KEYPP_14 ON PP_FLURSTUECK_NR(THE_GEOM) INDEXTYPE IS MDSYS.SPATIAL_INDEX PARALLEL; 
     106CREATE INDEX ALKIS_KEYPP_15 ON pp_flurstueck_nr(fsgml); 
    103107COMMENT ON TABLE  pp_flurstueck_nr           IS 'Post-Processing: Position der FlurstÃŒcksnummer in der Karte'; 
    104108COMMENT 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.