[OSM-dev] CSV tool for 0.5; target: plain SQL

Nick Burch openstreetmap at gagravarr.org
Tue Oct 16 11:29:40 BST 2007


On Tue, 16 Oct 2007, Stefan de Konink wrote:
> But it looks not yet compatible to Api 0.5. I would like to import the 
> planet.osm in another database that only supports 'plain SQL'. Without 
> fancy PostGIS or MySQL syntax.

There's /applications/utils/planet.osm/perl/planetosm-to-db.pl - it should 
be fairly easy to add in support for your database to that (already does 
postgresql and mysql), or even just tweak it to output the sql rather than 
running it against the dbi connection

Nick




More information about the dev mailing list