Changeset 189 for trunk/data
- Timestamp:
- 12/04/12 09:50:06 (11 years ago)
- Location:
- trunk/data/mapbender/http/nav
- Files:
-
- 3 edited
Legend:
- Unmodified
- Added
- Removed
-
trunk/data/mapbender/http/nav/alkisnav_eig.php
r140 r189 210 210 $sql1 ="SELECT s1.laufendenummer AS lfd, f.gml_id, f.flurnummer, f.zaehler, f.nenner, f.gemeinde, "; 211 211 if($epsg == "25832") { // Transform nicht notwendig 212 $sql1.=" x(st_centroid(f.wkb_geometry)) AS x, ";213 $sql1.=" y(st_centroid(f.wkb_geometry)) AS y, ";212 $sql1.="st_x(st_centroid(f.wkb_geometry)) AS x, "; 213 $sql1.="st_y(st_centroid(f.wkb_geometry)) AS y, "; 214 214 } else { 215 $sql1.=" x(st_transform(st_centroid(f.wkb_geometry), ".$epsg.")) AS x, ";216 $sql1.=" y(st_transform(st_centroid(f.wkb_geometry), ".$epsg.")) AS y, ";215 $sql1.="st_x(st_transform(st_centroid(f.wkb_geometry), ".$epsg.")) AS x, "; 216 $sql1.="st_y(st_transform(st_centroid(f.wkb_geometry), ".$epsg.")) AS y, "; 217 217 } 218 218 $sql1.="g.gemarkungsnummer, g.bezeichnung "; -
trunk/data/mapbender/http/nav/alkisnav_fls.php
r140 r189 352 352 $sql ="SELECT f.gml_id, f.flurnummer, f.zaehler, f.nenner, f.gemeinde, "; 353 353 if($epsg == "25832") { // Transform nicht notwendig 354 $sql.=" x(st_Centroid(f.wkb_geometry)) AS x, ";355 $sql.=" y(st_Centroid(f.wkb_geometry)) AS y ";354 $sql.="st_x(st_Centroid(f.wkb_geometry)) AS x, "; 355 $sql.="st_y(st_Centroid(f.wkb_geometry)) AS y "; 356 356 } else { 357 $sql.=" x(st_transform(st_Centroid(f.wkb_geometry), ".$epsg.")) AS x, ";358 $sql.=" y(st_transform(st_Centroid(f.wkb_geometry), ".$epsg.")) AS y ";357 $sql.="st_x(st_transform(st_Centroid(f.wkb_geometry), ".$epsg.")) AS x, "; 358 $sql.="st_y(st_transform(st_Centroid(f.wkb_geometry), ".$epsg.")) AS y "; 359 359 } 360 360 $sql.="FROM ax_flurstueck f WHERE f.gemarkungsnummer= $1 AND f.flurnummer= $2 "; -
trunk/data/mapbender/http/nav/alkisnav_grd.php
r154 r189 454 454 $sql ="SELECT t.gemeinde, g.bezeichnung, f.gml_id, f.flurnummer, f.zaehler, f.nenner, "; 455 455 if($epsg == "25832") { // Transform nicht notwendig 456 $sql.=" x(st_Centroid(f.wkb_geometry)) AS x, ";457 $sql.=" y(st_Centroid(f.wkb_geometry)) AS y ";456 $sql.="st_x(st_Centroid(f.wkb_geometry)) AS x, "; 457 $sql.="st_y(st_Centroid(f.wkb_geometry)) AS y "; 458 458 } else { 459 $sql.=" x(st_transform(st_Centroid(f.wkb_geometry),".$epsg.")) AS x, ";460 $sql.=" y(st_transform(st_Centroid(f.wkb_geometry),".$epsg.")) AS y ";459 $sql.="st_x(st_transform(st_Centroid(f.wkb_geometry),".$epsg.")) AS x, "; 460 $sql.="st_y(st_transform(st_Centroid(f.wkb_geometry),".$epsg.")) AS y "; 461 461 } 462 462 $sql.="FROM ax_gemarkung g ";
Note: See TracChangeset
for help on using the changeset viewer.