Thanks, I hadn't seen that. Whoops!
________________________________ From: Karl Newman <[EMAIL PROTECTED]> To: S Knox <[EMAIL PROTECTED]> Cc: [email protected] Sent: Saturday, 6 December, 2008 0:37:10 Subject: Re: [OSM-dev] Osmosis import to postgis - speed On Fri, Dec 5, 2008 at 4:11 PM, S Knox <[EMAIL PROTECTED]> wrote: I'm using Osmosis to import a recent UK extract of the planet file into a database, and I used the simple schema here: http://svn.openstreetmap.org/applications/utils/osmosis/script/pgsql_simple_schema_0.6.sql This took around 1 hour. I then found that this schema didn't give way geometries so re-ran the query, adding a geometry column 'linestring' so that way objects would be created. This import has taken 24 hours so far and isn't yet finished. Is this normal or has something gone wrong? It would be useful to have some sort of counter to find out how far into the process osmosis is - for example roughly what line of the XML it is on, as a percentage of the whole file. Try this: http://wiki.openstreetmap.org/wiki/Osmosis/DetailedUsage#--log-progress_.28--lp.29 Osmosis works on streams, so it can't know what percentage of the total is complete. You can use an external bzip to decompress the file to stdout and then pipe it to Osmosis. Type a hyphen as the filename for Osmosis to indicate it should read from stdin. Karl
_______________________________________________ dev mailing list [email protected] http://lists.openstreetmap.org/listinfo/dev
