21/06/17

Permalink 04:32:59 pm, by mholmes, 29 words, 12 views   English (CA)
Categories: Activity log; Mins. worked: 120

Work on mapping of obsolete/obscure kanji

Yesterday and today, working with SA on his TEI abstract; we now have a more sophisticated approach to the obsolete kanji and their modern equivalents, encapsulated in the ODD.

19/06/17

Permalink 12:50:34 pm, by mholmes, 26 words, 20 views   English (CA)
Categories: Activity log; Mins. worked: 40

XQuery to generate list of ja owners

At AK's request, wrote some XQuery to extract a list of Japanese owners who were the last owners of a property prior to the dispossession date.

Permalink 12:49:44 pm, by mholmes, 20 words, 19 views   English (CA)
Categories: Activity log; Mins. worked: 40

Created new copy db for Powell St

Per request from AG, created a new test db copied from Powell St but basically empty, for error-checking duplicate insertions.

01/06/17

Permalink 09:08:13 am, by mholmes, 267 words, 12 views   English (CA)
Categories: Activity log; Mins. worked: 60

Extinguished properties added to Vancouver db

After a lengthy discussion and agreement, I've added the same "extinguished properties" feature to the Vancouver db as exists in the Maple Ridge db. SQL:

DROP TABLE IF EXISTS `titles_to_ext_properties`;
CREATE TABLE IF NOT EXISTS `titles_to_ext_properties` (
  `tte_tte_id` int(11) NOT NULL auto_increment,
  `tte_prop_id_fk` int(11) NOT NULL,
  `tte_title_id_fk` int(11) NOT NULL,
  PRIMARY KEY  (`tte_tte_id`),
  KEY `tte_prop_id_fk` (`tte_prop_id_fk`,`tte_title_id_fk`),
  KEY `tte_title_id_fk` (`tte_title_id_fk`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

ALTER TABLE `titles_to_ext_properties`
  ADD CONSTRAINT `titles_to_ext_properties_ibfk_1` FOREIGN KEY (`tte_prop_id_fk`) REFERENCES `props` (`prp_property_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `titles_to_ext_properties_ibfk_2` FOREIGN KEY (`tte_title_id_fk`) REFERENCES `titles` (`ttl_title_id`) ON DELETE CASCADE ON UPDATE CASCADE;

Additions to local_classes.php:

//In title class, before preceding titles field:
$this->addField(new MdhOneToManyField('ttl_ext_properties', 'Extinguished properties',
                                'ttl_title_id', 
                                'props',
                                'prp_property_id',
                                'prp_desc',
                                'titles_to_ext_properties',
                                'tte_tte_id',
                                'tte_title_id_fk',
                                'tte_prop_id_fk',
                                true, 'prp_desc', true));
//In properties class, before related properties field:
$this->addField(new MdhOneToManyField('own_extinguishing_titles', 'Extinguished by titles',
                                'prp_property_id', 
                                'titles',
                                'ttl_title_id',
                                'ttl_desc',
                                'titles_to_ext_properties',
                                'tte_tte_id',
                                'tte_prop_id_fk',
                                'tte_title_id_fk',
                                true, 'ttl_desc', true));

Tested in dev, rolled out to live, awaiting any anomaly reports from the RAs in the field.

26/05/17

Permalink 03:35:54 pm, by mholmes, 65 words, 17 views   English (CA)
Categories: Activity log; Mins. worked: 60

Extinguishing titles

Long and confusing email discussion about the difficulties in entering data about titles extinguishing properties, especially when moving backwards through title records; you end up having to re-edit a later title you've already entered when you discover from an earlier title that it actually extinguished some lots. I don't see a good technical solution to this as yet, but something may emerge from the discussions.

25/05/17

Permalink 05:02:46 pm, by mholmes, 17 words, 13 views   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, 13 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, 13 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, 22 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, 14 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.

<< Previous Page :: Next Page >>

Landscapes of Injustice

Reports

XML Feeds