Mercurial > gemma

comparison schema/gemma.sql @ 2589:f4c399a496cb

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Morphological differences: Add SRID to cast in ios-lines view.
author Sascha L. Teichmann <sascha.teichmann@intevation.de>
date Mon, 11 Mar 2019 18:46:09 +0100
parents 802d2a62b4bc
children 3a242e6aa56d
comparison
equal deleted inserted replaced
2588:2fcb2f969321 2589:f4c399a496cb
774 PRIMARY KEY (sounding_differences_id, height) 774 PRIMARY KEY (sounding_differences_id, height)
775 ) 775 )
776 ; 776 ;
777 777
778 CREATE VIEW waterway.sounding_differences AS SELECT 778 CREATE VIEW waterway.sounding_differences AS SELECT
779 sd.id AS id, 779 sd.id AS id,
780 bn.objnam AS objnam, 780 bn.objnam AS objnam,
781 srm.date_info AS minuend, 781 srm.date_info AS minuend,
782 srs.date_info AS subtrahend, 782 srs.date_info AS subtrahend,
783 sdcl.height AS height, 783 sdcl.height AS height,
784 sdcl.lines::geometry AS lines 784 CAST(sdcl.lines AS geometry(multilinestring, 4326)) AS lines
785 FROM 785 FROM
786 caching.sounding_differences sd JOIN 786 caching.sounding_differences sd JOIN
787 caching.sounding_differences_contour_lines sdcl ON sd.id = sdcl.sounding_differences_id JOIN 787 caching.sounding_differences_contour_lines sdcl ON sd.id = sdcl.sounding_differences_id JOIN
788 waterway.sounding_results srm ON sd.minuend = srm.id JOIN 788 waterway.sounding_results srm ON sd.minuend = srm.id JOIN
789 waterway.sounding_results srs ON sd.subtrahend = srs.id JOIN 789 waterway.sounding_results srs ON sd.subtrahend = srs.id JOIN