OpenStreetMap is a collaborative project to create a free editable map of the world. The data is free, and free of legal and technical restrictions. OpenStreetMap is often shorted to OSM.

learn more… | top users | synonyms (1)

1
vote
2answers
123 views

Planet_osm_point versus Planet_osm_nodes for querying places

Hello I am using a PostGis Database with OSM Data. After importing the data with osm2pgsql in slim mode I found a table named Planet_osm_nodes that has places also. It seems really compressed and has ...
4
votes
2answers
227 views

Difference between osm_id and place_id?

I'd like to know what the difference is between place_id and osm_id. I understand osm_id is some sort of reference number + more convenient for OSM to find location v. lat/lng. If this is the case, ...
0
votes
0answers
88 views

Map box GL mature / appropriate for own OSM-Tileserver

I am quite new to this topic and currently trying to decide what library to use for developing OSM-apps with my own tile-server for Android, iOS and Websites (currently using Leaflet for websites) - ...
2
votes
1answer
74 views

How to handle duplicate id's when using the as_sp function in the R osmar package

Sometimes when I want to convert a subset of ways from an osm file loaded with the osmar package, I run into an error complaining about duplicate row names. The following code run on this file in ...
2
votes
3answers
91 views

Calculate Color of Object So No Adjacent Objects Repeat

I am attempting to assign one of 16 colors to map objects (e.g. counties, states, ZIP Codes, etc.) so that no two adjacent objects share the same color. I'm seeing tons of articles online about ...
1
vote
1answer
183 views

Marker icons overlapping street names in Tilemill

I'm new to CartoCSS and I'm trying to properly add subway markers on a map using Tilemill and OSM data. My problem is that some street names stay behind my marker icons : I have add ...
0
votes
0answers
80 views

how do I keep only highway roads and their nodes using osmfilter?

I am trying to filter a map from openstreetmaps using osmfilter to keep only highways (tag k) and the nodes that are at the extremes of these road segments. I have read many posts in different forums, ...
3
votes
2answers
209 views

how to extract country border from openstreetmap

I'm trying to extract the Jordanian country border from an openstreetmap. When I click the download link for the file, the following page opens: My question is: How do I save these XML tags as an ...
0
votes
1answer
48 views

osm2po street IDs

Is it somehow possible to always get the same IDs in the _2po_4pgr table and in the routing graph when it's run on newer version on the map? So if I ran it on OSM from today, and then on the same area ...
2
votes
0answers
52 views

How to get changeset tag from .osm file into PostGIS enabled Postgres db

End goal: visualize geographic data from .osm file with QGIS by adding PostGIS layers which include changeset information. I have used osm2pgsql successfully to populate PostGIS and visualize the ...
1
vote
0answers
28 views

Select a polygon which is just partly member of another polygon with its area of the other polygon

I need to generate random points within geometries, which works quite good, but there are some small errors. Take the picture below. There are some greenish and redish Polygons(?!) which do not have ...
2
votes
1answer
76 views

Merge multiple bus stops with same name

my question is similar to this one, but it's not answered sufficiently: How to merge points (bus stops) in QGIS manually or programmatically? I have OSM-transit data with bus stops. Some stops have ...
3
votes
1answer
125 views

How to display OSM relations (in QGIS) from osm2pgsql populated PostGIS DB

I have a PostGIS DB populated with OSM data (osm2pgsql, standart.style). Now I would like to display a hiking trail (http://www.openstreetmap.org/relation/51855). It would also be fine, if I just ...
1
vote
1answer
133 views

PostGis - BBox -vs- ST_intersects Queries

CartoDb Recommend here that the following query is faster than an St_intersects Query SELECT * FROM {table_name} WHERE the_geom && ST_SetSRID(ST_MakeBox2D(ST_Point(-73.9980, 40.726), ...
1
vote
1answer
138 views

CartoCSS Expression for shield-name

Is there any way to use a regular expression to filter a string when using CartoCSS expressions? I have geojson of some ways and route relations I obtained using Overpass Turbo. When creating a new ...
0
votes
0answers
129 views

Changing OSM Meta Tile Cache Location

We built an OSM Tile Server following the instructions at http://switch2osm.org/serving-tiles/building-a-tile-server-from-packages/ The Ubuntu OS and the Tile server database are on a 1 TB SSD which ...
4
votes
0answers
108 views

Spatial query too slow to handle bigger OSM extracts

I'm trying to compute some statistics for OSM data using PostgreSQL 9.3.5 and PostGIS 2.1.4. I started with a small bavaria extract which I downloaded from Geofabrik. The db schema is the normal API ...
0
votes
0answers
46 views

GIS Data from osm visual in google maps

I have download from openstreetmap data for my project in a workshop i use den coordinates from a roads network ,but i have problem with visualization the cord in google maps same roads is not drawn ...
1
vote
1answer
109 views

OSM Tiles slow at low zoom levels

We have built an OSM Tile Server following the instructions at http://switch2osm.org/serving-tiles/building-a-tile-server-from-packages/ We have imported planet_latest.osm.pbf. Our server renders ...
0
votes
0answers
282 views

OSM Tile Server: How to avoid 404 errors?

We have built a OSM tile server with the following hardware Make: Dell Model: PowerEdge T110II RAM: 16GB HDD: 1TB RAID 1 using the excellent instructions provided by ...
1
vote
0answers
49 views

DPI Dependent OSM Tile Rendering

We have built an OSM Tile Server following the instructions at http://switch2osm.org/serving-tiles/building-a-tile-server-from-packages/ The tile server is rendering tiles, but the street names on ...
1
vote
2answers
104 views

OSM queries on history?

I would like to get a list of modifications on the OSM database, in a given bounding box, between two given dates and impacting a given set of tags. Does anyone know how to do this? Any command-line ...
2
votes
4answers
183 views

PostGIS doesn't use spatial index with ST_Intersects

I imported the data from openstreetmap using osm2pgsql and copied it another table structure. If I made a query for containing rows using st_intersects, st_contain or someone else, postgis don't use ...
0
votes
1answer
267 views

Get postal codes of a city in OSM via postgis/postgresql

So, I'm trying to get the postal codes of a city (polygon). Unfortunately, I never get consistent results with my code: SELECT a.name, b.tags->'postal_code' FROM planet_osm_polygon a JOIN ...
2
votes
0answers
41 views

nominatim api for long streets

I'm using the Nominatim API in geojson method to retrieve streets poly line. For short streets I have no issue and the results are good. However for long streets the data I'm getting back in the ...
0
votes
2answers
209 views

using mod_tile in windows

I am trying to generate tiles on the fly in windows using mod_tile. I have followed the tutorial http://switch2osm.org/serving-tiles/manually-building-a-tile-server-14-04/ on ubuntu and successfully ...
0
votes
1answer
279 views

What can I do in Mapbox Studio with the osm_id number for #buildings from Mapbox Streets?

My goal is to use OpenStreetMap buildings data to create map tiles that show buildings styled with information such as name, floors, and other information from the tags associated with the way/feature ...
1
vote
0answers
33 views

OpenStreetMap Nominatim Underscore Amenities Not Working

I'm trying to locate the drinking_water amenity in Nominatim to no avail. When I run the following query: ...
1
vote
2answers
68 views

How can I add another WHERE filter to a PostGIS query?

I have this query, which works well, for an OSM database: SELECT row_to_json(fc) FROM ( SELECT ST_AsGeoJSON(ST_Transform(ST_Intersection(lg.geometry, bbox.geom), 4326))::json As geometry, ( ...
1
vote
3answers
698 views

Load external tileJSON file in Mapbox

I have tiles generated by Maperitive from an OSM file, and there's a nice tiles.json generated with them which specifies neatly the tiles-path, bounding box, minzoom, maxzoom, center, etc. The format ...
2
votes
1answer
84 views

Overpass (command line): how to view the results on a map?

I've tried to play with Overpass from command line because I've to do a query quite "expensive" that Overpass Turbo can't to do My issue is about to download all the addresses in Italy Here you are ...
1
vote
2answers
183 views

PostGIS SQL syntax for bounding box

I have the following query: SELECT row_to_json(fc) FROM ( SELECT ST_AsGeoJSON(lg.geometry)::json As geometry, ( select row_to_json(t) from ( ...
1
vote
2answers
86 views

Best way to get osm.pbf data for a given extent?

I need to download/create a PBF file containing all osm data for several french urban areas. To select data, I have, for each urban area, the values of the attribute ref:INSEE for every city composing ...
0
votes
0answers
129 views

Loading minimap in Leaflet

I use this for loading google basemaps https://gist.github.com/crofty/2197042#file-leaflet-google-js , this to switch basemaps https://github.com/ismyrnow/Leaflet.groupedlayercontrol and this as ...
3
votes
2answers
175 views

Create smaller OSM with only basic zoom levels data from larger OSM file

From a large .osm/.o5m file (for India), I only want to extract the data that would actually show up when one is looking from zoom levels 1/0 through 8 (which is quite zoomed out.. only major cities, ...
2
votes
1answer
216 views

ST_INTERSECT of each element of two tables (polygons, lines)

Im new to postgis and trying to solve the following problem: I have two tables: 1. containing polygons 2. containing lines I need to find out the id of all polygons on each line and fill them in new ...
0
votes
1answer
56 views

Search for untagged ways in overpass-turbo

Is there a way to search for untagged ways that are not part of a multi-polygon relation using overpass-turbo.eu? I am trying to locate all ways in my county that were not tagged (i.e. untagged ...
0
votes
1answer
108 views

Open Street Map and Arcgis 10.1 Network Analyzer

how to make roads in open_street_map ready for network_analyze in Arcgis-10.1 Details: I'v download an osm map of my town I saved the street lines as polyline shapefile I opend them in arcgis-10.1 I ...
1
vote
1answer
61 views

OSM iD editor WMS support

i want to use my WMS layer as a background in OSM iD editor. I know it works in JOSM but i couldn't figure it out in iD editor.Any one knows how to do this?
1
vote
1answer
30 views

QGIS explode line function fails with OSM file

I am exporting a small extract from OSM. I load the lines(layer 1) into QGIS and apply the function Explode lines. I get the error: Algorithm Explode lines starting... __len__() should return >= 0 ...
2
votes
1answer
136 views

Extract administrative boundaries

I'm looking to create maps of administrative boundaries. Sometimes nested. For example I want to create shapefiles or geojson-files for all the countries in the world, including states in the US and ...
0
votes
1answer
80 views

How do I project OSM tiles to a custom coordinate system?

Background: I'm planning to use OSM data to generate tiled maps and then serve them up as an internal service (hosting service still TBD). I want to be able to consume the tiled maps in both ArcMAP ...
2
votes
2answers
234 views

Prevent Leaflet from requesting non-existing custom tiles

I have created custom tiles using TileMill. extracted tiles as png images and adding them on base layer. using following code var venu_map = new L.tileLayer('static/b18/{z}/{x}/{y}.png', { ...
2
votes
1answer
110 views

Creating Spatialite DB from Swedish OSM

Good afternoon, I have just started to use GDAL/OGR and I am trying to create a spatialite DB from OSM data. I am using a cut of the Swedish OSM data downloaded from Geofabrik in .osm format. I have ...
2
votes
2answers
122 views

How to export a Shapefiles of an OpenStreetMap relation?

Given I have a relation such as this example. I have installed JOSM and QGIS as well as GDAL tools for the shell. I am aware of Overpass-Turbo. What is the best way to export geometry data from ...
2
votes
1answer
384 views

A way to search street intersection on openstreetmap

I need to find intersection by searching name of 2 streets; I fonud overpass API to query on osm data; the way i found was to find a node near a way; but the problem is all nodes don't have name and ...
1
vote
0answers
123 views

Calculate the distances between n geographical points

First of all, I'm sorry if my question is stupid, but I'm totally new to the world of GISs and geographic measurements. I would like to calculate the distances between N (an arbitrary number, but ...
0
votes
0answers
95 views

How to select main cities in a country from planet OSM data

I am trying to create a map with my own style with the help of geoserver and planet OSM data,but trying to give style to the polygon at different zoom level ,need to highlight main in cities in ...
1
vote
0answers
235 views

PostGIS: snap latitude/longitude input to nearest OSM road point

I need a function to return the nearest OSM road point for any latitude/longitude. i.e. users input a latitude/longitude and postgis finds and uses the point on a road that is the nearest to it. ...
0
votes
0answers
35 views

ST_Touches Function in Iterative Process

Im a complete newbie to postgis. I have the following problem: Got two tables: "mp_power_lines_new" -> contains lines of an electricity grid "uw.new"-> contains polygons of all substations in this ...