Changeset 189 for trunk/data/mapbender/http/nav/alkisnav_fls.php

Timestamp:

12/04/12 09:50:06 (11 years ago)

Author:

astrid.emde

Message:

st_x and st_y - neue Schreibweise der Funktionen für PostGIS 2.x

File:

• trunk/data/mapbender/http/nav/alkisnav_fls.php (modified) (1 diff)

trunk/data/mapbender/http/nav/alkisnav_fls.php

@@ -352 +352 @@
         $sql ="SELECT f.gml_id, f.flurnummer, f.zaehler, f.nenner, f.gemeinde, ";
         if($epsg == "25832") { // Transform nicht notwendig
-                $sql.="x(st_Centroid(f.wkb_geometry)) AS x, ";
-                $sql.="y(st_Centroid(f.wkb_geometry)) AS y ";
+                $sql.="st_x(st_Centroid(f.wkb_geometry)) AS x, ";
+                $sql.="st_y(st_Centroid(f.wkb_geometry)) AS y ";
         } else {  
-                $sql.="x(st_transform(st_Centroid(f.wkb_geometry), ".$epsg.")) AS x, ";
-                $sql.="y(st_transform(st_Centroid(f.wkb_geometry), ".$epsg.")) AS y ";                  
+                $sql.="st_x(st_transform(st_Centroid(f.wkb_geometry), ".$epsg.")) AS x, ";
+                $sql.="st_y(st_transform(st_Centroid(f.wkb_geometry), ".$epsg.")) AS y ";                       
         }
    $sql.="FROM ax_flurstueck f WHERE f.gemarkungsnummer= $1 AND f.flurnummer= $2 ";