Something went wrong. Try again.
Simple forward/reverse geocoder for WhosOnFirst admin data
Something went wrong. Try again.
123456789101112131415161718192021-- sql/plus_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 country = $2AND placetype IN ['locality', 'county']ORDER BY pop_mag DESC, placetype ASC;