[GIS] How to download only selected attributes using Overpass turbo

openstreetmapoverpass-apiquery

does anyone know of a query to download select attributes using Overpass turbo? I am trying to download very granular road dataset for an entire country, but I only want a few columns. Thanks!

Best Answer

Overpass does not have this feature now. In Overpass Turbo You can export the data in geojson format and then open it in http://geojson.io to remove unwanted columns.

Related Solutions

[GIS] Overpass Turbo Area Code Lookup

When searching for country areas instead of using {{geocodeArea:CH}} I found that this also works: area["ISO3166-1"="CH"]

To retrieve a list of IDs of country areas you can query

(
  area["ISO3166-1"="CH"];
  area["ISO3166-1"="DE"];
  area["ISO3166-1"="FR"];
  area["ISO3166-1"="NL"];
  area["ISO3166-1"="SP"];
  area["ISO3166-1"="RU"];
);
(._;>;);
out;

which will return something like the following, with all relevant tags attached:

  <area id="3600051477"/>
  <area id="3600051701"/>
  <area id="3600060189"/>
  <area id="3600062781"/>
  <area id="3602202162"/>
  <area id="3602323309"/>

A way to get all country area IDs is to query for boundary=administrative & admin_level=2 (see the OpenStreetMap Wiki) in combination with the existence of the ISO3166-1 tag:

area["boundary"="administrative"]["admin_level"="2"]["ISO3166-1"];
out ids;

This results in 214 areas at this point. Leaving out the ISO3166-1 tag results in a 391 results where there are a lot of duplicates and unwanted data. Some entries appeared to be Dutch islands, for example, which exist in addition to the main country Netherlands.

[GIS] Downloading large data sets on overpass-turbo

Am I exceeding the limits

Given that quoted error includes

Dispatcher_Client::request_read_and_idx::timeout. The server is probably too busy to handle your request.

Yes, you requested more than server is able to provide. Try splitting queries into smaller.

Also, from comments:

Besides, both timeout and maxsize values are both ridiculously large: 99999 seconds is more than 1 day (!), maxsize is >10GB

It is possible that server rejects queries with outrageous maxsize and timeout values.

Best Answer

Related Solutions

[GIS] Overpass Turbo Area Code Lookup

[GIS] Downloading large data sets on overpass-turbo

Related Question