Hi, It is nice that Paul is experimenting with GDAL. My own experience it that GDAL is pretty good if one wants to import OSM data with a weak Windows computer with slow CPU and little memory (2 GB). My timings with the same dataset (OSM data of Finland from Geofabrik): - osm2pgsql (2010 Windows build, supports only osm.bz2): 3 hours - osm2pgsql (recent Windows build, supports also OSM.pbf): 2 hours - GDAL from OSM.pbf to PostGIS: 28 minutes - GDAL from OSM.pbf to Spatialite: 9 minutes
Probably osm2pgsql is much faster with Linux computers with lots of RAM and GDAL is not an alternative if one wants to do updates with diff files but anyway, look at the numbers and consider if the GDAL option feels interesting. Here is a good GDAL command to use. Extra config options and a biggish -gt value are important and only GDAL-dev version has OSM support. ogr2ogr -f SQLite -dsco spatialite=yes finland.sqlite finland.osm.pbf --config SQLITE_SYNCHRONOUS OFF --config OSM_COMPRESS_NODES YES -progress -gt 20000 -Jukka Rahkonen- ________________________________________ Lähettäjä: Ákos Maróy [a...@maroy.hu] Lähetetty: 12. marraskuuta 2012 21:17 Vastaanottaja: geoserver-users@lists.sourceforge.net Aihe: Re: [Geoserver-users] OSM-style SLD files for GeoServer On 12/11/12 20:11, Justin Deoliveira wrote: > Interesting, I was able to get the FlorentDotMe styles to work with > the default output of osm2pgsql without problem. these also worked for me. well, I 'fixed' them, if you see a recent commit in these files, those are the results of my patches to what was there earlier. and yes, with a stock PostGIS import of OSM data worked for me quite well. ------------------------------------------------------------------------------ Monitor your physical, virtual and cloud infrastructure from a single web console. Get in-depth insight into apps, servers, databases, vmware, SAP, cloud infrastructure, etc. Download 30-day Free Trial. Pricing starts from $795 for 25 servers or applications! http://p.sf.net/sfu/zoho_dev2dev_nov _______________________________________________ Geoserver-users mailing list Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users ------------------------------------------------------------------------------ Monitor your physical, virtual and cloud infrastructure from a single web console. Get in-depth insight into apps, servers, databases, vmware, SAP, cloud infrastructure, etc. Download 30-day Free Trial. Pricing starts from $795 for 25 servers or applications! http://p.sf.net/sfu/zoho_dev2dev_nov _______________________________________________ Geoserver-users mailing list Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users