114 | | ogc_fid serial NOT NULL, |
115 | | typename character varying, |
116 | | featureid character varying, |
117 | | context character varying, -- delete/replace |
118 | | safetoignore character varying, -- replace.safetoignore 'true'/'false' |
119 | | replacedBy character varying, -- gmlid |
120 | | anlass character varying, -- update.anlass |
121 | | endet character(20), -- update.endet |
122 | | ignored boolean DEFAULT false, -- Satz wurde nicht verarbeitet |
123 | | CONSTRAINT delete_pk PRIMARY KEY (ogc_fid) |
| 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) |
219 | | ogc_fid serial NOT NULL, |
220 | | gml_id character varying NOT NULL, |
221 | | identifier character varying, |
222 | | beginnt character(20), |
223 | | endet character(20), |
224 | | advstandardmodell character varying[], |
225 | | sonstigesmodell character varying[], |
226 | | anlass character varying, |
227 | | |
228 | | signaturnummer character varying, -- ap_gpo |
229 | | darstellungsprioritaet integer, -- ap_gpo |
230 | | art character varying, -- ap_gpo |
231 | | |
232 | | drehwinkel double precision, |
233 | | skalierung double precision, |
234 | | |
235 | | -- Beziehungen: |
236 | | dientzurdarstellungvon character varying[], -- -> aa_objekt |
237 | | CONSTRAINT ap_ppo_pk PRIMARY KEY (ogc_fid) |
| 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) |
266 | | ogc_fid serial NOT NULL, |
267 | | gml_id character varying NOT NULL, |
268 | | identifier character varying, |
269 | | beginnt character(20), |
270 | | endet character(20), |
271 | | advstandardmodell character varying[], |
272 | | sonstigesmodell character varying[], |
273 | | anlass character varying, |
274 | | |
275 | | signaturnummer character varying, -- ap_gpo |
276 | | darstellungsprioritaet integer, -- ap_gpo |
277 | | art character varying, -- ap_gpo |
278 | | |
279 | | -- Beziehungen: |
280 | | dientzurdarstellungvon character varying[], -- -> aa_objekt |
281 | | CONSTRAINT ap_lpo_pk PRIMARY 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) |
308 | | ogc_fid serial NOT NULL, |
309 | | gml_id character varying NOT NULL, |
310 | | identifier character varying, |
311 | | beginnt character(20), |
312 | | endet character(20), |
313 | | advstandardmodell character varying[], |
314 | | sonstigesmodell character varying[], |
315 | | anlass character varying, |
316 | | |
317 | | schriftinhalt character varying, -- Label: anzuzeigender Text |
318 | | fontsperrung double precision, |
319 | | skalierung double precision, |
320 | | horizontaleausrichtung character varying, |
321 | | vertikaleausrichtung character varying, |
322 | | |
323 | | signaturnummer character varying, -- ap_gpo |
324 | | darstellungsprioritaet integer, -- ap_gpo |
325 | | art character varying, -- ap_gpo |
326 | | |
327 | | drehwinkel double precision, -- falsche Masseinheit fÃŒr Mapserver, im View umrechnen |
328 | | -- Beziehungen: |
329 | | dientzurdarstellungvon character varying[], -- -> aa_objekt |
330 | | hat character varying, -- -> ap_lpo |
331 | | CONSTRAINT ap_pto_pk PRIMARY KEY (ogc_fid) |
| 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) |
370 | | ogc_fid serial NOT NULL, |
371 | | gml_id character varying NOT NULL, |
372 | | identifier character varying, |
373 | | beginnt character(20), |
374 | | endet character(20), |
375 | | advstandardmodell character varying[], |
376 | | sonstigesmodell character varying[], |
377 | | anlass character varying, |
378 | | schriftinhalt character varying, |
379 | | fontsperrung double precision, |
380 | | skalierung double precision, |
381 | | horizontaleausrichtung character varying, |
382 | | vertikaleausrichtung character varying, |
383 | | |
384 | | signaturnummer character varying, -- ap_gpo |
385 | | darstellungsprioritaet integer, -- ap_gpo |
386 | | art character varying, -- ap_gpo |
387 | | |
388 | | -- Beziehungen: |
389 | | dientzurdarstellungvon character varying[], -- -> aa_objekt |
390 | | hat character varying, -- -> ap_lpo |
391 | | CONSTRAINT ap_lto_pk PRIMARY KEY (ogc_fid) |
| 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) |
420 | | ogc_fid serial NOT NULL, |
421 | | gml_id character varying NOT NULL, |
422 | | identifier character varying, |
423 | | beginnt character(20), -- Datumsformat |
424 | | endet character(20), -- Datumsformat |
425 | | advstandardmodell character varying[], |
426 | | sonstigesmodell character varying[], |
427 | | anlass character varying, |
428 | | |
429 | | signaturnummer character varying, -- ap_gpo |
430 | | darstellungsprioritaet integer, -- ap_gpo |
431 | | art character varying, -- ap_gpo |
432 | | |
433 | | positionierungsregel integer, |
434 | | -- Beziehungen: |
435 | | dientzurdarstellungvon character varying[], -- -> aa_objekt |
436 | | CONSTRAINT ap_darstellung_pk PRIMARY KEY (ogc_fid) |
| 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) |
472 | | ogc_fid serial NOT NULL, |
473 | | gml_id character varying NOT NULL, -- Datenbank-Tabelle interner SchlÃŒssel |
474 | | |
475 | | -- GID: AX_Flurstueck_Kerndaten |
476 | | -- '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ÃŒckskennzeichens |
480 | | 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ÃŒllt |
485 | | amtlicheflaeche double precision, -- AFL |
486 | | abweichenderrechtszustand character varying DEFAULT 'false', -- ARZ |
487 | | rechtsbehelfsverfahren character varying DEFAULT 'false', -- RBV |
488 | | zweifelhafterFlurstuecksnachweis character varying DEFAULT 'false', -- ZFM Boolean |
489 | | zeitpunktderentstehung character varying, -- ZDE Inhalt jjjj-mm-tt besser Format date ? |
490 | | gemeinde character varying, |
491 | | -- GID: ENDE AX_Flurstueck_Kerndaten |
492 | | |
493 | | identifier character varying, |
494 | | beginnt character(20), -- Timestamp der Entstehung |
495 | | endet character(20), -- Timestamp des Untergangs |
496 | | advstandardmodell character varying[], -- steuert die Darstellung nach Kartentyp |
497 | | sonstigesmodell character varying[], |
498 | | anlass character varying, |
499 | | name character varying[], |
500 | | regierungsbezirk character varying, |
501 | | kreis character varying, |
502 | | stelle character varying[], |
503 | | angabenzumabschnittflurstueck character varying[], |
504 | | kennungschluessel character varying[], |
505 | | flaechedesabschnitts double precision[], |
506 | | angabenzumabschnittnummeraktenzeichen integer[], |
507 | | angabenzumabschnittbemerkung character varying[], |
508 | | -- Beziehungen: |
509 | | -- beziehtsichaufflurstueck character varying[], -- <- ax_flurstueck (invers) |
510 | | zeigtauf character varying[], -- -> ax_lagebezeichnungohnehausnummer |
511 | | istgebucht character varying, -- -> ax_buchungsstelle |
512 | | weistauf character varying[], -- -> ax_lagebezeichnungmithausnummer |
513 | | gehoertanteiligzu character varying[], -- -> ax_flurstueck |
514 | | CONSTRAINT ax_flurstueck_pk PRIMARY KEY (ogc_fid) |
| 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) |
599 | | ogc_fid serial NOT NULL, |
600 | | gml_id character varying NOT NULL, |
601 | | identifier character varying, |
602 | | beginnt character(20), |
603 | | endet character(20), |
604 | | advstandardmodell character varying[], |
605 | | sonstigesmodell character varying[], |
606 | | anlass character varying, |
607 | | punktkennung character varying, |
608 | | land character varying, |
609 | | stelle character varying, |
610 | | abmarkung_marke integer, |
611 | | festgestelltergrenzpunkt character varying, |
612 | | besonderepunktnummer character varying, |
613 | | bemerkungzurabmarkung integer, |
614 | | sonstigeeigenschaft character varying[], |
615 | | art character varying, |
616 | | name character varying[], |
617 | | zeitpunktderentstehung character varying, |
618 | | relativehoehe double precision, |
619 | | -- Beziehungen: |
620 | | zeigtauf character varying, -- -> ax_grenzpunkt |
621 | | CONSTRAINT ax_grenzpunkt_pk PRIMARY KEY (ogc_fid) |
| 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) |
644 | | ogc_fid serial NOT NULL, |
645 | | gml_id character varying NOT NULL, |
646 | | identifier character varying, |
647 | | beginnt character(20), |
648 | | endet character(20), |
649 | | advstandardmodell character varying[], |
650 | | sonstigesmodell character varying[], |
651 | | anlass character varying, |
652 | | unverschluesselt character varying, -- Gewanne |
653 | | land character varying, |
654 | | regierungsbezirk character varying, |
655 | | kreis character varying, |
656 | | gemeinde character varying, |
657 | | lage character varying, -- Strassenschluessel |
658 | | zusatzzurlagebezeichnung character varying, |
659 | | -- Beziehungen: |
660 | | -- beschreibt character varying[], -- <- ax_historischesflurstueckohneraumbezug |
661 | | -- gehoertzu character varying[], -- <- ax_flurstueck |
662 | | CONSTRAINT ax_lagebezeichnungohnehausnummer_pk PRIMARY KEY (ogc_fid) |
| 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) |
693 | | ogc_fid serial NOT NULL, |
694 | | gml_id character varying NOT NULL, |
695 | | identifier character varying, |
696 | | beginnt character(20), |
697 | | endet character(20), |
698 | | advstandardmodell character varying[], |
699 | | sonstigesmodell character varying[], |
700 | | anlass character varying, |
701 | | land character varying, |
702 | | regierungsbezirk character varying, |
703 | | kreis character varying, |
704 | | gemeinde character varying, |
705 | | lage character varying, -- Strassenschluessel |
706 | | hausnummer character varying, -- Nummer (blank) Zusatz |
707 | | -- Beziehungen: |
708 | | -- hat character varying[], -- <- ax_historischesflurstueckohneraumbezug |
709 | | -- beziehtsichauf character varying, -- <- ax_gebaeude |
710 | | -- beziehtsichauchauf character varying, -- <- ax_georeferenziertegebaeudeadresse |
711 | | -- gehoertzu character varying[], -- <- ax_flurstueck |
712 | | -- weistzum character varying, -- <- ax_turm |
713 | | CONSTRAINT ax_lagebezeichnungmithausnummer_pk PRIMARY KEY (ogc_fid) |
| 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) |
756 | | ogc_fid serial NOT NULL, |
757 | | gml_id character varying NOT NULL, |
758 | | identifier character varying, |
759 | | beginnt character(20), |
760 | | endet character(20), |
761 | | advstandardmodell character varying[], |
762 | | sonstigesmodell character varying[], |
763 | | anlass character varying, |
764 | | land character varying, |
765 | | regierungsbezirk character varying, |
766 | | kreis character varying, |
767 | | gemeinde character varying, |
768 | | lage character varying, -- Strassenschluessel |
769 | | pseudonummer character varying, |
770 | | laufendenummer character varying, -- leer, Zahl, "P2" |
771 | | -- Beziehungen: |
772 | | -- gehoertzu character varying, -- <- ax_gebaeude |
773 | | CONSTRAINT ax_lagebezeichnungmitpseudonummer_pk PRIMARY KEY (ogc_fid) |
| 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) |
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) |
851 | | ogc_fid serial NOT NULL, |
852 | | gml_id character varying NOT NULL, |
853 | | identifier character varying, |
854 | | beginnt character(20), |
855 | | endet character(20), |
856 | | advstandardmodell character varying[], |
857 | | sonstigesmodell character varying[], |
858 | | anlass character varying, |
859 | | punktkennung character varying, -- integer ist zu klein, |
860 | | land character varying, |
861 | | stelle character varying, |
862 | | sonstigeeigenschaft character varying[], |
863 | | vermarkung_marke integer, |
864 | | relativehoehe double precision, |
865 | | -- Beziehungen: |
866 | | hat character varying[], --> ax_sicherungspunkt |
867 | | CONSTRAINT ax_aufnahmepunkt_pk PRIMARY KEY (ogc_fid) |
| 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) |
886 | | ogc_fid serial NOT NULL, |
887 | | gml_id character varying NOT NULL, |
888 | | identifier character varying, |
889 | | beginnt character(20), |
890 | | endet character(20), |
891 | | advstandardmodell character varying[], |
892 | | sonstigesmodell character varying[], |
893 | | anlass character varying, |
894 | | name character varying, |
895 | | punktkennung character varying, |
896 | | land character varying, |
897 | | stelle character varying, |
898 | | sonstigeeigenschaft character varying[], |
899 | | vermarkung_marke integer, |
900 | | relativehoehe double precision, |
901 | | -- Beziehungen: |
902 | | -- beziehtsichauf character varying, -- <- ax_sonstigervermessungspunkt |
903 | | -- gehoertzu character varying, -- <- ax_aufnahmepunkt |
904 | | CONSTRAINT ax_sicherungspunkt_pk PRIMARY KEY (ogc_fid) |
| 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) |
921 | | ogc_fid serial NOT NULL, |
922 | | gml_id character varying NOT NULL, |
923 | | identifier character varying, |
924 | | beginnt character(20), |
925 | | endet character(20), |
926 | | advstandardmodell character varying[], |
927 | | sonstigesmodell character varying[], |
928 | | anlass character varying, |
929 | | vermarkung_marke integer, |
930 | | punktkennung character varying, -- integer, |
931 | | art character varying, |
932 | | land character varying, |
933 | | stelle character varying, |
934 | | sonstigeeigenschaft character varying[], |
935 | | relativehoehe double precision, |
936 | | -- Beziehungen: |
937 | | hat character varying[], --> ax_sicherungspunkt |
938 | | CONSTRAINT ax_sonstigervermessungspunkt_pk PRIMARY KEY (ogc_fid) |
| 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) |
974 | | ogc_fid serial NOT NULL, |
975 | | gml_id character varying NOT NULL, |
976 | | identifier character varying, |
977 | | beginnt character(20), |
978 | | endet character(20), |
979 | | advstandardmodell character varying[], |
980 | | sonstigesmodell character varying[], |
981 | | anlass character varying, |
982 | | art character varying[], |
983 | | name character varying[], |
984 | | kartendarstellung character varying, |
985 | | ax_datenerhebung_punktort integer, |
986 | | genauigkeitsstufe integer, |
987 | | vertrauenswuerdigkeit integer, |
988 | | koordinatenstatus integer, |
989 | | hinweise character varying, |
990 | | -- Beziehungen: |
991 | | istteilvon character varying, --> ? |
992 | | CONSTRAINT ax_punktortag_pk PRIMARY KEY (ogc_fid) |
| 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) |
1009 | | ogc_fid serial NOT NULL, |
1010 | | gml_id character varying NOT NULL, |
1011 | | identifier character varying, |
1012 | | beginnt character(20), |
1013 | | endet character(20), |
1014 | | advstandardmodell character varying[], |
1015 | | sonstigesmodell character varying[], |
1016 | | anlass character varying, |
1017 | | kartendarstellung character varying, -- AX_Punktort Boolean |
1018 | | ax_datenerhebung_punktort integer, |
1019 | | name character varying[], |
1020 | | individualname character varying, |
1021 | | vertrauenswuerdigkeit integer, |
1022 | | genauigkeitsstufe integer, |
1023 | | koordinatenstatus integer, -- AX_Punktort |
1024 | | -- ueberpruefungsdatum -- AX_Punktort |
1025 | | -- qualitaetsangaben -- AX_Punktort |
1026 | | hinweise character varying, -- AX_Punktort |
1027 | | -- Beziehungen: |
1028 | | istteilvon character varying, |
1029 | | CONSTRAINT ax_punktortau_pk PRIMARY KEY (ogc_fid) |
| 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) |
1047 | | ogc_fid serial NOT NULL, |
1048 | | gml_id character varying NOT NULL, |
1049 | | identifier character varying, |
1050 | | beginnt character(20), |
1051 | | endet character(20), |
1052 | | advstandardmodell character varying[], |
1053 | | sonstigesmodell character varying[], |
1054 | | anlass character varying, |
1055 | | kartendarstellung character varying, |
1056 | | description integer, |
1057 | | ax_datenerhebung_punktort integer, |
1058 | | art character varying[], |
1059 | | name character varying[], |
1060 | | genauigkeitsstufe integer, |
1061 | | vertrauenswuerdigkeit integer, |
1062 | | koordinatenstatus integer, |
1063 | | hinweise character varying, |
1064 | | -- Beziehungen: |
1065 | | istteilvon character varying, |
1066 | | CONSTRAINT ax_punktortta_pk PRIMARY KEY (ogc_fid) |
| 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) |
1087 | | ogc_fid serial NOT NULL, |
1088 | | gml_id character varying NOT NULL, |
1089 | | identifier character varying, |
1090 | | beginnt character(20), |
1091 | | endet character(20), |
1092 | | advstandardmodell character varying[], |
1093 | | sonstigesmodell character varying[], |
1094 | | anlass character varying, |
1095 | | uri character varying, -- wirklich? |
1096 | | fortfuehrungsfallnummernbereich character varying, |
1097 | | land character varying, |
1098 | | gemarkungsnummer character varying, |
1099 | | laufendenummer integer, |
1100 | | titel character varying, |
1101 | | erstelltam character varying, -- Datum jjjj-mm-tt |
1102 | | fortfuehrungsentscheidungam character varying, |
1103 | | fortfuehrungsentscheidungvon character varying, -- Bearbeiter-Name und -Titel |
1104 | | bemerkung character varying, |
1105 | | -- Beziehungen: |
1106 | | beziehtsichauf character varying, -- Index drauf? |
1107 | | CONSTRAINT ax_fortfuehrungsnachweisdeckblatt_pk PRIMARY KEY (ogc_fid) |
| 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) |
1119 | | ogc_fid serial NOT NULL, |
1120 | | gml_id character varying NOT NULL, |
1121 | | identifier character varying, |
1122 | | beginnt character(20), |
1123 | | endet character(20), |
1124 | | advstandardmodell character varying[], |
1125 | | sonstigesmodell character varying[], |
1126 | | anlass character varying, |
1127 | | uri character varying, |
1128 | | fortfuehrungsfallnummer integer, |
1129 | | laufendenummer integer, |
1130 | | ueberschriftimfortfuehrungsnachweis integer[], |
1131 | | anzahlderfortfuehrungsmitteilungen integer, |
1132 | | -- Beziehungen: |
1133 | | zeigtaufaltesflurstueck character varying[], -- Format wie flurstueckskennzeichen (20) als Array |
1134 | | zeigtaufneuesflurstueck character varying[], -- Format wie flurstueckskennzeichen (20) als Array |
1135 | | bemerkung character varying, |
1136 | | CONSTRAINT ax_fortfuehrungsfall_pk PRIMARY KEY (ogc_fid) |
| 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) |
1150 | | ogc_fid serial NOT NULL, |
1151 | | gml_id character varying NOT NULL, |
1152 | | identifier character varying, |
1153 | | beginnt character(20), |
1154 | | endet character(20), |
1155 | | advstandardmodell character varying[], |
1156 | | sonstigesmodell character varying[], |
1157 | | anlass character varying, |
1158 | | art integer, |
1159 | | nummer character varying, |
1160 | | land character varying, |
1161 | | stelle character varying, |
1162 | | ablaufderreservierung character varying, |
1163 | | antragsnummer character varying, |
1164 | | auftragsnummer character varying, |
1165 | | CONSTRAINT ax_reservierung_pk PRIMARY KEY (ogc_fid) |
| 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) |
1205 | | ogc_fid serial NOT NULL, |
1206 | | gml_id character varying NOT NULL, |
1207 | | identifier character varying, |
1208 | | beginnt character(20), |
1209 | | endet character(20), |
1210 | | advstandardmodell character varying[], |
1211 | | sonstigesmodell character varying[], |
1212 | | anlass character varying, |
1213 | | art character varying[], |
1214 | | name character varying[], |
1215 | | |
1216 | | -- GID: AX_Flurstueck_Kerndaten |
1217 | | -- 'FlurstÌck_Kerndaten' enthÀlt Eigenschaften des FlurstÌcks, die auch fÌr andere FlurstÌcksobjektarten gelten (z.B. Historisches FlurstÌck). |
1218 | | land character varying, -- |
1219 | | gemarkungsnummer character varying, -- |
1220 | | flurnummer integer, -- Teile des FlurstÃŒckskennzeichens |
1221 | | zaehler integer, -- (redundant zu flurstueckskennzeichen) |
1222 | | nenner integer, -- |
1223 | | -- daraus abgeleitet: |
1224 | | flurstueckskennzeichen character(20), -- Inhalt rechts mit __ auf 20 aufgefÃŒllt |
1225 | | amtlicheflaeche double precision, -- AFL |
1226 | | abweichenderrechtszustand character varying DEFAULT 'false', -- ARZ |
| 1208 | 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 |
1228 | | rechtsbehelfsverfahren character varying DEFAULT 'false', -- RBV |
1229 | | zeitpunktderentstehung character(10), -- ZDE Inhalt jjjj-mm-tt besser Format date ? |
1230 | | zeitpunktderhistorisierung character varying, -- oder (10) ? |
1231 | | gemeinde character varying, |
1232 | | -- GID: ENDE AX_Flurstueck_Kerndaten |
1233 | | |
1234 | | regierungsbezirk character varying, |
1235 | | kreis character varying, |
1236 | | vorgaengerflurstueckskennzeichen character varying[], |
1237 | | nachfolgerflurstueckskennzeichen character varying[], |
1238 | | blattart integer, |
1239 | | buchungsart character varying, |
1240 | | buchungsblattkennzeichen character varying[], |
1241 | | bezirk character varying, |
1242 | | buchungsblattnummermitbuchstabenerweiterung character varying[], |
1243 | | laufendenummerderbuchungsstelle integer, |
1244 | | CONSTRAINT ax_historischesflurstueck_pk PRIMARY KEY (ogc_fid) |
| 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) |
1296 | | ogc_fid serial NOT NULL, |
1297 | | gml_id character varying NOT NULL, |
1298 | | identifier character varying, |
1299 | | beginnt character(20), |
1300 | | endet character(20), |
1301 | | advstandardmodell character varying[], |
1302 | | sonstigesmodell character varying[], |
1303 | | anlass character varying, |
1304 | | name character varying[], |
1305 | | |
1306 | | -- GID: AX_Flurstueck_Kerndaten |
1307 | | -- 'FlurstÌck_Kerndaten' enthÀlt Eigenschaften des FlurstÌcks, die auch fÌr andere FlurstÌcksobjektarten gelten (z.B. Historisches FlurstÌck). |
1308 | | land character varying, -- |
1309 | | gemarkungsnummer character varying, -- |
1310 | | flurnummer integer, -- Teile des FlurstÃŒckskennzeichens |
1311 | | zaehler integer, -- (redundant zu flurstueckskennzeichen) |
1312 | | nenner integer, -- |
1313 | | flurstuecksfolge character varying, |
1314 | | -- daraus abgeleitet: |
1315 | | flurstueckskennzeichen character(20), -- Inhalt rechts mit __ auf 20 aufgefÃŒllt |
1316 | | |
1317 | | amtlicheflaeche double precision, -- AFL |
1318 | | abweichenderrechtszustand character varying DEFAULT 'false', -- ARZ |
1319 | | zweifelhafterFlurstuecksnachweis character varying DEFAULT 'false', -- ZFM Boolean |
1320 | | rechtsbehelfsverfahren character varying DEFAULT 'false', -- RBV |
1321 | | zeitpunktderentstehung character(10), -- ZDE jjjj-mm-tt |
1322 | | gemeinde character varying, |
1323 | | -- GID: ENDE AX_Flurstueck_Kerndaten |
1324 | | |
1325 | | blattart integer, |
1326 | | buchungsart character varying[], |
1327 | | buchungsblattkennzeichen character varying[], |
1328 | | bezirk character varying, |
1329 | | buchungsblattnummermitbuchstabenerweiterung character varying[], |
1330 | | laufendenummerderbuchungsstelle character varying[], |
1331 | | zeitpunktderentstehungdesbezugsflurstuecks character varying, |
1332 | | laufendenummerderfortfuehrung character varying, |
1333 | | fortfuehrungsart character varying, |
1334 | | vorgaengerflurstueckskennzeichen character varying[], |
1335 | | nachfolgerflurstueckskennzeichen character varying[], |
1336 | | CONSTRAINT ax_historischesflurstueckalb_pk PRIMARY KEY (ogc_fid) |
| 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) |
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) |
1478 | | ogc_fid serial NOT NULL, |
1479 | | gml_id character varying NOT NULL, |
1480 | | identifier character varying, |
1481 | | beginnt character(20), |
1482 | | endet character(20), |
1483 | | advstandardmodell character varying[], |
1484 | | sonstigesmodell character varying[], |
1485 | | anlass character varying, |
1486 | | nachnameoderfirma character varying, |
1487 | | anrede integer, |
1488 | | vorname character varying, |
1489 | | geburtsname character varying, |
1490 | | geburtsdatum character varying, |
1491 | | namensbestandteil character varying, |
1492 | | akademischergrad character varying, |
1493 | | -- Beziehungen: |
1494 | | hat character varying[], -- -> ax_anschrift |
1495 | | -- weistauf character varying[], -- <- ax_namensnummer |
1496 | | wirdvertretenvon character varying[], -- -> ax_vertretung |
1497 | | gehoertzu character varying[], -- -> ax_personengruppe |
1498 | | -- uebtaus character varying[], -- <- ax_vertretung |
1499 | | -- besitzt character varying[], -- <- ax_gebaeude |
1500 | | -- zeigtauf character varying, -- <- ax_person |
1501 | | -- benennt character varying[], -- <- ax_verwaltung |
1502 | | CONSTRAINT ax_person_pk PRIMARY KEY (ogc_fid) |
| 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) |
1552 | | ogc_fid serial NOT NULL, |
1553 | | gml_id character varying NOT NULL, |
1554 | | identifier character varying, |
1555 | | beginnt character(20), |
1556 | | endet character(20), |
1557 | | advstandardmodell character varying[], |
1558 | | sonstigesmodell character varying[], |
1559 | | anlass character varying, |
1560 | | ort_post character varying, |
1561 | | postleitzahlpostzustellung character varying, |
1562 | | strasse character varying, |
1563 | | hausnummer character varying, |
1564 | | bestimmungsland character varying, |
1565 | | postleitzahlpostfach character varying, |
1566 | | postfach character varying, |
1567 | | ortsteil character varying, |
1568 | | weitereAdressen character varying[], |
1569 | | telefon character varying, |
1570 | | fax character varying, |
1571 | | organisationname character varying, |
1572 | | -- Beziehungen: |
1573 | | -- beziehtsichauf character varying[], -- <- ax_dienststelle |
1574 | | -- gehoertzu character varying[], -- <- ax_person |
1575 | | CONSTRAINT ax_anschrift_pk PRIMARY KEY (ogc_fid) |
| 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) |
1598 | | ogc_fid serial NOT NULL, |
1599 | | gml_id character varying NOT NULL, |
1600 | | identifier character varying, |
1601 | | beginnt character(20), |
1602 | | endet character(20), |
1603 | | advstandardmodell character varying[], |
1604 | | sonstigesmodell character varying[], |
1605 | | anlass character varying, |
1606 | | -- Beziehungen: |
1607 | | -- beziehtsichauf character varying[], -- <- ax_buchungsstelle |
1608 | | haengtan character varying, -- -> ax_person |
1609 | | CONSTRAINT ax_verwaltung_pk PRIMARY KEY (ogc_fid) |
| 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) |
1628 | | ogc_fid serial NOT NULL, |
1629 | | gml_id character varying NOT NULL, |
1630 | | identifier character varying, |
1631 | | beginnt character(20), |
1632 | | endet character(20), |
1633 | | advstandardmodell character varying[], |
1634 | | sonstigesmodell character varying[], |
1635 | | anlass character varying, |
1636 | | -- Beziehungen: |
1637 | | -- vertritt character varying[], -- <- ax_person |
1638 | | haengtan character varying, --> ax_person |
1639 | | beziehtsichauf character varying[], --> ax_flurstueck |
1640 | | CONSTRAINT ax_vertretung_pk PRIMARY KEY (ogc_fid) |
| 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) |
1659 | | ogc_fid serial NOT NULL, |
1660 | | gml_id character varying NOT NULL, |
1661 | | identifier character varying, |
1662 | | beginnt character(20), |
1663 | | endet character(20), |
1664 | | advstandardmodell character varying[], |
1665 | | sonstigesmodell character varying[], |
1666 | | anlass character varying, |
1667 | | laufendenummernachdin1421 character(16), -- 0000.00.00.00.00 |
1668 | | zaehler double precision, -- Anteil .. |
1669 | | nenner double precision, -- .. als Bruch |
1670 | | eigentuemerart integer, |
1671 | | nummer character varying, -- immer leer ? |
1672 | | artderrechtsgemeinschaft integer, -- SchlÃŒssel |
1673 | | beschriebderrechtsgemeinschaft character varying, |
1674 | | -- Beziehungen: |
1675 | | bestehtausrechtsverhaeltnissenzu character varying, -- -> ax_namensnummer |
1676 | | istbestandteilvon character varying, -- -> ax_buchungsblatt |
1677 | | hatvorgaenger character varying[], -- -> ax_namensnummer |
1678 | | benennt character varying, -- -> ax_person |
1679 | | CONSTRAINT ax_namensnummer_pk PRIMARY KEY (ogc_fid) |
| 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) |
1705 | | ogc_fid serial NOT NULL, |
1706 | | gml_id character varying NOT NULL, |
1707 | | identifier character varying, |
1708 | | beginnt character(20), |
1709 | | endet character(20), |
1710 | | advstandardmodell character varying[], |
1711 | | sonstigesmodell character varying[], |
1712 | | anlass character varying, |
1713 | | buchungsblattkennzeichen character varying, |
1714 | | land character varying, |
1715 | | bezirk character varying, |
1716 | | buchungsblattnummermitbuchstabenerweiterung character varying, |
1717 | | blattart character varying, -- bisher integer, |
1718 | | art character varying, |
1719 | | -- Beziehungen: |
1720 | | -- bestehtaus character varying[], -- <- ax_buchungsstelle |
1721 | | CONSTRAINT ax_buchungsblatt_pk PRIMARY KEY (ogc_fid) |
| 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) |
1742 | | ogc_fid serial NOT NULL, |
1743 | | gml_id character varying NOT NULL, |
1744 | | identifier character varying, |
1745 | | beginnt character(20), |
1746 | | endet character(20), |
1747 | | advstandardmodell character varying[], |
1748 | | sonstigesmodell character varying[], |
1749 | | anlass character varying, |
1750 | | buchungsart integer, |
1751 | | laufendenummer character varying, |
1752 | | beschreibungdesumfangsderbuchung character(1), |
1753 | | zaehler double precision, |
1754 | | nenner double precision, |
1755 | | nummerimaufteilungsplan character varying, |
1756 | | beschreibungdessondereigentums character varying, |
1757 | | buchungstext character varying, |
1758 | | -- Beziehungen: |
1759 | | istbestandteilvon character varying, -- -> ax_buchungsblatt |
1760 | | durch character varying[], -- -> ax_buchungsstelle |
1761 | | verweistauf character varying[], -- -> ax_flurstueck |
1762 | | -- grundstueckbestehtaus character varying[], -- <- ax_flurstueck |
1763 | | zu character varying[], -- -> ax_buchungsstelle |
1764 | | an character varying[], -- -> ax_buchungsstelle |
1765 | | hatvorgaenger character varying[], -- -> ax_buchungsstelle |
1766 | | wirdverwaltetvon character varying, -- -> ax_verwaltung |
1767 | | beziehtsichauf character varying[], -- -> ax_buchungsblatt |
1768 | | CONSTRAINT ax_buchungsstelle_pk PRIMARY 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) |
1813 | | ogc_fid serial NOT NULL, |
1814 | | gml_id character varying NOT NULL, |
1815 | | identifier character varying, |
1816 | | beginnt character(20), |
1817 | | endet character(20), |
1818 | | advstandardmodell character varying[], |
1819 | | sonstigesmodell character varying[], |
1820 | | anlass character varying, |
1821 | | gebaeudefunktion integer, -- Werte siehe SchlÃŒsseltabelle |
1822 | | weiteregebaeudefunktion integer[], |
1823 | | name character varying[], |
1824 | | bauweise integer, |
1825 | | anzahlderoberirdischengeschosse integer, |
1826 | | anzahlderunterirdischengeschosse integer, |
1827 | | hochhaus character varying, -- "true"/"false", meist leer |
1828 | | objekthoehe double precision, |
1829 | | dachform integer, |
1830 | | zustand integer, |
1831 | | geschossflaeche integer, |
1832 | | grundflaeche integer, |
1833 | | umbauterraum integer, |
1834 | | baujahr integer, |
1835 | | lagezurerdoberflaeche integer, |
1836 | | dachart character varying, |
1837 | | dachgeschossausbau integer, |
1838 | | qualitaetsangaben character varying, |
1839 | | ax_datenerhebung integer, |
1840 | | description integer, |
1841 | | art character varying, |
1842 | | individualname character varying, |
1843 | | -- Beziehungen: |
1844 | | gehoertzu character varying, -- -> ax_gebaeude |
1845 | | hat character varying, -- -> ax_lagebezeichnungmitpseudonummer |
1846 | | gehoert character varying[], -- -> ax_person |
1847 | | zeigtauf character varying[], -- -> ax_lagebezeichnungmithausnummer |
1848 | | -- haengtzusammenmit character varying, -- <- ax_gebaeude |
1849 | | CONSTRAINT ax_gebaeude_pk PRIMARY KEY (ogc_fid) |
| 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) |
1897 | | ogc_fid serial NOT NULL, |
1898 | | gml_id character varying NOT NULL, |
1899 | | identifier character varying, |
1900 | | beginnt character(20), |
1901 | | endet character(20), |
1902 | | advstandardmodell character varying[], |
1903 | | sonstigesmodell character varying[], |
1904 | | anlass character varying, |
1905 | | bauart integer, |
1906 | | dachform integer, |
1907 | | anzahlderoberirdischengeschosse integer, |
1908 | | anzahlderunterirdischengeschosse integer, |
1909 | | lagezurerdoberflaeche integer, |
1910 | | CONSTRAINT ax_bauteil_pk PRIMARY KEY (ogc_fid) |
| 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) |
1980 | | ogc_fid serial NOT NULL, |
1981 | | gml_id character varying NOT NULL, |
1982 | | identifier character varying, |
1983 | | beginnt character(20), |
1984 | | endet character(20), |
1985 | | advstandardmodell character varying[], |
1986 | | sonstigesmodell character varying[], |
1987 | | anlass character varying, |
1988 | | land character varying, |
1989 | | stelle character varying, |
1990 | | punktkennung character varying, |
1991 | | art character varying, |
1992 | | name character varying[], |
1993 | | sonstigeeigenschaft character varying[], |
1994 | | CONSTRAINT ax_besonderergebaeudepunkt_pk PRIMARY KEY (ogc_fid) |
| 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) |
2313 | | ogc_fid serial NOT NULL, |
2314 | | gml_id character varying NOT NULL, |
2315 | | identifier character varying, |
2316 | | beginnt character(20), |
2317 | | endet character(20), |
2318 | | advstandardmodell character varying[], |
2319 | | sonstigesmodell character varying[], |
2320 | | anlass character varying, |
2321 | | funktion integer, |
2322 | | name character varying, |
2323 | | zweitname character varying, |
2324 | | zustand integer, |
2325 | | land character varying, |
2326 | | regierungsbezirk character varying, |
2327 | | kreis character varying, |
2328 | | gemeinde character varying, |
2329 | | lage character varying, |
2330 | | unverschluesselt character varying, |
2331 | | CONSTRAINT ax_strassenverkehr_pk PRIMARY KEY (ogc_fid) |
| 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) |
2351 | | ogc_fid serial NOT NULL, |
2352 | | gml_id character varying NOT NULL, |
2353 | | identifier character varying, |
2354 | | beginnt character(20), |
2355 | | endet character(20), |
2356 | | advstandardmodell character varying[], |
2357 | | sonstigesmodell character varying[], |
2358 | | anlass character varying, |
2359 | | funktion integer, |
2360 | | name character varying, |
2361 | | bezeichnung character varying, |
2362 | | land character varying, |
2363 | | regierungsbezirk character varying, |
2364 | | kreis character varying, |
2365 | | gemeinde character varying, |
2366 | | lage character varying, |
2367 | | unverschluesselt character varying, |
2368 | | CONSTRAINT ax_weg_pk PRIMARY KEY (ogc_fid) |
| 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) |
2387 | | ogc_fid serial NOT NULL, |
2388 | | gml_id character varying NOT NULL, |
2389 | | identifier character varying, |
2390 | | beginnt character(20), |
2391 | | endet character(20), |
2392 | | advstandardmodell character varying[], |
2393 | | sonstigesmodell character varying[], |
2394 | | anlass character varying, |
2395 | | funktion integer, |
2396 | | name character varying, |
2397 | | zweitname character varying, |
2398 | | land character varying, |
2399 | | regierungsbezirk character varying, |
2400 | | kreis character varying, |
2401 | | gemeinde character varying, |
2402 | | lage character varying, -- StraÃenschlÃŒssel |
2403 | | unverschluesselt character varying, -- Gewanne? |
2404 | | CONSTRAINT ax_platz_pk PRIMARY KEY (ogc_fid) |
| 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) |
2423 | | ogc_fid serial NOT NULL, |
2424 | | gml_id character varying NOT NULL, |
2425 | | identifier character varying, |
2426 | | beginnt character(20), |
2427 | | endet character(20), |
2428 | | advstandardmodell character varying[], |
2429 | | sonstigesmodell character varying[], |
2430 | | anlass character varying, |
2431 | | funktion integer, |
2432 | | bahnkategorie integer, |
2433 | | bezeichnung character varying, |
2434 | | nummerderbahnstrecke character varying, |
2435 | | zweitname character varying, |
2436 | | zustand integer, |
2437 | | CONSTRAINT ax_bahnverkehr_pk PRIMARY KEY (ogc_fid) |
| 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) |
2560 | | ogc_fid serial NOT NULL, |
2561 | | gml_id character varying NOT NULL, |
2562 | | identifier character varying, |
2563 | | beginnt character(20), |
2564 | | endet character(20), |
2565 | | advstandardmodell character varying[], |
2566 | | sonstigesmodell character varying[], |
2567 | | anlass character varying, |
2568 | | vegetationsmerkmal integer, |
2569 | | name character varying, |
2570 | | bezeichnung character varying, |
2571 | | CONSTRAINT ax_wald_pk PRIMARY KEY (ogc_fid) |
| 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) |
2799 | | ogc_fid serial NOT NULL, |
2800 | | gml_id character varying NOT NULL, |
2801 | | identifier character varying, |
2802 | | beginnt character(20), |
2803 | | endet character(20), |
2804 | | advstandardmodell character varying[], |
2805 | | sonstigesmodell character varying[], |
2806 | | anlass character varying, |
2807 | | funktion integer, |
2808 | | name character varying, |
2809 | | gewaesserkennziffer character varying, |
2810 | | hydrologischesMerkmal integer, |
2811 | | unverschluesselt character varying, |
2812 | | CONSTRAINT ax_stehendesgewaesser_pk PRIMARY KEY (ogc_fid) |
| 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) |
2873 | | ogc_fid serial NOT NULL, |
2874 | | gml_id character varying NOT NULL, |
2875 | | identifier character varying, |
2876 | | beginnt character(20), |
2877 | | endet character(20), |
2878 | | advstandardmodell character varying[], |
2879 | | sonstigesmodell character varying[], |
2880 | | anlass character varying, |
2881 | | bauwerksfunktion integer, |
2882 | | zustand integer, |
2883 | | name character varying, |
2884 | | -- Beziehungen: |
2885 | | zeigtauf character varying, --> ax_lagebezeichnungmithausnummer |
2886 | | CONSTRAINT ax_turm_pk PRIMARY KEY (ogc_fid) |
| 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) |
2906 | | ogc_fid serial NOT NULL, |
2907 | | gml_id character varying NOT NULL, |
2908 | | identifier character varying, |
2909 | | beginnt character(20), |
2910 | | endet character(20), |
2911 | | advstandardmodell character varying[], |
2912 | | sonstigesmodell character varying[], |
2913 | | anlass character varying, |
2914 | | bauwerksfunktion integer, |
2915 | | name character varying, |
2916 | | zustand integer, |
2917 | | objekthoehe double precision, |
2918 | | CONSTRAINT ax_bauwerkoderanlagefuerindustrieundgewerbe_pk PRIMARY KEY (ogc_fid) |
| 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) |
2934 | | ogc_fid serial NOT NULL, |
2935 | | gml_id character varying NOT NULL, |
2936 | | identifier character varying, |
2937 | | beginnt character(20), |
2938 | | endet character(20), |
2939 | | advstandardmodell character varying[], |
2940 | | sonstigesmodell character varying[], |
2941 | | anlass character varying, |
2942 | | speicherinhalt integer, |
2943 | | bauwerksfunktion integer, |
2944 | | lagezurerdoberflaeche integer, |
2945 | | name character varying, |
2946 | | CONSTRAINT ax_vorratsbehaelterspeicherbauwerk_pk PRIMARY KEY (ogc_fid) |
| 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) |
2962 | | ogc_fid serial NOT NULL, |
2963 | | gml_id character varying NOT NULL, |
2964 | | identifier character varying, |
2965 | | beginnt character(20), |
2966 | | endet character(20), |
2967 | | advstandardmodell character varying[], |
2968 | | sonstigesmodell character varying[], |
2969 | | anlass character varying, |
2970 | | bauwerksfunktion integer, |
2971 | | lagezurerdoberflaeche integer, |
2972 | | art character varying, |
2973 | | name character varying, |
2974 | | produkt integer, |
2975 | | CONSTRAINT ax_transportanlage_pk PRIMARY KEY (ogc_fid) |
| 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) |
3096 | | ogc_fid serial NOT NULL, |
3097 | | gml_id character varying NOT NULL, |
3098 | | identifier character varying, |
3099 | | beginnt character(20), |
3100 | | endet character(20), |
3101 | | advstandardmodell character varying[], |
3102 | | sonstigesmodell character varying[], |
3103 | | anlass character varying, |
3104 | | description integer, |
3105 | | name character varying, |
3106 | | bauwerksfunktion integer, |
3107 | | funktion integer, |
3108 | | -- Beziehungen: |
3109 | | gehoertzubauwerk character varying, --> ax_bauwerkeeinrichtungenundsonstigeangaben |
3110 | | gehoertzu character varying, --> ax_gebaeude |
3111 | | CONSTRAINT ax_sonstigesbauwerkodersonstigeeinrichtung_pk PRIMARY KEY (ogc_fid) |
| 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) |
3159 | | ogc_fid serial NOT NULL, |
3160 | | gml_id character varying NOT NULL, |
3161 | | identifier character varying, |
3162 | | beginnt character(20), |
3163 | | endet character(20), |
3164 | | advstandardmodell character varying[], |
3165 | | sonstigesmodell character varying[], |
3166 | | anlass character varying, |
3167 | | punktkennung character varying, |
3168 | | land character varying, |
3169 | | stelle character varying, |
3170 | | sonstigeeigenschaft character varying[], |
3171 | | CONSTRAINT ax_besondererbauwerkspunkt_pk PRIMARY KEY (ogc_fid) |
| 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) |
3495 | | ogc_fid serial NOT NULL, |
3496 | | gml_id character varying NOT NULL, |
3497 | | identifier character varying, |
3498 | | beginnt character(20), |
3499 | | endet character(20), |
3500 | | advstandardmodell character varying[], |
3501 | | sonstigesmodell character varying[], |
3502 | | anlass character varying, |
3503 | | funktion integer, |
3504 | | lagezurerdoberflaeche integer, |
3505 | | hydrologischesmerkmal integer, |
3506 | | name character varying, |
3507 | | CONSTRAINT ax_untergeordnetesgewaesser_pk PRIMARY KEY (ogc_fid) |
| 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) |
3777 | | ogc_fid serial NOT NULL, |
3778 | | gml_id character varying NOT NULL, |
3779 | | identifier character varying, |
3780 | | beginnt character(20), |
3781 | | endet character(20), |
3782 | | advstandardmodell character varying[], |
3783 | | sonstigesmodell character varying[], |
3784 | | anlass character varying, |
3785 | | land character varying, |
3786 | | stelle character varying, |
3787 | | punktkennung character varying, |
3788 | | sonstigeeigenschaft character varying[], |
3789 | | CONSTRAINT ax_besonderertopographischerpunkt_pk PRIMARY KEY (ogc_fid) |
| 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) |
3836 | | ogc_fid serial NOT NULL, |
3837 | | gml_id character varying NOT NULL, |
3838 | | identifier character varying, |
3839 | | beginnt character(20), |
3840 | | endet character(20), |
3841 | | advstandardmodell character varying[], |
3842 | | sonstigesmodell character varying[], |
3843 | | anlass character varying, |
3844 | | artdergelaendekante integer, |
3845 | | ax_dqerfassungsmethode integer, |
3846 | | identifikation integer, |
3847 | | art integer, |
3848 | | -- Beziehungen: |
3849 | | istteilvon character varying, |
3850 | | CONSTRAINT ax_gelaendekante_pk PRIMARY KEY (ogc_fid) |
| 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) |
3916 | | ogc_fid serial NOT NULL, |
3917 | | gml_id character varying NOT NULL, |
3918 | | identifier character varying, |
3919 | | beginnt character(20), |
3920 | | endet character(20), |
3921 | | advstandardmodell character varying[], |
3922 | | sonstigesmodell character varying[], |
3923 | | anlass character varying, |
3924 | | artderfestlegung integer, |
3925 | | land character varying, |
3926 | | stelle character varying, |
3927 | | bezeichnung character varying, |
3928 | | CONSTRAINT ax_klassifizierungnachstrassenrecht_pk PRIMARY KEY (ogc_fid) |
| 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) |
3950 | | ogc_fid serial NOT NULL, |
3951 | | gml_id character varying NOT NULL, |
3952 | | identifier character varying, |
3953 | | beginnt character(20), |
3954 | | endet character(20), |
3955 | | advstandardmodell character varying[], |
3956 | | sonstigesmodell character varying[], |
3957 | | anlass character varying, |
3958 | | artderfestlegung integer, |
3959 | | land character varying, |
3960 | | stelle character varying, |
3961 | | CONSTRAINT ax_klassifizierungnachwasserrecht_pk PRIMARY KEY (ogc_fid) |
| 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) |
3977 | | ogc_fid serial NOT NULL, |
3978 | | gml_id character varying NOT NULL, |
3979 | | identifier character varying, |
3980 | | beginnt character(20), |
3981 | | endet character(20), |
3982 | | advstandardmodell character varying[], |
3983 | | sonstigesmodell character varying[], |
3984 | | anlass character varying, |
3985 | | artderfestlegung integer, |
3986 | | land character varying, |
3987 | | stelle character varying, |
3988 | | CONSTRAINT ax_anderefestlegungnachwasserrecht_pk PRIMARY KEY (ogc_fid) |
| 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) |
4005 | | ogc_fid serial NOT NULL, |
4006 | | gml_id character varying NOT NULL, |
4007 | | identifier character varying, |
4008 | | beginnt character(20), |
4009 | | endet character(20), |
4010 | | advstandardmodell character varying[], |
4011 | | sonstigesmodell character varying[], |
4012 | | anlass character varying, |
4013 | | artderfestlegung integer, |
4014 | | land character varying, |
4015 | | stelle character varying, |
4016 | | art character varying[], |
4017 | | name character varying[], |
4018 | | nummerdesschutzgebietes character varying, |
4019 | | CONSTRAINT ax_schutzgebietnachwasserrecht_pk PRIMARY KEY (ogc_fid) |
| 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) |
4035 | | ogc_fid serial NOT NULL, |
4036 | | gml_id character varying NOT NULL, |
4037 | | identifier character varying, |
4038 | | beginnt character(20), |
4039 | | endet character(20), |
4040 | | advstandardmodell character varying[], |
4041 | | sonstigesmodell character varying[], |
4042 | | anlass character varying, |
4043 | | artderfestlegung integer, |
4044 | | land character varying, |
4045 | | stelle character varying, |
4046 | | name character varying, |
4047 | | CONSTRAINT ax_naturumweltoderbodenschutzrecht_pk PRIMARY KEY (ogc_fid) |
| 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) |
4064 | | ogc_fid serial NOT NULL, |
4065 | | gml_id character varying NOT NULL, |
4066 | | identifier character varying, |
4067 | | beginnt character(20), |
4068 | | endet character(20), |
4069 | | advstandardmodell character varying[], |
4070 | | sonstigesmodell character varying[], |
4071 | | anlass character varying, |
4072 | | artderfestlegung integer, |
4073 | | land character varying, |
4074 | | stelle character varying, |
4075 | | name character varying, |
4076 | | CONSTRAINT ax_schutzgebietnachnaturumweltoderbodenschutzrecht_pk PRIMARY KEY (ogc_fid) |
| 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) |
4092 | | ogc_fid serial NOT NULL, |
4093 | | gml_id character varying NOT NULL, |
4094 | | identifier character varying, |
4095 | | beginnt character(20), |
4096 | | endet character(20), |
4097 | | advstandardmodell character varying[], |
4098 | | sonstigesmodell character varying[], |
4099 | | anlass character varying, |
4100 | | art character varying, |
4101 | | name character varying, |
4102 | | artderfestlegung integer, |
4103 | | land character varying, |
4104 | | stelle character varying, |
4105 | | bezeichnung character varying, |
4106 | | datumanordnung character varying, |
4107 | | CONSTRAINT ax_bauraumoderbodenordnungsrecht_pk PRIMARY KEY (ogc_fid) |
| 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) |
4125 | | ogc_fid serial NOT NULL, |
4126 | | gml_id character varying NOT NULL, |
4127 | | identifier character varying, |
4128 | | beginnt character(20), |
4129 | | endet character(20), |
4130 | | advstandardmodell character varying[], |
4131 | | sonstigesmodell character varying[], |
4132 | | anlass character varying, |
4133 | | artderfestlegung integer, |
4134 | | land character varying, |
4135 | | stelle character varying, |
4136 | | art character varying, |
4137 | | name character varying, |
4138 | | CONSTRAINT ax_denkmalschutzrecht_pk PRIMARY KEY (ogc_fid) |
| 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) |
4155 | | ogc_fid serial NOT NULL, |
4156 | | gml_id character varying NOT NULL, |
4157 | | identifier character varying, |
4158 | | beginnt character(20), |
4159 | | endet character(20), |
4160 | | advstandardmodell character varying[], |
4161 | | sonstigesmodell character varying[], |
4162 | | anlass character varying, |
4163 | | artderfestlegung integer, |
4164 | | besonderefunktion integer, |
4165 | | land character varying, |
4166 | | stelle character varying, |
4167 | | CONSTRAINT ax_forstrecht_pk PRIMARY KEY (ogc_fid) |
| 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) |
4184 | | ogc_fid serial NOT NULL, |
4185 | | gml_id character varying NOT NULL, |
4186 | | identifier character varying, |
4187 | | beginnt character(20), |
4188 | | endet character(20), |
4189 | | advstandardmodell character varying[], |
4190 | | sonstigesmodell character varying[], |
4191 | | anlass character varying, |
4192 | | artderfestlegung integer, |
4193 | | land character varying, |
4194 | | stelle character varying, |
4195 | | bezeichnung character varying, |
4196 | | characterstring character varying, |
4197 | | art character varying, |
4198 | | name character varying, |
4199 | | funktion integer, |
4200 | | CONSTRAINT ax_sonstigesrecht_pk PRIMARY KEY (ogc_fid) |
| 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) |
4255 | | ogc_fid serial NOT NULL, |
4256 | | gml_id character varying NOT NULL, |
4257 | | identifier character varying, |
4258 | | beginnt character(20), |
4259 | | endet character(20), |
4260 | | advstandardmodell character varying[], |
4261 | | sonstigesmodell character varying[], |
4262 | | anlass character varying, |
4263 | | art character varying, |
4264 | | name character varying, |
4265 | | kulturart integer, |
4266 | | bodenart integer, |
4267 | | zustandsstufeoderbodenstufe integer, |
4268 | | entstehungsartoderklimastufewasserverhaeltnisse integer[], |
4269 | | bodenzahlodergruenlandgrundzahl integer, |
4270 | | ackerzahlodergruenlandzahl integer, |
4271 | | sonstigeangaben integer[], |
4272 | | jahreszahl integer, |
4273 | | CONSTRAINT ax_bodenschaetzung_pk PRIMARY KEY (ogc_fid) |
| 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) |
4298 | | ogc_fid serial NOT NULL, |
4299 | | gml_id character varying NOT NULL, |
4300 | | identifier character varying, |
4301 | | beginnt character(20), |
4302 | | endet character(20), |
4303 | | advstandardmodell character varying[], |
4304 | | sonstigesmodell character varying[], |
4305 | | anlass character varying, |
4306 | | art character varying, |
4307 | | name character varying, |
4308 | | merkmal integer, |
4309 | | nummer character varying, -- integer |
4310 | | kulturart integer, |
4311 | | bodenart integer, |
4312 | | zustandsstufeoderbodenstufe integer, |
4313 | | entstehungsartoderklimastufewasserverhaeltnisse integer, |
4314 | | bodenzahlodergruenlandgrundzahl character varying, -- integer |
4315 | | ackerzahlodergruenlandzahl character varying, -- integer |
4316 | | sonstigeangaben integer[], |
4317 | | CONSTRAINT ax_musterlandesmusterundvergleichsstueck_pk PRIMARY KEY (ogc_fid) |
| 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) |
4344 | | ogc_fid serial NOT NULL, |
4345 | | gml_id character varying NOT NULL, |
4346 | | identifier character varying, |
4347 | | beginnt character(20), |
4348 | | endet character(20), |
4349 | | advstandardmodell character varying[], |
4350 | | sonstigesmodell character varying[], |
4351 | | anlass character varying, |
4352 | | art character varying, |
4353 | | name character varying, |
4354 | | bedeutung integer[], |
4355 | | land character varying, |
4356 | | nummerierungsbezirk character varying, |
4357 | | gemarkungsnummer character varying, |
4358 | | nummerdesgrablochs character varying, |
4359 | | bodenzahlodergruenlandgrundzahl integer, |
4360 | | -- Beziehungen: |
4361 | | gehoertzu character varying, --> ax_tagesabschnitt |
4362 | | CONSTRAINT ax_grablochderbodenschaetzung_pk PRIMARY KEY (ogc_fid) |
| 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) |
4437 | | ogc_fid serial NOT NULL, |
4438 | | gml_id character varying NOT NULL, |
4439 | | identifier character varying, |
4440 | | beginnt character(20), |
4441 | | endet character(20), |
4442 | | advstandardmodell character varying[], |
4443 | | sonstigesmodell character varying[], |
4444 | | anlass character varying, |
4445 | | schluesselgesamt character varying, |
4446 | | bezeichnung character varying, |
4447 | | land character varying, |
4448 | | stelle character varying, |
4449 | | CONSTRAINT ax_bundesland_pk PRIMARY KEY (ogc_fid) |
| 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) |
4464 | | ogc_fid serial NOT NULL, |
4465 | | gml_id character varying NOT NULL, |
4466 | | identifier character varying, |
4467 | | beginnt character(20), |
4468 | | endet character(20), |
4469 | | advstandardmodell character varying[], |
4470 | | sonstigesmodell character varying[], |
4471 | | anlass character varying, |
4472 | | schluesselgesamt character varying, |
4473 | | bezeichnung character varying, |
4474 | | land character varying, |
4475 | | regierungsbezirk character varying, |
4476 | | CONSTRAINT ax_regierungsbezirk_pk PRIMARY KEY (ogc_fid) |
| 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) |
4491 | | ogc_fid serial NOT NULL, |
4492 | | gml_id character varying NOT NULL, |
4493 | | identifier character varying, |
4494 | | beginnt character(20), |
4495 | | endet character(20), |
4496 | | advstandardmodell character varying[], |
4497 | | sonstigesmodell character varying[], |
4498 | | anlass character varying, |
4499 | | schluesselgesamt character varying, |
4500 | | bezeichnung character varying, |
4501 | | land character varying, |
4502 | | regierungsbezirk character varying, |
4503 | | kreis character varying, |
4504 | | CONSTRAINT ax_kreisregion_pk PRIMARY KEY (ogc_fid) |
| 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) |
4519 | | ogc_fid serial NOT NULL, |
4520 | | gml_id character varying NOT NULL, |
4521 | | identifier character varying, |
4522 | | beginnt character(20), |
4523 | | endet character(20), |
4524 | | advstandardmodell character varying[], |
4525 | | sonstigesmodell character varying[], |
4526 | | anlass character varying, |
4527 | | schluesselgesamt character varying, |
4528 | | bezeichnung character varying, |
4529 | | land character varying, |
4530 | | regierungsbezirk character varying, |
4531 | | kreis character varying, |
4532 | | gemeinde character varying, |
4533 | | stelle character varying, |
4534 | | -- Beziehungen: |
4535 | | istamtsbezirkvon character varying[], --> ax_dienststelle |
4536 | | CONSTRAINT ax_gemeinde_pk PRIMARY KEY (ogc_fid) |
| 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) |
4554 | | ogc_fid serial NOT NULL, |
4555 | | gml_id character varying NOT NULL, |
4556 | | identifier character varying, |
4557 | | beginnt character(20), |
4558 | | endet character(20), |
4559 | | advstandardmodell character varying[], |
4560 | | sonstigesmodell character varying[], |
4561 | | anlass character varying, |
4562 | | schluesselgesamt character varying, |
4563 | | bezeichnung character varying, |
4564 | | administrativefunktion integer, |
4565 | | land character varying, |
4566 | | regierungsbezirk character varying, |
4567 | | kreis character varying, |
4568 | | gemeinde character varying, |
4569 | | gemeindeteil integer, |
4570 | | CONSTRAINT ax_gemeindeteil_pk PRIMARY KEY (ogc_fid) |
| 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) |
4585 | | ogc_fid serial NOT NULL, |
4586 | | gml_id character varying NOT NULL, |
4587 | | identifier character varying, |
4588 | | beginnt character(20), |
4589 | | endet character(20), |
4590 | | advstandardmodell character varying[], |
4591 | | sonstigesmodell character varying[], |
4592 | | anlass character varying, |
4593 | | schluesselgesamt character varying, |
4594 | | bezeichnung character varying, |
4595 | | land character varying, |
4596 | | gemarkungsnummer character varying, |
4597 | | stelle character varying, |
4598 | | CONSTRAINT ax_gemarkung_pk PRIMARY KEY (ogc_fid) |
| 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) |
4614 | | ogc_fid serial NOT NULL, |
4615 | | gml_id character varying NOT NULL, |
4616 | | identifier character varying, |
4617 | | beginnt character(20), |
4618 | | endet character(20), |
4619 | | advstandardmodell character varying[], |
4620 | | sonstigesmodell character varying[], |
4621 | | anlass character varying, |
4622 | | schluesselgesamt character varying, |
4623 | | bezeichnung character varying, |
4624 | | land character varying, |
4625 | | gemarkung integer, |
4626 | | gemarkungsteilflur integer, |
4627 | | CONSTRAINT ax_gemarkungsteilflur_pk PRIMARY KEY (ogc_fid) |
| 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) |
4642 | | ogc_fid serial NOT NULL, |
4643 | | gml_id character varying NOT NULL, |
4644 | | identifier character varying, |
4645 | | beginnt character(20), |
4646 | | endet character(20), |
4647 | | advstandardmodell character varying[], |
4648 | | sonstigesmodell character varying[], |
4649 | | anlass character varying, |
4650 | | schluesselgesamt character varying, |
4651 | | bezeichnung character varying, |
4652 | | bezeichnungart integer, |
4653 | | land character varying, |
4654 | | regierungsbezirk character varying, |
4655 | | kreis character varying, |
4656 | | verwaltungsgemeinschaft integer, |
4657 | | CONSTRAINT ax_verwaltungsgemeinschaft_pk PRIMARY KEY (ogc_fid) |
| 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) |
4676 | | ogc_fid serial NOT NULL, |
4677 | | gml_id character varying NOT NULL, |
4678 | | identifier character varying, |
4679 | | beginnt character(20), |
4680 | | endet character(20), |
4681 | | advstandardmodell character varying[], |
4682 | | sonstigesmodell character varying[], |
4683 | | anlass character varying, |
4684 | | schluesselgesamt character varying, |
4685 | | bezeichnung character varying, |
4686 | | land character varying, |
4687 | | bezirk character varying, |
4688 | | stelle character varying, |
4689 | | -- Beziehungen: |
4690 | | gehoertzu character varying, --> ax_dienststelle |
4691 | | CONSTRAINT ax_buchungsblattbezirk_pk PRIMARY KEY (ogc_fid) |
| 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) |
4710 | | ogc_fid serial NOT NULL, |
4711 | | gml_id character varying NOT NULL, |
4712 | | identifier character varying, |
4713 | | beginnt character(20), |
4714 | | endet character(20), |
4715 | | advstandardmodell character varying[], |
4716 | | sonstigesmodell character varying[], |
4717 | | anlass character varying, |
4718 | | schluesselgesamt character varying, |
4719 | | bezeichnung character varying, |
4720 | | land character varying, |
4721 | | stelle character varying, |
4722 | | stellenart integer, |
4723 | | kennung character varying, |
4724 | | -- Beziehungen: |
4725 | | hat character varying, --> ax_anschrift |
4726 | | CONSTRAINT ax_dienststelle_pk PRIMARY KEY (ogc_fid) |
| 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) |
4752 | | ogc_fid serial NOT NULL, |
4753 | | gml_id character varying NOT NULL, |
4754 | | identifier character varying, |
4755 | | beginnt character(20), |
4756 | | endet character(20), |
4757 | | advstandardmodell character varying[], |
4758 | | sonstigesmodell character varying[], |
4759 | | anlass character varying, |
4760 | | schluesselgesamt character varying, |
4761 | | bezeichnung character varying, |
4762 | | land character varying, |
4763 | | regierungsbezirk character varying, |
4764 | | kreis character varying, |
4765 | | gemeinde character varying, |
4766 | | lage character varying, -- StraÃenschlÃŒssel |
4767 | | CONSTRAINT ax_lagebezeichnungkatalogeintrag_pk PRIMARY KEY (ogc_fid) |
| 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) |
4911 | | ogc_fid serial NOT NULL, |
4912 | | gml_id character varying NOT NULL, |
4913 | | identifier character varying, |
4914 | | beginnt character(20), |
4915 | | endet character(20), |
4916 | | advstandardmodell character varying[], |
4917 | | sonstigesmodell character varying[], |
4918 | | anlass character varying, |
4919 | | schluesselgesamt character varying, |
4920 | | land character varying, |
4921 | | regierungsbezirk character varying, |
4922 | | kreis character varying, |
4923 | | gemeinde character varying, |
4924 | | gemeindeflaeche double precision, |
4925 | | CONSTRAINT ax_kommunalesgebiet_pk PRIMARY KEY (ogc_fid) |
| 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) |
5002 | | ogc_fid serial NOT NULL, |
5003 | | gml_id character varying NOT NULL, |
5004 | | identifier character varying, |
5005 | | beginnt character(20), |
5006 | | endet character(20), |
5007 | | advstandardmodell character varying[], |
5008 | | sonstigesmodell character varying[], |
5009 | | anlass character varying, |
5010 | | liniendarstellung integer, |
5011 | | sonstigeeigenschaft character varying, |
5012 | | CONSTRAINT ax_topographischelinie_pk PRIMARY KEY (ogc_fid) |
| 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) |