25/05/17

Permalink 05:02:46 pm, by mholmes, 17 words, 1 view   English (CA)
Categories: Activity log; Mins. worked: 200

Finished second draft of article

Responded to all JSR's comments, added some additional sections, and reformatted to fit the journal submission guidelines.

24/05/17

Permalink 09:01:18 am, by mholmes, 59 words, 3 views   English (CA)
Categories: Activity log; Mins. worked: 60

Maple Ridge DB: new field and updated triggers

Per AG's request, added a new Range field to the property table, reconfigured the triggers to take account of it, and then updated all the desc fields (since we also made a small change in April). Code used is in the repo as trigger_update_2017-05.txt; tested on dev then run on live. Backups taken before and after.

23/05/17

Permalink 05:15:02 pm, by mholmes, 15 words, 4 views   English (CA)
Categories: Activity log; Mins. worked: 120

Working on second draft of article

Responding to all JSR's notes and doing a few other tweaks. I'm about half-way through.

11/05/17

Permalink 12:49:10 pm, by mholmes, 27 words, 9 views   English (CA)
Categories: Activity log; Mins. worked: 20

Maple Ridge: surfaced the Location setting

I've now revealed (through local_classes.php) the location table and associated location field in the props table, so the team can enter properties from other locations.

26/04/17

Permalink 10:21:36 am, by mholmes, 499 words, 9 views   English (CA)
Categories: Activity log; Mins. worked: 30

Maple Ridge db: new triggers

I've slightly modified the triggers for the Maple Ridge dbs on AG's instructions, to add block info into the description used for dropdowns:

DROP TRIGGER IF EXISTS `landscapes_mapridgelive`.`prp_desc_insert`;
DELIMITER //
CREATE TRIGGER `landscapes_mapridgelive`.`prp_desc_insert` BEFORE INSERT ON `landscapes_mapridgelive`.`props`
 FOR EACH ROW BEGIN
  DECLARE next_id INT;
  SET next_id = (SELECT `AUTO_INCREMENT` FROM `information_schema`.`TABLES` WHERE `TABLE_SCHEMA`=DATABASE() AND `TABLE_NAME`='props');
	SET NEW.`prp_desc` = 
	concat(
          IF (NEW.`prp_township` != '', concat('T:', LPAD(NEW.`prp_township`, 5, '0'), ' '), ''),
          IF (NEW.`prp_district` != '', concat('DL:', LPAD(NEW.`prp_district`, 5, '0'), ' '), ''),
          IF (NEW.`prp_section` != '', concat('S:', LPAD(NEW.`prp_section`, 5, '0'), ' '), ''),
          IF (NEW.`prp_block` != '', concat('B:', LPAD(NEW.`prp_block`, 5, '0'), ' '), ''),
          IF (NEW.`prp_quadrant` != '', concat('Q:', NEW.`prp_quadrant`, ' '), ''),
          IF (NEW.`prp_plan` != '', concat('PL:', LPAD(NEW.`prp_plan`, 5, '0'), ' '), ''),
          IF (NEW.`prp_sketch` != '', concat('SK:', LPAD(NEW.`prp_sketch`, 5, '0'), ' '), ''),
          IF (NEW.`prp_lot` != '', concat('L:', LPAD(NEW.`prp_lot`, 5, '0'), ' '), ''),
          IF (NEW.`prp_parcel` != '', concat('PC:', LPAD(NEW.`prp_parcel`, 5, '0'), ' '), ''),
          IF (NEW.`prp_acreage` != '', concat('A:', NEW.`prp_acreage`, ' '), ''),
          IF (NEW.`prp_exception` != '', 'EX', ''),
          ' (#', next_id, ')'
        );
END
//
DELIMITER ;
DROP TRIGGER IF EXISTS `landscapes_mapridgelive`.`prp_desc_update`;
DELIMITER //
CREATE TRIGGER `landscapes_mapridgelive`.`prp_desc_update` BEFORE UPDATE ON `landscapes_mapridgelive`.`props`
 FOR EACH ROW BEGIN
	SET NEW.`prp_desc` = 
	concat(
          IF (NEW.`prp_township` != '', concat('T:', LPAD(NEW.`prp_township`, 5, '0'), ' '), ''),
          IF (NEW.`prp_district` != '', concat('DL:', LPAD(NEW.`prp_district`, 5, '0'), ' '), ''),
          IF (NEW.`prp_section` != '', concat('S:', LPAD(NEW.`prp_section`, 5, '0'), ' '), ''),
          IF (NEW.`prp_block` != '', concat('B:', LPAD(NEW.`prp_block`, 5, '0'), ' '), ''),
          IF (NEW.`prp_quadrant` != '', concat('Q:', NEW.`prp_quadrant`, ' '), ''),
          IF (NEW.`prp_plan` != '', concat('PL:', LPAD(NEW.`prp_plan`, 5, '0'), ' '), ''),
          IF (NEW.`prp_sketch` != '', concat('SK:', LPAD(NEW.`prp_sketch`, 5, '0'), ' '), ''),
          IF (NEW.`prp_lot` != '', concat('L:', LPAD(NEW.`prp_lot`, 5, '0'), ' '), ''),
          IF (NEW.`prp_parcel` != '', concat('PC:', LPAD(NEW.`prp_parcel`, 5, '0'), ' '), ''),
          IF (NEW.`prp_acreage` != '', concat('A:', NEW.`prp_acreage`, ' '), ''),
          IF (NEW.`prp_exception` != '', 'EX', ''),
          ' (#', NEW.`prp_property_id`, ')'
        );
END
//
DELIMITER ;

I haven't yet updated all the old descriptions, since most of them don't have block info, but I'll do that when I have enough time to be cautious about it.

04/04/17

Permalink 04:52:48 pm, by mholmes, 13 words, 12 views   English (CA)
Categories: Activity log; Mins. worked: 240

Prep for interviews, interviews

Made a table to replace the diagram per JSR; conducted interviews; discussed outcomes.

03/04/17

Permalink 03:17:06 pm, by mholmes, 28 words, 11 views   English (CA)
Categories: Activity log; Mins. worked: 180

Prep for interviews, and JAEH readthrough

Read and annotated one of the JAEH articles, and also Skyped with JSR to prep for the interviews tomorrow; created a diagram to support one of the questions.

07/03/17

Permalink 04:46:15 pm, by mholmes, 54 words, 46 views   English (CA)
Categories: Activity log; Mins. worked: 90

Documentation for museum folks

The RBCM will be working on a public-facing edition of our land titles data, so I've put together an overview of the db and the data structure along with an EER diagram for them; waiting to hear back as to what they'd like us to do in terms of pre-processing or transforming the data.

21/02/17

Permalink 10:43:22 am, by mholmes, 147 words, 55 views   English (CA)
Categories: Activity log; Mins. worked: 120

Ethnicity assignment for Maple Ridge Land Titles owners done

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.

20/02/17

Permalink 02:13:34 pm, by mholmes, 7 words, 52 views   English (CA)
Categories: Activity log; Mins. worked: 240

First draft of JAEH article done

Sent it to JSR as a docx.

:: Next Page >>

Landscapes of Injustice

Reports

XML Feeds