[OSM-dev] osm2pgsql: create flatfile from database?

Walter Nordmann pille3 at hotmail.com
Sat Oct 26 10:25:53 UTC 2013

Frederik Ramm wrote
> I don't know of any existing tool. I'd just write a quick script that
> does "select id,lat,lon from planet_osm_nodes" and outputs lines of the
> form 
> <node id="x" lat="y" lon="z" />
> , and then feed that to osm2pgsql
> (called with --flat-nodes and the name of an otherwise unused, throwaway
> database). When you make the script, remember you need to divide lat/lon
> by 1E+07 or so.

great idea, will do the same with a well formed select like "<node
id="||id|| ... " and writing to file.

after the dummy-Import move the flat-file to the working directory, change
the update-script (adding  --flat-nodes ...), truncate planet_osm_lines and
cross my fingers ;)


[url=http://osm.wno-edv-service.de/residentials] Missing Residentials Map 1.17[/url] [url=http://osm.wno-edv-service.de/plz] Postcode Map 2.0.2[/url]
View this message in context: http://gis.19327.n5.nabble.com/osm2pgsql-create-flatfile-from-database-tp5782958p5782963.html
Sent from the Developer Discussion mailing list archive at Nabble.com.

More information about the dev mailing list