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

Revision 106, 152.0 KB checked in by armin.retterath, 13 years ago (diff)

Lösen des Problems der geometrielosen Tabellen. Hier wird jetzt wie auch schon für ALKIS ein dummy Eintrag in dier geometry_columns erstellt.

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