Skip to main content

I’m trying to use some Openstreetmap data in ODS.

However some of the data is formed where there are multiple lat/lon for an ID and when bringing it into ODS, ODS takes none of the lat/lon pairs when there are multiple.  See screenshot of the multiple lat/lon pairs

 

The records with multiple happen to be at the bottom as I think (assume) ODS uses the first 20 rows to determine a pattern.  I want ODS to at least take the first pair of lat/lon so the data is somewhat accurate (at the moment it just ignores this and leaves the lat and lon fields blank.

 

Query used for bringing in the data is here:

https://overpass-api.de/api/interpreter?data=%2F*%0AThis%20query%20looks%20for%20nodes%2C%20ways%20and%20relations%20%0Awith%20the%20given%20key%2Fvalue%20combination.%0AChoose%20your%20region%20and%20hit%20the%20Run%20button%20above%21%0A*%2F%0A%5Bout%3Ajson%5D%5Btimeout%3A25%5D%3B%0A%2F%2F%20gather%20results%0Anwr%5B%22highway%22%3D%22elevator%22%5D%28-27.870644599673355%2C152.0219421386719%2C-26.906150838533318%2C153.7138366699219%29%3B%0A%2F%2F%20print%20results%0Aout%20geom%3B

 

the ones I can’t bring it are Ways, which are shapes/polygons so I’ll exclude them from the query which should fix that dataset.  :)  

 

And now fixed.  Changed the source query which is now this

https://overpass-api.de/api/interpreter?data=%2F*%0AThis%20has%20been%20generated%20by%20the%20overpass-turbo%20wizard.%0AThe%20original%20search%20was%3A%0A%E2%80%9Celevator%20in%20brisbane%E2%80%9D%0A*%2F%0A%5Bout%3Ajson%5D%5Btimeout%3A25%5D%3B%0A%2F%2F%20fetch%20area%20%E2%80%9Cbrisbane%E2%80%9D%20to%20search%20in%0Aarea%28id%3A3611677792%29-%3E.searchArea%3B%0A%2F%2F%20gather%20results%0Anode%5B%22highway%22%3D%22elevator%22%5D%28area.searchArea%29%3B%0A%2F%2F%20print%20results%0Aout%20geom%3B

Reply


Terms & ConditionsCookie settings
Opendatasoft Terms & Conditions Cookie settings