Mercurial > gemma

comparison schema/gemma.sql @ 4894:8eb36d0d5bdf fairway-marks-import

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Draft implementation of fairway marks import Currently works (at least) for IENC feature BCNLAT. In order to be able to store different types of fairway marks, more tables and import types are needed. Currently stupidly stores every entry received from the data source. Sorting out duplicates and invalidating entries removed from the data source needs to implemented.
author Tom Gottfried <tom@intevation.de>
date Tue, 14 Jan 2020 15:01:42 +0100
parents 082027fb2d58
children 9f799077a3e6
comparison
equal deleted inserted replaced
4870:b55120fa8913 4894:8eb36d0d5bdf
838 OR forecast_generation_time IS NOT NULL), 838 OR forecast_generation_time IS NOT NULL),
839 value_lifetime timestamp with time zone, 839 value_lifetime timestamp with time zone,
840 CHECK(measure_type = 'minimum guaranteed' 840 CHECK(measure_type = 'minimum guaranteed'
841 OR value_lifetime IS NOT NULL) 841 OR value_lifetime IS NOT NULL)
842 ) 842 )
843
844 CREATE TABLE fairway_marks (
845 id int PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY,
846 geom geography(POINT, 4326) NOT NULL,
847 datsta varchar,
848 datend varchar,
849 persta varchar,
850 perend varchar,
851 objnam varchar,
852 nobjnm varchar,
853 inform varchar,
854 ninfom varchar,
855 scamin int,
856 picrep varchar,
857 txtdsc varchar,
858 sordat varchar,
859 sorind varchar,
860 colour varchar,
861 colpat varchar,
862 condtn int,
863 bcnshp int,
864 catlam int,
865 dirimp smallint REFERENCES dirimps
866 )
843 ; 867 ;
844 868
845 869
846 -- 870 --
847 -- Import queue and respective logging 871 -- Import queue and respective logging