Changeset 189 for trunk/data/mapbender/http/nav/alkisnav_grd.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_grd.php (modified) (1 diff)

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

@@ -454 +454 @@
         $sql ="SELECT t.gemeinde, g.bezeichnung, f.gml_id, f.flurnummer, f.zaehler, f.nenner, ";
         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_gemarkung g ";