Objective

Run the find_duplicate_nodes.sql script from Github repository to find all the possible duplicated nodes that exist in Romania. ## Hardware The hardware used is a Intel i7-4770 CPU @ 3.40GHz, 16 GB RAM ## Numbers The pbf file for Romania is 144 MB. Romania database have a total 18M nodes. The query took 20 minutes to run, and found 34674 duplicated nodes. # 34674 duplicated nodes loaded into JOSM ## 1 The way 336945939 have 1500 nodes, and does not contain now any relevant information. ## 2 Buildings not sharing same connecting nodes ## 3 All the city had been imported 2 times This means that every building have a duplicate, one of them should be deleted. ## 4 Duplicated Highway path Way 370332689 and way 363957545 are the same. ## 5 Bad Import Separate ways for each objects, when they should be connected and share the same way. ## 6 2 relations on 2 different ways Way 164811803 and way 164682871 should be combined where they shere the same path, and one of them deleted, and mode the relation into the remaining way ## 7 Bad Import - Building and fence not sharing same way. That is one of my imports. Ups. ## 8 - To much details ## 9 - Reduntant Nodes The line is strait, so the information is redundant.

Osm Diary Entry about Osm PostGIS Script Repo

## Github code ## YouTube Tutorial