Hi,
I will post something, but now I'm not at home. So maybe today night.
But Dane wrote me about sqlite support in mapnik, so you can try that:
----------------------------------------------------
Are you aware we have a postgres -> sqlite converter in mapnik?
https://trac.mapnik.org/browser/trunk/utils/pgsql2sqlite
It requires the postgis and sqlite plugins:
https://trac.mapnik.org/browser/trunk/plugins/input
Just build mapnik with:
$ python scons/scons.py INPUT_PLUGINS=all PGSQL2SQLITE=True
I have been hand converting the XML, a scripted approach would be cool.
Dane
-----------------------------------------------------
<https://trac.mapnik.org/browser/trunk/utils/pgsql2sqlite>I don't thing
that it is usable for me, because I do not like to convert something
many times to get the result. But I do not know about it (I played with
it half year ago, so maybe it did not exists yet).
Tomas
Christoph Eckert napsal(a):
Hi,
There is no reason to be sqlite slow. How much are you are using
transactions on your local db? What are you using for import? I'm
importing Czech republic (50Mb bziped) in one or two minutes. So for
5.4GB it takes 108 minutes (two hours). But I'm importig to modified osm
schema (something like mapnik schema in postgress). It is because of
query speed.
sounds cool. Is the Script that does the conversion from osm.xml into sqlite
available somewhere?
Thanks & best regards,
ce
_______________________________________________
dev mailing list
[email protected]
http://lists.openstreetmap.org/listinfo/dev
_______________________________________________
dev mailing list
[email protected]
http://lists.openstreetmap.org/listinfo/dev
