[Mapbender-commits] r8345 - trunk/mapbender/http/geoportal

[svn_mapbender at osgeo.org]

Author: armin11
Date: 2012-05-10 21:25:13 -0700 (Thu, 10 May 2012)
New Revision: 8345

Modified:
   trunk/mapbender/http/geoportal/gaz_geom.php
Log:
Adoption for geoportal to search in utm32.

Modified: trunk/mapbender/http/geoportal/gaz_geom.php
===================================================================
--- trunk/mapbender/http/geoportal/gaz_geom.php	2012-05-11 04:24:05 UTC (rev 8344)
+++ trunk/mapbender/http/geoportal/gaz_geom.php	2012-05-11 04:25:13 UTC (rev 8345)
@@ -194,7 +194,7 @@
 				$sql .= "(ymax(the_geom) + ".$bufferSTR.") as maxy ";                       
 				$sql .= "FROM strassenschluessel WHERE gem_schl = $1 ";
 				$sql .= " AND (strassenname_upper LIKE $2)";
-				if (isset($epsg) && is_numeric($epsg) && intval($epsg) != 31466) {
+				if (isset($epsg) && is_numeric($epsg) && intval($epsg) != 25832) {
 					$sql = str_replace("the_geom", "transform(the_geom,".$epsg.")", $sql);
 				}				
 				$res = db_prep_query($sql,$v,$t);
@@ -288,7 +288,7 @@
 					array_push($t,'i');
 				}
 				$sql .= ")";
-				if (isset($epsg) && is_numeric($epsg) && intval($epsg) != 31466) {
+				if (isset($epsg) && is_numeric($epsg) && intval($epsg) != 25832) {
 					$sql = str_replace("the_geom", "transform(the_geom,".$epsg.")", $sql);
 				}				
 
@@ -343,7 +343,7 @@
 			array_push($t,'s');
 		}
 		#$sql .= " GROUP BY the_geom, name, hausnummer, zusatz, plz, post_ortsname";	
-		if (isset($epsg) && is_numeric($epsg) && intval($epsg) != 31466) {
+		if (isset($epsg) && is_numeric($epsg) && intval($epsg) != 25832) {
 			$sql = str_replace("the_geom", "transform(the_geom,".$epsg.")", $sql);
 		}				
 		$res = db_prep_query($sql,$v,$t);
@@ -394,7 +394,7 @@
 		array_push($t,'s');
 	}
 	$sql .= "GROUP BY the_geom, gemeinde_gem_teile, gem_schl_neu, postleitzahl";	
-	if (isset($epsg) && is_numeric($epsg) && intval($epsg) != 31466) {
+	if (isset($epsg) && is_numeric($epsg) && intval($epsg) != 25832) {
 		$sql = str_replace("the_geom", "transform(the_geom,".$epsg.")", $sql);
 	}				
 	$res = db_prep_query($sql,$v,$t);
@@ -430,7 +430,7 @@
 		array_push($t,'i');
 	}
 	$sql .= ") GROUP BY the_geom, gemeinde";
-	if (isset($epsg) && is_numeric($epsg) && intval($epsg) != 31466) {
+	if (isset($epsg) && is_numeric($epsg) && intval($epsg) != 25832) {
 		$sql = str_replace("the_geom", "transform(the_geom,".$epsg.")", $sql);
 	}				
 	$res = db_prep_query($sql,$v,$t);
@@ -450,7 +450,7 @@
 	$sql .= "(ymax(the_geom) + ".$bufferG.") as maxy ";
 	$sql .= "FROM gemeinden WHERE gemeinde_upper ILIKE $1 ";
 	#$sql .= "GROUP BY the_geom, gemeinde, gem_schl_neu";
-	if (isset($epsg) && is_numeric($epsg) && intval($epsg) != 31466) {
+	if (isset($epsg) && is_numeric($epsg) && intval($epsg) != 25832) {
 		$sql = str_replace("the_geom", "transform(the_geom,".$epsg.")", $sql);
 	}				
 	$v = array("%".$str."%");
@@ -473,7 +473,7 @@
 	$sql .= "(xmax(the_geom)+".$bufferK.") as maxx, ";
 	$sql .= "(ymax(the_geom)+".$bufferK.") as maxy ";
 	$sql .= "FROM kreis_fl WHERE kreis_upper ILIKE $1 ";
-	if (isset($epsg) && is_numeric($epsg) && intval($epsg) != 31466) {
+	if (isset($epsg) && is_numeric($epsg) && intval($epsg) != 25832) {
 		$sql = str_replace("the_geom", "transform(the_geom,".$epsg.")", $sql);
 	}				
 	$v = array("%".$str."%");
@@ -493,7 +493,7 @@
 	$sql .= "(xmax(the_geom)+".$bufferV.") as maxx, ";
 	$sql .= "(ymax(the_geom)+".$bufferV.") as maxy ";
 	$sql .= "FROM vg_fl WHERE vg ILIKE $1 ";
-	if (isset($epsg) && is_numeric($epsg) && intval($epsg) != 31466) {
+	if (isset($epsg) && is_numeric($epsg) && intval($epsg) != 25832) {
 		$sql = str_replace("the_geom", "transform(the_geom,".$epsg.")", $sql);
 	}				
 	$v = array("%".$str."%");