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

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

@@ -210 +210 @@
         $sql1 ="SELECT s1.laufendenummer AS lfd, f.gml_id, f.flurnummer, f.zaehler, f.nenner, f.gemeinde, ";
         if($epsg == "25832") { // Transform nicht notwendig
-                $sql1.="x(st_centroid(f.wkb_geometry)) AS x, ";
-                $sql1.="y(st_centroid(f.wkb_geometry)) AS y, ";
+                $sql1.="st_x(st_centroid(f.wkb_geometry)) AS x, ";
+                $sql1.="st_y(st_centroid(f.wkb_geometry)) AS y, ";
         } else {  
-                $sql1.="x(st_transform(st_centroid(f.wkb_geometry), ".$epsg.")) AS x, ";
-                $sql1.="y(st_transform(st_centroid(f.wkb_geometry), ".$epsg.")) AS y, ";                        
+                $sql1.="st_x(st_transform(st_centroid(f.wkb_geometry), ".$epsg.")) AS x, ";
+                $sql1.="st_y(st_transform(st_centroid(f.wkb_geometry), ".$epsg.")) AS y, ";                     
         }
         $sql1.="g.gemarkungsnummer, g.bezeichnung ";