Something went wrong. Try again.
Simple forward/reverse geocoder for WhosOnFirst admin data
Something went wrong. Try again.
12345678910111213141516171819-- sql/plus_no_country.sql-- GENERATED - DO NOT MODIFY. See README.litSELECT id as gid, name, placetype, lon, lat, countryFROM dataWHERE substring(lower($1), 1, 3) = prefixAND name ILIKE concat($1, '%')AND placetype IN ['locality', 'county']ORDER BY pop_mag DESC, placetype ASC;