Home » SQL & PL/SQL » SQL & PL/SQL » How to populate County
How to populate County [message #8901] Wed, 01 October 2003 17:15 Go to next message
Martha Estrada
Messages: 1
Registered: October 2003
Junior Member
Does anyone knows how to populate county when is not in the original data? from API_ADDRESS? any suggestions??
Re: How to populate County [message #8919 is a reply to message #8901] Fri, 03 October 2003 06:58 Go to previous message
Art Metzer
Messages: 2480
Registered: December 2002
Senior Member
Martha,

To derive county names from an address, you're going to have to buy some third-party software.

If the number of mailing addresses whose counties you need is small, you can go to the United States Postal Service Web site and type in an address. It will return both the ZIP code and county to you, but you can only process one address at a time. It looks like the USPS does have a programmatic solution, but it, too, requires a licensing fee. If you're interested, see the text at the bottom of the page I've linked, where it says

----------------------------------------------------------------------
For integrating ZIP Code Lookup capabilities into your web site or application system, please visit our Web Tools (APIs) or find additional addressing products at Address Information System Products (AIS).

----------------------------------------------------------------------

Good luck, Martha.

A.
Previous Topic: negate a value
Next Topic: ORA-28595 "Invalid DLL path" and external procedure
Goto Forum:
  


Current Time: Tue Apr 16 16:11:56 CDT 2024