All Questions
Tagged with openstreetmap postgis
388 questions
1
vote
1
answer
1k
views
Mapping application basic for ruby on rails
I am new to build map application using ruby on rails, with rails 4.1.1.
I want to create map using map tiles. i have to use PostgreSQL database with postgis.
Can you please explain how this flow ...
- 61
1
vote
1
answer
335
views
How to configure osm2po to ignore certain class types?
I'm trying to import data using osm2po but am only interested in driving distances, so I'd like to omit all footway, cycleway, steps, etc. in the imported dataset. How can I configure osm2po to do ...
- 3,318
0
votes
1
answer
115
views
postgis loader osm shapefile
I downloaded the map of my city already in shapefile into postgis http://metro.teczno.com/ to load in order to consult routes using pgRouting.
Iss happening the error: http://metro.teczno.com/
...
- 2,376
5
votes
3
answers
5k
views
Offline Map Service with Mapnik and Leaflet
I'm relatively new to GIS, so I hope my asking doesn't appear to be ignorant in any way.
I currently work on an offline map service solution for usage in areas without internet connection. For that ...
- 141
2
votes
1
answer
1k
views
Converting a JOSM indoor map to QGIS
I have created an OpenStreeMap layer of the indoor of a bulding by following this tutorial: https://wiki.openstreetmap.org/wiki/IndoorOSM, since that is only a proposed tagging schema for indoor ...
- 6,739
1
vote
1
answer
893
views
How to use Mapserver+Openstreetmap for tracking service effectively?
I have got Asset tracking installations for many clients.
The availability of GIS map data for every client location seems to be the tough part. I have got a MapServer WMS installation.
Can I use OSM ...
CommunityBot
- 1
0
votes
3
answers
249
views
How to extract shape of each segment?
osm2po library does a great job in creating the data required by pgRouting to calculate theshortest paths. But I need the shape (Geometry - LineString 4326) to be extracted when osm2po generates the ...
CommunityBot
- 1
1
vote
1
answer
311
views
Will ogr2ogr correctly merge features from several OSM files to resulting set
In GDAL >= 1.10, ogr2ogr contains osm driver
I want to try this feature and migrate OSM to PostGIS (I'm aware of osm2pqsql existence)
I have several relatively small OSM files and wonder if ...
- 69.1k
0
votes
1
answer
112
views
Missing hstore column in TileMill!
I made a PostgreSQL with PosGIS Extension DB with the pgsnapshot_schema and loaded an .osm.pbf-file with OSMOSIS into it.
Now i connected it to TileMill, but if i look up into the table i just see ...
CommunityBot
- 1
1
vote
2
answers
2k
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 ...
- 405
3
votes
1
answer
1k
views
How do I avoid this osm2pgsql duplicate key error in Windows?
I am attempting to load an OSM .bz2 file into a PostGIS database using osm2pgsql but am stuck at a duplicate key value in the nodes which violates a unique constraint - any suggestions? output is ...
- 1,606
2
votes
0
answers
527
views
TileMill Exports Failing
I'm having trouble exporting my map in TileMill (v0.10.1). I'm using OSM Bright with a PostGIS database connection to import OpenStreetMap data. When exporting an SVG or PDF through the user interface ...
- 21
2
votes
1
answer
2k
views
Difference between planet_osm_polygon and planet_osm_point tables
What's the difference between the planet_osm_polygon and planet_osm_point tables? I find similar columns in both tables.
- 9,001
4
votes
1
answer
666
views
How to render overlapping bus trips as one route from OSM?
I would like to create bus map for my city from OSM data.
I imported data into Postgresql with osm2psql and I can render routes with Mapnik. But the problem is that same route ref is shown multiple ...
CommunityBot
- 1
12
votes
5
answers
5k
views
Speeding up OpenStreetMap PostGIS querying
I have OpenStreetMap data for the Netherlands loaded into a PostGIS database (PostgreSQL 8.3 / PostGIS 1.3.3) using the osmosis schema. This means all tags are stored in a hstore field. In addition to ...
- 1,606
1
vote
1
answer
1k
views
convert data from osm to osm tiles/marble
I need to convert the raw thata OSM XML to tiles styled like standard OSM tiles (and other styles if possible)
From the research I've done I've found I need to have osm2pgsql and put it on the same ...
- 519
0
votes
1
answer
337
views
an efficient way to find the pgrouting edges contained within an isochrone
So I am working with some pgrouting road network data in postgis2.0/postgresql 9.1. I am interested in routing around certain types of disasters like tornados or such. If a disaster event happens at ...
- 2,617
1
vote
1
answer
546
views
can I add additional data to an existing pgrouting postgis database using osm2pgrouting?
This is just a simple question but I could not find the information in the documentation. If I have an existing pgrouting database table named routing, can I add additional OpenStreetMap data to this ...
CommunityBot
- 1
1
vote
1
answer
397
views
Automatic four-colour (political boundary) rendering with PostGIS
This is probably a long shot, but is there a way to automatically select colours for neighbouring regions using the four colour theorem, in PostGIS? The data I'm using is suburb boundaries in ...
- 65.4k
4
votes
1
answer
539
views
Local Copy of OpenStreetMap of my City in PostGIS Database
I would like to use OpenStreetMap vector data for land cover analysis in my city.
Here is my goal:
I set up a PostGIS database with the city area extent (around 20x20 km) on my server.
I will ...
- 77.1k
1
vote
2
answers
147
views
Getting OSM data for a particular jurisdiction
I'm trying to make a street map of New York City (and only New York City). I've downloaded OSM data for the area (from here), but it contains lots of data from the suburbs.
Currently, I've loaded ...
CommunityBot
- 1
2
votes
2
answers
2k
views
Extract a PostGIS dump from OSM with a particular tag
I'm new to OpenStreetMap. I want to extract all restaurants from Switzerland with their capacity if available. I am using osmosis. I tried:
osmosis --read-pbf file=switzerland.pbf --tf accept-nodes ...
CommunityBot
- 1
4
votes
3
answers
2k
views
Why is sum of st_length() of segments 20% too big?
I'm running a query to return the total length of some bike paths, from OpenStreetMap. Compared to the known actual length of these paths, they're all a bit too big - something like 10-30%.
I know it ...
CommunityBot
- 1
1
vote
1
answer
600
views
Osm2pgsql crashed on import. Can I continue with what has been imported so far?
I recently imported the osm planet file using osm2pgsql. The process crashed (hung my whole box) when creating the geometry indices and other indices on the tables. Scouring through the source code, ...
- 77.1k
0
votes
3
answers
1k
views
What is gid in OpenStreetMap data model?
I'm using an old code written by an ex-fellow and I wonder what is GID in OSM? The gid is basically used everywhere. The project uses PostGIS and PgRouting. Any pointers to that?
I know this is a ...
CommunityBot
- 1
2
votes
1
answer
607
views
ST_AsLatLonText returns wrong data
I want to list all cities in lubelskie vovoidenship, which is relation 130919.
I also want to get latLong data for each city. To perform this I do:
SELECT
name, ST_AsLatLonText(way), place
...
- 12.9k
1
vote
0
answers
444
views
Traversing all possible road routes
I have created a topology from OSM data and would like to simulate a car driving every possible route along the map. The purpose is to "survey" the osm data as if in a car. My ultimate objective is to ...
- 861
1
vote
1
answer
6k
views
Publishing OSM data in GeoServer that has been imported into PostGIS
I'm trying to publish data on GeoServer.
I'm using Postgres/PostGIS and I've used osm2pgsql to load the data into the database.
I've configured a store correctly (I can see the tables from the ...
- 123
2
votes
2
answers
2k
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 ~/Nominatim/...
- 347
5
votes
1
answer
389
views
PostGIS Optimization - Group spatially close entities physically on disk
I'm working on my first PostGIS database and was hoping to find some performance gains for live rendering.
I'm rendering a map directly from a PostGIS (9.1, 2.0) db that contains an import of OSM ...
- 163
4
votes
1
answer
3k
views
osm2pgsql: Import data in custom projection
I have osm-file and I want to import it to the postgresql via osm2pgsql with custom projection EPSG:20022. I look to the help and found out any keys like -E EPSG: but when I try to do with it I get ...
- 413
2
votes
0
answers
402
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 (...
CommunityBot
- 1
3
votes
1
answer
498
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 ...
- 1,652
3
votes
1
answer
1k
views
GeoWebCache seed task dies immediately after being submitted
The data comes from Geofabrik's Brazil slice: http://download.geofabrik.de/south-america/brazil.html
Imported into a PostGIS DB with osm2pgsql. GeoServer is 2.4.0, running on latest Tomcat 7.0.x, on ...
- 5,148
2
votes
1
answer
2k
views
Problem with loading OSM planet into PostgreSQL
I try download OSM planet into PostgreSQL database.
I do all steps from instruction http://switch2osm.org/serving-tiles/manually-building-a-tile-server-12-04/
I also modify string "kernel.shmmax"
...
- 41
5
votes
1
answer
235
views
Good projection for covering most of the world
I'm writing an application for building navigation routes thru the city streets, and not quite sure what projection would be best.
I tried EPSG:3587, however, the tools I'm using - GeoTools and ...
CommunityBot
- 1
4
votes
0
answers
2k
views
Smoothing Lines in PostGIS
I want to smooth Lines in postgis, to be more specific, I want to smooth road data from OpenStreetMap.
Basicly I thought of something like this scenario.
This would be a possible road segment.
I ...
- 76
3
votes
3
answers
3k
views
Best way to assign points to nearest roads in postgis?
I'm trying to implement a simplified type of dasymetric mapping for census data. I've downloaded the Census's American Community Survey individual-level data and randomly assigned every household to a ...
CommunityBot
- 1
0
votes
1
answer
465
views
Full instruction for download OSM data in Ubuntu 12.04 LTC
Is there instruction for:
1) install software
2) download OSM data in Postgis database
3) set styles
4) generate tiles
5) initilaze MapProxy (all in OS Linux)
6) View map (generated tiles) ...
- 665
3
votes
1
answer
776
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 ...
CommunityBot
- 1
1
vote
1
answer
5k
views
Mapnik Initialization does not work
I create geodatabase "training"
sudo su
su postgres
createdb -E UTF8 template_postgis2
createlang -d template_postgis2 plpgsql
psql -d postgres -c "UPDATE pg_database SET datistemplate='true' WHERE ...
- 665
1
vote
1
answer
1k
views
Is there any instructions to download OSM in postgres database?
Is there any instructions to download OSM in postgres database? I use geosuite (geoserver, postgres, postgis). I'd like to download USA and Russia (1-12 levels). I also want to download sld styles. (...
- 1,263
3
votes
1
answer
1k
views
Find nearest neighbours faster in PostGIS
I currently have a query that calculates the number of useful amenities within a certain radius of each town, using OSM data:
create table places as
select town.name, place, town.way, (
select ...
- 5,720
1
vote
0
answers
134
views
Query OSM ids by name in PostGIS
I installed PostGIS on a server and now I want to query the OSM ids referring to a name, in order to get a list of all geometries according to this name.
Is there an efficient way to query this ids ...
- 16.4k
6
votes
2
answers
2k
views
How are housenumbers and streets linked in a OSM based PostGIS DB?
I'm trying to understand how OSM is linking housenumbers and streets with each other. I downloaded an osm file for germany and imported it into a PostGIS DB.
To understand how the linking is working I ...
- 21
2
votes
1
answer
420
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 ...
- 700
1
vote
2
answers
171
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 ...
- 8,563
0
votes
2
answers
174
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,695
9
votes
2
answers
14k
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 ...
- 3,575
3
votes
1
answer
683
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 ...
- 455