6 protected $aLangPrefOrder = array();
8 protected $bIncludeAddressDetails = false;
10 protected $bIncludePolygonAsPoints = false;
11 protected $bIncludePolygonAsText = false;
12 protected $bIncludePolygonAsGeoJSON = false;
13 protected $bIncludePolygonAsKML = false;
14 protected $bIncludePolygonAsSVG = false;
16 protected $aExcludePlaceIDs = array();
17 protected $bDeDupe = true;
18 protected $bReverseInPlan = true;
20 protected $iLimit = 20;
21 protected $iFinalLimit = 10;
22 protected $iOffset = 0;
23 protected $bFallback = false;
25 protected $aCountryCodes = false;
26 protected $aNearPoint = false;
28 protected $bBoundedSearch = false;
29 protected $aViewBox = false;
30 protected $sViewboxSmallSQL = false;
31 protected $sViewboxLargeSQL = false;
32 protected $aRoutePoints = false;
34 protected $iMaxRank = 20;
35 protected $iMinAddressRank = 0;
36 protected $iMaxAddressRank = 30;
37 protected $aAddressRankList = array();
38 protected $exactMatchCache = array();
40 protected $sAllowedTypesSQLList = false;
42 protected $sQuery = false;
43 protected $aStructuredQuery = false;
45 function Geocode(&$oDB)
50 function setReverseInPlan($bReverse)
52 $this->bReverseInPlan = $bReverse;
55 function setLanguagePreference($aLangPref)
57 $this->aLangPrefOrder = $aLangPref;
60 function setIncludeAddressDetails($bAddressDetails = true)
62 $this->bIncludeAddressDetails = (bool)$bAddressDetails;
65 function getIncludeAddressDetails()
67 return $this->bIncludeAddressDetails;
70 function setIncludePolygonAsPoints($b = true)
72 $this->bIncludePolygonAsPoints = $b;
75 function getIncludePolygonAsPoints()
77 return $this->bIncludePolygonAsPoints;
80 function setIncludePolygonAsText($b = true)
82 $this->bIncludePolygonAsText = $b;
85 function getIncludePolygonAsText()
87 return $this->bIncludePolygonAsText;
90 function setIncludePolygonAsGeoJSON($b = true)
92 $this->bIncludePolygonAsGeoJSON = $b;
95 function setIncludePolygonAsKML($b = true)
97 $this->bIncludePolygonAsKML = $b;
100 function setIncludePolygonAsSVG($b = true)
102 $this->bIncludePolygonAsSVG = $b;
105 function setDeDupe($bDeDupe = true)
107 $this->bDeDupe = (bool)$bDeDupe;
110 function setLimit($iLimit = 10)
112 if ($iLimit > 50) $iLimit = 50;
113 if ($iLimit < 1) $iLimit = 1;
115 $this->iFinalLimit = $iLimit;
116 $this->iLimit = $this->iFinalLimit + min($this->iFinalLimit, 10);
119 function setOffset($iOffset = 0)
121 $this->iOffset = $iOffset;
124 function setFallback($bFallback = true)
126 $this->bFallback = (bool)$bFallback;
129 function setExcludedPlaceIDs($a)
131 // TODO: force to int
132 $this->aExcludePlaceIDs = $a;
135 function getExcludedPlaceIDs()
137 return $this->aExcludePlaceIDs;
140 function setBounded($bBoundedSearch = true)
142 $this->bBoundedSearch = (bool)$bBoundedSearch;
145 function setViewBox($fLeft, $fBottom, $fRight, $fTop)
147 $this->aViewBox = array($fLeft, $fBottom, $fRight, $fTop);
150 function getViewBoxString()
152 if (!$this->aViewBox) return null;
153 return $this->aViewBox[0].','.$this->aViewBox[3].','.$this->aViewBox[2].','.$this->aViewBox[1];
156 function setRoute($aRoutePoints)
158 $this->aRoutePoints = $aRoutePoints;
161 function setFeatureType($sFeatureType)
163 switch($sFeatureType)
166 $this->setRankRange(4, 4);
169 $this->setRankRange(8, 8);
172 $this->setRankRange(14, 16);
175 $this->setRankRange(8, 20);
180 function setRankRange($iMin, $iMax)
182 $this->iMinAddressRank = (int)$iMin;
183 $this->iMaxAddressRank = (int)$iMax;
186 function setNearPoint($aNearPoint, $fRadiusDeg = 0.1)
188 $this->aNearPoint = array((float)$aNearPoint[0], (float)$aNearPoint[1], (float)$fRadiusDeg);
191 function setCountryCodesList($aCountryCodes)
193 $this->aCountryCodes = $aCountryCodes;
196 function setQuery($sQueryString)
198 $this->sQuery = $sQueryString;
199 $this->aStructuredQuery = false;
202 function getQueryString()
204 return $this->sQuery;
208 function loadParamArray($aParams)
210 if (isset($aParams['addressdetails'])) $this->bIncludeAddressDetails = (bool)$aParams['addressdetails'];
211 if (isset($aParams['bounded'])) $this->bBoundedSearch = (bool)$aParams['bounded'];
212 if (isset($aParams['dedupe'])) $this->bDeDupe = (bool)$aParams['dedupe'];
214 if (isset($aParams['limit'])) $this->setLimit((int)$aParams['limit']);
215 if (isset($aParams['offset'])) $this->iOffset = (int)$aParams['offset'];
217 if (isset($aParams['fallback'])) $this->bFallback = (bool)$aParams['fallback'];
219 // List of excluded Place IDs - used for more acurate pageing
220 if (isset($aParams['exclude_place_ids']) && $aParams['exclude_place_ids'])
222 foreach(explode(',',$aParams['exclude_place_ids']) as $iExcludedPlaceID)
224 $iExcludedPlaceID = (int)$iExcludedPlaceID;
225 if ($iExcludedPlaceID) $aExcludePlaceIDs[$iExcludedPlaceID] = $iExcludedPlaceID;
227 $this->aExcludePlaceIDs = $aExcludePlaceIDs;
230 // Only certain ranks of feature
231 if (isset($aParams['featureType'])) $this->setFeatureType($aParams['featureType']);
232 if (isset($aParams['featuretype'])) $this->setFeatureType($aParams['featuretype']);
235 if (isset($aParams['countrycodes']))
237 $aCountryCodes = array();
238 foreach(explode(',',$aParams['countrycodes']) as $sCountryCode)
240 if (preg_match('/^[a-zA-Z][a-zA-Z]$/', $sCountryCode))
242 $aCountryCodes[] = strtolower($sCountryCode);
245 $this->aCountryCodes = $aCountryCodes;
248 if (isset($aParams['viewboxlbrt']) && $aParams['viewboxlbrt'])
250 $aCoOrdinatesLBRT = explode(',',$aParams['viewboxlbrt']);
251 $this->setViewBox($aCoOrdinatesLBRT[0], $aCoOrdinatesLBRT[1], $aCoOrdinatesLBRT[2], $aCoOrdinatesLBRT[3]);
253 else if (isset($aParams['viewbox']) && $aParams['viewbox'])
255 $aCoOrdinatesLTRB = explode(',',$aParams['viewbox']);
256 $this->setViewBox($aCoOrdinatesLTRB[0], $aCoOrdinatesLTRB[3], $aCoOrdinatesLTRB[2], $aCoOrdinatesLTRB[1]);
259 if (isset($aParams['route']) && $aParams['route'] && isset($aParams['routewidth']) && $aParams['routewidth'])
261 $aPoints = explode(',',$aParams['route']);
262 if (sizeof($aPoints) % 2 != 0)
264 userError("Uneven number of points");
269 foreach($aPoints as $i => $fPoint)
273 $aRoute[] = array((float)$fPoint, $fPrevCoord);
277 $fPrevCoord = (float)$fPoint;
280 $this->aRoutePoints = $aRoute;
284 function setQueryFromParams($aParams)
287 $sQuery = (isset($aParams['q'])?trim($aParams['q']):'');
290 $this->setStructuredQuery(@$aParams['amenity'], @$aParams['street'], @$aParams['city'], @$aParams['county'], @$aParams['state'], @$aParams['country'], @$aParams['postalcode']);
291 $this->setReverseInPlan(false);
295 $this->setQuery($sQuery);
299 function loadStructuredAddressElement($sValue, $sKey, $iNewMinAddressRank, $iNewMaxAddressRank, $aItemListValues)
301 $sValue = trim($sValue);
302 if (!$sValue) return false;
303 $this->aStructuredQuery[$sKey] = $sValue;
304 if ($this->iMinAddressRank == 0 && $this->iMaxAddressRank == 30)
306 $this->iMinAddressRank = $iNewMinAddressRank;
307 $this->iMaxAddressRank = $iNewMaxAddressRank;
309 if ($aItemListValues) $this->aAddressRankList = array_merge($this->aAddressRankList, $aItemListValues);
313 function setStructuredQuery($sAmentiy = false, $sStreet = false, $sCity = false, $sCounty = false, $sState = false, $sCountry = false, $sPostalCode = false)
315 $this->sQuery = false;
318 $this->iMinAddressRank = 0;
319 $this->iMaxAddressRank = 30;
320 $this->aAddressRankList = array();
322 $this->aStructuredQuery = array();
323 $this->sAllowedTypesSQLList = '';
325 $this->loadStructuredAddressElement($sAmentiy, 'amenity', 26, 30, false);
326 $this->loadStructuredAddressElement($sStreet, 'street', 26, 30, false);
327 $this->loadStructuredAddressElement($sCity, 'city', 14, 24, false);
328 $this->loadStructuredAddressElement($sCounty, 'county', 9, 13, false);
329 $this->loadStructuredAddressElement($sState, 'state', 8, 8, false);
330 $this->loadStructuredAddressElement($sPostalCode, 'postalcode' , 5, 11, array(5, 11));
331 $this->loadStructuredAddressElement($sCountry, 'country', 4, 4, false);
333 if (sizeof($this->aStructuredQuery) > 0)
335 $this->sQuery = join(', ', $this->aStructuredQuery);
336 if ($this->iMaxAddressRank < 30)
338 $sAllowedTypesSQLList = '(\'place\',\'boundary\')';
343 function fallbackStructuredQuery()
345 if (!$this->aStructuredQuery) return false;
347 $aParams = $this->aStructuredQuery;
349 if (sizeof($aParams) == 1) return false;
351 $aOrderToFallback = array('postalcode', 'street', 'city', 'county', 'state');
353 foreach($aOrderToFallback as $sType)
355 if (isset($aParams[$sType]))
357 unset($aParams[$sType]);
358 $this->setStructuredQuery(@$aParams['amenity'], @$aParams['street'], @$aParams['city'], @$aParams['county'], @$aParams['state'], @$aParams['country'], @$aParams['postalcode']);
366 function getDetails($aPlaceIDs)
368 if (sizeof($aPlaceIDs) == 0) return array();
370 $sLanguagePrefArraySQL = "ARRAY[".join(',',array_map("getDBQuoted",$this->aLangPrefOrder))."]";
372 // Get the details for display (is this a redundant extra step?)
373 $sPlaceIDs = join(',',$aPlaceIDs);
375 $sImportanceSQL = '';
376 if ($this->sViewboxSmallSQL) $sImportanceSQL .= " case when ST_Contains($this->sViewboxSmallSQL, ST_Collect(centroid)) THEN 1 ELSE 0.75 END * ";
377 if ($this->sViewboxLargeSQL) $sImportanceSQL .= " case when ST_Contains($this->sViewboxLargeSQL, ST_Collect(centroid)) THEN 1 ELSE 0.75 END * ";
379 $sSQL = "select osm_type,osm_id,class,type,admin_level,rank_search,rank_address,min(place_id) as place_id, min(parent_place_id) as parent_place_id, calculated_country_code as country_code,";
380 $sSQL .= "get_address_by_language(place_id, $sLanguagePrefArraySQL) as langaddress,";
381 $sSQL .= "get_name_by_language(name, $sLanguagePrefArraySQL) as placename,";
382 $sSQL .= "get_name_by_language(name, ARRAY['ref']) as ref,";
383 $sSQL .= "avg(ST_X(centroid)) as lon,avg(ST_Y(centroid)) as lat, ";
384 $sSQL .= $sImportanceSQL."coalesce(importance,0.75-(rank_search::float/40)) as importance, ";
385 $sSQL .= "(select max(p.importance*(p.rank_address+2)) from place_addressline s, placex p where s.place_id = min(CASE WHEN placex.rank_search < 28 THEN placex.place_id ELSE placex.parent_place_id END) and p.place_id = s.address_place_id and s.isaddress and p.importance is not null) as addressimportance, ";
386 $sSQL .= "(extratags->'place') as extra_place ";
387 $sSQL .= "from placex where place_id in ($sPlaceIDs) ";
388 $sSQL .= "and (placex.rank_address between $this->iMinAddressRank and $this->iMaxAddressRank ";
389 if (14 >= $this->iMinAddressRank && 14 <= $this->iMaxAddressRank) $sSQL .= " OR (extratags->'place') = 'city'";
390 if ($this->aAddressRankList) $sSQL .= " OR placex.rank_address in (".join(',',$this->aAddressRankList).")";
392 if ($this->sAllowedTypesSQLList) $sSQL .= "and placex.class in $this->sAllowedTypesSQLList ";
393 $sSQL .= "and linked_place_id is null ";
394 $sSQL .= "group by osm_type,osm_id,class,type,admin_level,rank_search,rank_address,calculated_country_code,importance";
395 if (!$this->bDeDupe) $sSQL .= ",place_id";
396 $sSQL .= ",langaddress ";
397 $sSQL .= ",placename ";
399 $sSQL .= ",extratags->'place' ";
401 if (30 >= $this->iMinAddressRank && 30 <= $this->iMaxAddressRank)
404 $sSQL .= "select 'T' as osm_type,place_id as osm_id,'place' as class,'house' as type,null as admin_level,30 as rank_search,30 as rank_address,min(place_id) as place_id, min(parent_place_id) as parent_place_id,'us' as country_code,";
405 $sSQL .= "get_address_by_language(place_id, $sLanguagePrefArraySQL) as langaddress,";
406 $sSQL .= "null as placename,";
407 $sSQL .= "null as ref,";
408 $sSQL .= "avg(ST_X(centroid)) as lon,avg(ST_Y(centroid)) as lat, ";
409 $sSQL .= $sImportanceSQL."-1.15 as importance, ";
410 $sSQL .= "(select max(p.importance*(p.rank_address+2)) from place_addressline s, placex p where s.place_id = min(location_property_tiger.parent_place_id) and p.place_id = s.address_place_id and s.isaddress and p.importance is not null) as addressimportance, ";
411 $sSQL .= "null as extra_place ";
412 $sSQL .= "from location_property_tiger where place_id in ($sPlaceIDs) ";
413 $sSQL .= "and 30 between $this->iMinAddressRank and $this->iMaxAddressRank ";
414 $sSQL .= "group by place_id";
415 if (!$this->bDeDupe) $sSQL .= ",place_id ";
418 $sSQL .= "select 'L' as osm_type,place_id as osm_id,'place' as class,'house' as type,null as admin_level,30 as rank_search,30 as rank_address,min(place_id) as place_id, min(parent_place_id) as parent_place_id,'us' as country_code,";
419 $sSQL .= "get_address_by_language(place_id, $sLanguagePrefArraySQL) as langaddress,";
420 $sSQL .= "null as placename,";
421 $sSQL .= "null as ref,";
422 $sSQL .= "avg(ST_X(centroid)) as lon,avg(ST_Y(centroid)) as lat, ";
423 $sSQL .= $sImportanceSQL."-1.10 as importance, ";
424 $sSQL .= "(select max(p.importance*(p.rank_address+2)) from place_addressline s, placex p where s.place_id = min(location_property_aux.parent_place_id) and p.place_id = s.address_place_id and s.isaddress and p.importance is not null) as addressimportance, ";
425 $sSQL .= "null as extra_place ";
426 $sSQL .= "from location_property_aux where place_id in ($sPlaceIDs) ";
427 $sSQL .= "and 30 between $this->iMinAddressRank and $this->iMaxAddressRank ";
428 $sSQL .= "group by place_id";
429 if (!$this->bDeDupe) $sSQL .= ",place_id";
430 $sSQL .= ",get_address_by_language(place_id, $sLanguagePrefArraySQL) ";
434 $sSQL .= " order by importance desc";
435 if (CONST_Debug) { echo "<hr>"; var_dump($sSQL); }
436 $aSearchResults = $this->oDB->getAll($sSQL);
438 if (PEAR::IsError($aSearchResults))
440 failInternalError("Could not get details for place.", $sSQL, $aSearchResults);
443 return $aSearchResults;
446 /* Perform the actual query lookup.
448 Returns an ordered list of results, each with the following fields:
449 osm_type: type of corresponding OSM object
453 P - postcode (internally computed)
454 osm_id: id of corresponding OSM object
455 class: general object class (corresponds to tag key of primary OSM tag)
456 type: subclass of object (corresponds to tag value of primary OSM tag)
457 admin_level: see http://wiki.openstreetmap.org/wiki/Admin_level
458 rank_search: rank in search hierarchy
459 (see also http://wiki.openstreetmap.org/wiki/Nominatim/Development_overview#Country_to_street_level)
460 rank_address: rank in address hierarchy (determines orer in address)
461 place_id: internal key (may differ between different instances)
462 country_code: ISO country code
463 langaddress: localized full address
464 placename: localized name of object
465 ref: content of ref tag (if available)
468 importance: importance of place based on Wikipedia link count
469 addressimportance: cumulated importance of address elements
470 extra_place: type of place (for admin boundaries, if there is a place tag)
471 aBoundingBox: bounding Box
472 label: short description of the object class/type (English only)
473 name: full name (currently the same as langaddress)
474 foundorder: secondary ordering for places with same importance
478 if (!$this->sQuery && !$this->aStructuredQuery) return false;
480 $sLanguagePrefArraySQL = "ARRAY[".join(',',array_map("getDBQuoted",$this->aLangPrefOrder))."]";
482 $sCountryCodesSQL = false;
483 if ($this->aCountryCodes && sizeof($this->aCountryCodes))
485 $sCountryCodesSQL = join(',', array_map('addQuotes', $this->aCountryCodes));
488 $sQuery = $this->sQuery;
490 // Conflicts between US state abreviations and various words for 'the' in different languages
491 if (isset($this->aLangPrefOrder['name:en']))
493 $sQuery = preg_replace('/(^|,)\s*il\s*(,|$)/','\1illinois\2', $sQuery);
494 $sQuery = preg_replace('/(^|,)\s*al\s*(,|$)/','\1alabama\2', $sQuery);
495 $sQuery = preg_replace('/(^|,)\s*la\s*(,|$)/','\1louisiana\2', $sQuery);
499 $sViewboxCentreSQL = false;
500 $bBoundingBoxSearch = false;
503 $fHeight = $this->aViewBox[0]-$this->aViewBox[2];
504 $fWidth = $this->aViewBox[1]-$this->aViewBox[3];
505 $aBigViewBox[0] = $this->aViewBox[0] + $fHeight;
506 $aBigViewBox[2] = $this->aViewBox[2] - $fHeight;
507 $aBigViewBox[1] = $this->aViewBox[1] + $fWidth;
508 $aBigViewBox[3] = $this->aViewBox[3] - $fWidth;
510 $this->sViewboxSmallSQL = "ST_SetSRID(ST_MakeBox2D(ST_Point(".(float)$this->aViewBox[0].",".(float)$this->aViewBox[1]."),ST_Point(".(float)$this->aViewBox[2].",".(float)$this->aViewBox[3].")),4326)";
511 $this->sViewboxLargeSQL = "ST_SetSRID(ST_MakeBox2D(ST_Point(".(float)$aBigViewBox[0].",".(float)$aBigViewBox[1]."),ST_Point(".(float)$aBigViewBox[2].",".(float)$aBigViewBox[3].")),4326)";
512 $bBoundingBoxSearch = $this->bBoundedSearch;
516 if ($this->aRoutePoints)
518 $sViewboxCentreSQL = "ST_SetSRID('LINESTRING(";
520 foreach($this->aRoutePoints as $aPoint)
522 if (!$bFirst) $sViewboxCentreSQL .= ",";
523 $sViewboxCentreSQL .= $aPoint[1].' '.$aPoint[0];
526 $sViewboxCentreSQL .= ")'::geometry,4326)";
528 $sSQL = "select st_buffer(".$sViewboxCentreSQL.",".(float)($_GET['routewidth']/69).")";
529 $this->sViewboxSmallSQL = $this->oDB->getOne($sSQL);
530 if (PEAR::isError($this->sViewboxSmallSQL))
532 failInternalError("Could not get small viewbox.", $sSQL, $this->sViewboxSmallSQL);
534 $this->sViewboxSmallSQL = "'".$this->sViewboxSmallSQL."'::geometry";
536 $sSQL = "select st_buffer(".$sViewboxCentreSQL.",".(float)($_GET['routewidth']/30).")";
537 $this->sViewboxLargeSQL = $this->oDB->getOne($sSQL);
538 if (PEAR::isError($this->sViewboxLargeSQL))
540 failInternalError("Could not get large viewbox.", $sSQL, $this->sViewboxLargeSQL);
542 $this->sViewboxLargeSQL = "'".$this->sViewboxLargeSQL."'::geometry";
543 $bBoundingBoxSearch = $this->bBoundedSearch;
546 // Do we have anything that looks like a lat/lon pair?
547 if (preg_match('/\\b([NS])[ ]+([0-9]+[0-9.]*)[ ]+([0-9.]+)?[, ]+([EW])[ ]+([0-9]+)[ ]+([0-9]+[0-9.]*)?\\b/', $sQuery, $aData))
549 $fQueryLat = ($aData[1]=='N'?1:-1) * ($aData[2] + $aData[3]/60);
550 $fQueryLon = ($aData[4]=='E'?1:-1) * ($aData[5] + $aData[6]/60);
551 if ($fQueryLat <= 90.1 && $fQueryLat >= -90.1 && $fQueryLon <= 180.1 && $fQueryLon >= -180.1)
553 $this->setNearPoint(array($fQueryLat, $fQueryLon));
554 $sQuery = trim(str_replace($aData[0], ' ', $sQuery));
557 elseif (preg_match('/\\b([0-9]+)[ ]+([0-9]+[0-9.]*)?[ ]+([NS])[, ]+([0-9]+)[ ]+([0-9]+[0-9.]*)?[ ]+([EW])\\b/', $sQuery, $aData))
559 $fQueryLat = ($aData[3]=='N'?1:-1) * ($aData[1] + $aData[2]/60);
560 $fQueryLon = ($aData[6]=='E'?1:-1) * ($aData[4] + $aData[5]/60);
561 if ($fQueryLat <= 90.1 && $fQueryLat >= -90.1 && $fQueryLon <= 180.1 && $fQueryLon >= -180.1)
563 $this->setNearPoint(array($fQueryLat, $fQueryLon));
564 $sQuery = trim(str_replace($aData[0], ' ', $sQuery));
567 elseif (preg_match('/(\\[|^|\\b)(-?[0-9]+[0-9]*\\.[0-9]+)[, ]+(-?[0-9]+[0-9]*\\.[0-9]+)(\\]|$|\\b)/', $sQuery, $aData))
569 $fQueryLat = $aData[2];
570 $fQueryLon = $aData[3];
571 if ($fQueryLat <= 90.1 && $fQueryLat >= -90.1 && $fQueryLon <= 180.1 && $fQueryLon >= -180.1)
573 $this->setNearPoint(array($fQueryLat, $fQueryLon));
574 $sQuery = trim(str_replace($aData[0], ' ', $sQuery));
578 $aSearchResults = array();
579 if ($sQuery || $this->aStructuredQuery)
581 // Start with a blank search
583 array('iSearchRank' => 0, 'iNamePhrase' => -1, 'sCountryCode' => false, 'aName'=>array(), 'aAddress'=>array(), 'aFullNameAddress'=>array(),
584 'aNameNonSearch'=>array(), 'aAddressNonSearch'=>array(),
585 'sOperator'=>'', 'aFeatureName' => array(), 'sClass'=>'', 'sType'=>'', 'sHouseNumber'=>'', 'fLat'=>'', 'fLon'=>'', 'fRadius'=>'')
588 // Do we have a radius search?
589 $sNearPointSQL = false;
590 if ($this->aNearPoint)
592 $sNearPointSQL = "ST_SetSRID(ST_Point(".(float)$this->aNearPoint[1].",".(float)$this->aNearPoint[0]."),4326)";
593 $aSearches[0]['fLat'] = (float)$this->aNearPoint[0];
594 $aSearches[0]['fLon'] = (float)$this->aNearPoint[1];
595 $aSearches[0]['fRadius'] = (float)$this->aNearPoint[2];
598 // Any 'special' terms in the search?
599 $bSpecialTerms = false;
600 preg_match_all('/\\[(.*)=(.*)\\]/', $sQuery, $aSpecialTermsRaw, PREG_SET_ORDER);
601 $aSpecialTerms = array();
602 foreach($aSpecialTermsRaw as $aSpecialTerm)
604 $sQuery = str_replace($aSpecialTerm[0], ' ', $sQuery);
605 $aSpecialTerms[strtolower($aSpecialTerm[1])] = $aSpecialTerm[2];
608 preg_match_all('/\\[([\\w ]*)\\]/u', $sQuery, $aSpecialTermsRaw, PREG_SET_ORDER);
609 $aSpecialTerms = array();
610 if (isset($aStructuredQuery['amenity']) && $aStructuredQuery['amenity'])
612 $aSpecialTermsRaw[] = array('['.$aStructuredQuery['amenity'].']', $aStructuredQuery['amenity']);
613 unset($aStructuredQuery['amenity']);
615 foreach($aSpecialTermsRaw as $aSpecialTerm)
617 $sQuery = str_replace($aSpecialTerm[0], ' ', $sQuery);
618 $sToken = $this->oDB->getOne("select make_standard_name('".$aSpecialTerm[1]."') as string");
619 $sSQL = 'select * from (select word_id,word_token, word, class, type, country_code, operator';
620 $sSQL .= ' from word where word_token in (\' '.$sToken.'\')) as x where (class is not null and class not in (\'place\')) or country_code is not null';
621 if (CONST_Debug) var_Dump($sSQL);
622 $aSearchWords = $this->oDB->getAll($sSQL);
623 $aNewSearches = array();
624 foreach($aSearches as $aSearch)
626 foreach($aSearchWords as $aSearchTerm)
628 $aNewSearch = $aSearch;
629 if ($aSearchTerm['country_code'])
631 $aNewSearch['sCountryCode'] = strtolower($aSearchTerm['country_code']);
632 $aNewSearches[] = $aNewSearch;
633 $bSpecialTerms = true;
635 if ($aSearchTerm['class'])
637 $aNewSearch['sClass'] = $aSearchTerm['class'];
638 $aNewSearch['sType'] = $aSearchTerm['type'];
639 $aNewSearches[] = $aNewSearch;
640 $bSpecialTerms = true;
644 $aSearches = $aNewSearches;
647 // Split query into phrases
648 // Commas are used to reduce the search space by indicating where phrases split
649 if ($this->aStructuredQuery)
651 $aPhrases = $this->aStructuredQuery;
652 $bStructuredPhrases = true;
656 $aPhrases = explode(',',$sQuery);
657 $bStructuredPhrases = false;
660 // Convert each phrase to standard form
661 // Create a list of standard words
662 // Get all 'sets' of words
663 // Generate a complete list of all
665 foreach($aPhrases as $iPhrase => $sPhrase)
667 $aPhrase = $this->oDB->getRow("select make_standard_name('".pg_escape_string($sPhrase)."') as string");
668 if (PEAR::isError($aPhrase))
670 userError("Illegal query string (not an UTF-8 string): ".$sPhrase);
671 if (CONST_Debug) var_dump($aPhrase);
674 if (trim($aPhrase['string']))
676 $aPhrases[$iPhrase] = $aPhrase;
677 $aPhrases[$iPhrase]['words'] = explode(' ',$aPhrases[$iPhrase]['string']);
678 $aPhrases[$iPhrase]['wordsets'] = getWordSets($aPhrases[$iPhrase]['words'], 0);
679 $aTokens = array_merge($aTokens, getTokensFromSets($aPhrases[$iPhrase]['wordsets']));
683 unset($aPhrases[$iPhrase]);
687 // Reindex phrases - we make assumptions later on that they are numerically keyed in order
688 $aPhraseTypes = array_keys($aPhrases);
689 $aPhrases = array_values($aPhrases);
691 if (sizeof($aTokens))
693 // Check which tokens we have, get the ID numbers
694 $sSQL = 'select word_id,word_token, word, class, type, country_code, operator, search_name_count';
695 $sSQL .= ' from word where word_token in ('.join(',',array_map("getDBQuoted",$aTokens)).')';
697 if (CONST_Debug) var_Dump($sSQL);
699 $aValidTokens = array();
700 if (sizeof($aTokens)) $aDatabaseWords = $this->oDB->getAll($sSQL);
701 else $aDatabaseWords = array();
702 if (PEAR::IsError($aDatabaseWords))
704 failInternalError("Could not get word tokens.", $sSQL, $aDatabaseWords);
706 $aPossibleMainWordIDs = array();
707 $aWordFrequencyScores = array();
708 foreach($aDatabaseWords as $aToken)
710 // Very special case - require 2 letter country param to match the country code found
711 if ($bStructuredPhrases && $aToken['country_code'] && !empty($aStructuredQuery['country'])
712 && strlen($aStructuredQuery['country']) == 2 && strtolower($aStructuredQuery['country']) != $aToken['country_code'])
717 if (isset($aValidTokens[$aToken['word_token']]))
719 $aValidTokens[$aToken['word_token']][] = $aToken;
723 $aValidTokens[$aToken['word_token']] = array($aToken);
725 if (!$aToken['class'] && !$aToken['country_code']) $aPossibleMainWordIDs[$aToken['word_id']] = 1;
726 $aWordFrequencyScores[$aToken['word_id']] = $aToken['search_name_count'] + 1;
728 if (CONST_Debug) var_Dump($aPhrases, $aValidTokens);
730 // Try and calculate GB postcodes we might be missing
731 foreach($aTokens as $sToken)
733 // Source of gb postcodes is now definitive - always use
734 if (preg_match('/^([A-Z][A-Z]?[0-9][0-9A-Z]? ?[0-9])([A-Z][A-Z])$/', strtoupper(trim($sToken)), $aData))
736 if (substr($aData[1],-2,1) != ' ')
738 $aData[0] = substr($aData[0],0,strlen($aData[1]-1)).' '.substr($aData[0],strlen($aData[1]-1));
739 $aData[1] = substr($aData[1],0,-1).' '.substr($aData[1],-1,1);
741 $aGBPostcodeLocation = gbPostcodeCalculate($aData[0], $aData[1], $aData[2], $this->oDB);
742 if ($aGBPostcodeLocation)
744 $aValidTokens[$sToken] = $aGBPostcodeLocation;
747 // US ZIP+4 codes - if there is no token,
748 // merge in the 5-digit ZIP code
749 else if (!isset($aValidTokens[$sToken]) && preg_match('/^([0-9]{5}) [0-9]{4}$/', $sToken, $aData))
751 if (isset($aValidTokens[$aData[1]]))
753 foreach($aValidTokens[$aData[1]] as $aToken)
755 if (!$aToken['class'])
757 if (isset($aValidTokens[$sToken]))
759 $aValidTokens[$sToken][] = $aToken;
763 $aValidTokens[$sToken] = array($aToken);
771 foreach($aTokens as $sToken)
773 // Unknown single word token with a number - assume it is a house number
774 if (!isset($aValidTokens[' '.$sToken]) && strpos($sToken,' ') === false && preg_match('/[0-9]/', $sToken))
776 $aValidTokens[' '.$sToken] = array(array('class'=>'place','type'=>'house'));
780 // Any words that have failed completely?
783 // Start the search process
784 $aResultPlaceIDs = array();
787 Calculate all searches using aValidTokens i.e.
788 'Wodsworth Road, Sheffield' =>
792 0 1 (wodsworth)(road)
795 Score how good the search is so they can be ordered
797 foreach($aPhrases as $iPhrase => $sPhrase)
799 $aNewPhraseSearches = array();
800 if ($bStructuredPhrases) $sPhraseType = $aPhraseTypes[$iPhrase];
801 else $sPhraseType = '';
803 foreach($aPhrases[$iPhrase]['wordsets'] as $iWordSet => $aWordset)
805 // Too many permutations - too expensive
806 if ($iWordSet > 120) break;
808 $aWordsetSearches = $aSearches;
810 // Add all words from this wordset
811 foreach($aWordset as $iToken => $sToken)
813 //echo "<br><b>$sToken</b>";
814 $aNewWordsetSearches = array();
816 foreach($aWordsetSearches as $aCurrentSearch)
819 //var_dump($aCurrentSearch);
822 // If the token is valid
823 if (isset($aValidTokens[' '.$sToken]))
825 foreach($aValidTokens[' '.$sToken] as $aSearchTerm)
827 $aSearch = $aCurrentSearch;
828 $aSearch['iSearchRank']++;
829 if (($sPhraseType == '' || $sPhraseType == 'country') && !empty($aSearchTerm['country_code']) && $aSearchTerm['country_code'] != '0')
831 if ($aSearch['sCountryCode'] === false)
833 $aSearch['sCountryCode'] = strtolower($aSearchTerm['country_code']);
834 // Country is almost always at the end of the string - increase score for finding it anywhere else (optimisation)
835 // If reverse order is enabled, it may appear at the beginning as well.
836 if (($iToken+1 != sizeof($aWordset) || $iPhrase+1 != sizeof($aPhrases)) &&
837 (!$this->bReverseInPlan || $iToken > 0 || $iPhrase > 0))
839 $aSearch['iSearchRank'] += 5;
841 if ($aSearch['iSearchRank'] < $this->iMaxRank) $aNewWordsetSearches[] = $aSearch;
844 elseif (isset($aSearchTerm['lat']) && $aSearchTerm['lat'] !== '' && $aSearchTerm['lat'] !== null)
846 if ($aSearch['fLat'] === '')
848 $aSearch['fLat'] = $aSearchTerm['lat'];
849 $aSearch['fLon'] = $aSearchTerm['lon'];
850 $aSearch['fRadius'] = $aSearchTerm['radius'];
851 if ($aSearch['iSearchRank'] < $this->iMaxRank) $aNewWordsetSearches[] = $aSearch;
854 elseif ($sPhraseType == 'postalcode')
856 // We need to try the case where the postal code is the primary element (i.e. no way to tell if it is (postalcode, city) OR (city, postalcode) so try both
857 if (isset($aSearchTerm['word_id']) && $aSearchTerm['word_id'])
859 // If we already have a name try putting the postcode first
860 if (sizeof($aSearch['aName']))
862 $aNewSearch = $aSearch;
863 $aNewSearch['aAddress'] = array_merge($aNewSearch['aAddress'], $aNewSearch['aName']);
864 $aNewSearch['aName'] = array();
865 $aNewSearch['aName'][$aSearchTerm['word_id']] = $aSearchTerm['word_id'];
866 if ($aSearch['iSearchRank'] < $this->iMaxRank) $aNewWordsetSearches[] = $aNewSearch;
869 if (sizeof($aSearch['aName']))
871 if ((!$bStructuredPhrases || $iPhrase > 0) && $sPhraseType != 'country' && (!isset($aValidTokens[$sToken]) || strlen($sToken) < 4 || strpos($sToken, ' ') !== false))
873 $aSearch['aAddress'][$aSearchTerm['word_id']] = $aSearchTerm['word_id'];
877 $aCurrentSearch['aFullNameAddress'][$aSearchTerm['word_id']] = $aSearchTerm['word_id'];
878 $aSearch['iSearchRank'] += 1000; // skip;
883 $aSearch['aName'][$aSearchTerm['word_id']] = $aSearchTerm['word_id'];
884 //$aSearch['iNamePhrase'] = $iPhrase;
886 if ($aSearch['iSearchRank'] < $this->iMaxRank) $aNewWordsetSearches[] = $aSearch;
890 elseif (($sPhraseType == '' || $sPhraseType == 'street') && $aSearchTerm['class'] == 'place' && $aSearchTerm['type'] == 'house')
892 if ($aSearch['sHouseNumber'] === '')
894 $aSearch['sHouseNumber'] = $sToken;
895 // sanity check: if the housenumber is not mainly made
896 // up of numbers, add a penalty
897 if (preg_match_all("/[^0-9]/", $sToken, $aMatches) > 2) $aSearch['iSearchRank']++;
898 if ($aSearch['iSearchRank'] < $this->iMaxRank) $aNewWordsetSearches[] = $aSearch;
900 // Fall back to not searching for this item (better than nothing)
901 $aSearch = $aCurrentSearch;
902 $aSearch['iSearchRank'] += 1;
903 if ($aSearch['iSearchRank'] < $this->iMaxRank) $aNewWordsetSearches[] = $aSearch;
907 elseif ($sPhraseType == '' && $aSearchTerm['class'] !== '' && $aSearchTerm['class'] !== null)
909 if ($aSearch['sClass'] === '')
911 $aSearch['sOperator'] = $aSearchTerm['operator'];
912 $aSearch['sClass'] = $aSearchTerm['class'];
913 $aSearch['sType'] = $aSearchTerm['type'];
914 if (sizeof($aSearch['aName'])) $aSearch['sOperator'] = 'name';
915 else $aSearch['sOperator'] = 'near'; // near = in for the moment
916 if (strlen($aSearchTerm['operator']) == 0) $aSearch['iSearchRank'] += 1;
918 // Do we have a shortcut id?
919 if ($aSearch['sOperator'] == 'name')
921 $sSQL = "select get_tagpair('".$aSearch['sClass']."', '".$aSearch['sType']."')";
922 if ($iAmenityID = $this->oDB->getOne($sSQL))
924 $aValidTokens[$aSearch['sClass'].':'.$aSearch['sType']] = array('word_id' => $iAmenityID);
925 $aSearch['aName'][$iAmenityID] = $iAmenityID;
926 $aSearch['sClass'] = '';
927 $aSearch['sType'] = '';
930 if ($aSearch['iSearchRank'] < $this->iMaxRank) $aNewWordsetSearches[] = $aSearch;
933 elseif (isset($aSearchTerm['word_id']) && $aSearchTerm['word_id'])
935 if (sizeof($aSearch['aName']))
937 if ((!$bStructuredPhrases || $iPhrase > 0) && $sPhraseType != 'country' && (!isset($aValidTokens[$sToken]) || strlen($sToken) < 4 || strpos($sToken, ' ') !== false))
939 $aSearch['aAddress'][$aSearchTerm['word_id']] = $aSearchTerm['word_id'];
943 $aCurrentSearch['aFullNameAddress'][$aSearchTerm['word_id']] = $aSearchTerm['word_id'];
944 $aSearch['iSearchRank'] += 1000; // skip;
949 $aSearch['aName'][$aSearchTerm['word_id']] = $aSearchTerm['word_id'];
950 //$aSearch['iNamePhrase'] = $iPhrase;
952 if ($aSearch['iSearchRank'] < $this->iMaxRank) $aNewWordsetSearches[] = $aSearch;
956 if (isset($aValidTokens[$sToken]))
958 // Allow searching for a word - but at extra cost
959 foreach($aValidTokens[$sToken] as $aSearchTerm)
961 if (isset($aSearchTerm['word_id']) && $aSearchTerm['word_id'])
963 if ((!$bStructuredPhrases || $iPhrase > 0) && sizeof($aCurrentSearch['aName']) && strlen($sToken) >= 4)
965 $aSearch = $aCurrentSearch;
966 $aSearch['iSearchRank'] += 1;
967 if ($aWordFrequencyScores[$aSearchTerm['word_id']] < CONST_Max_Word_Frequency)
969 $aSearch['aAddress'][$aSearchTerm['word_id']] = $aSearchTerm['word_id'];
970 if ($aSearch['iSearchRank'] < $this->iMaxRank) $aNewWordsetSearches[] = $aSearch;
972 elseif (isset($aValidTokens[' '.$sToken])) // revert to the token version?
974 foreach($aValidTokens[' '.$sToken] as $aSearchTermToken)
976 if (empty($aSearchTermToken['country_code'])
977 && empty($aSearchTermToken['lat'])
978 && empty($aSearchTermToken['class']))
980 $aSearch = $aCurrentSearch;
981 $aSearch['iSearchRank'] += 1;
982 $aSearch['aAddress'][$aSearchTermToken['word_id']] = $aSearchTermToken['word_id'];
983 if ($aSearch['iSearchRank'] < $this->iMaxRank) $aNewWordsetSearches[] = $aSearch;
989 $aSearch['aAddressNonSearch'][$aSearchTerm['word_id']] = $aSearchTerm['word_id'];
990 if ($aSearch['iSearchRank'] < $this->iMaxRank) $aNewWordsetSearches[] = $aSearch;
994 if (!sizeof($aCurrentSearch['aName']) || $aCurrentSearch['iNamePhrase'] == $iPhrase)
996 $aSearch = $aCurrentSearch;
997 $aSearch['iSearchRank'] += 2;
998 if (preg_match('#^[0-9]+$#', $sToken)) $aSearch['iSearchRank'] += 2;
999 if ($aWordFrequencyScores[$aSearchTerm['word_id']] < CONST_Max_Word_Frequency)
1000 $aSearch['aName'][$aSearchTerm['word_id']] = $aSearchTerm['word_id'];
1002 $aSearch['aNameNonSearch'][$aSearchTerm['word_id']] = $aSearchTerm['word_id'];
1003 $aSearch['iNamePhrase'] = $iPhrase;
1004 if ($aSearch['iSearchRank'] < $this->iMaxRank) $aNewWordsetSearches[] = $aSearch;
1011 // Allow skipping a word - but at EXTREAM cost
1012 //$aSearch = $aCurrentSearch;
1013 //$aSearch['iSearchRank']+=100;
1014 //$aNewWordsetSearches[] = $aSearch;
1018 usort($aNewWordsetSearches, 'bySearchRank');
1019 $aWordsetSearches = array_slice($aNewWordsetSearches, 0, 50);
1021 //var_Dump('<hr>',sizeof($aWordsetSearches)); exit;
1023 $aNewPhraseSearches = array_merge($aNewPhraseSearches, $aNewWordsetSearches);
1024 usort($aNewPhraseSearches, 'bySearchRank');
1026 $aSearchHash = array();
1027 foreach($aNewPhraseSearches as $iSearch => $aSearch)
1029 $sHash = serialize($aSearch);
1030 if (isset($aSearchHash[$sHash])) unset($aNewPhraseSearches[$iSearch]);
1031 else $aSearchHash[$sHash] = 1;
1034 $aNewPhraseSearches = array_slice($aNewPhraseSearches, 0, 50);
1037 // Re-group the searches by their score, junk anything over 20 as just not worth trying
1038 $aGroupedSearches = array();
1039 foreach($aNewPhraseSearches as $aSearch)
1041 if ($aSearch['iSearchRank'] < $this->iMaxRank)
1043 if (!isset($aGroupedSearches[$aSearch['iSearchRank']])) $aGroupedSearches[$aSearch['iSearchRank']] = array();
1044 $aGroupedSearches[$aSearch['iSearchRank']][] = $aSearch;
1047 ksort($aGroupedSearches);
1050 $aSearches = array();
1051 foreach($aGroupedSearches as $iScore => $aNewSearches)
1053 $iSearchCount += sizeof($aNewSearches);
1054 $aSearches = array_merge($aSearches, $aNewSearches);
1055 if ($iSearchCount > 50) break;
1058 //if (CONST_Debug) _debugDumpGroupedSearches($aGroupedSearches, $aValidTokens);
1065 // Re-group the searches by their score, junk anything over 20 as just not worth trying
1066 $aGroupedSearches = array();
1067 foreach($aSearches as $aSearch)
1069 if ($aSearch['iSearchRank'] < $this->iMaxRank)
1071 if (!isset($aGroupedSearches[$aSearch['iSearchRank']])) $aGroupedSearches[$aSearch['iSearchRank']] = array();
1072 $aGroupedSearches[$aSearch['iSearchRank']][] = $aSearch;
1075 ksort($aGroupedSearches);
1078 if (CONST_Debug) var_Dump($aGroupedSearches);
1080 if ($this->bReverseInPlan)
1082 $aCopyGroupedSearches = $aGroupedSearches;
1083 foreach($aCopyGroupedSearches as $iGroup => $aSearches)
1085 foreach($aSearches as $iSearch => $aSearch)
1087 if (sizeof($aSearch['aAddress']))
1089 $iReverseItem = array_pop($aSearch['aAddress']);
1090 if (isset($aPossibleMainWordIDs[$iReverseItem]))
1092 $aSearch['aAddress'] = array_merge($aSearch['aAddress'], $aSearch['aName']);
1093 $aSearch['aName'] = array($iReverseItem);
1094 $aGroupedSearches[$iGroup][] = $aSearch;
1096 //$aReverseSearch['aName'][$iReverseItem] = $iReverseItem;
1097 //$aGroupedSearches[$iGroup][] = $aReverseSearch;
1103 if (CONST_Search_TryDroppedAddressTerms && sizeof($aStructuredQuery) > 0)
1105 $aCopyGroupedSearches = $aGroupedSearches;
1106 foreach($aCopyGroupedSearches as $iGroup => $aSearches)
1108 foreach($aSearches as $iSearch => $aSearch)
1110 $aReductionsList = array($aSearch['aAddress']);
1111 $iSearchRank = $aSearch['iSearchRank'];
1112 while(sizeof($aReductionsList) > 0)
1115 if ($iSearchRank > iMaxRank) break 3;
1116 $aNewReductionsList = array();
1117 foreach($aReductionsList as $aReductionsWordList)
1119 for ($iReductionWord = 0; $iReductionWord < sizeof($aReductionsWordList); $iReductionWord++)
1121 $aReductionsWordListResult = array_merge(array_slice($aReductionsWordList, 0, $iReductionWord), array_slice($aReductionsWordList, $iReductionWord+1));
1122 $aReverseSearch = $aSearch;
1123 $aSearch['aAddress'] = $aReductionsWordListResult;
1124 $aSearch['iSearchRank'] = $iSearchRank;
1125 $aGroupedSearches[$iSearchRank][] = $aReverseSearch;
1126 if (sizeof($aReductionsWordListResult) > 0)
1128 $aNewReductionsList[] = $aReductionsWordListResult;
1132 $aReductionsList = $aNewReductionsList;
1136 ksort($aGroupedSearches);
1139 // Filter out duplicate searches
1140 $aSearchHash = array();
1141 foreach($aGroupedSearches as $iGroup => $aSearches)
1143 foreach($aSearches as $iSearch => $aSearch)
1145 $sHash = serialize($aSearch);
1146 if (isset($aSearchHash[$sHash]))
1148 unset($aGroupedSearches[$iGroup][$iSearch]);
1149 if (sizeof($aGroupedSearches[$iGroup]) == 0) unset($aGroupedSearches[$iGroup]);
1153 $aSearchHash[$sHash] = 1;
1158 if (CONST_Debug) _debugDumpGroupedSearches($aGroupedSearches, $aValidTokens);
1162 foreach($aGroupedSearches as $iGroupedRank => $aSearches)
1165 foreach($aSearches as $aSearch)
1169 if (CONST_Debug) { echo "<hr><b>Search Loop, group $iGroupLoop, loop $iQueryLoop</b>"; }
1170 if (CONST_Debug) _debugDumpGroupedSearches(array($iGroupedRank => array($aSearch)), $aValidTokens);
1172 // No location term?
1173 if (!sizeof($aSearch['aName']) && !sizeof($aSearch['aAddress']) && !$aSearch['fLon'])
1175 if ($aSearch['sCountryCode'] && !$aSearch['sClass'] && !$aSearch['sHouseNumber'])
1177 // Just looking for a country by code - look it up
1178 if (4 >= $this->iMinAddressRank && 4 <= $this->iMaxAddressRank)
1180 $sSQL = "select place_id from placex where calculated_country_code='".$aSearch['sCountryCode']."' and rank_search = 4";
1181 if ($sCountryCodesSQL) $sSQL .= " and calculated_country_code in ($sCountryCodesSQL)";
1182 $sSQL .= " order by st_area(geometry) desc limit 1";
1183 if (CONST_Debug) var_dump($sSQL);
1184 $aPlaceIDs = $this->oDB->getCol($sSQL);
1189 if (!$bBoundingBoxSearch && !$aSearch['fLon']) continue;
1190 if (!$aSearch['sClass']) continue;
1191 $sSQL = "select count(*) from pg_tables where tablename = 'place_classtype_".$aSearch['sClass']."_".$aSearch['sType']."'";
1192 if ($this->oDB->getOne($sSQL))
1194 $sSQL = "select place_id from place_classtype_".$aSearch['sClass']."_".$aSearch['sType']." ct";
1195 if ($sCountryCodesSQL) $sSQL .= " join placex using (place_id)";
1196 $sSQL .= " where st_contains($this->sViewboxSmallSQL, ct.centroid)";
1197 if ($sCountryCodesSQL) $sSQL .= " and calculated_country_code in ($sCountryCodesSQL)";
1198 if (sizeof($this->aExcludePlaceIDs))
1200 $sSQL .= " and place_id not in (".join(',',$this->aExcludePlaceIDs).")";
1202 if ($sViewboxCentreSQL) $sSQL .= " order by st_distance($sViewboxCentreSQL, ct.centroid) asc";
1203 $sSQL .= " limit $this->iLimit";
1204 if (CONST_Debug) var_dump($sSQL);
1205 $aPlaceIDs = $this->oDB->getCol($sSQL);
1207 // If excluded place IDs are given, it is fair to assume that
1208 // there have been results in the small box, so no further
1209 // expansion in that case.
1210 if (!sizeof($aPlaceIDs) && !sizeof($this->aExcludePlaceIDs))
1212 $sSQL = "select place_id from place_classtype_".$aSearch['sClass']."_".$aSearch['sType']." ct";
1213 if ($sCountryCodesSQL) $sSQL .= " join placex using (place_id)";
1214 $sSQL .= " where st_contains($this->sViewboxLargeSQL, ct.centroid)";
1215 if ($sCountryCodesSQL) $sSQL .= " and calculated_country_code in ($sCountryCodesSQL)";
1216 if ($sViewboxCentreSQL) $sSQL .= " order by st_distance($sViewboxCentreSQL, ct.centroid) asc";
1217 $sSQL .= " limit $this->iLimit";
1218 if (CONST_Debug) var_dump($sSQL);
1219 $aPlaceIDs = $this->oDB->getCol($sSQL);
1224 $sSQL = "select place_id from placex where class='".$aSearch['sClass']."' and type='".$aSearch['sType']."'";
1225 $sSQL .= " and st_contains($this->sViewboxSmallSQL, geometry) and linked_place_id is null";
1226 if ($sCountryCodesSQL) $sSQL .= " and calculated_country_code in ($sCountryCodesSQL)";
1227 if ($sViewboxCentreSQL) $sSQL .= " order by st_distance($sViewboxCentreSQL, centroid) asc";
1228 $sSQL .= " limit $this->iLimit";
1229 if (CONST_Debug) var_dump($sSQL);
1230 $aPlaceIDs = $this->oDB->getCol($sSQL);
1236 $aPlaceIDs = array();
1238 // First we need a position, either aName or fLat or both
1242 // TODO: filter out the pointless search terms (2 letter name tokens and less)
1243 // they might be right - but they are just too darned expensive to run
1244 if (sizeof($aSearch['aName'])) $aTerms[] = "name_vector @> ARRAY[".join($aSearch['aName'],",")."]";
1245 //if (sizeof($aSearch['aNameNonSearch'])) $aTerms[] = "array_cat(name_vector,ARRAY[]::integer[]) @> ARRAY[".join($aSearch['aNameNonSearch'],",")."]";
1246 if (sizeof($aSearch['aAddress']) && $aSearch['aName'] != $aSearch['aAddress'])
1248 // For infrequent name terms disable index usage for address
1249 if (CONST_Search_NameOnlySearchFrequencyThreshold &&
1250 sizeof($aSearch['aName']) == 1 &&
1251 $aWordFrequencyScores[$aSearch['aName'][reset($aSearch['aName'])]] < CONST_Search_NameOnlySearchFrequencyThreshold)
1253 //$aTerms[] = "array_cat(nameaddress_vector,ARRAY[]::integer[]) @> ARRAY[".join(array_merge($aSearch['aAddress'],$aSearch['aAddressNonSearch']),",")."]";
1254 $aTerms[] = "array_cat(nameaddress_vector,ARRAY[]::integer[]) @> ARRAY[".join($aSearch['aAddress'],",")."]";
1258 $aTerms[] = "nameaddress_vector @> ARRAY[".join($aSearch['aAddress'],",")."]";
1259 //if (sizeof($aSearch['aAddressNonSearch'])) $aTerms[] = "array_cat(nameaddress_vector,ARRAY[]::integer[]) @> ARRAY[".join($aSearch['aAddressNonSearch'],",")."]";
1262 if ($aSearch['sCountryCode']) $aTerms[] = "country_code = '".pg_escape_string($aSearch['sCountryCode'])."'";
1263 if ($aSearch['sHouseNumber']) $aTerms[] = "address_rank between 16 and 27";
1264 if ($aSearch['fLon'] && $aSearch['fLat'])
1266 $aTerms[] = "ST_DWithin(centroid, ST_SetSRID(ST_Point(".$aSearch['fLon'].",".$aSearch['fLat']."),4326), ".$aSearch['fRadius'].")";
1267 $aOrder[] = "ST_Distance(centroid, ST_SetSRID(ST_Point(".$aSearch['fLon'].",".$aSearch['fLat']."),4326)) ASC";
1269 if (sizeof($this->aExcludePlaceIDs))
1271 $aTerms[] = "place_id not in (".join(',',$this->aExcludePlaceIDs).")";
1273 if ($sCountryCodesSQL)
1275 $aTerms[] = "country_code in ($sCountryCodesSQL)";
1278 if ($bBoundingBoxSearch) $aTerms[] = "centroid && $this->sViewboxSmallSQL";
1279 if ($sNearPointSQL) $aOrder[] = "ST_Distance($sNearPointSQL, centroid) asc";
1281 if ($aSearch['sHouseNumber'])
1283 $sImportanceSQL = '- abs(26 - address_rank) + 3';
1287 $sImportanceSQL = '(case when importance = 0 OR importance IS NULL then 0.75-(search_rank::float/40) else importance end)';
1289 if ($this->sViewboxSmallSQL) $sImportanceSQL .= " * case when ST_Contains($this->sViewboxSmallSQL, centroid) THEN 1 ELSE 0.5 END";
1290 if ($this->sViewboxLargeSQL) $sImportanceSQL .= " * case when ST_Contains($this->sViewboxLargeSQL, centroid) THEN 1 ELSE 0.5 END";
1292 $aOrder[] = "$sImportanceSQL DESC";
1293 if (sizeof($aSearch['aFullNameAddress']))
1295 $sExactMatchSQL = '(select count(*) from (select unnest(ARRAY['.join($aSearch['aFullNameAddress'],",").']) INTERSECT select unnest(nameaddress_vector))s) as exactmatch';
1296 $aOrder[] = 'exactmatch DESC';
1298 $sExactMatchSQL = '0::int as exactmatch';
1301 if (sizeof($aTerms))
1303 $sSQL = "select place_id, ";
1304 $sSQL .= $sExactMatchSQL;
1305 $sSQL .= " from search_name";
1306 $sSQL .= " where ".join(' and ',$aTerms);
1307 $sSQL .= " order by ".join(', ',$aOrder);
1308 if ($aSearch['sHouseNumber'] || $aSearch['sClass'])
1309 $sSQL .= " limit 50";
1310 elseif (!sizeof($aSearch['aName']) && !sizeof($aSearch['aAddress']) && $aSearch['sClass'])
1311 $sSQL .= " limit 1";
1313 $sSQL .= " limit ".$this->iLimit;
1315 if (CONST_Debug) { var_dump($sSQL); }
1316 $aViewBoxPlaceIDs = $this->oDB->getAll($sSQL);
1317 if (PEAR::IsError($aViewBoxPlaceIDs))
1319 failInternalError("Could not get places for search terms.", $sSQL, $aViewBoxPlaceIDs);
1321 //var_dump($aViewBoxPlaceIDs);
1322 // Did we have an viewbox matches?
1323 $aPlaceIDs = array();
1324 $bViewBoxMatch = false;
1325 foreach($aViewBoxPlaceIDs as $aViewBoxRow)
1327 //if ($bViewBoxMatch == 1 && $aViewBoxRow['in_small'] == 'f') break;
1328 //if ($bViewBoxMatch == 2 && $aViewBoxRow['in_large'] == 'f') break;
1329 //if ($aViewBoxRow['in_small'] == 't') $bViewBoxMatch = 1;
1330 //else if ($aViewBoxRow['in_large'] == 't') $bViewBoxMatch = 2;
1331 $aPlaceIDs[] = $aViewBoxRow['place_id'];
1332 $this->exactMatchCache[$aViewBoxRow['place_id']] = $aViewBoxRow['exactmatch'];
1335 //var_Dump($aPlaceIDs);
1338 if ($aSearch['sHouseNumber'] && sizeof($aPlaceIDs))
1340 $aRoadPlaceIDs = $aPlaceIDs;
1341 $sPlaceIDs = join(',',$aPlaceIDs);
1343 // Now they are indexed look for a house attached to a street we found
1344 $sHouseNumberRegex = '\\\\m'.str_replace(' ','[-,/ ]',$aSearch['sHouseNumber']).'\\\\M';
1345 $sSQL = "select place_id from placex where parent_place_id in (".$sPlaceIDs.") and housenumber ~* E'".$sHouseNumberRegex."'";
1346 if (sizeof($this->aExcludePlaceIDs))
1348 $sSQL .= " and place_id not in (".join(',',$this->aExcludePlaceIDs).")";
1350 $sSQL .= " limit $this->iLimit";
1351 if (CONST_Debug) var_dump($sSQL);
1352 $aPlaceIDs = $this->oDB->getCol($sSQL);
1354 // If not try the aux fallback table
1356 if (!sizeof($aPlaceIDs))
1358 $sSQL = "select place_id from location_property_aux where parent_place_id in (".$sPlaceIDs.") and housenumber = '".pg_escape_string($aSearch['sHouseNumber'])."'";
1359 if (sizeof($this->aExcludePlaceIDs))
1361 $sSQL .= " and place_id not in (".join(',',$this->aExcludePlaceIDs).")";
1363 //$sSQL .= " limit $this->iLimit";
1364 if (CONST_Debug) var_dump($sSQL);
1365 $aPlaceIDs = $this->oDB->getCol($sSQL);
1369 if (!sizeof($aPlaceIDs))
1371 $sSQL = "select place_id from location_property_tiger where parent_place_id in (".$sPlaceIDs.") and housenumber = '".pg_escape_string($aSearch['sHouseNumber'])."'";
1372 if (sizeof($this->aExcludePlaceIDs))
1374 $sSQL .= " and place_id not in (".join(',',$this->aExcludePlaceIDs).")";
1376 //$sSQL .= " limit $this->iLimit";
1377 if (CONST_Debug) var_dump($sSQL);
1378 $aPlaceIDs = $this->oDB->getCol($sSQL);
1381 // Fallback to the road
1382 if (!sizeof($aPlaceIDs) && preg_match('/[0-9]+/', $aSearch['sHouseNumber']))
1384 $aPlaceIDs = $aRoadPlaceIDs;
1389 if ($aSearch['sClass'] && sizeof($aPlaceIDs))
1391 $sPlaceIDs = join(',',$aPlaceIDs);
1392 $aClassPlaceIDs = array();
1394 if (!$aSearch['sOperator'] || $aSearch['sOperator'] == 'name')
1396 // If they were searching for a named class (i.e. 'Kings Head pub') then we might have an extra match
1397 $sSQL = "select place_id from placex where place_id in ($sPlaceIDs) and class='".$aSearch['sClass']."' and type='".$aSearch['sType']."'";
1398 $sSQL .= " and linked_place_id is null";
1399 if ($sCountryCodesSQL) $sSQL .= " and calculated_country_code in ($sCountryCodesSQL)";
1400 $sSQL .= " order by rank_search asc limit $this->iLimit";
1401 if (CONST_Debug) var_dump($sSQL);
1402 $aClassPlaceIDs = $this->oDB->getCol($sSQL);
1405 if (!$aSearch['sOperator'] || $aSearch['sOperator'] == 'near') // & in
1407 $sSQL = "select count(*) from pg_tables where tablename = 'place_classtype_".$aSearch['sClass']."_".$aSearch['sType']."'";
1408 $bCacheTable = $this->oDB->getOne($sSQL);
1410 $sSQL = "select min(rank_search) from placex where place_id in ($sPlaceIDs)";
1412 if (CONST_Debug) var_dump($sSQL);
1413 $this->iMaxRank = ((int)$this->oDB->getOne($sSQL));
1415 // For state / country level searches the normal radius search doesn't work very well
1416 $sPlaceGeom = false;
1417 if ($this->iMaxRank < 9 && $bCacheTable)
1419 // Try and get a polygon to search in instead
1420 $sSQL = "select geometry from placex where place_id in ($sPlaceIDs) and rank_search < $this->iMaxRank + 5 and st_geometrytype(geometry) in ('ST_Polygon','ST_MultiPolygon') order by rank_search asc limit 1";
1421 if (CONST_Debug) var_dump($sSQL);
1422 $sPlaceGeom = $this->oDB->getOne($sSQL);
1431 $this->iMaxRank += 5;
1432 $sSQL = "select place_id from placex where place_id in ($sPlaceIDs) and rank_search < $this->iMaxRank";
1433 if (CONST_Debug) var_dump($sSQL);
1434 $aPlaceIDs = $this->oDB->getCol($sSQL);
1435 $sPlaceIDs = join(',',$aPlaceIDs);
1438 if ($sPlaceIDs || $sPlaceGeom)
1444 // More efficient - can make the range bigger
1448 if ($sNearPointSQL) $sOrderBySQL = "ST_Distance($sNearPointSQL, l.centroid)";
1449 else if ($sPlaceIDs) $sOrderBySQL = "ST_Distance(l.centroid, f.geometry)";
1450 else if ($sPlaceGeom) $sOrderBysSQL = "ST_Distance(st_centroid('".$sPlaceGeom."'), l.centroid)";
1452 $sSQL = "select distinct l.place_id".($sOrderBySQL?','.$sOrderBySQL:'')." from place_classtype_".$aSearch['sClass']."_".$aSearch['sType']." as l";
1453 if ($sCountryCodesSQL) $sSQL .= " join placex as lp using (place_id)";
1456 $sSQL .= ",placex as f where ";
1457 $sSQL .= "f.place_id in ($sPlaceIDs) and ST_DWithin(l.centroid, f.centroid, $fRange) ";
1462 $sSQL .= "ST_Contains('".$sPlaceGeom."', l.centroid) ";
1464 if (sizeof($this->aExcludePlaceIDs))
1466 $sSQL .= " and l.place_id not in (".join(',',$this->aExcludePlaceIDs).")";
1468 if ($sCountryCodesSQL) $sSQL .= " and lp.calculated_country_code in ($sCountryCodesSQL)";
1469 if ($sOrderBySQL) $sSQL .= "order by ".$sOrderBySQL." asc";
1470 if ($iOffset) $sSQL .= " offset $iOffset";
1471 $sSQL .= " limit $this->iLimit";
1472 if (CONST_Debug) var_dump($sSQL);
1473 $aClassPlaceIDs = array_merge($aClassPlaceIDs, $this->oDB->getCol($sSQL));
1477 if (isset($aSearch['fRadius']) && $aSearch['fRadius']) $fRange = $aSearch['fRadius'];
1480 if ($sNearPointSQL) $sOrderBySQL = "ST_Distance($sNearPointSQL, l.geometry)";
1481 else $sOrderBySQL = "ST_Distance(l.geometry, f.geometry)";
1483 $sSQL = "select distinct l.place_id".($sOrderBysSQL?','.$sOrderBysSQL:'')." from placex as l,placex as f where ";
1484 $sSQL .= "f.place_id in ( $sPlaceIDs) and ST_DWithin(l.geometry, f.centroid, $fRange) ";
1485 $sSQL .= "and l.class='".$aSearch['sClass']."' and l.type='".$aSearch['sType']."' ";
1486 if (sizeof($this->aExcludePlaceIDs))
1488 $sSQL .= " and l.place_id not in (".join(',',$this->aExcludePlaceIDs).")";
1490 if ($sCountryCodesSQL) $sSQL .= " and l.calculated_country_code in ($sCountryCodesSQL)";
1491 if ($sOrderBy) $sSQL .= "order by ".$OrderBysSQL." asc";
1492 if ($iOffset) $sSQL .= " offset $iOffset";
1493 $sSQL .= " limit $this->iLimit";
1494 if (CONST_Debug) var_dump($sSQL);
1495 $aClassPlaceIDs = array_merge($aClassPlaceIDs, $this->oDB->getCol($sSQL));
1500 $aPlaceIDs = $aClassPlaceIDs;
1506 if (PEAR::IsError($aPlaceIDs))
1508 failInternalError("Could not get place IDs from tokens." ,$sSQL, $aPlaceIDs);
1511 if (CONST_Debug) { echo "<br><b>Place IDs:</b> "; var_Dump($aPlaceIDs); }
1513 foreach($aPlaceIDs as $iPlaceID)
1515 $aResultPlaceIDs[$iPlaceID] = $iPlaceID;
1517 if ($iQueryLoop > 20) break;
1520 if (isset($aResultPlaceIDs) && sizeof($aResultPlaceIDs) && ($this->iMinAddressRank != 0 || $this->iMaxAddressRank != 30))
1522 // Need to verify passes rank limits before dropping out of the loop (yuk!)
1523 $sSQL = "select place_id from placex where place_id in (".join(',',$aResultPlaceIDs).") ";
1524 $sSQL .= "and (placex.rank_address between $this->iMinAddressRank and $this->iMaxAddressRank ";
1525 if (14 >= $this->iMinAddressRank && 14 <= $this->iMaxAddressRank) $sSQL .= " OR (extratags->'place') = 'city'";
1526 if ($this->aAddressRankList) $sSQL .= " OR placex.rank_address in (".join(',',$this->aAddressRankList).")";
1527 $sSQL .= ") UNION select place_id from location_property_tiger where place_id in (".join(',',$aResultPlaceIDs).") ";
1528 $sSQL .= "and (30 between $this->iMinAddressRank and $this->iMaxAddressRank ";
1529 if ($this->aAddressRankList) $sSQL .= " OR 30 in (".join(',',$this->aAddressRankList).")";
1531 if (CONST_Debug) var_dump($sSQL);
1532 $aResultPlaceIDs = $this->oDB->getCol($sSQL);
1536 if (isset($aResultPlaceIDs) && sizeof($aResultPlaceIDs)) break;
1537 if ($iGroupLoop > 4) break;
1538 if ($iQueryLoop > 30) break;
1541 // Did we find anything?
1542 if (isset($aResultPlaceIDs) && sizeof($aResultPlaceIDs))
1544 $aSearchResults = $this->getDetails($aResultPlaceIDs);
1550 // Just interpret as a reverse geocode
1551 $iPlaceID = geocodeReverse((float)$this->aNearPoint[0], (float)$this->aNearPoint[1]);
1553 $aSearchResults = $this->getDetails(array($iPlaceID));
1555 $aSearchResults = array();
1559 if (!sizeof($aSearchResults))
1561 if ($this->bFallback)
1563 if ($this->fallbackStructuredQuery())
1565 return $this->lookup();
1572 $aClassType = getClassTypesWithImportance();
1573 $aRecheckWords = preg_split('/\b/u',$sQuery);
1574 foreach($aRecheckWords as $i => $sWord)
1576 if (!$sWord) unset($aRecheckWords[$i]);
1579 foreach($aSearchResults as $iResNum => $aResult)
1581 if (CONST_Search_AreaPolygons)
1583 // Get the bounding box and outline polygon
1584 $sSQL = "select place_id,0 as numfeatures,st_area(geometry) as area,";
1585 $sSQL .= "ST_Y(centroid) as centrelat,ST_X(centroid) as centrelon,";
1586 $sSQL .= "ST_Y(ST_PointN(ST_ExteriorRing(Box2D(geometry)),4)) as minlat,ST_Y(ST_PointN(ST_ExteriorRing(Box2D(geometry)),2)) as maxlat,";
1587 $sSQL .= "ST_X(ST_PointN(ST_ExteriorRing(Box2D(geometry)),1)) as minlon,ST_X(ST_PointN(ST_ExteriorRing(Box2D(geometry)),3)) as maxlon";
1588 if ($this->bIncludePolygonAsGeoJSON) $sSQL .= ",ST_AsGeoJSON(geometry) as asgeojson";
1589 if ($this->bIncludePolygonAsKML) $sSQL .= ",ST_AsKML(geometry) as askml";
1590 if ($this->bIncludePolygonAsSVG) $sSQL .= ",ST_AsSVG(geometry) as assvg";
1591 if ($this->bIncludePolygonAsText || $this->bIncludePolygonAsPoints) $sSQL .= ",ST_AsText(geometry) as astext";
1592 $sSQL .= " from placex where place_id = ".$aResult['place_id'].' and st_geometrytype(Box2D(geometry)) = \'ST_Polygon\'';
1593 $aPointPolygon = $this->oDB->getRow($sSQL);
1594 if (PEAR::IsError($aPointPolygon))
1596 failInternalError("Could not get outline.", $sSQL, $aPointPolygon);
1599 if ($aPointPolygon['place_id'])
1601 if ($this->bIncludePolygonAsGeoJSON) $aResult['asgeojson'] = $aPointPolygon['asgeojson'];
1602 if ($this->bIncludePolygonAsKML) $aResult['askml'] = $aPointPolygon['askml'];
1603 if ($this->bIncludePolygonAsSVG) $aResult['assvg'] = $aPointPolygon['assvg'];
1604 if ($this->bIncludePolygonAsText) $aResult['astext'] = $aPointPolygon['astext'];
1606 if ($aPointPolygon['centrelon'] !== null && $aPointPolygon['centrelat'] !== null )
1608 $aResult['lat'] = $aPointPolygon['centrelat'];
1609 $aResult['lon'] = $aPointPolygon['centrelon'];
1612 if ($this->bIncludePolygonAsPoints)
1614 // Translate geometary string to point array
1615 if (preg_match('#POLYGON\\(\\(([- 0-9.,]+)#',$aPointPolygon['astext'],$aMatch))
1617 preg_match_all('/(-?[0-9.]+) (-?[0-9.]+)/',$aMatch[1],$aPolyPoints,PREG_SET_ORDER);
1620 elseif (preg_match('#MULTIPOLYGON\\(\\(\\(([- 0-9.,]+)#',$aPointPolygon['astext'],$aMatch))
1622 preg_match_all('/(-?[0-9.]+) (-?[0-9.]+)/',$aMatch[1],$aPolyPoints,PREG_SET_ORDER);
1625 elseif (preg_match('#POINT\\((-?[0-9.]+) (-?[0-9.]+)\\)#',$aPointPolygon['astext'],$aMatch))
1628 $iSteps = ($fRadius * 40000)^2;
1629 $fStepSize = (2*pi())/$iSteps;
1630 $aPolyPoints = array();
1631 for($f = 0; $f < 2*pi(); $f += $fStepSize)
1633 $aPolyPoints[] = array('',$aMatch[1]+($fRadius*sin($f)),$aMatch[2]+($fRadius*cos($f)));
1635 $aPointPolygon['minlat'] = $aPointPolygon['minlat'] - $fRadius;
1636 $aPointPolygon['maxlat'] = $aPointPolygon['maxlat'] + $fRadius;
1637 $aPointPolygon['minlon'] = $aPointPolygon['minlon'] - $fRadius;
1638 $aPointPolygon['maxlon'] = $aPointPolygon['maxlon'] + $fRadius;
1642 // Output data suitable for display (points and a bounding box)
1643 if ($this->bIncludePolygonAsPoints && isset($aPolyPoints))
1645 $aResult['aPolyPoints'] = array();
1646 foreach($aPolyPoints as $aPoint)
1648 $aResult['aPolyPoints'][] = array($aPoint[1], $aPoint[2]);
1651 $aResult['aBoundingBox'] = array($aPointPolygon['minlat'],$aPointPolygon['maxlat'],$aPointPolygon['minlon'],$aPointPolygon['maxlon']);
1655 if ($aResult['extra_place'] == 'city')
1657 $aResult['class'] = 'place';
1658 $aResult['type'] = 'city';
1659 $aResult['rank_search'] = 16;
1662 if (!isset($aResult['aBoundingBox']))
1665 $fDiameter = 0.0001;
1667 if (isset($aClassType[$aResult['class'].':'.$aResult['type'].':'.$aResult['admin_level']]['defdiameter'])
1668 && $aClassType[$aResult['class'].':'.$aResult['type'].':'.$aResult['admin_level']]['defdiameter'])
1670 $fDiameter = $aClassType[$aResult['class'].':'.$aResult['type'].':'.$aResult['admin_level']]['defzoom'];
1672 elseif (isset($aClassType[$aResult['class'].':'.$aResult['type']]['defdiameter'])
1673 && $aClassType[$aResult['class'].':'.$aResult['type']]['defdiameter'])
1675 $fDiameter = $aClassType[$aResult['class'].':'.$aResult['type']]['defdiameter'];
1677 $fRadius = $fDiameter / 2;
1679 $iSteps = max(8,min(100,$fRadius * 3.14 * 100000));
1680 $fStepSize = (2*pi())/$iSteps;
1681 $aPolyPoints = array();
1682 for($f = 0; $f < 2*pi(); $f += $fStepSize)
1684 $aPolyPoints[] = array('',$aResult['lon']+($fRadius*sin($f)),$aResult['lat']+($fRadius*cos($f)));
1686 $aPointPolygon['minlat'] = $aResult['lat'] - $fRadius;
1687 $aPointPolygon['maxlat'] = $aResult['lat'] + $fRadius;
1688 $aPointPolygon['minlon'] = $aResult['lon'] - $fRadius;
1689 $aPointPolygon['maxlon'] = $aResult['lon'] + $fRadius;
1691 // Output data suitable for display (points and a bounding box)
1692 if ($this->bIncludePolygonAsPoints)
1694 $aResult['aPolyPoints'] = array();
1695 foreach($aPolyPoints as $aPoint)
1697 $aResult['aPolyPoints'][] = array($aPoint[1], $aPoint[2]);
1700 $aResult['aBoundingBox'] = array((string)$aPointPolygon['minlat'],(string)$aPointPolygon['maxlat'],(string)$aPointPolygon['minlon'],(string)$aPointPolygon['maxlon']);
1703 // Is there an icon set for this type of result?
1704 if (isset($aClassType[$aResult['class'].':'.$aResult['type']]['icon'])
1705 && $aClassType[$aResult['class'].':'.$aResult['type']]['icon'])
1707 $aResult['icon'] = CONST_Website_BaseURL.'images/mapicons/'.$aClassType[$aResult['class'].':'.$aResult['type']]['icon'].'.p.20.png';
1710 if (isset($aClassType[$aResult['class'].':'.$aResult['type'].':'.$aResult['admin_level']]['label'])
1711 && $aClassType[$aResult['class'].':'.$aResult['type'].':'.$aResult['admin_level']]['label'])
1713 $aResult['label'] = $aClassType[$aResult['class'].':'.$aResult['type'].':'.$aResult['admin_level']]['label'];
1715 elseif (isset($aClassType[$aResult['class'].':'.$aResult['type']]['label'])
1716 && $aClassType[$aResult['class'].':'.$aResult['type']]['label'])
1718 $aResult['label'] = $aClassType[$aResult['class'].':'.$aResult['type']]['label'];
1721 if ($this->bIncludeAddressDetails)
1723 $aResult['address'] = getAddressDetails($this->oDB, $sLanguagePrefArraySQL, $aResult['place_id'], $aResult['country_code']);
1724 if ($aResult['extra_place'] == 'city' && !isset($aResult['address']['city']))
1726 $aResult['address'] = array_merge(array('city' => array_shift(array_values($aResult['address']))), $aResult['address']);
1730 // Adjust importance for the number of exact string matches in the result
1731 $aResult['importance'] = max(0.001,$aResult['importance']);
1733 $sAddress = $aResult['langaddress'];
1734 foreach($aRecheckWords as $i => $sWord)
1736 if (stripos($sAddress, $sWord)!==false) $iCountWords++;
1739 $aResult['importance'] = $aResult['importance'] + ($iCountWords*0.1); // 0.1 is a completely arbitrary number but something in the range 0.1 to 0.5 would seem right
1741 $aResult['name'] = $aResult['langaddress'];
1742 // secondary ordering (for results with same importance (the smaller the better):
1743 // - approximate importance of address parts
1744 $aResult['foundorder'] = -$aResult['addressimportance']/10;
1745 // - number of exact matches from the query
1746 if (isset($this->exactMatchCache[$aResult['place_id']]))
1747 $aResult['foundorder'] -= $this->exactMatchCache[$aResult['place_id']];
1748 else if (isset($this->exactMatchCache[$aResult['parent_place_id']]))
1749 $aResult['foundorder'] -= $this->exactMatchCache[$aResult['parent_place_id']];
1750 // - importance of the class/type
1751 if (isset($aClassType[$aResult['class'].':'.$aResult['type']]['importance'])
1752 && $aClassType[$aResult['class'].':'.$aResult['type']]['importance'])
1754 $aResult['foundorder'] = $aResult['foundorder'] + 0.000001 * $aClassType[$aResult['class'].':'.$aResult['type']]['importance'];
1758 $aResult['foundorder'] = $aResult['foundorder'] + 0.001;
1760 $aSearchResults[$iResNum] = $aResult;
1762 uasort($aSearchResults, 'byImportance');
1764 $aOSMIDDone = array();
1765 $aClassTypeNameDone = array();
1766 $aToFilter = $aSearchResults;
1767 $aSearchResults = array();
1770 foreach($aToFilter as $iResNum => $aResult)
1772 if ($aResult['type'] == 'adminitrative') $aResult['type'] = 'administrative';
1773 $this->aExcludePlaceIDs[$aResult['place_id']] = $aResult['place_id'];
1776 $fLat = $aResult['lat'];
1777 $fLon = $aResult['lon'];
1778 if (isset($aResult['zoom'])) $iZoom = $aResult['zoom'];
1781 if (!$this->bDeDupe || (!isset($aOSMIDDone[$aResult['osm_type'].$aResult['osm_id']])
1782 && !isset($aClassTypeNameDone[$aResult['osm_type'].$aResult['class'].$aResult['type'].$aResult['name'].$aResult['admin_level']])))
1784 $aOSMIDDone[$aResult['osm_type'].$aResult['osm_id']] = true;
1785 $aClassTypeNameDone[$aResult['osm_type'].$aResult['class'].$aResult['type'].$aResult['name'].$aResult['admin_level']] = true;
1786 $aSearchResults[] = $aResult;
1789 // Absolute limit on number of results
1790 if (sizeof($aSearchResults) >= $this->iFinalLimit) break;
1793 return $aSearchResults;
1802 if (isset($_GET['route']) && $_GET['route'] && isset($_GET['routewidth']) && $_GET['routewidth'])
1804 $aPoints = explode(',',$_GET['route']);
1805 if (sizeof($aPoints) % 2 != 0)
1807 userError("Uneven number of points");
1810 $sViewboxCentreSQL = "ST_SetSRID('LINESTRING(";
1811 $fPrevCoord = false;