Preserving Old Ontario Barns in the On-Line World: Part 4 of 5, Creating an Informative Database
by Hugh Fraser
This blog appears throughout November and December 2020 with the following topics that build upon each other. They explore some reasons why barn databases may have failed in the past, how OBP is trying to find ways to make it simpler, and to enlist a small army of people to do the work. If something in the blog sparks your good ideas, leave us a message by adding your comment below.
Part 2 of 5: What’s an old barn, and why are they difficult to document?
Part 3 of 5: Creating a consistent database
Part 4 of 5: Creating an informative database
Part 5 of 5: Creating a secure, centralized and sustainable database
Databases are only as good as the information fed into them. There is objective data that is easier to describe with numbers such as measurements, or the number of a certain feature; subjective data that is more difficult to determine such as the profile of features, or the condition of a barn; and observational data that varies widely between barns such as carvings, dormers, lightning rods, etc. However, if data collectors are given many choices in drop-down menus on some simple software, good information should result.
For example, objective data might include queries about a barn’s outside length, width, wall height, etc. with drop-down menu options in increments of feet, or inches, because these barns were built before the metric system was adopted. Other objective data includes questions about sizes of beams, posts, other members, roof slopes, number of bents, etc.

Subjective data might include queries about a barn’s condition such as good, fair, poor, or in ruins, with drop-down menu options. Descriptive information would assist in making the correct choice.

Observational data includes those features one might find on the roof of a barn, or its walls, or inside. There are so many of these and they vary so widely, it can be overwhelming just to describe them. However, again, if drop-down menus of the observational data we already know about are included, data collectors can simply check them off as being present.

Next time, we will explore how to create a secure, centralized and sustainable database