Ethnicity assignment for Maple Ridge Land Titles owners done
Posted by mholmes on 21 Feb 2017 in Activity log
After using the Maple Ridge db as the case study for the article work, I've now done a final pass through all the results from the algorithm and generated SQL commands which have been run to add ethnicity for owners. These are the steps:
- Check all name lists manually. There were a couple of Indian names which were not picked up by the Lauderdale and Kestenbaum list process. Researched those, and a couple of other oddities.
- Generated SQL statements from the name lists. These are in three files in svn for the record.
- Copied live to dev db, and backed up live db.
- Uncommented the ethnicity field in the local_classes.php file in both databases and tested that the field is available.
- Ran SQL on dev db and tested results.
- Ran SQL on live db and tested results.
- Made a second backup of the live db.