0
votes
0answers
22 views

OpenStreetMap Road and Polygon Data as 1x1 Degree Shapefiles

I am working on a global project for which I want to use OSM data as a model input. I am looking for advice on the best way to produce 1x1 degree WGS84 shapefiles from either regional extracts or the ...
2
votes
2answers
40 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 ...
1
vote
1answer
29 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, ...
2
votes
2answers
41 views

How to obtain timestamp and user id from .osm file in PostGIS enabled Postgres database

At present, osm2pgsql seems to ignore the timestamp and user id of the elements, a serious drawback for some applications. According to a bug report this is not solved by the addition of the ...
0
votes
0answers
16 views

Transforming multiple LineStrings to shape for ST_Contains

I want to find cities, villages etc inside each region of Poland. For most of them querying something like this is enough: ... AND ST_Contains((SELECT way FROM planet_osm_polygon WHERE osm_id = ...
1
vote
1answer
29 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 ...
0
votes
0answers
24 views

Postgis and osm2pgsql: find all cities that belong to selected state [duplicate]

I'm pretty new to postgis, so I don't quite understand it's mechanisms yet. My task is to build database with relations: +---------+ +------------+ +----------+ | country | | adm_unit ...
0
votes
0answers
10 views

Prepare OSM file for PGROUTING use [duplicate]

Well I am new in the GIS World :p well I have a webGIS to realise and I want use OpenStreetMap. well the region I need wasn't vectorised so I modified it with JOSM ( Added Roads and buildings) and ...
0
votes
0answers
13 views

OSM DataImported in to Postgres: What is the significance of “_gen0” and “_gen1” suffixed tables

Imported .OSM file to postgres/postgis (IMPOSM). Along with the table "osm_new_motorways" I see two more tables "osm_new_motorways_gen0" and "osm_new_motorways_gen1". Same is there for few other ...
1
vote
0answers
64 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 ...
1
vote
1answer
86 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 ...
0
votes
1answer
87 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 ...
1
vote
0answers
96 views

identify subgraphs within planet_osm_line table

I want to identify subgraphs within the planet_osm_line table of the osm2pgsql-schema. those subgraphs are classified by certain tags i want to check. My first attempt was to do this recursively with ...
1
vote
1answer
138 views

How to draw bus routes on OpenStreetMap with mapnik

I have successfully set up Postgres with PostGIS and MapNik to serve map tiles. The database is populated with data from OpenStreetMap project. I can see that bus routes are in the data-set, but I ...
5
votes
1answer
116 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 ...
0
votes
3answers
72 views

osm2po - 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 ...
3
votes
1answer
172 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 ...
2
votes
1answer
508 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" ...
2
votes
1answer
141 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
votes
1answer
121 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 ...
3
votes
3answers
190 views

osm2pgsql --hstore

I'm working with postgreSQL 8.$ and PostGIS and I need to import osm file to database. I tried it with utility osm2pgsql, but I have problem with hstore extension. Does anyone know how to solve this ...
1
vote
0answers
104 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 ...
3
votes
3answers
356 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 ...
0
votes
1answer
96 views

How to get the linestring of a way in postgis with pg_snapshot schema

I have loaded some data from openstreetmap using osmosis and its pg_snapshot schema. This results in a table wayswhich contains a list of nodesreferenced by their ids: select w.nodes from ways as w ...
0
votes
1answer
151 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) ...
1
vote
1answer
462 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 ...
2
votes
0answers
84 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: ...
3
votes
2answers
1k views

Where download sld styles for OpenStreetMap for GeoServer?

I display OpenStreetMap with some sld styles. This map is not the same OSM. I want that this map is equal OSM map. I use geoserver 2.3.5 Does anyone display OSM through MapServer, ArcGisServer ...
1
vote
1answer
234 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. ...
4
votes
1answer
171 views

Maritime route prediction avoiding land masses

I am working on a project where the following functions have to be implemented: Predicting the locations of the ships (in maritime environment) at a future time. (Can be done with Kalman filter, IMM ...
0
votes
3answers
138 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 ...
1
vote
1answer
142 views

Why does Driving distance of pgRouting return disconnected results?

I am trying the driving distance function of pgRouting 2.0 beta, with an extract of OSM data. The problem i have is illustrated on the following image : On this picture i try to get all the ways ...
1
vote
2answers
119 views

Cutting OSM roads in sections using PostGis

I'm a newby in postgis. I define a section by a part of a road that has no intersection. See image bellow: I'd like to extract all sections from all the roads of my postgis database. This gis ...
1
vote
1answer
183 views

Split all OSM roads within boundingbox in 20m segments and save to new table

I have a PostGIS Database with all streets from osm within a given boundingbox. Now I want to split all roads from my table planet_osm_roads into segments of max 20 meters length and save those ...
0
votes
1answer
116 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 ...
0
votes
0answers
78 views

Query Multipolygon from PostGIS database

I my OSM PostGIS DB there are multiple polygons in the planet_osm_polygon table with the same osm_id, my idea is that this must be the parts of a Multipolygon. Now I want to query the Multipolygon ...
3
votes
3answers
223 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 ...
1
vote
1answer
241 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 ...
1
vote
0answers
49 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 ...
2
votes
1answer
241 views

Help building SQL query to get a list of streets of a city

From two layers in PostGIS (osm_places and osm_roads), I would need to have the roads belonging to a certain city. It would be fair enough to get the street names of all streets in a radius of X ...
3
votes
1answer
347 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
87 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
145 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 ...
3
votes
2answers
898 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
3answers
631 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 ...
2
votes
2answers
742 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
75 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
134 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
427 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
479 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 ...