Re: [OSM-dev] Can SQLite3 handle OSM 150G data file?

2009-04-28 Thread Shaun McDonald
On 28 Apr 2009, at 00:16, Kelly Jones wrote: I've seen many posts saying that SQLite2 can't handle OpenStreetMap's large planet.osm data file: http://planet.openstreetmap.org/planet-090421.osm.bz2 which is 5.4G bzip2 compressed, about 150G uncompressed. Can SQLite3 handle this? Has

Re: [OSM-dev] Can SQLite3 handle OSM 150G data file?

2009-04-28 Thread marcus.wolschon
On Tue, 28 Apr 2009 08:02:30 +0100, Shaun McDonald SQLite isn't designed for huge databases like OpenStreetMap. You could get away with a city or small region, but more than that, you will get the slowness that you are seeing. http://www.sqlite.org/faq.html#q19 and some other FAQs on that

Re: [OSM-dev] Can SQLite3 handle OSM 150G data file?

2009-04-28 Thread Stefan de Konink
marcus.wolsc...@googlemail.com wrote: On Tue, 28 Apr 2009 08:02:30 +0100, Shaun McDonald SQLite isn't designed for huge databases like OpenStreetMap. You could get away with a city or small region, but more than that, you will get the slowness that you are seeing.

Re: [OSM-dev] Can SQLite3 handle OSM 150G data file?

2009-04-28 Thread Tomas Kolda
There is no reason to be sqlite slow. How much are you are using transactions on your local db? What are you using for import? I'm importing Czech republic (50Mb bziped) in one or two minutes. So for 5.4GB it takes 108 minutes (two hours). But I'm importig to modified osm schema (something

Re: [OSM-dev] API: version number of newly created objects.

2009-04-28 Thread D Tucny
2009/4/28 Chris Browet c...@semperpax.com Hi, I see in the api doc: Version numbers will most of the time begin at *1* and increase by *1*every time an element is changed but this behaviour is not guaranteed and should not be relied upon I understand that phrase as I cannot assume that a

Re: [OSM-dev] API: version number of newly created objects.

2009-04-28 Thread Frederik Ramm
Hi, Chris Browet wrote: As a creation PUT do not return the version number (AFAIK), does that mean that we are suppose to do a GET on the newly created object to get the version number? No, that would be the stupidest API. I have fixed the Wiki page. Assume new versions to always be 1. If

Re: [OSM-dev] API: version number of newly created objects.

2009-04-28 Thread Chris Browet
Thanks - Chris - 2009/4/28 Frederik Ramm frede...@remote.org Hi, Chris Browet wrote: As a creation PUT do not return the version number (AFAIK), does that mean that we are suppose to do a GET on the newly created object to get the version number? No, that would be the stupidest API. I

Re: [OSM-dev] Can SQLite3 handle OSM 150G data file?

2009-04-28 Thread Matt Amos
On Tue, Apr 28, 2009 at 8:26 AM, Stefan de Konink ste...@konink.de wrote: marcus.wolsc...@googlemail.com wrote: On Tue, 28 Apr 2009 08:02:30 +0100, Shaun McDonald SQLite isn't designed for huge databases like OpenStreetMap. You could get away with a city or small region, but more than that,

Re: [OSM-dev] Problems with rendering tiles with mapnik

2009-04-28 Thread Barnett, Phillip
DISCLAIMER - I have not set up a mapnik server or followed these instructions. Your error message is probably because it doesn’t understand ‘source’ – do you have this program/script installed? Might be from TCL if I read it correctly. Or it can’t find the file set-mapnik-env – try changing to

Re: [josm-dev] Deletion conflicts

2009-04-28 Thread Shaun McDonald
On 28 Apr 2009, at 09:23, Frederik Ramm wrote: Hi, Shaun McDonald wrote: It is already possible to do a multiget, ... which will return 404 as soon as any one of its targets has been deleted ;-) Nope, you will only get a 404 if the elements have never existed before. If it has been

Re: [OSM-dev] Can SQLite3 handle OSM 150G data file?

2009-04-28 Thread marcus.wolschon
On Tue, 28 Apr 2009 09:26:21 +0200, Stefan de Konink ste...@konink.de wrote: marcus.wolsc...@googlemail.com wrote: On Tue, 28 Apr 2009 08:02:30 +0100, Shaun McDonald SQLite isn't designed for huge databases like OpenStreetMap. You could get away with a city or small region, but more than

Re: [OSM-dev] Cloudmade routing for OSM rails_port site.

2009-04-28 Thread Eddy Petrișor
On Mon, Apr 27, 2009 at 11:04 AM, Марат Хасанов angedo...@gmail.com wrote: Hi all! Let me introduce Routing for OSM! My name is Marat Khasanov and I’m working for CloudMade as Front-End developer. Few days ago I’ve already finished routing tool for OSM project. With this tool you can aOSdd

[OSM-dev] Embedded databases

2009-04-28 Thread Nolan Darilek
I'm slowly hacking on a project that could benefit from an embedded database, and I'm not smart enough to create my own binary format. Furthermore, since we aren't usually under as severe constraints with embedded resources these days, an actual embedded DB makes more sense. I had a few questions

Re: [OSM-dev] Cloudmade routing for OSM rails_port site .

2009-04-28 Thread marcus.wolschon
On Tue, 28 Apr 2009 16:15:47 +0300, Eddy Petrișor eddy.petri...@gmail.com wrote: I meant shouldn't be passed through. An exception should be made if one of the ends is within the private area. So in other words, the cost of going through an access=private node or way should be way higher than

Re: [OSM-dev] Can SQLite3 handle OSM 150G data file?

2009-04-28 Thread Ævar Arnfjörð Bjarmason
On Tue, Apr 28, 2009 at 12:29 PM, marcus.wolsc...@googlemail.com wrote: On Tue, 28 Apr 2009 09:26:21 +0200, Stefan de Konink ste...@konink.de wrote: marcus.wolsc...@googlemail.com wrote: On Tue, 28 Apr 2009 08:02:30 +0100, Shaun McDonald SQLite isn't designed for huge databases like

Re: [OSM-dev] Embedded databases

2009-04-28 Thread Tomas Kolda
As I wrote in another thread I tried sqlite to do rendering along with mapnik. There is no problem to do it even with builtin rtree spatial index. I can try to create some SVN repos to share code, but it was just for playing (not for production). I tweaked postgress datasource in mapnik and

Re: [OSM-dev] Can SQLite3 handle OSM 150G data file?

2009-04-28 Thread Christoph Eckert
Hi, There is no reason to be sqlite slow. How much are you are using transactions on your local db? What are you using for import? I'm importing Czech republic (50Mb bziped) in one or two minutes. So for 5.4GB it takes 108 minutes (two hours). But I'm importig to modified osm schema

Re: [OSM-dev] [bug] direction of GPS traces

2009-04-28 Thread Graham Jones (Physics)
This thread seemed to fizzle out without coming to a conclusion. I would suggest the following: - Many developers (never mind users) did not appreciate that the opposite of 'public' in this context is 'anonymous'. - Although the wiki does explain this, the GPX upload page does not, it

Re: [OSM-dev] Can SQLite3 handle OSM 150G data file?

2009-04-28 Thread Robert Joop
On 09-04-28 09:14:31 CEST, marcus.wolsc...@googlemail.com wrote: Is there ANY embedded database out there that can handle the planet? Anything that does not require the (unskilled) user of a program to install a local database-server first? has anybody tried embedded innodb? i saw mention of

[OSM-dev] Slippy Map Elevation Overlay

2009-04-28 Thread Graham Jones (Physics)
I sometimes think that the main slippy map has a bit too much plain white, especially in undeveloped places where there are not many roads such as the Pennines or North Yorkshire Moors in Northern England - I keep wondering if this is an un-mapped area, or if there is nothing there The cycle

[OSM-dev] Problems with rendering tiles with mapnik

2009-04-28 Thread Mohamad Ali
Actually guys, I have Ubuntu OS, and I am a newbie to Linux, I think You are right, Ubuntu is missing the shell, I googled about Install sh but I didn't find information that can help me to fix the problem? Please can u give me more details? Thanks guys, Mohamad

Re: [OSM-dev] Problems with rendering tiles with mapnik

2009-04-28 Thread Iván Sánchez Ortega
El Miércoles, 29 de Abril de 2009, Mohamad Ali escribió: Actually guys, I have Ubuntu OS, and I am a newbie to Linux, I think You are right, Ubuntu is missing the shell, Missing?? Applications - Accesories - Terminal ... -- -- Iván Sánchez Ortega

[OSM-dev] More Immediate Changeset Feedback

2009-04-28 Thread Ian Dees
Would it be possible (I know, patches welcome -- I'm just asking about feasibility right now) to stream the node IDs back as the API creates them instead of waiting until the /changeset/upload operation is finished? This would potentially kill two birds with one stone: 1. Give the clients the

Re: [OSM-dev] Problems with rendering tiles with mapnik

2009-04-28 Thread Iván Sánchez Ortega
El Miércoles, 29 de Abril de 2009, Dirk-Lüder Kreie escribió: I think You are right, Ubuntu is missing the shell, Missing?? he has /bin/bash apparently, but not /bin/sh Debian and Debian-like systems (i.e. Ubuntu) use bash as a replacement of sh. So, if /bin/sh is *really* missing, just

Re: [OSM-dev] Problems with rendering tiles with mapnik

2009-04-28 Thread Mohamad Ali
I have Applications - Accesories - Terminal ... -Original Message- From: Dirk-Lüder Kreie [mailto:osm-l...@deelkar.net] Sent: Wednesday, April 29, 2009 10:05 AM To: Iván Sánchez Ortega Cc: dev@openstreetmap.org; Mohamad Ali Subject: Re: [OSM-dev] Problems with rendering tiles with

Re: [OSM-dev] Slippy Map Elevation Overlay

2009-04-28 Thread MilesTogoe
Graham Jones (Physics) wrote: I sometimes think that the main slippy map has a bit too much plain white, especially in undeveloped places where there are not many roads such as the Pennines or North Yorkshire Moors in Northern England - I keep wondering if this is an un-mapped area, or if

[OSM-dev] Hi OpenStreetMap

2009-04-28 Thread Sam Mor
Hi Guys We are very happy to join your Project, Wonderful Project We will take a breath and go deeper.. Have  a Nice Day Sam The new Internet Explorer 8 optimised for Yahoo!7: Faster, Safer, Easier.___ dev mailing list dev@openstreetmap.org

[OSM-dev] List of Questions

2009-04-28 Thread Sam Mor
Sorry We are at beginning, but it's good to understand the basics,  how do mapnik create the image from osm file? where are the images are located? Enjoy a better web experience. Upgrade to the new Internet Explorer 8 optimised for Yahoo!7. Get it

[OSM-dev] building A openstreetmap server

2009-04-28 Thread Sam Mor
I would to comment about I read: is it correct that everyone can build his openstreet map server? if yes , what are the needs of hardwares and softwares? I tried long time to look for a free mapping system, but I didnt and I think OpenStreetMap is a Wonderful one if it's open source and can be

Re: [OSM-dev] List of Questions

2009-04-28 Thread Sam Mor
  Mapnik get : -the images from Symbols file - data from osm files then mapnik draws (renders) tha images is it true? and about mod_tile, we need to read it first.. sorry not yet finished thanks, and it was a funny joke, hahaha Cheers From: Stephan

Re: [josm-dev] Deletion conflicts

2009-04-28 Thread Dirk Stöcker
On Mon, 27 Apr 2009, Frederik Ramm wrote: Idea 2: Before re-downloading an area, let JOSM mark all objects that came from the API on the last download as possibly deleted. On merging the newly downloaded dataset with the existing data, reset that flag for every object retrieved from the API.

Re: [josm-dev] Deletion conflicts

2009-04-28 Thread Shaun McDonald
On 28 Apr 2009, at 08:17, Dirk Stöcker wrote: On Mon, 27 Apr 2009, Frederik Ramm wrote: Idea 2: Before re-downloading an area, let JOSM mark all objects that came from the API on the last download as possibly deleted. On merging the newly downloaded dataset with the existing data, reset

Re: [josm-dev] Deletion conflicts

2009-04-28 Thread Frederik Ramm
Hi, Shaun McDonald wrote: It is already possible to do a multiget, ... which will return 404 as soon as any one of its targets has been deleted ;-) Bye Frederik ___ josm-dev mailing list josm-dev@openstreetmap.org

Re: [josm-dev] Deletion conflicts

2009-04-28 Thread Marko Mäkelä
On Tue, Apr 28, 2009 at 11:32:51AM +0200, Rolf Bode-Meyer wrote: 2009/4/27 Frederik Ramm frede...@remote.org: (Incidentally - how can a node have only one version and this is deleted? Would one not have to first create the node, making v1, then delete it, making v2?) Why? Deleting

Re: [josm-dev] Deletion conflicts

2009-04-28 Thread Frederik Ramm
Hi, Rolf Bode-Meyer wrote: (Incidentally - how can a node have only one version and this is deleted? Would one not have to first create the node, making v1, then delete it, making v2?) Why? Deleting doesn't create a version of the deleted element. I don't think CVS does either. I don't

Re: [josm-dev] Deletion conflicts

2009-04-28 Thread Rolf Bode-Meyer
2009/4/27 Frederik Ramm frede...@remote.org: (Incidentally - how can a node have only one version and this is deleted? Would one not have to first create the node, making v1, then delete it, making v2?) Why? Deleting doesn't create a version of the deleted element. I don't think CVS does