On Jun 19, 2009, at 11:24 PM, Andrew Ayre wrote: > Dane Springmeyer wrote: >> Andy, >> On Jun 16, 2009, at 1:07 PM, Andrew Ayre wrote: >>> Hi Dane, >>> >>> Yep, but I'm using SQLite/Spatialite. >> Ah, well you can use more than one datasource for different layers >> in your map. But maybe you're saying you want to only use file >> based datasources, either sqlite or raster files? >>> I haven't managed to find a simple program like osm2pgsql to get >>> data from OSM XML to Spatialite. >> Ya, I've seen postings on the OSM dev list about scripts, but I've >> not tried them. Generally I use the tool Artem wrote called >> 'pgsql2sqlite' (http://trac.mapnik.org/browser/trunk/utils/pgsql2sqlite >> ) > > Can't seem to get it to compile.
How are you trying to compile it? If you do: python scons/scons.py -h You'll see the at the bottom, the instructions for how to build it (which is not enabled by default since it is experimental) which are: python scons/scons.py PGSQL2SQLITE=True > I tried literally converting the contents of a PostgreSQL database > into a SQLite database verbatim and I can't get Mapnik to accept it, > so there must be a step I am missing. It complains about syntax > errors when there are colons in the column names, about "limit" and > missing column "the_geom", even though I set the geometry column to > "way" in the XML file. > You can ignore the "limit" errors. I'm not sure why you'd get a missing column geometry column error if you are properly setting sit as "way" Dane _______________________________________________ Mapnik-users mailing list [email protected] https://lists.berlios.de/mailman/listinfo/mapnik-users
