Changeset 336 for trunk/import/alkis_PostNAS_schema.sql
- Timestamp:
- 09/19/14 13:52:07 (10 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
trunk/import/alkis_PostNAS_schema.sql
r332 r336 11 11 -- (cd /pfad/zu/postnas; psql -f alkis_PostNAS_schema.sql) 12 12 13 -- Variable fÃŒr das Koordinatensystem ÃŒbergeben mit "psql .. -v alkis_epsg= 25832"13 -- Variable fÃŒr das Koordinatensystem ÃŒbergeben mit "psql .. -v alkis_epsg="25832" 14 14 15 15 … … 53 53 -- "delete"-Tabelle aus Norbit-Version passend zum Hist-Trigger. 54 54 55 -- 2014-09-17 FJ Die aus der Norbit-Version ÃŒbernommene Ãnderung des Formates von "gml_id" auf "character variyng". 56 -- wieder rÃŒckgÀngig machen. Dies ist auch dort inzwischen revertiert worden und die aktuelle 57 -- Trigger-Function "delete_feature_hist()" arbeitet fehlerhaft, wenn die gml_id lÀnger als 16 Zeichen sind. 58 -- Aktuell: "gml_id character(16) NOT NULL" 59 55 60 -- Dies Schema kann NICHT mehr mit der gdal-Version 1.9 verwendet werden. 56 61 … … 90 95 -- Kann mit "alkis_beziehungen" entfallen, wenn alle Views und Programm umgestellt sind auf interne Relationen. 91 96 CREATE TABLE import ( 92 id 93 datum 94 verzeichnis 95 importart 96 CONSTRAINT 97 id serial NOT NULL, 98 datum timestamp without time zone, 99 verzeichnis text, 100 importart text, 101 CONSTRAINT import_pk PRIMARY KEY (id) 97 102 ); 98 103 … … 112 117 -- 2014-09-12: "anlass" und "endet" hinzugefÃŒgt. Aktueller Trigger (hist) fÃŒr NAS-"update" benötigt diese Spalten. 113 118 CREATE TABLE "delete" ( 114 ogc_fidserial NOT NULL,115 typenamecharacter varying,116 featureidcharacter varying,117 context character varying, -- delete/replace118 safetoignore character varying,-- replace.safetoignore 'true'/'false'119 replacedBy character varying,-- gmlid120 anlasscharacter varying, -- update.anlass121 endet character(20),-- update.endet122 ignored boolean DEFAULT false,-- Satz wurde nicht verarbeitet123 119 ogc_fid serial NOT NULL, 120 typename character varying, 121 featureid character varying, 122 context character varying, -- delete/replace/update 123 safetoignore character varying, -- replace.safetoignore 'true'/'false' 124 replacedBy character varying, -- gmlid 125 anlass character varying, -- update.anlass 126 endet character(20), -- update.endet 127 ignored boolean DEFAULT false, -- Satz wurde nicht verarbeitet 128 CONSTRAINT delete_pk PRIMARY KEY (ogc_fid) 124 129 ); 125 130 … … 131 136 COMMENT ON COLUMN delete.typename IS 'Objektart, also Name der Tabelle, aus der das Objekt zu löschen ist.'; 132 137 COMMENT ON COLUMN delete.featureid IS 'Zusammen gesetzt aus GML-ID (16) und Zeitstempel.'; 133 COMMENT ON COLUMN delete.context IS 'Operation ''delete'' oder ''replace''';138 COMMENT ON COLUMN delete.context IS 'Operation ''delete'', ''replace'' oder ''update'''; 134 139 COMMENT ON COLUMN delete.safetoignore IS 'Attribut safeToIgnore von wfsext:Replace'; 135 140 COMMENT ON COLUMN delete.replacedBy IS 'gml_id des Objekts, das featureid ersetzt'; … … 147 152 /* 148 153 CREATE TABLE alkis_beziehungen ( 149 ogc_fidserial NOT NULL,150 beziehung_voncharacter varying,151 beziehungsartcharacter varying,152 beziehung_zucharacter varying,153 import_idinteger,154 154 ogc_fid serial NOT NULL, 155 beziehung_von character varying, 156 beziehungsart character varying, 157 beziehung_zu character varying, 158 import_id integer, 159 CONSTRAINT alkis_beziehungen_pk PRIMARY KEY (ogc_fid) 155 160 ); 156 161 … … 168 173 */ 169 174 175 170 176 -- S o n s t i g e s B a u w e r k 171 177 -- ---------------------------------- 172 178 -- Wird von PostNAS generiert, ist aber keiner Objektartengruppe zuzuordnen. 173 179 CREATE TABLE ks_sonstigesbauwerk ( 174 ogc_fidserial NOT NULL,175 gml_id character varyingNOT NULL,176 identifiercharacter varying,177 beginntcharacter(20),178 endetcharacter(20),179 sonstigesmodellcharacter varying[],180 anlasscharacter varying,181 bauwerksfunktioninteger,182 180 ogc_fid serial NOT NULL, 181 gml_id character(16) NOT NULL, 182 --identifier character varying, 183 beginnt character(20), 184 endet character(20), 185 sonstigesmodell character varying[], 186 anlass character varying, 187 bauwerksfunktion integer, 188 CONSTRAINT ks_sonstigesbauwerk_pk PRIMARY KEY (ogc_fid) 183 189 ); 184 190 … … 217 223 -- Objektart: AP_PPO Kennung: 02310 218 224 CREATE TABLE ap_ppo ( 219 ogc_fidserial NOT NULL,220 gml_id character varyingNOT NULL,221 identifiercharacter varying,222 beginntcharacter(20),223 endetcharacter(20),224 advstandardmodellcharacter varying[],225 sonstigesmodellcharacter varying[],226 anlasscharacter varying,227 228 signaturnummercharacter varying, -- ap_gpo229 darstellungsprioritaet integer,-- ap_gpo230 art character varying,-- ap_gpo231 232 drehwinkeldouble precision,233 skalierungdouble precision,234 235 236 dientzurdarstellungvoncharacter varying[], -- -> aa_objekt237 225 ogc_fid serial NOT NULL, 226 gml_id character(16) NOT NULL, 227 --identifier character varying, 228 beginnt character(20), 229 endet character(20), 230 advstandardmodell character varying[], 231 sonstigesmodell character varying[], 232 anlass character varying, 233 234 signaturnummer character varying, -- ap_gpo 235 darstellungsprioritaet integer, -- ap_gpo 236 art character varying, -- ap_gpo 237 238 drehwinkel double precision, 239 skalierung double precision, 240 241 -- Beziehungen: 242 dientzurdarstellungvon character varying[], -- -> aa_objekt 243 CONSTRAINT ap_ppo_pk PRIMARY KEY (ogc_fid) 238 244 ); 239 245 … … 264 270 -- Objektart: AP_LPO Kennung: 02320 265 271 CREATE TABLE ap_lpo ( 266 ogc_fidserial NOT NULL,267 gml_id character varyingNOT NULL,268 identifiercharacter varying,269 beginntcharacter(20),270 endetcharacter(20),271 advstandardmodellcharacter varying[],272 sonstigesmodellcharacter varying[],273 anlasscharacter varying,274 275 signaturnummercharacter varying, -- ap_gpo276 darstellungsprioritaet integer,-- ap_gpo277 artcharacter varying, -- ap_gpo278 279 280 dientzurdarstellungvoncharacter varying[], -- -> aa_objekt281 CONSTRAINT ap_lpo_pkPRIMARY KEY (ogc_fid)272 ogc_fid serial NOT NULL, 273 gml_id character(16) NOT NULL, 274 --identifier character varying, 275 beginnt character(20), 276 endet character(20), 277 advstandardmodell character varying[], 278 sonstigesmodell character varying[], 279 anlass character varying, 280 281 signaturnummer character varying, -- ap_gpo 282 darstellungsprioritaet integer, -- ap_gpo 283 art character varying, -- ap_gpo 284 285 -- Beziehungen: 286 dientzurdarstellungvon character varying[], -- -> aa_objekt 287 CONSTRAINT ap_lpo_pk PRIMARY KEY (ogc_fid) 282 288 ); 283 289 … … 306 312 -- Objektart: AP_PTO Kennung: 02341 307 313 CREATE TABLE ap_pto ( 308 ogc_fidserial NOT NULL,309 gml_id character varyingNOT NULL,310 identifiercharacter varying,311 beginntcharacter(20),312 endetcharacter(20),313 advstandardmodellcharacter varying[],314 sonstigesmodellcharacter varying[],315 anlasscharacter varying,316 317 schriftinhalt character varying,-- Label: anzuzeigender Text318 fontsperrungdouble precision,319 skalierungdouble precision,320 horizontaleausrichtungcharacter varying,321 vertikaleausrichtungcharacter varying,322 323 signaturnummercharacter varying, -- ap_gpo324 darstellungsprioritaet integer,-- ap_gpo325 art character varying,-- ap_gpo326 327 drehwinkel double precision,-- falsche Masseinheit fÃŒr Mapserver, im View umrechnen328 329 dientzurdarstellungvoncharacter varying[], -- -> aa_objekt330 hat character varying,-- -> ap_lpo331 314 ogc_fid serial NOT NULL, 315 gml_id character(16) NOT NULL, 316 --identifier character varying, 317 beginnt character(20), 318 endet character(20), 319 advstandardmodell character varying[], 320 sonstigesmodell character varying[], 321 anlass character varying, 322 323 schriftinhalt character varying, -- Label: anzuzeigender Text 324 fontsperrung double precision, 325 skalierung double precision, 326 horizontaleausrichtung character varying, 327 vertikaleausrichtung character varying, 328 329 signaturnummer character varying, -- ap_gpo 330 darstellungsprioritaet integer, -- ap_gpo 331 art character varying, -- ap_gpo 332 333 drehwinkel double precision, -- falsche Masseinheit fÃŒr Mapserver, im View umrechnen 334 -- Beziehungen: 335 dientzurdarstellungvon character varying[], -- -> aa_objekt 336 hat character varying, -- -> ap_lpo 337 CONSTRAINT ap_pto_pk PRIMARY KEY (ogc_fid) 332 338 ); 333 339 … … 368 374 -- Objektart: AP_LTO Kennung: 02342 369 375 CREATE TABLE ap_lto ( 370 ogc_fidserial NOT NULL,371 gml_id character varyingNOT NULL,372 identifiercharacter varying,373 beginntcharacter(20),374 endetcharacter(20),375 advstandardmodellcharacter varying[],376 sonstigesmodellcharacter varying[],377 anlasscharacter varying,378 schriftinhaltcharacter varying,379 fontsperrungdouble precision,380 skalierungdouble precision,381 horizontaleausrichtungcharacter varying,382 vertikaleausrichtungcharacter varying,383 384 signaturnummercharacter varying, -- ap_gpo385 darstellungsprioritaet integer,-- ap_gpo386 artcharacter varying, -- ap_gpo387 388 389 dientzurdarstellungvoncharacter varying[], -- -> aa_objekt390 hat character varying,-- -> ap_lpo391 376 ogc_fid serial NOT NULL, 377 gml_id character(16) NOT NULL, 378 --identifier character varying, 379 beginnt character(20), 380 endet character(20), 381 advstandardmodell character varying[], 382 sonstigesmodell character varying[], 383 anlass character varying, 384 schriftinhalt character varying, 385 fontsperrung double precision, 386 skalierung double precision, 387 horizontaleausrichtung character varying, 388 vertikaleausrichtung character varying, 389 390 signaturnummer character varying, -- ap_gpo 391 darstellungsprioritaet integer, -- ap_gpo 392 art character varying, -- ap_gpo 393 394 -- Beziehungen: 395 dientzurdarstellungvon character varying[], -- -> aa_objekt 396 hat character varying, -- -> ap_lpo 397 CONSTRAINT ap_lto_pk PRIMARY KEY (ogc_fid) 392 398 ); 393 399 … … 418 424 -- Objektart: AP_Darstellung Kennung: 02350 419 425 CREATE TABLE ap_darstellung ( 420 ogc_fidserial NOT NULL,421 gml_id character varyingNOT NULL,422 identifiercharacter varying,423 beginnt character(20), -- Datumsformat424 endet character(20), -- Datumsformat425 advstandardmodellcharacter varying[],426 sonstigesmodellcharacter varying[],427 anlasscharacter varying,428 429 signaturnummercharacter varying, -- ap_gpo430 darstellungsprioritaet integer,-- ap_gpo431 artcharacter varying, -- ap_gpo432 433 positionierungsregelinteger,434 435 dientzurdarstellungvoncharacter varying[], -- -> aa_objekt436 426 ogc_fid serial NOT NULL, 427 gml_id character(16) NOT NULL, 428 --identifier character varying, 429 beginnt character(20), 430 endet character(20), 431 advstandardmodell character varying[], 432 sonstigesmodell character varying[], 433 anlass character varying, 434 435 signaturnummer character varying, -- ap_gpo 436 darstellungsprioritaet integer, -- ap_gpo 437 art character varying, -- ap_gpo 438 439 positionierungsregel integer, 440 -- Beziehungen: 441 dientzurdarstellungvon character varying[], -- -> aa_objekt 442 CONSTRAINT ap_darstellung_pk PRIMARY KEY (ogc_fid) 437 443 ); 438 444 … … 470 476 -- Objektart: AX_Flurstueck Kennung: 11001 471 477 CREATE TABLE ax_flurstueck ( 472 ogc_fidserial NOT NULL,473 gml_id character varying NOT NULL, -- Datenbank-Tabelle interner SchlÃŒssel474 475 -- GID: AX_Flurstueck_Kerndaten476 -- 'FlurstÃŒck_Kerndaten' enthÀlt Eigenschaften des FlurstÃŒcks, die auch fÃŒr andere FlurstÃŒcksobjektarten gelten (z.B. Historisches FlurstÃŒck).477 land character varying, -- 478 gemarkungsnummer character varying, --479 flurnummer integer, -- Teile des FlurstÃŒckskennzeichens480 zaehler integer, -- (redundant zu flurstueckskennzeichen)481 nenner integer,--482 flurstuecksfolge character varying,483 -- daraus abgeleitet:484 flurstueckskennzeichen character(20), -- Inhalt rechts mit __ auf 20 aufgefÃŒllt485 amtlicheflaeche double precision, -- AFL486 abweichenderrechtszustand character varying DEFAULT 'false', -- ARZ487 rechtsbehelfsverfahren character varying DEFAULT 'false', -- RBV488 zweifelhafterFlurstuecksnachweis character varying DEFAULT 'false', -- ZFM Boolean489 zeitpunktderentstehung character varying, -- ZDE Inhalt jjjj-mm-tt besser Format date ?490 gemeinde character varying,491 -- GID: ENDE AX_Flurstueck_Kerndaten492 493 identifiercharacter varying,494 beginnt character(20), -- Timestamp der Entstehung495 endet character(20), -- Timestamp des Untergangs 496 advstandardmodell character varying[], -- steuert die Darstellung nach Kartentyp497 sonstigesmodellcharacter varying[],498 anlasscharacter varying,499 namecharacter varying[],500 regierungsbezirkcharacter varying,501 kreischaracter varying,502 stellecharacter varying[],503 angabenzumabschnittflurstueckcharacter varying[],504 kennungschluesselcharacter varying[],505 flaechedesabschnittsdouble precision[],506 507 angabenzumabschnittbemerkungcharacter varying[],508 509 -- beziehtsichaufflurstueckcharacter varying[], -- <- ax_flurstueck (invers)510 zeigtaufcharacter varying[], -- -> ax_lagebezeichnungohnehausnummer511 istgebucht character varying,-- -> ax_buchungsstelle512 weistaufcharacter varying[], -- -> ax_lagebezeichnungmithausnummer513 gehoertanteiligzucharacter varying[], -- -> ax_flurstueck514 478 ogc_fid serial NOT NULL, 479 gml_id character(16) NOT NULL, 480 --identifier character varying, 481 beginnt character(20), 482 endet character(20), 483 484 -- GID: AX_Flurstueck_Kerndaten 485 -- 'FlurstÃŒck_Kerndaten' enthÀlt Eigenschaften des FlurstÃŒcks, die auch fÃŒr andere FlurstÃŒcksobjektarten gelten (z.B. Historisches FlurstÃŒck). 486 land character varying, -- 487 gemarkungsnummer character varying, -- 488 flurnummer integer, -- Teile des FlurstÃŒckskennzeichens 489 zaehler integer, -- (redundant zu flurstueckskennzeichen) 490 nenner integer, -- 491 flurstuecksfolge character varying, 492 -- daraus abgeleitet: 493 flurstueckskennzeichen character(20), -- Inhalt rechts mit __ auf 20 aufgefÃŒllt 494 amtlicheflaeche double precision, -- AFL 495 abweichenderrechtszustand character varying DEFAULT 'false', -- ARZ 496 rechtsbehelfsverfahren character varying DEFAULT 'false', -- RBV 497 zweifelhafterFlurstuecksnachweis character varying DEFAULT 'false', -- ZFM Boolean 498 zeitpunktderentstehung character varying,-- ZDE Inhalt jjjj-mm-tt besser Format date ? 499 gemeinde character varying, 500 -- GID: ENDE AX_Flurstueck_Kerndaten 501 502 advstandardmodell character varying[], 503 sonstigesmodell character varying[], 504 anlass character varying, 505 name character varying[], 506 regierungsbezirk character varying, 507 kreis character varying, 508 stelle character varying[], 509 angabenzumabschnittflurstueck character varying[], 510 kennungschluessel character varying[], 511 flaechedesabschnitts double precision[], 512 angabenzumabschnittnummeraktenzeichen integer[], 513 angabenzumabschnittbemerkung character varying[], 514 -- Beziehungen: 515 --beziehtsichaufflurstueck character varying[], -- <- ax_flurstueck (invers) 516 zeigtauf character varying[], -- -> ax_lagebezeichnungohnehausnummer 517 istgebucht character varying, -- -> ax_buchungsstelle 518 weistauf character varying[], -- -> ax_lagebezeichnungmithausnummer 519 gehoertanteiligzu character varying[], -- -> ax_flurstueck 520 CONSTRAINT ax_flurstueck_pk PRIMARY KEY (ogc_fid) 515 521 ); 516 522 … … 571 577 -- Objektart: AX_BesondereFlurstuecksgrenze Kennung: 11002 572 578 CREATE TABLE ax_besondereflurstuecksgrenze ( 573 ogc_fidserial NOT NULL,574 gml_id character varyingNOT NULL,575 identifiercharacter varying,576 beginntcharacter(20),577 endetcharacter(20),578 advstandardmodellcharacter varying[],579 sonstigesmodellcharacter varying[],580 anlasscharacter varying,581 artderflurstuecksgrenzeinteger[],582 579 ogc_fid serial NOT NULL, 580 gml_id character(16) NOT NULL, 581 --identifier character varying, 582 beginnt character(20), 583 endet character(20), 584 advstandardmodell character varying[], 585 sonstigesmodell character varying[], 586 anlass character varying, 587 artderflurstuecksgrenze integer[], 588 CONSTRAINT ax_besondereflurstuecksgrenze_pk PRIMARY KEY (ogc_fid) 583 589 ); 584 590 … … 597 603 -- Objektart: AX_Grenzpunkt Kennung: 11003 598 604 CREATE TABLE ax_grenzpunkt ( 599 ogc_fidserial NOT NULL,600 gml_id character varyingNOT NULL,601 identifiercharacter varying,602 beginntcharacter(20),603 endetcharacter(20),604 advstandardmodellcharacter varying[],605 sonstigesmodellcharacter varying[],606 anlasscharacter varying,607 punktkennungcharacter varying,608 landcharacter varying,609 stellecharacter varying,610 abmarkung_markeinteger,611 612 besonderepunktnummercharacter varying,613 bemerkungzurabmarkunginteger,614 sonstigeeigenschaftcharacter varying[],615 artcharacter varying,616 namecharacter varying[],617 zeitpunktderentstehungcharacter varying,618 relativehoehedouble precision,619 620 zeigtaufcharacter varying, -- -> ax_grenzpunkt621 605 ogc_fid serial NOT NULL, 606 gml_id character(16) NOT NULL, 607 --identifier character varying, 608 beginnt character(20), 609 endet character(20), 610 advstandardmodell character varying[], 611 sonstigesmodell character varying[], 612 anlass character varying, 613 punktkennung character varying, 614 land character varying, 615 stelle character varying, 616 abmarkung_marke integer, 617 festgestelltergrenzpunkt character varying, 618 besonderepunktnummer character varying, 619 bemerkungzurabmarkung integer, 620 sonstigeeigenschaft character varying[], 621 art character varying, 622 name character varying[], 623 zeitpunktderentstehung character varying, 624 relativehoehe double precision, 625 -- Beziehungen: 626 zeigtauf character varying, -- -> ax_grenzpunkt 627 CONSTRAINT ax_grenzpunkt_pk PRIMARY KEY (ogc_fid) 622 628 ); 623 629 … … 642 648 -- Objektart: AX_LagebezeichnungOhneHausnummer Kennung: 12001 643 649 CREATE TABLE ax_lagebezeichnungohnehausnummer ( 644 ogc_fidserial NOT NULL,645 gml_id character varyingNOT NULL,646 identifiercharacter varying,647 beginntcharacter(20),648 endetcharacter(20),649 advstandardmodellcharacter varying[],650 sonstigesmodellcharacter varying[],651 anlasscharacter varying,652 unverschluesseltcharacter varying, -- Gewanne653 landcharacter varying,654 regierungsbezirkcharacter varying,655 kreischaracter varying,656 gemeindecharacter varying,657 lagecharacter varying, -- Strassenschluessel658 659 660 -- beschreibt character varying[],-- <- ax_historischesflurstueckohneraumbezug661 -- gehoertzu character varying[],-- <- ax_flurstueck662 650 ogc_fid serial NOT NULL, 651 gml_id character(16) NOT NULL, 652 --identifier character varying, 653 beginnt character(20), 654 endet character(20), 655 advstandardmodell character varying[], 656 sonstigesmodell character varying[], 657 anlass character varying, 658 unverschluesselt character varying, -- Gewanne 659 land character varying, 660 regierungsbezirk character varying, 661 kreis character varying, 662 gemeinde character varying, 663 lage character varying, -- Strassenschluessel 664 zusatzzurlagebezeichnung character varying, 665 -- Beziehungen: 666 --beschreibt character varying[], -- <- ax_historischesflurstueckohneraumbezug 667 --gehoertzu character varying[], -- <- ax_flurstueck 668 CONSTRAINT ax_lagebezeichnungohnehausnummer_pk PRIMARY KEY (ogc_fid) 663 669 ); 664 670 … … 691 697 -- Objektart: AX_LagebezeichnungOhneHausnummer Kennung: 12001 692 698 CREATE TABLE ax_lagebezeichnungmithausnummer ( 693 ogc_fidserial NOT NULL,694 gml_id character varyingNOT NULL,695 identifiercharacter varying,696 beginntcharacter(20),697 endetcharacter(20),698 advstandardmodellcharacter varying[],699 sonstigesmodellcharacter varying[],700 anlasscharacter varying,701 landcharacter varying,702 regierungsbezirkcharacter varying,703 kreischaracter varying,704 gemeindecharacter varying,705 lage character varying,-- Strassenschluessel706 hausnummer character varying,-- Nummer (blank) Zusatz707 708 -- hatcharacter varying[], -- <- ax_historischesflurstueckohneraumbezug709 -- beziehtsichauf character varying,-- <- ax_gebaeude710 -- beziehtsichauchauf character varying,-- <- ax_georeferenziertegebaeudeadresse711 -- gehoertzucharacter varying[], -- <- ax_flurstueck712 -- weistzum character varying,-- <- ax_turm713 699 ogc_fid serial NOT NULL, 700 gml_id character(16) NOT NULL, 701 --identifier character varying, 702 beginnt character(20), 703 endet character(20), 704 advstandardmodell character varying[], 705 sonstigesmodell character varying[], 706 anlass character varying, 707 land character varying, 708 regierungsbezirk character varying, 709 kreis character varying, 710 gemeinde character varying, 711 lage character varying, -- Strassenschluessel 712 hausnummer character varying, -- Nummer (blank) Zusatz 713 -- Beziehungen: 714 --hat character varying[], -- <- ax_historischesflurstueckohneraumbezug 715 --beziehtsichauf character varying, -- <- ax_gebaeude 716 --beziehtsichauchauf character varying, -- <- ax_georeferenziertegebaeudeadresse 717 --gehoertzu character varying[], -- <- ax_flurstueck 718 --weistzum character varying, -- <- ax_turm 719 CONSTRAINT ax_lagebezeichnungmithausnummer_pk PRIMARY KEY (ogc_fid) 714 720 ); 715 721 … … 754 760 -- NebengebÀude: lfd-Nummer eines NebengebÀudes zu einer (Pseudo-) Hausnummer 755 761 CREATE TABLE ax_lagebezeichnungmitpseudonummer ( 756 ogc_fidserial NOT NULL,757 gml_id character varyingNOT NULL,758 identifiercharacter varying,759 beginntcharacter(20),760 endetcharacter(20),761 advstandardmodellcharacter varying[],762 sonstigesmodellcharacter varying[],763 anlasscharacter varying,764 landcharacter varying,765 regierungsbezirkcharacter varying,766 kreischaracter varying,767 gemeindecharacter varying,768 lagecharacter varying, -- Strassenschluessel769 pseudonummercharacter varying,770 laufendenummercharacter varying, -- leer, Zahl, "P2"771 772 -- 773 762 ogc_fid serial NOT NULL, 763 gml_id character(16) NOT NULL, 764 --identifier character varying, 765 beginnt character(20), 766 endet character(20), 767 advstandardmodell character varying[], 768 sonstigesmodell character varying[], 769 anlass character varying, 770 land character varying, 771 regierungsbezirk character varying, 772 kreis character varying, 773 gemeinde character varying, 774 lage character varying, -- Strassenschluessel 775 pseudonummer character varying, 776 laufendenummer character varying, -- leer, Zahl, "P2" 777 -- Beziehungen: 778 --gehoertzu character varying, -- <- ax_gebaeude 779 CONSTRAINT ax_lagebezeichnungmitpseudonummer_pk PRIMARY KEY (ogc_fid) 774 780 ); 775 781 … … 801 807 -- Objektart: AX_GeoreferenzierteGebaeudeadresse Kennung: 12006 802 808 CREATE TABLE ax_georeferenziertegebaeudeadresse ( 803 ogc_fid serial NOT NULL, 804 gml_id character varying NOT NULL, 805 identifier character varying, 806 beginnt character(20), -- Inhalt z.B. "2008-06-10T15:19:17Z" 807 endet character(20), -- Inhalt z.B. "2008-06-10T15:19:17Z" 808 -- ISO: waere "2008-06-10 15:19:17-00", timestamp-Format wird nicht geladen, bleibt leer 809 advstandardmodell character varying[], 810 sonstigesmodell character varying[], 811 anlass character varying, 812 qualitaetsangaben integer, -- zb: "1000" (= Massstab) 813 -- -- -- Gemeindeschluessel, bestehend aus: 814 land character varying, -- "05" = NRW 815 regierungsbezirk character varying, 816 kreis character varying, 817 gemeinde character varying, 818 ortsteil integer, 819 -- 820 postleitzahl character varying, -- mit fuehrenden Nullen 821 ortsnamepost character varying, 822 zusatzortsname character varying, 823 strassenname character varying, 824 strassenschluessel character varying, -- max. 5 Stellen 825 hausnummer character varying, -- meist 3 Stellen 826 adressierungszusatz character varying, -- Hausnummernzusatz-Buchstabe 827 -- Beziehungen: 828 hatauch character varying, -- <- ax_lagebezeichnungmithausnummer 829 CONSTRAINT ax_georeferenziertegebaeudeadresse_pk PRIMARY KEY (ogc_fid) 809 ogc_fid serial NOT NULL, 810 gml_id character(16) NOT NULL, 811 --identifier character varying, 812 beginnt character(20), 813 endet character(20), 814 advstandardmodell character varying[], 815 sonstigesmodell character varying[], 816 anlass character varying, 817 qualitaetsangaben integer, -- zb: "1000" (= Massstab) 818 land character varying, -- "05" = NRW 819 regierungsbezirk character varying, 820 kreis character varying, 821 gemeinde character varying, 822 ortsteil integer, 823 postleitzahl character varying, -- mit fuehrenden Nullen 824 ortsnamepost character varying, 825 zusatzortsname character varying, 826 strassenname character varying, 827 strassenschluessel character varying, -- max. 5 Stellen 828 hausnummer character varying, -- meist 3 Stellen 829 adressierungszusatz character varying, -- Hausnummernzusatz-Buchstabe 830 -- Beziehungen: 831 hatauch character varying, -- <- ax_lagebezeichnungmithausnummer 832 CONSTRAINT ax_georeferenziertegebaeudeadresse_pk PRIMARY KEY (ogc_fid) 830 833 ); 831 834 … … 849 852 -- Objektart: AX_Aufnahmepunkt Kennung: 13001 850 853 CREATE TABLE ax_aufnahmepunkt ( 851 ogc_fidserial NOT NULL,852 gml_id character varyingNOT NULL,853 identifiercharacter varying,854 beginntcharacter(20),855 endetcharacter(20),856 advstandardmodellcharacter varying[],857 sonstigesmodellcharacter varying[],858 anlasscharacter varying,859 punktkennung character varying,-- integer ist zu klein,860 landcharacter varying,861 stellecharacter varying,862 863 vermarkung_markeinteger,864 relativehoehedouble precision,865 866 hat character varying[], --> ax_sicherungspunkt867 854 ogc_fid serial NOT NULL, 855 gml_id character(16) NOT NULL, 856 --identifier character varying, 857 beginnt character(20), 858 endet character(20), 859 advstandardmodell character varying[], 860 sonstigesmodell character varying[], 861 anlass character varying, 862 punktkennung character varying, -- integer ist zu klein, 863 land character varying, 864 stelle character varying, 865 sonstigeeigenschaft character varying[], 866 vermarkung_marke integer, 867 relativehoehe double precision, 868 -- Beziehungen: 869 hat character varying[], -- -> ax_sicherungspunkt 870 CONSTRAINT ax_aufnahmepunkt_pk PRIMARY KEY (ogc_fid) 868 871 ); 869 872 … … 884 887 -- Objektart: AX_Sicherungspunkt Kennung: 13002 885 888 CREATE TABLE ax_sicherungspunkt ( 886 ogc_fidserial NOT NULL,887 gml_id character varyingNOT NULL,888 identifiercharacter varying,889 beginntcharacter(20),890 endetcharacter(20),891 advstandardmodellcharacter varying[],892 sonstigesmodellcharacter varying[],893 anlasscharacter varying,894 namecharacter varying,895 punktkennungcharacter varying,896 landcharacter varying,897 stellecharacter varying,898 899 vermarkung_markeinteger,900 relativehoehedouble precision,901 902 -- beziehtsichaufcharacter varying, -- <- ax_sonstigervermessungspunkt903 -- gehoertzucharacter varying, -- <- ax_aufnahmepunkt904 889 ogc_fid serial NOT NULL, 890 gml_id character(16) NOT NULL, 891 --identifier character varying, 892 beginnt character(20), 893 endet character(20), 894 advstandardmodell character varying[], 895 sonstigesmodell character varying[], 896 anlass character varying, 897 name character varying, 898 punktkennung character varying, 899 land character varying, 900 stelle character varying, 901 sonstigeeigenschaft character varying[], 902 vermarkung_marke integer, 903 relativehoehe double precision, 904 -- Beziehungen: 905 --beziehtsichauf character varying, -- <- ax_sonstigervermessungspunkt 906 --gehoertzu character varying, -- <- ax_aufnahmepunkt 907 CONSTRAINT ax_sicherungspunkt_pk PRIMARY KEY (ogc_fid) 905 908 ); 906 909 … … 919 922 -- Objektart: AX_SonstigerVermessungspunkt Kennung: 13003 920 923 CREATE TABLE ax_sonstigervermessungspunkt ( 921 ogc_fidserial NOT NULL,922 gml_id character varyingNOT NULL,923 identifiercharacter varying,924 beginntcharacter(20),925 endetcharacter(20),926 advstandardmodellcharacter varying[],927 sonstigesmodellcharacter varying[],928 anlasscharacter varying,929 vermarkung_markeinteger,930 punktkennungcharacter varying, -- integer,931 artcharacter varying,932 landcharacter varying,933 stellecharacter varying,934 935 relativehoehedouble precision,936 937 938 924 ogc_fid serial NOT NULL, 925 gml_id character(16) NOT NULL, 926 --identifier character varying, 927 beginnt character(20), 928 endet character(20), 929 advstandardmodell character varying[], 930 sonstigesmodell character varying[], 931 anlass character varying, 932 vermarkung_marke integer, 933 punktkennung character varying, -- integer, 934 art character varying, 935 land character varying, 936 stelle character varying, 937 sonstigeeigenschaft character varying[], 938 relativehoehe double precision, 939 -- Beziehungen: 940 hat character varying[], --> ax_sicherungspunkt 941 CONSTRAINT ax_sonstigervermessungspunkt_pk PRIMARY KEY (ogc_fid) 939 942 ); 940 943 … … 972 975 -- Objektart: AX_PunktortAG Kennung: 14002 973 976 CREATE TABLE ax_punktortag ( 974 ogc_fidserial NOT NULL,975 gml_id character varyingNOT NULL,976 identifiercharacter varying,977 beginntcharacter(20),978 endetcharacter(20),979 advstandardmodellcharacter varying[],980 sonstigesmodellcharacter varying[],981 anlasscharacter varying,982 artcharacter varying[],983 namecharacter varying[],984 kartendarstellungcharacter varying,985 986 genauigkeitsstufeinteger,987 vertrauenswuerdigkeitinteger,988 koordinatenstatusinteger,989 hinweisecharacter varying,990 991 istteilvoncharacter varying, --> ?992 977 ogc_fid serial NOT NULL, 978 gml_id character(16) NOT NULL, 979 --identifier character varying, 980 beginnt character(20), 981 endet character(20), 982 advstandardmodell character varying[], 983 sonstigesmodell character varying[], 984 anlass character varying, 985 art character varying[], 986 name character varying[], 987 kartendarstellung character varying, 988 ax_datenerhebung_punktort integer, 989 genauigkeitsstufe integer, 990 vertrauenswuerdigkeit integer, 991 koordinatenstatus integer, 992 hinweise character varying, 993 -- Beziehungen: 994 istteilvon character varying, --> ? 995 CONSTRAINT ax_punktortag_pk PRIMARY KEY (ogc_fid) 993 996 ); 994 997 … … 1007 1010 -- Objektart: AX_PunktortAU Kennung: 14003 1008 1011 CREATE TABLE ax_punktortau ( 1009 ogc_fidserial NOT NULL,1010 gml_id character varyingNOT NULL,1011 identifiercharacter varying,1012 beginntcharacter(20),1013 endetcharacter(20),1014 advstandardmodellcharacter varying[],1015 sonstigesmodellcharacter varying[],1016 anlasscharacter varying,1017 kartendarstellungcharacter varying, -- AX_Punktort Boolean1018 ax_datenerhebung_punktortinteger,1019 namecharacter varying[],1020 individualnamecharacter varying,1021 vertrauenswuerdigkeitinteger,1022 genauigkeitsstufeinteger,1023 koordinatenstatus integer,-- AX_Punktort1024 -- ueberpruefungsdatum-- AX_Punktort1025 -- qualitaetsangaben-- AX_Punktort1026 hinweisecharacter varying, -- AX_Punktort1027 1028 istteilvoncharacter varying,1029 1012 ogc_fid serial NOT NULL, 1013 gml_id character(16) NOT NULL, 1014 --identifier character varying, 1015 beginnt character(20), 1016 endet character(20), 1017 advstandardmodell character varying[], 1018 sonstigesmodell character varying[], 1019 anlass character varying, 1020 kartendarstellung character varying, -- AX_Punktort Boolean 1021 ax_datenerhebung_punktort integer, 1022 name character varying[], 1023 individualname character varying, 1024 vertrauenswuerdigkeit integer, 1025 genauigkeitsstufe integer, 1026 koordinatenstatus integer, -- AX_Punktort 1027 --ueberpruefungsdatum -- AX_Punktort 1028 --qualitaetsangaben -- AX_Punktort 1029 hinweise character varying, -- AX_Punktort 1030 -- Beziehungen: 1031 istteilvon character varying, 1032 CONSTRAINT ax_punktortau_pk PRIMARY KEY (ogc_fid) 1030 1033 ); 1031 1034 … … 1045 1048 -- Objektart: AX_PunktortTA Kennung: 14004 1046 1049 CREATE TABLE ax_punktortta ( 1047 ogc_fidserial NOT NULL,1048 gml_id character varyingNOT NULL,1049 identifiercharacter varying,1050 beginntcharacter(20),1051 endetcharacter(20),1052 advstandardmodellcharacter varying[],1053 sonstigesmodellcharacter varying[],1054 anlasscharacter varying,1055 kartendarstellungcharacter varying,1056 descriptioninteger,1057 ax_datenerhebung_punktortinteger,1058 artcharacter varying[],1059 namecharacter varying[],1060 genauigkeitsstufeinteger,1061 vertrauenswuerdigkeitinteger,1062 koordinatenstatusinteger,1063 hinweisecharacter varying,1064 1065 istteilvoncharacter varying,1066 1050 ogc_fid serial NOT NULL, 1051 gml_id character(16) NOT NULL, 1052 --identifier character varying, 1053 beginnt character(20), 1054 endet character(20), 1055 advstandardmodell character varying[], 1056 sonstigesmodell character varying[], 1057 anlass character varying, 1058 kartendarstellung character varying, 1059 description integer, 1060 ax_datenerhebung_punktort integer, 1061 art character varying[], 1062 name character varying[], 1063 genauigkeitsstufe integer, 1064 vertrauenswuerdigkeit integer, 1065 koordinatenstatus integer, 1066 hinweise character varying, 1067 -- Beziehungen: 1068 istteilvon character varying, 1069 CONSTRAINT ax_punktortta_pk PRIMARY KEY (ogc_fid) 1067 1070 ); 1068 1071 … … 1085 1088 -- Objektart: AX_FortfuehrungsnachweisDeckblatt Kennung: 15001 1086 1089 CREATE TABLE ax_fortfuehrungsnachweisdeckblatt ( 1087 ogc_fidserial NOT NULL,1088 gml_id character varyingNOT NULL,1089 identifiercharacter varying,1090 beginntcharacter(20),1091 endetcharacter(20),1092 advstandardmodellcharacter varying[],1093 sonstigesmodellcharacter varying[],1094 anlasscharacter varying,1095 uri character varying,-- wirklich?1096 1097 landcharacter varying,1098 gemarkungsnummercharacter varying,1099 laufendenummerinteger,1100 titelcharacter varying,1101 erstelltam character varying,-- Datum jjjj-mm-tt1102 fortfuehrungsentscheidungamcharacter varying,1103 fortfuehrungsentscheidungvon character varying,-- Bearbeiter-Name und -Titel1104 bemerkungcharacter varying,1105 1106 beziehtsichauf character varying,-- Index drauf?1107 1090 ogc_fid serial NOT NULL, 1091 gml_id character(16) NOT NULL, 1092 --identifier character varying, 1093 beginnt character(20), 1094 endet character(20), 1095 advstandardmodell character varying[], 1096 sonstigesmodell character varying[], 1097 anlass character varying, 1098 uri character varying, -- wirklich? 1099 fortfuehrungsfallnummernbereich character varying, 1100 land character varying, 1101 gemarkungsnummer character varying, 1102 laufendenummer integer, 1103 titel character varying, 1104 erstelltam character varying, -- Datum jjjj-mm-tt 1105 fortfuehrungsentscheidungam character varying, 1106 fortfuehrungsentscheidungvon character varying, -- Bearbeiter-Name und -Titel 1107 bemerkung character varying, 1108 -- Beziehungen: 1109 beziehtsichauf character varying, -- Index drauf? 1110 CONSTRAINT ax_fortfuehrungsnachweisdeckblatt_pk PRIMARY KEY (ogc_fid) 1108 1111 ); 1109 1112 … … 1117 1120 -- Objektart: AX_Fortfuehrungsfall Kennung: 15002 1118 1121 CREATE TABLE ax_fortfuehrungsfall ( 1119 ogc_fidserial NOT NULL,1120 gml_id character varyingNOT NULL,1121 identifiercharacter varying,1122 beginntcharacter(20),1123 endetcharacter(20),1124 advstandardmodellcharacter varying[],1125 sonstigesmodellcharacter varying[],1126 anlasscharacter varying,1127 uricharacter varying,1128 fortfuehrungsfallnummerinteger,1129 laufendenummerinteger,1130 1131 1132 1133 zeigtaufaltesflurstueckcharacter varying[], -- Format wie flurstueckskennzeichen (20) als Array1134 zeigtaufneuesflurstueckcharacter varying[], -- Format wie flurstueckskennzeichen (20) als Array1135 bemerkungcharacter varying,1136 1122 ogc_fid serial NOT NULL, 1123 gml_id character(16) NOT NULL, 1124 --identifier character varying, 1125 beginnt character(20), 1126 endet character(20), 1127 advstandardmodell character varying[], 1128 sonstigesmodell character varying[], 1129 anlass character varying, 1130 uri character varying, 1131 fortfuehrungsfallnummer integer, 1132 laufendenummer integer, 1133 ueberschriftimfortfuehrungsnachweis integer[], 1134 anzahlderfortfuehrungsmitteilungen integer, 1135 -- Beziehungen: 1136 zeigtaufaltesflurstueck character varying[], -- Format wie flurstueckskennzeichen (20) als Array 1137 zeigtaufneuesflurstueck character varying[], -- Format wie flurstueckskennzeichen (20) als Array 1138 bemerkung character varying, 1139 CONSTRAINT ax_fortfuehrungsfall_pk PRIMARY KEY (ogc_fid) 1137 1140 ); 1138 1141 SELECT AddGeometryColumn('ax_fortfuehrungsfall','dummy',:alkis_epsg,'POINT',2); … … 1148 1151 -- Objektart: AX_Reservierung Kennung: 16001 1149 1152 CREATE TABLE ax_reservierung ( 1150 ogc_fidserial NOT NULL,1151 gml_id character varyingNOT NULL,1152 identifiercharacter varying,1153 beginntcharacter(20),1154 endetcharacter(20),1155 advstandardmodellcharacter varying[],1156 sonstigesmodellcharacter varying[],1157 anlasscharacter varying,1158 artinteger,1159 nummercharacter varying,1160 landcharacter varying,1161 stellecharacter varying,1162 1163 antragsnummercharacter varying,1164 auftragsnummercharacter varying,1165 1153 ogc_fid serial NOT NULL, 1154 gml_id character(16) NOT NULL, 1155 --identifier character varying, 1156 beginnt character(20), 1157 endet character(20), 1158 advstandardmodell character varying[], 1159 sonstigesmodell character varying[], 1160 anlass character varying, 1161 art integer, 1162 nummer character varying, 1163 land character varying, 1164 stelle character varying, 1165 ablaufderreservierung character varying, 1166 antragsnummer character varying, 1167 auftragsnummer character varying, 1168 CONSTRAINT ax_reservierung_pk PRIMARY KEY (ogc_fid) 1166 1169 ); 1167 1170 SELECT AddGeometryColumn('ax_reservierung','dummy',:alkis_epsg,'POINT',2); … … 1174 1177 -- Objektart: AX_PunktkennungUntergegangen Kennung: 16002 1175 1178 CREATE TABLE ax_punktkennunguntergegangen ( 1176 ogc_fidserial NOT NULL,1177 gml_id character varyingNOT NULL,1178 identifiercharacter varying,1179 beginntcharacter(20),1180 endetcharacter(20),1181 advstandardmodellcharacter varying[],1182 sonstigesmodellcharacter varying[],1183 anlasscharacter varying,1184 punktkennungcharacter varying,1185 artinteger,1186 1179 ogc_fid serial NOT NULL, 1180 gml_id character(16) NOT NULL, 1181 --identifier character varying, 1182 beginnt character(20), 1183 endet character(20), 1184 advstandardmodell character varying[], 1185 sonstigesmodell character varying[], 1186 anlass character varying, 1187 punktkennung character varying, 1188 art integer, 1189 CONSTRAINT ax_punktkennunguntergegangen_pk PRIMARY KEY (ogc_fid) 1187 1190 ); 1188 1191 … … 1203 1206 -- Die "neue" Historie, die durch FortfÃŒhrungen innerhalb von ALKIS entstanden ist. 1204 1207 CREATE TABLE ax_historischesflurstueck ( 1205 ogc_fidserial NOT NULL,1206 gml_id character varyingNOT NULL,1207 identifiercharacter varying,1208 beginntcharacter(20),1209 endetcharacter(20),1210 advstandardmodellcharacter varying[],1211 sonstigesmodellcharacter varying[],1212 anlasscharacter varying,1213 artcharacter varying[],1214 namecharacter varying[],1215 1216 1217 1218 landcharacter varying, --1219 gemarkungsnummer character varying, --1220 flurnummer integer, -- Teile des FlurstÃŒckskennzeichens1221 zaehler integer, -- (redundant zu flurstueckskennzeichen)1222 nenner integer, --1223 1224 flurstueckskennzeichen character(20),-- Inhalt rechts mit __ auf 20 aufgefÃŒllt1225 amtlicheflaeche double precision,-- AFL1226 abweichenderrechtszustandcharacter varying DEFAULT 'false', -- ARZ1208 ogc_fid serial NOT NULL, 1209 gml_id character(16) NOT NULL, 1210 --identifier character varying, 1211 beginnt character(20), 1212 endet character(20), 1213 advstandardmodell character varying[], 1214 sonstigesmodell character varying[], 1215 anlass character varying, 1216 art character varying[], 1217 name character varying[], 1218 1219 -- GID: AX_Flurstueck_Kerndaten 1220 -- 'FlurstÃŒck_Kerndaten' enthÀlt Eigenschaften des FlurstÃŒcks, die auch fÃŒr andere FlurstÃŒcksobjektarten gelten (z.B. Historisches FlurstÃŒck). 1221 land character varying, -- 1222 gemarkungsnummer character varying, 1223 flurnummer integer, 1224 zaehler integer, 1225 nenner integer, 1226 -- daraus abgeleitet: 1227 flurstueckskennzeichen character(20), -- Inhalt rechts mit __ auf 20 aufgefÃŒllt 1228 amtlicheflaeche double precision, -- AFL 1229 abweichenderrechtszustand character varying DEFAULT 'false', -- ARZ 1227 1230 zweifelhafterflurstuecksnachweis character varying DEFAULT 'false', -- ZFM Boolean 1228 rechtsbehelfsverfahrencharacter varying DEFAULT 'false', -- RBV1229 zeitpunktderentstehung character(10),-- ZDE Inhalt jjjj-mm-tt besser Format date ?1230 zeitpunktderhistorisierung character varying,-- oder (10) ?1231 gemeindecharacter varying,1232 1233 1234 regierungsbezirkcharacter varying,1235 kreischaracter varying,1236 1237 1238 blattartinteger,1239 buchungsartcharacter varying,1240 buchungsblattkennzeichencharacter varying[],1241 bezirkcharacter varying,1242 buchungsblattnummermitbuchstabenerweiterungcharacter varying[],1243 laufendenummerderbuchungsstelleinteger,1244 1231 rechtsbehelfsverfahren character varying DEFAULT 'false', -- RBV 1232 zeitpunktderentstehung character(10), -- ZDE Inhalt jjjj-mm-tt besser Format date ? 1233 zeitpunktderhistorisierung character varying, -- oder (10) ? 1234 gemeinde character varying, 1235 -- GID: ENDE AX_Flurstueck_Kerndaten 1236 1237 regierungsbezirk character varying, 1238 kreis character varying, 1239 vorgaengerflurstueckskennzeichen character varying[], 1240 nachfolgerflurstueckskennzeichen character varying[], 1241 blattart integer, 1242 buchungsart character varying, 1243 buchungsblattkennzeichen character varying[], 1244 bezirk character varying, 1245 buchungsblattnummermitbuchstabenerweiterung character varying[], 1246 laufendenummerderbuchungsstelle integer, 1247 CONSTRAINT ax_historischesflurstueck_pk PRIMARY KEY (ogc_fid) 1245 1248 ); 1246 1249 … … 1294 1297 1295 1298 CREATE TABLE ax_historischesflurstueckalb ( 1296 ogc_fidserial NOT NULL,1297 gml_id character varyingNOT NULL,1298 identifiercharacter varying,1299 beginntcharacter(20),1300 endetcharacter(20),1301 advstandardmodellcharacter varying[],1302 sonstigesmodellcharacter varying[],1303 anlasscharacter varying,1304 namecharacter varying[],1305 1306 1307 1308 landcharacter varying, --1309 gemarkungsnummer character varying, --1310 flurnummer integer, -- Teile des FlurstÃŒckskennzeichens1311 zaehler integer, -- (redundant zu flurstueckskennzeichen)1312 nenner integer, --1313 flurstuecksfolgecharacter varying,1314 1315 flurstueckskennzeichen character(20),-- Inhalt rechts mit __ auf 20 aufgefÃŒllt1316 1317 amtlicheflaeche double precision,-- AFL1318 abweichenderrechtszustandcharacter varying DEFAULT 'false', -- ARZ1319 1320 rechtsbehelfsverfahrencharacter varying DEFAULT 'false', -- RBV1321 zeitpunktderentstehung character(10),-- ZDE jjjj-mm-tt1322 gemeindecharacter varying,1323 1324 1325 blattartinteger,1326 buchungsartcharacter varying[],1327 buchungsblattkennzeichencharacter varying[],1328 bezirkcharacter varying,1329 buchungsblattnummermitbuchstabenerweiterungcharacter varying[],1330 laufendenummerderbuchungsstellecharacter varying[],1331 zeitpunktderentstehungdesbezugsflurstueckscharacter varying,1332 laufendenummerderfortfuehrungcharacter varying,1333 fortfuehrungsartcharacter varying,1334 1335 1336 1299 ogc_fid serial NOT NULL, 1300 gml_id character(16) NOT NULL, 1301 --identifier character varying, 1302 beginnt character(20), 1303 endet character(20), 1304 advstandardmodell character varying[], 1305 sonstigesmodell character varying[], 1306 anlass character varying, 1307 name character varying[], 1308 1309 -- GID: AX_Flurstueck_Kerndaten 1310 -- 'FlurstÃŒck_Kerndaten' enthÀlt Eigenschaften des FlurstÃŒcks, die auch fÃŒr andere FlurstÃŒcksobjektarten gelten (z.B. Historisches FlurstÃŒck). 1311 land character varying, -- 1312 gemarkungsnummer character varying, 1313 flurnummer integer, 1314 zaehler integer, 1315 nenner integer, 1316 flurstuecksfolge character varying, 1317 -- daraus abgeleitet: 1318 flurstueckskennzeichen character(20), -- Inhalt rechts mit __ auf 20 aufgefÃŒllt 1319 1320 amtlicheflaeche double precision, -- AFL 1321 abweichenderrechtszustand character varying DEFAULT 'false', -- ARZ 1322 zweifelhafterFlurstuecksnachweis character varying DEFAULT 'false', -- ZFM Boolean 1323 rechtsbehelfsverfahren character varying DEFAULT 'false', -- RBV 1324 zeitpunktderentstehung character(10), -- ZDE jjjj-mm-tt 1325 gemeinde character varying, 1326 -- GID: ENDE AX_Flurstueck_Kerndaten 1327 1328 blattart integer, 1329 buchungsart character varying[], 1330 buchungsblattkennzeichen character varying[], 1331 bezirk character varying, 1332 buchungsblattnummermitbuchstabenerweiterung character varying[], 1333 laufendenummerderbuchungsstelle character varying[], 1334 zeitpunktderentstehungdesbezugsflurstuecks character varying, 1335 laufendenummerderfortfuehrung character varying, 1336 fortfuehrungsart character varying, 1337 vorgaengerflurstueckskennzeichen character varying[], 1338 nachfolgerflurstueckskennzeichen character varying[], 1339 CONSTRAINT ax_historischesflurstueckalb_pk PRIMARY KEY (ogc_fid) 1337 1340 ); 1338 1341 … … 1376 1379 -- Objektart: AX_HistorischesFlurstueckOhneRaumbezug Kennung: 17003 1377 1380 CREATE TABLE ax_historischesflurstueckohneraumbezug ( 1378 1379 ogc_fid serial NOT NULL, 1380 gml_id character varying NOT NULL, 1381 identifier character varying, 1382 beginnt character(20), 1383 endet character(20), 1384 advstandardmodell character varying[], 1385 sonstigesmodell character varying[], 1386 anlass character varying, 1387 name character varying[], 1388 1389 -- GID: AX_Flurstueck_Kerndaten 1390 -- 'FlurstÃŒck_Kerndaten' enthÀlt Eigenschaften des FlurstÃŒcks, die auch fÃŒr andere FlurstÃŒcksobjektarten gelten (z.B. Historisches FlurstÃŒck). 1391 land character varying, -- 1392 gemarkungsnummer character varying, -- 1393 flurnummer integer, -- Teile des FlurstÃŒckskennzeichens 1394 zaehler integer, -- (redundant zu flurstueckskennzeichen) 1395 nenner integer, -- 1396 -- daraus abgeleitet: 1397 flurstueckskennzeichen character(20), -- Inhalt rechts mit __ auf 20 aufgefÃŒllt 1398 amtlicheflaeche double precision, -- AFL 1399 abweichenderrechtszustand character varying, -- ARZ 1400 zweifelhafterFlurstuecksnachweis character varying, -- ZFM 1401 rechtsbehelfsverfahren integer, -- RBV 1402 zeitpunktderentstehung character varying, -- ZDE Inhalt jjjj-mm-tt besser Format date ? 1403 gemeinde character varying, 1404 -- GID: ENDE AX_Flurstueck_Kerndaten 1405 1406 nachfolgerflurstueckskennzeichen character varying[], 1407 vorgaengerflurstueckskennzeichen character varying[], 1408 -- Beziehungen: 1409 gehoertanteiligzu character varying[], --> ax_historischesflurstueckohneraumbezug 1410 weistauf character varying[], --> ax_lagebezeichnungmithausnummer 1411 zeigtauf character varying[], --> ax_lagebezeichnungohnehausnummer 1412 istgebucht character varying, --> ax_buchungsstelle 1413 CONSTRAINT ax_historischesflurstueckohneraumbezug_pk PRIMARY KEY (ogc_fid) 1381 ogc_fid serial NOT NULL, 1382 gml_id character(16) NOT NULL, 1383 --identifier character varying, 1384 beginnt character(20), 1385 endet character(20), 1386 advstandardmodell character varying[], 1387 sonstigesmodell character varying[], 1388 anlass character varying, 1389 name character varying[], 1390 1391 -- GID: AX_Flurstueck_Kerndaten 1392 -- 'FlurstÃŒck_Kerndaten' enthÀlt Eigenschaften des FlurstÃŒcks, die auch fÃŒr andere FlurstÃŒcksobjektarten gelten (z.B. Historisches FlurstÃŒck). 1393 land character varying, -- 1394 gemarkungsnummer character varying, 1395 flurnummer integer, 1396 zaehler integer, 1397 nenner integer, 1398 -- daraus abgeleitet: 1399 flurstueckskennzeichen character(20), -- Inhalt rechts mit __ auf 20 aufgefÃŒllt 1400 amtlicheflaeche double precision, -- AFL 1401 abweichenderrechtszustand character varying, -- ARZ 1402 zweifelhafterFlurstuecksnachweis character varying, -- ZFM 1403 rechtsbehelfsverfahren integer, -- RBV 1404 zeitpunktderentstehung character varying, -- ZDE Inhalt jjjj-mm-tt besser Format date ? 1405 gemeinde character varying, 1406 -- GID: ENDE AX_Flurstueck_Kerndaten 1407 1408 nachfolgerflurstueckskennzeichen character varying[], 1409 vorgaengerflurstueckskennzeichen character varying[], 1410 -- Beziehungen: 1411 gehoertanteiligzu character varying[], --> ax_historischesflurstueckohneraumbezug 1412 weistauf character varying[], --> ax_lagebezeichnungmithausnummer 1413 zeigtauf character varying[], --> ax_lagebezeichnungohnehausnummer 1414 istgebucht character varying, --> ax_buchungsstelle 1415 CONSTRAINT ax_historischesflurstueckohneraumbezug_pk PRIMARY KEY (ogc_fid) 1414 1416 ); 1415 1417 … … 1476 1478 -- Objektart: AX_Person Kennung: 21001 1477 1479 CREATE TABLE ax_person ( 1478 ogc_fidserial NOT NULL,1479 gml_id character varyingNOT NULL,1480 identifiercharacter varying,1481 beginntcharacter(20),1482 endetcharacter(20),1483 advstandardmodellcharacter varying[],1484 sonstigesmodellcharacter varying[],1485 anlasscharacter varying,1486 nachnameoderfirmacharacter varying,1487 anredeinteger,1488 vornamecharacter varying,1489 geburtsnamecharacter varying,1490 geburtsdatumcharacter varying,1491 namensbestandteilcharacter varying,1492 akademischergradcharacter varying,1493 1494 hatcharacter varying[], -- -> ax_anschrift1495 -- weistaufcharacter varying[], -- <- ax_namensnummer1496 wirdvertretenvoncharacter varying[], -- -> ax_vertretung1497 gehoertzucharacter varying[], -- -> ax_personengruppe1498 -- uebtauscharacter varying[], -- <- ax_vertretung1499 -- besitztcharacter varying[], -- <- ax_gebaeude1500 -- zeigtauf character varying,-- <- ax_person1501 -- benenntcharacter varying[], -- <- ax_verwaltung1502 1480 ogc_fid serial NOT NULL, 1481 gml_id character(16) NOT NULL, 1482 --identifier character varying, 1483 beginnt character(20), 1484 endet character(20), 1485 advstandardmodell character varying[], 1486 sonstigesmodell character varying[], 1487 anlass character varying, 1488 nachnameoderfirma character varying, 1489 anrede integer, 1490 vorname character varying, 1491 geburtsname character varying, 1492 geburtsdatum character varying, 1493 namensbestandteil character varying, 1494 akademischergrad character varying, 1495 -- Beziehungen: 1496 hat character varying[], -- -> ax_anschrift 1497 --weistauf character varying[], -- <- ax_namensnummer 1498 wirdvertretenvon character varying[], -- -> ax_vertretung 1499 gehoertzu character varying[], -- -> ax_personengruppe 1500 --uebtaus character varying[], -- <- ax_vertretung 1501 --besitzt character varying[], -- <- ax_gebaeude 1502 --zeigtauf character varying, -- <- ax_person 1503 --benennt character varying[], -- <- ax_verwaltung 1504 CONSTRAINT ax_person_pk PRIMARY KEY (ogc_fid) 1503 1505 ); 1504 1506 … … 1550 1552 -- Objektart: AX_Anschrift Kennung: 21003 1551 1553 CREATE TABLE ax_anschrift ( 1552 ogc_fidserial NOT NULL,1553 gml_id character varyingNOT NULL,1554 identifiercharacter varying,1555 beginntcharacter(20),1556 endetcharacter(20),1557 advstandardmodellcharacter varying[],1558 sonstigesmodellcharacter varying[],1559 anlasscharacter varying,1560 ort_postcharacter varying,1561 1562 strassecharacter varying,1563 hausnummercharacter varying,1564 bestimmungslandcharacter varying,1565 postleitzahlpostfachcharacter varying,1566 postfachcharacter varying,1567 ortsteilcharacter varying,1568 weitereAdressencharacter varying[],1569 telefoncharacter varying,1570 faxcharacter varying,1571 organisationnamecharacter varying,1572 1573 -- beziehtsichauf character varying[],-- <- ax_dienststelle1574 -- gehoertzu character varying[],-- <- ax_person1575 1554 ogc_fid serial NOT NULL, 1555 gml_id character(16) NOT NULL, 1556 --identifier character varying, 1557 beginnt character(20), 1558 endet character(20), 1559 advstandardmodell character varying[], 1560 sonstigesmodell character varying[], 1561 anlass character varying, 1562 ort_post character varying, 1563 postleitzahlpostzustellung character varying, 1564 strasse character varying, 1565 hausnummer character varying, 1566 bestimmungsland character varying, 1567 postleitzahlpostfach character varying, 1568 postfach character varying, 1569 ortsteil character varying, 1570 weitereAdressen character varying[], 1571 telefon character varying, 1572 fax character varying, 1573 organisationname character varying, 1574 -- Beziehungen: 1575 --beziehtsichauf character varying[], -- <- ax_dienststelle 1576 --gehoertzu character varying[], -- <- ax_person 1577 CONSTRAINT ax_anschrift_pk PRIMARY KEY (ogc_fid) 1576 1578 ); 1577 1579 … … 1596 1598 -- Objektart: AX_Verwaltung Kennung: 21004 1597 1599 CREATE TABLE ax_verwaltung ( 1598 ogc_fidserial NOT NULL,1599 gml_id character varyingNOT NULL,1600 identifiercharacter varying,1601 beginntcharacter(20),1602 endetcharacter(20),1603 advstandardmodellcharacter varying[],1604 sonstigesmodellcharacter varying[],1605 anlasscharacter varying,1606 1607 -- beziehtsichauf character varying[],-- <- ax_buchungsstelle1608 haengtan character varying,-- -> ax_person1609 1600 ogc_fid serial NOT NULL, 1601 gml_id character(16) NOT NULL, 1602 --identifier character varying, 1603 beginnt character(20), 1604 endet character(20), 1605 advstandardmodell character varying[], 1606 sonstigesmodell character varying[], 1607 anlass character varying, 1608 -- Beziehungen: 1609 --beziehtsichauf character varying[], -- <- ax_buchungsstelle 1610 haengtan character varying, -- -> ax_person 1611 CONSTRAINT ax_verwaltung_pk PRIMARY KEY (ogc_fid) 1610 1612 ); 1611 1613 SELECT AddGeometryColumn('ax_verwaltung','dummy',:alkis_epsg,'POINT',2); … … 1626 1628 -- Objektart: AX_Vertretung Kennung: 21005 1627 1629 CREATE TABLE ax_vertretung ( 1628 ogc_fidserial NOT NULL,1629 gml_id character varyingNOT NULL,1630 identifiercharacter varying,1631 beginntcharacter(20),1632 endetcharacter(20),1633 advstandardmodellcharacter varying[],1634 sonstigesmodellcharacter varying[],1635 anlasscharacter varying,1636 1637 -- vertritt character varying[],-- <- ax_person1638 haengtan character varying,--> ax_person1639 beziehtsichauf character varying[],--> ax_flurstueck1640 1630 ogc_fid serial NOT NULL, 1631 gml_id character(16) NOT NULL, 1632 --identifier character varying, 1633 beginnt character(20), 1634 endet character(20), 1635 advstandardmodell character varying[], 1636 sonstigesmodell character varying[], 1637 anlass character varying, 1638 -- Beziehungen: 1639 --vertritt character varying[], -- <- ax_person 1640 haengtan character varying, --> ax_person 1641 beziehtsichauf character varying[], --> ax_flurstueck 1642 CONSTRAINT ax_vertretung_pk PRIMARY KEY (ogc_fid) 1641 1643 ); 1642 1644 SELECT AddGeometryColumn('ax_vertretung','dummy',:alkis_epsg,'POINT',2); … … 1657 1659 -- AX_Namensnummer Kennung: 21006 1658 1660 CREATE TABLE ax_namensnummer ( 1659 ogc_fidserial NOT NULL,1660 gml_id character varyingNOT NULL,1661 identifiercharacter varying,1662 beginntcharacter(20),1663 endetcharacter(20),1664 advstandardmodellcharacter varying[],1665 sonstigesmodellcharacter varying[],1666 anlasscharacter varying,1667 laufendenummernachdin1421 character(16),-- 0000.00.00.00.001668 zaehler double precision,-- Anteil ..1669 nenner double precision, --.. als Bruch1670 eigentuemerartinteger,1671 nummer character varying,-- immer leer ?1672 artderrechtsgemeinschaft integer,-- SchlÃŒssel1673 1674 1675 1676 istbestandteilvon character varying,-- -> ax_buchungsblatt1677 hatvorgaenger character varying[],-- -> ax_namensnummer1678 benennt character varying,-- -> ax_person1679 1661 ogc_fid serial NOT NULL, 1662 gml_id character(16) NOT NULL, 1663 --identifier character varying, 1664 beginnt character(20), 1665 endet character(20), 1666 advstandardmodell character varying[], 1667 sonstigesmodell character varying[], 1668 anlass character varying, 1669 laufendenummernachdin1421 character(16), -- 0000.00.00.00.00 1670 zaehler double precision, -- Anteil .. 1671 nenner double precision, -- .. als Bruch 1672 eigentuemerart integer, 1673 nummer character varying, -- immer leer ? 1674 artderrechtsgemeinschaft integer, -- SchlÃŒssel 1675 beschriebderrechtsgemeinschaft character varying, 1676 -- Beziehungen: 1677 bestehtausrechtsverhaeltnissenzu character varying, -- -> ax_namensnummer 1678 istbestandteilvon character varying, -- -> ax_buchungsblatt 1679 hatvorgaenger character varying[], -- -> ax_namensnummer 1680 benennt character varying, -- -> ax_person 1681 CONSTRAINT ax_namensnummer_pk PRIMARY KEY (ogc_fid) 1680 1682 ); 1681 1683 … … 1703 1705 -- Objektart: AX_Buchungsblatt Kennung: 21007 1704 1706 CREATE TABLE ax_buchungsblatt ( 1705 ogc_fidserial NOT NULL,1706 gml_id character varyingNOT NULL,1707 identifiercharacter varying,1708 beginntcharacter(20),1709 endetcharacter(20),1710 advstandardmodellcharacter varying[],1711 sonstigesmodellcharacter varying[],1712 anlasscharacter varying,1713 1714 landcharacter varying,1715 bezirkcharacter varying,1716 buchungsblattnummermitbuchstabenerweiterungcharacter varying,1717 blattart character varying,-- bisher integer,1718 artcharacter varying,1719 1720 -- bestehtauscharacter varying[], -- <- ax_buchungsstelle1721 1707 ogc_fid serial NOT NULL, 1708 gml_id character(16) NOT NULL, 1709 --identifier character varying, 1710 beginnt character(20), 1711 endet character(20), 1712 advstandardmodell character varying[], 1713 sonstigesmodell character varying[], 1714 anlass character varying, 1715 buchungsblattkennzeichen character varying, 1716 land character varying, 1717 bezirk character varying, 1718 buchungsblattnummermitbuchstabenerweiterung character varying, 1719 blattart character varying, -- bisher integer, 1720 art character varying, 1721 -- Beziehungen: 1722 --bestehtaus character varying[], -- <- ax_buchungsstelle 1723 CONSTRAINT ax_buchungsblatt_pk PRIMARY KEY (ogc_fid) 1722 1724 ); 1723 1725 … … 1740 1742 -- Objektart: AX_Buchungsstelle Kennung: 21008 1741 1743 CREATE TABLE ax_buchungsstelle ( 1742 ogc_fidserial NOT NULL,1743 gml_id character varyingNOT NULL,1744 identifiercharacter varying,1745 beginntcharacter(20),1746 endetcharacter(20),1747 advstandardmodellcharacter varying[],1748 sonstigesmodellcharacter varying[],1749 anlasscharacter varying,1750 buchungsartinteger,1751 laufendenummercharacter varying,1752 beschreibungdesumfangsderbuchungcharacter(1),1753 zaehlerdouble precision,1754 nennerdouble precision,1755 nummerimaufteilungsplancharacter varying,1756 beschreibungdessondereigentumscharacter varying,1757 buchungstextcharacter varying,1758 1759 istbestandteilvon character varying,-- -> ax_buchungsblatt1760 durch character varying[],-- -> ax_buchungsstelle1761 verweistauf character varying[],-- -> ax_flurstueck1762 -- grundstueckbestehtaus character varying[],-- <- ax_flurstueck1763 zu character varying[],-- -> ax_buchungsstelle1764 an character varying[],-- -> ax_buchungsstelle1765 hatvorgaenger character varying[],-- -> ax_buchungsstelle1766 wirdverwaltetvon character varying,-- -> ax_verwaltung1767 beziehtsichauf character varying[],-- -> ax_buchungsblatt1768 CONSTRAINT ax_buchungsstelle_pkPRIMARY KEY (ogc_fid)1744 ogc_fid serial NOT NULL, 1745 gml_id character(16) NOT NULL, 1746 --identifier character varying, 1747 beginnt character(20), 1748 endet character(20), 1749 advstandardmodell character varying[], 1750 sonstigesmodell character varying[], 1751 anlass character varying, 1752 buchungsart integer, 1753 laufendenummer character varying, 1754 beschreibungdesumfangsderbuchung character(1), 1755 zaehler double precision, 1756 nenner double precision, 1757 nummerimaufteilungsplan character varying, 1758 beschreibungdessondereigentums character varying, 1759 buchungstext character varying, 1760 -- Beziehungen: 1761 istbestandteilvon character varying, -- -> ax_buchungsblatt 1762 durch character varying[], -- -> ax_buchungsstelle 1763 verweistauf character varying[], -- -> ax_flurstueck 1764 --grundstueckbestehtaus character varying[], -- <- ax_flurstueck 1765 zu character varying[], -- -> ax_buchungsstelle 1766 an character varying[], -- -> ax_buchungsstelle 1767 hatvorgaenger character varying[], -- -> ax_buchungsstelle 1768 wirdverwaltetvon character varying, -- -> ax_verwaltung 1769 beziehtsichauf character varying[], -- -> ax_buchungsblatt 1770 CONSTRAINT ax_buchungsstelle_pk PRIMARY KEY (ogc_fid) 1769 1771 ); 1770 1772 … … 1811 1813 -- Objektart: AX_Gebaeude Kennung: 31001 1812 1814 CREATE TABLE ax_gebaeude ( 1813 ogc_fidserial NOT NULL,1814 gml_id character varyingNOT NULL,1815 identifiercharacter varying,1816 beginntcharacter(20),1817 endetcharacter(20),1818 advstandardmodellcharacter varying[],1819 sonstigesmodellcharacter varying[],1820 anlasscharacter varying,1821 gebaeudefunktion integer,-- Werte siehe SchlÃŒsseltabelle1822 weiteregebaeudefunktioninteger[],1823 namecharacter varying[],1824 bauweiseinteger,1825 anzahlderoberirdischengeschosseinteger,1826 1827 hochhaus character varying,-- "true"/"false", meist leer1828 objekthoehedouble precision,1829 dachforminteger,1830 zustandinteger,1831 geschossflaecheinteger,1832 grundflaecheinteger,1833 umbauterrauminteger,1834 baujahrinteger,1835 1836 dachartcharacter varying,1837 dachgeschossausbauinteger,1838 qualitaetsangabencharacter varying,1839 ax_datenerhebunginteger,1840 descriptioninteger,1841 artcharacter varying,1842 individualnamecharacter varying,1843 1844 gehoertzu character varying,-- -> ax_gebaeude1845 hat character varying,-- -> ax_lagebezeichnungmitpseudonummer1846 gehoertcharacter varying[], -- -> ax_person1847 zeigtaufcharacter varying[], -- -> ax_lagebezeichnungmithausnummer1848 -- haengtzusammenmit character varying,-- <- ax_gebaeude1849 1815 ogc_fid serial NOT NULL, 1816 gml_id character(16) NOT NULL, 1817 --identifier character varying, 1818 beginnt character(20), 1819 endet character(20), 1820 advstandardmodell character varying[], 1821 sonstigesmodell character varying[], 1822 anlass character varying, 1823 gebaeudefunktion integer, -- Werte siehe SchlÃŒsseltabelle 1824 weiteregebaeudefunktion integer[], 1825 name character varying[], 1826 bauweise integer, 1827 anzahlderoberirdischengeschosse integer, 1828 anzahlderunterirdischengeschosse integer, 1829 hochhaus character varying, -- "true"/"false", meist leer 1830 objekthoehe double precision, 1831 dachform integer, 1832 zustand integer, 1833 geschossflaeche integer, 1834 grundflaeche integer, 1835 umbauterraum integer, 1836 baujahr integer, 1837 lagezurerdoberflaeche integer, 1838 dachart character varying, 1839 dachgeschossausbau integer, 1840 qualitaetsangaben character varying, 1841 ax_datenerhebung integer, 1842 description integer, 1843 art character varying, 1844 individualname character varying, 1845 -- Beziehungen: 1846 gehoertzu character varying, -- -> ax_gebaeude 1847 hat character varying, -- -> ax_lagebezeichnungmitpseudonummer 1848 gehoert character varying[], -- -> ax_person 1849 zeigtauf character varying[], -- -> ax_lagebezeichnungmithausnummer 1850 --haengtzusammenmit character varying, -- <- ax_gebaeude 1851 CONSTRAINT ax_gebaeude_pk PRIMARY KEY (ogc_fid) 1850 1852 ); 1851 1853 … … 1895 1897 -- Objektart: AX_Bauteil Kennung: 31002 1896 1898 CREATE TABLE ax_bauteil ( 1897 ogc_fidserial NOT NULL,1898 gml_id character varyingNOT NULL,1899 identifiercharacter varying,1900 beginntcharacter(20),1901 endetcharacter(20),1902 advstandardmodellcharacter varying[],1903 sonstigesmodellcharacter varying[],1904 anlasscharacter varying,1905 bauartinteger,1906 dachforminteger,1907 anzahlderoberirdischengeschosseinteger,1908 1909 lagezurerdoberflaecheinteger,1910 1899 ogc_fid serial NOT NULL, 1900 gml_id character(16) NOT NULL, 1901 --identifier character varying, 1902 beginnt character(20), 1903 endet character(20), 1904 advstandardmodell character varying[], 1905 sonstigesmodell character varying[], 1906 anlass character varying, 1907 bauart integer, 1908 dachform integer, 1909 anzahlderoberirdischengeschosse integer, 1910 anzahlderunterirdischengeschosse integer, 1911 lagezurerdoberflaeche integer, 1912 CONSTRAINT ax_bauteil_pk PRIMARY KEY (ogc_fid) 1911 1913 ); 1912 1914 … … 1925 1927 -- Objektart: AX_BesondereGebaeudelinie Kennung: 31003 1926 1928 CREATE TABLE ax_besonderegebaeudelinie ( 1927 ogc_fidserial NOT NULL,1928 gml_id character varyingNOT NULL,1929 identifiercharacter varying,1930 beginntcharacter(20),1931 endetcharacter(20),1932 advstandardmodellcharacter varying[],1933 sonstigesmodellcharacter varying[],1934 beschaffenheitinteger[],1935 anlasscharacter varying,1936 1929 ogc_fid serial NOT NULL, 1930 gml_id character(16) NOT NULL, 1931 --identifier character varying, 1932 beginnt character(20), 1933 endet character(20), 1934 advstandardmodell character varying[], 1935 sonstigesmodell character varying[], 1936 beschaffenheit integer[], 1937 anlass character varying, 1938 CONSTRAINT ax_besonderegebaeudelinie_pk PRIMARY KEY (ogc_fid) 1937 1939 ); 1938 1940 … … 1952 1954 -- Objektart: AX_Firstlinie Kennung: 31004 1953 1955 CREATE TABLE ax_firstlinie ( 1954 ogc_fidserial NOT NULL,1955 gml_id character varyingNOT NULL,1956 identifiercharacter varying,1957 beginntcharacter(20),1958 endetcharacter(20),1959 advstandardmodellcharacter varying[],1960 sonstigesmodellcharacter varying[],1961 anlasscharacter varying,1962 artcharacter varying,1963 uricharacter varying, -- wirklich?1964 1956 ogc_fid serial NOT NULL, 1957 gml_id character(16) NOT NULL, 1958 --identifier character varying, 1959 beginnt character(20), 1960 endet character(20), 1961 advstandardmodell character varying[], 1962 sonstigesmodell character varying[], 1963 anlass character varying, 1964 art character varying, 1965 uri character varying, -- wirklich? 1966 CONSTRAINT ax_firstlinie_pk PRIMARY KEY (ogc_fid) 1965 1967 ); 1966 1968 … … 1978 1980 -- Objektart: AX_BesondererGebaeudepunkt Kennung: 31005 1979 1981 CREATE TABLE ax_besonderergebaeudepunkt ( 1980 ogc_fidserial NOT NULL,1981 gml_id character varyingNOT NULL,1982 identifiercharacter varying,1983 beginntcharacter(20),1984 endetcharacter(20),1985 advstandardmodellcharacter varying[],1986 sonstigesmodellcharacter varying[],1987 anlasscharacter varying,1988 landcharacter varying,1989 stellecharacter varying,1990 punktkennungcharacter varying,1991 artcharacter varying,1992 namecharacter varying[],1993 1994 1982 ogc_fid serial NOT NULL, 1983 gml_id character(16) NOT NULL, 1984 --identifier character varying, 1985 beginnt character(20), 1986 endet character(20), 1987 advstandardmodell character varying[], 1988 sonstigesmodell character varying[], 1989 anlass character varying, 1990 land character varying, 1991 stelle character varying, 1992 punktkennung character varying, 1993 art character varying, 1994 name character varying[], 1995 sonstigeeigenschaft character varying[], 1996 CONSTRAINT ax_besonderergebaeudepunkt_pk PRIMARY KEY (ogc_fid) 1995 1997 ); 1996 1998 … … 2020 2022 -- Objektart: AX_Wohnbauflaeche Kennung: 41001 2021 2023 CREATE TABLE ax_wohnbauflaeche ( 2022 ogc_fidserial NOT NULL,2023 gml_id character varyingNOT NULL,2024 identifiercharacter varying,2025 beginntcharacter(20),2026 endetcharacter(20),2027 advstandardmodellcharacter varying[],2028 sonstigesmodellcharacter varying[],2029 anlasscharacter varying,2030 artderbebauunginteger,2031 zustandinteger,2032 namecharacter varying,2033 2024 ogc_fid serial NOT NULL, 2025 gml_id character(16) NOT NULL, 2026 --identifier character varying, 2027 beginnt character(20), 2028 endet character(20), 2029 advstandardmodell character varying[], 2030 sonstigesmodell character varying[], 2031 anlass character varying, 2032 artderbebauung integer, 2033 zustand integer, 2034 name character varying, 2035 CONSTRAINT ax_wohnbauflaeche_pk PRIMARY KEY (ogc_fid) 2034 2036 ); 2035 2037 … … 2051 2053 -- Objektart: AX_IndustrieUndGewerbeflaeche Kennung: 41002 2052 2054 CREATE TABLE ax_industrieundgewerbeflaeche ( 2053 ogc_fidserial NOT NULL,2054 gml_id character varyingNOT NULL,2055 identifiercharacter varying,2056 beginntcharacter(20),2057 endetcharacter(20),2058 advstandardmodellcharacter varying[],2059 sonstigesmodellcharacter varying[],2060 anlasscharacter varying,2061 funktioninteger,2062 namecharacter varying,2063 zustandinteger,2064 foerdergutinteger,2065 primaerenergieinteger,2066 lagergutinteger,2067 2055 ogc_fid serial NOT NULL, 2056 gml_id character(16) NOT NULL, 2057 --identifier character varying, 2058 beginnt character(20), 2059 endet character(20), 2060 advstandardmodell character varying[], 2061 sonstigesmodell character varying[], 2062 anlass character varying, 2063 funktion integer, 2064 name character varying, 2065 zustand integer, 2066 foerdergut integer, 2067 primaerenergie integer, 2068 lagergut integer, 2069 CONSTRAINT ax_industrieundgewerbeflaeche_pk PRIMARY KEY (ogc_fid) 2068 2070 ); 2069 2071 … … 2087 2089 -- ---------------------------------------------- 2088 2090 -- Objektart: AX_Halde Kennung: 41003 2089 CREATE TABLE ax_halde 2090 ( ogc_fidserial NOT NULL,2091 gml_id character varyingNOT NULL,2092 identifiercharacter varying,2093 beginntcharacter(20),2094 endetcharacter(20),2095 advstandardmodellcharacter varying[],2096 sonstigesmodellcharacter varying[],2097 anlasscharacter varying,2098 lagergutinteger,2099 namecharacter varying,2100 zustandinteger,2101 2091 CREATE TABLE ax_halde ( 2092 ogc_fid serial NOT NULL, 2093 gml_id character(16) NOT NULL, 2094 --identifier character varying, 2095 beginnt character(20), 2096 endet character(20), 2097 advstandardmodell character varying[], 2098 sonstigesmodell character varying[], 2099 anlass character varying, 2100 lagergut integer, 2101 name character varying, 2102 zustand integer, 2103 CONSTRAINT ax_halde_pk PRIMARY KEY (ogc_fid) 2102 2104 ); 2103 2105 … … 2119 2121 -- Objektart: AX_Bergbaubetrieb Kennung: 41004 2120 2122 CREATE TABLE ax_bergbaubetrieb ( 2121 ogc_fidserial NOT NULL,2122 gml_id character varyingNOT NULL,2123 identifiercharacter varying,2124 beginntcharacter(20),2125 endetcharacter(20),2126 advstandardmodellcharacter varying[],2127 sonstigesmodellcharacter varying[],2128 anlasscharacter varying,2129 abbaugutinteger,2130 namecharacter varying,2131 bezeichnungcharacter varying,2132 zustandinteger,2133 2123 ogc_fid serial NOT NULL, 2124 gml_id character(16) NOT NULL, 2125 --identifier character varying, 2126 beginnt character(20), 2127 endet character(20), 2128 advstandardmodell character varying[], 2129 sonstigesmodell character varying[], 2130 anlass character varying, 2131 abbaugut integer, 2132 name character varying, 2133 bezeichnung character varying, 2134 zustand integer, 2135 CONSTRAINT ax_bergbaubetrieb_pk PRIMARY KEY (ogc_fid) 2134 2136 ); 2135 2137 … … 2151 2153 -- Objektart: AX_TagebauGrubeSteinbruch Kennung: 41005 2152 2154 CREATE TABLE ax_tagebaugrubesteinbruch ( 2153 ogc_fidserial NOT NULL,2154 gml_id character varyingNOT NULL,2155 identifiercharacter varying,2156 beginntcharacter(20),2157 endetcharacter(20),2158 advstandardmodellcharacter varying[],2159 sonstigesmodellcharacter varying[],2160 anlasscharacter varying,2161 abbaugutinteger,2162 namecharacter varying,2163 zustandinteger,2164 2165 2155 ogc_fid serial NOT NULL, 2156 gml_id character(16) NOT NULL, 2157 --identifier character varying, 2158 beginnt character(20), 2159 endet character(20), 2160 advstandardmodell character varying[], 2161 sonstigesmodell character varying[], 2162 anlass character varying, 2163 abbaugut integer, 2164 name character varying, 2165 zustand integer, 2166 2167 CONSTRAINT ax_tagebaugrubesteinbruch_pk PRIMARY KEY (ogc_fid) 2166 2168 ); 2167 2169 … … 2183 2185 -- Objektart: AX_FlaecheGemischterNutzung Kennung: 41006 2184 2186 CREATE TABLE ax_flaechegemischternutzung ( 2185 ogc_fidserial NOT NULL,2186 gml_id character varyingNOT NULL,2187 identifiercharacter varying,2188 beginntcharacter(20),2189 endetcharacter(20),2190 advstandardmodellcharacter varying[],2191 sonstigesmodellcharacter varying[],2192 anlasscharacter varying,2193 artderbebauunginteger,2194 funktioninteger,2195 namecharacter varying,2196 zustandinteger,2197 2187 ogc_fid serial NOT NULL, 2188 gml_id character(16) NOT NULL, 2189 --identifier character varying, 2190 beginnt character(20), 2191 endet character(20), 2192 advstandardmodell character varying[], 2193 sonstigesmodell character varying[], 2194 anlass character varying, 2195 artderbebauung integer, 2196 funktion integer, 2197 name character varying, 2198 zustand integer, 2199 CONSTRAINT ax_flaechegemischternutzung_pk PRIMARY KEY (ogc_fid) 2198 2200 ); 2199 2201 … … 2215 2217 -- Objektart: AX_FlaecheBesondererFunktionalerPraegung Kennung: 41007 2216 2218 CREATE TABLE ax_flaechebesondererfunktionalerpraegung ( 2217 ogc_fidserial NOT NULL,2218 gml_id character varyingNOT NULL,2219 identifiercharacter varying,2220 beginntcharacter(20),2221 endetcharacter(20),2222 advstandardmodellcharacter varying[],2223 sonstigesmodellcharacter varying[],2224 anlasscharacter varying,2225 funktioninteger,2226 artderbebauunginteger,2227 namecharacter varying,2228 zustandinteger,2229 2219 ogc_fid serial NOT NULL, 2220 gml_id character(16) NOT NULL, 2221 --identifier character varying, 2222 beginnt character(20), 2223 endet character(20), 2224 advstandardmodell character varying[], 2225 sonstigesmodell character varying[], 2226 anlass character varying, 2227 funktion integer, 2228 artderbebauung integer, 2229 name character varying, 2230 zustand integer, 2231 CONSTRAINT ax_flaechebesondererfunktionalerpraegung_pk PRIMARY KEY (ogc_fid) 2230 2232 ); 2231 2233 … … 2247 2249 -- Objektart: AX_SportFreizeitUndErholungsflaeche Kennung: 41008 2248 2250 CREATE TABLE ax_sportfreizeitunderholungsflaeche ( 2249 ogc_fidserial NOT NULL,2250 gml_id character varyingNOT NULL,2251 identifiercharacter varying,2252 beginntcharacter(20),2253 endetcharacter(20),2254 advstandardmodellcharacter varying[],2255 sonstigesmodellcharacter varying[],2256 anlasscharacter varying,2257 funktioninteger,2258 zustandinteger,2259 namecharacter varying,2260 2251 ogc_fid serial NOT NULL, 2252 gml_id character(16) NOT NULL, 2253 --identifier character varying, 2254 beginnt character(20), 2255 endet character(20), 2256 advstandardmodell character varying[], 2257 sonstigesmodell character varying[], 2258 anlass character varying, 2259 funktion integer, 2260 zustand integer, 2261 name character varying, 2262 CONSTRAINT ax_sportfreizeitunderholungsflaeche_pk PRIMARY KEY (ogc_fid) 2261 2263 ); 2262 2264 … … 2278 2280 -- Objektart: AX_Friedhof Kennung: 41009 2279 2281 CREATE TABLE ax_friedhof ( 2280 ogc_fidserial NOT NULL,2281 gml_id character varyingNOT NULL,2282 identifiercharacter varying,2283 beginntcharacter(20),2284 endetcharacter(20),2285 advstandardmodellcharacter varying[],2286 sonstigesmodellcharacter varying[],2287 anlasscharacter varying,2288 funktioninteger,2289 namecharacter varying,2290 zustandinteger,2291 2282 ogc_fid serial NOT NULL, 2283 gml_id character(16) NOT NULL, 2284 --identifier character varying, 2285 beginnt character(20), 2286 endet character(20), 2287 advstandardmodell character varying[], 2288 sonstigesmodell character varying[], 2289 anlass character varying, 2290 funktion integer, 2291 name character varying, 2292 zustand integer, 2293 CONSTRAINT ax_friedhof_pk PRIMARY KEY (ogc_fid) 2292 2294 ); 2293 2295 … … 2311 2313 -- Objektart: AX_Strassenverkehr Kennung: 42001 2312 2314 CREATE TABLE ax_strassenverkehr ( 2313 ogc_fidserial NOT NULL,2314 gml_id character varyingNOT NULL,2315 identifiercharacter varying,2316 beginntcharacter(20),2317 endetcharacter(20),2318 advstandardmodellcharacter varying[],2319 sonstigesmodellcharacter varying[],2320 anlasscharacter varying,2321 funktioninteger,2322 namecharacter varying,2323 zweitnamecharacter varying,2324 zustandinteger,2325 landcharacter varying,2326 regierungsbezirkcharacter varying,2327 kreischaracter varying,2328 gemeindecharacter varying,2329 lagecharacter varying,2330 unverschluesseltcharacter varying,2331 2315 ogc_fid serial NOT NULL, 2316 gml_id character(16) NOT NULL, 2317 --identifier character varying, 2318 beginnt character(20), 2319 endet character(20), 2320 advstandardmodell character varying[], 2321 sonstigesmodell character varying[], 2322 anlass character varying, 2323 funktion integer, 2324 name character varying, 2325 zweitname character varying, 2326 zustand integer, 2327 land character varying, 2328 regierungsbezirk character varying, 2329 kreis character varying, 2330 gemeinde character varying, 2331 lage character varying, 2332 unverschluesselt character varying, 2333 CONSTRAINT ax_strassenverkehr_pk PRIMARY KEY (ogc_fid) 2332 2334 ); 2333 2335 … … 2349 2351 -- Objektart: AX_Strassenverkehr Kennung: 42001 2350 2352 CREATE TABLE ax_weg ( 2351 ogc_fidserial NOT NULL,2352 gml_id character varyingNOT NULL,2353 identifiercharacter varying,2354 beginntcharacter(20),2355 endetcharacter(20),2356 advstandardmodellcharacter varying[],2357 sonstigesmodellcharacter varying[],2358 anlasscharacter varying,2359 funktioninteger,2360 namecharacter varying,2361 bezeichnungcharacter varying,2362 landcharacter varying,2363 regierungsbezirkcharacter varying,2364 kreischaracter varying,2365 gemeindecharacter varying,2366 lagecharacter varying,2367 unverschluesseltcharacter varying,2368 2353 ogc_fid serial NOT NULL, 2354 gml_id character(16) NOT NULL, 2355 --identifier character varying, 2356 beginnt character(20), 2357 endet character(20), 2358 advstandardmodell character varying[], 2359 sonstigesmodell character varying[], 2360 anlass character varying, 2361 funktion integer, 2362 name character varying, 2363 bezeichnung character varying, 2364 land character varying, 2365 regierungsbezirk character varying, 2366 kreis character varying, 2367 gemeinde character varying, 2368 lage character varying, 2369 unverschluesselt character varying, 2370 CONSTRAINT ax_weg_pk PRIMARY KEY (ogc_fid) 2369 2371 ); 2370 2372 … … 2385 2387 -- Objektart: AX_Platz Kennung: 42009 2386 2388 CREATE TABLE ax_platz ( 2387 ogc_fidserial NOT NULL,2388 gml_id character varyingNOT NULL,2389 identifiercharacter varying,2390 beginntcharacter(20),2391 endetcharacter(20),2392 advstandardmodellcharacter varying[],2393 sonstigesmodellcharacter varying[],2394 anlasscharacter varying,2395 funktioninteger,2396 namecharacter varying,2397 zweitnamecharacter varying,2398 landcharacter varying,2399 regierungsbezirkcharacter varying,2400 kreischaracter varying,2401 gemeindecharacter varying,2402 lage character varying,-- StraÃenschlÃŒssel2403 unverschluesselt character varying,-- Gewanne?2404 2389 ogc_fid serial NOT NULL, 2390 gml_id character(16) NOT NULL, 2391 --identifier character varying, 2392 beginnt character(20), 2393 endet character(20), 2394 advstandardmodell character varying[], 2395 sonstigesmodell character varying[], 2396 anlass character varying, 2397 funktion integer, 2398 name character varying, 2399 zweitname character varying, 2400 land character varying, 2401 regierungsbezirk character varying, 2402 kreis character varying, 2403 gemeinde character varying, 2404 lage character varying, -- StraÃenschlÃŒssel 2405 unverschluesselt character varying, -- Gewanne? 2406 CONSTRAINT ax_platz_pk PRIMARY KEY (ogc_fid) 2405 2407 ); 2406 2408 … … 2421 2423 -- Objektart: AX_Bahnverkehr Kennung: 42010 2422 2424 CREATE TABLE ax_bahnverkehr ( 2423 ogc_fidserial NOT NULL,2424 gml_id character varyingNOT NULL,2425 identifiercharacter varying,2426 beginntcharacter(20),2427 endetcharacter(20),2428 advstandardmodellcharacter varying[],2429 sonstigesmodellcharacter varying[],2430 anlasscharacter varying,2431 funktioninteger,2432 bahnkategorieinteger,2433 bezeichnungcharacter varying,2434 2435 zweitnamecharacter varying,2436 zustandinteger,2437 2425 ogc_fid serial NOT NULL, 2426 gml_id character(16) NOT NULL, 2427 --identifier character varying, 2428 beginnt character(20), 2429 endet character(20), 2430 advstandardmodell character varying[], 2431 sonstigesmodell character varying[], 2432 anlass character varying, 2433 funktion integer, 2434 bahnkategorie integer, 2435 bezeichnung character varying, 2436 nummerderbahnstrecke character varying, 2437 zweitname character varying, 2438 zustand integer, 2439 CONSTRAINT ax_bahnverkehr_pk PRIMARY KEY (ogc_fid) 2438 2440 ); 2439 2441 … … 2462 2464 -- Objektart: AX_Flugverkehr Kennung: 42015 2463 2465 CREATE TABLE ax_flugverkehr ( 2464 ogc_fidserial NOT NULL,2465 gml_id character varyingNOT NULL,2466 identifiercharacter varying,2467 beginntcharacter(20),2468 endetcharacter(20),2469 advstandardmodellcharacter varying[],2470 sonstigesmodellcharacter varying[],2471 anlasscharacter varying,2472 funktioninteger,2473 artinteger,2474 namecharacter varying,2475 bezeichnungcharacter varying,2476 nutzunginteger,2477 zustandinteger,2478 2466 ogc_fid serial NOT NULL, 2467 gml_id character(16) NOT NULL, 2468 --identifier character varying, 2469 beginnt character(20), 2470 endet character(20), 2471 advstandardmodell character varying[], 2472 sonstigesmodell character varying[], 2473 anlass character varying, 2474 funktion integer, 2475 art integer, 2476 name character varying, 2477 bezeichnung character varying, 2478 nutzung integer, 2479 zustand integer, 2480 CONSTRAINT ax_flugverkehr_pk PRIMARY KEY (ogc_fid) 2479 2481 ); 2480 2482 … … 2498 2500 -- Objektart: AX_Schiffsverkehr Kennung: 42016 2499 2501 CREATE TABLE ax_schiffsverkehr ( 2500 ogc_fidserial NOT NULL,2501 gml_id character varyingNOT NULL,2502 identifiercharacter varying,2503 beginntcharacter(20),2504 endetcharacter(20),2505 advstandardmodellcharacter varying[],2506 sonstigesmodellcharacter varying[],2507 anlasscharacter varying,2508 funktioninteger,2509 namecharacter varying,2510 zustandinteger,2511 2502 ogc_fid serial NOT NULL, 2503 gml_id character(16) NOT NULL, 2504 --identifier character varying, 2505 beginnt character(20), 2506 endet character(20), 2507 advstandardmodell character varying[], 2508 sonstigesmodell character varying[], 2509 anlass character varying, 2510 funktion integer, 2511 name character varying, 2512 zustand integer, 2513 CONSTRAINT ax_schiffsverkehr_pk PRIMARY KEY (ogc_fid) 2512 2514 ); 2513 2515 … … 2531 2533 -- Objektart: AX_Landwirtschaft Kennung: 43001 2532 2534 CREATE TABLE ax_landwirtschaft ( 2533 ogc_fidserial NOT NULL,2534 gml_id character varyingNOT NULL,2535 identifiercharacter varying,2536 beginntcharacter(20),2537 endetcharacter(20),2538 advstandardmodellcharacter varying[],2539 sonstigesmodellcharacter varying[],2540 anlasscharacter varying,2541 vegetationsmerkmalinteger,2542 namecharacter varying,2543 2535 ogc_fid serial NOT NULL, 2536 gml_id character(16) NOT NULL, 2537 --identifier character varying, 2538 beginnt character(20), 2539 endet character(20), 2540 advstandardmodell character varying[], 2541 sonstigesmodell character varying[], 2542 anlass character varying, 2543 vegetationsmerkmal integer, 2544 name character varying, 2545 CONSTRAINT ax_landwirtschaft_pk PRIMARY KEY (ogc_fid) 2544 2546 ); 2545 2547 SELECT AddGeometryColumn('ax_landwirtschaft','wkb_geometry',:alkis_epsg,'GEOMETRY',2); … … 2558 2560 -- Objektart: AX_Wald Kennung: 43002 2559 2561 CREATE TABLE ax_wald ( 2560 ogc_fidserial NOT NULL,2561 gml_id character varyingNOT NULL,2562 identifiercharacter varying,2563 beginntcharacter(20),2564 endetcharacter(20),2565 advstandardmodellcharacter varying[],2566 sonstigesmodellcharacter varying[],2567 anlasscharacter varying,2568 vegetationsmerkmalinteger,2569 namecharacter varying,2570 bezeichnungcharacter varying,2571 2562 ogc_fid serial NOT NULL, 2563 gml_id character(16) NOT NULL, 2564 --identifier character varying, 2565 beginnt character(20), 2566 endet character(20), 2567 advstandardmodell character varying[], 2568 sonstigesmodell character varying[], 2569 anlass character varying, 2570 vegetationsmerkmal integer, 2571 name character varying, 2572 bezeichnung character varying, 2573 CONSTRAINT ax_wald_pk PRIMARY KEY (ogc_fid) 2572 2574 ); 2573 2575 … … 2588 2590 -- Objektart: AX_Gehoelz Kennung: 43003 2589 2591 CREATE TABLE ax_gehoelz ( 2590 ogc_fidserial NOT NULL,2591 gml_id character varyingNOT NULL,2592 identifiercharacter varying,2593 beginntcharacter(20),2594 endetcharacter(20),2595 advstandardmodellcharacter varying[],2596 sonstigesmodellcharacter varying[],2597 anlasscharacter varying,2598 vegetationsmerkmalinteger,2599 namecharacter varying,2600 funktioninteger,2601 2592 ogc_fid serial NOT NULL, 2593 gml_id character(16) NOT NULL, 2594 --identifier character varying, 2595 beginnt character(20), 2596 endet character(20), 2597 advstandardmodell character varying[], 2598 sonstigesmodell character varying[], 2599 anlass character varying, 2600 vegetationsmerkmal integer, 2601 name character varying, 2602 funktion integer, 2603 CONSTRAINT ax_gehoelz_pk PRIMARY KEY (ogc_fid) 2602 2604 ); 2603 2605 … … 2619 2621 -- Objektart: AX_Heide Kennung: 43004 2620 2622 CREATE TABLE ax_heide ( 2621 ogc_fidserial NOT NULL,2622 gml_id character varyingNOT NULL,2623 identifiercharacter varying,2624 beginntcharacter(20),2625 endetcharacter(20),2626 advstandardmodellcharacter varying[],2627 sonstigesmodellcharacter varying[],2628 anlasscharacter varying,2629 namecharacter varying,2630 2623 ogc_fid serial NOT NULL, 2624 gml_id character(16) NOT NULL, 2625 --identifier character varying, 2626 beginnt character(20), 2627 endet character(20), 2628 advstandardmodell character varying[], 2629 sonstigesmodell character varying[], 2630 anlass character varying, 2631 name character varying, 2632 CONSTRAINT ax_heide_pk PRIMARY KEY (ogc_fid) 2631 2633 ); 2632 2634 … … 2645 2647 -- Objektart: AX_Moor Kennung: 43005 2646 2648 CREATE TABLE ax_moor ( 2647 ogc_fidserial NOT NULL,2648 gml_id character varyingNOT NULL,2649 identifiercharacter varying,2650 beginntcharacter(20),2651 endetcharacter(20),2652 advstandardmodellcharacter varying[],2653 sonstigesmodellcharacter varying[],2654 anlasscharacter varying,2655 namecharacter varying,2656 2649 ogc_fid serial NOT NULL, 2650 gml_id character(16) NOT NULL, 2651 --identifier character varying, 2652 beginnt character(20), 2653 endet character(20), 2654 advstandardmodell character varying[], 2655 sonstigesmodell character varying[], 2656 anlass character varying, 2657 name character varying, 2658 CONSTRAINT ax_moor_pk PRIMARY KEY (ogc_fid) 2657 2659 ); 2658 2660 … … 2672 2674 -- Objektart: AX_Sumpf Kennung: 43006 2673 2675 CREATE TABLE ax_sumpf ( 2674 ogc_fidserial NOT NULL,2675 gml_id character varyingNOT NULL,2676 identifiercharacter varying,2677 beginntcharacter(20),2678 endetcharacter(20),2679 advstandardmodellcharacter varying[],2680 sonstigesmodellcharacter varying[],2681 anlasscharacter varying,2682 namecharacter varying,2683 2676 ogc_fid serial NOT NULL, 2677 gml_id character(16) NOT NULL, 2678 --identifier character varying, 2679 beginnt character(20), 2680 endet character(20), 2681 advstandardmodell character varying[], 2682 sonstigesmodell character varying[], 2683 anlass character varying, 2684 name character varying, 2685 CONSTRAINT ax_sumpf_pk PRIMARY KEY (ogc_fid) 2684 2686 ); 2685 2687 … … 2698 2700 -- Objektart: AX_UnlandVegetationsloseFlaeche Kennung: 43007 2699 2701 CREATE TABLE ax_unlandvegetationsloseflaeche ( 2700 ogc_fidserial NOT NULL,2701 gml_id character varyingNOT NULL,2702 identifiercharacter varying,2703 beginntcharacter(20),2704 endetcharacter(20),2705 advstandardmodellcharacter varying[],2706 sonstigesmodellcharacter varying[],2707 anlasscharacter varying,2708 2709 namecharacter varying,2710 funktioninteger,2711 2702 ogc_fid serial NOT NULL, 2703 gml_id character(16) NOT NULL, 2704 --identifier character varying, 2705 beginnt character(20), 2706 endet character(20), 2707 advstandardmodell character varying[], 2708 sonstigesmodell character varying[], 2709 anlass character varying, 2710 oberflaechenmaterial integer, 2711 name character varying, 2712 funktion integer, 2713 CONSTRAINT ax_unlandvegetationsloseflaeche_pk PRIMARY KEY (ogc_fid) 2712 2714 ); 2713 2715 … … 2731 2733 -- Objektart: AX_Fliessgewaesser Kennung: 44001 2732 2734 CREATE TABLE ax_fliessgewaesser ( 2733 ogc_fidserial NOT NULL,2734 gml_id character varyingNOT NULL,2735 identifiercharacter varying,2736 beginntcharacter(20),2737 endetcharacter(20),2738 advstandardmodellcharacter varying[],2739 sonstigesmodellcharacter varying[],2740 anlasscharacter varying,2741 funktioninteger,2742 namecharacter varying,2743 zustandinteger,2744 unverschluesseltcharacter varying,2745 2735 ogc_fid serial NOT NULL, 2736 gml_id character(16) NOT NULL, 2737 --identifier character varying, 2738 beginnt character(20), 2739 endet character(20), 2740 advstandardmodell character varying[], 2741 sonstigesmodell character varying[], 2742 anlass character varying, 2743 funktion integer, 2744 name character varying, 2745 zustand integer, 2746 unverschluesselt character varying, 2747 CONSTRAINT ax_fliessgewaesser_pk PRIMARY KEY (ogc_fid) 2746 2748 ); 2747 2749 SELECT AddGeometryColumn('ax_fliessgewaesser','wkb_geometry',:alkis_epsg,'GEOMETRY',2); … … 2766 2768 -- Objektart: AX_Hafenbecken Kennung: 44005 2767 2769 CREATE TABLE ax_hafenbecken ( 2768 ogc_fidserial NOT NULL,2769 gml_id character varyingNOT NULL,2770 identifiercharacter varying,2771 beginntcharacter(20),2772 endetcharacter(20),2773 advstandardmodellcharacter varying[],2774 sonstigesmodellcharacter varying[],2775 anlasscharacter varying,2776 funktioninteger,2777 namecharacter varying,2778 nutzunginteger,2779 2770 ogc_fid serial NOT NULL, 2771 gml_id character(16) NOT NULL, 2772 --identifier character varying, 2773 beginnt character(20), 2774 endet character(20), 2775 advstandardmodell character varying[], 2776 sonstigesmodell character varying[], 2777 anlass character varying, 2778 funktion integer, 2779 name character varying, 2780 nutzung integer, 2781 CONSTRAINT ax_hafenbecken_pk PRIMARY KEY (ogc_fid) 2780 2782 ); 2781 2783 … … 2797 2799 -- Objektart: AX_StehendesGewaesser Kennung: 44006 2798 2800 CREATE TABLE ax_stehendesgewaesser ( 2799 ogc_fidserial NOT NULL,2800 gml_id character varyingNOT NULL,2801 identifiercharacter varying,2802 beginntcharacter(20),2803 endetcharacter(20),2804 advstandardmodellcharacter varying[],2805 sonstigesmodellcharacter varying[],2806 anlasscharacter varying,2807 funktioninteger,2808 namecharacter varying,2809 2810 2811 unverschluesseltcharacter varying,2812 2801 ogc_fid serial NOT NULL, 2802 gml_id character(16) NOT NULL, 2803 --identifier character varying, 2804 beginnt character(20), 2805 endet character(20), 2806 advstandardmodell character varying[], 2807 sonstigesmodell character varying[], 2808 anlass character varying, 2809 funktion integer, 2810 name character varying, 2811 gewaesserkennziffer character varying, 2812 hydrologischesMerkmal integer, 2813 unverschluesselt character varying, 2814 CONSTRAINT ax_stehendesgewaesser_pk PRIMARY KEY (ogc_fid) 2813 2815 ); 2814 2816 … … 2830 2832 -- Objektart: AX_Meer Kennung: 44007 2831 2833 CREATE TABLE ax_meer ( 2832 ogc_fidserial NOT NULL,2833 gml_id character varyingNOT NULL,2834 identifiercharacter varying,2835 beginntcharacter(20),2836 endetcharacter(20),2837 advstandardmodellcharacter varying[],2838 sonstigesmodellcharacter varying[],2839 anlasscharacter varying,2840 funktioninteger,2841 namecharacter varying,2842 bezeichnungcharacter varying,2843 tidemerkmalinteger,2844 2834 ogc_fid serial NOT NULL, 2835 gml_id character(16) NOT NULL, 2836 --identifier character varying, 2837 beginnt character(20), 2838 endet character(20), 2839 advstandardmodell character varying[], 2840 sonstigesmodell character varying[], 2841 anlass character varying, 2842 funktion integer, 2843 name character varying, 2844 bezeichnung character varying, 2845 tidemerkmal integer, 2846 CONSTRAINT ax_meer_pk PRIMARY KEY (ogc_fid) 2845 2847 ); 2846 2848 … … 2871 2873 -- Objektart: AX_Turm Kennung: 51001 2872 2874 CREATE TABLE ax_turm ( 2873 ogc_fidserial NOT NULL,2874 gml_id character varyingNOT NULL,2875 identifiercharacter varying,2876 beginntcharacter(20),2877 endetcharacter(20),2878 advstandardmodellcharacter varying[],2879 sonstigesmodellcharacter varying[],2880 anlasscharacter varying,2881 bauwerksfunktioninteger,2882 zustandinteger,2883 namecharacter varying,2884 2885 zeigtaufcharacter varying, --> ax_lagebezeichnungmithausnummer2886 2875 ogc_fid serial NOT NULL, 2876 gml_id character(16) NOT NULL, 2877 --identifier character varying, 2878 beginnt character(20), 2879 endet character(20), 2880 advstandardmodell character varying[], 2881 sonstigesmodell character varying[], 2882 anlass character varying, 2883 bauwerksfunktion integer, 2884 zustand integer, 2885 name character varying, 2886 -- Beziehungen: 2887 zeigtauf character varying, --> ax_lagebezeichnungmithausnummer 2888 CONSTRAINT ax_turm_pk PRIMARY KEY (ogc_fid) 2887 2889 ); 2888 2890 … … 2904 2906 -- Objektart: AX_BauwerkOderAnlageFuerIndustrieUndGewerbe Kennung: 51002 2905 2907 CREATE TABLE ax_bauwerkoderanlagefuerindustrieundgewerbe ( 2906 ogc_fidserial NOT NULL,2907 gml_id character varyingNOT NULL,2908 identifiercharacter varying,2909 beginntcharacter(20),2910 endetcharacter(20),2911 advstandardmodellcharacter varying[],2912 sonstigesmodellcharacter varying[],2913 anlasscharacter varying,2914 bauwerksfunktioninteger,2915 namecharacter varying,2916 zustandinteger,2917 objekthoehedouble precision,2918 2908 ogc_fid serial NOT NULL, 2909 gml_id character(16) NOT NULL, 2910 --identifier character varying, 2911 beginnt character(20), 2912 endet character(20), 2913 advstandardmodell character varying[], 2914 sonstigesmodell character varying[], 2915 anlass character varying, 2916 bauwerksfunktion integer, 2917 name character varying, 2918 zustand integer, 2919 objekthoehe double precision, 2920 CONSTRAINT ax_bauwerkoderanlagefuerindustrieundgewerbe_pk PRIMARY KEY (ogc_fid) 2919 2921 ); 2920 2922 … … 2932 2934 -- Objektart: AX_VorratsbehaelterSpeicherbauwerk Kennung: 51003 2933 2935 CREATE TABLE ax_vorratsbehaelterspeicherbauwerk ( 2934 ogc_fidserial NOT NULL,2935 gml_id character varyingNOT NULL,2936 identifiercharacter varying,2937 beginntcharacter(20),2938 endetcharacter(20),2939 advstandardmodellcharacter varying[],2940 sonstigesmodellcharacter varying[],2941 anlasscharacter varying,2942 speicherinhaltinteger,2943 bauwerksfunktioninteger,2944 2945 namecharacter varying,2946 2936 ogc_fid serial NOT NULL, 2937 gml_id character(16) NOT NULL, 2938 --identifier character varying, 2939 beginnt character(20), 2940 endet character(20), 2941 advstandardmodell character varying[], 2942 sonstigesmodell character varying[], 2943 anlass character varying, 2944 speicherinhalt integer, 2945 bauwerksfunktion integer, 2946 lagezurerdoberflaeche integer, 2947 name character varying, 2948 CONSTRAINT ax_vorratsbehaelterspeicherbauwerk_pk PRIMARY KEY (ogc_fid) 2947 2949 ); 2948 2950 … … 2960 2962 -- Objektart: AX_Transportanlage Kennung: 51004 2961 2963 CREATE TABLE ax_transportanlage ( 2962 ogc_fidserial NOT NULL,2963 gml_id character varyingNOT NULL,2964 identifiercharacter varying,2965 beginntcharacter(20),2966 endetcharacter(20),2967 advstandardmodellcharacter varying[],2968 sonstigesmodellcharacter varying[],2969 anlasscharacter varying,2970 bauwerksfunktioninteger,2971 2972 artcharacter varying,2973 namecharacter varying,2974 produktinteger,2975 2964 ogc_fid serial NOT NULL, 2965 gml_id character(16) NOT NULL, 2966 --identifier character varying, 2967 beginnt character(20), 2968 endet character(20), 2969 advstandardmodell character varying[], 2970 sonstigesmodell character varying[], 2971 anlass character varying, 2972 bauwerksfunktion integer, 2973 lagezurerdoberflaeche integer, 2974 art character varying, 2975 name character varying, 2976 produkt integer, 2977 CONSTRAINT ax_transportanlage_pk PRIMARY KEY (ogc_fid) 2976 2978 ); 2977 2979 … … 2989 2991 -- Objektart: AX_Leitung Kennung: 51005 2990 2992 CREATE TABLE ax_leitung ( 2991 ogc_fidserial NOT NULL,2992 gml_id character varyingNOT NULL,2993 identifiercharacter varying,2994 beginntcharacter(20),2995 endetcharacter(20),2996 advstandardmodellcharacter varying[],2997 sonstigesmodellcharacter varying[],2998 anlasscharacter varying,2999 bauwerksfunktioninteger,3000 spannungsebeneinteger,3001 2993 ogc_fid serial NOT NULL, 2994 gml_id character(16) NOT NULL, 2995 --identifier character varying, 2996 beginnt character(20), 2997 endet character(20), 2998 advstandardmodell character varying[], 2999 sonstigesmodell character varying[], 3000 anlass character varying, 3001 bauwerksfunktion integer, 3002 spannungsebene integer, 3003 CONSTRAINT ax_leitung_pk PRIMARY KEY (ogc_fid) 3002 3004 ); 3003 3005 … … 3015 3017 -- Objektart: AX_BauwerkOderAnlageFuerSportFreizeitUndErholung Kennung: 51006 3016 3018 CREATE TABLE ax_bauwerkoderanlagefuersportfreizeitunderholung ( 3017 ogc_fidserial NOT NULL,3018 gml_id character varyingNOT NULL,3019 identifiercharacter varying,3020 beginntcharacter(20),3021 endetcharacter(20),3022 advstandardmodellcharacter varying[],3023 sonstigesmodellcharacter varying[],3024 anlasscharacter varying,3025 bauwerksfunktioninteger,3026 sportartinteger,3027 namecharacter varying,3028 3019 ogc_fid serial NOT NULL, 3020 gml_id character(16) NOT NULL, 3021 --identifier character varying, 3022 beginnt character(20), 3023 endet character(20), 3024 advstandardmodell character varying[], 3025 sonstigesmodell character varying[], 3026 anlass character varying, 3027 bauwerksfunktion integer, 3028 sportart integer, 3029 name character varying, 3030 CONSTRAINT ax_bauwerkoderanlagefuersportfreizeitunderholung_pk PRIMARY KEY (ogc_fid) 3029 3031 ); 3030 3032 … … 3042 3044 -- Objektart: AX_HistorischesBauwerkOderHistorischeEinrichtung Kennung: 51007 3043 3045 CREATE TABLE ax_historischesbauwerkoderhistorischeeinrichtung ( 3044 ogc_fidserial NOT NULL,3045 gml_id character varyingNOT NULL,3046 identifiercharacter varying,3047 beginntcharacter(20),3048 endetcharacter(20),3049 advstandardmodellcharacter varying[],3050 sonstigesmodellcharacter varying[],3051 anlasscharacter varying,3052 3053 namecharacter varying,3054 3046 ogc_fid serial NOT NULL, 3047 gml_id character(16) NOT NULL, 3048 --identifier character varying, 3049 beginnt character(20), 3050 endet character(20), 3051 advstandardmodell character varying[], 3052 sonstigesmodell character varying[], 3053 anlass character varying, 3054 archaeologischertyp integer, 3055 name character varying, 3056 CONSTRAINT ax_historischesbauwerkoderhistorischeeinrichtung_pk PRIMARY KEY (ogc_fid) 3055 3057 ); 3056 3058 … … 3068 3070 -- Objektart: AX_HeilquelleGasquelle Kennung: 51008 3069 3071 CREATE TABLE ax_heilquellegasquelle ( 3070 ogc_fidserial NOT NULL,3071 gml_id character varyingNOT NULL,3072 identifiercharacter varying,3073 beginntcharacter(20),3074 endetcharacter(20),3075 advstandardmodellcharacter varying[],3076 sonstigesmodellcharacter varying[],3077 anlasscharacter varying,3078 artinteger,3079 namecharacter varying,3080 3072 ogc_fid serial NOT NULL, 3073 gml_id character(16) NOT NULL, 3074 --identifier character varying, 3075 beginnt character(20), 3076 endet character(20), 3077 advstandardmodell character varying[], 3078 sonstigesmodell character varying[], 3079 anlass character varying, 3080 art integer, 3081 name character varying, 3082 CONSTRAINT ax_heilquellegasquelle_pk PRIMARY KEY (ogc_fid) 3081 3083 ); 3082 3084 … … 3094 3096 -- Objektart: AX_SonstigesBauwerkOderSonstigeEinrichtung Kennung: 51009 3095 3097 CREATE TABLE ax_sonstigesbauwerkodersonstigeeinrichtung ( 3096 ogc_fidserial NOT NULL,3097 gml_id character varyingNOT NULL,3098 identifiercharacter varying,3099 beginntcharacter(20),3100 endetcharacter(20),3101 advstandardmodellcharacter varying[],3102 sonstigesmodellcharacter varying[],3103 anlasscharacter varying,3104 descriptioninteger,3105 namecharacter varying,3106 bauwerksfunktioninteger,3107 funktioninteger,3108 3109 gehoertzubauwerkcharacter varying, --> ax_bauwerkeeinrichtungenundsonstigeangaben3110 gehoertzucharacter varying, --> ax_gebaeude3111 3098 ogc_fid serial NOT NULL, 3099 gml_id character(16) NOT NULL, 3100 --identifier character varying, 3101 beginnt character(20), 3102 endet character(20), 3103 advstandardmodell character varying[], 3104 sonstigesmodell character varying[], 3105 anlass character varying, 3106 description integer, 3107 name character varying, 3108 bauwerksfunktion integer, 3109 funktion integer, 3110 -- Beziehungen: 3111 gehoertzubauwerk character varying, --> ax_bauwerkeeinrichtungenundsonstigeangaben 3112 gehoertzu character varying, --> ax_gebaeude 3113 CONSTRAINT ax_sonstigesbauwerkodersonstigeeinrichtung_pk PRIMARY KEY (ogc_fid) 3112 3114 ); 3113 3115 … … 3131 3133 -- Objektart: AX_EinrichtungInOeffentlichenBereichen Kennung: 51010 3132 3134 CREATE TABLE ax_einrichtunginoeffentlichenbereichen ( 3133 ogc_fidserial NOT NULL,3134 gml_id character varyingNOT NULL,3135 identifiercharacter varying,3136 beginntcharacter(20),3137 endetcharacter(20),3138 advstandardmodellcharacter varying[],3139 sonstigesmodellcharacter varying[],3140 anlasscharacter varying,3141 artinteger,3142 kilometerangabecharacter varying,3143 3135 ogc_fid serial NOT NULL, 3136 gml_id character(16) NOT NULL, 3137 --identifier character varying, 3138 beginnt character(20), 3139 endet character(20), 3140 advstandardmodell character varying[], 3141 sonstigesmodell character varying[], 3142 anlass character varying, 3143 art integer, 3144 kilometerangabe character varying, 3145 CONSTRAINT ax_einrichtunginoeffentlichenbereichen_pk PRIMARY KEY (ogc_fid) 3144 3146 ); 3145 3147 … … 3157 3159 -- Objektart: AX_BesondererBauwerkspunkt Kennung: 51011 3158 3160 CREATE TABLE ax_besondererbauwerkspunkt ( 3159 ogc_fidserial NOT NULL,3160 gml_id character varyingNOT NULL,3161 identifiercharacter varying,3162 beginntcharacter(20),3163 endetcharacter(20),3164 advstandardmodellcharacter varying[],3165 sonstigesmodellcharacter varying[],3166 anlasscharacter varying,3167 punktkennungcharacter varying,3168 landcharacter varying,3169 stellecharacter varying,3170 3171 3161 ogc_fid serial NOT NULL, 3162 gml_id character(16) NOT NULL, 3163 --identifier character varying, 3164 beginnt character(20), 3165 endet character(20), 3166 advstandardmodell character varying[], 3167 sonstigesmodell character varying[], 3168 anlass character varying, 3169 punktkennung character varying, 3170 land character varying, 3171 stelle character varying, 3172 sonstigeeigenschaft character varying[], 3173 CONSTRAINT ax_besondererbauwerkspunkt_pk PRIMARY KEY (ogc_fid) 3172 3174 ); 3173 3175 … … 3191 3193 -- Objektart: AX_BauwerkImVerkehrsbereich Kennung: 53001 3192 3194 CREATE TABLE ax_bauwerkimverkehrsbereich ( 3193 ogc_fidserial NOT NULL,3194 gml_id character varyingNOT NULL,3195 identifiercharacter varying,3196 beginntcharacter(20),3197 endetcharacter(20),3198 advstandardmodellcharacter varying[],3199 sonstigesmodellcharacter varying[],3200 anlasscharacter varying,3201 bauwerksfunktioninteger,3202 namecharacter varying,3203 zustandinteger,3204 3195 ogc_fid serial NOT NULL, 3196 gml_id character(16) NOT NULL, 3197 --identifier character varying, 3198 beginnt character(20), 3199 endet character(20), 3200 advstandardmodell character varying[], 3201 sonstigesmodell character varying[], 3202 anlass character varying, 3203 bauwerksfunktion integer, 3204 name character varying, 3205 zustand integer, 3206 CONSTRAINT ax_bauwerkimverkehrsbereich_pk PRIMARY KEY (ogc_fid) 3205 3207 ); 3206 3208 … … 3218 3220 -- Objektart: AX_Strassenverkehrsanlage Kennung: 53002 3219 3221 CREATE TABLE ax_strassenverkehrsanlage ( 3220 ogc_fidserial NOT NULL,3221 gml_id character varyingNOT NULL,3222 identifiercharacter varying,3223 beginntcharacter(20),3224 endetcharacter(20),3225 advstandardmodellcharacter varying[],3226 sonstigesmodellcharacter varying[],3227 anlasscharacter varying,3228 artinteger,3229 bezeichnungcharacter varying,3230 namecharacter varying,3231 3222 ogc_fid serial NOT NULL, 3223 gml_id character(16) NOT NULL, 3224 --identifier character varying, 3225 beginnt character(20), 3226 endet character(20), 3227 advstandardmodell character varying[], 3228 sonstigesmodell character varying[], 3229 anlass character varying, 3230 art integer, 3231 bezeichnung character varying, 3232 name character varying, 3233 CONSTRAINT ax_strassenverkehrsanlage_pk PRIMARY KEY (ogc_fid) 3232 3234 ); 3233 3235 … … 3245 3247 -- Objektart: AX_WegPfadSteig Kennung: 53003 3246 3248 CREATE TABLE ax_wegpfadsteig ( 3247 ogc_fidserial NOT NULL,3248 gml_id character varyingNOT NULL,3249 identifiercharacter varying,3250 beginntcharacter(20),3251 endetcharacter(20),3252 advstandardmodellcharacter varying[],3253 sonstigesmodellcharacter varying[],3254 anlasscharacter varying,3255 artinteger,3256 namecharacter varying,3257 3249 ogc_fid serial NOT NULL, 3250 gml_id character(16) NOT NULL, 3251 --identifier character varying, 3252 beginnt character(20), 3253 endet character(20), 3254 advstandardmodell character varying[], 3255 sonstigesmodell character varying[], 3256 anlass character varying, 3257 art integer, 3258 name character varying, 3259 CONSTRAINT ax_wegpfadsteig_pk PRIMARY KEY (ogc_fid) 3258 3260 ); 3259 3261 … … 3271 3273 -- Objektart: AX_Bahnverkehrsanlage Kennung: 53004 3272 3274 CREATE TABLE ax_bahnverkehrsanlage ( 3273 ogc_fidserial NOT NULL,3274 gml_id character varyingNOT NULL,3275 identifiercharacter varying,3276 beginntcharacter(20),3277 endetcharacter(20),3278 advstandardmodellcharacter varying[],3279 sonstigesmodellcharacter varying[],3280 anlasscharacter varying,3281 bahnhofskategorieinteger,3282 bahnkategorieinteger,3283 namecharacter varying,3284 3275 ogc_fid serial NOT NULL, 3276 gml_id character(16) NOT NULL, 3277 --identifier character varying, 3278 beginnt character(20), 3279 endet character(20), 3280 advstandardmodell character varying[], 3281 sonstigesmodell character varying[], 3282 anlass character varying, 3283 bahnhofskategorie integer, 3284 bahnkategorie integer, 3285 name character varying, 3286 CONSTRAINT ax_bahnverkehrsanlage_pk PRIMARY KEY (ogc_fid) 3285 3287 ); 3286 3288 … … 3299 3301 -- Objektart: AX_SeilbahnSchwebebahn Kennung: 53005 3300 3302 CREATE TABLE ax_seilbahnschwebebahn ( 3301 ogc_fidserial NOT NULL,3302 gml_id character varyingNOT NULL,3303 identifiercharacter varying,3304 beginntcharacter(20),3305 endetcharacter(20),3306 advstandardmodellcharacter varying[],3307 sonstigesmodellcharacter varying[],3308 anlasscharacter varying,3309 bahnkategorieinteger,3310 namecharacter varying,3311 3303 ogc_fid serial NOT NULL, 3304 gml_id character(16) NOT NULL, 3305 --identifier character varying, 3306 beginnt character(20), 3307 endet character(20), 3308 advstandardmodell character varying[], 3309 sonstigesmodell character varying[], 3310 anlass character varying, 3311 bahnkategorie integer, 3312 name character varying, 3313 CONSTRAINT ax_seilbahnschwebebahn_pk PRIMARY KEY (ogc_fid) 3312 3314 ); 3313 3315 … … 3325 3327 -- Objektart: AX_Gleis Kennung: 53006 3326 3328 CREATE TABLE ax_gleis ( 3327 ogc_fidserial NOT NULL,3328 gml_id character varyingNOT NULL,3329 identifiercharacter varying,3330 beginntcharacter(20),3331 endetcharacter(20),3332 advstandardmodellcharacter varying[],3333 sonstigesmodellcharacter varying[],3334 anlasscharacter varying,3335 bahnkategorieinteger,3336 artinteger,3337 lagezuroberflaecheinteger,3338 namecharacter varying,3339 3329 ogc_fid serial NOT NULL, 3330 gml_id character(16) NOT NULL, 3331 --identifier character varying, 3332 beginnt character(20), 3333 endet character(20), 3334 advstandardmodell character varying[], 3335 sonstigesmodell character varying[], 3336 anlass character varying, 3337 bahnkategorie integer, 3338 art integer, 3339 lagezuroberflaeche integer, 3340 name character varying, 3341 CONSTRAINT ax_gleis_pk PRIMARY KEY (ogc_fid) 3340 3342 ); 3341 3343 … … 3353 3355 -- Objektart: AX_Flugverkehrsanlage Kennung: 53007 3354 3356 CREATE TABLE ax_flugverkehrsanlage ( 3355 ogc_fidserial NOT NULL,3356 gml_id character varyingNOT NULL,3357 identifiercharacter varying,3358 beginntcharacter(20),3359 endetcharacter(20),3360 advstandardmodellcharacter varying[],3361 sonstigesmodellcharacter varying[],3362 anlasscharacter varying,3363 artinteger,3364 3365 namecharacter varying,3366 3357 ogc_fid serial NOT NULL, 3358 gml_id character(16) NOT NULL, 3359 --identifier character varying, 3360 beginnt character(20), 3361 endet character(20), 3362 advstandardmodell character varying[], 3363 sonstigesmodell character varying[], 3364 anlass character varying, 3365 art integer, 3366 oberflaechenmaterial integer, 3367 name character varying, 3368 CONSTRAINT ax_flugverkehrsanlage_pk PRIMARY KEY (ogc_fid) 3367 3369 ); 3368 3370 … … 3380 3382 -- Objektart: AX_EinrichtungenFuerDenSchiffsverkehr Kennung: 53008 3381 3383 CREATE TABLE ax_einrichtungenfuerdenschiffsverkehr ( 3382 ogc_fidserial NOT NULL,3383 gml_id character varyingNOT NULL,3384 identifiercharacter varying,3385 beginntcharacter(20),3386 endetcharacter(20),3387 advstandardmodellcharacter varying[],3388 sonstigesmodellcharacter varying[],3389 anlasscharacter varying,3390 artinteger,3391 kilometerangabecharacter varying,3392 namecharacter varying,3393 3384 ogc_fid serial NOT NULL, 3385 gml_id character(16) NOT NULL, 3386 --identifier character varying, 3387 beginnt character(20), 3388 endet character(20), 3389 advstandardmodell character varying[], 3390 sonstigesmodell character varying[], 3391 anlass character varying, 3392 art integer, 3393 kilometerangabe character varying, 3394 name character varying, 3395 CONSTRAINT ax_einrichtungfuerdenschiffsverkehr_pk PRIMARY KEY (ogc_fid) 3394 3396 ); 3395 3397 … … 3407 3409 -- Objektart: AX_BauwerkImGewaesserbereich Kennung: 53009 3408 3410 CREATE TABLE ax_bauwerkimgewaesserbereich ( 3409 ogc_fidserial NOT NULL,3410 gml_id character varyingNOT NULL,3411 identifiercharacter varying,3412 beginntcharacter(20),3413 endetcharacter(20),3414 advstandardmodellcharacter varying[],3415 sonstigesmodellcharacter varying[],3416 anlasscharacter varying,3417 bauwerksfunktioninteger,3418 namecharacter varying,3419 zustandinteger,3420 3411 ogc_fid serial NOT NULL, 3412 gml_id character(16) NOT NULL, 3413 --identifier character varying, 3414 beginnt character(20), 3415 endet character(20), 3416 advstandardmodell character varying[], 3417 sonstigesmodell character varying[], 3418 anlass character varying, 3419 bauwerksfunktion integer, 3420 name character varying, 3421 zustand integer, 3422 CONSTRAINT ax_bauwerkimgewaesserbereich_pk PRIMARY KEY (ogc_fid) 3421 3423 ); 3422 3424 … … 3437 3439 -- Objektart: AX_Vegetationsmerkmal Kennung: 54001 3438 3440 CREATE TABLE ax_vegetationsmerkmal ( 3439 ogc_fidserial NOT NULL,3440 gml_id character varyingNOT NULL,3441 identifiercharacter varying,3442 beginntcharacter(20),3443 endetcharacter(20),3444 advstandardmodellcharacter varying[],3445 sonstigesmodellcharacter varying[],3446 anlasscharacter varying,3447 bewuchsinteger,3448 zustandinteger,3449 namecharacter varying,3450 3441 ogc_fid serial NOT NULL, 3442 gml_id character(16) NOT NULL, 3443 --identifier character varying, 3444 beginnt character(20), 3445 endet character(20), 3446 advstandardmodell character varying[], 3447 sonstigesmodell character varying[], 3448 anlass character varying, 3449 bewuchs integer, 3450 zustand integer, 3451 name character varying, 3452 CONSTRAINT ax_vegetationsmerkmal_pk PRIMARY KEY (ogc_fid) 3451 3453 ); 3452 3454 … … 3467 3469 -- Objektart: AX_Gewaessermerkmal Kennung: 55001 3468 3470 CREATE TABLE ax_gewaessermerkmal ( 3469 ogc_fidserial NOT NULL,3470 gml_id character varyingNOT NULL,3471 identifiercharacter varying,3472 beginntcharacter(20),3473 endetcharacter(20),3474 advstandardmodellcharacter varying[],3475 sonstigesmodellcharacter varying[],3476 anlasscharacter varying,3477 artinteger,3478 namecharacter varying,3479 3471 ogc_fid serial NOT NULL, 3472 gml_id character(16) NOT NULL, 3473 --identifier character varying, 3474 beginnt character(20), 3475 endet character(20), 3476 advstandardmodell character varying[], 3477 sonstigesmodell character varying[], 3478 anlass character varying, 3479 art integer, 3480 name character varying, 3481 CONSTRAINT ax_gewaessermerkmal_pk PRIMARY KEY (ogc_fid) 3480 3482 ); 3481 3483 … … 3493 3495 -- Objektart: AX_UntergeordnetesGewaesser Kennung: 55002 3494 3496 CREATE TABLE ax_untergeordnetesgewaesser ( 3495 ogc_fidserial NOT NULL,3496 gml_id character varyingNOT NULL,3497 identifiercharacter varying,3498 beginntcharacter(20),3499 endetcharacter(20),3500 advstandardmodellcharacter varying[],3501 sonstigesmodellcharacter varying[],3502 anlasscharacter varying,3503 funktioninteger,3504 lagezurerdoberflaecheinteger,3505 hydrologischesmerkmalinteger,3506 namecharacter varying,3507 3497 ogc_fid serial NOT NULL, 3498 gml_id character(16) NOT NULL, 3499 --identifier character varying, 3500 beginnt character(20), 3501 endet character(20), 3502 advstandardmodell character varying[], 3503 sonstigesmodell character varying[], 3504 anlass character varying, 3505 funktion integer, 3506 lagezurerdoberflaeche integer, 3507 hydrologischesmerkmal integer, 3508 name character varying, 3509 CONSTRAINT ax_untergeordnetesgewaesser_pk PRIMARY KEY (ogc_fid) 3508 3510 ); 3509 3511 … … 3536 3538 -- Objektart: AX_Wasserspiegelhoehe Kennung: 57001 3537 3539 CREATE TABLE ax_wasserspiegelhoehe ( 3538 ogc_fidserial NOT NULL,3539 gml_id character varyingNOT NULL,3540 identifiercharacter varying,3541 beginntcharacter(20),3542 endetcharacter(20),3543 advstandardmodellcharacter varying[],3544 sonstigesmodellcharacter varying[],3545 anlasscharacter varying,3546 hoehedeswasserspiegelsdouble precision,3547 3540 ogc_fid serial NOT NULL, 3541 gml_id character(16) NOT NULL, 3542 --identifier character varying, 3543 beginnt character(20), 3544 endet character(20), 3545 advstandardmodell character varying[], 3546 sonstigesmodell character varying[], 3547 anlass character varying, 3548 hoehedeswasserspiegels double precision, 3549 CONSTRAINT ax_wasserspiegelhoehe_pk PRIMARY KEY (ogc_fid) 3548 3550 ); 3549 3551 … … 3560 3562 -- Objektart: AX_SchifffahrtslinieFaehrverkehr Kennung: 57002 3561 3563 CREATE TABLE ax_schifffahrtsliniefaehrverkehr ( 3562 ogc_fidserial NOT NULL,3563 gml_id character varyingNOT NULL,3564 identifiercharacter varying,3565 beginntcharacter(20),3566 endetcharacter(20),3567 advstandardmodellcharacter varying[],3568 sonstigesmodellcharacter varying[],3569 anlasscharacter varying,3570 artinteger[],3571 namecharacter varying,3572 3564 ogc_fid serial NOT NULL, 3565 gml_id character(16) NOT NULL, 3566 --identifier character varying, 3567 beginnt character(20), 3568 endet character(20), 3569 advstandardmodell character varying[], 3570 sonstigesmodell character varying[], 3571 anlass character varying, 3572 art integer[], 3573 name character varying, 3574 CONSTRAINT ax_schifffahrtsliniefaehrverkehr_pk PRIMARY KEY (ogc_fid) 3573 3575 ); 3574 3576 … … 3593 3595 -- Objektart: AX_BoeschungKliff Kennung: 61001 3594 3596 CREATE TABLE ax_boeschungkliff ( 3595 ogc_fidserial NOT NULL,3596 gml_id character varyingNOT NULL,3597 identifiercharacter varying,3598 beginntcharacter(20),3599 endetcharacter(20),3600 advstandardmodellcharacter varying[],3601 sonstigesmodellcharacter varying[],3602 anlasscharacter varying,3603 objekthoehedouble precision,3604 3597 ogc_fid serial NOT NULL, 3598 gml_id character(16) NOT NULL, 3599 --identifier character varying, 3600 beginnt character(20), 3601 endet character(20), 3602 advstandardmodell character varying[], 3603 sonstigesmodell character varying[], 3604 anlass character varying, 3605 objekthoehe double precision, 3606 CONSTRAINT ax_boeschungkliff_pk PRIMARY KEY (ogc_fid) 3605 3607 ); 3606 3608 … … 3619 3621 -- Objektart: AX_Boeschungsflaeche Kennung: 61002 3620 3622 CREATE TABLE ax_boeschungsflaeche ( 3621 ogc_fidserial NOT NULL,3622 gml_id character varyingNOT NULL,3623 identifiercharacter varying,3624 beginntcharacter(20),3625 endetcharacter(20),3626 advstandardmodellcharacter varying[],3627 sonstigesmodellcharacter varying[],3628 anlasscharacter varying,3629 3630 istteilvon character varying,-- Index drauf?3631 3623 ogc_fid serial NOT NULL, 3624 gml_id character(16) NOT NULL, 3625 --identifier character varying, 3626 beginnt character(20), 3627 endet character(20), 3628 advstandardmodell character varying[], 3629 sonstigesmodell character varying[], 3630 anlass character varying, 3631 -- Beziehungen: 3632 istteilvon character varying, -- Index drauf? 3633 CONSTRAINT ax_boeschungsflaeche_pk PRIMARY KEY (ogc_fid) 3632 3634 ); 3633 3635 … … 3646 3648 -- Objektart: AX_DammWallDeich Kennung: 61003 3647 3649 CREATE TABLE ax_dammwalldeich ( 3648 ogc_fidserial NOT NULL,3649 gml_id character varyingNOT NULL,3650 identifiercharacter varying,3651 beginntcharacter(20),3652 endetcharacter(20),3653 advstandardmodellcharacter varying[],3654 sonstigesmodellcharacter varying[],3655 anlasscharacter varying,3656 artinteger,3657 namecharacter varying,3658 funktioninteger,3659 3650 ogc_fid serial NOT NULL, 3651 gml_id character(16) NOT NULL, 3652 --identifier character varying, 3653 beginnt character(20), 3654 endet character(20), 3655 advstandardmodell character varying[], 3656 sonstigesmodell character varying[], 3657 anlass character varying, 3658 art integer, 3659 name character varying, 3660 funktion integer, 3661 CONSTRAINT ax_dammwalldeich_pk PRIMARY KEY (ogc_fid) 3660 3662 ); 3661 3663 … … 3673 3675 -- Objektart: AX_Hoehleneingang Kennung: 61005 3674 3676 CREATE TABLE ax_hoehleneingang ( 3675 ogc_fidserial NOT NULL,3676 gml_id character varyingNOT NULL,3677 identifiercharacter varying,3678 beginntcharacter(20),3679 endetcharacter(20),3680 advstandardmodellcharacter varying[],3681 sonstigesmodellcharacter varying[],3682 anlasscharacter varying,3683 namecharacter varying,3684 ax_datenerhebunginteger,3685 3677 ogc_fid serial NOT NULL, 3678 gml_id character(16) NOT NULL, 3679 --identifier character varying, 3680 beginnt character(20), 3681 endet character(20), 3682 advstandardmodell character varying[], 3683 sonstigesmodell character varying[], 3684 anlass character varying, 3685 name character varying, 3686 ax_datenerhebung integer, 3687 CONSTRAINT ax_hoehleneingang_pk PRIMARY KEY (ogc_fid) 3686 3688 ); 3687 3689 … … 3699 3701 -- Objektart: AX_FelsenFelsblockFelsnadel Kennung: 61006 3700 3702 CREATE TABLE ax_felsenfelsblockfelsnadel ( 3701 ogc_fidserial NOT NULL,3702 gml_id character varyingNOT NULL,3703 identifiercharacter varying,3704 beginntcharacter(20),3705 endetcharacter(20),3706 advstandardmodellcharacter varying[],3707 sonstigesmodellcharacter varying[],3708 anlasscharacter varying,3709 namecharacter varying,3710 3703 ogc_fid serial NOT NULL, 3704 gml_id character(16) NOT NULL, 3705 --identifier character varying, 3706 beginnt character(20), 3707 endet character(20), 3708 advstandardmodell character varying[], 3709 sonstigesmodell character varying[], 3710 anlass character varying, 3711 name character varying, 3712 CONSTRAINT ax_felsenfelsblockfelsnadel_pk PRIMARY KEY (ogc_fid) 3711 3713 ); 3712 3714 … … 3724 3726 -- Objektart: AX_Duene Kennung: 61007 3725 3727 CREATE TABLE ax_duene ( 3726 ogc_fidserial NOT NULL,3727 gml_id character varyingNOT NULL,3728 identifiercharacter varying,3729 beginntcharacter(20),3730 endetcharacter(20),3731 advstandardmodellcharacter varying[],3732 sonstigesmodellcharacter varying[],3733 anlasscharacter varying,3734 namecharacter varying,3735 3728 ogc_fid serial NOT NULL, 3729 gml_id character(16) NOT NULL, 3730 --identifier character varying, 3731 beginnt character(20), 3732 endet character(20), 3733 advstandardmodell character varying[], 3734 sonstigesmodell character varying[], 3735 anlass character varying, 3736 name character varying, 3737 CONSTRAINT ax_duene_pk PRIMARY KEY (ogc_fid) 3736 3738 ); 3737 3739 SELECT AddGeometryColumn('ax_duene','wkb_geometry',:alkis_epsg,'GEOMETRY',2); … … 3748 3750 -- Objektart: AX_Hoehenlinie Kennung: 61008 3749 3751 CREATE TABLE ax_hoehenlinie ( 3750 ogc_fidserial NOT NULL,3751 gml_id character varyingNOT NULL,3752 identifiercharacter varying,3753 beginntcharacter(20),3754 endetcharacter(20),3755 advstandardmodellcharacter varying[],3756 sonstigesmodellcharacter varying[],3757 anlasscharacter varying,3758 hoehevonhoehenliniedouble precision,3759 3752 ogc_fid serial NOT NULL, 3753 gml_id character(16) NOT NULL, 3754 --identifier character varying, 3755 beginnt character(20), 3756 endet character(20), 3757 advstandardmodell character varying[], 3758 sonstigesmodell character varying[], 3759 anlass character varying, 3760 hoehevonhoehenlinie double precision, 3761 CONSTRAINT ax_hoehenlinie_pk PRIMARY KEY (ogc_fid) 3760 3762 ); 3761 3763 … … 3775 3777 -- Objektart: AX_BesondererTopographischerPunkt Kennung: 61009 3776 3778 CREATE TABLE ax_besonderertopographischerpunkt ( 3777 ogc_fidserial NOT NULL,3778 gml_id character varyingNOT NULL,3779 identifiercharacter varying,3780 beginntcharacter(20),3781 endetcharacter(20),3782 advstandardmodellcharacter varying[],3783 sonstigesmodellcharacter varying[],3784 anlasscharacter varying,3785 landcharacter varying,3786 stellecharacter varying,3787 punktkennungcharacter varying,3788 3789 3779 ogc_fid serial NOT NULL, 3780 gml_id character(16) NOT NULL, 3781 --identifier character varying, 3782 beginnt character(20), 3783 endet character(20), 3784 advstandardmodell character varying[], 3785 sonstigesmodell character varying[], 3786 anlass character varying, 3787 land character varying, 3788 stelle character varying, 3789 punktkennung character varying, 3790 sonstigeeigenschaft character varying[], 3791 CONSTRAINT ax_besonderertopographischerpunkt_pk PRIMARY KEY (ogc_fid) 3790 3792 ); 3791 3793 … … 3802 3804 -- Objektart: AX_Soll Kennung: 61010 3803 3805 CREATE TABLE ax_soll ( 3804 ogc_fidserial NOT NULL,3805 gml_id character varyingNOT NULL,3806 identifiercharacter varying,3807 beginntcharacter(20),3808 endetcharacter(20),3809 advstandardmodellcharacter varying[],3810 sonstigesmodellcharacter varying[],3811 anlasscharacter varying,3812 namecharacter varying,3813 3806 ogc_fid serial NOT NULL, 3807 gml_id character(16) NOT NULL, 3808 --identifier character varying, 3809 beginnt character(20), 3810 endet character(20), 3811 advstandardmodell character varying[], 3812 sonstigesmodell character varying[], 3813 anlass character varying, 3814 name character varying, 3815 CONSTRAINT ax_soll_pk PRIMARY KEY (ogc_fid) 3814 3816 ); 3815 3817 … … 3834 3836 -- Objektart: AX_Gelaendekante Kennung: 62040 3835 3837 CREATE TABLE ax_gelaendekante ( 3836 ogc_fidserial NOT NULL,3837 gml_id character varyingNOT NULL,3838 identifiercharacter varying,3839 beginntcharacter(20),3840 endetcharacter(20),3841 advstandardmodellcharacter varying[],3842 sonstigesmodellcharacter varying[],3843 anlasscharacter varying,3844 artdergelaendekanteinteger,3845 ax_dqerfassungsmethodeinteger,3846 identifikationinteger,3847 artinteger,3848 3849 3850 3838 ogc_fid serial NOT NULL, 3839 gml_id character(16) NOT NULL, 3840 --identifier character varying, 3841 beginnt character(20), 3842 endet character(20), 3843 advstandardmodell character varying[], 3844 sonstigesmodell character varying[], 3845 anlass character varying, 3846 artdergelaendekante integer, 3847 ax_dqerfassungsmethode integer, 3848 identifikation integer, 3849 art integer, 3850 -- Beziehungen: 3851 istteilvon character varying, 3852 CONSTRAINT ax_gelaendekante_pk PRIMARY KEY (ogc_fid) 3851 3853 ); 3852 3854 … … 3872 3874 -- Objektart: AX_BesondererHoehenpunkt Kennung: 62090 3873 3875 CREATE TABLE ax_besondererhoehenpunkt ( 3874 ogc_fidserial NOT NULL,3875 gml_id character varyingNOT NULL,3876 identifiercharacter varying,3877 beginntcharacter(20),3878 endetcharacter(20),3879 advstandardmodellcharacter varying[],3880 sonstigesmodellcharacter varying[],3881 anlasscharacter varying,3882 besonderebedeutunginteger,3883 3876 ogc_fid serial NOT NULL, 3877 gml_id character(16) NOT NULL, 3878 --identifier character varying, 3879 beginnt character(20), 3880 endet character(20), 3881 advstandardmodell character varying[], 3882 sonstigesmodell character varying[], 3883 anlass character varying, 3884 besonderebedeutung integer, 3885 CONSTRAINT ax_besondererhoehenpunkt_pk PRIMARY KEY (ogc_fid) 3884 3886 ); 3885 3887 … … 3914 3916 -- Objektart: AX_KlassifizierungNachStrassenrecht Kennung: 71001 3915 3917 CREATE TABLE ax_klassifizierungnachstrassenrecht ( 3916 ogc_fidserial NOT NULL,3917 gml_id character varyingNOT NULL,3918 identifiercharacter varying,3919 beginntcharacter(20),3920 endetcharacter(20),3921 advstandardmodellcharacter varying[],3922 sonstigesmodellcharacter varying[],3923 anlasscharacter varying,3924 artderfestlegunginteger,3925 landcharacter varying,3926 stellecharacter varying,3927 bezeichnungcharacter varying,3928 3918 ogc_fid serial NOT NULL, 3919 gml_id character(16) NOT NULL, 3920 --identifier character varying, 3921 beginnt character(20), 3922 endet character(20), 3923 advstandardmodell character varying[], 3924 sonstigesmodell character varying[], 3925 anlass character varying, 3926 artderfestlegung integer, 3927 land character varying, 3928 stelle character varying, 3929 bezeichnung character varying, 3930 CONSTRAINT ax_klassifizierungnachstrassenrecht_pk PRIMARY KEY (ogc_fid) 3929 3931 ); 3930 3932 … … 3948 3950 -- Objektart: AX_KlassifizierungNachWasserrecht Kennung: 71003 3949 3951 CREATE TABLE ax_klassifizierungnachwasserrecht ( 3950 ogc_fidserial NOT NULL,3951 gml_id character varyingNOT NULL,3952 identifiercharacter varying,3953 beginntcharacter(20),3954 endetcharacter(20),3955 advstandardmodellcharacter varying[],3956 sonstigesmodellcharacter varying[],3957 anlasscharacter varying,3958 artderfestlegunginteger,3959 landcharacter varying,3960 stellecharacter varying,3961 3952 ogc_fid serial NOT NULL, 3953 gml_id character(16) NOT NULL, 3954 --identifier character varying, 3955 beginnt character(20), 3956 endet character(20), 3957 advstandardmodell character varying[], 3958 sonstigesmodell character varying[], 3959 anlass character varying, 3960 artderfestlegung integer, 3961 land character varying, 3962 stelle character varying, 3963 CONSTRAINT ax_klassifizierungnachwasserrecht_pk PRIMARY KEY (ogc_fid) 3962 3964 ); 3963 3965 … … 3975 3977 -- Objektart: AX_AndereFestlegungNachWasserrecht Kennung: 71004 3976 3978 CREATE TABLE ax_anderefestlegungnachwasserrecht ( 3977 ogc_fidserial NOT NULL,3978 gml_id character varyingNOT NULL,3979 identifiercharacter varying,3980 beginntcharacter(20),3981 endetcharacter(20),3982 advstandardmodellcharacter varying[],3983 sonstigesmodellcharacter varying[],3984 anlasscharacter varying,3985 artderfestlegunginteger,3986 landcharacter varying,3987 stellecharacter varying,3988 3979 ogc_fid serial NOT NULL, 3980 gml_id character(16) NOT NULL, 3981 --identifier character varying, 3982 beginnt character(20), 3983 endet character(20), 3984 advstandardmodell character varying[], 3985 sonstigesmodell character varying[], 3986 anlass character varying, 3987 artderfestlegung integer, 3988 land character varying, 3989 stelle character varying, 3990 CONSTRAINT ax_anderefestlegungnachwasserrecht_pk PRIMARY KEY (ogc_fid) 3989 3991 ); 3990 3992 … … 4003 4005 -- Objektart: AX_SchutzgebietNachWasserrecht Kennung: 71005 4004 4006 CREATE TABLE ax_schutzgebietnachwasserrecht ( 4005 ogc_fidserial NOT NULL,4006 gml_id character varyingNOT NULL,4007 identifiercharacter varying,4008 beginntcharacter(20),4009 endetcharacter(20),4010 advstandardmodellcharacter varying[],4011 sonstigesmodellcharacter varying[],4012 anlasscharacter varying,4013 artderfestlegunginteger,4014 landcharacter varying,4015 stellecharacter varying,4016 artcharacter varying[],4017 namecharacter varying[],4018 nummerdesschutzgebietescharacter varying,4019 4007 ogc_fid serial NOT NULL, 4008 gml_id character(16) NOT NULL, 4009 --identifier character varying, 4010 beginnt character(20), 4011 endet character(20), 4012 advstandardmodell character varying[], 4013 sonstigesmodell character varying[], 4014 anlass character varying, 4015 artderfestlegung integer, 4016 land character varying, 4017 stelle character varying, 4018 art character varying[], 4019 name character varying[], 4020 nummerdesschutzgebietes character varying, 4021 CONSTRAINT ax_schutzgebietnachwasserrecht_pk PRIMARY KEY (ogc_fid) 4020 4022 ); 4021 4023 … … 4033 4035 -- Objektart: AX_NaturUmweltOderBodenschutzrecht Kennung: 71006 4034 4036 CREATE TABLE ax_naturumweltoderbodenschutzrecht ( 4035 ogc_fidserial NOT NULL,4036 gml_id character varyingNOT NULL,4037 identifiercharacter varying,4038 beginntcharacter(20),4039 endetcharacter(20),4040 advstandardmodellcharacter varying[],4041 sonstigesmodellcharacter varying[],4042 anlasscharacter varying,4043 artderfestlegunginteger,4044 landcharacter varying,4045 stellecharacter varying,4046 namecharacter varying,4047 4037 ogc_fid serial NOT NULL, 4038 gml_id character(16) NOT NULL, 4039 --identifier character varying, 4040 beginnt character(20), 4041 endet character(20), 4042 advstandardmodell character varying[], 4043 sonstigesmodell character varying[], 4044 anlass character varying, 4045 artderfestlegung integer, 4046 land character varying, 4047 stelle character varying, 4048 name character varying, 4049 CONSTRAINT ax_naturumweltoderbodenschutzrecht_pk PRIMARY KEY (ogc_fid) 4048 4050 ); 4049 4051 … … 4062 4064 -- Objektart: AX_SchutzgebietNachNaturUmweltOderBodenschutzrecht Kennung: 71007 4063 4065 CREATE TABLE ax_schutzgebietnachnaturumweltoderbodenschutzrecht ( 4064 ogc_fidserial NOT NULL,4065 gml_id character varyingNOT NULL,4066 identifiercharacter varying,4067 beginntcharacter(20),4068 endetcharacter(20),4069 advstandardmodellcharacter varying[],4070 sonstigesmodellcharacter varying[],4071 anlasscharacter varying,4072 artderfestlegunginteger,4073 landcharacter varying,4074 stellecharacter varying,4075 name 4076 4066 ogc_fid serial NOT NULL, 4067 gml_id character(16) NOT NULL, 4068 --identifier character varying, 4069 beginnt character(20), 4070 endet character(20), 4071 advstandardmodell character varying[], 4072 sonstigesmodell character varying[], 4073 anlass character varying, 4074 artderfestlegung integer, 4075 land character varying, 4076 stelle character varying, 4077 name character varying, 4078 CONSTRAINT ax_schutzgebietnachnaturumweltoderbodenschutzrecht_pk PRIMARY KEY (ogc_fid) 4077 4079 ); 4078 4080 … … 4090 4092 -- Objektart: AX_BauRaumOderBodenordnungsrecht Kennung: 71008 4091 4093 CREATE TABLE ax_bauraumoderbodenordnungsrecht ( 4092 ogc_fidserial NOT NULL,4093 gml_id character varyingNOT NULL,4094 identifiercharacter varying,4095 beginntcharacter(20),4096 endetcharacter(20),4097 advstandardmodellcharacter varying[],4098 sonstigesmodellcharacter varying[],4099 anlasscharacter varying,4100 artcharacter varying,4101 namecharacter varying,4102 artderfestlegunginteger,4103 landcharacter varying,4104 stellecharacter varying,4105 bezeichnungcharacter varying,4106 datumanordnungcharacter varying,4107 4094 ogc_fid serial NOT NULL, 4095 gml_id character(16) NOT NULL, 4096 --identifier character varying, 4097 beginnt character(20), 4098 endet character(20), 4099 advstandardmodell character varying[], 4100 sonstigesmodell character varying[], 4101 anlass character varying, 4102 art character varying, 4103 name character varying, 4104 artderfestlegung integer, 4105 land character varying, 4106 stelle character varying, 4107 bezeichnung character varying, 4108 datumanordnung character varying, 4109 CONSTRAINT ax_bauraumoderbodenordnungsrecht_pk PRIMARY KEY (ogc_fid) 4108 4110 ); 4109 4111 SELECT AddGeometryColumn('ax_bauraumoderbodenordnungsrecht','wkb_geometry',:alkis_epsg,'GEOMETRY',2); … … 4123 4125 -- Objektart: AX_Denkmalschutzrecht Kennung: 71009 4124 4126 CREATE TABLE ax_denkmalschutzrecht ( 4125 ogc_fidserial NOT NULL,4126 gml_id character varyingNOT NULL,4127 identifiercharacter varying,4128 beginntcharacter(20),4129 endetcharacter(20),4130 advstandardmodellcharacter varying[],4131 sonstigesmodellcharacter varying[],4132 anlasscharacter varying,4133 artderfestlegunginteger,4134 landcharacter varying,4135 stellecharacter varying,4136 artcharacter varying,4137 namecharacter varying,4138 4127 ogc_fid serial NOT NULL, 4128 gml_id character(16) NOT NULL, 4129 --identifier character varying, 4130 beginnt character(20), 4131 endet character(20), 4132 advstandardmodell character varying[], 4133 sonstigesmodell character varying[], 4134 anlass character varying, 4135 artderfestlegung integer, 4136 land character varying, 4137 stelle character varying, 4138 art character varying, 4139 name character varying, 4140 CONSTRAINT ax_denkmalschutzrecht_pk PRIMARY KEY (ogc_fid) 4139 4141 ); 4140 4142 … … 4153 4155 -- Objektart: AX_Forstrecht Kennung: 71010 4154 4156 CREATE TABLE ax_forstrecht ( 4155 ogc_fidserial NOT NULL,4156 gml_id character varyingNOT NULL,4157 identifiercharacter varying,4158 beginntcharacter(20),4159 endetcharacter(20),4160 advstandardmodellcharacter varying[],4161 sonstigesmodellcharacter varying[],4162 anlasscharacter varying,4163 artderfestlegunginteger,4164 besonderefunktioninteger,4165 landcharacter varying,4166 stellecharacter varying,4167 4157 ogc_fid serial NOT NULL, 4158 gml_id character(16) NOT NULL, 4159 --identifier character varying, 4160 beginnt character(20), 4161 endet character(20), 4162 advstandardmodell character varying[], 4163 sonstigesmodell character varying[], 4164 anlass character varying, 4165 artderfestlegung integer, 4166 besonderefunktion integer, 4167 land character varying, 4168 stelle character varying, 4169 CONSTRAINT ax_forstrecht_pk PRIMARY KEY (ogc_fid) 4168 4170 ); 4169 4171 … … 4182 4184 -- Objektart: AX_SonstigesRecht Kennung: 71011 4183 4185 CREATE TABLE ax_sonstigesrecht ( 4184 ogc_fidserial NOT NULL,4185 gml_id character varyingNOT NULL,4186 identifiercharacter varying,4187 beginntcharacter(20),4188 endetcharacter(20),4189 advstandardmodellcharacter varying[],4190 sonstigesmodellcharacter varying[],4191 anlasscharacter varying,4192 artderfestlegunginteger,4193 landcharacter varying,4194 stellecharacter varying,4195 bezeichnungcharacter varying,4196 characterstringcharacter varying,4197 artcharacter varying,4198 namecharacter varying,4199 funktioninteger,4200 4186 ogc_fid serial NOT NULL, 4187 gml_id character(16) NOT NULL, 4188 --identifier character varying, 4189 beginnt character(20), 4190 endet character(20), 4191 advstandardmodell character varying[], 4192 sonstigesmodell character varying[], 4193 anlass character varying, 4194 artderfestlegung integer, 4195 land character varying, 4196 stelle character varying, 4197 bezeichnung character varying, 4198 characterstring character varying, 4199 art character varying, 4200 name character varying, 4201 funktion integer, 4202 CONSTRAINT ax_sonstigesrecht_pk PRIMARY KEY (ogc_fid) 4201 4203 ); 4202 4204 … … 4216 4218 -- Objektart: AX_Schutzzone Kennung: 71012 4217 4219 CREATE TABLE ax_schutzzone ( 4218 ogc_fidserial NOT NULL,4219 gml_id character varyingNOT NULL,4220 identifiercharacter varying,4221 beginntcharacter(20),4222 endetcharacter(20),4223 advstandardmodellcharacter varying[],4224 sonstigesmodellcharacter varying[],4225 anlasscharacter varying,4226 "zone"integer,4227 artcharacter varying[],4228 4229 4230 4220 ogc_fid serial NOT NULL, 4221 gml_id character(16) NOT NULL, 4222 --identifier character varying, 4223 beginnt character(20), 4224 endet character(20), 4225 advstandardmodell character varying[], 4226 sonstigesmodell character varying[], 4227 anlass character varying, 4228 "zone" integer, 4229 art character varying[], 4230 -- Beziehungen: 4231 istteilvon character varying, --> AX_SchutzgebietNachWasserrecht 4232 CONSTRAINT ax_schutzzone_pk PRIMARY KEY (ogc_fid) 4231 4233 ); 4232 4234 … … 4253 4255 -- Objektart: AX_Bodenschaetzung Kennung: 72001 4254 4256 CREATE TABLE ax_bodenschaetzung ( 4255 ogc_fidserial NOT NULL,4256 gml_id character varyingNOT NULL,4257 identifiercharacter varying,4258 beginntcharacter(20),4259 endetcharacter(20),4260 advstandardmodellcharacter varying[],4261 sonstigesmodellcharacter varying[],4262 anlasscharacter varying,4263 artcharacter varying,4264 namecharacter varying,4265 kulturartinteger,4266 bodenartinteger,4267 zustandsstufeoderbodenstufeinteger,4268 4269 4270 ackerzahlodergruenlandzahlinteger,4271 sonstigeangabeninteger[],4272 jahreszahlinteger,4273 4257 ogc_fid serial NOT NULL, 4258 gml_id character(16) NOT NULL, 4259 --identifier character varying, 4260 beginnt character(20), 4261 endet character(20), 4262 advstandardmodell character varying[], 4263 sonstigesmodell character varying[], 4264 anlass character varying, 4265 art character varying, 4266 name character varying, 4267 kulturart integer, 4268 bodenart integer, 4269 zustandsstufeoderbodenstufe integer, 4270 entstehungsartoderklimastufewasserverhaeltnisse integer[], 4271 bodenzahlodergruenlandgrundzahl integer, 4272 ackerzahlodergruenlandzahl integer, 4273 sonstigeangaben integer[], 4274 jahreszahl integer, 4275 CONSTRAINT ax_bodenschaetzung_pk PRIMARY KEY (ogc_fid) 4274 4276 ); 4275 4277 … … 4296 4298 -- Objektart: AX_MusterLandesmusterUndVergleichsstueck Kennung: 72002 4297 4299 CREATE TABLE ax_musterlandesmusterundvergleichsstueck ( 4298 ogc_fidserial NOT NULL,4299 gml_id character varyingNOT NULL,4300 identifiercharacter varying,4301 beginntcharacter(20),4302 endetcharacter(20),4303 advstandardmodellcharacter varying[],4304 sonstigesmodellcharacter varying[],4305 anlasscharacter varying,4306 artcharacter varying,4307 namecharacter varying,4308 merkmalinteger,4309 nummercharacter varying, -- integer4310 kulturartinteger,4311 bodenartinteger,4312 zustandsstufeoderbodenstufeinteger,4313 4314 bodenzahlodergruenlandgrundzahlcharacter varying, -- integer4315 ackerzahlodergruenlandzahlcharacter varying, -- integer4316 sonstigeangabeninteger[],4317 4300 ogc_fid serial NOT NULL, 4301 gml_id character(16) NOT NULL, 4302 --identifier character varying, 4303 beginnt character(20), 4304 endet character(20), 4305 advstandardmodell character varying[], 4306 sonstigesmodell character varying[], 4307 anlass character varying, 4308 art character varying, 4309 name character varying, 4310 merkmal integer, 4311 nummer character varying, -- integer 4312 kulturart integer, 4313 bodenart integer, 4314 zustandsstufeoderbodenstufe integer, 4315 entstehungsartoderklimastufewasserverhaeltnisse integer, 4316 bodenzahlodergruenlandgrundzahl character varying, -- integer 4317 ackerzahlodergruenlandzahl character varying, -- integer 4318 sonstigeangaben integer[], 4319 CONSTRAINT ax_musterlandesmusterundvergleichsstueck_pk PRIMARY KEY (ogc_fid) 4318 4320 ); 4319 4321 … … 4342 4344 -- Objektart: AX_GrablochDerBodenschaetzung Kennung: 72003 4343 4345 CREATE TABLE ax_grablochderbodenschaetzung ( 4344 ogc_fidserial NOT NULL,4345 gml_id character varyingNOT NULL,4346 identifiercharacter varying,4347 beginntcharacter(20),4348 endetcharacter(20),4349 advstandardmodellcharacter varying[],4350 sonstigesmodellcharacter varying[],4351 anlasscharacter varying,4352 artcharacter varying,4353 namecharacter varying,4354 bedeutunginteger[],4355 landcharacter varying,4356 4357 gemarkungsnummercharacter varying,4358 nummerdesgrablochscharacter varying,4359 4360 4361 gehoertzucharacter varying, --> ax_tagesabschnitt4362 4346 ogc_fid serial NOT NULL, 4347 gml_id character(16) NOT NULL, 4348 --identifier character varying, 4349 beginnt character(20), 4350 endet character(20), 4351 advstandardmodell character varying[], 4352 sonstigesmodell character varying[], 4353 anlass character varying, 4354 art character varying, 4355 name character varying, 4356 bedeutung integer[], 4357 land character varying, 4358 nummerierungsbezirk character varying, 4359 gemarkungsnummer character varying, 4360 nummerdesgrablochs character varying, 4361 bodenzahlodergruenlandgrundzahl integer, 4362 -- Beziehungen: 4363 gehoertzu character varying, --> ax_tagesabschnitt 4364 CONSTRAINT ax_grablochderbodenschaetzung_pk PRIMARY KEY (ogc_fid) 4363 4365 ); 4364 4366 … … 4378 4380 -- Objektart: AX_Bewertung Kennung: 72004 4379 4381 CREATE TABLE ax_bewertung ( 4380 ogc_fidserial NOT NULL,4381 gml_id character varyingNOT NULL,4382 identifiercharacter varying,4383 beginntcharacter(20),4384 endetcharacter(20),4385 advstandardmodellcharacter varying[],4386 sonstigesmodellcharacter varying[],4387 anlasscharacter varying,4388 klassifizierunginteger,4389 4382 ogc_fid serial NOT NULL, 4383 gml_id character(16) NOT NULL, 4384 --identifier character varying, 4385 beginnt character(20), 4386 endet character(20), 4387 advstandardmodell character varying[], 4388 sonstigesmodell character varying[], 4389 anlass character varying, 4390 klassifizierung integer, 4391 CONSTRAINT ax_bewertung_pk PRIMARY KEY (ogc_fid) 4390 4392 ); 4391 4393 … … 4405 4407 -- Objektart: AX_Tagesabschnitt Kennung: 72006 4406 4408 CREATE TABLE ax_tagesabschnitt ( 4407 ogc_fidserial NOT NULL,4408 gml_id character varyingNOT NULL,4409 identifiercharacter varying,4410 beginntcharacter(20),4411 endetcharacter(20),4412 advstandardmodellcharacter varying[],4413 sonstigesmodellcharacter varying[],4414 anlasscharacter varying,4415 tagesabschnittsnummercharacter varying,4416 4409 ogc_fid serial NOT NULL, 4410 gml_id character(16) NOT NULL, 4411 --identifier character varying, 4412 beginnt character(20), 4413 endet character(20), 4414 advstandardmodell character varying[], 4415 sonstigesmodell character varying[], 4416 anlass character varying, 4417 tagesabschnittsnummer character varying, 4418 CONSTRAINT ax_tagesabschnitt_pk PRIMARY KEY (ogc_fid) 4417 4419 ); 4418 4420 … … 4435 4437 -- Objektart: AX_Bundesland Kennung: 73002 4436 4438 CREATE TABLE ax_bundesland ( 4437 ogc_fidserial NOT NULL,4438 gml_id character varyingNOT NULL,4439 identifiercharacter varying,4440 beginntcharacter(20),4441 endetcharacter(20),4442 advstandardmodellcharacter varying[],4443 sonstigesmodellcharacter varying[],4444 anlasscharacter varying,4445 schluesselgesamtcharacter varying,4446 bezeichnungcharacter varying,4447 landcharacter varying,4448 stellecharacter varying,4449 4439 ogc_fid serial NOT NULL, 4440 gml_id character(16) NOT NULL, 4441 --identifier character varying, 4442 beginnt character(20), 4443 endet character(20), 4444 advstandardmodell character varying[], 4445 sonstigesmodell character varying[], 4446 anlass character varying, 4447 schluesselgesamt character varying, 4448 bezeichnung character varying, 4449 land character varying, 4450 stelle character varying, 4451 CONSTRAINT ax_bundesland_pk PRIMARY KEY (ogc_fid) 4450 4452 ); 4451 4453 … … 4462 4464 -- Objektart: AX_Regierungsbezirk Kennung: 73003 4463 4465 CREATE TABLE ax_regierungsbezirk ( 4464 ogc_fidserial NOT NULL,4465 gml_id character varyingNOT NULL,4466 identifiercharacter varying,4467 beginntcharacter(20),4468 endetcharacter(20),4469 advstandardmodellcharacter varying[],4470 sonstigesmodellcharacter varying[],4471 anlasscharacter varying,4472 schluesselgesamtcharacter varying,4473 bezeichnungcharacter varying,4474 landcharacter varying,4475 regierungsbezirkcharacter varying,4476 4466 ogc_fid serial NOT NULL, 4467 gml_id character(16) NOT NULL, 4468 --identifier character varying, 4469 beginnt character(20), 4470 endet character(20), 4471 advstandardmodell character varying[], 4472 sonstigesmodell character varying[], 4473 anlass character varying, 4474 schluesselgesamt character varying, 4475 bezeichnung character varying, 4476 land character varying, 4477 regierungsbezirk character varying, 4478 CONSTRAINT ax_regierungsbezirk_pk PRIMARY KEY (ogc_fid) 4477 4479 ); 4478 4480 … … 4489 4491 -- Objektart: AX_KreisRegion Kennung: 73004 4490 4492 CREATE TABLE ax_kreisregion ( 4491 ogc_fidserial NOT NULL,4492 gml_id character varyingNOT NULL,4493 identifiercharacter varying,4494 beginntcharacter(20),4495 endetcharacter(20),4496 advstandardmodellcharacter varying[],4497 sonstigesmodellcharacter varying[],4498 anlasscharacter varying,4499 schluesselgesamtcharacter varying,4500 bezeichnungcharacter varying,4501 landcharacter varying,4502 regierungsbezirkcharacter varying,4503 kreischaracter varying,4504 4493 ogc_fid serial NOT NULL, 4494 gml_id character(16) NOT NULL, 4495 --identifier character varying, 4496 beginnt character(20), 4497 endet character(20), 4498 advstandardmodell character varying[], 4499 sonstigesmodell character varying[], 4500 anlass character varying, 4501 schluesselgesamt character varying, 4502 bezeichnung character varying, 4503 land character varying, 4504 regierungsbezirk character varying, 4505 kreis character varying, 4506 CONSTRAINT ax_kreisregion_pk PRIMARY KEY (ogc_fid) 4505 4507 ); 4506 4508 … … 4517 4519 -- Objektart: AX_Gemeinde Kennung: 73005 4518 4520 CREATE TABLE ax_gemeinde ( 4519 ogc_fidserial NOT NULL,4520 gml_id character varyingNOT NULL,4521 identifiercharacter varying,4522 beginntcharacter(20),4523 endetcharacter(20),4524 advstandardmodellcharacter varying[],4525 sonstigesmodellcharacter varying[],4526 anlasscharacter varying,4527 schluesselgesamtcharacter varying,4528 bezeichnungcharacter varying,4529 landcharacter varying,4530 regierungsbezirkcharacter varying,4531 kreischaracter varying,4532 gemeindecharacter varying,4533 stellecharacter varying,4534 4535 istamtsbezirkvoncharacter varying[], --> ax_dienststelle4536 4521 ogc_fid serial NOT NULL, 4522 gml_id character(16) NOT NULL, 4523 --identifier character varying, 4524 beginnt character(20), 4525 endet character(20), 4526 advstandardmodell character varying[], 4527 sonstigesmodell character varying[], 4528 anlass character varying, 4529 schluesselgesamt character varying, 4530 bezeichnung character varying, 4531 land character varying, 4532 regierungsbezirk character varying, 4533 kreis character varying, 4534 gemeinde character varying, 4535 stelle character varying, 4536 -- Beziehungen: 4537 istamtsbezirkvon character varying[], --> ax_dienststelle 4538 CONSTRAINT ax_gemeinde_pk PRIMARY KEY (ogc_fid) 4537 4539 ); 4538 4540 … … 4552 4554 -- Objektart: AX_Gemeindeteil Kennung: 73006 4553 4555 CREATE TABLE ax_gemeindeteil ( 4554 ogc_fidserial NOT NULL,4555 gml_id character varyingNOT NULL,4556 identifiercharacter varying,4557 beginntcharacter(20),4558 endetcharacter(20),4559 advstandardmodellcharacter varying[],4560 sonstigesmodellcharacter varying[],4561 anlasscharacter varying,4562 schluesselgesamtcharacter varying,4563 bezeichnungcharacter varying,4564 4565 landcharacter varying,4566 regierungsbezirkcharacter varying,4567 kreischaracter varying,4568 gemeindecharacter varying,4569 gemeindeteilinteger,4570 4556 ogc_fid serial NOT NULL, 4557 gml_id character(16) NOT NULL, 4558 --identifier character varying, 4559 beginnt character(20), 4560 endet character(20), 4561 advstandardmodell character varying[], 4562 sonstigesmodell character varying[], 4563 anlass character varying, 4564 schluesselgesamt character varying, 4565 bezeichnung character varying, 4566 administrativefunktion integer, 4567 land character varying, 4568 regierungsbezirk character varying, 4569 kreis character varying, 4570 gemeinde character varying, 4571 gemeindeteil integer, 4572 CONSTRAINT ax_gemeindeteil_pk PRIMARY KEY (ogc_fid) 4571 4573 ); 4572 4574 … … 4583 4585 -- Objektart: AX_Gemarkung Kennung: 73007 4584 4586 CREATE TABLE ax_gemarkung ( 4585 ogc_fidserial NOT NULL,4586 gml_id character varyingNOT NULL,4587 identifiercharacter varying,4588 beginntcharacter(20),4589 endetcharacter(20),4590 advstandardmodellcharacter varying[],4591 sonstigesmodellcharacter varying[],4592 anlasscharacter varying,4593 schluesselgesamtcharacter varying,4594 bezeichnungcharacter varying,4595 landcharacter varying,4596 gemarkungsnummercharacter varying,4597 stellecharacter varying,4598 4587 ogc_fid serial NOT NULL, 4588 gml_id character(16) NOT NULL, 4589 --identifier character varying, 4590 beginnt character(20), 4591 endet character(20), 4592 advstandardmodell character varying[], 4593 sonstigesmodell character varying[], 4594 anlass character varying, 4595 schluesselgesamt character varying, 4596 bezeichnung character varying, 4597 land character varying, 4598 gemarkungsnummer character varying, 4599 stelle character varying, 4600 CONSTRAINT ax_gemarkung_pk PRIMARY KEY (ogc_fid) 4599 4601 ); 4600 4602 … … 4612 4614 -- Objektart: AX_GemarkungsteilFlur Kennung: 73008 4613 4615 CREATE TABLE ax_gemarkungsteilflur ( 4614 ogc_fidserial NOT NULL,4615 gml_id character varyingNOT NULL,4616 identifiercharacter varying,4617 beginntcharacter(20),4618 endetcharacter(20),4619 advstandardmodellcharacter varying[],4620 sonstigesmodellcharacter varying[],4621 anlasscharacter varying,4622 schluesselgesamtcharacter varying,4623 bezeichnungcharacter varying,4624 landcharacter varying,4625 gemarkunginteger,4626 gemarkungsteilflurinteger,4627 4616 ogc_fid serial NOT NULL, 4617 gml_id character(16) NOT NULL, 4618 --identifier character varying, 4619 beginnt character(20), 4620 endet character(20), 4621 advstandardmodell character varying[], 4622 sonstigesmodell character varying[], 4623 anlass character varying, 4624 schluesselgesamt character varying, 4625 bezeichnung character varying, 4626 land character varying, 4627 gemarkung integer, 4628 gemarkungsteilflur integer, 4629 CONSTRAINT ax_gemarkungsteilflur_pk PRIMARY KEY (ogc_fid) 4628 4630 ); 4629 4631 … … 4640 4642 -- Objektart: AX_Verwaltungsgemeinschaft Kennung: 73009 4641 4643 CREATE TABLE ax_verwaltungsgemeinschaft ( 4642 ogc_fidserial NOT NULL,4643 gml_id character varyingNOT NULL,4644 identifiercharacter varying,4645 beginntcharacter(20),4646 endetcharacter(20),4647 advstandardmodellcharacter varying[],4648 sonstigesmodellcharacter varying[],4649 anlasscharacter varying,4650 schluesselgesamtcharacter varying,4651 bezeichnungcharacter varying,4652 bezeichnungartinteger,4653 landcharacter varying,4654 regierungsbezirkcharacter varying,4655 kreischaracter varying,4656 verwaltungsgemeinschaftinteger,4657 4644 ogc_fid serial NOT NULL, 4645 gml_id character(16) NOT NULL, 4646 --identifier character varying, 4647 beginnt character(20), 4648 endet character(20), 4649 advstandardmodell character varying[], 4650 sonstigesmodell character varying[], 4651 anlass character varying, 4652 schluesselgesamt character varying, 4653 bezeichnung character varying, 4654 bezeichnungart integer, 4655 land character varying, 4656 regierungsbezirk character varying, 4657 kreis character varying, 4658 verwaltungsgemeinschaft integer, 4659 CONSTRAINT ax_verwaltungsgemeinschaft_pk PRIMARY KEY (ogc_fid) 4658 4660 ); 4659 4661 … … 4674 4676 -- Objektart: AX_Buchungsblattbezirk Kennung: 73010 4675 4677 CREATE TABLE ax_buchungsblattbezirk ( 4676 ogc_fidserial NOT NULL,4677 gml_id character varyingNOT NULL,4678 identifiercharacter varying,4679 beginntcharacter(20),4680 endetcharacter(20),4681 advstandardmodellcharacter varying[],4682 sonstigesmodellcharacter varying[],4683 anlasscharacter varying,4684 schluesselgesamtcharacter varying,4685 bezeichnungcharacter varying,4686 landcharacter varying,4687 bezirkcharacter varying,4688 stellecharacter varying,4689 4690 gehoertzucharacter varying, --> ax_dienststelle4691 4678 ogc_fid serial NOT NULL, 4679 gml_id character(16) NOT NULL, 4680 --identifier character varying, 4681 beginnt character(20), 4682 endet character(20), 4683 advstandardmodell character varying[], 4684 sonstigesmodell character varying[], 4685 anlass character varying, 4686 schluesselgesamt character varying, 4687 bezeichnung character varying, 4688 land character varying, 4689 bezirk character varying, 4690 stelle character varying, 4691 -- Beziehungen: 4692 gehoertzu character varying, --> ax_dienststelle 4693 CONSTRAINT ax_buchungsblattbezirk_pk PRIMARY KEY (ogc_fid) 4692 4694 ); 4693 4695 SELECT AddGeometryColumn('ax_buchungsblattbezirk','dummy',:alkis_epsg,'POINT',2); … … 4708 4710 -- Objektart: AX_Dienststelle Kennung: 73011 4709 4711 CREATE TABLE ax_dienststelle ( 4710 ogc_fidserial NOT NULL,4711 gml_id character varyingNOT NULL,4712 identifiercharacter varying,4713 beginntcharacter(20),4714 endetcharacter(20),4715 advstandardmodellcharacter varying[],4716 sonstigesmodellcharacter varying[],4717 anlasscharacter varying,4718 schluesselgesamtcharacter varying,4719 bezeichnungcharacter varying,4720 landcharacter varying,4721 stellecharacter varying,4722 stellenartinteger,4723 kennungcharacter varying,4724 4725 hatcharacter varying, --> ax_anschrift4726 4712 ogc_fid serial NOT NULL, 4713 gml_id character(16) NOT NULL, 4714 --identifier character varying, 4715 beginnt character(20), 4716 endet character(20), 4717 advstandardmodell character varying[], 4718 sonstigesmodell character varying[], 4719 anlass character varying, 4720 schluesselgesamt character varying, 4721 bezeichnung character varying, 4722 land character varying, 4723 stelle character varying, 4724 stellenart integer, 4725 kennung character varying, 4726 -- Beziehungen: 4727 hat character varying, --> ax_anschrift 4728 CONSTRAINT ax_dienststelle_pk PRIMARY KEY (ogc_fid) 4727 4729 ); 4728 4730 … … 4750 4752 -- Objektart: AX_LagebezeichnungKatalogeintrag Kennung: 73013 4751 4753 CREATE TABLE ax_lagebezeichnungkatalogeintrag ( 4752 ogc_fidserial NOT NULL,4753 gml_id character varyingNOT NULL,4754 identifiercharacter varying,4755 beginntcharacter(20),4756 endetcharacter(20),4757 advstandardmodellcharacter varying[],4758 sonstigesmodellcharacter varying[],4759 anlasscharacter varying,4760 schluesselgesamtcharacter varying,4761 bezeichnungcharacter varying,4762 landcharacter varying,4763 regierungsbezirkcharacter varying,4764 kreischaracter varying,4765 gemeindecharacter varying,4766 lagecharacter varying, -- StraÃenschlÃŒssel4767 4754 ogc_fid serial NOT NULL, 4755 gml_id character(16) NOT NULL, 4756 --identifier character varying, 4757 beginnt character(20), 4758 endet character(20), 4759 advstandardmodell character varying[], 4760 sonstigesmodell character varying[], 4761 anlass character varying, 4762 schluesselgesamt character varying, 4763 bezeichnung character varying, 4764 land character varying, 4765 regierungsbezirk character varying, 4766 kreis character varying, 4767 gemeinde character varying, 4768 lage character varying, -- StraÃenschlÃŒssel 4769 CONSTRAINT ax_lagebezeichnungkatalogeintrag_pk PRIMARY KEY (ogc_fid) 4768 4770 ); 4769 4771 … … 4798 4800 -- Objektart: AX_KleinraeumigerLandschaftsteil Kennung: 74002 4799 4801 CREATE TABLE ax_kleinraeumigerlandschaftsteil ( 4800 ogc_fidserial NOT NULL,4801 gml_id character varyingNOT NULL,4802 identifiercharacter varying,4803 beginntcharacter(20),4804 endetcharacter(20),4805 advstandardmodellcharacter varying[],4806 sonstigesmodellcharacter varying[],4807 anlasscharacter varying,4808 landschaftstypinteger,4809 namecharacter varying,4810 4802 ogc_fid serial NOT NULL, 4803 gml_id character(16) NOT NULL, 4804 --identifier character varying, 4805 beginnt character(20), 4806 endet character(20), 4807 advstandardmodell character varying[], 4808 sonstigesmodell character varying[], 4809 anlass character varying, 4810 landschaftstyp integer, 4811 name character varying, 4812 CONSTRAINT ax_kleinraeumigerlandschaftsteil_pk PRIMARY KEY (ogc_fid) 4811 4813 ); 4812 4814 … … 4827 4829 -- Objektart: AX_Wohnplatz Kennung: 74005 4828 4830 CREATE TABLE ax_wohnplatz ( 4829 ogc_fidserial NOT NULL,4830 gml_id character varyingNOT NULL,4831 identifiercharacter varying,4832 beginntcharacter(20),4833 endetcharacter(20),4834 advstandardmodellcharacter varying[],4835 sonstigesmodellcharacter varying[],4836 anlasscharacter varying,4837 namecharacter varying,4838 zweitnamecharacter varying,4839 4831 ogc_fid serial NOT NULL, 4832 gml_id character(16) NOT NULL, 4833 --identifier character varying, 4834 beginnt character(20), 4835 endet character(20), 4836 advstandardmodell character varying[], 4837 sonstigesmodell character varying[], 4838 anlass character varying, 4839 name character varying, 4840 zweitname character varying, 4841 CONSTRAINT ax_wohnplatz_pk PRIMARY KEY (ogc_fid) 4840 4842 ); 4841 4843 SELECT AddGeometryColumn('ax_wohnplatz','wkb_geometry',:alkis_epsg,'POINT',2); … … 4859 4861 -- Objektart: AX_Baublock Kennung: 75001 4860 4862 CREATE TABLE ax_baublock ( 4861 ogc_fidserial NOT NULL,4862 gml_id character varyingNOT NULL,4863 identifiercharacter varying,4864 beginntcharacter(20),4865 endetcharacter(20),4866 advstandardmodellcharacter varying[],4867 sonstigesmodellcharacter varying[],4868 anlasscharacter varying,4869 4870 artinteger,4871 4863 ogc_fid serial NOT NULL, 4864 gml_id character(16) NOT NULL, 4865 --identifier character varying, 4866 beginnt character(20), 4867 endet character(20), 4868 advstandardmodell character varying[], 4869 sonstigesmodell character varying[], 4870 anlass character varying, 4871 baublockbezeichnung character varying, 4872 art integer, 4873 CONSTRAINT ax_baublock_pk PRIMARY KEY (ogc_fid) 4872 4874 ); 4873 4875 … … 4882 4884 COMMENT ON COLUMN ax_baublock.baublockbezeichnung IS 'BBZ "Baublockbezeichnung" ist die von der Gemeinde vergebene eindeutige Bezeichnung eines Teils des Gemeindegebietes.'; 4883 4885 COMMENT ON COLUMN ax_baublock.art IS 'ART "Art" ist die Art der BaublockflÀche.'; 4884 4885 4886 4886 4887 … … 4889 4890 -- Objektart: AX_WirtschaftlicheEinheit Kennung: 75002 4890 4891 CREATE TABLE ax_wirtschaftlicheeinheit ( 4891 ogc_fidserial NOT NULL,4892 gml_id character varying(16),4893 identifier character varying(28),4894 beginnt character varying(20),4895 endet character varying(20),4896 4897 sonstigesmodellcharacter varying[],4898 anlassinteger,4899 CONSTRAINTax_wirtschaftlicheeinheit_pk PRIMARY KEY (ogc_fid)4892 ogc_fid serial NOT NULL, 4893 gml_id character(16) NOT NULL, 4894 --identifier character varying, 4895 beginnt character(20), 4896 endet character(20), 4897 advstandardmodell character varying[], 4898 sonstigesmodell character varying[], 4899 anlass integer, 4900 CONSTRAINT ax_wirtschaftlicheeinheit_pk PRIMARY KEY (ogc_fid) 4900 4901 ); 4901 4902 … … 4909 4910 -- Objektart: AX_KommunalesGebiet Kennung: 75003 4910 4911 CREATE TABLE ax_kommunalesgebiet ( 4911 ogc_fidserial NOT NULL,4912 gml_id character varyingNOT NULL,4913 identifiercharacter varying,4914 beginntcharacter(20),4915 endetcharacter(20),4916 advstandardmodellcharacter varying[],4917 sonstigesmodellcharacter varying[],4918 anlasscharacter varying,4919 schluesselgesamtcharacter varying,4920 landcharacter varying,4921 regierungsbezirkcharacter varying,4922 kreischaracter varying,4923 gemeindecharacter varying,4924 gemeindeflaechedouble precision,4925 4912 ogc_fid serial NOT NULL, 4913 gml_id character(16) NOT NULL, 4914 --identifier character varying, 4915 beginnt character(20), 4916 endet character(20), 4917 advstandardmodell character varying[], 4918 sonstigesmodell character varying[], 4919 anlass character varying, 4920 schluesselgesamt character varying, 4921 land character varying, 4922 regierungsbezirk character varying, 4923 kreis character varying, 4924 gemeinde character varying, 4925 gemeindeflaeche double precision, 4926 CONSTRAINT ax_kommunalesgebiet_pk PRIMARY KEY (ogc_fid) 4926 4927 ); 4927 4928 … … 4973 4974 -- Objektart: AX_Gebaeudeausgestaltung Kennung: 91001 4974 4975 CREATE TABLE ax_gebaeudeausgestaltung ( 4975 ogc_fidserial NOT NULL,4976 gml_id character varyingNOT NULL,4977 identifiercharacter varying,4978 beginntcharacter(20),4979 endetcharacter(20),4980 advstandardmodellcharacter varying[],4981 sonstigesmodellcharacter varying[],4982 anlasscharacter varying,4983 darstellunginteger,4984 zeigtaufcharacter varying, --> ax_gebaeude4985 4976 ogc_fid serial NOT NULL, 4977 gml_id character(16) NOT NULL, 4978 --identifier character varying, 4979 beginnt character(20), 4980 endet character(20), 4981 advstandardmodell character varying[], 4982 sonstigesmodell character varying[], 4983 anlass character varying, 4984 darstellung integer, 4985 zeigtauf character varying, --> ax_gebaeude 4986 CONSTRAINT ax_gebaeudeausgestaltung_pk PRIMARY KEY (ogc_fid) 4986 4987 ); 4987 4988 … … 5000 5001 -- Objektart: AX_TopographischeLinie Kennung: 91002 5001 5002 CREATE TABLE ax_topographischelinie ( 5002 ogc_fidserial NOT NULL,5003 gml_id character varyingNOT NULL,5004 identifiercharacter varying,5005 beginntcharacter(20),5006 endetcharacter(20),5007 advstandardmodellcharacter varying[],5008 sonstigesmodellcharacter varying[],5009 anlasscharacter varying,5010 liniendarstellunginteger,5011 5012 5003 ogc_fid serial NOT NULL, 5004 gml_id character(16) NOT NULL, 5005 --identifier character varying, 5006 beginnt character(20), 5007 endet character(20), 5008 advstandardmodell character varying[], 5009 sonstigesmodell character varying[], 5010 anlass character varying, 5011 liniendarstellung integer, 5012 sonstigeeigenschaft character varying, 5013 CONSTRAINT ax_topographischelinie_pk PRIMARY KEY (ogc_fid) 5013 5014 ); 5014 5015
Note: See TracChangeset
for help on using the changeset viewer.