[OSM-dev] Importing planet file with osmosis into PostgreSQL

2009-12-13 Thread Frank Bielig
Hallo, I want to setup up an own OSM server as a mirror. Therefore I downloaded the planet file (2009/12/02) and used osmosis for import with following command line: bzcat '/data/osm/all/20091202/planet-latest.osm.bz2' | osmosis --read-xml-0.6 file='-' --log-progress --write-apidb host=

Re: [OSM-dev] Importing planet file with osmosis into PostgreSQL

2009-12-13 Thread Frederik Ramm
Hi, Frank Bielig wrote: > I want to setup up an own OSM server as a mirror. Therefore I downloaded > the planet file (2009/12/02) and used osmosis for import with following > command line: The planet files do not have referential integrity. Because the ways are dumped long after the nodes, if

Re: [OSM-dev] Importing planet file with osmosis into PostgreSQL

2009-12-13 Thread Lennard
Frederik Ramm wrote: > The planet files do not have referential integrity. Because the ways are > dumped long after the nodes, if someone creates a new way plus new nodes > some time during the planet dump creation, the new way will be in the > dump but the new nodes will not. I thought that w

Re: [OSM-dev] Importing planet file with osmosis into PostgreSQL

2009-12-13 Thread Shaun McDonald
On 13 Dec 2009, at 10:47, Lennard wrote: > Frederik Ramm wrote: > >> The planet files do not have referential integrity. Because the ways are >> dumped long after the nodes, if someone creates a new way plus new nodes >> some time during the planet dump creation, the new way will be in the >>

Re: [OSM-dev] Importing planet file with osmosis into PostgreSQL

2009-12-13 Thread Frederik Ramm
Hi, Lennard wrote: > I thought that was fixed, and the dump now runs in a transaction? No; many seem to think it is fixed but simple inspection of the current planet file tells you that the highest node id therein is 583444559 (added 2009-12-09T01:19:27Z), whereas the highest *referenced* node

Re: [OSM-dev] Importing planet file with osmosis into PostgreSQL

2009-12-13 Thread Frank Bielig
Many thanks for fast and valuable responses. One more open question I have. Currently I need about four days for importing the whole planet file. Is that a normal computing time? The bottleneck seems to be the database (PostgreSQL). Are there any hints for the database configuration? For conve

Re: [OSM-dev] Importing planet file with osmosis into PostgreSQL

2009-12-13 Thread Shaun McDonald
There are some additional hints on the following wiki page: http://wiki.openstreetmap.org/wiki/Mapnik#Loading_Data I'm sure other people on the list will be able to add more than me on tuning postgres. You should expect it to take a day or two to load if the disks are slow. There are a few discu

Re: [OSM-dev] Importing planet file with osmosis into PostgreSQL

2009-12-13 Thread Lars Francke
> Currently I need about four days for importing the whole planet file. Is > that a normal computing time? The bottleneck seems to be the database > (PostgreSQL). Are there any hints for the database configuration? For > conversion I use  a quadcore machine with 8GB RAM. Data files are > located on

Re: [OSM-dev] Importing planet file with osmosis into PostgreSQL

2009-12-13 Thread Jon Burgess
On Sun, 2009-12-13 at 12:41 +, Shaun McDonald wrote: > There are some additional hints on the following wiki page: > http://wiki.openstreetmap.org/wiki/Mapnik#Loading_Data > > I'm sure other people on the list will be able to add more than me on tuning > postgres. You should expect it to take

[OSM-dev] Trac database locked?

2009-12-13 Thread Maarten Deen
I wanted to submit a ticket to trac, but at submitting I received this error: Python Traceback Traceback (most recent call last): File "/var/lib/python-support/python2.5/trac/web/main.py", line 406, in dispatch_request dispatcher.dispatch(req) File "/var/lib/python-support/python2.5/tr

Re: [OSM-dev] Trac database locked?

2009-12-13 Thread Tom Hughes
On 13/12/09 15:47, Maarten Deen wrote: > Any reason why the trac database is locked? Yes, somebody else is accessing it. Try again and it will almost certainly work. We should be getting the wiki off that machine soon which should eliminate these problems. Tom -- Tom Hughes (t...@compton.nu

Re: [OSM-dev] Trac database locked?

2009-12-13 Thread Peter Körner
> We should be getting the wiki off that machine soon which should > eliminate these problems. Are you using sqlite or a postgres db? We switched to postgres to solve exactly this issue. Peter ___ dev mailing list dev@openstreetmap.org http://lists.

Re: [OSM-dev] Trac database locked?

2009-12-13 Thread Tom Hughes
On 13/12/09 17:00, Peter Körner wrote: >> We should be getting the wiki off that machine soon which should >> eliminate these problems. > > Are you using sqlite or a postgres db? We switched to postgres to solve > exactly this issue. It's Berkeley DB I think, isn't it? I didn't install it, so I d

Re: [OSM-dev] Trac database locked?

2009-12-13 Thread Tom Hughes
On 13/12/09 17:21, Tom Hughes wrote: > On 13/12/09 17:00, Peter Körner wrote: > >> Are you using sqlite or a postgres db? We switched to postgres to solve >> exactly this issue. > > It's Berkeley DB I think, isn't it? I didn't install it, so I don't know > for sure but it's likely to be whatever t

[OSM-dev] Open changeset(s) with potlatch

2009-12-13 Thread hy-soft
Hi, I just noticed that if you open Potlatch and skip to another tab above [view|edit|history|export] a new changeset is opened each time - even if you have saved your editings. Maybe it's not important (and I actually don't care) but people might find it annoying to have lots of changesets still

[OSM-dev] Delete a node

2009-12-13 Thread hy-soft
the wiki says: http://wiki.openstreetmap.org/wiki/API_v0.6 Delete: DELETE /api/0.6/[node|way|relation]/#id Expects a valid XML representation of the element to be deleted. --- What exactly does the term 'valid XML representation of the element' mean? Is it the same what I would get when download

Re: [OSM-dev] Delete a node

2009-12-13 Thread jamesmikedup...@googlemail.com
yes. I think, at least the node data like id and version. mike On Sun, Dec 13, 2009 at 6:54 PM, hy-soft wrote: > the wiki says: > http://wiki.openstreetmap.org/wiki/API_v0.6 > > Delete: DELETE /api/0.6/[node|way|relation]/#id > > Expects a valid XML representation of the element to be deleted. >

Re: [OSM-dev] Delete a node

2009-12-13 Thread Ævar Arnfjörð Bjarmason
On Sun, Dec 13, 2009 at 17:54, hy-soft wrote: > the wiki says: > http://wiki.openstreetmap.org/wiki/API_v0.6 > > Delete: DELETE /api/0.6/[node|way|relation]/#id > > Expects a valid XML representation of the element to be deleted. > --- > What exactly does the term 'valid XML representation of the

Re: [OSM-dev] Delete a node

2009-12-13 Thread Ian Dees
On Sun, Dec 13, 2009 at 1:16 PM, Ævar Arnfjörð Bjarmason wrote: > On Sun, Dec 13, 2009 at 17:54, hy-soft wrote: > > the wiki says: > > http://wiki.openstreetmap.org/wiki/API_v0.6 > > > > Delete: DELETE /api/0.6/[node|way|relation]/#id > > > > Expects a valid XML representation of the element to b

Re: [OSM-dev] Delete a node

2009-12-13 Thread Anthony
On Sun, Dec 13, 2009 at 2:23 PM, Ian Dees wrote: > On Sun, Dec 13, 2009 at 1:16 PM, Ævar Arnfjörð Bjarmason > wrote: > >> On Sun, Dec 13, 2009 at 17:54, hy-soft wrote: >> > the wiki says: >> > http://wiki.openstreetmap.org/wiki/API_v0.6 >> > >> > Delete: DELETE /api/0.6/[node|way|relation]/#id

Re: [OSM-dev] Delete a node

2009-12-13 Thread Shaun McDonald
On 13 Dec 2009, at 19:29, Anthony wrote: > ant to delete node id 54321 with tags foo=bar and bar=baz, then you send: > > DELETE /api/0.6/node/54321 > > with content: > > > > > > > > > I thought you needed the version (and I forget if it's the new version or the > old version). Wil

Re: [OSM-dev] Delete a node

2009-12-13 Thread Ævar Arnfjörð Bjarmason
On Sun, Dec 13, 2009 at 19:23, Ian Dees wrote: > On Sun, Dec 13, 2009 at 1:16 PM, Ævar Arnfjörð Bjarmason > wrote: >> >> On Sun, Dec 13, 2009 at 17:54, hy-soft wrote: >> > the wiki says: >> > http://wiki.openstreetmap.org/wiki/API_v0.6 >> > >> > Delete: DELETE /api/0.6/[node|way|relation]/#id >>

Re: [OSM-dev] Delete a node

2009-12-13 Thread Ian Dees
On Sun, Dec 13, 2009 at 1:36 PM, Ævar Arnfjörð Bjarmason wrote: > > Obviously they aren't hopeless in all cases, but I've frequently run > into areas where it has been more useful to just read the source / > network sniff than try to figure out what they're talking about. > Perhaps you (or others

Re: [OSM-dev] Delete a node

2009-12-13 Thread Anthony
On Sun, Dec 13, 2009 at 2:34 PM, Shaun McDonald wrote: > It's the version of the item that you have downloaded. (i.e. the old > version). > > Your welcome to add clarifications to the API docs to improve them for > others. > Thanks for the invite. Unfortunately, I don't know enough about the API

Re: [OSM-dev] Delete a node

2009-12-13 Thread Ævar Arnfjörð Bjarmason
On Sun, Dec 13, 2009 at 19:38, Ian Dees wrote: > Perhaps you (or others) that spend the time to do the network sniffing could > update the wiki API docs so that in the future these questions are answered > without a trip to the mailing list? I already know how it works so there's no personal gain

Re: [OSM-dev] Delete a node

2009-12-13 Thread Ian Dees
On Sun, Dec 13, 2009 at 2:06 PM, Ævar Arnfjörð Bjarmason wrote: > On Sun, Dec 13, 2009 at 19:38, Ian Dees wrote: > > Perhaps you (or others) that spend the time to do the network sniffing > could > > update the wiki API docs so that in the future these questions are > answered > > without a trip

Re: [OSM-dev] Open changeset(s) with potlatch

2009-12-13 Thread Richard Fairhurst
hy-soft wrote: > I just noticed that if you open Potlatch and skip to another tab above > [view|edit|history|export] > a new changeset is opened each time - even if you have saved your > editings. Um, are you sure? Potlatch opens a changeset when you enter 'Edit live' mode, or when you save you

Re: [OSM-dev] Delete a node

2009-12-13 Thread jamesmikedup...@googlemail.com
It is not like people want to program an API most of the time. they want to use a simple lib that wraps that api. That is what we need, a libOSM that is up to date and usable in many languages. mike On Sun, Dec 13, 2009 at 9:14 PM, Ian Dees wrote: > On Sun, Dec 13, 2009 at 2:06 PM, Ævar Arnfjörð

Re: [OSM-dev] Delete a node

2009-12-13 Thread Anthony
On Sun, Dec 13, 2009 at 3:14 PM, Ian Dees wrote: > Is there personal gain for you in spending time on an Open Street Map? :-) > Of course there is. ___ dev mailing list dev@openstreetmap.org http://lists.openstreetmap.org/listinfo/dev

Re: [OSM-dev] Delete a node

2009-12-13 Thread hy-soft
Shaun McDonald wrote: >> I thought you needed the version (and I forget if it's the new version >> or the old version). Will it really work without the version? No you really need the version and of course not the last changeset but the changeset that represents your current processing(s). > It'

Re: [OSM-dev] Delete a node

2009-12-13 Thread Ævar Arnfjörð Bjarmason
On Sun, Dec 13, 2009 at 20:14, Ian Dees wrote: > On Sun, Dec 13, 2009 at 2:06 PM, Ævar Arnfjörð Bjarmason > wrote: >> >> On Sun, Dec 13, 2009 at 19:38, Ian Dees wrote: >> > Perhaps you (or others) that spend the time to do the network sniffing >> > could >> > update the wiki API docs so that in

Re: [OSM-dev] Open changeset(s) with potlatch

2009-12-13 Thread Ævar Arnfjörð Bjarmason
On Sun, Dec 13, 2009 at 17:52, hy-soft wrote: > Hi, > I just noticed that if you open Potlatch and skip to another tab above > [view|edit|history|export] > a new changeset is opened each time - even if you have saved your editings. > > Maybe it's not important (and I actually don't care) but peopl

Re: [OSM-dev] Open changeset(s) with potlatch

2009-12-13 Thread Tom Hughes
On 13/12/09 20:26, Richard Fairhurst wrote: > > hy-soft wrote: >> I just noticed that if you open Potlatch and skip to another tab above >> [view|edit|history|export] >> a new changeset is opened each time - even if you have saved your >> editings. > > Um, are you sure? Yes, he is. > Potlatch ope

Re: [OSM-dev] Open changeset(s) with potlatch

2009-12-13 Thread Katie Filbert
On Sun, Dec 13, 2009 at 12:52 PM, hy-soft wrote: > Hi, > I just noticed that if you open Potlatch and skip to another tab above > [view|edit|history|export] > a new changeset is opened each time - even if you have saved your editings. > > Maybe it's not important (and I actually don't care) but p

Re: [OSM-dev] Open changeset(s) with potlatch

2009-12-13 Thread Richard Fairhurst
Tom Hughes wrote: > Exactly, so if you switch away from Potlatch by clicking on a different > tab and then switch back then the flash app will be restarted and will > have to open a new changeset. Sure, though I wouldn't say "a new changeset is opened each time". It's not opened, you open it by c