Thanks Dane. I'll take a look at pgsql2splite. I won't have a PostGIS database available at all, so hopefully I can get it to input a SQL file.
Andy 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) > >> Seems I need multiple tools, 20Mb download (FW Tools), etc. > > Migrating data into sqlite with GDAL/OGR should work well. Posting a > wiki page on what you've done so far would be interesting for helping > other users. > > >> I also want to use the standard OSM styling for the maps - not sure if >> the SQLite plugin for Mapnik would use it. >> > > > Sure, you can use the default OSM provided xml styles, you'd just need > to tweak the the SQL statements to be compliant with SQLite. I've done > this in the past but not too recently. > > Dane -- Andy PGP Key ID: 0xDC1B5864 _______________________________________________ Mapnik-users mailing list [email protected] https://lists.berlios.de/mailman/listinfo/mapnik-users
