23/05/17

Permalink 05:15:02 pm, by mholmes, 15 words, 3 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, 8 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, 8 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, 11 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, 45 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, 54 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, 51 views   English (CA)
Categories: Activity log; Mins. worked: 240

First draft of JAEH article done

Sent it to JSR as a docx.

17/02/17

Permalink 01:54:10 pm, by sarneil, 70 words, 50 views   English (CA)
Categories: Activity log; Mins. worked: 360

Report 4-1 completed

Lots of back and forth with SK at NNM to complete retrospective report on activities (Research, Dissemination, Training) in both parts of our cluster, and to set major milestones and budget for upcoming year. Also worked out location of student labour (almost all at NNM) and workflow and tasks for stuff project needs for integration with material developed by other clusters.
Submitted 2 documents to JSR for review by Executive Committee.

15/02/17

Permalink 03:39:59 pm, by mholmes, 34 words, 49 views   English (CA)
Categories: Activity log; Mins. worked: 180

First rough draft of article complete

Much polishing to do, and formatting/footnoting/referencing, but the bulk is done, and I've added a flowchart diagram which helps clarify things. I think it'll come in at about 25 pages at 12pt double-spaced.

:: Next Page >>

Landscapes of Injustice

Reports

XML Feeds