Ignore:
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

Location:
trunk/data/mapbender/http/nav
Files:
3 edited

Legend:

Unmodified
Added
Removed
  • trunk/data/mapbender/http/nav/alkisnav_eig.php

    r140 r189  
    210210        $sql1 ="SELECT s1.laufendenummer AS lfd, f.gml_id, f.flurnummer, f.zaehler, f.nenner, f.gemeinde, "; 
    211211        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, "; 
    214214        } 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, ";                      
    217217        } 
    218218        $sql1.="g.gemarkungsnummer, g.bezeichnung "; 
  • trunk/data/mapbender/http/nav/alkisnav_fls.php

    r140 r189  
    352352        $sql ="SELECT f.gml_id, f.flurnummer, f.zaehler, f.nenner, f.gemeinde, "; 
    353353        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 "; 
    356356        } 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 ";                        
    359359        } 
    360360   $sql.="FROM ax_flurstueck f WHERE f.gemarkungsnummer= $1 AND f.flurnummer= $2 "; 
  • trunk/data/mapbender/http/nav/alkisnav_grd.php

    r154 r189  
    454454        $sql ="SELECT t.gemeinde, g.bezeichnung, f.gml_id, f.flurnummer, f.zaehler, f.nenner, "; 
    455455        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 "; 
    458458        } 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 ";                         
    461461        } 
    462462        $sql.="FROM ax_gemarkung g "; 
Note: See TracChangeset for help on using the changeset viewer.