New answers tagged osm2pgsql
5
Replacing st_length with st_transform(way,4326)::geography solves the geodetic distance problem - thanks unicoletti!.
Old Beechy Rail Trail | 47.2km
Great Southern Rail Trail | 53.5km
Ballarat-Skipton Rail Trail | 57.2km
High Country Rail Trail | 63.7km
East Gippsland Rail Trail | 97.6km
...
5
You are not using geodesic functions to calculate the length, which means that for a point there is an error factor of:
cos( LATITUDE * pi() / 180 )
If you then multiply the calculated lenght by the error factor you should obtain a value pretty close to the actual trail length. For instance the Old Beechy Rail Trail is close to Melbourne, which has a ...
0
Regarding to steps to get the OSM data into your database:
I would not use shapefiles to process your data. It is easier to import the OSM data (*.xml) directly into your database.
Download the raw OSM files from Geofabrik for your desired region.
Setup Osmosis on your system.
Filter with Osmosis the features you are interested in.
Write the extracted ...
2
I am not aware that you have a converter from Mapnik to Mapserver mapfile styles.
You will really need a lot of tools for what you expect.
OSM world has his own set of tools because of their DB complexity and storage (XML)
I don't recommend to use Shapefile for rendering OSM data.
If you need lot of custom styles, the shp don't give you all the attributes ...
Top 50 recent answers are included
