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

Check for entnahmeOrt in messprogramm and add error if missing.

author	Raimund Renkert <raimund.renkert@intevation.de>
date	Fri, 27 Jan 2017 16:12:52 +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