view db_schema/stammdaten_fill_verwaltungsgrenze.sql @ 1191:3923b41f8783

reorganize db setup
author Michael Stanko <mstanko@bfs.de>
date Fri, 25 Nov 2016 22:25:13 +0100
parents 1bc8ab13e1f7
children f094aca05cf2
line wrap: on
line source
insert into stammdaten.verwaltungsgrenze(gem_id, shape)
SELECT 
  verwaltungseinheit.id,
  gem_utm.geom
FROM 
  stammdaten.verwaltungseinheit
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)