Investigate adding go-whosonfirst-spatial-duckdb

[thisisaaronland]

https://duckdb.org/2024/09/09/announcing-duckdb-110.html

[thisisaaronland]

Related:

https://geocode.earth/data/whosonfirst/combined/

D SELECT id,name FROM read_parquet('/usr/local/data/whosonfirst-data-admin-latest.parquet') WHERE ST_Contains(geometry::GEOMETRY, 'POINT(-113.49058382120987 53.55192911144368)'::GEOMETRY);
100% ▕████████████████████████████████████████████████████████████▏ 
┌────────────┬────────────────────┐
│     id     │        name        │
├────────────┼────────────────────┤
│ 1108970679 │ Central Core       │
│ 1108970663 │ Chinatown North    │
│ 890458485  │ Edmonton           │
│ 1108971557 │ Mature Area Sector │
│ 1511799791 │ Edmonton           │
│ 102047473  │ America/Edmonton   │
│ 85874693   │ McCauley           │
│ 85682091   │ Alberta            │
│ 85633041   │ Canada             │
│ 102191575  │ North America      │
└────────────┴────────────────────┘

It's not crazy-fast but probably fast enough.