Re: OSM Plugin

> 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