source: trunk/data/konvert/postnas_0.6/atkis_rp_PostNAS_0.6_schema.sql @ 100

Revision 100, 150.7 KB checked in by retterath, 13 years ago (diff)

Initiales Schema um ATKIS Daten aus Rheinland-Pfalz mittels PostNAS in eine PostGIS DB zu laden.

Line 
1--
2-- TOC entry 2670 (class 1259 OID 29899)
3-- Dependencies: 3
4-- Name: alkis_beziehungen; Type: TABLE; Schema: public; Owner: -
5--
6
7CREATE TABLE alkis_beziehungen (
8    ogc_fid integer NOT NULL,
9    beziehung_von character varying,
10    beziehungsart character varying,
11    beziehung_zu character varying
12);
13
14
15--
16-- TOC entry 2669 (class 1259 OID 29897)
17-- Dependencies: 2670 3
18-- Name: alkis_beziehungen_ogc_fid_seq; Type: SEQUENCE; Schema: public; Owner: -
19--
20
21CREATE SEQUENCE alkis_beziehungen_ogc_fid_seq
22    START WITH 1
23    INCREMENT BY 1
24    NO MAXVALUE
25    NO MINVALUE
26    CACHE 1;
27
28
29--
30-- TOC entry 3591 (class 0 OID 0)
31-- Dependencies: 2669
32-- Name: alkis_beziehungen_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
33--
34
35ALTER SEQUENCE alkis_beziehungen_ogc_fid_seq OWNED BY alkis_beziehungen.ogc_fid;
36
37
38--
39-- TOC entry 2672 (class 1259 OID 29911)
40-- Dependencies: 3132 3133 3134 3 1087
41-- Name: ax_abschnitt; Type: TABLE; Schema: public; Owner: -
42--
43
44CREATE TABLE ax_abschnitt (
45    ogc_fid integer NOT NULL,
46    wkb_geometry geometry,
47    gml_id character(16),
48    identifier character(28),
49    beginnt character(20),
50    advstandardmodell character(9),
51    art character(16),
52    name character(11),
53    bezeichnung character(200), --16
54    CONSTRAINT enforce_dims_wkb_geometry CHECK ((st_ndims(wkb_geometry) = 2)),
55    CONSTRAINT enforce_geotype_wkb_geometry CHECK (((geometrytype(wkb_geometry) = 'LINESTRING'::text) OR (wkb_geometry IS NULL))),
56    CONSTRAINT enforce_srid_wkb_geometry CHECK ((st_srid(wkb_geometry) = 25832))
57);
58
59
60--
61-- TOC entry 2671 (class 1259 OID 29909)
62-- Dependencies: 2672 3
63-- Name: ax_abschnitt_ogc_fid_seq; Type: SEQUENCE; Schema: public; Owner: -
64--
65
66CREATE SEQUENCE ax_abschnitt_ogc_fid_seq
67    START WITH 1
68    INCREMENT BY 1
69    NO MAXVALUE
70    NO MINVALUE
71    CACHE 1;
72
73
74--
75-- TOC entry 3592 (class 0 OID 0)
76-- Dependencies: 2671
77-- Name: ax_abschnitt_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
78--
79
80ALTER SEQUENCE ax_abschnitt_ogc_fid_seq OWNED BY ax_abschnitt.ogc_fid;
81
82
83--
84-- TOC entry 2674 (class 1259 OID 29927)
85-- Dependencies: 3136 3137 3138 1087 3
86-- Name: ax_ast; Type: TABLE; Schema: public; Owner: -
87--
88
89CREATE TABLE ax_ast (
90    ogc_fid integer NOT NULL,
91    wkb_geometry geometry,
92    gml_id character(16),
93    identifier character(28),
94    beginnt character(20),
95    advstandardmodell character(9),
96    art character(16),
97    name character(11),
98    istteilvon character varying,
99    bezeichnung character(200), --9
100    CONSTRAINT enforce_dims_wkb_geometry CHECK ((st_ndims(wkb_geometry) = 2)),
101    CONSTRAINT enforce_geotype_wkb_geometry CHECK (((geometrytype(wkb_geometry) = 'LINESTRING'::text) OR (wkb_geometry IS NULL))),
102    CONSTRAINT enforce_srid_wkb_geometry CHECK ((st_srid(wkb_geometry) = 25832))
103);
104
105
106--
107-- TOC entry 2673 (class 1259 OID 29925)
108-- Dependencies: 3 2674
109-- Name: ax_ast_ogc_fid_seq; Type: SEQUENCE; Schema: public; Owner: -
110--
111
112CREATE SEQUENCE ax_ast_ogc_fid_seq
113    START WITH 1
114    INCREMENT BY 1
115    NO MAXVALUE
116    NO MINVALUE
117    CACHE 1;
118
119
120--
121-- TOC entry 3593 (class 0 OID 0)
122-- Dependencies: 2673
123-- Name: ax_ast_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
124--
125
126ALTER SEQUENCE ax_ast_ogc_fid_seq OWNED BY ax_ast.ogc_fid;
127
128
129--
130-- TOC entry 2734 (class 1259 OID 30568)
131-- Dependencies: 3248 3249 3250 1087 3
132-- Name: ax_bahnstrecke; Type: TABLE; Schema: public; Owner: -
133--
134
135CREATE TABLE ax_bahnstrecke (
136    ogc_fid integer NOT NULL,
137    wkb_geometry geometry,
138    gml_id character(16),
139    identifier character(28),
140    beginnt character(20),
141    advstandardmodell character varying[],
142    art character(16),
143    name character(11),
144    hatdirektunten character varying,
145    bahnkategorie integer,
146    elektrifizierung integer,
147    anzahlderstreckengleise integer,
148    nummerderbahnstrecke integer,
149    spurweite integer,
150    CONSTRAINT enforce_dims_wkb_geometry CHECK ((st_ndims(wkb_geometry) = 2)),
151    CONSTRAINT enforce_geotype_wkb_geometry CHECK (((geometrytype(wkb_geometry) = 'LINESTRING'::text) OR (wkb_geometry IS NULL))),
152    CONSTRAINT enforce_srid_wkb_geometry CHECK ((st_srid(wkb_geometry) = 25832))
153);
154
155
156--
157-- TOC entry 2733 (class 1259 OID 30566)
158-- Dependencies: 3 2734
159-- Name: ax_bahnstrecke_ogc_fid_seq; Type: SEQUENCE; Schema: public; Owner: -
160--
161
162CREATE SEQUENCE ax_bahnstrecke_ogc_fid_seq
163    START WITH 1
164    INCREMENT BY 1
165    NO MAXVALUE
166    NO MINVALUE
167    CACHE 1;
168
169
170--
171-- TOC entry 3594 (class 0 OID 0)
172-- Dependencies: 2733
173-- Name: ax_bahnstrecke_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
174--
175
176ALTER SEQUENCE ax_bahnstrecke_ogc_fid_seq OWNED BY ax_bahnstrecke.ogc_fid;
177
178
179--
180-- TOC entry 2770 (class 1259 OID 33469)
181-- Dependencies: 3317 3318 3319 1087 3
182-- Name: ax_bahnverkehr; Type: TABLE; Schema: public; Owner: -
183--
184
185CREATE TABLE ax_bahnverkehr (
186    ogc_fid integer NOT NULL,
187    wkb_geometry geometry,
188    gml_id character(16),
189    identifier character(28),
190    beginnt character(20),
191    advstandardmodell character varying[],
192    CONSTRAINT enforce_dims_wkb_geometry CHECK ((st_ndims(wkb_geometry) = 2)),
193    CONSTRAINT enforce_geotype_wkb_geometry CHECK (((geometrytype(wkb_geometry) = 'POLYGON'::text) OR (wkb_geometry IS NULL))),
194    CONSTRAINT enforce_srid_wkb_geometry CHECK ((st_srid(wkb_geometry) = 25832))
195);
196
197
198--
199-- TOC entry 2769 (class 1259 OID 33467)
200-- Dependencies: 2770 3
201-- Name: ax_bahnverkehr_ogc_fid_seq; Type: SEQUENCE; Schema: public; Owner: -
202--
203
204CREATE SEQUENCE ax_bahnverkehr_ogc_fid_seq
205    START WITH 1
206    INCREMENT BY 1
207    NO MAXVALUE
208    NO MINVALUE
209    CACHE 1;
210
211
212--
213-- TOC entry 3595 (class 0 OID 0)
214-- Dependencies: 2769
215-- Name: ax_bahnverkehr_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
216--
217
218ALTER SEQUENCE ax_bahnverkehr_ogc_fid_seq OWNED BY ax_bahnverkehr.ogc_fid;
219
220
221--
222-- TOC entry 2732 (class 1259 OID 30552)
223-- Dependencies: 3244 3245 3246 3 1087
224-- Name: ax_bahnverkehrsanlage; Type: TABLE; Schema: public; Owner: -
225--
226
227CREATE TABLE ax_bahnverkehrsanlage (
228    ogc_fid integer NOT NULL,
229    wkb_geometry geometry,
230    gml_id character(16),
231    identifier character(28),
232    beginnt character(20),
233    advstandardmodell character varying[],
234    art character(16),
235    name character(11),
236    bahnhofskategorie integer,
237    name_ character(200), --15
238    CONSTRAINT enforce_dims_wkb_geometry CHECK ((st_ndims(wkb_geometry) = 2)),
239    --CONSTRAINT enforce_geotype_wkb_geometry CHECK (((geometrytype(wkb_geometry) = 'POINT'::text) OR (wkb_geometry IS NULL))),
240    CONSTRAINT enforce_srid_wkb_geometry CHECK ((st_srid(wkb_geometry) = 25832))
241);
242
243
244--
245-- TOC entry 2731 (class 1259 OID 30550)
246-- Dependencies: 2732 3
247-- Name: ax_bahnverkehrsanlage_ogc_fid_seq; Type: SEQUENCE; Schema: public; Owner: -
248--
249
250CREATE SEQUENCE ax_bahnverkehrsanlage_ogc_fid_seq
251    START WITH 1
252    INCREMENT BY 1
253    NO MAXVALUE
254    NO MINVALUE
255    CACHE 1;
256
257
258--
259-- TOC entry 3596 (class 0 OID 0)
260-- Dependencies: 2731
261-- Name: ax_bahnverkehrsanlage_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
262--
263
264ALTER SEQUENCE ax_bahnverkehrsanlage_ogc_fid_seq OWNED BY ax_bahnverkehrsanlage.ogc_fid;
265
266
267--
268-- TOC entry 2676 (class 1259 OID 29943)
269-- Dependencies: 3140 3141 3142 3 1087
270-- Name: ax_bauwerkimgewaesserbereich; Type: TABLE; Schema: public; Owner: -
271--
272
273CREATE TABLE ax_bauwerkimgewaesserbereich (
274    ogc_fid integer NOT NULL,
275    wkb_geometry geometry,
276    gml_id character(16),
277    identifier character(28),
278    beginnt character(20),
279    advstandardmodell character varying[],
280    art character(16),
281    name character(11),
282    bauwerksfunktion integer,
283    CONSTRAINT enforce_dims_wkb_geometry CHECK ((st_ndims(wkb_geometry) = 2)),
284    --CONSTRAINT enforce_geotype_wkb_geometry CHECK (((geometrytype(wkb_geometry) = 'LINESTRING'::text) OR (wkb_geometry IS NULL))),
285    CONSTRAINT enforce_srid_wkb_geometry CHECK ((st_srid(wkb_geometry) = 25832))
286);
287
288
289--
290-- TOC entry 2675 (class 1259 OID 29941)
291-- Dependencies: 2676 3
292-- Name: ax_bauwerkimgewaesserbereich_ogc_fid_seq; Type: SEQUENCE; Schema: public; Owner: -
293--
294
295CREATE SEQUENCE ax_bauwerkimgewaesserbereich_ogc_fid_seq
296    START WITH 1
297    INCREMENT BY 1
298    NO MAXVALUE
299    NO MINVALUE
300    CACHE 1;
301
302
303--
304-- TOC entry 3597 (class 0 OID 0)
305-- Dependencies: 2675
306-- Name: ax_bauwerkimgewaesserbereich_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
307--
308
309ALTER SEQUENCE ax_bauwerkimgewaesserbereich_ogc_fid_seq OWNED BY ax_bauwerkimgewaesserbereich.ogc_fid;
310
311
312--
313-- TOC entry 2680 (class 1259 OID 29975)
314-- Dependencies: 3148 3149 3 1087
315-- Name: ax_bauwerkimverkehrsbereich; Type: TABLE; Schema: public; Owner: -
316--
317
318CREATE TABLE ax_bauwerkimverkehrsbereich (
319    ogc_fid integer NOT NULL,
320    wkb_geometry geometry,
321    gml_id character(16),
322    identifier character(28),
323    beginnt character(20),
324    advstandardmodell character varying[],
325    art character(16),
326    name character(11),
327    bauwerksfunktion integer,
328    CONSTRAINT enforce_dims_wkb_geometry CHECK ((st_ndims(wkb_geometry) = 2)),
329    CONSTRAINT enforce_srid_wkb_geometry CHECK ((st_srid(wkb_geometry) = 25832))
330);
331
332
333--
334-- TOC entry 2679 (class 1259 OID 29973)
335-- Dependencies: 2680 3
336-- Name: ax_bauwerkimverkehrsbereich_ogc_fid_seq; Type: SEQUENCE; Schema: public; Owner: -
337--
338
339CREATE SEQUENCE ax_bauwerkimverkehrsbereich_ogc_fid_seq
340    START WITH 1
341    INCREMENT BY 1
342    NO MAXVALUE
343    NO MINVALUE
344    CACHE 1;
345
346
347--
348-- TOC entry 3598 (class 0 OID 0)
349-- Dependencies: 2679
350-- Name: ax_bauwerkimverkehrsbereich_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
351--
352
353ALTER SEQUENCE ax_bauwerkimverkehrsbereich_ogc_fid_seq OWNED BY ax_bauwerkimverkehrsbereich.ogc_fid;
354
355
356--
357-- TOC entry 2682 (class 1259 OID 29990)
358-- Dependencies: 3151 3152 3153 1087 3
359-- Name: ax_bauwerkoderanlagefuerindustrieundgewerbe; Type: TABLE; Schema: public; Owner: -
360--
361
362CREATE TABLE ax_bauwerkoderanlagefuerindustrieundgewerbe (
363    ogc_fid integer NOT NULL,
364    wkb_geometry geometry,
365    gml_id character(16),
366    identifier character(28),
367    beginnt character(20),
368    advstandardmodell character varying[],
369    art character(16),
370    name character(11),
371    bauwerksfunktion integer,
372    CONSTRAINT enforce_dims_wkb_geometry CHECK ((st_ndims(wkb_geometry) = 2)),
373    --CONSTRAINT enforce_geotype_wkb_geometry CHECK (((geometrytype(wkb_geometry) = 'POINT'::text) OR (wkb_geometry IS NULL))),
374    CONSTRAINT enforce_srid_wkb_geometry CHECK ((st_srid(wkb_geometry) = 25832))
375);
376
377
378--
379-- TOC entry 2681 (class 1259 OID 29988)
380-- Dependencies: 3 2682
381-- Name: ax_bauwerkoderanlagefuerindustrieundgewerbe_ogc_fid_seq; Type: SEQUENCE; Schema: public; Owner: -
382--
383
384CREATE SEQUENCE ax_bauwerkoderanlagefuerindustrieundgewerbe_ogc_fid_seq
385    START WITH 1
386    INCREMENT BY 1
387    NO MAXVALUE
388    NO MINVALUE
389    CACHE 1;
390
391
392--
393-- TOC entry 3599 (class 0 OID 0)
394-- Dependencies: 2681
395-- Name: ax_bauwerkoderanlagefuerindustrieundgewerbe_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
396--
397
398ALTER SEQUENCE ax_bauwerkoderanlagefuerindustrieundgewerbe_ogc_fid_seq OWNED BY ax_bauwerkoderanlagefuerindustrieundgewerbe.ogc_fid;
399
400
401--
402-- TOC entry 2678 (class 1259 OID 29959)
403-- Dependencies: 3144 3145 3146 3 1087
404-- Name: ax_bauwerkoderanlagefuersportfreizeitunderholung; Type: TABLE; Schema: public; Owner: -
405--
406
407CREATE TABLE ax_bauwerkoderanlagefuersportfreizeitunderholung (
408    ogc_fid integer NOT NULL,
409    wkb_geometry geometry,
410    gml_id character(16),
411    identifier character(28),
412    beginnt character(20),
413    advstandardmodell character varying[],
414    art character(16),
415    name character(11),
416    bauwerksfunktion integer,
417    CONSTRAINT enforce_dims_wkb_geometry CHECK ((st_ndims(wkb_geometry) = 2)),
418    --CONSTRAINT enforce_geotype_wkb_geometry CHECK (((geometrytype(wkb_geometry) = 'POLYGON'::text) OR (wkb_geometry IS NULL))),
419    CONSTRAINT enforce_srid_wkb_geometry CHECK ((st_srid(wkb_geometry) = 25832))
420);
421
422
423--
424-- TOC entry 2677 (class 1259 OID 29957)
425-- Dependencies: 2678 3
426-- Name: ax_bauwerkoderanlagefuersportfreizeitunderholung_ogc_fid_seq; Type: SEQUENCE; Schema: public; Owner: -
427--
428
429CREATE SEQUENCE ax_bauwerkoderanlagefuersportfreizeitunderholung_ogc_fid_seq
430    START WITH 1
431    INCREMENT BY 1
432    NO MAXVALUE
433    NO MINVALUE
434    CACHE 1;
435
436
437--
438-- TOC entry 3600 (class 0 OID 0)
439-- Dependencies: 2677
440-- Name: ax_bauwerkoderanlagefuersportfreizeitunderholung_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
441--
442
443ALTER SEQUENCE ax_bauwerkoderanlagefuersportfreizeitunderholung_ogc_fid_seq OWNED BY ax_bauwerkoderanlagefuersportfreizeitunderholung.ogc_fid;
444
445
446--
447-- TOC entry 2796 (class 1259 OID 133065)
448-- Dependencies: 3366 3367 3368 3 1087
449-- Name: ax_bergbaubetrieb; Type: TABLE; Schema: public; Owner: -
450--
451
452CREATE TABLE ax_bergbaubetrieb (
453    ogc_fid integer NOT NULL,
454    wkb_geometry geometry,
455    gml_id character(16),
456    identifier character(28),
457    beginnt character(20),
458    advstandardmodell character varying[],
459    CONSTRAINT enforce_dims_wkb_geometry CHECK ((st_ndims(wkb_geometry) = 2)),
460    CONSTRAINT enforce_geotype_wkb_geometry CHECK (((geometrytype(wkb_geometry) = 'POLYGON'::text) OR (wkb_geometry IS NULL))),
461    CONSTRAINT enforce_srid_wkb_geometry CHECK ((st_srid(wkb_geometry) = 25832))
462);
463
464
465--
466-- TOC entry 2795 (class 1259 OID 133063)
467-- Dependencies: 3 2796
468-- Name: ax_bergbaubetrieb_ogc_fid_seq; Type: SEQUENCE; Schema: public; Owner: -
469--
470
471CREATE SEQUENCE ax_bergbaubetrieb_ogc_fid_seq
472    START WITH 1
473    INCREMENT BY 1
474    NO MAXVALUE
475    NO MINVALUE
476    CACHE 1;
477
478
479--
480-- TOC entry 3601 (class 0 OID 0)
481-- Dependencies: 2795
482-- Name: ax_bergbaubetrieb_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
483--
484
485ALTER SEQUENCE ax_bergbaubetrieb_ogc_fid_seq OWNED BY ax_bergbaubetrieb.ogc_fid;
486
487
488--
489-- TOC entry 2738 (class 1259 OID 30600)
490-- Dependencies: 3256 3257 3258 1087 3
491-- Name: ax_dammwalldeich; Type: TABLE; Schema: public; Owner: -
492--
493
494CREATE TABLE ax_dammwalldeich (
495    ogc_fid integer NOT NULL,
496    wkb_geometry geometry,
497    gml_id character(16),
498    identifier character(28),
499    beginnt character(20),
500    advstandardmodell character varying[],
501    art character(16),
502    name character(11),
503    funktion integer,
504    CONSTRAINT enforce_dims_wkb_geometry CHECK ((st_ndims(wkb_geometry) = 2)),
505    --CONSTRAINT enforce_geotype_wkb_geometry CHECK (((geometrytype(wkb_geometry) = 'LINESTRING'::text) OR (wkb_geometry IS NULL))),
506    CONSTRAINT enforce_srid_wkb_geometry CHECK ((st_srid(wkb_geometry) = 25832))
507);
508
509
510--
511-- TOC entry 2737 (class 1259 OID 30598)
512-- Dependencies: 3 2738
513-- Name: ax_dammwalldeich_ogc_fid_seq; Type: SEQUENCE; Schema: public; Owner: -
514--
515
516CREATE SEQUENCE ax_dammwalldeich_ogc_fid_seq
517    START WITH 1
518    INCREMENT BY 1
519    NO MAXVALUE
520    NO MINVALUE
521    CACHE 1;
522
523
524--
525-- TOC entry 3602 (class 0 OID 0)
526-- Dependencies: 2737
527-- Name: ax_dammwalldeich_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
528--
529
530ALTER SEQUENCE ax_dammwalldeich_ogc_fid_seq OWNED BY ax_dammwalldeich.ogc_fid;
531
532
533--
534-- TOC entry 2758 (class 1259 OID 30998)
535-- Dependencies: 3293 3294 3295 3 1087
536-- Name: ax_denkmalschutzrecht; Type: TABLE; Schema: public; Owner: -
537--
538
539CREATE TABLE ax_denkmalschutzrecht (
540    ogc_fid integer NOT NULL,
541    wkb_geometry geometry,
542    gml_id character(16),
543    identifier character(28),
544    beginnt character(20),
545    advstandardmodell character varying[],
546    art character(16),
547    name character(11),
548    artderfestlegung integer,
549    CONSTRAINT enforce_dims_wkb_geometry CHECK ((st_ndims(wkb_geometry) = 2)),
550    --CONSTRAINT enforce_geotype_wkb_geometry CHECK (((geometrytype(wkb_geometry) = 'LINESTRING'::text) OR (wkb_geometry IS NULL))),
551    CONSTRAINT enforce_srid_wkb_geometry CHECK ((st_srid(wkb_geometry) = 25832))
552);
553
554
555--
556-- TOC entry 2757 (class 1259 OID 30996)
557-- Dependencies: 3 2758
558-- Name: ax_denkmalschutzrecht_ogc_fid_seq; Type: SEQUENCE; Schema: public; Owner: -
559--
560
561CREATE SEQUENCE ax_denkmalschutzrecht_ogc_fid_seq
562    START WITH 1
563    INCREMENT BY 1
564    NO MAXVALUE
565    NO MINVALUE
566    CACHE 1;
567
568
569--
570-- TOC entry 3603 (class 0 OID 0)
571-- Dependencies: 2757
572-- Name: ax_denkmalschutzrecht_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
573--
574
575ALTER SEQUENCE ax_denkmalschutzrecht_ogc_fid_seq OWNED BY ax_denkmalschutzrecht.ogc_fid;
576
577
578--
579-- TOC entry 2736 (class 1259 OID 30584)
580-- Dependencies: 3252 3253 3254 1087 3
581-- Name: ax_einrichtungenfuerdenschiffsverkehr; Type: TABLE; Schema: public; Owner: -
582--
583
584CREATE TABLE ax_einrichtungenfuerdenschiffsverkehr (
585    ogc_fid integer NOT NULL,
586    wkb_geometry geometry,
587    gml_id character(16),
588    identifier character(28),
589    beginnt character(20),
590    advstandardmodell character varying[],
591    art character(16),
592    name character(11),
593    art_ integer,
594    bezeichnung integer,
595    kilometerangabe double precision,
596    CONSTRAINT enforce_dims_wkb_geometry CHECK ((st_ndims(wkb_geometry) = 2)),
597    CONSTRAINT enforce_geotype_wkb_geometry CHECK (((geometrytype(wkb_geometry) = 'POINT'::text) OR (wkb_geometry IS NULL))),
598    CONSTRAINT enforce_srid_wkb_geometry CHECK ((st_srid(wkb_geometry) = 25832))
599);
600
601
602--
603-- TOC entry 2735 (class 1259 OID 30582)
604-- Dependencies: 3 2736
605-- Name: ax_einrichtungenfuerdenschiffsverkehr_ogc_fid_seq; Type: SEQUENCE; Schema: public; Owner: -
606--
607
608CREATE SEQUENCE ax_einrichtungenfuerdenschiffsverkehr_ogc_fid_seq
609    START WITH 1
610    INCREMENT BY 1
611    NO MAXVALUE
612    NO MINVALUE
613    CACHE 1;
614
615
616--
617-- TOC entry 3604 (class 0 OID 0)
618-- Dependencies: 2735
619-- Name: ax_einrichtungenfuerdenschiffsverkehr_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
620--
621
622ALTER SEQUENCE ax_einrichtungenfuerdenschiffsverkehr_ogc_fid_seq OWNED BY ax_einrichtungenfuerdenschiffsverkehr.ogc_fid;
623
624
625--
626-- TOC entry 2684 (class 1259 OID 30006)
627-- Dependencies: 3155 3156 3157 1087 3
628-- Name: ax_fahrbahnachse; Type: TABLE; Schema: public; Owner: -
629--
630
631CREATE TABLE ax_fahrbahnachse (
632    ogc_fid integer NOT NULL,
633    wkb_geometry geometry,
634    gml_id character(16),
635    identifier character(28),
636    beginnt character(20),
637    advstandardmodell character varying[],
638    art character(16),
639    name character(11),
640    istteilvon character varying,
641    breitederfahrbahn double precision,
642    CONSTRAINT enforce_dims_wkb_geometry CHECK ((st_ndims(wkb_geometry) = 2)),
643    CONSTRAINT enforce_geotype_wkb_geometry CHECK (((geometrytype(wkb_geometry) = 'LINESTRING'::text) OR (wkb_geometry IS NULL))),
644    CONSTRAINT enforce_srid_wkb_geometry CHECK ((st_srid(wkb_geometry) = 25832))
645);
646
647
648--
649-- TOC entry 2683 (class 1259 OID 30004)
650-- Dependencies: 2684 3
651-- Name: ax_fahrbahnachse_ogc_fid_seq; Type: SEQUENCE; Schema: public; Owner: -
652--
653
654CREATE SEQUENCE ax_fahrbahnachse_ogc_fid_seq
655    START WITH 1
656    INCREMENT BY 1
657    NO MAXVALUE
658    NO MINVALUE
659    CACHE 1;
660
661
662--
663-- TOC entry 3605 (class 0 OID 0)
664-- Dependencies: 2683
665-- Name: ax_fahrbahnachse_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
666--
667
668ALTER SEQUENCE ax_fahrbahnachse_ogc_fid_seq OWNED BY ax_fahrbahnachse.ogc_fid;
669
670
671--
672-- TOC entry 2652 (class 1259 OID 29719)
673-- Dependencies: 3095 3096 3097 1087 3
674-- Name: ax_fahrwegachse; Type: TABLE; Schema: public; Owner: -
675--
676
677CREATE TABLE ax_fahrwegachse (
678    ogc_fid integer NOT NULL,
679    wkb_geometry geometry,
680    gml_id character(16),
681    identifier character(28),
682    beginnt character(20),
683    advstandardmodell character varying[],
684    art character(16),
685    name character(11),
686    befestigung integer,
687    breitedesverkehrsweges integer,
688    funktion integer,
689    CONSTRAINT enforce_dims_wkb_geometry CHECK ((st_ndims(wkb_geometry) = 2)),
690    CONSTRAINT enforce_geotype_wkb_geometry CHECK (((geometrytype(wkb_geometry) = 'LINESTRING'::text) OR (wkb_geometry IS NULL))),
691    CONSTRAINT enforce_srid_wkb_geometry CHECK ((st_srid(wkb_geometry) = 25832))
692);
693
694
695--
696-- TOC entry 2651 (class 1259 OID 29717)
697-- Dependencies: 2652 3
698-- Name: ax_fahrwegachse_ogc_fid_seq; Type: SEQUENCE; Schema: public; Owner: -
699--
700
701CREATE SEQUENCE ax_fahrwegachse_ogc_fid_seq
702    START WITH 1
703    INCREMENT BY 1
704    NO MAXVALUE
705    NO MINVALUE
706    CACHE 1;
707
708
709--
710-- TOC entry 3606 (class 0 OID 0)
711-- Dependencies: 2651
712-- Name: ax_fahrwegachse_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
713--
714
715ALTER SEQUENCE ax_fahrwegachse_ogc_fid_seq OWNED BY ax_fahrwegachse.ogc_fid;
716
717
718--
719-- TOC entry 2760 (class 1259 OID 31044)
720-- Dependencies: 3297 3298 3299 1087 3
721-- Name: ax_felsenfelsblockfelsnadel; Type: TABLE; Schema: public; Owner: -
722--
723
724CREATE TABLE ax_felsenfelsblockfelsnadel (
725    ogc_fid integer NOT NULL,
726    wkb_geometry geometry,
727    gml_id character(16),
728    identifier character(28),
729    beginnt character(20),
730    advstandardmodell character varying[],
731    art character(16),
732    name character(11),
733    name_ character(200), --16
734    CONSTRAINT enforce_dims_wkb_geometry CHECK ((st_ndims(wkb_geometry) = 2)),
735    --CONSTRAINT enforce_geotype_wkb_geometry CHECK (((geometrytype(wkb_geometry) = 'LINESTRING'::text) OR (wkb_geometry IS NULL))),
736    CONSTRAINT enforce_srid_wkb_geometry CHECK ((st_srid(wkb_geometry) = 25832))
737);
738
739
740--
741-- TOC entry 2759 (class 1259 OID 31042)
742-- Dependencies: 2760 3
743-- Name: ax_felsenfelsblockfelsnadel_ogc_fid_seq; Type: SEQUENCE; Schema: public; Owner: -
744--
745
746CREATE SEQUENCE ax_felsenfelsblockfelsnadel_ogc_fid_seq
747    START WITH 1
748    INCREMENT BY 1
749    NO MAXVALUE
750    NO MINVALUE
751    CACHE 1;
752
753
754--
755-- TOC entry 3607 (class 0 OID 0)
756-- Dependencies: 2759
757-- Name: ax_felsenfelsblockfelsnadel_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
758--
759
760ALTER SEQUENCE ax_felsenfelsblockfelsnadel_ogc_fid_seq OWNED BY ax_felsenfelsblockfelsnadel.ogc_fid;
761
762
763--
764-- TOC entry 2686 (class 1259 OID 30022)
765-- Dependencies: 3159 3160 3161 1087 3
766-- Name: ax_flaechebesondererfunktionalerpraegung; Type: TABLE; Schema: public; Owner: -
767--
768
769CREATE TABLE ax_flaechebesondererfunktionalerpraegung (
770    ogc_fid integer NOT NULL,
771    wkb_geometry geometry,
772    gml_id character(16),
773    identifier character(28),
774    beginnt character(20),
775    advstandardmodell character varying[],
776    art character(16),
777    name character(11),
778    artderbebauung integer,
779    CONSTRAINT enforce_dims_wkb_geometry CHECK ((st_ndims(wkb_geometry) = 2)),
780    CONSTRAINT enforce_geotype_wkb_geometry CHECK (((geometrytype(wkb_geometry) = 'POLYGON'::text) OR (wkb_geometry IS NULL))),
781    CONSTRAINT enforce_srid_wkb_geometry CHECK ((st_srid(wkb_geometry) = 25832))
782);
783
784
785--
786-- TOC entry 2685 (class 1259 OID 30020)
787-- Dependencies: 2686 3
788-- Name: ax_flaechebesondererfunktionalerpraegung_ogc_fid_seq; Type: SEQUENCE; Schema: public; Owner: -
789--
790
791CREATE SEQUENCE ax_flaechebesondererfunktionalerpraegung_ogc_fid_seq
792    START WITH 1
793    INCREMENT BY 1
794    NO MAXVALUE
795    NO MINVALUE
796    CACHE 1;
797
798
799--
800-- TOC entry 3608 (class 0 OID 0)
801-- Dependencies: 2685
802-- Name: ax_flaechebesondererfunktionalerpraegung_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
803--
804
805ALTER SEQUENCE ax_flaechebesondererfunktionalerpraegung_ogc_fid_seq OWNED BY ax_flaechebesondererfunktionalerpraegung.ogc_fid;
806
807
808--
809-- TOC entry 2688 (class 1259 OID 30038)
810-- Dependencies: 3163 3164 3165 3 1087
811-- Name: ax_flaechegemischternutzung; Type: TABLE; Schema: public; Owner: -
812--
813
814CREATE TABLE ax_flaechegemischternutzung (
815    ogc_fid integer NOT NULL,
816    wkb_geometry geometry,
817    gml_id character(16),
818    identifier character(28),
819    beginnt character(20),
820    advstandardmodell character varying[],
821    art character(16),
822    name character(11),
823    artderbebauung integer,
824    CONSTRAINT enforce_dims_wkb_geometry CHECK ((st_ndims(wkb_geometry) = 2)),
825    CONSTRAINT enforce_geotype_wkb_geometry CHECK (((geometrytype(wkb_geometry) = 'POLYGON'::text) OR (wkb_geometry IS NULL))),
826    CONSTRAINT enforce_srid_wkb_geometry CHECK ((st_srid(wkb_geometry) = 25832))
827);
828
829
830--
831-- TOC entry 2687 (class 1259 OID 30036)
832-- Dependencies: 3 2688
833-- Name: ax_flaechegemischternutzung_ogc_fid_seq; Type: SEQUENCE; Schema: public; Owner: -
834--
835
836CREATE SEQUENCE ax_flaechegemischternutzung_ogc_fid_seq
837    START WITH 1
838    INCREMENT BY 1
839    NO MAXVALUE
840    NO MINVALUE
841    CACHE 1;
842
843
844--
845-- TOC entry 3609 (class 0 OID 0)
846-- Dependencies: 2687
847-- Name: ax_flaechegemischternutzung_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
848--
849
850ALTER SEQUENCE ax_flaechegemischternutzung_ogc_fid_seq OWNED BY ax_flaechegemischternutzung.ogc_fid;
851
852
853--
854-- TOC entry 2740 (class 1259 OID 30616)
855-- Dependencies: 3260 3261 3262 3 1087
856-- Name: ax_flaechezurzeitunbestimmbar; Type: TABLE; Schema: public; Owner: -
857--
858
859CREATE TABLE ax_flaechezurzeitunbestimmbar (
860    ogc_fid integer NOT NULL,
861    wkb_geometry geometry,
862    gml_id character(16),
863    identifier character(28),
864    beginnt character(20),
865    advstandardmodell character varying[],
866    art character(16),
867    name character(11),
868    CONSTRAINT enforce_dims_wkb_geometry CHECK ((st_ndims(wkb_geometry) = 2)),
869    CONSTRAINT enforce_geotype_wkb_geometry CHECK (((geometrytype(wkb_geometry) = 'POLYGON'::text) OR (wkb_geometry IS NULL))),
870    CONSTRAINT enforce_srid_wkb_geometry CHECK ((st_srid(wkb_geometry) = 25832))
871);
872
873
874--
875-- TOC entry 2739 (class 1259 OID 30614)
876-- Dependencies: 3 2740
877-- Name: ax_flaechezurzeitunbestimmbar_ogc_fid_seq; Type: SEQUENCE; Schema: public; Owner: -
878--
879
880CREATE SEQUENCE ax_flaechezurzeitunbestimmbar_ogc_fid_seq
881    START WITH 1
882    INCREMENT BY 1
883    NO MAXVALUE
884    NO MINVALUE
885    CACHE 1;
886
887
888--
889-- TOC entry 3610 (class 0 OID 0)
890-- Dependencies: 2739
891-- Name: ax_flaechezurzeitunbestimmbar_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
892--
893
894ALTER SEQUENCE ax_flaechezurzeitunbestimmbar_ogc_fid_seq OWNED BY ax_flaechezurzeitunbestimmbar.ogc_fid;
895
896
897--
898-- TOC entry 2742 (class 1259 OID 30632)
899-- Dependencies: 3264 3265 3266 3 1087
900-- Name: ax_fliessgewaesser; Type: TABLE; Schema: public; Owner: -
901--
902
903CREATE TABLE ax_fliessgewaesser (
904    ogc_fid integer NOT NULL,
905    wkb_geometry geometry,
906    gml_id character(16),
907    identifier character(28),
908    beginnt character(20),
909    advstandardmodell character varying[],
910    art character(16),
911    name character(11),
912    istteilvon character varying,
913    CONSTRAINT enforce_dims_wkb_geometry CHECK ((st_ndims(wkb_geometry) = 2)),
914    CONSTRAINT enforce_geotype_wkb_geometry CHECK (((geometrytype(wkb_geometry) = 'POLYGON'::text) OR (wkb_geometry IS NULL))),
915    CONSTRAINT enforce_srid_wkb_geometry CHECK ((st_srid(wkb_geometry) = 25832))
916);
917
918
919--
920-- TOC entry 2741 (class 1259 OID 30630)
921-- Dependencies: 2742 3
922-- Name: ax_fliessgewaesser_ogc_fid_seq; Type: SEQUENCE; Schema: public; Owner: -
923--
924
925CREATE SEQUENCE ax_fliessgewaesser_ogc_fid_seq
926    START WITH 1
927    INCREMENT BY 1
928    NO MAXVALUE
929    NO MINVALUE
930    CACHE 1;
931
932
933--
934-- TOC entry 3611 (class 0 OID 0)
935-- Dependencies: 2741
936-- Name: ax_fliessgewaesser_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
937--
938
939ALTER SEQUENCE ax_fliessgewaesser_ogc_fid_seq OWNED BY ax_fliessgewaesser.ogc_fid;
940
941
942--
943-- TOC entry 2766 (class 1259 OID 32182)
944-- Dependencies: 3309 3310 3311 3 1087
945-- Name: ax_flugverkehr; Type: TABLE; Schema: public; Owner: -
946--
947
948CREATE TABLE ax_flugverkehr (
949    ogc_fid integer NOT NULL,
950    wkb_geometry geometry,
951    gml_id character(16),
952    identifier character(28),
953    beginnt character(20),
954    advstandardmodell character varying[],
955    art character(16),
956    name character(11),
957    art_ integer,
958    unverschluesselt character(18),
959    CONSTRAINT enforce_dims_wkb_geometry CHECK ((st_ndims(wkb_geometry) = 2)),
960    CONSTRAINT enforce_geotype_wkb_geometry CHECK (((geometrytype(wkb_geometry) = 'POLYGON'::text) OR (wkb_geometry IS NULL))),
961    CONSTRAINT enforce_srid_wkb_geometry CHECK ((st_srid(wkb_geometry) = 25832))
962);
963
964
965--
966-- TOC entry 2765 (class 1259 OID 32180)
967-- Dependencies: 2766 3
968-- Name: ax_flugverkehr_ogc_fid_seq; Type: SEQUENCE; Schema: public; Owner: -
969--
970
971CREATE SEQUENCE ax_flugverkehr_ogc_fid_seq
972    START WITH 1
973    INCREMENT BY 1
974    NO MAXVALUE
975    NO MINVALUE
976    CACHE 1;
977
978
979--
980-- TOC entry 3612 (class 0 OID 0)
981-- Dependencies: 2765
982-- Name: ax_flugverkehr_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
983--
984
985ALTER SEQUENCE ax_flugverkehr_ogc_fid_seq OWNED BY ax_flugverkehr.ogc_fid;
986
987
988--
989-- TOC entry 2768 (class 1259 OID 33034)
990-- Dependencies: 3313 3314 3315 3 1087
991-- Name: ax_flugverkehrsanlage; Type: TABLE; Schema: public; Owner: -
992--
993
994CREATE TABLE ax_flugverkehrsanlage (
995    ogc_fid integer NOT NULL,
996    wkb_geometry geometry,
997    gml_id character(16),
998    identifier character(28),
999    beginnt character(20),
1000    advstandardmodell character varying[],
1001    art character(16),
1002    name character(11),
1003    art_ integer,
1004    name_ character(200), --26
1005    CONSTRAINT enforce_dims_wkb_geometry CHECK ((st_ndims(wkb_geometry) = 2)),
1006    --CONSTRAINT enforce_geotype_wkb_geometry CHECK (((geometrytype(wkb_geometry) = 'POINT'::text) OR (wkb_geometry IS NULL))),
1007    CONSTRAINT enforce_srid_wkb_geometry CHECK ((st_srid(wkb_geometry) = 25832))
1008);
1009
1010
1011--
1012-- TOC entry 2767 (class 1259 OID 33032)
1013-- Dependencies: 2768 3
1014-- Name: ax_flugverkehrsanlage_ogc_fid_seq; Type: SEQUENCE; Schema: public; Owner: -
1015--
1016
1017CREATE SEQUENCE ax_flugverkehrsanlage_ogc_fid_seq
1018    START WITH 1
1019    INCREMENT BY 1
1020    NO MAXVALUE
1021    NO MINVALUE
1022    CACHE 1;
1023
1024
1025--
1026-- TOC entry 3613 (class 0 OID 0)
1027-- Dependencies: 2767
1028-- Name: ax_flugverkehrsanlage_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1029--
1030
1031ALTER SEQUENCE ax_flugverkehrsanlage_ogc_fid_seq OWNED BY ax_flugverkehrsanlage.ogc_fid;
1032
1033
1034--
1035-- TOC entry 2690 (class 1259 OID 30054)
1036-- Dependencies: 3167 3168 3169 3 1087
1037-- Name: ax_friedhof; Type: TABLE; Schema: public; Owner: -
1038--
1039
1040CREATE TABLE ax_friedhof (
1041    ogc_fid integer NOT NULL,
1042    wkb_geometry geometry,
1043    gml_id character(16),
1044    identifier character(28),
1045    beginnt character(20),
1046    advstandardmodell character varying[],
1047    art character(16),
1048    name character(11),
1049    CONSTRAINT enforce_dims_wkb_geometry CHECK ((st_ndims(wkb_geometry) = 2)),
1050    CONSTRAINT enforce_geotype_wkb_geometry CHECK (((geometrytype(wkb_geometry) = 'POLYGON'::text) OR (wkb_geometry IS NULL))),
1051    CONSTRAINT enforce_srid_wkb_geometry CHECK ((st_srid(wkb_geometry) = 25832))
1052);
1053
1054
1055--
1056-- TOC entry 2689 (class 1259 OID 30052)
1057-- Dependencies: 3 2690
1058-- Name: ax_friedhof_ogc_fid_seq; Type: SEQUENCE; Schema: public; Owner: -
1059--
1060
1061CREATE SEQUENCE ax_friedhof_ogc_fid_seq
1062    START WITH 1
1063    INCREMENT BY 1
1064    NO MAXVALUE
1065    NO MINVALUE
1066    CACHE 1;
1067
1068
1069--
1070-- TOC entry 3614 (class 0 OID 0)
1071-- Dependencies: 2689
1072-- Name: ax_friedhof_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1073--
1074
1075ALTER SEQUENCE ax_friedhof_ogc_fid_seq OWNED BY ax_friedhof.ogc_fid;
1076
1077
1078--
1079-- TOC entry 2692 (class 1259 OID 30070)
1080-- Dependencies: 3171 3172 3173 1087 3
1081-- Name: ax_gebaeude; Type: TABLE; Schema: public; Owner: -
1082--
1083
1084CREATE TABLE ax_gebaeude (
1085    ogc_fid integer NOT NULL,
1086    wkb_geometry geometry,
1087    gml_id character(16),
1088    identifier character(28),
1089    beginnt character(20),
1090    advstandardmodell character varying[],
1091    art character(16),
1092    name character(11),
1093    gebaeudefunktion integer,
1094    gebaeudekennzeichen character(27),
1095    CONSTRAINT enforce_dims_wkb_geometry CHECK ((st_ndims(wkb_geometry) = 2)),
1096    --CONSTRAINT enforce_geotype_wkb_geometry CHECK (((geometrytype(wkb_geometry) = 'POINT'::text) OR (wkb_geometry IS NULL))),
1097    CONSTRAINT enforce_srid_wkb_geometry CHECK ((st_srid(wkb_geometry) = 25832))
1098);
1099
1100
1101--
1102-- TOC entry 2691 (class 1259 OID 30068)
1103-- Dependencies: 3 2692
1104-- Name: ax_gebaeude_ogc_fid_seq; Type: SEQUENCE; Schema: public; Owner: -
1105--
1106
1107CREATE SEQUENCE ax_gebaeude_ogc_fid_seq
1108    START WITH 1
1109    INCREMENT BY 1
1110    NO MAXVALUE
1111    NO MINVALUE
1112    CACHE 1;
1113
1114
1115--
1116-- TOC entry 3615 (class 0 OID 0)
1117-- Dependencies: 2691
1118-- Name: ax_gebaeude_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1119--
1120
1121ALTER SEQUENCE ax_gebaeude_ogc_fid_seq OWNED BY ax_gebaeude.ogc_fid;
1122
1123
1124--
1125-- TOC entry 2654 (class 1259 OID 29735)
1126-- Dependencies: 3099 3100 3101 1087 3
1127-- Name: ax_gebietsgrenze; Type: TABLE; Schema: public; Owner: -
1128--
1129
1130CREATE TABLE ax_gebietsgrenze (
1131    ogc_fid integer NOT NULL,
1132    wkb_geometry geometry,
1133    gml_id character(16),
1134    identifier character(28),
1135    beginnt character(20),
1136    advstandardmodell character varying[],
1137    art character(16),
1138    name character(11),
1139    artdergebietsgrenze integer[],
1140    CONSTRAINT enforce_dims_wkb_geometry CHECK ((st_ndims(wkb_geometry) = 2)),
1141    CONSTRAINT enforce_geotype_wkb_geometry CHECK (((geometrytype(wkb_geometry) = 'LINESTRING'::text) OR (wkb_geometry IS NULL))),
1142    CONSTRAINT enforce_srid_wkb_geometry CHECK ((st_srid(wkb_geometry) = 25832))
1143);
1144
1145
1146--
1147-- TOC entry 2653 (class 1259 OID 29733)
1148-- Dependencies: 2654 3
1149-- Name: ax_gebietsgrenze_ogc_fid_seq; Type: SEQUENCE; Schema: public; Owner: -
1150--
1151
1152CREATE SEQUENCE ax_gebietsgrenze_ogc_fid_seq
1153    START WITH 1
1154    INCREMENT BY 1
1155    NO MAXVALUE
1156    NO MINVALUE
1157    CACHE 1;
1158
1159
1160--
1161-- TOC entry 3616 (class 0 OID 0)
1162-- Dependencies: 2653
1163-- Name: ax_gebietsgrenze_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1164--
1165
1166ALTER SEQUENCE ax_gebietsgrenze_ogc_fid_seq OWNED BY ax_gebietsgrenze.ogc_fid;
1167
1168
1169--
1170-- TOC entry 2694 (class 1259 OID 30128)
1171-- Dependencies: 3175 3176 3177 3 1087
1172-- Name: ax_gehoelz; Type: TABLE; Schema: public; Owner: -
1173--
1174
1175CREATE TABLE ax_gehoelz (
1176    ogc_fid integer NOT NULL,
1177    wkb_geometry geometry,
1178    gml_id character(16),
1179    identifier character(28),
1180    beginnt character(20),
1181    advstandardmodell character varying[],
1182    art character(16),
1183    name character(11),
1184    CONSTRAINT enforce_dims_wkb_geometry CHECK ((st_ndims(wkb_geometry) = 2)),
1185    CONSTRAINT enforce_geotype_wkb_geometry CHECK (((geometrytype(wkb_geometry) = 'POLYGON'::text) OR (wkb_geometry IS NULL))),
1186    CONSTRAINT enforce_srid_wkb_geometry CHECK ((st_srid(wkb_geometry) = 25832))
1187);
1188
1189
1190--
1191-- TOC entry 2693 (class 1259 OID 30126)
1192-- Dependencies: 3 2694
1193-- Name: ax_gehoelz_ogc_fid_seq; Type: SEQUENCE; Schema: public; Owner: -
1194--
1195
1196CREATE SEQUENCE ax_gehoelz_ogc_fid_seq
1197    START WITH 1
1198    INCREMENT BY 1
1199    NO MAXVALUE
1200    NO MINVALUE
1201    CACHE 1;
1202
1203
1204--
1205-- TOC entry 3617 (class 0 OID 0)
1206-- Dependencies: 2693
1207-- Name: ax_gehoelz_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1208--
1209
1210ALTER SEQUENCE ax_gehoelz_ogc_fid_seq OWNED BY ax_gehoelz.ogc_fid;
1211
1212
1213--
1214-- TOC entry 2656 (class 1259 OID 29761)
1215-- Dependencies: 3103 3104 3105 3 1087
1216-- Name: ax_gewaesserachse; Type: TABLE; Schema: public; Owner: -
1217--
1218
1219CREATE TABLE ax_gewaesserachse (
1220    ogc_fid integer NOT NULL,
1221    wkb_geometry geometry,
1222    gml_id character(16),
1223    identifier character(28),
1224    beginnt character(20),
1225    advstandardmodell character varying[],
1226    art character(16),
1227    name character(11),
1228    istteilvon character varying,
1229    breitedesgewaessers integer,
1230    fliessrichtung character(5),
1231    hydrologischesmerkmal integer,
1232    CONSTRAINT enforce_dims_wkb_geometry CHECK ((st_ndims(wkb_geometry) = 2)),
1233    CONSTRAINT enforce_geotype_wkb_geometry CHECK (((geometrytype(wkb_geometry) = 'LINESTRING'::text) OR (wkb_geometry IS NULL))),
1234    CONSTRAINT enforce_srid_wkb_geometry CHECK ((st_srid(wkb_geometry) = 25832))
1235);
1236
1237
1238--
1239-- TOC entry 2655 (class 1259 OID 29759)
1240-- Dependencies: 2656 3
1241-- Name: ax_gewaesserachse_ogc_fid_seq; Type: SEQUENCE; Schema: public; Owner: -
1242--
1243
1244CREATE SEQUENCE ax_gewaesserachse_ogc_fid_seq
1245    START WITH 1
1246    INCREMENT BY 1
1247    NO MAXVALUE
1248    NO MINVALUE
1249    CACHE 1;
1250
1251
1252--
1253-- TOC entry 3618 (class 0 OID 0)
1254-- Dependencies: 2655
1255-- Name: ax_gewaesserachse_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1256--
1257
1258ALTER SEQUENCE ax_gewaesserachse_ogc_fid_seq OWNED BY ax_gewaesserachse.ogc_fid;
1259
1260
1261--
1262-- TOC entry 2744 (class 1259 OID 30709)
1263-- Dependencies: 3268 3269 3270 3 1087
1264-- Name: ax_gewaessermerkmal; Type: TABLE; Schema: public; Owner: -
1265--
1266
1267CREATE TABLE ax_gewaessermerkmal (
1268    ogc_fid integer NOT NULL,
1269    wkb_geometry geometry,
1270    gml_id character(16),
1271    identifier character(28),
1272    beginnt character(20),
1273    advstandardmodell character varying[],
1274    art character(16),
1275    name character(11),
1276    art_ integer,
1277    CONSTRAINT enforce_dims_wkb_geometry CHECK ((st_ndims(wkb_geometry) = 2)),
1278    --CONSTRAINT enforce_geotype_wkb_geometry CHECK (((geometrytype(wkb_geometry) = 'POINT'::text) OR (wkb_geometry IS NULL))),
1279    CONSTRAINT enforce_srid_wkb_geometry CHECK ((st_srid(wkb_geometry) = 25832))
1280);
1281
1282
1283--
1284-- TOC entry 2743 (class 1259 OID 30707)
1285-- Dependencies: 2744 3
1286-- Name: ax_gewaessermerkmal_ogc_fid_seq; Type: SEQUENCE; Schema: public; Owner: -
1287--
1288
1289CREATE SEQUENCE ax_gewaessermerkmal_ogc_fid_seq
1290    START WITH 1
1291    INCREMENT BY 1
1292    NO MAXVALUE
1293    NO MINVALUE
1294    CACHE 1;
1295
1296
1297--
1298-- TOC entry 3619 (class 0 OID 0)
1299-- Dependencies: 2743
1300-- Name: ax_gewaessermerkmal_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1301--
1302
1303ALTER SEQUENCE ax_gewaessermerkmal_ogc_fid_seq OWNED BY ax_gewaessermerkmal.ogc_fid;
1304
1305
1306--
1307-- TOC entry 2748 (class 1259 OID 30743)
1308-- Dependencies: 3276 3277 3278 1087 3
1309-- Name: ax_gewaesserstationierungsachse; Type: TABLE; Schema: public; Owner: -
1310--
1311
1312CREATE TABLE ax_gewaesserstationierungsachse (
1313    ogc_fid integer NOT NULL,
1314    wkb_geometry geometry,
1315    gml_id character(16),
1316    identifier character(28),
1317    beginnt character(20),
1318    advstandardmodell character(9),
1319    art character(16),
1320    name character(11),
1321    artdergewaesserachse integer,
1322    name_ character(200), --20
1323    gewaesserkennzahl double precision,
1324    fliessrichtung character(5),
1325    CONSTRAINT enforce_dims_wkb_geometry CHECK ((st_ndims(wkb_geometry) = 2)),
1326    CONSTRAINT enforce_geotype_wkb_geometry CHECK (((geometrytype(wkb_geometry) = 'LINESTRING'::text) OR (wkb_geometry IS NULL))),
1327    CONSTRAINT enforce_srid_wkb_geometry CHECK ((st_srid(wkb_geometry) = 25832))
1328);
1329
1330
1331--
1332-- TOC entry 2747 (class 1259 OID 30741)
1333-- Dependencies: 2748 3
1334-- Name: ax_gewaesserstationierungsachse_ogc_fid_seq; Type: SEQUENCE; Schema: public; Owner: -
1335--
1336
1337CREATE SEQUENCE ax_gewaesserstationierungsachse_ogc_fid_seq
1338    START WITH 1
1339    INCREMENT BY 1
1340    NO MAXVALUE
1341    NO MINVALUE
1342    CACHE 1;
1343
1344
1345--
1346-- TOC entry 3620 (class 0 OID 0)
1347-- Dependencies: 2747
1348-- Name: ax_gewaesserstationierungsachse_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1349--
1350
1351ALTER SEQUENCE ax_gewaesserstationierungsachse_ogc_fid_seq OWNED BY ax_gewaesserstationierungsachse.ogc_fid;
1352
1353
1354--
1355-- TOC entry 2774 (class 1259 OID 33730)
1356-- Dependencies: 3325 3326 3327 3 1087
1357-- Name: ax_hafen; Type: TABLE; Schema: public; Owner: -
1358--
1359
1360CREATE TABLE ax_hafen (
1361    ogc_fid integer NOT NULL,
1362    wkb_geometry geometry,
1363    gml_id character(16),
1364    identifier character(28),
1365    beginnt character(20),
1366    advstandardmodell character varying[],
1367    art character(16),
1368    name character(11),
1369    name_ character(200), --28
1370    CONSTRAINT enforce_dims_wkb_geometry CHECK ((st_ndims(wkb_geometry) = 2)),
1371    CONSTRAINT enforce_geotype_wkb_geometry CHECK (((geometrytype(wkb_geometry) = 'POLYGON'::text) OR (wkb_geometry IS NULL))),
1372    CONSTRAINT enforce_srid_wkb_geometry CHECK ((st_srid(wkb_geometry) = 25832))
1373);
1374
1375
1376--
1377-- TOC entry 2773 (class 1259 OID 33728)
1378-- Dependencies: 2774 3
1379-- Name: ax_hafen_ogc_fid_seq; Type: SEQUENCE; Schema: public; Owner: -
1380--
1381
1382CREATE SEQUENCE ax_hafen_ogc_fid_seq
1383    START WITH 1
1384    INCREMENT BY 1
1385    NO MAXVALUE
1386    NO MINVALUE
1387    CACHE 1;
1388
1389
1390--
1391-- TOC entry 3621 (class 0 OID 0)
1392-- Dependencies: 2773
1393-- Name: ax_hafen_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1394--
1395
1396ALTER SEQUENCE ax_hafen_ogc_fid_seq OWNED BY ax_hafen.ogc_fid;
1397
1398
1399--
1400-- TOC entry 2772 (class 1259 OID 33706)
1401-- Dependencies: 3321 3322 3323 3 1087
1402-- Name: ax_hafenbecken; Type: TABLE; Schema: public; Owner: -
1403--
1404
1405CREATE TABLE ax_hafenbecken (
1406    ogc_fid integer NOT NULL,
1407    wkb_geometry geometry,
1408    gml_id character(16),
1409    identifier character(28),
1410    beginnt character(20),
1411    advstandardmodell character varying[],
1412    art character(16),
1413    name character(11),
1414    CONSTRAINT enforce_dims_wkb_geometry CHECK ((st_ndims(wkb_geometry) = 2)),
1415    CONSTRAINT enforce_geotype_wkb_geometry CHECK (((geometrytype(wkb_geometry) = 'POLYGON'::text) OR (wkb_geometry IS NULL))),
1416    CONSTRAINT enforce_srid_wkb_geometry CHECK ((st_srid(wkb_geometry) = 25832))
1417);
1418
1419
1420--
1421-- TOC entry 2771 (class 1259 OID 33704)
1422-- Dependencies: 2772 3
1423-- Name: ax_hafenbecken_ogc_fid_seq; Type: SEQUENCE; Schema: public; Owner: -
1424--
1425
1426CREATE SEQUENCE ax_hafenbecken_ogc_fid_seq
1427    START WITH 1
1428    INCREMENT BY 1
1429    NO MAXVALUE
1430    NO MINVALUE
1431    CACHE 1;
1432
1433
1434--
1435-- TOC entry 3622 (class 0 OID 0)
1436-- Dependencies: 2771
1437-- Name: ax_hafenbecken_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1438--
1439
1440ALTER SEQUENCE ax_hafenbecken_ogc_fid_seq OWNED BY ax_hafenbecken.ogc_fid;
1441
1442
1443--
1444-- TOC entry 2780 (class 1259 OID 36945)
1445-- Dependencies: 3337 3338 3339 1087 3
1446-- Name: ax_halde; Type: TABLE; Schema: public; Owner: -
1447--
1448
1449CREATE TABLE ax_halde (
1450    ogc_fid integer NOT NULL,
1451    wkb_geometry geometry,
1452    gml_id character(16),
1453    identifier character(28),
1454    beginnt character(20),
1455    advstandardmodell character varying[],
1456    art character(16),
1457    name character(11),
1458    CONSTRAINT enforce_dims_wkb_geometry CHECK ((st_ndims(wkb_geometry) = 2)),
1459    CONSTRAINT enforce_geotype_wkb_geometry CHECK (((geometrytype(wkb_geometry) = 'POLYGON'::text) OR (wkb_geometry IS NULL))),
1460    CONSTRAINT enforce_srid_wkb_geometry CHECK ((st_srid(wkb_geometry) = 25832))
1461);
1462
1463
1464--
1465-- TOC entry 2779 (class 1259 OID 36943)
1466-- Dependencies: 2780 3
1467-- Name: ax_halde_ogc_fid_seq; Type: SEQUENCE; Schema: public; Owner: -
1468--
1469
1470CREATE SEQUENCE ax_halde_ogc_fid_seq
1471    START WITH 1
1472    INCREMENT BY 1
1473    NO MAXVALUE
1474    NO MINVALUE
1475    CACHE 1;
1476
1477
1478--
1479-- TOC entry 3623 (class 0 OID 0)
1480-- Dependencies: 2779
1481-- Name: ax_halde_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1482--
1483
1484ALTER SEQUENCE ax_halde_ogc_fid_seq OWNED BY ax_halde.ogc_fid;
1485
1486
1487--
1488-- TOC entry 2792 (class 1259 OID 63873)
1489-- Dependencies: 3361 3362 3363 3 1087
1490-- Name: ax_heide; Type: TABLE; Schema: public; Owner: -
1491--
1492
1493CREATE TABLE ax_heide (
1494    ogc_fid integer NOT NULL,
1495    wkb_geometry geometry,
1496    gml_id character(16),
1497    identifier character(28),
1498    beginnt character(20),
1499    advstandardmodell character varying[],
1500    art character(16),
1501    name character(11),
1502    CONSTRAINT enforce_dims_wkb_geometry CHECK ((st_ndims(wkb_geometry) = 2)),
1503    CONSTRAINT enforce_geotype_wkb_geometry CHECK (((geometrytype(wkb_geometry) = 'POLYGON'::text) OR (wkb_geometry IS NULL))),
1504    CONSTRAINT enforce_srid_wkb_geometry CHECK ((st_srid(wkb_geometry) = 25832))
1505);
1506
1507
1508--
1509-- TOC entry 2791 (class 1259 OID 63871)
1510-- Dependencies: 3 2792
1511-- Name: ax_heide_ogc_fid_seq; Type: SEQUENCE; Schema: public; Owner: -
1512--
1513
1514CREATE SEQUENCE ax_heide_ogc_fid_seq
1515    START WITH 1
1516    INCREMENT BY 1
1517    NO MAXVALUE
1518    NO MINVALUE
1519    CACHE 1;
1520
1521
1522--
1523-- TOC entry 3624 (class 0 OID 0)
1524-- Dependencies: 2791
1525-- Name: ax_heide_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1526--
1527
1528ALTER SEQUENCE ax_heide_ogc_fid_seq OWNED BY ax_heide.ogc_fid;
1529
1530
1531--
1532-- TOC entry 2658 (class 1259 OID 29777)
1533-- Dependencies: 3107 3108 3109 3 1087
1534-- Name: ax_historischesbauwerkoderhistorischeeinrichtung; Type: TABLE; Schema: public; Owner: -
1535--
1536
1537CREATE TABLE ax_historischesbauwerkoderhistorischeeinrichtung (
1538    ogc_fid integer NOT NULL,
1539    wkb_geometry geometry,
1540    gml_id character(16),
1541    identifier character(28),
1542    beginnt character(20),
1543    advstandardmodell character varying[],
1544    art character(16),
1545    name character(11),
1546    archaeologischertyp integer,
1547    CONSTRAINT enforce_dims_wkb_geometry CHECK ((st_ndims(wkb_geometry) = 2)),
1548    --CONSTRAINT enforce_geotype_wkb_geometry CHECK (((geometrytype(wkb_geometry) = 'LINESTRING'::text) OR (wkb_geometry IS NULL))),
1549    CONSTRAINT enforce_srid_wkb_geometry CHECK ((st_srid(wkb_geometry) = 25832))
1550);
1551
1552
1553--
1554-- TOC entry 2657 (class 1259 OID 29775)
1555-- Dependencies: 3 2658
1556-- Name: ax_historischesbauwerkoderhistorischeeinrichtung_ogc_fid_seq; Type: SEQUENCE; Schema: public; Owner: -
1557--
1558
1559CREATE SEQUENCE ax_historischesbauwerkoderhistorischeeinrichtung_ogc_fid_seq
1560    START WITH 1
1561    INCREMENT BY 1
1562    NO MAXVALUE
1563    NO MINVALUE
1564    CACHE 1;
1565
1566
1567--
1568-- TOC entry 3625 (class 0 OID 0)
1569-- Dependencies: 2657
1570-- Name: ax_historischesbauwerkoderhistorischeeinrichtung_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1571--
1572
1573ALTER SEQUENCE ax_historischesbauwerkoderhistorischeeinrichtung_ogc_fid_seq OWNED BY ax_historischesbauwerkoderhistorischeeinrichtung.ogc_fid;
1574
1575
1576--
1577-- TOC entry 2762 (class 1259 OID 31384)
1578-- Dependencies: 3301 3302 3303 3 1087
1579-- Name: ax_hoehleneingang; Type: TABLE; Schema: public; Owner: -
1580--
1581
1582CREATE TABLE ax_hoehleneingang (
1583    ogc_fid integer NOT NULL,
1584    wkb_geometry geometry,
1585    gml_id character(16),
1586    identifier character(28),
1587    beginnt character(20),
1588    advstandardmodell character varying[],
1589    art character(16),
1590    name character(11),
1591    CONSTRAINT enforce_dims_wkb_geometry CHECK ((st_ndims(wkb_geometry) = 2)),
1592    CONSTRAINT enforce_geotype_wkb_geometry CHECK (((geometrytype(wkb_geometry) = 'POINT'::text) OR (wkb_geometry IS NULL))),
1593    CONSTRAINT enforce_srid_wkb_geometry CHECK ((st_srid(wkb_geometry) = 25832))
1594);
1595
1596
1597--
1598-- TOC entry 2761 (class 1259 OID 31382)
1599-- Dependencies: 2762 3
1600-- Name: ax_hoehleneingang_ogc_fid_seq; Type: SEQUENCE; Schema: public; Owner: -
1601--
1602
1603CREATE SEQUENCE ax_hoehleneingang_ogc_fid_seq
1604    START WITH 1
1605    INCREMENT BY 1
1606    NO MAXVALUE
1607    NO MINVALUE
1608    CACHE 1;
1609
1610
1611--
1612-- TOC entry 3626 (class 0 OID 0)
1613-- Dependencies: 2761
1614-- Name: ax_hoehleneingang_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1615--
1616
1617ALTER SEQUENCE ax_hoehleneingang_ogc_fid_seq OWNED BY ax_hoehleneingang.ogc_fid;
1618
1619
1620--
1621-- TOC entry 2696 (class 1259 OID 30185)
1622-- Dependencies: 3179 3180 3181 3 1087
1623-- Name: ax_industrieundgewerbeflaeche; Type: TABLE; Schema: public; Owner: -
1624--
1625
1626CREATE TABLE ax_industrieundgewerbeflaeche (
1627    ogc_fid integer NOT NULL,
1628    wkb_geometry geometry,
1629    gml_id character(16),
1630    identifier character(28),
1631    beginnt character(20),
1632    advstandardmodell character varying[],
1633    art character(16),
1634    name character(11),
1635    funktion integer,
1636    CONSTRAINT enforce_dims_wkb_geometry CHECK ((st_ndims(wkb_geometry) = 2)),
1637    CONSTRAINT enforce_geotype_wkb_geometry CHECK (((geometrytype(wkb_geometry) = 'POLYGON'::text) OR (wkb_geometry IS NULL))),
1638    CONSTRAINT enforce_srid_wkb_geometry CHECK ((st_srid(wkb_geometry) = 25832))
1639);
1640
1641
1642--
1643-- TOC entry 2695 (class 1259 OID 30183)
1644-- Dependencies: 2696 3
1645-- Name: ax_industrieundgewerbeflaeche_ogc_fid_seq; Type: SEQUENCE; Schema: public; Owner: -
1646--
1647
1648CREATE SEQUENCE ax_industrieundgewerbeflaeche_ogc_fid_seq
1649    START WITH 1
1650    INCREMENT BY 1
1651    NO MAXVALUE
1652    NO MINVALUE
1653    CACHE 1;
1654
1655
1656--
1657-- TOC entry 3627 (class 0 OID 0)
1658-- Dependencies: 2695
1659-- Name: ax_industrieundgewerbeflaeche_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1660--
1661
1662ALTER SEQUENCE ax_industrieundgewerbeflaeche_ogc_fid_seq OWNED BY ax_industrieundgewerbeflaeche.ogc_fid;
1663
1664
1665--
1666-- TOC entry 2746 (class 1259 OID 30727)
1667-- Dependencies: 3272 3273 3274 3 1087
1668-- Name: ax_insel; Type: TABLE; Schema: public; Owner: -
1669--
1670
1671CREATE TABLE ax_insel (
1672    ogc_fid integer NOT NULL,
1673    wkb_geometry geometry,
1674    gml_id character(16),
1675    identifier character(28),
1676    beginnt character(20),
1677    advstandardmodell character varying[],
1678    art character(16),
1679    name character(11),
1680    CONSTRAINT enforce_dims_wkb_geometry CHECK ((st_ndims(wkb_geometry) = 2)),
1681    CONSTRAINT enforce_geotype_wkb_geometry CHECK (((geometrytype(wkb_geometry) = 'POLYGON'::text) OR (wkb_geometry IS NULL))),
1682    CONSTRAINT enforce_srid_wkb_geometry CHECK ((st_srid(wkb_geometry) = 25832))
1683);
1684
1685
1686--
1687-- TOC entry 2745 (class 1259 OID 30725)
1688-- Dependencies: 3 2746
1689-- Name: ax_insel_ogc_fid_seq; Type: SEQUENCE; Schema: public; Owner: -
1690--
1691
1692CREATE SEQUENCE ax_insel_ogc_fid_seq
1693    START WITH 1
1694    INCREMENT BY 1
1695    NO MAXVALUE
1696    NO MINVALUE
1697    CACHE 1;
1698
1699
1700--
1701-- TOC entry 3628 (class 0 OID 0)
1702-- Dependencies: 2745
1703-- Name: ax_insel_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1704--
1705
1706ALTER SEQUENCE ax_insel_ogc_fid_seq OWNED BY ax_insel.ogc_fid;
1707
1708
1709--
1710-- TOC entry 2794 (class 1259 OID 69842)
1711-- Dependencies: 3
1712-- Name: ax_kanal; Type: TABLE; Schema: public; Owner: -
1713--
1714
1715CREATE TABLE ax_kanal (
1716    ogc_fid integer NOT NULL,
1717    gml_id character(16),
1718    identifier character(28),
1719    beginnt character(20),
1720    advstandardmodell character varying[],
1721    art character(16),
1722    name character(11),
1723    name_ character(200), --9
1724    gewaesserkennzahl double precision,
1725    schifffahrtskategorie integer
1726);
1727
1728
1729--
1730-- TOC entry 2793 (class 1259 OID 69840)
1731-- Dependencies: 2794 3
1732-- Name: ax_kanal_ogc_fid_seq; Type: SEQUENCE; Schema: public; Owner: -
1733--
1734
1735CREATE SEQUENCE ax_kanal_ogc_fid_seq
1736    START WITH 1
1737    INCREMENT BY 1
1738    NO MAXVALUE
1739    NO MINVALUE
1740    CACHE 1;
1741
1742
1743--
1744-- TOC entry 3629 (class 0 OID 0)
1745-- Dependencies: 2793
1746-- Name: ax_kanal_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1747--
1748
1749ALTER SEQUENCE ax_kanal_ogc_fid_seq OWNED BY ax_kanal.ogc_fid;
1750
1751
1752--
1753-- TOC entry 2660 (class 1259 OID 29793)
1754-- Dependencies: 3111 3112 3113 3 1087
1755-- Name: ax_kommunalesgebiet; Type: TABLE; Schema: public; Owner: -
1756--
1757
1758CREATE TABLE ax_kommunalesgebiet (
1759    ogc_fid integer NOT NULL,
1760    wkb_geometry geometry,
1761    gml_id character(16),
1762    identifier character(28),
1763    beginnt character(20),
1764    advstandardmodell character(9),
1765    art character(16),
1766    name character(11),
1767    schluesselgesamt integer,
1768    land integer,
1769    regierungsbezirk integer,
1770    kreis integer,
1771    gemeinde integer,
1772    CONSTRAINT enforce_dims_wkb_geometry CHECK ((st_ndims(wkb_geometry) = 2)),
1773    CONSTRAINT enforce_geotype_wkb_geometry CHECK (((geometrytype(wkb_geometry) = 'POLYGON'::text) OR (wkb_geometry IS NULL))),
1774    CONSTRAINT enforce_srid_wkb_geometry CHECK ((st_srid(wkb_geometry) = 25832))
1775);
1776
1777
1778--
1779-- TOC entry 2659 (class 1259 OID 29791)
1780-- Dependencies: 3 2660
1781-- Name: ax_kommunalesgebiet_ogc_fid_seq; Type: SEQUENCE; Schema: public; Owner: -
1782--
1783
1784CREATE SEQUENCE ax_kommunalesgebiet_ogc_fid_seq
1785    START WITH 1
1786    INCREMENT BY 1
1787    NO MAXVALUE
1788    NO MINVALUE
1789    CACHE 1;
1790
1791
1792--
1793-- TOC entry 3630 (class 0 OID 0)
1794-- Dependencies: 2659
1795-- Name: ax_kommunalesgebiet_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1796--
1797
1798ALTER SEQUENCE ax_kommunalesgebiet_ogc_fid_seq OWNED BY ax_kommunalesgebiet.ogc_fid;
1799
1800
1801--
1802-- TOC entry 2788 (class 1259 OID 61522)
1803-- Dependencies: 3353 3354 3355 3 1087
1804-- Name: ax_kondominium; Type: TABLE; Schema: public; Owner: -
1805--
1806
1807CREATE TABLE ax_kondominium (
1808    ogc_fid integer NOT NULL,
1809    wkb_geometry geometry,
1810    gml_id character(16),
1811    identifier character(28),
1812    beginnt character(20),
1813    advstandardmodell character(9),
1814    art character(16),
1815    name character(11),
1816    CONSTRAINT enforce_dims_wkb_geometry CHECK ((st_ndims(wkb_geometry) = 2)),
1817    CONSTRAINT enforce_geotype_wkb_geometry CHECK (((geometrytype(wkb_geometry) = 'POLYGON'::text) OR (wkb_geometry IS NULL))),
1818    CONSTRAINT enforce_srid_wkb_geometry CHECK ((st_srid(wkb_geometry) = 25832))
1819);
1820
1821
1822--
1823-- TOC entry 2787 (class 1259 OID 61520)
1824-- Dependencies: 2788 3
1825-- Name: ax_kondominium_ogc_fid_seq; Type: SEQUENCE; Schema: public; Owner: -
1826--
1827
1828CREATE SEQUENCE ax_kondominium_ogc_fid_seq
1829    START WITH 1
1830    INCREMENT BY 1
1831    NO MAXVALUE
1832    NO MINVALUE
1833    CACHE 1;
1834
1835
1836--
1837-- TOC entry 3631 (class 0 OID 0)
1838-- Dependencies: 2787
1839-- Name: ax_kondominium_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1840--
1841
1842ALTER SEQUENCE ax_kondominium_ogc_fid_seq OWNED BY ax_kondominium.ogc_fid;
1843
1844
1845--
1846-- TOC entry 2662 (class 1259 OID 29815)
1847-- Dependencies: 3115 3116 3117 3 1087
1848-- Name: ax_landwirtschaft; Type: TABLE; Schema: public; Owner: -
1849--
1850
1851CREATE TABLE ax_landwirtschaft (
1852    ogc_fid integer NOT NULL,
1853    wkb_geometry geometry,
1854    gml_id character(16),
1855    identifier character(28),
1856    beginnt character(20),
1857    advstandardmodell character varying[],
1858    art character(16),
1859    name character(11),
1860    vegetationsmerkmal integer,
1861    CONSTRAINT enforce_dims_wkb_geometry CHECK ((st_ndims(wkb_geometry) = 2)),
1862    CONSTRAINT enforce_geotype_wkb_geometry CHECK (((geometrytype(wkb_geometry) = 'POLYGON'::text) OR (wkb_geometry IS NULL))),
1863    CONSTRAINT enforce_srid_wkb_geometry CHECK ((st_srid(wkb_geometry) = 25832))
1864);
1865
1866
1867--
1868-- TOC entry 2661 (class 1259 OID 29813)
1869-- Dependencies: 3 2662
1870-- Name: ax_landwirtschaft_ogc_fid_seq; Type: SEQUENCE; Schema: public; Owner: -
1871--
1872
1873CREATE SEQUENCE ax_landwirtschaft_ogc_fid_seq
1874    START WITH 1
1875    INCREMENT BY 1
1876    NO MAXVALUE
1877    NO MINVALUE
1878    CACHE 1;
1879
1880
1881--
1882-- TOC entry 3632 (class 0 OID 0)
1883-- Dependencies: 2661
1884-- Name: ax_landwirtschaft_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1885--
1886
1887ALTER SEQUENCE ax_landwirtschaft_ogc_fid_seq OWNED BY ax_landwirtschaft.ogc_fid;
1888
1889
1890--
1891-- TOC entry 2750 (class 1259 OID 30811)
1892-- Dependencies: 3280 3281 3282 3 1087
1893-- Name: ax_leitung; Type: TABLE; Schema: public; Owner: -
1894--
1895
1896CREATE TABLE ax_leitung (
1897    ogc_fid integer NOT NULL,
1898    wkb_geometry geometry,
1899    gml_id character(16),
1900    identifier character(28),
1901    beginnt character(20),
1902    advstandardmodell character varying[],
1903    art character(16),
1904    name character(11),
1905    bauwerksfunktion integer,
1906    CONSTRAINT enforce_dims_wkb_geometry CHECK ((st_ndims(wkb_geometry) = 2)),
1907    CONSTRAINT enforce_geotype_wkb_geometry CHECK (((geometrytype(wkb_geometry) = 'LINESTRING'::text) OR (wkb_geometry IS NULL))),
1908    CONSTRAINT enforce_srid_wkb_geometry CHECK ((st_srid(wkb_geometry) = 25832))
1909);
1910
1911
1912--
1913-- TOC entry 2749 (class 1259 OID 30809)
1914-- Dependencies: 2750 3
1915-- Name: ax_leitung_ogc_fid_seq; Type: SEQUENCE; Schema: public; Owner: -
1916--
1917
1918CREATE SEQUENCE ax_leitung_ogc_fid_seq
1919    START WITH 1
1920    INCREMENT BY 1
1921    NO MAXVALUE
1922    NO MINVALUE
1923    CACHE 1;
1924
1925
1926--
1927-- TOC entry 3633 (class 0 OID 0)
1928-- Dependencies: 2749
1929-- Name: ax_leitung_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1930--
1931
1932ALTER SEQUENCE ax_leitung_ogc_fid_seq OWNED BY ax_leitung.ogc_fid;
1933
1934
1935--
1936-- TOC entry 2786 (class 1259 OID 51734)
1937-- Dependencies: 3349 3350 3351 3 1087
1938-- Name: ax_moor; Type: TABLE; Schema: public; Owner: -
1939--
1940
1941CREATE TABLE ax_moor (
1942    ogc_fid integer NOT NULL,
1943    wkb_geometry geometry,
1944    gml_id character(16),
1945    identifier character(28),
1946    beginnt character(20),
1947    advstandardmodell character varying[],
1948    art character(16),
1949    name character(11),
1950    CONSTRAINT enforce_dims_wkb_geometry CHECK ((st_ndims(wkb_geometry) = 2)),
1951    CONSTRAINT enforce_geotype_wkb_geometry CHECK (((geometrytype(wkb_geometry) = 'POLYGON'::text) OR (wkb_geometry IS NULL))),
1952    CONSTRAINT enforce_srid_wkb_geometry CHECK ((st_srid(wkb_geometry) = 25832))
1953);
1954
1955
1956--
1957-- TOC entry 2785 (class 1259 OID 51732)
1958-- Dependencies: 3 2786
1959-- Name: ax_moor_ogc_fid_seq; Type: SEQUENCE; Schema: public; Owner: -
1960--
1961
1962CREATE SEQUENCE ax_moor_ogc_fid_seq
1963    START WITH 1
1964    INCREMENT BY 1
1965    NO MAXVALUE
1966    NO MINVALUE
1967    CACHE 1;
1968
1969
1970--
1971-- TOC entry 3634 (class 0 OID 0)
1972-- Dependencies: 2785
1973-- Name: ax_moor_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1974--
1975
1976ALTER SEQUENCE ax_moor_ogc_fid_seq OWNED BY ax_moor.ogc_fid;
1977
1978
1979--
1980-- TOC entry 2664 (class 1259 OID 29835)
1981-- Dependencies: 3119 3120 3121 1087 3
1982-- Name: ax_naturumweltoderbodenschutzrecht; Type: TABLE; Schema: public; Owner: -
1983--
1984
1985CREATE TABLE ax_naturumweltoderbodenschutzrecht (
1986    ogc_fid integer NOT NULL,
1987    wkb_geometry geometry,
1988    gml_id character(16),
1989    identifier character(28),
1990    beginnt character(20),
1991    advstandardmodell character varying[],
1992    art character(16),
1993    name character(11),
1994    artderfestlegung integer,
1995    name_ character(200), --15
1996    CONSTRAINT enforce_dims_wkb_geometry CHECK ((st_ndims(wkb_geometry) = 2)),
1997    --CONSTRAINT enforce_geotype_wkb_geometry CHECK (((geometrytype(wkb_geometry) = 'POLYGON'::text) OR (wkb_geometry IS NULL))),
1998    CONSTRAINT enforce_srid_wkb_geometry CHECK ((st_srid(wkb_geometry) = 25832))
1999);
2000
2001
2002--
2003-- TOC entry 2663 (class 1259 OID 29833)
2004-- Dependencies: 2664 3
2005-- Name: ax_naturumweltoderbodenschutzrecht_ogc_fid_seq; Type: SEQUENCE; Schema: public; Owner: -
2006--
2007
2008CREATE SEQUENCE ax_naturumweltoderbodenschutzrecht_ogc_fid_seq
2009    START WITH 1
2010    INCREMENT BY 1
2011    NO MAXVALUE
2012    NO MINVALUE
2013    CACHE 1;
2014
2015
2016--
2017-- TOC entry 3635 (class 0 OID 0)
2018-- Dependencies: 2663
2019-- Name: ax_naturumweltoderbodenschutzrecht_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2020--
2021
2022ALTER SEQUENCE ax_naturumweltoderbodenschutzrecht_ogc_fid_seq OWNED BY ax_naturumweltoderbodenschutzrecht.ogc_fid;
2023
2024
2025--
2026-- TOC entry 2730 (class 1259 OID 30544)
2027-- Dependencies: 3
2028-- Name: ax_netzknoten; Type: TABLE; Schema: public; Owner: -
2029--
2030
2031CREATE TABLE ax_netzknoten (
2032    ogc_fid integer NOT NULL,
2033    gml_id character(16),
2034    identifier character(28),
2035    beginnt character(20),
2036    advstandardmodell character(9),
2037    art character(16),
2038    name character(7),
2039    bezeichnung integer
2040);
2041
2042
2043--
2044-- TOC entry 2729 (class 1259 OID 30542)
2045-- Dependencies: 2730 3
2046-- Name: ax_netzknoten_ogc_fid_seq; Type: SEQUENCE; Schema: public; Owner: -
2047--
2048
2049CREATE SEQUENCE ax_netzknoten_ogc_fid_seq
2050    START WITH 1
2051    INCREMENT BY 1
2052    NO MAXVALUE
2053    NO MINVALUE
2054    CACHE 1;
2055
2056
2057--
2058-- TOC entry 3636 (class 0 OID 0)
2059-- Dependencies: 2729
2060-- Name: ax_netzknoten_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2061--
2062
2063ALTER SEQUENCE ax_netzknoten_ogc_fid_seq OWNED BY ax_netzknoten.ogc_fid;
2064
2065
2066--
2067-- TOC entry 2704 (class 1259 OID 30313)
2068-- Dependencies: 3195 3196 3197 3 1087
2069-- Name: ax_nullpunkt; Type: TABLE; Schema: public; Owner: -
2070--
2071
2072CREATE TABLE ax_nullpunkt (
2073    ogc_fid integer NOT NULL,
2074    wkb_geometry geometry,
2075    gml_id character(16),
2076    identifier character(28),
2077    beginnt character(20),
2078    advstandardmodell character(9),
2079    art character(16),
2080    name character(11),
2081    istteilvon character varying,
2082    artdesnullpunktes integer,
2083    bezeichnung character(200), --8
2084    CONSTRAINT enforce_dims_wkb_geometry CHECK ((st_ndims(wkb_geometry) = 2)),
2085    CONSTRAINT enforce_geotype_wkb_geometry CHECK (((geometrytype(wkb_geometry) = 'POINT'::text) OR (wkb_geometry IS NULL))),
2086    CONSTRAINT enforce_srid_wkb_geometry CHECK ((st_srid(wkb_geometry) = 25832))
2087);
2088
2089
2090--
2091-- TOC entry 2703 (class 1259 OID 30311)
2092-- Dependencies: 3 2704
2093-- Name: ax_nullpunkt_ogc_fid_seq; Type: SEQUENCE; Schema: public; Owner: -
2094--
2095
2096CREATE SEQUENCE ax_nullpunkt_ogc_fid_seq
2097    START WITH 1
2098    INCREMENT BY 1
2099    NO MAXVALUE
2100    NO MINVALUE
2101    CACHE 1;
2102
2103
2104--
2105-- TOC entry 3637 (class 0 OID 0)
2106-- Dependencies: 2703
2107-- Name: ax_nullpunkt_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2108--
2109
2110ALTER SEQUENCE ax_nullpunkt_ogc_fid_seq OWNED BY ax_nullpunkt.ogc_fid;
2111
2112
2113--
2114-- TOC entry 2700 (class 1259 OID 30279)
2115-- Dependencies: 3187 3188 3189 1087 3
2116-- Name: ax_ortslage; Type: TABLE; Schema: public; Owner: -
2117--
2118
2119CREATE TABLE ax_ortslage (
2120    ogc_fid integer NOT NULL,
2121    wkb_geometry geometry,
2122    gml_id character(16),
2123    identifier character(28),
2124    beginnt character(20),
2125    advstandardmodell character(9),
2126    art character(16),
2127    name character(11),
2128    name_ character(200), --13
2129    CONSTRAINT enforce_dims_wkb_geometry CHECK ((st_ndims(wkb_geometry) = 2)),
2130    CONSTRAINT enforce_geotype_wkb_geometry CHECK (((geometrytype(wkb_geometry) = 'POLYGON'::text) OR (wkb_geometry IS NULL))),
2131    CONSTRAINT enforce_srid_wkb_geometry CHECK ((st_srid(wkb_geometry) = 25832))
2132);
2133
2134
2135--
2136-- TOC entry 2699 (class 1259 OID 30277)
2137-- Dependencies: 2700 3
2138-- Name: ax_ortslage_ogc_fid_seq; Type: SEQUENCE; Schema: public; Owner: -
2139--
2140
2141CREATE SEQUENCE ax_ortslage_ogc_fid_seq
2142    START WITH 1
2143    INCREMENT BY 1
2144    NO MAXVALUE
2145    NO MINVALUE
2146    CACHE 1;
2147
2148
2149--
2150-- TOC entry 3638 (class 0 OID 0)
2151-- Dependencies: 2699
2152-- Name: ax_ortslage_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2153--
2154
2155ALTER SEQUENCE ax_ortslage_ogc_fid_seq OWNED BY ax_ortslage.ogc_fid;
2156
2157
2158--
2159-- TOC entry 2698 (class 1259 OID 30263)
2160-- Dependencies: 3183 3184 3185 1087 3
2161-- Name: ax_platz; Type: TABLE; Schema: public; Owner: -
2162--
2163
2164CREATE TABLE ax_platz (
2165    ogc_fid integer NOT NULL,
2166    wkb_geometry geometry,
2167    gml_id character(16),
2168    identifier character(28),
2169    beginnt character(20),
2170    advstandardmodell character varying[],
2171    art character(16),
2172    name character(11),
2173    funktion integer,
2174    CONSTRAINT enforce_dims_wkb_geometry CHECK ((st_ndims(wkb_geometry) = 2)),
2175    CONSTRAINT enforce_geotype_wkb_geometry CHECK (((geometrytype(wkb_geometry) = 'POLYGON'::text) OR (wkb_geometry IS NULL))),
2176    CONSTRAINT enforce_srid_wkb_geometry CHECK ((st_srid(wkb_geometry) = 25832))
2177);
2178
2179
2180--
2181-- TOC entry 2697 (class 1259 OID 30261)
2182-- Dependencies: 3 2698
2183-- Name: ax_platz_ogc_fid_seq; Type: SEQUENCE; Schema: public; Owner: -
2184--
2185
2186CREATE SEQUENCE ax_platz_ogc_fid_seq
2187    START WITH 1
2188    INCREMENT BY 1
2189    NO MAXVALUE
2190    NO MINVALUE
2191    CACHE 1;
2192
2193
2194--
2195-- TOC entry 3639 (class 0 OID 0)
2196-- Dependencies: 2697
2197-- Name: ax_platz_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2198--
2199
2200ALTER SEQUENCE ax_platz_ogc_fid_seq OWNED BY ax_platz.ogc_fid;
2201
2202
2203--
2204-- TOC entry 2752 (class 1259 OID 30842)
2205-- Dependencies: 3284 3285 3286 3 1087
2206-- Name: ax_schifffahrtsliniefaehrverkehr; Type: TABLE; Schema: public; Owner: -
2207--
2208
2209CREATE TABLE ax_schifffahrtsliniefaehrverkehr (
2210    ogc_fid integer NOT NULL,
2211    wkb_geometry geometry,
2212    gml_id character(16),
2213    identifier character(28),
2214    beginnt character(20),
2215    advstandardmodell character varying[],
2216    art character(16),
2217    name character(11),
2218    art_ integer,
2219    CONSTRAINT enforce_dims_wkb_geometry CHECK ((st_ndims(wkb_geometry) = 2)),
2220    CONSTRAINT enforce_geotype_wkb_geometry CHECK (((geometrytype(wkb_geometry) = 'LINESTRING'::text) OR (wkb_geometry IS NULL))),
2221    CONSTRAINT enforce_srid_wkb_geometry CHECK ((st_srid(wkb_geometry) = 25832))
2222);
2223
2224
2225--
2226-- TOC entry 2751 (class 1259 OID 30840)
2227-- Dependencies: 2752 3
2228-- Name: ax_schifffahrtsliniefaehrverkehr_ogc_fid_seq; Type: SEQUENCE; Schema: public; Owner: -
2229--
2230
2231CREATE SEQUENCE ax_schifffahrtsliniefaehrverkehr_ogc_fid_seq
2232    START WITH 1
2233    INCREMENT BY 1
2234    NO MAXVALUE
2235    NO MINVALUE
2236    CACHE 1;
2237
2238
2239--
2240-- TOC entry 3640 (class 0 OID 0)
2241-- Dependencies: 2751
2242-- Name: ax_schifffahrtsliniefaehrverkehr_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2243--
2244
2245ALTER SEQUENCE ax_schifffahrtsliniefaehrverkehr_ogc_fid_seq OWNED BY ax_schifffahrtsliniefaehrverkehr.ogc_fid;
2246
2247
2248--
2249-- TOC entry 2776 (class 1259 OID 33862)
2250-- Dependencies: 3329 3330 3331 3 1087
2251-- Name: ax_schiffsverkehr; Type: TABLE; Schema: public; Owner: -
2252--
2253
2254CREATE TABLE ax_schiffsverkehr (
2255    ogc_fid integer NOT NULL,
2256    wkb_geometry geometry,
2257    gml_id character(16),
2258    identifier character(28),
2259    beginnt character(20),
2260    advstandardmodell character varying[],
2261    funktion integer,
2262    CONSTRAINT enforce_dims_wkb_geometry CHECK ((st_ndims(wkb_geometry) = 2)),
2263    CONSTRAINT enforce_geotype_wkb_geometry CHECK (((geometrytype(wkb_geometry) = 'POLYGON'::text) OR (wkb_geometry IS NULL))),
2264    CONSTRAINT enforce_srid_wkb_geometry CHECK ((st_srid(wkb_geometry) = 25832))
2265);
2266
2267
2268--
2269-- TOC entry 2775 (class 1259 OID 33860)
2270-- Dependencies: 3 2776
2271-- Name: ax_schiffsverkehr_ogc_fid_seq; Type: SEQUENCE; Schema: public; Owner: -
2272--
2273
2274CREATE SEQUENCE ax_schiffsverkehr_ogc_fid_seq
2275    START WITH 1
2276    INCREMENT BY 1
2277    NO MAXVALUE
2278    NO MINVALUE
2279    CACHE 1;
2280
2281
2282--
2283-- TOC entry 3641 (class 0 OID 0)
2284-- Dependencies: 2775
2285-- Name: ax_schiffsverkehr_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2286--
2287
2288ALTER SEQUENCE ax_schiffsverkehr_ogc_fid_seq OWNED BY ax_schiffsverkehr.ogc_fid;
2289
2290
2291--
2292-- TOC entry 2790 (class 1259 OID 61541)
2293-- Dependencies: 3357 3358 3359 3 1087
2294-- Name: ax_schleuse; Type: TABLE; Schema: public; Owner: -
2295--
2296
2297CREATE TABLE ax_schleuse (
2298    ogc_fid integer NOT NULL,
2299    wkb_geometry geometry,
2300    gml_id character(16),
2301    identifier character(28),
2302    beginnt character(20),
2303    advstandardmodell character varying[],
2304    art character(16),
2305    name character(11),
2306    konstruktionsmerkmalbauart integer,
2307    CONSTRAINT enforce_dims_wkb_geometry CHECK ((st_ndims(wkb_geometry) = 2)),
2308    CONSTRAINT enforce_geotype_wkb_geometry CHECK (((geometrytype(wkb_geometry) = 'POLYGON'::text) OR (wkb_geometry IS NULL))),
2309    CONSTRAINT enforce_srid_wkb_geometry CHECK ((st_srid(wkb_geometry) = 25832))
2310);
2311
2312
2313--
2314-- TOC entry 2789 (class 1259 OID 61539)
2315-- Dependencies: 2790 3
2316-- Name: ax_schleuse_ogc_fid_seq; Type: SEQUENCE; Schema: public; Owner: -
2317--
2318
2319CREATE SEQUENCE ax_schleuse_ogc_fid_seq
2320    START WITH 1
2321    INCREMENT BY 1
2322    NO MAXVALUE
2323    NO MINVALUE
2324    CACHE 1;
2325
2326
2327--
2328-- TOC entry 3642 (class 0 OID 0)
2329-- Dependencies: 2789
2330-- Name: ax_schleuse_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2331--
2332
2333ALTER SEQUENCE ax_schleuse_ogc_fid_seq OWNED BY ax_schleuse.ogc_fid;
2334
2335
2336--
2337-- TOC entry 2782 (class 1259 OID 40021)
2338-- Dependencies: 3341 3342 3343 3 1087
2339-- Name: ax_seilbahnschwebebahn; Type: TABLE; Schema: public; Owner: -
2340--
2341
2342CREATE TABLE ax_seilbahnschwebebahn (
2343    ogc_fid integer NOT NULL,
2344    wkb_geometry geometry,
2345    gml_id character(16),
2346    identifier character(28),
2347    beginnt character(20),
2348    advstandardmodell character varying[],
2349    art character(16),
2350    name character(11),
2351    bahnkategorie integer,
2352    CONSTRAINT enforce_dims_wkb_geometry CHECK ((st_ndims(wkb_geometry) = 2)),
2353    CONSTRAINT enforce_geotype_wkb_geometry CHECK (((geometrytype(wkb_geometry) = 'LINESTRING'::text) OR (wkb_geometry IS NULL))),
2354    CONSTRAINT enforce_srid_wkb_geometry CHECK ((st_srid(wkb_geometry) = 25832))
2355);
2356
2357
2358--
2359-- TOC entry 2781 (class 1259 OID 40019)
2360-- Dependencies: 2782 3
2361-- Name: ax_seilbahnschwebebahn_ogc_fid_seq; Type: SEQUENCE; Schema: public; Owner: -
2362--
2363
2364CREATE SEQUENCE ax_seilbahnschwebebahn_ogc_fid_seq
2365    START WITH 1
2366    INCREMENT BY 1
2367    NO MAXVALUE
2368    NO MINVALUE
2369    CACHE 1;
2370
2371
2372--
2373-- TOC entry 3643 (class 0 OID 0)
2374-- Dependencies: 2781
2375-- Name: ax_seilbahnschwebebahn_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2376--
2377
2378ALTER SEQUENCE ax_seilbahnschwebebahn_ogc_fid_seq OWNED BY ax_seilbahnschwebebahn.ogc_fid;
2379
2380
2381--
2382-- TOC entry 2702 (class 1259 OID 30297)
2383-- Dependencies: 3191 3192 3193 1087 3
2384-- Name: ax_sonstigesbauwerkodersonstigeeinrichtung; Type: TABLE; Schema: public; Owner: -
2385--
2386
2387CREATE TABLE ax_sonstigesbauwerkodersonstigeeinrichtung (
2388    ogc_fid integer NOT NULL,
2389    wkb_geometry geometry,
2390    gml_id character(16),
2391    identifier character(28),
2392    beginnt character(20),
2393    advstandardmodell character varying[],
2394    art character(16),
2395    name character(11),
2396    bauwerksfunktion integer,
2397    name_ character(200), --13
2398    CONSTRAINT enforce_dims_wkb_geometry CHECK ((st_ndims(wkb_geometry) = 2)),
2399    --CONSTRAINT enforce_geotype_wkb_geometry CHECK (((geometrytype(wkb_geometry) = 'POINT'::text) OR (wkb_geometry IS NULL))),
2400    CONSTRAINT enforce_srid_wkb_geometry CHECK ((st_srid(wkb_geometry) = 25832))
2401);
2402
2403
2404--
2405-- TOC entry 2701 (class 1259 OID 30295)
2406-- Dependencies: 3 2702
2407-- Name: ax_sonstigesbauwerkodersonstigeeinrichtung_ogc_fid_seq; Type: SEQUENCE; Schema: public; Owner: -
2408--
2409
2410CREATE SEQUENCE ax_sonstigesbauwerkodersonstigeeinrichtung_ogc_fid_seq
2411    START WITH 1
2412    INCREMENT BY 1
2413    NO MAXVALUE
2414    NO MINVALUE
2415    CACHE 1;
2416
2417
2418--
2419-- TOC entry 3644 (class 0 OID 0)
2420-- Dependencies: 2701
2421-- Name: ax_sonstigesbauwerkodersonstigeeinrichtung_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2422--
2423
2424ALTER SEQUENCE ax_sonstigesbauwerkodersonstigeeinrichtung_ogc_fid_seq OWNED BY ax_sonstigesbauwerkodersonstigeeinrichtung.ogc_fid;
2425
2426
2427--
2428-- TOC entry 2784 (class 1259 OID 40092)
2429-- Dependencies: 3345 3346 3347 3 1087
2430-- Name: ax_sonstigesrecht; Type: TABLE; Schema: public; Owner: -
2431--
2432
2433CREATE TABLE ax_sonstigesrecht (
2434    ogc_fid integer NOT NULL,
2435    wkb_geometry geometry,
2436    gml_id character(16),
2437    identifier character(28),
2438    beginnt character(20),
2439    advstandardmodell character varying[],
2440    art character(16),
2441    name character(11),
2442    artderfestlegung integer,
2443    name_ character(200), --12
2444    CONSTRAINT enforce_dims_wkb_geometry CHECK ((st_ndims(wkb_geometry) = 2)),
2445    CONSTRAINT enforce_geotype_wkb_geometry CHECK (((geometrytype(wkb_geometry) = 'POLYGON'::text) OR (wkb_geometry IS NULL))),
2446    CONSTRAINT enforce_srid_wkb_geometry CHECK ((st_srid(wkb_geometry) = 25832))
2447);
2448
2449
2450--
2451-- TOC entry 2783 (class 1259 OID 40090)
2452-- Dependencies: 3 2784
2453-- Name: ax_sonstigesrecht_ogc_fid_seq; Type: SEQUENCE; Schema: public; Owner: -
2454--
2455
2456CREATE SEQUENCE ax_sonstigesrecht_ogc_fid_seq
2457    START WITH 1
2458    INCREMENT BY 1
2459    NO MAXVALUE
2460    NO MINVALUE
2461    CACHE 1;
2462
2463
2464--
2465-- TOC entry 3645 (class 0 OID 0)
2466-- Dependencies: 2783
2467-- Name: ax_sonstigesrecht_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2468--
2469
2470ALTER SEQUENCE ax_sonstigesrecht_ogc_fid_seq OWNED BY ax_sonstigesrecht.ogc_fid;
2471
2472
2473--
2474-- TOC entry 2706 (class 1259 OID 30329)
2475-- Dependencies: 3199 3200 3201 1087 3
2476-- Name: ax_sportfreizeitunderholungsflaeche; Type: TABLE; Schema: public; Owner: -
2477--
2478
2479CREATE TABLE ax_sportfreizeitunderholungsflaeche (
2480    ogc_fid integer NOT NULL,
2481    wkb_geometry geometry,
2482    gml_id character(16),
2483    identifier character(28),
2484    beginnt character(20),
2485    advstandardmodell character varying[],
2486    art character(16),
2487    name character(11),
2488    funktion integer,
2489    CONSTRAINT enforce_dims_wkb_geometry CHECK ((st_ndims(wkb_geometry) = 2)),
2490    CONSTRAINT enforce_geotype_wkb_geometry CHECK (((geometrytype(wkb_geometry) = 'POLYGON'::text) OR (wkb_geometry IS NULL))),
2491    CONSTRAINT enforce_srid_wkb_geometry CHECK ((st_srid(wkb_geometry) = 25832))
2492);
2493
2494
2495--
2496-- TOC entry 2705 (class 1259 OID 30327)
2497-- Dependencies: 3 2706
2498-- Name: ax_sportfreizeitunderholungsflaeche_ogc_fid_seq; Type: SEQUENCE; Schema: public; Owner: -
2499--
2500
2501CREATE SEQUENCE ax_sportfreizeitunderholungsflaeche_ogc_fid_seq
2502    START WITH 1
2503    INCREMENT BY 1
2504    NO MAXVALUE
2505    NO MINVALUE
2506    CACHE 1;
2507
2508
2509--
2510-- TOC entry 3646 (class 0 OID 0)
2511-- Dependencies: 2705
2512-- Name: ax_sportfreizeitunderholungsflaeche_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2513--
2514
2515ALTER SEQUENCE ax_sportfreizeitunderholungsflaeche_ogc_fid_seq OWNED BY ax_sportfreizeitunderholungsflaeche.ogc_fid;
2516
2517
2518--
2519-- TOC entry 2708 (class 1259 OID 30345)
2520-- Dependencies: 3203 3204 3205 1087 3
2521-- Name: ax_stehendesgewaesser; Type: TABLE; Schema: public; Owner: -
2522--
2523
2524CREATE TABLE ax_stehendesgewaesser (
2525    ogc_fid integer NOT NULL,
2526    wkb_geometry geometry,
2527    gml_id character(16),
2528    identifier character(28),
2529    beginnt character(20),
2530    advstandardmodell character varying[],
2531    art character(16),
2532    name character(11),
2533    CONSTRAINT enforce_dims_wkb_geometry CHECK ((st_ndims(wkb_geometry) = 2)),
2534    CONSTRAINT enforce_geotype_wkb_geometry CHECK (((geometrytype(wkb_geometry) = 'POLYGON'::text) OR (wkb_geometry IS NULL))),
2535    CONSTRAINT enforce_srid_wkb_geometry CHECK ((st_srid(wkb_geometry) = 25832))
2536);
2537
2538
2539--
2540-- TOC entry 2707 (class 1259 OID 30343)
2541-- Dependencies: 3 2708
2542-- Name: ax_stehendesgewaesser_ogc_fid_seq; Type: SEQUENCE; Schema: public; Owner: -
2543--
2544
2545CREATE SEQUENCE ax_stehendesgewaesser_ogc_fid_seq
2546    START WITH 1
2547    INCREMENT BY 1
2548    NO MAXVALUE
2549    NO MINVALUE
2550    CACHE 1;
2551
2552
2553--
2554-- TOC entry 3647 (class 0 OID 0)
2555-- Dependencies: 2707
2556-- Name: ax_stehendesgewaesser_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2557--
2558
2559ALTER SEQUENCE ax_stehendesgewaesser_ogc_fid_seq OWNED BY ax_stehendesgewaesser.ogc_fid;
2560
2561
2562--
2563-- TOC entry 2728 (class 1259 OID 30533)
2564-- Dependencies: 3
2565-- Name: ax_strasse; Type: TABLE; Schema: public; Owner: -
2566--
2567
2568CREATE TABLE ax_strasse (
2569    ogc_fid integer NOT NULL,
2570    gml_id character(16),
2571    identifier character(28),
2572    beginnt character(20),
2573    advstandardmodell character varying[],
2574    art character varying[],
2575    name character varying[],
2576    name_ character(200), --19
2577    widmung integer,
2578    strassenschluessel double precision,
2579    bezeichnung character(200), --4
2580    fahrbahntrennung integer
2581);
2582
2583
2584--
2585-- TOC entry 2727 (class 1259 OID 30531)
2586-- Dependencies: 2728 3
2587-- Name: ax_strasse_ogc_fid_seq; Type: SEQUENCE; Schema: public; Owner: -
2588--
2589
2590CREATE SEQUENCE ax_strasse_ogc_fid_seq
2591    START WITH 1
2592    INCREMENT BY 1
2593    NO MAXVALUE
2594    NO MINVALUE
2595    CACHE 1;
2596
2597
2598--
2599-- TOC entry 3648 (class 0 OID 0)
2600-- Dependencies: 2727
2601-- Name: ax_strasse_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2602--
2603
2604ALTER SEQUENCE ax_strasse_ogc_fid_seq OWNED BY ax_strasse.ogc_fid;
2605
2606
2607--
2608-- TOC entry 2710 (class 1259 OID 30361)
2609-- Dependencies: 3207 3208 3209 1087 3
2610-- Name: ax_strassenachse; Type: TABLE; Schema: public; Owner: -
2611--
2612
2613CREATE TABLE ax_strassenachse (
2614    ogc_fid integer NOT NULL,
2615    wkb_geometry geometry,
2616    gml_id character(16),
2617    identifier character(28),
2618    beginnt character(20),
2619    advstandardmodell character varying[],
2620    art character(16),
2621    name character(11),
2622    istteilvon character varying,
2623    hatdirektunten character varying,
2624    breitederfahrbahn double precision,
2625    anzahlderfahrstreifen integer,
2626    verkehrsbedeutunginneroertlich integer,
2627    CONSTRAINT enforce_dims_wkb_geometry CHECK ((st_ndims(wkb_geometry) = 2)),
2628    CONSTRAINT enforce_geotype_wkb_geometry CHECK (((geometrytype(wkb_geometry) = 'LINESTRING'::text) OR (wkb_geometry IS NULL))),
2629    CONSTRAINT enforce_srid_wkb_geometry CHECK ((st_srid(wkb_geometry) = 25832))
2630);
2631
2632
2633--
2634-- TOC entry 2709 (class 1259 OID 30359)
2635-- Dependencies: 2710 3
2636-- Name: ax_strassenachse_ogc_fid_seq; Type: SEQUENCE; Schema: public; Owner: -
2637--
2638
2639CREATE SEQUENCE ax_strassenachse_ogc_fid_seq
2640    START WITH 1
2641    INCREMENT BY 1
2642    NO MAXVALUE
2643    NO MINVALUE
2644    CACHE 1;
2645
2646
2647--
2648-- TOC entry 3649 (class 0 OID 0)
2649-- Dependencies: 2709
2650-- Name: ax_strassenachse_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2651--
2652
2653ALTER SEQUENCE ax_strassenachse_ogc_fid_seq OWNED BY ax_strassenachse.ogc_fid;
2654
2655
2656--
2657-- TOC entry 2712 (class 1259 OID 30377)
2658-- Dependencies: 3211 3212 3213 1087 3
2659-- Name: ax_strassenverkehr; Type: TABLE; Schema: public; Owner: -
2660--
2661
2662CREATE TABLE ax_strassenverkehr (
2663    ogc_fid integer NOT NULL,
2664    wkb_geometry geometry,
2665    gml_id character(16),
2666    identifier character(28),
2667    beginnt character(20),
2668    advstandardmodell character varying[],
2669    art character(16),
2670    name character(11),
2671    funktion integer,
2672    hatdirektunten character varying,
2673    CONSTRAINT enforce_dims_wkb_geometry CHECK ((st_ndims(wkb_geometry) = 2)),
2674    --CONSTRAINT enforce_geotype_wkb_geometry CHECK (((geometrytype(wkb_geometry) = 'POLYGON'::text) OR (wkb_geometry IS NULL))),
2675    CONSTRAINT enforce_srid_wkb_geometry CHECK ((st_srid(wkb_geometry) = 25832))
2676);
2677
2678
2679--
2680-- TOC entry 2711 (class 1259 OID 30375)
2681-- Dependencies: 3 2712
2682-- Name: ax_strassenverkehr_ogc_fid_seq; Type: SEQUENCE; Schema: public; Owner: -
2683--
2684
2685CREATE SEQUENCE ax_strassenverkehr_ogc_fid_seq
2686    START WITH 1
2687    INCREMENT BY 1
2688    NO MAXVALUE
2689    NO MINVALUE
2690    CACHE 1;
2691
2692
2693--
2694-- TOC entry 3650 (class 0 OID 0)
2695-- Dependencies: 2711
2696-- Name: ax_strassenverkehr_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2697--
2698
2699ALTER SEQUENCE ax_strassenverkehr_ogc_fid_seq OWNED BY ax_strassenverkehr.ogc_fid;
2700
2701
2702--
2703-- TOC entry 2720 (class 1259 OID 30441)
2704-- Dependencies: 3227 3228 3229 1087 3
2705-- Name: ax_strassenverkehrsanlage; Type: TABLE; Schema: public; Owner: -
2706--
2707
2708CREATE TABLE ax_strassenverkehrsanlage (
2709    ogc_fid integer NOT NULL,
2710    wkb_geometry geometry,
2711    gml_id character(16),
2712    identifier character(28),
2713    beginnt character(20),
2714    advstandardmodell character varying[],
2715    art character(16),
2716    name character(11),
2717    art_ integer,
2718    CONSTRAINT enforce_dims_wkb_geometry CHECK ((st_ndims(wkb_geometry) = 2)),
2719    --CONSTRAINT enforce_geotype_wkb_geometry CHECK (((geometrytype(wkb_geometry) = 'POINT'::text) OR (wkb_geometry IS NULL))),
2720    CONSTRAINT enforce_srid_wkb_geometry CHECK ((st_srid(wkb_geometry) = 25832))
2721);
2722
2723
2724--
2725-- TOC entry 2719 (class 1259 OID 30439)
2726-- Dependencies: 3 2720
2727-- Name: ax_strassenverkehrsanlage_ogc_fid_seq; Type: SEQUENCE; Schema: public; Owner: -
2728--
2729
2730CREATE SEQUENCE ax_strassenverkehrsanlage_ogc_fid_seq
2731    START WITH 1
2732    INCREMENT BY 1
2733    NO MAXVALUE
2734    NO MINVALUE
2735    CACHE 1;
2736
2737
2738--
2739-- TOC entry 3651 (class 0 OID 0)
2740-- Dependencies: 2719
2741-- Name: ax_strassenverkehrsanlage_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2742--
2743
2744ALTER SEQUENCE ax_strassenverkehrsanlage_ogc_fid_seq OWNED BY ax_strassenverkehrsanlage.ogc_fid;
2745
2746
2747--
2748-- TOC entry 2778 (class 1259 OID 34082)
2749-- Dependencies: 3333 3334 3335 3 1087
2750-- Name: ax_sumpf; Type: TABLE; Schema: public; Owner: -
2751--
2752
2753CREATE TABLE ax_sumpf (
2754    ogc_fid integer NOT NULL,
2755    wkb_geometry geometry,
2756    gml_id character(16),
2757    identifier character(28),
2758    beginnt character(20),
2759    advstandardmodell character varying[],
2760    art character(16),
2761    name character(11),
2762    CONSTRAINT enforce_dims_wkb_geometry CHECK ((st_ndims(wkb_geometry) = 2)),
2763    CONSTRAINT enforce_geotype_wkb_geometry CHECK (((geometrytype(wkb_geometry) = 'POLYGON'::text) OR (wkb_geometry IS NULL))),
2764    CONSTRAINT enforce_srid_wkb_geometry CHECK ((st_srid(wkb_geometry) = 25832))
2765);
2766
2767
2768--
2769-- TOC entry 2777 (class 1259 OID 34080)
2770-- Dependencies: 3 2778
2771-- Name: ax_sumpf_ogc_fid_seq; Type: SEQUENCE; Schema: public; Owner: -
2772--
2773
2774CREATE SEQUENCE ax_sumpf_ogc_fid_seq
2775    START WITH 1
2776    INCREMENT BY 1
2777    NO MAXVALUE
2778    NO MINVALUE
2779    CACHE 1;
2780
2781
2782--
2783-- TOC entry 3652 (class 0 OID 0)
2784-- Dependencies: 2777
2785-- Name: ax_sumpf_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2786--
2787
2788ALTER SEQUENCE ax_sumpf_ogc_fid_seq OWNED BY ax_sumpf.ogc_fid;
2789
2790
2791--
2792-- TOC entry 2754 (class 1259 OID 30887)
2793-- Dependencies: 3288 3289 3290 1087 3
2794-- Name: ax_tagebaugrubesteinbruch; Type: TABLE; Schema: public; Owner: -
2795--
2796
2797CREATE TABLE ax_tagebaugrubesteinbruch (
2798    ogc_fid integer NOT NULL,
2799    wkb_geometry geometry,
2800    gml_id character(16),
2801    identifier character(28),
2802    beginnt character(20),
2803    advstandardmodell character varying[],
2804    art character(16),
2805    name character(11),
2806    CONSTRAINT enforce_dims_wkb_geometry CHECK ((st_ndims(wkb_geometry) = 2)),
2807    CONSTRAINT enforce_geotype_wkb_geometry CHECK (((geometrytype(wkb_geometry) = 'POLYGON'::text) OR (wkb_geometry IS NULL))),
2808    CONSTRAINT enforce_srid_wkb_geometry CHECK ((st_srid(wkb_geometry) = 25832))
2809);
2810
2811
2812--
2813-- TOC entry 2753 (class 1259 OID 30885)
2814-- Dependencies: 2754 3
2815-- Name: ax_tagebaugrubesteinbruch_ogc_fid_seq; Type: SEQUENCE; Schema: public; Owner: -
2816--
2817
2818CREATE SEQUENCE ax_tagebaugrubesteinbruch_ogc_fid_seq
2819    START WITH 1
2820    INCREMENT BY 1
2821    NO MAXVALUE
2822    NO MINVALUE
2823    CACHE 1;
2824
2825
2826--
2827-- TOC entry 3653 (class 0 OID 0)
2828-- Dependencies: 2753
2829-- Name: ax_tagebaugrubesteinbruch_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2830--
2831
2832ALTER SEQUENCE ax_tagebaugrubesteinbruch_ogc_fid_seq OWNED BY ax_tagebaugrubesteinbruch.ogc_fid;
2833
2834
2835--
2836-- TOC entry 2718 (class 1259 OID 30425)
2837-- Dependencies: 3223 3224 3225 3 1087
2838-- Name: ax_transportanlage; Type: TABLE; Schema: public; Owner: -
2839--
2840
2841CREATE TABLE ax_transportanlage (
2842    ogc_fid integer NOT NULL,
2843    wkb_geometry geometry,
2844    gml_id character(16),
2845    identifier character(28),
2846    beginnt character(20),
2847    advstandardmodell character varying[],
2848    art character(16),
2849    name character(11),
2850    bauwerksfunktion integer,
2851    produkt integer,
2852    CONSTRAINT enforce_dims_wkb_geometry CHECK ((st_ndims(wkb_geometry) = 2)),
2853    --CONSTRAINT enforce_geotype_wkb_geometry CHECK (((geometrytype(wkb_geometry) = 'POINT'::text) OR (wkb_geometry IS NULL))),
2854    CONSTRAINT enforce_srid_wkb_geometry CHECK ((st_srid(wkb_geometry) = 25832))
2855);
2856
2857
2858--
2859-- TOC entry 2717 (class 1259 OID 30423)
2860-- Dependencies: 3 2718
2861-- Name: ax_transportanlage_ogc_fid_seq; Type: SEQUENCE; Schema: public; Owner: -
2862--
2863
2864CREATE SEQUENCE ax_transportanlage_ogc_fid_seq
2865    START WITH 1
2866    INCREMENT BY 1
2867    NO MAXVALUE
2868    NO MINVALUE
2869    CACHE 1;
2870
2871
2872--
2873-- TOC entry 3654 (class 0 OID 0)
2874-- Dependencies: 2717
2875-- Name: ax_transportanlage_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2876--
2877
2878ALTER SEQUENCE ax_transportanlage_ogc_fid_seq OWNED BY ax_transportanlage.ogc_fid;
2879
2880
2881--
2882-- TOC entry 2716 (class 1259 OID 30409)
2883-- Dependencies: 3219 3220 3221 3 1087
2884-- Name: ax_turm; Type: TABLE; Schema: public; Owner: -
2885--
2886
2887CREATE TABLE ax_turm (
2888    ogc_fid integer NOT NULL,
2889    wkb_geometry geometry,
2890    gml_id character(16),
2891    identifier character(28),
2892    beginnt character(20),
2893    advstandardmodell character varying[],
2894    art character(16),
2895    name character(11),
2896    bauwerksfunktion integer,
2897    CONSTRAINT enforce_dims_wkb_geometry CHECK ((st_ndims(wkb_geometry) = 2)),
2898    --CONSTRAINT enforce_geotype_wkb_geometry CHECK (((geometrytype(wkb_geometry) = 'POINT'::text) OR (wkb_geometry IS NULL))),
2899    CONSTRAINT enforce_srid_wkb_geometry CHECK ((st_srid(wkb_geometry) = 25832))
2900);
2901
2902
2903--
2904-- TOC entry 2715 (class 1259 OID 30407)
2905-- Dependencies: 2716 3
2906-- Name: ax_turm_ogc_fid_seq; Type: SEQUENCE; Schema: public; Owner: -
2907--
2908
2909CREATE SEQUENCE ax_turm_ogc_fid_seq
2910    START WITH 1
2911    INCREMENT BY 1
2912    NO MAXVALUE
2913    NO MINVALUE
2914    CACHE 1;
2915
2916
2917--
2918-- TOC entry 3655 (class 0 OID 0)
2919-- Dependencies: 2715
2920-- Name: ax_turm_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2921--
2922
2923ALTER SEQUENCE ax_turm_ogc_fid_seq OWNED BY ax_turm.ogc_fid;
2924
2925
2926--
2927-- TOC entry 2714 (class 1259 OID 30393)
2928-- Dependencies: 3215 3216 3217 1087 3
2929-- Name: ax_unlandvegetationsloseflaeche; Type: TABLE; Schema: public; Owner: -
2930--
2931
2932CREATE TABLE ax_unlandvegetationsloseflaeche (
2933    ogc_fid integer NOT NULL,
2934    wkb_geometry geometry,
2935    gml_id character(16),
2936    identifier character(28),
2937    beginnt character(20),
2938    advstandardmodell character varying[],
2939    art character(16),
2940    name character(11),
2941    funktion integer,
2942    CONSTRAINT enforce_dims_wkb_geometry CHECK ((st_ndims(wkb_geometry) = 2)),
2943    CONSTRAINT enforce_geotype_wkb_geometry CHECK (((geometrytype(wkb_geometry) = 'POLYGON'::text) OR (wkb_geometry IS NULL))),
2944    CONSTRAINT enforce_srid_wkb_geometry CHECK ((st_srid(wkb_geometry) = 25832))
2945);
2946
2947
2948--
2949-- TOC entry 2713 (class 1259 OID 30391)
2950-- Dependencies: 3 2714
2951-- Name: ax_unlandvegetationsloseflaeche_ogc_fid_seq; Type: SEQUENCE; Schema: public; Owner: -
2952--
2953
2954CREATE SEQUENCE ax_unlandvegetationsloseflaeche_ogc_fid_seq
2955    START WITH 1
2956    INCREMENT BY 1
2957    NO MAXVALUE
2958    NO MINVALUE
2959    CACHE 1;
2960
2961
2962--
2963-- TOC entry 3656 (class 0 OID 0)
2964-- Dependencies: 2713
2965-- Name: ax_unlandvegetationsloseflaeche_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2966--
2967
2968ALTER SEQUENCE ax_unlandvegetationsloseflaeche_ogc_fid_seq OWNED BY ax_unlandvegetationsloseflaeche.ogc_fid;
2969
2970
2971--
2972-- TOC entry 2722 (class 1259 OID 30457)
2973-- Dependencies: 3231 3232 3 1087
2974-- Name: ax_vegetationsmerkmal; Type: TABLE; Schema: public; Owner: -
2975--
2976
2977CREATE TABLE ax_vegetationsmerkmal (
2978    ogc_fid integer NOT NULL,
2979    wkb_geometry geometry,
2980    gml_id character(16),
2981    identifier character(28),
2982    beginnt character(20),
2983    advstandardmodell character varying[],
2984    art character(16),
2985    name character(11),
2986    bewuchs integer,
2987    CONSTRAINT enforce_dims_wkb_geometry CHECK ((st_ndims(wkb_geometry) = 2)),
2988    CONSTRAINT enforce_srid_wkb_geometry CHECK ((st_srid(wkb_geometry) = 25832))
2989);
2990
2991
2992--
2993-- TOC entry 2721 (class 1259 OID 30455)
2994-- Dependencies: 3 2722
2995-- Name: ax_vegetationsmerkmal_ogc_fid_seq; Type: SEQUENCE; Schema: public; Owner: -
2996--
2997
2998CREATE SEQUENCE ax_vegetationsmerkmal_ogc_fid_seq
2999    START WITH 1
3000    INCREMENT BY 1
3001    NO MAXVALUE
3002    NO MINVALUE
3003    CACHE 1;
3004
3005
3006--
3007-- TOC entry 3657 (class 0 OID 0)
3008-- Dependencies: 2721
3009-- Name: ax_vegetationsmerkmal_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
3010--
3011
3012ALTER SEQUENCE ax_vegetationsmerkmal_ogc_fid_seq OWNED BY ax_vegetationsmerkmal.ogc_fid;
3013
3014
3015--
3016-- TOC entry 2666 (class 1259 OID 29861)
3017-- Dependencies: 3123 3124 3125 3 1087
3018-- Name: ax_wald; Type: TABLE; Schema: public; Owner: -
3019--
3020
3021CREATE TABLE ax_wald (
3022    ogc_fid integer NOT NULL,
3023    wkb_geometry geometry,
3024    gml_id character(16),
3025    identifier character(28),
3026    beginnt character(20),
3027    advstandardmodell character varying[],
3028    art character(16),
3029    name character(11),
3030    vegetationsmerkmal integer,
3031    CONSTRAINT enforce_dims_wkb_geometry CHECK ((st_ndims(wkb_geometry) = 2)),
3032    CONSTRAINT enforce_geotype_wkb_geometry CHECK (((geometrytype(wkb_geometry) = 'POLYGON'::text) OR (wkb_geometry IS NULL))),
3033    CONSTRAINT enforce_srid_wkb_geometry CHECK ((st_srid(wkb_geometry) = 25832))
3034);
3035
3036
3037--
3038-- TOC entry 2665 (class 1259 OID 29859)
3039-- Dependencies: 3 2666
3040-- Name: ax_wald_ogc_fid_seq; Type: SEQUENCE; Schema: public; Owner: -
3041--
3042
3043CREATE SEQUENCE ax_wald_ogc_fid_seq
3044    START WITH 1
3045    INCREMENT BY 1
3046    NO MAXVALUE
3047    NO MINVALUE
3048    CACHE 1;
3049
3050
3051--
3052-- TOC entry 3658 (class 0 OID 0)
3053-- Dependencies: 2665
3054-- Name: ax_wald_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
3055--
3056
3057ALTER SEQUENCE ax_wald_ogc_fid_seq OWNED BY ax_wald.ogc_fid;
3058
3059
3060--
3061-- TOC entry 2756 (class 1259 OID 30987)
3062-- Dependencies: 3
3063-- Name: ax_wasserlauf; Type: TABLE; Schema: public; Owner: -
3064--
3065
3066CREATE TABLE ax_wasserlauf (
3067    ogc_fid integer NOT NULL,
3068    gml_id character(16),
3069    identifier character(28),
3070    beginnt character(20),
3071    advstandardmodell character varying[],
3072    art character(16),
3073    name character(11),
3074    name_ character(200), --20
3075    gewaesserkennzahl double precision
3076);
3077
3078
3079--
3080-- TOC entry 2755 (class 1259 OID 30985)
3081-- Dependencies: 2756 3
3082-- Name: ax_wasserlauf_ogc_fid_seq; Type: SEQUENCE; Schema: public; Owner: -
3083--
3084
3085CREATE SEQUENCE ax_wasserlauf_ogc_fid_seq
3086    START WITH 1
3087    INCREMENT BY 1
3088    NO MAXVALUE
3089    NO MINVALUE
3090    CACHE 1;
3091
3092
3093--
3094-- TOC entry 3659 (class 0 OID 0)
3095-- Dependencies: 2755
3096-- Name: ax_wasserlauf_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
3097--
3098
3099ALTER SEQUENCE ax_wasserlauf_ogc_fid_seq OWNED BY ax_wasserlauf.ogc_fid;
3100
3101
3102--
3103-- TOC entry 2764 (class 1259 OID 32124)
3104-- Dependencies: 3305 3306 3307 3 1087
3105-- Name: ax_wasserspiegelhoehe; Type: TABLE; Schema: public; Owner: -
3106--
3107
3108CREATE TABLE ax_wasserspiegelhoehe (
3109    ogc_fid integer NOT NULL,
3110    wkb_geometry geometry,
3111    gml_id character(16),
3112    identifier character(28),
3113    beginnt character(20),
3114    advstandardmodell character varying[],
3115    art character(16),
3116    name character(11),
3117    hoehedeswasserspiegels double precision,
3118    CONSTRAINT enforce_dims_wkb_geometry CHECK ((st_ndims(wkb_geometry) = 2)),
3119    CONSTRAINT enforce_geotype_wkb_geometry CHECK (((geometrytype(wkb_geometry) = 'POINT'::text) OR (wkb_geometry IS NULL))),
3120    CONSTRAINT enforce_srid_wkb_geometry CHECK ((st_srid(wkb_geometry) = 25832))
3121);
3122
3123
3124--
3125-- TOC entry 2763 (class 1259 OID 32122)
3126-- Dependencies: 3 2764
3127-- Name: ax_wasserspiegelhoehe_ogc_fid_seq; Type: SEQUENCE; Schema: public; Owner: -
3128--
3129
3130CREATE SEQUENCE ax_wasserspiegelhoehe_ogc_fid_seq
3131    START WITH 1
3132    INCREMENT BY 1
3133    NO MAXVALUE
3134    NO MINVALUE
3135    CACHE 1;
3136
3137
3138--
3139-- TOC entry 3660 (class 0 OID 0)
3140-- Dependencies: 2763
3141-- Name: ax_wasserspiegelhoehe_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
3142--
3143
3144ALTER SEQUENCE ax_wasserspiegelhoehe_ogc_fid_seq OWNED BY ax_wasserspiegelhoehe.ogc_fid;
3145
3146
3147--
3148-- TOC entry 2668 (class 1259 OID 29883)
3149-- Dependencies: 3127 3128 3129 3 1087
3150-- Name: ax_wegpfadsteig; Type: TABLE; Schema: public; Owner: -
3151--
3152
3153CREATE TABLE ax_wegpfadsteig (
3154    ogc_fid integer NOT NULL,
3155    wkb_geometry geometry,
3156    gml_id character(16),
3157    identifier character(28),
3158    beginnt character(20),
3159    advstandardmodell character varying[],
3160    art character(16),
3161    name character(11),
3162    art_ integer,
3163    breitedesverkehrsweges integer,
3164    CONSTRAINT enforce_dims_wkb_geometry CHECK ((st_ndims(wkb_geometry) = 2)),
3165    CONSTRAINT enforce_geotype_wkb_geometry CHECK (((geometrytype(wkb_geometry) = 'LINESTRING'::text) OR (wkb_geometry IS NULL))),
3166    CONSTRAINT enforce_srid_wkb_geometry CHECK ((st_srid(wkb_geometry) = 25832))
3167);
3168
3169
3170--
3171-- TOC entry 2667 (class 1259 OID 29881)
3172-- Dependencies: 2668 3
3173-- Name: ax_wegpfadsteig_ogc_fid_seq; Type: SEQUENCE; Schema: public; Owner: -
3174--
3175
3176CREATE SEQUENCE ax_wegpfadsteig_ogc_fid_seq
3177    START WITH 1
3178    INCREMENT BY 1
3179    NO MAXVALUE
3180    NO MINVALUE
3181    CACHE 1;
3182
3183
3184--
3185-- TOC entry 3661 (class 0 OID 0)
3186-- Dependencies: 2667
3187-- Name: ax_wegpfadsteig_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
3188--
3189
3190ALTER SEQUENCE ax_wegpfadsteig_ogc_fid_seq OWNED BY ax_wegpfadsteig.ogc_fid;
3191
3192
3193--
3194-- TOC entry 2724 (class 1259 OID 30501)
3195-- Dependencies: 3234 3235 3236 1087 3
3196-- Name: ax_wohnbauflaeche; Type: TABLE; Schema: public; Owner: -
3197--
3198
3199CREATE TABLE ax_wohnbauflaeche (
3200    ogc_fid integer NOT NULL,
3201    wkb_geometry geometry,
3202    gml_id character(16),
3203    identifier character(28),
3204    beginnt character(20),
3205    advstandardmodell character varying[],
3206    art character(16),
3207    name character(11),
3208    artderbebauung integer,
3209    CONSTRAINT enforce_dims_wkb_geometry CHECK ((st_ndims(wkb_geometry) = 2)),
3210    CONSTRAINT enforce_geotype_wkb_geometry CHECK (((geometrytype(wkb_geometry) = 'POLYGON'::text) OR (wkb_geometry IS NULL))),
3211    CONSTRAINT enforce_srid_wkb_geometry CHECK ((st_srid(wkb_geometry) = 25832))
3212);
3213
3214
3215--
3216-- TOC entry 2723 (class 1259 OID 30499)
3217-- Dependencies: 2724 3
3218-- Name: ax_wohnbauflaeche_ogc_fid_seq; Type: SEQUENCE; Schema: public; Owner: -
3219--
3220
3221CREATE SEQUENCE ax_wohnbauflaeche_ogc_fid_seq
3222    START WITH 1
3223    INCREMENT BY 1
3224    NO MAXVALUE
3225    NO MINVALUE
3226    CACHE 1;
3227
3228
3229--
3230-- TOC entry 3662 (class 0 OID 0)
3231-- Dependencies: 2723
3232-- Name: ax_wohnbauflaeche_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
3233--
3234
3235ALTER SEQUENCE ax_wohnbauflaeche_ogc_fid_seq OWNED BY ax_wohnbauflaeche.ogc_fid;
3236
3237
3238--
3239-- TOC entry 2726 (class 1259 OID 30517)
3240-- Dependencies: 3238 3239 3240 3 1087
3241-- Name: ax_wohnplatz; Type: TABLE; Schema: public; Owner: -
3242--
3243
3244CREATE TABLE ax_wohnplatz (
3245    ogc_fid integer NOT NULL,
3246    wkb_geometry geometry,
3247    gml_id character(16),
3248    identifier character(28),
3249    beginnt character(20),
3250    advstandardmodell character varying[],
3251    art character(16),
3252    name character(11),
3253    bezeichnung double precision[],
3254    name_ character(200), --28
3255    CONSTRAINT enforce_dims_wkb_geometry CHECK ((st_ndims(wkb_geometry) = 2)),
3256    CONSTRAINT enforce_geotype_wkb_geometry CHECK (((geometrytype(wkb_geometry) = 'POINT'::text) OR (wkb_geometry IS NULL))),
3257    CONSTRAINT enforce_srid_wkb_geometry CHECK ((st_srid(wkb_geometry) = 25832))
3258);
3259
3260
3261--
3262-- TOC entry 2725 (class 1259 OID 30515)
3263-- Dependencies: 2726 3
3264-- Name: ax_wohnplatz_ogc_fid_seq; Type: SEQUENCE; Schema: public; Owner: -
3265--
3266
3267CREATE SEQUENCE ax_wohnplatz_ogc_fid_seq
3268    START WITH 1
3269    INCREMENT BY 1
3270    NO MAXVALUE
3271    NO MINVALUE
3272    CACHE 1;
3273
3274
3275--
3276-- TOC entry 3663 (class 0 OID 0)
3277-- Dependencies: 2725
3278-- Name: ax_wohnplatz_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
3279--
3280
3281ALTER SEQUENCE ax_wohnplatz_ogc_fid_seq OWNED BY ax_wohnplatz.ogc_fid;
3282
3283--
3284-- TOC entry 3130 (class 2604 OID 29902)
3285-- Dependencies: 2669 2670 2670
3286-- Name: ogc_fid; Type: DEFAULT; Schema: public; Owner: -
3287--
3288
3289ALTER TABLE alkis_beziehungen ALTER COLUMN ogc_fid SET DEFAULT nextval('alkis_beziehungen_ogc_fid_seq'::regclass);
3290
3291
3292--
3293-- TOC entry 3131 (class 2604 OID 29914)
3294-- Dependencies: 2672 2671 2672
3295-- Name: ogc_fid; Type: DEFAULT; Schema: public; Owner: -
3296--
3297
3298ALTER TABLE ax_abschnitt ALTER COLUMN ogc_fid SET DEFAULT nextval('ax_abschnitt_ogc_fid_seq'::regclass);
3299
3300
3301--
3302-- TOC entry 3135 (class 2604 OID 29930)
3303-- Dependencies: 2673 2674 2674
3304-- Name: ogc_fid; Type: DEFAULT; Schema: public; Owner: -
3305--
3306
3307ALTER TABLE ax_ast ALTER COLUMN ogc_fid SET DEFAULT nextval('ax_ast_ogc_fid_seq'::regclass);
3308
3309
3310--
3311-- TOC entry 3247 (class 2604 OID 30571)
3312-- Dependencies: 2733 2734 2734
3313-- Name: ogc_fid; Type: DEFAULT; Schema: public; Owner: -
3314--
3315
3316ALTER TABLE ax_bahnstrecke ALTER COLUMN ogc_fid SET DEFAULT nextval('ax_bahnstrecke_ogc_fid_seq'::regclass);
3317
3318
3319--
3320-- TOC entry 3316 (class 2604 OID 33472)
3321-- Dependencies: 2770 2769 2770
3322-- Name: ogc_fid; Type: DEFAULT; Schema: public; Owner: -
3323--
3324
3325ALTER TABLE ax_bahnverkehr ALTER COLUMN ogc_fid SET DEFAULT nextval('ax_bahnverkehr_ogc_fid_seq'::regclass);
3326
3327
3328--
3329-- TOC entry 3243 (class 2604 OID 30555)
3330-- Dependencies: 2732 2731 2732
3331-- Name: ogc_fid; Type: DEFAULT; Schema: public; Owner: -
3332--
3333
3334ALTER TABLE ax_bahnverkehrsanlage ALTER COLUMN ogc_fid SET DEFAULT nextval('ax_bahnverkehrsanlage_ogc_fid_seq'::regclass);
3335
3336
3337--
3338-- TOC entry 3139 (class 2604 OID 29946)
3339-- Dependencies: 2675 2676 2676
3340-- Name: ogc_fid; Type: DEFAULT; Schema: public; Owner: -
3341--
3342
3343ALTER TABLE ax_bauwerkimgewaesserbereich ALTER COLUMN ogc_fid SET DEFAULT nextval('ax_bauwerkimgewaesserbereich_ogc_fid_seq'::regclass);
3344
3345
3346--
3347-- TOC entry 3147 (class 2604 OID 29978)
3348-- Dependencies: 2680 2679 2680
3349-- Name: ogc_fid; Type: DEFAULT; Schema: public; Owner: -
3350--
3351
3352ALTER TABLE ax_bauwerkimverkehrsbereich ALTER COLUMN ogc_fid SET DEFAULT nextval('ax_bauwerkimverkehrsbereich_ogc_fid_seq'::regclass);
3353
3354
3355--
3356-- TOC entry 3150 (class 2604 OID 29993)
3357-- Dependencies: 2682 2681 2682
3358-- Name: ogc_fid; Type: DEFAULT; Schema: public; Owner: -
3359--
3360
3361ALTER TABLE ax_bauwerkoderanlagefuerindustrieundgewerbe ALTER COLUMN ogc_fid SET DEFAULT nextval('ax_bauwerkoderanlagefuerindustrieundgewerbe_ogc_fid_seq'::regclass);
3362
3363
3364--
3365-- TOC entry 3143 (class 2604 OID 29962)
3366-- Dependencies: 2677 2678 2678
3367-- Name: ogc_fid; Type: DEFAULT; Schema: public; Owner: -
3368--
3369
3370ALTER TABLE ax_bauwerkoderanlagefuersportfreizeitunderholung ALTER COLUMN ogc_fid SET DEFAULT nextval('ax_bauwerkoderanlagefuersportfreizeitunderholung_ogc_fid_seq'::regclass);
3371
3372
3373--
3374-- TOC entry 3365 (class 2604 OID 133068)
3375-- Dependencies: 2796 2795 2796
3376-- Name: ogc_fid; Type: DEFAULT; Schema: public; Owner: -
3377--
3378
3379ALTER TABLE ax_bergbaubetrieb ALTER COLUMN ogc_fid SET DEFAULT nextval('ax_bergbaubetrieb_ogc_fid_seq'::regclass);
3380
3381
3382--
3383-- TOC entry 3255 (class 2604 OID 30603)
3384-- Dependencies: 2738 2737 2738
3385-- Name: ogc_fid; Type: DEFAULT; Schema: public; Owner: -
3386--
3387
3388ALTER TABLE ax_dammwalldeich ALTER COLUMN ogc_fid SET DEFAULT nextval('ax_dammwalldeich_ogc_fid_seq'::regclass);
3389
3390
3391--
3392-- TOC entry 3292 (class 2604 OID 31001)
3393-- Dependencies: 2757 2758 2758
3394-- Name: ogc_fid; Type: DEFAULT; Schema: public; Owner: -
3395--
3396
3397ALTER TABLE ax_denkmalschutzrecht ALTER COLUMN ogc_fid SET DEFAULT nextval('ax_denkmalschutzrecht_ogc_fid_seq'::regclass);
3398
3399
3400--
3401-- TOC entry 3251 (class 2604 OID 30587)
3402-- Dependencies: 2735 2736 2736
3403-- Name: ogc_fid; Type: DEFAULT; Schema: public; Owner: -
3404--
3405
3406ALTER TABLE ax_einrichtungenfuerdenschiffsverkehr ALTER COLUMN ogc_fid SET DEFAULT nextval('ax_einrichtungenfuerdenschiffsverkehr_ogc_fid_seq'::regclass);
3407
3408
3409--
3410-- TOC entry 3154 (class 2604 OID 30009)
3411-- Dependencies: 2683 2684 2684
3412-- Name: ogc_fid; Type: DEFAULT; Schema: public; Owner: -
3413--
3414
3415ALTER TABLE ax_fahrbahnachse ALTER COLUMN ogc_fid SET DEFAULT nextval('ax_fahrbahnachse_ogc_fid_seq'::regclass);
3416
3417
3418--
3419-- TOC entry 3094 (class 2604 OID 29722)
3420-- Dependencies: 2651 2652 2652
3421-- Name: ogc_fid; Type: DEFAULT; Schema: public; Owner: -
3422--
3423
3424ALTER TABLE ax_fahrwegachse ALTER COLUMN ogc_fid SET DEFAULT nextval('ax_fahrwegachse_ogc_fid_seq'::regclass);
3425
3426
3427--
3428-- TOC entry 3296 (class 2604 OID 31047)
3429-- Dependencies: 2759 2760 2760
3430-- Name: ogc_fid; Type: DEFAULT; Schema: public; Owner: -
3431--
3432
3433ALTER TABLE ax_felsenfelsblockfelsnadel ALTER COLUMN ogc_fid SET DEFAULT nextval('ax_felsenfelsblockfelsnadel_ogc_fid_seq'::regclass);
3434
3435
3436--
3437-- TOC entry 3158 (class 2604 OID 30025)
3438-- Dependencies: 2686 2685 2686
3439-- Name: ogc_fid; Type: DEFAULT; Schema: public; Owner: -
3440--
3441
3442ALTER TABLE ax_flaechebesondererfunktionalerpraegung ALTER COLUMN ogc_fid SET DEFAULT nextval('ax_flaechebesondererfunktionalerpraegung_ogc_fid_seq'::regclass);
3443
3444
3445--
3446-- TOC entry 3162 (class 2604 OID 30041)
3447-- Dependencies: 2688 2687 2688
3448-- Name: ogc_fid; Type: DEFAULT; Schema: public; Owner: -
3449--
3450
3451ALTER TABLE ax_flaechegemischternutzung ALTER COLUMN ogc_fid SET DEFAULT nextval('ax_flaechegemischternutzung_ogc_fid_seq'::regclass);
3452
3453
3454--
3455-- TOC entry 3259 (class 2604 OID 30619)
3456-- Dependencies: 2740 2739 2740
3457-- Name: ogc_fid; Type: DEFAULT; Schema: public; Owner: -
3458--
3459
3460ALTER TABLE ax_flaechezurzeitunbestimmbar ALTER COLUMN ogc_fid SET DEFAULT nextval('ax_flaechezurzeitunbestimmbar_ogc_fid_seq'::regclass);
3461
3462
3463--
3464-- TOC entry 3263 (class 2604 OID 30635)
3465-- Dependencies: 2741 2742 2742
3466-- Name: ogc_fid; Type: DEFAULT; Schema: public; Owner: -
3467--
3468
3469ALTER TABLE ax_fliessgewaesser ALTER COLUMN ogc_fid SET DEFAULT nextval('ax_fliessgewaesser_ogc_fid_seq'::regclass);
3470
3471
3472--
3473-- TOC entry 3308 (class 2604 OID 32185)
3474-- Dependencies: 2765 2766 2766
3475-- Name: ogc_fid; Type: DEFAULT; Schema: public; Owner: -
3476--
3477
3478ALTER TABLE ax_flugverkehr ALTER COLUMN ogc_fid SET DEFAULT nextval('ax_flugverkehr_ogc_fid_seq'::regclass);
3479
3480
3481--
3482-- TOC entry 3312 (class 2604 OID 33037)
3483-- Dependencies: 2767 2768 2768
3484-- Name: ogc_fid; Type: DEFAULT; Schema: public; Owner: -
3485--
3486
3487ALTER TABLE ax_flugverkehrsanlage ALTER COLUMN ogc_fid SET DEFAULT nextval('ax_flugverkehrsanlage_ogc_fid_seq'::regclass);
3488
3489
3490--
3491-- TOC entry 3166 (class 2604 OID 30057)
3492-- Dependencies: 2689 2690 2690
3493-- Name: ogc_fid; Type: DEFAULT; Schema: public; Owner: -
3494--
3495
3496ALTER TABLE ax_friedhof ALTER COLUMN ogc_fid SET DEFAULT nextval('ax_friedhof_ogc_fid_seq'::regclass);
3497
3498
3499--
3500-- TOC entry 3170 (class 2604 OID 30073)
3501-- Dependencies: 2692 2691 2692
3502-- Name: ogc_fid; Type: DEFAULT; Schema: public; Owner: -
3503--
3504
3505ALTER TABLE ax_gebaeude ALTER COLUMN ogc_fid SET DEFAULT nextval('ax_gebaeude_ogc_fid_seq'::regclass);
3506
3507
3508--
3509-- TOC entry 3098 (class 2604 OID 29738)
3510-- Dependencies: 2653 2654 2654
3511-- Name: ogc_fid; Type: DEFAULT; Schema: public; Owner: -
3512--
3513
3514ALTER TABLE ax_gebietsgrenze ALTER COLUMN ogc_fid SET DEFAULT nextval('ax_gebietsgrenze_ogc_fid_seq'::regclass);
3515
3516
3517--
3518-- TOC entry 3174 (class 2604 OID 30131)
3519-- Dependencies: 2694 2693 2694
3520-- Name: ogc_fid; Type: DEFAULT; Schema: public; Owner: -
3521--
3522
3523ALTER TABLE ax_gehoelz ALTER COLUMN ogc_fid SET DEFAULT nextval('ax_gehoelz_ogc_fid_seq'::regclass);
3524
3525
3526--
3527-- TOC entry 3102 (class 2604 OID 29764)
3528-- Dependencies: 2656 2655 2656
3529-- Name: ogc_fid; Type: DEFAULT; Schema: public; Owner: -
3530--
3531
3532ALTER TABLE ax_gewaesserachse ALTER COLUMN ogc_fid SET DEFAULT nextval('ax_gewaesserachse_ogc_fid_seq'::regclass);
3533
3534
3535--
3536-- TOC entry 3267 (class 2604 OID 30712)
3537-- Dependencies: 2744 2743 2744
3538-- Name: ogc_fid; Type: DEFAULT; Schema: public; Owner: -
3539--
3540
3541ALTER TABLE ax_gewaessermerkmal ALTER COLUMN ogc_fid SET DEFAULT nextval('ax_gewaessermerkmal_ogc_fid_seq'::regclass);
3542
3543
3544--
3545-- TOC entry 3275 (class 2604 OID 30746)
3546-- Dependencies: 2748 2747 2748
3547-- Name: ogc_fid; Type: DEFAULT; Schema: public; Owner: -
3548--
3549
3550ALTER TABLE ax_gewaesserstationierungsachse ALTER COLUMN ogc_fid SET DEFAULT nextval('ax_gewaesserstationierungsachse_ogc_fid_seq'::regclass);
3551
3552
3553--
3554-- TOC entry 3324 (class 2604 OID 33733)
3555-- Dependencies: 2774 2773 2774
3556-- Name: ogc_fid; Type: DEFAULT; Schema: public; Owner: -
3557--
3558
3559ALTER TABLE ax_hafen ALTER COLUMN ogc_fid SET DEFAULT nextval('ax_hafen_ogc_fid_seq'::regclass);
3560
3561
3562--
3563-- TOC entry 3320 (class 2604 OID 33709)
3564-- Dependencies: 2771 2772 2772
3565-- Name: ogc_fid; Type: DEFAULT; Schema: public; Owner: -
3566--
3567
3568ALTER TABLE ax_hafenbecken ALTER COLUMN ogc_fid SET DEFAULT nextval('ax_hafenbecken_ogc_fid_seq'::regclass);
3569
3570
3571--
3572-- TOC entry 3336 (class 2604 OID 36948)
3573-- Dependencies: 2779 2780 2780
3574-- Name: ogc_fid; Type: DEFAULT; Schema: public; Owner: -
3575--
3576
3577ALTER TABLE ax_halde ALTER COLUMN ogc_fid SET DEFAULT nextval('ax_halde_ogc_fid_seq'::regclass);
3578
3579
3580--
3581-- TOC entry 3360 (class 2604 OID 63876)
3582-- Dependencies: 2791 2792 2792
3583-- Name: ogc_fid; Type: DEFAULT; Schema: public; Owner: -
3584--
3585
3586ALTER TABLE ax_heide ALTER COLUMN ogc_fid SET DEFAULT nextval('ax_heide_ogc_fid_seq'::regclass);
3587
3588
3589--
3590-- TOC entry 3106 (class 2604 OID 29780)
3591-- Dependencies: 2658 2657 2658
3592-- Name: ogc_fid; Type: DEFAULT; Schema: public; Owner: -
3593--
3594
3595ALTER TABLE ax_historischesbauwerkoderhistorischeeinrichtung ALTER COLUMN ogc_fid SET DEFAULT nextval('ax_historischesbauwerkoderhistorischeeinrichtung_ogc_fid_seq'::regclass);
3596
3597
3598--
3599-- TOC entry 3300 (class 2604 OID 31387)
3600-- Dependencies: 2761 2762 2762
3601-- Name: ogc_fid; Type: DEFAULT; Schema: public; Owner: -
3602--
3603
3604ALTER TABLE ax_hoehleneingang ALTER COLUMN ogc_fid SET DEFAULT nextval('ax_hoehleneingang_ogc_fid_seq'::regclass);
3605
3606
3607--
3608-- TOC entry 3178 (class 2604 OID 30188)
3609-- Dependencies: 2695 2696 2696
3610-- Name: ogc_fid; Type: DEFAULT; Schema: public; Owner: -
3611--
3612
3613ALTER TABLE ax_industrieundgewerbeflaeche ALTER COLUMN ogc_fid SET DEFAULT nextval('ax_industrieundgewerbeflaeche_ogc_fid_seq'::regclass);
3614
3615
3616--
3617-- TOC entry 3271 (class 2604 OID 30730)
3618-- Dependencies: 2746 2745 2746
3619-- Name: ogc_fid; Type: DEFAULT; Schema: public; Owner: -
3620--
3621
3622ALTER TABLE ax_insel ALTER COLUMN ogc_fid SET DEFAULT nextval('ax_insel_ogc_fid_seq'::regclass);
3623
3624
3625--
3626-- TOC entry 3364 (class 2604 OID 69845)
3627-- Dependencies: 2793 2794 2794
3628-- Name: ogc_fid; Type: DEFAULT; Schema: public; Owner: -
3629--
3630
3631ALTER TABLE ax_kanal ALTER COLUMN ogc_fid SET DEFAULT nextval('ax_kanal_ogc_fid_seq'::regclass);
3632
3633
3634--
3635-- TOC entry 3110 (class 2604 OID 29796)
3636-- Dependencies: 2660 2659 2660
3637-- Name: ogc_fid; Type: DEFAULT; Schema: public; Owner: -
3638--
3639
3640ALTER TABLE ax_kommunalesgebiet ALTER COLUMN ogc_fid SET DEFAULT nextval('ax_kommunalesgebiet_ogc_fid_seq'::regclass);
3641
3642
3643--
3644-- TOC entry 3352 (class 2604 OID 61525)
3645-- Dependencies: 2788 2787 2788
3646-- Name: ogc_fid; Type: DEFAULT; Schema: public; Owner: -
3647--
3648
3649ALTER TABLE ax_kondominium ALTER COLUMN ogc_fid SET DEFAULT nextval('ax_kondominium_ogc_fid_seq'::regclass);
3650
3651
3652--
3653-- TOC entry 3114 (class 2604 OID 29818)
3654-- Dependencies: 2662 2661 2662
3655-- Name: ogc_fid; Type: DEFAULT; Schema: public; Owner: -
3656--
3657
3658ALTER TABLE ax_landwirtschaft ALTER COLUMN ogc_fid SET DEFAULT nextval('ax_landwirtschaft_ogc_fid_seq'::regclass);
3659
3660
3661--
3662-- TOC entry 3279 (class 2604 OID 30814)
3663-- Dependencies: 2750 2749 2750
3664-- Name: ogc_fid; Type: DEFAULT; Schema: public; Owner: -
3665--
3666
3667ALTER TABLE ax_leitung ALTER COLUMN ogc_fid SET DEFAULT nextval('ax_leitung_ogc_fid_seq'::regclass);
3668
3669
3670--
3671-- TOC entry 3348 (class 2604 OID 51737)
3672-- Dependencies: 2785 2786 2786
3673-- Name: ogc_fid; Type: DEFAULT; Schema: public; Owner: -
3674--
3675
3676ALTER TABLE ax_moor ALTER COLUMN ogc_fid SET DEFAULT nextval('ax_moor_ogc_fid_seq'::regclass);
3677
3678
3679--
3680-- TOC entry 3118 (class 2604 OID 29838)
3681-- Dependencies: 2664 2663 2664
3682-- Name: ogc_fid; Type: DEFAULT; Schema: public; Owner: -
3683--
3684
3685ALTER TABLE ax_naturumweltoderbodenschutzrecht ALTER COLUMN ogc_fid SET DEFAULT nextval('ax_naturumweltoderbodenschutzrecht_ogc_fid_seq'::regclass);
3686
3687
3688--
3689-- TOC entry 3242 (class 2604 OID 30547)
3690-- Dependencies: 2730 2729 2730
3691-- Name: ogc_fid; Type: DEFAULT; Schema: public; Owner: -
3692--
3693
3694ALTER TABLE ax_netzknoten ALTER COLUMN ogc_fid SET DEFAULT nextval('ax_netzknoten_ogc_fid_seq'::regclass);
3695
3696
3697--
3698-- TOC entry 3194 (class 2604 OID 30316)
3699-- Dependencies: 2703 2704 2704
3700-- Name: ogc_fid; Type: DEFAULT; Schema: public; Owner: -
3701--
3702
3703ALTER TABLE ax_nullpunkt ALTER COLUMN ogc_fid SET DEFAULT nextval('ax_nullpunkt_ogc_fid_seq'::regclass);
3704
3705
3706--
3707-- TOC entry 3186 (class 2604 OID 30282)
3708-- Dependencies: 2699 2700 2700
3709-- Name: ogc_fid; Type: DEFAULT; Schema: public; Owner: -
3710--
3711
3712ALTER TABLE ax_ortslage ALTER COLUMN ogc_fid SET DEFAULT nextval('ax_ortslage_ogc_fid_seq'::regclass);
3713
3714
3715--
3716-- TOC entry 3182 (class 2604 OID 30266)
3717-- Dependencies: 2697 2698 2698
3718-- Name: ogc_fid; Type: DEFAULT; Schema: public; Owner: -
3719--
3720
3721ALTER TABLE ax_platz ALTER COLUMN ogc_fid SET DEFAULT nextval('ax_platz_ogc_fid_seq'::regclass);
3722
3723
3724--
3725-- TOC entry 3283 (class 2604 OID 30845)
3726-- Dependencies: 2752 2751 2752
3727-- Name: ogc_fid; Type: DEFAULT; Schema: public; Owner: -
3728--
3729
3730ALTER TABLE ax_schifffahrtsliniefaehrverkehr ALTER COLUMN ogc_fid SET DEFAULT nextval('ax_schifffahrtsliniefaehrverkehr_ogc_fid_seq'::regclass);
3731
3732
3733--
3734-- TOC entry 3328 (class 2604 OID 33865)
3735-- Dependencies: 2775 2776 2776
3736-- Name: ogc_fid; Type: DEFAULT; Schema: public; Owner: -
3737--
3738
3739ALTER TABLE ax_schiffsverkehr ALTER COLUMN ogc_fid SET DEFAULT nextval('ax_schiffsverkehr_ogc_fid_seq'::regclass);
3740
3741
3742--
3743-- TOC entry 3356 (class 2604 OID 61544)
3744-- Dependencies: 2790 2789 2790
3745-- Name: ogc_fid; Type: DEFAULT; Schema: public; Owner: -
3746--
3747
3748ALTER TABLE ax_schleuse ALTER COLUMN ogc_fid SET DEFAULT nextval('ax_schleuse_ogc_fid_seq'::regclass);
3749
3750
3751--
3752-- TOC entry 3340 (class 2604 OID 40024)
3753-- Dependencies: 2782 2781 2782
3754-- Name: ogc_fid; Type: DEFAULT; Schema: public; Owner: -
3755--
3756
3757ALTER TABLE ax_seilbahnschwebebahn ALTER COLUMN ogc_fid SET DEFAULT nextval('ax_seilbahnschwebebahn_ogc_fid_seq'::regclass);
3758
3759
3760--
3761-- TOC entry 3190 (class 2604 OID 30300)
3762-- Dependencies: 2701 2702 2702
3763-- Name: ogc_fid; Type: DEFAULT; Schema: public; Owner: -
3764--
3765
3766ALTER TABLE ax_sonstigesbauwerkodersonstigeeinrichtung ALTER COLUMN ogc_fid SET DEFAULT nextval('ax_sonstigesbauwerkodersonstigeeinrichtung_ogc_fid_seq'::regclass);
3767
3768
3769--
3770-- TOC entry 3344 (class 2604 OID 40095)
3771-- Dependencies: 2783 2784 2784
3772-- Name: ogc_fid; Type: DEFAULT; Schema: public; Owner: -
3773--
3774
3775ALTER TABLE ax_sonstigesrecht ALTER COLUMN ogc_fid SET DEFAULT nextval('ax_sonstigesrecht_ogc_fid_seq'::regclass);
3776
3777
3778--
3779-- TOC entry 3198 (class 2604 OID 30332)
3780-- Dependencies: 2706 2705 2706
3781-- Name: ogc_fid; Type: DEFAULT; Schema: public; Owner: -
3782--
3783
3784ALTER TABLE ax_sportfreizeitunderholungsflaeche ALTER COLUMN ogc_fid SET DEFAULT nextval('ax_sportfreizeitunderholungsflaeche_ogc_fid_seq'::regclass);
3785
3786
3787--
3788-- TOC entry 3202 (class 2604 OID 30348)
3789-- Dependencies: 2707 2708 2708
3790-- Name: ogc_fid; Type: DEFAULT; Schema: public; Owner: -
3791--
3792
3793ALTER TABLE ax_stehendesgewaesser ALTER COLUMN ogc_fid SET DEFAULT nextval('ax_stehendesgewaesser_ogc_fid_seq'::regclass);
3794
3795
3796--
3797-- TOC entry 3241 (class 2604 OID 30536)
3798-- Dependencies: 2727 2728 2728
3799-- Name: ogc_fid; Type: DEFAULT; Schema: public; Owner: -
3800--
3801
3802ALTER TABLE ax_strasse ALTER COLUMN ogc_fid SET DEFAULT nextval('ax_strasse_ogc_fid_seq'::regclass);
3803
3804
3805--
3806-- TOC entry 3206 (class 2604 OID 30364)
3807-- Dependencies: 2710 2709 2710
3808-- Name: ogc_fid; Type: DEFAULT; Schema: public; Owner: -
3809--
3810
3811ALTER TABLE ax_strassenachse ALTER COLUMN ogc_fid SET DEFAULT nextval('ax_strassenachse_ogc_fid_seq'::regclass);
3812
3813
3814--
3815-- TOC entry 3210 (class 2604 OID 30380)
3816-- Dependencies: 2712 2711 2712
3817-- Name: ogc_fid; Type: DEFAULT; Schema: public; Owner: -
3818--
3819
3820ALTER TABLE ax_strassenverkehr ALTER COLUMN ogc_fid SET DEFAULT nextval('ax_strassenverkehr_ogc_fid_seq'::regclass);
3821
3822
3823--
3824-- TOC entry 3226 (class 2604 OID 30444)
3825-- Dependencies: 2720 2719 2720
3826-- Name: ogc_fid; Type: DEFAULT; Schema: public; Owner: -
3827--
3828
3829ALTER TABLE ax_strassenverkehrsanlage ALTER COLUMN ogc_fid SET DEFAULT nextval('ax_strassenverkehrsanlage_ogc_fid_seq'::regclass);
3830
3831
3832--
3833-- TOC entry 3332 (class 2604 OID 34085)
3834-- Dependencies: 2777 2778 2778
3835-- Name: ogc_fid; Type: DEFAULT; Schema: public; Owner: -
3836--
3837
3838ALTER TABLE ax_sumpf ALTER COLUMN ogc_fid SET DEFAULT nextval('ax_sumpf_ogc_fid_seq'::regclass);
3839
3840
3841--
3842-- TOC entry 3287 (class 2604 OID 30890)
3843-- Dependencies: 2753 2754 2754
3844-- Name: ogc_fid; Type: DEFAULT; Schema: public; Owner: -
3845--
3846
3847ALTER TABLE ax_tagebaugrubesteinbruch ALTER COLUMN ogc_fid SET DEFAULT nextval('ax_tagebaugrubesteinbruch_ogc_fid_seq'::regclass);
3848
3849
3850--
3851-- TOC entry 3222 (class 2604 OID 30428)
3852-- Dependencies: 2717 2718 2718
3853-- Name: ogc_fid; Type: DEFAULT; Schema: public; Owner: -
3854--
3855
3856ALTER TABLE ax_transportanlage ALTER COLUMN ogc_fid SET DEFAULT nextval('ax_transportanlage_ogc_fid_seq'::regclass);
3857
3858
3859--
3860-- TOC entry 3218 (class 2604 OID 30412)
3861-- Dependencies: 2715 2716 2716
3862-- Name: ogc_fid; Type: DEFAULT; Schema: public; Owner: -
3863--
3864
3865ALTER TABLE ax_turm ALTER COLUMN ogc_fid SET DEFAULT nextval('ax_turm_ogc_fid_seq'::regclass);
3866
3867
3868--
3869-- TOC entry 3214 (class 2604 OID 30396)
3870-- Dependencies: 2713 2714 2714
3871-- Name: ogc_fid; Type: DEFAULT; Schema: public; Owner: -
3872--
3873
3874ALTER TABLE ax_unlandvegetationsloseflaeche ALTER COLUMN ogc_fid SET DEFAULT nextval('ax_unlandvegetationsloseflaeche_ogc_fid_seq'::regclass);
3875
3876
3877--
3878-- TOC entry 3230 (class 2604 OID 30460)
3879-- Dependencies: 2722 2721 2722
3880-- Name: ogc_fid; Type: DEFAULT; Schema: public; Owner: -
3881--
3882
3883ALTER TABLE ax_vegetationsmerkmal ALTER COLUMN ogc_fid SET DEFAULT nextval('ax_vegetationsmerkmal_ogc_fid_seq'::regclass);
3884
3885
3886--
3887-- TOC entry 3122 (class 2604 OID 29864)
3888-- Dependencies: 2666 2665 2666
3889-- Name: ogc_fid; Type: DEFAULT; Schema: public; Owner: -
3890--
3891
3892ALTER TABLE ax_wald ALTER COLUMN ogc_fid SET DEFAULT nextval('ax_wald_ogc_fid_seq'::regclass);
3893
3894
3895--
3896-- TOC entry 3291 (class 2604 OID 30990)
3897-- Dependencies: 2756 2755 2756
3898-- Name: ogc_fid; Type: DEFAULT; Schema: public; Owner: -
3899--
3900
3901ALTER TABLE ax_wasserlauf ALTER COLUMN ogc_fid SET DEFAULT nextval('ax_wasserlauf_ogc_fid_seq'::regclass);
3902
3903
3904--
3905-- TOC entry 3304 (class 2604 OID 32127)
3906-- Dependencies: 2764 2763 2764
3907-- Name: ogc_fid; Type: DEFAULT; Schema: public; Owner: -
3908--
3909
3910ALTER TABLE ax_wasserspiegelhoehe ALTER COLUMN ogc_fid SET DEFAULT nextval('ax_wasserspiegelhoehe_ogc_fid_seq'::regclass);
3911
3912
3913--
3914-- TOC entry 3126 (class 2604 OID 29886)
3915-- Dependencies: 2667 2668 2668
3916-- Name: ogc_fid; Type: DEFAULT; Schema: public; Owner: -
3917--
3918
3919ALTER TABLE ax_wegpfadsteig ALTER COLUMN ogc_fid SET DEFAULT nextval('ax_wegpfadsteig_ogc_fid_seq'::regclass);
3920
3921
3922--
3923-- TOC entry 3233 (class 2604 OID 30504)
3924-- Dependencies: 2724 2723 2724
3925-- Name: ogc_fid; Type: DEFAULT; Schema: public; Owner: -
3926--
3927
3928ALTER TABLE ax_wohnbauflaeche ALTER COLUMN ogc_fid SET DEFAULT nextval('ax_wohnbauflaeche_ogc_fid_seq'::regclass);
3929
3930
3931--
3932-- TOC entry 3237 (class 2604 OID 30520)
3933-- Dependencies: 2725 2726 2726
3934-- Name: ogc_fid; Type: DEFAULT; Schema: public; Owner: -
3935--
3936
3937ALTER TABLE ax_wohnplatz ALTER COLUMN ogc_fid SET DEFAULT nextval('ax_wohnplatz_ogc_fid_seq'::regclass);
3938
3939
3940--
3941-- TOC entry 3401 (class 2606 OID 29904)
3942-- Dependencies: 2670 2670
3943-- Name: alkis_beziehungen_pk; Type: CONSTRAINT; Schema: public; Owner: -
3944--
3945
3946ALTER TABLE ONLY alkis_beziehungen
3947    ADD CONSTRAINT alkis_beziehungen_pk PRIMARY KEY (ogc_fid);
3948
3949
3950--
3951-- TOC entry 3404 (class 2606 OID 29916)
3952-- Dependencies: 2672 2672
3953-- Name: ax_abschnitt_pk; Type: CONSTRAINT; Schema: public; Owner: -
3954--
3955
3956ALTER TABLE ONLY ax_abschnitt
3957    ADD CONSTRAINT ax_abschnitt_pk PRIMARY KEY (ogc_fid);
3958
3959
3960--
3961-- TOC entry 3407 (class 2606 OID 29932)
3962-- Dependencies: 2674 2674
3963-- Name: ax_ast_pk; Type: CONSTRAINT; Schema: public; Owner: -
3964--
3965
3966ALTER TABLE ONLY ax_ast
3967    ADD CONSTRAINT ax_ast_pk PRIMARY KEY (ogc_fid);
3968
3969
3970--
3971-- TOC entry 3495 (class 2606 OID 30573)
3972-- Dependencies: 2734 2734
3973-- Name: ax_bahnstrecke_pk; Type: CONSTRAINT; Schema: public; Owner: -
3974--
3975
3976ALTER TABLE ONLY ax_bahnstrecke
3977    ADD CONSTRAINT ax_bahnstrecke_pk PRIMARY KEY (ogc_fid);
3978
3979
3980--
3981-- TOC entry 3548 (class 2606 OID 33474)
3982-- Dependencies: 2770 2770
3983-- Name: ax_bahnverkehr_pk; Type: CONSTRAINT; Schema: public; Owner: -
3984--
3985
3986ALTER TABLE ONLY ax_bahnverkehr
3987    ADD CONSTRAINT ax_bahnverkehr_pk PRIMARY KEY (ogc_fid);
3988
3989
3990--
3991-- TOC entry 3492 (class 2606 OID 30557)
3992-- Dependencies: 2732 2732
3993-- Name: ax_bahnverkehrsanlage_pk; Type: CONSTRAINT; Schema: public; Owner: -
3994--
3995
3996ALTER TABLE ONLY ax_bahnverkehrsanlage
3997    ADD CONSTRAINT ax_bahnverkehrsanlage_pk PRIMARY KEY (ogc_fid);
3998
3999
4000--
4001-- TOC entry 3410 (class 2606 OID 29948)
4002-- Dependencies: 2676 2676
4003-- Name: ax_bauwerkimgewaesserbereich_pk; Type: CONSTRAINT; Schema: public; Owner: -
4004--
4005
4006ALTER TABLE ONLY ax_bauwerkimgewaesserbereich
4007    ADD CONSTRAINT ax_bauwerkimgewaesserbereich_pk PRIMARY KEY (ogc_fid);
4008
4009
4010--
4011-- TOC entry 3416 (class 2606 OID 29980)
4012-- Dependencies: 2680 2680
4013-- Name: ax_bauwerkimverkehrsbereich_pk; Type: CONSTRAINT; Schema: public; Owner: -
4014--
4015
4016ALTER TABLE ONLY ax_bauwerkimverkehrsbereich
4017    ADD CONSTRAINT ax_bauwerkimverkehrsbereich_pk PRIMARY KEY (ogc_fid);
4018
4019
4020--
4021-- TOC entry 3419 (class 2606 OID 29995)
4022-- Dependencies: 2682 2682
4023-- Name: ax_bauwerkoderanlagefuerindustrieundgewerbe_pk; Type: CONSTRAINT; Schema: public; Owner: -
4024--
4025
4026ALTER TABLE ONLY ax_bauwerkoderanlagefuerindustrieundgewerbe
4027    ADD CONSTRAINT ax_bauwerkoderanlagefuerindustrieundgewerbe_pk PRIMARY KEY (ogc_fid);
4028
4029
4030--
4031-- TOC entry 3413 (class 2606 OID 29964)
4032-- Dependencies: 2678 2678
4033-- Name: ax_bauwerkoderanlagefuersportfreizeitunderholung_pk; Type: CONSTRAINT; Schema: public; Owner: -
4034--
4035
4036ALTER TABLE ONLY ax_bauwerkoderanlagefuersportfreizeitunderholung
4037    ADD CONSTRAINT ax_bauwerkoderanlagefuersportfreizeitunderholung_pk PRIMARY KEY (ogc_fid);
4038
4039
4040--
4041-- TOC entry 3586 (class 2606 OID 133070)
4042-- Dependencies: 2796 2796
4043-- Name: ax_bergbaubetrieb_pk; Type: CONSTRAINT; Schema: public; Owner: -
4044--
4045
4046ALTER TABLE ONLY ax_bergbaubetrieb
4047    ADD CONSTRAINT ax_bergbaubetrieb_pk PRIMARY KEY (ogc_fid);
4048
4049
4050--
4051-- TOC entry 3501 (class 2606 OID 30605)
4052-- Dependencies: 2738 2738
4053-- Name: ax_dammwalldeich_pk; Type: CONSTRAINT; Schema: public; Owner: -
4054--
4055
4056ALTER TABLE ONLY ax_dammwalldeich
4057    ADD CONSTRAINT ax_dammwalldeich_pk PRIMARY KEY (ogc_fid);
4058
4059
4060--
4061-- TOC entry 3530 (class 2606 OID 31003)
4062-- Dependencies: 2758 2758
4063-- Name: ax_denkmalschutzrecht_pk; Type: CONSTRAINT; Schema: public; Owner: -
4064--
4065
4066ALTER TABLE ONLY ax_denkmalschutzrecht
4067    ADD CONSTRAINT ax_denkmalschutzrecht_pk PRIMARY KEY (ogc_fid);
4068
4069
4070--
4071-- TOC entry 3498 (class 2606 OID 30589)
4072-- Dependencies: 2736 2736
4073-- Name: ax_einrichtungenfuerdenschiffsverkehr_pk; Type: CONSTRAINT; Schema: public; Owner: -
4074--
4075
4076ALTER TABLE ONLY ax_einrichtungenfuerdenschiffsverkehr
4077    ADD CONSTRAINT ax_einrichtungenfuerdenschiffsverkehr_pk PRIMARY KEY (ogc_fid);
4078
4079
4080--
4081-- TOC entry 3422 (class 2606 OID 30011)
4082-- Dependencies: 2684 2684
4083-- Name: ax_fahrbahnachse_pk; Type: CONSTRAINT; Schema: public; Owner: -
4084--
4085
4086ALTER TABLE ONLY ax_fahrbahnachse
4087    ADD CONSTRAINT ax_fahrbahnachse_pk PRIMARY KEY (ogc_fid);
4088
4089
4090--
4091-- TOC entry 3375 (class 2606 OID 29724)
4092-- Dependencies: 2652 2652
4093-- Name: ax_fahrwegachse_pk; Type: CONSTRAINT; Schema: public; Owner: -
4094--
4095
4096ALTER TABLE ONLY ax_fahrwegachse
4097    ADD CONSTRAINT ax_fahrwegachse_pk PRIMARY KEY (ogc_fid);
4098
4099
4100--
4101-- TOC entry 3533 (class 2606 OID 31049)
4102-- Dependencies: 2760 2760
4103-- Name: ax_felsenfelsblockfelsnadel_pk; Type: CONSTRAINT; Schema: public; Owner: -
4104--
4105
4106ALTER TABLE ONLY ax_felsenfelsblockfelsnadel
4107    ADD CONSTRAINT ax_felsenfelsblockfelsnadel_pk PRIMARY KEY (ogc_fid);
4108
4109
4110--
4111-- TOC entry 3425 (class 2606 OID 30027)
4112-- Dependencies: 2686 2686
4113-- Name: ax_flaechebesondererfunktionalerpraegung_pk; Type: CONSTRAINT; Schema: public; Owner: -
4114--
4115
4116ALTER TABLE ONLY ax_flaechebesondererfunktionalerpraegung
4117    ADD CONSTRAINT ax_flaechebesondererfunktionalerpraegung_pk PRIMARY KEY (ogc_fid);
4118
4119
4120--
4121-- TOC entry 3428 (class 2606 OID 30043)
4122-- Dependencies: 2688 2688
4123-- Name: ax_flaechegemischternutzung_pk; Type: CONSTRAINT; Schema: public; Owner: -
4124--
4125
4126ALTER TABLE ONLY ax_flaechegemischternutzung
4127    ADD CONSTRAINT ax_flaechegemischternutzung_pk PRIMARY KEY (ogc_fid);
4128
4129
4130--
4131-- TOC entry 3504 (class 2606 OID 30621)
4132-- Dependencies: 2740 2740
4133-- Name: ax_flaechezurzeitunbestimmbar_pk; Type: CONSTRAINT; Schema: public; Owner: -
4134--
4135
4136ALTER TABLE ONLY ax_flaechezurzeitunbestimmbar
4137    ADD CONSTRAINT ax_flaechezurzeitunbestimmbar_pk PRIMARY KEY (ogc_fid);
4138
4139
4140--
4141-- TOC entry 3507 (class 2606 OID 30637)
4142-- Dependencies: 2742 2742
4143-- Name: ax_fliessgewaesser_pk; Type: CONSTRAINT; Schema: public; Owner: -
4144--
4145
4146ALTER TABLE ONLY ax_fliessgewaesser
4147    ADD CONSTRAINT ax_fliessgewaesser_pk PRIMARY KEY (ogc_fid);
4148
4149
4150--
4151-- TOC entry 3542 (class 2606 OID 32187)
4152-- Dependencies: 2766 2766
4153-- Name: ax_flugverkehr_pk; Type: CONSTRAINT; Schema: public; Owner: -
4154--
4155
4156ALTER TABLE ONLY ax_flugverkehr
4157    ADD CONSTRAINT ax_flugverkehr_pk PRIMARY KEY (ogc_fid);
4158
4159
4160--
4161-- TOC entry 3545 (class 2606 OID 33039)
4162-- Dependencies: 2768 2768
4163-- Name: ax_flugverkehrsanlage_pk; Type: CONSTRAINT; Schema: public; Owner: -
4164--
4165
4166ALTER TABLE ONLY ax_flugverkehrsanlage
4167    ADD CONSTRAINT ax_flugverkehrsanlage_pk PRIMARY KEY (ogc_fid);
4168
4169
4170--
4171-- TOC entry 3431 (class 2606 OID 30059)
4172-- Dependencies: 2690 2690
4173-- Name: ax_friedhof_pk; Type: CONSTRAINT; Schema: public; Owner: -
4174--
4175
4176ALTER TABLE ONLY ax_friedhof
4177    ADD CONSTRAINT ax_friedhof_pk PRIMARY KEY (ogc_fid);
4178
4179
4180--
4181-- TOC entry 3434 (class 2606 OID 30075)
4182-- Dependencies: 2692 2692
4183-- Name: ax_gebaeude_pk; Type: CONSTRAINT; Schema: public; Owner: -
4184--
4185
4186ALTER TABLE ONLY ax_gebaeude
4187    ADD CONSTRAINT ax_gebaeude_pk PRIMARY KEY (ogc_fid);
4188
4189
4190--
4191-- TOC entry 3378 (class 2606 OID 29740)
4192-- Dependencies: 2654 2654
4193-- Name: ax_gebietsgrenze_pk; Type: CONSTRAINT; Schema: public; Owner: -
4194--
4195
4196ALTER TABLE ONLY ax_gebietsgrenze
4197    ADD CONSTRAINT ax_gebietsgrenze_pk PRIMARY KEY (ogc_fid);
4198
4199
4200--
4201-- TOC entry 3437 (class 2606 OID 30133)
4202-- Dependencies: 2694 2694
4203-- Name: ax_gehoelz_pk; Type: CONSTRAINT; Schema: public; Owner: -
4204--
4205
4206ALTER TABLE ONLY ax_gehoelz
4207    ADD CONSTRAINT ax_gehoelz_pk PRIMARY KEY (ogc_fid);
4208
4209
4210--
4211-- TOC entry 3381 (class 2606 OID 29766)
4212-- Dependencies: 2656 2656
4213-- Name: ax_gewaesserachse_pk; Type: CONSTRAINT; Schema: public; Owner: -
4214--
4215
4216ALTER TABLE ONLY ax_gewaesserachse
4217    ADD CONSTRAINT ax_gewaesserachse_pk PRIMARY KEY (ogc_fid);
4218
4219
4220--
4221-- TOC entry 3510 (class 2606 OID 30714)
4222-- Dependencies: 2744 2744
4223-- Name: ax_gewaessermerkmal_pk; Type: CONSTRAINT; Schema: public; Owner: -
4224--
4225
4226ALTER TABLE ONLY ax_gewaessermerkmal
4227    ADD CONSTRAINT ax_gewaessermerkmal_pk PRIMARY KEY (ogc_fid);
4228
4229
4230--
4231-- TOC entry 3516 (class 2606 OID 30748)
4232-- Dependencies: 2748 2748
4233-- Name: ax_gewaesserstationierungsachse_pk; Type: CONSTRAINT; Schema: public; Owner: -
4234--
4235
4236ALTER TABLE ONLY ax_gewaesserstationierungsachse
4237    ADD CONSTRAINT ax_gewaesserstationierungsachse_pk PRIMARY KEY (ogc_fid);
4238
4239
4240--
4241-- TOC entry 3554 (class 2606 OID 33735)
4242-- Dependencies: 2774 2774
4243-- Name: ax_hafen_pk; Type: CONSTRAINT; Schema: public; Owner: -
4244--
4245
4246ALTER TABLE ONLY ax_hafen
4247    ADD CONSTRAINT ax_hafen_pk PRIMARY KEY (ogc_fid);
4248
4249
4250--
4251-- TOC entry 3551 (class 2606 OID 33711)
4252-- Dependencies: 2772 2772
4253-- Name: ax_hafenbecken_pk; Type: CONSTRAINT; Schema: public; Owner: -
4254--
4255
4256ALTER TABLE ONLY ax_hafenbecken
4257    ADD CONSTRAINT ax_hafenbecken_pk PRIMARY KEY (ogc_fid);
4258
4259
4260--
4261-- TOC entry 3563 (class 2606 OID 36950)
4262-- Dependencies: 2780 2780
4263-- Name: ax_halde_pk; Type: CONSTRAINT; Schema: public; Owner: -
4264--
4265
4266ALTER TABLE ONLY ax_halde
4267    ADD CONSTRAINT ax_halde_pk PRIMARY KEY (ogc_fid);
4268
4269
4270--
4271-- TOC entry 3581 (class 2606 OID 63878)
4272-- Dependencies: 2792 2792
4273-- Name: ax_heide_pk; Type: CONSTRAINT; Schema: public; Owner: -
4274--
4275
4276ALTER TABLE ONLY ax_heide
4277    ADD CONSTRAINT ax_heide_pk PRIMARY KEY (ogc_fid);
4278
4279
4280--
4281-- TOC entry 3384 (class 2606 OID 29782)
4282-- Dependencies: 2658 2658
4283-- Name: ax_historischesbauwerkoderhistorischeeinrichtung_pk; Type: CONSTRAINT; Schema: public; Owner: -
4284--
4285
4286ALTER TABLE ONLY ax_historischesbauwerkoderhistorischeeinrichtung
4287    ADD CONSTRAINT ax_historischesbauwerkoderhistorischeeinrichtung_pk PRIMARY KEY (ogc_fid);
4288
4289
4290--
4291-- TOC entry 3536 (class 2606 OID 31389)
4292-- Dependencies: 2762 2762
4293-- Name: ax_hoehleneingang_pk; Type: CONSTRAINT; Schema: public; Owner: -
4294--
4295
4296ALTER TABLE ONLY ax_hoehleneingang
4297    ADD CONSTRAINT ax_hoehleneingang_pk PRIMARY KEY (ogc_fid);
4298
4299
4300--
4301-- TOC entry 3440 (class 2606 OID 30190)
4302-- Dependencies: 2696 2696
4303-- Name: ax_industrieundgewerbeflaeche_pk; Type: CONSTRAINT; Schema: public; Owner: -
4304--
4305
4306ALTER TABLE ONLY ax_industrieundgewerbeflaeche
4307    ADD CONSTRAINT ax_industrieundgewerbeflaeche_pk PRIMARY KEY (ogc_fid);
4308
4309
4310--
4311-- TOC entry 3513 (class 2606 OID 30732)
4312-- Dependencies: 2746 2746
4313-- Name: ax_insel_pk; Type: CONSTRAINT; Schema: public; Owner: -
4314--
4315
4316ALTER TABLE ONLY ax_insel
4317    ADD CONSTRAINT ax_insel_pk PRIMARY KEY (ogc_fid);
4318
4319
4320--
4321-- TOC entry 3583 (class 2606 OID 69847)
4322-- Dependencies: 2794 2794
4323-- Name: ax_kanal_pk; Type: CONSTRAINT; Schema: public; Owner: -
4324--
4325
4326ALTER TABLE ONLY ax_kanal
4327    ADD CONSTRAINT ax_kanal_pk PRIMARY KEY (ogc_fid);
4328
4329
4330--
4331-- TOC entry 3387 (class 2606 OID 29798)
4332-- Dependencies: 2660 2660
4333-- Name: ax_kommunalesgebiet_pk; Type: CONSTRAINT; Schema: public; Owner: -
4334--
4335
4336ALTER TABLE ONLY ax_kommunalesgebiet
4337    ADD CONSTRAINT ax_kommunalesgebiet_pk PRIMARY KEY (ogc_fid);
4338
4339
4340--
4341-- TOC entry 3575 (class 2606 OID 61527)
4342-- Dependencies: 2788 2788
4343-- Name: ax_kondominium_pk; Type: CONSTRAINT; Schema: public; Owner: -
4344--
4345
4346ALTER TABLE ONLY ax_kondominium
4347    ADD CONSTRAINT ax_kondominium_pk PRIMARY KEY (ogc_fid);
4348
4349
4350--
4351-- TOC entry 3390 (class 2606 OID 29820)
4352-- Dependencies: 2662 2662
4353-- Name: ax_landwirtschaft_pk; Type: CONSTRAINT; Schema: public; Owner: -
4354--
4355
4356ALTER TABLE ONLY ax_landwirtschaft
4357    ADD CONSTRAINT ax_landwirtschaft_pk PRIMARY KEY (ogc_fid);
4358
4359
4360--
4361-- TOC entry 3519 (class 2606 OID 30816)
4362-- Dependencies: 2750 2750
4363-- Name: ax_leitung_pk; Type: CONSTRAINT; Schema: public; Owner: -
4364--
4365
4366ALTER TABLE ONLY ax_leitung
4367    ADD CONSTRAINT ax_leitung_pk PRIMARY KEY (ogc_fid);
4368
4369
4370--
4371-- TOC entry 3572 (class 2606 OID 51739)
4372-- Dependencies: 2786 2786
4373-- Name: ax_moor_pk; Type: CONSTRAINT; Schema: public; Owner: -
4374--
4375
4376ALTER TABLE ONLY ax_moor
4377    ADD CONSTRAINT ax_moor_pk PRIMARY KEY (ogc_fid);
4378
4379
4380--
4381-- TOC entry 3393 (class 2606 OID 29840)
4382-- Dependencies: 2664 2664
4383-- Name: ax_naturumweltoderbodenschutzrecht_pk; Type: CONSTRAINT; Schema: public; Owner: -
4384--
4385
4386ALTER TABLE ONLY ax_naturumweltoderbodenschutzrecht
4387    ADD CONSTRAINT ax_naturumweltoderbodenschutzrecht_pk PRIMARY KEY (ogc_fid);
4388
4389
4390--
4391-- TOC entry 3489 (class 2606 OID 30549)
4392-- Dependencies: 2730 2730
4393-- Name: ax_netzknoten_pk; Type: CONSTRAINT; Schema: public; Owner: -
4394--
4395
4396ALTER TABLE ONLY ax_netzknoten
4397    ADD CONSTRAINT ax_netzknoten_pk PRIMARY KEY (ogc_fid);
4398
4399
4400--
4401-- TOC entry 3452 (class 2606 OID 30318)
4402-- Dependencies: 2704 2704
4403-- Name: ax_nullpunkt_pk; Type: CONSTRAINT; Schema: public; Owner: -
4404--
4405
4406ALTER TABLE ONLY ax_nullpunkt
4407    ADD CONSTRAINT ax_nullpunkt_pk PRIMARY KEY (ogc_fid);
4408
4409
4410--
4411-- TOC entry 3446 (class 2606 OID 30284)
4412-- Dependencies: 2700 2700
4413-- Name: ax_ortslage_pk; Type: CONSTRAINT; Schema: public; Owner: -
4414--
4415
4416ALTER TABLE ONLY ax_ortslage
4417    ADD CONSTRAINT ax_ortslage_pk PRIMARY KEY (ogc_fid);
4418
4419
4420--
4421-- TOC entry 3443 (class 2606 OID 30268)
4422-- Dependencies: 2698 2698
4423-- Name: ax_platz_pk; Type: CONSTRAINT; Schema: public; Owner: -
4424--
4425
4426ALTER TABLE ONLY ax_platz
4427    ADD CONSTRAINT ax_platz_pk PRIMARY KEY (ogc_fid);
4428
4429
4430--
4431-- TOC entry 3522 (class 2606 OID 30847)
4432-- Dependencies: 2752 2752
4433-- Name: ax_schifffahrtsliniefaehrverkehr_pk; Type: CONSTRAINT; Schema: public; Owner: -
4434--
4435
4436ALTER TABLE ONLY ax_schifffahrtsliniefaehrverkehr
4437    ADD CONSTRAINT ax_schifffahrtsliniefaehrverkehr_pk PRIMARY KEY (ogc_fid);
4438
4439
4440--
4441-- TOC entry 3557 (class 2606 OID 33867)
4442-- Dependencies: 2776 2776
4443-- Name: ax_schiffsverkehr_pk; Type: CONSTRAINT; Schema: public; Owner: -
4444--
4445
4446ALTER TABLE ONLY ax_schiffsverkehr
4447    ADD CONSTRAINT ax_schiffsverkehr_pk PRIMARY KEY (ogc_fid);
4448
4449
4450--
4451-- TOC entry 3578 (class 2606 OID 61546)
4452-- Dependencies: 2790 2790
4453-- Name: ax_schleuse_pk; Type: CONSTRAINT; Schema: public; Owner: -
4454--
4455
4456ALTER TABLE ONLY ax_schleuse
4457    ADD CONSTRAINT ax_schleuse_pk PRIMARY KEY (ogc_fid);
4458
4459
4460--
4461-- TOC entry 3566 (class 2606 OID 40026)
4462-- Dependencies: 2782 2782
4463-- Name: ax_seilbahnschwebebahn_pk; Type: CONSTRAINT; Schema: public; Owner: -
4464--
4465
4466ALTER TABLE ONLY ax_seilbahnschwebebahn
4467    ADD CONSTRAINT ax_seilbahnschwebebahn_pk PRIMARY KEY (ogc_fid);
4468
4469
4470--
4471-- TOC entry 3449 (class 2606 OID 30302)
4472-- Dependencies: 2702 2702
4473-- Name: ax_sonstigesbauwerkodersonstigeeinrichtung_pk; Type: CONSTRAINT; Schema: public; Owner: -
4474--
4475
4476ALTER TABLE ONLY ax_sonstigesbauwerkodersonstigeeinrichtung
4477    ADD CONSTRAINT ax_sonstigesbauwerkodersonstigeeinrichtung_pk PRIMARY KEY (ogc_fid);
4478
4479
4480--
4481-- TOC entry 3569 (class 2606 OID 40097)
4482-- Dependencies: 2784 2784
4483-- Name: ax_sonstigesrecht_pk; Type: CONSTRAINT; Schema: public; Owner: -
4484--
4485
4486ALTER TABLE ONLY ax_sonstigesrecht
4487    ADD CONSTRAINT ax_sonstigesrecht_pk PRIMARY KEY (ogc_fid);
4488
4489
4490--
4491-- TOC entry 3455 (class 2606 OID 30334)
4492-- Dependencies: 2706 2706
4493-- Name: ax_sportfreizeitunderholungsflaeche_pk; Type: CONSTRAINT; Schema: public; Owner: -
4494--
4495
4496ALTER TABLE ONLY ax_sportfreizeitunderholungsflaeche
4497    ADD CONSTRAINT ax_sportfreizeitunderholungsflaeche_pk PRIMARY KEY (ogc_fid);
4498
4499
4500--
4501-- TOC entry 3458 (class 2606 OID 30350)
4502-- Dependencies: 2708 2708
4503-- Name: ax_stehendesgewaesser_pk; Type: CONSTRAINT; Schema: public; Owner: -
4504--
4505
4506ALTER TABLE ONLY ax_stehendesgewaesser
4507    ADD CONSTRAINT ax_stehendesgewaesser_pk PRIMARY KEY (ogc_fid);
4508
4509
4510--
4511-- TOC entry 3487 (class 2606 OID 30538)
4512-- Dependencies: 2728 2728
4513-- Name: ax_strasse_pk; Type: CONSTRAINT; Schema: public; Owner: -
4514--
4515
4516ALTER TABLE ONLY ax_strasse
4517    ADD CONSTRAINT ax_strasse_pk PRIMARY KEY (ogc_fid);
4518
4519
4520--
4521-- TOC entry 3461 (class 2606 OID 30366)
4522-- Dependencies: 2710 2710
4523-- Name: ax_strassenachse_pk; Type: CONSTRAINT; Schema: public; Owner: -
4524--
4525
4526ALTER TABLE ONLY ax_strassenachse
4527    ADD CONSTRAINT ax_strassenachse_pk PRIMARY KEY (ogc_fid);
4528
4529
4530--
4531-- TOC entry 3464 (class 2606 OID 30382)
4532-- Dependencies: 2712 2712
4533-- Name: ax_strassenverkehr_pk; Type: CONSTRAINT; Schema: public; Owner: -
4534--
4535
4536ALTER TABLE ONLY ax_strassenverkehr
4537    ADD CONSTRAINT ax_strassenverkehr_pk PRIMARY KEY (ogc_fid);
4538
4539
4540--
4541-- TOC entry 3476 (class 2606 OID 30446)
4542-- Dependencies: 2720 2720
4543-- Name: ax_strassenverkehrsanlage_pk; Type: CONSTRAINT; Schema: public; Owner: -
4544--
4545
4546ALTER TABLE ONLY ax_strassenverkehrsanlage
4547    ADD CONSTRAINT ax_strassenverkehrsanlage_pk PRIMARY KEY (ogc_fid);
4548
4549
4550--
4551-- TOC entry 3560 (class 2606 OID 34087)
4552-- Dependencies: 2778 2778
4553-- Name: ax_sumpf_pk; Type: CONSTRAINT; Schema: public; Owner: -
4554--
4555
4556ALTER TABLE ONLY ax_sumpf
4557    ADD CONSTRAINT ax_sumpf_pk PRIMARY KEY (ogc_fid);
4558
4559
4560--
4561-- TOC entry 3525 (class 2606 OID 30892)
4562-- Dependencies: 2754 2754
4563-- Name: ax_tagebaugrubesteinbruch_pk; Type: CONSTRAINT; Schema: public; Owner: -
4564--
4565
4566ALTER TABLE ONLY ax_tagebaugrubesteinbruch
4567    ADD CONSTRAINT ax_tagebaugrubesteinbruch_pk PRIMARY KEY (ogc_fid);
4568
4569
4570--
4571-- TOC entry 3473 (class 2606 OID 30430)
4572-- Dependencies: 2718 2718
4573-- Name: ax_transportanlage_pk; Type: CONSTRAINT; Schema: public; Owner: -
4574--
4575
4576ALTER TABLE ONLY ax_transportanlage
4577    ADD CONSTRAINT ax_transportanlage_pk PRIMARY KEY (ogc_fid);
4578
4579
4580--
4581-- TOC entry 3470 (class 2606 OID 30414)
4582-- Dependencies: 2716 2716
4583-- Name: ax_turm_pk; Type: CONSTRAINT; Schema: public; Owner: -
4584--
4585
4586ALTER TABLE ONLY ax_turm
4587    ADD CONSTRAINT ax_turm_pk PRIMARY KEY (ogc_fid);
4588
4589
4590--
4591-- TOC entry 3467 (class 2606 OID 30398)
4592-- Dependencies: 2714 2714
4593-- Name: ax_unlandvegetationsloseflaeche_pk; Type: CONSTRAINT; Schema: public; Owner: -
4594--
4595
4596ALTER TABLE ONLY ax_unlandvegetationsloseflaeche
4597    ADD CONSTRAINT ax_unlandvegetationsloseflaeche_pk PRIMARY KEY (ogc_fid);
4598
4599
4600--
4601-- TOC entry 3479 (class 2606 OID 30462)
4602-- Dependencies: 2722 2722
4603-- Name: ax_vegetationsmerkmal_pk; Type: CONSTRAINT; Schema: public; Owner: -
4604--
4605
4606ALTER TABLE ONLY ax_vegetationsmerkmal
4607    ADD CONSTRAINT ax_vegetationsmerkmal_pk PRIMARY KEY (ogc_fid);
4608
4609
4610--
4611-- TOC entry 3396 (class 2606 OID 29866)
4612-- Dependencies: 2666 2666
4613-- Name: ax_wald_pk; Type: CONSTRAINT; Schema: public; Owner: -
4614--
4615
4616ALTER TABLE ONLY ax_wald
4617    ADD CONSTRAINT ax_wald_pk PRIMARY KEY (ogc_fid);
4618
4619
4620--
4621-- TOC entry 3527 (class 2606 OID 30992)
4622-- Dependencies: 2756 2756
4623-- Name: ax_wasserlauf_pk; Type: CONSTRAINT; Schema: public; Owner: -
4624--
4625
4626ALTER TABLE ONLY ax_wasserlauf
4627    ADD CONSTRAINT ax_wasserlauf_pk PRIMARY KEY (ogc_fid);
4628
4629
4630--
4631-- TOC entry 3539 (class 2606 OID 32129)
4632-- Dependencies: 2764 2764
4633-- Name: ax_wasserspiegelhoehe_pk; Type: CONSTRAINT; Schema: public; Owner: -
4634--
4635
4636ALTER TABLE ONLY ax_wasserspiegelhoehe
4637    ADD CONSTRAINT ax_wasserspiegelhoehe_pk PRIMARY KEY (ogc_fid);
4638
4639
4640--
4641-- TOC entry 3399 (class 2606 OID 29888)
4642-- Dependencies: 2668 2668
4643-- Name: ax_wegpfadsteig_pk; Type: CONSTRAINT; Schema: public; Owner: -
4644--
4645
4646ALTER TABLE ONLY ax_wegpfadsteig
4647    ADD CONSTRAINT ax_wegpfadsteig_pk PRIMARY KEY (ogc_fid);
4648
4649
4650--
4651-- TOC entry 3482 (class 2606 OID 30506)
4652-- Dependencies: 2724 2724
4653-- Name: ax_wohnbauflaeche_pk; Type: CONSTRAINT; Schema: public; Owner: -
4654--
4655
4656ALTER TABLE ONLY ax_wohnbauflaeche
4657    ADD CONSTRAINT ax_wohnbauflaeche_pk PRIMARY KEY (ogc_fid);
4658
4659
4660--
4661-- TOC entry 3485 (class 2606 OID 30522)
4662-- Dependencies: 2726 2726
4663-- Name: ax_wohnplatz_pk; Type: CONSTRAINT; Schema: public; Owner: -
4664--
4665
4666ALTER TABLE ONLY ax_wohnplatz
4667    ADD CONSTRAINT ax_wohnplatz_pk PRIMARY KEY (ogc_fid);
4668
4669
4670--
4671-- TOC entry 3402 (class 1259 OID 29924)
4672-- Dependencies: 2672 2269
4673-- Name: ax_abschnitt_geom_idx; Type: INDEX; Schema: public; Owner: -
4674--
4675
4676CREATE INDEX ax_abschnitt_geom_idx ON ax_abschnitt USING gist (wkb_geometry);
4677
4678
4679--
4680-- TOC entry 3405 (class 1259 OID 29940)
4681-- Dependencies: 2674 2269
4682-- Name: ax_ast_geom_idx; Type: INDEX; Schema: public; Owner: -
4683--
4684
4685CREATE INDEX ax_ast_geom_idx ON ax_ast USING gist (wkb_geometry);
4686
4687
4688--
4689-- TOC entry 3493 (class 1259 OID 30581)
4690-- Dependencies: 2269 2734
4691-- Name: ax_bahnstrecke_geom_idx; Type: INDEX; Schema: public; Owner: -
4692--
4693
4694CREATE INDEX ax_bahnstrecke_geom_idx ON ax_bahnstrecke USING gist (wkb_geometry);
4695
4696
4697--
4698-- TOC entry 3546 (class 1259 OID 33482)
4699-- Dependencies: 2770 2269
4700-- Name: ax_bahnverkehr_geom_idx; Type: INDEX; Schema: public; Owner: -
4701--
4702
4703CREATE INDEX ax_bahnverkehr_geom_idx ON ax_bahnverkehr USING gist (wkb_geometry);
4704
4705
4706--
4707-- TOC entry 3490 (class 1259 OID 30565)
4708-- Dependencies: 2269 2732
4709-- Name: ax_bahnverkehrsanlage_geom_idx; Type: INDEX; Schema: public; Owner: -
4710--
4711
4712CREATE INDEX ax_bahnverkehrsanlage_geom_idx ON ax_bahnverkehrsanlage USING gist (wkb_geometry);
4713
4714
4715--
4716-- TOC entry 3408 (class 1259 OID 29956)
4717-- Dependencies: 2676 2269
4718-- Name: ax_bauwerkimgewaesserbereich_geom_idx; Type: INDEX; Schema: public; Owner: -
4719--
4720
4721CREATE INDEX ax_bauwerkimgewaesserbereich_geom_idx ON ax_bauwerkimgewaesserbereich USING gist (wkb_geometry);
4722
4723
4724--
4725-- TOC entry 3414 (class 1259 OID 29987)
4726-- Dependencies: 2680 2269
4727-- Name: ax_bauwerkimverkehrsbereich_geom_idx; Type: INDEX; Schema: public; Owner: -
4728--
4729
4730CREATE INDEX ax_bauwerkimverkehrsbereich_geom_idx ON ax_bauwerkimverkehrsbereich USING gist (wkb_geometry);
4731
4732
4733--
4734-- TOC entry 3417 (class 1259 OID 30003)
4735-- Dependencies: 2269 2682
4736-- Name: ax_bauwerkoderanlagefuerindustrieundgewerbe_geom_idx; Type: INDEX; Schema: public; Owner: -
4737--
4738
4739CREATE INDEX ax_bauwerkoderanlagefuerindustrieundgewerbe_geom_idx ON ax_bauwerkoderanlagefuerindustrieundgewerbe USING gist (wkb_geometry);
4740
4741
4742--
4743-- TOC entry 3411 (class 1259 OID 29972)
4744-- Dependencies: 2269 2678
4745-- Name: ax_bauwerkoderanlagefuersportfreizeitunderholung_geom_idx; Type: INDEX; Schema: public; Owner: -
4746--
4747
4748CREATE INDEX ax_bauwerkoderanlagefuersportfreizeitunderholung_geom_idx ON ax_bauwerkoderanlagefuersportfreizeitunderholung USING gist (wkb_geometry);
4749
4750
4751--
4752-- TOC entry 3584 (class 1259 OID 133078)
4753-- Dependencies: 2796 2269
4754-- Name: ax_bergbaubetrieb_geom_idx; Type: INDEX; Schema: public; Owner: -
4755--
4756
4757CREATE INDEX ax_bergbaubetrieb_geom_idx ON ax_bergbaubetrieb USING gist (wkb_geometry);
4758
4759
4760--
4761-- TOC entry 3499 (class 1259 OID 30613)
4762-- Dependencies: 2269 2738
4763-- Name: ax_dammwalldeich_geom_idx; Type: INDEX; Schema: public; Owner: -
4764--
4765
4766CREATE INDEX ax_dammwalldeich_geom_idx ON ax_dammwalldeich USING gist (wkb_geometry);
4767
4768
4769--
4770-- TOC entry 3528 (class 1259 OID 31012)
4771-- Dependencies: 2269 2758
4772-- Name: ax_denkmalschutzrecht_geom_idx; Type: INDEX; Schema: public; Owner: -
4773--
4774
4775CREATE INDEX ax_denkmalschutzrecht_geom_idx ON ax_denkmalschutzrecht USING gist (wkb_geometry);
4776
4777
4778--
4779-- TOC entry 3496 (class 1259 OID 30597)
4780-- Dependencies: 2269 2736
4781-- Name: ax_einrichtungenfuerdenschiffsverkehr_geom_idx; Type: INDEX; Schema: public; Owner: -
4782--
4783
4784CREATE INDEX ax_einrichtungenfuerdenschiffsverkehr_geom_idx ON ax_einrichtungenfuerdenschiffsverkehr USING gist (wkb_geometry);
4785
4786
4787--
4788-- TOC entry 3420 (class 1259 OID 30019)
4789-- Dependencies: 2684 2269
4790-- Name: ax_fahrbahnachse_geom_idx; Type: INDEX; Schema: public; Owner: -
4791--
4792
4793CREATE INDEX ax_fahrbahnachse_geom_idx ON ax_fahrbahnachse USING gist (wkb_geometry);
4794
4795
4796--
4797-- TOC entry 3373 (class 1259 OID 29732)
4798-- Dependencies: 2269 2652
4799-- Name: ax_fahrwegachse_geom_idx; Type: INDEX; Schema: public; Owner: -
4800--
4801
4802CREATE INDEX ax_fahrwegachse_geom_idx ON ax_fahrwegachse USING gist (wkb_geometry);
4803
4804
4805--
4806-- TOC entry 3531 (class 1259 OID 31057)
4807-- Dependencies: 2760 2269
4808-- Name: ax_felsenfelsblockfelsnadel_geom_idx; Type: INDEX; Schema: public; Owner: -
4809--
4810
4811CREATE INDEX ax_felsenfelsblockfelsnadel_geom_idx ON ax_felsenfelsblockfelsnadel USING gist (wkb_geometry);
4812
4813
4814--
4815-- TOC entry 3423 (class 1259 OID 30035)
4816-- Dependencies: 2269 2686
4817-- Name: ax_flaechebesondererfunktionalerpraegung_geom_idx; Type: INDEX; Schema: public; Owner: -
4818--
4819
4820CREATE INDEX ax_flaechebesondererfunktionalerpraegung_geom_idx ON ax_flaechebesondererfunktionalerpraegung USING gist (wkb_geometry);
4821
4822
4823--
4824-- TOC entry 3426 (class 1259 OID 30051)
4825-- Dependencies: 2269 2688
4826-- Name: ax_flaechegemischternutzung_geom_idx; Type: INDEX; Schema: public; Owner: -
4827--
4828
4829CREATE INDEX ax_flaechegemischternutzung_geom_idx ON ax_flaechegemischternutzung USING gist (wkb_geometry);
4830
4831
4832--
4833-- TOC entry 3502 (class 1259 OID 30629)
4834-- Dependencies: 2740 2269
4835-- Name: ax_flaechezurzeitunbestimmbar_geom_idx; Type: INDEX; Schema: public; Owner: -
4836--
4837
4838CREATE INDEX ax_flaechezurzeitunbestimmbar_geom_idx ON ax_flaechezurzeitunbestimmbar USING gist (wkb_geometry);
4839
4840
4841--
4842-- TOC entry 3505 (class 1259 OID 30645)
4843-- Dependencies: 2269 2742
4844-- Name: ax_fliessgewaesser_geom_idx; Type: INDEX; Schema: public; Owner: -
4845--
4846
4847CREATE INDEX ax_fliessgewaesser_geom_idx ON ax_fliessgewaesser USING gist (wkb_geometry);
4848
4849
4850--
4851-- TOC entry 3540 (class 1259 OID 32195)
4852-- Dependencies: 2766 2269
4853-- Name: ax_flugverkehr_geom_idx; Type: INDEX; Schema: public; Owner: -
4854--
4855
4856CREATE INDEX ax_flugverkehr_geom_idx ON ax_flugverkehr USING gist (wkb_geometry);
4857
4858
4859--
4860-- TOC entry 3543 (class 1259 OID 33047)
4861-- Dependencies: 2269 2768
4862-- Name: ax_flugverkehrsanlage_geom_idx; Type: INDEX; Schema: public; Owner: -
4863--
4864
4865CREATE INDEX ax_flugverkehrsanlage_geom_idx ON ax_flugverkehrsanlage USING gist (wkb_geometry);
4866
4867
4868--
4869-- TOC entry 3429 (class 1259 OID 30067)
4870-- Dependencies: 2269 2690
4871-- Name: ax_friedhof_geom_idx; Type: INDEX; Schema: public; Owner: -
4872--
4873
4874CREATE INDEX ax_friedhof_geom_idx ON ax_friedhof USING gist (wkb_geometry);
4875
4876
4877--
4878-- TOC entry 3432 (class 1259 OID 30083)
4879-- Dependencies: 2269 2692
4880-- Name: ax_gebaeude_geom_idx; Type: INDEX; Schema: public; Owner: -
4881--
4882
4883CREATE INDEX ax_gebaeude_geom_idx ON ax_gebaeude USING gist (wkb_geometry);
4884
4885
4886--
4887-- TOC entry 3376 (class 1259 OID 29748)
4888-- Dependencies: 2654 2269
4889-- Name: ax_gebietsgrenze_geom_idx; Type: INDEX; Schema: public; Owner: -
4890--
4891
4892CREATE INDEX ax_gebietsgrenze_geom_idx ON ax_gebietsgrenze USING gist (wkb_geometry);
4893
4894
4895--
4896-- TOC entry 3435 (class 1259 OID 30141)
4897-- Dependencies: 2269 2694
4898-- Name: ax_gehoelz_geom_idx; Type: INDEX; Schema: public; Owner: -
4899--
4900
4901CREATE INDEX ax_gehoelz_geom_idx ON ax_gehoelz USING gist (wkb_geometry);
4902
4903
4904--
4905-- TOC entry 3379 (class 1259 OID 29774)
4906-- Dependencies: 2656 2269
4907-- Name: ax_gewaesserachse_geom_idx; Type: INDEX; Schema: public; Owner: -
4908--
4909
4910CREATE INDEX ax_gewaesserachse_geom_idx ON ax_gewaesserachse USING gist (wkb_geometry);
4911
4912
4913--
4914-- TOC entry 3508 (class 1259 OID 30722)
4915-- Dependencies: 2269 2744
4916-- Name: ax_gewaessermerkmal_geom_idx; Type: INDEX; Schema: public; Owner: -
4917--
4918
4919CREATE INDEX ax_gewaessermerkmal_geom_idx ON ax_gewaessermerkmal USING gist (wkb_geometry);
4920
4921
4922--
4923-- TOC entry 3514 (class 1259 OID 30756)
4924-- Dependencies: 2748 2269
4925-- Name: ax_gewaesserstationierungsachse_geom_idx; Type: INDEX; Schema: public; Owner: -
4926--
4927
4928CREATE INDEX ax_gewaesserstationierungsachse_geom_idx ON ax_gewaesserstationierungsachse USING gist (wkb_geometry);
4929
4930
4931--
4932-- TOC entry 3552 (class 1259 OID 33743)
4933-- Dependencies: 2269 2774
4934-- Name: ax_hafen_geom_idx; Type: INDEX; Schema: public; Owner: -
4935--
4936
4937CREATE INDEX ax_hafen_geom_idx ON ax_hafen USING gist (wkb_geometry);
4938
4939
4940--
4941-- TOC entry 3549 (class 1259 OID 33719)
4942-- Dependencies: 2269 2772
4943-- Name: ax_hafenbecken_geom_idx; Type: INDEX; Schema: public; Owner: -
4944--
4945
4946CREATE INDEX ax_hafenbecken_geom_idx ON ax_hafenbecken USING gist (wkb_geometry);
4947
4948
4949--
4950-- TOC entry 3561 (class 1259 OID 36958)
4951-- Dependencies: 2780 2269
4952-- Name: ax_halde_geom_idx; Type: INDEX; Schema: public; Owner: -
4953--
4954
4955CREATE INDEX ax_halde_geom_idx ON ax_halde USING gist (wkb_geometry);
4956
4957
4958--
4959-- TOC entry 3579 (class 1259 OID 63886)
4960-- Dependencies: 2792 2269
4961-- Name: ax_heide_geom_idx; Type: INDEX; Schema: public; Owner: -
4962--
4963
4964CREATE INDEX ax_heide_geom_idx ON ax_heide USING gist (wkb_geometry);
4965
4966
4967--
4968-- TOC entry 3382 (class 1259 OID 29790)
4969-- Dependencies: 2269 2658
4970-- Name: ax_historischesbauwerkoderhistorischeeinrichtung_geom_idx; Type: INDEX; Schema: public; Owner: -
4971--
4972
4973CREATE INDEX ax_historischesbauwerkoderhistorischeeinrichtung_geom_idx ON ax_historischesbauwerkoderhistorischeeinrichtung USING gist (wkb_geometry);
4974
4975
4976--
4977-- TOC entry 3534 (class 1259 OID 31397)
4978-- Dependencies: 2762 2269
4979-- Name: ax_hoehleneingang_geom_idx; Type: INDEX; Schema: public; Owner: -
4980--
4981
4982CREATE INDEX ax_hoehleneingang_geom_idx ON ax_hoehleneingang USING gist (wkb_geometry);
4983
4984
4985--
4986-- TOC entry 3438 (class 1259 OID 30198)
4987-- Dependencies: 2696 2269
4988-- Name: ax_industrieundgewerbeflaeche_geom_idx; Type: INDEX; Schema: public; Owner: -
4989--
4990
4991CREATE INDEX ax_industrieundgewerbeflaeche_geom_idx ON ax_industrieundgewerbeflaeche USING gist (wkb_geometry);
4992
4993
4994--
4995-- TOC entry 3511 (class 1259 OID 30740)
4996-- Dependencies: 2746 2269
4997-- Name: ax_insel_geom_idx; Type: INDEX; Schema: public; Owner: -
4998--
4999
5000CREATE INDEX ax_insel_geom_idx ON ax_insel USING gist (wkb_geometry);
5001
5002
5003--
5004-- TOC entry 3385 (class 1259 OID 29806)
5005-- Dependencies: 2269 2660
5006-- Name: ax_kommunalesgebiet_geom_idx; Type: INDEX; Schema: public; Owner: -
5007--
5008
5009CREATE INDEX ax_kommunalesgebiet_geom_idx ON ax_kommunalesgebiet USING gist (wkb_geometry);
5010
5011
5012--
5013-- TOC entry 3573 (class 1259 OID 61535)
5014-- Dependencies: 2269 2788
5015-- Name: ax_kondominium_geom_idx; Type: INDEX; Schema: public; Owner: -
5016--
5017
5018CREATE INDEX ax_kondominium_geom_idx ON ax_kondominium USING gist (wkb_geometry);
5019
5020
5021--
5022-- TOC entry 3388 (class 1259 OID 29828)
5023-- Dependencies: 2662 2269
5024-- Name: ax_landwirtschaft_geom_idx; Type: INDEX; Schema: public; Owner: -
5025--
5026
5027CREATE INDEX ax_landwirtschaft_geom_idx ON ax_landwirtschaft USING gist (wkb_geometry);
5028
5029
5030--
5031-- TOC entry 3517 (class 1259 OID 30824)
5032-- Dependencies: 2269 2750
5033-- Name: ax_leitung_geom_idx; Type: INDEX; Schema: public; Owner: -
5034--
5035
5036CREATE INDEX ax_leitung_geom_idx ON ax_leitung USING gist (wkb_geometry);
5037
5038
5039--
5040-- TOC entry 3570 (class 1259 OID 51747)
5041-- Dependencies: 2786 2269
5042-- Name: ax_moor_geom_idx; Type: INDEX; Schema: public; Owner: -
5043--
5044
5045CREATE INDEX ax_moor_geom_idx ON ax_moor USING gist (wkb_geometry);
5046
5047
5048--
5049-- TOC entry 3391 (class 1259 OID 29848)
5050-- Dependencies: 2269 2664
5051-- Name: ax_naturumweltoderbodenschutzrecht_geom_idx; Type: INDEX; Schema: public; Owner: -
5052--
5053
5054CREATE INDEX ax_naturumweltoderbodenschutzrecht_geom_idx ON ax_naturumweltoderbodenschutzrecht USING gist (wkb_geometry);
5055
5056
5057--
5058-- TOC entry 3450 (class 1259 OID 30326)
5059-- Dependencies: 2269 2704
5060-- Name: ax_nullpunkt_geom_idx; Type: INDEX; Schema: public; Owner: -
5061--
5062
5063CREATE INDEX ax_nullpunkt_geom_idx ON ax_nullpunkt USING gist (wkb_geometry);
5064
5065
5066--
5067-- TOC entry 3444 (class 1259 OID 30292)
5068-- Dependencies: 2700 2269
5069-- Name: ax_ortslage_geom_idx; Type: INDEX; Schema: public; Owner: -
5070--
5071
5072CREATE INDEX ax_ortslage_geom_idx ON ax_ortslage USING gist (wkb_geometry);
5073
5074
5075--
5076-- TOC entry 3441 (class 1259 OID 30276)
5077-- Dependencies: 2698 2269
5078-- Name: ax_platz_geom_idx; Type: INDEX; Schema: public; Owner: -
5079--
5080
5081CREATE INDEX ax_platz_geom_idx ON ax_platz USING gist (wkb_geometry);
5082
5083
5084--
5085-- TOC entry 3520 (class 1259 OID 30855)
5086-- Dependencies: 2752 2269
5087-- Name: ax_schifffahrtsliniefaehrverkehr_geom_idx; Type: INDEX; Schema: public; Owner: -
5088--
5089
5090CREATE INDEX ax_schifffahrtsliniefaehrverkehr_geom_idx ON ax_schifffahrtsliniefaehrverkehr USING gist (wkb_geometry);
5091
5092
5093--
5094-- TOC entry 3555 (class 1259 OID 33875)
5095-- Dependencies: 2269 2776
5096-- Name: ax_schiffsverkehr_geom_idx; Type: INDEX; Schema: public; Owner: -
5097--
5098
5099CREATE INDEX ax_schiffsverkehr_geom_idx ON ax_schiffsverkehr USING gist (wkb_geometry);
5100
5101
5102--
5103-- TOC entry 3576 (class 1259 OID 61554)
5104-- Dependencies: 2790 2269
5105-- Name: ax_schleuse_geom_idx; Type: INDEX; Schema: public; Owner: -
5106--
5107
5108CREATE INDEX ax_schleuse_geom_idx ON ax_schleuse USING gist (wkb_geometry);
5109
5110
5111--
5112-- TOC entry 3564 (class 1259 OID 40034)
5113-- Dependencies: 2269 2782
5114-- Name: ax_seilbahnschwebebahn_geom_idx; Type: INDEX; Schema: public; Owner: -
5115--
5116
5117CREATE INDEX ax_seilbahnschwebebahn_geom_idx ON ax_seilbahnschwebebahn USING gist (wkb_geometry);
5118
5119
5120--
5121-- TOC entry 3447 (class 1259 OID 30310)
5122-- Dependencies: 2269 2702
5123-- Name: ax_sonstigesbauwerkodersonstigeeinrichtung_geom_idx; Type: INDEX; Schema: public; Owner: -
5124--
5125
5126CREATE INDEX ax_sonstigesbauwerkodersonstigeeinrichtung_geom_idx ON ax_sonstigesbauwerkodersonstigeeinrichtung USING gist (wkb_geometry);
5127
5128
5129--
5130-- TOC entry 3567 (class 1259 OID 40105)
5131-- Dependencies: 2784 2269
5132-- Name: ax_sonstigesrecht_geom_idx; Type: INDEX; Schema: public; Owner: -
5133--
5134
5135CREATE INDEX ax_sonstigesrecht_geom_idx ON ax_sonstigesrecht USING gist (wkb_geometry);
5136
5137
5138--
5139-- TOC entry 3453 (class 1259 OID 30342)
5140-- Dependencies: 2706 2269
5141-- Name: ax_sportfreizeitunderholungsflaeche_geom_idx; Type: INDEX; Schema: public; Owner: -
5142--
5143
5144CREATE INDEX ax_sportfreizeitunderholungsflaeche_geom_idx ON ax_sportfreizeitunderholungsflaeche USING gist (wkb_geometry);
5145
5146
5147--
5148-- TOC entry 3456 (class 1259 OID 30358)
5149-- Dependencies: 2708 2269
5150-- Name: ax_stehendesgewaesser_geom_idx; Type: INDEX; Schema: public; Owner: -
5151--
5152
5153CREATE INDEX ax_stehendesgewaesser_geom_idx ON ax_stehendesgewaesser USING gist (wkb_geometry);
5154
5155
5156--
5157-- TOC entry 3459 (class 1259 OID 30374)
5158-- Dependencies: 2269 2710
5159-- Name: ax_strassenachse_geom_idx; Type: INDEX; Schema: public; Owner: -
5160--
5161
5162CREATE INDEX ax_strassenachse_geom_idx ON ax_strassenachse USING gist (wkb_geometry);
5163
5164
5165--
5166-- TOC entry 3462 (class 1259 OID 30390)
5167-- Dependencies: 2269 2712
5168-- Name: ax_strassenverkehr_geom_idx; Type: INDEX; Schema: public; Owner: -
5169--
5170
5171CREATE INDEX ax_strassenverkehr_geom_idx ON ax_strassenverkehr USING gist (wkb_geometry);
5172
5173
5174--
5175-- TOC entry 3474 (class 1259 OID 30454)
5176-- Dependencies: 2269 2720
5177-- Name: ax_strassenverkehrsanlage_geom_idx; Type: INDEX; Schema: public; Owner: -
5178--
5179
5180CREATE INDEX ax_strassenverkehrsanlage_geom_idx ON ax_strassenverkehrsanlage USING gist (wkb_geometry);
5181
5182
5183--
5184-- TOC entry 3558 (class 1259 OID 34095)
5185-- Dependencies: 2778 2269
5186-- Name: ax_sumpf_geom_idx; Type: INDEX; Schema: public; Owner: -
5187--
5188
5189CREATE INDEX ax_sumpf_geom_idx ON ax_sumpf USING gist (wkb_geometry);
5190
5191
5192--
5193-- TOC entry 3523 (class 1259 OID 30900)
5194-- Dependencies: 2269 2754
5195-- Name: ax_tagebaugrubesteinbruch_geom_idx; Type: INDEX; Schema: public; Owner: -
5196--
5197
5198CREATE INDEX ax_tagebaugrubesteinbruch_geom_idx ON ax_tagebaugrubesteinbruch USING gist (wkb_geometry);
5199
5200
5201--
5202-- TOC entry 3471 (class 1259 OID 30438)
5203-- Dependencies: 2269 2718
5204-- Name: ax_transportanlage_geom_idx; Type: INDEX; Schema: public; Owner: -
5205--
5206
5207CREATE INDEX ax_transportanlage_geom_idx ON ax_transportanlage USING gist (wkb_geometry);
5208
5209
5210--
5211-- TOC entry 3468 (class 1259 OID 30422)
5212-- Dependencies: 2269 2716
5213-- Name: ax_turm_geom_idx; Type: INDEX; Schema: public; Owner: -
5214--
5215
5216CREATE INDEX ax_turm_geom_idx ON ax_turm USING gist (wkb_geometry);
5217
5218
5219--
5220-- TOC entry 3465 (class 1259 OID 30406)
5221-- Dependencies: 2269 2714
5222-- Name: ax_unlandvegetationsloseflaeche_geom_idx; Type: INDEX; Schema: public; Owner: -
5223--
5224
5225CREATE INDEX ax_unlandvegetationsloseflaeche_geom_idx ON ax_unlandvegetationsloseflaeche USING gist (wkb_geometry);
5226
5227
5228--
5229-- TOC entry 3477 (class 1259 OID 30469)
5230-- Dependencies: 2722 2269
5231-- Name: ax_vegetationsmerkmal_geom_idx; Type: INDEX; Schema: public; Owner: -
5232--
5233
5234CREATE INDEX ax_vegetationsmerkmal_geom_idx ON ax_vegetationsmerkmal USING gist (wkb_geometry);
5235
5236
5237--
5238-- TOC entry 3394 (class 1259 OID 29874)
5239-- Dependencies: 2666 2269
5240-- Name: ax_wald_geom_idx; Type: INDEX; Schema: public; Owner: -
5241--
5242
5243CREATE INDEX ax_wald_geom_idx ON ax_wald USING gist (wkb_geometry);
5244
5245
5246--
5247-- TOC entry 3537 (class 1259 OID 32137)
5248-- Dependencies: 2764 2269
5249-- Name: ax_wasserspiegelhoehe_geom_idx; Type: INDEX; Schema: public; Owner: -
5250--
5251
5252CREATE INDEX ax_wasserspiegelhoehe_geom_idx ON ax_wasserspiegelhoehe USING gist (wkb_geometry);
5253
5254
5255--
5256-- TOC entry 3397 (class 1259 OID 29896)
5257-- Dependencies: 2668 2269
5258-- Name: ax_wegpfadsteig_geom_idx; Type: INDEX; Schema: public; Owner: -
5259--
5260
5261CREATE INDEX ax_wegpfadsteig_geom_idx ON ax_wegpfadsteig USING gist (wkb_geometry);
5262
5263
5264--
5265-- TOC entry 3480 (class 1259 OID 30514)
5266-- Dependencies: 2724 2269
5267-- Name: ax_wohnbauflaeche_geom_idx; Type: INDEX; Schema: public; Owner: -
5268--
5269
5270CREATE INDEX ax_wohnbauflaeche_geom_idx ON ax_wohnbauflaeche USING gist (wkb_geometry);
5271
5272
5273--
5274-- TOC entry 3483 (class 1259 OID 30530)
5275-- Dependencies: 2726 2269
5276-- Name: ax_wohnplatz_geom_idx; Type: INDEX; Schema: public; Owner: -
5277--
5278
5279CREATE INDEX ax_wohnplatz_geom_idx ON ax_wohnplatz USING gist (wkb_geometry);
5280
5281
5282-- Completed on 2011-07-07 07:43:06 CEST
5283
5284--
5285-- PostgreSQL database dump complete
5286--
5287
5288
5289--create content of table geometry_columns
5290--
5291-- TOC entry 3087 (class 0 OID 16749)
5292-- Dependencies: 2640
5293-- Data for Name: geometry_columns; Type: TABLE DATA; Schema: public; Owner: postgres
5294--
5295
5296INSERT INTO geometry_columns VALUES ('', 'public', 'ax_fahrwegachse', 'wkb_geometry', 2, 25832, 'LINESTRING');
5297INSERT INTO geometry_columns VALUES ('', 'public', 'ax_gebietsgrenze', 'wkb_geometry', 2, 25832, 'LINESTRING');
5298INSERT INTO geometry_columns VALUES ('', 'public', 'ax_gewaesserachse', 'wkb_geometry', 2, 25832, 'LINESTRING');
5299INSERT INTO geometry_columns VALUES ('', 'public', 'ax_historischesbauwerkoderhistorischeeinrichtung', 'wkb_geometry', 2, 25832, 'GEOMETRY');--LINESTRING
5300INSERT INTO geometry_columns VALUES ('', 'public', 'ax_kommunalesgebiet', 'wkb_geometry', 2, 25832, 'POLYGON');
5301INSERT INTO geometry_columns VALUES ('', 'public', 'ax_landwirtschaft', 'wkb_geometry', 2, 25832, 'POLYGON');
5302INSERT INTO geometry_columns VALUES ('', 'public', 'ax_naturumweltoderbodenschutzrecht', 'wkb_geometry', 2, 25832, 'GEOMETRY');--POLYGON
5303INSERT INTO geometry_columns VALUES ('', 'public', 'ax_wald', 'wkb_geometry', 2, 25832, 'POLYGON');
5304INSERT INTO geometry_columns VALUES ('', 'public', 'ax_wegpfadsteig', 'wkb_geometry', 2, 25832, 'LINESTRING');
5305INSERT INTO geometry_columns VALUES ('', 'public', 'ax_abschnitt', 'wkb_geometry', 2, 25832, 'LINESTRING');
5306INSERT INTO geometry_columns VALUES ('', 'public', 'ax_ast', 'wkb_geometry', 2, 25832, 'LINESTRING');
5307INSERT INTO geometry_columns VALUES ('', 'public', 'ax_bauwerkimgewaesserbereich', 'wkb_geometry', 2, 25832, 'GEOMETRY');--LINESTRING
5308INSERT INTO geometry_columns VALUES ('', 'public', 'ax_bauwerkoderanlagefuersportfreizeitunderholung', 'wkb_geometry', 2, 25832, 'GEOMETRY');--POLYGON
5309INSERT INTO geometry_columns VALUES ('', 'public', 'ax_bauwerkimverkehrsbereich', 'wkb_geometry', 2, 25832, 'GEOMETRY');
5310INSERT INTO geometry_columns VALUES ('', 'public', 'ax_bauwerkoderanlagefuerindustrieundgewerbe', 'wkb_geometry', 2, 25832, 'GEOMETRY');--POINT
5311INSERT INTO geometry_columns VALUES ('', 'public', 'ax_fahrbahnachse', 'wkb_geometry', 2, 25832, 'LINESTRING');
5312INSERT INTO geometry_columns VALUES ('', 'public', 'ax_flaechebesondererfunktionalerpraegung', 'wkb_geometry', 2, 25832, 'POLYGON');
5313INSERT INTO geometry_columns VALUES ('', 'public', 'ax_flaechegemischternutzung', 'wkb_geometry', 2, 25832, 'POLYGON');
5314INSERT INTO geometry_columns VALUES ('', 'public', 'ax_friedhof', 'wkb_geometry', 2, 25832, 'POLYGON');
5315INSERT INTO geometry_columns VALUES ('', 'public', 'ax_gebaeude', 'wkb_geometry', 2, 25832, 'GEOMETRY');--POINT
5316INSERT INTO geometry_columns VALUES ('', 'public', 'ax_gehoelz', 'wkb_geometry', 2, 25832, 'POLYGON');
5317INSERT INTO geometry_columns VALUES ('', 'public', 'ax_industrieundgewerbeflaeche', 'wkb_geometry', 2, 25832, 'POLYGON');
5318INSERT INTO geometry_columns VALUES ('', 'public', 'ax_platz', 'wkb_geometry', 2, 25832, 'POLYGON');
5319INSERT INTO geometry_columns VALUES ('', 'public', 'ax_ortslage', 'wkb_geometry', 2, 25832, 'POLYGON');
5320INSERT INTO geometry_columns VALUES ('', 'public', 'ax_sonstigesbauwerkodersonstigeeinrichtung', 'wkb_geometry', 2, 25832, 'GEOMETRY');--POINT
5321INSERT INTO geometry_columns VALUES ('', 'public', 'ax_nullpunkt', 'wkb_geometry', 2, 25832, 'POINT');
5322INSERT INTO geometry_columns VALUES ('', 'public', 'ax_sportfreizeitunderholungsflaeche', 'wkb_geometry', 2, 25832, 'POLYGON');
5323INSERT INTO geometry_columns VALUES ('', 'public', 'ax_stehendesgewaesser', 'wkb_geometry', 2, 25832, 'POLYGON');
5324INSERT INTO geometry_columns VALUES ('', 'public', 'ax_strassenachse', 'wkb_geometry', 2, 25832, 'LINESTRING');
5325INSERT INTO geometry_columns VALUES ('', 'public', 'ax_strassenverkehr', 'wkb_geometry', 2, 25832, 'GEOMETRY');--POLYGON
5326INSERT INTO geometry_columns VALUES ('', 'public', 'ax_unlandvegetationsloseflaeche', 'wkb_geometry', 2, 25832, 'POLYGON');
5327INSERT INTO geometry_columns VALUES ('', 'public', 'ax_turm', 'wkb_geometry', 2, 25832, 'GEOMETRY');--POINT
5328INSERT INTO geometry_columns VALUES ('', 'public', 'ax_transportanlage', 'wkb_geometry', 2, 25832, 'GEOMETRY');--POINT
5329INSERT INTO geometry_columns VALUES ('', 'public', 'ax_strassenverkehrsanlage', 'wkb_geometry', 2, 25832, 'GEOMETRY');--POINT
5330INSERT INTO geometry_columns VALUES ('', 'public', 'ax_vegetationsmerkmal', 'wkb_geometry', 2, 25832, 'GEOMETRY');
5331INSERT INTO geometry_columns VALUES ('', 'public', 'ax_wohnbauflaeche', 'wkb_geometry', 2, 25832, 'POLYGON');
5332INSERT INTO geometry_columns VALUES ('', 'public', 'ax_wohnplatz', 'wkb_geometry', 2, 25832, 'POINT');
5333INSERT INTO geometry_columns VALUES ('', 'public', 'ax_bahnverkehrsanlage', 'wkb_geometry', 2, 25832, 'GEOMETRY');--POINT
5334INSERT INTO geometry_columns VALUES ('', 'public', 'ax_bahnstrecke', 'wkb_geometry', 2, 25832, 'LINESTRING');
5335INSERT INTO geometry_columns VALUES ('', 'public', 'ax_einrichtungenfuerdenschiffsverkehr', 'wkb_geometry', 2, 25832, 'POINT');
5336INSERT INTO geometry_columns VALUES ('', 'public', 'ax_dammwalldeich', 'wkb_geometry', 2, 25832, 'GEOMETRY');--LINESTRING
5337INSERT INTO geometry_columns VALUES ('', 'public', 'ax_flaechezurzeitunbestimmbar', 'wkb_geometry', 2, 25832, 'POLYGON');
5338INSERT INTO geometry_columns VALUES ('', 'public', 'ax_fliessgewaesser', 'wkb_geometry', 2, 25832, 'POLYGON');
5339INSERT INTO geometry_columns VALUES ('', 'public', 'ax_gewaessermerkmal', 'wkb_geometry', 2, 25832, 'GEOMETRY');--POINT
5340INSERT INTO geometry_columns VALUES ('', 'public', 'ax_insel', 'wkb_geometry', 2, 25832, 'POLYGON');
5341INSERT INTO geometry_columns VALUES ('', 'public', 'ax_gewaesserstationierungsachse', 'wkb_geometry', 2, 25832, 'LINESTRING');
5342INSERT INTO geometry_columns VALUES ('', 'public', 'ax_leitung', 'wkb_geometry', 2, 25832, 'LINESTRING');
5343INSERT INTO geometry_columns VALUES ('', 'public', 'ax_schifffahrtsliniefaehrverkehr', 'wkb_geometry', 2, 25832, 'LINESTRING');
5344INSERT INTO geometry_columns VALUES ('', 'public', 'ax_tagebaugrubesteinbruch', 'wkb_geometry', 2, 25832, 'POLYGON');
5345INSERT INTO geometry_columns VALUES ('', 'public', 'ax_denkmalschutzrecht', 'wkb_geometry', 2, 25832, 'GEOMETRY');--LINESTRING
5346INSERT INTO geometry_columns VALUES ('', 'public', 'ax_felsenfelsblockfelsnadel', 'wkb_geometry', 2, 25832, 'GEOMETRY');--LINESTRING
5347INSERT INTO geometry_columns VALUES ('', 'public', 'ax_hoehleneingang', 'wkb_geometry', 2, 25832, 'POINT');
5348INSERT INTO geometry_columns VALUES ('', 'public', 'ax_wasserspiegelhoehe', 'wkb_geometry', 2, 25832, 'POINT');
5349INSERT INTO geometry_columns VALUES ('', 'public', 'ax_flugverkehr', 'wkb_geometry', 2, 25832, 'POLYGON');
5350INSERT INTO geometry_columns VALUES ('', 'public', 'ax_flugverkehrsanlage', 'wkb_geometry', 2, 25832, 'GEOMETRY');--POINT
5351INSERT INTO geometry_columns VALUES ('', 'public', 'ax_bahnverkehr', 'wkb_geometry', 2, 25832, 'POLYGON');
5352INSERT INTO geometry_columns VALUES ('', 'public', 'ax_hafenbecken', 'wkb_geometry', 2, 25832, 'POLYGON');
5353INSERT INTO geometry_columns VALUES ('', 'public', 'ax_hafen', 'wkb_geometry', 2, 25832, 'POLYGON');
5354INSERT INTO geometry_columns VALUES ('', 'public', 'ax_schiffsverkehr', 'wkb_geometry', 2, 25832, 'POLYGON');
5355INSERT INTO geometry_columns VALUES ('', 'public', 'ax_sumpf', 'wkb_geometry', 2, 25832, 'POLYGON');
5356INSERT INTO geometry_columns VALUES ('', 'public', 'ax_halde', 'wkb_geometry', 2, 25832, 'POLYGON');
5357INSERT INTO geometry_columns VALUES ('', 'public', 'ax_seilbahnschwebebahn', 'wkb_geometry', 2, 25832, 'LINESTRING');
5358INSERT INTO geometry_columns VALUES ('', 'public', 'ax_sonstigesrecht', 'wkb_geometry', 2, 25832, 'POLYGON');
5359INSERT INTO geometry_columns VALUES ('', 'public', 'ax_moor', 'wkb_geometry', 2, 25832, 'POLYGON');
5360INSERT INTO geometry_columns VALUES ('', 'public', 'ax_kondominium', 'wkb_geometry', 2, 25832, 'POLYGON');
5361INSERT INTO geometry_columns VALUES ('', 'public', 'ax_schleuse', 'wkb_geometry', 2, 25832, 'POLYGON');
5362INSERT INTO geometry_columns VALUES ('', 'public', 'ax_heide', 'wkb_geometry', 2, 25832, 'POLYGON');
5363INSERT INTO geometry_columns VALUES ('', 'public', 'ax_bergbaubetrieb', 'wkb_geometry', 2, 25832, 'POLYGON');
5364
5365
5366-- Completed on 2011-07-07 07:54:54 CEST
5367
5368--
5369-- PostgreSQL database dump complete
5370--
5371
Note: See TracBrowser for help on using the repository browser.