Combine two queries into one

ABZ_OSM · 2019-04-02T12:27:03.000Z

I have two queries for the same

{{bbox}}

area.

The only difference between the queries is that one has the following line at the top - which allows me to count houses - and the other does not.

[out:csv(::count,"addr:street","addr:housenumber","addr:housename")];

When I add the above line so I can count the houses I am no longer able to see the nice coloured map on the map tab.

How can I combine both queries so that I have the nice colour map with house numbers as shown on the map tab, like here
http://overpass-turbo.eu/s/HAL

and the house count on the data tab, as shown here
http://overpass-turbo.eu/s/HAK

For clarity I want to complete all of this with one query, not two.

Somehow it seems like it should be easy, but I’m not sure how.

mmd · 2019-04-02T12:39:45.000Z

This is not possible. You can either create csv output or json/xml output, but not both in one query.

ABZ_OSM · 2019-04-02T17:12:52.000Z

Format is not important here. As long as the houses are nicely coloured & numbered and I can get the data I need on the data tab.
All in JSON, XML or csv or any other format would be Ok.

mmd · 2019-04-02T17:34:47.000Z

The data tab contains exactly the same information that is also rendered on the map, and requires XML or JSON format. Once you switch to CSV, you won’t get anything on the map. Basically what you’re asking for is impossible with overpass turbo. You need to somehow create your own tool for it.

fx99 · 2019-04-02T18:59:24.000Z

ABZ_OSM:

Format is not important here. As long as the houses are nicely coloured & numbered and I can get the data I need on the data tab.
All in JSON, XML or csv or any other format would be Ok.

The count information is included in the XML data:

 <count id="0">
    <tag k="nodes" v="0"/>
    <tag k="ways" v="36"/>
    <tag k="relations" v="0"/>
    <tag k="total" v="36"/>
  </count>
.....
  <count id="0">
    <tag k="nodes" v="0"/>
    <tag k="ways" v="9"/>
    <tag k="relations" v="0"/>
    <tag k="total" v="9"/>
  </count>
.....
  <count id="0">
    <tag k="nodes" v="0"/>
    <tag k="ways" v="16"/>
    <tag k="relations" v="0"/>
    <tag k="total" v="16"/>
  </count>
......
  <count id="0">
    <tag k="nodes" v="0"/>
    <tag k="ways" v="61"/>
    <tag k="relations" v="0"/>
    <tag k="total" v="61"/>
  </count>

It is just a bit more work to filter it out.

ABZ_OSM · 2019-04-03T15:07:23.000Z

Yes it is there in the xml output. Is there a way to bring the summary data in xml to the top of the data tab page. I have tried to figure than out …

fx99:

ABZ_OSM:

Format is not important here. As long as the houses are nicely coloured & numbered and I can get the data I need on the data tab.
All in JSON, XML or csv or any other format would be Ok.

The count information is included in the XML data:
 <count id="0">
    <tag k="nodes" v="0"/>
    <tag k="ways" v="36"/>
    <tag k="relations" v="0"/>
    <tag k="total" v="36"/>
  </count>
.....
  <count id="0">
    <tag k="nodes" v="0"/>
    <tag k="ways" v="9"/>
    <tag k="relations" v="0"/>
    <tag k="total" v="9"/>
  </count>
.....
  <count id="0">
    <tag k="nodes" v="0"/>
    <tag k="ways" v="16"/>
    <tag k="relations" v="0"/>
    <tag k="total" v="16"/>
  </count>
......
  <count id="0">
    <tag k="nodes" v="0"/>
    <tag k="ways" v="61"/>
    <tag k="relations" v="0"/>
    <tag k="total" v="61"/>
  </count>
It is just a bit more work to filter it out.

alphensebezorger · 2019-04-03T18:58:40.000Z

ABZ_OSM:

Is there a way to bring the summary data in xml to the top of the data tab page. I have tried to figure than out …

You can just delete the three out:'s from lines 11,13 and 15, and insert one after your 4th out count; in line 27. That should do the trick.

P.S. I’ve cleaned up your query a bit to avoid getting the ways twice from the overpass-server, and filter for the exact streetname. This is the result I ended up with: http://overpass-turbo.eu/s/HEf You might want to take a look at it for inspiration.

ABZ_OSM · 2019-04-03T19:15:13.000Z

Thank you. That’s a lot of help. Is it possible to print out the street name with the count?

alphensebezorger:

ABZ_OSM:

Is there a way to bring the summary data in xml to the top of the data tab page. I have tried to figure than out …

You can just delete the three out:'s from lines 11,13 and 15, and insert one after your 4th out count; in line 27. That should do the trick.

P.S. I’ve cleaned up your query a bit to avoid getting the ways twice from the overpass-server, and filter for the exact streetname. This is the result I ended up with: http://overpass-turbo.eu/s/HEf You might want to take a look at it for inspiration.

alphensebezorger · 2019-04-03T20:26:01.000Z

ABZ_OSM:

Thank you. That’s a lot of help. Is it possible to print out the street name with the count?

I don’t think that is possible using overpass-turbo.eu. At least I wouldn’t know how to do it.
You could try to run Overpass Turbo on your own computer with a modified source code. The source code can be found here: https://github.com/tyrasd/overpass-turbo