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

Graft some improvements to dockerised PostgreSQL from rev ea6b062e5305.

author	Tom Gottfried <tom@intevation.de>
date	Mon, 27 Mar 2017 15:25:27 +0200
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