IRA Project Update 10/28/13

I spent most of my weekend doing much the same thing I spent last week doing.  I decided it might be easier to create Excel spreadsheets with the information I needed for my work with Google Earth and ArcGIS and then use those to create the map files with which I wanted to work.  Turned out I was right.  Almost.

It’s fairly easy to create a list of town names that are associated in a spreadsheet with the names of the politicians that were either born in those places or represented them in Congress.  It’s also fairly easy to then upload that list onto a web service that will use Google Maps to find the coordinates of that location so that Google Earth and ArcGIS can find them.  It is then also fairly easy to use those coordinates to create a spreadsheet with all the information you need to create a Google Earth file and then convert it into a file format that ArcGIS can recognize.

When I discovered all this, I was fairly excited.  I was able to create a Google Earth map showing all of the birthplaces of the members of the 21st Congress that voted on the Indian Removal Act of 1830 and all of the districts they represented.  I was even able to put a link in the location marker description back to each of their individual biographies in the Congressional Biographical Directory, many of which contain portraits of the men in question.  I’m hoping I can include this map on my website to help visitors to the site visualize the individuals with which I’m dealing.

Again, all that was fairly easy.  A bit time-consuming and mind-numbing, but easy.  What was not easy was when all of the coordinates in my map of the congressmen’s district towns who voted against the Indian Removal Act somehow switched to the coordinates for their birthplaces.  It was also not easy when that somehow became the case for every single file and every single copy of those files that contained the information I needed.  Somehow, every version of every file I had that contained the coordinates for the districts of the congressmen who voted against the Indian Removal Act switched to the coordinates for their birthplaces.  Everything else stayed the same and was correct.  For no reason.  I had done nothing to prompt this course of events.

It was at this moment that I decided technology is black magic.


5 thoughts on “IRA Project Update 10/28/13

  1. I am really excited to see use of spacial information in your project. It could provide a lot of information about how the context of were a person was from impacted the choices to vote for Indians removal.

  2. Might you have inadvertently switched the axis when graphing in the Excel file? If so, it’s not difficult to remedy. I’ll be happy to show you how to fix it after class.

  3. I’m certain entering locations into a spreadsheet is mind-numbing, but I look forward to seeing the final outcome of this project and how the congressmen’s memories effected their voting patterns. Out of curiosity, was Google Earth easier to use than ArcGIS?

    • At first I thought Google Earth was easier in at least some respects than ArcGIS, but now I’ve found some online tools that you can use to find the coordinates for all of the locations you’ve typed into an Excel file and then convert the resultant file into something that ArcGIS uses so Google Earth isn’t really necessary at all. It’s nice in some respects I guess. For example, there’s a web gadget that allows you to post an interactive Google Earth map on your site. I’ve been toying around with that for a while and it seems like it could be of some use.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s