[gdal-dev] Basic OpenStreetMap driver with ReadOSM?

[Jeff McKenna]

On 12-07-07 8:14 AM, Rahkonen Jukka wrote:
> Osm2pgsql outputs only to PostGIS and even PostGIS is super fine I consider that the threshold in installing and managing it is too high for many users. In addition, there has been only two Windows builds of osm2pgsql available ever and the latter one is more than two years old. ImpOsm is impossible to make work on Windows due to something called Tokyo Cabinet. Osm2pgsql fails every time for me with my lean Linux box with only 700 MB of memory and I must do local import with my home computer and use PostGIS dump/restore after that.  And on my home Windows laptop running import with osm2pgsql (with that 2 years old version) takes something like 3 hours while Sandro had a try with the same Finnish OSM excerpt and reported that he could parse it with ReadOSM in five minutes.  If something is possibly 30 times faster than something else I usually get interested.
> If you count together the number of users who are on Windows OR do not want to learn to be DB admins OR are willing to run cheap and weak virtual servers, then I would say that there might be enough interest for such a driver.
> 
> I think that what Osm2pgsql is doing is enough for the majority of users. That is, create point, line and polygon layers from features which have at least on tag in the configuration file. Parsing relations must be pretty difficult, at least with polygons and therefore I was thinking that by using the ReadOSM library the responsibility about doing it right could be left to ReadOSM developer. Advanced users could still use the advanced tools.
> 
> -Jukka Rahkonen-

Jukka,

Your assessment of the situation with importing OSM on Windows is
bang-on as usual.  In fact I have been hitting this same wall for a
while, so Mike Smith and I last week worked on a script to change the
osm2pgsql-imported tables, to the same schema of Imposm (so generalized
features, specific layers, and therefore faster drawing in MapServer,
Mapnik, or whatever you use).  Give it a try:
https://github.com/jmckenna/basemaps/blob/master/contrib/osm2pgsql-to-imposm-schema.sql

I'll be using this on Windows, until something better comes along.

-jeff


-- 
Jeff McKenna
MapServer Consulting and Training Services
http://www.gatewaygeomatics.com/