2
votes
2answers
34 views

How to download only selected attributes using Overpass turbo?

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!
1
vote
1answer
26 views

Why do I suddenly get 'ERROR' as elements in my attribute table after doing a query in QGIS?

I was looking at an .osm file in QGIS using the OSM plugin; I was specifically looking at a country's lines layer. When I checked the attribute table just after opening the .osm, everything looked ...
2
votes
1answer
296 views

Help building SQL query to get a list of streets of a city

From two layers in PostGIS (osm_places and osm_roads), I would need to have the roads belonging to a certain city. It would be fair enough to get the street names of all streets in a radius of X ...
2
votes
3answers
370 views

How can I export or query all hospitals from Open Street Map?

I'd like to extract all the hospital locations in the US from Open Street Map as a reference for my geocoding project. I know how to get all the OSM data for a small area with the QGIS plugin but not ...
3
votes
1answer
209 views

How to filter layer of osm data?

I have a table osm_roads that has a column named geometry geometry geometry(LineString,900913). If I want to filter a city to draw districts, I cannot do it by geographic coordinates? What if in ...
3
votes
2answers
152 views

Multiple queries in a row

I have osm data imported into PostgreSQL with osm2po tool (wich makes the data routable). Also I have imported data relationed with nodes and node_tags with osmosis tool. I need to obtain a set of ...
4
votes
1answer
305 views

Improve database performance for geospatial

I have a database with osm data imported with osmosis tool. I want to search for the nearest POIs from a given point. For this purpose, I perform this query: select id from nodes where ...
2
votes
1answer
309 views

How to query OSM tags by polygon?

I do not know whether something like this is possible but nonetheless. If I understand OSM correctly all objects essentially have associated tags based on type of object (street, building etc) ... ...
2
votes
1answer
824 views

troubles with osm2pgrouting

I'm trying desperately to write my first query in pgRouting using maps in osm format (as shown in http://www.carsonfarmer.com/?p=799). Im using Ubuntu 10.10 with Postgresql 8.4 ang postgis 1.5. After ...