annotate db_schema/stammdaten_fill_verwaltungsgrenze.sql @ 1279:bbfb7c3b5dd8

Add warning to existing client-side fields.
author Tom Gottfried <tom@intevation.de>
date Thu, 02 Feb 2017 17:32:30 +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;
This site is hosted by Intevation GmbH (Datenschutzerklärung und Impressum | Privacy Policy and Imprint)