Changeset 188 for trunk

Timestamp:

12/04/12 09:47:16 (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_adr.php (modified) (3 diffs)

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

@@ -192 +192 @@
                         $sqlko ="SELECT ";              
                         if($epsg == "25832") { // Transform nicht notwendig
-                                $sqlko.="x(st_Centroid(f.wkb_geometry)) AS x, ";
-                                $sqlko.="y(st_Centroid(f.wkb_geometry)) AS y ";
+                                $sqlko.="st_x(st_Centroid(f.wkb_geometry)) AS x, ";
+                                $sqlko.="st_y(st_Centroid(f.wkb_geometry)) AS y ";
                         } else {  
-                                $sqlko.="x(st_transform(st_Centroid(f.wkb_geometry), ".$epsg.")) AS x, ";
-                                $sqlko.="y(st_transform(st_Centroid(f.wkb_geometry), ".$epsg.")) AS y ";                        
+                                $sqlko.="st_x(st_transform(st_Centroid(f.wkb_geometry), ".$epsg.")) AS x, ";
+                                $sqlko.="st_y(st_transform(st_Centroid(f.wkb_geometry), ".$epsg.")) AS y ";                     
                         }
                         $sqlko.="FROM ax_lagebezeichnungohnehausnummer o ";
@@ -245 +245 @@
                 
                 if($epsg == "25832") { // Transform nicht notwendig
-                        $sql.="x(st_Centroid(g.wkb_geometry)) AS x, ";
-                        $sql.="y(st_Centroid(g.wkb_geometry)) AS y ";           
+                        $sql.="st_x(st_Centroid(g.wkb_geometry)) AS x, ";
+                        $sql.="st_y(st_Centroid(g.wkb_geometry)) AS y ";                
                 }
                 else {  
-                        $sql.="x(st_transform(st_Centroid(g.wkb_geometry), ".$epsg.")) AS x, ";
-                        $sql.="y(st_transform(st_Centroid(g.wkb_geometry), ".$epsg.")) AS y ";          
+                        $sql.="st_x(st_transform(st_Centroid(g.wkb_geometry), ".$epsg.")) AS x, ";
+                        $sql.="st_y(st_transform(st_Centroid(g.wkb_geometry), ".$epsg.")) AS y ";               
                 }               
                 $sql.="FROM ax_lagebezeichnungmithausnummer h ";
@@ -295 +295 @@
                         $sql ="SELECT gml_id, replace (schriftinhalt, ' ','') AS hsnr, ";
                         if($epsg == "25832") { // Transform nicht notwendig
-                                $sql.="x(wkb_geometry) AS x, ";
-                                $sql.="y(wkb_geometry) AS y ";          
+                                $sql.="st_x(wkb_geometry) AS x, ";
+                                $sql.="st_y(wkb_geometry) AS y ";               
                         }
                         else {  
-                                $sql.="x(st_transform(wkb_geometry), ".$epsg.")) AS x, ";
-                                $sql.="y(st_transform(wkb_geometry), ".$epsg.")) AS y ";                
+                                $sql.="st_x(st_transform(wkb_geometry), ".$epsg.")) AS x, ";
+                                $sql.="st_y(st_transform(wkb_geometry), ".$epsg.")) AS y ";             
                         }               
                         $sql.="from ap_pto where ";