This project is for a freelancer who is already very comfortable with the Google maps API AND Classic ASP
I just want to geocode Latitude and Longitude into my database if the record is NOT already geocoded
I want to be able to search for records without geocoding using the attached search form
This should give you the Idea of what I’m trying to do. I would like both Google and Yahoo options.
I have Access 2000 with two tables, SDI and Sketches
Both have fields Latitude, Longitude and an autonumber field called index_id in them.
The Sketches table has a field called HName that contains the address city state of the record all together.
The SDI table addresses are split up into HOUSE_NR STREET_DIR STREET_NAM CITY STATE ZIP.