Hi Walter, i agree, this was my error, i did not factor in the difference in experience between the members of the team. We where 4 persons that handled the re-gluing the al6 to the al4 .

For the future we had decided to have a peer approach when after we will do a import, another user will check what other member of the team did.

Hi @nakaner, thanks for the feedback, i will try to do it tomorrow, if not i will do it during the weekend.

It is in EPSG 3857

Great idea, is in my to do list, but did not figure out the code to to that yet

Butrus sure this can be filtered from the query.

Anyhow, this is a hobby project, i don`t have yet the postgis skills to do it, so no worry

Also, i just want to see the result, i will not act upon it.

When i will be able, i will just highlight the extreme cases, and maybe do a maproulette challenge when a road have more then 10 nodes that can be deleted, so that users can check them

Nice, waiting to hear more about your adventure :)

I will leave the code here and try to work on it after i will find some postgis gurus that will be able to help me :P

https://gist.github.com/anonymous/3669b78e0898bde4f638

@SimonPoole that is a valid point of view.

Anyhow, i think i should change the initial hypothesis, to the first thing that i am interested, that is, to be able to detect and count this. then, publish the metrics. Then we will know some numbers.

I am trying to develop different metrics that could help us find errors on the map. One of the aims is to be able to detect the overnoded ways from import.

Thanks, i did not know about the Douglas-Peucker algorithm, i will check it out and see if maybe this can be used for this simple task.

I had used this in the past http://pastebin.com/2kH0mAWG to calculate in Qgis the angles that are more then 50 degrees ,when i wanted to create a map roulette challenge for Romania and

Now, it`s kind of the same idea, but with a different threshold

romanian discussion about the topic

I don`t want to do it, especially in a automated way and without consulting the community. I had not find yet a way to import the whole planet, only part of the planet

But i want to have the proof of concept, to show.

Example 53405432 nodes could be removed, saving us XX MB , reducing the import time of the planet file by XXX seconds …

I will kill the task and try 2 different version :

1 imposm3

1. load by regions and then join in postgis

the only information that found says that i still have to wait at least 7 more days http://ksmapper.blogspot.ro/2011/04/parse-planet-into-pgsnapshot-database.html

I think i got an answer, based on

If the copy*****n it`s 317 GB

What is the approximate size of copy****w 80 % ( 240~ GB ) copy*****wn 10-20 % (50-60 GB)

i want to do statistics about everything that is on the planet file, from every piece of the world.

I know that i could just import each continent and then do some join to stitch all together, but then whats the point of a planet file.

I already Have Africa loaded, some more countries loaded, but the aim of my statistics will be to show everything that is on the map, how it relates, what particularities exists in different parts of the world

@jean osmosis have a bug and it does not work to process a file and upload it to postgres without the sudo command.

I have access to the server, what should i change / could i change

I want the whole planet, so i can do some statistics for the whole planet, not just a country or a continent.

top - 11:00:23 up 62 days, 15:27, 7 users, load average: 2.03, 2.07, 2.10 Tasks: 305 total, 2 running, 280 sleeping, 23 stopped, 0 zombie %Cpu(s): 3.5 us, 9.6 sy, 0.0 ni, 73.7 id, 13.2 wa, 0.0 hi, 0.0 si, 0.0 st KiB Mem: 16341788 total, 16174748 used, 167040 free, 25816 buffers KiB Swap: 16684028 total, 16521344 used, 162684 free. 9697612 cached Mem

PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND 21798 postgres 20 0 369660 190580 144392 R 0.0 1.2 16935:45 postgres 22127 postgres 20 0 295484 144512 144468 S 0.0 0.9 600:18.35 postgres

@Jadrzerj Pelka I am thinking of redoing the gigapixel that i did last year https://photosynth.net/view.aspx?cid=cc38ddc9-5f75-45c9-8ee7-3d1388439a3e

@baditaflorin/diary/23729

and with that, some new statistics.

And now there is also a JOSM plugin.

I am uisng to make photos, using 2 phones, side by side, so i can map more in the same time.

Do you have admin on OsmRomania fb page ?

You could post status updates about the map also there :)

and now with the mapillary JOSM plugin it`s much easier then it was 6 months ago when i was making photos and trying to add the info on the map, using josm

Glad to hear this :)

Hello Harry, i have them in my computer, if the Dropbox link does not work

https://www.dropbox.com/sh/whixmqcr14n873y/AAA5cRJev87o7dcdjAnKsylda?lst

I did not even know that we have such a list :)