changeset 5854:249b8766a178

Schema change: new column 'waterbody' for floodmaps and importer
author Tom Gottfried <tom.gottfried@intevation.de>
date Fri, 26 Apr 2013 16:50:14 +0200 (2013-04-26)
parents 774d25915eb1
children cff1eea9854f
files backend/contrib/shpimporter/uesg.py backend/doc/schema/oracle-spatial.sql backend/doc/schema/postgresql-spatial.sql
diffstat 3 files changed, 5 insertions(+), 0 deletions(-) [+]
line wrap: on
line diff
--- a/backend/contrib/shpimporter/uesg.py	Fri Apr 26 15:04:22 2013 +0200
+++ b/backend/contrib/shpimporter/uesg.py	Fri Apr 26 16:50:14 2013 +0200
@@ -80,6 +80,9 @@
         else:
             perimeter = 0
 
+        if self.IsFieldSet(feat, "GEWAESSER"):
+            newFeat.SetField("waterbody", feat.GetField("GEWAESSER"))
+
         if kind >= 200:
             newFeat.SetField("source",
                     os.path.basename(os.path.dirname(args['path'])))
--- a/backend/doc/schema/oracle-spatial.sql	Fri Apr 26 15:04:22 2013 +0200
+++ b/backend/doc/schema/oracle-spatial.sql	Fri Apr 26 16:50:14 2013 +0200
@@ -319,6 +319,7 @@
     count NUMBER(38),
     area NUMBER(19,5),
     perimeter NUMBER(19,5),
+    waterbody  VARCHAR(64),
     path     VARCHAR(256),
     source   varchar(64),
     id NUMBER PRIMARY KEY NOT NULL
--- a/backend/doc/schema/postgresql-spatial.sql	Fri Apr 26 15:04:22 2013 +0200
+++ b/backend/doc/schema/postgresql-spatial.sql	Fri Apr 26 16:50:14 2013 +0200
@@ -238,6 +238,7 @@
     count      int,
     area       FLOAT8,
     perimeter  FLOAT8,
+    waterbody  varchar(64),
     path     VARCHAR(256),
     source   varchar(64)
 );

http://dive4elements.wald.intevation.org