I have a base of addresses (street, city, state, zip code, neighborhood) and would need to complete the address with the Zone (East, North, South, West, Center).
I thought the easiest way to do it would be by API, this site is perfect to illustrate: #
PS: If only São Paulo already answers most of my addresses.
I've exported id and zip code from my entire database to an Excel, I've picked up zip codes by zone on that site: link and I put it in the same Excel. Separating by the Zone, Start, and End columns
I did a PROCV looking for the zip codes from my base on the CEP Tracking Table and returning the Zone. Now I had id and Zone, so I mounted an UPDATE and executed it in the Database.
