Mercurial > gemma

view schema/updates/1314/01.fix_sr_dateinfo.sql @ 5095:e21cbb9768a2

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Prevent duplicate fairway areas In principal, there can be only one or no fairway area at each point on the map. Since polygons from real data will often be topologically inexact, just disallow equal geometries. This will also help to avoid importing duplicates with concurrent imports, once the history of fairway dimensions will be preserved.
author Tom Gottfried <tom@intevation.de>
date Wed, 25 Mar 2020 18:10:02 +0100
parents 3a8ec3c396e0
children
line wrap: on
line source

UPDATE sys_admin.published_services SET view_def = $$
        SELECT bottleneck_id,
            to_char(date_info, 'YYYY-MM-DD') AS date_info,
            height,
            areas,
            surtyp
        FROM waterway.sounding_results_iso_areas ia
            JOIN waterway.sounding_results sr ON sr.id = ia.sounding_result_id
    $$ WHERE name = 'sounding_results_areas_geoserver';