Re: [Talk-ca] [OSM-talk] Northern lights
2008/12/31 Jochen Topf > On Wed, Dec 31, 2008 at 03:26:26AM +, michc...@gmail.com wrote: > > Ok. I found the IDs of the ways I would like to delete. What do I do next > > to retrieve them and remove them. Thanks. > > http://wiki.openstreetmap.org/wiki/OSM_Protocol_Version_0.5 > In addition to what I wrote before... the use of the /full modifier (which I had either not noticed before or forgotten about, thanks Jochen) when fetching the ways would allow fetching of the nodes too, though you would likely need to sort the resulting file before being able to use it... Actually, as you don't really need the original nodes to delete them it might not be so useful in this case... d ___ Talk-ca mailing list Talk-ca@openstreetmap.org http://lists.openstreetmap.org/listinfo/talk-ca
Re: [Talk-ca] [OSM-talk] Northern lights
On Wed, Dec 31, 2008 at 03:26:26AM +, michc...@gmail.com wrote: > Ok. I found the IDs of the ways I would like to delete. What do I do next > to retrieve them and remove them. Thanks. http://wiki.openstreetmap.org/wiki/OSM_Protocol_Version_0.5 Jochen -- Jochen Topf joc...@remote.org http://www.remote.org/jochen/ +49-721-388298 ___ Talk-ca mailing list Talk-ca@openstreetmap.org http://lists.openstreetmap.org/listinfo/talk-ca
Re: [Talk-ca] [OSM-talk] Northern lights
2008/12/31 > On Dec 29, 2008 10:41am, Jochen Topf wrote: > > On Mon, Dec 29, 2008 at 03:08:36PM +, michc...@gmail.com wrote: > > > > >> There just was a discussion on dev about a single way with 40.000 > nodes. > > > > >> > > > > >> That is far too long to be able to handle it with current software and > > > > >> > > > > >> makes lots of problems. Are you maybe referring to that? Ways should > not > > > > >> > > > > >> have more than 1000 nodes or so. > > > > >> > > > > > > > > > > Yes we are. The current ways we are talking about may have more than 40 > > > > > 000 nodes. I would like to delete them and replace them by chopping the > > > > > ways. > > > > > > > > > > Do you known how I could delete the current ones at once. I thought > about > > > > > something like: SELECT boundary FROM ways WHERE > > > > > (boundary='administrative' AND admin_level=4 AND source='geobase'). The > > > > > number we should get is 503 ways. > > > > > > > > When you uploaded those ways you should have gotten the new way_id. If > > > > you didn't record this but remember on which day you did the upload you > > > > can download the right daily or hourly diff (from > > > > http://planet.openstreetmap.org/) and find the IDs in there. (And record > > > > the IDs the next time you do a bulk upload for cases like this.) > > > > > > Ok. I found the IDs of the ways I would like to delete. What do I do next > to retrieve them and remove them. Thanks. > > Michel > > One way to do it would be to script a request to http://api.openstreetmap.org/api/0.5/way/ for each wayid, stripping the , and tags out and concatenating into a single file... Parse the resulting file extracting node IDs, and add lines similar to " lat='0' lon='0' visible='false' />" to the beginning of the file... If you want to/can use JOSM to remove them, when complete, add back the tag at the top, the tag at the bottom and replace all instances of visible='true' with visible='false', load into JOSM and hit upload... Otherwise, you'll probably need to use the bulk import script, for this, you'd add and at the bottom, then feed it through the bulk import script... I hope that helps... It's quite easily scriptable, though perhaps someone has a premade bulk-delete script already... d ___ Talk-ca mailing list Talk-ca@openstreetmap.org http://lists.openstreetmap.org/listinfo/talk-ca
Re: [Talk-ca] [OSM-talk] Northern lights
On Dec 29, 2008 10:41am, Jochen Topf wrote: On Mon, Dec 29, 2008 at 03:08:36PM +, michc...@gmail.com wrote: >> There just was a discussion on dev about a single way with 40.000 nodes. >> >> That is far too long to be able to handle it with current software and >> >> makes lots of problems. Are you maybe referring to that? Ways should not >> >> have more than 1000 nodes or so. >> > > Yes we are. The current ways we are talking about may have more than 40 > 000 nodes. I would like to delete them and replace them by chopping the > ways. > > Do you known how I could delete the current ones at once. I thought about > something like: SELECT boundary FROM ways WHERE > (boundary='administrative' AND admin_level=4 AND source='geobase'). The > number we should get is 503 ways. When you uploaded those ways you should have gotten the new way_id. If you didn't record this but remember on which day you did the upload you can download the right daily or hourly diff (from http://planet.openstreetmap.org/) and find the IDs in there. (And record the IDs the next time you do a bulk upload for cases like this.) Ok. I found the IDs of the ways I would like to delete. What do I do next to retrieve them and remove them. Thanks. Michel Jochen -- Jochen Topf joc...@remote.org http://www.remote.org/jochen/ +49-721-388298 ___ Talk-ca mailing list Talk-ca@openstreetmap.org http://lists.openstreetmap.org/listinfo/talk-ca
Re: [Talk-ca] [OSM-talk] Northern lights
On Mon, Dec 29, 2008 at 03:08:36PM +, michc...@gmail.com wrote: >> There just was a discussion on dev about a single way with 40.000 nodes. >> >> That is far too long to be able to handle it with current software and >> >> makes lots of problems. Are you maybe referring to that? Ways should not >> >> have more than 1000 nodes or so. >> > > Yes we are. The current ways we are talking about may have more than 40 > 000 nodes. I would like to delete them and replace them by chopping the > ways. > > Do you known how I could delete the current ones at once. I thought about > something like: SELECT boundary FROM ways WHERE > (boundary='administrative' AND admin_level=4 AND source='geobase'). The > number we should get is 503 ways. When you uploaded those ways you should have gotten the new way_id. If you didn't record this but remember on which day you did the upload you can download the right daily or hourly diff (from http://planet.openstreetmap.org/) and find the IDs in there. (And record the IDs the next time you do a bulk upload for cases like this.) Jochen -- Jochen Topf joc...@remote.org http://www.remote.org/jochen/ +49-721-388298 ___ Talk-ca mailing list Talk-ca@openstreetmap.org http://lists.openstreetmap.org/listinfo/talk-ca
Re: [Talk-ca] [OSM-talk] Northern lights
On Dec 29, 2008 3:11am, Jochen Topf wrote: On Sun, Dec 28, 2008 at 06:48:37PM -0800, Sam Vekemans wrote: > the canadian geopolitical boundries was just imported. > I imagine there was a spike in the database. > > What exactly was the problem? And why &how would it need to be removed? > Im sure theres some folks who can help. (if not already doing so) > -the message is on the last talk-ca digest. (just need to find the > link, but using my cell for this msg) There just was a discussion on dev about a single way with 40.000 nodes. That is far too long to be able to handle it with current software and makes lots of problems. Are you maybe referring to that? Ways should not have more than 1000 nodes or so. Yes we are. The current ways we are talking about may have more than 40 000 nodes. I would like to delete them and replace them by chopping the ways. Do you known how I could delete the current ones at once. I thought about something like: SELECT boundary FROM ways WHERE (boundary='administrative' AND admin_level=4 AND source='geobase'). The number we should get is 503 ways. Michel Jochen -- Jochen Topf joc...@remote.org http://www.remote.org/jochen/ +49-721-388298 ___ Talk-ca mailing list Talk-ca@openstreetmap.org http://lists.openstreetmap.org/listinfo/talk-ca ___ Talk-ca mailing list Talk-ca@openstreetmap.org http://lists.openstreetmap.org/listinfo/talk-ca
Re: [Talk-ca] [OSM-talk] Northern lights
On Sun, Dec 28, 2008 at 06:48:37PM -0800, Sam Vekemans wrote: > the canadian geopolitical boundries was just imported. > I imagine there was a spike in the database. > > What exactly was the problem? And why &how would it need to be removed? > Im sure theres some folks who can help. (if not already doing so) > -the message is on the last talk-ca digest. (just need to find the > link, but using my cell for this msg) There just was a discussion on dev about a single way with 40.000 nodes. That is far too long to be able to handle it with current software and makes lots of problems. Are you maybe referring to that? Ways should not have more than 1000 nodes or so. Jochen -- Jochen Topf joc...@remote.org http://www.remote.org/jochen/ +49-721-388298 ___ Talk-ca mailing list Talk-ca@openstreetmap.org http://lists.openstreetmap.org/listinfo/talk-ca