Ontario Cemetery Finding Aid Query
This tool is an alternate and unauthorized interface to an old copy of the database maintained at Ontario Cemetery Finding Aid.
Specifying simple text, comprising letters and spaces, matches against any names containing that text. "Hill" or "hill" or "HILL" will match "Hillcrest" and "Anything Hill" as well as the simple "Hill".
Specifying simple text, comprising letters and spaces, matches against any names containing that text. "John" or "john" or "JOHN" will match "Johnathan" and "William John" as well as the simple "John".
This is an extended regular expression, as supported by MySQL, There are too many options to enumerate here, but a few examples include:
- If you want to match just the name "John", excluding names that include "John" as part of them, enter "^John$".
- Enumerators often use unusual spellings of names. For example if you want to match names including both "Henry" and "Henery", enter "Hen.*ry".
This field is used to specify text to look for in the surname of the person getting married. If the value contains only letters and spaces then only surnames that match exactly (except for case) are found. Otherwise this uses regular expression pattern matching. For example to match surnames starting with "McL..." and ending with "...n", such as "McLean", "McLain", "McLennan", or "McLellan" you could specify "^McL.*n$".
The meaning of this field changes if the Soundex option is selected.
The Soundex code has been used for decades to attempt to match names that sound similar. For example it is used by police forces to perform a rough match for the names of drivers. It is a problematic tool, as it is based upon the phonetics of British surnames. If you select Soundex then the search is made for surnames that "sound like" the given surname. For example specifying Soundex together with "McLean" will match all of the surnames in the pattern match example under "Surname", but many other names as well, such "McCallum", "McAllan", "McClain", and "McWilliams".