From: gemo1011 Date: Thu, 14 Jun 2018 12:39:51 +0000 (+0200) Subject: fixed getoutlines function if no coordinates are passed X-Git-Tag: v3.2.0~60^2~12 X-Git-Url: https://git.openstreetmap.org./nominatim.git/commitdiff_plain/41249377d25c9c0df1855c6750f9b9e21a16a650 fixed getoutlines function if no coordinates are passed --- diff --git a/lib/PlaceLookup.php b/lib/PlaceLookup.php index ca7a48cf..7620ac0d 100644 --- a/lib/PlaceLookup.php +++ b/lib/PlaceLookup.php @@ -555,7 +555,11 @@ class PlaceLookup if ($this->bIncludePolygonAsKML) $sSQL .= ',ST_AsKML(geometry) as askml'; if ($this->bIncludePolygonAsSVG) $sSQL .= ',ST_AsSVG(geometry) as assvg'; if ($this->bIncludePolygonAsText || $this->bIncludePolygonAsPoints) $sSQL .= ',ST_AsText(geometry) as astext'; - $sFrom = ' from (SELECT * , ST_ClosestPoint(geometry, ST_SetSRID(ST_Point('.$fLatReverse.','.$fLonReverse.'),4326)) AS closest_point'; + if ($fLonReverse != null && $fLatReverse != null) { + $sFrom = ' from (SELECT * , ST_ClosestPoint(geometry, ST_SetSRID(ST_Point('.$fLatReverse.','.$fLonReverse.'),4326)) AS closest_point'; + } else { + $sFrom = $sFrom = ' from placex where place_id = '.$iPlaceID; + } $sFrom .= ' from placex where place_id = '.$iPlaceID.') as plx'; if ($this->fPolygonSimplificationThreshold > 0) { $sSQL .= ' from (select place_id,centroid,ST_SimplifyPreserveTopology(geometry,'.$this->fPolygonSimplificationThreshold.') as geometry'.$sFrom.') as plx';