Changes between Version 20 and Version 21 of PostNASMapbender3
- Timestamp:
- 10/06/16 11:09:30 (8 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
PostNASMapbender3
v20 v21 98 98 l.lage AS strschl, 99 99 m.kreis::text AS kreis, 100 p.wkb_geometry 100 p.wkb_geometry AS the_geom_etrs 101 101 FROM ap_pto p 102 102 JOIN alkis_beziehungen v ON p.gml_id = v.beziehung_von … … 104 104 JOIN ax_lagebezeichnungkatalogeintrag k ON l.kreis = k.kreis AND l.gemeinde = k.gemeinde AND l.lage::text = k.lage::text 105 105 JOIN ax_gemeinde m ON l.gemeinde = m.gemeinde AND l.kreis = m.kreis 106 WHERE p.art::text = 'HNR'::text AND v.beziehungsart::text = 'dientZurDarstellungVon'::text AND p.endet IS NULL AND l.endet IS NULL; }}}106 WHERE p.art::text = 'HNR'::text AND v.beziehungsart::text = 'dientZurDarstellungVon'::text AND p.endet IS NULL AND l.endet IS NULL; 107 107 108 108 }}}