Remove redundant data from address column

  • Maybe we could use the google geocoding web service with a clr object to normalize an address.

    https://developers.google.com/maps/documentation/geocoding/#Geocoding

    According to this link, we can sent an address and get the coordinates. After that we can send the coordinates back to get an address (which i think it will be in normalized format).

    What do you think?.

    I guess it will be slow.

  • adrian.facio (8/9/2012)


    Maybe we could use the google geocoding web service with a clr object to normalize an address.

    https://developers.google.com/maps/documentation/geocoding/#Geocoding

    According to this link, we can sent an address and get the coordinates. After that we can send the coordinates back to get an address (which i think it will be in normalized format).

    What do you think?.

    I guess it will be slow.

    There are limits on the number of addresses you can validate per day. It will CASS/PAVE/PAF addresses for you. There's an API for that. But there are limits on speed and volume.

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

Viewing 2 posts - 16 through 16 (of 16 total)

You must be logged in to reply to this topic. Login to reply