1
I have a base of addresses (street, city, state, zip code, neighborhood) and 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: http://thiagorodrigo.com.br/cep-sao-paulo-lista-de-cep-por-bairro-e-cidade-da-grande-sao-paulo/, but I didn’t find API, someone knows some?
PS.: If only São Paulo already meets most of my addresses.
0
I exported id and zip code of my entire database to an Excel, I took the zip codes by zone on this site: http://rainydays.com.br/faixas-de-cep-de-sao-paulo and put in the same Excel. Separating by the columns Zone, Start and End
I did a PROCV looking for the Zip Code of my base in the Zip Code Table returning me to Zone. Now I had id and Zone, so I set up an UPDATE and ran it in the Database.
Browser other questions tagged api zip-code
You are not signed in. Login or sign up in order to post.