Get ODS to take at least the first value (lat/lon)

Question

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

yvonne · Answer

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

Sign up

Already have a Huwise account ?

Login to the community

Already have a Huwise account ?

Scanning file for viruses.

This file cannot be downloaded