--- 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 (