http://simonwillison.net/2024-08-01T23:14:49+00:00Simon Willison2024-08-01T23:14:49+00:002024-08-01T23:14:49+00:00https://simonwillison.net/2024/Aug/1/towards-standardizing-place/#atom-tag

<p><strong><a href="https://www.dbreunig.com/2024/07/31/towards-standardizing-place.html">Towards Standardizing Place</a></strong></p> Overture Maps <a href="https://overturemaps.org/overture-maps-foundation-releases-general-availability-of-its-open-maps-datasets/">announced General Availability of its global maps datasets</a> last week, covering places, buildings, divisions, and base layers.</p> <p>Drew Breunig demonstrates how this can be accessed using both the <a href="https://explore.overturemaps.org/#13.1/37.46975/-122.44309">Overture Explorer tool</a> and DuckDB, and talks about Overture's GERS IDs - reminiscent of <a href="https://whosonfirst.org/">Who's On First</a> IDs - which provide stable IDs for all kinds of geographic places. <p>Tags: <a href="https://simonwillison.net/tags/geospatial">geospatial</a>, <a href="https://simonwillison.net/tags/whosonfirst">whosonfirst</a>, <a href="https://simonwillison.net/tags/drew-breunig">drew-breunig</a>, <a href="https://simonwillison.net/tags/overture">overture</a></p>

2018-02-03T05:25:25+00:002018-02-03T05:25:25+00:00https://simonwillison.net/2018/Feb/3/whosonfirst/#atom-tag

<p><strong><a href="https://gist.github.com/simonw/425ede4e8453b89aef00e095dee4f3d3">How I made a Who&#x27;s On First subset database</a></strong></p> Inspired by Paul Ford on Twitter, I tried out a new trick with SQLite: connect to a database containing JSON, attach a brand new empty database file using “attach database”, then populate it using INSERT INTO ... SELECT plus the json_extract() function to extract out a subset of the JSON properties into a new table in the new database. <p>Tags: <a href="https://simonwillison.net/tags/json">json</a>, <a href="https://simonwillison.net/tags/paul-ford">paul-ford</a>, <a href="https://simonwillison.net/tags/sqlite">sqlite</a>, <a href="https://simonwillison.net/tags/whosonfirst">whosonfirst</a></p>

2017-10-04T23:51:20+00:002017-10-04T23:51:20+00:00https://simonwillison.net/2017/Oct/4/whosonfirst/#atom-tag

<p><strong><a href="https://github.com/whosonfirst/whosonfirst-www-api/issues/99">Feature request: a batch version of mapzen.places.getHierarchiesByLatLon</a></strong></p> I’ve been having a lot of fun filing issues against various Mapzen / Who’s On First repositories recently—mainly because the team there are incredibly responsive to suggestions and feature requests. Here’s a fun thread where Aaron Straup Cope and myself have been bouncing around some ideas around batch API design. <p>Tags: <a href="https://simonwillison.net/tags/aaron-straup-cope">aaron-straup-cope</a>, <a href="https://simonwillison.net/tags/geospatial">geospatial</a>, <a href="https://simonwillison.net/tags/mapzen">mapzen</a>, <a href="https://simonwillison.net/tags/whosonfirst">whosonfirst</a></p>