As Jukka says I'm experimenting with the new OSM driver of GDAL.
I noticed it uses an ini-file to map OSM tags to property names.
http://www.gdal.org/ogr/drv_osm.html

It seems the properties the SDL is expecting are not all in the ini file.
I will investigate further and let you know my progress (will take a day or
two due to other tasks).

Thanks

Paul


2012/11/12 Rahkonen Jukka <[email protected]>

> 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 [[email protected]]
> Lähetetty: 12. marraskuuta 2012 21:17
> Vastaanottaja: [email protected]
> 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
> [email protected]
> 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
> [email protected]
> 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
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-users

Reply via email to