Permalink 04:17:04 pm, by mholmes, 494 words, 13 views   English (CA)
Categories: Activity log; Mins. worked: 60

Deep dive on possible missing titles

Did some archaeology on the apparent missing titles from Powell St and reported as follows:

My backup of the database from September 2014 (when I think we were just creating it) contains a total of 3489 titles, including those for B43 L2. The next backup, from November, has only 1513 titles, so nearly 2,000 were deleted.

This was planned. These are my notes from our discussions and our action at the time:

October 3:
Met with JSR and SF to discuss refining data in the LTD. First, we create a new duplicate of the existing db. SF will generate a list of known-good titles (in that they've been fully edited using the final protocols). I'll then generate lists of titles that don't match that set, which will be candidates for deletion; she will check those. Then we delete those. Then we generate lists of now-unlinked people (owners and sellers), other documents, and legal descriptions, which again are assessed as candidates for deletion.

October 14:
SF and I have been working on generating and checking lists of records which we believe can be deleted from the db. I've made a landscapes_backup db and cloned the current content into it before we start deleting; it looks like we'll be removing over 2,000 title records, but we're still doing some checking; then we'll remove associated unlinked items.

October 17:
Did a number of planned deletions, and then some additional work identifying now-unlinked owners; there are 2713 which could be deleted. Many of these are additions by the recent research team, which were added, but whose titles were then mistakenly linked to earlier identical or similar entries. SF is now analysing this situation, and we will eventually prune all the unwanted owners from the system. Then comes the issue of identifying and linking or merging owners we believe to be the same person.

October 27:
Generated lists of owners who were previously connected to Block 43 and 52, so that they can be eliminated from the db if they're now no longer connected to anything else. SF is doing this work.

November 7:
SF and I worked through a lot of different approaches to confirming that no useful data was deleted during our cleanup. We have plausible explanations for all but 32 of the orphaned owners; and we have identified about ten titles which were deleted by editors during the summer work period; these must have been purposefully deleted around the time they were created -- they never got saved into a backup -- so they must have been erroneously entered. I think these are the plausible explanation for the orphaned owners.

In the process I added a new titles as seller field to the owners table, and we confirmed the consistency of data in lots of other respects, so we're looking good.

So we know these deletions were intentional, they were carefully checked, and they seem to have been primarily associated with blocks 43 and 52. If the intention was that these titles should be re-captured, that apparently never happened. 


Permalink 04:51:14 pm, by mholmes, 46 words, 12 views   English (CA)
Categories: Activity log; Mins. worked: 60

Work on character encoding

Email discussion with NH about approaches to obscure, old and obsolete characters; I've adopted a couple of the ideas that resulted into the schema, and elaborated some of the existing descriptors we have. We're slowly getting towards an understanding of how best to approach these oddities.

Permalink 04:43:55 pm, by mholmes, 77 words, 13 views   English (CA)
Categories: Activity log; Mins. worked: 60

Powell St: possible missing titles?

AC has listed a number of lots which appear in the titles db but are not linked to titles. A deep dive on one of them shows that it was linked to a number of titles in the database that pre-dates the Landscapes project; those titles go back to 1949. We don't yet know whether there is lost or missed data in the current version of the db, or whether these cases are omitted for some specific reason.


Permalink 04:43:08 pm, by mholmes, 57 words, 11 views   English (CA)
Categories: Activity log; Mins. worked: 60

Powell St mapping

Spent some time discussing issues arising out of the Powell St data and db with AC, as she's getting started on it. Looks like some of the work done by the GIS team can be re-purposed. Generated a list of properties from the db which are linked to titles (many aren't, I think for project history reasons).


Permalink 08:49:10 am, by mholmes, 33 words, 10 views   English (CA)
Categories: Activity log; Mins. worked: 45

Protocol doc for Maple Ridge geomapping

AC has produced an excellent protocol doc for the mapping, which I've read through and commented. I'm beginning to understand the process a bit better, but there are still gaps in my knowledge...


Permalink 04:17:53 pm, by sarneil, 117 words, 19 views   English (CA)
Categories: Activity log; Mins. worked: 150

map NNM DB fields to RAD ATOM fields

Spent couple of hours with KJ working out how to map fields from the NNM csv output to fields conformant with the RAD standard for input to AtoM. More or less completed the collection, series and file levels, started on the item level.
To be researched further:
- external links to jpgs (vs uploading into db as digital objects
- create authority record for Mr. Sato and figure out how to link to it.
- check RAD spec for any constraints on e.g. identifier values, or syntactic requirements

csv import documentation for AtoM 2.1 at https://www.accesstomemory.org/en/docs/2.1/user-manual/data-templates/rad-template/#template-description

RAD specification at http://www.cdncouncilarchives.ca/RAD/RAD_Chapter01_July2008.pdf


Permalink 02:55:53 pm, by mholmes, 92 words, 22 views   English (CA)
Categories: Activity log; Mins. worked: 240

Meeting and decisions; paper draft 3 done

Met with JSR and RRR to discuss the geo-reffing of the Maple Ridge plans. Decisions are in my notes; the basic idea is to use the identifiers from the land titles db properties table for the GIS polygons. I started examining how well our data fits with the key plans, and it's not a perfect fit at all. More work to be done here.

Finished draft three of the JAEH article, with additional material on multi-ethnicity in Japan suggested by JSR based on something in EO's paper. That's now back with JSR.


Permalink 04:32:59 pm, by mholmes, 29 words, 18 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.


Permalink 12:50:34 pm, by mholmes, 26 words, 25 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, 23 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.

<< Previous Page :: Next Page >>

Landscapes of Injustice


XML Feeds