[GIS] Geoserver Routing with OSM data and PostGIS

geoserveropenstreetmappostgisrouting

Does Geoserver have a routing functionality for the OSM data in PostGIS?

Best Answer

http://osm2postgis.sourceforge.net/

has all the components for routing with Geoserver (is in development and in Alpha)

Related Solutions

[GIS] How to convert OSM Data to PostgreSQL for Routing Purposes

Routing in Postgres / PostGIS is handled by the pgRouting library from http://pgrouting.org

It looks like a script has already been written to handle osm straight into pgRouting at http://www.pgrouting.org/docs/tools/osm2pgrouting.html

You will need to install pgRouting within Postgres before running the osm2pgrouting script.

[GIS] OSM To Postgis & WGS84 Newbie confusion

OpenStreetMap stores data in WGS84 coordinates. You can check this by downloading the XML data for any OSM node:

 $ curl "http://www.openstreetmap.org/api/0.6/node/327031143"
 <?xml version="1.0" encoding="UTF-8"?>
 <osm version="0.6" generator="OpenStreetMap server">
   <node id="327031143" lat="44.4795174" lon="26.0865814" [..]>
[..]

However, the tool that imports the OSM data to postgresql (osm2pgsql) defaults to re-projecting node coordinates:

$ ./osm2pgsql --help

This will import the data from the OSM file(s) into a PostgreSQL database
suitable for use by the Mapnik renderer

Options:
[..]
   -l|--latlong     Store data in degrees of latitude & longitude.
   -m|--merc        Store data in proper spherical mercator (default)
   -M|--oldmerc     Store data in the legacy OSM mercator format
   -E|--proj num    Use projection EPSG:num
   -u|--utf8-sanitize   Repair bad UTF8 input data (present in planet

If you use the -l option, the postgresql database will contain WGS84 coordinates (EPSG 4326).

Best Answer

Related Solutions

[GIS] How to convert OSM Data to PostgreSQL for Routing Purposes

[GIS] OSM To Postgis & WGS84 Newbie confusion

Related Question