Mercurial > gemma
changeset 80:004198a3cbc0
Set correct EPSG code.
author | Tom Gottfried <tom@intevation.de> |
---|---|
date | Thu, 31 May 2018 16:30:20 +0200 |
parents | c22ddffc2071 |
children | acaa485c0c1e |
files | wamos.sql |
diffstat | 1 files changed, 4 insertions(+), 4 deletions(-) [+] |
line wrap: on
line diff
--- a/wamos.sql Thu May 31 16:28:12 2018 +0200 +++ b/wamos.sql Thu May 31 16:30:20 2018 +0200 @@ -106,7 +106,7 @@ -- distance marks along waterway axis (see SUC7). CREATE TABLE wamos.distance_marks ( location_code isrs PRIMARY KEY, - geom geometry(POINT, 3146), + geom geometry(POINT, 4326), distance_mark_function varchar(8) REFERENCES distance_mark_functions, -- TODO: add relations to stuff provided as enumerations dummy_attrib varchar, @@ -171,7 +171,7 @@ objnam varchar, nobjnm varchar, stretch isrsrange NOT NULL, - area geometry(POLYGON, 3146) NOT NULL, + area geometry(POLYGON, 4326) NOT NULL, rb char(2) NOT NULL REFERENCES countries, -- from rb_lb in interface lb char(2) NOT NULL REFERENCES countries, -- from rb_lb in interface responsible_country char(2) NOT NULL REFERENCES countries, @@ -204,7 +204,7 @@ bottleneck_id varchar NOT NULL REFERENCES bottlenecks, date_info date NOT NULL, PRIMARY KEY (bottleneck_id, date_info), - area geometry(POLYGON, 3146) NOT NULL, + area geometry(POLYGON, 4326) NOT NULL, surtyp varchar NOT NULL REFERENCES survey_types, coverage varchar REFERENCES coverage_types, depth_reference char(3) NOT NULL REFERENCES depth_references, @@ -258,7 +258,7 @@ fairway_width smallint, fairway_radius int, CHECK(COALESCE(fairway_depth, fairway_width, fairway_radius) IS NOT NULL), - shallowest_spot geometry(POINT, 3146) + shallowest_spot geometry(POINT, 4326) ); CREATE TABLE wamos.bottleneck_pdfs (