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

Removed ortId from messprogramm query statement and result.

author	Raimund Renkert <raimund.renkert@intevation.de>
date	Mon, 30 Jan 2017 13:12:55 +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