[ale] OT - Latitude/Longitude Lookup

[Alex Carver]

On 7/5/2013 09:09, Jay Lozier wrote:
> Hi,
>
> I have a project were I need to take latitude/longitude data and get the
> place name. I can do this manually using Google maps by entering the
> lat/long and getting the city, state location. But for this project I
> have about 10,000 lat/long I need to look up. City/State/Zip or
> County/State is ok - I actually need the counties.
>
> I am looking to automate the process using the lat/long data.
>
> I am open to suggestions.
>

One option is the Census TIGER database which is freely downloadable 
(http://www.census.gov/geo/maps-data/data/tiger.html) and contains 
mostly shp and dbf files.  With some massaging you can combine this data 
and put it into a GIS aware database (or just brute force it) to get any 
of the data you need.  Some of the smaller data sets contain just county 
lines and some address data.  The larger files contain every known 
address, county lines, city boundaries, and more.