CiviCRM Community Forums (archive)

*

News:

Have a question about CiviCRM?
Get it answered quickly at the new
CiviCRM Stack Exchange Q+A site
This forum was archived on 25 November 2017. Learn more.
How to get involved.
What to do if you think you've found a bug.



  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Discussion (deprecated) »
  • Feature Requests and Suggestions (Moderator: Dave Greenberg) »
  • Batch address standardization and Congressional district lookup with ZIP+4
Pages: [1]

Author Topic: Batch address standardization and Congressional district lookup with ZIP+4  (Read 1729 times)

Dennis Gray

  • Ask me questions
  • ****
  • Posts: 472
  • Karma: 1
  • CiviCRM version: Various. See post.
  • CMS version: Drupal, Wordpress and Joomla. See post.
  • MySQL version: TBA
  • PHP version: TBA
Batch address standardization and Congressional district lookup with ZIP+4
August 15, 2011, 12:51:11 am
Because I have been unable to get the USPS to allow us to use their service, I am now looking for a low cost commercial or free method of submitting a batch of about 80,000 contact records to be returned with the ZIP+4 data. I am not so interested in address standardization as I am getting the full ZIP+4 for the address. The ultimate goal is to determine the US Congressional district for the address.

I realize re-districting is happening but I would like this working and tested as soon as I can.

« Last Edit: August 15, 2011, 12:53:46 am by Ozyank »

Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: Batch address standardization and Congressional district lookup with ZIP+4
August 15, 2011, 07:24:00 am

i would check the geocoding / mapping providers (yahoo/google). I think they also do address standardization / cleanup and return the ZIP + 4 as part of the cleaned address

U'll need to modify the code to do the above. If you do so, please submit your code back with a description, so we can merge it back in

lobo
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions

Dennis Gray

  • Ask me questions
  • ****
  • Posts: 472
  • Karma: 1
  • CiviCRM version: Various. See post.
  • CMS version: Drupal, Wordpress and Joomla. See post.
  • MySQL version: TBA
  • PHP version: TBA
Re: Batch address standardization and Congressional district lookup with ZIP+4
August 15, 2011, 02:12:04 pm
The first thing I got when I googled this was a link back to http://forum.civicrm.org/index.php?topic=9678.0. I've tried this code but don't see where it standardises the address. I'll investigate more but my first requirement is that it be done in batch over the entire database. Commercial service can work but may be expensive.

I tested one called Qualified Addess and the price is reasonable but I'm still looking for a free option

Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Discussion (deprecated) »
  • Feature Requests and Suggestions (Moderator: Dave Greenberg) »
  • Batch address standardization and Congressional district lookup with ZIP+4

This forum was archived on 2017-11-26.