annotate db_schema/stammdaten_fill_verwaltungsgrenze.sql @ 1195:768a4c957a18

Added ort factory to generate and find attributes, updated model.
author Raimund Renkert <raimund.renkert@intevation.de>
date Tue, 29 Nov 2016 15:59:38 +0100
parents 1bc8ab13e1f7
children f094aca05cf2
rev   line source
1188
1bc8ab13e1f7 redesign stammdaten.verwaltungseinheit
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
1 insert into stammdaten.verwaltungsgrenze(gem_id, shape)
1bc8ab13e1f7 redesign stammdaten.verwaltungseinheit
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
2 SELECT
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
1bc8ab13e1f7 redesign stammdaten.verwaltungseinheit
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
5 FROM
1bc8ab13e1f7 redesign stammdaten.verwaltungseinheit
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
6 stammdaten.verwaltungseinheit
1bc8ab13e1f7 redesign stammdaten.verwaltungseinheit
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
7 left 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)