Address Lookup

Posted on 2011-10-27
Last Modified: 2012-05-12
Does anyone know of a web service or file download that can provide the COUNTY based on street address, city and state?

Question by:Rickzzz
    LVL 6

    Expert Comment

    LVL 50

    Expert Comment

    for which country/countries do you need this?

    what type of county do you want Postal , or Geo-Political?

    Author Comment

    Thanks mcp111, but I'm looking to return the County. Also, can't use zipcode for this as multiple counties would be returned, need to use address to return a unique county. MilissaData does this (, but for quite a hefty premium.

    Lowfatspread, USA and postal. Thanks!!

    LVL 6

    Expert Comment

    Actually at that website you can enter the full address and then hit Find. Then in the results page click " Show mailing address details" and it will display lots of details including the county for that address.
    And everything is free.

    Author Comment

    Thanks, but I just need to return the County, from some service, via query. I'm pulling 100's of thousands of records.
    LVL 14

    Accepted Solution

    Just some thoughts,

    I use the Melissa Data Address Object (  

    Like you mentioned, not cheap but works very well.  I've actually wrapped the object in a CLR so I can access the results via a table valued function in a T-SQL query.  Very convenient, but very slow (it has to do text file lookups based on their own custom algorithms).  

    Lastly (and very important) If you're pulling 100's of thousand of records this way (in real time query), it'll slow your query down BIG BIG BIG time.  It'd be better to batch the process and then pull clean data.

    Author Closing Comment

    Thanks gohord.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    What Should I Do With This Threat Intelligence?

    Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

    Suggested Solutions

    Entering a date in Microsoft Access can be tricky. A typo can cause month and day to be shuffled, entering the day only causes an error, as does entering, say, day 31 in June. This article shows how an inputmask supported by code can help the user a…
    Shadow IT is coming out of the shadows as more businesses are choosing cloud-based applications. It is now a multi-cloud world for most organizations. Simultaneously, most businesses have yet to consolidate with one cloud provider or define an offic…
    Video by: Steve
    Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
    Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

    761 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    11 Experts available now in Live!

    Get 1:1 Help Now