1
vote
RESIDENCE conversion to CENSUS
I would like a tool that would convert Residence facts that contain "census" in the related source/citation to a Census fact. I do not like the decisions by Ancestry, FamilySearch, etc. to just lump these events as "residence" A census connotes a level of legal mandate (think "A decree went out from Ceasar…") that has more force than a simple statement that "Mr. Jones resided at…". Also, folks who were enumerated in jails or state hospitals on the date of a census would hardly think that those were their "normal" residences.
I prefer to use the Residence in a more general fashion such as their home at death, marriage, and so forth.
Dan C. Mohn shared this idea
There are a couple of partial solutions:
– a SQLite script by me published here: Facts – Change Fact Type #facttypes #events #rm8
– one of Richard Otter’s python utilities: Convert Fact
Neither, however, can filter on only those Residence facts that have a Census source. That would be an additional constraint requiring additional coding.
To design the constraint, we would need to know which field in your database can be relied upon to find the term “census”. Is it the Citation Name, or the Source Name? Those are the easiest. A citation sentence template field might be more complicated.
I’ve adapted my script referenced above and the OP has used it successfully. I may publish it after possibly generalising it to use with SQLite Expert for any pair of fact types and any text string in a Source field. Also trying to make the same script default to Residence => Census conversion when “census” is found in the Source and when executed by SQLiteSpy which does not support runtime variables.