query for locations and additionally retrieving their landuse

Hello all,

I need to analyse the locations of electric vehicle charging points for university. I plan on doing that with R and so far I have been successful to get the locations for Germany, France and Italy through a csv export. I would now like to know if it's possible to attach another column with the "landuse" data. It would be very helpful for my analysis to be able to know whether a charging station is in a residential area, commercial area, etc.

Is that at all possible? Thank you for your time.

My query so far:

/*
This is an example Overpass query.
Try it out by pressing the Run button above!
You can find more examples with the Load tool.
*/
[out:csv(::id,::type,"name","addr:postcode","addr:city","addr:street","addr:housenumber",
"authentication.nfc","authentication.none","authentication.membership_card","brand","capacity","car","fee","network","note","opening_hours","operator","socket=*","voltage",::lat,::lon,::timestamp;
    true; "|")][timeout:50];
 area["ISO3166-1"="DE"]->.a;
( node(area.a)[amenity=charging_station];
  way(area.a)[amenity=charging_station];
  rel(area.a)[amenity=charging_station];);
out meta;

asked 24 Mar '20, 17:17

Gerd_Lauer
11●1●1●2
accept rate: 0%

edited 24 Mar '20, 21:19

TZorn
12.3k●7●64●225

I would not expect any of the addr:* tags on a amenity=charging_station, especially not an addr:housenumber

You cannot simply add another field to retrieve the landuse. You will have to make additional queries for that.

(25 Mar '20, 06:49) escada

Thank you @escada. I'm trying to set up queries per landuse type now. Adding the additional column should be very easy in R later-on once I have all the data ready.

If you have a minute, could you help me with the following query? I modeled it after one that I found online that also queried for multiple conditions: https://wiki.openstreetmap.org/wiki/User:Tagtheworld/CSV-Export

The thing is that I don't get any output with this query. Also not with other landuse types so there has to be sth wrong with the query. The output just shows the column headers without content. Do you have an idea for that?

Query: https://pastebin.com/skRgCG8G

(27 Mar '20, 15:00) Gerd_Lauer

Hi there,

As I was told that I cannot retrieve the landuse as another field, I'm trying to create different queries per landuse and then merge them later-on in R.

I have tried to model my query after different variations I found online, namely this one and that one. The problem is that the results of the query are empty fields and I don't know what is going on. I'm very new to the OSM and Overpass Turbo syntax.

My resulting query attempts look like this and that and both produce empty fields.

What I would like to achieve is the following: I want to retrieve the location of all charging stations in Germany, Italy and France. I also need to know what kind of area they are located in. For example I would like to know how many public charging stations are within residential areas of cities, how many are at rest stops on highways, etc.

Can anyone give me a hint as to how I can achieve this? Thank you all for your time.

(28 Mar '20, 11:02) Gerd_Lauer

Can nobody help me with this problem? Whatever I do I can't seem to be able to retrieve the information about the environment of the charging stations. This is the query that I'm using now. That way it returns all charging stations, but as soon as I try to specify the landuse type from ["landuse" = ""] to eg this ["landuse" = "residential"] it returns empty fields. Does anyone have an idea how I could go about somehow adding that information to my csv export or just in general to my query?

(30 Mar '20, 14:56) Gerd_Lauer

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

*italic* or _italic_
**bold** or __bold__
link:[text](http://url.com/ "title")
image?![alt text](/path/img.jpg "title")
numbered list: 1. Foo 2. Bar
to add a line break simply add two spaces to where you would like the new line to be.
basic HTML tags are also supported

learn more about Markdown

Question tags:

export ×315
landuse ×103
csv ×42
charging_station ×10

question asked: 24 Mar '20, 17:17

question was seen: 1,523 times

last updated: 30 Apr '20, 23:49

query for locations and additionally retrieving their landuse

Follow this question

Related questions