+ $aNewPhraseSearches = array_merge($aNewPhraseSearches, $aNewWordsetSearches);
+ usort($aNewPhraseSearches, 'bySearchRank');
+
+ $aSearchHash = array();
+ foreach ($aNewPhraseSearches as $iSearch => $aSearch) {
+ $sHash = serialize($aSearch);
+ if (isset($aSearchHash[$sHash])) unset($aNewPhraseSearches[$iSearch]);
+ else $aSearchHash[$sHash] = 1;
+ }
+
+ $aNewPhraseSearches = array_slice($aNewPhraseSearches, 0, 50);
+ }
+
+ // Re-group the searches by their score, junk anything over 20 as just not worth trying
+ $aGroupedSearches = array();
+ foreach ($aNewPhraseSearches as $aSearch) {
+ if ($aSearch['iSearchRank'] < $this->iMaxRank) {
+ if (!isset($aGroupedSearches[$aSearch['iSearchRank']])) $aGroupedSearches[$aSearch['iSearchRank']] = array();
+ $aGroupedSearches[$aSearch['iSearchRank']][] = $aSearch;
+ }
+ }
+ ksort($aGroupedSearches);
+
+ $iSearchCount = 0;
+ $aSearches = array();
+ foreach ($aGroupedSearches as $iScore => $aNewSearches) {
+ $iSearchCount += sizeof($aNewSearches);
+ $aSearches = array_merge($aSearches, $aNewSearches);
+ if ($iSearchCount > 50) break;
+ }
+
+ //if (CONST_Debug) _debugDumpGroupedSearches($aGroupedSearches, $aValidTokens);
+ }
+ return $aGroupedSearches;
+ }
+
+ /* Perform the actual query lookup.
+
+ Returns an ordered list of results, each with the following fields:
+ osm_type: type of corresponding OSM object
+ N - node
+ W - way
+ R - relation
+ P - postcode (internally computed)
+ osm_id: id of corresponding OSM object
+ class: general object class (corresponds to tag key of primary OSM tag)
+ type: subclass of object (corresponds to tag value of primary OSM tag)
+ admin_level: see http://wiki.openstreetmap.org/wiki/Admin_level
+ rank_search: rank in search hierarchy
+ (see also http://wiki.openstreetmap.org/wiki/Nominatim/Development_overview#Country_to_street_level)
+ rank_address: rank in address hierarchy (determines orer in address)
+ place_id: internal key (may differ between different instances)
+ country_code: ISO country code
+ langaddress: localized full address
+ placename: localized name of object
+ ref: content of ref tag (if available)
+ lon: longitude
+ lat: latitude
+ importance: importance of place based on Wikipedia link count
+ addressimportance: cumulated importance of address elements
+ extra_place: type of place (for admin boundaries, if there is a place tag)
+ aBoundingBox: bounding Box
+ label: short description of the object class/type (English only)
+ name: full name (currently the same as langaddress)
+ foundorder: secondary ordering for places with same importance
+ */
+
+
+ public function lookup()
+ {
+ if (!$this->sQuery && !$this->aStructuredQuery) return false;
+
+ $sLanguagePrefArraySQL = "ARRAY[".join(',', array_map("getDBQuoted", $this->aLangPrefOrder))."]";
+ $sCountryCodesSQL = false;
+ if ($this->aCountryCodes) {
+ $sCountryCodesSQL = join(',', array_map('addQuotes', $this->aCountryCodes));
+ }
+
+ $sQuery = $this->sQuery;
+ if (!preg_match('//u', $sQuery)) {
+ userError("Query string is not UTF-8 encoded.");
+ }
+
+ // Conflicts between US state abreviations and various words for 'the' in different languages
+ if (isset($this->aLangPrefOrder['name:en'])) {
+ $sQuery = preg_replace('/(^|,)\s*il\s*(,|$)/', '\1illinois\2', $sQuery);
+ $sQuery = preg_replace('/(^|,)\s*al\s*(,|$)/', '\1alabama\2', $sQuery);
+ $sQuery = preg_replace('/(^|,)\s*la\s*(,|$)/', '\1louisiana\2', $sQuery);
+ }
+
+ $bBoundingBoxSearch = $this->bBoundedSearch && $this->sViewboxSmallSQL;
+ if ($this->sViewboxCentreSQL) {
+ // For complex viewboxes (routes) precompute the bounding geometry
+ $sGeom = chksql(
+ $this->oDB->getOne("select ".$this->sViewboxSmallSQL),
+ "Could not get small viewbox"
+ );
+ $this->sViewboxSmallSQL = "'".$sGeom."'::geometry";
+
+ $sGeom = chksql(
+ $this->oDB->getOne("select ".$this->sViewboxLargeSQL),
+ "Could not get large viewbox"
+ );
+ $this->sViewboxLargeSQL = "'".$sGeom."'::geometry";
+ }
+
+ // Do we have anything that looks like a lat/lon pair?
+ if ($aLooksLike = looksLikeLatLonPair($sQuery)) {
+ $this->setNearPoint(array($aLooksLike['lat'], $aLooksLike['lon']));
+ $sQuery = $aLooksLike['query'];
+ }
+
+ $aSearchResults = array();
+ if ($sQuery || $this->aStructuredQuery) {
+ // Start with a blank search
+ $aSearches = array(
+ array(
+ 'iSearchRank' => 0,
+ 'iNamePhrase' => -1,
+ 'sCountryCode' => false,
+ 'aName' => array(),
+ 'aAddress' => array(),
+ 'aFullNameAddress' => array(),
+ 'aNameNonSearch' => array(),
+ 'aAddressNonSearch' => array(),
+ 'sOperator' => '',
+ 'aFeatureName' => array(),
+ 'sClass' => '',
+ 'sType' => '',
+ 'sHouseNumber' => '',
+ 'fLat' => '',
+ 'fLon' => '',
+ 'fRadius' => ''
+ )
+ );
+
+ // Do we have a radius search?
+ $sNearPointSQL = false;
+ if ($this->aNearPoint) {
+ $sNearPointSQL = "ST_SetSRID(ST_Point(".(float)$this->aNearPoint[1].",".(float)$this->aNearPoint[0]."),4326)";
+ $aSearches[0]['fLat'] = (float)$this->aNearPoint[0];
+ $aSearches[0]['fLon'] = (float)$this->aNearPoint[1];
+ $aSearches[0]['fRadius'] = (float)$this->aNearPoint[2];
+ }
+
+ // Any 'special' terms in the search?
+ $bSpecialTerms = false;
+ preg_match_all('/\\[(.*)=(.*)\\]/', $sQuery, $aSpecialTermsRaw, PREG_SET_ORDER);
+ $aSpecialTerms = array();
+ foreach ($aSpecialTermsRaw as $aSpecialTerm) {
+ $sQuery = str_replace($aSpecialTerm[0], ' ', $sQuery);
+ $aSpecialTerms[strtolower($aSpecialTerm[1])] = $aSpecialTerm[2];
+ }
+
+ preg_match_all('/\\[([\\w ]*)\\]/u', $sQuery, $aSpecialTermsRaw, PREG_SET_ORDER);
+ $aSpecialTerms = array();
+ if (isset($this->aStructuredQuery['amenity']) && $this->aStructuredQuery['amenity']) {
+ $aSpecialTermsRaw[] = array('['.$this->aStructuredQuery['amenity'].']', $this->aStructuredQuery['amenity']);
+ unset($this->aStructuredQuery['amenity']);
+ }
+
+ foreach ($aSpecialTermsRaw as $aSpecialTerm) {
+ $sQuery = str_replace($aSpecialTerm[0], ' ', $sQuery);
+ $sToken = chksql($this->oDB->getOne("SELECT make_standard_name('".$aSpecialTerm[1]."') AS string"));
+ $sSQL = 'SELECT * ';
+ $sSQL .= 'FROM ( ';
+ $sSQL .= ' SELECT word_id, word_token, word, class, type, country_code, operator';
+ $sSQL .= ' FROM word ';
+ $sSQL .= ' WHERE word_token in (\' '.$sToken.'\')';
+ $sSQL .= ') AS x ';
+ $sSQL .= ' WHERE (class is not null AND class not in (\'place\')) ';
+ $sSQL .= ' OR country_code is not null';
+ if (CONST_Debug) var_Dump($sSQL);
+ $aSearchWords = chksql($this->oDB->getAll($sSQL));
+ $aNewSearches = array();
+ foreach ($aSearches as $aSearch) {
+ foreach ($aSearchWords as $aSearchTerm) {
+ $aNewSearch = $aSearch;
+ if ($aSearchTerm['country_code']) {
+ $aNewSearch['sCountryCode'] = strtolower($aSearchTerm['country_code']);
+ $aNewSearches[] = $aNewSearch;
+ $bSpecialTerms = true;
+ }
+ if ($aSearchTerm['class']) {
+ $aNewSearch['sClass'] = $aSearchTerm['class'];
+ $aNewSearch['sType'] = $aSearchTerm['type'];
+ $aNewSearches[] = $aNewSearch;
+ $bSpecialTerms = true;
+ }
+ }
+ }
+ $aSearches = $aNewSearches;
+ }
+
+ // Split query into phrases
+ // Commas are used to reduce the search space by indicating where phrases split
+ if ($this->aStructuredQuery) {
+ $aPhrases = $this->aStructuredQuery;
+ $bStructuredPhrases = true;
+ } else {
+ $aPhrases = explode(',', $sQuery);
+ $bStructuredPhrases = false;
+ }
+
+ // Convert each phrase to standard form
+ // Create a list of standard words
+ // Get all 'sets' of words
+ // Generate a complete list of all
+ $aTokens = array();
+ foreach ($aPhrases as $iPhrase => $sPhrase) {
+ $aPhrase = chksql(
+ $this->oDB->getRow("SELECT make_standard_name('".pg_escape_string($sPhrase)."') as string"),
+ "Cannot normalize query string (is it a UTF-8 string?)"
+ );
+ if (trim($aPhrase['string'])) {
+ $aPhrases[$iPhrase] = $aPhrase;
+ $aPhrases[$iPhrase]['words'] = explode(' ', $aPhrases[$iPhrase]['string']);
+ $aPhrases[$iPhrase]['wordsets'] = getWordSets($aPhrases[$iPhrase]['words'], 0);
+ $aTokens = array_merge($aTokens, getTokensFromSets($aPhrases[$iPhrase]['wordsets']));
+ } else {
+ unset($aPhrases[$iPhrase]);
+ }
+ }
+
+ // Reindex phrases - we make assumptions later on that they are numerically keyed in order
+ $aPhraseTypes = array_keys($aPhrases);
+ $aPhrases = array_values($aPhrases);
+
+ if (sizeof($aTokens)) {
+ // Check which tokens we have, get the ID numbers
+ $sSQL = 'SELECT word_id, word_token, word, class, type, country_code, operator, search_name_count';
+ $sSQL .= ' FROM word ';
+ $sSQL .= ' WHERE word_token in ('.join(',', array_map("getDBQuoted", $aTokens)).')';
+
+ if (CONST_Debug) var_Dump($sSQL);
+
+ $aValidTokens = array();
+ if (sizeof($aTokens)) {
+ $aDatabaseWords = chksql(
+ $this->oDB->getAll($sSQL),
+ "Could not get word tokens."
+ );
+ } else {
+ $aDatabaseWords = array();
+ }
+ $aPossibleMainWordIDs = array();
+ $aWordFrequencyScores = array();
+ foreach ($aDatabaseWords as $aToken) {
+ // Very special case - require 2 letter country param to match the country code found
+ if ($bStructuredPhrases && $aToken['country_code'] && !empty($this->aStructuredQuery['country'])
+ && strlen($this->aStructuredQuery['country']) == 2 && strtolower($this->aStructuredQuery['country']) != $aToken['country_code']
+ ) {
+ continue;
+ }
+
+ if (isset($aValidTokens[$aToken['word_token']])) {
+ $aValidTokens[$aToken['word_token']][] = $aToken;
+ } else {
+ $aValidTokens[$aToken['word_token']] = array($aToken);
+ }
+ if (!$aToken['class'] && !$aToken['country_code']) $aPossibleMainWordIDs[$aToken['word_id']] = 1;
+ $aWordFrequencyScores[$aToken['word_id']] = $aToken['search_name_count'] + 1;
+ }
+ if (CONST_Debug) var_Dump($aPhrases, $aValidTokens);
+
+ // Try and calculate GB postcodes we might be missing
+ foreach ($aTokens as $sToken) {
+ // Source of gb postcodes is now definitive - always use
+ if (preg_match('/^([A-Z][A-Z]?[0-9][0-9A-Z]? ?[0-9])([A-Z][A-Z])$/', strtoupper(trim($sToken)), $aData)) {
+ if (substr($aData[1], -2, 1) != ' ') {
+ $aData[0] = substr($aData[0], 0, strlen($aData[1])-1).' '.substr($aData[0], strlen($aData[1])-1);
+ $aData[1] = substr($aData[1], 0, -1).' '.substr($aData[1], -1, 1);
+ }
+ $aGBPostcodeLocation = gbPostcodeCalculate($aData[0], $aData[1], $aData[2], $this->oDB);
+ if ($aGBPostcodeLocation) {
+ $aValidTokens[$sToken] = $aGBPostcodeLocation;
+ }
+ } elseif (!isset($aValidTokens[$sToken]) && preg_match('/^([0-9]{5}) [0-9]{4}$/', $sToken, $aData)) {
+ // US ZIP+4 codes - if there is no token,
+ // merge in the 5-digit ZIP code
+ if (isset($aValidTokens[$aData[1]])) {
+ foreach ($aValidTokens[$aData[1]] as $aToken) {
+ if (!$aToken['class']) {
+ if (isset($aValidTokens[$sToken])) {
+ $aValidTokens[$sToken][] = $aToken;
+ } else {
+ $aValidTokens[$sToken] = array($aToken);
+ }
+ }
+ }
+ }
+ }
+ }
+
+ foreach ($aTokens as $sToken) {
+ // Unknown single word token with a number - assume it is a house number
+ if (!isset($aValidTokens[' '.$sToken]) && strpos($sToken, ' ') === false && preg_match('/[0-9]/', $sToken)) {
+ $aValidTokens[' '.$sToken] = array(array('class' => 'place', 'type' => 'house'));
+ }
+ }
+
+ // Any words that have failed completely?
+ // TODO: suggestions
+
+ // Start the search process
+ // array with: placeid => -1 | tiger-housenumber
+ $aResultPlaceIDs = array();
+
+ $aGroupedSearches = $this->getGroupedSearches($aSearches, $aPhraseTypes, $aPhrases, $aValidTokens, $aWordFrequencyScores, $bStructuredPhrases);
+
+ if ($this->bReverseInPlan) {
+ // Reverse phrase array and also reverse the order of the wordsets in
+ // the first and final phrase. Don't bother about phrases in the middle
+ // because order in the address doesn't matter.
+ $aPhrases = array_reverse($aPhrases);
+ $aPhrases[0]['wordsets'] = getInverseWordSets($aPhrases[0]['words'], 0);
+ if (sizeof($aPhrases) > 1) {
+ $aFinalPhrase = end($aPhrases);
+ $aPhrases[sizeof($aPhrases)-1]['wordsets'] = getInverseWordSets($aFinalPhrase['words'], 0);
+ }
+ $aReverseGroupedSearches = $this->getGroupedSearches($aSearches, null, $aPhrases, $aValidTokens, $aWordFrequencyScores, false);
+
+ foreach ($aGroupedSearches as $aSearches) {
+ foreach ($aSearches as $aSearch) {
+ if ($aSearch['iSearchRank'] < $this->iMaxRank) {
+ if (!isset($aReverseGroupedSearches[$aSearch['iSearchRank']])) $aReverseGroupedSearches[$aSearch['iSearchRank']] = array();
+ $aReverseGroupedSearches[$aSearch['iSearchRank']][] = $aSearch;
+ }
+ }
+ }
+
+ $aGroupedSearches = $aReverseGroupedSearches;
+ ksort($aGroupedSearches);
+ }
+ } else {
+ // Re-group the searches by their score, junk anything over 20 as just not worth trying
+ $aGroupedSearches = array();
+ foreach ($aSearches as $aSearch) {
+ if ($aSearch['iSearchRank'] < $this->iMaxRank) {
+ if (!isset($aGroupedSearches[$aSearch['iSearchRank']])) $aGroupedSearches[$aSearch['iSearchRank']] = array();
+ $aGroupedSearches[$aSearch['iSearchRank']][] = $aSearch;
+ }
+ }
+ ksort($aGroupedSearches);
+ }
+
+ if (CONST_Debug) var_Dump($aGroupedSearches);
+ if (CONST_Search_TryDroppedAddressTerms && sizeof($this->aStructuredQuery) > 0) {
+ $aCopyGroupedSearches = $aGroupedSearches;
+ foreach ($aCopyGroupedSearches as $iGroup => $aSearches) {
+ foreach ($aSearches as $iSearch => $aSearch) {
+ $aReductionsList = array($aSearch['aAddress']);
+ $iSearchRank = $aSearch['iSearchRank'];
+ while (sizeof($aReductionsList) > 0) {
+ $iSearchRank += 5;
+ if ($iSearchRank > iMaxRank) break 3;
+ $aNewReductionsList = array();
+ foreach ($aReductionsList as $aReductionsWordList) {
+ for ($iReductionWord = 0; $iReductionWord < sizeof($aReductionsWordList); $iReductionWord++) {
+ $aReductionsWordListResult = array_merge(array_slice($aReductionsWordList, 0, $iReductionWord), array_slice($aReductionsWordList, $iReductionWord+1));
+ $aReverseSearch = $aSearch;
+ $aSearch['aAddress'] = $aReductionsWordListResult;
+ $aSearch['iSearchRank'] = $iSearchRank;
+ $aGroupedSearches[$iSearchRank][] = $aReverseSearch;
+ if (sizeof($aReductionsWordListResult) > 0) {
+ $aNewReductionsList[] = $aReductionsWordListResult;
+ }
+ }
+ }
+ $aReductionsList = $aNewReductionsList;
+ }
+ }
+ }
+ ksort($aGroupedSearches);
+ }
+
+ // Filter out duplicate searches
+ $aSearchHash = array();
+ foreach ($aGroupedSearches as $iGroup => $aSearches) {
+ foreach ($aSearches as $iSearch => $aSearch) {
+ $sHash = serialize($aSearch);
+ if (isset($aSearchHash[$sHash])) {
+ unset($aGroupedSearches[$iGroup][$iSearch]);
+ if (sizeof($aGroupedSearches[$iGroup]) == 0) unset($aGroupedSearches[$iGroup]);
+ } else {
+ $aSearchHash[$sHash] = 1;
+ }
+ }
+ }
+
+ if (CONST_Debug) _debugDumpGroupedSearches($aGroupedSearches, $aValidTokens);
+
+ $iGroupLoop = 0;
+ $iQueryLoop = 0;
+ foreach ($aGroupedSearches as $iGroupedRank => $aSearches) {
+ $iGroupLoop++;
+ foreach ($aSearches as $aSearch) {
+ $iQueryLoop++;
+ $searchedHousenumber = -1;
+
+ if (CONST_Debug) echo "<hr><b>Search Loop, group $iGroupLoop, loop $iQueryLoop</b>";
+ if (CONST_Debug) _debugDumpGroupedSearches(array($iGroupedRank => array($aSearch)), $aValidTokens);
+
+ // No location term?
+ if (!sizeof($aSearch['aName']) && !sizeof($aSearch['aAddress']) && !$aSearch['fLon']) {
+ if ($aSearch['sCountryCode'] && !$aSearch['sClass'] && !$aSearch['sHouseNumber']) {
+ // Just looking for a country by code - look it up
+ if (4 >= $this->iMinAddressRank && 4 <= $this->iMaxAddressRank) {
+ $sSQL = "SELECT place_id FROM placex WHERE calculated_country_code='".$aSearch['sCountryCode']."' AND rank_search = 4";
+ if ($sCountryCodesSQL) $sSQL .= " AND calculated_country_code in ($sCountryCodesSQL)";
+ if ($bBoundingBoxSearch)
+ $sSQL .= " AND _st_intersects($this->sViewboxSmallSQL, geometry)";
+ $sSQL .= " ORDER BY st_area(geometry) DESC LIMIT 1";
+ if (CONST_Debug) var_dump($sSQL);
+ $aPlaceIDs = chksql($this->oDB->getCol($sSQL));
+ } else {
+ $aPlaceIDs = array();
+ }
+ } else {
+ if (!$bBoundingBoxSearch && !$aSearch['fLon']) continue;
+ if (!$aSearch['sClass']) continue;
+
+ $sSQL = "SELECT COUNT(*) FROM pg_tables WHERE tablename = 'place_classtype_".$aSearch['sClass']."_".$aSearch['sType']."'";
+ if (chksql($this->oDB->getOne($sSQL))) {
+ $sSQL = "SELECT place_id FROM place_classtype_".$aSearch['sClass']."_".$aSearch['sType']." ct";
+ if ($sCountryCodesSQL) $sSQL .= " JOIN placex USING (place_id)";
+ $sSQL .= " WHERE st_contains($this->sViewboxSmallSQL, ct.centroid)";
+ if ($sCountryCodesSQL) $sSQL .= " AND calculated_country_code in ($sCountryCodesSQL)";
+ if (sizeof($this->aExcludePlaceIDs)) {
+ $sSQL .= " AND place_id not in (".join(',', $this->aExcludePlaceIDs).")";
+ }
+ if ($this->sViewboxCentreSQL) $sSQL .= " ORDER BY ST_Distance($this->sViewboxCentreSQL, ct.centroid) ASC";
+ $sSQL .= " limit $this->iLimit";
+ if (CONST_Debug) var_dump($sSQL);
+ $aPlaceIDs = chksql($this->oDB->getCol($sSQL));
+
+ // If excluded place IDs are given, it is fair to assume that
+ // there have been results in the small box, so no further
+ // expansion in that case.
+ // Also don't expand if bounded results were requested.
+ if (!sizeof($aPlaceIDs) && !sizeof($this->aExcludePlaceIDs) && !$this->bBoundedSearch) {
+ $sSQL = "SELECT place_id FROM place_classtype_".$aSearch['sClass']."_".$aSearch['sType']." ct";
+ if ($sCountryCodesSQL) $sSQL .= " join placex using (place_id)";
+ $sSQL .= " WHERE ST_Contains($this->sViewboxLargeSQL, ct.centroid)";
+ if ($sCountryCodesSQL) $sSQL .= " AND calculated_country_code in ($sCountryCodesSQL)";
+ if ($this->sViewboxCentreSQL) $sSQL .= " ORDER BY ST_Distance($this->sViewboxCentreSQL, ct.centroid) ASC";
+ $sSQL .= " LIMIT $this->iLimit";
+ if (CONST_Debug) var_dump($sSQL);
+ $aPlaceIDs = chksql($this->oDB->getCol($sSQL));
+ }
+ } else {
+ $sSQL = "SELECT place_id ";
+ $sSQL .= "FROM placex ";
+ $sSQL .= "WHERE class='".$aSearch['sClass']."' ";
+ $sSQL .= " AND type='".$aSearch['sType']."'";
+ $sSQL .= " AND ST_Contains($this->sViewboxSmallSQL, geometry) ";
+ $sSQL .= " AND linked_place_id is null";
+ if ($sCountryCodesSQL) $sSQL .= " AND calculated_country_code in ($sCountryCodesSQL)";
+ if ($this->sViewboxCentreSQL) $sSQL .= " ORDER BY ST_Distance($this->sViewboxCentreSQL, centroid) ASC";
+ $sSQL .= " LIMIT $this->iLimit";
+ if (CONST_Debug) var_dump($sSQL);
+ $aPlaceIDs = chksql($this->oDB->getCol($sSQL));
+ }
+ }
+ } elseif ($aSearch['fLon'] && !sizeof($aSearch['aName']) && !sizeof($aSearch['aAddress']) && !$aSearch['sClass']) {
+ // If a coordinate is given, the search must either
+ // be for a name or a special search. Ignore everythin else.
+ $aPlaceIDs = array();
+ } else {
+ $aPlaceIDs = array();
+
+ // First we need a position, either aName or fLat or both
+ $aTerms = array();
+ $aOrder = array();
+
+ if ($aSearch['sHouseNumber'] && sizeof($aSearch['aAddress'])) {
+ $sHouseNumberRegex = '\\\\m'.$aSearch['sHouseNumber'].'\\\\M';
+ $aOrder[] = "";
+ $aOrder[0] = " (";
+ $aOrder[0] .= " EXISTS(";
+ $aOrder[0] .= " SELECT place_id ";
+ $aOrder[0] .= " FROM placex ";
+ $aOrder[0] .= " WHERE parent_place_id = search_name.place_id";
+ $aOrder[0] .= " AND transliteration(housenumber) ~* E'".$sHouseNumberRegex."' ";
+ $aOrder[0] .= " LIMIT 1";
+ $aOrder[0] .= " ) ";
+ // also housenumbers from interpolation lines table are needed
+ $aOrder[0] .= " OR EXISTS(";
+ $aOrder[0] .= " SELECT place_id ";
+ $aOrder[0] .= " FROM location_property_osmline ";
+ $aOrder[0] .= " WHERE parent_place_id = search_name.place_id";
+ $aOrder[0] .= " AND startnumber is not NULL";
+ $aOrder[0] .= " AND ".intval($aSearch['sHouseNumber']).">=startnumber ";
+ $aOrder[0] .= " AND ".intval($aSearch['sHouseNumber'])."<=endnumber ";
+ $aOrder[0] .= " LIMIT 1";
+ $aOrder[0] .= " )";
+ $aOrder[0] .= " )";
+ $aOrder[0] .= " DESC";
+ }
+
+ // TODO: filter out the pointless search terms (2 letter name tokens and less)
+ // they might be right - but they are just too darned expensive to run
+ if (sizeof($aSearch['aName'])) $aTerms[] = "name_vector @> ARRAY[".join($aSearch['aName'], ",")."]";
+ //if (sizeof($aSearch['aNameNonSearch'])) $aTerms[] = "array_cat(name_vector,ARRAY[]::integer[]) @> ARRAY[".join($aSearch['aNameNonSearch'], ",")."]";
+ if (sizeof($aSearch['aAddress']) && $aSearch['aName'] != $aSearch['aAddress']) {
+ // For infrequent name terms disable index usage for address
+ if (CONST_Search_NameOnlySearchFrequencyThreshold
+ && sizeof($aSearch['aName']) == 1
+ && $aWordFrequencyScores[$aSearch['aName'][reset($aSearch['aName'])]] < CONST_Search_NameOnlySearchFrequencyThreshold
+ ) {
+ //$aTerms[] = "array_cat(nameaddress_vector,ARRAY[]::integer[]) @> ARRAY[".join(array_merge($aSearch['aAddress'], $aSearch['aAddressNonSearch']), ",")."]";
+ $aTerms[] = "array_cat(nameaddress_vector,ARRAY[]::integer[]) @> ARRAY[".join($aSearch['aAddress'],",")."]";
+ } else {
+ $aTerms[] = "nameaddress_vector @> ARRAY[".join($aSearch['aAddress'], ",")."]";
+ /*if (sizeof($aSearch['aAddressNonSearch'])) {
+ $aTerms[] = "array_cat(nameaddress_vector,ARRAY[]::integer[]) @> ARRAY[".join($aSearch['aAddressNonSearch'], ",")."]";
+ }*/
+ }
+ }
+ if ($aSearch['sCountryCode']) $aTerms[] = "country_code = '".pg_escape_string($aSearch['sCountryCode'])."'";
+ if ($aSearch['sHouseNumber']) {
+ $aTerms[] = "address_rank between 16 and 27";
+ } else {
+ if ($this->iMinAddressRank > 0) {
+ $aTerms[] = "address_rank >= ".$this->iMinAddressRank;
+ }
+ if ($this->iMaxAddressRank < 30) {
+ $aTerms[] = "address_rank <= ".$this->iMaxAddressRank;
+ }
+ }
+ if ($aSearch['fLon'] && $aSearch['fLat']) {
+ $aTerms[] = sprintf(
+ 'ST_DWithin(centroid, ST_SetSRID(ST_Point(%F,%F),4326), %F)',
+ $aSearch['fLon'],
+ $aSearch['fLat'],
+ $aSearch['fRadius']
+ );
+
+ $aOrder[] = "ST_Distance(centroid, ST_SetSRID(ST_Point(".$aSearch['fLon'].",".$aSearch['fLat']."),4326)) ASC";
+ }
+ if (sizeof($this->aExcludePlaceIDs)) {
+ $aTerms[] = "place_id not in (".join(',', $this->aExcludePlaceIDs).")";
+ }
+ if ($sCountryCodesSQL) {
+ $aTerms[] = "country_code in ($sCountryCodesSQL)";
+ }
+
+ if ($bBoundingBoxSearch) $aTerms[] = "centroid && $this->sViewboxSmallSQL";
+ if ($sNearPointSQL) $aOrder[] = "ST_Distance($sNearPointSQL, centroid) ASC";
+
+ if ($aSearch['sHouseNumber']) {
+ $sImportanceSQL = '- abs(26 - address_rank) + 3';
+ } else {
+ $sImportanceSQL = '(CASE WHEN importance = 0 OR importance IS NULL THEN 0.75-(search_rank::float/40) ELSE importance END)';
+ }
+ if ($this->sViewboxSmallSQL) $sImportanceSQL .= " * CASE WHEN ST_Contains($this->sViewboxSmallSQL, centroid) THEN 1 ELSE 0.5 END";
+ if ($this->sViewboxLargeSQL) $sImportanceSQL .= " * CASE WHEN ST_Contains($this->sViewboxLargeSQL, centroid) THEN 1 ELSE 0.5 END";
+
+ $aOrder[] = "$sImportanceSQL DESC";
+ if (sizeof($aSearch['aFullNameAddress'])) {
+ $sExactMatchSQL = ' ( ';
+ $sExactMatchSQL .= ' SELECT count(*) FROM ( ';
+ $sExactMatchSQL .= ' SELECT unnest(ARRAY['.join($aSearch['aFullNameAddress'], ",").']) ';
+ $sExactMatchSQL .= ' INTERSECT ';
+ $sExactMatchSQL .= ' SELECT unnest(nameaddress_vector)';
+ $sExactMatchSQL .= ' ) s';
+ $sExactMatchSQL .= ') as exactmatch';
+ $aOrder[] = 'exactmatch DESC';
+ } else {
+ $sExactMatchSQL = '0::int as exactmatch';
+ }
+
+ if (sizeof($aTerms)) {
+ $sSQL = "SELECT place_id, ";
+ $sSQL .= $sExactMatchSQL;
+ $sSQL .= " FROM search_name";
+ $sSQL .= " WHERE ".join(' and ', $aTerms);
+ $sSQL .= " ORDER BY ".join(', ', $aOrder);
+ if ($aSearch['sHouseNumber'] || $aSearch['sClass']) {
+ $sSQL .= " LIMIT 20";
+ } elseif (!sizeof($aSearch['aName']) && !sizeof($aSearch['aAddress']) && $aSearch['sClass']) {
+ $sSQL .= " LIMIT 1";
+ } else {
+ $sSQL .= " LIMIT ".$this->iLimit;
+ }
+
+ if (CONST_Debug) var_dump($sSQL);
+ $aViewBoxPlaceIDs = chksql(
+ $this->oDB->getAll($sSQL),
+ "Could not get places for search terms."
+ );
+ //var_dump($aViewBoxPlaceIDs);
+ // Did we have an viewbox matches?
+ $aPlaceIDs = array();
+ $bViewBoxMatch = false;
+ foreach ($aViewBoxPlaceIDs as $aViewBoxRow) {
+ //if ($bViewBoxMatch == 1 && $aViewBoxRow['in_small'] == 'f') break;
+ //if ($bViewBoxMatch == 2 && $aViewBoxRow['in_large'] == 'f') break;
+ //if ($aViewBoxRow['in_small'] == 't') $bViewBoxMatch = 1;
+ //else if ($aViewBoxRow['in_large'] == 't') $bViewBoxMatch = 2;
+ $aPlaceIDs[] = $aViewBoxRow['place_id'];
+ $this->exactMatchCache[$aViewBoxRow['place_id']] = $aViewBoxRow['exactmatch'];
+ }
+ }
+ //var_Dump($aPlaceIDs);
+ //exit;
+
+ //now search for housenumber, if housenumber provided
+ if ($aSearch['sHouseNumber'] && sizeof($aPlaceIDs)) {
+ $searchedHousenumber = intval($aSearch['sHouseNumber']);
+ $aRoadPlaceIDs = $aPlaceIDs;
+ $sPlaceIDs = join(',', $aPlaceIDs);
+
+ // Now they are indexed, look for a house attached to a street we found
+ $sHouseNumberRegex = '\\\\m'.$aSearch['sHouseNumber'].'\\\\M';
+ $sSQL = "SELECT place_id FROM placex ";
+ $sSQL .= "WHERE parent_place_id in (".$sPlaceIDs.") and transliteration(housenumber) ~* E'".$sHouseNumberRegex."'";
+ if (sizeof($this->aExcludePlaceIDs)) {
+ $sSQL .= " AND place_id not in (".join(',', $this->aExcludePlaceIDs).")";
+ }
+ $sSQL .= " LIMIT $this->iLimit";
+ if (CONST_Debug) var_dump($sSQL);
+ $aPlaceIDs = chksql($this->oDB->getCol($sSQL));
+
+ // if nothing found, search in the interpolation line table
+ if (!sizeof($aPlaceIDs)) {
+ // do we need to use transliteration and the regex for housenumbers???
+ //new query for lines, not housenumbers anymore
+ $sSQL = "SELECT distinct place_id FROM location_property_osmline";
+ $sSQL .= " WHERE startnumber is not NULL and parent_place_id in (".$sPlaceIDs.") and (";
+ if ($searchedHousenumber%2 == 0) {
+ //if housenumber is even, look for housenumber in streets with interpolationtype even or all
+ $sSQL .= "interpolationtype='even'";
+ } else {
+ //look for housenumber in streets with interpolationtype odd or all
+ $sSQL .= "interpolationtype='odd'";
+ }
+ $sSQL .= " or interpolationtype='all') and ";
+ $sSQL .= $searchedHousenumber.">=startnumber and ";
+ $sSQL .= $searchedHousenumber."<=endnumber";
+
+ if (sizeof($this->aExcludePlaceIDs)) {
+ $sSQL .= " AND place_id not in (".join(',', $this->aExcludePlaceIDs).")";
+ }
+ //$sSQL .= " limit $this->iLimit";
+ if (CONST_Debug) var_dump($sSQL);
+ //get place IDs
+ $aPlaceIDs = chksql($this->oDB->getCol($sSQL, 0));
+ }
+
+ // If nothing found try the aux fallback table
+ if (CONST_Use_Aux_Location_data && !sizeof($aPlaceIDs)) {
+ $sSQL = "SELECT place_id FROM location_property_aux ";
+ $sSQL .= " WHERE parent_place_id in (".$sPlaceIDs.") ";
+ $sSQL .= " AND housenumber = '".pg_escape_string($aSearch['sHouseNumber'])."'";
+ if (sizeof($this->aExcludePlaceIDs)) {
+ $sSQL .= " AND parent_place_id not in (".join(',', $this->aExcludePlaceIDs).")";
+ }
+ //$sSQL .= " limit $this->iLimit";
+ if (CONST_Debug) var_dump($sSQL);
+ $aPlaceIDs = chksql($this->oDB->getCol($sSQL));
+ }
+
+ //if nothing was found in placex or location_property_aux, then search in Tiger data for this housenumber(location_property_tiger)
+ if (CONST_Use_US_Tiger_Data && !sizeof($aPlaceIDs)) {
+ $sSQL = "SELECT distinct place_id FROM location_property_tiger";
+ $sSQL .= " WHERE parent_place_id in (".$sPlaceIDs.") and (";
+ if ($searchedHousenumber%2 == 0) {
+ $sSQL .= "interpolationtype='even'";
+ } else {
+ $sSQL .= "interpolationtype='odd'";
+ }
+ $sSQL .= " or interpolationtype='all') and ";
+ $sSQL .= $searchedHousenumber.">=startnumber and ";
+ $sSQL .= $searchedHousenumber."<=endnumber";
+
+ if (sizeof($this->aExcludePlaceIDs)) {
+ $sSQL .= " AND place_id not in (".join(',', $this->aExcludePlaceIDs).")";
+ }
+ //$sSQL .= " limit $this->iLimit";
+ if (CONST_Debug) var_dump($sSQL);
+ //get place IDs
+ $aPlaceIDs = chksql($this->oDB->getCol($sSQL, 0));
+ }
+
+ // Fallback to the road (if no housenumber was found)
+ if (!sizeof($aPlaceIDs) && preg_match('/[0-9]+/', $aSearch['sHouseNumber'])) {
+ $aPlaceIDs = $aRoadPlaceIDs;
+ //set to -1, if no housenumbers were found
+ $searchedHousenumber = -1;
+ }
+ //else: housenumber was found, remains saved in searchedHousenumber
+ }
+
+
+ if ($aSearch['sClass'] && sizeof($aPlaceIDs)) {
+ $sPlaceIDs = join(',', $aPlaceIDs);
+ $aClassPlaceIDs = array();
+
+ if (!$aSearch['sOperator'] || $aSearch['sOperator'] == 'name') {
+ // If they were searching for a named class (i.e. 'Kings Head pub') then we might have an extra match
+ $sSQL = "SELECT place_id ";
+ $sSQL .= " FROM placex ";
+ $sSQL .= " WHERE place_id in ($sPlaceIDs) ";
+ $sSQL .= " AND class='".$aSearch['sClass']."' ";
+ $sSQL .= " AND type='".$aSearch['sType']."'";
+ $sSQL .= " AND linked_place_id is null";
+ if ($sCountryCodesSQL) $sSQL .= " AND calculated_country_code in ($sCountryCodesSQL)";
+ $sSQL .= " ORDER BY rank_search ASC ";
+ $sSQL .= " LIMIT $this->iLimit";
+ if (CONST_Debug) var_dump($sSQL);
+ $aClassPlaceIDs = chksql($this->oDB->getCol($sSQL));
+ }
+
+ if (!$aSearch['sOperator'] || $aSearch['sOperator'] == 'near') { // & in
+ $sSQL = "SELECT count(*) FROM pg_tables ";
+ $sSQL .= "WHERE tablename = 'place_classtype_".$aSearch['sClass']."_".$aSearch['sType']."'";
+ $bCacheTable = chksql($this->oDB->getOne($sSQL));
+
+ $sSQL = "SELECT min(rank_search) FROM placex WHERE place_id in ($sPlaceIDs)";
+
+ if (CONST_Debug) var_dump($sSQL);
+ $this->iMaxRank = ((int)chksql($this->oDB->getOne($sSQL)));
+
+ // For state / country level searches the normal radius search doesn't work very well
+ $sPlaceGeom = false;
+ if ($this->iMaxRank < 9 && $bCacheTable) {
+ // Try and get a polygon to search in instead
+ $sSQL = "SELECT geometry ";
+ $sSQL .= " FROM placex";
+ $sSQL .= " WHERE place_id in ($sPlaceIDs)";
+ $sSQL .= " AND rank_search < $this->iMaxRank + 5";
+ $sSQL .= " AND ST_Geometrytype(geometry) in ('ST_Polygon','ST_MultiPolygon')";
+ $sSQL .= " ORDER BY rank_search ASC ";
+ $sSQL .= " LIMIT 1";
+ if (CONST_Debug) var_dump($sSQL);
+ $sPlaceGeom = chksql($this->oDB->getOne($sSQL));
+ }
+
+ if ($sPlaceGeom) {
+ $sPlaceIDs = false;
+ } else {
+ $this->iMaxRank += 5;
+ $sSQL = "SELECT place_id FROM placex WHERE place_id in ($sPlaceIDs) and rank_search < $this->iMaxRank";
+ if (CONST_Debug) var_dump($sSQL);
+ $aPlaceIDs = chksql($this->oDB->getCol($sSQL));
+ $sPlaceIDs = join(',', $aPlaceIDs);
+ }
+
+ if ($sPlaceIDs || $sPlaceGeom) {
+ $fRange = 0.01;
+ if ($bCacheTable) {
+ // More efficient - can make the range bigger
+ $fRange = 0.05;
+
+ $sOrderBySQL = '';
+ if ($sNearPointSQL) $sOrderBySQL = "ST_Distance($sNearPointSQL, l.centroid)";
+ elseif ($sPlaceIDs) $sOrderBySQL = "ST_Distance(l.centroid, f.geometry)";
+ elseif ($sPlaceGeom) $sOrderBysSQL = "ST_Distance(st_centroid('".$sPlaceGeom."'), l.centroid)";
+
+ $sSQL = "select distinct l.place_id".($sOrderBySQL?','.$sOrderBySQL:'')." from place_classtype_".$aSearch['sClass']."_".$aSearch['sType']." as l";
+ if ($sCountryCodesSQL) $sSQL .= " join placex as lp using (place_id)";
+ if ($sPlaceIDs) {
+ $sSQL .= ",placex as f where ";
+ $sSQL .= "f.place_id in ($sPlaceIDs) and ST_DWithin(l.centroid, f.centroid, $fRange) ";
+ }
+ if ($sPlaceGeom) {
+ $sSQL .= " where ";
+ $sSQL .= "ST_Contains('".$sPlaceGeom."', l.centroid) ";
+ }
+ if (sizeof($this->aExcludePlaceIDs)) {
+ $sSQL .= " and l.place_id not in (".join(',', $this->aExcludePlaceIDs).")";
+ }
+ if ($sCountryCodesSQL) $sSQL .= " and lp.calculated_country_code in ($sCountryCodesSQL)";
+ if ($sOrderBySQL) $sSQL .= "order by ".$sOrderBySQL." asc";
+ if ($this->iOffset) $sSQL .= " offset $this->iOffset";
+ $sSQL .= " limit $this->iLimit";
+ if (CONST_Debug) var_dump($sSQL);
+ $aClassPlaceIDs = array_merge($aClassPlaceIDs, chksql($this->oDB->getCol($sSQL)));
+ } else {
+ if (isset($aSearch['fRadius']) && $aSearch['fRadius']) $fRange = $aSearch['fRadius'];
+
+ $sOrderBySQL = '';
+ if ($sNearPointSQL) $sOrderBySQL = "ST_Distance($sNearPointSQL, l.geometry)";
+ else $sOrderBySQL = "ST_Distance(l.geometry, f.geometry)";
+
+ $sSQL = "SELECT distinct l.place_id".($sOrderBysSQL?','.$sOrderBysSQL:'');
+ $sSQL .= " FROM placex as l, placex as f ";
+ $sSQL .= " WHERE f.place_id in ($sPlaceIDs) ";
+ $sSQL .= " AND ST_DWithin(l.geometry, f.centroid, $fRange) ";
+ $sSQL .= " AND l.class='".$aSearch['sClass']."' ";
+ $sSQL .= " AND l.type='".$aSearch['sType']."' ";
+ if (sizeof($this->aExcludePlaceIDs)) {
+ $sSQL .= " AND l.place_id not in (".join(',', $this->aExcludePlaceIDs).")";
+ }
+ if ($sCountryCodesSQL) $sSQL .= " AND l.calculated_country_code in ($sCountryCodesSQL)";
+ if ($sOrderBy) $sSQL .= "ORDER BY ".$OrderBysSQL." ASC";
+ if ($this->iOffset) $sSQL .= " OFFSET $this->iOffset";
+ $sSQL .= " limit $this->iLimit";
+ if (CONST_Debug) var_dump($sSQL);
+ $aClassPlaceIDs = array_merge($aClassPlaceIDs, chksql($this->oDB->getCol($sSQL)));
+ }
+ }
+ }
+ $aPlaceIDs = $aClassPlaceIDs;
+ }
+ }
+
+ if (CONST_Debug) {
+ echo "<br><b>Place IDs:</b> ";
+ var_Dump($aPlaceIDs);
+ }
+
+ foreach ($aPlaceIDs as $iPlaceID) {
+ // array for placeID => -1 | Tiger housenumber
+ $aResultPlaceIDs[$iPlaceID] = $searchedHousenumber;
+ }
+ if ($iQueryLoop > 20) break;
+ }
+
+ if (isset($aResultPlaceIDs) && sizeof($aResultPlaceIDs) && ($this->iMinAddressRank != 0 || $this->iMaxAddressRank != 30)) {
+ // Need to verify passes rank limits before dropping out of the loop (yuk!)
+ // reduces the number of place ids, like a filter
+ // rank_address is 30 for interpolated housenumbers
+ $sSQL = "SELECT place_id ";
+ $sSQL .= "FROM placex ";
+ $sSQL .= "WHERE place_id in (".join(',', array_keys($aResultPlaceIDs)).") ";
+ $sSQL .= " AND (";
+ $sSQL .= " placex.rank_address between $this->iMinAddressRank and $this->iMaxAddressRank ";
+ if (14 >= $this->iMinAddressRank && 14 <= $this->iMaxAddressRank) {
+ $sSQL .= " OR (extratags->'place') = 'city'";
+ }
+ if ($this->aAddressRankList) {
+ $sSQL .= " OR placex.rank_address in (".join(',', $this->aAddressRankList).")";
+ }
+ if (CONST_Use_US_Tiger_Data) {
+ $sSQL .= " ) ";
+ $sSQL .= "UNION ";
+ $sSQL .= " SELECT place_id ";
+ $sSQL .= " FROM location_property_tiger ";
+ $sSQL .= " WHERE place_id in (".join(',', array_keys($aResultPlaceIDs)).") ";
+ $sSQL .= " AND (30 between $this->iMinAddressRank and $this->iMaxAddressRank ";
+ if ($this->aAddressRankList) $sSQL .= " OR 30 in (".join(',', $this->aAddressRankList).")";
+ }
+ $sSQL .= ") UNION ";
+ $sSQL .= " SELECT place_id ";
+ $sSQL .= " FROM location_property_osmline ";
+ $sSQL .= " WHERE place_id in (".join(',', array_keys($aResultPlaceIDs)).")";
+ $sSQL .= " AND startnumber is not NULL AND (30 between $this->iMinAddressRank and $this->iMaxAddressRank)";
+ if (CONST_Debug) var_dump($sSQL);
+ $aFilteredPlaceIDs = chksql($this->oDB->getCol($sSQL));
+ $tempIDs = array();
+ foreach ($aFilteredPlaceIDs as $placeID) {
+ $tempIDs[$placeID] = $aResultPlaceIDs[$placeID]; //assign housenumber to placeID
+ }
+ $aResultPlaceIDs = $tempIDs;
+ }
+
+ //exit;
+ if (isset($aResultPlaceIDs) && sizeof($aResultPlaceIDs)) break;
+ if ($iGroupLoop > 4) break;
+ if ($iQueryLoop > 30) break;
+ }
+
+ // Did we find anything?
+ if (isset($aResultPlaceIDs) && sizeof($aResultPlaceIDs)) {
+ $aSearchResults = $this->getDetails($aResultPlaceIDs);
+ }
+ } else {
+ // Just interpret as a reverse geocode
+ $oReverse = new ReverseGeocode($this->oDB);
+ $oReverse->setZoom(18);
+
+ $aLookup = $oReverse->lookup(
+ (float)$this->aNearPoint[0],
+ (float)$this->aNearPoint[1],
+ false
+ );
+
+ if (CONST_Debug) var_dump("Reverse search", $aLookup);
+
+ if ($aLookup['place_id']) {
+ $aSearchResults = $this->getDetails(array($aLookup['place_id'] => -1));
+ $aResultPlaceIDs[$aLookup['place_id']] = -1;
+ } else {
+ $aSearchResults = array();
+ }
+ }
+
+ // No results? Done
+ if (!sizeof($aSearchResults)) {
+ if ($this->bFallback) {
+ if ($this->fallbackStructuredQuery()) {
+ return $this->lookup();
+ }
+ }
+
+ return array();
+ }
+
+ $aClassType = getClassTypesWithImportance();
+ $aRecheckWords = preg_split('/\b[\s,\\-]*/u', $sQuery);
+ foreach ($aRecheckWords as $i => $sWord) {
+ if (!preg_match('/\pL/', $sWord)) unset($aRecheckWords[$i]);
+ }
+
+ if (CONST_Debug) {
+ echo '<i>Recheck words:<\i>';
+ var_dump($aRecheckWords);
+ }
+
+ $oPlaceLookup = new PlaceLookup($this->oDB);
+ $oPlaceLookup->setIncludePolygonAsPoints($this->bIncludePolygonAsPoints);
+ $oPlaceLookup->setIncludePolygonAsText($this->bIncludePolygonAsText);
+ $oPlaceLookup->setIncludePolygonAsGeoJSON($this->bIncludePolygonAsGeoJSON);
+ $oPlaceLookup->setIncludePolygonAsKML($this->bIncludePolygonAsKML);
+ $oPlaceLookup->setIncludePolygonAsSVG($this->bIncludePolygonAsSVG);
+ $oPlaceLookup->setPolygonSimplificationThreshold($this->fPolygonSimplificationThreshold);
+
+ foreach ($aSearchResults as $iResNum => $aResult) {
+ // Default
+ $fDiameter = getResultDiameter($aResult);
+
+ $aOutlineResult = $oPlaceLookup->getOutlines($aResult['place_id'], $aResult['lon'], $aResult['lat'], $fDiameter/2);
+ if ($aOutlineResult) {
+ $aResult = array_merge($aResult, $aOutlineResult);
+ }
+
+ if ($aResult['extra_place'] == 'city') {
+ $aResult['class'] = 'place';
+ $aResult['type'] = 'city';
+ $aResult['rank_search'] = 16;
+ }
+
+ // Is there an icon set for this type of result?
+ if (isset($aClassType[$aResult['class'].':'.$aResult['type']]['icon'])
+ && $aClassType[$aResult['class'].':'.$aResult['type']]['icon']
+ ) {
+ $aResult['icon'] = CONST_Website_BaseURL.'images/mapicons/'.$aClassType[$aResult['class'].':'.$aResult['type']]['icon'].'.p.20.png';
+ }
+
+ if (isset($aClassType[$aResult['class'].':'.$aResult['type'].':'.$aResult['admin_level']]['label'])
+ && $aClassType[$aResult['class'].':'.$aResult['type'].':'.$aResult['admin_level']]['label']
+ ) {
+ $aResult['label'] = $aClassType[$aResult['class'].':'.$aResult['type'].':'.$aResult['admin_level']]['label'];
+ } elseif (isset($aClassType[$aResult['class'].':'.$aResult['type']]['label'])
+ && $aClassType[$aResult['class'].':'.$aResult['type']]['label']
+ ) {
+ $aResult['label'] = $aClassType[$aResult['class'].':'.$aResult['type']]['label'];
+ }
+ // if tag '&addressdetails=1' is set in query
+ if ($this->bIncludeAddressDetails) {
+ // getAddressDetails() is defined in lib.php and uses the SQL function get_addressdata in functions.sql
+ $aResult['address'] = getAddressDetails($this->oDB, $sLanguagePrefArraySQL, $aResult['place_id'], $aResult['country_code'], $aResultPlaceIDs[$aResult['place_id']]);
+ if ($aResult['extra_place'] == 'city' && !isset($aResult['address']['city'])) {
+ $aResult['address'] = array_merge(array('city' => array_values($aResult['address'])[0]), $aResult['address']);
+ }
+ }
+
+ if ($this->bIncludeExtraTags) {
+ if ($aResult['extra']) {
+ $aResult['sExtraTags'] = json_decode($aResult['extra']);
+ } else {
+ $aResult['sExtraTags'] = (object) array();
+ }
+ }
+
+ if ($this->bIncludeNameDetails) {
+ if ($aResult['names']) {
+ $aResult['sNameDetails'] = json_decode($aResult['names']);
+ } else {
+ $aResult['sNameDetails'] = (object) array();
+ }
+ }
+
+ // Adjust importance for the number of exact string matches in the result
+ $aResult['importance'] = max(0.001, $aResult['importance']);
+ $iCountWords = 0;
+ $sAddress = $aResult['langaddress'];
+ foreach ($aRecheckWords as $i => $sWord) {
+ if (stripos($sAddress, $sWord)!==false) {
+ $iCountWords++;
+ if (preg_match("/(^|,)\s*".preg_quote($sWord, '/')."\s*(,|$)/", $sAddress)) $iCountWords += 0.1;
+ }
+ }
+
+ $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
+
+ $aResult['name'] = $aResult['langaddress'];
+ // secondary ordering (for results with same importance (the smaller the better):
+ // - approximate importance of address parts
+ $aResult['foundorder'] = -$aResult['addressimportance']/10;
+ // - number of exact matches from the query
+ if (isset($this->exactMatchCache[$aResult['place_id']])) {
+ $aResult['foundorder'] -= $this->exactMatchCache[$aResult['place_id']];
+ } elseif (isset($this->exactMatchCache[$aResult['parent_place_id']])) {
+ $aResult['foundorder'] -= $this->exactMatchCache[$aResult['parent_place_id']];
+ }
+ // - importance of the class/type
+ if (isset($aClassType[$aResult['class'].':'.$aResult['type']]['importance'])
+ && $aClassType[$aResult['class'].':'.$aResult['type']]['importance']
+ ) {
+ $aResult['foundorder'] += 0.0001 * $aClassType[$aResult['class'].':'.$aResult['type']]['importance'];
+ } else {
+ $aResult['foundorder'] += 0.01;
+ }
+ if (CONST_Debug) var_dump($aResult);
+ $aSearchResults[$iResNum] = $aResult;
+ }
+ uasort($aSearchResults, 'byImportance');
+
+ $aOSMIDDone = array();
+ $aClassTypeNameDone = array();
+ $aToFilter = $aSearchResults;
+ $aSearchResults = array();
+
+ $bFirst = true;
+ foreach ($aToFilter as $iResNum => $aResult) {
+ $this->aExcludePlaceIDs[$aResult['place_id']] = $aResult['place_id'];
+ if ($bFirst) {
+ $fLat = $aResult['lat'];
+ $fLon = $aResult['lon'];
+ if (isset($aResult['zoom'])) $iZoom = $aResult['zoom'];
+ $bFirst = false;
+ }
+ if (!$this->bDeDupe || (!isset($aOSMIDDone[$aResult['osm_type'].$aResult['osm_id']])
+ && !isset($aClassTypeNameDone[$aResult['osm_type'].$aResult['class'].$aResult['type'].$aResult['name'].$aResult['admin_level']]))
+ ) {
+ $aOSMIDDone[$aResult['osm_type'].$aResult['osm_id']] = true;
+ $aClassTypeNameDone[$aResult['osm_type'].$aResult['class'].$aResult['type'].$aResult['name'].$aResult['admin_level']] = true;
+ $aSearchResults[] = $aResult;
+ }
+
+ // Absolute limit on number of results
+ if (sizeof($aSearchResults) >= $this->iFinalLimit) break;
+ }
+
+ return $aSearchResults;
+ } // end lookup()
+} // end class
projects / nominatim.git / blobdiff