Changeset 334 for trunk/info/info/alkis/alkisfsnw.php
- Timestamp:
- 09/15/14 17:52:35 (10 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
trunk/info/info/alkis/alkisfsnw.php
r333 r334 497 497 echo "\n</tr>"; 498 498 499 // H inweisauf Bodenneuordnung oder eine strittige Grenze500 // 499 // H i n w e i s auf Bodenneuordnung oder eine strittige Grenze 500 // b.name, b.artderfestlegung, 501 501 502 502 $sql_boden ="SELECT a.wert, a.bezeichner AS art_verf, b.gml_id AS verf_gml, b.bezeichnung AS verf_bez, … … 505 505 LEFT JOIN ax_dienststelle d ON b.stelle=d.stelle 506 506 WHERE b.endet IS NULL AND d.endet IS NULL 507 AND ST_Within((SELECT wkb_geometry FROM ax_flurstueck WHERE gml_id = $1), wkb_geometry)508 OR ST_Overlaps((SELECT wkb_geometry FROM ax_flurstueck WHERE gml_id = $1 ), wkb_geometry)";507 AND (ST_Within((SELECT wkb_geometry FROM ax_flurstueck WHERE gml_id = $1 AND endet IS NULL ), wkb_geometry) 508 OR ST_Overlaps((SELECT wkb_geometry FROM ax_flurstueck WHERE gml_id = $1 AND endet IS NULL), wkb_geometry))"; 509 509 510 510 pg_prepare($con, "bodeneuordnung", $sql_boden); … … 587 587 } 588 588 589 // Erweiterung Kreis Unna - Ende590 591 589 echo "\n</table>"; 592 590
Note: See TracChangeset
for help on using the changeset viewer.