';
?>
Resultset
3){
$sql = "SELECT area2d(GeometryFromText('MULTIPOLYGON(((";
for($i=0; $i0){$sql .= ",";}
$sql .= $posX[$i] . " " . $posY[$i];
}
$sql .= ")))',".rawurldecode($epsg).")) as myArea";
$res = db_query($sql);
if($row = db_fetch_array($res)){
echo "Fläche: ".round($row[0]*100)/100 . " m2";
}
}
else{
echo "Fläche: 0 m2";
}
}else{
#echo "Fl�chenberechnung f�r MySQL liegt derzeit nicht vor
";
#$con = db_connect($GEOS_DBSERVER,$GEOS_PORT,$GEOS_OWNER,$GEOS_PW);
#db_select_db($GEOS_DBSERVER,$con);
$con_string = "host=$GEOS_DBSERVER port=$GEOS_PORT dbname=$GEOS_DB user=$GEOS_OWNER password=$GEOS_PW";
$con = pg_connect($con_string) or die ("Error while connecting database");
if(count($posX) > 3){
$sql = "SELECT area2d(GeometryFromText('MULTIPOLYGON(((";
$i==0;
for($i=0; $i0){$sql .= ",";}
$sql .= $posX[$i] . " " . $posY[$i];
}
$sql .= ")))',".rawurldecode($epsg).")) as myArea";
$res = pg_query($con,$sql);
$cnt = 0;
while(pg_fetch_row($res)){
$area = pg_fetch_result($res,$cnt,0);
echo "Fläche: ".round($area*100)/100 . " m2";
$cnt++;
}
}
else{
echo "Fläche: 0 m2";
}
}
echo "
";
echo "Umfang: ". htmlentities($length,ENT_QUOTES) . " m";
#Centroid(geometry)
/*
$sql = "SELECT Centroid(GeometryFromText('MULTIPOLYGON(((";
for($i=0; $i0){$sql .= ",";}
$sql .= $posX[$i] . " " . $posY[$i];
}
$sql .= ")))',".rawurldecode($epsg).")) as myCentroid";
$res = db_query($con,$sql);
if(db_fetch_row($res)){
echo "Zentrum: ".db_result($res,0,"myCentroid");
}
*/
#box3d(geometry)
/*
$sql = "SELECT box3d(GeometryFromText('MULTIPOLYGON(((";
for($i=0; $i0){$sql .= ",";}
$sql .= $posX[$i] . " " . $posY[$i];
}
$sql .= ")))',".rawurldecode($epsg).")) as myBox";
$res = db_query($sql);
if(db_fetch_row($res)){
echo "Aussen: ".db_result($res,0,"myBox");
}
*/
?>