+ public function lookup($fLat, $fLon, $bDoInterpolation = true)
+ {
+ return $this->lookupPoint(
+ 'ST_SetSRID(ST_Point('.$fLon.','.$fLat.'),4326)',
+ $bDoInterpolation
+ );
+ }
+
+ public function lookupPoint($sPointSQL, $bDoInterpolation = true)
+ {
+
+ $iMaxRank = $this->iMaxRank;
+
+ // Find the nearest point
+ $fSearchDiam = 0.006;
+ $oResult = null;
+ $aPlace = null;
+ $fMaxAreaDistance = 1;
+ $bIsTigerStreet = false;
+
+ // for POI or street level
+ if ($iMaxRank >= 26) {
+ $sSQL = 'select place_id,parent_place_id,rank_address,country_code,';
+ $sSQL .= 'CASE WHEN ST_GeometryType(geometry) in (\'ST_Polygon\',\'ST_MultiPolygon\') THEN ST_distance('.$sPointSQL.', centroid)';
+ $sSQL .= ' ELSE ST_distance('.$sPointSQL.', geometry) ';
+ $sSQL .= ' END as distance';
+ $sSQL .= ' FROM ';
+ $sSQL .= ' placex';
+ $sSQL .= ' WHERE ST_DWithin('.$sPointSQL.', geometry, '.$fSearchDiam.')';
+ $sSQL .= ' AND';
+ // only streets
+ if ($iMaxRank == 26) {
+ $sSQL .= ' rank_address = 26';
+ } else {
+ $sSQL .= ' rank_address between 26 and '.$iMaxRank;
+ }
+ $sSQL .= ' and (name is not null or housenumber is not null';
+ $sSQL .= ' or rank_address between 26 and 27)';
+ $sSQL .= ' and class not in (\'railway\',\'tunnel\',\'bridge\',\'man_made\')';
+ $sSQL .= ' and indexed_status = 0 and linked_place_id is null';
+ $sSQL .= ' and (ST_GeometryType(geometry) not in (\'ST_Polygon\',\'ST_MultiPolygon\') ';
+ $sSQL .= ' OR ST_DWithin('.$sPointSQL.', centroid, '.$fSearchDiam.'))';
+ $sSQL .= ' ORDER BY distance ASC limit 1';
+ if (CONST_Debug) var_dump($sSQL);
+ $aPlace = chksql(
+ $this->oDB->getRow($sSQL),
+ 'Could not determine closest place.'
+ );
+
+ if ($aPlace) {
+
+ $iDistance = $aPlace['distance'];
+ $iPlaceID = $aPlace['place_id'];
+ $oResult = new Result($iPlaceID);
+ $iParentPlaceID = $aPlace['parent_place_id'];
+
+ if ($bDoInterpolation && $iMaxRank >= 30) {
+ if ($aPlace['rank_address'] <=27) {
+ $iDistance = 0.001;
+ }
+ $aHouse = $this->lookupInterpolation($sPointSQL, $iDistance);
+
+ if ($aHouse) {
+ $oResult = new Result($aHouse['place_id'], Result::TABLE_OSMLINE);
+ $oResult->iHouseNumber = closestHouseNumber($aHouse);
+ }
+ }
+
+ // if street and maxrank > streetlevel
+ if (($aPlace['rank_address'] <=27)&& $iMaxRank > 27) {
+ // find the closest object (up to a certain radius) of which the street is a parent of
+ $sSQL = ' select place_id,parent_place_id,rank_address,country_code,';
+ $sSQL .= ' ST_distance('.$sPointSQL.', geometry) as distance';
+ $sSQL .= ' FROM ';
+ $sSQL .= ' placex';
+ // radius ?
+ $sSQL .= ' WHERE ST_DWithin('.$sPointSQL.', geometry, 0.001)';
+ $sSQL .= ' AND parent_place_id = '.$iPlaceID;
+ $sSQL .= ' and rank_address != 28';
+ $sSQL .= ' and (name is not null or housenumber is not null)';
+ $sSQL .= ' and class not in (\'railway\',\'tunnel\',\'bridge\',\'man_made\')';
+ $sSQL .= ' and indexed_status = 0 and linked_place_id is null';
+ $sSQL .= ' ORDER BY distance ASC limit 1';
+ if (CONST_Debug) var_dump($sSQL);
+ $aStreet = chksql(
+ $this->oDB->getRow($sSQL),
+ 'Could not determine closest place.'
+ );
+ if ($aStreet) {
+ $iDistance = $aStreet['distance'];
+ $iPlaceID = $aStreet['place_id'];
+ $oResult = new Result($iPlaceID);
+ $iParentPlaceID = $aStreet['parent_place_id'];
+
+ if ($bDoInterpolation && $iMaxRank >= 30) {
+ $aHouse = $this->lookupInterpolation($sPointSQL, $iDistance, $iParentPlaceID);
+
+ if ($aHouse) {
+ $oResult = new Result($aHouse['place_id'], Result::TABLE_OSMLINE);
+ $oResult->iHouseNumber = closestHouseNumber($aHouse);
+ }
+ }
+ }
+ }
+
+ // In the US we can check TIGER data for nearest housenumber
+ if (CONST_Use_US_Tiger_Data && $aPlace['country_code'] == 'us' && $this->iMaxRank >= 28) {
+ $fSearchDiam = $aPlace['rank_search'] > 28 ? $aPlace['distance'] : 0.001;
+ $sSQL = 'SELECT place_id,parent_place_id,30 as rank_search,';
+ $sSQL .= 'ST_LineLocatePoint(linegeo,'.$sPointSQL.') as fraction,';
+ $sSQL .= 'ST_distance('.$sPointSQL.', linegeo) as distance,';
+ $sSQL .= 'startnumber,endnumber,interpolationtype';
+ $sSQL .= ' FROM location_property_tiger WHERE parent_place_id = '.$oResult->iId;
+ $sSQL .= ' AND ST_DWithin('.$sPointSQL.', linegeo, '.$fSearchDiam.')';
+ $sSQL .= ' ORDER BY distance ASC limit 1';
+ if (CONST_Debug) var_dump($sSQL);
+ $aPlaceTiger = chksql(
+ $this->oDB->getRow($sSQL),
+ 'Could not determine closest Tiger place.'
+ );
+ if ($aPlaceTiger) {
+ if (CONST_Debug) var_dump('found Tiger housenumber', $aPlaceTiger);
+ $aPlace = $aPlaceTiger;
+ $oResult = new Result($aPlace['place_id'], Result::TABLE_TIGER);
+ $oResult->iHouseNumber = closestHouseNumber($aPlaceTiger);
+ }
+ }
+ // if no POI or street is found ...
+ } else {
+ $oResult = $this->PolygonFunctions($sPointSQL, $iMaxRank);
+ }
+ // lower than street level ($iMaxRank < 26 )
+ } else {
+ $oResult = $this->PolygonFunctions($sPointSQL, $iMaxRank);
+ }
+ return $oResult;
+ }
+}
projects / nominatim.git / blobdiff