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. I don't have a /usr/local/include/boost-1_38. Any ideas what package I need to install? Is there a list of dependencies somewhere for pgsql2sqlite? 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. Andy -- Andy PGP Key ID: 0xDC1B5864 _______________________________________________ Mapnik-users mailing list [email protected] https://lists.berlios.de/mailman/listinfo/mapnik-users
