All Questions
Tagged with openstreetmap postgis
388 questions
6
votes
3
answers
3k
views
Raster to vector conversion [closed]
I have a bunch of raster maps from a general plan of a city.
Examples:
Areas reserved for federal, regional and municipal buildings
Special land use zones
Zoning
Risks of occurrence of emergencies
...
CommunityBot
- 1
3
votes
3
answers
3k
views
How do I apply Dijkstra's algorithm in Python with PostGIS data?
I have currently parsed OSM data, from a PBF file, into a pgRouting database with the use of osm2po, an excellent parsing tool. I don't however want to use the algorithms provided by pgRouting and ...
- 191
2
votes
2
answers
2k
views
Turn-by-turn direction using PgRouting [duplicate]
How can I generate turn-by-turn directions using PgRouting?
At the moment, I have a web-page where a user can enter and start/end location and a route is generated on a map (using PgRouting and ...
CommunityBot
- 1
1
vote
0
answers
158
views
How can I assign road names from OSM to gis linestrings using open source tools?
Starting with a shapefile of linestrings I want to assign street names to these lines if there is a match with a road/street in OpenStreetMap.
There are no exact matches as the linestrings have a ...
- 1,565
6
votes
2
answers
1k
views
Join multiple spatial tables by distance
I'm trying to join two tables, one which contains road names and the other just a point. After exhausting research I'm now stuck.
The idea is to join up the two tables using only distance, ie, select ...
- 161
3
votes
0
answers
540
views
From pgRouting shortest_path back to osm node id
I'm successfully performing path finding queries like shortest_path on data imported with osm2pgrouting.
The tables I have inside my pgrouting DB are the following:
List of relations
...
- 903
3
votes
1
answer
3k
views
Creating osm2pgsql tables in PostGIS database
I managed to partially setup osm2psql to work with my PostGIS DB.
My DB contains now the following tables:
Schema | Name | Type | Owner
--------+-------------------+-------+-------
...
CommunityBot
- 1
1
vote
1
answer
453
views
Howto setup osm2psql
I'm following these instructions to setup osm2psql . I need it to import osm data file inside a PostGIS DB.
The following steps worked fine:
createdb -E UTF8 -O user mydb
createlang plpgsql mydb
I ...
- 2,176
3
votes
3
answers
923
views
How can I get a road network to run a simulation on?
I'm new to GIS and I'm asking this a bit out of desperation, but I'm trying my best not to get overwhelmed. :)
I want to download a file that contains data of a road network (of what road network is ...
- 84.5k
3
votes
2
answers
272
views
Why are the results different for the same point using GEOS Point.transform and Postgis ST_Transform?
I'm trying to define a default point setting for OSM layers in my application and I want users to be able to define the default latitude and longitude in EPSG:4326. What I'm doing right now is to use ...
- 41
6
votes
3
answers
6k
views
How to import OSM data into Postgres DB using osm2pgsql in Linux?
I'm using the following command to import an osm file into a Postgres DB using Linux:
osm2pgsql -v -a -U user -S default.style -d routing myfile.osm
I got the following error:
Setting up table: ...
- 1,305
4
votes
2
answers
924
views
Why is osm2pgrouting not importing?
I installed pgrouting successfully and did a little import with a 20Mb file. Works good!
Now I'm trying to import a file with the size of a country and it doesn't even start to import. The last 2 ...
- 84.5k
7
votes
3
answers
849
views
Is there a paid service for accessing a PostGIS/OSM DB
I want to render a world map with mapnik and postgis, but do not want to set up my own DB, because the needed hardware and processing time for the OSM import make it nearly impossible for me. I just ...
- 15.4k
4
votes
1
answer
1k
views
Problem processing OSM file with osm2pgsql
I have an OSM file and when I want to import it in my PostGIS base using osm2pgsql, I get the following error:
Processing: Node(130k 8.7k/s) Way(0k 0.00k/s) Relation(0 0.00/s)Assertion failed: (xlon),...
- 6,739
0
votes
1
answer
1k
views
socket connect failed for: /tmp/osm-renderd
I have installed Mapnik and have a functioning PostGIS database (I can access data through QGIS with no problems). When I try to run render_list to generate tiles it fails with
socket connect failed ...
- 141
0
votes
1
answer
788
views
How to get City, State, Numeration, etc from OSM roads by Geofabrik?
I'm really new in this GIS world. I downloaded a shp file from Geofabrik (http://download.geofabrik.de/osm/south-america/chile.shp.zip) and imported it to Postgresql using Postgis. If I see the road ...
- 84.5k
2
votes
1
answer
742
views
Obtain address from PostGIS OSM data like Nominatim does?
We currently use the Nominatim service to do address lookups. We want to store the OSM data in our own servers as our usage gets higher.
How do I calculate the address of a given coordinate, like ...
- 12.9k
27
votes
5
answers
17k
views
Optimizing osm2pgsql imports for OSM data
I'm currently building an instance on EC2 on which to import the entire Planet.osm snapshot of the whole Earth's worth of data for some projects we're working on. I've spun up a large Ubuntu x64 ...
- 4,267
1
vote
0
answers
1k
views
How to display indoor map using OpenLayers?
I created my osm file in JOSM, and i imported it to my database by osm2pgsql tool.
I created new layer in my osm.xml file, which selecting data with query:
select way from planet_osm_line,
(select ...
- 1,645
2
votes
1
answer
275
views
Simple GIS to Provide Urban Boundaries
I have an app built on top of Google Maps right now and everything works great.
I want to add one feature that seems exceedingly difficult. On my site, I want users to be able to type "Boston, MA" or ...
- 22.6k
5
votes
4
answers
3k
views
OSM To Postgis & WGS84 problems
I’m trying to import OpenStreetMap (OSM) data into postGIS it doesn’t appear to be working in that features do not appear to be in the correct place..
Using the QGIS OSM add in and a coastal shape ...
- 460
9
votes
3
answers
3k
views
Large Open Street Map OSM file to Shapefile. Is there any hope for 32-bit FME?
I have a large OSM XML file (around 8 GB) that I was hoping to process in FME. I have a workbench that I previously used to process smaller files (500 MB) into feature type-specific Shapefiles (e.g. ...
CommunityBot
- 1
1
vote
1
answer
212
views
Generate source_id and target_ id for every segment in a multilinestring geometry (PostGIS|PgRouting)
I am working on a project that requires finding the shortest path and to achieve this, I've used the PgRouting dijkstra function and it's all worked out perfectly.
Initially, the road network was ...
- 4,796
1
vote
2
answers
2k
views
Projecting OpenStreetMap data in PostGIS
I've loaded an extract of Openstreetmap data into a Postgresql database with PostGIS 1.5 using the following command withosm2pgsql.exe:
C:\Program Files (x86)\HOTOSM\bin>osm2pgsql.exe -c -s -H ...
1
vote
2
answers
170
views
How to prevent base layers from being edited?
I've made a local tile server (mapnik + postgis + tilecache).
Now i need to make use of some editing tool so that only newly created layer can be edited: users of this tool shouldn't have rights to ...
- 84.5k
2
votes
2
answers
2k
views
How to add a background map to a java project?
I'm new at GIS. I am trying to make a java application that can display a map with certain points. I have achieved this using the geotools library. However, I want to put the map from OpenStreetMap or ...
- 171
6
votes
1
answer
6k
views
How to extract data for a specific area from OSM? [duplicate]
I need to extract all streets available on a particular area of a City. I'm able to extract all streets name using this query:
select distinct P2.*
from
planet_osm_polygon P1,
planet_osm_line P2
...
- 606
2
votes
1
answer
2k
views
JOSM vs QGIS/uDIG for road network editing and storage
My application needs to store a road network and provide editing functionality for that network (editing/updating/removing lanes, signs, traffic lights, speed limits info, etc.).
I find JOSM tool to ...
- 66.5k
2
votes
1
answer
1k
views
How do PostGIS layers in QGIS work? [duplicate]
I use QGIS 1.4.0 to import a layer which is basically a road network converted from an .osm file to a PostGIS database table by osm2pgrouting.
I have skimmed through the documentation, but I am still ...
CommunityBot
- 1
1
vote
1
answer
493
views
Find all of the ways that intersect a linestring
I'm new to Open Street Map and PostGIS, and am trying to figure out how to
find all of the ways that intersect a linestring (i.e. all of the streets that
intersect a route). Is there a way to do this ...
CommunityBot
- 1
7
votes
2
answers
6k
views
Can't import OSM data to PostGIS, permission denied
I use Postgres 9.1 on Xubuntu 11.10. I've created a db 'aus' and user 'aus', granted ALL on the db to the user. Now I try to import the data, and it outputs this error:
$ osm2pgsql --create --...
- 2,344
6
votes
1
answer
1k
views
Split edges at intersections in PostGIS
I'm attempting to do a walking distance analysis using OpenStreetMap data (osm2pgrouting) and PostGIS and following underdark's blog posts, however I need to exclude residential and service roads that ...
- 84.5k
5
votes
2
answers
4k
views
Geoserver Routing with OSM data and PostGIS
Does Geoserver have a routing functionality for the OSM data in PostGIS?
- 84.5k
2
votes
1
answer
144
views
Temporary additions to OSM data
I'm planning on building a transportation related GIS App.
In the app, users will be allowed to add their own links to the network. For example, let's say a user wants to add a "driveway" in front of ...
- 3,697
6
votes
1
answer
705
views
demo maps for training pgRouting
I'm very new to postgis and pgRouting but I'm using it for my thesys.
I need any map to train my self with routing and TSP problems in pgRouting, but on the Internet I found unworking links only!
Can ...
- 8,608
9
votes
1
answer
1k
views
Creating columns in PostGIS using osm2pgsql hstore tags
While I feel this may come down to a database question, it feels GIS-related enough that I feel comfortable posting it here. I'll be happy to take it elsewhere if it belongs there, though!
I've ...
- 9,865
7
votes
1
answer
4k
views
Find nearest POI of given GPS coordinates
I am new to GIS and need to achieve the following:
Find the nearest train station or bus stop of given GPS coordinates in a Java application. Since there are many coordinates to be checked, an ...
- 14.6k
3
votes
3
answers
5k
views
Render vectors from OSM data in POSTGIS database
I'm a newbie when it comes to mapping application. I had successfully loaded my OpenstreetMap data in a Postgresql/PostGIS database. Now my problem is how to render the vector data (the POI's, ways, ...
CommunityBot
- 1