lada/lada-server: db_schema/stammdaten_fill_verwaltungsgrenze.sql annotate

Fixed query for messprogramme to show messprogramme without e-ort.

author	Raimund Renkert <raimund.renkert@intevation.de>
date	Thu, 02 Feb 2017 17:28:31 +0100
parents	f094aca05cf2
children

rev	line source
1249 f094aca05cf2 Avoid having to handle missing shapes. Tom Gottfried <tom@intevation.de> parents: 1188 diff changeset	1 INSERT INTO stammdaten.verwaltungsgrenze(gem_id, shape)
f094aca05cf2 Avoid having to handle missing shapes. Tom Gottfried <tom@intevation.de> parents: 1188 diff changeset	2 SELECT
1188 1bc8ab13e1f7 redesign stammdaten.verwaltungseinheit Michael Stanko <mstanko@bfs.de> parents: diff changeset	3 verwaltungseinheit.id,
1bc8ab13e1f7 redesign stammdaten.verwaltungseinheit Michael Stanko <mstanko@bfs.de> parents: diff changeset	4 gem_utm.geom
1249 f094aca05cf2 Avoid having to handle missing shapes. Tom Gottfried <tom@intevation.de> parents: 1188 diff changeset	5 FROM
1188 1bc8ab13e1f7 redesign stammdaten.verwaltungseinheit Michael Stanko <mstanko@bfs.de> parents: diff changeset	6 stammdaten.verwaltungseinheit
1249 f094aca05cf2 Avoid having to handle missing shapes. Tom Gottfried <tom@intevation.de> parents: 1188 diff changeset	7 JOIN geo.gem_utm ON verwaltungseinheit.id = gem_utm.ags;

Mercurial > lada > lada-server