-
Notifications
You must be signed in to change notification settings - Fork 41
Closed
Labels
Description
Hey,
I just visited this rest area in Norway few days ago and for the fun I compared the data in openstreetmaps:
https://www.openstreetbrowser.org/#map=18/68.59424/16.59066&basemap=osm-mapnik
and overture:
https://explore.overturemaps.org/#16.9/68.594354/16.590991
Overture does know the streets and the buildings properly but the information regarding the toilet and the parking place were stripped away and were not added into the places dataset which I queried locally:
SELECT
*,
ST_Distance_Sphere(geometry, ST_Point(16.59136124040593, 68.59423360286094)) as distance
FROM 'overture/theme=places/*/*.parquet'
WHERE distance < 500
ORDER BY distance;
┌─────────┬──────────┬──────────────────────┬───┬──────────────────────┬─────────┬─────────┬──────────┐
│ id │ geometry │ bbox │ … │ addresses │ theme │ type │ distance │
│ varchar │ geometry │ struct(xmin float,… │ │ struct(freeform va… │ varchar │ varchar │ double │
├─────────┴──────────┴──────────────────────┴───┴──────────────────────┴─────────┴─────────┴──────────┤
│ 0 rows │
└─────────────────────────────────────────────────────────────────────────────────────────────────────┘
Is there any intention to add these in later versions? The geoparquet format is absolutely fantastic compared to the pbf and thus I would really want to use overture instead for most things.
Reactions are currently unavailable