view db_schema/stammdaten_fill_verwaltungsgrenze.sql @ 1244:86ef81592f67

Implement negation of query filter closer to underlying API. Previously andNot() negated the whole filter and it's usage in IsUnique was actually a misunderstanding. Having not() as in javax.persistence.criteria.Predicate seems to be more intuitive for negating the whole filter and more flexible.
author Tom Gottfried <tom@intevation.de>
date Fri, 16 Dec 2016 12:06:34 +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)