X-Git-Url: https://git.openstreetmap.org./nominatim.git/blobdiff_plain/7879ad44cd1e36ae1235c3dcdfd9e477491813e4..e842d8793c1c416a75bbae39c004184f1ed66289:/lib/PlaceLookup.php diff --git a/lib/PlaceLookup.php b/lib/PlaceLookup.php index 07988927..831f6ef6 100644 --- a/lib/PlaceLookup.php +++ b/lib/PlaceLookup.php @@ -42,18 +42,12 @@ function setIncludeExtraTags($bExtraTags = false) { - if ((float) CONST_Postgresql_Version > 9.2) - { - $this->bExtraTags = $bExtraTags; - } + $this->bExtraTags = $bExtraTags; } function setIncludeNameDetails($bNameDetails = false) { - if ((float) CONST_Postgresql_Version > 9.2) - { - $this->bNameDetails = $bNameDetails; - } + $this->bNameDetails = $bNameDetails; } @@ -106,7 +100,7 @@ function setOSMID($sType, $iID) { $sSQL = "select place_id from placex where osm_type = '".pg_escape_string($sType)."' and osm_id = ".(int)$iID." order by type = 'postcode' asc"; - $this->iPlaceID = $this->oDB->getOne($sSQL); + $this->iPlaceID = chksql($this->oDB->getOne($sSQL)); } function lookupPlace($details) @@ -128,7 +122,7 @@ $sLanguagePrefArraySQL = "ARRAY[".join(',',array_map("getDBQuoted", $this->aLangPrefOrder))."]"; - if ($this->sType == 'tiger') + if (CONST_Use_US_Tiger_Data && $this->sType == 'tiger') { $sSQL = "select place_id,partition, 'T' as osm_type, place_id as osm_id, 'place' as class, 'house' as type, null as admin_level, housenumber, null as street, null as isin, postcode,"; $sSQL .= " 'us' as country_code, parent_place_id, null as linked_place_id, 30 as rank_address, 30 as rank_search,"; @@ -148,9 +142,9 @@ } else if ($this->sType == 'interpolation') { - $sSQL = "select place_id, partition, 'I' as osm_type, osm_id, 'place' as class, 'house' as type, null admin_level, housenumber, null as street, null as isin, postcode,"; + $sSQL = "select place_id, partition, 'W' as osm_type, osm_id, 'place' as class, 'house' as type, null admin_level, housenumber, null as street, null as isin, postcode,"; $sSQL .= " calculated_country_code as country_code, parent_place_id, null as linked_place_id, 30 as rank_address, 30 as rank_search,"; - $sSQL .= " coalesce(null,0.75-(30::float/40)) as importance, null as indexed_status, null as indexed_date, null as wikipedia, calculated_country_code, "; + $sSQL .= " (0.75-(30::float/40)) as importance, null as indexed_status, null as indexed_date, null as wikipedia, calculated_country_code, "; $sSQL .= " get_address_by_language(place_id, housenumber, $sLanguagePrefArraySQL) as langaddress,"; $sSQL .= " null as placename,"; $sSQL .= " null as ref,"; @@ -181,19 +175,13 @@ $sSQL .= " from placex where place_id = ".(int)$this->iPlaceID; } - $aPlace = $this->oDB->getRow($sSQL); - - - if (PEAR::IsError($aPlace)) - { - failInternalError("Could not lookup place.", $sSQL, $aPlace); - } + $aPlace = chksql($this->oDB->getRow($sSQL), "Could not lookup place"); if (!$aPlace['place_id']) return null; if ($this->bAddressDetails) { - if ($this->sType == 'tiger' || $this->sType == 'interpolation') // to get addressdetails for interpolation lines and tiger data, the housenumber is needed + if(CONST_Use_US_Tiger_Data && $this->sType == 'tiger' || $this->sType == 'interpolation') // to get addressdetails for tiger data, the housenumber is needed $aAddress = $this->getAddressNames($aPlace['housenumber']); else $aAddress = $this->getAddressNames(); @@ -254,13 +242,7 @@ if (!$bAll) $sSQL .= " WHERE isaddress OR type = 'country_code'"; $sSQL .= " order by rank_address desc,isaddress desc"; - $aAddressLines = $this->oDB->getAll($sSQL); - if (PEAR::IsError($aAddressLines)) - { - var_dump($aAddressLines); - exit; - } - return $aAddressLines; + return chksql($this->oDB->getAll($sSQL)); } function getAddressNames($housenumber = -1) @@ -338,12 +320,8 @@ $sSQL .= $sFrom; } - $aPointPolygon = $this->oDB->getRow($sSQL); - if (PEAR::IsError($aPointPolygon)) - { - echo var_dump($aPointPolygon); - failInternalError("Could not get outline.", $sSQL, $aPointPolygon); - } + $aPointPolygon = chksql($this->oDB->getRow($sSQL), + "Could not get outline"); if ($aPointPolygon['place_id']) {