User talk:Allenday

From OpenStreetMap Wiki
Jump to navigation Jump to search

Update frequency of the bigquery openstreetmap dataset in google cloud

https://console.cloud.google.com/marketplace/product/openstreetmap/geo-openstreetmap indicates that the update frequency is "historical" but it appears the dataset is being updated (has 2021 data despite the last update timestamp indicating it is sometime in 2020). Should that be updated / changed? --Dónal (talk) 14:36, 30 March 2021 (UTC)


I'm not sure how to reply. I hope you get this message.
The link you give to the marketplace has a doc that is out of date. The dataset are being regularly updated. If you click the "view dataset" link, you'll find that the tables were most recently updated on February 15. Here's one of the tables:
https://console.cloud.google.com/bigquery?p=bigquery-public-data&d=geo_openstreetmap&page=table&t=planet_layers
--Allenday (talk) 15:08, 30 March 2021 (UTC)
Thanks for the information Allen. I guess it's just a meta data / catalog data issue. Would be great to understand if it can be updated so people aren't mislead.
Separately, are there any plans to try and keep the dataset more in sync? I've started exploring biqquery and bigquery ML and it would be great to be able to utilise the openstreetmap dataset.
If it's easier to communicate using the OSM message system, I have the same username there or you can reach me at donal.hunt AT openstreetmap.ie. :)
--Dónal (talk) 09:16, 31 March 2021 (UTC)