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 ;) Regards walter ----- [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. _______________________________________________ dev mailing list [email protected] https://lists.openstreetmap.org/listinfo/dev

