All Questions
Tagged with openstreetmap postgis
388 questions
2
votes
1
answer
1k
views
pg_dump Database that was populated with osm2pgsql
Is it possible to dump a postgres database that was created with osm2pgsql and a .osm.pbf file with pg_dump and import this into a remote postgres database?
After running osm2pgsql the database is ...
CommunityBot
- 1
3
votes
2
answers
1k
views
OSM To Postgis & WGS84 Newbie confusion
I wonder if someone can clarify as I'm confused.
I need to load planet OSM data into PostGIS so I downloaded a small data set of a UK County and followed the instructions here loading the Google ...
- 13.6k
3
votes
0
answers
380
views
Loaded OSM Data into PostGIS Database. Cannot view in ArcMap "The coordinate system identifier is invalid" [closed]
I loaded OSM File for Pennsylvania into a PostGIS Database in PostgreSQL using osm2pgsql. Everything seemed to go without a hitch until I finally connected to the Database in arcCatalog and tried to ...
- 65.4k
7
votes
1
answer
3k
views
How to interpolate polyline or line from points?
We have a lot of points, but with no timestamps to create ways. For now, I've created a sample of the way the points traverse. It's in here, this way can be compared with a Google one.
I haven't ...
CommunityBot
- 1
2
votes
1
answer
349
views
pgRouting from geocoded user input
have created database by tool osm2pgrouting. On my website can user enter start and end point.
How can I find ids of nodes? Because I have only text value of nodes which enter user, but tables ...
- 65.4k
1
vote
1
answer
102
views
PostGIS error with working expression
I'm using OSM-Data via PostGIS (osm2pgsql). To draw a highway with and without bridges or tunnels, I use the following expressions:
The highway:
"highway" = 'motorway' AND "bridge" IS NOT 'yes' AND ...
- 190
15
votes
1
answer
1k
views
Combined Hstore key/value and 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....
CommunityBot
- 1
2
votes
0
answers
169
views
Exported OSM database do not contains node names
I've used osm2pgrouting tool to export data from osm file to my postgresql database. Now I have database with this schema:
osm_node:
-node_id
-osm_id
-lon
-lat
-numofuse
-the_geom
...
- 65.4k
2
votes
3
answers
4k
views
How to get India OSM map offline in geoserver which looks similar to online OSM map?
I need to OSM map of India having same look and feel as of Online OSM map. I have done following steps for the same :
I have downloaded India map OSM data from below link :
http://download.geofabrik....
- 65.4k
1
vote
1
answer
329
views
Error with TileMill and OpenStreetMap Carto project
I have been trying to load the OpenStreetMap carto project in order to export tiles for use on our in house GIS Server. I have followed all the instructions up to loading the osm xml into postGIS and ...
- 65.4k
1
vote
0
answers
91
views
Finding relation between Nominatim row and gb_postcode table row?
Currently I have PgAdmin 3 open with a copy of the Nominatim DB I processed on a Linux virtual machine. I imported the gb_postcode.sql database successfully from the Nominatim documentation but I'm ...
- 65.4k
0
votes
1
answer
274
views
How to quick-fix drive time in residential area with Osm2PgRouting?
I'm currently testing pgRouting using OpenStreempMap XML dataset loaded via Osm2PgRouting. My goal is to solve shortest path problems using time driven costs instead of path length.
I noticed that ...
- 1,250
1
vote
1
answer
1k
views
How to update the OSM data in a PGRouting Database built with osm2pgrouting?
I'm using a PGRouting database originally built with osm2pgrouting from a *.osm file downloaded from Mapzen.
If I want to update the OSM data in that database, ie. re-build my PGRouting Database, ...
CommunityBot
- 1
1
vote
0
answers
244
views
OSM Bright Cartography XML
I have successfully setup a tile server as described here: https://switch2osm.org/serving-tiles/manually-building-a-tile-server-14-04/
What's troubling is the lack of clarify surrounding OSM Bright ...
- 65.4k
1
vote
1
answer
555
views
OSM postgis radius search
I imported the OSM data into my Postgresql 9.5 database, I also installed the Postgis. So when I use these SQL-Syntax:
SELECT
ST_Y(ST_Transform(point.way, 4326)) AS lat,
ST_X(ST_Transform(point.way, ...
- 65.4k
1
vote
2
answers
452
views
Enlisting all OpenStreetMap (OSM) street names for General Transit Feed Specification (GTFS) routes?
I have exported OpenStreetMap (OSM) data of a city to my local postgresql db using osm2pgsql.
I would like to add the General Transit Feed Specification (GTFS) routes information (say bus routes) ...
CommunityBot
- 1
0
votes
1
answer
548
views
How to publish multiple languages in geoserver, data from osm
I need to generate maps with labels in multiple languages. Currently I have already imported the osm data into postgis and pusblish it with geoserver, but apparently after querying the feature (using ...
CommunityBot
- 1
4
votes
2
answers
4k
views
How to find the country in which a point is located?
I have a PostGis database created with osm2pgsql. I am looking for a way to add the country name in which a point is located to the point row. It must work also for countries with enclaves, such as ...
1
vote
2
answers
103
views
Average road distance for each county between two location/Lat-Long
Say, one travels from Times Square (1451 Broadway New York, NY, 10036) to White House (1600 Pennsylvania Ave NW, Washington, DC 20500). For this 4+ hour drive, I would like to calculate the average ...
- 11.1k
2
votes
2
answers
3k
views
Applying OSM z-order after osm2pgsql with qgis
I've trying to find a solution to applying the OpenStreetMap z-order in QGIS after using osm2pgsql. Everything is working perfectly, until I add the each layer to the canvas, where the z-order is not ...
- 1,477
2
votes
2
answers
1k
views
Starting Tile Sever Rendering Error: OSMBright.xml
I was following the entire process found here: https://switch2osm.org/serving-tiles/manually-building-a-tile-server-14-04/
I have an error though on Testing your tileserver part where i run the ...
CommunityBot
- 1
0
votes
1
answer
237
views
Download boundaries from OSM to Postgis
I need to download some cities boundaries polygons and store them in a Postgis database. Is this possible? Using what tools?
- 11.6k
4
votes
1
answer
373
views
Tracking OSM "Planet" Extract dates
I'm trying to build a GUI that allows replacement / update of the PostGIS database that holds my OSM extract (which I use for rendering, typical mapnik / tile server arrangement).
I'd like to show ...
- 3,640
2
votes
1
answer
464
views
OSM Carto Street Numbers style rules for OSM Bright
I'm running an OSM tile server stack using Mod_tile, renderd, mapnik, osm2pgsql and a postgresql/postgis database on Ubuntu Linux 14.04.
I've chosen OSM Bright for my tiles, but i would like to ...
- 1,606
0
votes
1
answer
353
views
Updating OSM data
I'm trying to keep my OSM PostGIS data up to date by reading this tutorial http://wiki.openstreetmap.org/wiki/Minutely_Mapnik
The time periods are minute, hour and day, but I think a daily update is ...
- 3,640
1
vote
0
answers
136
views
How to create cost maps based on OSM (landuse/...)? [closed]
I'd like to create cost maps (georef raster) for cross-country hiking based on OSM from pgsql/postgis plus height data.
Maybe by creating multiple raster-files and the later merging them (lake=...
- 143
2
votes
2
answers
9k
views
Instruction to import OSM file using PostGIS in windows
I want to import OSM data into a PostGIS database running under windows. After a web search I learned that I should use osmosis. But most of the explanations are for Linux. But I have to use windows. ...
CommunityBot
- 1
1
vote
1
answer
645
views
Delete tags from planet.osm with osm2pgsql and minimize size of database
I want to import into PostGIS the whole planet but I am interested for certain tags. Specifically I am not interested in nodes, ways and areas which are related with the land. Below is a small part ...
- 1,129
11
votes
2
answers
5k
views
How to convert OSM Data to PostgreSQL for Routing Purposes?
I'm creating a routing application using OpenStreetMap. Currently, my task is to convert the data from an OSM file to PostgreSQL.
I read about osm2pgsql, but the problem is it says there that ...
- 3,274
1
vote
1
answer
1k
views
Getting node information of a way in OSM2PGSQL data
I have a feeling this is not possible, but I am looking to get information on the nodes which are part of a line in the planet_osm_line table.
The issue which I am trying to handle is I am trying to ...
- 306
1
vote
2
answers
2k
views
Casting between PostGIS types in GeoAlchemy
I'm working with OpenStreetMap data, and loading it into a PostGIS database using osm2pgsql.
The issue that I am currently dealing with is that osm2pgsql stores the shape as a geometry type.
I'm ...
- 103
2
votes
1
answer
407
views
PostGIS help writing a ST_MakeSimple method for self intersecting lines?
I have imported Open Street Map lines into PostGIS 2.1 and I need to clean up the self intersecting ways. I have done some manual edits in the past but there are many more ST_IsSimple(way) = false ...
CommunityBot
- 1
1
vote
2
answers
406
views
What is the format for OSM lat/lon in .osm/.osh files and how to import correctly into PostGIS?
I've been having issues converting OpenStreetMap geometries to valid points in PostGIS.
MY PostGIS table has the this definition for the geom column:
SELECT AddGeometryColumn('node','geom',900913,'...
- 65.4k
4
votes
1
answer
1k
views
Styling OSM data with OSM-Carto
I have set up on Ubuntu a tile server by following this tutorial
I followed the instructions for downloading and configuring osm-bright, but now I want to use the openstreetmap-carto stylesheet.
In ...
3
votes
1
answer
141
views
Postgis Query Construction - postgresql
I'm a newbie and I need a little bit help with postgis query construction. My situation looks like this.
I have a table in postgresql with ways converted from bicycle routes (take from Open Street Map)...
- 41
5
votes
3
answers
3k
views
How to route between lat/lon pairs in pgRouting?
I have set up Postgresql, PostGIS and pgrouting on Ubuntu.
I have imported an osm for wales using the following command:
./osm2pgrouting -file wales.osm \
-conf mapconfig....
- 12.1k
2
votes
1
answer
260
views
Load filtered OSM relations into Postgis with OSMOSIS
I am really hitting the wall trying to grips with merging filters in OSMOSIS.
I would like to load relations, their related nodes and ways.
If I use a tag filter like this:
--tf accept-relations ...
- 77.1k
4
votes
0
answers
139
views
Wrong coordinates after loading OSM to postgre [closed]
After loading OSM data for whole Europe to postgres (Osm2pgsql) I'm trying to add them to Geoserver, but the coordinates are totally wrong. The SRS is correct (4326), but the coordinate values are ...
- 1,958
5
votes
3
answers
2k
views
Importing OSM files to PostGIS
I have installed QGIS 2.4.0 on Windows. I also downloaded an OSM file form Geofrabrik (SouthAmerica).
I have been searching an option (plugin also) in QGIS for importing the OSM file to my PostGIS ...
- 550
2
votes
0
answers
194
views
How to quickly get coverage of multiple services at once using pgrouting driving distance
I'm trying to get some useful information out of openstreetmap data to choose where to rent an apartment in my city.
I used osm2pgrouting and osm2pgsql to get OSM data into my postgis database.
So far ...
- 447
2
votes
2
answers
610
views
How to style ways with CartoCSS depending on a relation property (OSM)
I'm using CartoCSS together with an OSM Postgres DB (hstore on).
I want to set the line color depending on the operator tag of relations (routes).
How can I do that?
Update
Thanks to Paul Norman for ...
CommunityBot
- 1
1
vote
1
answer
1k
views
Where to download .osm files and how to convert it to .xml? [closed]
I am new to deal with OSM data, and I want to download only .osm files not .pbf. I tried geofabrik.com but it provides .osm.pbf file format
where can I download .osm files?
is there any recommended ...
- 65.4k
1
vote
0
answers
444
views
Automatically generating raster maps (from OSM) for areas bounded by polygons?
In order to create walking lists for a volunteer campaign I have used qgis to draw polygons over groups of addresses. These are irregular areas, so I've used postgis's ST_ENVELOPE function to ...
- 65.4k
7
votes
1
answer
524
views
Find and destroy duplicate OSM multipolygon/polygons in TileMill/PostGIS
In OpenStreetMap there are sometimes multipolygons where attributes are present on both the polygon and the multipolygon relation, such as the Grampians National Park:
http://www.openstreetmap.org/...
- 748
1
vote
0
answers
83
views
Updating an Openstreetmap PostgreSQL database after the system restore
My Openstreetmap PostgreSQL database takes a long time – about 25 hours by now – for updating via Osmosis after I had made a system restore at the last weekend. Before making the system restore it ...
- 198
6
votes
2
answers
2k
views
Reverse geocoding using OSM data imported into PostGIS
I'm trying to reverse geocode some points using an OSM import into PostGIS. I imported the OSM data (for Denmark so all addresses should be avaialable) into PostGIS using osm2pgsql enabling "addr:...
- 13.2k
2
votes
1
answer
515
views
PostGIS: How to dissolve vector data
I have a few scenarios where I need to dissolve vector data, and I'm wondering how to do this using PostGIS. What would the queries look like to perform these operations?
Below I'll describe the ...
- 20k
0
votes
2
answers
326
views
Creating Intranet GIS application [duplicate]
I am working about task for custom GIS application (about 70 users). It must show a map of region with custom objects from database (they will be triangles, lines, and icons with coordinates) . Users ...
- 111
2
votes
1
answer
4k
views
Show geometry on a web map
Is there a simple webpage that I can paste a geometry field from POSTGIS (OSM data - sRID 900913) and it will show on the map?
Something like this http://www.darrinward.com/lat-long/ but with ...
- 616
0
votes
2
answers
676
views
error while loading osm2po routing sql-script into PostgreSQL
please advice what could be wrong in my situation:
I succesfully generated sql-file using osm2po
I tried to run it within PostgreSQL and got the following error:
********** Error **********
ERROR: ...
