diff db_schema/stammdaten_schema.sql @ 1056:299f4ba86090

extend docker envireoment to load geographical data of german comunities
author Michael Stanko <mstanko@bfs.de>
date Wed, 28 Sep 2016 09:06:18 +0200
parents 5efb32a41b24
children effef57f3f7e
line wrap: on
line diff
--- a/db_schema/stammdaten_schema.sql	Wed Sep 28 08:48:04 2016 +0200
+++ b/db_schema/stammdaten_schema.sql	Wed Sep 28 09:06:18 2016 +0200
@@ -231,37 +231,6 @@
 
 ALTER SEQUENCE datensatz_erzeuger_id_seq OWNED BY datensatz_erzeuger.id;
 
-
-CREATE SEQUENCE de_vg_id_seq
-    START WITH 1
-    INCREMENT BY 1
-    NO MINVALUE
-    NO MAXVALUE
-    CACHE 1;
-
-CREATE TABLE de_vg (
-    id integer PRIMARY KEY DEFAULT nextval('de_vg_id_seq'::regclass),
-    use double precision,
-    rs character varying(12),
-    gf double precision,
-    rau_rs character varying(12),
-    gen character varying(50),
-    des character varying(75),
-    isn double precision,
-    bemerk character varying(75),
-    nambild character varying(16),
-    ags character varying(12),
-    rs_alt character varying(20),
-    wirksamkei date,
-    debkg_id character varying(16),
-    length numeric,
-    shape_area numeric,
-    geom public.geometry(MultiPolygon,4326)
-);
-
-ALTER SEQUENCE de_vg_id_seq OWNED BY de_vg.id;
-
-
 CREATE TABLE deskriptor_umwelt (
     id integer PRIMARY KEY,
     s00 integer NOT NULL,
@@ -809,9 +778,6 @@
     ADD CONSTRAINT umwelt_umwelt_bereich_key UNIQUE (umwelt_bereich);
 
 
-CREATE INDEX de_vg_geom_gist ON de_vg USING gist (geom);
-
-
 CREATE INDEX fts_stauts_kooin10001 ON staat USING btree (kda_id);
 
 
This site is hosted by Intevation GmbH (Datenschutzerklärung und Impressum | Privacy Policy and Imprint)