Api Location with Zone


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.

asked by anonymous 05.01.2017 / 19:43

1 answer


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.

06.01.2017 / 20:13