[OSM-talk] Re: [OSM-dev] Another vote for a monthly database image....

Joerg Ostertag openstreetmap at ostertag.name
Tue Apr 11 07:06:47 BST 2006


On Monday 10 April 2006 14:33, Dan Karran wrote:
> I've knocked up a quick and dirty PHP script to read in nodes and
> segments (though none of the tags that go with them) from the
> planet.osm file and insert them into nodes and segments tables in a
> MySQL database using the OSM schema from
> http://trac.openstreetmap.org/browser/sql/mysql-schema.sql
>
> The code is at:
> http://www.dankarran.com/openstreetmap/planet_to_mysql.phps
>
> I didn't need the tags for what I was importing the data for, but feel
> free to add in that functionality if you need them  :)

With geoinfo.pl supplied in the gpsdrive source you can mirror planet.osm.gz 
import into the mysql Table with the command:
  geoinfo.pl --osm

Current gpsdrive Versions can be found at http://www.ostertag.name/gpsdrive/

-

Joerg




More information about the talk mailing list