Hi TLDR, I think my question below has possibly been answered [here][1] but it's too technical for me to understand. I would like to get the lat-long of some POIs in csv format so I can compare them with a published dataset using Excel (that's all I can manage!) I get the following result with Overpass Turbo: "elements": [ { "type": "node", "id": 7841169184, "lat": 52.5786297, "lon": -0.2276290, "tags": { "addr:city": "Peterborough", "addr:postcode": "PE1 5EH", "addr:street": "Padholme Road", "amenity": "place_of_worship", "denomination": "sunni", "religion": "muslim" } }, { "type": "way", "id": 236058204, "nodes": [ 2441318658, 5934211602, 5934211603, 2441318882, 2441318621, 2441318773, 2441318658 ], "tags": { "addr:city": "Peterborough", "addr:housenumber": "116", "addr:postcode": "PE3 6DD", "addr:street": "Midland Road", "amenity": "place_of_worship", "building": "yes", "denomination": "sunni", "name": "Madina Madrassa & Spiritual Centre", "religion": "muslim" } }, [continues] Can I efficiently identify the lat-long of the area, either interpolating the centre of the area or using (say) the first-listed node? Can I force Overpass to output a csv file with one line per POI, rather than the line-separated text above? Is it even possible for someone who uses iD for map editing, and Excel for database editing, to do this? Many thanks. [1]: https://help.openstreetmap.org/questions/34080/using-r-to-get-lat-and-lon-from-osm_ids-without-assistance-of-external-software-eg-qgis

Hi TLDR, I think my question below has possibly been answered [here][1] but it's too technical for me to understand. I would like to get the lat-long of some POIs in csv format so I can compare them with a published dataset using Excel (that's all I can manage!) I get the following result with Overpass Turbo: "elements": [ { "type": "node", "id": 7841169184, "lat": 52.5786297, "lon": -0.2276290, "tags": { "addr:city": "Peterborough", "addr:postcode": "PE1 5EH", "addr:street": "Padholme Road", "amenity": "place_of_worship", "denomination": "sunni", "religion": "muslim" } }, { "type": "way", "id": 236058204, "nodes": [ 2441318658, 5934211602, 5934211603, 2441318882, 2441318621, 2441318773, 2441318658 ], "tags": { "addr:city": "Peterborough", "addr:housenumber": "116", "addr:postcode": "PE3 6DD", "addr:street": "Midland Road", "amenity": "place_of_worship", "building": "yes", "denomination": "sunni", "name": "Madina Madrassa & Spiritual Centre", "religion": "muslim" } }, [continues] Can I efficiently identify the lat-long of the area, either interpolating the centre of the area or using (say) the first-listed node? Is it even possible for someone who uses iD for map editing, and Excel for database editing, to do this? Many thanks. [1]: https://help.openstreetmap.org/questions/34080/using-r-to-get-lat-and-lon-from-osm_ids-without-assistance-of-external-software-eg-qgis