Tagged Questions
1
vote
1answer
65 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 ...
0
votes
2answers
55 views
Is PostGIS doing a full table scan?
I am trying to retrieve all points p that are within polygons c. While building the query, I came across this strange behavior.
Question: Why does query 2 takes so long compared to query 1? Is it ...
1
vote
0answers
88 views
How can I map data points to OpenStreetMap (OSM) line data?
my goal is to filter measuring points of vehicles by mapping them to streets.
So I could filter out all the false data located in fields and rivers and so on.
I imported my data into a PostGIS ...
2
votes
1answer
129 views
osm2pgsql Error: operator class “gist_geometry_ops” does not exist for access method “gist”
When using osm2pgsql to import massachusetts-latest.osm.bz2 into PostGIS 2.0.1 database osm (running on PostgreSQL 9.1 on an Ubuntu 12.04), I get the error failed: ERROR: operator class ...
1
vote
1answer
127 views
What format is lat/long stored in OSM PostGIS?
Question:
How do I to get the lat, long for all the toll booths stored in OSM for Virginia?
Current Query:
> gis=# select * from planet_osm_nodes where ('toll_booth' = ANY(tags));
id ...
1
vote
2answers
157 views
What Spatial Reference System do I store Google Map's Lat/Lng in
I am new to PostGIS, Spatial Reference Systems and projections and want to store lat/lng coordinates retrieved from Google Maps and Openstreetmap and its services like the Geocoder/Nominatim. I'm ...
1
vote
2answers
55 views
Where can I get public transportation locations for USA
I am trying to find a list of all public transportation/transit locations like subway stations, airports, bus terminals and bus stops for USA. Only major transit locations are required, rural bus ...
2
votes
1answer
71 views
Value at a particular spot on Geoserver Heatmap
Geoserver is drawing from a PostGIS database to generate a heatmap using this SLD extension. Leaflet then overlays the heatmap over the base layer.
Question: How can you determine the value at a ...
2
votes
1answer
92 views
How to get the coastline from OSM?
I've successfully imported all data for Sweden to my PostGIS database. Right now I'm designing my map in Tilemill with OSM Bright as base.
But I've got a major problem: where is the coastline? Right ...
1
vote
2answers
122 views
imposm: Failing to import OSM data to PostgreSQL
Somehow I can't import OSM data to my database. I'm using Debian, PostgreSQL 9.1 and PostGIS 1.5. The user root has been granted all privileges for the database osm.
Input:
imposm -U root -d osm -m ...
1
vote
1answer
187 views
Unreachable vertex
I'm developing an application for academic purposes that mainly gives to the user a recommended itinerary for a previously introduced preferences (Gastronomy, Leisure,etc.).
For this purpose, I use ...
1
vote
0answers
75 views
GeoDjango / PostGIS - Cut geometry by bounding box
I am looking for a solution to retrieve the geometry(ies) from a polygon/multipolygon within a bounding box in a GeoDjango application.
The application I am developing has a requirement to serve out ...
0
votes
2answers
79 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: ...
2
votes
0answers
114 views
Geoserver, PostGIS and KML: Creating clickable nodes from OSM data
I have a PostGIS database that has OSM data imported into it using osm2pgsql and I'm using GeoServer to plot the points into a networked KML file for Google Earth.
What I'd like to do is make the ...
3
votes
3answers
399 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 ...
1
vote
0answers
53 views
django + apache mod_tile
I'm not sure if I'm doing this right and I need your opinion on this current situation. I'm creating a Web Interface using django and postgres as the database. With regards to the slippy map, I went ...
1
vote
2answers
188 views
Turn-by-turn direction using PgRouting
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 ...
1
vote
0answers
39 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 ...
5
votes
3answers
302 views
Raster to vector conversion
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
...
4
votes
1answer
153 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 ...
6
votes
1answer
142 views
How to find the nearest city for a POI in a OpenStreetMap/PostGIS database?
I'm interested in finding additional data for the POIs in OSM database.
Currently I can use the following SQL for getting the name+long+lat for all the POIs
SELECT name,
x(transform(way, ...
2
votes
1answer
90 views
Detect city from coordinates
I need to know how to detect which city belong certain coordinates.
Wich is the best way to do this?
Thanks in advance.
Pd: excuse my english
2
votes
0answers
110 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
...
6
votes
2answers
119 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 ...
1
vote
1answer
343 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
--------+-------------------+-------+-------
...
3
votes
2answers
126 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 ...
1
vote
1answer
111 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 ...
1
vote
1answer
65 views
How to find out what features /tags are included in an .osm or .pbf file?
I would like to load osm data into a postgis (postgresql) database. In
How to load OSM data into PostGIS preserving all Tags? there has beeen a solution posted:
Download the OSM files (in .osm ...
2
votes
3answers
158 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 ...
2
votes
2answers
76 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 ...
5
votes
3answers
455 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: ...
9
votes
3answers
352 views
How to add offsets to the route?
Edited:
I want to ilustrate my question. Suppose that you're in "Point A" and want to go to "Point B". This points wouldn't be in "at_2po_4pgr" table cause aren't source/targets nodes.
Then, I ...
2
votes
0answers
91 views
Create a consistent topology using pgrouting
I'm developing an application that needs routing information for certain cities. First, I downloaded a openstreetmap datafile (*.osm) and then I imported it into a postgreSQL database using ...
1
vote
1answer
84 views
Imposm full database schema import template
I noticed that the default imposm template for importing OSM data into postgis lacks some types of features (powerlines for example). I was searching the web to find a complete schema import template ...
5
votes
1answer
303 views
Is it possible to geocode street intersections using Nominatim?
Is it possible to geocode the location of a street intersection using Nominatim?
Example geocode query
Commonwealth Ave at Washington Street, Boston, MA
Successful Geocode by Google
...
7
votes
3answers
154 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 ...
0
votes
0answers
104 views
Can Nominatim use another OSM importer?
Nominatim comes with osm2pgsql by default and uses it to import the osm files during the initial set up (utils/setup.php).
Problem: I am experiencing problems with importing us-northeast.osm.pbf ...
0
votes
1answer
140 views
osm2pgsql import crashed!
I am currently importing a bz2 country file into PostgreSQL 9.1 database for Nominatim 2 using its setup.php that runs osm2pgsql.
After processing the nodes. it seems to be stuck at a certain spot ...
0
votes
0answers
81 views
Nominatim (postgresql) import problem: unable to start pgsql
While importing the planet files into Nominatim, I encounter the following error below. The import command used is ./setup.php --osm-file us-northeast.osm.pbf --all
I have been following the ...
1
vote
1answer
285 views
Importing planet files into Nominatim
After a gruesome night installing PostgreSQL 9.1, PostGIS 2 and Nominatim 2 on CentOS 6.3 using the instructions here, I am finally at the stage of importing a US planet file.
Problem: In ...
2
votes
1answer
225 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: ...
0
votes
1answer
183 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 ...
0
votes
1answer
370 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 ...
1
vote
1answer
185 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 ...
9
votes
1answer
431 views
Conflate (merge) private shapefile data with OSM data
Background
Downloaded Alberta OSM data from Geofabrik and have it running on a private Linux server using PostgreSQL 9.1, PostGIS 2.0, Mapnik 2.1.0, osm2pgsql, Apache 2, mod_tile, renderd, and ...
2
votes
1answer
160 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 ...
1
vote
0answers
283 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 ...
4
votes
4answers
845 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 ...
6
votes
3answers
706 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. ...
1
vote
1answer
102 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 ...
