Add coordinates for a ZIP where we have same coordinate for other ZIPs in the same City

unknown

Hello,

I'm trying to replace the nulls in Longitude & Latitude for ZIP codes that belong to same City, where I already have coordinates for the City (as other ZIPs in same city)

Up to now I could only partially solve it by checking if a value exists in the Row+1 or Row-1. 

But it has to be a different solution, because I still end up with Nulls where the ZIP code is not one in a certain order.

 

AkimasaKajitani

Hi @Inactive User 

If the same city that have different postal code is the same Lat/Lon, you can Join tool.

1.Make City List by Summarize tool.
2.Join at Key Field that is City
3.Fill the Null or Unselect Old Lon/Lat

Input:

Output:

City List:

Fill_LatLon.yxmd