viHistory

INSERT INTO "location" VALUES (99, 'BC', 'British Columbia', '13', 'Victoria City', '23', 'Humboldt', NULL, NULL, NULL, NULL, NULL, '1911', NULL, NULL); 

INSERT INTO "location" VALUES (98, 'BC', 'British Columbia', '13', 'Victoria City', '17', 'James Bay North', NULL, NULL, NULL, NULL, NULL, '1911', NULL, NULL); 

PD sent me the data for SD19 and SD22, both of which are sub-districts covering people living on ships docked at the Victoria harbour. All data imported successfully along with a handful of new occupations.

Received the data for Rockland-Foul Bay (SD 12) from PD yesterday and imported today, along with a handful of new occupations.

INSERT INTO "location" VALUES (95, 'BC', 'British Columbia', '13', 'Victoria City', '12', 'Rockland-Foul Bay', NULL, NULL, NULL, NULL, NULL, '1911', NULL, NULL); 

Received Fernwood-Fort Street from PD and imported. Large dataset of around 3400 records. Added in some new occupation codes.

The loader app is showing its limitations when handling large files such as this one. It could use a rewrite, since it was originally designed for Access files with only cursory support for CSVs. But with so much data already in it's probably not worth the effort right now.

INSERT INTO "location" VALUES (94, 'BC', 'British Columbia', '13', 'Victoria City', '9', 'Fernwood-Fort Street', NULL, NULL, NULL, NULL, NULL, '1911', NULL, NULL); 

Received three datasets from PD: Gorge-Douglas (SD2), Hillside-Douglas (SD6), and Quadra-Harris Green (SD21). All imported into development database with a bunch of new occupations, races, nationalities, origins, and religions.

INSERT INTO "location" VALUES (91, 'BC', 'British Columbia', '13', 'Victoria City', '2', 'Douglas-Gorge', NULL, NULL, NULL, NULL, NULL, '1911', NULL, NULL); 

INSERT INTO "location" VALUES (92, 'BC', 'British Columbia', '13', 'Victoria City', '6', 'Hillside-Douglas', NULL, NULL, NULL, NULL, NULL, '1911', NULL, NULL);

INSERT INTO "location" VALUES (93, 'BC', 'British Columbia', '13', 'Victoria City', '21', 'Quadra-Harris Green', NULL, NULL, NULL, NULL, NULL, '1911', NULL, NULL); 

Received new versions of the Central Park and Vic West datasets from PD. Imported succesfully to development website.

Received Hillside-Quadra data from PD and imported successfully to development database/website.

INSERT INTO "location" VALUES (90, 'BC', 'British Columbia', '13', 'Victoria City', '7', 'Hillside-Quadra', NULL, NULL, NULL, NULL, NULL, '1911', NULL, NULL); 

Three data sets as noted in title imported into development website successfully.

INSERT INTO "location" VALUES (87, 'BC', 'British Columbia', '13', 'Victoria City', '25', 'James Bay', NULL, NULL, NULL, NULL, NULL, '1911', NULL, NULL); 

INSERT INTO "location" VALUES (88, 'BC', 'British Columbia', '13', 'Victoria City', '24', 'James Bay Southeast', NULL, NULL, NULL, NULL, NULL, '1911', NULL, NULL); 

INSERT INTO "location" VALUES (89, 'BC', 'British Columbia', '13', 'Victoria City', '18', 'James Bay Southwest', NULL, NULL, NULL, NULL, NULL, '1911', NULL, NULL);