view db_schema/stammdaten_fill_verwaltungsgrenze.sql @ 1292:588f6deae24a

Fix authorization for OrtszuordnungMp and friends. Setting readonly equal to owner implied an owner cannot edit its own objects. That was probably not intended. As many of the conditionals actually evaluated to doing nothing, those were removed.
author Tom Gottfried <tom@intevation.de>
date Wed, 08 Feb 2017 19:56:01 +0100
parents f094aca05cf2
children
line wrap: on
line source
INSERT INTO stammdaten.verwaltungsgrenze(gem_id, shape)
SELECT
  verwaltungseinheit.id,
  gem_utm.geom
FROM
  stammdaten.verwaltungseinheit
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)