Step 1.
Why need find duplicate POI and address?
Over time, when you collect this years POI or Address, compare to last years data,
part 1). newly opened POI or address,
part 2). closed POI or no longer exist address.
part 3).The rest have no change.
Step 2.
If a POI or address in this years dataset, is identical to a POI or address in last year,
means this POI is duplicate, it is part 3 have no change.
What condition make you determine 2 POI are idential?
Step 3.
geometry (location) should not be used.
Because same location have multiple bussiness is very often.
As long as POI name is same, street number is same
I will think they are idential POI.
If this is not enough, require street name as well.
POI name, street number, street name, make a unique POI.
Step 4.
same POI name, different street number
for example: walmart have different store.
Step 5.
different POI name, same street number.
old business closed last year, this year a new different business open in the same location.
Step 6.
same POI name, same street number, diferent street name.
I think this case is very rare.
IF this does happen, then you will have to add street name to compare as well.
Because la county does not have a POI database, so I can not test it here.
Step 7.
What about address?
can we say, if 2 address have same street number, and street name, then they are duplicate, identical?
Yes or no?
we have to find out from la county's locator test.
https://transparentgov.net/json2tree/esri/server/folder2.html?org=https%3A%2F%2Fgeocode.gis.lacounty.gov%2Fgeocode%2Frest%2Fservices&url=https%3A%2F%2Fgeocode.gis.lacounty.gov%2Fgeocode%2Frest%2Fservices&arcgis_online_token=&timeout=9000&select_folder=6&select_layer=-1&select_folder_text=CAMS_Pro_Locator+%3Csup%3EGeocodeServer%3C%2Fsup%3E&select_layer_text=CAMS_Pro_Locator+%3Csup%3EGeocodeServer%3C%2Fsup%3E
Step 8.
these 2 addres have same number, same street name,
but different city, zip code.
https://transparentgov.net/json2tree/gateway/feature-geocode/geocode-suggest-real-addr.html?backgroundlayerurl=https%3A%2F%2Fgeocode.gis.lacounty.gov%2Fgeocode%2Frest%2Fservices%2FCAMS_Pro_Locator%2FGeocodeServer&layer=CAMS_Pro_Locator&_center_lat=33.928799999999995&_center_long=-118.2468&_center_zoom=13&panto=0&search=200
Step 9.
these 2 address have same number, same street name, but 2 different pre-direction
Step 10.
these 2 address have same number, same street name, but 2 different pre-direction
Step 11.
these 2 addres have same number, same street name,
but different city, zip code.
Step 12.
these 2 addres have same number, same street name,
but different city, zip code.
Step 13.
conclusion:
if 2 address have same
street number, pre-direction, street name, city name(zip code)
They are identical.
all 4 component must be same, I will determine they are duplicated.
If duplicate, you can skip this one.
Step 14.
Step 15.
Step 16.
Step 17.
Step 18.
Step 19.
Step 20.