Geocode Addresses From Database

If there is an ADDRESS field in the database, the program can compute the LAT/LONG.  This ADDRESS can be a complete street address, or just the city and state.  There must be a map open from which the database was opened for this option to be available. This uses a web service from a server.

Original table, from the web site of a college football team. Note that the hometown field includes the city, state, and the name of the high school. 

Copy the HTML table into Excel, clean it up, save as a CSV file, and import into MICRODEM.
  If you have separate fields with CITY and STATE, you can combine them with Edit, Insert new fields, Concatenate fields.
Turn on edits, and pick Edit, Insert new fields, Split field with separator.  In this case we split the HOMETOWN into ADDRESS and HIGH_SCHOOL with "/" as the separator.   Similar operations could work with other address variants.

This would also work with complete street addresses, in which case you would get a more accurate location.

Pick Edit, Geocode addresses.  There must be an ADDRESS field (rename the field if necessary by clicking on the name), which can be either a complete address, or just the town and state.  The web interface will be relatively tolerant of how the data is entered (note that in this case the "-" between the town and state does not cause any problems; the original "," in the files was replaced in Excel  because of the challenges that the commas can create with CSV file import.  The program will cycle through all records.  The web service might limit how many requests you can make each day before you have to pay.

Close the database, reopen, and locations will plot.

You could get the tracts or counties for each record, using Point in area.

You could get demographic and economic data with American Community Survey Data  and then Joining databases.


Last revision 4/19/2017