Sunday afternoon Genealogy Fun

Sunday Afternoon Genealogy Fun – How Many Place Names in Your Family Tree Database

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

place statistics
There is also an option in the Legacy Statistics to create a graph.

most popular 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.

new location report

I then created a pivot table, to get the total for each place

top 10 places

I then created a Chart for the top 10 places

top 10 places spreadsheet

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.