Step 1.
I have original county street segment, without fix missing 100 block breaker.
Now I have a bunch of new street segment which have fixed missing breaker.
when I combine these 2, I need to determine if this street segment is already exist(fixed) or not exist.
So what is rule to determine a street segment is already exist or not?
google AI suggest have long list, sounds great, but not applicable.
Step 2.
ChatGPT seems smarter than Google AI,
seems understand the problem deeper than google,
but still to much suggestion, they all sounds great, but not applicable.
block breaker issue is very rare, the solution is un-predictable, un-limited.
AI try to search and combine past experience, does not work here.
Step 3.
human brain can truly undestand this problem,
can looking for solution specially for this exact problem.
Ignore the irrelevant.
human brain can create method like this:
1) if 2 segment have same street name and overlapped block range,
then I can detemine, it is exist, not new.
2) how to determine block range overlap or not?
2.1 calculate the middle number
( LeftTo - LeftFrom ) / 2
2.2 if this middle number fall between any segment's LeftTo and LeftFrom,
then detemine as overlapped segment.
Both rule 1 and 2 need satified at same time.
Step 4.
To implement rule 1 in Arcgis Pro, reach the limit.
ArcPro only allow you to write SQL command, (red arrow)
does not allow you to write souce code apply rule #1
Step 5.
work around is write source code to apply rule 1 and 2.
Step 6.
Step 7.
Step 8.
Step 9.
Step 10.
Step 11.
Step 12.
Step 13.
Step 14.
Step 15.
Step 16.
Step 17.
Step 18.
Step 19.
Step 20.
Step 21.
Step 22.
Step 23.
Step 24.
Step 25.
Step 26.
Step 27.
Step 28.
Step 29.