- $sSQL = 'select address_place_id';
- $sSQL .= ' FROM place_addressline';
- $sSQL .= " WHERE place_id = $iPlaceID";
- $sSQL .= " ORDER BY abs(cached_rank_address - $iMaxRank) asc,cached_rank_address desc,isaddress desc,distance desc";
- $sSQL .= ' LIMIT 1';
- $iPlaceID = chksql($this->oDB->getOne($sSQL), "Could not get parent for place.");
- if (!$iPlaceID) {
- $iPlaceID = $aPlace['place_id'];
+
+ if ($aPlace) {
+ // if street and maxrank > streetlevel
+ if ($iRankAddress <= 27 && $iMaxRank > 27) {
+ // find the closest object (up to a certain radius) of which the street is a parent of
+ $sSQL = ' select place_id,';
+ $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 ST_GeometryType(geometry) != \'ST_LineString\'';
+ $sSQL .= ' and (name is not null or housenumber is not null)';
+ $sSQL .= ' and class not in (\'boundary\')';
+ $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) {
+ if (CONST_Debug) var_dump($aStreet);
+ $oResult = new Result($aStreet['place_id']);
+ }
+ }
+
+ // In the US we can check TIGER data for nearest housenumber
+ if (CONST_Use_US_Tiger_Data
+ && $iRankAddress <= 27
+ && $aPlace['country_code'] == 'us'
+ && $this->iMaxRank >= 28
+ ) {
+ $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, 0.001)';
+ $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);
+ $oResult = new Result($aPlaceTiger['place_id'], Result::TABLE_TIGER);
+ $oResult->iHouseNumber = closestHouseNumber($aPlaceTiger);
+ }
+ }
+ } else {
+ // if no POI or street is found ...
+ $oResult = $this->lookupLargeArea($sPointSQL, 25);