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/




_______________________________________________
gdal-dev mailing list
gdal-dev@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/gdal-dev

Reply via email to