Something went wrong. Try again.
Simple forward/reverse geocoder for WhosOnFirst admin data
Something went wrong. Try again.
123456789101112131415161718192021222324252627282930-- load.sqlINSTALL spatial;LOAD spatial;SET geometry_always_xy = true;INSTALL h3 FROM community;LOAD h3;
CREATE TABLE data ASWITH clean AS ( SELECT id, parent_id, name, placetype, country, lon, lat, h3_latlng_to_cell(lat, lon, 4) as cell_id, modified, len(population) as pop_mag, ST_Point(lon, lat) AS point, substring(lower(name), 1, 3) as prefix, ROW_NUMBER() OVER (PARTITION BY name, placetype, country, cell_id ORDER BY pop_mag DESC, modified DESC) as rn FROM '%s')SELECT *FROM cleanWHERE rn = 1;