Tiger/Line Data

[Michael Malone]

Hello,

I am working on a project and need to geolocate street addresses. I will
only be doing this for my county (Maricopa county phoenix Arizona). I know
this can be done with the US Census Tiger/Line data set, but I am lost as
how to import this data into an access table. Has anyone done this or have
any ideas?

On the same note...

I know how to generate a request for an address via a free online service
but do not know how to make access go out and fetch the data without
spawning a web browser. The command line is like this

http://geocoder.us/service/csv/geocode?zip=95472
This returns a page that has only has the lat lon on it. What I would like
do is just enter an address on a form and have it return the lat lon for the
entered data.

Any ideas would be helpful.

Mike

 

[Douglas J. Steele]

See whether you can use the concept I outlined in my November, 2003 "Access
Answers" in Pinnacle Publication's "Smart Access".

You can download the column (and sample database) for free from
http://www.accessmvp.com/DJSteele/SmartAccess.html

 

[Michael Malone]

Thanks for the information. It looks just like what I need.

Mike