Mercurial > gemma

comparison schema/gemma.sql @ 4579:4c56682f83f7 iso-areas

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Adjusted templating for iso areas.
author Sascha L. Teichmann <sascha.teichmann@intevation.de>
date Tue, 08 Oct 2019 13:02:21 +0200
parents c657dec6b0fa
children 30bb2d819d57
comparison
equal deleted inserted replaced
4578:c657dec6b0fa 4579:4c56682f83f7
688 EXECUTE FUNCTION check_valid_bottleneck_ts('bottleneck_id','date_info') 688 EXECUTE FUNCTION check_valid_bottleneck_ts('bottleneck_id','date_info')
689 CREATE CONSTRAINT TRIGGER b_sounding_results_in_bn_area 689 CREATE CONSTRAINT TRIGGER b_sounding_results_in_bn_area
690 AFTER INSERT OR UPDATE ON sounding_results 690 AFTER INSERT OR UPDATE ON sounding_results
691 FOR EACH ROW EXECUTE FUNCTION check_sr_in_bn_area() 691 FOR EACH ROW EXECUTE FUNCTION check_sr_in_bn_area()
692 692
693 CREATE TABLE sounding_results_contour_lines (
694 sounding_result_id int NOT NULL REFERENCES sounding_results
695 ON DELETE CASCADE,
696 height numeric NOT NULL,
697 lines geography(multilinestring, 4326) NOT NULL,
698 -- TODO: generate valid simple features and add constraint:
699 -- CHECK(ST_IsSimple(CAST(lines AS geometry))),
700 PRIMARY KEY (sounding_result_id, height)
701 )
702
703 CREATE TABLE sounding_results_iso_areas ( 693 CREATE TABLE sounding_results_iso_areas (
704 sounding_result_id int NOT NULL REFERENCES sounding_results 694 sounding_result_id int NOT NULL REFERENCES sounding_results
705 ON DELETE CASCADE, 695 ON DELETE CASCADE,
706 height numeric NOT NULL, 696 height numeric NOT NULL,
707 areas geography(MULTIPOLYGON, 4326) NOT NULL, 697 areas geography(MULTIPOLYGON, 4326) NOT NULL,