$sSQL .= ' WHERE osm_type = \'N\'';
$sSQL .= ' AND country_code = \''.$sCountryCode.'\'';
$sSQL .= ' AND rank_address > 0';
- $sSQL .= ' AND rank_address <= ' .$iMaxRank;
+ $sSQL .= ' AND rank_address <= ' .min(25, $iMaxRank);
$sSQL .= ' AND type != \'postcode\'';
$sSQL .= ' AND name IS NOT NULL ';
$sSQL .= ' and indexed_status = 0 and linked_place_id is null';
+ $sSQL .= ' AND ST_DWithin('.$sPointSQL.', geometry, 1.0)';
$sSQL .= ' ORDER BY distance ASC, rank_address DESC';
$sSQL .= ' LIMIT 1';
Scenario: Location off the coast
When sending jsonv2 reverse coordinates 54.046489113,8.5546870529
- | zoom |
+ | zoom |
| 5 |
Then results contain
- | display_name |
- | ^.*Hamburg, Deutschland |
+ | error |
+ | Unable to geocode |