diff db_schema/stammdaten_schema.sql @ 1194:289edf060550

Removed table de_vg and added verwaltungsgrenze.
author Raimund Renkert <raimund.renkert@intevation.de>
date Tue, 29 Nov 2016 15:57:09 +0100
parents 1bc8ab13e1f7
children 9dda1237c756
line wrap: on
line diff
--- a/db_schema/stammdaten_schema.sql	Tue Nov 29 15:54:48 2016 +0100
+++ b/db_schema/stammdaten_schema.sql	Tue Nov 29 15:57:09 2016 +0100
@@ -167,7 +167,7 @@
 CREATE TABLE verwaltungsgrenze (
     id serial PRIMARY KEY,
     gem_id character varying(8) NOT NULL,
-    shape public.geometry(MultiPolygon)
+    shape public.geometry(MultiPolygon, 4326)
 );
 
 CREATE TABLE netz_betreiber (
@@ -236,26 +236,6 @@
 );
 CREATE TRIGGER letzte_aenderung_datensatz_erzeuger BEFORE UPDATE ON datensatz_erzeuger FOR EACH ROW EXECUTE PROCEDURE update_letzte_aenderung();
 
-CREATE TABLE de_vg (
-    id serial PRIMARY KEY,
-    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)
-);
-
 
 CREATE TABLE deskriptor_umwelt (
     id serial PRIMARY KEY,
This site is hosted by Intevation GmbH (Datenschutzerklärung und Impressum | Privacy Policy and Imprint)