Here are some updates about project #34 discussions
Issue summary
A mapper in Canada pointed out that some of our team’s edits caused ‘orphan’ address nodes where the street name in the address node no longer matches the street name of the corresponding way. So in Canada are now 339219 addresses on node or building polygons with different addr:street tag than the street next to the feature.
Fixing steps
We received from a user a dump file (street_not_found.zip) with all the addresses from Canada with different addr:street tag;
I extracted all the ways from Canada edited by Telenav Users which has the name tag:
I exported this table and using QGis I create a 50 meters buffer for these ways and I extracted all the addressees from street_not_found that overlaps the buffer with Telenav edits.
Using the same method I did the same for all the ways in Canada.
Using PostGIS I created the following metrics:
select canada_bbox.name, count (*) FROM address_all, merged WHERE
st_intersects(address_telenav.geom,canada_bbox.geom)
GROUP BY canada_bbox.name
ORDER BY canada_bbox.name;
I deleted from address_all the nodes that are already on adress_telenav:
delete from address_all where node_id in (select node_id from adress_telenav)
Copied from original issue: TelenavMapping/mapping-projects#40
From @hoream-telenav on November 8, 2017 10:55
Here are some updates about project #34 discussions
Issue summary
A mapper in Canada pointed out that some of our team’s edits caused ‘orphan’ address nodes where the street name in the address node no longer matches the street name of the corresponding way. So in Canada are now 339219 addresses on node or building polygons with different addr:street tag than the street next to the feature.
Fixing steps
We received from a user a dump file (street_not_found.zip) with all the addresses from Canada with different addr:street tag;
I extracted all the ways from Canada edited by Telenav Users which has the name tag:
I exported this table and using QGis I create a 50 meters buffer for these ways and I extracted all the addressees from street_not_found that overlaps the buffer with Telenav edits.
Using the same method I did the same for all the ways in Canada.
Using PostGIS I created the following metrics: select canada_bbox.name, count (*) FROM address_all, merged WHERE st_intersects(address_telenav.geom,canada_bbox.geom) GROUP BY canada_bbox.name ORDER BY canada_bbox.name;
I deleted from address_all the nodes that are already on adress_telenav: delete from address_all where node_id in (select node_id from adress_telenav)
Copied from original issue: TelenavMapping/mapping-projects#40