Each week on Randy Seaver’s Genea-musings blog he has a post for Saturday night Genealogy fun. Because of the time difference, I have called my series Sunday Afternoon Genealogy Fun. This week the mission was:
1) Go into your Genealogy Management Program (GMP; either software on your computer, or an online family tree) and figure out how to Count how many places (e.g., towns, counties, states, countries) you have in your family tree database.
2) Tell us which GMP you’re using and how you did this task.
3) Tell us how many place names are in your database and, if possible, which Place has the most entries. If this excites you, tell us which surnames are in the top 5! Or 10!! Or 20!!!
4) Write about it in your own blog post, in a comment to this blog post, in a status or comment on Facebook, or in Google Plus Stream post.
I also used the Statistics feature in Legacy to come up with the top 9 locations
I include place details, such as cemeteries, in my place names, which is why the Necropolis Springvale and Fawkner Crematorium appear in my top 9 locations.
Since I include Place Details in my Location field, I wanted to see what the results would be if I removed those place details. To do this, I ran a Location Report in Legacy, copied the report to Microsoft Excel, and then manipulated the data in the report to generate a new location list.
I then created a pivot table, to get the total for each place
I then created a Chart for the top 10 places
By merging this way, I now had only 2225 unique locations.
In comparing the two sets of statistics, I’m not sure manipulating the data in Excel was worth the time it took. The Legacy statistics lists the number of events the location is linked to, while the Location Report creates a summary on the number of individuals the location is linked to, so there is a discrepancy between the two.