Final draft Visualization – Part 2
YOU MUST READ THE PART ONE RECAP FIRST so you know where I am going with things.
For starters, HERE IS THE REVISED AND COMPLETED MAP ON GOOGLE MAPS – Mad River Cemeteries.
A screen shot is a little harder for this one, so it’s best to just VISIT THE LINK. and poke around but here’s the idea:
When you click on a marker, it will give you the lat/long (in some cases, and they are noted, I had to approximate the location based on directions given so some may not be exactly right – I welcome any corrections, please comment) and other information such as whether it is still there, how many burials if known, condition, etc. There are only three cemeteries still in use today – Myrtle Tree, Nettle Creek, and Terre Haute. Myrtle Tree and Nettle Creek also had churches associated with them. (So did many of the family cemeteries including Shaffer and Zerkle, but that is for another project.)
I had a little fun with the markers, don’t hold it against me. I did color code Shaffer, Zerkle, and Terre Haute to correspond with my NodeXL relationship charts.
And that brings me to the NodeXL charts I created.
The above two NodeXL charts show the relationships between the people in each cemetery (connections) and where they are buried (color). Corresponding colors in each indicate which families are related. As I said before in my first test, these won’t work for a larger data set so that is why I didn’t include one for Terre Haute. It is the largest cemetery and there is no way I could represent it in a NodeXL file. You can see some of the relations are indicated above in Orange.
The two NodeXL charts above show the relationships between the people buried in the cemetery and between those buried across the cemeteries. The colors indicate relationships. You can see the two largest families are the George and Catherine (Roush) Zirkle families (indicated by aqua) and the Abraham and Margaret (Maurer) Zirkle families (indicated in blue – not exactly the same color blue, oops. It’s a royal blue in the Shaffer cemetery and a dark blue in the Zerkle cemetery). Incidentally, George and Abraham were brothers.
The above cluster was just something I used in the analyzation section of NodeXL. I love how it came out but I don’t know how I did it. It shows the different family relations in the Zerkle cemetery. The program chose the colors, so they really don’t indicate anything other than a family relationship. I tried to repeat it in the Shaffer cemetery but couldn’t. You can see how this would never work for a larger data set, it’s almost too much here.
So there we go. I’ve visualized until my eyes were ready to pop out. I welcome feedback. If anyone can tell me how to do a relationship chart for a really BIG set of data, please let me know!