Re: [gdal-dev] OSM driver with z_order values

2014-11-10 Thread Jukka Rahkonen
Even Rouault spatialys.com> writes: > Instead of outputing to finland.sqlite, try /vsimem/finland.sqlite. Of course > you will have no file at the end, but it would be a good simulation of the > potential performance gains (you should add to that number the time to copy a > file from memory t

Re: [gdal-dev] OSM driver with z_order values

2014-11-10 Thread Even Rouault
Le lundi 10 novembre 2014 16:35:04, Jukka Rahkonen a écrit : > Even Rouault spatialys.com> writes: > > Jeff, > > > > I've implemented the above idea in latest trunk. I've translated the > > osm2pgsql > > > rules (*) for the lines layer. Let me know if that works OK. The > > implementation of th

Re: [gdal-dev] OSM driver with z_order values

2014-11-10 Thread Jeff McKenna
On 2014-11-08 4:00 PM, Even Rouault wrote: Le vendredi 07 novembre 2014 14:48:57, Jeff McKenna a écrit : On 2014-11-07 4:49 AM, Even Rouault wrote: The ideal would to find some syntax to do this in osmconf.ini. Actually, Jukka's mention of sqlite makes me think that the syntax could be SQL eval

Re: [gdal-dev] OSM driver with z_order values

2014-11-10 Thread Jukka Rahkonen
Even Rouault spatialys.com> writes: > Jeff, > > I've implemented the above idea in latest trunk. I've translated the osm2pgsql > rules (*) for the lines layer. Let me know if that works OK. The > implementation of the mechanism is rather generic, so it could potentially be > used to do many

Re: [gdal-dev] OSM driver with z_order values

2014-11-10 Thread Jeff McKenna
On 2014-11-10 11:21 AM, Jeff McKenna wrote: On 2014-11-08 4:00 PM, Even Rouault wrote: Le vendredi 07 novembre 2014 14:48:57, Jeff McKenna a écrit : On 2014-11-07 4:49 AM, Even Rouault wrote: The ideal would to find some syntax to do this in osmconf.ini. Actually, Jukka's mention of sqlite mak

Re: [gdal-dev] OSM driver with z_order values

2014-11-08 Thread Even Rouault
Le vendredi 07 novembre 2014 14:48:57, Jeff McKenna a écrit : > On 2014-11-07 4:49 AM, Even Rouault wrote: > > The ideal would to find some syntax to do this in osmconf.ini. Actually, > > Jukka's mention of sqlite makes me think that the syntax could be SQL > > evaluated by SQLite. > > Something li

Re: [gdal-dev] OSM driver with z_order values

2014-11-07 Thread Jeff McKenna
On 2014-11-07 4:49 AM, Even Rouault wrote: The ideal would to find some syntax to do this in osmconf.ini. Actually, Jukka's mention of sqlite makes me think that the syntax could be SQL evaluated by SQLite. Something like : computed_fields = z_order z_order_type = Integer z_order_sql = "SELECT

Re: [gdal-dev] OSM driver with z_order values

2014-11-07 Thread Even Rouault
Jeff, > > I've successfully used the OSM driver[1] to convert from the OSM pbf > binary format into another (in my case Postgres/PostGIS, and testing > with Japan dataset). The time to do this is much much faster than other > tools Mostly due to the optimized custom node indexing and the local

Re: [gdal-dev] OSM driver with z_order values

2014-11-06 Thread Jeff McKenna
On 2014-11-06 6:48 PM, Jukka Rahkonen wrote: Hi Jeff, Imposm and osm2pgsql utilities are more or less made to one purpose that is to generate database for rendering with more or less standard styles and therefore they can have fixes rules for creating z_orders. I am not sure if the GDAL OSM dr

Re: [gdal-dev] OSM driver with z_order values

2014-11-06 Thread Jukka Rahkonen
Jeff McKenna gatewaygeomatics.com> writes: > > Hi all, > > I've successfully used the OSM driver[1] to convert from the OSM pbf > binary format into another (in my case Postgres/PostGIS, and testing > with Japan dataset). The time to do this is much much faster than other > tools such as os

[gdal-dev] OSM driver with z_order values

2014-11-06 Thread Jeff McKenna
Hi all, I've successfully used the OSM driver[1] to convert from the OSM pbf binary format into another (in my case Postgres/PostGIS, and testing with Japan dataset). The time to do this is much much faster than other tools such as osm2pgsql (once I learned the "PG_USE_COPY YES" parameter th