Mercurial > dive4elements > river
diff flys-backend/doc/schema/postgresql-spatial.sql @ 5137:04eb62eae722
River Axes and HWS_lines are now multiline
author | Andre Heinecke <aheinecke@intevation.de> |
---|---|
date | Thu, 28 Feb 2013 12:58:25 +0100 |
parents | e4cc9aebfcf1 |
children | d4fdd98a04f7 |
line wrap: on
line diff
--- a/flys-backend/doc/schema/postgresql-spatial.sql Thu Feb 28 12:48:27 2013 +0100 +++ b/flys-backend/doc/schema/postgresql-spatial.sql Thu Feb 28 12:58:25 2013 +0100 @@ -9,7 +9,7 @@ name VARCHAR(64), path VARCHAR(256) ); -SELECT AddGeometryColumn('river_axes', 'geom', 31467, 'LINESTRING', 2); +SELECT AddGeometryColumn('river_axes', 'geom', 31467, 'MULTILINESTRING', 2); ALTER TABLE river_axes ALTER COLUMN id SET DEFAULT NEXTVAL('RIVER_AXES_ID_SEQ'); @@ -152,7 +152,7 @@ status_date TIMESTAMP, description VARCHAR(256) ); -SELECT AddGeometryColumn('hws_lines', 'geom', 31467, 'LINESTRING', 3); +SELECT AddGeometryColumn('hws_lines', 'geom', 31467, 'MULTILINESTRING', 3); -- TODO: dike_km_from dike_km_to, are they geometries? ALTER TABLE hws_lines ALTER COLUMN id SET DEFAULT NEXTVAL('HWS_LINES_ID_SEQ');