Using data available from Wikipedia concerning historic homes constructed near the turn of 19th and 20th century, I have created a map of structures in Knoxville, Tennessee designed by George A. Barber, an architect.
I pulled the data from <http://en.wikipedia.org/wiki/List_of_George_Franklin_Barber_works> as a simple “copy” and “paste” operation into Apache Open Office Calc spreadsheet.
I saved the spreadsheet as a .csv file, comma delimited.
I added a new column and duplicated the street addresses. I deleted the parantheticals surrounding the street address, along with the name of the property.
I deleted the street address and parenthetical in column 1 to retain the name of the property.
After saving the .csv file again, I opened up my personal Google Drive account.
I added the “Google Fusion Tables” application from Google, and then selected “create new fusion table” as instructed in Google’s tutorial.
After importing the data, I ran into some problems concerning the division of street, city, and state. From “File > Geocode” my “street” was not recognized immediately as a location address. After changing the “street” drop down in the “Rows 1” view to “location,” I was able to direct the application to geocode based on the street address.
At present time, this is a very basic map.
I do like the ease with which it obtained the lat/long coordinates, and how it transformed the table data into “cards” with the pertinent information in a “pop-up” on the map.
I’m also happy that it can export the resultant geocoded map as KML.
For future work, I think it would be interesting to link a Flickr or other photo management system to the Geocoder.
I also understand it is possible to add a Google Street view image of the particular property.
However, it is necessary to obtain the location information in the form of lat/long for this to work.
It is unfortunate that Fusion Tables do not append the lat – long information to the table.
There is software available which can provide this information.
From my course in the Geography Department, I’m aware of this software:
The application of interest is listed under “Google Geocoder.”
Geocoding with Google Earth is accomplished through two programs: KMLGeocode and KMLReport. The first program reads Excel Worksheets or an XML export of a table from a relational database system and creates a KML file that can be loaded into Google Earth. Once the KML file is loaded, Google Earth will attempt to geocode each entry in it. After the file is geocoded, it can be saved to a new KML file. This file will contain the coordinates of each
address found. The second program, KMLReport, reads that file and generates two files: one for
geocoded addresses and one for addresses that were not found. The file for geocoded address is written as a comma delimited text file that can be loaded into ArcGIS.
At the moment it seems like obtaining a street view would require me to obtain the lat-long coordinates for the data, the append it to the Fusion Table.
Fusion has some advantages, including automatic publishing to the web, the ability to easily update table data, and for “collaborative data entry.” I can see some potential applications for my neighborhood organization, or any other collaborative group with limited access to mapping technology (especially a library system or other local municipality that does not have thousands of dollars to spend on ESRI software).