source: branches/0.6/data/konvert/postnas_0.6/atkis_rp_PostNAS_0.6_schema.sql @ 420

Revision 117, 157.2 KB checked in by tobias.dick, 7 years ago (diff)

Änderung im Datenmodell führt dazu, dass ax_kommunalesgebiet jetzt nicht mehr ein POLYGON ist, sondern als Multipolygon abgelegt wird :-( .

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    unverschluesselt character(200),
1233    istteilvon character varying,
1234    breitedesgewaessers integer,
1235    fliessrichtung character(5),
1236    hydrologischesmerkmal integer,
1237    CONSTRAINT enforce_dims_wkb_geometry CHECK ((st_ndims(wkb_geometry) = 2)),
1238    CONSTRAINT enforce_geotype_wkb_geometry CHECK (((geometrytype(wkb_geometry) = 'LINESTRING'::text) OR (wkb_geometry IS NULL))),
1239    CONSTRAINT enforce_srid_wkb_geometry CHECK ((st_srid(wkb_geometry) = 25832))
1240);
1241
1242
1243--
1244-- TOC entry 2655 (class 1259 OID 29759)
1245-- Dependencies: 2656 3
1246-- Name: ax_gewaesserachse_ogc_fid_seq; Type: SEQUENCE; Schema: public; Owner: -
1247--
1248
1249CREATE SEQUENCE ax_gewaesserachse_ogc_fid_seq
1250    START WITH 1
1251    INCREMENT BY 1
1252    NO MAXVALUE
1253    NO MINVALUE
1254    CACHE 1;
1255
1256
1257--
1258-- TOC entry 3618 (class 0 OID 0)
1259-- Dependencies: 2655
1260-- Name: ax_gewaesserachse_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1261--
1262
1263ALTER SEQUENCE ax_gewaesserachse_ogc_fid_seq OWNED BY ax_gewaesserachse.ogc_fid;
1264
1265
1266--
1267-- TOC entry 2744 (class 1259 OID 30709)
1268-- Dependencies: 3268 3269 3270 3 1087
1269-- Name: ax_gewaessermerkmal; Type: TABLE; Schema: public; Owner: -
1270--
1271
1272CREATE TABLE ax_gewaessermerkmal (
1273    ogc_fid integer NOT NULL,
1274    wkb_geometry geometry,
1275    gml_id character(16),
1276    identifier character(28),
1277    beginnt character(20),
1278    advstandardmodell character varying[],
1279    art character(16),
1280    name character(11),
1281    art_ integer,
1282    CONSTRAINT enforce_dims_wkb_geometry CHECK ((st_ndims(wkb_geometry) = 2)),
1283    --CONSTRAINT enforce_geotype_wkb_geometry CHECK (((geometrytype(wkb_geometry) = 'POINT'::text) OR (wkb_geometry IS NULL))),
1284    CONSTRAINT enforce_srid_wkb_geometry CHECK ((st_srid(wkb_geometry) = 25832))
1285);
1286
1287
1288--
1289-- TOC entry 2743 (class 1259 OID 30707)
1290-- Dependencies: 2744 3
1291-- Name: ax_gewaessermerkmal_ogc_fid_seq; Type: SEQUENCE; Schema: public; Owner: -
1292--
1293
1294CREATE SEQUENCE ax_gewaessermerkmal_ogc_fid_seq
1295    START WITH 1
1296    INCREMENT BY 1
1297    NO MAXVALUE
1298    NO MINVALUE
1299    CACHE 1;
1300
1301
1302--
1303-- TOC entry 3619 (class 0 OID 0)
1304-- Dependencies: 2743
1305-- Name: ax_gewaessermerkmal_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1306--
1307
1308ALTER SEQUENCE ax_gewaessermerkmal_ogc_fid_seq OWNED BY ax_gewaessermerkmal.ogc_fid;
1309
1310
1311--
1312-- TOC entry 2748 (class 1259 OID 30743)
1313-- Dependencies: 3276 3277 3278 1087 3
1314-- Name: ax_gewaesserstationierungsachse; Type: TABLE; Schema: public; Owner: -
1315--
1316
1317CREATE TABLE ax_gewaesserstationierungsachse (
1318    ogc_fid integer NOT NULL,
1319    wkb_geometry geometry,
1320    gml_id character(16),
1321    identifier character(28),
1322    beginnt character(20),
1323    advstandardmodell character(9),
1324    art character(16),
1325    name character(11),
1326    artdergewaesserachse integer,
1327    name_ character(200), --20
1328    gewaesserkennzahl double precision,
1329    fliessrichtung character(5),
1330    CONSTRAINT enforce_dims_wkb_geometry CHECK ((st_ndims(wkb_geometry) = 2)),
1331    CONSTRAINT enforce_geotype_wkb_geometry CHECK (((geometrytype(wkb_geometry) = 'LINESTRING'::text) OR (wkb_geometry IS NULL))),
1332    CONSTRAINT enforce_srid_wkb_geometry CHECK ((st_srid(wkb_geometry) = 25832))
1333);
1334
1335
1336--
1337-- TOC entry 2747 (class 1259 OID 30741)
1338-- Dependencies: 2748 3
1339-- Name: ax_gewaesserstationierungsachse_ogc_fid_seq; Type: SEQUENCE; Schema: public; Owner: -
1340--
1341
1342CREATE SEQUENCE ax_gewaesserstationierungsachse_ogc_fid_seq
1343    START WITH 1
1344    INCREMENT BY 1
1345    NO MAXVALUE
1346    NO MINVALUE
1347    CACHE 1;
1348
1349
1350--
1351-- TOC entry 3620 (class 0 OID 0)
1352-- Dependencies: 2747
1353-- Name: ax_gewaesserstationierungsachse_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1354--
1355
1356ALTER SEQUENCE ax_gewaesserstationierungsachse_ogc_fid_seq OWNED BY ax_gewaesserstationierungsachse.ogc_fid;
1357
1358
1359--
1360-- TOC entry 2774 (class 1259 OID 33730)
1361-- Dependencies: 3325 3326 3327 3 1087
1362-- Name: ax_hafen; Type: TABLE; Schema: public; Owner: -
1363--
1364
1365CREATE TABLE ax_hafen (
1366    ogc_fid integer NOT NULL,
1367    wkb_geometry geometry,
1368    gml_id character(16),
1369    identifier character(28),
1370    beginnt character(20),
1371    advstandardmodell character varying[],
1372    art character(16),
1373    name character(11),
1374    name_ character(200), --28
1375    CONSTRAINT enforce_dims_wkb_geometry CHECK ((st_ndims(wkb_geometry) = 2)),
1376    CONSTRAINT enforce_geotype_wkb_geometry CHECK (((geometrytype(wkb_geometry) = 'POLYGON'::text) OR (wkb_geometry IS NULL))),
1377    CONSTRAINT enforce_srid_wkb_geometry CHECK ((st_srid(wkb_geometry) = 25832))
1378);
1379
1380
1381--
1382-- TOC entry 2773 (class 1259 OID 33728)
1383-- Dependencies: 2774 3
1384-- Name: ax_hafen_ogc_fid_seq; Type: SEQUENCE; Schema: public; Owner: -
1385--
1386
1387CREATE SEQUENCE ax_hafen_ogc_fid_seq
1388    START WITH 1
1389    INCREMENT BY 1
1390    NO MAXVALUE
1391    NO MINVALUE
1392    CACHE 1;
1393
1394
1395--
1396-- TOC entry 3621 (class 0 OID 0)
1397-- Dependencies: 2773
1398-- Name: ax_hafen_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1399--
1400
1401ALTER SEQUENCE ax_hafen_ogc_fid_seq OWNED BY ax_hafen.ogc_fid;
1402
1403
1404--
1405-- TOC entry 2772 (class 1259 OID 33706)
1406-- Dependencies: 3321 3322 3323 3 1087
1407-- Name: ax_hafenbecken; Type: TABLE; Schema: public; Owner: -
1408--
1409
1410CREATE TABLE ax_hafenbecken (
1411    ogc_fid integer NOT NULL,
1412    wkb_geometry geometry,
1413    gml_id character(16),
1414    identifier character(28),
1415    beginnt character(20),
1416    advstandardmodell character varying[],
1417    art character(16),
1418    name character(11),
1419    CONSTRAINT enforce_dims_wkb_geometry CHECK ((st_ndims(wkb_geometry) = 2)),
1420    CONSTRAINT enforce_geotype_wkb_geometry CHECK (((geometrytype(wkb_geometry) = 'POLYGON'::text) OR (wkb_geometry IS NULL))),
1421    CONSTRAINT enforce_srid_wkb_geometry CHECK ((st_srid(wkb_geometry) = 25832))
1422);
1423
1424
1425--
1426-- TOC entry 2771 (class 1259 OID 33704)
1427-- Dependencies: 2772 3
1428-- Name: ax_hafenbecken_ogc_fid_seq; Type: SEQUENCE; Schema: public; Owner: -
1429--
1430
1431CREATE SEQUENCE ax_hafenbecken_ogc_fid_seq
1432    START WITH 1
1433    INCREMENT BY 1
1434    NO MAXVALUE
1435    NO MINVALUE
1436    CACHE 1;
1437
1438
1439--
1440-- TOC entry 3622 (class 0 OID 0)
1441-- Dependencies: 2771
1442-- Name: ax_hafenbecken_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1443--
1444
1445ALTER SEQUENCE ax_hafenbecken_ogc_fid_seq OWNED BY ax_hafenbecken.ogc_fid;
1446
1447
1448--
1449-- TOC entry 2780 (class 1259 OID 36945)
1450-- Dependencies: 3337 3338 3339 1087 3
1451-- Name: ax_halde; Type: TABLE; Schema: public; Owner: -
1452--
1453
1454CREATE TABLE ax_halde (
1455    ogc_fid integer NOT NULL,
1456    wkb_geometry geometry,
1457    gml_id character(16),
1458    identifier character(28),
1459    beginnt character(20),
1460    advstandardmodell character varying[],
1461    art character(16),
1462    name character(11),
1463    CONSTRAINT enforce_dims_wkb_geometry CHECK ((st_ndims(wkb_geometry) = 2)),
1464    CONSTRAINT enforce_geotype_wkb_geometry CHECK (((geometrytype(wkb_geometry) = 'POLYGON'::text) OR (wkb_geometry IS NULL))),
1465    CONSTRAINT enforce_srid_wkb_geometry CHECK ((st_srid(wkb_geometry) = 25832))
1466);
1467
1468
1469--
1470-- TOC entry 2779 (class 1259 OID 36943)
1471-- Dependencies: 2780 3
1472-- Name: ax_halde_ogc_fid_seq; Type: SEQUENCE; Schema: public; Owner: -
1473--
1474
1475CREATE SEQUENCE ax_halde_ogc_fid_seq
1476    START WITH 1
1477    INCREMENT BY 1
1478    NO MAXVALUE
1479    NO MINVALUE
1480    CACHE 1;
1481
1482
1483--
1484-- TOC entry 3623 (class 0 OID 0)
1485-- Dependencies: 2779
1486-- Name: ax_halde_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1487--
1488
1489ALTER SEQUENCE ax_halde_ogc_fid_seq OWNED BY ax_halde.ogc_fid;
1490
1491
1492--
1493-- TOC entry 2792 (class 1259 OID 63873)
1494-- Dependencies: 3361 3362 3363 3 1087
1495-- Name: ax_heide; Type: TABLE; Schema: public; Owner: -
1496--
1497
1498CREATE TABLE ax_heide (
1499    ogc_fid integer NOT NULL,
1500    wkb_geometry geometry,
1501    gml_id character(16),
1502    identifier character(28),
1503    beginnt character(20),
1504    advstandardmodell character varying[],
1505    art character(16),
1506    name character(11),
1507    CONSTRAINT enforce_dims_wkb_geometry CHECK ((st_ndims(wkb_geometry) = 2)),
1508    CONSTRAINT enforce_geotype_wkb_geometry CHECK (((geometrytype(wkb_geometry) = 'POLYGON'::text) OR (wkb_geometry IS NULL))),
1509    CONSTRAINT enforce_srid_wkb_geometry CHECK ((st_srid(wkb_geometry) = 25832))
1510);
1511
1512
1513--
1514-- TOC entry 2791 (class 1259 OID 63871)
1515-- Dependencies: 3 2792
1516-- Name: ax_heide_ogc_fid_seq; Type: SEQUENCE; Schema: public; Owner: -
1517--
1518
1519CREATE SEQUENCE ax_heide_ogc_fid_seq
1520    START WITH 1
1521    INCREMENT BY 1
1522    NO MAXVALUE
1523    NO MINVALUE
1524    CACHE 1;
1525
1526
1527--
1528-- TOC entry 3624 (class 0 OID 0)
1529-- Dependencies: 2791
1530-- Name: ax_heide_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1531--
1532
1533ALTER SEQUENCE ax_heide_ogc_fid_seq OWNED BY ax_heide.ogc_fid;
1534
1535
1536--
1537-- TOC entry 2658 (class 1259 OID 29777)
1538-- Dependencies: 3107 3108 3109 3 1087
1539-- Name: ax_historischesbauwerkoderhistorischeeinrichtung; Type: TABLE; Schema: public; Owner: -
1540--
1541
1542CREATE TABLE ax_historischesbauwerkoderhistorischeeinrichtung (
1543    ogc_fid integer NOT NULL,
1544    wkb_geometry geometry,
1545    gml_id character(16),
1546    identifier character(28),
1547    beginnt character(20),
1548    advstandardmodell character varying[],
1549    art character(16),
1550    name character(11),
1551    archaeologischertyp integer,
1552    CONSTRAINT enforce_dims_wkb_geometry CHECK ((st_ndims(wkb_geometry) = 2)),
1553    --CONSTRAINT enforce_geotype_wkb_geometry CHECK (((geometrytype(wkb_geometry) = 'LINESTRING'::text) OR (wkb_geometry IS NULL))),
1554    CONSTRAINT enforce_srid_wkb_geometry CHECK ((st_srid(wkb_geometry) = 25832))
1555);
1556
1557
1558--
1559-- TOC entry 2657 (class 1259 OID 29775)
1560-- Dependencies: 3 2658
1561-- Name: ax_historischesbauwerkoderhistorischeeinrichtung_ogc_fid_seq; Type: SEQUENCE; Schema: public; Owner: -
1562--
1563
1564CREATE SEQUENCE ax_historischesbauwerkoderhistorischeeinrichtung_ogc_fid_seq
1565    START WITH 1
1566    INCREMENT BY 1
1567    NO MAXVALUE
1568    NO MINVALUE
1569    CACHE 1;
1570
1571
1572--
1573-- TOC entry 3625 (class 0 OID 0)
1574-- Dependencies: 2657
1575-- Name: ax_historischesbauwerkoderhistorischeeinrichtung_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1576--
1577
1578ALTER SEQUENCE ax_historischesbauwerkoderhistorischeeinrichtung_ogc_fid_seq OWNED BY ax_historischesbauwerkoderhistorischeeinrichtung.ogc_fid;
1579
1580
1581--
1582-- TOC entry 2762 (class 1259 OID 31384)
1583-- Dependencies: 3301 3302 3303 3 1087
1584-- Name: ax_hoehleneingang; Type: TABLE; Schema: public; Owner: -
1585--
1586
1587CREATE TABLE ax_hoehleneingang (
1588    ogc_fid integer NOT NULL,
1589    wkb_geometry geometry,
1590    gml_id character(16),
1591    identifier character(28),
1592    beginnt character(20),
1593    advstandardmodell character varying[],
1594    art character(16),
1595    name character(11),
1596    CONSTRAINT enforce_dims_wkb_geometry CHECK ((st_ndims(wkb_geometry) = 2)),
1597    CONSTRAINT enforce_geotype_wkb_geometry CHECK (((geometrytype(wkb_geometry) = 'POINT'::text) OR (wkb_geometry IS NULL))),
1598    CONSTRAINT enforce_srid_wkb_geometry CHECK ((st_srid(wkb_geometry) = 25832))
1599);
1600
1601
1602--
1603-- TOC entry 2761 (class 1259 OID 31382)
1604-- Dependencies: 2762 3
1605-- Name: ax_hoehleneingang_ogc_fid_seq; Type: SEQUENCE; Schema: public; Owner: -
1606--
1607
1608CREATE SEQUENCE ax_hoehleneingang_ogc_fid_seq
1609    START WITH 1
1610    INCREMENT BY 1
1611    NO MAXVALUE
1612    NO MINVALUE
1613    CACHE 1;
1614
1615
1616--
1617-- TOC entry 3626 (class 0 OID 0)
1618-- Dependencies: 2761
1619-- Name: ax_hoehleneingang_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1620--
1621
1622ALTER SEQUENCE ax_hoehleneingang_ogc_fid_seq OWNED BY ax_hoehleneingang.ogc_fid;
1623
1624
1625--
1626-- TOC entry 2696 (class 1259 OID 30185)
1627-- Dependencies: 3179 3180 3181 3 1087
1628-- Name: ax_industrieundgewerbeflaeche; Type: TABLE; Schema: public; Owner: -
1629--
1630
1631CREATE TABLE ax_industrieundgewerbeflaeche (
1632    ogc_fid integer NOT NULL,
1633    wkb_geometry geometry,
1634    gml_id character(16),
1635    identifier character(28),
1636    beginnt character(20),
1637    advstandardmodell character varying[],
1638    art character(16),
1639    name character(11),
1640    funktion integer,
1641    CONSTRAINT enforce_dims_wkb_geometry CHECK ((st_ndims(wkb_geometry) = 2)),
1642    CONSTRAINT enforce_geotype_wkb_geometry CHECK (((geometrytype(wkb_geometry) = 'POLYGON'::text) OR (wkb_geometry IS NULL))),
1643    CONSTRAINT enforce_srid_wkb_geometry CHECK ((st_srid(wkb_geometry) = 25832))
1644);
1645
1646
1647--
1648-- TOC entry 2695 (class 1259 OID 30183)
1649-- Dependencies: 2696 3
1650-- Name: ax_industrieundgewerbeflaeche_ogc_fid_seq; Type: SEQUENCE; Schema: public; Owner: -
1651--
1652
1653CREATE SEQUENCE ax_industrieundgewerbeflaeche_ogc_fid_seq
1654    START WITH 1
1655    INCREMENT BY 1
1656    NO MAXVALUE
1657    NO MINVALUE
1658    CACHE 1;
1659
1660
1661--
1662-- TOC entry 3627 (class 0 OID 0)
1663-- Dependencies: 2695
1664-- Name: ax_industrieundgewerbeflaeche_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1665--
1666
1667ALTER SEQUENCE ax_industrieundgewerbeflaeche_ogc_fid_seq OWNED BY ax_industrieundgewerbeflaeche.ogc_fid;
1668
1669
1670--
1671-- TOC entry 2746 (class 1259 OID 30727)
1672-- Dependencies: 3272 3273 3274 3 1087
1673-- Name: ax_insel; Type: TABLE; Schema: public; Owner: -
1674--
1675
1676CREATE TABLE ax_insel (
1677    ogc_fid integer NOT NULL,
1678    wkb_geometry geometry,
1679    gml_id character(16),
1680    identifier character(28),
1681    beginnt character(20),
1682    advstandardmodell character varying[],
1683    art character(16),
1684    name character(11),
1685    CONSTRAINT enforce_dims_wkb_geometry CHECK ((st_ndims(wkb_geometry) = 2)),
1686    CONSTRAINT enforce_geotype_wkb_geometry CHECK (((geometrytype(wkb_geometry) = 'POLYGON'::text) OR (wkb_geometry IS NULL))),
1687    CONSTRAINT enforce_srid_wkb_geometry CHECK ((st_srid(wkb_geometry) = 25832))
1688);
1689
1690
1691--
1692-- TOC entry 2745 (class 1259 OID 30725)
1693-- Dependencies: 3 2746
1694-- Name: ax_insel_ogc_fid_seq; Type: SEQUENCE; Schema: public; Owner: -
1695--
1696
1697CREATE SEQUENCE ax_insel_ogc_fid_seq
1698    START WITH 1
1699    INCREMENT BY 1
1700    NO MAXVALUE
1701    NO MINVALUE
1702    CACHE 1;
1703
1704
1705--
1706-- TOC entry 3628 (class 0 OID 0)
1707-- Dependencies: 2745
1708-- Name: ax_insel_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1709--
1710
1711ALTER SEQUENCE ax_insel_ogc_fid_seq OWNED BY ax_insel.ogc_fid;
1712
1713
1714--
1715-- TOC entry 2794 (class 1259 OID 69842)
1716-- Dependencies: 3
1717-- Name: ax_kanal; Type: TABLE; Schema: public; Owner: -
1718--
1719
1720CREATE TABLE ax_kanal (
1721    ogc_fid integer NOT NULL,
1722    gml_id character(16),
1723    identifier character(28),
1724    beginnt character(20),
1725    advstandardmodell character varying[],
1726    art character(16),
1727    name character(11),
1728    name_ character(200), --9
1729    gewaesserkennzahl double precision,
1730    schifffahrtskategorie integer
1731);
1732
1733-- keine Geometrie, daher ersatzweise: Dummy-Eintrag in Metatabelle - siehe ALKIS
1734INSERT INTO geometry_columns
1735   (f_table_catalog, f_table_schema, f_table_name, f_geometry_column, coord_dimension, srid, type)
1736VALUES ('', 'public', 'ax_kanal', 'dummy', 2, 25832, 'POINT');
1737
1738--
1739-- TOC entry 2793 (class 1259 OID 69840)
1740-- Dependencies: 2794 3
1741-- Name: ax_kanal_ogc_fid_seq; Type: SEQUENCE; Schema: public; Owner: -
1742--
1743
1744CREATE SEQUENCE ax_kanal_ogc_fid_seq
1745    START WITH 1
1746    INCREMENT BY 1
1747    NO MAXVALUE
1748    NO MINVALUE
1749    CACHE 1;
1750
1751
1752--
1753-- TOC entry 3629 (class 0 OID 0)
1754-- Dependencies: 2793
1755-- Name: ax_kanal_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1756--
1757
1758ALTER SEQUENCE ax_kanal_ogc_fid_seq OWNED BY ax_kanal.ogc_fid;
1759
1760
1761--
1762-- TOC entry 2660 (class 1259 OID 29793)
1763-- Dependencies: 3111 3112 3113 3 1087
1764-- Name: ax_kommunalesgebiet; Type: TABLE; Schema: public; Owner: -
1765--
1766
1767CREATE TABLE ax_kommunalesgebiet (
1768    ogc_fid integer NOT NULL,
1769    wkb_geometry geometry,
1770    gml_id character(16),
1771    identifier character(28),
1772    beginnt character(20),
1773    advstandardmodell character(9),
1774    art character(16),
1775    name character(11),
1776    schluesselgesamt integer,
1777    land integer,
1778    regierungsbezirk integer,
1779    kreis integer,
1780    gemeinde integer,
1781    CONSTRAINT enforce_dims_wkb_geometry CHECK ((st_ndims(wkb_geometry) = 2)),
1782    --CONSTRAINT enforce_geotype_wkb_geometry CHECK (((geometrytype(wkb_geometry) = 'POLYGON'::text) OR (wkb_geometry IS NULL))),
1783    CONSTRAINT enforce_srid_wkb_geometry CHECK ((st_srid(wkb_geometry) = 25832))
1784);
1785
1786
1787--
1788-- TOC entry 2659 (class 1259 OID 29791)
1789-- Dependencies: 3 2660
1790-- Name: ax_kommunalesgebiet_ogc_fid_seq; Type: SEQUENCE; Schema: public; Owner: -
1791--
1792
1793CREATE SEQUENCE ax_kommunalesgebiet_ogc_fid_seq
1794    START WITH 1
1795    INCREMENT BY 1
1796    NO MAXVALUE
1797    NO MINVALUE
1798    CACHE 1;
1799
1800
1801--
1802-- TOC entry 3630 (class 0 OID 0)
1803-- Dependencies: 2659
1804-- Name: ax_kommunalesgebiet_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1805--
1806
1807ALTER SEQUENCE ax_kommunalesgebiet_ogc_fid_seq OWNED BY ax_kommunalesgebiet.ogc_fid;
1808
1809
1810--
1811-- TOC entry 2788 (class 1259 OID 61522)
1812-- Dependencies: 3353 3354 3355 3 1087
1813-- Name: ax_kondominium; Type: TABLE; Schema: public; Owner: -
1814--
1815
1816CREATE TABLE ax_kondominium (
1817    ogc_fid integer NOT NULL,
1818    wkb_geometry geometry,
1819    gml_id character(16),
1820    identifier character(28),
1821    beginnt character(20),
1822    advstandardmodell character(9),
1823    art character(16),
1824    name character(11),
1825    CONSTRAINT enforce_dims_wkb_geometry CHECK ((st_ndims(wkb_geometry) = 2)),
1826    CONSTRAINT enforce_geotype_wkb_geometry CHECK (((geometrytype(wkb_geometry) = 'POLYGON'::text) OR (wkb_geometry IS NULL))),
1827    CONSTRAINT enforce_srid_wkb_geometry CHECK ((st_srid(wkb_geometry) = 25832))
1828);
1829
1830
1831--
1832-- TOC entry 2787 (class 1259 OID 61520)
1833-- Dependencies: 2788 3
1834-- Name: ax_kondominium_ogc_fid_seq; Type: SEQUENCE; Schema: public; Owner: -
1835--
1836
1837CREATE SEQUENCE ax_kondominium_ogc_fid_seq
1838    START WITH 1
1839    INCREMENT BY 1
1840    NO MAXVALUE
1841    NO MINVALUE
1842    CACHE 1;
1843
1844
1845--
1846-- TOC entry 3631 (class 0 OID 0)
1847-- Dependencies: 2787
1848-- Name: ax_kondominium_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1849--
1850
1851ALTER SEQUENCE ax_kondominium_ogc_fid_seq OWNED BY ax_kondominium.ogc_fid;
1852
1853
1854--
1855-- TOC entry 2662 (class 1259 OID 29815)
1856-- Dependencies: 3115 3116 3117 3 1087
1857-- Name: ax_landwirtschaft; Type: TABLE; Schema: public; Owner: -
1858--
1859
1860CREATE TABLE ax_landwirtschaft (
1861    ogc_fid integer NOT NULL,
1862    wkb_geometry geometry,
1863    gml_id character(16),
1864    identifier character(28),
1865    beginnt character(20),
1866    advstandardmodell character varying[],
1867    art character(16),
1868    name character(11),
1869    vegetationsmerkmal integer,
1870    CONSTRAINT enforce_dims_wkb_geometry CHECK ((st_ndims(wkb_geometry) = 2)),
1871    CONSTRAINT enforce_geotype_wkb_geometry CHECK (((geometrytype(wkb_geometry) = 'POLYGON'::text) OR (wkb_geometry IS NULL))),
1872    CONSTRAINT enforce_srid_wkb_geometry CHECK ((st_srid(wkb_geometry) = 25832))
1873);
1874
1875
1876--
1877-- TOC entry 2661 (class 1259 OID 29813)
1878-- Dependencies: 3 2662
1879-- Name: ax_landwirtschaft_ogc_fid_seq; Type: SEQUENCE; Schema: public; Owner: -
1880--
1881
1882CREATE SEQUENCE ax_landwirtschaft_ogc_fid_seq
1883    START WITH 1
1884    INCREMENT BY 1
1885    NO MAXVALUE
1886    NO MINVALUE
1887    CACHE 1;
1888
1889
1890--
1891-- TOC entry 3632 (class 0 OID 0)
1892-- Dependencies: 2661
1893-- Name: ax_landwirtschaft_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1894--
1895
1896ALTER SEQUENCE ax_landwirtschaft_ogc_fid_seq OWNED BY ax_landwirtschaft.ogc_fid;
1897
1898
1899--
1900-- TOC entry 2750 (class 1259 OID 30811)
1901-- Dependencies: 3280 3281 3282 3 1087
1902-- Name: ax_leitung; Type: TABLE; Schema: public; Owner: -
1903--
1904
1905CREATE TABLE ax_leitung (
1906    ogc_fid integer NOT NULL,
1907    wkb_geometry geometry,
1908    gml_id character(16),
1909    identifier character(28),
1910    beginnt character(20),
1911    advstandardmodell character varying[],
1912    art character(16),
1913    name character(11),
1914    bauwerksfunktion integer,
1915    CONSTRAINT enforce_dims_wkb_geometry CHECK ((st_ndims(wkb_geometry) = 2)),
1916    CONSTRAINT enforce_geotype_wkb_geometry CHECK (((geometrytype(wkb_geometry) = 'LINESTRING'::text) OR (wkb_geometry IS NULL))),
1917    CONSTRAINT enforce_srid_wkb_geometry CHECK ((st_srid(wkb_geometry) = 25832))
1918);
1919
1920
1921--
1922-- TOC entry 2749 (class 1259 OID 30809)
1923-- Dependencies: 2750 3
1924-- Name: ax_leitung_ogc_fid_seq; Type: SEQUENCE; Schema: public; Owner: -
1925--
1926
1927CREATE SEQUENCE ax_leitung_ogc_fid_seq
1928    START WITH 1
1929    INCREMENT BY 1
1930    NO MAXVALUE
1931    NO MINVALUE
1932    CACHE 1;
1933
1934
1935--
1936-- TOC entry 3633 (class 0 OID 0)
1937-- Dependencies: 2749
1938-- Name: ax_leitung_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1939--
1940
1941ALTER SEQUENCE ax_leitung_ogc_fid_seq OWNED BY ax_leitung.ogc_fid;
1942
1943
1944--
1945-- TOC entry 2786 (class 1259 OID 51734)
1946-- Dependencies: 3349 3350 3351 3 1087
1947-- Name: ax_moor; Type: TABLE; Schema: public; Owner: -
1948--
1949
1950CREATE TABLE ax_moor (
1951    ogc_fid integer NOT NULL,
1952    wkb_geometry geometry,
1953    gml_id character(16),
1954    identifier character(28),
1955    beginnt character(20),
1956    advstandardmodell character varying[],
1957    art character(16),
1958    name character(11),
1959    CONSTRAINT enforce_dims_wkb_geometry CHECK ((st_ndims(wkb_geometry) = 2)),
1960    CONSTRAINT enforce_geotype_wkb_geometry CHECK (((geometrytype(wkb_geometry) = 'POLYGON'::text) OR (wkb_geometry IS NULL))),
1961    CONSTRAINT enforce_srid_wkb_geometry CHECK ((st_srid(wkb_geometry) = 25832))
1962);
1963
1964
1965--
1966-- TOC entry 2785 (class 1259 OID 51732)
1967-- Dependencies: 3 2786
1968-- Name: ax_moor_ogc_fid_seq; Type: SEQUENCE; Schema: public; Owner: -
1969--
1970
1971CREATE SEQUENCE ax_moor_ogc_fid_seq
1972    START WITH 1
1973    INCREMENT BY 1
1974    NO MAXVALUE
1975    NO MINVALUE
1976    CACHE 1;
1977
1978
1979--
1980-- TOC entry 3634 (class 0 OID 0)
1981-- Dependencies: 2785
1982-- Name: ax_moor_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1983--
1984
1985ALTER SEQUENCE ax_moor_ogc_fid_seq OWNED BY ax_moor.ogc_fid;
1986
1987
1988--
1989-- TOC entry 2664 (class 1259 OID 29835)
1990-- Dependencies: 3119 3120 3121 1087 3
1991-- Name: ax_naturumweltoderbodenschutzrecht; Type: TABLE; Schema: public; Owner: -
1992--
1993
1994CREATE TABLE ax_naturumweltoderbodenschutzrecht (
1995    ogc_fid integer NOT NULL,
1996    wkb_geometry geometry,
1997    gml_id character(16),
1998    identifier character(28),
1999    beginnt character(20),
2000    advstandardmodell character varying[],
2001    art character(16),
2002    name character(11),
2003    artderfestlegung integer,
2004    name_ character(200), --15
2005    CONSTRAINT enforce_dims_wkb_geometry CHECK ((st_ndims(wkb_geometry) = 2)),
2006    --CONSTRAINT enforce_geotype_wkb_geometry CHECK (((geometrytype(wkb_geometry) = 'POLYGON'::text) OR (wkb_geometry IS NULL))),
2007    CONSTRAINT enforce_srid_wkb_geometry CHECK ((st_srid(wkb_geometry) = 25832))
2008);
2009
2010
2011--
2012-- TOC entry 2663 (class 1259 OID 29833)
2013-- Dependencies: 2664 3
2014-- Name: ax_naturumweltoderbodenschutzrecht_ogc_fid_seq; Type: SEQUENCE; Schema: public; Owner: -
2015--
2016
2017CREATE SEQUENCE ax_naturumweltoderbodenschutzrecht_ogc_fid_seq
2018    START WITH 1
2019    INCREMENT BY 1
2020    NO MAXVALUE
2021    NO MINVALUE
2022    CACHE 1;
2023
2024
2025--
2026-- TOC entry 3635 (class 0 OID 0)
2027-- Dependencies: 2663
2028-- Name: ax_naturumweltoderbodenschutzrecht_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2029--
2030
2031ALTER SEQUENCE ax_naturumweltoderbodenschutzrecht_ogc_fid_seq OWNED BY ax_naturumweltoderbodenschutzrecht.ogc_fid;
2032
2033
2034--
2035-- TOC entry 2730 (class 1259 OID 30544)
2036-- Dependencies: 3
2037-- Name: ax_netzknoten; Type: TABLE; Schema: public; Owner: -
2038--
2039
2040CREATE TABLE ax_netzknoten (
2041    ogc_fid integer NOT NULL,
2042    gml_id character(16),
2043    identifier character(28),
2044    beginnt character(20),
2045    advstandardmodell character(9),
2046    art character(16),
2047    name character(7),
2048    bezeichnung integer
2049);
2050
2051-- keine Geometrie, daher ersatzweise: Dummy-Eintrag in Metatabelle - siehe ALKIS
2052INSERT INTO geometry_columns
2053   (f_table_catalog, f_table_schema, f_table_name, f_geometry_column, coord_dimension, srid, type)
2054VALUES ('', 'public', 'ax_netzknoten', 'dummy', 2, 25832, 'POINT');
2055
2056--
2057-- TOC entry 2729 (class 1259 OID 30542)
2058-- Dependencies: 2730 3
2059-- Name: ax_netzknoten_ogc_fid_seq; Type: SEQUENCE; Schema: public; Owner: -
2060--
2061
2062CREATE SEQUENCE ax_netzknoten_ogc_fid_seq
2063    START WITH 1
2064    INCREMENT BY 1
2065    NO MAXVALUE
2066    NO MINVALUE
2067    CACHE 1;
2068
2069
2070--
2071-- TOC entry 3636 (class 0 OID 0)
2072-- Dependencies: 2729
2073-- Name: ax_netzknoten_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2074--
2075
2076ALTER SEQUENCE ax_netzknoten_ogc_fid_seq OWNED BY ax_netzknoten.ogc_fid;
2077
2078
2079--
2080-- TOC entry 2704 (class 1259 OID 30313)
2081-- Dependencies: 3195 3196 3197 3 1087
2082-- Name: ax_nullpunkt; Type: TABLE; Schema: public; Owner: -
2083--
2084
2085CREATE TABLE ax_nullpunkt (
2086    ogc_fid integer NOT NULL,
2087    wkb_geometry geometry,
2088    gml_id character(16),
2089    identifier character(28),
2090    beginnt character(20),
2091    advstandardmodell character(9),
2092    art character(16),
2093    name character(11),
2094    istteilvon character varying,
2095    artdesnullpunktes integer,
2096    bezeichnung character(200), --8
2097    CONSTRAINT enforce_dims_wkb_geometry CHECK ((st_ndims(wkb_geometry) = 2)),
2098    CONSTRAINT enforce_geotype_wkb_geometry CHECK (((geometrytype(wkb_geometry) = 'POINT'::text) OR (wkb_geometry IS NULL))),
2099    CONSTRAINT enforce_srid_wkb_geometry CHECK ((st_srid(wkb_geometry) = 25832))
2100);
2101
2102
2103--
2104-- TOC entry 2703 (class 1259 OID 30311)
2105-- Dependencies: 3 2704
2106-- Name: ax_nullpunkt_ogc_fid_seq; Type: SEQUENCE; Schema: public; Owner: -
2107--
2108
2109CREATE SEQUENCE ax_nullpunkt_ogc_fid_seq
2110    START WITH 1
2111    INCREMENT BY 1
2112    NO MAXVALUE
2113    NO MINVALUE
2114    CACHE 1;
2115
2116
2117--
2118-- TOC entry 3637 (class 0 OID 0)
2119-- Dependencies: 2703
2120-- Name: ax_nullpunkt_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2121--
2122
2123ALTER SEQUENCE ax_nullpunkt_ogc_fid_seq OWNED BY ax_nullpunkt.ogc_fid;
2124
2125
2126--
2127-- TOC entry 2700 (class 1259 OID 30279)
2128-- Dependencies: 3187 3188 3189 1087 3
2129-- Name: ax_ortslage; Type: TABLE; Schema: public; Owner: -
2130--
2131
2132CREATE TABLE ax_ortslage (
2133    ogc_fid integer NOT NULL,
2134    wkb_geometry geometry,
2135    gml_id character(16),
2136    identifier character(28),
2137    beginnt character(20),
2138    advstandardmodell character(9),
2139    art character(16),
2140    name character(11),
2141    name_ character(200), --13
2142    CONSTRAINT enforce_dims_wkb_geometry CHECK ((st_ndims(wkb_geometry) = 2)),
2143    CONSTRAINT enforce_geotype_wkb_geometry CHECK (((geometrytype(wkb_geometry) = 'POLYGON'::text) OR (wkb_geometry IS NULL))),
2144    CONSTRAINT enforce_srid_wkb_geometry CHECK ((st_srid(wkb_geometry) = 25832))
2145);
2146
2147
2148--
2149-- TOC entry 2699 (class 1259 OID 30277)
2150-- Dependencies: 2700 3
2151-- Name: ax_ortslage_ogc_fid_seq; Type: SEQUENCE; Schema: public; Owner: -
2152--
2153
2154CREATE SEQUENCE ax_ortslage_ogc_fid_seq
2155    START WITH 1
2156    INCREMENT BY 1
2157    NO MAXVALUE
2158    NO MINVALUE
2159    CACHE 1;
2160
2161
2162--
2163-- TOC entry 3638 (class 0 OID 0)
2164-- Dependencies: 2699
2165-- Name: ax_ortslage_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2166--
2167
2168ALTER SEQUENCE ax_ortslage_ogc_fid_seq OWNED BY ax_ortslage.ogc_fid;
2169
2170
2171--
2172-- TOC entry 2698 (class 1259 OID 30263)
2173-- Dependencies: 3183 3184 3185 1087 3
2174-- Name: ax_platz; Type: TABLE; Schema: public; Owner: -
2175--
2176
2177CREATE TABLE ax_platz (
2178    ogc_fid integer NOT NULL,
2179    wkb_geometry geometry,
2180    gml_id character(16),
2181    identifier character(28),
2182    beginnt character(20),
2183    advstandardmodell character varying[],
2184    art character(16),
2185    name character(11),
2186    funktion integer,
2187    CONSTRAINT enforce_dims_wkb_geometry CHECK ((st_ndims(wkb_geometry) = 2)),
2188    CONSTRAINT enforce_geotype_wkb_geometry CHECK (((geometrytype(wkb_geometry) = 'POLYGON'::text) OR (wkb_geometry IS NULL))),
2189    CONSTRAINT enforce_srid_wkb_geometry CHECK ((st_srid(wkb_geometry) = 25832))
2190);
2191
2192
2193--
2194-- TOC entry 2697 (class 1259 OID 30261)
2195-- Dependencies: 3 2698
2196-- Name: ax_platz_ogc_fid_seq; Type: SEQUENCE; Schema: public; Owner: -
2197--
2198
2199CREATE SEQUENCE ax_platz_ogc_fid_seq
2200    START WITH 1
2201    INCREMENT BY 1
2202    NO MAXVALUE
2203    NO MINVALUE
2204    CACHE 1;
2205
2206
2207--
2208-- TOC entry 3639 (class 0 OID 0)
2209-- Dependencies: 2697
2210-- Name: ax_platz_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2211--
2212
2213ALTER SEQUENCE ax_platz_ogc_fid_seq OWNED BY ax_platz.ogc_fid;
2214
2215
2216--
2217-- TOC entry 2752 (class 1259 OID 30842)
2218-- Dependencies: 3284 3285 3286 3 1087
2219-- Name: ax_schifffahrtsliniefaehrverkehr; Type: TABLE; Schema: public; Owner: -
2220--
2221
2222CREATE TABLE ax_schifffahrtsliniefaehrverkehr (
2223    ogc_fid integer NOT NULL,
2224    wkb_geometry geometry,
2225    gml_id character(16),
2226    identifier character(28),
2227    beginnt character(20),
2228    advstandardmodell character varying[],
2229    art character(16),
2230    name character(11),
2231    art_ integer,
2232    CONSTRAINT enforce_dims_wkb_geometry CHECK ((st_ndims(wkb_geometry) = 2)),
2233    CONSTRAINT enforce_geotype_wkb_geometry CHECK (((geometrytype(wkb_geometry) = 'LINESTRING'::text) OR (wkb_geometry IS NULL))),
2234    CONSTRAINT enforce_srid_wkb_geometry CHECK ((st_srid(wkb_geometry) = 25832))
2235);
2236
2237
2238--
2239-- TOC entry 2751 (class 1259 OID 30840)
2240-- Dependencies: 2752 3
2241-- Name: ax_schifffahrtsliniefaehrverkehr_ogc_fid_seq; Type: SEQUENCE; Schema: public; Owner: -
2242--
2243
2244CREATE SEQUENCE ax_schifffahrtsliniefaehrverkehr_ogc_fid_seq
2245    START WITH 1
2246    INCREMENT BY 1
2247    NO MAXVALUE
2248    NO MINVALUE
2249    CACHE 1;
2250
2251
2252--
2253-- TOC entry 3640 (class 0 OID 0)
2254-- Dependencies: 2751
2255-- Name: ax_schifffahrtsliniefaehrverkehr_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2256--
2257
2258ALTER SEQUENCE ax_schifffahrtsliniefaehrverkehr_ogc_fid_seq OWNED BY ax_schifffahrtsliniefaehrverkehr.ogc_fid;
2259
2260
2261--
2262-- TOC entry 2776 (class 1259 OID 33862)
2263-- Dependencies: 3329 3330 3331 3 1087
2264-- Name: ax_schiffsverkehr; Type: TABLE; Schema: public; Owner: -
2265--
2266
2267CREATE TABLE ax_schiffsverkehr (
2268    ogc_fid integer NOT NULL,
2269    wkb_geometry geometry,
2270    gml_id character(16),
2271    identifier character(28),
2272    beginnt character(20),
2273    advstandardmodell character varying[],
2274    funktion integer,
2275    CONSTRAINT enforce_dims_wkb_geometry CHECK ((st_ndims(wkb_geometry) = 2)),
2276    CONSTRAINT enforce_geotype_wkb_geometry CHECK (((geometrytype(wkb_geometry) = 'POLYGON'::text) OR (wkb_geometry IS NULL))),
2277    CONSTRAINT enforce_srid_wkb_geometry CHECK ((st_srid(wkb_geometry) = 25832))
2278);
2279
2280
2281--
2282-- TOC entry 2775 (class 1259 OID 33860)
2283-- Dependencies: 3 2776
2284-- Name: ax_schiffsverkehr_ogc_fid_seq; Type: SEQUENCE; Schema: public; Owner: -
2285--
2286
2287CREATE SEQUENCE ax_schiffsverkehr_ogc_fid_seq
2288    START WITH 1
2289    INCREMENT BY 1
2290    NO MAXVALUE
2291    NO MINVALUE
2292    CACHE 1;
2293
2294
2295--
2296-- TOC entry 3641 (class 0 OID 0)
2297-- Dependencies: 2775
2298-- Name: ax_schiffsverkehr_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2299--
2300
2301ALTER SEQUENCE ax_schiffsverkehr_ogc_fid_seq OWNED BY ax_schiffsverkehr.ogc_fid;
2302
2303
2304--
2305-- TOC entry 2790 (class 1259 OID 61541)
2306-- Dependencies: 3357 3358 3359 3 1087
2307-- Name: ax_schleuse; Type: TABLE; Schema: public; Owner: -
2308--
2309
2310CREATE TABLE ax_schleuse (
2311    ogc_fid integer NOT NULL,
2312    wkb_geometry geometry,
2313    gml_id character(16),
2314    identifier character(28),
2315    beginnt character(20),
2316    advstandardmodell character varying[],
2317    art character(16),
2318    name character(11),
2319    konstruktionsmerkmalbauart integer,
2320    CONSTRAINT enforce_dims_wkb_geometry CHECK ((st_ndims(wkb_geometry) = 2)),
2321    CONSTRAINT enforce_geotype_wkb_geometry CHECK (((geometrytype(wkb_geometry) = 'POLYGON'::text) OR (wkb_geometry IS NULL))),
2322    CONSTRAINT enforce_srid_wkb_geometry CHECK ((st_srid(wkb_geometry) = 25832))
2323);
2324
2325
2326--
2327-- TOC entry 2789 (class 1259 OID 61539)
2328-- Dependencies: 2790 3
2329-- Name: ax_schleuse_ogc_fid_seq; Type: SEQUENCE; Schema: public; Owner: -
2330--
2331
2332CREATE SEQUENCE ax_schleuse_ogc_fid_seq
2333    START WITH 1
2334    INCREMENT BY 1
2335    NO MAXVALUE
2336    NO MINVALUE
2337    CACHE 1;
2338
2339
2340--
2341-- TOC entry 3642 (class 0 OID 0)
2342-- Dependencies: 2789
2343-- Name: ax_schleuse_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2344--
2345
2346ALTER SEQUENCE ax_schleuse_ogc_fid_seq OWNED BY ax_schleuse.ogc_fid;
2347
2348
2349--
2350-- TOC entry 2782 (class 1259 OID 40021)
2351-- Dependencies: 3341 3342 3343 3 1087
2352-- Name: ax_seilbahnschwebebahn; Type: TABLE; Schema: public; Owner: -
2353--
2354
2355CREATE TABLE ax_seilbahnschwebebahn (
2356    ogc_fid integer NOT NULL,
2357    wkb_geometry geometry,
2358    gml_id character(16),
2359    identifier character(28),
2360    beginnt character(20),
2361    advstandardmodell character varying[],
2362    art character(16),
2363    name character(11),
2364    bahnkategorie integer,
2365    CONSTRAINT enforce_dims_wkb_geometry CHECK ((st_ndims(wkb_geometry) = 2)),
2366    CONSTRAINT enforce_geotype_wkb_geometry CHECK (((geometrytype(wkb_geometry) = 'LINESTRING'::text) OR (wkb_geometry IS NULL))),
2367    CONSTRAINT enforce_srid_wkb_geometry CHECK ((st_srid(wkb_geometry) = 25832))
2368);
2369
2370
2371--
2372-- TOC entry 2781 (class 1259 OID 40019)
2373-- Dependencies: 2782 3
2374-- Name: ax_seilbahnschwebebahn_ogc_fid_seq; Type: SEQUENCE; Schema: public; Owner: -
2375--
2376
2377CREATE SEQUENCE ax_seilbahnschwebebahn_ogc_fid_seq
2378    START WITH 1
2379    INCREMENT BY 1
2380    NO MAXVALUE
2381    NO MINVALUE
2382    CACHE 1;
2383
2384
2385--
2386-- TOC entry 3643 (class 0 OID 0)
2387-- Dependencies: 2781
2388-- Name: ax_seilbahnschwebebahn_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2389--
2390
2391ALTER SEQUENCE ax_seilbahnschwebebahn_ogc_fid_seq OWNED BY ax_seilbahnschwebebahn.ogc_fid;
2392
2393
2394--
2395-- TOC entry 2702 (class 1259 OID 30297)
2396-- Dependencies: 3191 3192 3193 1087 3
2397-- Name: ax_sonstigesbauwerkodersonstigeeinrichtung; Type: TABLE; Schema: public; Owner: -
2398--
2399
2400CREATE TABLE ax_sonstigesbauwerkodersonstigeeinrichtung (
2401    ogc_fid integer NOT NULL,
2402    wkb_geometry geometry,
2403    gml_id character(16),
2404    identifier character(28),
2405    beginnt character(20),
2406    advstandardmodell character varying[],
2407    art character(16),
2408    name character(11),
2409    bauwerksfunktion integer,
2410    name_ character(200), --13
2411    CONSTRAINT enforce_dims_wkb_geometry CHECK ((st_ndims(wkb_geometry) = 2)),
2412    --CONSTRAINT enforce_geotype_wkb_geometry CHECK (((geometrytype(wkb_geometry) = 'POINT'::text) OR (wkb_geometry IS NULL))),
2413    CONSTRAINT enforce_srid_wkb_geometry CHECK ((st_srid(wkb_geometry) = 25832))
2414);
2415
2416
2417--
2418-- TOC entry 2701 (class 1259 OID 30295)
2419-- Dependencies: 3 2702
2420-- Name: ax_sonstigesbauwerkodersonstigeeinrichtung_ogc_fid_seq; Type: SEQUENCE; Schema: public; Owner: -
2421--
2422
2423CREATE SEQUENCE ax_sonstigesbauwerkodersonstigeeinrichtung_ogc_fid_seq
2424    START WITH 1
2425    INCREMENT BY 1
2426    NO MAXVALUE
2427    NO MINVALUE
2428    CACHE 1;
2429
2430
2431--
2432-- TOC entry 3644 (class 0 OID 0)
2433-- Dependencies: 2701
2434-- Name: ax_sonstigesbauwerkodersonstigeeinrichtung_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2435--
2436
2437ALTER SEQUENCE ax_sonstigesbauwerkodersonstigeeinrichtung_ogc_fid_seq OWNED BY ax_sonstigesbauwerkodersonstigeeinrichtung.ogc_fid;
2438
2439
2440--
2441-- TOC entry 2784 (class 1259 OID 40092)
2442-- Dependencies: 3345 3346 3347 3 1087
2443-- Name: ax_sonstigesrecht; Type: TABLE; Schema: public; Owner: -
2444--
2445
2446CREATE TABLE ax_sonstigesrecht (
2447    ogc_fid integer NOT NULL,
2448    wkb_geometry geometry,
2449    gml_id character(16),
2450    identifier character(28),
2451    beginnt character(20),
2452    advstandardmodell character varying[],
2453    art character(16),
2454    name character(11),
2455    artderfestlegung integer,
2456    name_ character(200), --12
2457    CONSTRAINT enforce_dims_wkb_geometry CHECK ((st_ndims(wkb_geometry) = 2)),
2458    CONSTRAINT enforce_geotype_wkb_geometry CHECK (((geometrytype(wkb_geometry) = 'POLYGON'::text) OR (wkb_geometry IS NULL))),
2459    CONSTRAINT enforce_srid_wkb_geometry CHECK ((st_srid(wkb_geometry) = 25832))
2460);
2461
2462
2463--
2464-- TOC entry 2783 (class 1259 OID 40090)
2465-- Dependencies: 3 2784
2466-- Name: ax_sonstigesrecht_ogc_fid_seq; Type: SEQUENCE; Schema: public; Owner: -
2467--
2468
2469CREATE SEQUENCE ax_sonstigesrecht_ogc_fid_seq
2470    START WITH 1
2471    INCREMENT BY 1
2472    NO MAXVALUE
2473    NO MINVALUE
2474    CACHE 1;
2475
2476
2477--
2478-- TOC entry 3645 (class 0 OID 0)
2479-- Dependencies: 2783
2480-- Name: ax_sonstigesrecht_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2481--
2482
2483ALTER SEQUENCE ax_sonstigesrecht_ogc_fid_seq OWNED BY ax_sonstigesrecht.ogc_fid;
2484
2485
2486--
2487-- TOC entry 2706 (class 1259 OID 30329)
2488-- Dependencies: 3199 3200 3201 1087 3
2489-- Name: ax_sportfreizeitunderholungsflaeche; Type: TABLE; Schema: public; Owner: -
2490--
2491
2492CREATE TABLE ax_sportfreizeitunderholungsflaeche (
2493    ogc_fid integer NOT NULL,
2494    wkb_geometry geometry,
2495    gml_id character(16),
2496    identifier character(28),
2497    beginnt character(20),
2498    advstandardmodell character varying[],
2499    art character(16),
2500    name character(11),
2501    funktion integer,
2502    CONSTRAINT enforce_dims_wkb_geometry CHECK ((st_ndims(wkb_geometry) = 2)),
2503    CONSTRAINT enforce_geotype_wkb_geometry CHECK (((geometrytype(wkb_geometry) = 'POLYGON'::text) OR (wkb_geometry IS NULL))),
2504    CONSTRAINT enforce_srid_wkb_geometry CHECK ((st_srid(wkb_geometry) = 25832))
2505);
2506
2507
2508--
2509-- TOC entry 2705 (class 1259 OID 30327)
2510-- Dependencies: 3 2706
2511-- Name: ax_sportfreizeitunderholungsflaeche_ogc_fid_seq; Type: SEQUENCE; Schema: public; Owner: -
2512--
2513
2514CREATE SEQUENCE ax_sportfreizeitunderholungsflaeche_ogc_fid_seq
2515    START WITH 1
2516    INCREMENT BY 1
2517    NO MAXVALUE
2518    NO MINVALUE
2519    CACHE 1;
2520
2521
2522--
2523-- TOC entry 3646 (class 0 OID 0)
2524-- Dependencies: 2705
2525-- Name: ax_sportfreizeitunderholungsflaeche_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2526--
2527
2528ALTER SEQUENCE ax_sportfreizeitunderholungsflaeche_ogc_fid_seq OWNED BY ax_sportfreizeitunderholungsflaeche.ogc_fid;
2529
2530
2531--
2532-- TOC entry 2708 (class 1259 OID 30345)
2533-- Dependencies: 3203 3204 3205 1087 3
2534-- Name: ax_stehendesgewaesser; Type: TABLE; Schema: public; Owner: -
2535--
2536
2537CREATE TABLE ax_stehendesgewaesser (
2538    ogc_fid integer NOT NULL,
2539    wkb_geometry geometry,
2540    gml_id character(16),
2541    identifier character(28),
2542    beginnt character(20),
2543    advstandardmodell character varying[],
2544    art character(16),
2545    name character(11),
2546    name_ character(200),
2547    unverschluesselt character(200),
2548    CONSTRAINT enforce_dims_wkb_geometry CHECK ((st_ndims(wkb_geometry) = 2)),
2549    CONSTRAINT enforce_geotype_wkb_geometry CHECK (((geometrytype(wkb_geometry) = 'POLYGON'::text) OR (wkb_geometry IS NULL))),
2550    CONSTRAINT enforce_srid_wkb_geometry CHECK ((st_srid(wkb_geometry) = 25832))
2551);
2552
2553
2554--
2555-- TOC entry 2707 (class 1259 OID 30343)
2556-- Dependencies: 3 2708
2557-- Name: ax_stehendesgewaesser_ogc_fid_seq; Type: SEQUENCE; Schema: public; Owner: -
2558--
2559
2560CREATE SEQUENCE ax_stehendesgewaesser_ogc_fid_seq
2561    START WITH 1
2562    INCREMENT BY 1
2563    NO MAXVALUE
2564    NO MINVALUE
2565    CACHE 1;
2566
2567
2568--
2569-- TOC entry 3647 (class 0 OID 0)
2570-- Dependencies: 2707
2571-- Name: ax_stehendesgewaesser_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2572--
2573
2574ALTER SEQUENCE ax_stehendesgewaesser_ogc_fid_seq OWNED BY ax_stehendesgewaesser.ogc_fid;
2575
2576
2577--
2578-- TOC entry 2728 (class 1259 OID 30533)
2579-- Dependencies: 3
2580-- Name: ax_strasse; Type: TABLE; Schema: public; Owner: -
2581--
2582
2583CREATE TABLE ax_strasse (
2584    ogc_fid integer NOT NULL,
2585    gml_id character(16),
2586    identifier character(28),
2587    beginnt character(20),
2588    advstandardmodell character varying[],
2589    art character varying[],
2590    name character varying[],
2591    name_ character(200), --19
2592    widmung integer,
2593    strassenschluessel double precision,
2594    bezeichnung character(200), --4
2595    fahrbahntrennung integer
2596);
2597
2598-- keine Geometrie, daher ersatzweise: Dummy-Eintrag in Metatabelle - siehe ALKIS
2599INSERT INTO geometry_columns
2600   (f_table_catalog, f_table_schema, f_table_name, f_geometry_column, coord_dimension, srid, type)
2601VALUES ('', 'public', 'ax_strasse', 'dummy', 2, 25832, 'POINT');
2602
2603
2604
2605--
2606-- TOC entry 2727 (class 1259 OID 30531)
2607-- Dependencies: 2728 3
2608-- Name: ax_strasse_ogc_fid_seq; Type: SEQUENCE; Schema: public; Owner: -
2609--
2610
2611CREATE SEQUENCE ax_strasse_ogc_fid_seq
2612    START WITH 1
2613    INCREMENT BY 1
2614    NO MAXVALUE
2615    NO MINVALUE
2616    CACHE 1;
2617
2618
2619--
2620-- TOC entry 3648 (class 0 OID 0)
2621-- Dependencies: 2727
2622-- Name: ax_strasse_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2623--
2624
2625ALTER SEQUENCE ax_strasse_ogc_fid_seq OWNED BY ax_strasse.ogc_fid;
2626
2627
2628--
2629-- TOC entry 2710 (class 1259 OID 30361)
2630-- Dependencies: 3207 3208 3209 1087 3
2631-- Name: ax_strassenachse; Type: TABLE; Schema: public; Owner: -
2632--
2633
2634CREATE TABLE ax_strassenachse (
2635    ogc_fid integer NOT NULL,
2636    wkb_geometry geometry,
2637    gml_id character(16),
2638    identifier character(28),
2639    beginnt character(20),
2640    advstandardmodell character varying[],
2641    art character(16),
2642    name character(11),
2643    istteilvon character varying,
2644    hatdirektunten character varying,
2645    breitederfahrbahn double precision,
2646    anzahlderfahrstreifen integer,
2647    verkehrsbedeutunginneroertlich integer,
2648    CONSTRAINT enforce_dims_wkb_geometry CHECK ((st_ndims(wkb_geometry) = 2)),
2649    CONSTRAINT enforce_geotype_wkb_geometry CHECK (((geometrytype(wkb_geometry) = 'LINESTRING'::text) OR (wkb_geometry IS NULL))),
2650    CONSTRAINT enforce_srid_wkb_geometry CHECK ((st_srid(wkb_geometry) = 25832))
2651);
2652
2653
2654--
2655-- TOC entry 2709 (class 1259 OID 30359)
2656-- Dependencies: 2710 3
2657-- Name: ax_strassenachse_ogc_fid_seq; Type: SEQUENCE; Schema: public; Owner: -
2658--
2659
2660CREATE SEQUENCE ax_strassenachse_ogc_fid_seq
2661    START WITH 1
2662    INCREMENT BY 1
2663    NO MAXVALUE
2664    NO MINVALUE
2665    CACHE 1;
2666
2667
2668--
2669-- TOC entry 3649 (class 0 OID 0)
2670-- Dependencies: 2709
2671-- Name: ax_strassenachse_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2672--
2673
2674ALTER SEQUENCE ax_strassenachse_ogc_fid_seq OWNED BY ax_strassenachse.ogc_fid;
2675
2676
2677--
2678-- TOC entry 2712 (class 1259 OID 30377)
2679-- Dependencies: 3211 3212 3213 1087 3
2680-- Name: ax_strassenverkehr; Type: TABLE; Schema: public; Owner: -
2681--
2682
2683CREATE TABLE ax_strassenverkehr (
2684    ogc_fid integer NOT NULL,
2685    wkb_geometry geometry,
2686    gml_id character(16),
2687    identifier character(28),
2688    beginnt character(20),
2689    advstandardmodell character varying[],
2690    art character(16),
2691    name character(11),
2692    funktion integer,
2693    hatdirektunten character varying,
2694    CONSTRAINT enforce_dims_wkb_geometry CHECK ((st_ndims(wkb_geometry) = 2)),
2695    --CONSTRAINT enforce_geotype_wkb_geometry CHECK (((geometrytype(wkb_geometry) = 'POLYGON'::text) OR (wkb_geometry IS NULL))),
2696    CONSTRAINT enforce_srid_wkb_geometry CHECK ((st_srid(wkb_geometry) = 25832))
2697);
2698
2699
2700--
2701-- TOC entry 2711 (class 1259 OID 30375)
2702-- Dependencies: 3 2712
2703-- Name: ax_strassenverkehr_ogc_fid_seq; Type: SEQUENCE; Schema: public; Owner: -
2704--
2705
2706CREATE SEQUENCE ax_strassenverkehr_ogc_fid_seq
2707    START WITH 1
2708    INCREMENT BY 1
2709    NO MAXVALUE
2710    NO MINVALUE
2711    CACHE 1;
2712
2713
2714--
2715-- TOC entry 3650 (class 0 OID 0)
2716-- Dependencies: 2711
2717-- Name: ax_strassenverkehr_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2718--
2719
2720ALTER SEQUENCE ax_strassenverkehr_ogc_fid_seq OWNED BY ax_strassenverkehr.ogc_fid;
2721
2722
2723--
2724-- TOC entry 2720 (class 1259 OID 30441)
2725-- Dependencies: 3227 3228 3229 1087 3
2726-- Name: ax_strassenverkehrsanlage; Type: TABLE; Schema: public; Owner: -
2727--
2728
2729CREATE TABLE ax_strassenverkehrsanlage (
2730    ogc_fid integer NOT NULL,
2731    wkb_geometry geometry,
2732    gml_id character(16),
2733    identifier character(28),
2734    beginnt character(20),
2735    advstandardmodell character varying[],
2736    art character(16),
2737    name character(11),
2738    art_ integer,
2739    CONSTRAINT enforce_dims_wkb_geometry CHECK ((st_ndims(wkb_geometry) = 2)),
2740    --CONSTRAINT enforce_geotype_wkb_geometry CHECK (((geometrytype(wkb_geometry) = 'POINT'::text) OR (wkb_geometry IS NULL))),
2741    CONSTRAINT enforce_srid_wkb_geometry CHECK ((st_srid(wkb_geometry) = 25832))
2742);
2743
2744
2745--
2746-- TOC entry 2719 (class 1259 OID 30439)
2747-- Dependencies: 3 2720
2748-- Name: ax_strassenverkehrsanlage_ogc_fid_seq; Type: SEQUENCE; Schema: public; Owner: -
2749--
2750
2751CREATE SEQUENCE ax_strassenverkehrsanlage_ogc_fid_seq
2752    START WITH 1
2753    INCREMENT BY 1
2754    NO MAXVALUE
2755    NO MINVALUE
2756    CACHE 1;
2757
2758
2759--
2760-- TOC entry 3651 (class 0 OID 0)
2761-- Dependencies: 2719
2762-- Name: ax_strassenverkehrsanlage_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2763--
2764
2765ALTER SEQUENCE ax_strassenverkehrsanlage_ogc_fid_seq OWNED BY ax_strassenverkehrsanlage.ogc_fid;
2766
2767
2768--
2769-- TOC entry 2778 (class 1259 OID 34082)
2770-- Dependencies: 3333 3334 3335 3 1087
2771-- Name: ax_sumpf; Type: TABLE; Schema: public; Owner: -
2772--
2773
2774CREATE TABLE ax_sumpf (
2775    ogc_fid integer NOT NULL,
2776    wkb_geometry geometry,
2777    gml_id character(16),
2778    identifier character(28),
2779    beginnt character(20),
2780    advstandardmodell character varying[],
2781    art character(16),
2782    name character(11),
2783    CONSTRAINT enforce_dims_wkb_geometry CHECK ((st_ndims(wkb_geometry) = 2)),
2784    CONSTRAINT enforce_geotype_wkb_geometry CHECK (((geometrytype(wkb_geometry) = 'POLYGON'::text) OR (wkb_geometry IS NULL))),
2785    CONSTRAINT enforce_srid_wkb_geometry CHECK ((st_srid(wkb_geometry) = 25832))
2786);
2787
2788
2789--
2790-- TOC entry 2777 (class 1259 OID 34080)
2791-- Dependencies: 3 2778
2792-- Name: ax_sumpf_ogc_fid_seq; Type: SEQUENCE; Schema: public; Owner: -
2793--
2794
2795CREATE SEQUENCE ax_sumpf_ogc_fid_seq
2796    START WITH 1
2797    INCREMENT BY 1
2798    NO MAXVALUE
2799    NO MINVALUE
2800    CACHE 1;
2801
2802
2803--
2804-- TOC entry 3652 (class 0 OID 0)
2805-- Dependencies: 2777
2806-- Name: ax_sumpf_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2807--
2808
2809ALTER SEQUENCE ax_sumpf_ogc_fid_seq OWNED BY ax_sumpf.ogc_fid;
2810
2811
2812--
2813-- TOC entry 2754 (class 1259 OID 30887)
2814-- Dependencies: 3288 3289 3290 1087 3
2815-- Name: ax_tagebaugrubesteinbruch; Type: TABLE; Schema: public; Owner: -
2816--
2817
2818CREATE TABLE ax_tagebaugrubesteinbruch (
2819    ogc_fid integer NOT NULL,
2820    wkb_geometry geometry,
2821    gml_id character(16),
2822    identifier character(28),
2823    beginnt character(20),
2824    advstandardmodell character varying[],
2825    art character(16),
2826    name character(11),
2827    CONSTRAINT enforce_dims_wkb_geometry CHECK ((st_ndims(wkb_geometry) = 2)),
2828    CONSTRAINT enforce_geotype_wkb_geometry CHECK (((geometrytype(wkb_geometry) = 'POLYGON'::text) OR (wkb_geometry IS NULL))),
2829    CONSTRAINT enforce_srid_wkb_geometry CHECK ((st_srid(wkb_geometry) = 25832))
2830);
2831
2832
2833--
2834-- TOC entry 2753 (class 1259 OID 30885)
2835-- Dependencies: 2754 3
2836-- Name: ax_tagebaugrubesteinbruch_ogc_fid_seq; Type: SEQUENCE; Schema: public; Owner: -
2837--
2838
2839CREATE SEQUENCE ax_tagebaugrubesteinbruch_ogc_fid_seq
2840    START WITH 1
2841    INCREMENT BY 1
2842    NO MAXVALUE
2843    NO MINVALUE
2844    CACHE 1;
2845
2846
2847--
2848-- TOC entry 3653 (class 0 OID 0)
2849-- Dependencies: 2753
2850-- Name: ax_tagebaugrubesteinbruch_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2851--
2852
2853ALTER SEQUENCE ax_tagebaugrubesteinbruch_ogc_fid_seq OWNED BY ax_tagebaugrubesteinbruch.ogc_fid;
2854
2855
2856--
2857-- TOC entry 2718 (class 1259 OID 30425)
2858-- Dependencies: 3223 3224 3225 3 1087
2859-- Name: ax_transportanlage; Type: TABLE; Schema: public; Owner: -
2860--
2861
2862CREATE TABLE ax_transportanlage (
2863    ogc_fid integer NOT NULL,
2864    wkb_geometry geometry,
2865    gml_id character(16),
2866    identifier character(28),
2867    beginnt character(20),
2868    advstandardmodell character varying[],
2869    art character(16),
2870    name character(11),
2871    bauwerksfunktion integer,
2872    produkt integer,
2873    CONSTRAINT enforce_dims_wkb_geometry CHECK ((st_ndims(wkb_geometry) = 2)),
2874    --CONSTRAINT enforce_geotype_wkb_geometry CHECK (((geometrytype(wkb_geometry) = 'POINT'::text) OR (wkb_geometry IS NULL))),
2875    CONSTRAINT enforce_srid_wkb_geometry CHECK ((st_srid(wkb_geometry) = 25832))
2876);
2877
2878
2879--
2880-- TOC entry 2717 (class 1259 OID 30423)
2881-- Dependencies: 3 2718
2882-- Name: ax_transportanlage_ogc_fid_seq; Type: SEQUENCE; Schema: public; Owner: -
2883--
2884
2885CREATE SEQUENCE ax_transportanlage_ogc_fid_seq
2886    START WITH 1
2887    INCREMENT BY 1
2888    NO MAXVALUE
2889    NO MINVALUE
2890    CACHE 1;
2891
2892
2893--
2894-- TOC entry 3654 (class 0 OID 0)
2895-- Dependencies: 2717
2896-- Name: ax_transportanlage_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2897--
2898
2899ALTER SEQUENCE ax_transportanlage_ogc_fid_seq OWNED BY ax_transportanlage.ogc_fid;
2900
2901
2902--
2903-- TOC entry 2716 (class 1259 OID 30409)
2904-- Dependencies: 3219 3220 3221 3 1087
2905-- Name: ax_turm; Type: TABLE; Schema: public; Owner: -
2906--
2907
2908CREATE TABLE ax_turm (
2909    ogc_fid integer NOT NULL,
2910    wkb_geometry geometry,
2911    gml_id character(16),
2912    identifier character(28),
2913    beginnt character(20),
2914    advstandardmodell character varying[],
2915    art character(16),
2916    name character(11),
2917    bauwerksfunktion integer,
2918    CONSTRAINT enforce_dims_wkb_geometry CHECK ((st_ndims(wkb_geometry) = 2)),
2919    --CONSTRAINT enforce_geotype_wkb_geometry CHECK (((geometrytype(wkb_geometry) = 'POINT'::text) OR (wkb_geometry IS NULL))),
2920    CONSTRAINT enforce_srid_wkb_geometry CHECK ((st_srid(wkb_geometry) = 25832))
2921);
2922
2923
2924--
2925-- TOC entry 2715 (class 1259 OID 30407)
2926-- Dependencies: 2716 3
2927-- Name: ax_turm_ogc_fid_seq; Type: SEQUENCE; Schema: public; Owner: -
2928--
2929
2930CREATE SEQUENCE ax_turm_ogc_fid_seq
2931    START WITH 1
2932    INCREMENT BY 1
2933    NO MAXVALUE
2934    NO MINVALUE
2935    CACHE 1;
2936
2937
2938--
2939-- TOC entry 3655 (class 0 OID 0)
2940-- Dependencies: 2715
2941-- Name: ax_turm_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2942--
2943
2944ALTER SEQUENCE ax_turm_ogc_fid_seq OWNED BY ax_turm.ogc_fid;
2945
2946
2947--
2948-- TOC entry 2714 (class 1259 OID 30393)
2949-- Dependencies: 3215 3216 3217 1087 3
2950-- Name: ax_unlandvegetationsloseflaeche; Type: TABLE; Schema: public; Owner: -
2951--
2952
2953CREATE TABLE ax_unlandvegetationsloseflaeche (
2954    ogc_fid integer NOT NULL,
2955    wkb_geometry geometry,
2956    gml_id character(16),
2957    identifier character(28),
2958    beginnt character(20),
2959    advstandardmodell character varying[],
2960    art character(16),
2961    name character(11),
2962    funktion integer,
2963    CONSTRAINT enforce_dims_wkb_geometry CHECK ((st_ndims(wkb_geometry) = 2)),
2964    CONSTRAINT enforce_geotype_wkb_geometry CHECK (((geometrytype(wkb_geometry) = 'POLYGON'::text) OR (wkb_geometry IS NULL))),
2965    CONSTRAINT enforce_srid_wkb_geometry CHECK ((st_srid(wkb_geometry) = 25832))
2966);
2967
2968
2969--
2970-- TOC entry 2713 (class 1259 OID 30391)
2971-- Dependencies: 3 2714
2972-- Name: ax_unlandvegetationsloseflaeche_ogc_fid_seq; Type: SEQUENCE; Schema: public; Owner: -
2973--
2974
2975CREATE SEQUENCE ax_unlandvegetationsloseflaeche_ogc_fid_seq
2976    START WITH 1
2977    INCREMENT BY 1
2978    NO MAXVALUE
2979    NO MINVALUE
2980    CACHE 1;
2981
2982
2983--
2984-- TOC entry 3656 (class 0 OID 0)
2985-- Dependencies: 2713
2986-- Name: ax_unlandvegetationsloseflaeche_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2987--
2988
2989ALTER SEQUENCE ax_unlandvegetationsloseflaeche_ogc_fid_seq OWNED BY ax_unlandvegetationsloseflaeche.ogc_fid;
2990
2991
2992--
2993-- TOC entry 2722 (class 1259 OID 30457)
2994-- Dependencies: 3231 3232 3 1087
2995-- Name: ax_vegetationsmerkmal; Type: TABLE; Schema: public; Owner: -
2996--
2997
2998CREATE TABLE ax_vegetationsmerkmal (
2999    ogc_fid integer NOT NULL,
3000    wkb_geometry geometry,
3001    gml_id character(16),
3002    identifier character(28),
3003    beginnt character(20),
3004    advstandardmodell character varying[],
3005    art character(16),
3006    name character(11),
3007    bewuchs integer,
3008    CONSTRAINT enforce_dims_wkb_geometry CHECK ((st_ndims(wkb_geometry) = 2)),
3009    CONSTRAINT enforce_srid_wkb_geometry CHECK ((st_srid(wkb_geometry) = 25832))
3010);
3011
3012
3013--
3014-- TOC entry 2721 (class 1259 OID 30455)
3015-- Dependencies: 3 2722
3016-- Name: ax_vegetationsmerkmal_ogc_fid_seq; Type: SEQUENCE; Schema: public; Owner: -
3017--
3018
3019CREATE SEQUENCE ax_vegetationsmerkmal_ogc_fid_seq
3020    START WITH 1
3021    INCREMENT BY 1
3022    NO MAXVALUE
3023    NO MINVALUE
3024    CACHE 1;
3025
3026
3027--
3028-- TOC entry 3657 (class 0 OID 0)
3029-- Dependencies: 2721
3030-- Name: ax_vegetationsmerkmal_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
3031--
3032
3033ALTER SEQUENCE ax_vegetationsmerkmal_ogc_fid_seq OWNED BY ax_vegetationsmerkmal.ogc_fid;
3034
3035
3036--
3037-- TOC entry 2666 (class 1259 OID 29861)
3038-- Dependencies: 3123 3124 3125 3 1087
3039-- Name: ax_wald; Type: TABLE; Schema: public; Owner: -
3040--
3041
3042CREATE TABLE ax_wald (
3043    ogc_fid integer NOT NULL,
3044    wkb_geometry geometry,
3045    gml_id character(16),
3046    identifier character(28),
3047    beginnt character(20),
3048    advstandardmodell character varying[],
3049    art character(16),
3050    name character(11),
3051    vegetationsmerkmal integer,
3052    CONSTRAINT enforce_dims_wkb_geometry CHECK ((st_ndims(wkb_geometry) = 2)),
3053    CONSTRAINT enforce_geotype_wkb_geometry CHECK (((geometrytype(wkb_geometry) = 'POLYGON'::text) OR (wkb_geometry IS NULL))),
3054    CONSTRAINT enforce_srid_wkb_geometry CHECK ((st_srid(wkb_geometry) = 25832))
3055);
3056
3057
3058--
3059-- TOC entry 2665 (class 1259 OID 29859)
3060-- Dependencies: 3 2666
3061-- Name: ax_wald_ogc_fid_seq; Type: SEQUENCE; Schema: public; Owner: -
3062--
3063
3064CREATE SEQUENCE ax_wald_ogc_fid_seq
3065    START WITH 1
3066    INCREMENT BY 1
3067    NO MAXVALUE
3068    NO MINVALUE
3069    CACHE 1;
3070
3071
3072--
3073-- TOC entry 3658 (class 0 OID 0)
3074-- Dependencies: 2665
3075-- Name: ax_wald_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
3076--
3077
3078ALTER SEQUENCE ax_wald_ogc_fid_seq OWNED BY ax_wald.ogc_fid;
3079
3080
3081--
3082-- TOC entry 2756 (class 1259 OID 30987)
3083-- Dependencies: 3
3084-- Name: ax_wasserlauf; Type: TABLE; Schema: public; Owner: -
3085--
3086
3087CREATE TABLE ax_wasserlauf (
3088    ogc_fid integer NOT NULL,
3089    gml_id character(16),
3090    identifier character(28),
3091    beginnt character(20),
3092    advstandardmodell character varying[],
3093    art character(16),
3094    name character(11),
3095    name_ character(200), --20
3096    unverschluesselt character(200), --null
3097    gewaesserkennzahl double precision
3098);
3099
3100-- keine Geometrie, daher ersatzweise: Dummy-Eintrag in Metatabelle - siehe ALKIS
3101INSERT INTO geometry_columns
3102   (f_table_catalog, f_table_schema, f_table_name, f_geometry_column, coord_dimension, srid, type)
3103VALUES ('', 'public', 'ax_wasserlauf', 'dummy', 2, 25832, 'POINT');
3104
3105--
3106-- TOC entry 2755 (class 1259 OID 30985)
3107-- Dependencies: 2756 3
3108-- Name: ax_wasserlauf_ogc_fid_seq; Type: SEQUENCE; Schema: public; Owner: -
3109--
3110
3111CREATE SEQUENCE ax_wasserlauf_ogc_fid_seq
3112    START WITH 1
3113    INCREMENT BY 1
3114    NO MAXVALUE
3115    NO MINVALUE
3116    CACHE 1;
3117
3118
3119--
3120-- TOC entry 3659 (class 0 OID 0)
3121-- Dependencies: 2755
3122-- Name: ax_wasserlauf_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
3123--
3124
3125ALTER SEQUENCE ax_wasserlauf_ogc_fid_seq OWNED BY ax_wasserlauf.ogc_fid;
3126
3127
3128--
3129-- TOC entry 2764 (class 1259 OID 32124)
3130-- Dependencies: 3305 3306 3307 3 1087
3131-- Name: ax_wasserspiegelhoehe; Type: TABLE; Schema: public; Owner: -
3132--
3133
3134CREATE TABLE ax_wasserspiegelhoehe (
3135    ogc_fid integer NOT NULL,
3136    wkb_geometry geometry,
3137    gml_id character(16),
3138    identifier character(28),
3139    beginnt character(20),
3140    advstandardmodell character varying[],
3141    art character(16),
3142    name character(11),
3143    hoehedeswasserspiegels double precision,
3144    CONSTRAINT enforce_dims_wkb_geometry CHECK ((st_ndims(wkb_geometry) = 2)),
3145    CONSTRAINT enforce_geotype_wkb_geometry CHECK (((geometrytype(wkb_geometry) = 'POINT'::text) OR (wkb_geometry IS NULL))),
3146    CONSTRAINT enforce_srid_wkb_geometry CHECK ((st_srid(wkb_geometry) = 25832))
3147);
3148
3149
3150--
3151-- TOC entry 2763 (class 1259 OID 32122)
3152-- Dependencies: 3 2764
3153-- Name: ax_wasserspiegelhoehe_ogc_fid_seq; Type: SEQUENCE; Schema: public; Owner: -
3154--
3155
3156CREATE SEQUENCE ax_wasserspiegelhoehe_ogc_fid_seq
3157    START WITH 1
3158    INCREMENT BY 1
3159    NO MAXVALUE
3160    NO MINVALUE
3161    CACHE 1;
3162
3163
3164--
3165-- TOC entry 3660 (class 0 OID 0)
3166-- Dependencies: 2763
3167-- Name: ax_wasserspiegelhoehe_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
3168--
3169
3170ALTER SEQUENCE ax_wasserspiegelhoehe_ogc_fid_seq OWNED BY ax_wasserspiegelhoehe.ogc_fid;
3171
3172
3173--
3174-- TOC entry 2668 (class 1259 OID 29883)
3175-- Dependencies: 3127 3128 3129 3 1087
3176-- Name: ax_wegpfadsteig; Type: TABLE; Schema: public; Owner: -
3177--
3178
3179CREATE TABLE ax_wegpfadsteig (
3180    ogc_fid integer NOT NULL,
3181    wkb_geometry geometry,
3182    gml_id character(16),
3183    identifier character(28),
3184    beginnt character(20),
3185    advstandardmodell character varying[],
3186    art character(16),
3187    name character(11),
3188    art_ integer,
3189    breitedesverkehrsweges integer,
3190    CONSTRAINT enforce_dims_wkb_geometry CHECK ((st_ndims(wkb_geometry) = 2)),
3191    CONSTRAINT enforce_geotype_wkb_geometry CHECK (((geometrytype(wkb_geometry) = 'LINESTRING'::text) OR (wkb_geometry IS NULL))),
3192    CONSTRAINT enforce_srid_wkb_geometry CHECK ((st_srid(wkb_geometry) = 25832))
3193);
3194
3195
3196--
3197-- TOC entry 2667 (class 1259 OID 29881)
3198-- Dependencies: 2668 3
3199-- Name: ax_wegpfadsteig_ogc_fid_seq; Type: SEQUENCE; Schema: public; Owner: -
3200--
3201
3202CREATE SEQUENCE ax_wegpfadsteig_ogc_fid_seq
3203    START WITH 1
3204    INCREMENT BY 1
3205    NO MAXVALUE
3206    NO MINVALUE
3207    CACHE 1;
3208
3209
3210--
3211-- TOC entry 3661 (class 0 OID 0)
3212-- Dependencies: 2667
3213-- Name: ax_wegpfadsteig_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
3214--
3215
3216ALTER SEQUENCE ax_wegpfadsteig_ogc_fid_seq OWNED BY ax_wegpfadsteig.ogc_fid;
3217
3218
3219--
3220-- TOC entry 2724 (class 1259 OID 30501)
3221-- Dependencies: 3234 3235 3236 1087 3
3222-- Name: ax_wohnbauflaeche; Type: TABLE; Schema: public; Owner: -
3223--
3224
3225CREATE TABLE ax_wohnbauflaeche (
3226    ogc_fid integer NOT NULL,
3227    wkb_geometry geometry,
3228    gml_id character(16),
3229    identifier character(28),
3230    beginnt character(20),
3231    advstandardmodell character varying[],
3232    art character(16),
3233    name character(11),
3234    artderbebauung integer,
3235    CONSTRAINT enforce_dims_wkb_geometry CHECK ((st_ndims(wkb_geometry) = 2)),
3236    CONSTRAINT enforce_geotype_wkb_geometry CHECK (((geometrytype(wkb_geometry) = 'POLYGON'::text) OR (wkb_geometry IS NULL))),
3237    CONSTRAINT enforce_srid_wkb_geometry CHECK ((st_srid(wkb_geometry) = 25832))
3238);
3239
3240
3241--
3242-- TOC entry 2723 (class 1259 OID 30499)
3243-- Dependencies: 2724 3
3244-- Name: ax_wohnbauflaeche_ogc_fid_seq; Type: SEQUENCE; Schema: public; Owner: -
3245--
3246
3247CREATE SEQUENCE ax_wohnbauflaeche_ogc_fid_seq
3248    START WITH 1
3249    INCREMENT BY 1
3250    NO MAXVALUE
3251    NO MINVALUE
3252    CACHE 1;
3253
3254
3255--
3256-- TOC entry 3662 (class 0 OID 0)
3257-- Dependencies: 2723
3258-- Name: ax_wohnbauflaeche_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
3259--
3260
3261ALTER SEQUENCE ax_wohnbauflaeche_ogc_fid_seq OWNED BY ax_wohnbauflaeche.ogc_fid;
3262
3263
3264--
3265-- TOC entry 2726 (class 1259 OID 30517)
3266-- Dependencies: 3238 3239 3240 3 1087
3267-- Name: ax_wohnplatz; Type: TABLE; Schema: public; Owner: -
3268--
3269
3270CREATE TABLE ax_wohnplatz (
3271    ogc_fid integer NOT NULL,
3272    wkb_geometry geometry,
3273    gml_id character(16),
3274    identifier character(28),
3275    beginnt character(20),
3276    advstandardmodell character varying[],
3277    art character(16),
3278    name character(11),
3279    bezeichnung double precision[],
3280    name_ character(200), --28
3281    CONSTRAINT enforce_dims_wkb_geometry CHECK ((st_ndims(wkb_geometry) = 2)),
3282    CONSTRAINT enforce_geotype_wkb_geometry CHECK (((geometrytype(wkb_geometry) = 'POINT'::text) OR (wkb_geometry IS NULL))),
3283    CONSTRAINT enforce_srid_wkb_geometry CHECK ((st_srid(wkb_geometry) = 25832))
3284);
3285
3286
3287--
3288-- TOC entry 2725 (class 1259 OID 30515)
3289-- Dependencies: 2726 3
3290-- Name: ax_wohnplatz_ogc_fid_seq; Type: SEQUENCE; Schema: public; Owner: -
3291--
3292
3293CREATE SEQUENCE ax_wohnplatz_ogc_fid_seq
3294    START WITH 1
3295    INCREMENT BY 1
3296    NO MAXVALUE
3297    NO MINVALUE
3298    CACHE 1;
3299
3300
3301--
3302-- TOC entry 3663 (class 0 OID 0)
3303-- Dependencies: 2725
3304-- Name: ax_wohnplatz_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
3305--
3306
3307ALTER SEQUENCE ax_wohnplatz_ogc_fid_seq OWNED BY ax_wohnplatz.ogc_fid;
3308
3309--
3310-- TOC entry 3130 (class 2604 OID 29902)
3311-- Dependencies: 2669 2670 2670
3312-- Name: ogc_fid; Type: DEFAULT; Schema: public; Owner: -
3313--
3314
3315ALTER TABLE alkis_beziehungen ALTER COLUMN ogc_fid SET DEFAULT nextval('alkis_beziehungen_ogc_fid_seq'::regclass);
3316
3317
3318--
3319-- TOC entry 3131 (class 2604 OID 29914)
3320-- Dependencies: 2672 2671 2672
3321-- Name: ogc_fid; Type: DEFAULT; Schema: public; Owner: -
3322--
3323
3324ALTER TABLE ax_abschnitt ALTER COLUMN ogc_fid SET DEFAULT nextval('ax_abschnitt_ogc_fid_seq'::regclass);
3325
3326
3327--
3328-- TOC entry 3135 (class 2604 OID 29930)
3329-- Dependencies: 2673 2674 2674
3330-- Name: ogc_fid; Type: DEFAULT; Schema: public; Owner: -
3331--
3332
3333ALTER TABLE ax_ast ALTER COLUMN ogc_fid SET DEFAULT nextval('ax_ast_ogc_fid_seq'::regclass);
3334
3335
3336--
3337-- TOC entry 3247 (class 2604 OID 30571)
3338-- Dependencies: 2733 2734 2734
3339-- Name: ogc_fid; Type: DEFAULT; Schema: public; Owner: -
3340--
3341
3342ALTER TABLE ax_bahnstrecke ALTER COLUMN ogc_fid SET DEFAULT nextval('ax_bahnstrecke_ogc_fid_seq'::regclass);
3343
3344
3345--
3346-- TOC entry 3316 (class 2604 OID 33472)
3347-- Dependencies: 2770 2769 2770
3348-- Name: ogc_fid; Type: DEFAULT; Schema: public; Owner: -
3349--
3350
3351ALTER TABLE ax_bahnverkehr ALTER COLUMN ogc_fid SET DEFAULT nextval('ax_bahnverkehr_ogc_fid_seq'::regclass);
3352
3353
3354--
3355-- TOC entry 3243 (class 2604 OID 30555)
3356-- Dependencies: 2732 2731 2732
3357-- Name: ogc_fid; Type: DEFAULT; Schema: public; Owner: -
3358--
3359
3360ALTER TABLE ax_bahnverkehrsanlage ALTER COLUMN ogc_fid SET DEFAULT nextval('ax_bahnverkehrsanlage_ogc_fid_seq'::regclass);
3361
3362
3363--
3364-- TOC entry 3139 (class 2604 OID 29946)
3365-- Dependencies: 2675 2676 2676
3366-- Name: ogc_fid; Type: DEFAULT; Schema: public; Owner: -
3367--
3368
3369ALTER TABLE ax_bauwerkimgewaesserbereich ALTER COLUMN ogc_fid SET DEFAULT nextval('ax_bauwerkimgewaesserbereich_ogc_fid_seq'::regclass);
3370
3371
3372--
3373-- TOC entry 3147 (class 2604 OID 29978)
3374-- Dependencies: 2680 2679 2680
3375-- Name: ogc_fid; Type: DEFAULT; Schema: public; Owner: -
3376--
3377
3378ALTER TABLE ax_bauwerkimverkehrsbereich ALTER COLUMN ogc_fid SET DEFAULT nextval('ax_bauwerkimverkehrsbereich_ogc_fid_seq'::regclass);
3379
3380
3381--
3382-- TOC entry 3150 (class 2604 OID 29993)
3383-- Dependencies: 2682 2681 2682
3384-- Name: ogc_fid; Type: DEFAULT; Schema: public; Owner: -
3385--
3386
3387ALTER TABLE ax_bauwerkoderanlagefuerindustrieundgewerbe ALTER COLUMN ogc_fid SET DEFAULT nextval('ax_bauwerkoderanlagefuerindustrieundgewerbe_ogc_fid_seq'::regclass);
3388
3389
3390--
3391-- TOC entry 3143 (class 2604 OID 29962)
3392-- Dependencies: 2677 2678 2678
3393-- Name: ogc_fid; Type: DEFAULT; Schema: public; Owner: -
3394--
3395
3396ALTER TABLE ax_bauwerkoderanlagefuersportfreizeitunderholung ALTER COLUMN ogc_fid SET DEFAULT nextval('ax_bauwerkoderanlagefuersportfreizeitunderholung_ogc_fid_seq'::regclass);
3397
3398
3399--
3400-- TOC entry 3365 (class 2604 OID 133068)
3401-- Dependencies: 2796 2795 2796
3402-- Name: ogc_fid; Type: DEFAULT; Schema: public; Owner: -
3403--
3404
3405ALTER TABLE ax_bergbaubetrieb ALTER COLUMN ogc_fid SET DEFAULT nextval('ax_bergbaubetrieb_ogc_fid_seq'::regclass);
3406
3407
3408--
3409-- TOC entry 3255 (class 2604 OID 30603)
3410-- Dependencies: 2738 2737 2738
3411-- Name: ogc_fid; Type: DEFAULT; Schema: public; Owner: -
3412--
3413
3414ALTER TABLE ax_dammwalldeich ALTER COLUMN ogc_fid SET DEFAULT nextval('ax_dammwalldeich_ogc_fid_seq'::regclass);
3415
3416
3417--
3418-- TOC entry 3292 (class 2604 OID 31001)
3419-- Dependencies: 2757 2758 2758
3420-- Name: ogc_fid; Type: DEFAULT; Schema: public; Owner: -
3421--
3422
3423ALTER TABLE ax_denkmalschutzrecht ALTER COLUMN ogc_fid SET DEFAULT nextval('ax_denkmalschutzrecht_ogc_fid_seq'::regclass);
3424
3425
3426--
3427-- TOC entry 3251 (class 2604 OID 30587)
3428-- Dependencies: 2735 2736 2736
3429-- Name: ogc_fid; Type: DEFAULT; Schema: public; Owner: -
3430--
3431
3432ALTER TABLE ax_einrichtungenfuerdenschiffsverkehr ALTER COLUMN ogc_fid SET DEFAULT nextval('ax_einrichtungenfuerdenschiffsverkehr_ogc_fid_seq'::regclass);
3433
3434
3435--
3436-- TOC entry 3154 (class 2604 OID 30009)
3437-- Dependencies: 2683 2684 2684
3438-- Name: ogc_fid; Type: DEFAULT; Schema: public; Owner: -
3439--
3440
3441ALTER TABLE ax_fahrbahnachse ALTER COLUMN ogc_fid SET DEFAULT nextval('ax_fahrbahnachse_ogc_fid_seq'::regclass);
3442
3443
3444--
3445-- TOC entry 3094 (class 2604 OID 29722)
3446-- Dependencies: 2651 2652 2652
3447-- Name: ogc_fid; Type: DEFAULT; Schema: public; Owner: -
3448--
3449
3450ALTER TABLE ax_fahrwegachse ALTER COLUMN ogc_fid SET DEFAULT nextval('ax_fahrwegachse_ogc_fid_seq'::regclass);
3451
3452
3453--
3454-- TOC entry 3296 (class 2604 OID 31047)
3455-- Dependencies: 2759 2760 2760
3456-- Name: ogc_fid; Type: DEFAULT; Schema: public; Owner: -
3457--
3458
3459ALTER TABLE ax_felsenfelsblockfelsnadel ALTER COLUMN ogc_fid SET DEFAULT nextval('ax_felsenfelsblockfelsnadel_ogc_fid_seq'::regclass);
3460
3461
3462--
3463-- TOC entry 3158 (class 2604 OID 30025)
3464-- Dependencies: 2686 2685 2686
3465-- Name: ogc_fid; Type: DEFAULT; Schema: public; Owner: -
3466--
3467
3468ALTER TABLE ax_flaechebesondererfunktionalerpraegung ALTER COLUMN ogc_fid SET DEFAULT nextval('ax_flaechebesondererfunktionalerpraegung_ogc_fid_seq'::regclass);
3469
3470
3471--
3472-- TOC entry 3162 (class 2604 OID 30041)
3473-- Dependencies: 2688 2687 2688
3474-- Name: ogc_fid; Type: DEFAULT; Schema: public; Owner: -
3475--
3476
3477ALTER TABLE ax_flaechegemischternutzung ALTER COLUMN ogc_fid SET DEFAULT nextval('ax_flaechegemischternutzung_ogc_fid_seq'::regclass);
3478
3479
3480--
3481-- TOC entry 3259 (class 2604 OID 30619)
3482-- Dependencies: 2740 2739 2740
3483-- Name: ogc_fid; Type: DEFAULT; Schema: public; Owner: -
3484--
3485
3486ALTER TABLE ax_flaechezurzeitunbestimmbar ALTER COLUMN ogc_fid SET DEFAULT nextval('ax_flaechezurzeitunbestimmbar_ogc_fid_seq'::regclass);
3487
3488
3489--
3490-- TOC entry 3263 (class 2604 OID 30635)
3491-- Dependencies: 2741 2742 2742
3492-- Name: ogc_fid; Type: DEFAULT; Schema: public; Owner: -
3493--
3494
3495ALTER TABLE ax_fliessgewaesser ALTER COLUMN ogc_fid SET DEFAULT nextval('ax_fliessgewaesser_ogc_fid_seq'::regclass);
3496
3497
3498--
3499-- TOC entry 3308 (class 2604 OID 32185)
3500-- Dependencies: 2765 2766 2766
3501-- Name: ogc_fid; Type: DEFAULT; Schema: public; Owner: -
3502--
3503
3504ALTER TABLE ax_flugverkehr ALTER COLUMN ogc_fid SET DEFAULT nextval('ax_flugverkehr_ogc_fid_seq'::regclass);
3505
3506
3507--
3508-- TOC entry 3312 (class 2604 OID 33037)
3509-- Dependencies: 2767 2768 2768
3510-- Name: ogc_fid; Type: DEFAULT; Schema: public; Owner: -
3511--
3512
3513ALTER TABLE ax_flugverkehrsanlage ALTER COLUMN ogc_fid SET DEFAULT nextval('ax_flugverkehrsanlage_ogc_fid_seq'::regclass);
3514
3515
3516--
3517-- TOC entry 3166 (class 2604 OID 30057)
3518-- Dependencies: 2689 2690 2690
3519-- Name: ogc_fid; Type: DEFAULT; Schema: public; Owner: -
3520--
3521
3522ALTER TABLE ax_friedhof ALTER COLUMN ogc_fid SET DEFAULT nextval('ax_friedhof_ogc_fid_seq'::regclass);
3523
3524
3525--
3526-- TOC entry 3170 (class 2604 OID 30073)
3527-- Dependencies: 2692 2691 2692
3528-- Name: ogc_fid; Type: DEFAULT; Schema: public; Owner: -
3529--
3530
3531ALTER TABLE ax_gebaeude ALTER COLUMN ogc_fid SET DEFAULT nextval('ax_gebaeude_ogc_fid_seq'::regclass);
3532
3533
3534--
3535-- TOC entry 3098 (class 2604 OID 29738)
3536-- Dependencies: 2653 2654 2654
3537-- Name: ogc_fid; Type: DEFAULT; Schema: public; Owner: -
3538--
3539
3540ALTER TABLE ax_gebietsgrenze ALTER COLUMN ogc_fid SET DEFAULT nextval('ax_gebietsgrenze_ogc_fid_seq'::regclass);
3541
3542
3543--
3544-- TOC entry 3174 (class 2604 OID 30131)
3545-- Dependencies: 2694 2693 2694
3546-- Name: ogc_fid; Type: DEFAULT; Schema: public; Owner: -
3547--
3548
3549ALTER TABLE ax_gehoelz ALTER COLUMN ogc_fid SET DEFAULT nextval('ax_gehoelz_ogc_fid_seq'::regclass);
3550
3551
3552--
3553-- TOC entry 3102 (class 2604 OID 29764)
3554-- Dependencies: 2656 2655 2656
3555-- Name: ogc_fid; Type: DEFAULT; Schema: public; Owner: -
3556--
3557
3558ALTER TABLE ax_gewaesserachse ALTER COLUMN ogc_fid SET DEFAULT nextval('ax_gewaesserachse_ogc_fid_seq'::regclass);
3559
3560
3561--
3562-- TOC entry 3267 (class 2604 OID 30712)
3563-- Dependencies: 2744 2743 2744
3564-- Name: ogc_fid; Type: DEFAULT; Schema: public; Owner: -
3565--
3566
3567ALTER TABLE ax_gewaessermerkmal ALTER COLUMN ogc_fid SET DEFAULT nextval('ax_gewaessermerkmal_ogc_fid_seq'::regclass);
3568
3569
3570--
3571-- TOC entry 3275 (class 2604 OID 30746)
3572-- Dependencies: 2748 2747 2748
3573-- Name: ogc_fid; Type: DEFAULT; Schema: public; Owner: -
3574--
3575
3576ALTER TABLE ax_gewaesserstationierungsachse ALTER COLUMN ogc_fid SET DEFAULT nextval('ax_gewaesserstationierungsachse_ogc_fid_seq'::regclass);
3577
3578
3579--
3580-- TOC entry 3324 (class 2604 OID 33733)
3581-- Dependencies: 2774 2773 2774
3582-- Name: ogc_fid; Type: DEFAULT; Schema: public; Owner: -
3583--
3584
3585ALTER TABLE ax_hafen ALTER COLUMN ogc_fid SET DEFAULT nextval('ax_hafen_ogc_fid_seq'::regclass);
3586
3587
3588--
3589-- TOC entry 3320 (class 2604 OID 33709)
3590-- Dependencies: 2771 2772 2772
3591-- Name: ogc_fid; Type: DEFAULT; Schema: public; Owner: -
3592--
3593
3594ALTER TABLE ax_hafenbecken ALTER COLUMN ogc_fid SET DEFAULT nextval('ax_hafenbecken_ogc_fid_seq'::regclass);
3595
3596
3597--
3598-- TOC entry 3336 (class 2604 OID 36948)
3599-- Dependencies: 2779 2780 2780
3600-- Name: ogc_fid; Type: DEFAULT; Schema: public; Owner: -
3601--
3602
3603ALTER TABLE ax_halde ALTER COLUMN ogc_fid SET DEFAULT nextval('ax_halde_ogc_fid_seq'::regclass);
3604
3605
3606--
3607-- TOC entry 3360 (class 2604 OID 63876)
3608-- Dependencies: 2791 2792 2792
3609-- Name: ogc_fid; Type: DEFAULT; Schema: public; Owner: -
3610--
3611
3612ALTER TABLE ax_heide ALTER COLUMN ogc_fid SET DEFAULT nextval('ax_heide_ogc_fid_seq'::regclass);
3613
3614
3615--
3616-- TOC entry 3106 (class 2604 OID 29780)
3617-- Dependencies: 2658 2657 2658
3618-- Name: ogc_fid; Type: DEFAULT; Schema: public; Owner: -
3619--
3620
3621ALTER TABLE ax_historischesbauwerkoderhistorischeeinrichtung ALTER COLUMN ogc_fid SET DEFAULT nextval('ax_historischesbauwerkoderhistorischeeinrichtung_ogc_fid_seq'::regclass);
3622
3623
3624--
3625-- TOC entry 3300 (class 2604 OID 31387)
3626-- Dependencies: 2761 2762 2762
3627-- Name: ogc_fid; Type: DEFAULT; Schema: public; Owner: -
3628--
3629
3630ALTER TABLE ax_hoehleneingang ALTER COLUMN ogc_fid SET DEFAULT nextval('ax_hoehleneingang_ogc_fid_seq'::regclass);
3631
3632
3633--
3634-- TOC entry 3178 (class 2604 OID 30188)
3635-- Dependencies: 2695 2696 2696
3636-- Name: ogc_fid; Type: DEFAULT; Schema: public; Owner: -
3637--
3638
3639ALTER TABLE ax_industrieundgewerbeflaeche ALTER COLUMN ogc_fid SET DEFAULT nextval('ax_industrieundgewerbeflaeche_ogc_fid_seq'::regclass);
3640
3641
3642--
3643-- TOC entry 3271 (class 2604 OID 30730)
3644-- Dependencies: 2746 2745 2746
3645-- Name: ogc_fid; Type: DEFAULT; Schema: public; Owner: -
3646--
3647
3648ALTER TABLE ax_insel ALTER COLUMN ogc_fid SET DEFAULT nextval('ax_insel_ogc_fid_seq'::regclass);
3649
3650
3651--
3652-- TOC entry 3364 (class 2604 OID 69845)
3653-- Dependencies: 2793 2794 2794
3654-- Name: ogc_fid; Type: DEFAULT; Schema: public; Owner: -
3655--
3656
3657ALTER TABLE ax_kanal ALTER COLUMN ogc_fid SET DEFAULT nextval('ax_kanal_ogc_fid_seq'::regclass);
3658
3659
3660--
3661-- TOC entry 3110 (class 2604 OID 29796)
3662-- Dependencies: 2660 2659 2660
3663-- Name: ogc_fid; Type: DEFAULT; Schema: public; Owner: -
3664--
3665
3666ALTER TABLE ax_kommunalesgebiet ALTER COLUMN ogc_fid SET DEFAULT nextval('ax_kommunalesgebiet_ogc_fid_seq'::regclass);
3667
3668
3669--
3670-- TOC entry 3352 (class 2604 OID 61525)
3671-- Dependencies: 2788 2787 2788
3672-- Name: ogc_fid; Type: DEFAULT; Schema: public; Owner: -
3673--
3674
3675ALTER TABLE ax_kondominium ALTER COLUMN ogc_fid SET DEFAULT nextval('ax_kondominium_ogc_fid_seq'::regclass);
3676
3677
3678--
3679-- TOC entry 3114 (class 2604 OID 29818)
3680-- Dependencies: 2662 2661 2662
3681-- Name: ogc_fid; Type: DEFAULT; Schema: public; Owner: -
3682--
3683
3684ALTER TABLE ax_landwirtschaft ALTER COLUMN ogc_fid SET DEFAULT nextval('ax_landwirtschaft_ogc_fid_seq'::regclass);
3685
3686
3687--
3688-- TOC entry 3279 (class 2604 OID 30814)
3689-- Dependencies: 2750 2749 2750
3690-- Name: ogc_fid; Type: DEFAULT; Schema: public; Owner: -
3691--
3692
3693ALTER TABLE ax_leitung ALTER COLUMN ogc_fid SET DEFAULT nextval('ax_leitung_ogc_fid_seq'::regclass);
3694
3695
3696--
3697-- TOC entry 3348 (class 2604 OID 51737)
3698-- Dependencies: 2785 2786 2786
3699-- Name: ogc_fid; Type: DEFAULT; Schema: public; Owner: -
3700--
3701
3702ALTER TABLE ax_moor ALTER COLUMN ogc_fid SET DEFAULT nextval('ax_moor_ogc_fid_seq'::regclass);
3703
3704
3705--
3706-- TOC entry 3118 (class 2604 OID 29838)
3707-- Dependencies: 2664 2663 2664
3708-- Name: ogc_fid; Type: DEFAULT; Schema: public; Owner: -
3709--
3710
3711ALTER TABLE ax_naturumweltoderbodenschutzrecht ALTER COLUMN ogc_fid SET DEFAULT nextval('ax_naturumweltoderbodenschutzrecht_ogc_fid_seq'::regclass);
3712
3713
3714--
3715-- TOC entry 3242 (class 2604 OID 30547)
3716-- Dependencies: 2730 2729 2730
3717-- Name: ogc_fid; Type: DEFAULT; Schema: public; Owner: -
3718--
3719
3720ALTER TABLE ax_netzknoten ALTER COLUMN ogc_fid SET DEFAULT nextval('ax_netzknoten_ogc_fid_seq'::regclass);
3721
3722
3723--
3724-- TOC entry 3194 (class 2604 OID 30316)
3725-- Dependencies: 2703 2704 2704
3726-- Name: ogc_fid; Type: DEFAULT; Schema: public; Owner: -
3727--
3728
3729ALTER TABLE ax_nullpunkt ALTER COLUMN ogc_fid SET DEFAULT nextval('ax_nullpunkt_ogc_fid_seq'::regclass);
3730
3731
3732--
3733-- TOC entry 3186 (class 2604 OID 30282)
3734-- Dependencies: 2699 2700 2700
3735-- Name: ogc_fid; Type: DEFAULT; Schema: public; Owner: -
3736--
3737
3738ALTER TABLE ax_ortslage ALTER COLUMN ogc_fid SET DEFAULT nextval('ax_ortslage_ogc_fid_seq'::regclass);
3739
3740
3741--
3742-- TOC entry 3182 (class 2604 OID 30266)
3743-- Dependencies: 2697 2698 2698
3744-- Name: ogc_fid; Type: DEFAULT; Schema: public; Owner: -
3745--
3746
3747ALTER TABLE ax_platz ALTER COLUMN ogc_fid SET DEFAULT nextval('ax_platz_ogc_fid_seq'::regclass);
3748
3749
3750--
3751-- TOC entry 3283 (class 2604 OID 30845)
3752-- Dependencies: 2752 2751 2752
3753-- Name: ogc_fid; Type: DEFAULT; Schema: public; Owner: -
3754--
3755
3756ALTER TABLE ax_schifffahrtsliniefaehrverkehr ALTER COLUMN ogc_fid SET DEFAULT nextval('ax_schifffahrtsliniefaehrverkehr_ogc_fid_seq'::regclass);
3757
3758
3759--
3760-- TOC entry 3328 (class 2604 OID 33865)
3761-- Dependencies: 2775 2776 2776
3762-- Name: ogc_fid; Type: DEFAULT; Schema: public; Owner: -
3763--
3764
3765ALTER TABLE ax_schiffsverkehr ALTER COLUMN ogc_fid SET DEFAULT nextval('ax_schiffsverkehr_ogc_fid_seq'::regclass);
3766
3767
3768--
3769-- TOC entry 3356 (class 2604 OID 61544)
3770-- Dependencies: 2790 2789 2790
3771-- Name: ogc_fid; Type: DEFAULT; Schema: public; Owner: -
3772--
3773
3774ALTER TABLE ax_schleuse ALTER COLUMN ogc_fid SET DEFAULT nextval('ax_schleuse_ogc_fid_seq'::regclass);
3775
3776
3777--
3778-- TOC entry 3340 (class 2604 OID 40024)
3779-- Dependencies: 2782 2781 2782
3780-- Name: ogc_fid; Type: DEFAULT; Schema: public; Owner: -
3781--
3782
3783ALTER TABLE ax_seilbahnschwebebahn ALTER COLUMN ogc_fid SET DEFAULT nextval('ax_seilbahnschwebebahn_ogc_fid_seq'::regclass);
3784
3785
3786--
3787-- TOC entry 3190 (class 2604 OID 30300)
3788-- Dependencies: 2701 2702 2702
3789-- Name: ogc_fid; Type: DEFAULT; Schema: public; Owner: -
3790--
3791
3792ALTER TABLE ax_sonstigesbauwerkodersonstigeeinrichtung ALTER COLUMN ogc_fid SET DEFAULT nextval('ax_sonstigesbauwerkodersonstigeeinrichtung_ogc_fid_seq'::regclass);
3793
3794
3795--
3796-- TOC entry 3344 (class 2604 OID 40095)
3797-- Dependencies: 2783 2784 2784
3798-- Name: ogc_fid; Type: DEFAULT; Schema: public; Owner: -
3799--
3800
3801ALTER TABLE ax_sonstigesrecht ALTER COLUMN ogc_fid SET DEFAULT nextval('ax_sonstigesrecht_ogc_fid_seq'::regclass);
3802
3803
3804--
3805-- TOC entry 3198 (class 2604 OID 30332)
3806-- Dependencies: 2706 2705 2706
3807-- Name: ogc_fid; Type: DEFAULT; Schema: public; Owner: -
3808--
3809
3810ALTER TABLE ax_sportfreizeitunderholungsflaeche ALTER COLUMN ogc_fid SET DEFAULT nextval('ax_sportfreizeitunderholungsflaeche_ogc_fid_seq'::regclass);
3811
3812
3813--
3814-- TOC entry 3202 (class 2604 OID 30348)
3815-- Dependencies: 2707 2708 2708
3816-- Name: ogc_fid; Type: DEFAULT; Schema: public; Owner: -
3817--
3818
3819ALTER TABLE ax_stehendesgewaesser ALTER COLUMN ogc_fid SET DEFAULT nextval('ax_stehendesgewaesser_ogc_fid_seq'::regclass);
3820
3821
3822--
3823-- TOC entry 3241 (class 2604 OID 30536)
3824-- Dependencies: 2727 2728 2728
3825-- Name: ogc_fid; Type: DEFAULT; Schema: public; Owner: -
3826--
3827
3828ALTER TABLE ax_strasse ALTER COLUMN ogc_fid SET DEFAULT nextval('ax_strasse_ogc_fid_seq'::regclass);
3829
3830
3831--
3832-- TOC entry 3206 (class 2604 OID 30364)
3833-- Dependencies: 2710 2709 2710
3834-- Name: ogc_fid; Type: DEFAULT; Schema: public; Owner: -
3835--
3836
3837ALTER TABLE ax_strassenachse ALTER COLUMN ogc_fid SET DEFAULT nextval('ax_strassenachse_ogc_fid_seq'::regclass);
3838
3839
3840--
3841-- TOC entry 3210 (class 2604 OID 30380)
3842-- Dependencies: 2712 2711 2712
3843-- Name: ogc_fid; Type: DEFAULT; Schema: public; Owner: -
3844--
3845
3846ALTER TABLE ax_strassenverkehr ALTER COLUMN ogc_fid SET DEFAULT nextval('ax_strassenverkehr_ogc_fid_seq'::regclass);
3847
3848
3849--
3850-- TOC entry 3226 (class 2604 OID 30444)
3851-- Dependencies: 2720 2719 2720
3852-- Name: ogc_fid; Type: DEFAULT; Schema: public; Owner: -
3853--
3854
3855ALTER TABLE ax_strassenverkehrsanlage ALTER COLUMN ogc_fid SET DEFAULT nextval('ax_strassenverkehrsanlage_ogc_fid_seq'::regclass);
3856
3857
3858--
3859-- TOC entry 3332 (class 2604 OID 34085)
3860-- Dependencies: 2777 2778 2778
3861-- Name: ogc_fid; Type: DEFAULT; Schema: public; Owner: -
3862--
3863
3864ALTER TABLE ax_sumpf ALTER COLUMN ogc_fid SET DEFAULT nextval('ax_sumpf_ogc_fid_seq'::regclass);
3865
3866
3867--
3868-- TOC entry 3287 (class 2604 OID 30890)
3869-- Dependencies: 2753 2754 2754
3870-- Name: ogc_fid; Type: DEFAULT; Schema: public; Owner: -
3871--
3872
3873ALTER TABLE ax_tagebaugrubesteinbruch ALTER COLUMN ogc_fid SET DEFAULT nextval('ax_tagebaugrubesteinbruch_ogc_fid_seq'::regclass);
3874
3875
3876--
3877-- TOC entry 3222 (class 2604 OID 30428)
3878-- Dependencies: 2717 2718 2718
3879-- Name: ogc_fid; Type: DEFAULT; Schema: public; Owner: -
3880--
3881
3882ALTER TABLE ax_transportanlage ALTER COLUMN ogc_fid SET DEFAULT nextval('ax_transportanlage_ogc_fid_seq'::regclass);
3883
3884
3885--
3886-- TOC entry 3218 (class 2604 OID 30412)
3887-- Dependencies: 2715 2716 2716
3888-- Name: ogc_fid; Type: DEFAULT; Schema: public; Owner: -
3889--
3890
3891ALTER TABLE ax_turm ALTER COLUMN ogc_fid SET DEFAULT nextval('ax_turm_ogc_fid_seq'::regclass);
3892
3893
3894--
3895-- TOC entry 3214 (class 2604 OID 30396)
3896-- Dependencies: 2713 2714 2714
3897-- Name: ogc_fid; Type: DEFAULT; Schema: public; Owner: -
3898--
3899
3900ALTER TABLE ax_unlandvegetationsloseflaeche ALTER COLUMN ogc_fid SET DEFAULT nextval('ax_unlandvegetationsloseflaeche_ogc_fid_seq'::regclass);
3901
3902
3903--
3904-- TOC entry 3230 (class 2604 OID 30460)
3905-- Dependencies: 2722 2721 2722
3906-- Name: ogc_fid; Type: DEFAULT; Schema: public; Owner: -
3907--
3908
3909ALTER TABLE ax_vegetationsmerkmal ALTER COLUMN ogc_fid SET DEFAULT nextval('ax_vegetationsmerkmal_ogc_fid_seq'::regclass);
3910
3911
3912--
3913-- TOC entry 3122 (class 2604 OID 29864)
3914-- Dependencies: 2666 2665 2666
3915-- Name: ogc_fid; Type: DEFAULT; Schema: public; Owner: -
3916--
3917
3918ALTER TABLE ax_wald ALTER COLUMN ogc_fid SET DEFAULT nextval('ax_wald_ogc_fid_seq'::regclass);
3919
3920
3921--
3922-- TOC entry 3291 (class 2604 OID 30990)
3923-- Dependencies: 2756 2755 2756
3924-- Name: ogc_fid; Type: DEFAULT; Schema: public; Owner: -
3925--
3926
3927ALTER TABLE ax_wasserlauf ALTER COLUMN ogc_fid SET DEFAULT nextval('ax_wasserlauf_ogc_fid_seq'::regclass);
3928
3929
3930--
3931-- TOC entry 3304 (class 2604 OID 32127)
3932-- Dependencies: 2764 2763 2764
3933-- Name: ogc_fid; Type: DEFAULT; Schema: public; Owner: -
3934--
3935
3936ALTER TABLE ax_wasserspiegelhoehe ALTER COLUMN ogc_fid SET DEFAULT nextval('ax_wasserspiegelhoehe_ogc_fid_seq'::regclass);
3937
3938
3939--
3940-- TOC entry 3126 (class 2604 OID 29886)
3941-- Dependencies: 2667 2668 2668
3942-- Name: ogc_fid; Type: DEFAULT; Schema: public; Owner: -
3943--
3944
3945ALTER TABLE ax_wegpfadsteig ALTER COLUMN ogc_fid SET DEFAULT nextval('ax_wegpfadsteig_ogc_fid_seq'::regclass);
3946
3947
3948--
3949-- TOC entry 3233 (class 2604 OID 30504)
3950-- Dependencies: 2724 2723 2724
3951-- Name: ogc_fid; Type: DEFAULT; Schema: public; Owner: -
3952--
3953
3954ALTER TABLE ax_wohnbauflaeche ALTER COLUMN ogc_fid SET DEFAULT nextval('ax_wohnbauflaeche_ogc_fid_seq'::regclass);
3955
3956
3957--
3958-- TOC entry 3237 (class 2604 OID 30520)
3959-- Dependencies: 2725 2726 2726
3960-- Name: ogc_fid; Type: DEFAULT; Schema: public; Owner: -
3961--
3962
3963ALTER TABLE ax_wohnplatz ALTER COLUMN ogc_fid SET DEFAULT nextval('ax_wohnplatz_ogc_fid_seq'::regclass);
3964
3965
3966--
3967-- TOC entry 3401 (class 2606 OID 29904)
3968-- Dependencies: 2670 2670
3969-- Name: alkis_beziehungen_pk; Type: CONSTRAINT; Schema: public; Owner: -
3970--
3971
3972ALTER TABLE ONLY alkis_beziehungen
3973    ADD CONSTRAINT alkis_beziehungen_pk PRIMARY KEY (ogc_fid);
3974
3975
3976--
3977-- TOC entry 3404 (class 2606 OID 29916)
3978-- Dependencies: 2672 2672
3979-- Name: ax_abschnitt_pk; Type: CONSTRAINT; Schema: public; Owner: -
3980--
3981
3982ALTER TABLE ONLY ax_abschnitt
3983    ADD CONSTRAINT ax_abschnitt_pk PRIMARY KEY (ogc_fid);
3984
3985
3986--
3987-- TOC entry 3407 (class 2606 OID 29932)
3988-- Dependencies: 2674 2674
3989-- Name: ax_ast_pk; Type: CONSTRAINT; Schema: public; Owner: -
3990--
3991
3992ALTER TABLE ONLY ax_ast
3993    ADD CONSTRAINT ax_ast_pk PRIMARY KEY (ogc_fid);
3994
3995
3996--
3997-- TOC entry 3495 (class 2606 OID 30573)
3998-- Dependencies: 2734 2734
3999-- Name: ax_bahnstrecke_pk; Type: CONSTRAINT; Schema: public; Owner: -
4000--
4001
4002ALTER TABLE ONLY ax_bahnstrecke
4003    ADD CONSTRAINT ax_bahnstrecke_pk PRIMARY KEY (ogc_fid);
4004
4005
4006--
4007-- TOC entry 3548 (class 2606 OID 33474)
4008-- Dependencies: 2770 2770
4009-- Name: ax_bahnverkehr_pk; Type: CONSTRAINT; Schema: public; Owner: -
4010--
4011
4012ALTER TABLE ONLY ax_bahnverkehr
4013    ADD CONSTRAINT ax_bahnverkehr_pk PRIMARY KEY (ogc_fid);
4014
4015
4016--
4017-- TOC entry 3492 (class 2606 OID 30557)
4018-- Dependencies: 2732 2732
4019-- Name: ax_bahnverkehrsanlage_pk; Type: CONSTRAINT; Schema: public; Owner: -
4020--
4021
4022ALTER TABLE ONLY ax_bahnverkehrsanlage
4023    ADD CONSTRAINT ax_bahnverkehrsanlage_pk PRIMARY KEY (ogc_fid);
4024
4025
4026--
4027-- TOC entry 3410 (class 2606 OID 29948)
4028-- Dependencies: 2676 2676
4029-- Name: ax_bauwerkimgewaesserbereich_pk; Type: CONSTRAINT; Schema: public; Owner: -
4030--
4031
4032ALTER TABLE ONLY ax_bauwerkimgewaesserbereich
4033    ADD CONSTRAINT ax_bauwerkimgewaesserbereich_pk PRIMARY KEY (ogc_fid);
4034
4035
4036--
4037-- TOC entry 3416 (class 2606 OID 29980)
4038-- Dependencies: 2680 2680
4039-- Name: ax_bauwerkimverkehrsbereich_pk; Type: CONSTRAINT; Schema: public; Owner: -
4040--
4041
4042ALTER TABLE ONLY ax_bauwerkimverkehrsbereich
4043    ADD CONSTRAINT ax_bauwerkimverkehrsbereich_pk PRIMARY KEY (ogc_fid);
4044
4045
4046--
4047-- TOC entry 3419 (class 2606 OID 29995)
4048-- Dependencies: 2682 2682
4049-- Name: ax_bauwerkoderanlagefuerindustrieundgewerbe_pk; Type: CONSTRAINT; Schema: public; Owner: -
4050--
4051
4052ALTER TABLE ONLY ax_bauwerkoderanlagefuerindustrieundgewerbe
4053    ADD CONSTRAINT ax_bauwerkoderanlagefuerindustrieundgewerbe_pk PRIMARY KEY (ogc_fid);
4054
4055
4056--
4057-- TOC entry 3413 (class 2606 OID 29964)
4058-- Dependencies: 2678 2678
4059-- Name: ax_bauwerkoderanlagefuersportfreizeitunderholung_pk; Type: CONSTRAINT; Schema: public; Owner: -
4060--
4061
4062ALTER TABLE ONLY ax_bauwerkoderanlagefuersportfreizeitunderholung
4063    ADD CONSTRAINT ax_bauwerkoderanlagefuersportfreizeitunderholung_pk PRIMARY KEY (ogc_fid);
4064
4065
4066--
4067-- TOC entry 3586 (class 2606 OID 133070)
4068-- Dependencies: 2796 2796
4069-- Name: ax_bergbaubetrieb_pk; Type: CONSTRAINT; Schema: public; Owner: -
4070--
4071
4072ALTER TABLE ONLY ax_bergbaubetrieb
4073    ADD CONSTRAINT ax_bergbaubetrieb_pk PRIMARY KEY (ogc_fid);
4074
4075
4076--
4077-- TOC entry 3501 (class 2606 OID 30605)
4078-- Dependencies: 2738 2738
4079-- Name: ax_dammwalldeich_pk; Type: CONSTRAINT; Schema: public; Owner: -
4080--
4081
4082ALTER TABLE ONLY ax_dammwalldeich
4083    ADD CONSTRAINT ax_dammwalldeich_pk PRIMARY KEY (ogc_fid);
4084
4085
4086--
4087-- TOC entry 3530 (class 2606 OID 31003)
4088-- Dependencies: 2758 2758
4089-- Name: ax_denkmalschutzrecht_pk; Type: CONSTRAINT; Schema: public; Owner: -
4090--
4091
4092ALTER TABLE ONLY ax_denkmalschutzrecht
4093    ADD CONSTRAINT ax_denkmalschutzrecht_pk PRIMARY KEY (ogc_fid);
4094
4095
4096--
4097-- TOC entry 3498 (class 2606 OID 30589)
4098-- Dependencies: 2736 2736
4099-- Name: ax_einrichtungenfuerdenschiffsverkehr_pk; Type: CONSTRAINT; Schema: public; Owner: -
4100--
4101
4102ALTER TABLE ONLY ax_einrichtungenfuerdenschiffsverkehr
4103    ADD CONSTRAINT ax_einrichtungenfuerdenschiffsverkehr_pk PRIMARY KEY (ogc_fid);
4104
4105
4106--
4107-- TOC entry 3422 (class 2606 OID 30011)
4108-- Dependencies: 2684 2684
4109-- Name: ax_fahrbahnachse_pk; Type: CONSTRAINT; Schema: public; Owner: -
4110--
4111
4112ALTER TABLE ONLY ax_fahrbahnachse
4113    ADD CONSTRAINT ax_fahrbahnachse_pk PRIMARY KEY (ogc_fid);
4114
4115
4116--
4117-- TOC entry 3375 (class 2606 OID 29724)
4118-- Dependencies: 2652 2652
4119-- Name: ax_fahrwegachse_pk; Type: CONSTRAINT; Schema: public; Owner: -
4120--
4121
4122ALTER TABLE ONLY ax_fahrwegachse
4123    ADD CONSTRAINT ax_fahrwegachse_pk PRIMARY KEY (ogc_fid);
4124
4125
4126--
4127-- TOC entry 3533 (class 2606 OID 31049)
4128-- Dependencies: 2760 2760
4129-- Name: ax_felsenfelsblockfelsnadel_pk; Type: CONSTRAINT; Schema: public; Owner: -
4130--
4131
4132ALTER TABLE ONLY ax_felsenfelsblockfelsnadel
4133    ADD CONSTRAINT ax_felsenfelsblockfelsnadel_pk PRIMARY KEY (ogc_fid);
4134
4135
4136--
4137-- TOC entry 3425 (class 2606 OID 30027)
4138-- Dependencies: 2686 2686
4139-- Name: ax_flaechebesondererfunktionalerpraegung_pk; Type: CONSTRAINT; Schema: public; Owner: -
4140--
4141
4142ALTER TABLE ONLY ax_flaechebesondererfunktionalerpraegung
4143    ADD CONSTRAINT ax_flaechebesondererfunktionalerpraegung_pk PRIMARY KEY (ogc_fid);
4144
4145
4146--
4147-- TOC entry 3428 (class 2606 OID 30043)
4148-- Dependencies: 2688 2688
4149-- Name: ax_flaechegemischternutzung_pk; Type: CONSTRAINT; Schema: public; Owner: -
4150--
4151
4152ALTER TABLE ONLY ax_flaechegemischternutzung
4153    ADD CONSTRAINT ax_flaechegemischternutzung_pk PRIMARY KEY (ogc_fid);
4154
4155
4156--
4157-- TOC entry 3504 (class 2606 OID 30621)
4158-- Dependencies: 2740 2740
4159-- Name: ax_flaechezurzeitunbestimmbar_pk; Type: CONSTRAINT; Schema: public; Owner: -
4160--
4161
4162ALTER TABLE ONLY ax_flaechezurzeitunbestimmbar
4163    ADD CONSTRAINT ax_flaechezurzeitunbestimmbar_pk PRIMARY KEY (ogc_fid);
4164
4165
4166--
4167-- TOC entry 3507 (class 2606 OID 30637)
4168-- Dependencies: 2742 2742
4169-- Name: ax_fliessgewaesser_pk; Type: CONSTRAINT; Schema: public; Owner: -
4170--
4171
4172ALTER TABLE ONLY ax_fliessgewaesser
4173    ADD CONSTRAINT ax_fliessgewaesser_pk PRIMARY KEY (ogc_fid);
4174
4175
4176--
4177-- TOC entry 3542 (class 2606 OID 32187)
4178-- Dependencies: 2766 2766
4179-- Name: ax_flugverkehr_pk; Type: CONSTRAINT; Schema: public; Owner: -
4180--
4181
4182ALTER TABLE ONLY ax_flugverkehr
4183    ADD CONSTRAINT ax_flugverkehr_pk PRIMARY KEY (ogc_fid);
4184
4185
4186--
4187-- TOC entry 3545 (class 2606 OID 33039)
4188-- Dependencies: 2768 2768
4189-- Name: ax_flugverkehrsanlage_pk; Type: CONSTRAINT; Schema: public; Owner: -
4190--
4191
4192ALTER TABLE ONLY ax_flugverkehrsanlage
4193    ADD CONSTRAINT ax_flugverkehrsanlage_pk PRIMARY KEY (ogc_fid);
4194
4195
4196--
4197-- TOC entry 3431 (class 2606 OID 30059)
4198-- Dependencies: 2690 2690
4199-- Name: ax_friedhof_pk; Type: CONSTRAINT; Schema: public; Owner: -
4200--
4201
4202ALTER TABLE ONLY ax_friedhof
4203    ADD CONSTRAINT ax_friedhof_pk PRIMARY KEY (ogc_fid);
4204
4205
4206--
4207-- TOC entry 3434 (class 2606 OID 30075)
4208-- Dependencies: 2692 2692
4209-- Name: ax_gebaeude_pk; Type: CONSTRAINT; Schema: public; Owner: -
4210--
4211
4212ALTER TABLE ONLY ax_gebaeude
4213    ADD CONSTRAINT ax_gebaeude_pk PRIMARY KEY (ogc_fid);
4214
4215
4216--
4217-- TOC entry 3378 (class 2606 OID 29740)
4218-- Dependencies: 2654 2654
4219-- Name: ax_gebietsgrenze_pk; Type: CONSTRAINT; Schema: public; Owner: -
4220--
4221
4222ALTER TABLE ONLY ax_gebietsgrenze
4223    ADD CONSTRAINT ax_gebietsgrenze_pk PRIMARY KEY (ogc_fid);
4224
4225
4226--
4227-- TOC entry 3437 (class 2606 OID 30133)
4228-- Dependencies: 2694 2694
4229-- Name: ax_gehoelz_pk; Type: CONSTRAINT; Schema: public; Owner: -
4230--
4231
4232ALTER TABLE ONLY ax_gehoelz
4233    ADD CONSTRAINT ax_gehoelz_pk PRIMARY KEY (ogc_fid);
4234
4235
4236--
4237-- TOC entry 3381 (class 2606 OID 29766)
4238-- Dependencies: 2656 2656
4239-- Name: ax_gewaesserachse_pk; Type: CONSTRAINT; Schema: public; Owner: -
4240--
4241
4242ALTER TABLE ONLY ax_gewaesserachse
4243    ADD CONSTRAINT ax_gewaesserachse_pk PRIMARY KEY (ogc_fid);
4244
4245
4246--
4247-- TOC entry 3510 (class 2606 OID 30714)
4248-- Dependencies: 2744 2744
4249-- Name: ax_gewaessermerkmal_pk; Type: CONSTRAINT; Schema: public; Owner: -
4250--
4251
4252ALTER TABLE ONLY ax_gewaessermerkmal
4253    ADD CONSTRAINT ax_gewaessermerkmal_pk PRIMARY KEY (ogc_fid);
4254
4255
4256--
4257-- TOC entry 3516 (class 2606 OID 30748)
4258-- Dependencies: 2748 2748
4259-- Name: ax_gewaesserstationierungsachse_pk; Type: CONSTRAINT; Schema: public; Owner: -
4260--
4261
4262ALTER TABLE ONLY ax_gewaesserstationierungsachse
4263    ADD CONSTRAINT ax_gewaesserstationierungsachse_pk PRIMARY KEY (ogc_fid);
4264
4265
4266--
4267-- TOC entry 3554 (class 2606 OID 33735)
4268-- Dependencies: 2774 2774
4269-- Name: ax_hafen_pk; Type: CONSTRAINT; Schema: public; Owner: -
4270--
4271
4272ALTER TABLE ONLY ax_hafen
4273    ADD CONSTRAINT ax_hafen_pk PRIMARY KEY (ogc_fid);
4274
4275
4276--
4277-- TOC entry 3551 (class 2606 OID 33711)
4278-- Dependencies: 2772 2772
4279-- Name: ax_hafenbecken_pk; Type: CONSTRAINT; Schema: public; Owner: -
4280--
4281
4282ALTER TABLE ONLY ax_hafenbecken
4283    ADD CONSTRAINT ax_hafenbecken_pk PRIMARY KEY (ogc_fid);
4284
4285
4286--
4287-- TOC entry 3563 (class 2606 OID 36950)
4288-- Dependencies: 2780 2780
4289-- Name: ax_halde_pk; Type: CONSTRAINT; Schema: public; Owner: -
4290--
4291
4292ALTER TABLE ONLY ax_halde
4293    ADD CONSTRAINT ax_halde_pk PRIMARY KEY (ogc_fid);
4294
4295
4296--
4297-- TOC entry 3581 (class 2606 OID 63878)
4298-- Dependencies: 2792 2792
4299-- Name: ax_heide_pk; Type: CONSTRAINT; Schema: public; Owner: -
4300--
4301
4302ALTER TABLE ONLY ax_heide
4303    ADD CONSTRAINT ax_heide_pk PRIMARY KEY (ogc_fid);
4304
4305
4306--
4307-- TOC entry 3384 (class 2606 OID 29782)
4308-- Dependencies: 2658 2658
4309-- Name: ax_historischesbauwerkoderhistorischeeinrichtung_pk; Type: CONSTRAINT; Schema: public; Owner: -
4310--
4311
4312ALTER TABLE ONLY ax_historischesbauwerkoderhistorischeeinrichtung
4313    ADD CONSTRAINT ax_historischesbauwerkoderhistorischeeinrichtung_pk PRIMARY KEY (ogc_fid);
4314
4315
4316--
4317-- TOC entry 3536 (class 2606 OID 31389)
4318-- Dependencies: 2762 2762
4319-- Name: ax_hoehleneingang_pk; Type: CONSTRAINT; Schema: public; Owner: -
4320--
4321
4322ALTER TABLE ONLY ax_hoehleneingang
4323    ADD CONSTRAINT ax_hoehleneingang_pk PRIMARY KEY (ogc_fid);
4324
4325
4326--
4327-- TOC entry 3440 (class 2606 OID 30190)
4328-- Dependencies: 2696 2696
4329-- Name: ax_industrieundgewerbeflaeche_pk; Type: CONSTRAINT; Schema: public; Owner: -
4330--
4331
4332ALTER TABLE ONLY ax_industrieundgewerbeflaeche
4333    ADD CONSTRAINT ax_industrieundgewerbeflaeche_pk PRIMARY KEY (ogc_fid);
4334
4335
4336--
4337-- TOC entry 3513 (class 2606 OID 30732)
4338-- Dependencies: 2746 2746
4339-- Name: ax_insel_pk; Type: CONSTRAINT; Schema: public; Owner: -
4340--
4341
4342ALTER TABLE ONLY ax_insel
4343    ADD CONSTRAINT ax_insel_pk PRIMARY KEY (ogc_fid);
4344
4345
4346--
4347-- TOC entry 3583 (class 2606 OID 69847)
4348-- Dependencies: 2794 2794
4349-- Name: ax_kanal_pk; Type: CONSTRAINT; Schema: public; Owner: -
4350--
4351
4352ALTER TABLE ONLY ax_kanal
4353    ADD CONSTRAINT ax_kanal_pk PRIMARY KEY (ogc_fid);
4354
4355
4356--
4357-- TOC entry 3387 (class 2606 OID 29798)
4358-- Dependencies: 2660 2660
4359-- Name: ax_kommunalesgebiet_pk; Type: CONSTRAINT; Schema: public; Owner: -
4360--
4361
4362ALTER TABLE ONLY ax_kommunalesgebiet
4363    ADD CONSTRAINT ax_kommunalesgebiet_pk PRIMARY KEY (ogc_fid);
4364
4365
4366--
4367-- TOC entry 3575 (class 2606 OID 61527)
4368-- Dependencies: 2788 2788
4369-- Name: ax_kondominium_pk; Type: CONSTRAINT; Schema: public; Owner: -
4370--
4371
4372ALTER TABLE ONLY ax_kondominium
4373    ADD CONSTRAINT ax_kondominium_pk PRIMARY KEY (ogc_fid);
4374
4375
4376--
4377-- TOC entry 3390 (class 2606 OID 29820)
4378-- Dependencies: 2662 2662
4379-- Name: ax_landwirtschaft_pk; Type: CONSTRAINT; Schema: public; Owner: -
4380--
4381
4382ALTER TABLE ONLY ax_landwirtschaft
4383    ADD CONSTRAINT ax_landwirtschaft_pk PRIMARY KEY (ogc_fid);
4384
4385
4386--
4387-- TOC entry 3519 (class 2606 OID 30816)
4388-- Dependencies: 2750 2750
4389-- Name: ax_leitung_pk; Type: CONSTRAINT; Schema: public; Owner: -
4390--
4391
4392ALTER TABLE ONLY ax_leitung
4393    ADD CONSTRAINT ax_leitung_pk PRIMARY KEY (ogc_fid);
4394
4395
4396--
4397-- TOC entry 3572 (class 2606 OID 51739)
4398-- Dependencies: 2786 2786
4399-- Name: ax_moor_pk; Type: CONSTRAINT; Schema: public; Owner: -
4400--
4401
4402ALTER TABLE ONLY ax_moor
4403    ADD CONSTRAINT ax_moor_pk PRIMARY KEY (ogc_fid);
4404
4405
4406--
4407-- TOC entry 3393 (class 2606 OID 29840)
4408-- Dependencies: 2664 2664
4409-- Name: ax_naturumweltoderbodenschutzrecht_pk; Type: CONSTRAINT; Schema: public; Owner: -
4410--
4411
4412ALTER TABLE ONLY ax_naturumweltoderbodenschutzrecht
4413    ADD CONSTRAINT ax_naturumweltoderbodenschutzrecht_pk PRIMARY KEY (ogc_fid);
4414
4415
4416--
4417-- TOC entry 3489 (class 2606 OID 30549)
4418-- Dependencies: 2730 2730
4419-- Name: ax_netzknoten_pk; Type: CONSTRAINT; Schema: public; Owner: -
4420--
4421
4422ALTER TABLE ONLY ax_netzknoten
4423    ADD CONSTRAINT ax_netzknoten_pk PRIMARY KEY (ogc_fid);
4424
4425
4426--
4427-- TOC entry 3452 (class 2606 OID 30318)
4428-- Dependencies: 2704 2704
4429-- Name: ax_nullpunkt_pk; Type: CONSTRAINT; Schema: public; Owner: -
4430--
4431
4432ALTER TABLE ONLY ax_nullpunkt
4433    ADD CONSTRAINT ax_nullpunkt_pk PRIMARY KEY (ogc_fid);
4434
4435
4436--
4437-- TOC entry 3446 (class 2606 OID 30284)
4438-- Dependencies: 2700 2700
4439-- Name: ax_ortslage_pk; Type: CONSTRAINT; Schema: public; Owner: -
4440--
4441
4442ALTER TABLE ONLY ax_ortslage
4443    ADD CONSTRAINT ax_ortslage_pk PRIMARY KEY (ogc_fid);
4444
4445
4446--
4447-- TOC entry 3443 (class 2606 OID 30268)
4448-- Dependencies: 2698 2698
4449-- Name: ax_platz_pk; Type: CONSTRAINT; Schema: public; Owner: -
4450--
4451
4452ALTER TABLE ONLY ax_platz
4453    ADD CONSTRAINT ax_platz_pk PRIMARY KEY (ogc_fid);
4454
4455
4456--
4457-- TOC entry 3522 (class 2606 OID 30847)
4458-- Dependencies: 2752 2752
4459-- Name: ax_schifffahrtsliniefaehrverkehr_pk; Type: CONSTRAINT; Schema: public; Owner: -
4460--
4461
4462ALTER TABLE ONLY ax_schifffahrtsliniefaehrverkehr
4463    ADD CONSTRAINT ax_schifffahrtsliniefaehrverkehr_pk PRIMARY KEY (ogc_fid);
4464
4465
4466--
4467-- TOC entry 3557 (class 2606 OID 33867)
4468-- Dependencies: 2776 2776
4469-- Name: ax_schiffsverkehr_pk; Type: CONSTRAINT; Schema: public; Owner: -
4470--
4471
4472ALTER TABLE ONLY ax_schiffsverkehr
4473    ADD CONSTRAINT ax_schiffsverkehr_pk PRIMARY KEY (ogc_fid);
4474
4475
4476--
4477-- TOC entry 3578 (class 2606 OID 61546)
4478-- Dependencies: 2790 2790
4479-- Name: ax_schleuse_pk; Type: CONSTRAINT; Schema: public; Owner: -
4480--
4481
4482ALTER TABLE ONLY ax_schleuse
4483    ADD CONSTRAINT ax_schleuse_pk PRIMARY KEY (ogc_fid);
4484
4485
4486--
4487-- TOC entry 3566 (class 2606 OID 40026)
4488-- Dependencies: 2782 2782
4489-- Name: ax_seilbahnschwebebahn_pk; Type: CONSTRAINT; Schema: public; Owner: -
4490--
4491
4492ALTER TABLE ONLY ax_seilbahnschwebebahn
4493    ADD CONSTRAINT ax_seilbahnschwebebahn_pk PRIMARY KEY (ogc_fid);
4494
4495
4496--
4497-- TOC entry 3449 (class 2606 OID 30302)
4498-- Dependencies: 2702 2702
4499-- Name: ax_sonstigesbauwerkodersonstigeeinrichtung_pk; Type: CONSTRAINT; Schema: public; Owner: -
4500--
4501
4502ALTER TABLE ONLY ax_sonstigesbauwerkodersonstigeeinrichtung
4503    ADD CONSTRAINT ax_sonstigesbauwerkodersonstigeeinrichtung_pk PRIMARY KEY (ogc_fid);
4504
4505
4506--
4507-- TOC entry 3569 (class 2606 OID 40097)
4508-- Dependencies: 2784 2784
4509-- Name: ax_sonstigesrecht_pk; Type: CONSTRAINT; Schema: public; Owner: -
4510--
4511
4512ALTER TABLE ONLY ax_sonstigesrecht
4513    ADD CONSTRAINT ax_sonstigesrecht_pk PRIMARY KEY (ogc_fid);
4514
4515
4516--
4517-- TOC entry 3455 (class 2606 OID 30334)
4518-- Dependencies: 2706 2706
4519-- Name: ax_sportfreizeitunderholungsflaeche_pk; Type: CONSTRAINT; Schema: public; Owner: -
4520--
4521
4522ALTER TABLE ONLY ax_sportfreizeitunderholungsflaeche
4523    ADD CONSTRAINT ax_sportfreizeitunderholungsflaeche_pk PRIMARY KEY (ogc_fid);
4524
4525
4526--
4527-- TOC entry 3458 (class 2606 OID 30350)
4528-- Dependencies: 2708 2708
4529-- Name: ax_stehendesgewaesser_pk; Type: CONSTRAINT; Schema: public; Owner: -
4530--
4531
4532ALTER TABLE ONLY ax_stehendesgewaesser
4533    ADD CONSTRAINT ax_stehendesgewaesser_pk PRIMARY KEY (ogc_fid);
4534
4535
4536--
4537-- TOC entry 3487 (class 2606 OID 30538)
4538-- Dependencies: 2728 2728
4539-- Name: ax_strasse_pk; Type: CONSTRAINT; Schema: public; Owner: -
4540--
4541
4542ALTER TABLE ONLY ax_strasse
4543    ADD CONSTRAINT ax_strasse_pk PRIMARY KEY (ogc_fid);
4544
4545
4546--
4547-- TOC entry 3461 (class 2606 OID 30366)
4548-- Dependencies: 2710 2710
4549-- Name: ax_strassenachse_pk; Type: CONSTRAINT; Schema: public; Owner: -
4550--
4551
4552ALTER TABLE ONLY ax_strassenachse
4553    ADD CONSTRAINT ax_strassenachse_pk PRIMARY KEY (ogc_fid);
4554
4555
4556--
4557-- TOC entry 3464 (class 2606 OID 30382)
4558-- Dependencies: 2712 2712
4559-- Name: ax_strassenverkehr_pk; Type: CONSTRAINT; Schema: public; Owner: -
4560--
4561
4562ALTER TABLE ONLY ax_strassenverkehr
4563    ADD CONSTRAINT ax_strassenverkehr_pk PRIMARY KEY (ogc_fid);
4564
4565
4566--
4567-- TOC entry 3476 (class 2606 OID 30446)
4568-- Dependencies: 2720 2720
4569-- Name: ax_strassenverkehrsanlage_pk; Type: CONSTRAINT; Schema: public; Owner: -
4570--
4571
4572ALTER TABLE ONLY ax_strassenverkehrsanlage
4573    ADD CONSTRAINT ax_strassenverkehrsanlage_pk PRIMARY KEY (ogc_fid);
4574
4575
4576--
4577-- TOC entry 3560 (class 2606 OID 34087)
4578-- Dependencies: 2778 2778
4579-- Name: ax_sumpf_pk; Type: CONSTRAINT; Schema: public; Owner: -
4580--
4581
4582ALTER TABLE ONLY ax_sumpf
4583    ADD CONSTRAINT ax_sumpf_pk PRIMARY KEY (ogc_fid);
4584
4585
4586--
4587-- TOC entry 3525 (class 2606 OID 30892)
4588-- Dependencies: 2754 2754
4589-- Name: ax_tagebaugrubesteinbruch_pk; Type: CONSTRAINT; Schema: public; Owner: -
4590--
4591
4592ALTER TABLE ONLY ax_tagebaugrubesteinbruch
4593    ADD CONSTRAINT ax_tagebaugrubesteinbruch_pk PRIMARY KEY (ogc_fid);
4594
4595
4596--
4597-- TOC entry 3473 (class 2606 OID 30430)
4598-- Dependencies: 2718 2718
4599-- Name: ax_transportanlage_pk; Type: CONSTRAINT; Schema: public; Owner: -
4600--
4601
4602ALTER TABLE ONLY ax_transportanlage
4603    ADD CONSTRAINT ax_transportanlage_pk PRIMARY KEY (ogc_fid);
4604
4605
4606--
4607-- TOC entry 3470 (class 2606 OID 30414)
4608-- Dependencies: 2716 2716
4609-- Name: ax_turm_pk; Type: CONSTRAINT; Schema: public; Owner: -
4610--
4611
4612ALTER TABLE ONLY ax_turm
4613    ADD CONSTRAINT ax_turm_pk PRIMARY KEY (ogc_fid);
4614
4615
4616--
4617-- TOC entry 3467 (class 2606 OID 30398)
4618-- Dependencies: 2714 2714
4619-- Name: ax_unlandvegetationsloseflaeche_pk; Type: CONSTRAINT; Schema: public; Owner: -
4620--
4621
4622ALTER TABLE ONLY ax_unlandvegetationsloseflaeche
4623    ADD CONSTRAINT ax_unlandvegetationsloseflaeche_pk PRIMARY KEY (ogc_fid);
4624
4625
4626--
4627-- TOC entry 3479 (class 2606 OID 30462)
4628-- Dependencies: 2722 2722
4629-- Name: ax_vegetationsmerkmal_pk; Type: CONSTRAINT; Schema: public; Owner: -
4630--
4631
4632ALTER TABLE ONLY ax_vegetationsmerkmal
4633    ADD CONSTRAINT ax_vegetationsmerkmal_pk PRIMARY KEY (ogc_fid);
4634
4635
4636--
4637-- TOC entry 3396 (class 2606 OID 29866)
4638-- Dependencies: 2666 2666
4639-- Name: ax_wald_pk; Type: CONSTRAINT; Schema: public; Owner: -
4640--
4641
4642ALTER TABLE ONLY ax_wald
4643    ADD CONSTRAINT ax_wald_pk PRIMARY KEY (ogc_fid);
4644
4645
4646--
4647-- TOC entry 3527 (class 2606 OID 30992)
4648-- Dependencies: 2756 2756
4649-- Name: ax_wasserlauf_pk; Type: CONSTRAINT; Schema: public; Owner: -
4650--
4651
4652ALTER TABLE ONLY ax_wasserlauf
4653    ADD CONSTRAINT ax_wasserlauf_pk PRIMARY KEY (ogc_fid);
4654
4655
4656--
4657-- TOC entry 3539 (class 2606 OID 32129)
4658-- Dependencies: 2764 2764
4659-- Name: ax_wasserspiegelhoehe_pk; Type: CONSTRAINT; Schema: public; Owner: -
4660--
4661
4662ALTER TABLE ONLY ax_wasserspiegelhoehe
4663    ADD CONSTRAINT ax_wasserspiegelhoehe_pk PRIMARY KEY (ogc_fid);
4664
4665
4666--
4667-- TOC entry 3399 (class 2606 OID 29888)
4668-- Dependencies: 2668 2668
4669-- Name: ax_wegpfadsteig_pk; Type: CONSTRAINT; Schema: public; Owner: -
4670--
4671
4672ALTER TABLE ONLY ax_wegpfadsteig
4673    ADD CONSTRAINT ax_wegpfadsteig_pk PRIMARY KEY (ogc_fid);
4674
4675
4676--
4677-- TOC entry 3482 (class 2606 OID 30506)
4678-- Dependencies: 2724 2724
4679-- Name: ax_wohnbauflaeche_pk; Type: CONSTRAINT; Schema: public; Owner: -
4680--
4681
4682ALTER TABLE ONLY ax_wohnbauflaeche
4683    ADD CONSTRAINT ax_wohnbauflaeche_pk PRIMARY KEY (ogc_fid);
4684
4685
4686--
4687-- TOC entry 3485 (class 2606 OID 30522)
4688-- Dependencies: 2726 2726
4689-- Name: ax_wohnplatz_pk; Type: CONSTRAINT; Schema: public; Owner: -
4690--
4691
4692ALTER TABLE ONLY ax_wohnplatz
4693    ADD CONSTRAINT ax_wohnplatz_pk PRIMARY KEY (ogc_fid);
4694
4695
4696--
4697-- TOC entry 3402 (class 1259 OID 29924)
4698-- Dependencies: 2672 2269
4699-- Name: ax_abschnitt_geom_idx; Type: INDEX; Schema: public; Owner: -
4700--
4701
4702CREATE INDEX ax_abschnitt_geom_idx ON ax_abschnitt USING gist (wkb_geometry);
4703
4704
4705--
4706-- TOC entry 3405 (class 1259 OID 29940)
4707-- Dependencies: 2674 2269
4708-- Name: ax_ast_geom_idx; Type: INDEX; Schema: public; Owner: -
4709--
4710
4711CREATE INDEX ax_ast_geom_idx ON ax_ast USING gist (wkb_geometry);
4712
4713
4714--
4715-- TOC entry 3493 (class 1259 OID 30581)
4716-- Dependencies: 2269 2734
4717-- Name: ax_bahnstrecke_geom_idx; Type: INDEX; Schema: public; Owner: -
4718--
4719
4720CREATE INDEX ax_bahnstrecke_geom_idx ON ax_bahnstrecke USING gist (wkb_geometry);
4721
4722
4723--
4724-- TOC entry 3546 (class 1259 OID 33482)
4725-- Dependencies: 2770 2269
4726-- Name: ax_bahnverkehr_geom_idx; Type: INDEX; Schema: public; Owner: -
4727--
4728
4729CREATE INDEX ax_bahnverkehr_geom_idx ON ax_bahnverkehr USING gist (wkb_geometry);
4730
4731
4732--
4733-- TOC entry 3490 (class 1259 OID 30565)
4734-- Dependencies: 2269 2732
4735-- Name: ax_bahnverkehrsanlage_geom_idx; Type: INDEX; Schema: public; Owner: -
4736--
4737
4738CREATE INDEX ax_bahnverkehrsanlage_geom_idx ON ax_bahnverkehrsanlage USING gist (wkb_geometry);
4739
4740
4741--
4742-- TOC entry 3408 (class 1259 OID 29956)
4743-- Dependencies: 2676 2269
4744-- Name: ax_bauwerkimgewaesserbereich_geom_idx; Type: INDEX; Schema: public; Owner: -
4745--
4746
4747CREATE INDEX ax_bauwerkimgewaesserbereich_geom_idx ON ax_bauwerkimgewaesserbereich USING gist (wkb_geometry);
4748
4749
4750--
4751-- TOC entry 3414 (class 1259 OID 29987)
4752-- Dependencies: 2680 2269
4753-- Name: ax_bauwerkimverkehrsbereich_geom_idx; Type: INDEX; Schema: public; Owner: -
4754--
4755
4756CREATE INDEX ax_bauwerkimverkehrsbereich_geom_idx ON ax_bauwerkimverkehrsbereich USING gist (wkb_geometry);
4757
4758
4759--
4760-- TOC entry 3417 (class 1259 OID 30003)
4761-- Dependencies: 2269 2682
4762-- Name: ax_bauwerkoderanlagefuerindustrieundgewerbe_geom_idx; Type: INDEX; Schema: public; Owner: -
4763--
4764
4765CREATE INDEX ax_bauwerkoderanlagefuerindustrieundgewerbe_geom_idx ON ax_bauwerkoderanlagefuerindustrieundgewerbe USING gist (wkb_geometry);
4766
4767
4768--
4769-- TOC entry 3411 (class 1259 OID 29972)
4770-- Dependencies: 2269 2678
4771-- Name: ax_bauwerkoderanlagefuersportfreizeitunderholung_geom_idx; Type: INDEX; Schema: public; Owner: -
4772--
4773
4774CREATE INDEX ax_bauwerkoderanlagefuersportfreizeitunderholung_geom_idx ON ax_bauwerkoderanlagefuersportfreizeitunderholung USING gist (wkb_geometry);
4775
4776
4777--
4778-- TOC entry 3584 (class 1259 OID 133078)
4779-- Dependencies: 2796 2269
4780-- Name: ax_bergbaubetrieb_geom_idx; Type: INDEX; Schema: public; Owner: -
4781--
4782
4783CREATE INDEX ax_bergbaubetrieb_geom_idx ON ax_bergbaubetrieb USING gist (wkb_geometry);
4784
4785
4786--
4787-- TOC entry 3499 (class 1259 OID 30613)
4788-- Dependencies: 2269 2738
4789-- Name: ax_dammwalldeich_geom_idx; Type: INDEX; Schema: public; Owner: -
4790--
4791
4792CREATE INDEX ax_dammwalldeich_geom_idx ON ax_dammwalldeich USING gist (wkb_geometry);
4793
4794
4795--
4796-- TOC entry 3528 (class 1259 OID 31012)
4797-- Dependencies: 2269 2758
4798-- Name: ax_denkmalschutzrecht_geom_idx; Type: INDEX; Schema: public; Owner: -
4799--
4800
4801CREATE INDEX ax_denkmalschutzrecht_geom_idx ON ax_denkmalschutzrecht USING gist (wkb_geometry);
4802
4803
4804--
4805-- TOC entry 3496 (class 1259 OID 30597)
4806-- Dependencies: 2269 2736
4807-- Name: ax_einrichtungenfuerdenschiffsverkehr_geom_idx; Type: INDEX; Schema: public; Owner: -
4808--
4809
4810CREATE INDEX ax_einrichtungenfuerdenschiffsverkehr_geom_idx ON ax_einrichtungenfuerdenschiffsverkehr USING gist (wkb_geometry);
4811
4812
4813--
4814-- TOC entry 3420 (class 1259 OID 30019)
4815-- Dependencies: 2684 2269
4816-- Name: ax_fahrbahnachse_geom_idx; Type: INDEX; Schema: public; Owner: -
4817--
4818
4819CREATE INDEX ax_fahrbahnachse_geom_idx ON ax_fahrbahnachse USING gist (wkb_geometry);
4820
4821
4822--
4823-- TOC entry 3373 (class 1259 OID 29732)
4824-- Dependencies: 2269 2652
4825-- Name: ax_fahrwegachse_geom_idx; Type: INDEX; Schema: public; Owner: -
4826--
4827
4828CREATE INDEX ax_fahrwegachse_geom_idx ON ax_fahrwegachse USING gist (wkb_geometry);
4829
4830
4831--
4832-- TOC entry 3531 (class 1259 OID 31057)
4833-- Dependencies: 2760 2269
4834-- Name: ax_felsenfelsblockfelsnadel_geom_idx; Type: INDEX; Schema: public; Owner: -
4835--
4836
4837CREATE INDEX ax_felsenfelsblockfelsnadel_geom_idx ON ax_felsenfelsblockfelsnadel USING gist (wkb_geometry);
4838
4839
4840--
4841-- TOC entry 3423 (class 1259 OID 30035)
4842-- Dependencies: 2269 2686
4843-- Name: ax_flaechebesondererfunktionalerpraegung_geom_idx; Type: INDEX; Schema: public; Owner: -
4844--
4845
4846CREATE INDEX ax_flaechebesondererfunktionalerpraegung_geom_idx ON ax_flaechebesondererfunktionalerpraegung USING gist (wkb_geometry);
4847
4848
4849--
4850-- TOC entry 3426 (class 1259 OID 30051)
4851-- Dependencies: 2269 2688
4852-- Name: ax_flaechegemischternutzung_geom_idx; Type: INDEX; Schema: public; Owner: -
4853--
4854
4855CREATE INDEX ax_flaechegemischternutzung_geom_idx ON ax_flaechegemischternutzung USING gist (wkb_geometry);
4856
4857
4858--
4859-- TOC entry 3502 (class 1259 OID 30629)
4860-- Dependencies: 2740 2269
4861-- Name: ax_flaechezurzeitunbestimmbar_geom_idx; Type: INDEX; Schema: public; Owner: -
4862--
4863
4864CREATE INDEX ax_flaechezurzeitunbestimmbar_geom_idx ON ax_flaechezurzeitunbestimmbar USING gist (wkb_geometry);
4865
4866
4867--
4868-- TOC entry 3505 (class 1259 OID 30645)
4869-- Dependencies: 2269 2742
4870-- Name: ax_fliessgewaesser_geom_idx; Type: INDEX; Schema: public; Owner: -
4871--
4872
4873CREATE INDEX ax_fliessgewaesser_geom_idx ON ax_fliessgewaesser USING gist (wkb_geometry);
4874
4875
4876--
4877-- TOC entry 3540 (class 1259 OID 32195)
4878-- Dependencies: 2766 2269
4879-- Name: ax_flugverkehr_geom_idx; Type: INDEX; Schema: public; Owner: -
4880--
4881
4882CREATE INDEX ax_flugverkehr_geom_idx ON ax_flugverkehr USING gist (wkb_geometry);
4883
4884
4885--
4886-- TOC entry 3543 (class 1259 OID 33047)
4887-- Dependencies: 2269 2768
4888-- Name: ax_flugverkehrsanlage_geom_idx; Type: INDEX; Schema: public; Owner: -
4889--
4890
4891CREATE INDEX ax_flugverkehrsanlage_geom_idx ON ax_flugverkehrsanlage USING gist (wkb_geometry);
4892
4893
4894--
4895-- TOC entry 3429 (class 1259 OID 30067)
4896-- Dependencies: 2269 2690
4897-- Name: ax_friedhof_geom_idx; Type: INDEX; Schema: public; Owner: -
4898--
4899
4900CREATE INDEX ax_friedhof_geom_idx ON ax_friedhof USING gist (wkb_geometry);
4901
4902
4903--
4904-- TOC entry 3432 (class 1259 OID 30083)
4905-- Dependencies: 2269 2692
4906-- Name: ax_gebaeude_geom_idx; Type: INDEX; Schema: public; Owner: -
4907--
4908
4909CREATE INDEX ax_gebaeude_geom_idx ON ax_gebaeude USING gist (wkb_geometry);
4910
4911
4912--
4913-- TOC entry 3376 (class 1259 OID 29748)
4914-- Dependencies: 2654 2269
4915-- Name: ax_gebietsgrenze_geom_idx; Type: INDEX; Schema: public; Owner: -
4916--
4917
4918CREATE INDEX ax_gebietsgrenze_geom_idx ON ax_gebietsgrenze USING gist (wkb_geometry);
4919
4920
4921--
4922-- TOC entry 3435 (class 1259 OID 30141)
4923-- Dependencies: 2269 2694
4924-- Name: ax_gehoelz_geom_idx; Type: INDEX; Schema: public; Owner: -
4925--
4926
4927CREATE INDEX ax_gehoelz_geom_idx ON ax_gehoelz USING gist (wkb_geometry);
4928
4929
4930--
4931-- TOC entry 3379 (class 1259 OID 29774)
4932-- Dependencies: 2656 2269
4933-- Name: ax_gewaesserachse_geom_idx; Type: INDEX; Schema: public; Owner: -
4934--
4935
4936CREATE INDEX ax_gewaesserachse_geom_idx ON ax_gewaesserachse USING gist (wkb_geometry);
4937
4938
4939--
4940-- TOC entry 3508 (class 1259 OID 30722)
4941-- Dependencies: 2269 2744
4942-- Name: ax_gewaessermerkmal_geom_idx; Type: INDEX; Schema: public; Owner: -
4943--
4944
4945CREATE INDEX ax_gewaessermerkmal_geom_idx ON ax_gewaessermerkmal USING gist (wkb_geometry);
4946
4947
4948--
4949-- TOC entry 3514 (class 1259 OID 30756)
4950-- Dependencies: 2748 2269
4951-- Name: ax_gewaesserstationierungsachse_geom_idx; Type: INDEX; Schema: public; Owner: -
4952--
4953
4954CREATE INDEX ax_gewaesserstationierungsachse_geom_idx ON ax_gewaesserstationierungsachse USING gist (wkb_geometry);
4955
4956
4957--
4958-- TOC entry 3552 (class 1259 OID 33743)
4959-- Dependencies: 2269 2774
4960-- Name: ax_hafen_geom_idx; Type: INDEX; Schema: public; Owner: -
4961--
4962
4963CREATE INDEX ax_hafen_geom_idx ON ax_hafen USING gist (wkb_geometry);
4964
4965
4966--
4967-- TOC entry 3549 (class 1259 OID 33719)
4968-- Dependencies: 2269 2772
4969-- Name: ax_hafenbecken_geom_idx; Type: INDEX; Schema: public; Owner: -
4970--
4971
4972CREATE INDEX ax_hafenbecken_geom_idx ON ax_hafenbecken USING gist (wkb_geometry);
4973
4974
4975--
4976-- TOC entry 3561 (class 1259 OID 36958)
4977-- Dependencies: 2780 2269
4978-- Name: ax_halde_geom_idx; Type: INDEX; Schema: public; Owner: -
4979--
4980
4981CREATE INDEX ax_halde_geom_idx ON ax_halde USING gist (wkb_geometry);
4982
4983
4984--
4985-- TOC entry 3579 (class 1259 OID 63886)
4986-- Dependencies: 2792 2269
4987-- Name: ax_heide_geom_idx; Type: INDEX; Schema: public; Owner: -
4988--
4989
4990CREATE INDEX ax_heide_geom_idx ON ax_heide USING gist (wkb_geometry);
4991
4992
4993--
4994-- TOC entry 3382 (class 1259 OID 29790)
4995-- Dependencies: 2269 2658
4996-- Name: ax_historischesbauwerkoderhistorischeeinrichtung_geom_idx; Type: INDEX; Schema: public; Owner: -
4997--
4998
4999CREATE INDEX ax_historischesbauwerkoderhistorischeeinrichtung_geom_idx ON ax_historischesbauwerkoderhistorischeeinrichtung USING gist (wkb_geometry);
5000
5001
5002--
5003-- TOC entry 3534 (class 1259 OID 31397)
5004-- Dependencies: 2762 2269
5005-- Name: ax_hoehleneingang_geom_idx; Type: INDEX; Schema: public; Owner: -
5006--
5007
5008CREATE INDEX ax_hoehleneingang_geom_idx ON ax_hoehleneingang USING gist (wkb_geometry);
5009
5010
5011--
5012-- TOC entry 3438 (class 1259 OID 30198)
5013-- Dependencies: 2696 2269
5014-- Name: ax_industrieundgewerbeflaeche_geom_idx; Type: INDEX; Schema: public; Owner: -
5015--
5016
5017CREATE INDEX ax_industrieundgewerbeflaeche_geom_idx ON ax_industrieundgewerbeflaeche USING gist (wkb_geometry);
5018
5019
5020--
5021-- TOC entry 3511 (class 1259 OID 30740)
5022-- Dependencies: 2746 2269
5023-- Name: ax_insel_geom_idx; Type: INDEX; Schema: public; Owner: -
5024--
5025
5026CREATE INDEX ax_insel_geom_idx ON ax_insel USING gist (wkb_geometry);
5027
5028
5029--
5030-- TOC entry 3385 (class 1259 OID 29806)
5031-- Dependencies: 2269 2660
5032-- Name: ax_kommunalesgebiet_geom_idx; Type: INDEX; Schema: public; Owner: -
5033--
5034
5035CREATE INDEX ax_kommunalesgebiet_geom_idx ON ax_kommunalesgebiet USING gist (wkb_geometry);
5036
5037
5038--
5039-- TOC entry 3573 (class 1259 OID 61535)
5040-- Dependencies: 2269 2788
5041-- Name: ax_kondominium_geom_idx; Type: INDEX; Schema: public; Owner: -
5042--
5043
5044CREATE INDEX ax_kondominium_geom_idx ON ax_kondominium USING gist (wkb_geometry);
5045
5046
5047--
5048-- TOC entry 3388 (class 1259 OID 29828)
5049-- Dependencies: 2662 2269
5050-- Name: ax_landwirtschaft_geom_idx; Type: INDEX; Schema: public; Owner: -
5051--
5052
5053CREATE INDEX ax_landwirtschaft_geom_idx ON ax_landwirtschaft USING gist (wkb_geometry);
5054
5055
5056--
5057-- TOC entry 3517 (class 1259 OID 30824)
5058-- Dependencies: 2269 2750
5059-- Name: ax_leitung_geom_idx; Type: INDEX; Schema: public; Owner: -
5060--
5061
5062CREATE INDEX ax_leitung_geom_idx ON ax_leitung USING gist (wkb_geometry);
5063
5064
5065--
5066-- TOC entry 3570 (class 1259 OID 51747)
5067-- Dependencies: 2786 2269
5068-- Name: ax_moor_geom_idx; Type: INDEX; Schema: public; Owner: -
5069--
5070
5071CREATE INDEX ax_moor_geom_idx ON ax_moor USING gist (wkb_geometry);
5072
5073
5074--
5075-- TOC entry 3391 (class 1259 OID 29848)
5076-- Dependencies: 2269 2664
5077-- Name: ax_naturumweltoderbodenschutzrecht_geom_idx; Type: INDEX; Schema: public; Owner: -
5078--
5079
5080CREATE INDEX ax_naturumweltoderbodenschutzrecht_geom_idx ON ax_naturumweltoderbodenschutzrecht USING gist (wkb_geometry);
5081
5082
5083--
5084-- TOC entry 3450 (class 1259 OID 30326)
5085-- Dependencies: 2269 2704
5086-- Name: ax_nullpunkt_geom_idx; Type: INDEX; Schema: public; Owner: -
5087--
5088
5089CREATE INDEX ax_nullpunkt_geom_idx ON ax_nullpunkt USING gist (wkb_geometry);
5090
5091
5092--
5093-- TOC entry 3444 (class 1259 OID 30292)
5094-- Dependencies: 2700 2269
5095-- Name: ax_ortslage_geom_idx; Type: INDEX; Schema: public; Owner: -
5096--
5097
5098CREATE INDEX ax_ortslage_geom_idx ON ax_ortslage USING gist (wkb_geometry);
5099
5100
5101--
5102-- TOC entry 3441 (class 1259 OID 30276)
5103-- Dependencies: 2698 2269
5104-- Name: ax_platz_geom_idx; Type: INDEX; Schema: public; Owner: -
5105--
5106
5107CREATE INDEX ax_platz_geom_idx ON ax_platz USING gist (wkb_geometry);
5108
5109
5110--
5111-- TOC entry 3520 (class 1259 OID 30855)
5112-- Dependencies: 2752 2269
5113-- Name: ax_schifffahrtsliniefaehrverkehr_geom_idx; Type: INDEX; Schema: public; Owner: -
5114--
5115
5116CREATE INDEX ax_schifffahrtsliniefaehrverkehr_geom_idx ON ax_schifffahrtsliniefaehrverkehr USING gist (wkb_geometry);
5117
5118
5119--
5120-- TOC entry 3555 (class 1259 OID 33875)
5121-- Dependencies: 2269 2776
5122-- Name: ax_schiffsverkehr_geom_idx; Type: INDEX; Schema: public; Owner: -
5123--
5124
5125CREATE INDEX ax_schiffsverkehr_geom_idx ON ax_schiffsverkehr USING gist (wkb_geometry);
5126
5127
5128--
5129-- TOC entry 3576 (class 1259 OID 61554)
5130-- Dependencies: 2790 2269
5131-- Name: ax_schleuse_geom_idx; Type: INDEX; Schema: public; Owner: -
5132--
5133
5134CREATE INDEX ax_schleuse_geom_idx ON ax_schleuse USING gist (wkb_geometry);
5135
5136
5137--
5138-- TOC entry 3564 (class 1259 OID 40034)
5139-- Dependencies: 2269 2782
5140-- Name: ax_seilbahnschwebebahn_geom_idx; Type: INDEX; Schema: public; Owner: -
5141--
5142
5143CREATE INDEX ax_seilbahnschwebebahn_geom_idx ON ax_seilbahnschwebebahn USING gist (wkb_geometry);
5144
5145
5146--
5147-- TOC entry 3447 (class 1259 OID 30310)
5148-- Dependencies: 2269 2702
5149-- Name: ax_sonstigesbauwerkodersonstigeeinrichtung_geom_idx; Type: INDEX; Schema: public; Owner: -
5150--
5151
5152CREATE INDEX ax_sonstigesbauwerkodersonstigeeinrichtung_geom_idx ON ax_sonstigesbauwerkodersonstigeeinrichtung USING gist (wkb_geometry);
5153
5154
5155--
5156-- TOC entry 3567 (class 1259 OID 40105)
5157-- Dependencies: 2784 2269
5158-- Name: ax_sonstigesrecht_geom_idx; Type: INDEX; Schema: public; Owner: -
5159--
5160
5161CREATE INDEX ax_sonstigesrecht_geom_idx ON ax_sonstigesrecht USING gist (wkb_geometry);
5162
5163
5164--
5165-- TOC entry 3453 (class 1259 OID 30342)
5166-- Dependencies: 2706 2269
5167-- Name: ax_sportfreizeitunderholungsflaeche_geom_idx; Type: INDEX; Schema: public; Owner: -
5168--
5169
5170CREATE INDEX ax_sportfreizeitunderholungsflaeche_geom_idx ON ax_sportfreizeitunderholungsflaeche USING gist (wkb_geometry);
5171
5172
5173--
5174-- TOC entry 3456 (class 1259 OID 30358)
5175-- Dependencies: 2708 2269
5176-- Name: ax_stehendesgewaesser_geom_idx; Type: INDEX; Schema: public; Owner: -
5177--
5178
5179CREATE INDEX ax_stehendesgewaesser_geom_idx ON ax_stehendesgewaesser USING gist (wkb_geometry);
5180
5181
5182--
5183-- TOC entry 3459 (class 1259 OID 30374)
5184-- Dependencies: 2269 2710
5185-- Name: ax_strassenachse_geom_idx; Type: INDEX; Schema: public; Owner: -
5186--
5187
5188CREATE INDEX ax_strassenachse_geom_idx ON ax_strassenachse USING gist (wkb_geometry);
5189
5190
5191--
5192-- TOC entry 3462 (class 1259 OID 30390)
5193-- Dependencies: 2269 2712
5194-- Name: ax_strassenverkehr_geom_idx; Type: INDEX; Schema: public; Owner: -
5195--
5196
5197CREATE INDEX ax_strassenverkehr_geom_idx ON ax_strassenverkehr USING gist (wkb_geometry);
5198
5199
5200--
5201-- TOC entry 3474 (class 1259 OID 30454)
5202-- Dependencies: 2269 2720
5203-- Name: ax_strassenverkehrsanlage_geom_idx; Type: INDEX; Schema: public; Owner: -
5204--
5205
5206CREATE INDEX ax_strassenverkehrsanlage_geom_idx ON ax_strassenverkehrsanlage USING gist (wkb_geometry);
5207
5208
5209--
5210-- TOC entry 3558 (class 1259 OID 34095)
5211-- Dependencies: 2778 2269
5212-- Name: ax_sumpf_geom_idx; Type: INDEX; Schema: public; Owner: -
5213--
5214
5215CREATE INDEX ax_sumpf_geom_idx ON ax_sumpf USING gist (wkb_geometry);
5216
5217
5218--
5219-- TOC entry 3523 (class 1259 OID 30900)
5220-- Dependencies: 2269 2754
5221-- Name: ax_tagebaugrubesteinbruch_geom_idx; Type: INDEX; Schema: public; Owner: -
5222--
5223
5224CREATE INDEX ax_tagebaugrubesteinbruch_geom_idx ON ax_tagebaugrubesteinbruch USING gist (wkb_geometry);
5225
5226
5227--
5228-- TOC entry 3471 (class 1259 OID 30438)
5229-- Dependencies: 2269 2718
5230-- Name: ax_transportanlage_geom_idx; Type: INDEX; Schema: public; Owner: -
5231--
5232
5233CREATE INDEX ax_transportanlage_geom_idx ON ax_transportanlage USING gist (wkb_geometry);
5234
5235
5236--
5237-- TOC entry 3468 (class 1259 OID 30422)
5238-- Dependencies: 2269 2716
5239-- Name: ax_turm_geom_idx; Type: INDEX; Schema: public; Owner: -
5240--
5241
5242CREATE INDEX ax_turm_geom_idx ON ax_turm USING gist (wkb_geometry);
5243
5244
5245--
5246-- TOC entry 3465 (class 1259 OID 30406)
5247-- Dependencies: 2269 2714
5248-- Name: ax_unlandvegetationsloseflaeche_geom_idx; Type: INDEX; Schema: public; Owner: -
5249--
5250
5251CREATE INDEX ax_unlandvegetationsloseflaeche_geom_idx ON ax_unlandvegetationsloseflaeche USING gist (wkb_geometry);
5252
5253
5254--
5255-- TOC entry 3477 (class 1259 OID 30469)
5256-- Dependencies: 2722 2269
5257-- Name: ax_vegetationsmerkmal_geom_idx; Type: INDEX; Schema: public; Owner: -
5258--
5259
5260CREATE INDEX ax_vegetationsmerkmal_geom_idx ON ax_vegetationsmerkmal USING gist (wkb_geometry);
5261
5262
5263--
5264-- TOC entry 3394 (class 1259 OID 29874)
5265-- Dependencies: 2666 2269
5266-- Name: ax_wald_geom_idx; Type: INDEX; Schema: public; Owner: -
5267--
5268
5269CREATE INDEX ax_wald_geom_idx ON ax_wald USING gist (wkb_geometry);
5270
5271
5272--
5273-- TOC entry 3537 (class 1259 OID 32137)
5274-- Dependencies: 2764 2269
5275-- Name: ax_wasserspiegelhoehe_geom_idx; Type: INDEX; Schema: public; Owner: -
5276--
5277
5278CREATE INDEX ax_wasserspiegelhoehe_geom_idx ON ax_wasserspiegelhoehe USING gist (wkb_geometry);
5279
5280
5281--
5282-- TOC entry 3397 (class 1259 OID 29896)
5283-- Dependencies: 2668 2269
5284-- Name: ax_wegpfadsteig_geom_idx; Type: INDEX; Schema: public; Owner: -
5285--
5286
5287CREATE INDEX ax_wegpfadsteig_geom_idx ON ax_wegpfadsteig USING gist (wkb_geometry);
5288
5289
5290--
5291-- TOC entry 3480 (class 1259 OID 30514)
5292-- Dependencies: 2724 2269
5293-- Name: ax_wohnbauflaeche_geom_idx; Type: INDEX; Schema: public; Owner: -
5294--
5295
5296CREATE INDEX ax_wohnbauflaeche_geom_idx ON ax_wohnbauflaeche USING gist (wkb_geometry);
5297
5298
5299--
5300-- TOC entry 3483 (class 1259 OID 30530)
5301-- Dependencies: 2726 2269
5302-- Name: ax_wohnplatz_geom_idx; Type: INDEX; Schema: public; Owner: -
5303--
5304
5305CREATE INDEX ax_wohnplatz_geom_idx ON ax_wohnplatz USING gist (wkb_geometry);
5306
5307
5308-- Completed on 2011-07-07 07:43:06 CEST
5309
5310--
5311-- PostgreSQL database dump complete
5312--
5313
5314
5315--create content of table geometry_columns
5316--
5317-- TOC entry 3087 (class 0 OID 16749)
5318-- Dependencies: 2640
5319-- Data for Name: geometry_columns; Type: TABLE DATA; Schema: public; Owner: postgres
5320--
5321
5322INSERT INTO geometry_columns VALUES ('', 'public', 'ax_fahrwegachse', 'wkb_geometry', 2, 25832, 'LINESTRING');
5323INSERT INTO geometry_columns VALUES ('', 'public', 'ax_gebietsgrenze', 'wkb_geometry', 2, 25832, 'LINESTRING');
5324INSERT INTO geometry_columns VALUES ('', 'public', 'ax_gewaesserachse', 'wkb_geometry', 2, 25832, 'LINESTRING');
5325INSERT INTO geometry_columns VALUES ('', 'public', 'ax_historischesbauwerkoderhistorischeeinrichtung', 'wkb_geometry', 2, 25832, 'GEOMETRY');--LINESTRING
5326INSERT INTO geometry_columns VALUES ('', 'public', 'ax_kommunalesgebiet', 'wkb_geometry', 2, 25832, 'GEOMETRY');--POLYGON
5327INSERT INTO geometry_columns VALUES ('', 'public', 'ax_landwirtschaft', 'wkb_geometry', 2, 25832, 'POLYGON');
5328INSERT INTO geometry_columns VALUES ('', 'public', 'ax_naturumweltoderbodenschutzrecht', 'wkb_geometry', 2, 25832, 'GEOMETRY');--POLYGON
5329INSERT INTO geometry_columns VALUES ('', 'public', 'ax_wald', 'wkb_geometry', 2, 25832, 'POLYGON');
5330INSERT INTO geometry_columns VALUES ('', 'public', 'ax_wegpfadsteig', 'wkb_geometry', 2, 25832, 'LINESTRING');
5331INSERT INTO geometry_columns VALUES ('', 'public', 'ax_abschnitt', 'wkb_geometry', 2, 25832, 'LINESTRING');
5332INSERT INTO geometry_columns VALUES ('', 'public', 'ax_ast', 'wkb_geometry', 2, 25832, 'LINESTRING');
5333INSERT INTO geometry_columns VALUES ('', 'public', 'ax_bauwerkimgewaesserbereich', 'wkb_geometry', 2, 25832, 'GEOMETRY');--LINESTRING
5334INSERT INTO geometry_columns VALUES ('', 'public', 'ax_bauwerkoderanlagefuersportfreizeitunderholung', 'wkb_geometry', 2, 25832, 'GEOMETRY');--POLYGON
5335INSERT INTO geometry_columns VALUES ('', 'public', 'ax_bauwerkimverkehrsbereich', 'wkb_geometry', 2, 25832, 'GEOMETRY');
5336INSERT INTO geometry_columns VALUES ('', 'public', 'ax_bauwerkoderanlagefuerindustrieundgewerbe', 'wkb_geometry', 2, 25832, 'GEOMETRY');--POINT
5337INSERT INTO geometry_columns VALUES ('', 'public', 'ax_fahrbahnachse', 'wkb_geometry', 2, 25832, 'LINESTRING');
5338INSERT INTO geometry_columns VALUES ('', 'public', 'ax_flaechebesondererfunktionalerpraegung', 'wkb_geometry', 2, 25832, 'POLYGON');
5339INSERT INTO geometry_columns VALUES ('', 'public', 'ax_flaechegemischternutzung', 'wkb_geometry', 2, 25832, 'POLYGON');
5340INSERT INTO geometry_columns VALUES ('', 'public', 'ax_friedhof', 'wkb_geometry', 2, 25832, 'POLYGON');
5341INSERT INTO geometry_columns VALUES ('', 'public', 'ax_gebaeude', 'wkb_geometry', 2, 25832, 'GEOMETRY');--POINT
5342INSERT INTO geometry_columns VALUES ('', 'public', 'ax_gehoelz', 'wkb_geometry', 2, 25832, 'POLYGON');
5343INSERT INTO geometry_columns VALUES ('', 'public', 'ax_industrieundgewerbeflaeche', 'wkb_geometry', 2, 25832, 'POLYGON');
5344INSERT INTO geometry_columns VALUES ('', 'public', 'ax_platz', 'wkb_geometry', 2, 25832, 'POLYGON');
5345INSERT INTO geometry_columns VALUES ('', 'public', 'ax_ortslage', 'wkb_geometry', 2, 25832, 'POLYGON');
5346INSERT INTO geometry_columns VALUES ('', 'public', 'ax_sonstigesbauwerkodersonstigeeinrichtung', 'wkb_geometry', 2, 25832, 'GEOMETRY');--POINT
5347INSERT INTO geometry_columns VALUES ('', 'public', 'ax_nullpunkt', 'wkb_geometry', 2, 25832, 'POINT');
5348INSERT INTO geometry_columns VALUES ('', 'public', 'ax_sportfreizeitunderholungsflaeche', 'wkb_geometry', 2, 25832, 'POLYGON');
5349INSERT INTO geometry_columns VALUES ('', 'public', 'ax_stehendesgewaesser', 'wkb_geometry', 2, 25832, 'POLYGON');
5350INSERT INTO geometry_columns VALUES ('', 'public', 'ax_strassenachse', 'wkb_geometry', 2, 25832, 'LINESTRING');
5351INSERT INTO geometry_columns VALUES ('', 'public', 'ax_strassenverkehr', 'wkb_geometry', 2, 25832, 'GEOMETRY');--POLYGON
5352INSERT INTO geometry_columns VALUES ('', 'public', 'ax_unlandvegetationsloseflaeche', 'wkb_geometry', 2, 25832, 'POLYGON');
5353INSERT INTO geometry_columns VALUES ('', 'public', 'ax_turm', 'wkb_geometry', 2, 25832, 'GEOMETRY');--POINT
5354INSERT INTO geometry_columns VALUES ('', 'public', 'ax_transportanlage', 'wkb_geometry', 2, 25832, 'GEOMETRY');--POINT
5355INSERT INTO geometry_columns VALUES ('', 'public', 'ax_strassenverkehrsanlage', 'wkb_geometry', 2, 25832, 'GEOMETRY');--POINT
5356INSERT INTO geometry_columns VALUES ('', 'public', 'ax_vegetationsmerkmal', 'wkb_geometry', 2, 25832, 'GEOMETRY');
5357INSERT INTO geometry_columns VALUES ('', 'public', 'ax_wohnbauflaeche', 'wkb_geometry', 2, 25832, 'POLYGON');
5358INSERT INTO geometry_columns VALUES ('', 'public', 'ax_wohnplatz', 'wkb_geometry', 2, 25832, 'POINT');
5359INSERT INTO geometry_columns VALUES ('', 'public', 'ax_bahnverkehrsanlage', 'wkb_geometry', 2, 25832, 'GEOMETRY');--POINT
5360INSERT INTO geometry_columns VALUES ('', 'public', 'ax_bahnstrecke', 'wkb_geometry', 2, 25832, 'LINESTRING');
5361INSERT INTO geometry_columns VALUES ('', 'public', 'ax_einrichtungenfuerdenschiffsverkehr', 'wkb_geometry', 2, 25832, 'POINT');
5362INSERT INTO geometry_columns VALUES ('', 'public', 'ax_dammwalldeich', 'wkb_geometry', 2, 25832, 'GEOMETRY');--LINESTRING
5363INSERT INTO geometry_columns VALUES ('', 'public', 'ax_flaechezurzeitunbestimmbar', 'wkb_geometry', 2, 25832, 'POLYGON');
5364INSERT INTO geometry_columns VALUES ('', 'public', 'ax_fliessgewaesser', 'wkb_geometry', 2, 25832, 'POLYGON');
5365INSERT INTO geometry_columns VALUES ('', 'public', 'ax_gewaessermerkmal', 'wkb_geometry', 2, 25832, 'GEOMETRY');--POINT
5366INSERT INTO geometry_columns VALUES ('', 'public', 'ax_insel', 'wkb_geometry', 2, 25832, 'POLYGON');
5367INSERT INTO geometry_columns VALUES ('', 'public', 'ax_gewaesserstationierungsachse', 'wkb_geometry', 2, 25832, 'LINESTRING');
5368INSERT INTO geometry_columns VALUES ('', 'public', 'ax_leitung', 'wkb_geometry', 2, 25832, 'LINESTRING');
5369INSERT INTO geometry_columns VALUES ('', 'public', 'ax_schifffahrtsliniefaehrverkehr', 'wkb_geometry', 2, 25832, 'LINESTRING');
5370INSERT INTO geometry_columns VALUES ('', 'public', 'ax_tagebaugrubesteinbruch', 'wkb_geometry', 2, 25832, 'POLYGON');
5371INSERT INTO geometry_columns VALUES ('', 'public', 'ax_denkmalschutzrecht', 'wkb_geometry', 2, 25832, 'GEOMETRY');--LINESTRING
5372INSERT INTO geometry_columns VALUES ('', 'public', 'ax_felsenfelsblockfelsnadel', 'wkb_geometry', 2, 25832, 'GEOMETRY');--LINESTRING
5373INSERT INTO geometry_columns VALUES ('', 'public', 'ax_hoehleneingang', 'wkb_geometry', 2, 25832, 'POINT');
5374INSERT INTO geometry_columns VALUES ('', 'public', 'ax_wasserspiegelhoehe', 'wkb_geometry', 2, 25832, 'POINT');
5375INSERT INTO geometry_columns VALUES ('', 'public', 'ax_flugverkehr', 'wkb_geometry', 2, 25832, 'POLYGON');
5376INSERT INTO geometry_columns VALUES ('', 'public', 'ax_flugverkehrsanlage', 'wkb_geometry', 2, 25832, 'GEOMETRY');--POINT
5377INSERT INTO geometry_columns VALUES ('', 'public', 'ax_bahnverkehr', 'wkb_geometry', 2, 25832, 'POLYGON');
5378INSERT INTO geometry_columns VALUES ('', 'public', 'ax_hafenbecken', 'wkb_geometry', 2, 25832, 'POLYGON');
5379INSERT INTO geometry_columns VALUES ('', 'public', 'ax_hafen', 'wkb_geometry', 2, 25832, 'POLYGON');
5380INSERT INTO geometry_columns VALUES ('', 'public', 'ax_schiffsverkehr', 'wkb_geometry', 2, 25832, 'POLYGON');
5381INSERT INTO geometry_columns VALUES ('', 'public', 'ax_sumpf', 'wkb_geometry', 2, 25832, 'POLYGON');
5382INSERT INTO geometry_columns VALUES ('', 'public', 'ax_halde', 'wkb_geometry', 2, 25832, 'POLYGON');
5383INSERT INTO geometry_columns VALUES ('', 'public', 'ax_seilbahnschwebebahn', 'wkb_geometry', 2, 25832, 'LINESTRING');
5384INSERT INTO geometry_columns VALUES ('', 'public', 'ax_sonstigesrecht', 'wkb_geometry', 2, 25832, 'POLYGON');
5385INSERT INTO geometry_columns VALUES ('', 'public', 'ax_moor', 'wkb_geometry', 2, 25832, 'POLYGON');
5386INSERT INTO geometry_columns VALUES ('', 'public', 'ax_kondominium', 'wkb_geometry', 2, 25832, 'POLYGON');
5387INSERT INTO geometry_columns VALUES ('', 'public', 'ax_schleuse', 'wkb_geometry', 2, 25832, 'POLYGON');
5388INSERT INTO geometry_columns VALUES ('', 'public', 'ax_heide', 'wkb_geometry', 2, 25832, 'POLYGON');
5389INSERT INTO geometry_columns VALUES ('', 'public', 'ax_bergbaubetrieb', 'wkb_geometry', 2, 25832, 'POLYGON');
5390
5391
5392-- Completed on 2011-07-07 07:54:54 CEST
5393
5394--
5395-- PostgreSQL database dump complete
5396--
5397
5398
5399--create indexes for identifier
5400CREATE INDEX ax_abschnitt_idx ON ax_abschnitt(gml_id);
5401CREATE INDEX ax_ast_idx ON ax_ast(gml_id);
5402CREATE INDEX ax_bahnstrecke_idx ON ax_bahnstrecke(gml_id);
5403CREATE INDEX ax_bahnverkehr_idx ON ax_bahnverkehr(gml_id);
5404CREATE INDEX ax_bahnverkehrsanlage_idx ON ax_bahnverkehrsanlage(gml_id);
5405CREATE INDEX ax_bauwerkimgewaesserbereich_idx ON ax_bauwerkimgewaesserbereich(gml_id);
5406CREATE INDEX ax_bauwerkimverkehrsbereich_idx ON ax_bauwerkimverkehrsbereich(gml_id);
5407CREATE INDEX ax_bauwerkoderanlagefuerindustrieundgewerbe_idx ON ax_bauwerkoderanlagefuerindustrieundgewerbe(gml_id);
5408CREATE INDEX ax_bauwerkoderanlagefuersportfreizeitunderholung_idx ON ax_bauwerkoderanlagefuersportfreizeitunderholung(gml_id);
5409CREATE INDEX ax_bergbaubetrieb_idx ON ax_bergbaubetrieb(gml_id);
5410CREATE INDEX ax_dammwalldeich_idx ON ax_dammwalldeich(gml_id);
5411CREATE INDEX ax_denkmalschutzrecht_idx ON ax_denkmalschutzrecht(gml_id);
5412CREATE INDEX ax_einrichtungenfuerdenschiffsverkehr_idx ON ax_einrichtungenfuerdenschiffsverkehr(gml_id);
5413CREATE INDEX ax_fahrbahnachse_idx ON ax_fahrbahnachse(gml_id);
5414CREATE INDEX ax_fahrwegachse_idx ON ax_fahrwegachse(gml_id);
5415CREATE INDEX ax_felsenfelsblockfelsnadel_idx ON ax_felsenfelsblockfelsnadel(gml_id);
5416CREATE INDEX ax_flaechebesondererfunktionalerpraegung_idx ON ax_flaechebesondererfunktionalerpraegung(gml_id);
5417CREATE INDEX ax_flaechegemischternutzung_idx ON ax_flaechegemischternutzung(gml_id);
5418CREATE INDEX ax_flaechezurzeitunbestimmbar_idx ON ax_flaechezurzeitunbestimmbar(gml_id);
5419CREATE INDEX ax_fliessgewaesser_idx ON ax_fliessgewaesser(gml_id);
5420CREATE INDEX ax_flugverkehr_idx ON ax_flugverkehr(gml_id);
5421CREATE INDEX ax_flugverkehrsanlage_idx ON ax_flugverkehrsanlage(gml_id);
5422CREATE INDEX ax_friedhof_idx ON ax_friedhof(gml_id);
5423CREATE INDEX ax_gebaeude_idx ON ax_gebaeude(gml_id);
5424CREATE INDEX ax_gebietsgrenze_idx ON ax_gebietsgrenze(gml_id);
5425CREATE INDEX ax_gehoelz_idx ON ax_gehoelz(gml_id);
5426CREATE INDEX ax_gewaesserachse_idx ON ax_gewaesserachse(gml_id);
5427CREATE INDEX ax_gewaessermerkmal_idx ON ax_gewaessermerkmal(gml_id);
5428CREATE INDEX ax_gewaesserstationierungsachse_idx ON ax_gewaesserstationierungsachse(gml_id);
5429CREATE INDEX ax_hafen_idx ON ax_hafen(gml_id);
5430CREATE INDEX ax_hafenbecken_idx ON ax_hafenbecken(gml_id);
5431CREATE INDEX ax_halde_idx ON ax_halde(gml_id);
5432CREATE INDEX ax_heide_idx ON ax_heide(gml_id);
5433CREATE INDEX ax_historischesbauwerkoderhistorischeeinrichtung_idx ON ax_historischesbauwerkoderhistorischeeinrichtung(gml_id);
5434CREATE INDEX ax_hoehleneingang_idx ON ax_hoehleneingang(gml_id);
5435CREATE INDEX ax_industrieundgewerbeflaeche_idx ON ax_industrieundgewerbeflaeche(gml_id);
5436CREATE INDEX ax_insel_idx ON ax_insel(gml_id);
5437CREATE INDEX ax_kanal_idx ON ax_kanal(gml_id);
5438CREATE INDEX ax_kommunalesgebiet_idx ON ax_kommunalesgebiet(gml_id);
5439CREATE INDEX ax_kondominium_idx ON ax_kondominium(gml_id);
5440CREATE INDEX ax_landwirtschaft_idx ON ax_landwirtschaft(gml_id);
5441CREATE INDEX ax_leitung_idx ON ax_leitung(gml_id);
5442CREATE INDEX ax_moor_idx ON ax_moor(gml_id);
5443CREATE INDEX ax_naturumweltoderbodenschutzrecht_idx ON ax_naturumweltoderbodenschutzrecht(gml_id);
5444CREATE INDEX ax_netzknoten_idx ON ax_netzknoten(gml_id);
5445CREATE INDEX ax_nullpunkt_idx ON ax_nullpunkt(gml_id);
5446CREATE INDEX ax_ortslage_idx ON ax_ortslage(gml_id);
5447CREATE INDEX ax_platz_idx ON ax_platz(gml_id);
5448CREATE INDEX ax_schifffahrtsliniefaehrverkehr_idx ON ax_schifffahrtsliniefaehrverkehr(gml_id);
5449CREATE INDEX ax_schiffsverkehr_idx ON ax_schiffsverkehr(gml_id);
5450CREATE INDEX ax_schleuse_idx ON ax_schleuse(gml_id);
5451CREATE INDEX ax_seilbahnschwebebahn_idx ON ax_seilbahnschwebebahn(gml_id);
5452CREATE INDEX ax_sonstigesbauwerkodersonstigeeinrichtung_idx ON ax_sonstigesbauwerkodersonstigeeinrichtung(gml_id);
5453CREATE INDEX ax_sonstigesrecht_idx ON ax_sonstigesrecht(gml_id);
5454CREATE INDEX ax_sportfreizeitunderholungsflaeche_idx ON ax_sportfreizeitunderholungsflaeche(gml_id);
5455CREATE INDEX ax_stehendesgewaesser_idx ON ax_stehendesgewaesser(gml_id);
5456CREATE INDEX ax_strasse_idx ON ax_strasse(gml_id);
5457CREATE INDEX ax_strassenachse_idx ON ax_strassenachse(gml_id);
5458CREATE INDEX ax_strassenverkehr_idx ON ax_strassenverkehr(gml_id);
5459CREATE INDEX ax_strassenverkehrsanlage_idx ON ax_strassenverkehrsanlage(gml_id);
5460CREATE INDEX ax_sumpf_idx ON ax_sumpf(gml_id);
5461CREATE INDEX ax_tagebaugrubesteinbruch_idx ON ax_tagebaugrubesteinbruch(gml_id);
5462CREATE INDEX ax_transportanlage_idx ON ax_transportanlage(gml_id);
5463CREATE INDEX ax_turm_idx ON ax_turm(gml_id);
5464CREATE INDEX ax_unlandvegetationsloseflaeche_idx ON ax_unlandvegetationsloseflaeche(gml_id);
5465CREATE INDEX ax_vegetationsmerkmal_idx ON ax_vegetationsmerkmal(gml_id);
5466CREATE INDEX ax_wald_idx ON ax_wald(gml_id);
5467CREATE INDEX ax_wasserlauf_idx ON ax_wasserlauf(gml_id);
5468CREATE INDEX ax_wasserspiegelhoehe_idx ON ax_wasserspiegelhoehe(gml_id);
5469CREATE INDEX ax_wegpfadsteig_idx ON ax_wegpfadsteig(gml_id);
5470CREATE INDEX ax_wohnbauflaeche_idx ON ax_wohnbauflaeche(gml_id);
5471CREATE INDEX ax_wohnplatz_idx ON ax_wohnplatz(gml_id);
5472
5473CREATE INDEX alkis_beziehungen_von_idx ON alkis_beziehungen (beziehung_von);
5474
5475CREATE INDEX alkis_beziehungen_zu_idx ON alkis_beziehungen (beziehung_zu);
5476
5477
Note: See TracBrowser for help on using the repository browser.