Question

Adjacent Road Elements have slightly different Street Names

  • 21 February 2019
  • 1 reply
  • 1 view
I

I have shape file for a country which contains ~70000 line segments with new street names as per reality and these new street names need to update on database. Database already having old Street names per reality as well.

Eg- Old Street Name (database)- Park Ave Street New Name- Park Avenue Street. Adjacent Road Name- Park Avenue Road (database). I need to know how to find such cases automatically without visiting each location in shape file. Refer Attachment number 1.jpg and 2.jpg

Such situations with different names may be there while replacing names at different location.

How to find out such cases spatially? There could be lot of cases in a country.

Thanks in advance.

 

1 reply

david_r
Rank
Userlevel 4

This can be a fairly complicated task, but I've had some success in the past using this method:

  • Buffer around one of the datasets
  • LineOnAreaOverlayer between the buffers and the other dataset, be sure to generate a list for the overlaps
  • Analyze the overlaps line vs. buffer and calculate the length of each line inside the buffer, retain the attributes from the line that dominates the buffer ("spends the most time inside the buffer")

It will probably still be necessary to do some manual checks and corrections.

Reply


Community Stats

28,669
Posts
109,362
Replies
36,531
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.