source: trunk/data/konvert/postnas_0.5/alkis_PostNAS_schema_ooo.sql @ 163

Revision 94, 83.9 KB checked in by astrid.emde, 11 years ago (diff)

SQL Vorlagen zum mergen

Line 
1SET search_path = public, pg_catalog;
2
3SET default_tablespace = '';
4
5SET default_with_oids = true;
6
7--
8-- TOC entry 2446 (class 1259 OID 5511154)
9-- Dependencies: 3
10-- Name: alkis_beziehungen; Type: TABLE; Schema: public; Owner: -; Tablespace:
11--
12
13CREATE TABLE alkis_beziehungen (
14    ogc_fid integer NOT NULL,
15    beziehung_von character varying,
16    beziehungsart character varying,
17    beziehung_zu character varying
18);
19
20
21--
22-- TOC entry 2445 (class 1259 OID 5511152)
23-- Dependencies: 2446 3
24-- Name: alkis_beziehungen_ogc_fid_seq; Type: SEQUENCE; Schema: public; Owner: -
25--
26
27CREATE SEQUENCE alkis_beziehungen_ogc_fid_seq
28    INCREMENT BY 1
29    NO MAXVALUE
30    NO MINVALUE
31    CACHE 1;
32
33
34--
35-- TOC entry 2999 (class 0 OID 0)
36-- Dependencies: 2445
37-- Name: alkis_beziehungen_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
38--
39
40ALTER SEQUENCE alkis_beziehungen_ogc_fid_seq OWNED BY alkis_beziehungen.ogc_fid;
41
42
43--
44-- TOC entry 2380 (class 1259 OID 5504868)
45-- Dependencies: 2759 2760 2761 961 3
46-- Name: ap_lpo; Type: TABLE; Schema: public; Owner: -; Tablespace:
47--
48
49CREATE TABLE ap_lpo (
50    ogc_fid integer NOT NULL,
51    wkb_geometry geometry,
52    gml_id character(16),
53    beginnt character(20),
54    advstandardmodell character(8),
55    anlass integer,
56    signaturnummer integer,
57    dientzurdarstellungvon character varying,
58    CONSTRAINT enforce_dims_wkb_geometry CHECK ((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 ((srid(wkb_geometry) = 25832))
61);
62
63
64--
65-- TOC entry 2379 (class 1259 OID 5504866)
66-- Dependencies: 2380 3
67-- Name: ap_lpo_ogc_fid_seq; Type: SEQUENCE; Schema: public; Owner: -
68--
69
70CREATE SEQUENCE ap_lpo_ogc_fid_seq
71    INCREMENT BY 1
72    NO MAXVALUE
73    NO MINVALUE
74    CACHE 1;
75
76
77--
78-- TOC entry 3000 (class 0 OID 0)
79-- Dependencies: 2379
80-- Name: ap_lpo_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
81--
82
83ALTER SEQUENCE ap_lpo_ogc_fid_seq OWNED BY ap_lpo.ogc_fid;
84
85
86--
87-- TOC entry 2382 (class 1259 OID 5505030)
88-- Dependencies: 2763 2764 2765 3 961
89-- Name: ap_ppo; Type: TABLE; Schema: public; Owner: -; Tablespace:
90--
91
92CREATE TABLE ap_ppo (
93    ogc_fid integer NOT NULL,
94    wkb_geometry geometry,
95    gml_id character(16),
96    beginnt character(20),
97    advstandardmodell character(8),
98    anlass integer,
99    signaturnummer integer,
100    dientzurdarstellungvon character varying,
101    drehwinkel double precision,
102    CONSTRAINT enforce_dims_wkb_geometry CHECK ((ndims(wkb_geometry) = 2)),
103    CONSTRAINT enforce_geotype_wkb_geometry CHECK (((geometrytype(wkb_geometry) = 'POINT'::text) OR (wkb_geometry IS NULL))),
104    CONSTRAINT enforce_srid_wkb_geometry CHECK ((srid(wkb_geometry) = 25832))
105);
106
107
108--
109-- TOC entry 2381 (class 1259 OID 5505028)
110-- Dependencies: 3 2382
111-- Name: ap_ppo_ogc_fid_seq; Type: SEQUENCE; Schema: public; Owner: -
112--
113
114CREATE SEQUENCE ap_ppo_ogc_fid_seq
115    INCREMENT BY 1
116    NO MAXVALUE
117    NO MINVALUE
118    CACHE 1;
119
120
121--
122-- TOC entry 3001 (class 0 OID 0)
123-- Dependencies: 2381
124-- Name: ap_ppo_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
125--
126
127ALTER SEQUENCE ap_ppo_ogc_fid_seq OWNED BY ap_ppo.ogc_fid;
128
129
130--
131-- TOC entry 2378 (class 1259 OID 5504177)
132-- Dependencies: 2755 2756 2757 3 961
133-- Name: ap_pto; Type: TABLE; Schema: public; Owner: -; Tablespace:
134--
135
136CREATE TABLE ap_pto (
137    ogc_fid integer NOT NULL,
138    wkb_geometry geometry,
139    gml_id character(16),
140    beginnt character(20),
141    advstandardmodell character(8),
142    anlass integer,
143    signaturnummer integer,
144    dientzurdarstellungvon character varying,
145    schriftinhalt character(25),
146    fontsperrung double precision,
147    skalierung double precision,
148    horizontaleausrichtung character(13),
149    vertikaleausrichtung character(5),
150    hat character varying,
151    drehwinkel double precision,
152    CONSTRAINT enforce_dims_wkb_geometry CHECK ((ndims(wkb_geometry) = 2)),
153    CONSTRAINT enforce_geotype_wkb_geometry CHECK (((geometrytype(wkb_geometry) = 'POINT'::text) OR (wkb_geometry IS NULL))),
154    CONSTRAINT enforce_srid_wkb_geometry CHECK ((srid(wkb_geometry) = 25832))
155);
156
157
158--
159-- TOC entry 2377 (class 1259 OID 5504175)
160-- Dependencies: 2378 3
161-- Name: ap_pto_ogc_fid_seq; Type: SEQUENCE; Schema: public; Owner: -
162--
163
164CREATE SEQUENCE ap_pto_ogc_fid_seq
165    INCREMENT BY 1
166    NO MAXVALUE
167    NO MINVALUE
168    CACHE 1;
169
170
171--
172-- TOC entry 3002 (class 0 OID 0)
173-- Dependencies: 2377
174-- Name: ap_pto_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
175--
176
177ALTER SEQUENCE ap_pto_ogc_fid_seq OWNED BY ap_pto.ogc_fid;
178
179
180--
181-- TOC entry 2432 (class 1259 OID 5510360)
182-- Dependencies: 3
183-- Name: ax_aufnahmepunkt; Type: TABLE; Schema: public; Owner: -; Tablespace:
184--
185
186CREATE TABLE ax_aufnahmepunkt (
187    ogc_fid integer NOT NULL,
188    gml_id character(16),
189    beginnt character(20),
190    advstandardmodell character(4),
191    anlass integer,
192    punktkennung character(15),
193    sonstigeeigenschaft character varying[],
194    vermarkung_marke integer,
195    hat character varying
196);
197
198
199--
200-- TOC entry 2431 (class 1259 OID 5510358)
201-- Dependencies: 3 2432
202-- Name: ax_aufnahmepunkt_ogc_fid_seq; Type: SEQUENCE; Schema: public; Owner: -
203--
204
205CREATE SEQUENCE ax_aufnahmepunkt_ogc_fid_seq
206    INCREMENT BY 1
207    NO MAXVALUE
208    NO MINVALUE
209    CACHE 1;
210
211
212--
213-- TOC entry 3003 (class 0 OID 0)
214-- Dependencies: 2431
215-- Name: ax_aufnahmepunkt_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
216--
217
218ALTER SEQUENCE ax_aufnahmepunkt_ogc_fid_seq OWNED BY ax_aufnahmepunkt.ogc_fid;
219
220
221--
222-- TOC entry 2386 (class 1259 OID 5505350)
223-- Dependencies: 2771 2772 2773 3 961
224-- Name: ax_bahnverkehr; Type: TABLE; Schema: public; Owner: -; Tablespace:
225--
226
227CREATE TABLE ax_bahnverkehr (
228    ogc_fid integer NOT NULL,
229    wkb_geometry geometry,
230    gml_id character(16),
231    beginnt character(20),
232    advstandardmodell character(4),
233    anlass integer,
234    land integer,
235    regierungsbezirk integer,
236    kreis integer,
237    gemeinde integer,
238    lage character(5),
239    CONSTRAINT enforce_dims_wkb_geometry CHECK ((ndims(wkb_geometry) = 2)),
240    CONSTRAINT enforce_geotype_wkb_geometry CHECK (((geometrytype(wkb_geometry) = 'POLYGON'::text) OR (wkb_geometry IS NULL))),
241    CONSTRAINT enforce_srid_wkb_geometry CHECK ((srid(wkb_geometry) = 25832))
242);
243
244
245--
246-- TOC entry 2385 (class 1259 OID 5505348)
247-- Dependencies: 3 2386
248-- Name: ax_bahnverkehr_ogc_fid_seq; Type: SEQUENCE; Schema: public; Owner: -
249--
250
251CREATE SEQUENCE ax_bahnverkehr_ogc_fid_seq
252    INCREMENT BY 1
253    NO MAXVALUE
254    NO MINVALUE
255    CACHE 1;
256
257
258--
259-- TOC entry 3004 (class 0 OID 0)
260-- Dependencies: 2385
261-- Name: ax_bahnverkehr_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
262--
263
264ALTER SEQUENCE ax_bahnverkehr_ogc_fid_seq OWNED BY ax_bahnverkehr.ogc_fid;
265
266
267--
268-- TOC entry 2388 (class 1259 OID 5505368)
269-- Dependencies: 2775 2776 2777 3 961
270-- Name: ax_bauraumoderbodenordnungsrecht; Type: TABLE; Schema: public; Owner: -; Tablespace:
271--
272
273CREATE TABLE ax_bauraumoderbodenordnungsrecht (
274    ogc_fid integer NOT NULL,
275    wkb_geometry geometry,
276    gml_id character(16),
277    beginnt character(20),
278    advstandardmodell character(4),
279    anlass integer,
280    artderfestlegung integer,
281    name character(18),
282    bezeichnung character(7),
283    CONSTRAINT enforce_dims_wkb_geometry CHECK ((ndims(wkb_geometry) = 2)),
284    CONSTRAINT enforce_geotype_wkb_geometry CHECK (((geometrytype(wkb_geometry) = 'POLYGON'::text) OR (wkb_geometry IS NULL))),
285    CONSTRAINT enforce_srid_wkb_geometry CHECK ((srid(wkb_geometry) = 25832))
286);
287
288
289--
290-- TOC entry 2387 (class 1259 OID 5505366)
291-- Dependencies: 2388 3
292-- Name: ax_bauraumoderbodenordnungsrecht_ogc_fid_seq; Type: SEQUENCE; Schema: public; Owner: -
293--
294
295CREATE SEQUENCE ax_bauraumoderbodenordnungsrecht_ogc_fid_seq
296    INCREMENT BY 1
297    NO MAXVALUE
298    NO MINVALUE
299    CACHE 1;
300
301
302--
303-- TOC entry 3005 (class 0 OID 0)
304-- Dependencies: 2387
305-- Name: ax_bauraumoderbodenordnungsrecht_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
306--
307
308ALTER SEQUENCE ax_bauraumoderbodenordnungsrecht_ogc_fid_seq OWNED BY ax_bauraumoderbodenordnungsrecht.ogc_fid;
309
310
311--
312-- TOC entry 2390 (class 1259 OID 5505413)
313-- Dependencies: 2779 2780 2781 3 961
314-- Name: ax_bauteil; Type: TABLE; Schema: public; Owner: -; Tablespace:
315--
316
317CREATE TABLE ax_bauteil (
318    ogc_fid integer NOT NULL,
319    wkb_geometry geometry,
320    gml_id character(16),
321    beginnt character(20),
322    advstandardmodell character(4),
323    anlass integer,
324    bauart integer,
325    CONSTRAINT enforce_dims_wkb_geometry CHECK ((ndims(wkb_geometry) = 2)),
326    CONSTRAINT enforce_geotype_wkb_geometry CHECK (((geometrytype(wkb_geometry) = 'POLYGON'::text) OR (wkb_geometry IS NULL))),
327    CONSTRAINT enforce_srid_wkb_geometry CHECK ((srid(wkb_geometry) = 25832))
328);
329
330
331--
332-- TOC entry 2389 (class 1259 OID 5505411)
333-- Dependencies: 2390 3
334-- Name: ax_bauteil_ogc_fid_seq; Type: SEQUENCE; Schema: public; Owner: -
335--
336
337CREATE SEQUENCE ax_bauteil_ogc_fid_seq
338    INCREMENT BY 1
339    NO MAXVALUE
340    NO MINVALUE
341    CACHE 1;
342
343
344--
345-- TOC entry 3006 (class 0 OID 0)
346-- Dependencies: 2389
347-- Name: ax_bauteil_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
348--
349
350ALTER SEQUENCE ax_bauteil_ogc_fid_seq OWNED BY ax_bauteil.ogc_fid;
351
352
353--
354-- TOC entry 2384 (class 1259 OID 5505132)
355-- Dependencies: 2767 2768 2769 3 961
356-- Name: ax_besondereflurstuecksgrenze; Type: TABLE; Schema: public; Owner: -; Tablespace:
357--
358
359CREATE TABLE ax_besondereflurstuecksgrenze (
360    ogc_fid integer NOT NULL,
361    wkb_geometry geometry,
362    gml_id character(16),
363    beginnt character(20),
364    advstandardmodell character(4),
365    anlass integer,
366    artderflurstuecksgrenze integer[],
367    CONSTRAINT enforce_dims_wkb_geometry CHECK ((ndims(wkb_geometry) = 2)),
368    CONSTRAINT enforce_geotype_wkb_geometry CHECK (((geometrytype(wkb_geometry) = 'LINESTRING'::text) OR (wkb_geometry IS NULL))),
369    CONSTRAINT enforce_srid_wkb_geometry CHECK ((srid(wkb_geometry) = 25832))
370);
371
372
373--
374-- TOC entry 2383 (class 1259 OID 5505130)
375-- Dependencies: 2384 3
376-- Name: ax_besondereflurstuecksgrenze_ogc_fid_seq; Type: SEQUENCE; Schema: public; Owner: -
377--
378
379CREATE SEQUENCE ax_besondereflurstuecksgrenze_ogc_fid_seq
380    INCREMENT BY 1
381    NO MAXVALUE
382    NO MINVALUE
383    CACHE 1;
384
385
386--
387-- TOC entry 3007 (class 0 OID 0)
388-- Dependencies: 2383
389-- Name: ax_besondereflurstuecksgrenze_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
390--
391
392ALTER SEQUENCE ax_besondereflurstuecksgrenze_ogc_fid_seq OWNED BY ax_besondereflurstuecksgrenze.ogc_fid;
393
394
395--
396-- TOC entry 2396 (class 1259 OID 5505479)
397-- Dependencies: 2791 2792 2793 3 961
398-- Name: ax_besonderegebaeudelinie; Type: TABLE; Schema: public; Owner: -; Tablespace:
399--
400
401CREATE TABLE ax_besonderegebaeudelinie (
402    ogc_fid integer NOT NULL,
403    wkb_geometry geometry,
404    gml_id character(16),
405    beginnt character(20),
406    advstandardmodell character(4),
407    anlass integer,
408    beschaffenheit integer,
409    CONSTRAINT enforce_dims_wkb_geometry CHECK ((ndims(wkb_geometry) = 2)),
410    CONSTRAINT enforce_geotype_wkb_geometry CHECK (((geometrytype(wkb_geometry) = 'LINESTRING'::text) OR (wkb_geometry IS NULL))),
411    CONSTRAINT enforce_srid_wkb_geometry CHECK ((srid(wkb_geometry) = 25832))
412);
413
414
415--
416-- TOC entry 2395 (class 1259 OID 5505477)
417-- Dependencies: 2396 3
418-- Name: ax_besonderegebaeudelinie_ogc_fid_seq; Type: SEQUENCE; Schema: public; Owner: -
419--
420
421CREATE SEQUENCE ax_besonderegebaeudelinie_ogc_fid_seq
422    INCREMENT BY 1
423    NO MAXVALUE
424    NO MINVALUE
425    CACHE 1;
426
427
428--
429-- TOC entry 3008 (class 0 OID 0)
430-- Dependencies: 2395
431-- Name: ax_besonderegebaeudelinie_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
432--
433
434ALTER SEQUENCE ax_besonderegebaeudelinie_ogc_fid_seq OWNED BY ax_besonderegebaeudelinie.ogc_fid;
435
436
437--
438-- TOC entry 2438 (class 1259 OID 5510550)
439-- Dependencies: 3
440-- Name: ax_besonderergebaeudepunkt; Type: TABLE; Schema: public; Owner: -; Tablespace:
441--
442
443CREATE TABLE ax_besonderergebaeudepunkt (
444    ogc_fid integer NOT NULL,
445    gml_id character(16),
446    beginnt character(20),
447    advstandardmodell character(4),
448    anlass integer,
449    punktkennung character(15),
450    sonstigeeigenschaft character(10)
451);
452
453
454--
455-- TOC entry 2437 (class 1259 OID 5510548)
456-- Dependencies: 3 2438
457-- Name: ax_besonderergebaeudepunkt_ogc_fid_seq; Type: SEQUENCE; Schema: public; Owner: -
458--
459
460CREATE SEQUENCE ax_besonderergebaeudepunkt_ogc_fid_seq
461    INCREMENT BY 1
462    NO MAXVALUE
463    NO MINVALUE
464    CACHE 1;
465
466
467--
468-- TOC entry 3009 (class 0 OID 0)
469-- Dependencies: 2437
470-- Name: ax_besonderergebaeudepunkt_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
471--
472
473ALTER SEQUENCE ax_besonderergebaeudepunkt_ogc_fid_seq OWNED BY ax_besonderergebaeudepunkt.ogc_fid;
474
475
476--
477-- TOC entry 2366 (class 1259 OID 5503222)
478-- Dependencies: 2735 2736 2737 3 961
479-- Name: ax_bewertung; Type: TABLE; Schema: public; Owner: -; Tablespace:
480--
481
482CREATE TABLE ax_bewertung (
483    ogc_fid integer NOT NULL,
484    wkb_geometry geometry,
485    gml_id character(16),
486    beginnt character(20),
487    advstandardmodell character(4),
488    anlass integer,
489    klassifizierung integer,
490    CONSTRAINT enforce_dims_wkb_geometry CHECK ((ndims(wkb_geometry) = 2)),
491    CONSTRAINT enforce_geotype_wkb_geometry CHECK (((geometrytype(wkb_geometry) = 'POLYGON'::text) OR (wkb_geometry IS NULL))),
492    CONSTRAINT enforce_srid_wkb_geometry CHECK ((srid(wkb_geometry) = 25832))
493);
494
495
496--
497-- TOC entry 2365 (class 1259 OID 5503220)
498-- Dependencies: 3 2366
499-- Name: ax_bewertung_ogc_fid_seq; Type: SEQUENCE; Schema: public; Owner: -
500--
501
502CREATE SEQUENCE ax_bewertung_ogc_fid_seq
503    INCREMENT BY 1
504    NO MAXVALUE
505    NO MINVALUE
506    CACHE 1;
507
508
509--
510-- TOC entry 3010 (class 0 OID 0)
511-- Dependencies: 2365
512-- Name: ax_bewertung_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
513--
514
515ALTER SEQUENCE ax_bewertung_ogc_fid_seq OWNED BY ax_bewertung.ogc_fid;
516
517
518--
519-- TOC entry 2364 (class 1259 OID 5503202)
520-- Dependencies: 2731 2732 2733 3 961
521-- Name: ax_bodenschaetzung; Type: TABLE; Schema: public; Owner: -; Tablespace:
522--
523
524CREATE TABLE ax_bodenschaetzung (
525    ogc_fid integer NOT NULL,
526    wkb_geometry geometry,
527    gml_id character(16),
528    beginnt character(20),
529    advstandardmodell character(4),
530    anlass integer,
531    kulturart integer,
532    bodenart integer,
533    zustandsstufeoderbodenstufe integer,
534    entstehungsartoderklimastufewasserverhaeltnisse integer[],
535    bodenzahlodergruenlandgrundzahl integer,
536    ackerzahlodergruenlandzahl integer,
537    CONSTRAINT enforce_dims_wkb_geometry CHECK ((ndims(wkb_geometry) = 2)),
538    CONSTRAINT enforce_geotype_wkb_geometry CHECK (((geometrytype(wkb_geometry) = 'POLYGON'::text) OR (wkb_geometry IS NULL))),
539    CONSTRAINT enforce_srid_wkb_geometry CHECK ((srid(wkb_geometry) = 25832))
540);
541
542
543--
544-- TOC entry 2363 (class 1259 OID 5503200)
545-- Dependencies: 3 2364
546-- Name: ax_bodenschaetzung_ogc_fid_seq; Type: SEQUENCE; Schema: public; Owner: -
547--
548
549CREATE SEQUENCE ax_bodenschaetzung_ogc_fid_seq
550    INCREMENT BY 1
551    NO MAXVALUE
552    NO MINVALUE
553    CACHE 1;
554
555
556--
557-- TOC entry 3011 (class 0 OID 0)
558-- Dependencies: 2363
559-- Name: ax_bodenschaetzung_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
560--
561
562ALTER SEQUENCE ax_bodenschaetzung_ogc_fid_seq OWNED BY ax_bodenschaetzung.ogc_fid;
563
564
565--
566-- TOC entry 2394 (class 1259 OID 5505462)
567-- Dependencies: 2787 2788 2789 3 961
568-- Name: ax_flaechebesondererfunktionalerpraegung; Type: TABLE; Schema: public; Owner: -; Tablespace:
569--
570
571CREATE TABLE ax_flaechebesondererfunktionalerpraegung (
572    ogc_fid integer NOT NULL,
573    wkb_geometry geometry,
574    gml_id character(16),
575    beginnt character(20),
576    advstandardmodell character(4),
577    anlass integer,
578    funktion integer,
579    CONSTRAINT enforce_dims_wkb_geometry CHECK ((ndims(wkb_geometry) = 2)),
580    CONSTRAINT enforce_geotype_wkb_geometry CHECK (((geometrytype(wkb_geometry) = 'POLYGON'::text) OR (wkb_geometry IS NULL))),
581    CONSTRAINT enforce_srid_wkb_geometry CHECK ((srid(wkb_geometry) = 25832))
582);
583
584
585--
586-- TOC entry 2393 (class 1259 OID 5505460)
587-- Dependencies: 2394 3
588-- Name: ax_flaechebesondererfunktionalerpraegung_ogc_fid_seq; Type: SEQUENCE; Schema: public; Owner: -
589--
590
591CREATE SEQUENCE ax_flaechebesondererfunktionalerpraegung_ogc_fid_seq
592    INCREMENT BY 1
593    NO MAXVALUE
594    NO MINVALUE
595    CACHE 1;
596
597
598--
599-- TOC entry 3012 (class 0 OID 0)
600-- Dependencies: 2393
601-- Name: ax_flaechebesondererfunktionalerpraegung_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
602--
603
604ALTER SEQUENCE ax_flaechebesondererfunktionalerpraegung_ogc_fid_seq OWNED BY ax_flaechebesondererfunktionalerpraegung.ogc_fid;
605
606
607--
608-- TOC entry 2392 (class 1259 OID 5505434)
609-- Dependencies: 2783 2784 2785 3 961
610-- Name: ax_flaechegemischternutzung; Type: TABLE; Schema: public; Owner: -; Tablespace:
611--
612
613CREATE TABLE ax_flaechegemischternutzung (
614    ogc_fid integer NOT NULL,
615    wkb_geometry geometry,
616    gml_id character(16),
617    beginnt character(20),
618    advstandardmodell character(4),
619    anlass integer,
620    funktion integer,
621    CONSTRAINT enforce_dims_wkb_geometry CHECK ((ndims(wkb_geometry) = 2)),
622    CONSTRAINT enforce_geotype_wkb_geometry CHECK (((geometrytype(wkb_geometry) = 'POLYGON'::text) OR (wkb_geometry IS NULL))),
623    CONSTRAINT enforce_srid_wkb_geometry CHECK ((srid(wkb_geometry) = 25832))
624);
625
626
627--
628-- TOC entry 2391 (class 1259 OID 5505432)
629-- Dependencies: 2392 3
630-- Name: ax_flaechegemischternutzung_ogc_fid_seq; Type: SEQUENCE; Schema: public; Owner: -
631--
632
633CREATE SEQUENCE ax_flaechegemischternutzung_ogc_fid_seq
634    INCREMENT BY 1
635    NO MAXVALUE
636    NO MINVALUE
637    CACHE 1;
638
639
640--
641-- TOC entry 3013 (class 0 OID 0)
642-- Dependencies: 2391
643-- Name: ax_flaechegemischternutzung_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
644--
645
646ALTER SEQUENCE ax_flaechegemischternutzung_ogc_fid_seq OWNED BY ax_flaechegemischternutzung.ogc_fid;
647
648
649--
650-- TOC entry 2362 (class 1259 OID 5503162)
651-- Dependencies: 2727 2728 2729 961 3
652-- Name: ax_fliessgewaesser; Type: TABLE; Schema: public; Owner: -; Tablespace:
653--
654
655CREATE TABLE ax_fliessgewaesser (
656    ogc_fid integer NOT NULL,
657    wkb_geometry geometry,
658    gml_id character(16),
659    beginnt character(20),
660    advstandardmodell character(4),
661    anlass integer,
662    funktion integer,
663    land integer,
664    regierungsbezirk integer,
665    kreis integer,
666    gemeinde integer,
667    lage character(5),
668    CONSTRAINT enforce_dims_wkb_geometry CHECK ((ndims(wkb_geometry) = 2)),
669    CONSTRAINT enforce_geotype_wkb_geometry CHECK (((geometrytype(wkb_geometry) = 'POLYGON'::text) OR (wkb_geometry IS NULL))),
670    CONSTRAINT enforce_srid_wkb_geometry CHECK ((srid(wkb_geometry) = 25832))
671);
672
673
674--
675-- TOC entry 2361 (class 1259 OID 5503160)
676-- Dependencies: 3 2362
677-- Name: ax_fliessgewaesser_ogc_fid_seq; Type: SEQUENCE; Schema: public; Owner: -
678--
679
680CREATE SEQUENCE ax_fliessgewaesser_ogc_fid_seq
681    INCREMENT BY 1
682    NO MAXVALUE
683    NO MINVALUE
684    CACHE 1;
685
686
687--
688-- TOC entry 3014 (class 0 OID 0)
689-- Dependencies: 2361
690-- Name: ax_fliessgewaesser_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
691--
692
693ALTER SEQUENCE ax_fliessgewaesser_ogc_fid_seq OWNED BY ax_fliessgewaesser.ogc_fid;
694
695
696--
697-- TOC entry 2368 (class 1259 OID 5503302)
698-- Dependencies: 2739 2740 3 961
699-- Name: ax_flurstueck; Type: TABLE; Schema: public; Owner: -; Tablespace:
700--
701
702CREATE TABLE ax_flurstueck (
703    ogc_fid integer NOT NULL,
704    wkb_geometry geometry,
705    gml_id character(16),
706    beginnt character(20),
707    advstandardmodell character(4),
708    anlass integer,
709    land integer,
710    gemarkungsnummer integer,
711    zaehler integer,
712    flurstueckskennzeichen character(20),
713    amtlicheflaeche double precision,
714    flurnummer integer,
715    angabenzumabschnittflurstueck character varying[],
716    "gemeindezugehoerigkeit|ax_gemeindekennzeichen|land" integer,
717    regierungsbezirk integer,
718    kreis integer,
719    gemeinde integer,
720    istgebucht character varying,
721    zeigtauf character varying,
722    nenner integer,
723    kennungschluessel character varying[],
724    flaechedesabschnitts double precision[],
725    angabenzumabschnittnummeraktenzeichen integer[],
726    angabenzumabschnittbemerkung character varying[],
727    zeitpunktderentstehung character(10),
728    weistauf character varying,
729    CONSTRAINT enforce_dims_wkb_geometry CHECK ((ndims(wkb_geometry) = 2)),
730    CONSTRAINT enforce_srid_wkb_geometry CHECK ((srid(wkb_geometry) = 25832))
731);
732
733
734--
735-- TOC entry 2367 (class 1259 OID 5503300)
736-- Dependencies: 2368 3
737-- Name: ax_flurstueck_ogc_fid_seq; Type: SEQUENCE; Schema: public; Owner: -
738--
739
740CREATE SEQUENCE ax_flurstueck_ogc_fid_seq
741    INCREMENT BY 1
742    NO MAXVALUE
743    NO MINVALUE
744    CACHE 1;
745
746
747--
748-- TOC entry 3015 (class 0 OID 0)
749-- Dependencies: 2367
750-- Name: ax_flurstueck_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
751--
752
753ALTER SEQUENCE ax_flurstueck_ogc_fid_seq OWNED BY ax_flurstueck.ogc_fid;
754
755
756--
757-- TOC entry 2398 (class 1259 OID 5505695)
758-- Dependencies: 2795 2796 2797 3 961
759-- Name: ax_gebaeude; Type: TABLE; Schema: public; Owner: -; Tablespace:
760--
761
762CREATE TABLE ax_gebaeude (
763    ogc_fid integer NOT NULL,
764    wkb_geometry geometry,
765    gml_id character(16),
766    beginnt character(20),
767    advstandardmodell character varying[],
768    anlass integer,
769    gebaeudefunktion integer,
770    description integer,
771    zeigtauf character varying,
772    CONSTRAINT enforce_dims_wkb_geometry CHECK ((ndims(wkb_geometry) = 2)),
773    CONSTRAINT enforce_geotype_wkb_geometry CHECK (((geometrytype(wkb_geometry) = 'POLYGON'::text) OR (wkb_geometry IS NULL))),
774    CONSTRAINT enforce_srid_wkb_geometry CHECK ((srid(wkb_geometry) = 25832))
775);
776
777
778--
779-- TOC entry 2397 (class 1259 OID 5505693)
780-- Dependencies: 3 2398
781-- Name: ax_gebaeude_ogc_fid_seq; Type: SEQUENCE; Schema: public; Owner: -
782--
783
784CREATE SEQUENCE ax_gebaeude_ogc_fid_seq
785    INCREMENT BY 1
786    NO MAXVALUE
787    NO MINVALUE
788    CACHE 1;
789
790
791--
792-- TOC entry 3016 (class 0 OID 0)
793-- Dependencies: 2397
794-- Name: ax_gebaeude_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
795--
796
797ALTER SEQUENCE ax_gebaeude_ogc_fid_seq OWNED BY ax_gebaeude.ogc_fid;
798
799
800--
801-- TOC entry 2402 (class 1259 OID 5506224)
802-- Dependencies: 2803 2804 2805 3 961
803-- Name: ax_gebaeudeausgestaltung; Type: TABLE; Schema: public; Owner: -; Tablespace:
804--
805
806CREATE TABLE ax_gebaeudeausgestaltung (
807    ogc_fid integer NOT NULL,
808    wkb_geometry geometry,
809    gml_id character(16),
810    beginnt character(20),
811    advstandardmodell character(4),
812    anlass integer,
813    darstellung integer,
814    zeigtauf character varying,
815    CONSTRAINT enforce_dims_wkb_geometry CHECK ((ndims(wkb_geometry) = 2)),
816    CONSTRAINT enforce_geotype_wkb_geometry CHECK (((geometrytype(wkb_geometry) = 'LINESTRING'::text) OR (wkb_geometry IS NULL))),
817    CONSTRAINT enforce_srid_wkb_geometry CHECK ((srid(wkb_geometry) = 25832))
818);
819
820
821--
822-- TOC entry 2401 (class 1259 OID 5506222)
823-- Dependencies: 2402 3
824-- Name: ax_gebaeudeausgestaltung_ogc_fid_seq; Type: SEQUENCE; Schema: public; Owner: -
825--
826
827CREATE SEQUENCE ax_gebaeudeausgestaltung_ogc_fid_seq
828    INCREMENT BY 1
829    NO MAXVALUE
830    NO MINVALUE
831    CACHE 1;
832
833
834--
835-- TOC entry 3017 (class 0 OID 0)
836-- Dependencies: 2401
837-- Name: ax_gebaeudeausgestaltung_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
838--
839
840ALTER SEQUENCE ax_gebaeudeausgestaltung_ogc_fid_seq OWNED BY ax_gebaeudeausgestaltung.ogc_fid;
841
842
843--
844-- TOC entry 2400 (class 1259 OID 5506206)
845-- Dependencies: 2799 2800 2801 3 961
846-- Name: ax_gehoelz; Type: TABLE; Schema: public; Owner: -; Tablespace:
847--
848
849CREATE TABLE ax_gehoelz (
850    ogc_fid integer NOT NULL,
851    wkb_geometry geometry,
852    gml_id character(16),
853    beginnt character(20),
854    advstandardmodell character(4),
855    anlass integer,
856    CONSTRAINT enforce_dims_wkb_geometry CHECK ((ndims(wkb_geometry) = 2)),
857    CONSTRAINT enforce_geotype_wkb_geometry CHECK (((geometrytype(wkb_geometry) = 'POLYGON'::text) OR (wkb_geometry IS NULL))),
858    CONSTRAINT enforce_srid_wkb_geometry CHECK ((srid(wkb_geometry) = 25832))
859);
860
861
862--
863-- TOC entry 2399 (class 1259 OID 5506204)
864-- Dependencies: 2400 3
865-- Name: ax_gehoelz_ogc_fid_seq; Type: SEQUENCE; Schema: public; Owner: -
866--
867
868CREATE SEQUENCE ax_gehoelz_ogc_fid_seq
869    INCREMENT BY 1
870    NO MAXVALUE
871    NO MINVALUE
872    CACHE 1;
873
874
875--
876-- TOC entry 3018 (class 0 OID 0)
877-- Dependencies: 2399
878-- Name: ax_gehoelz_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
879--
880
881ALTER SEQUENCE ax_gehoelz_ogc_fid_seq OWNED BY ax_gehoelz.ogc_fid;
882
883
884--
885-- TOC entry 2442 (class 1259 OID 5511081)
886-- Dependencies: 3
887-- Name: ax_gemarkungsteilflur; Type: TABLE; Schema: public; Owner: -; Tablespace:
888--
889
890CREATE TABLE ax_gemarkungsteilflur (
891    ogc_fid integer NOT NULL,
892    gml_id character(16),
893    beginnt character(20),
894    advstandardmodell character(4),
895    anlass integer,
896    schluesselgesamt integer,
897    bezeichnung integer,
898    land integer,
899    gemarkung integer,
900    gemarkungsteilflur integer
901);
902
903
904--
905-- TOC entry 2441 (class 1259 OID 5511079)
906-- Dependencies: 3 2442
907-- Name: ax_gemarkungsteilflur_ogc_fid_seq; Type: SEQUENCE; Schema: public; Owner: -
908--
909
910CREATE SEQUENCE ax_gemarkungsteilflur_ogc_fid_seq
911    INCREMENT BY 1
912    NO MAXVALUE
913    NO MINVALUE
914    CACHE 1;
915
916
917--
918-- TOC entry 3019 (class 0 OID 0)
919-- Dependencies: 2441
920-- Name: ax_gemarkungsteilflur_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
921--
922
923ALTER SEQUENCE ax_gemarkungsteilflur_ogc_fid_seq OWNED BY ax_gemarkungsteilflur.ogc_fid;
924
925
926--
927-- TOC entry 2430 (class 1259 OID 5508762)
928-- Dependencies: 3
929-- Name: ax_grenzpunkt; Type: TABLE; Schema: public; Owner: -; Tablespace:
930--
931
932CREATE TABLE ax_grenzpunkt (
933    ogc_fid integer NOT NULL,
934    gml_id character(16),
935    beginnt character(20),
936    advstandardmodell character(4),
937    anlass integer,
938    punktkennung character(15),
939    abmarkung_marke integer,
940    sonstigeeigenschaft character varying[]
941);
942
943
944--
945-- TOC entry 2429 (class 1259 OID 5508760)
946-- Dependencies: 2430 3
947-- Name: ax_grenzpunkt_ogc_fid_seq; Type: SEQUENCE; Schema: public; Owner: -
948--
949
950CREATE SEQUENCE ax_grenzpunkt_ogc_fid_seq
951    INCREMENT BY 1
952    NO MAXVALUE
953    NO MINVALUE
954    CACHE 1;
955
956
957--
958-- TOC entry 3020 (class 0 OID 0)
959-- Dependencies: 2429
960-- Name: ax_grenzpunkt_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
961--
962
963ALTER SEQUENCE ax_grenzpunkt_ogc_fid_seq OWNED BY ax_grenzpunkt.ogc_fid;
964
965
966--
967-- TOC entry 2408 (class 1259 OID 5506800)
968-- Dependencies: 2815 2816 2817 3 961
969-- Name: ax_industrieundgewerbeflaeche; Type: TABLE; Schema: public; Owner: -; Tablespace:
970--
971
972CREATE TABLE ax_industrieundgewerbeflaeche (
973    ogc_fid integer NOT NULL,
974    wkb_geometry geometry,
975    gml_id character(16),
976    beginnt character(20),
977    advstandardmodell character(4),
978    anlass integer,
979    funktion integer,
980    CONSTRAINT enforce_dims_wkb_geometry CHECK ((ndims(wkb_geometry) = 2)),
981    CONSTRAINT enforce_geotype_wkb_geometry CHECK (((geometrytype(wkb_geometry) = 'POLYGON'::text) OR (wkb_geometry IS NULL))),
982    CONSTRAINT enforce_srid_wkb_geometry CHECK ((srid(wkb_geometry) = 25832))
983);
984
985
986--
987-- TOC entry 2407 (class 1259 OID 5506798)
988-- Dependencies: 2408 3
989-- Name: ax_industrieundgewerbeflaeche_ogc_fid_seq; Type: SEQUENCE; Schema: public; Owner: -
990--
991
992CREATE SEQUENCE ax_industrieundgewerbeflaeche_ogc_fid_seq
993    INCREMENT BY 1
994    NO MAXVALUE
995    NO MINVALUE
996    CACHE 1;
997
998
999--
1000-- TOC entry 3021 (class 0 OID 0)
1001-- Dependencies: 2407
1002-- Name: ax_industrieundgewerbeflaeche_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1003--
1004
1005ALTER SEQUENCE ax_industrieundgewerbeflaeche_ogc_fid_seq OWNED BY ax_industrieundgewerbeflaeche.ogc_fid;
1006
1007
1008--
1009-- TOC entry 2444 (class 1259 OID 5511093)
1010-- Dependencies: 2866 2867 2868 3 961
1011-- Name: ax_klassifizierungnachstrassenrecht; Type: TABLE; Schema: public; Owner: -; Tablespace:
1012--
1013
1014CREATE TABLE ax_klassifizierungnachstrassenrecht (
1015    ogc_fid integer NOT NULL,
1016    wkb_geometry geometry,
1017    gml_id character(16),
1018    beginnt character(20),
1019    advstandardmodell character(4),
1020    anlass integer,
1021    artderfestlegung integer,
1022    bezeichnung character(5),
1023    CONSTRAINT enforce_dims_wkb_geometry CHECK ((ndims(wkb_geometry) = 2)),
1024    CONSTRAINT enforce_geotype_wkb_geometry CHECK (((geometrytype(wkb_geometry) = 'LINESTRING'::text) OR (wkb_geometry IS NULL))),
1025    CONSTRAINT enforce_srid_wkb_geometry CHECK ((srid(wkb_geometry) = 25832))
1026);
1027
1028
1029--
1030-- TOC entry 2443 (class 1259 OID 5511091)
1031-- Dependencies: 2444 3
1032-- Name: ax_klassifizierungnachstrassenrecht_ogc_fid_seq; Type: SEQUENCE; Schema: public; Owner: -
1033--
1034
1035CREATE SEQUENCE ax_klassifizierungnachstrassenrecht_ogc_fid_seq
1036    INCREMENT BY 1
1037    NO MAXVALUE
1038    NO MINVALUE
1039    CACHE 1;
1040
1041
1042--
1043-- TOC entry 3022 (class 0 OID 0)
1044-- Dependencies: 2443
1045-- Name: ax_klassifizierungnachstrassenrecht_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1046--
1047
1048ALTER SEQUENCE ax_klassifizierungnachstrassenrecht_ogc_fid_seq OWNED BY ax_klassifizierungnachstrassenrecht.ogc_fid;
1049
1050
1051--
1052-- TOC entry 2372 (class 1259 OID 5503988)
1053-- Dependencies: 2746 2747 2748 3 961
1054-- Name: ax_klassifizierungnachwasserrecht; Type: TABLE; Schema: public; Owner: -; Tablespace:
1055--
1056
1057CREATE TABLE ax_klassifizierungnachwasserrecht (
1058    ogc_fid integer NOT NULL,
1059    wkb_geometry geometry,
1060    gml_id character(16),
1061    beginnt character(20),
1062    advstandardmodell character(4),
1063    anlass integer,
1064    artderfestlegung integer,
1065    CONSTRAINT enforce_dims_wkb_geometry CHECK ((ndims(wkb_geometry) = 2)),
1066    CONSTRAINT enforce_geotype_wkb_geometry CHECK (((geometrytype(wkb_geometry) = 'POLYGON'::text) OR (wkb_geometry IS NULL))),
1067    CONSTRAINT enforce_srid_wkb_geometry CHECK ((srid(wkb_geometry) = 25832))
1068);
1069
1070
1071--
1072-- TOC entry 2371 (class 1259 OID 5503986)
1073-- Dependencies: 2372 3
1074-- Name: ax_klassifizierungnachwasserrecht_ogc_fid_seq; Type: SEQUENCE; Schema: public; Owner: -
1075--
1076
1077CREATE SEQUENCE ax_klassifizierungnachwasserrecht_ogc_fid_seq
1078    INCREMENT BY 1
1079    NO MAXVALUE
1080    NO MINVALUE
1081    CACHE 1;
1082
1083
1084--
1085-- TOC entry 3023 (class 0 OID 0)
1086-- Dependencies: 2371
1087-- Name: ax_klassifizierungnachwasserrecht_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1088--
1089
1090ALTER SEQUENCE ax_klassifizierungnachwasserrecht_ogc_fid_seq OWNED BY ax_klassifizierungnachwasserrecht.ogc_fid;
1091
1092
1093--
1094-- TOC entry 2436 (class 1259 OID 5510426)
1095-- Dependencies: 3
1096-- Name: ax_lagebezeichnungmithausnummer; Type: TABLE; Schema: public; Owner: -; Tablespace:
1097--
1098
1099CREATE TABLE ax_lagebezeichnungmithausnummer (
1100    ogc_fid integer NOT NULL,
1101    gml_id character(16),
1102    beginnt character(20),
1103    advstandardmodell character(4),
1104    anlass integer,
1105    land integer,
1106    regierungsbezirk integer,
1107    kreis integer,
1108    gemeinde integer,
1109    lage character(5),
1110    hausnummer character(3)
1111);
1112
1113
1114--
1115-- TOC entry 2435 (class 1259 OID 5510424)
1116-- Dependencies: 2436 3
1117-- Name: ax_lagebezeichnungmithausnummer_ogc_fid_seq; Type: SEQUENCE; Schema: public; Owner: -
1118--
1119
1120CREATE SEQUENCE ax_lagebezeichnungmithausnummer_ogc_fid_seq
1121    INCREMENT BY 1
1122    NO MAXVALUE
1123    NO MINVALUE
1124    CACHE 1;
1125
1126
1127--
1128-- TOC entry 3024 (class 0 OID 0)
1129-- Dependencies: 2435
1130-- Name: ax_lagebezeichnungmithausnummer_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1131--
1132
1133ALTER SEQUENCE ax_lagebezeichnungmithausnummer_ogc_fid_seq OWNED BY ax_lagebezeichnungmithausnummer.ogc_fid;
1134
1135
1136--
1137-- TOC entry 2376 (class 1259 OID 5504095)
1138-- Dependencies: 3
1139-- Name: ax_lagebezeichnungohnehausnummer; Type: TABLE; Schema: public; Owner: -; Tablespace:
1140--
1141
1142CREATE TABLE ax_lagebezeichnungohnehausnummer (
1143    ogc_fid integer NOT NULL,
1144    gml_id character(16),
1145    beginnt character(20),
1146    advstandardmodell character(4),
1147    anlass integer,
1148    land integer,
1149    regierungsbezirk integer,
1150    kreis integer,
1151    gemeinde integer,
1152    lage character(5)
1153);
1154
1155
1156--
1157-- TOC entry 2375 (class 1259 OID 5504093)
1158-- Dependencies: 3 2376
1159-- Name: ax_lagebezeichnungohnehausnummer_ogc_fid_seq; Type: SEQUENCE; Schema: public; Owner: -
1160--
1161
1162CREATE SEQUENCE ax_lagebezeichnungohnehausnummer_ogc_fid_seq
1163    INCREMENT BY 1
1164    NO MAXVALUE
1165    NO MINVALUE
1166    CACHE 1;
1167
1168
1169--
1170-- TOC entry 3025 (class 0 OID 0)
1171-- Dependencies: 2375
1172-- Name: ax_lagebezeichnungohnehausnummer_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1173--
1174
1175ALTER SEQUENCE ax_lagebezeichnungohnehausnummer_ogc_fid_seq OWNED BY ax_lagebezeichnungohnehausnummer.ogc_fid;
1176
1177
1178--
1179-- TOC entry 2370 (class 1259 OID 5503890)
1180-- Dependencies: 2742 2743 2744 3 961
1181-- Name: ax_landwirtschaft; Type: TABLE; Schema: public; Owner: -; Tablespace:
1182--
1183
1184CREATE TABLE ax_landwirtschaft (
1185    ogc_fid integer NOT NULL,
1186    wkb_geometry geometry,
1187    gml_id character(16),
1188    beginnt character(20),
1189    advstandardmodell character(4),
1190    anlass integer,
1191    vegetationsmerkmal integer,
1192    CONSTRAINT enforce_dims_wkb_geometry CHECK ((ndims(wkb_geometry) = 2)),
1193    CONSTRAINT enforce_geotype_wkb_geometry CHECK (((geometrytype(wkb_geometry) = 'POLYGON'::text) OR (wkb_geometry IS NULL))),
1194    CONSTRAINT enforce_srid_wkb_geometry CHECK ((srid(wkb_geometry) = 25832))
1195);
1196
1197
1198--
1199-- TOC entry 2369 (class 1259 OID 5503888)
1200-- Dependencies: 2370 3
1201-- Name: ax_landwirtschaft_ogc_fid_seq; Type: SEQUENCE; Schema: public; Owner: -
1202--
1203
1204CREATE SEQUENCE ax_landwirtschaft_ogc_fid_seq
1205    INCREMENT BY 1
1206    NO MAXVALUE
1207    NO MINVALUE
1208    CACHE 1;
1209
1210
1211--
1212-- TOC entry 3026 (class 0 OID 0)
1213-- Dependencies: 2369
1214-- Name: ax_landwirtschaft_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1215--
1216
1217ALTER SEQUENCE ax_landwirtschaft_ogc_fid_seq OWNED BY ax_landwirtschaft.ogc_fid;
1218
1219
1220--
1221-- TOC entry 2406 (class 1259 OID 5506781)
1222-- Dependencies: 2811 2812 2813 961 3
1223-- Name: ax_platz; Type: TABLE; Schema: public; Owner: -; Tablespace:
1224--
1225
1226CREATE TABLE ax_platz (
1227    ogc_fid integer NOT NULL,
1228    wkb_geometry geometry,
1229    gml_id character(16),
1230    beginnt character(20),
1231    advstandardmodell character(4),
1232    anlass integer,
1233    funktion integer,
1234    land integer,
1235    regierungsbezirk integer,
1236    kreis integer,
1237    gemeinde integer,
1238    lage character(5),
1239    CONSTRAINT enforce_dims_wkb_geometry CHECK ((ndims(wkb_geometry) = 2)),
1240    CONSTRAINT enforce_geotype_wkb_geometry CHECK (((geometrytype(wkb_geometry) = 'POLYGON'::text) OR (wkb_geometry IS NULL))),
1241    CONSTRAINT enforce_srid_wkb_geometry CHECK ((srid(wkb_geometry) = 25832))
1242);
1243
1244
1245--
1246-- TOC entry 2405 (class 1259 OID 5506779)
1247-- Dependencies: 3 2406
1248-- Name: ax_platz_ogc_fid_seq; Type: SEQUENCE; Schema: public; Owner: -
1249--
1250
1251CREATE SEQUENCE ax_platz_ogc_fid_seq
1252    INCREMENT BY 1
1253    NO MAXVALUE
1254    NO MINVALUE
1255    CACHE 1;
1256
1257
1258--
1259-- TOC entry 3027 (class 0 OID 0)
1260-- Dependencies: 2405
1261-- Name: ax_platz_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1262--
1263
1264ALTER SEQUENCE ax_platz_ogc_fid_seq OWNED BY ax_platz.ogc_fid;
1265
1266
1267--
1268-- TOC entry 2404 (class 1259 OID 5506252)
1269-- Dependencies: 2807 2808 2809 961 3
1270-- Name: ax_punktortag; Type: TABLE; Schema: public; Owner: -; Tablespace:
1271--
1272
1273CREATE TABLE ax_punktortag (
1274    ogc_fid integer NOT NULL,
1275    wkb_geometry geometry,
1276    gml_id character(16),
1277    beginnt character(20),
1278    advstandardmodell character(4),
1279    anlass integer,
1280    istteilvon character varying,
1281    kartendarstellung character(4),
1282    koordinatenstatus integer,
1283    description integer,
1284    genauigkeitsstufe integer,
1285    vertrauenswuerdigkeit integer,
1286    CONSTRAINT enforce_dims_wkb_geometry CHECK ((ndims(wkb_geometry) = 2)),
1287    CONSTRAINT enforce_geotype_wkb_geometry CHECK (((geometrytype(wkb_geometry) = 'POINT'::text) OR (wkb_geometry IS NULL))),
1288    CONSTRAINT enforce_srid_wkb_geometry CHECK ((srid(wkb_geometry) = 25832))
1289);
1290
1291
1292--
1293-- TOC entry 2403 (class 1259 OID 5506250)
1294-- Dependencies: 2404 3
1295-- Name: ax_punktortag_ogc_fid_seq; Type: SEQUENCE; Schema: public; Owner: -
1296--
1297
1298CREATE SEQUENCE ax_punktortag_ogc_fid_seq
1299    INCREMENT BY 1
1300    NO MAXVALUE
1301    NO MINVALUE
1302    CACHE 1;
1303
1304
1305--
1306-- TOC entry 3028 (class 0 OID 0)
1307-- Dependencies: 2403
1308-- Name: ax_punktortag_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1309--
1310
1311ALTER SEQUENCE ax_punktortag_ogc_fid_seq OWNED BY ax_punktortag.ogc_fid;
1312
1313
1314--
1315-- TOC entry 2410 (class 1259 OID 5506820)
1316-- Dependencies: 2819 2820 2821 3 961
1317-- Name: ax_punktortau; Type: TABLE; Schema: public; Owner: -; Tablespace:
1318--
1319
1320CREATE TABLE ax_punktortau (
1321    ogc_fid integer NOT NULL,
1322    wkb_geometry geometry,
1323    gml_id character(16),
1324    beginnt character(20),
1325    advstandardmodell character(4),
1326    anlass integer,
1327    istteilvon character varying,
1328    kartendarstellung character(5),
1329    koordinatenstatus integer,
1330    description integer,
1331    genauigkeitsstufe integer,
1332    vertrauenswuerdigkeit integer,
1333    CONSTRAINT enforce_dims_wkb_geometry CHECK ((ndims(wkb_geometry) = 2)),
1334    CONSTRAINT enforce_geotype_wkb_geometry CHECK (((geometrytype(wkb_geometry) = 'POINT'::text) OR (wkb_geometry IS NULL))),
1335    CONSTRAINT enforce_srid_wkb_geometry CHECK ((srid(wkb_geometry) = 25832))
1336);
1337
1338
1339--
1340-- TOC entry 2409 (class 1259 OID 5506818)
1341-- Dependencies: 3 2410
1342-- Name: ax_punktortau_ogc_fid_seq; Type: SEQUENCE; Schema: public; Owner: -
1343--
1344
1345CREATE SEQUENCE ax_punktortau_ogc_fid_seq
1346    INCREMENT BY 1
1347    NO MAXVALUE
1348    NO MINVALUE
1349    CACHE 1;
1350
1351
1352--
1353-- TOC entry 3029 (class 0 OID 0)
1354-- Dependencies: 2409
1355-- Name: ax_punktortau_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1356--
1357
1358ALTER SEQUENCE ax_punktortau_ogc_fid_seq OWNED BY ax_punktortau.ogc_fid;
1359
1360
1361--
1362-- TOC entry 2412 (class 1259 OID 5506885)
1363-- Dependencies: 2823 2824 2825 3 961
1364-- Name: ax_punktortta; Type: TABLE; Schema: public; Owner: -; Tablespace:
1365--
1366
1367CREATE TABLE ax_punktortta (
1368    ogc_fid integer NOT NULL,
1369    wkb_geometry geometry,
1370    gml_id character(16),
1371    beginnt character(20),
1372    advstandardmodell character(4),
1373    anlass integer,
1374    istteilvon character varying,
1375    kartendarstellung character(4),
1376    koordinatenstatus integer,
1377    description integer,
1378    genauigkeitsstufe integer,
1379    vertrauenswuerdigkeit integer,
1380    CONSTRAINT enforce_dims_wkb_geometry CHECK ((ndims(wkb_geometry) = 2)),
1381    CONSTRAINT enforce_geotype_wkb_geometry CHECK (((geometrytype(wkb_geometry) = 'POINT'::text) OR (wkb_geometry IS NULL))),
1382    CONSTRAINT enforce_srid_wkb_geometry CHECK ((srid(wkb_geometry) = 25832))
1383);
1384
1385
1386--
1387-- TOC entry 2411 (class 1259 OID 5506883)
1388-- Dependencies: 3 2412
1389-- Name: ax_punktortta_ogc_fid_seq; Type: SEQUENCE; Schema: public; Owner: -
1390--
1391
1392CREATE SEQUENCE ax_punktortta_ogc_fid_seq
1393    INCREMENT BY 1
1394    NO MAXVALUE
1395    NO MINVALUE
1396    CACHE 1;
1397
1398
1399--
1400-- TOC entry 3030 (class 0 OID 0)
1401-- Dependencies: 2411
1402-- Name: ax_punktortta_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1403--
1404
1405ALTER SEQUENCE ax_punktortta_ogc_fid_seq OWNED BY ax_punktortta.ogc_fid;
1406
1407
1408--
1409-- TOC entry 2440 (class 1259 OID 5511071)
1410-- Dependencies: 3
1411-- Name: ax_sicherungspunkt; Type: TABLE; Schema: public; Owner: -; Tablespace:
1412--
1413
1414CREATE TABLE ax_sicherungspunkt (
1415    ogc_fid integer NOT NULL,
1416    gml_id character(16),
1417    beginnt character(20),
1418    advstandardmodell character(4),
1419    anlass integer,
1420    punktkennung character(15),
1421    sonstigeeigenschaft character(10),
1422    vermarkung_marke integer
1423);
1424
1425
1426--
1427-- TOC entry 2439 (class 1259 OID 5511069)
1428-- Dependencies: 2440 3
1429-- Name: ax_sicherungspunkt_ogc_fid_seq; Type: SEQUENCE; Schema: public; Owner: -
1430--
1431
1432CREATE SEQUENCE ax_sicherungspunkt_ogc_fid_seq
1433    INCREMENT BY 1
1434    NO MAXVALUE
1435    NO MINVALUE
1436    CACHE 1;
1437
1438
1439--
1440-- TOC entry 3031 (class 0 OID 0)
1441-- Dependencies: 2439
1442-- Name: ax_sicherungspunkt_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1443--
1444
1445ALTER SEQUENCE ax_sicherungspunkt_ogc_fid_seq OWNED BY ax_sicherungspunkt.ogc_fid;
1446
1447
1448--
1449-- TOC entry 2434 (class 1259 OID 5510414)
1450-- Dependencies: 3
1451-- Name: ax_sonstigervermessungspunkt; Type: TABLE; Schema: public; Owner: -; Tablespace:
1452--
1453
1454CREATE TABLE ax_sonstigervermessungspunkt (
1455    ogc_fid integer NOT NULL,
1456    gml_id character(16),
1457    beginnt character(20),
1458    advstandardmodell character(4),
1459    anlass integer,
1460    punktkennung character(15),
1461    sonstigeeigenschaft character(10),
1462    vermarkung_marke integer
1463);
1464
1465
1466--
1467-- TOC entry 2433 (class 1259 OID 5510412)
1468-- Dependencies: 3 2434
1469-- Name: ax_sonstigervermessungspunkt_ogc_fid_seq; Type: SEQUENCE; Schema: public; Owner: -
1470--
1471
1472CREATE SEQUENCE ax_sonstigervermessungspunkt_ogc_fid_seq
1473    INCREMENT BY 1
1474    NO MAXVALUE
1475    NO MINVALUE
1476    CACHE 1;
1477
1478
1479--
1480-- TOC entry 3032 (class 0 OID 0)
1481-- Dependencies: 2433
1482-- Name: ax_sonstigervermessungspunkt_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1483--
1484
1485ALTER SEQUENCE ax_sonstigervermessungspunkt_ogc_fid_seq OWNED BY ax_sonstigervermessungspunkt.ogc_fid;
1486
1487
1488--
1489-- TOC entry 2428 (class 1259 OID 5508741)
1490-- Dependencies: 2855 2856 2857 3 961
1491-- Name: ax_sonstigesbauwerkodersonstigeeinrichtung; Type: TABLE; Schema: public; Owner: -; Tablespace:
1492--
1493
1494CREATE TABLE ax_sonstigesbauwerkodersonstigeeinrichtung (
1495    ogc_fid integer NOT NULL,
1496    wkb_geometry geometry,
1497    gml_id character(16),
1498    beginnt character(20),
1499    advstandardmodell character(4),
1500    anlass integer,
1501    bauwerksfunktion integer,
1502    CONSTRAINT enforce_dims_wkb_geometry CHECK ((ndims(wkb_geometry) = 2)),
1503    CONSTRAINT enforce_geotype_wkb_geometry CHECK (((geometrytype(wkb_geometry) = 'POLYGON'::text) OR (wkb_geometry IS NULL))),
1504    CONSTRAINT enforce_srid_wkb_geometry CHECK ((srid(wkb_geometry) = 25832))
1505);
1506
1507
1508--
1509-- TOC entry 2427 (class 1259 OID 5508739)
1510-- Dependencies: 2428 3
1511-- Name: ax_sonstigesbauwerkodersonstigeeinrichtung_ogc_fid_seq; Type: SEQUENCE; Schema: public; Owner: -
1512--
1513
1514CREATE SEQUENCE ax_sonstigesbauwerkodersonstigeeinrichtung_ogc_fid_seq
1515    INCREMENT BY 1
1516    NO MAXVALUE
1517    NO MINVALUE
1518    CACHE 1;
1519
1520
1521--
1522-- TOC entry 3033 (class 0 OID 0)
1523-- Dependencies: 2427
1524-- Name: ax_sonstigesbauwerkodersonstigeeinrichtung_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1525--
1526
1527ALTER SEQUENCE ax_sonstigesbauwerkodersonstigeeinrichtung_ogc_fid_seq OWNED BY ax_sonstigesbauwerkodersonstigeeinrichtung.ogc_fid;
1528
1529
1530--
1531-- TOC entry 2424 (class 1259 OID 5508641)
1532-- Dependencies: 2847 2848 2849 3 961
1533-- Name: ax_sportfreizeitunderholungsflaeche; Type: TABLE; Schema: public; Owner: -; Tablespace:
1534--
1535
1536CREATE TABLE ax_sportfreizeitunderholungsflaeche (
1537    ogc_fid integer NOT NULL,
1538    wkb_geometry geometry,
1539    gml_id character(16),
1540    beginnt character(20),
1541    advstandardmodell character(4),
1542    anlass integer,
1543    funktion integer,
1544    CONSTRAINT enforce_dims_wkb_geometry CHECK ((ndims(wkb_geometry) = 2)),
1545    CONSTRAINT enforce_geotype_wkb_geometry CHECK (((geometrytype(wkb_geometry) = 'POLYGON'::text) OR (wkb_geometry IS NULL))),
1546    CONSTRAINT enforce_srid_wkb_geometry CHECK ((srid(wkb_geometry) = 25832))
1547);
1548
1549
1550--
1551-- TOC entry 2423 (class 1259 OID 5508639)
1552-- Dependencies: 3 2424
1553-- Name: ax_sportfreizeitunderholungsflaeche_ogc_fid_seq; Type: SEQUENCE; Schema: public; Owner: -
1554--
1555
1556CREATE SEQUENCE ax_sportfreizeitunderholungsflaeche_ogc_fid_seq
1557    INCREMENT BY 1
1558    NO MAXVALUE
1559    NO MINVALUE
1560    CACHE 1;
1561
1562
1563--
1564-- TOC entry 3034 (class 0 OID 0)
1565-- Dependencies: 2423
1566-- Name: ax_sportfreizeitunderholungsflaeche_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1567--
1568
1569ALTER SEQUENCE ax_sportfreizeitunderholungsflaeche_ogc_fid_seq OWNED BY ax_sportfreizeitunderholungsflaeche.ogc_fid;
1570
1571
1572--
1573-- TOC entry 2418 (class 1259 OID 5508567)
1574-- Dependencies: 2835 2836 2837 3 961
1575-- Name: ax_stehendesgewaesser; Type: TABLE; Schema: public; Owner: -; Tablespace:
1576--
1577
1578CREATE TABLE ax_stehendesgewaesser (
1579    ogc_fid integer NOT NULL,
1580    wkb_geometry geometry,
1581    gml_id character(16),
1582    beginnt character(20),
1583    advstandardmodell character(4),
1584    anlass integer,
1585    funktion integer,
1586    land integer,
1587    regierungsbezirk integer,
1588    kreis integer,
1589    gemeinde integer,
1590    lage character(5),
1591    CONSTRAINT enforce_dims_wkb_geometry CHECK ((ndims(wkb_geometry) = 2)),
1592    CONSTRAINT enforce_geotype_wkb_geometry CHECK (((geometrytype(wkb_geometry) = 'POLYGON'::text) OR (wkb_geometry IS NULL))),
1593    CONSTRAINT enforce_srid_wkb_geometry CHECK ((srid(wkb_geometry) = 25832))
1594);
1595
1596
1597--
1598-- TOC entry 2417 (class 1259 OID 5508565)
1599-- Dependencies: 3 2418
1600-- Name: ax_stehendesgewaesser_ogc_fid_seq; Type: SEQUENCE; Schema: public; Owner: -
1601--
1602
1603CREATE SEQUENCE ax_stehendesgewaesser_ogc_fid_seq
1604    INCREMENT BY 1
1605    NO MAXVALUE
1606    NO MINVALUE
1607    CACHE 1;
1608
1609
1610--
1611-- TOC entry 3035 (class 0 OID 0)
1612-- Dependencies: 2417
1613-- Name: ax_stehendesgewaesser_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1614--
1615
1616ALTER SEQUENCE ax_stehendesgewaesser_ogc_fid_seq OWNED BY ax_stehendesgewaesser.ogc_fid;
1617
1618
1619--
1620-- TOC entry 2422 (class 1259 OID 5508607)
1621-- Dependencies: 2843 2844 2845 3 961
1622-- Name: ax_strassenverkehr; Type: TABLE; Schema: public; Owner: -; Tablespace:
1623--
1624
1625CREATE TABLE ax_strassenverkehr (
1626    ogc_fid integer NOT NULL,
1627    wkb_geometry geometry,
1628    gml_id character(16),
1629    beginnt character(20),
1630    advstandardmodell character(4),
1631    anlass integer,
1632    land integer,
1633    regierungsbezirk integer,
1634    kreis integer,
1635    gemeinde integer,
1636    lage character(5),
1637    CONSTRAINT enforce_dims_wkb_geometry CHECK ((ndims(wkb_geometry) = 2)),
1638    CONSTRAINT enforce_geotype_wkb_geometry CHECK (((geometrytype(wkb_geometry) = 'POLYGON'::text) OR (wkb_geometry IS NULL))),
1639    CONSTRAINT enforce_srid_wkb_geometry CHECK ((srid(wkb_geometry) = 25832))
1640);
1641
1642
1643--
1644-- TOC entry 2421 (class 1259 OID 5508605)
1645-- Dependencies: 3 2422
1646-- Name: ax_strassenverkehr_ogc_fid_seq; Type: SEQUENCE; Schema: public; Owner: -
1647--
1648
1649CREATE SEQUENCE ax_strassenverkehr_ogc_fid_seq
1650    INCREMENT BY 1
1651    NO MAXVALUE
1652    NO MINVALUE
1653    CACHE 1;
1654
1655
1656--
1657-- TOC entry 3036 (class 0 OID 0)
1658-- Dependencies: 2421
1659-- Name: ax_strassenverkehr_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1660--
1661
1662ALTER SEQUENCE ax_strassenverkehr_ogc_fid_seq OWNED BY ax_strassenverkehr.ogc_fid;
1663
1664
1665--
1666-- TOC entry 2426 (class 1259 OID 5508665)
1667-- Dependencies: 2851 2852 2853 3 961
1668-- Name: ax_topographischelinie; Type: TABLE; Schema: public; Owner: -; Tablespace:
1669--
1670
1671CREATE TABLE ax_topographischelinie (
1672    ogc_fid integer NOT NULL,
1673    wkb_geometry geometry,
1674    gml_id character(16),
1675    beginnt character(20),
1676    advstandardmodell character(4),
1677    anlass integer,
1678    liniendarstellung integer,
1679    sonstigeeigenschaft character(8),
1680    CONSTRAINT enforce_dims_wkb_geometry CHECK ((ndims(wkb_geometry) = 2)),
1681    CONSTRAINT enforce_geotype_wkb_geometry CHECK (((geometrytype(wkb_geometry) = 'LINESTRING'::text) OR (wkb_geometry IS NULL))),
1682    CONSTRAINT enforce_srid_wkb_geometry CHECK ((srid(wkb_geometry) = 25832))
1683);
1684
1685
1686--
1687-- TOC entry 2425 (class 1259 OID 5508663)
1688-- Dependencies: 2426 3
1689-- Name: ax_topographischelinie_ogc_fid_seq; Type: SEQUENCE; Schema: public; Owner: -
1690--
1691
1692CREATE SEQUENCE ax_topographischelinie_ogc_fid_seq
1693    INCREMENT BY 1
1694    NO MAXVALUE
1695    NO MINVALUE
1696    CACHE 1;
1697
1698
1699--
1700-- TOC entry 3037 (class 0 OID 0)
1701-- Dependencies: 2425
1702-- Name: ax_topographischelinie_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1703--
1704
1705ALTER SEQUENCE ax_topographischelinie_ogc_fid_seq OWNED BY ax_topographischelinie.ogc_fid;
1706
1707
1708--
1709-- TOC entry 2420 (class 1259 OID 5508585)
1710-- Dependencies: 2839 2840 2841 961 3
1711-- Name: ax_unlandvegetationsloseflaeche; Type: TABLE; Schema: public; Owner: -; Tablespace:
1712--
1713
1714CREATE TABLE ax_unlandvegetationsloseflaeche (
1715    ogc_fid integer NOT NULL,
1716    wkb_geometry geometry,
1717    gml_id character(16),
1718    beginnt character(20),
1719    advstandardmodell character(4),
1720    anlass integer,
1721    CONSTRAINT enforce_dims_wkb_geometry CHECK ((ndims(wkb_geometry) = 2)),
1722    CONSTRAINT enforce_geotype_wkb_geometry CHECK (((geometrytype(wkb_geometry) = 'POLYGON'::text) OR (wkb_geometry IS NULL))),
1723    CONSTRAINT enforce_srid_wkb_geometry CHECK ((srid(wkb_geometry) = 25832))
1724);
1725
1726
1727--
1728-- TOC entry 2419 (class 1259 OID 5508583)
1729-- Dependencies: 2420 3
1730-- Name: ax_unlandvegetationsloseflaeche_ogc_fid_seq; Type: SEQUENCE; Schema: public; Owner: -
1731--
1732
1733CREATE SEQUENCE ax_unlandvegetationsloseflaeche_ogc_fid_seq
1734    INCREMENT BY 1
1735    NO MAXVALUE
1736    NO MINVALUE
1737    CACHE 1;
1738
1739
1740--
1741-- TOC entry 3038 (class 0 OID 0)
1742-- Dependencies: 2419
1743-- Name: ax_unlandvegetationsloseflaeche_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1744--
1745
1746ALTER SEQUENCE ax_unlandvegetationsloseflaeche_ogc_fid_seq OWNED BY ax_unlandvegetationsloseflaeche.ogc_fid;
1747
1748
1749--
1750-- TOC entry 2416 (class 1259 OID 5508536)
1751-- Dependencies: 2831 2832 2833 3 961
1752-- Name: ax_wald; Type: TABLE; Schema: public; Owner: -; Tablespace:
1753--
1754
1755CREATE TABLE ax_wald (
1756    ogc_fid integer NOT NULL,
1757    wkb_geometry geometry,
1758    gml_id character(16),
1759    beginnt character(20),
1760    advstandardmodell character(4),
1761    anlass integer,
1762    vegetationsmerkmal integer,
1763    CONSTRAINT enforce_dims_wkb_geometry CHECK ((ndims(wkb_geometry) = 2)),
1764    CONSTRAINT enforce_geotype_wkb_geometry CHECK (((geometrytype(wkb_geometry) = 'POLYGON'::text) OR (wkb_geometry IS NULL))),
1765    CONSTRAINT enforce_srid_wkb_geometry CHECK ((srid(wkb_geometry) = 25832))
1766);
1767
1768
1769--
1770-- TOC entry 2415 (class 1259 OID 5508534)
1771-- Dependencies: 3 2416
1772-- Name: ax_wald_ogc_fid_seq; Type: SEQUENCE; Schema: public; Owner: -
1773--
1774
1775CREATE SEQUENCE ax_wald_ogc_fid_seq
1776    INCREMENT BY 1
1777    NO MAXVALUE
1778    NO MINVALUE
1779    CACHE 1;
1780
1781
1782--
1783-- TOC entry 3039 (class 0 OID 0)
1784-- Dependencies: 2415
1785-- Name: ax_wald_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1786--
1787
1788ALTER SEQUENCE ax_wald_ogc_fid_seq OWNED BY ax_wald.ogc_fid;
1789
1790
1791--
1792-- TOC entry 2374 (class 1259 OID 5504021)
1793-- Dependencies: 2750 2751 2752 961 3
1794-- Name: ax_weg; Type: TABLE; Schema: public; Owner: -; Tablespace:
1795--
1796
1797CREATE TABLE ax_weg (
1798    ogc_fid integer NOT NULL,
1799    wkb_geometry geometry,
1800    gml_id character(16),
1801    beginnt character(20),
1802    advstandardmodell character(4),
1803    anlass integer,
1804    land integer,
1805    regierungsbezirk integer,
1806    kreis integer,
1807    gemeinde integer,
1808    lage character(5),
1809    CONSTRAINT enforce_dims_wkb_geometry CHECK ((ndims(wkb_geometry) = 2)),
1810    CONSTRAINT enforce_geotype_wkb_geometry CHECK (((geometrytype(wkb_geometry) = 'POLYGON'::text) OR (wkb_geometry IS NULL))),
1811    CONSTRAINT enforce_srid_wkb_geometry CHECK ((srid(wkb_geometry) = 25832))
1812);
1813
1814
1815--
1816-- TOC entry 2373 (class 1259 OID 5504019)
1817-- Dependencies: 2374 3
1818-- Name: ax_weg_ogc_fid_seq; Type: SEQUENCE; Schema: public; Owner: -
1819--
1820
1821CREATE SEQUENCE ax_weg_ogc_fid_seq
1822    INCREMENT BY 1
1823    NO MAXVALUE
1824    NO MINVALUE
1825    CACHE 1;
1826
1827
1828--
1829-- TOC entry 3040 (class 0 OID 0)
1830-- Dependencies: 2373
1831-- Name: ax_weg_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1832--
1833
1834ALTER SEQUENCE ax_weg_ogc_fid_seq OWNED BY ax_weg.ogc_fid;
1835
1836
1837--
1838-- TOC entry 2414 (class 1259 OID 5508488)
1839-- Dependencies: 2827 2828 2829 961 3
1840-- Name: ax_wohnbauflaeche; Type: TABLE; Schema: public; Owner: -; Tablespace:
1841--
1842
1843CREATE TABLE ax_wohnbauflaeche (
1844    ogc_fid integer NOT NULL,
1845    wkb_geometry geometry,
1846    gml_id character(16),
1847    beginnt character(20),
1848    advstandardmodell character(4),
1849    anlass integer,
1850    artderbebauung integer,
1851    CONSTRAINT enforce_dims_wkb_geometry CHECK ((ndims(wkb_geometry) = 2)),
1852    CONSTRAINT enforce_geotype_wkb_geometry CHECK (((geometrytype(wkb_geometry) = 'POLYGON'::text) OR (wkb_geometry IS NULL))),
1853    CONSTRAINT enforce_srid_wkb_geometry CHECK ((srid(wkb_geometry) = 25832))
1854);
1855
1856
1857--
1858-- TOC entry 2413 (class 1259 OID 5508486)
1859-- Dependencies: 2414 3
1860-- Name: ax_wohnbauflaeche_ogc_fid_seq; Type: SEQUENCE; Schema: public; Owner: -
1861--
1862
1863CREATE SEQUENCE ax_wohnbauflaeche_ogc_fid_seq
1864    INCREMENT BY 1
1865    NO MAXVALUE
1866    NO MINVALUE
1867    CACHE 1;
1868
1869
1870--
1871-- TOC entry 3041 (class 0 OID 0)
1872-- Dependencies: 2413
1873-- Name: ax_wohnbauflaeche_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1874--
1875
1876ALTER SEQUENCE ax_wohnbauflaeche_ogc_fid_seq OWNED BY ax_wohnbauflaeche.ogc_fid;
1877
1878
1879--
1880-- TOC entry 2360 (class 1259 OID 16784)
1881-- Dependencies: 3
1882-- Name: geometry_columns; Type: TABLE; Schema: public; Owner: -; Tablespace:
1883--
1884
1885CREATE TABLE geometry_columns (
1886    f_table_catalog character varying(256) NOT NULL,
1887    f_table_schema character varying(256) NOT NULL,
1888    f_table_name character varying(256) NOT NULL,
1889    f_geometry_column character varying(256) NOT NULL,
1890    coord_dimension integer NOT NULL,
1891    srid integer NOT NULL,
1892    type character varying(30) NOT NULL
1893);
1894
1895
1896SET default_with_oids = false;
1897
1898--
1899-- TOC entry 2359 (class 1259 OID 16776)
1900-- Dependencies: 3
1901-- Name: spatial_ref_sys; Type: TABLE; Schema: public; Owner: -; Tablespace:
1902--
1903
1904CREATE TABLE spatial_ref_sys (
1905    srid integer NOT NULL,
1906    auth_name character varying(256),
1907    auth_srid integer,
1908    srtext character varying(2048),
1909    proj4text character varying(2048)
1910);
1911
1912
1913--
1914-- TOC entry 2869 (class 2604 OID 5511157)
1915-- Dependencies: 2446 2445 2446
1916-- Name: ogc_fid; Type: DEFAULT; Schema: public; Owner: -
1917--
1918
1919ALTER TABLE alkis_beziehungen ALTER COLUMN ogc_fid SET DEFAULT nextval('alkis_beziehungen_ogc_fid_seq'::regclass);
1920
1921
1922--
1923-- TOC entry 2758 (class 2604 OID 5504871)
1924-- Dependencies: 2380 2379 2380
1925-- Name: ogc_fid; Type: DEFAULT; Schema: public; Owner: -
1926--
1927
1928ALTER TABLE ap_lpo ALTER COLUMN ogc_fid SET DEFAULT nextval('ap_lpo_ogc_fid_seq'::regclass);
1929
1930
1931--
1932-- TOC entry 2762 (class 2604 OID 5505033)
1933-- Dependencies: 2382 2381 2382
1934-- Name: ogc_fid; Type: DEFAULT; Schema: public; Owner: -
1935--
1936
1937ALTER TABLE ap_ppo ALTER COLUMN ogc_fid SET DEFAULT nextval('ap_ppo_ogc_fid_seq'::regclass);
1938
1939
1940--
1941-- TOC entry 2754 (class 2604 OID 5504180)
1942-- Dependencies: 2377 2378 2378
1943-- Name: ogc_fid; Type: DEFAULT; Schema: public; Owner: -
1944--
1945
1946ALTER TABLE ap_pto ALTER COLUMN ogc_fid SET DEFAULT nextval('ap_pto_ogc_fid_seq'::regclass);
1947
1948
1949--
1950-- TOC entry 2859 (class 2604 OID 5510363)
1951-- Dependencies: 2432 2431 2432
1952-- Name: ogc_fid; Type: DEFAULT; Schema: public; Owner: -
1953--
1954
1955ALTER TABLE ax_aufnahmepunkt ALTER COLUMN ogc_fid SET DEFAULT nextval('ax_aufnahmepunkt_ogc_fid_seq'::regclass);
1956
1957
1958--
1959-- TOC entry 2770 (class 2604 OID 5505353)
1960-- Dependencies: 2385 2386 2386
1961-- Name: ogc_fid; Type: DEFAULT; Schema: public; Owner: -
1962--
1963
1964ALTER TABLE ax_bahnverkehr ALTER COLUMN ogc_fid SET DEFAULT nextval('ax_bahnverkehr_ogc_fid_seq'::regclass);
1965
1966
1967--
1968-- TOC entry 2774 (class 2604 OID 5505371)
1969-- Dependencies: 2387 2388 2388
1970-- Name: ogc_fid; Type: DEFAULT; Schema: public; Owner: -
1971--
1972
1973ALTER TABLE ax_bauraumoderbodenordnungsrecht ALTER COLUMN ogc_fid SET DEFAULT nextval('ax_bauraumoderbodenordnungsrecht_ogc_fid_seq'::regclass);
1974
1975
1976--
1977-- TOC entry 2778 (class 2604 OID 5505416)
1978-- Dependencies: 2389 2390 2390
1979-- Name: ogc_fid; Type: DEFAULT; Schema: public; Owner: -
1980--
1981
1982ALTER TABLE ax_bauteil ALTER COLUMN ogc_fid SET DEFAULT nextval('ax_bauteil_ogc_fid_seq'::regclass);
1983
1984
1985--
1986-- TOC entry 2766 (class 2604 OID 5505135)
1987-- Dependencies: 2384 2383 2384
1988-- Name: ogc_fid; Type: DEFAULT; Schema: public; Owner: -
1989--
1990
1991ALTER TABLE ax_besondereflurstuecksgrenze ALTER COLUMN ogc_fid SET DEFAULT nextval('ax_besondereflurstuecksgrenze_ogc_fid_seq'::regclass);
1992
1993
1994--
1995-- TOC entry 2790 (class 2604 OID 5505482)
1996-- Dependencies: 2396 2395 2396
1997-- Name: ogc_fid; Type: DEFAULT; Schema: public; Owner: -
1998--
1999
2000ALTER TABLE ax_besonderegebaeudelinie ALTER COLUMN ogc_fid SET DEFAULT nextval('ax_besonderegebaeudelinie_ogc_fid_seq'::regclass);
2001
2002
2003--
2004-- TOC entry 2862 (class 2604 OID 5510553)
2005-- Dependencies: 2437 2438 2438
2006-- Name: ogc_fid; Type: DEFAULT; Schema: public; Owner: -
2007--
2008
2009ALTER TABLE ax_besonderergebaeudepunkt ALTER COLUMN ogc_fid SET DEFAULT nextval('ax_besonderergebaeudepunkt_ogc_fid_seq'::regclass);
2010
2011
2012--
2013-- TOC entry 2734 (class 2604 OID 5503225)
2014-- Dependencies: 2366 2365 2366
2015-- Name: ogc_fid; Type: DEFAULT; Schema: public; Owner: -
2016--
2017
2018ALTER TABLE ax_bewertung ALTER COLUMN ogc_fid SET DEFAULT nextval('ax_bewertung_ogc_fid_seq'::regclass);
2019
2020
2021--
2022-- TOC entry 2730 (class 2604 OID 5503205)
2023-- Dependencies: 2364 2363 2364
2024-- Name: ogc_fid; Type: DEFAULT; Schema: public; Owner: -
2025--
2026
2027ALTER TABLE ax_bodenschaetzung ALTER COLUMN ogc_fid SET DEFAULT nextval('ax_bodenschaetzung_ogc_fid_seq'::regclass);
2028
2029
2030--
2031-- TOC entry 2786 (class 2604 OID 5505465)
2032-- Dependencies: 2394 2393 2394
2033-- Name: ogc_fid; Type: DEFAULT; Schema: public; Owner: -
2034--
2035
2036ALTER TABLE ax_flaechebesondererfunktionalerpraegung ALTER COLUMN ogc_fid SET DEFAULT nextval('ax_flaechebesondererfunktionalerpraegung_ogc_fid_seq'::regclass);
2037
2038
2039--
2040-- TOC entry 2782 (class 2604 OID 5505437)
2041-- Dependencies: 2391 2392 2392
2042-- Name: ogc_fid; Type: DEFAULT; Schema: public; Owner: -
2043--
2044
2045ALTER TABLE ax_flaechegemischternutzung ALTER COLUMN ogc_fid SET DEFAULT nextval('ax_flaechegemischternutzung_ogc_fid_seq'::regclass);
2046
2047
2048--
2049-- TOC entry 2726 (class 2604 OID 5503165)
2050-- Dependencies: 2362 2361 2362
2051-- Name: ogc_fid; Type: DEFAULT; Schema: public; Owner: -
2052--
2053
2054ALTER TABLE ax_fliessgewaesser ALTER COLUMN ogc_fid SET DEFAULT nextval('ax_fliessgewaesser_ogc_fid_seq'::regclass);
2055
2056
2057--
2058-- TOC entry 2738 (class 2604 OID 5503305)
2059-- Dependencies: 2367 2368 2368
2060-- Name: ogc_fid; Type: DEFAULT; Schema: public; Owner: -
2061--
2062
2063ALTER TABLE ax_flurstueck ALTER COLUMN ogc_fid SET DEFAULT nextval('ax_flurstueck_ogc_fid_seq'::regclass);
2064
2065
2066--
2067-- TOC entry 2794 (class 2604 OID 5505698)
2068-- Dependencies: 2398 2397 2398
2069-- Name: ogc_fid; Type: DEFAULT; Schema: public; Owner: -
2070--
2071
2072ALTER TABLE ax_gebaeude ALTER COLUMN ogc_fid SET DEFAULT nextval('ax_gebaeude_ogc_fid_seq'::regclass);
2073
2074
2075--
2076-- TOC entry 2802 (class 2604 OID 5506227)
2077-- Dependencies: 2402 2401 2402
2078-- Name: ogc_fid; Type: DEFAULT; Schema: public; Owner: -
2079--
2080
2081ALTER TABLE ax_gebaeudeausgestaltung ALTER COLUMN ogc_fid SET DEFAULT nextval('ax_gebaeudeausgestaltung_ogc_fid_seq'::regclass);
2082
2083
2084--
2085-- TOC entry 2798 (class 2604 OID 5506209)
2086-- Dependencies: 2399 2400 2400
2087-- Name: ogc_fid; Type: DEFAULT; Schema: public; Owner: -
2088--
2089
2090ALTER TABLE ax_gehoelz ALTER COLUMN ogc_fid SET DEFAULT nextval('ax_gehoelz_ogc_fid_seq'::regclass);
2091
2092
2093--
2094-- TOC entry 2864 (class 2604 OID 5511084)
2095-- Dependencies: 2441 2442 2442
2096-- Name: ogc_fid; Type: DEFAULT; Schema: public; Owner: -
2097--
2098
2099ALTER TABLE ax_gemarkungsteilflur ALTER COLUMN ogc_fid SET DEFAULT nextval('ax_gemarkungsteilflur_ogc_fid_seq'::regclass);
2100
2101
2102--
2103-- TOC entry 2858 (class 2604 OID 5508765)
2104-- Dependencies: 2430 2429 2430
2105-- Name: ogc_fid; Type: DEFAULT; Schema: public; Owner: -
2106--
2107
2108ALTER TABLE ax_grenzpunkt ALTER COLUMN ogc_fid SET DEFAULT nextval('ax_grenzpunkt_ogc_fid_seq'::regclass);
2109
2110
2111--
2112-- TOC entry 2814 (class 2604 OID 5506803)
2113-- Dependencies: 2408 2407 2408
2114-- Name: ogc_fid; Type: DEFAULT; Schema: public; Owner: -
2115--
2116
2117ALTER TABLE ax_industrieundgewerbeflaeche ALTER COLUMN ogc_fid SET DEFAULT nextval('ax_industrieundgewerbeflaeche_ogc_fid_seq'::regclass);
2118
2119
2120--
2121-- TOC entry 2865 (class 2604 OID 5511096)
2122-- Dependencies: 2443 2444 2444
2123-- Name: ogc_fid; Type: DEFAULT; Schema: public; Owner: -
2124--
2125
2126ALTER TABLE ax_klassifizierungnachstrassenrecht ALTER COLUMN ogc_fid SET DEFAULT nextval('ax_klassifizierungnachstrassenrecht_ogc_fid_seq'::regclass);
2127
2128
2129--
2130-- TOC entry 2745 (class 2604 OID 5503991)
2131-- Dependencies: 2372 2371 2372
2132-- Name: ogc_fid; Type: DEFAULT; Schema: public; Owner: -
2133--
2134
2135ALTER TABLE ax_klassifizierungnachwasserrecht ALTER COLUMN ogc_fid SET DEFAULT nextval('ax_klassifizierungnachwasserrecht_ogc_fid_seq'::regclass);
2136
2137
2138--
2139-- TOC entry 2861 (class 2604 OID 5510429)
2140-- Dependencies: 2436 2435 2436
2141-- Name: ogc_fid; Type: DEFAULT; Schema: public; Owner: -
2142--
2143
2144ALTER TABLE ax_lagebezeichnungmithausnummer ALTER COLUMN ogc_fid SET DEFAULT nextval('ax_lagebezeichnungmithausnummer_ogc_fid_seq'::regclass);
2145
2146
2147--
2148-- TOC entry 2753 (class 2604 OID 5504098)
2149-- Dependencies: 2376 2375 2376
2150-- Name: ogc_fid; Type: DEFAULT; Schema: public; Owner: -
2151--
2152
2153ALTER TABLE ax_lagebezeichnungohnehausnummer ALTER COLUMN ogc_fid SET DEFAULT nextval('ax_lagebezeichnungohnehausnummer_ogc_fid_seq'::regclass);
2154
2155
2156--
2157-- TOC entry 2741 (class 2604 OID 5503893)
2158-- Dependencies: 2370 2369 2370
2159-- Name: ogc_fid; Type: DEFAULT; Schema: public; Owner: -
2160--
2161
2162ALTER TABLE ax_landwirtschaft ALTER COLUMN ogc_fid SET DEFAULT nextval('ax_landwirtschaft_ogc_fid_seq'::regclass);
2163
2164
2165--
2166-- TOC entry 2810 (class 2604 OID 5506784)
2167-- Dependencies: 2406 2405 2406
2168-- Name: ogc_fid; Type: DEFAULT; Schema: public; Owner: -
2169--
2170
2171ALTER TABLE ax_platz ALTER COLUMN ogc_fid SET DEFAULT nextval('ax_platz_ogc_fid_seq'::regclass);
2172
2173
2174--
2175-- TOC entry 2806 (class 2604 OID 5506255)
2176-- Dependencies: 2403 2404 2404
2177-- Name: ogc_fid; Type: DEFAULT; Schema: public; Owner: -
2178--
2179
2180ALTER TABLE ax_punktortag ALTER COLUMN ogc_fid SET DEFAULT nextval('ax_punktortag_ogc_fid_seq'::regclass);
2181
2182
2183--
2184-- TOC entry 2818 (class 2604 OID 5506823)
2185-- Dependencies: 2410 2409 2410
2186-- Name: ogc_fid; Type: DEFAULT; Schema: public; Owner: -
2187--
2188
2189ALTER TABLE ax_punktortau ALTER COLUMN ogc_fid SET DEFAULT nextval('ax_punktortau_ogc_fid_seq'::regclass);
2190
2191
2192--
2193-- TOC entry 2822 (class 2604 OID 5506888)
2194-- Dependencies: 2411 2412 2412
2195-- Name: ogc_fid; Type: DEFAULT; Schema: public; Owner: -
2196--
2197
2198ALTER TABLE ax_punktortta ALTER COLUMN ogc_fid SET DEFAULT nextval('ax_punktortta_ogc_fid_seq'::regclass);
2199
2200
2201--
2202-- TOC entry 2863 (class 2604 OID 5511074)
2203-- Dependencies: 2439 2440 2440
2204-- Name: ogc_fid; Type: DEFAULT; Schema: public; Owner: -
2205--
2206
2207ALTER TABLE ax_sicherungspunkt ALTER COLUMN ogc_fid SET DEFAULT nextval('ax_sicherungspunkt_ogc_fid_seq'::regclass);
2208
2209
2210--
2211-- TOC entry 2860 (class 2604 OID 5510417)
2212-- Dependencies: 2434 2433 2434
2213-- Name: ogc_fid; Type: DEFAULT; Schema: public; Owner: -
2214--
2215
2216ALTER TABLE ax_sonstigervermessungspunkt ALTER COLUMN ogc_fid SET DEFAULT nextval('ax_sonstigervermessungspunkt_ogc_fid_seq'::regclass);
2217
2218
2219--
2220-- TOC entry 2854 (class 2604 OID 5508744)
2221-- Dependencies: 2428 2427 2428
2222-- Name: ogc_fid; Type: DEFAULT; Schema: public; Owner: -
2223--
2224
2225ALTER TABLE ax_sonstigesbauwerkodersonstigeeinrichtung ALTER COLUMN ogc_fid SET DEFAULT nextval('ax_sonstigesbauwerkodersonstigeeinrichtung_ogc_fid_seq'::regclass);
2226
2227
2228--
2229-- TOC entry 2846 (class 2604 OID 5508644)
2230-- Dependencies: 2424 2423 2424
2231-- Name: ogc_fid; Type: DEFAULT; Schema: public; Owner: -
2232--
2233
2234ALTER TABLE ax_sportfreizeitunderholungsflaeche ALTER COLUMN ogc_fid SET DEFAULT nextval('ax_sportfreizeitunderholungsflaeche_ogc_fid_seq'::regclass);
2235
2236
2237--
2238-- TOC entry 2834 (class 2604 OID 5508570)
2239-- Dependencies: 2417 2418 2418
2240-- Name: ogc_fid; Type: DEFAULT; Schema: public; Owner: -
2241--
2242
2243ALTER TABLE ax_stehendesgewaesser ALTER COLUMN ogc_fid SET DEFAULT nextval('ax_stehendesgewaesser_ogc_fid_seq'::regclass);
2244
2245
2246--
2247-- TOC entry 2842 (class 2604 OID 5508610)
2248-- Dependencies: 2422 2421 2422
2249-- Name: ogc_fid; Type: DEFAULT; Schema: public; Owner: -
2250--
2251
2252ALTER TABLE ax_strassenverkehr ALTER COLUMN ogc_fid SET DEFAULT nextval('ax_strassenverkehr_ogc_fid_seq'::regclass);
2253
2254
2255--
2256-- TOC entry 2850 (class 2604 OID 5508668)
2257-- Dependencies: 2425 2426 2426
2258-- Name: ogc_fid; Type: DEFAULT; Schema: public; Owner: -
2259--
2260
2261ALTER TABLE ax_topographischelinie ALTER COLUMN ogc_fid SET DEFAULT nextval('ax_topographischelinie_ogc_fid_seq'::regclass);
2262
2263
2264--
2265-- TOC entry 2838 (class 2604 OID 5508588)
2266-- Dependencies: 2419 2420 2420
2267-- Name: ogc_fid; Type: DEFAULT; Schema: public; Owner: -
2268--
2269
2270ALTER TABLE ax_unlandvegetationsloseflaeche ALTER COLUMN ogc_fid SET DEFAULT nextval('ax_unlandvegetationsloseflaeche_ogc_fid_seq'::regclass);
2271
2272
2273--
2274-- TOC entry 2830 (class 2604 OID 5508539)
2275-- Dependencies: 2415 2416 2416
2276-- Name: ogc_fid; Type: DEFAULT; Schema: public; Owner: -
2277--
2278
2279ALTER TABLE ax_wald ALTER COLUMN ogc_fid SET DEFAULT nextval('ax_wald_ogc_fid_seq'::regclass);
2280
2281
2282--
2283-- TOC entry 2749 (class 2604 OID 5504024)
2284-- Dependencies: 2373 2374 2374
2285-- Name: ogc_fid; Type: DEFAULT; Schema: public; Owner: -
2286--
2287
2288ALTER TABLE ax_weg ALTER COLUMN ogc_fid SET DEFAULT nextval('ax_weg_ogc_fid_seq'::regclass);
2289
2290
2291--
2292-- TOC entry 2826 (class 2604 OID 5508491)
2293-- Dependencies: 2413 2414 2414
2294-- Name: ogc_fid; Type: DEFAULT; Schema: public; Owner: -
2295--
2296
2297ALTER TABLE ax_wohnbauflaeche ALTER COLUMN ogc_fid SET DEFAULT nextval('ax_wohnbauflaeche_ogc_fid_seq'::regclass);
2298
2299
2300--
2301-- TOC entry 2993 (class 2606 OID 5511159)
2302-- Dependencies: 2446 2446
2303-- Name: alkis_beziehungen_pk; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
2304--
2305
2306ALTER TABLE ONLY alkis_beziehungen
2307    ADD CONSTRAINT alkis_beziehungen_pk PRIMARY KEY (ogc_fid);
2308
2309
2310--
2311-- TOC entry 2902 (class 2606 OID 5504873)
2312-- Dependencies: 2380 2380
2313-- Name: ap_lpo_pk; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
2314--
2315
2316ALTER TABLE ONLY ap_lpo
2317    ADD CONSTRAINT ap_lpo_pk PRIMARY KEY (ogc_fid);
2318
2319
2320--
2321-- TOC entry 2905 (class 2606 OID 5505035)
2322-- Dependencies: 2382 2382
2323-- Name: ap_ppo_pk; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
2324--
2325
2326ALTER TABLE ONLY ap_ppo
2327    ADD CONSTRAINT ap_ppo_pk PRIMARY KEY (ogc_fid);
2328
2329
2330--
2331-- TOC entry 2899 (class 2606 OID 5504182)
2332-- Dependencies: 2378 2378
2333-- Name: ap_pto_pk; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
2334--
2335
2336ALTER TABLE ONLY ap_pto
2337    ADD CONSTRAINT ap_pto_pk PRIMARY KEY (ogc_fid);
2338
2339
2340--
2341-- TOC entry 2978 (class 2606 OID 5510365)
2342-- Dependencies: 2432 2432
2343-- Name: ax_aufnahmepunkt_pk; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
2344--
2345
2346ALTER TABLE ONLY ax_aufnahmepunkt
2347    ADD CONSTRAINT ax_aufnahmepunkt_pk PRIMARY KEY (ogc_fid);
2348
2349
2350--
2351-- TOC entry 2911 (class 2606 OID 5505355)
2352-- Dependencies: 2386 2386
2353-- Name: ax_bahnverkehr_pk; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
2354--
2355
2356ALTER TABLE ONLY ax_bahnverkehr
2357    ADD CONSTRAINT ax_bahnverkehr_pk PRIMARY KEY (ogc_fid);
2358
2359
2360--
2361-- TOC entry 2914 (class 2606 OID 5505373)
2362-- Dependencies: 2388 2388
2363-- Name: ax_bauraumoderbodenordnungsrecht_pk; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
2364--
2365
2366ALTER TABLE ONLY ax_bauraumoderbodenordnungsrecht
2367    ADD CONSTRAINT ax_bauraumoderbodenordnungsrecht_pk PRIMARY KEY (ogc_fid);
2368
2369
2370--
2371-- TOC entry 2917 (class 2606 OID 5505418)
2372-- Dependencies: 2390 2390
2373-- Name: ax_bauteil_pk; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
2374--
2375
2376ALTER TABLE ONLY ax_bauteil
2377    ADD CONSTRAINT ax_bauteil_pk PRIMARY KEY (ogc_fid);
2378
2379
2380--
2381-- TOC entry 2908 (class 2606 OID 5505137)
2382-- Dependencies: 2384 2384
2383-- Name: ax_besondereflurstuecksgrenze_pk; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
2384--
2385
2386ALTER TABLE ONLY ax_besondereflurstuecksgrenze
2387    ADD CONSTRAINT ax_besondereflurstuecksgrenze_pk PRIMARY KEY (ogc_fid);
2388
2389
2390--
2391-- TOC entry 2926 (class 2606 OID 5505484)
2392-- Dependencies: 2396 2396
2393-- Name: ax_besonderegebaeudelinie_pk; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
2394--
2395
2396ALTER TABLE ONLY ax_besonderegebaeudelinie
2397    ADD CONSTRAINT ax_besonderegebaeudelinie_pk PRIMARY KEY (ogc_fid);
2398
2399
2400--
2401-- TOC entry 2984 (class 2606 OID 5510555)
2402-- Dependencies: 2438 2438
2403-- Name: ax_besonderergebaeudepunkt_pk; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
2404--
2405
2406ALTER TABLE ONLY ax_besonderergebaeudepunkt
2407    ADD CONSTRAINT ax_besonderergebaeudepunkt_pk PRIMARY KEY (ogc_fid);
2408
2409
2410--
2411-- TOC entry 2882 (class 2606 OID 5503227)
2412-- Dependencies: 2366 2366
2413-- Name: ax_bewertung_pk; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
2414--
2415
2416ALTER TABLE ONLY ax_bewertung
2417    ADD CONSTRAINT ax_bewertung_pk PRIMARY KEY (ogc_fid);
2418
2419
2420--
2421-- TOC entry 2879 (class 2606 OID 5503207)
2422-- Dependencies: 2364 2364
2423-- Name: ax_bodenschaetzung_pk; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
2424--
2425
2426ALTER TABLE ONLY ax_bodenschaetzung
2427    ADD CONSTRAINT ax_bodenschaetzung_pk PRIMARY KEY (ogc_fid);
2428
2429
2430--
2431-- TOC entry 2923 (class 2606 OID 5505467)
2432-- Dependencies: 2394 2394
2433-- Name: ax_flaechebesondererfunktionalerpraegung_pk; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
2434--
2435
2436ALTER TABLE ONLY ax_flaechebesondererfunktionalerpraegung
2437    ADD CONSTRAINT ax_flaechebesondererfunktionalerpraegung_pk PRIMARY KEY (ogc_fid);
2438
2439
2440--
2441-- TOC entry 2920 (class 2606 OID 5505439)
2442-- Dependencies: 2392 2392
2443-- Name: ax_flaechegemischternutzung_pk; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
2444--
2445
2446ALTER TABLE ONLY ax_flaechegemischternutzung
2447    ADD CONSTRAINT ax_flaechegemischternutzung_pk PRIMARY KEY (ogc_fid);
2448
2449
2450--
2451-- TOC entry 2876 (class 2606 OID 5503167)
2452-- Dependencies: 2362 2362
2453-- Name: ax_fliessgewaesser_pk; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
2454--
2455
2456ALTER TABLE ONLY ax_fliessgewaesser
2457    ADD CONSTRAINT ax_fliessgewaesser_pk PRIMARY KEY (ogc_fid);
2458
2459
2460--
2461-- TOC entry 2885 (class 2606 OID 5503307)
2462-- Dependencies: 2368 2368
2463-- Name: ax_flurstueck_pk; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
2464--
2465
2466ALTER TABLE ONLY ax_flurstueck
2467    ADD CONSTRAINT ax_flurstueck_pk PRIMARY KEY (ogc_fid);
2468
2469
2470--
2471-- TOC entry 2929 (class 2606 OID 5505700)
2472-- Dependencies: 2398 2398
2473-- Name: ax_gebaeude_pk; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
2474--
2475
2476ALTER TABLE ONLY ax_gebaeude
2477    ADD CONSTRAINT ax_gebaeude_pk PRIMARY KEY (ogc_fid);
2478
2479
2480--
2481-- TOC entry 2935 (class 2606 OID 5506229)
2482-- Dependencies: 2402 2402
2483-- Name: ax_gebaeudeausgestaltung_pk; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
2484--
2485
2486ALTER TABLE ONLY ax_gebaeudeausgestaltung
2487    ADD CONSTRAINT ax_gebaeudeausgestaltung_pk PRIMARY KEY (ogc_fid);
2488
2489
2490--
2491-- TOC entry 2932 (class 2606 OID 5506211)
2492-- Dependencies: 2400 2400
2493-- Name: ax_gehoelz_pk; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
2494--
2495
2496ALTER TABLE ONLY ax_gehoelz
2497    ADD CONSTRAINT ax_gehoelz_pk PRIMARY KEY (ogc_fid);
2498
2499
2500--
2501-- TOC entry 2988 (class 2606 OID 5511086)
2502-- Dependencies: 2442 2442
2503-- Name: ax_gemarkungsteilflur_pk; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
2504--
2505
2506ALTER TABLE ONLY ax_gemarkungsteilflur
2507    ADD CONSTRAINT ax_gemarkungsteilflur_pk PRIMARY KEY (ogc_fid);
2508
2509
2510--
2511-- TOC entry 2976 (class 2606 OID 5508767)
2512-- Dependencies: 2430 2430
2513-- Name: ax_grenzpunkt_pk; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
2514--
2515
2516ALTER TABLE ONLY ax_grenzpunkt
2517    ADD CONSTRAINT ax_grenzpunkt_pk PRIMARY KEY (ogc_fid);
2518
2519
2520--
2521-- TOC entry 2944 (class 2606 OID 5506805)
2522-- Dependencies: 2408 2408
2523-- Name: ax_industrieundgewerbeflaeche_pk; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
2524--
2525
2526ALTER TABLE ONLY ax_industrieundgewerbeflaeche
2527    ADD CONSTRAINT ax_industrieundgewerbeflaeche_pk PRIMARY KEY (ogc_fid);
2528
2529
2530--
2531-- TOC entry 2991 (class 2606 OID 5511098)
2532-- Dependencies: 2444 2444
2533-- Name: ax_klassifizierungnachstrassenrecht_pk; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
2534--
2535
2536ALTER TABLE ONLY ax_klassifizierungnachstrassenrecht
2537    ADD CONSTRAINT ax_klassifizierungnachstrassenrecht_pk PRIMARY KEY (ogc_fid);
2538
2539
2540--
2541-- TOC entry 2891 (class 2606 OID 5503993)
2542-- Dependencies: 2372 2372
2543-- Name: ax_klassifizierungnachwasserrecht_pk; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
2544--
2545
2546ALTER TABLE ONLY ax_klassifizierungnachwasserrecht
2547    ADD CONSTRAINT ax_klassifizierungnachwasserrecht_pk PRIMARY KEY (ogc_fid);
2548
2549
2550--
2551-- TOC entry 2982 (class 2606 OID 5510431)
2552-- Dependencies: 2436 2436
2553-- Name: ax_lagebezeichnungmithausnummer_pk; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
2554--
2555
2556ALTER TABLE ONLY ax_lagebezeichnungmithausnummer
2557    ADD CONSTRAINT ax_lagebezeichnungmithausnummer_pk PRIMARY KEY (ogc_fid);
2558
2559
2560--
2561-- TOC entry 2896 (class 2606 OID 5504100)
2562-- Dependencies: 2376 2376
2563-- Name: ax_lagebezeichnungohnehausnummer_pk; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
2564--
2565
2566ALTER TABLE ONLY ax_lagebezeichnungohnehausnummer
2567    ADD CONSTRAINT ax_lagebezeichnungohnehausnummer_pk PRIMARY KEY (ogc_fid);
2568
2569
2570--
2571-- TOC entry 2888 (class 2606 OID 5503895)
2572-- Dependencies: 2370 2370
2573-- Name: ax_landwirtschaft_pk; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
2574--
2575
2576ALTER TABLE ONLY ax_landwirtschaft
2577    ADD CONSTRAINT ax_landwirtschaft_pk PRIMARY KEY (ogc_fid);
2578
2579
2580--
2581-- TOC entry 2941 (class 2606 OID 5506786)
2582-- Dependencies: 2406 2406
2583-- Name: ax_platz_pk; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
2584--
2585
2586ALTER TABLE ONLY ax_platz
2587    ADD CONSTRAINT ax_platz_pk PRIMARY KEY (ogc_fid);
2588
2589
2590--
2591-- TOC entry 2938 (class 2606 OID 5506257)
2592-- Dependencies: 2404 2404
2593-- Name: ax_punktortag_pk; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
2594--
2595
2596ALTER TABLE ONLY ax_punktortag
2597    ADD CONSTRAINT ax_punktortag_pk PRIMARY KEY (ogc_fid);
2598
2599
2600--
2601-- TOC entry 2947 (class 2606 OID 5506825)
2602-- Dependencies: 2410 2410
2603-- Name: ax_punktortau_pk; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
2604--
2605
2606ALTER TABLE ONLY ax_punktortau
2607    ADD CONSTRAINT ax_punktortau_pk PRIMARY KEY (ogc_fid);
2608
2609
2610--
2611-- TOC entry 2950 (class 2606 OID 5506890)
2612-- Dependencies: 2412 2412
2613-- Name: ax_punktortta_pk; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
2614--
2615
2616ALTER TABLE ONLY ax_punktortta
2617    ADD CONSTRAINT ax_punktortta_pk PRIMARY KEY (ogc_fid);
2618
2619
2620--
2621-- TOC entry 2986 (class 2606 OID 5511076)
2622-- Dependencies: 2440 2440
2623-- Name: ax_sicherungspunkt_pk; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
2624--
2625
2626ALTER TABLE ONLY ax_sicherungspunkt
2627    ADD CONSTRAINT ax_sicherungspunkt_pk PRIMARY KEY (ogc_fid);
2628
2629
2630--
2631-- TOC entry 2980 (class 2606 OID 5510419)
2632-- Dependencies: 2434 2434
2633-- Name: ax_sonstigervermessungspunkt_pk; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
2634--
2635
2636ALTER TABLE ONLY ax_sonstigervermessungspunkt
2637    ADD CONSTRAINT ax_sonstigervermessungspunkt_pk PRIMARY KEY (ogc_fid);
2638
2639
2640--
2641-- TOC entry 2974 (class 2606 OID 5508746)
2642-- Dependencies: 2428 2428
2643-- Name: ax_sonstigesbauwerkodersonstigeeinrichtung_pk; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
2644--
2645
2646ALTER TABLE ONLY ax_sonstigesbauwerkodersonstigeeinrichtung
2647    ADD CONSTRAINT ax_sonstigesbauwerkodersonstigeeinrichtung_pk PRIMARY KEY (ogc_fid);
2648
2649
2650--
2651-- TOC entry 2968 (class 2606 OID 5508646)
2652-- Dependencies: 2424 2424
2653-- Name: ax_sportfreizeitunderholungsflaeche_pk; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
2654--
2655
2656ALTER TABLE ONLY ax_sportfreizeitunderholungsflaeche
2657    ADD CONSTRAINT ax_sportfreizeitunderholungsflaeche_pk PRIMARY KEY (ogc_fid);
2658
2659
2660--
2661-- TOC entry 2959 (class 2606 OID 5508572)
2662-- Dependencies: 2418 2418
2663-- Name: ax_stehendesgewaesser_pk; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
2664--
2665
2666ALTER TABLE ONLY ax_stehendesgewaesser
2667    ADD CONSTRAINT ax_stehendesgewaesser_pk PRIMARY KEY (ogc_fid);
2668
2669
2670--
2671-- TOC entry 2965 (class 2606 OID 5508612)
2672-- Dependencies: 2422 2422
2673-- Name: ax_strassenverkehr_pk; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
2674--
2675
2676ALTER TABLE ONLY ax_strassenverkehr
2677    ADD CONSTRAINT ax_strassenverkehr_pk PRIMARY KEY (ogc_fid);
2678
2679
2680--
2681-- TOC entry 2971 (class 2606 OID 5508670)
2682-- Dependencies: 2426 2426
2683-- Name: ax_topographischelinie_pk; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
2684--
2685
2686ALTER TABLE ONLY ax_topographischelinie
2687    ADD CONSTRAINT ax_topographischelinie_pk PRIMARY KEY (ogc_fid);
2688
2689
2690--
2691-- TOC entry 2962 (class 2606 OID 5508590)
2692-- Dependencies: 2420 2420
2693-- Name: ax_unlandvegetationsloseflaeche_pk; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
2694--
2695
2696ALTER TABLE ONLY ax_unlandvegetationsloseflaeche
2697    ADD CONSTRAINT ax_unlandvegetationsloseflaeche_pk PRIMARY KEY (ogc_fid);
2698
2699
2700--
2701-- TOC entry 2956 (class 2606 OID 5508541)
2702-- Dependencies: 2416 2416
2703-- Name: ax_wald_pk; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
2704--
2705
2706ALTER TABLE ONLY ax_wald
2707    ADD CONSTRAINT ax_wald_pk PRIMARY KEY (ogc_fid);
2708
2709
2710--
2711-- TOC entry 2894 (class 2606 OID 5504026)
2712-- Dependencies: 2374 2374
2713-- Name: ax_weg_pk; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
2714--
2715
2716ALTER TABLE ONLY ax_weg
2717    ADD CONSTRAINT ax_weg_pk PRIMARY KEY (ogc_fid);
2718
2719
2720--
2721-- TOC entry 2953 (class 2606 OID 5508493)
2722-- Dependencies: 2414 2414
2723-- Name: ax_wohnbauflaeche_pk; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
2724--
2725
2726ALTER TABLE ONLY ax_wohnbauflaeche
2727    ADD CONSTRAINT ax_wohnbauflaeche_pk PRIMARY KEY (ogc_fid);
2728
2729
2730--
2731-- TOC entry 2873 (class 2606 OID 16791)
2732-- Dependencies: 2360 2360 2360 2360 2360
2733-- Name: geometry_columns_pk; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
2734--
2735
2736ALTER TABLE ONLY geometry_columns
2737    ADD CONSTRAINT geometry_columns_pk PRIMARY KEY (f_table_catalog, f_table_schema, f_table_name, f_geometry_column);
2738
2739
2740--
2741-- TOC entry 2871 (class 2606 OID 16783)
2742-- Dependencies: 2359 2359
2743-- Name: spatial_ref_sys_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
2744--
2745
2746ALTER TABLE ONLY spatial_ref_sys
2747    ADD CONSTRAINT spatial_ref_sys_pkey PRIMARY KEY (srid);
2748
2749
2750--
2751-- TOC entry 2900 (class 1259 OID 5504881)
2752-- Dependencies: 1998 2380
2753-- Name: ap_lpo_geom_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
2754--
2755
2756CREATE INDEX ap_lpo_geom_idx ON ap_lpo USING gist (wkb_geometry);
2757
2758
2759--
2760-- TOC entry 2903 (class 1259 OID 5505043)
2761-- Dependencies: 1998 2382
2762-- Name: ap_ppo_geom_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
2763--
2764
2765CREATE INDEX ap_ppo_geom_idx ON ap_ppo USING gist (wkb_geometry);
2766
2767
2768--
2769-- TOC entry 2897 (class 1259 OID 5504190)
2770-- Dependencies: 2378 1998
2771-- Name: ap_pto_geom_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
2772--
2773
2774CREATE INDEX ap_pto_geom_idx ON ap_pto USING gist (wkb_geometry);
2775
2776
2777--
2778-- TOC entry 2909 (class 1259 OID 5505363)
2779-- Dependencies: 1998 2386
2780-- Name: ax_bahnverkehr_geom_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
2781--
2782
2783CREATE INDEX ax_bahnverkehr_geom_idx ON ax_bahnverkehr USING gist (wkb_geometry);
2784
2785
2786--
2787-- TOC entry 2912 (class 1259 OID 5505381)
2788-- Dependencies: 1998 2388
2789-- Name: ax_bauraumoderbodenordnungsrecht_geom_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
2790--
2791
2792CREATE INDEX ax_bauraumoderbodenordnungsrecht_geom_idx ON ax_bauraumoderbodenordnungsrecht USING gist (wkb_geometry);
2793
2794
2795--
2796-- TOC entry 2915 (class 1259 OID 5505426)
2797-- Dependencies: 1998 2390
2798-- Name: ax_bauteil_geom_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
2799--
2800
2801CREATE INDEX ax_bauteil_geom_idx ON ax_bauteil USING gist (wkb_geometry);
2802
2803
2804--
2805-- TOC entry 2906 (class 1259 OID 5505145)
2806-- Dependencies: 1998 2384
2807-- Name: ax_besondereflurstuecksgrenze_geom_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
2808--
2809
2810CREATE INDEX ax_besondereflurstuecksgrenze_geom_idx ON ax_besondereflurstuecksgrenze USING gist (wkb_geometry);
2811
2812
2813--
2814-- TOC entry 2924 (class 1259 OID 5505492)
2815-- Dependencies: 1998 2396
2816-- Name: ax_besonderegebaeudelinie_geom_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
2817--
2818
2819CREATE INDEX ax_besonderegebaeudelinie_geom_idx ON ax_besonderegebaeudelinie USING gist (wkb_geometry);
2820
2821
2822--
2823-- TOC entry 2880 (class 1259 OID 5503235)
2824-- Dependencies: 1998 2366
2825-- Name: ax_bewertung_geom_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
2826--
2827
2828CREATE INDEX ax_bewertung_geom_idx ON ax_bewertung USING gist (wkb_geometry);
2829
2830
2831--
2832-- TOC entry 2877 (class 1259 OID 5503215)
2833-- Dependencies: 1998 2364
2834-- Name: ax_bodenschaetzung_geom_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
2835--
2836
2837CREATE INDEX ax_bodenschaetzung_geom_idx ON ax_bodenschaetzung USING gist (wkb_geometry);
2838
2839
2840--
2841-- TOC entry 2921 (class 1259 OID 5505475)
2842-- Dependencies: 2394 1998
2843-- Name: ax_flaechebesondererfunktionalerpraegung_geom_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
2844--
2845
2846CREATE INDEX ax_flaechebesondererfunktionalerpraegung_geom_idx ON ax_flaechebesondererfunktionalerpraegung USING gist (wkb_geometry);
2847
2848
2849--
2850-- TOC entry 2918 (class 1259 OID 5505447)
2851-- Dependencies: 1998 2392
2852-- Name: ax_flaechegemischternutzung_geom_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
2853--
2854
2855CREATE INDEX ax_flaechegemischternutzung_geom_idx ON ax_flaechegemischternutzung USING gist (wkb_geometry);
2856
2857
2858--
2859-- TOC entry 2874 (class 1259 OID 5503175)
2860-- Dependencies: 2362 1998
2861-- Name: ax_fliessgewaesser_geom_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
2862--
2863
2864CREATE INDEX ax_fliessgewaesser_geom_idx ON ax_fliessgewaesser USING gist (wkb_geometry);
2865
2866
2867--
2868-- TOC entry 2883 (class 1259 OID 5503314)
2869-- Dependencies: 1998 2368
2870-- Name: ax_flurstueck_geom_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
2871--
2872
2873CREATE INDEX ax_flurstueck_geom_idx ON ax_flurstueck USING gist (wkb_geometry);
2874
2875
2876--
2877-- TOC entry 2927 (class 1259 OID 5505708)
2878-- Dependencies: 1998 2398
2879-- Name: ax_gebaeude_geom_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
2880--
2881
2882CREATE INDEX ax_gebaeude_geom_idx ON ax_gebaeude USING gist (wkb_geometry);
2883
2884
2885--
2886-- TOC entry 2933 (class 1259 OID 5506237)
2887-- Dependencies: 1998 2402
2888-- Name: ax_gebaeudeausgestaltung_geom_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
2889--
2890
2891CREATE INDEX ax_gebaeudeausgestaltung_geom_idx ON ax_gebaeudeausgestaltung USING gist (wkb_geometry);
2892
2893
2894--
2895-- TOC entry 2930 (class 1259 OID 5506219)
2896-- Dependencies: 1998 2400
2897-- Name: ax_gehoelz_geom_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
2898--
2899
2900CREATE INDEX ax_gehoelz_geom_idx ON ax_gehoelz USING gist (wkb_geometry);
2901
2902
2903--
2904-- TOC entry 2942 (class 1259 OID 5506813)
2905-- Dependencies: 1998 2408
2906-- Name: ax_industrieundgewerbeflaeche_geom_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
2907--
2908
2909CREATE INDEX ax_industrieundgewerbeflaeche_geom_idx ON ax_industrieundgewerbeflaeche USING gist (wkb_geometry);
2910
2911
2912--
2913-- TOC entry 2989 (class 1259 OID 5511106)
2914-- Dependencies: 1998 2444
2915-- Name: ax_klassifizierungnachstrassenrecht_geom_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
2916--
2917
2918CREATE INDEX ax_klassifizierungnachstrassenrecht_geom_idx ON ax_klassifizierungnachstrassenrecht USING gist (wkb_geometry);
2919
2920
2921--
2922-- TOC entry 2889 (class 1259 OID 5504001)
2923-- Dependencies: 1998 2372
2924-- Name: ax_klassifizierungnachwasserrecht_geom_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
2925--
2926
2927CREATE INDEX ax_klassifizierungnachwasserrecht_geom_idx ON ax_klassifizierungnachwasserrecht USING gist (wkb_geometry);
2928
2929
2930--
2931-- TOC entry 2886 (class 1259 OID 5503903)
2932-- Dependencies: 1998 2370
2933-- Name: ax_landwirtschaft_geom_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
2934--
2935
2936CREATE INDEX ax_landwirtschaft_geom_idx ON ax_landwirtschaft USING gist (wkb_geometry);
2937
2938
2939--
2940-- TOC entry 2939 (class 1259 OID 5506794)
2941-- Dependencies: 1998 2406
2942-- Name: ax_platz_geom_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
2943--
2944
2945CREATE INDEX ax_platz_geom_idx ON ax_platz USING gist (wkb_geometry);
2946
2947
2948--
2949-- TOC entry 2936 (class 1259 OID 5506265)
2950-- Dependencies: 1998 2404
2951-- Name: ax_punktortag_geom_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
2952--
2953
2954CREATE INDEX ax_punktortag_geom_idx ON ax_punktortag USING gist (wkb_geometry);
2955
2956
2957--
2958-- TOC entry 2945 (class 1259 OID 5506833)
2959-- Dependencies: 2410 1998
2960-- Name: ax_punktortau_geom_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
2961--
2962
2963CREATE INDEX ax_punktortau_geom_idx ON ax_punktortau USING gist (wkb_geometry);
2964
2965
2966--
2967-- TOC entry 2948 (class 1259 OID 5506898)
2968-- Dependencies: 2412 1998
2969-- Name: ax_punktortta_geom_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
2970--
2971
2972CREATE INDEX ax_punktortta_geom_idx ON ax_punktortta USING gist (wkb_geometry);
2973
2974
2975--
2976-- TOC entry 2972 (class 1259 OID 5508754)
2977-- Dependencies: 1998 2428
2978-- Name: ax_sonstigesbauwerkodersonstigeeinrichtung_geom_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
2979--
2980
2981CREATE INDEX ax_sonstigesbauwerkodersonstigeeinrichtung_geom_idx ON ax_sonstigesbauwerkodersonstigeeinrichtung USING gist (wkb_geometry);
2982
2983
2984--
2985-- TOC entry 2966 (class 1259 OID 5508654)
2986-- Dependencies: 1998 2424
2987-- Name: ax_sportfreizeitunderholungsflaeche_geom_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
2988--
2989
2990CREATE INDEX ax_sportfreizeitunderholungsflaeche_geom_idx ON ax_sportfreizeitunderholungsflaeche USING gist (wkb_geometry);
2991
2992
2993--
2994-- TOC entry 2957 (class 1259 OID 5508580)
2995-- Dependencies: 2418 1998
2996-- Name: ax_stehendesgewaesser_geom_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
2997--
2998
2999CREATE INDEX ax_stehendesgewaesser_geom_idx ON ax_stehendesgewaesser USING gist (wkb_geometry);
3000
3001
3002--
3003-- TOC entry 2963 (class 1259 OID 5508620)
3004-- Dependencies: 2422 1998
3005-- Name: ax_strassenverkehr_geom_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
3006--
3007
3008CREATE INDEX ax_strassenverkehr_geom_idx ON ax_strassenverkehr USING gist (wkb_geometry);
3009
3010
3011--
3012-- TOC entry 2969 (class 1259 OID 5508678)
3013-- Dependencies: 1998 2426
3014-- Name: ax_topographischelinie_geom_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
3015--
3016
3017CREATE INDEX ax_topographischelinie_geom_idx ON ax_topographischelinie USING gist (wkb_geometry);
3018
3019
3020--
3021-- TOC entry 2960 (class 1259 OID 5508598)
3022-- Dependencies: 1998 2420
3023-- Name: ax_unlandvegetationsloseflaeche_geom_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
3024--
3025
3026CREATE INDEX ax_unlandvegetationsloseflaeche_geom_idx ON ax_unlandvegetationsloseflaeche USING gist (wkb_geometry);
3027
3028
3029--
3030-- TOC entry 2954 (class 1259 OID 5508549)
3031-- Dependencies: 1998 2416
3032-- Name: ax_wald_geom_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
3033--
3034
3035CREATE INDEX ax_wald_geom_idx ON ax_wald USING gist (wkb_geometry);
3036
3037
3038--
3039-- TOC entry 2892 (class 1259 OID 5504034)
3040-- Dependencies: 2374 1998
3041-- Name: ax_weg_geom_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
3042--
3043
3044CREATE INDEX ax_weg_geom_idx ON ax_weg USING gist (wkb_geometry);
3045
3046
3047--
3048-- TOC entry 2951 (class 1259 OID 5508501)
3049-- Dependencies: 1998 2414
3050-- Name: ax_wohnbauflaeche_geom_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
3051--
3052
3053CREATE INDEX ax_wohnbauflaeche_geom_idx ON ax_wohnbauflaeche USING gist (wkb_geometry);
3054
3055
3056--
3057-- TOC entry 2998 (class 0 OID 0)
3058-- Dependencies: 3
3059-- Name: public; Type: ACL; Schema: -; Owner: -
3060--
3061
3062REVOKE ALL ON SCHEMA public FROM PUBLIC;
3063REVOKE ALL ON SCHEMA public FROM postgres;
3064GRANT ALL ON SCHEMA public TO postgres;
3065GRANT ALL ON SCHEMA public TO PUBLIC;
3066
3067
3068-- Completed on 2011-05-13 15:57:00 CEST
3069
3070--
3071-- PostgreSQL database dump complete
3072--
3073
Note: See TracBrowser for help on using the repository browser.