Archives for: April 2011

29/04/11

Permalink 04:09:03 pm, by Matthew, 1102 words, 108 views   English (CA)
Categories: Activity log; Mins. worked: 180

Revisions: Apollodorus 3.5.2-3.6.4

§ 3.5.3 - "event/character/citation" tab empty, check this **Added events from "event/place" tab to here citing proper characters**
- ID677, The ship Dionysus hired…and heads for Asia instead (change to "…and heads for Asia to sell him instead"?) "event/place" **Nevermind**
§ - Add event "People begin to honor the god Dionysus" (place "Nowhere") **Only added this to "event/character/citation" tab citing character: Dionysus**
§ 3.5.4 - "event/character/citation" tab empty, check this **Added events from "event/place" tab to here citing proper characters**
- ID685, Zeus sends Cadmus and Harmonia to the Elysian Fields (change to "Zeus turns Cadmus and Harmonia into serpents and sends them away to the Elysian Fields"?) "event/place" **Nevermind**
§ 3.5.5 - ID2688, Dirce is spouse of Lycus (4) (add vice versa) "character/character/citation"
§ - ID2691, ibid "character/character/citation"
§ - ID2737, Labdacus is mortal mother of Nycteis (delete record, this is inaccurate) "character/character/citation"
§ - ID1924-1926, Amphion and Zethus…throw her into a river (change to "…into a spring") "event/character/citation"
§ - ID709, ibid "event/place"
§ - ID1927, Dirce gives her name to the river in which she died (change to "Dirce gives her name to the spring…") "event/character/citation"
§ - ID710, ibid "event/place"
§ - Add event "Lycus and Nycteus fled Euboea for killing Phlegyas" (characters: Lycus, Nycteus, Phlegyas) "event/character/citation"
§ - ibid (place: Euboea) "event/place"
§ - Add event "Lycus and Nycteus move to Hyria" (characters: Lycus, Nycteus) "event/character/citation"
§ - ibid (place: Hyria) "event/place"
§ 3.5.6 - ID2696, Thebe is spouse of Zethus (add vice versa) "character/character/citation"
§ - ID660/1424, Ethodaia is the daughter of Amphion and Niobe (2) (text says "or, as some say, Neaera", add new record with this character's name as daughter of Amphion and another for Niobe (2)?) "character/character/citation" **Added Neaera (2) as daughter of Amphion and Niobe (2)**
§ - ID1963, Niobe leaves Thebes and goes to her father in Sipylus (character cited is "Sipylus", but text says "[Niobe] went to her father Tantalus at Sipylus", so should we change this to Tantalus (2) since he is not cited?) "event/character/citation" **Corrected, also changed character Tantalus to Tantalus (1) since there are two**
- ID1945-1946, Niobe says she is more blessed with children than Leto (text says "Latona" rather than Leto, change event and cited character to "Latona"?) "event/character/citation" **Please look into this, I am not sure since there is an entry for Leto and Latona. Ought we to keep both or should we use the Latinized version "Latona" for all entries instead?**
- ID723, ibid "event/place"
- ID1947-1949, Leto calls upon Apollo… (ibid) "event/character/citation"
- ID724, ibid "event/place"
- ID726, Apollo shoots down the men while they are hunting on Mt. Cithaeron (place cited is "Thebes" but should we change to "Mt. Cithaeron" instead?) "event/place" **Mount Cithaeron is not in the database**
- ID730, Niobe leaves Thebes and goes to her father in Sipylus (place cited is "Unknown" should we change to "Sipylus" instead?) "event/place" **Ibid**
- ID731, Niobe prays to Zeus and is turned into a stone that weeps (ibid) "event/place"
* 3.5.7 - ID669, Menoeceus is the mortal father of Jocasta (text says "some [say] that she was Epicasta", add a new record for Epicasta as the daughter of Menoeceus?) "character/character/citation"
- Add new record for Epicasta as the mortal mother of Oedipus? "character/character/citation" **Epicasta is not in the database**
- ID2675/2720, Jocasta is spouse of Laius & vice versa (add two new records with Epicasta as spouse of Laius & vice versa?) "character/character/citation"
- ID2009-2010, Laius marries Jocasta (also cite "Epicasta"?) "event/character/citation"
- ID2012-2013, Laius gets drunk and sleeps with Jocasta (ibid) "event/character/citation"
3.5.8 - ID1592-1595/2676/2734, also cite Epicasta? "character/character/citation"
- ID2039-2040, Oedipus unwittingly marries his mother (ibid) "event/character/citation"
- ID2042-2046, Oedipus begets Polynices, Eteocles… (ibid) "event/character/citation"
§ - ID2033, Hera sends the Sphinx to Thebes (also cite character: Sphinx) "event/character/citation"
§ - ID2037, Oedipus solves the riddle of the Sphinx (ibid) "event/character/citation"
* - ID749, Hera sends the Sphinx to Thebes (place: Thebes, should this say Mount Phicium instead? Text says "she sat on Mount Phicium") "event/place"
§ - Add event "Damasistratus rules Plataea" (character: Damasistratus, place: Plataea)
3.5.9 - Personal note: Colonus is in Attica
3.6
§ 3.6.1 - ID2681, Argia is spouse of Polynices (In ID2562 as well as in 1.9.17 she is Argia (1), however "Argia" has not been cited anywhere but here. We ought to make this change then delete the record for "Argia" so that way we have Argia (1) for this citation and Argia (2) who is unrelated.) "character/character/citation"
§ - Add record entry for: Adrastus (1) is mortal father of Deipyle & Argia (1) "character/character/citation"
- Add event "Polynices marries Argia" (characters: Polynices, Argia (1)) "event/character/citation" **Nevermind**
§ - ID2076, Polynices and Tydeus wear the boar and the lion… (character cited is Argia, change to Argia (1)) "event/character/citation"
§ - Add event "Tydeus fled from Calydon" (character: Tydeus) "event/character/citation"
§ 3.6.2 - "event/character/citation" tab is empty, check this **Added events from "event/place" tab citing proper characters**
§ - ID783, Polyncies begs Eriphyle to convince Amphiarous to go to war (correct spelling to "Polynices begs Eriphyle to convince Amphiaraus to go to war") "event/place" **Corrected spelling**
3.6.3 - Frazer's footnote #3 mentions Mecisteus as the brother of Adrastus as mentioned in 1.9.13, ought we to add Talaus as the mortal father of Mecisteus (1)? "character/character/citation"
* - Add Tydeus and Parthenopaeus (2) to group "Seven against Thebes" (there ought to be nine since text says "Some…do not reckon Tydeus and Polynices among them") "group/character/citation"
§ - ID2457, Parthenopaeus goes to war against Thebes (should this be "Adrastus musters an army and the Seven against Thebes" instead? If so, add characters: Adrastus (1), Capaneus, Eteoclus, Hippomedon, Mecisteus (1), Parthenopaeus (2), Polynices, and Amphiaraus) "event/character/citation" **Deleted event and replaced with "Adrastus musters an army…" and cited aforementioned characters**
* 3.6.4 - Add record for Hypsipyle as foster mother of Opheltes (check to see if this is accurate, text says "Hypsipyle showed them the way to a spring, leaving behind an infant boy Opheltes, whom she nursed, a child of Eurydice and Lycurgus") "character/character/citation"
§ - Add record for Lycurgus (2) as mortal father of Opheltes "character/character/citation"
§ - "event/character/citation" tab is missing many events, check this
§ - ID799-805, match verb tenses present/past "event/place"
§ - ID789, Hypsiple leads the Seven against Thebes to a spring (correct spelling to "Hypsipyle…") "event/place"
§ - ID793, Hypsiple becomes servant of Lycurgus (ibid) "event/place"

Permalink 02:28:53 pm, by mholmes, 5 words, 49 views   English (CA)
Categories: G&T Hours; Mins. worked: 0

MDH: 129 - 1 = 128 hours G&T

Leaving early. Hours are mounting.

28/04/11

Permalink 05:55:21 pm, by mholmes, 27 words, 58 views   English (CA)
Categories: G&T Hours; Mins. worked: 0

MDH: 127 + 2 = 129 hours G&T

Planning and administration for Calico is getting into high gear. I could actually have spent all day answering emails as they came in without a break today...

Permalink 05:54:09 pm, by mholmes, 84 words, 109 views   English (CA)
Categories: Activity log; Mins. worked: 60

Tried temporary tables instead of views

In breaks between workshop sessions, I tried to address the problem of the length of time queries are taking by using temporary tables constructed directly in the query instead of joining to views. The approach I took (joining to a temporary table created in the join clause) had no effect -- the query took exactly the same time. But there may be a way to create a temporary table once earlier in the query, and then join to it later. Still working on this.

Permalink 05:52:26 pm, by mholmes, 30 words, 65 views   English (CA)
Categories: Activity log; Mins. worked: 240

Volunteer training sessions

Did two training sessions today, including walk-throughs of actual rooms, and tours to Cadboro Commons. Also tested some ports and investigated storage options in Cad Commons (there are basically none).

Permalink 04:24:35 pm, by Matthew, 827 words, 134 views   English (CA)
Categories: Activity log; Mins. worked: 150

Revisions: Apollodorus 3.1.2-3.5.1

§ 3.1.2 - ID2551, Minos is spouse of Pasiphae (add vice versa) "character/character/citation"
§ - ID2706/2708, Crete is spouse of Minos (record is repeated twice, one of them should be changed to the opposite of the other) "character/character/citation"
§ - Add relationships for Pasiphae and Crete being the possible mothers of Minos' children: Catreus, Deucalion (2), Glaucus (2), Androgeus, Acalle, Xenodice, Ariadne, and Phaedra "character/character/citation"
§ - ID1664, Minos marries Crete or Pasiphae, has children (character cited is Glaucus (1), but in the relationships table it was Glaucus (2) that was cited as son of Minos, which Glaucus is correct?) "event/character/citation" **Changed to Glaucus (2)**
§ 3.1.3 - ID1672-1679, these records do not belong in 3.1.3, move to 3.1.4 "event/character/citation"
§ - ID622-625, ibid. "event/place"
- ID1670, Poseidon sends a bull to Minos…Minos neglects to sacrifice it. (change to "…Minos sacrifices a different bull, keeping the fine one in his herd"? to emphasize that he tried to trick Poseidon by making him think that he did sacrifice the fine bull when in fact he did not.) "event/character/citation"
- ID1670, ibid. (cite Poseidon in this event as well) "event/character/citation"
§ 3.1.4 - move aforementioned records to here
3.2
3.2.1 - ok
§ 3.2.2 - Aerope is spouse of Plisthenes, and vice versa (add) "character/character/citation"
§ - Clymene (1) is mortal mother of Palamedes and Oeax (add) "character/character/citation"
§ - ID2727/2730, these do not belong in 3.2.2 "character/character/citation" **Deleted citations for 3.2.2**
§ - ID636, does not belong in 3.2.2, move to 3.3.2 "event/place"
3.3
3.3.1 - ok
* 3.3.2 - ID1698-1700, Minos causes Polyidus to teach divination to Glaucus… (these events have no place listed, should we add "Crete" as the place?) "event/character/citation"
3.4
* 3.4.1 - ID637, Cadmus buries Telephassa, who died (place is listed as "Thrace", but text says: "When Telephassa died, Cadmus buried her, and after being hospitably received by the Thracians he came to Delphi…" should we therefore cite place as -UNSPECIFIED-? If so we ought to make a new event such as "Cadmus is received hospitably by the Thracians" with place being "Thrace") "event/place"
§ 3.4.2 - ID638, Cadmus is mortal father of Polydorus (1) (add Harmonia as god mother of Polydorus (1) also) "character/character/citation"
§ - ID2682, Aristaeus is spouse of Autonoe (4) (add vice versa) "character/character/citation"
§ - ID2690, Echion (3) is spouse of Agave (3) (add vice versa) "character/character/citation"
§ - ID1718-1719, Gods attends the wedding of Cadmus and Harmonia (change spelling to "Gods attend…", also Zeus and Europa are cited but not explicitly mentioned, just "all the gods", should we use Abas (1) instead?) "event/character/citation" **Deleted citations for Zeus and Europa and corrected spelling**
§ - ID644, Gods attends the wedding of Cadmus and Harmonia (change spelling to "Gods attend…") "event/place"
§ 3.4.3 - ID1761, Zeus turns Dionysus into a kid (Zeus is cited, add Dionysus to event as well) "event/character/citation"
- ID651, Giants born (not sure if this belongs in 3.4.3) "event/place"
§ 3.4.4 - ID654, Chiron trains Actaeon to be a hunter (this ought to be in the event/character/citation tab as well, with characters Chiron and Actaeon involved in the event) "event/place"
§ - ID655, Actaeon eaten by his dogs (ibid, with Actaeon involved in the event) "event/place"
§ - ID656, Actaeon sees Artemis bathing… (ibid, with Actaeon and Artemis involved in the event) "event/place"
3.5
§ 3.5.1 - ID662, Lycurgus is king of the Edonians (place is "-UNSPECIFIED-" but text says they dwell beside the river Strymon, should we change to reflect this?) "event/place"
§ - Add event "Proteus rules Egypt", character "Proteus", place "Egypt" **Unsure which Proteus to cite, so I cited Proteus (1). Double-check please**
§ - Add event "Dionysus hastens through Thrace against the Indians", character "Dionysus", place "Thrace"
§ - All the events in "event/place" tab should also appear in the "event/character/citation" tab. They are as follows:
§ - ID657, Dionysus discovers the vine (character: Dionysus)
§ - ID658, Hera drives Dionysus insane (characters: Hera, Dionysus)
§ - ID659, Dionysus roams around… (character: Dionysus, Proteus) **Also cited Hera**
§ - ID660, ibid (character: Dionysus)
§ - ID661, Dionysus purified of his insanity by Rhea… (characters: Dionysus, Rhea, also Cybela is in Phrygia for my personal reference)
§ - ID662, Lycurgus is king of the Edonians (character: Lycurgus (4))
§ - ID663, Lycurgus insults and expels Dionysus (characters: Lycurgus (4), Dionysus)
§ - ID664, Dionysus takes refuge in the Sea with Thetis (characters: Dionysus, Thetis)
§ - ID665 - ok
§ - ID666, Dionysus drives Lycurgus crazy (characters: Lycurgus (4), Dionysus)
§ - ID667, Lycurgus kills his son Dryas with an axe (characters: Lycurgus (4), Dryas (3), also add "in a fit of madness"?)
§ - ID668, Lycurgus chained up by the Edonians… (character: Lycurgus (4), Dionysus, also add "by the will of Dionysus"?)
§ 3.5.2 - "event/character/citation" tab is again empty, please look into this **Added events from "event/place" tab to "event/character/citation" tab, citing the proper characters**
- ID670, Dionysus wanders through (place "India", text says that Dionysus set up pillars there, should we change to "…and sets up pillars in India" to reflect this?) "event/place" **Nevermind**

Permalink 01:51:31 pm, by jamie, 47 words, 84 views   English (CA)
Categories: Notes; Mins. worked: 0

FrancoToile: the eXist rebuild

Starting an exploratory rewrite of FrancoToile with a pure eXist 1.5 architecture. Learning eXist along the way. Should be interesting. Not anticipating to be done for quite a while since this is my first-ever eXist site, and my first use of XQuery beyond simple functions in XSLT stylesheets.

27/04/11

Permalink 05:00:31 pm, by mholmes, 16 words, 64 views   English (CA)
Categories: G&T Hours; Mins. worked: 0

MDH: 126 + 1 = 127 hours G&T

Working to prep for volunteer training tomorrow, and get some last-minute changes done to Properties db.

Permalink 04:40:29 pm, by mholmes, 136 words, 99 views   English (CA)
Categories: Activity log; Mins. worked: 45

Cleaned up owners_full and examined mega-view data

Reworked VW_owners_full so that it includes more records and data (a regular join changed to a left join):

DROP VIEW IF EXISTS owners_full;

CREATE VIEW VW_owners_full AS 
(
SELECT owners.*,
owners_to_ethnicities.ote_ethnicity_id_fk,
ethnicities.eth_name,
owners_to_titles.ott_title_id_fk AS title_id,
titles.ttl_title_id,
titles.ttl_title_code,
titles.ttl_date
FROM owners_to_titles 
LEFT JOIN owners ON owners.own_owner_id = owners_to_titles.ott_owner_id_fk
LEFT JOIN titles ON owners_to_titles.ott_title_id_fk = titles.ttl_title_id
LEFT JOIN owners_to_ethnicities ON owners.own_owner_id = owners_to_ethnicities.ote_owner_id_fk 
LEFT JOIN ethnicities ON owners_to_ethnicities.ote_ethnicity_id_fk = ethnicities.eth_ethnicity_id
order by owners.own_surname
)
Permalink 03:53:40 pm, by Matthew, 1594 words, 110 views   English (CA)
Categories: Activity log; Mins. worked: 210

Revisions: Apollodorus 2.5.10-3.1.1

§ 2.5.10 - ID1989/2214, Echidna and Poseidon are god parents of 'an immortal dragon' (if this is referring to Orthus, then can we delete these 2 records? There is no specific mention in 2.5.10 of a dragon borne to Echidna and Poseidon) "character/character/citation" **Moved to 2.5.11**
- ID1342, Hercules puts up pillars (would it be ok to be more specific here, "at the boundaries of Europe and Libya [is this modern day Gibraltar-ish area?]") "event/character/citation" **Nevermind**
§ - ID2622-2623, A bull from Geryon's herd escapes Hercules (Apollo and Hyacinth (1) are mentioned as being involved in this event, but I cannot find them in the text, please clarify) "event/character/citation" **Deleted Apollo & Hyacinth from this event**
§ 2.5.11 - Typhon and Echidna are god parents of the 'immortal dragon' with a hundred heads (add relationships?) "character/character/citation" **Already done**
§ - ID450, Emathion is son of [blank] (change father to "Tithonus"?) "character/character/citation" **Deleted this record, added citation to ID2766 which already cited relationship**
- Should we add an event "Hercules is ordered to do an eleventh labor, fetching golden apples from the Hesperides, since Eurystheus did not acknowledge two of Hercules' labours"?
- ID1395, Phrasius advises the Egyptians to make human sacrifices to Zeus (should this be changed to reflect that in particular strangers were sacrificed, and that Phrasius himself was the first to be sacrificed?) "event/character/citation"
§ - ID1396, Hercules steals a cow and eats it (text says he sacrificed a bullock, or young bull, should this say "bull" instead?) "event/character/citation"
§ 2.5.12 - ID1418-1419, Hercules goes to be initiated (Hercules and Eumolpus (1) are noted, should we also add Pylius? Text says "since [Hercules] proposed to be initiated as the adoptive son of Pylius") "event/character/citation"
2.6
2.6.1 - ok
2.6.2 - Add event "Hercules gets an oracle by himself, which declares that to be free of disease he must be sold, and serve for three years"?
2.6.3 - ID1461-1462, Tmolus rules Lydia, Omphale takes over after he dies (text says "…Omphale, daughter of Iardanes, queen of Lydia, to whom at his death her husband Tmolus had bequeathed the government", change to say "Tmolus rules Lydia with Omphale, after her father Iardanes dies and bequeathes Lydia to Tmolus"?) "event/character/citation" **Please double-check this, I am unsure about it**
§ - ID523, ibid. (change location of event to "Lydia"?) "event/place"
§ - ID1471, Hercules buries Icarus (Hercules is involved in this event, add Icarus also?) "event/character/citation"
§ - ID1475, Hercules musters a group of volunteers to sail to Troy (doesn't belong in 2.6.3, move to 2.6.4) "event/character/citation"
§ - ID532, ibid. "event/place"
§ 2.6.4 - Add Podarces as son of Laomedon (1)? Also, Podarces is referred to as Priam in the text, add Priam as son of Laomedon (1) also?
§ - ID85/499, Hercules' expedition to Ilium (Oicles and Telamon are part of this group, but not Hercules, add?) "group/character/citation"
* - Hercules thanks Telamon by giving him Hesione as a prize, does this mean that she is his spouse? Please clarify, also for future references of spoils of war if humans are taken does that make them spouses or slaves, or both? I suppose context will be very important in issues like this.
2.7
2.7.1 - ok
2.7.2 - ok
§ 2.7.3 - ID547, Hercules attacks the Lacedaemon with Cepheus… (change to "Hercules attacks Lacedaemon…"?) "event/place" **Also added this to the "event/character/citation" tab and cited characters: Hercules, Cepheus (4), Hippocoon (2), Icarius (1), Tyndareus (2), Iphicles, Dorycleus, Scaeus, Enarophorus, Eutiches, Bucolus (2), Lycaethus (1), Tebrus, Hippothous (2), Eurytus (5), Hippocorystes, Alcinus, Alcon. This is already cited in 3.10.5 so I added citations for 2.7.3 as well**
§ 2.7.4 - ID554, A bull from Geryon's herd escapes Hercules (does not belong in 2.7.4) "event/place" **Deleted**
2.7.5 - ok
* 2.7.6 - ID466, Architeles is mortal father of Eunomos (Frazer's footnote says that his name is "variously given as Eunomus, Ennomus, Eurynomus, Archias, Cherias, and Cyathus", if we use Eunomus should we change spelling? Also, text doesn't explicitly name the victim, other than he was a kinsman of Oeneus and son of Architeles) "character/character/citation"
- ID1546-1548, Hercules accidentally kills Eunomos… (ibid., change to "Hercules accidentally kills son of Architeles/Eunomus…"?) "event/character/citation"
- ID564, Nessus ferries Deianira across the river… (place is cited as "Lycormas", but text says "he came to the river Evenus", change to "Evenus"?) "event/place"
§ 2.7.7 - ID1553-1554, Hercules eats on of Thiodamas' bullocks (change spelling to "Hercules eats one of Thiodamas' bullocks"?) "event/character/citation"
§ - ID1557-1560, Hercules fights with Aegimius against the Lapiths, Hercules kills Coronus, kills Dryopes and his children (change to "…kills Laogoras, king of the Dryopes and his children"?) "event/character/citation" **Changed spelling to: "Hercules fights with Aegimius against the Lapiths. Hercules kills Coronus, and kills Laogoras, king of the Dryopes and his children"**
§ - ID1563-1564, Hercules kills Amytor (change spelling to "Amyntor"?) "event/character/citation
* 2.7.8 - ID1414, Eury… is mortal mother of Teleutagoras (the record and text say "Eury…" is the mother, are there any other sources that give the name or is it no longer legible?) "character/character/citation"
§ - ID1381, Exole is mortal mother of Erythas (text says "Erythras", change?) "character/character/citation" **Changed character "Erythas" to "Erythras"**
* - Text mentions Hercules bore "by Anthea …", is this also lost or do we know if any other sources mention whom Hercules had with Anthea?
- I just noticed now that there are 2 entries for "Omphale", but they are not named Omphale (1) and Omphale (2) like other characters, should we check this to see if it needs to be done, or are they supposed to be the same Omphale?
§ - ID1408, Chalciope (2) is mortal mother of Thetallus (text says "Thettalus", change?) "character/character/citation" **Changed character "Thetallus" to "Thettalus"**
2.8
* 2.8.1 - Text says "the Athenians bore the brunt of war with Eurystheus, and slew his sons, Alexander, Iphimedon, Eurybius, Mentor and Perimedes. Eurystheus himself fled in a chariot…" but the records for character/character/citation state that Hercules is the father of these men. Is Eurystheus the father? It would make more sense in the context of the passage. If so, many of the records under 2.8.1 need to be changed to reflect this.
§ - Hercules/Eurystheus is mortal father of Mentor (add?) "character/character/citation" **Cited Hercules as mortal father of Mentor**
- ID1594-1595, Hyllus kills Eurystheus, cuts off his head (add "and gives it to Alcmena"?, add Alcmena as a character involved in said event also?) "event/character/citation" **Nevermind**
§ - ID1586-1591, Hercules sons, pursued from Trachis by Eurystheus…Eurystheus and his sons are killed (change to "Hercules' sons…Eurystheus and Hercules' sons are killed"?) "event/character/citation" **Changed to "Hercules' sons, pursued from Trachis by Eurystheus, take sanctuary at the altar of Mercy. Eurystheus goes to war with the Athenians, Eurystheus and his sons are killed.", also quoted Mentor in this event**
§ - ID581, Hylllus gives Eurystheus' severed head with weaving pins, who gouges out the eyes (correct spelling and change to "Hyllus gives Eurystheus' severed head to Alcmena, who gouges out the eyes of the head with weaving-pins"?) "event/place"
2.8.2 - Text mentions the Heraclids at this point, but they are not a group in the database. Should we create a group of the Heraclids?
- ID1596-1597, The sons of Hercules conquer the Peloponnese… (should we change to "The sons of Hercules, the Heraclids, conquer the Peloponnese…"?) "event/character/citation"
- Add event "The Heraclids quit the Peloponnese and dwell in Marathon", place "Marathon"?
§ 2.8.3 - ID1610, Heraclids fight for the Peloponnese… ("Tismaneus" is involved in this event, but he should be corrected in spelling to "Tisamenus") "event/character/citation" **Changed character to "Tisamenus"**
§ 2.8.4 - ID1613-1616, Temenus, Procles,Eurysthenes and Cresphontes draw lots… (add space after comma "..Procles, Eurysthenes…") "event/character/citation"
§ 2.8.5 - ID2686, Deiphontes is spouse of Hyrnetho (add vice versa) "character/character/citation"
§ - ID2693, Merope (3) is spouse of Cresphontes (ibid) "character/character/citation"
§ - ID2694, Merope (3) is spouse of Polyphontes (1) (ibid) "character/character/citation"
§ - Add event "founders of Argos find a toad" (place "Argos") "event/place" **Also cited character: Temenus**
§ - Add event "founders of Lacedaemon find a serpent" (place "Lacedaemon") "event/place" **Also cited characters: Eurysthenes, Procles**
§ - Add event "founders of Messene find a fox" (place "Messene") "event/place" **Also cited character: Cresphontes**
§ - ID1626, Cresphontes murdered with two of his sons, and usurped (change to "usurped by Polyphontes"? Also, cite Polyphontes as well for this event?) "event/character/citation"

BOOK 3
3.1
3.1.1 - ID2638, Telephassa is spouse of Agenor (3) (add vice versa) "character/character/citation"
*§ - ID431, ID608-609, Europa is mortal father of Minos/Sarpedon (2)/Rhadamanthys (Europa must be a mother, is she god mother? If so, these need to be changed) "character/character/citation" **Changed to mortal mother**
§ - ID610, Laodamia (1) is mortal father of Sarpedon (2) (Laodamia must be a mother, change) "character/character/citation" **Changed to mortal mother**
* - ID1796, Poseidon is god father of Belus (not explicitly mentioned in 3.1.1, but Frazer's footnote relates this to Apollod. 2.1.4 which this record also does, should we keep this citation anyways?) "character/character/citation"
§ - ID1635-1640, Agenor sends his sons , andTelephassa, and Thasus… (correct spelling and punctuation to "Agenor sends his sons, Telephassa, and Thasus…"?) "event/character/citation"
§ - ID606, ibid "event/place"
§ - ID1642, Cilix, unable to find Europa, settle in Cilicia (change spelling to "settles in Cilicia"?) "event/character/citation"
§ - ID608, ibid "event/place"
§ - Add event "Belus reigns over the Egyptians" (character "Belus"?) "event/character/citation" **Cited ID779, Belus rules over Egypt (Apollod. 2.1.4) in 3.1.1 as well**
§ - ibid (place "Egypt"?) "event/place"
§ - Event "Agenor rules Phoenicia" belongs in "event/place" with place "Phoenicia"

Permalink 02:43:55 pm, by mholmes, 268 words, 85 views   English (CA)
Categories: Activity log; Mins. worked: 15

Updated the mega-view to include total institutional buyers and sellers

DROP VIEW IF EXISTS VW_trans_composite_eth_prop;

CREATE VIEW VW_trans_composite_eth_prop AS

(
SELECT 

seller_titles.ttl_title_id AS seller_title_id, seller_titles.ttl_date AS seller_title_date, seller_titles.ttl_title_code AS seller_title_code,
buyer_titles.ttl_title_id AS buyer_title_id, buyer_titles.ttl_date AS buyer_title_date, buyer_titles.ttl_title_code AS buyer_title_code,
DATEDIFF(buyer_titles.ttl_date, seller_titles.ttl_date) as seller_duration_days,
census_tracts.census_tract_code,
props.*,
sellers.concat_owners AS concat_sellers, sellers.concat_ethnicities AS seller_ethnicities, sellers.total_owners AS total_sellers,
sellers.munged_ethnicity AS seller_munged_eth,
sellers.total_institutional AS institutional_sellers,
buyers.concat_owners AS concat_buyers, buyers.concat_ethnicities AS buyer_ethnicities, buyers.total_owners AS total_buyers,
buyers.munged_ethnicity AS buyer_munged_eth,
buyers.total_institutional AS institutional_buyers

FROM titles AS buyer_titles
LEFT JOIN titles_to_prectitles ON buyer_titles.ttl_title_id = titles_to_prectitles.ttp_title_id_fk
LEFT JOIN titles AS seller_titles ON seller_titles.ttl_title_id = titles_to_prectitles.ttp_prectitle_id_fk
LEFT JOIN VW_titles_composite_eth AS sellers ON seller_titles.ttl_title_id = sellers.ttl_title_id
LEFT JOIN VW_titles_composite_eth AS buyers ON buyer_titles.ttl_title_id = buyers.ttl_title_id

LEFT JOIN props AS props ON seller_titles.ttl_property_id_fk = props.prp_property_id
LEFT JOIN census_tracts ON props.prp_census_tract_id_fk = census_tracts.census_tract_id

ORDER BY seller_titles.ttl_title_id
)
Permalink 02:41:41 pm, by mholmes, 282 words, 79 views   English (CA)
Categories: Activity log; Mins. worked: 30

Revised one view

Revised the VW_titles_composite_eth view so that it includes even owners who have no ethnicity (are institutional):

DROP VIEW IF EXISTS VW_titles_composite_eth;

CREATE VIEW VW_titles_composite_eth AS
(
SELECT 
titles.ttl_title_id,
titles.ttl_title_code,
titles.ttl_date,
CAST(group_concat(owners.own_owner_id separator ', ') AS CHAR) AS concat_owners,
SUM(owners.own_institutional) AS total_institutional,
CAST(group_concat(owners_to_ethnicities.ote_ethnicity_id_fk separator ', ') AS CHAR) AS concat_eth_ids,
group_concat(ethnicities.eth_name separator ', ') AS concat_ethnicities,
(SELECT IF (COUNT(owners.own_owner_id) > 1, 'multiple', 'single')) AS multi_owner,
(COUNT(owners.own_owner_id)) AS total_owners,
(SELECT CASE
WHEN group_concat(ethnicities.eth_name separator ', ') LIKE "%Japanese%" AND group_concat(ethnicities.eth_name separator ', ') LIKE "%Chinese%" THEN "c"
WHEN group_concat(ethnicities.eth_name separator ', ') LIKE "%Japanese%" AND (SELECT COUNT(DISTINCT(ethnicities.eth_name))) > 1 THEN "b"
WHEN group_concat(ethnicities.eth_name separator ', ') LIKE "%Chinese%" AND (SELECT COUNT(DISTINCT(ethnicities.eth_name))) > 1 THEN "a"
WHEN (SELECT COUNT(DISTINCT(ethnicities.eth_name))) > 1 THEN "d"
ELSE SUBSTRING_INDEX(group_concat(ethnicities.eth_name separator ', '), ',', 1)
END) AS munged_ethnicity
FROM titles
LEFT JOIN owners_to_titles ON owners_to_titles.ott_title_id_fk = titles.ttl_title_id
LEFT JOIN owners ON owners_to_titles.ott_owner_id_fk = owners.own_owner_id
LEFT JOIN owners_to_ethnicities ON owners.own_owner_id = owners_to_ethnicities.ote_owner_id_fk
LEFT JOIN ethnicities ON owners_to_ethnicities.ote_ethnicity_id_fk = ethnicities.eth_ethnicity_id
GROUP BY titles.ttl_title_id
)
Permalink 10:56:25 am, by mholmes, 28 words, 61 views   English (CA)
Categories: Activity log; Mins. worked: 30

Fixed a bug on the Phil site

Duplicated half-open tag caused a display bug in the menu. Fixed it at LW's request. Also some discussion of how the PDF handbook should be produced in future.

Permalink 10:36:59 am, by jnazar, 6 words, 56 views   English (CA)
Categories: Activity log; Mins. worked: 420

JavaScript

Ongoing: working my way through JavaScript.

Permalink 10:10:57 am, by jnazar, 23 words, 40 views   English (CA)
Categories: Activity log; Mins. worked: 30

Administrative - office operations

Received invoiced payment from HB (1st Qtr 2011); deposited cheque; obtained receipt, filed paperwork/receipt in HCMC records; sent
email confirmation to MDH,SA.

Permalink 10:07:55 am, by mholmes, 19 words, 84 views   English (CA)
Categories: Activity log; Mins. worked: 30

More info needed for VW_trans_composite_eth_prop

The latest requirement is a field containing a comma-separated list of the owner names where the owners are institutional.

26/04/11

Permalink 05:23:40 pm, by mholmes, 5 words, 58 views   English (CA)
Categories: G&T Hours; Mins. worked: 0

MDH: 125 + 1 = 126 hours G&T

Preparing for meetings and workshops.

Permalink 02:10:12 pm, by mholmes, 193 words, 133 views   English (CA)
Categories: R & D, Activity log; Mins. worked: 30

TEI build now working

SR has removed some build targets and components from the makefile, which means I can now build P5 without errors, but some of the issues will need to be handled at some point -- for instance, the error in building the PDF is due to the need for TeX Live 2010, whereas current Ubuntu versions are stuck at 2009. Still working on a detailed plan for creating a clone Jenkins machine, for which we'll need to solve all these problems. Here's some bits from email for the record (our suggested plan and SR's responses):

 -Start with an Ubuntu 10.04 headless server install.
  
   -Install the Oracle JDK.
  
   -Install Tomcat (any particular version? Latest? What's in repos?).
doesnt matter, version 6 or 7 latest

  
   -Install Jenkins from here:
     http://pkg.jenkins-ci.org/debian/
  
   -Install Tex Live 2010 from here:
     http://www.tug.org/texlive/acquire.html
  
   -Follow these instructions to get a working build setup:
     http://hcmc.uvic.ca/blogs/index.php?blog=15&p=8081
  
Jenkins will do its own checkout, so no need for some of that

   -???Profit?
pleasure

  
  I'm pretty sure we'll also have to install some extras (fonts and the 
  like),
note the result of 

    make dependencies

Permalink 02:06:16 pm, by mholmes, 109 words, 79 views   English (CA)
Categories: Activity log; Mins. worked: 60

Site changes based on advice from France

Made the following changes to some site content based on advice from the French team:

  • "Allusions/Notes" is now simply "Index".
  • The default style is "Pelouse".
  • Superscripts in editorial introductions have been reconfigured using CSS so that they no longer have any impact on line-spacing. "vertical-align: superscript;" was replaced with "position: relative; bottom: 0.8ex;". I have not made this change in any anthology documents, although we may do that if it proves worthwhile. There are 31 instances of the use of "vertical-align: superscript" in the text_original collection.
  • Mentions of genres on the home page have been linked to their respective TOC pages.

Other changes are pending after some discussion.

Permalink 09:41:38 am, by mholmes, 284 words, 96 views   English (CA)
Categories: Activity log; Mins. worked: 15

Expanded the large view

JS-R needed to add the full property information to the transactions view, so I've added a new view:

DROP VIEW IF EXISTS VW_trans_composite_eth_prop;

CREATE VIEW VW_trans_composite_eth_prop AS

(
SELECT 

seller_titles.ttl_title_id AS seller_title_id, seller_titles.ttl_date AS seller_title_date, seller_titles.ttl_title_code AS seller_title_code,
buyer_titles.ttl_title_id AS buyer_title_id, buyer_titles.ttl_date AS buyer_title_date, buyer_titles.ttl_title_code AS buyer_title_code,
DATEDIFF(buyer_titles.ttl_date, seller_titles.ttl_date) as seller_duration_days,
census_tracts.census_tract_code,
props.*,
sellers.concat_owners AS concat_sellers, sellers.concat_ethnicities AS seller_ethnicities, sellers.total_owners AS total_sellers,
sellers.munged_ethnicity AS seller_munged_eth,
buyers.concat_owners AS concat_buyers, buyers.concat_ethnicities AS buyer_ethnicities, buyers.total_owners AS total_buyers,
buyers.munged_ethnicity AS buyer_munged_eth

FROM titles AS buyer_titles
LEFT JOIN titles_to_prectitles ON buyer_titles.ttl_title_id = titles_to_prectitles.ttp_title_id_fk
LEFT JOIN titles AS seller_titles ON seller_titles.ttl_title_id = titles_to_prectitles.ttp_prectitle_id_fk
LEFT JOIN VW_titles_composite_eth AS sellers ON seller_titles.ttl_title_id = sellers.ttl_title_id
LEFT JOIN VW_titles_composite_eth AS buyers ON buyer_titles.ttl_title_id = buyers.ttl_title_id

LEFT JOIN props AS props ON seller_titles.ttl_property_id_fk = props.prp_property_id
LEFT JOIN census_tracts ON props.prp_census_tract_id_fk = census_tracts.census_tract_id

ORDER BY seller_titles.ttl_title_id
)

This takes even longer to generate than the original, unfortunately.

22/04/11

Permalink 01:38:01 pm, by jamie, 6 words, 37 views   English (CA)
Categories: G&T Hours; Mins. worked: 0

JPN: -2 + 1.5 = -0.5 Hours G&T

Made up some time on Thursday.

21/04/11

Permalink 04:51:01 pm, by mholmes, 136 words, 347 views   English (CA)
Categories: Activity log, Documentation; Mins. worked: 60

NVivo problem

At the end of the day, NVivo froze while shutting down. This meant that none of the day's changes were written to disk, because apparently it stores them up and writes them at the end of the session. We found a .tmp file in docs and settings -- can't remember the exact path, but it was named like the actual data file -- and this turned out to be a complete copy of the altered data, with the exception that the dates of recent changes had not been recorded. Backed up the original day-old file as "...last known good", then copied the tmp file over to the original filename, and everything should be good to go, but when M comes in next, she should have a good look to make sure nothing else has been lost.

Permalink 04:47:37 pm, by mholmes, 10 words, 56 views   English (CA)
Categories: G&T Hours; Mins. worked: 0

MDH: 124 + 1 = 125 hours G&T

NVivo data loss emergency at the end of the day...

Permalink 02:48:46 pm, by mholmes, 80 words, 74 views   English (CA)
Categories: Activity log; Mins. worked: 90

Processed and uploaded new Spanish test exercises

Earlier in the week I received new and revised materials for many of the historical Spanish 100 exam exercise collections. I've now processed and uploaded all the new material, as well as fixing some discrepancies in style for titling of various pages and exercises, fixing a couple of broken links, and rewriting an old index page that was not in the house style. All currently pending work is now done on this, but RLS has more in store for the future.

Permalink 11:19:06 am, by jamie, 93 words, 93 views   English (CA)
Categories: Activity log; Mins. worked: 60

1911 "Central Park" data received and imported

Received sub-district 5, "Central Park", from PD yesterday and imported this morning. Had to fix a handful of codes and modify the loader map file for slightly-different column names, but other than that the data was brought in smoothly. Added new occupations:

INSERT INTO occupation (occupation_description, occupation_code) VALUES 
('Pool Romm Attendant', '59990'),
('Setter', '81275'),
('Lamp Fitter', '87330'),
('General Finisher', '99999');

And a new location:

INSERT INTO "location" VALUES (84, 'BC', 'British Columbia', '13', 'Victoria City', '5', 'Central Park', NULL, NULL, NULL, NULL, NULL, '1911', NULL, NULL); 

Permalink 10:53:53 am, by mholmes, 480 words, 69 views   English (CA)
Categories: Activity log; Mins. worked: 90

Calico meeting

Points from the meeting:

  • All required network ports are turned on, and will be switched over to the conference VLAN the day before the conference.
  • T-shirts are printed, and look good. They're stashed in HCMC.
  • Signage: we've agreed on 10 outdoor signs, and we'll circulate a map to agree on where to place them. We'll have to get them printed on something vaguely waterproof; Zap can do that. Indoor signs we'll handle ourselves. MDH will circulate a map next week, and design a generic sign, which we can customize once we know the locations.
  • No response from Walmart on phones yet. The phone issue is looking very complicated and expensive, so we resolved not to worry about it; we'll ensure that the two volunteers without phones are next to volunteers who do have them. There are also courtesy phones dotted around the buildings; we can check on the nearest ones from our presentation rooms.
  • The splitter issue for PCs is being dealt with. AV have at least three splitters; HCMC has one; and HCMC also has some old graphics cards that might help. If we don't find enough solutions, we can rent splitters from Sharps.
  • Video streaming: just streaming over a regular ethernet connection is not likely to be successful, so GN will investigate with AE the possibility of getting the relevant ports switched to a system which can handle the traffic. For audio, AE will also investigate getting a feed from the PA in Bob Wright A104; in the dining room, the best option might be a shotgun mic, which AE can provide. I've written to MS to get details of the camera he's bringing.
  • The rented Mac laptops solve one problem for us, but create another: security. We devised a plan for storing them securely during lunchtimes and overnight.
  • Temporary ids for wifi logon will be provided as a spreadsheet, which we can print, cut up, and have the registration folks distribute.
  • CC will check with Cad Commons to see if we can get keys to lock the presentation rooms (e.g. during lunch), and whether we can also get a key for the little storage room in (we think?) Queenswood.
  • For training sessions next week:
    • Sessions are in A010.
    • PF will make sure that there's at least one PC that's similar to what will be used for the conference rooms available.
    • CC will attend, and will bring a Mac laptop and a dongle for it.
    • MDH will also bring a Windows laptop (and Linux).
    • We will collect: phone numbers and emails of volunteers, and dates/times when they're not available.
    • We will distribute: key emergency phone numbers (HCMC, AV, MDH, GN, Help desk, ???).
    • We'll have them hook up and unhook PC and Mac a few times, and deal with some obvious problems.
    • We will take the volunteers to look at the rooms in Clearihue and in Cad Commons.

20/04/11

Permalink 04:07:09 pm, by Matthew, 1637 words, 198 views   English (CA)
Categories: Activity log; Mins. worked: 180

Revisions: Apollodorus 2.1.4-2.5.9

* 2.1.4 - Nile is other non-human entity father of Memphis (please check this, add if it's true?) "character/character/citation"
§ - Belus is spouse of Anchinoe, and vice versa (add?) "character/character/citation"
* - Nile is other non-human entity father of Anchinoe (add if true?) "character/character/citation"
§ - ID778/1756, Agenor rules Phoenicia (mentioned twice, but ID1756 cites 2.1.4 as well as 3.1.1, so remove ID778?) "event/character/citation"
§ 2.1.5 - ID2430/2436, Encaladus (2) is spouse of Amymone (text spells it "Enceladus", change?) "character/character/citation"
§ - ID2687, Hippodamia (2) is spouse of Dicorystes (spelling says "Diocorystes" rather than "Dicorystes", change?) "character/character/citation"
- Important note: There are 3 different characters named "Diocorystes" without (#) to denote which is which, please clarify.
§ - ID2452, Hippomedusa is spouse of Alcemnor (spelling says "Alcmenor" rather than "Alcemnor", change?) "character/character/citation"
§ - ID2692, Menemachua is spouse of Nelo (spelling says "Menemachus rather than "Menemachua", change?) "character/character/citation"
§ - ID2730, Hesione (2) is spouse of Nauplius (add vice versa?) "character/character/citation"
§ - Danaus is mortal father of Amymone (add?) "character/character/citation"
§ - ID267, Egyptus (1) is father of Encaladus (2) (text spells it "Enceladus", change?) "character/character/citation"
§ - ID285, Egyptus (1) is father of Alcemnor (spelling says "Alcmenor" rather than "Alcemnor", change?) "character/character/citation"
* - Europe is the mother of Danaus' children: Automate, Amymone, Agave, and Scaea (these have not been added, add Europa as god mother?) "character/character/citation"
* - Clymene is the daughter of Catreus/Philyra/Hesione depending on the author, text also mentions "By her he had Palamedes, Oeax, and Nausimedon." (Catreus is listed as the mother of Clymene only, while Philyra is listed as the mother of all four, and Hesione is listed as the mother of Oeax and Palamedes only, please clarify whether we should list all four as the children of Catreus/Philyra/Hesione?) "character/character/citation"
§ - ID899, Sons of Egyptus come to Argos… Encaladus (2) is involved in this event (text spells it "Enceladus", change?) "event/character/citation"
§ - ID909, Sons of Egyptus come to Argos… Alcemnor is involved in this event (text spells it "Alcmenor", change?) "event/character/citation"
- ID307, Nauplius sails the sea, lures people to death with a beacon (add "and dies this way"?) "event/place" **Nevermind**
2.2
2.2.1 - ID2529/2669, Antia is spouse of Proetus (3) and vice versa (the "tragic poets call her Stheneboea", add as spouse of Proetus (3) also?) "character/character/citation"
§ - ID1000-1002, Lynceus rules Argos, has children (change to "child" or "Abas"? only one child is mentioned) "event/character/citation" **Changed to "has a child"**
§ - ID1005/1006, Acrisius and Proetus fight for the kingdom, event shields (change to "invent shields"?) "event/character/citation"
§ - ID1011, Amphianax or Proeteus sends and army of… (change to "Proetus"?) "event/character/citation" **Also cite characters: Amphianax, Proetus (3)**
§ - ID310, Acrisius and Proetus fight for the kingdom, event shields (change to "invent shields"?) "event/place"
§ - ID312, Amphianax or Proeteus sends an army of… (change to "Proetus"?) "event/place"
§ 2.2.2 - Eurydice is daughter of Lacedaemon (add relationship?) "character/character/citation" **Added Lacedaemon (2) as mortal father of Eurydice (3)**
* - ID1351-1353, Antia mortal mother of Lysippe (1), Iphinoe, and Iphianassa (add Stheneboea as mortal mother of these three in addition? "the tragic poets call her Stheneboea" When we have an alternate name for a character should we repeat every event and relationship to include the alternate names as well?) "character/character/citation"
- Melampus is mentioned as brother of Bias (should we add this relationship?) "character/character/citation" **Nevermind**
§ - ID1018-1020, Melampus cures the the women possessed by Dionyussus… (remove 2nd "the" and change spelling to "Dionysus" instead of "Dionyussus"?) "event/character/citation"
§ - ID1021-1024, Melampus chases the maddened women to Sicyon… (doesn't mention Iphianassa, add?) "event/character/citation"
2.3
* 2.3.1 - ID378, Glaucus (1) is mortal father of Deliades (should we add Piren and Alcimenes as the sons of Glaucus (1) as well, which others mention was the brother of Bellerophon?) "character/character/citation"
- ID1025, Bellerophon kills his brother Deliades/Piren/Alcimenes (ibid) "event/character/citation"
- ID1029, Bellerophon goes to Proetus to be purified… (mentions Antia being involved, should we add Stheneboea as well?) "event/character/citation" **Nevermind**
2.3.2 - ok
2.4
2.4.1 - ok
* 2.4.2 - ID1798-1799, Poseidon is god father of Pegasus and Chrysaor (is Medusa the mother since they sprang from her as she was beheaded?) "character/character/citation"
§ 2.4.3 - ID2684, Cepheus (3) is spouse of Cassiepea (1) (add vice versa?) "character/character/citation"
§ - Phineus, brother of Cepheus, was originally married to Andromeda before Perseus came along (should we add them as spouses?) "character/character/citation"
§ 2.4.4 - ID1096-1097, Perseus competes in Teutamides' games, accidentally kills Acrisius (add Acrisius to this event?) "event/character/citation"
§ 2.4.5 - Perseus (2) is mortal father of Gorgophone, whom Perieres married (add Perseus as father?) "character/character/citation"
- ibid (add Gorgophone as spouse of Perieres and vice versa?) "character/character/citation" **Please check which Perieres is correct, as there are two citations for Gorgophone as the spouse of each of the two Perieres, both of whom are cited as the son of Cynortes/Cynortas but are cited in different sections although they are ostensibly the same character.**
§ - ID402, Pterelaus is father of Everes (2) (text spells it "Eueres", change spelling?) "character/character/citation" **Changed character "Everes (2)" to Eueres, also changed character "Everes (1)" to Everes. Please note that Perseus' reference to both spellings of Everes and Eueres point to Apollod. 2.4.5 so these may just be alternate spellings, please verify.**
* - ID397-402, Pterelaus is mortal father of Chromius, Tyrannus, Antiochus, Chersidamas, Mestor, and Eueres (Poseidon made him immortal by planting a golden hair on his head, does this make Pterelaus a god father rather than a mortal father? Please clarify) "character/character/citation"
§ - ID2255, Melian nymph is god mother of Nemean Lion (not mentioned in 2.4.5) "character/character/citation" **Delete, the Melian nymph is the mother of the centaur Pholus (Apollod. 2.5.4), while the Nemean Lion was the "son" of Typhon**
§ 2.4.6 - ID1132-1134, Amphitryon accidentally kills Amphitryon… (text says "but the club rebounded from the cow's horns and striking Electryon's head killed him", change to "Amphitryon accidentally kills Electryon"?) "event/character/citation"
§ - ID1139-1143, Amphitryon, Alcmena and Licymnius go the Thebes… (change to "go to Thebes"?) "event/character/citation"
§ - ID368, ibid, "event/place"
§ - ID1144, Amphitryon unsucessfully attempts to stop the vixen… (change to "unsuccessfully"?) "event/character/citation"
§ - ID369, ibid, "event/place"
§ 2.4.7 - ID1150, Amphitryon and Cephalus hunt the Cadmean vixen… (should this also include Zeus?) "event/character/citation"
2.4.8 - ID1180-1183, Two snakes sent by Hera attack Hercules and Iphicles in their crib (should this say "sent by Hera or Amphitryon", or create a separate event?) "event/character/citation"
- Add event "Hercules saves Alcmena by strangling the two snakes with both hands"? **Nevermind**
2.4.9 - ID1192-1193, Linus teaches Hercules to play the lyre, is accidentally killed by Hercules (text says "for being struck by him, Hercules flew into a rage and slew him", should we be more ambiguous and say "is killed by Hercules"?) "event/character/citation" **Nevermind**
§ - ID1188/1189, ID1757/1758, Hercules taught to shoot a bow (this event is repeated twice, with ID1757/1758 having an extra citation for 2.4.11, should we delete the first two entries?) "event/character/citation"
§ - ID394, Hercules sent to a catte farm my Amphitryon…(correct spelling to "Hercules sent to a cattle farm by Amphitryon…"?) "event/character/citation"
2.4.10 - Add event "Hercules dresses himself in the skin of the lion and wears the scalp as a helmet"?
§ 2.4.11 - ID1202-1204, Ergiinus marches against Thebes again… (correct spelling to "Erginus"?) "event/character/citation"
§ - ID400, ibid "event/place"
§ 2.4.12 - ID432, Typhon is mortal father of Nemean Lion (not mentioned in 2.4.12, belongs in 2.5.1) "character/character/citation" **Also changed to "God father"**
2.5
§ 2.5.1 - ID413, Hercules comes back to Molorchus with the body of the Nemea Lion (correct spelling to "Nemean Lion"?) "event/place"
§ - ID1233-1234, ibid "event/character/citation"
2.5.2 - ok
§ 2.5.3 - ID1251, Hercules bring in the Cerynitian hind (correct spelling to "Hercules brings in…"?) "event/character/citation"
§ - ID423, ibid "event/place"
2.5.4 - ok
§ 2.5.5 - Augeas (1) is son of the Sun (Helios) (add relationship?) "character/character/citation"
2.5.6 - ok
§ 2.5.7 - ID2007, Amphion dies (does not belong in 2.5.7) "event/character/citation" **Moved to 3.5.7**
§ - ID1289, ID1754-1755, bull carries Europa for Zeus… (event is mentioned twice, but ID1754-1755 also cite 3.1.1, remove ID1289?)
§ 2.5.8 - ID1304, Home of Abderus (character involved is "Abdera", is this correct or is the character supposed to be "Abderus"? Text says "…Abderus, who was a son of Hermes, a native of Opus in Locris…", please clarify) "event/character/citation"
2.5.9 - ID1801, Poseidon is god father of Mygdon (is this correct? please verify) "character/character/citation" **Nevermind**
§ - ID1310-1316, Hercules as some volunteers, on their way to get Hippolyte's belt… (change to "Hercules and some volunteers…"?) "event/character/citation"
§ - ID459, ibid "event/place"
§ - ID1317-1320, Hercules and crew help Lycus in a battle against King Mygdon of the Bebryces (add Mygdon to this event?) "event/character/citation"
§ - ID1326-1328, Hercules rescues Hesione (Hesione is mentioned twice, is one of these citations supposed to be Laomedon instead? He is not mentioned but he participated in this event) "event/character/citation"
* - ID1329-1331, Apollo and Poseidon fortify Troy (should we change this so as to avoid confusion "Apollo and Poseidon fortify Pergamum (Troy)", wikipedia and Herodotus 7.43 state that Pergamum was the ancient citadel of Troy and Laomedon was a Trojan king, the text is a little confusing here since it uses them interchangeably)
- ID464, ibid "event/place"
§ - ID458, blank (blank event with character "Thermodon", erase this?) "event/place" **I take it this is supposed to have an event involving the Amazons and Hippolyte, but I can't find any events so I added a new event: "Hippolyte rules over the Amazons" and cited it as the event for Thermodon (ID458)**

Permalink 03:52:52 pm, by mholmes, 268 words, 93 views   English (CA)
Categories: Activity log; Mins. worked: 45

Figured out the showstopper...

Had to use a separate view to aggregate owners against titles. It's working, but it's mighty slow!

DROP VIEW IF EXISTS VW_trans_composite_eth;

CREATE VIEW VW_trans_composite_eth AS

(
SELECT 

seller_titles.ttl_title_id AS seller_title_id, seller_titles.ttl_date AS seller_title_date, seller_titles.ttl_title_code AS seller_title_code,
buyer_titles.ttl_title_id AS buyer_title_id, buyer_titles.ttl_date AS buyer_title_date, buyer_titles.ttl_title_code AS buyer_title_code,
DATEDIFF(buyer_titles.ttl_date, seller_titles.ttl_date) as seller_duration_days,
census_tracts.census_tract_code,
sellers.concat_owners AS concat_sellers, sellers.concat_ethnicities AS seller_ethnicities, sellers.total_owners AS total_sellers,
sellers.munged_ethnicity AS seller_munged_eth,
buyers.concat_owners AS concat_buyers, buyers.concat_ethnicities AS buyer_ethnicities, buyers.total_owners AS total_buyers,
buyers.munged_ethnicity AS buyer_munged_eth

FROM titles AS buyer_titles
LEFT JOIN titles_to_prectitles ON buyer_titles.ttl_title_id = titles_to_prectitles.ttp_title_id_fk
LEFT JOIN titles AS seller_titles ON seller_titles.ttl_title_id = titles_to_prectitles.ttp_prectitle_id_fk
LEFT JOIN VW_titles_composite_eth AS sellers ON seller_titles.ttl_title_id = sellers.ttl_title_id
LEFT JOIN VW_titles_composite_eth AS buyers ON buyer_titles.ttl_title_id = buyers.ttl_title_id

LEFT JOIN props ON seller_titles.ttl_property_id_fk = props.prp_property_id
LEFT JOIN census_tracts ON props.prp_census_tract_id_fk = census_tracts.census_tract_id

ORDER BY seller_titles.ttl_title_id
)
Permalink 03:11:41 pm, by mholmes, 482 words, 85 views   English (CA)
Categories: Activity log; Mins. worked: 120

New views: some progress, one showstopper

I've completed two of the three tasks from this morning: the VW_sellers_duration view has been modified to rename its fields, and the VW_mortgate_ethnicity view has been created.

DROP VIEW IF EXISTS VW_mortgage_ethnicity;
CREATE VIEW VW_mortgage_ethnicity AS
(SELECT mortgages.*,
titles.ttl_title_id, titles.ttl_title_code, titles.ttl_date,
census_tracts.census_tract_code,
CAST(group_concat(owners.own_owner_id separator ', ') AS CHAR) AS concat_owners,
CAST(group_concat(owners_to_ethnicities.ote_ethnicity_id_fk separator ', ') AS CHAR) AS concat_eth_ids,
group_concat(ethnicities.eth_name separator ', ') AS concat_ethnicities,
(SELECT IF (COUNT(owners.own_owner_id) > 1, 'multiple', 'single')) AS multi_owner,
(COUNT(owners.own_owner_id)) AS total_owners,
(SELECT CASE
WHEN group_concat(ethnicities.eth_name separator ', ') LIKE "%Japanese%" AND group_concat(ethnicities.eth_name separator ', ') LIKE "%Chinese%" THEN "c"
WHEN group_concat(ethnicities.eth_name separator ', ') LIKE "%Japanese%" AND (SELECT COUNT(DISTINCT(ethnicities.eth_name))) > 1 THEN "b"
WHEN group_concat(ethnicities.eth_name separator ', ') LIKE "%Chinese%" AND (SELECT COUNT(DISTINCT(ethnicities.eth_name))) > 1 THEN "a"
WHEN (SELECT COUNT(DISTINCT(ethnicities.eth_name))) > 1 THEN "d"
ELSE SUBSTRING_INDEX(group_concat(ethnicities.eth_name separator ', '), ',', 1)
END) AS munged_ethnicity

FROM mortgages
LEFT JOIN mortgages_to_titles ON mortgages.mgg_mortgage_id = mortgages_to_titles.mtt_mortgage_id_fk
LEFT JOIN titles on mortgages_to_titles.mtt_title_id_fk = titles.ttl_title_id
LEFT JOIN owners_to_titles ON owners_to_titles.ott_title_id_fk = titles.ttl_title_id
LEFT JOIN owners ON owners_to_titles.ott_owner_id_fk = owners.own_owner_id
LEFT JOIN owners_to_ethnicities ON owners.own_owner_id = owners_to_ethnicities.ote_owner_id_fk
LEFT JOIN ethnicities ON owners_to_ethnicities.ote_ethnicity_id_fk = ethnicities.eth_ethnicity_id
LEFT JOIN props ON titles.ttl_property_id_fk = props.prp_property_id
LEFT JOIN census_tracts ON props.prp_census_tract_id_fk = census_tracts.census_tract_id
GROUP BY mortgages.mgg_mortgage_id)

I'm now working on the transaction view, but I've run into an issue variously known as the "Cartesian product" or "Cascading aggregates" problem: in simple terms, when I aggregate both the buyers and the sellers in a single row, I end up with multiple instances. For example, if there are two buyers and three sellers, then each buyer appears three times and each seller twice, for spurious totals of six buyers and six sellers.

What this means is that my strategy for munging buyers OR sellers works only when we're only looking at one of them; when we need to munge both of them in the same row, a different strategy has to be adopted. Right now, I don't know what that strategy might be, but I'm doing some research.

Permalink 03:10:38 pm, by jamie, 68 words, 78 views   English (CA)
Categories: Activity log; Mins. worked: 45

Updated page copy

Received and added some new and updated page copy from PD. Added to both the development and live sites.

Permalink 03:08:24 pm, by jnazar, 25 words, 56 views   English (CA)
Categories: Activity log; Mins. worked: 360

JavaScript

In order to apply to the various websites I'm working on (e.g. LATAM) I've started learning JavaScript. Currently working my way through the tutorials.

Permalink 01:53:38 pm, by mholmes, 104 words, 81 views   English (CA)
Categories: Activity log; Mins. worked: 60

Versioning, SVN and history

LSPW reported that an entry in the references file was missing (Chypre). We checked back through SVN, and confirmed that it had never been present during the time we've been using SVN, but I found an old version of the references file from Mariage version 4, and we retrieved it from there.

Meanwhile, there were conflicts with the le_bon_mariage.xml file, arising I think when EGB forgot to do an svn update before starting work, after I had edited the file on the 14th. I think I've resolved these, but we'll know for sure tomorrow when she comes in and does an update.

Permalink 01:34:06 pm, by mholmes, 72 words, 58 views   English (CA)
Categories: Activity log; Mins. worked: 90

History Cascade project progress

Met with TG and LL from History to discuss the IA's response to the navigation plan, and made a number of changes to reduce numbers of items and lengths of captions, as well as to reaffirm their confidence that their navigation plan accords well with their target audience. TG reworked the navigation spreadsheet, and we completed the project light web document, then submitted them to AR along with the CMS provisioning request.

Permalink 11:10:42 am, by jamie, 118 words, 69 views   English (CA)
Categories: Activity log; Mins. worked: 60

1911 Vic West data received by PD; imported

Received the latest set of 1911 census data from PD - subdistrict, #1, Vic West. Imported into the development database smoothly and without incident.

Also inserted six new occupations:


INSERT INTO occupation (occupation_description, occupation_code) VALUES ('Pianist', 17140);
INSERT INTO occupation (occupation_description, occupation_code) VALUES ('Show Woman', 17225);
INSERT INTO occupation (occupation_description, occupation_code) VALUES ('Butter Maker', 77530);
INSERT INTO occupation (occupation_description, occupation_code) VALUES ('Gas Fitter', 87120);
INSERT INTO occupation (occupation_description, occupation_code) VALUES ('Cement Worker', 95200);
INSERT INTO occupation (occupation_description, occupation_code) VALUES ('Road Maker', 97415);

And a new location for the sub district:


INSERT INTO "location" VALUES (83, 'BC', 'British Columbia', '13', 'Victoria City', '1', 'Victoria West', NULL, NULL, NULL, NULL, NULL, '1911', NULL, NULL);

Permalink 10:29:54 am, by jamie, 169 words, 10702 views   English (CA)
Categories: Notes; Mins. worked: 0

How to fix PostgreSQL error "duplicate key violates unique constraint"

If you get this message when trying to insert data into a PostgreSQL database:

ERROR:  duplicate key violates unique constraint

That likely means that the primary key sequence in the table you're working with has somehow become out of sync, likely because of a mass import process (or something along those lines). Call it a "bug by design", but it seems that you have to manually reset the a primary key index after restoring from a dump file. At any rate, to see if your values are out of sync, run these two commands:

SELECT MAX(the_primary_key) FROM the_table;

SELECT nextval('the_primary_key_sequence');

If the first value is higher than the second value, your sequence is out of sync. Back up your PG database (just in case), then run thisL

SELECT setval('the_primary_key_sequence', (SELECT MAX(the_primary_key) FROM the_table)+1);

That will set the sequence to the next available value that's higher than any existing primary key in the sequence.
Permalink 09:31:57 am, by mholmes, 108 words, 84 views   English (CA)
Categories: Activity log; Mins. worked: 60

Plans for new views

Met with JS-R and worked through requirements for new views of the data:

  • Existing view should not be discarded; they're all potentially useful.
  • VW_sellers_duration needs some renamed fields: anything beginning with "old_" should be renamed "seller_", "new_" s/b "buyer_", and "duration_days" s/b "seller_duration_days".
  • A new view needs to be created like VW_sellers_duration, but rooted on the title instead; it should included munged seller ethnicity and munged buyer ethnicity.
  • A new view of mortgages is required, with 1 row per mortgage, including all the mortgage info, and the core title info, followed by the munged owners, and also incorporating property info.

19/04/11

Permalink 04:20:05 pm, by mholmes, 6 words, 53 views   English (CA)
Categories: G&T Hours; Mins. worked: 0

MDH: 123.5 + 0.5 = 124 hours G&T

Nearly managed to leave on time.

Permalink 03:22:59 pm, by mholmes, 614 words, 59 views   English (CA)
Categories: Activity log; Mins. worked: 60

Documenting TEI SVN editing/building

I made my first few commits today, and I thought I'd report my experiences in case they help anyone else who's intending to do this but hasn't tried yet. This is all on Ubuntu Linux.

First I followed these instructions to install the TEI packages for Debian on my machine:

http://wiki.tei-c.org/index.php/TEIDebian

I made a directory and checked out the full source my local machine:

mkdir sf_repo
svn co https://tei.svn.sourceforge.net/svnroot/tei sv_repo

Then I moved to the P5 directory and ran a build using "make":

cd sf_repo/trunk/P5
make

This took a long while the first time, and showed me lots of messages that turned out to be a mixture of the incomprehensible, the ignorable, and the relevant. Relevant messages (for me) are ones that I can imagine a way to fix; or that were caused by one of my changes (this hasn't happened yet).

I soon realized that watching the messages go by in my terminal was not really useful, so I started saving the error output to a separate file incorporating a datetime stamp in its name every time I ran a build. This is how I'm working now:

#Go to the root directory of the SVN tree
cd sf_repo

#Check out the latest changes
svn up

#Go into the P5 directory
cd trunk/P5

#Run a preliminary build
make 2> /path/to/error/file/make_errors_`date +"%Y-%m-%dT%H:%M:%S"`.txt

#Make my own changes...

#then run another build
make 2> /path/to/error/file/make_errors_`date +"%Y-%m-%dT%H:%M:%S"`.txt

#Finally, diff the two latest error files to see if I've fixed 
#any previous errors, or introduced any new ones. For this I 
#use Meld.

#Commit my changes if all is OK
cd Source/Specs #(for instance, assuming that's where I edited a file)
svn commit -m "Message explaining my changes."

#Go to Jenkins and watch it build the changed source, 
#then check for errors again.

Watching Jenkins today answered a number of questions for me about how it works, especially with regard to queueing up builds:

Jenkins seems to be configured to run up to two builds simultaneously. When it is already engaged in doing two builds, it will not start another one until one of the current ones is finished. Then it will initiate a new build which incorporates ALL the changes which have been committed during the time it was engaged in the previous build. What this means is that some revisions are never built independently. For instance, I committed two changes to SVN while a build was in progress (revisions 8816 and 8817); when Jenkins was free, it commenced a build of the documentation that incorporated both those changes, meaning that no independent build of revision 8816 was created. Only revision 8817 was built. (At least, that's my current understanding based on observation.)

What this means in practice is that, if there are many editors making changes and commits, we will only see the results of our commits (in terms of errors and warnings) mixed in with those from other commits which have happened around the same time. That will make it slightly more difficult to tell whether you caused an error or not, and how you might fix it. So I think it's probably even more important to have a local build environment you can use to test your changes before committing them. While errors can easily be undone by means of reverting, there is a danger that in order to do this, you might have to revert past other people's changes that were committed just after your own.

Permalink 02:11:12 pm, by mholmes, 110 words, 58 views   English (CA)
Categories: Activity log; Mins. worked: 60

First TEI source edits

Made two sets of changes to TEI source and committed them today. Watching to see how Jenkins handles the results. The first one went fine, with no errors (as expected from my local tests). Local tests also show no errors from the second batch of changes (relating to nested bibls), but the first Jenkins build has only just started. I took advanted of the second commit being in two different directories to stagger the commits, so that Jenkins will (presumably) start two separate builds; I'm now waiting to see if it does them serially or in parallel. We need to figure this out for our own local copy of Jenkins.

Permalink 01:36:10 pm, by mholmes, 64 words, 91 views   English (CA)
Categories: Activity log; Mins. worked: 15

Fix to XSLT issue

My previous changes caused a change to the way paragraphs were displayed in the popup references. I've now refined the XSLT a little so that paragraphs in references no longer get the host document's default paragraph styles added to them (as they shouldn't, because they're editorial content and should be consistent across the collection, rather than varying with the style of their host documents).

Permalink 01:04:51 pm, by mholmes, 47 words, 62 views   English (CA)
Categories: Activity log; Mins. worked: 10

TEI source/guidelines editing

Command-line run from /trunk/P5 to get the errors out to a timed file, for diffing against previous error output:

make 2> /home/mholmes/WorkData/tei/make_errors_`date +"%Y-%m-%dT%H:%M:%S"`.txt

(Just to save me from mistyping and forgetting and having to re-learn.)

Permalink 11:57:11 am, by jamie, 286 words, 356 views   English (CA)
Categories: Activity log; Mins. worked: 60

VPN: installed new custom WordPress plugin

Installed the VPN Search WordPress plugin (and widget) that I wrote for the VPN website. It searches the external VPN poetry database and displays the results within WordPress. The PHP code is fully documented.

These guides, from the WordPress site, are especially useful for writing a WP plugin:

The readme.txt file that comes with the plugin:



=== VPN Search ===
Requires at least: 3.0
Tested up to: 3.1

Provides an interface to search the external Victorian Poetry Network database.

== Description ==

VPN Search provides an interface to search the external Victorian Poetry Network database, via a standalone search form and results page.

Usage once installed (see below) is simple. You can either use the widget that comes with the plugin to place the form in one of your widget-enabled areas (the recommended way), or place this code wherever you want the search form to appear (for example, in the sidebar): 

Use as you would a normal search engine. The search engine has support for boolean operators. See this Google page for more info: http://www.google.com/support/websearch/bin/answer.py?answer=136861

== Installation ==

1. Upload the vpn-search directory to your '/wp-content/plugins/' directory
2. Modify the database connection variables in the 'config.php' file in the vpn-search directory
3. Active the plugin through the 'Plugins' menu in WordPress
4. Copy vpn-search-results.php and vpn-single-record.php from the plugin directory to your theme's directory and modify to suit. These templates show search results and single records respectively
5. To options for using:
   A: wherever you want the search form to appear, place ''
   B: use the widget to put the search form in one of your sidebars

You're done!

== Changelog ==

= 0.1 =
* Initial release

Permalink 11:03:33 am, by jamie, 43 words, 119 views   English (CA)
Categories: Academic; Mins. worked: 5

VPN site: switched to PHP 5

Had to flip the switch from php4 to php5 for the VPN WordPress site because the new VPN poetry database plugin requires version 5. unix.uvic.ca uses php4 by default, so to enable php5 this goes into the .htaccess file:

SetEnv UVPHP_VERSION 5

Permalink 11:00:05 am, by mholmes, 232 words, 212 views   English (CA)
Categories: Activity log; Mins. worked: 90

Implementation of coming-week events list

I've now implemented the plans described in this previous post, as follows:

  • The rssReaderManyDepts.php file has been modified in a couple of places, to add an optional parameter (default value "true") called $includeDesc, which is used to control whether or not the Description field is included when the full event detail is written out. This doesn't change any other behaviour elsewhere on the site, but enables me to suppress the description information when I need to.
  • A new page (aboutus/eventsWeek.php) has been created. This instantiates a special instance of the rssReader class, which is set to retrieve events for only 8 days. This class then writes out the events twice, once in short form (for copy-pasting into the email) and once in long form (so that the speaker information can be retrieved and copy-pasted into the email too, where appropriate).
  • The new page does not include the normal right-column listings, because its special version of the RSS reader wouldn't be able to provide them, since it's only retrieving 8 days of material. However, this is not a page intended for the public anyway, so it doesn't really matter whether it's complete or not.
  • This special reader uses its own cache file, so as not to step on the toes of the other two instances of readers used on the site.

I've emailed BLT to let him know about the new page.

Permalink 10:52:45 am, by jamie, 55 words, 80 views   English (CA)
Categories: Academic; Mins. worked: 15

Update to VPN site navigation

At the request of AC, removed the "Twitter Feed" page link from the navigation menu. The menu is just a dynamic link of the pages (i.e. the stuff in the "Pages" section of the WordPress dashboard), so to exclude the Twitter Feed page from the navigation I installed the Exclude Pages from Navigation plugin.
Permalink 09:53:18 am, by mholmes, 175 words, 206 views   English (CA)
Categories: Activity log; Mins. worked: 90

Fixes for Humanities site to make pages validate

Preparing to write the new Events feed page requested by BLT, I first set about fixing a bunch of errors in the existing code:

  • The RSS reader class (includes/rssReaderManyDepts.php) function writeOutTitle() did not echo open <li> and close </li> tags around its content, although it is called in the context of a <ul> tag. Added the appropriate tags, and also commented out <br/> tags which were being used to space the content.
  • The RSS reader class (includes/rssReaderManyDepts.php) function writeOutEvent() echoed out two <br/>s and an <hr/> after closing the <li> tag; this obviously was invalid, so I've moved them inside the <li> tag.
  • <includes/rightColumn.inc> had two elements with the same id attribute (rightCol_1). I changed the second to rightCol_1a.
  • <includes/rightColumn.inc> had an unclosed <ul> (in rightCol_2). That's now closed.

Pages now validate, so I can move on to the new events output page.

18/04/11

Permalink 05:58:52 pm, by mholmes, 22 words, 45 views   English (CA)
Categories: G&T Hours; Mins. worked: 0

MDH: 121 + 2.5 = 123.5 hours G&T

Pressure of work on Properties project along with deadline for DHSI materials and unavoidable admin stuff made for a very long day.

Permalink 05:57:25 pm, by mholmes, 36 words, 51 views   English (CA)
Categories: Activity log; Mins. worked: 60

Meeting with Systems re VMs for INKE

Met with MR, along with JA, GN and CL, and RS on Skype, to discuss the provisioning and admin of VMS for the INKE project. Made good progress; my summary sent out to everyone by email.

Permalink 04:44:24 pm, by mholmes, 358 words, 102 views   English (CA)
Categories: Activity log; Mins. worked: 120

Working on a new view of titles with munged ethnicity

Started experimenting with building a view of the titles table which will include a sort of composite ethnicity column, as detailed in the preceding post. I now have the key owner and ethnicity data munged together in a view created like this:

CREATE VIEW VW_titles_composite_eth AS
(SELECT 
titles.ttl_title_id,
titles.ttl_title_code,
titles.ttl_date,
CAST(group_concat(owners.own_owner_id separator ', ') AS CHAR) AS concat_owners,
CAST(group_concat(owners_to_ethnicities.ote_ethnicity_id_fk separator ', ') AS CHAR) AS concat_eth_ids,
group_concat(ethnicities.eth_name separator ', ') AS concat_ethnicities,
(SELECT IF (COUNT(owners.own_owner_id) > 1, 'multiple', 'single')) AS multi_owner,
(COUNT(owners.own_owner_id)) AS total_owners,
(SELECT CASE
WHEN group_concat(ethnicities.eth_name separator ', ') LIKE "%Japanese%" AND group_concat(ethnicities.eth_name separator ', ') LIKE "%Chinese%" THEN "c"
WHEN group_concat(ethnicities.eth_name separator ', ') LIKE "%Japanese%" AND (SELECT COUNT(DISTINCT(ethnicities.eth_name))) > 1 THEN "b"
WHEN group_concat(ethnicities.eth_name separator ', ') LIKE "%Chinese%" AND (SELECT COUNT(DISTINCT(ethnicities.eth_name))) > 1 THEN "a"
WHEN (SELECT COUNT(DISTINCT(ethnicities.eth_name))) > 1 THEN "d"
ELSE SUBSTRING_INDEX(group_concat(ethnicities.eth_name separator ', '), ',', 1)
END) AS munged_ethnicity
FROM titles
JOIN owners_to_titles ON owners_to_titles.ott_title_id_fk = titles.ttl_title_id
JOIN owners ON owners_to_titles.ott_owner_id_fk = owners.own_owner_id
JOIN owners_to_ethnicities ON owners.own_owner_id = owners_to_ethnicities.ote_owner_id_fk
JOIN ethnicities ON owners_to_ethnicities.ote_ethnicity_id_fk = ethnicities.eth_ethnicity_id
GROUP BY titles.ttl_title_id)

This has the following values, as previously requested:

  • a = Mixed ethnicity with Chinese
  • b = Mixed Ethnicity with Japanese (include Japanese provisional)
  • c = Mixed ethnicity with Chinese and Japanese
  • d = Mixed ethnicity--ALL Others (all not included above, including mixes that include the Asia: other category but neither Japanese or Chinese, if they include both Asia other and Japanese or Chinese, categorize as indicated above)
  • ELSE--> copy the single ethnicity (or shared ethnicity) here
Permalink 04:19:35 pm, by Matthew, 752 words, 115 views   English (CA)
Categories: Activity log; Mins. worked: 90

Revisions: Apollodorus 1.9.21-2.1.3

§ 1.9.21 - ID209, Lycurgus (2) is mortal father of Opheltes (not mentioned in 1.9.21) **Moved to 1.9.14**
§ - Add group "Harpies"? Harpys/Nicothoe/Aellopus and Ocypete/Ocythoe/Ocypode are part of this group **Added all to group "Harpy", created new character "Harpys", edited character "Aeollpusm" to correct spelling, "Aeollopus" instead**
- ID650-ID654, Zetes and Calais chase the Harpies (Aello and Aellopusm are mentioned, but not found in text, instead put Harpys/Nicothoe/Aellopus and Ocypete/Ocythoe/Ocypode?) "event/character/citation" **
- Important note: Apollodorus states in 1.2.6 that Thaumas and Electra had the Harpies, Aello and Ocypete. In 1.9.21 he uses the above names for them, which in the case of Aello he calls her Aellopus in this section. Is this a translation choice or what is happening here? Also there are two entries for "Aello" in the database, without a (#) after their names, please check what's happening here as well. The first has a note in the character tab stating "aka Nicothoe,Aellopus", while the 2nd has nothing attributed. Ought we to delete the 2nd Aello?
- ID655, Remaining Harpy flees (Ocypete is mentioned, add aliases Ocythoe and Ocypode?) "event/character/citation"
- ID656, Harpy falls from exhaustion (Ocypete is mentioned, add aliases Ocythoe and Ocypode?) "event/character/citation"
* - ID227, Harpy falls from exhaustion (Echinadian Islands is mentioned, but these are also known as Strophades Islands, add this place also?) "event/place"
§ 1.9.22 - ID210, Autolycus is mortal father of Polymede (not mentioned in 1.9.22)
§ 1.9.23 - ID211, Hagnias is mortal father of Tiphys (not mentioned in 1.9.23)
- ID234/1252, Apsyrtus is son of Idyia and Aeetes (not specifically mentioned although he is the brother of Medea, is it o.k. to assume this?) **Nevermind**
- Add event where Jason yokes the wild fire-breathing bulls in order to get the fleece? **Nevermind**
§ - ID233, Medea gets Jason the Golden Fleece (misspelled "Colchis" as "Cholcis", change?)
- Important note: There is a place in the database called "Cholcis" with GIS co-ordinates, and its note states "aka Sebastopolis". There are no events or characters related to this place in the text, but a search of "Cholcis" on perseus brings it up once in Ovid's Amores, and nowhere in Apollodorus is it cited.
§ 1.9.24 - ID676, An island speaks to the Argonauts (the text says the ship spoke to them, change?) **Changed to "The Argo speaks to the Argonauts as they pass the Apsyrtides Islands**
§ - ID684/685, Butes swims off … settles him on Lilybaeum (not mentioned in 1.9.24, belongs in 1.9.25)
1.9.25 - Add group "Phaeacians"? (Alcinous is mentioned as being king) **Nevermind**
§ 1.9.26 - ID703, Pelias forces Aeson to kill himself … kills Promachus (not mentioned in 1.9.26, belongs in 1.9.27)
§ - Add event "Argo sails past" and place "Euboea and Locris"? **Added Euboea and Locris to places for new event "Argo sails between"**
1.9.27 - ok
1.9.28 - ID1296/1881, Perses (2) is the son of Perseis and the Sun (Helios) (not mentioned in 1.9.28) **Nevermind this is inferred by being the brother of Aeetes**

BOOK 2
2.1
§ 2.1.1 - ID240, Piren is mortal father of Phoroneus (not mentioned in 2.1.1) "character/character/citation" **Deleted**
§ 2.1.2 - ID738-744, Argos rules the Peloponnese …, Argos marries and has children (Should it not be spelled "Argus"?) "event/character/citation" **Changed to Argus (2)**
2.1.3 - Argus (3) is mortal father of Iasus (1) ("Argus and Ismene…had a son Iasus", add?) "character/character/citation" **Nevermind, already done**
§ - Piren is mortal father of Io ("Hesiod and Acusilaus say that she was a daughter of Piren", add?) "character/character/citation"
- Zeus is god father of Epaphus ("Zeus seduced [Io]…" is this enough to say that he was the father?) "character/character/citation"
§ - ID2695, Telegonus (3) is spouse of Io (add vice versa?) "character/character/citation"
§ - ID756-759, Hermes rescues the cow Ino on Zeus' orders… (change "Ino" to "Io"?) "event/character/citation"
§ - ID769, Io goes looking…finds him in Syra with the wife of king Byblus (change "Syra" to "Syria"?) "event/character/citation"
§ - ID279, Hermes rescues the cow Ino on Zeus' orders… (change "Ino" to "Io"?) "event/place"
§ - ID289, Io goes looking…finds him in Syra with the wife of king Byblus (change "Syra" to "Syria"?) "event/place"
- Important note: the character "Wife of the king of Byblus" is found cited solely in the "character/character/citation" tab of Apollod. 2.1.3 as the foster mother of Epaphus (ID2329). Ought we to keep this character or delete? Specifically, is she important enough (probably not since she's not cited in any event or group) to warrant being in the database? Please check this, I'll keep her in until I hear anything further.

Permalink 03:29:17 pm, by jamie, 339 words, 87 views   English (CA)
Categories: Activity log; Mins. worked: 60

New views: origins, nationalities, races, bands, mother tongue

Added more views to the PostgreSQL database to generate lists of values that are present in the census data, for the advanced search form.

vOriginsUsed - used for the "Birthplace", "Birthplace of Father", and "Birthplace of Mother" fields:


CREATE VIEW "vOriginsUsed" AS

SELECT origin_id, origin

FROM "origins"  

WHERE origin IS NOT NULL   

AND origins.origin_id IN (
    SELECT "vCensus1881".birthplace_id FROM "vCensus1881"
    UNION
    SELECT "vCensus1881".birthplace_father_id FROM "vCensus1881"
    UNION
    SELECT "vCensus1891".birthplace_id FROM "vCensus1891"
    UNION
    SELECT "vCensus1891".birthplace_father_id FROM "vCensus1891"
    UNION
    SELECT "vCensus1891".birthplace_mother_id FROM "vCensus1891"
    UNION
    SELECT "vCensus1901".birthplace_id FROM "vCensus1901"
    UNION
    SELECT "vCensus1911".birthplace_id FROM "vCensus1911"
    )  
    
ORDER BY upper(origin)

The origins view is pretty slow because of the large number of SELECT subqueries.

vNationalitiesUsed - used for the "Nationality" search field:


CREATE VIEW "vNationalitiesUsed" AS

SELECT nationality_id, nationality

FROM "nationalities"

WHERE nationality IS NOT NULL

AND nationalities.nationality_id IN (
    SELECT "vCensus1901".nationality_id FROM "vCensus1901"
    UNION
    SELECT "vCensus1911".nationality_id FROM "vCensus1911"
)

ORDER BY upper(nationality)

vRacesUsed - used for the "Race/Ethnic Origin" search field:


CREATE VIEW "vRacesUsed" AS

SELECT race_id, race_name

FROM "races"

WHERE race_name IS NOT NULL

AND races.race_id IN (
    SELECT "vCensus1901".race_id FROM "vCensus1901"
    UNION
    SELECT "vCensus1911".race_id FROM "vCensus1911"
)

ORDER BY upper(race_name)

vBandsUsed - used for the "First Nations Band" search field:


CREATE VIEW "vBandsUsed" AS

SELECT band_id, band

FROM "band"

WHERE band IS NOT NULL

AND band.band_id IN (
    SELECT "vCensus1881".band_id FROM "vCensus1881"
    UNION
    SELECT "vCensus1891".band_id FROM "vCensus1891"
)

ORDER BY upper(band)

vMotherTonguesUsed - used for the "Mother Tongue", "First Language Spoken", and "Second Language Spoken" search fields:


CREATE VIEW "vMotherTonguesUsed" AS

SELECT mother_tongue_id, mother_tongue

FROM "mother_tongues"

WHERE mother_tongue IS NOT NULL

AND mother_tongues.mother_tongue_id IN (
    SELECT "vCensus1901".mother_tongue_id FROM "vCensus1901"
    UNION
    SELECT "vCensus1911".first_language_id FROM "vCensus1911"
    UNION
    SELECT "vCensus1911".second_language_id FROM "vCensus1911"
)

ORDER BY upper(mother_tongue)

Permalink 12:43:33 pm, by mholmes, 26 words, 77 views   English (CA)
Categories: Academic; Mins. worked: 15

Updates to Pacific Asia site

Minor updates on DR's instructions. Also an email discussion about the future move to CASCADE; DR would like to be able to edit the site directly.

Permalink 12:42:46 pm, by mholmes, 27 words, 50 views   English (CA)
Categories: Activity log; Mins. worked: 30

Meeting re French dept site project

Met with CC and CH to complete the "project lite web" document, which we've now submitted, along with a new version of the navigation plan, to AR.

Permalink 12:29:41 pm, by lspwong, 70 words, 92 views   English (CA)
Categories: Academic; Mins. worked: 0

"A.C.N./P.C.N." changed back to "av./ap. J.-C."

CC and I decided to revert to our old dating system using "av./ap. J.-C." instead of the more modern dating system "A.C.N./P.C.N." in our references because it is more widely used. I have made these changes to all applicable references in the references.xml file. All dates written in references from now on will also use the "av./ap. J.-C." dating system.
Permalink 10:06:24 am, by jamie, 142 words, 57 views   English (CA)
Categories: Activity log; Mins. worked: 30

New view for all used occupations

Made a new view, "vOccupationsUsed", to get a list of all occupations that show at least once in any of the census data sets (1881-1911). This will enable the "occupations" pop up list in the advanced census form only to show occupations that are present in the census data. Other views for religion, race, birthplace, etc. will follow.

CREATE VIEW "vOccupationsUsed" AS 

SELECT DISTINCT ON (upper(occupation_description)) occupation_description AS occupation_description, occupation_id, occupation_code

FROM "occupation"

WHERE 
    occupation_description IS NOT NULL 
    
    AND 
    (
        (occupation.occupation_code IN (SELECT "vOccupations1881".code FROM "vOccupations1881" WHERE "vOccupations1881".count1881 > 0))
        OR
        (occupation.occupation_code IN (SELECT "vOccupations1891".code FROM "vOccupations1891" WHERE "vOccupations1891".count1891 > 0))
        OR
        (occupation.occupation_code IN (SELECT "vOccupations1901".code FROM "vOccupations1901" WHERE "vOccupations1901".count1901 > 0))
        OR
        (occupation.occupation_code IN (SELECT "vOccupations1911".code FROM "vOccupations1911" WHERE "vOccupations1911".count1911 > 0))
    )

ORDER BY upper(occupation_description)

Permalink 09:32:42 am, by mholmes, 17 words, 38 views   English (CA)
Categories: Activity log; Mins. worked: 45

Submitting expenses for Chicago

The usual form-filling and photocopying. Mailed in the package and also posted a zip copy as backup.

Permalink 09:31:36 am, by mholmes, 45 words, 50 views   English (CA)
Categories: Activity log; Mins. worked: 30

Another working TEI build environment set up

Following my own instructions in the previous post, got my working build environment set up on the work computer, and ran a test build. I'm now running another build, saving the output to a file so I can examine the errors coming out of tests.

17/04/11

Permalink 05:05:00 pm, by mholmes, 25 words, 50 views   English (CA)
Categories: G&T Hours; Mins. worked: 0

MDH: 114 + 7 = 121 hours G&T

Trying to get TEI- and DHSI-related work out of the way over the weekend so I can get back to regular project work by Tuesday.

Permalink 05:00:39 pm, by mholmes, 235 words, 135 views   English (CA)
Categories: Activity log; Mins. worked: 180

TEI Council work

Follow-up work arising out of the council meeting:

  • Set up and tested a working build environment (here documented because I'll have to do it at work too):
    • Setting up repo:
      gpg --keyserver wwwkeys.uk.pgp.net --recv-keys FEA4973F86A9A497
      sudo apt-key add ~/.gnupg/pubring.gpg 
    • Add to /etc/apt/sources.list:
      deb http://tei.oucs.ox.ac.uk/teideb/binary ./
      
    • Installing packages:
      sudo apt-get update
      sudo apt-get install psgml xmlstarlet debiandoc-sgml linuxdoc-sgml jing jing-trang-doc libjing-java rnv texlive-xetex
      sudo apt-get install trang-java tei-p5-doc tei-emacs saxon nxml-mode-tei tei-p5-xsl  tei-p5-xsl2 tei-roma onvdl
      
    • Removing gcj to avoid confusion (advice from here):
      sudo apt-get remove `apt-cache search gcj | grep gcj | awk '{print $1}'`
      
    • Checking out the source (in home dir):
      mkdir tei
      cd tei
      svn co https://tei.svn.sourceforge.net/svnroot/tei .
      
    • Test-build of the source:
      cd trunk/P5
      make
      
      Doing this for the first time, the main build was fine, as were most of the tests, but some tests towards the end threw up errors; I'm not sure yet which of these errors might be significant, and how to find that out or do anything about it.
  • Went through the minutes from the meeting and gave a bit of feedback.
  • Did some reading around in the source code to prepare for my first edit.
  • Posted details of my planned edit on the relevant ticket to get feedback before making any actual changes.
Permalink 11:55:04 am, by mholmes, 34 words, 63 views   English (CA)
Categories: Activity log; Mins. worked: 240

XSLT workshop preparation work

Posting time spent over the weekend on preparation work for the workshop (creation of stage diagrams stepping through various files and processes), editing of existing presentations, and a conference call with SB and DJB.

15/04/11

Permalink 11:24:52 pm, by mholmes, 4 words, 50 views   English (CA)
Categories: G&T Hours; Mins. worked: 0

MDH: 115 - 1 = 114 hours G&T

Left a little early.

Permalink 04:15:44 pm, by Matthew, 1666 words, 91 views   English (CA)
Categories: Activity log; Mins. worked: 270

Revisions: Apollodorus 1.8-1.9.20

1.8
§ 1.8.1 - Althaea is daughter of Thestius (add?) "character/character/citation"
§ - ID290-294, Fates visit Althaea, tell her about Meleager and the log (this belongs in 1.8.2) "event/character/citation"
§ - ID101, ibid. (this belongs in 1.8.2) "event/place"
§ 1.8.2 - Idas and Lynceus are sons of Aphareus (add?) "character/character/citation"
§ - Admetus is son of Pheres (add?) "character/character/citation"
§ - Ancaeus is son of Lycurgus (add?) "character/character/citation"
§ - Atalanta is daughter of Schoeneus (add?) "character/character/citation"
§ - Amphiaraus is son of Oicles (add?) "character/character/citation"
- ID1958, Meleager son of Ares (incorrect?) "character/character/citation" **Nevermind**
- Hyleus was killed by the boar, not mentioned earlier in "character/character/citation" (perhaps he is one of Thestius' sons? "With them came also the sons of Thestius") **Nevermind**
- Artemis not mentioned in boar hunt, but she was the one that brought the beast out of wrath (should she be mentioned in group "Boar hunt?") "group/character/citation" **Nevermind**
§ - Meleager and Dryas not included in event "starting out for the Calydonian boar hunt" (add?) "event/character/citation"
§ - Oeneus not included either, although he was the one that called together the men for the hunt (add?) "event/character/citation"
§ 1.8.3 - ID336/337, Olenus is sacked, Oeneus gets Periboea as a prize (a city is mentioned as being sacked in 1.8.3, but these details appear in 1.8.4) "event/character/citation"
§ - ID118, ibid. "event/place"
1.8.4 - Hipponous sent Periboea "away from Olenus in Achaia to Oeneus" (add place/region?) "event/place"
1.8.5 - Tydeus spouse of Deipyle, and vice versa (add?) "character/character/citation" **Nevermind**
1.8.6 - ok
1.9
§ 1.9.1 - Athamas is the son of Aeolus (add?) "character/character/citation"
§ - ID2697, Athamas spouse of Nephele (add Nephele spouse of Athamas) "character/character/citation"
- ID2705/2707, Minos spouse of Pasiphae (duplicate record, erase one?) "character/character/citation" **Already done, nevermind**
- "Phrixes came to the Colchians, whose king was Aeetes" (add Aeetes to group "Colchians?") "group/character/citation" **Nevermind**
§ - ID410-416, Nephele plots against Helle and Phrixus, sets Phrixus up for sacrifice (should be Ino instead of Nephele, change?) "event/character/citation"
§ 1.9.2 - Athamas spouse of Themisto, vice versa (add?) "character/character/citation"
§ - ID1630, Nephele is mortal mother of Helle (not mentioned in 1.9.2) "character/character/citation"
§ 1.9.3 - ID452, Deion reigns over Phocis (doesn't belong in 1.9.3, move to 1.9.4) "event/character/citation"
§ - ID158, ibid. (doesn't belong in 1.9.3) "event/place"
1.9.4 - Move ID452 from 1.9.2 into 1.9.3 **Nevermind**
§ 1.9.5 - Perieres spouse of Gorgophone, vice versa (add?) "character/character/citation" **It is Perieres (2) that married Gorgophone (1), but see below**
- Important note: Perieres (1) and Perieres (2), what is the difference?? Perieres (1) is in database as the son of Aeolus, whilst Perieres (2) as the son of Cynortas. However, this chapter states that Perieres (1) may have instead of being the son of Aeolus, was the son of Cynortas. Therefore, ought we to have just Perieres (1) in the database and everything cited to Perieres (2) changed to Perieres (1) instead? For now I added Perieres (1) as the spouse of Gorgophone (1). Please check this.
§ - Perieres is son of Cynortas (add?) "character/character/citation" **I added Perieres (1) as son of Cynortas, see above for why**
§ - Perieres is mortal father of Aphareus and Leucippus (1) (add?) "character/character/citation" **Same as above**
- ID455/456, Perieres takes over Messene (two Perieres, 1 and 2 are mentioned, which one is it?) "event/character/citation" **For now I kept both in until I hear more on this subject**
§ 1.9.6 - ID2677, Magnes (2) spouse of Naiad nymph (add Naiad nymph as spouse of Magnes (2)) "character/character/citation"
§ - ID2266, Naiad nymph is god mother of Cynortas (this ought to be Dictys instead?) "character/character/citation"
1.9.7 - Salmoneus imitates Zeus (add event?) "event/character/citation" **Nevermind**
§ 1.9.8 - ID1090, Cretheus is foster father of Dictys (in text it says "Tyro…was brought up by Cretheus", change?) "character/character/citation"
1.9.9 - Neleus is spouse of Pylus, vice versa (add?) "character/character/citation" **Nevermind**
- ID167/1213, Psidice daughter of Nestor & Anaxibia (1) (misspelled, should be "Pisidice") "character/character/citation" **There is a bit of a problem with the character Pisidice. In the database, Pisidice (1) is the daughter of Aeolus and Enarete (see 1.7.3), whilst Pisidice (2) is the daughter of Anaxibia (2) (this Anaxibia is the daughter of Bias) and Pelias (as in 1.9.10). In Apollod. 1.9.9, there is a Pisidice that is the daughter of a DIFFERENT Anaxibia (1) (daughter of Craetieus) and Nestor. Therefore, we have 3 different Pisidices, but only 2 in the database. The missing Pisidice ought to be put in and made the daughter of Nestor and Anaxibia (1). I won't change anything until I get this has been verified.**
- "Nestor alone was brought up among the Gerenians" (add group "Gerenians"?) "group/character/citation" **Nevermind**
§ - ID497, Hercules and Periclymenus fight at Pylus…, Abas (1) (not mentioned, erase?) "event/character/citation"
§ 1.9.10 - ID2405, Anaxibia (2) is spouse of Pelias (add Pelias is spouse of Anaxibia (2)?) "character/character/citation"
§ - ID2406, Phylomache is spouse of Pelias (ibid) "character/character/citation"
§ 1.9.11 - Tyro is daughter of Salmoneus (add?) "character/character/citation"
§ - ID2639, Idomene is spouse of Amythaon (add Amythaon is spouse of Idomene?) "character/character/citation"
§ 1.9.12 - Pero is daughter of Neleus (add?) "character/character/citation"
§ 1.9.13 - Mecisteus is mortal father of Euryalus (2) (add?) "character/character/citation"
§ - Pronax is mortal father of Lycurgus (add?) "character/character/citation"
§ - Pronax is mortal father of Amphithea (add?) "character/character/citation"
§ - Adrastus (1) is mortal father of Argia, Aegialeus and Cyanippus (add?) "character/character/citation"
§ - "Promachus…marched with the Epigoni against Thebes" (add group "Epigoni"?) "group/character/citation"
§ - ID191, Euryalus goes to Troy, -UNSPECIFIED- (change to Troy?) "event/place"
§ - "Promachus… marched with the Epigoni against Thebes" (add event/place Thebes?) "event/place"
§ 1.9.14 - Cretheus is mortal father of Pheres (add?) "character/character/citation"
§ - Pheres is mortal father of Admetus and Lycurgus (add?) "character/character/citation"
§ - ID2721, Lycurgus (2) is spouse of Eurydice (5) (add vice versa?) "character/character/citation"
§ - ID2735, Ibid., (add vice versa?) "character/character/citation"
§ - ID202, Mecisteus (2) is mortal father of Euryalus (2) (doesn't belong in 1.9.14) "character/character/citation" **Moved to 1.9.16**
§ - Lycurgus (2) is mortal father of Opheltes (add?) "character/character/citation"
- Opheltes "afterwards called Archemorus" (add Archemorus as son of Lycurgus & Eurydice/Amphithea?) "character/character/citation" **Nevermind**
- ID553-556, Lycurgus moves to Nemea, marries and has a family (add Archemorus?) "event/character/citation" **Nevermind**
- ID192, Pheres founds Pherae (Pheres "founded Pherae in Thessaly", add this to description?) "event/place" **Nevermind**
§ 1.9.15 - ID203, Pronax is mortal father of Lycurgus (1) (doesn't belong in 1.9.15) "character/character/citation" **Moved to 1.9.13**
§ - ID566/567, Admetus and Alcestis get married, forget to sacrifice to Artemis (add Artemis?) "event/character/citation"
§ 1.9.16 - Cretheus is mortal father of Aeson (add?) "character/character/citation"
§ - Polymede is daughter of Autolycus (add?) "character/character/citation"
§ - Tiphys is son of Hagnias (add?) "character/character/citation"
§ - Orpheus is son of Oeagrus (add?) "character/character/citation"
§ - Idas and Lynceus are sons of Aphareus (add?) "character/character/citation"
§ - Amphiaraus is son of Oicles (add?) "character/character/citation"
§ - Atalanta is daughter of Schoeneus (add?) "character/character/citation"
§ - Admetus is son of Pheres (add?) "character/character/citation"
§ - Acastus is son of Pelias (add?) "character/character/citation"
§ - Ancaeus is son of Lycurgus (add?) "character/character/citation"
§ - Iphiclus is son of Thestius (add?) "character/character/citation"
§ - Euryalus is son of Mecisteus (add?) "character/character/citation"
- Peneleos is son of Hippalmus (add?) "character/character/citation" **Already done, nevermind**
§ - ID204, Pronax is mortal father of Amphithea (doesn't belong in 1.9.16) "character/character/citation" **Moved to 1.9.13**
§ - ID234, Argus (3) is an Argonaut (but in char/char/cite it says Argus (1), what is the difference between Argus 1 and 3?) "group/character/citation" **Changed to Argus (1), since Argus (3) isn't mentioned until later on in Apollod. 2.1.3**
§ - ID246, Idmon (1) is an Argonaut (but he is not mentioned in 1.9.16, please clarify) "group/character/citation" **Moved to 1.9.23**
- ID577/578, Jason lives in Iolcus (should we include Cretheus, who was king before Pelias?) "event/character/citation" **Nevermind**
§ 1.9.17 - ID205, Adrastus is mortal father of Argia (doesn't belong in 1.9.17) "character/character/citation" **Moved to 1.9.13**
- Add a new group "Lemnian women"? Hypsipyle is a Lemnian **Nevermind**
§ - ID625, Lemnian capture women from Thrace (is it supposed to say Lemnian men?) "event/character/citation" **Event cites Abas (1), I deleted this record and changed the event name to "Lemnian men capture women from Thrace"**
- Add new event "Argonauts have intercourse with Lemnian women"? **Nevermind**
§ 1.9.18 - ID206, Adrastus is mortal father of Aegialeus (not mentioned in 1.9.18) "character/character/citation" **Moved to 1.9.13**
- Add a new group "Doliones"? Cyzicus is king of the Doliones **Nevermind**
§ - ID631, Argo goes among the Doliones, slaughter (should this be clarified to say they accidentally killed the Doliones because at night they mistook the Argonauts for the Pelasgian army?) "event/character/citation" **Changed event text to "Argo goes among the Doliones, Argonauts and Doliones accidentally slaughter each other"**
* - ID214, Argo goes among the Doliones, slaughter (the location is Doliones, but these are the inhabitants, should this say "Nowhere" instead?) "event/place"
§ 1.9.19 - ID207, Adrastus is mortal father of Cyanippus (this doesn't belong in 1.9.19) "character/character/citation" **Moved to 1.9.13**
§ - According to Demaratus, Hercules sailed to Colchis (add event?) **Added events: "Hercules leads the Argonauts", "Hercules sails to Colchis" to account for different tales of the Argo's adventures involving Hercules**
- ID217, Polyphemus founds Cius (location is Cius, but text says Cius is in Mysia, should this be the location instead?) "event/place" **Nevermind**
§ - ID220, Hercules left behind by the Argo at Aphetae (location is Aphetae, but text says Aphetae is in Thessaly, should this be the location instead?) "event/place" **Added note to record stating "Located in Thessaly"**
§ 1.9.20 - ID208, Pheres is mortal father of Lycurgus (doesn't belong in 1.9.20) "character/character/citation"
- Add event "Pollux kills King Amycus in a boxing match by a blow to the elbow"? **Nevermind**
- ID221, Argonauts go to the Land of the Bebryces (the location is Land of the Bebryces, should it be "Nowhere" instead?) **Nevermind**

Permalink 02:14:36 pm, by jamie, 53 words, 71 views   English (CA)
Categories: Activity log; Mins. worked: 120

Changes made as per last meeting

Made all changes, and committed to the development site, from the last meeting EXCEPT for "When choosing occupations, races, birthplaces, relationships to head, etc. in the advanced search form, only display values that have corresponding census records". Due to the inconsistency between some of the codes, that will take a little while longer.
Permalink 01:55:11 pm, by mholmes, 5 words, 57 views   English (CA)
Categories: Activity log; Mins. worked: 120

Meeting with UBC library folks

Meetings before and after lunch.

Permalink 12:28:01 pm, by jamie, 68 words, 60 views   English (CA)
Categories: Activity log; Mins. worked: 30

SQL to update census_1911 location ID

Since location_id isn't part of the 1911 records insert, but sub_district_id is, use this SQL to update the location_id after you've put a row into the location table corresponding to the new sub-district:


UPDATE census_1911 SET location_id = (SELECT location.location_id FROM location WHERE location_02_id = '13' AND location_03_id = CAST(census_1911.sub_district_id AS character varying(50)) AND census_year = '1911')

Permalink 11:39:23 am, by jnazar, 7 words, 69 views   English (CA)
Categories: Activity log; Mins. worked: 10

Connect U registration

Registered for Connect U conference, Thursday, June 2

Permalink 11:37:05 am, by jnazar, 54 words, 49 views   English (CA)
Categories: Activity log; Mins. worked: 60

Latin American Studies Website

Received request from BAK today for changes/edits to website:

Updated website:
- All pages: included new upcoming conference information in right column
- Current Events page: included upcoming conference info.
- Home Page: edited first sentence as requested

To be done:
- prep additional images
- set up archival method of Past Events

Permalink 10:34:55 am, by mholmes, 51 words, 66 views   English (CA)
Categories: Activity log; Mins. worked: 120

Presentation for UBC library folks

Prepared a presentation for UBC library folks (meeting this morning) on our XML projects and workflows. Used the opportunity to test LibreOffice; xferred to laptop, which has OpenOffice, and found a problem with fonts when arrows were used. Note to self: dump OpenOffice for LibreOffice everywhere, for better compatibility and stability.

14/04/11

Permalink 05:37:27 pm, by mholmes, 10 words, 49 views   English (CA)
Categories: G&T Hours; Mins. worked: 0

MDH: 114 + 1 = 115 hours G&T

First day back in the office, working through email etc.

Permalink 04:29:35 pm, by mholmes, 193 words, 93 views   English (CA)
Categories: Activity log; Mins. worked: 120

Fixes to CSS and XSLT

Fixed some bugs in CSS and XSLT shown up by Le Bon Mariage:

  • Unordered lists had no default text-align, so they were inheriting it from (eg) a parent text front div, meaning they'd end up centred. It's almost always the case that they should be left-aligned, so I made that the default in the CSS.
  • Some text paragraphs (those with no @rend attribute) were failing to inherit the default paragraph style from the <teiHeader>; this turned out to be a bug in the XSLT, which I fixed.
  • Marginal (authorial) notes (<note type="marginal">) were being treated as editorial notes, and turned into buttons with popups, so I suppressed that (and see below).

Also added handling for the marginal notes, grouping them in with the arguments, because that's the way to handle them IMHO; in some cases too, judging by EGB's markup, it's hard to tell the difference between them. So the argument markup now handles editorial marginal notes.

In the process, I fixed a few typos in the Bon Mariage XML file too.

Note to self: TOCs are still not being handled at all. That's a must-do sometime soon.

Permalink 04:08:36 pm, by Matthew, 1783 words, 99 views   English (CA)
Categories: Activity log; Mins. worked: 240

Revisions: Apollodorus 1-1.7.10

I am going through and making corrections, mostly spelling or citations in the wrong chapters, etc. I put a § symbol to denote that I have made a revision, otherwise I am either uncertain or after going through a second time realised that said revision is unnecessary. I sometimes use ** double asterisks to denote that I added this in on my 2nd revision and want to better justify whatever change I am making.

APOLLODORUS: LIBRARY
BOOK 1
§ 1.1
§ 1.1.1 - ID140/141/142, Hundred handed (hyphenated in Apoll. not in record?), "group/character/citation"
§ - ID1762-1763, wedding of Earth and Sky, birth of the Hundred-handed (not cited in Apollod. 1.1.2, this section deals with the Cyclopes, delete citation for 1.1.2) "event/character/citation"
§ 1.1.2 - ID1769, wedding between Earth/Sky, Abas (1)?? (Steropes? look this up **This is supposed to be Steropes and not Abas (1), but more importantly this event doesn't belong in 1.1.2, delete) "event/character/citation"
§ - ID1767-1769, wedding of Earth and Sky, birth of the Hundred-handed (this does not belong in 1.1.2, delete) "event/character/citation"
§ - Add event "birth of Cyclopes, Cyclopes cast down into Tartarus" (character: Earth) "event/character/citation"
1.1.3 - ok
1.1.4 - Event "rescued their brethren from Tartarus, committed sovereignty to Cronus." (add event?) **Nevermind**
1.1.5 - ID8, unspecified Titans shut up in Tartarus (all but Cronus and Rhea? add them to list of characters?) "event/place" **Nevermind**
1.1.6 - Group "Curetes" or "nymphs" (no individuals listed, but should this be added as a group?) **Nevermind**
1.1.7 - ibid. **Nevermind**
1.2
1.2.1 - ID15, meeting of those opposed to the Titans with the Cyclopes, Nowhere (should this be in Tartarus?) "event/place" **Nevermind**
- ID72/73/74, Titans imprisoned by the gods, guarded by hundred-handers (Hundred-handeds, typo?) "event/citation/character" **Nevermind**
- Zeus given thunder, lightning & thunderbolt, Pluto given helmet, Poseidon a trident (add this as an event?) **Nevermind**
1.2.2 - ID21, more next generation (unclear, what does this mean?) "event/place" **Nevermind**
- ID20, Oceanids born (to whom? Titans) "event/place" **Nevermind**
§ - Latona born to Coeus/Phoebe (add? Add Latona in group "more next generation") "event/character/citation"
§ - Eurybia (1) is daughter of sea (Pontus)
1.2.3 - ID22, Menoetius (1) hurled into Tartarus in the battle with the Titans (battle with Zeus more accurate?) "event/place" **NEVERMIND**
§ - ID1744-ID1749, more next generation (these belong in 1.2.4 instead) "event/character/citation"
§ 1.2.4 - Victory, Dominion, Emulation, Violence (all need Styx as "other non human entity" mother of these characters) "character/character/citation"
§ - Chiron is a Centaur (add?) "group/character/citation"
- Dawn/Astraeus begat winds & stars (add?)
§ - No events (add "more generation"?)
- ID2330, Philyra (1) is as yet uncategorized mother of Chiron (change to god mother instead?) "character/character/citation"
1.2.5 - ok
§ 1.2.6 - ID2011, Eurybia (1) and Eurybia (2) born to Pontus (Earth is mother of Eurybia (2) so should it only be Eurybia (2) for Pontus also? **Eurybia (1) is the correct one, Eurybia (2) is the daughter of Thespius and mother of Heracles' child Polylaus. Delete entries with Eurybia (2) and correct it to Eurybia (1)**) "character/character/citation"
§ - ID2015, Pontus is god father of Eurybia (2) (delete, see above) "character/character/citation"
§ - ID2055, Earth is god mother of Eurybia (2) (change to Eurybia (1), see above) "character/character/citation"
- Gorgons born (add event?) **Nevermind**
1.2.7 - ok
1.3
§ 1.3.1 - ID2202/2203, Linus (1) & Orpheus born to Calliope (not mentioned in 1.3.1, move to 1.3.2) "character/character/citation"
§ - ID104, various children of Zeus born, Abas (1) (why Abas and not Zeus? is anybody missing from this list? Add Zeus and all those mentioned in "character/character/citation" tab as his children and their mothers, 30 in all) "event/character/citation"
§ - ID2253, Styx is god mother of Persephone (change to other non-human entity) "character/character/citation"
1.3.2 - "Maenads" (add this group? Global question: WHAT to do with mentioned groups & no members??) **Nevermind**
- ID112, Eurydice dies (by snakebite, add?) "event/character/citation" **Nevermind**
§ - ID118/119, Hyacinth born (this should be in 1.3.3) "event/character/citation"
§ - ID31, Hyacinth born (this should be in 1.3.3) "event/place"
§ 1.3.3 - Argiope the nymph (add?) "group/character/citation"
- Important note: we have 2 Argiopes in the database, both same spelling, but the first one in the list has stuff cited whereas the 2nd Argiope down the list has nothing, and in the "character" tab, there is a note stating "same as first Argiope, delete?"
§ - Thamyris has homosexual attraction to Hyacinth, but Apollo loved Hyacinth instead and killed him involuntarily by the cast of a quoit brooch (add this event? or maybe make into 2 events?? it is similar to ID120/121 events **Added "Apollo accidentally killed Hyacinth**) "event/character/citation"
§ - ID33, A bull from Geryon's herd escapes Hercules (doesn't belong in 1.3.3 **delete**) "event/place"
1.3.4 - "Corybantes" (add group?) **Nevermind**
- "Sirens" (add group?) **Nevermind**
§ - ID2246/2247 The Corybantes born to god mother Thalia (is it Thalia (1) or Thalia (2)? Both are mentioned as mother **Delete ID2246, since Thalia (2) is supposed to be the mother**) "character/character/citation"
- Important note: Thalia (1) is the Grace, and Thalia (2) is the Muse of comedy/poetry, correct? The Muse is said to be the mother of the Corybantes, thus Thalia (2)
1.3.5 - ID130/131, Hephaestus lands and hurts his legs (add "saved by Thetis"?) "event/character/citation" **Nevermind**
- Hercules takes Troy and was at sea, Hera sent a storm after him, Zeus hung her from Olympus (add event?)
1.3.6 - ok
1.4
§ 1.4.1 - ID2173/2174, Asteria (1) is mother of Artemis and Apollo (is it not Latona who is the mother? **Change Asteria (1) to Latona**) "character/character/citation"
1.4.2 - ok
1.4.3 - ID157/158/159, Orion fights Oenopion for his daughter Merope (more accurately but more wordy "Orion is blinded by Oenopion and cast to the beach"? next event has to do with the blinding) **Nevermind**
- ID160, Orion kidnaps a boy from the smithy of Hephaestus (with the purpose of leading him to sunrise, where the sun's rays would heal his sight in order to get revenge on Oenopion) **Nevermind**
§ 1.4.4 - Aphrodite causes Dawn to be forever in love with Orion, for bedding with Ares (add?) "event/character/citation"
§ 1.4.5 - ID2352, Amphitrite spouse of Poseidon (add Poseidon spouse of Amphitrite. Global Issue: spouse is often mentioned one way but not vice versa as a 2nd record, should these all be added??) "character/character/citation"
§ - Amphitrite daughter of Ocean, god father (add?) "character/character/citation"
§ - ID2354, Rhode (1) spouse of Sun (Helios) (add Sun (Helios) spouse of Rhode (1)?) "character/character/citation"
§ - Orion killed by Artemis (add event?) "event/character/citation"
- Poseidon marries Amphitrite and has children (add event?) "event/character/citation" **Nevermind**
- Orion killed by Artemis, Nowhere (add?) "event/place" **Nevermind**
1.5
1.5.1 - Celeus reigned over the Eleusinians when Demeter came by (add group?) "group/character/citation" **Nevermind**
§ - ID165/166, Pluto abducts Persephone (add Zeus as a character since he helped?) "event/character/citation"
- Praxithea watched as baby Demophon was burned in the fire (add this character/event?) **Nevermind**
1.5.2 - Triptolemus is the elder of Metanira's children, is Celeus the father (not mentioned) **Nevermind**
- ID1255, ID3563-ID3566, Praxithea sees Demeter...gives Triptolemus a winged chariot and wheat (add "he sows the inhabited earth"?) "event/character/citation" & "event/place" **Nevermind**
- ID1255, ID3563-ID3566, Praxithea sees Demeter put Demophon into the fire...(this part belongs in 1.5.1, remainder is fine in 1.5.2) "event/character/citation" & "event/place" **Nevermind**
§ 1.5.3 - ID2351, Persephone spouse of Pluto (add Pluto spouse of Persephone?)
1.6
§ 1.6.1 - ID177/178/179, Giants born (add Sky?) "event/character/citation"
§ - ID177/178/179 & ID1735/1736/1737, Giants born (mentioned twice, redundant? **delete**) "event/character/citation"
§ - ID56, Giants born in Phlegrae (others say in Pallene, add?) "event/place"
1.6.2 - ok
1.6.3 - ID225/226/227, Zeus attacks Typhon (Clotho Lachesis and Atropus are included, is this correct?) "event/character/citation" **NEVERMIND**
1.7
§ 1.7.1 - ID233/234, Prometheus nailed to the mountain (should Zeus be included since he ordered Hephaestus to nail Prometheus?) "event/character/citation"
§ 1.7.2 - Enarte misspelled, should read "Enarete", correct this
§ - ID1111-ID1122, Enarte mortal mother of multiple (this should be in 1.7.3)
§ - ID239/240/241, Deucalion builds boat at Prometheus' advice, gets on (rather than boat/ark the text says a "chest") "event/character/citation"
- ID245/246/247, Hermes visits Deucalion and Pyrrha, humanity reborn (maybe mention that Deucalion and Pyrrha recreated humanity by tossing stones, also include Zeus as character?) "event/character/citation" **Nevermind**
- Mention most of humanity drowned save a few, and that the mountains of Thessaly then parted? (add event?) **Nevermind**
§ 1.7.3 - ID2363/2365 and more, Enarte spouse of Aeolus (Enarte in all cases should be "Enarete") "character/character/citation"
§ - Perieres missing as mortal son of Aeolus
§ - ID1125/1126, Psidice mother of Antiphus & Actor (misspelled, should be "Pisidice". **Change to Pisidice (1)**) "character/character/citation"
§ - Correct Pisidice in database to "Pisidice (1)" since there is a Pisidice (2) also
- Orseis part of group "nymph"? "group/character/citation"
- Hellen part of group "Hellenes"? "group/character/citation"
- Achaeus part of group "Achaeans"? "group/character/citation"
- Ion part of group "Ionians"? "group/character/citation"
- Dorus part of group "Dorians"? "group/character/citation"
- Aeolus part of group "Aeolians"? "group/character/citation"
- ID251, Dorus gets the Dorian regions (change to "Dorus gets the region over against Peloponnese" instead?) **Nevermind**
§ 1.7.4 - ID2680, Ceyx (1) spouse of Alcyone (3) (add Alcyone spouse of Ceyx?) "character/character/citation"
§ - ID2369, Iphimedia spouse of Aloeus (add Aloeus spouse of Iphimedia?) "character/character/citation"
§ - ID1856, Zeus god father of Endymion (doesn't belong in 1.7.4) "character/character/citation"
- ID86, Artemis kills the Aloads (add the fact that they killed each other with darts trying to hit Artemis in shape of a deer?) "event/place" **Nevermind**
§ 1.7.5 - Endymion may also be son of god father Zeus (add?) "character/character/citation"
- Endymion part of group "Aeolians"? "group/character/citation"
- Endymion on account of his beauty, from Zeus chose to sleep forever (add event?) **Nevermind**
1.7.6 - Aetolus names the Curetian country Aetolia, after himself (add event?) **Nevermind**
§ 1.7.7 - Pleuron spouse of Xanthippe, and vice versa (add) "character/character/citation"
§ 1.7.8 - Aphareus is father of Idas (add) "character/character/citation"
- ID95, Evenus chases them, is unsuccessful, throws himself in a river [Lycormas] and dies (it mentions the river is called Evenus after him, add?)
1.7.9 - Marpessa chooses Idas over Apollo as her husband (add event?)
§ 1.7.10 - Thestius is the mortal father of Leda (add) "character/character/citation"
§ - ID62, Hippodamus (3) is mortal father of Euryte (1) (text says "Hippodamas", different character? **I changed it to "Hippodamas (1), please double-check that this is the correct character**) "character/character/citation"
- ID225/227/231/417, Boar hunt (doesn't belong in 1.7.10. **Eurypylus (1), Evippus, Plexippus, and Iphiclus (1), the sons of Thestius and Eurythemis. Did they partake in the Calydonian boar hunt? If so, they aren't explicitly mentioned in 1.7.10 as participating. Please verify**) "group/character/citation"
- Sterope & Achelous begat the Sirens (add group for "Sirens"?) "group/character/citation" **Nevermind**

Permalink 01:01:27 pm, by mholmes, 288 words, 61 views   English (CA)
Categories: Activity log; Mins. worked: 60

CALICO: checking out connectivity in banquet room

GN and I investigated the dining room situation. We found that it's actually an L-shaped room in three parts, of which I expect only two parts will be used (GN has a floor plan). There are two ethernet ports, one at each end of the L, of which only one (D36) appears to be connected; Greg is confirming this with networking now. Port D41 is not in the database at all, so it may never have been connected. Assuming the event were taking place in the part of the L that contains the working port (the South Dining Room, which has port D36), and assuming we placed the speaker at the end of the room towards the bottom of the plan, and ran a long ethernet cable away from the speaker to the video setup, then we would probably be able to provide connectivity.

On the other hand, if the event is taking place in the North Dining Room, then there may not be a connected ethernet port.

So it's important we find out which part of the dining room will be used. In previous events, we've used the North bit or the South bit, including the middle bit (North + middle bit giving a long thin room across the top of the plan, or South + middle bit giving a slightly smaller room running down from the top). It's also conceivable the whole room would be used, but in that case a speaker at either end would be invisible to some diners, so that's not so likely.

I've written to DA to find out; CC's memory of the arrangements is that it would be the North room that would be used, which would unfortunately be the wrong orientation entirely.

Permalink 11:36:13 am, by jamie, 298 words, 173 views   English (CA)
Categories: Notes; Mins. worked: 60

Meeting with PD

Met with PD today to discuss the integration of the 1911 data thus far, and to go over any changes that need to be made. My task list from the meeting:

  • Fix the occupation and religions table searches, both of which are broken on the development and live sites
  • Add the 1911 information into the locations table:
    • location_02: id 13/"Victoria City"
    • location_03: sub district ID as given by PD (e.g. 10 for Fernwood, 3 for Rock Bay)
  • Remove the "address" field from the advanced search, which is now obsolete thanks to the "street" field
  • Put insurance data into the detail view for 1911 records
  • Change instances of "color" to "colour"
  • Remove "colour" from 1911 views since that data wasn't collected
  • In the summary view of a record, move "Speaks English/French" above "First Language" and "Second Language"
  • Insert missing first/second language information into 1911 data
  • For census record fields that have no information, display a blank field instead of "Unknown" as this glosses over the nuances of the data (i.e. no data vs. illegible or otherwise unknown data)
  • Fix the earnings field in the advanced search, which doesn't seem to work at all
  • Fix a display error in the "Birthdate" field for 1911 records
  • When choosing occupations, races, birthplaces, relationships to head, etc. in the advanced search form, only display values that have corresponding census records
  • Remove erroneous "E" relationship to head and move all records associated with it to "Employee"
  • Add "Hotel" to the building table with an ID of 9
  • Add the amount paid for education field to the 1911 detail view
I am also going to send PD a list of all the annotations for census records submitted by users over the years. He will compile a list of corrections and then we will go through them together to fix the data.
Permalink 08:36:21 am, by mholmes, 6 words, 63 views   English (CA)
Categories: Activity log; Mins. worked: 10

Added Norrman bio

We now have ten complete reviews.

Permalink 08:35:54 am, by mholmes, 15 words, 64 views   English (CA)
Categories: Activity log; Mins. worked: 20

Hispanital: updates to site

Added photos from the LARG 4 event, and a couple of other changes, at DR's request.

13/04/11

Permalink 02:30:07 pm, by Matthew, 879 words, 121 views   English (CA)
Categories: Activity log; Mins. worked: 210

HOMER: ILIAD 2.490-2.630

HOMER: ILIAD

CATALOGUE OF SHIPS

Note: There are many instances of place-names and character names whose spellings are transliterated from the Greek rather than romanized versions, which one are we to use for this text? It matters quite a bit, especially for characters like Aias [Ajax] who is already prominently cited in Apollodorus, for example. For spellings and corrections I was using the following text from Perseus: http://perseus.uchicago.edu/perseus-cgi/citequery3.pl?dbname=GreekFeb2011&getid=2&query=Hom.%20Il.%202

2.490-2.495 - ID599/601, Arkesilaos/Klonios are in group "Boeotian Leaders" (are we to use the Latin forms Arcesilaus/Clonius instead?) "group/character/citation"
2.490-2.510 - Add event "Boeotian Leaders send 50 ships to Troy, each ship contains 120 young Boeotian men" (characters: Peneleos (2), Leitus, Arkesilaos, Prothoenor, Klonios) "event/character/citation"
- ID1308-1313, ID1504-ID1526, "Boeotian Leaders send 50 ships to Troy, Each ship contains…" (correct to lowercase "e", "each ship contains") "event/place"
2.510-2.515 - ID2830, Ares is god father of *blank* (delete record?) "character/character/citation"
2.515-2.525 - ID605-606, Schedius (1) and Epistrophus (1) are in group "Phocaean Leaders" (check spelling with "Phocian", which one do we use?) "group/character/citation"
- ID4217, A bull from Geryon's herd escapes Hercules (doesn't belong in here, delete) "event/character/citation"
2.525-2.535 - ok
2.535-2.545 - ID4220, Abantes Leader sends 50 ships to Troy (text says forty, change to "Abantes Leader sends 40 ships to Troy") "event/character/citation"
- ID1406, ID1543-1549, ibid (ibid) "event/place"
2.545-2.555 - Add relationship: Zeus is god father of Athena "character/character/citation"
2.555 - ID833, Telamon is mortal father of Ajax (2) (doesn't belong in line 2.555. Telamonian Aias [Ajax] is only mentioned in 2.525-2.530.) "character/character/citation"
- Text says "And Aias led from Salamis twelve ships" however he was also cited earlier following the Locrian ships. Is this a different Ajax? If so ought we to add a group for "Leaders of Salamis"?
- ID4225, Ajax sends 12 ships to Troy… (this actually is cited between lines 2.555-2.560; however Nestor and his 50 black ships are cited right on line 2.555, cite this instead and move Ajax's navy to Hom. Il. 2.555-2.565?) "event/character/citation"
- ID1409, ibid (ibid) "event/place"
2.555-2.565 - Add event "Leaders of Argos send 80 ships to Troy" (place: Argos) "event/place"
2.560-2.570 - Add relationship: Talaus is mortal father of Mecisteus (1) "character/character/citation"
2.570-2.580 - Add group "Leaders of Mycenae", cite Agamemnon? "group/character/citation"
- ID1553, Agamemnon…sends 100 ships to Troy (place cited is "Orneae", text spells it "Orneiae", double-check to see if spelling is ok) "event/place"
- Add to event "Agamemnon…sends 100 ships to Troy" places: Aegium, Aegialus, Helice "event/place"
2.580-2.590 - ID2849, Agamemnon is brother of Menelaus (change relationship to "mortal father", and change Agamemnon to "Atreus", to get away from using this relationship type) "character/character/citation"
- Add group "Leaders of Lacedaemon", cite Menelaus? "group/character/citation"
- ID1560, Menelaus…sends 60 ships to Troy (place cited is "Bryseae", text spells it "Bryseiae", double-check spelling) "event/place"
- ID1561, ibid (place cited is "Augeae", text spells it "Augeiae", double check spelling) "event/place"
- Add to event "Menelaus…sends 60 ships to Troy place: Laas "event/place"
2.590-2.600 - ID1564, Nestor sends 90 ships to Troy (place cited is "Alpheus", text spells it "Alpheius", double-check spelling) "event/place"
- ID1568, ibid (place cited is "Aipy", text spells it "Aepy", double-check spelling) "event/place"
- ID1570, ibid (place cited is "Amphigenea", text spells it "Amphigeneia") "event/place"
- ID1571, ibid ("Pteleum", text says "Pteleos") "event/place"
- ID1565, ibid ("Helos", text says "Helus") "event/place"
2.590-2.605 - Add group "Leaders of Pylos", cite Nestor? "group/character/citation"
- ID1563, Nestor sends 90 ships to Troy (place cited is "Pylus", change to "Pylos"? Also, this ought to be cited in 2.590-2.600 instead) "event/place"
2.600-2.615 - Add relationship: Atreus is mortal father of Agamemnon "character/character/citation"
- Add group "Arcadian Leaders", cite Agapenor (2)? "group/character/citation"
- Add to event "King Agapenor of Arcadia sends 60 ships to Troy" places: Arcadia, Pheneos, Rhipe, Stratia, Enispe, Parrhasia "event/place"
- ID1627, King Agapenor of Arcadia sends 60 ships to Troy (place cited is "Mantinea", text spells it "Mantineia", double-check spelling) "event/place"
2.610 - ID4632, Agamemnon finds ships for Arcadians to cross the sea… (should we say "gives" instead of "finds", maybe check the original Greek verb used here) "event/character/citation"
- ID1629, ibid (ibid) "event/place"
2.615-2.620 - ID4636-4637, Epean Leaders send 40 ships to Troy (these two records, citing Diores and Polyxenus (2), ought to be in Hom. Il. 2.620-2.625, which by the way this range does not exist in the database) "event/character/citation"
- ID4637, ibid (character cited is "Polyxenus (2)", text spells it "Polyxeinus", double-check spelling) "event/character/citation"
- Add to event "Epean Leaders send 40 ships to Troy" places: Buprasium, Hyrmine, Myrsinus, Olen, Alesium (maybe double check the latter four, since Homer is saying that everybody in the lands between these joined, does that mean that they are themselves included as places or are they just boundary markers?) "event/place"
2.625-2.630 - Add group "Leaders of Dulichiuni and the Echinae", cite Meges? "group/character/citation"
- ID1632, Epean Leaders send 40 ships to Troy (doesn't belong in 2.625-2.630, nor is it correct, delete) "event/place"

MORE REVISIONS PENDING (up to Hom. Il. 2.765?)

12/04/11

Permalink 10:54:31 am, by jamie, 56 words, 67 views   English (CA)
Categories: Activity log; Mins. worked: 60

Fixed global and ajax searching

Fixed the search functions - both the standalone search page and the 'search inside this lecture' feature - so that annotation text is no longer searched. Also changed the format of the ajax search results so that they match the results of the global search: ordered list with the excerpt of text surrounding the search term.
Permalink 09:03:16 am, by jamie, 401 words, 68 views   English (CA)
Categories: Activity log; Mins. worked: 90

XQuery (1.0) code for finding text in a node while ignoring specific descendents

The structure of the utterances for the FrancoToile transcripts looks something like this:


<u>
    Text of an utterance here...
</u>
<u>
    Some more text here. <ref type="info">Special keyword <note>with an annotation</note></ref> here.
</u>

Each utterance is within a <u> element. Some of the words and phrases in utterances are marked by annotations. These special phrases are inside <ref> elements, and the annotations to go along with them inside <note> elements.

When searching the utterances for a keyword, I needed a way to exclude all text within <note> elements from the search, since they're not part of the actual utterance text. Martin and I spent a long (long!) time coming up with a good solution, but couldn't find anything satisfying. Then, thanks to Stack Overflow, I finally found found something that works:


//textNodeToSearch//text()[not(ancestor::note) and contains(., "searchTerm")]

Phew. This will search your text node (whatever you use for textNodeToSearch) for the search term but exclude all <note> elements from the search.

The complete XQuery used in the FrancoToile search, which orders the results by number of utterances found and also returns those utterances, is:


declare namespace tei = "http://www.tei-c.org/ns/1.0";
declare namespace exist = "http://exist.sourceforge.net/NS/exist";

for $result in collection('francotoile/data')//tei:TEI[tei:text/tei:body//text()[not(ancestor::note) and contains(., "searchTerm")]]

return 
<match> 
    {
    let $articleBody := $result//tei:body
    let $id := $result//tei:TEI/@xml:id
    let $articleTitle := $result//tei:titleStmt/tei:title
    let $timeline := $result//tei:TEI/tei:text/tei:body/tei:timeline
    return
    <info>
        <title>{data($articleTitle)}</title>
        <refid>{data($id)}</refid>
	<count>{text:match-count($result)}</count>
	<timeline>{data($timeline)}</timeline>
    </info>
    }
    <utterances>
        {
        for $utter in $result//tei:u
	    let $start := $result//tei:timeline/tei:when[@xml:id=$utter/@start]/@absolute
	    let $end := $result//tei:timeline/tei:when[@xml:id=$utter/@end]/@absolute
	    where matches($utter, 'searchTerm') 
            return
	    <utterance>
	        <start>{data($start)}</start>
		<end>{data($end)}</end>
		<text>{data($utter)}</text>
            </utterance>
	}
    </utterances>
</match>

11/04/11

Permalink 02:58:24 pm, by jamie, 25 words, 66 views   English (CA)
Categories: Activity log; Mins. worked: 20

Updated views with street information

Updated the four census views with street_number and street_name fields. The fields are NULL in 1881 and 1891 and point to real data in 1901 and 1911.
Permalink 12:19:20 pm, by jamie, 126 words, 72 views   English (CA)
Categories: Activity log; Mins. worked: 30

Loader app changes: converted from raw SQL to organized arrays

To prepae for the previous update (adding 'conditionKey' support), I modified the loader so that, instead of building a raw SQL query to insert each row, the app now builds an associative array of data and then passes it to either pg_insert() or pg_update(), depending on whether any conditions exist. Aside from allowing for condition support, this change also keeps the data more organized and takes out the guesswork involved in building raw SQL queries via a for loop. I also had to edit the _fix_field() function in inc/lib.inc to stop the automatic escaping of data values into single quotes (e.g. 'data'). pg_insert() and pg_update() escape automatically, so the code in _fix_field() was resulting in double escaping.
Permalink 12:17:17 pm, by jamie, 199 words, 59 views   English (CA)
Categories: Activity log; Mins. worked: 60

Loader app expansion: conditional updating support

PD recently sent me an updated version of the 1901 data with expanded address information, namely street number and street name separated into two fields. This will allow us to have street searching for both 1901 and 1911. However, the loader application didn't support updating existing rows, only importing new ones. So, I had to build update capabilities.

The loader now supports "conditionKey" lines, which can be used to specify conditions that need to be met in order to perform an update. The format of the line is:


conditionKey=SourceDataColumnName:DatabaseTableColumnName

For example, this is the condition key line that I specified when importing the new address data for 1901:


conditionKey=census_record_id:census_record_id

The field on the left of the colon tells the loader to look at the value of the census_record_id column in the source data CSV, while the field on the right side of the colon tells the loader to check that value against the census_record_id column in the database table.

Internally, adding one or more conditions causes the loader to use the pg_update() function instead of the pg_insert function for the row in question.

Multiple conditionKey lines may be specified.

Permalink 09:01:14 am, by jnazar, 26 words, 46 views   English (CA)
Categories: Activity log; Mins. worked: 15

Administrative - office operations

As instructed emailed Facilities Management with HCMC exterior windows cleaning request.
No charge for service as building is part of KIP project.
Service request in queue.

08/04/11

Permalink 08:38:21 am, by jamie, 37 words, 98 views   English (CA)
Categories: Notes; Mins. worked: 0

SD away for six weeks

SD is in Britain from April 2 - May 16. Since the ball is currently in SD's court - he's double checking the 1790s and 1800s data - progress will be on hold until the latter half of May.

07/04/11

Permalink 02:20:21 pm, by jamie, 94 words, 132 views   English (CA)
Categories: Activity log; Mins. worked: 30

Changes made as per last meeting

Made the following changes today from my to-do list from the last meeting (earlier today, April 07/11):

  • Moved the 'dev' site to http://francotoile.uvic.ca
  • Made off-site links in transcript annotations open in a new window
  • Fixed the "Browse" link from the help page so that it goes to the correct map page
  • Removed timestamps from the search results page and replace with a simple ordered list of results (#1, #2, etc.)
  • Removed superfluous controls from the Google map
  • Added a "No related videos" message when there are no matches found for a video's "related" sidebar
Permalink 12:10:09 pm, by jamie, 15 words, 70 views   English (CA)
Categories: Activity log; Mins. worked: 15

Dev site moved to main URL

The old version of FrancoToile has been replaced with the new: http://francotoile.uvic.ca
Permalink 11:54:11 am, by jamie, 189 words, 71 views   English (CA)
Categories: Activity log; Mins. worked: 90

Meeting with CC and PS April 07/11

CC, PS and myself met this morning to discuss the state of the website and any changes that need to be done before CC presents the site at CALICO. Our next meeting is scheduled for Monday, May 9th at 10:00 AM. Our task list before that meeting looks like this:

Jamie will:

  • Replace the old version of the website with the "dev" site, so that http://francotoile.uvic.ca points to the new version
  • Make off-site links in transcript annotations open in a new window
  • Investigate and fix "pulsating" utterance hover boxes
  • Fix the "Browse" link from the help page so that it goes to the correct map page
  • Remove timestamps from the search results page and replace with a simple ordered list of results (#1, #2, etc.)
  • Ensure that search queries do not search annotations within transcripts
  • Remove superfluous controls from the Google map
  • Add a "No related videos" message when there are no matches found for a video's "related" sidebar

Pat will:

  • Change the size and location of the UVic and HCMC logos on the Help page
  • Make a new 'Reel' favicon
  • Add a copyright notice to the site-wide footer

06/04/11

Permalink 03:43:40 pm, by mholmes, 139 words, 64 views   English (CA)
Categories: Activity log; Mins. worked: 20

New derived column for titles table

JS-R has made the following request for a new column in the titles table, which would handle a kind of munged-together value for all the owners' ethnicities. It would be a string field, presumably (unless we want to give these numbers to keep them short).

Maybe we need two new variables as characteristics of titles:

 1. Multiple or single owner:
      a. multiple
      b. single

 2. Ownership ethnicity (don't worry here whether they are individuals or groups):
     a. Mixed ethnicity with Chinese
     b. Mixed Ethnicity with Japanese (include Japanese provisional)
     c. Mixed ethnicity with Chinese and Japanese
     d. Mixed ethnicity--ALL Others (all not included above, including mixes that include the Asia: other category but neither Japanese or Chinese, if they include both Asia other and Japanese or Chinese, categorize as indicated above)
     e. ELSE-->  copy the single ethnicity (or shared ethnicity) here
Permalink 03:40:55 pm, by mholmes, 19 words, 39 views   English (CA)
Categories: G&T Hours; Mins. worked: 0

MDH: 54 - 2 = 52 vacation days left (up to end of 2011)

Taking the 7th and 8th as vacation days to prepare for my trip to Chicago for the TEI conference.

Permalink 03:39:52 pm, by mholmes, 61 words, 400 views   English (CA)
Categories: Activity log; Mins. worked: 120

ImtLink and ImtLinkSet basically working

They can read and write themselves from a QDomDocument, and seem to be working well. Next, I need to polish up the test application so that it works as a demo of that module of the real app, which means installing some more filtering features (sorting works already, but filtering on any of the values in the fields would be great).

Permalink 03:38:18 pm, by mholmes, 84 words, 50 views   English (CA)
Categories: Activity log; Mins. worked: 40

CALICO: new requirement to do live video streaming

The CALICO team phoned to check on the possibilities for live streaming of the keynote and the banquet presentation. This was previously definitely off the table, so we hadn't prepared for it. It will require wired ethernet. Went over to check the Bob Wright room, and it looks like there's good wired connectivity available there, so that shouldn't be a problem. The banquet is in the Cadboro Dining Room, which is an unknown quantity right now. We've written to ask about what's available there.

Permalink 03:34:08 pm, by mholmes, 39 words, 50 views   English (CA)
Categories: Activity log; Mins. worked: 60

Accounting stuff for eoy

Did one last trawl through last year's accounts with JN, and checked everything. All appears to be OK, with errors we previously identified now corrected. Saved and printed copies of the main spreadsheets so we have a paper record.

Permalink 01:49:24 pm, by jamie, 69 words, 68 views   English (CA)
Categories: Activity log; Mins. worked: 45

Dev site updates

Committed all of my changes to the census search/display to the SVN repository and pushed to the dev site. Dev site also has an up-to-date database with the partial 1911 data (Fernwood/Hillside and Rock Bay) as well as any new codes I've added (occupations, nationality, race, etc.). From this point I'll commit my code changes daily and push to the dev site at the end of the day.
Permalink 12:31:00 pm, by jamie, 99 words, 154 views   English (CA)
Categories: Notes; Mins. worked: 0

Development site online

With help from Greg I've put a development site for VIHistory online at: http://tapor.uvic.ca/~vihdev/

Access is currently restricted by Netlink ID to associated parties (myself, GN, MH, SA, PD, JL). The dev site runs its own database. We put this site online so that PD and JL could "beta test" the new 1911 data once it's ready for them. This also allows me to periodically commit my development changes to the SVN repository, rather than having them sit on my machine for months, in case I get hit by a bus (or suffer another similar calamity).

Permalink 10:09:35 am, by mholmes, 13 words, 61 views   English (CA)
Categories: Activity log; Mins. worked: 45

Timesheets

Did Mariage and workstudy timesheets in advance because I'll be away next week.

Permalink 09:20:27 am, by mholmes, 278 words, 201 views   English (CA)
Categories: Activity log; Mins. worked: 20

Events calendar feature for Humanities site

Details of a request from BLT to an enhancement to the RSS feed reader on the Humanities faculty site:

  • We need to create a page which shows only one week's events.
  • This should be done by added a custom output format to the current RSS feed reader code. There are already two or three output routines; this would just be another, for this specific purpose.
  • The output from this routine would provide two lists of the events for the coming week:
    1. The first should be identical to the current output, except that it should not include the description field. BLT will copy-paste this into an email he sends out to the faculty.
    2. The second would be the same, except that it would include the description field; this would enable BLT to extract the speaker information from it manually (there is no speaker field in the events calendar, so this always has to be extracted manually).
  • A page showing this output will be added to the Hums site, but not linked from anywhere. The URL will be known to BLT, who will use it to generate his weekly emails. It wouldn't matter if anyone else stumbled upon this page, because it's just another list of events from the calendar.
  • While writing this, we should also take the opportunity to fix a bug in the current output from the reader, as it appears in all pages -- see this validator output. The bug is caused by the use of a <ul> element with children which are <p>s instead of <li>s.

I'll get to work on this in the week of the 18th.

Permalink 08:32:45 am, by mholmes, 3 words, 52 views   English (CA)
Categories: Activity log; Mins. worked: 5

Added keywords to Sheffield

Supplied by HT.

05/04/11

Permalink 03:51:52 pm, by mholmes, 8 words, 380 views   English (CA)
Categories: Activity log; Mins. worked: 60

ImtLink and ImtLinkSet progress

Added transcriptional attribute, and tested sorting with QSortFilterProxyModel.

Permalink 03:51:11 pm, by mholmes, 4 words, 63 views   English (CA)
Categories: Activity log; Mins. worked: 20

Entered proofing corrections for Sheffield

Should now be complete.

Permalink 03:13:04 pm, by jamie, 43 words, 173 views   English (CA)
Categories: Notes; Mins. worked: 0

1871 data: not to be integrated

Contrary to my previous post about the advanced census search to-do list, PD, MH and I have agreed that integrating the 1871 data isn't prudent at this time. It's not nearly as complete as the other census years and would probably just confuse users.
Permalink 02:48:33 pm, by jamie, 80 words, 70 views   English (CA)
Categories: Notes; Mins. worked: 0

Google Maps API, script tags, and Firefox

Fixed a longstanding bug with the Google map that was causing Firefox to freeze on page load. It looks like Firefox can't handle this line (which loads the Javascript API file) in the <body>; it needs to be in the <head>:


<script type='text/javascript' src='http://maps.google.com/maps/api/js?sensor=false'></script>

Not sure exactly why Firefox freezes when the script is loaded in the body. Ideas welcome.

Permalink 02:32:01 pm, by mholmes, 5 words, 46 views   English (CA)
Categories: Activity log; Mins. worked: 15

Award meeting

Attendance at Liddell Award meeting.

Permalink 02:20:25 pm, by mholmes, 33 words, 47 views   English (CA)
Categories: Activity log; Mins. worked: 60

CALICO meeting

CALICO meeting to discuss the issue of Macs for presentation rooms. Later obviated by news from EH that CALICO will supply Mac laptops. Now replaced by the issue of security for these laptops.

Permalink 02:11:44 pm, by mholmes, 40 words, 50 views   English (CA)
Categories: Activity log; Mins. worked: 45

Registered for DH 2011 conference and booked housing

Took a while to get through this process -- their server seemed to get confused at one point, and was insisting I pay for something I'd already paid for before I could go ahead and pay for the other thing...

04/04/11

Permalink 04:47:25 pm, by mholmes, 3 words, 39 views   English (CA)
Categories: G&T Hours; Mins. worked: 0

MDH: 113 + 1 = 114 hours G&T

Admin, admin, admin.

Permalink 03:09:00 pm, by mholmes, 386 words, 46 views   English (CA)
Categories: Activity log; Mins. worked: 60

CALICO phones

Did another review of what's available in terms of "disposable" cellphones. The $20 phones Rogers had last year seem to have disappeared; looked at Telus, Fido, Koodo, Chatr, Virgin and a couple of others, as well as contacting 7-Eleven stores and Walmart. The cheapest option at this point seems to be Walmart, where you can get a Samsung R100 phone for $28.83 + tax; if you then activate that phone directly through Telus, and do it online, you get $20 of talk time, which would amount to about an hour of talk time.

Timing is the key to this, though, because these phones go in and out of stock (the $20 Rogers phones that were available last year seem to have disappeared now). Walmart only have a couple of those Samsung phones at the moment, but they have a bunch on order, and they're going to call me when they come in. The Telus website has an ominous mention of the possibility that you might "need to purchase a Starter Kit during the activation process" -- it's not clear what that might cost.

We've also been talking about the possibility of doing this a slightly different way, though. My guess is that the majority of our volunteers will have cellphones already (certainly Greg, Jamie and I do), and most people would be happy to use their own cellphones. We could cut our costs by if volunteers were prepared to use their own phone while "on duty". We could gather people's cellphone numbers at or before the training workshops, and have them program the key numbers in at the workshops. They wouldn't need each other's numbers, just the numbers of the main emergency contacts (HCMC, AV, and our roving tech support people). And we wouldn't have the hassle of collecting and handing out a batch of phones every day. We'd just have to have the list of all the volunteers' numbers, and the schedule for where and when they're going to be on duty.

There would obviously be the problem of our two out-of-town tech support folks, whose phones would be from the US, so they'd be paying a US roaming rate, but I suspect that at the end of the day, having CALICO reimburse them for any charges incurred calling in Canada would be cheaper than buying a batch of phones.

Permalink 01:34:04 pm, by jamie, 137 words, 164 views   English (CA)
Categories: Notes; Mins. worked: 0

Changes needed to advanced census search form

PD has sent a list of changes to be done to the advanced census search form, in preparation for the 1911 data:

  • Move address from Name/Family/Location to Building
  • Move infirmities to its own group
  • Change "Race" heading to "Race/Ethnic Origin"
  • Add "1st language commonly spoken" and "2nd language commonly spoken" fields to Language
  • Change 'Building' header to 'Habitation'
  • Add "Street" to aforementioned group to search 1901 and 1911 census
  • Include 1871 as an option
  • Add new "Infirmities/Insurance" header with: Infirmities, Has Life Insurance, and Has Accident/Health Insurance
A few small shuffles, but also a few larger jobs, namely integrating the 1871 data, adding the new Infirmities/Insurance section (most of the work there is massaging the pre-1911 data to allow it to be searchable), and being able to search just by street, rather than address, for 1901 and 1911.
Permalink 12:31:53 pm, by jamie, 166 words, 50 views   English (CA)
Categories: Activity log; Mins. worked: 30

Changes made to 1911 table/view: languages

Some clarification from PD about how language fields work in the 1911 data. There are two language fields: 1st language spoken and 2nd language spoken. I had mistakingly thought that 1st language spoken was equivalent to the "mother tongue" of previous years and imported it as such. I had also made a new "secondary_language" field in the 1911 table and in all of the views. PD, however, informs me that, in fact, there is no "mother tongue" in the 1911 census and "1st language spoken" and "2nd language spoken" are new fields. So, I've modified the 1911 census table and all of the census views as follows: - census_1911 table: renamed "mother_tongue_id" to "first_language_id"; renamed "secondary_language_id" to "second_language_id" - view for census 1911: converted mother_tongue and mother_tongue_id to NULL fields - views for all census years: renamed "secondary_language_id" to "second_language_id"; added "first_language_id" and "first_language" as NULL fields to all years previous to 1911
Permalink 12:09:50 pm, by mholmes, 15 words, 55 views   English (CA)
Categories: Activity log; Mins. worked: 75

Marked up Sheffield review

New one came in from HT; marked it up and posted it. Three questions outstanding.

Permalink 11:13:01 am, by mholmes, 16 words, 68 views   English (CA)
Categories: Activity log; Mins. worked: 15

Updates to the team page

Added in the new members of the team and more details about tasks, on CC's instructions.

Permalink 10:35:58 am, by mholmes, 15 words, 43 views   English (CA)
Categories: Activity log; Mins. worked: 90

Liddell Award evaluation

Did detailed technical evaluations of the candidates for this year's Liddell Award, for the committee.

Permalink 09:31:15 am, by jamie, 34 words, 89 views   English (CA)
Categories: Notes; Mins. worked: 0

Fernwood-Hillside data received

Received the spreadsheets for the Fernwood-Hillside sub-district (#10) for the 1911 census from PD. Importing of the data into my development database should be seamless. Two new occupation codes are being inserted: Riveter (87460) and Cement Worker (95200).
Permalink 09:25:09 am, by mholmes, 62 words, 41 views   English (CA)
Categories: Activity log; Mins. worked: 60

Meeting with AR re hums sites in cms

Met with AR: there have been responses from the Info Architects to the proposed navigation which will necessitate some changes, and also we need to complete a Project-Lite-Web document for the Info Architects to consult when evaluating the navigation plan. Looking ahead, I need to check with DW about how static content such as Hispanital's exams and interactive exercises could be integrated.

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

Gathered stats for March

Nothing unusual.

01/04/11

Permalink 04:25:44 pm, by Matthew, 847 words, 89 views   English (CA)
Categories: Activity log; Mins. worked: 150

Apollodorus E 7.1-END

CHAPTER 7
7.1 - Add event: "Ulysses wanders about Libya" (character: Ulysses, place: Libya)
- Add event: "Ulysses wanders about Sicily" (character: Ulysses, place: Sicily)
- Add event: "Ulysses wanders about the Tyrrhenian Sea" (character: Ulysses, place: Tyrrhenian Sea)
7.2 - ok
7.3 - ID3260, blank event (character cites is "Ulysses", should this be something regarding "Ulysses sets out for the land of the Cyclopes"?) "event/character/citation"
7.4 - ok
7.5 - ok
7.6 - ok
7.7 - ok
7.8 - ok
7.9 - ok
7.10 - ok
7.11 - ok
7.12 - ok
7.13 - ok
7.14 - Add relationships: Perse and Sun (Helios) are mortal mother and god father of Aeetes "character/character/citation"
- In Apollod. 1.9.1, the mother of Aeetes is spelled "Perseis" and the father is Sun (Helios). In this chapter she is called "Perse". Was there a spelling error by the author or are these two people, Perse and Perseis, different people?
- ID1171-1172, Ulysses arrives on an Aeaean island, which is inhabited by Circe (place is "Aeaean Ilse", correct spelling in the database to "Aeaean Isle"?) "event/place"
7.15 - ID1173, ibid (ibid) "event/place"
7.16 - ID1174-1175, ibid (ibid) "event/place"
7.17 - ok
7.18 - ok
7.19 - ok
7.20 - ID3329-3330, Ulysses arrives at a parting…one with Scylla and the other with Charybdis (7.20 only mentions Scylla, while 7.21 describes the other side with Charybdis. These ought to be broken into two events and the latter moved to 7.21 Also, for the latter, ought we to cite the character "Charybdis" in the event? This character isn't in the database by the way. Wikipedia says Charybdis is the daughter of Poseidon and Gaia, but lacks a source, and Apollod. Epit. E.7.21 states: "Charybdis, who thrice a day…" My understanding is that it is a place and a creature, please clarify this) "event/character/citation"
- ID1231, ibid (ibid) "event/place"
7.21 - ok
7.22 - ok
7.23 - ID3335, When the ship breaks, Ulysses clings to the mast and drifts to Charybdis (add character "Charybdis"?) "event/character/citation"
- ID3336, Ulysses survives Charybdis and is carried to the island of Ogygia (ibid) "event/character/citation"
7.24 - ok
7.25 - ok
7.26 - Add event: "Fifty-seven suitors came from Dulichium to woo Penelope" (character: Penelope, place: Dulichium. Section 7.27 simply lists them all, so probably better to cite this passage as well, but only including Penelope)
7.27 - ID293, Amphimachus (3) is in group "Suitor of Penelope" (in "event/character/citation" tab, ID3414 cites Amphimachus (5) as a suitor. Which Amphimachus is the suitor? Please verify) "group/character/citation"
- ID312, Clytius (4) is in group "Suitor of Penelope" (ibid, ID3418 cites Clytius (5)) "group/character/citation"
- ID284, Agenor (6) is in group "Suitor of Penelope" (ibid, ID3419 cites Agenor (9)) "group/character/citation"
- ID334, Eurypylus (5) is in group "Suitor of Penelope" (ibid, ID3420 cites Eurypylus (8)) "group/character/citation"
- ID280, Acamas (3) is in group "Suitor of Penelope" (ibid, ID3422 cites Acamas (4)) "group/character/citation"
- ID306, Bias (4) is in group "Suitor of Penelope" (ibid, ID3429 cites Bias (5)) "group/character/citation"
- 33 Suitors are missing from the event "Fifty-seven suitors came from Dulichium to woo Penelope". Please add them, check that they are the right 'version' of that character. They are: Polyidus, Astylochus, Schedius, Antigonus, Marpsius, Iphidamas, Argius, Glaucus, Calydoneus, Echion, Lamas, Andraemon, Agerochus, Medon, Agrius, Promus, Ctesius, Acarnan, Cycnus, Pseras, Hellanicus, Periphron, Megasthenes, Thrasymedes, Ormenius, Diopithes, Mecisteus, Antimachus, Ptolemaeus, Lestorides, Nicomachus, Polypoetes, and Ceraus. Also double-check the versions to see that they agree with the entries in the "group/character/citation" tab in the group "Suitor of Penelope"
- Despite the text saying there were fifty-seven suitors from Dulichium, there are only 53
7.28 - ID282, Agelaus (3) is in group "Suitor of Penelope" (ibid, ID3464 cites Agelaus (4)) "group/character/citation"
- ID327, Elatus (3) is in group "Suitor of Penelope" (ibid, ID3466 cites Elatus (4)) "group/character/citation"
- ID315, Ctesippus (3) is in group "Suitor of Penelope" (ibid, ID3467 cites Ctesippus (2)) "group/character/citation"
- ID313, Clytius (5) is in group "Suitor of Penelope" (ibid, ID3481 cites Clytius (4)) "group/character/citation"
- 3 Suitors are missing from the event "Twenty-three suitors came from Samethere to woo Penelope". Please add: Eumelus, Itanus, Lyammus. Check that they are the correct versions.
7.29 - ID283, Agenor (9) is in group "Suitor of Penelope" (ibid, ID3503 cites Agenor (8)) "group/character/citation"
- ID3490/ID3508, Forty-four suitors came from Zacynthos to woo Penelope (character cited in both is Phrenius (1), one of these ought to be Phrenius (2) since there are two Phreniuses mentioned in the text) "event/character/citation"
- Despite the text saying there were forty-four suitors from Zacynthos, there are only 41
7.30 - ID395, Pronous (1) is in group "Suitor of Penelope" (ibid, ID3529 cites Pronous (2)) "group/character/citation"
- ID290, Amphimachus (5) is in group "Suitor of Penelope" (ibid, ID3532 cites Amphimachus (4)) "group/character/citation"
- ID316, Ctesippus (4) is in group "Suitor of Penelope" (ibid, ID3539 cites Ctesippus (1)) "group/character/citation"
7.31 - ok
7.32 - ok
7.33 - ok
7.34 - ok
7.35 - ok
7.36 - ok
7.37 - ID1204, Telegonus recognizes Ulysses and conveys the corpse and Penelope to Circe (place cited is "Aeaean Ilse", correct to "Aeaean Isle") "event/place"
7.38 - Add relationship: Icarius (1) is mortal father of Penelope "character/character/citation"
7.39 - ok
7.40 - ok

Permalink 02:39:29 pm, by jamie, 149 words, 282 views   English (CA)
Categories: Notes; Mins. worked: 0

MySQL requests no longer sent to sysadmin@uvic.ca

Update from Stewart 20120622: the dbadmin says that the originating request is supposed to go through helpdesk@uvic.ca, who forwards it on to dbadmin@uvic.ca.

  • Your affiliation with UVic (Faculty/Staff, etc)
  • Your department
  • Which netlink Id is associated with this database
  • The database name (must be of the form netlink_whatever)
  • Whether or not you will be using drupal for this instance.

As per my correspondence with sysadmin@uvic.ca, all MySQL-related support requests/questions should be sent to dbadmin@uvic.ca rather than sysadmin@uvic.ca:

Hi Jamie,
The unix sysadmin no longer handles MySQL requests, these should be set
to dbadmin@uvic.ca, if you resend this email to that address it will
find it's way into the correct queue of our ticketing systems


Thanks
Hendrik
Not sure whether he actually means only MySQL, or whether PostgreSQL falls under this new support email as well.
Permalink 12:56:08 pm, by mholmes, 20 words, 40 views   English (CA)
Categories: G&T Hours; Mins. worked: 0

MDH: 116 - 3 = 113 hours G&T

Leaving early -- need to get rid of some G&T hours, and this has been an exhausting week.

Permalink 11:53:44 am, by mholmes, 1199 words, 105 views   English (CA)
Categories: Activity log; Mins. worked: 120

Generating a search view

I'm beginning the process of implementing the kind of simple search interface documented by JN here and in preceding posts.

I've generated a view of the complete document data (excluding custom fields, for the moment). The view can be dumped into an Excel spreadsheet, so that's what I've done (attached). These are the details:

  • There's one row for each document in the spreadsheet.
  • Regular fields in the document table are copied as-is into the spreadsheet.
  • One-to-one lookup fields (such as document status) are copied in the form of their text representation (just as you see them when viewing a single document)One-to-many fields are turned into a single field in which each entry is shown in its text representation, and entries are separated by pipe characters (|).

I think this view, and the ability to dump it into a spreadsheet, will be useful in itself (although it takes several minutes to generate it). The rest of the plan, though, goes like this:

  1. Write a procedure to copy the view (in which everything is represented as text) to a new table, in which all fields are text fields.
  2. Create a full-text index on this table.
  3. Create a simple text-search interface that uses a simple Google-style search box to search that full-text index.

This would make it simple to do normal searches as if you were searching with Google, not worrying about fields and drop-down selectors etc. It would have to lag behind changes in the db a little, though; the table would have to be re-generated in order to take account of changes in the underlying database. We might be able to automate that, or we might have to run a procedure to refresh it periodically.

Here's the SQL used to create the views:



/*
CREATING VIEWS: 
LITTLE VIEWS FOR USE IN THE MASTER VIEW
*/

CREATE VIEW VW_doc_chapters_concat AS
(SELECT
documents.doc_id,
(SELECT GROUP_CONCAT(chapters.ch_name SEPARATOR ' | ') 
	FROM docs_to_chapters 
        INNER JOIN chapters ON chapters.ch_id = docs_to_chapters.dtc_ch_id_fk 
        INNER JOIN documents as ch_docs ON ch_docs.doc_id = docs_to_chapters.dtc_doc_id_fk
        WHERE docs_to_chapters.dtc_doc_id_fk = documents.doc_id) 
AS chapters

FROM documents
ORDER BY documents.doc_id);


CREATE VIEW VW_doc_authConcerns_concat AS
(SELECT
documents.doc_id,
(SELECT GROUP_CONCAT(authConcerns.ac_name SEPARATOR ' | ') 
	FROM docs_to_authConcerns 
        INNER JOIN authConcerns ON authConcerns.ac_id = docs_to_authConcerns.dta_authConcern_id_fk 
        INNER JOIN documents as temp_docs ON temp_docs.doc_id = docs_to_authConcerns.dta_doc_id_fk
        WHERE docs_to_authConcerns.dta_doc_id_fk = documents.doc_id) 
AS authConcerns

FROM documents
ORDER BY documents.doc_id);

CREATE VIEW VW_doc_disStatus_concat AS
(SELECT
documents.doc_id,
(SELECT GROUP_CONCAT(disStatus.ds_desc SEPARATOR ' | ') 
	FROM docs_to_disStatus 
        INNER JOIN disStatus ON disStatus.ds_id = docs_to_disStatus.dts_disStatus_id_fk 
        INNER JOIN documents as temp_docs ON temp_docs.doc_id = docs_to_disStatus.dts_doc_id_fk
        WHERE docs_to_disStatus.dts_doc_id_fk = documents.doc_id) 
AS disStatus

FROM documents
ORDER BY documents.doc_id);

CREATE VIEW VW_doc_disTopics_concat AS
(SELECT
documents.doc_id,
(SELECT GROUP_CONCAT(disTopics.dc_name SEPARATOR ' | ') 
	FROM docs_to_disTopics 
        INNER JOIN disTopics ON disTopics.dc_id = docs_to_disTopics.dtc_disTopic_id_fk 
        INNER JOIN documents as temp_docs ON temp_docs.doc_id = docs_to_disTopics.dtc_doc_id_fk
        WHERE docs_to_disTopics.dtc_doc_id_fk = documents.doc_id) 
AS disTopics

FROM documents
ORDER BY documents.doc_id);

CREATE VIEW VW_doc_disTypes_concat AS
(SELECT
documents.doc_id,
(SELECT GROUP_CONCAT(disTypes.dt_name SEPARATOR ' | ') 
	FROM docs_to_disTypes 
        INNER JOIN disTypes ON disTypes.dt_id = docs_to_disTypes.dtd_disType_id_fk 
        INNER JOIN documents as temp_docs ON temp_docs.doc_id = docs_to_disTypes.dtd_doc_id_fk
        WHERE docs_to_disTypes.dtd_doc_id_fk = documents.doc_id) 
AS disTypes

FROM documents
ORDER BY documents.doc_id);

CREATE VIEW VW_doc_docPeriods_concat AS
(SELECT
documents.doc_id,
(SELECT GROUP_CONCAT(docPeriods.dp_name SEPARATOR ' | ') 
	FROM docs_to_docPeriods 
        INNER JOIN docPeriods ON docPeriods.dp_id = docs_to_docPeriods.dtp_docPeriod_id_fk 
        INNER JOIN documents as temp_docs ON temp_docs.doc_id = docs_to_docPeriods.dtp_doc_id_fk
        WHERE docs_to_docPeriods.dtp_doc_id_fk = documents.doc_id) 
AS docPeriods

FROM documents
ORDER BY documents.doc_id);


CREATE VIEW VW_doc_meetPlaces_concat AS
(SELECT
documents.doc_id,
(SELECT GROUP_CONCAT(meetPlaces.mp_desc SEPARATOR ' | ') 
	FROM docs_to_meetPlaces 
        INNER JOIN meetPlaces ON meetPlaces.mp_id = docs_to_meetPlaces.dtm_meetPlace_id_fk 
        INNER JOIN documents as temp_docs ON temp_docs.doc_id = docs_to_meetPlaces.dtm_doc_id_fk
        WHERE docs_to_meetPlaces.dtm_doc_id_fk = documents.doc_id) 
AS meetPlaces

FROM documents
ORDER BY documents.doc_id);

CREATE VIEW VW_doc_news_concat AS
(SELECT
documents.doc_id,
(SELECT GROUP_CONCAT(news.nw_desc SEPARATOR ' | ') 
	FROM docs_to_news 
        INNER JOIN news ON news.nw_id = docs_to_news.dtn_news_id_fk 
        INNER JOIN documents as temp_docs ON temp_docs.doc_id = docs_to_news.dtn_doc_id_fk
        WHERE docs_to_news.dtn_doc_id_fk = documents.doc_id) 
AS news

FROM documents
ORDER BY documents.doc_id);





/* THE MASTER VIEW, TO BE EXPANDED. */
CREATE VIEW VW_documents_all AS

(SELECT 
documents.doc_id,
docTypes.dt_name AS docType,
VW_doc_chapters_concat.chapters AS chapters,
VW_doc_docPeriods_concat.docPeriods AS docPeriods,
projects.proj_name,
documents.doc_archive, documents.doc_cote, documents.doc_date,
docStatusVals.dsv_description,
documents.doc_notBefore, documents.doc_notAfter, documents.doc_description, documents.doc_people,
documents.doc_notes, documents.doc_transcription, documents.doc_done,
documents.doc_revisit, documents.doc_linked_files, 
VW_doc_disStatus_concat.disStatus AS disStatus,
VW_doc_disTypes_concat.disTypes AS disTypes,
VW_doc_disTopics_concat.disTopics AS disTopics,
documents.doc_disTopicDesc,
VW_doc_authConcerns_concat.authConcerns AS authConcerns,
documents.doc_authConcernDesc,
VW_doc_meetPlaces_concat.meetPlaces AS meetPlaces,
VW_doc_news_concat.news AS news

FROM documents
LEFT JOIN docTypes ON documents.doc_to_docTypes_id = docTypes.dt_id
JOIN VW_doc_chapters_concat ON documents.doc_id = VW_doc_chapters_concat.doc_id
JOIN VW_doc_docPeriods_concat ON documents.doc_id = VW_doc_docPeriods_concat.doc_id
LEFT JOIN projects ON documents.doc_to_projects_id = projects.proj_id
LEFT JOIN docStatusVals ON documents.doc_to_docStatusVals_id = docStatusVals.dsv_id
JOIN VW_doc_disStatus_concat ON documents.doc_id = VW_doc_disStatus_concat.doc_id
JOIN VW_doc_disTypes_concat ON documents.doc_id = VW_doc_disTypes_concat.doc_id
JOIN VW_doc_disTopics_concat ON documents.doc_id = VW_doc_disTopics_concat.doc_id
JOIN VW_doc_authConcerns_concat ON documents.doc_id = VW_doc_authConcerns_concat.doc_id
JOIN VW_doc_meetPlaces_concat ON documents.doc_id = VW_doc_meetPlaces_concat.doc_id
JOIN VW_doc_news_concat ON documents.doc_id = VW_doc_news_concat.doc_id

ORDER BY documents.doc_id);
Permalink 09:33:34 am, by mholmes, 402 words, 90 views   English (CA)
Categories: Activity log; Mins. worked: 90

Change to one view requirement

It turns out that this one should be buyers instead of vendors: Vendor ethnicity by mortgage institutional or not (we will fill in this data as we go) (with analysis possible by date and by sample). So here we go with:

Buyer ethnicity by mortgage institutional or not (we will fill in this data as we go) (with analysis possible by date and by sample)

Here's the SQL:

CREATE VIEW VW_buyers_and_lenders AS

(SELECT 
titles.ttl_title_id, titles.ttl_title_code, titles.ttl_date, 
owners.own_owner_id, owners.own_surname, owners.own_forenames,
buyer_ethnicities.eth_name AS buyer_ethnicity,
mortgages.mgg_mortgage_id, mortgages.mgg_doc_num, mortgages.mgg_value, mortgages.mgg_interest,
lenders.lnd_display_name, lenders.lnd_individual,
lender_ethnicities.eth_name AS lender_ethnicity

FROM titles
JOIN owners_to_titles ON titles.ttl_title_id = owners_to_titles.ott_title_id_fk
LEFT JOIN owners ON owners_to_titles.ott_owner_id_fk = owners.own_owner_id
LEFT JOIN owners_to_ethnicities ON owners.own_owner_id = owners_to_ethnicities.ote_owner_id_fk
LEFT JOIN ethnicities AS buyer_ethnicities ON owners_to_ethnicities.ote_ethnicity_id_fk = buyer_ethnicities.eth_ethnicity_id
JOIN mortgages_to_titles ON titles.ttl_title_id = mortgages_to_titles.mtt_title_id_fk
LEFT JOIN mortgages ON mortgages_to_titles.mtt_mortgage_id_fk = mortgages.mgg_mortgage_id
LEFT JOIN lenders_to_mortgages ON mortgages.mgg_mortgage_id = lenders_to_mortgages.ltm_mortgage_id_fk
LEFT JOIN lenders ON lenders_to_mortgages.ltm_lender_id_fk = lenders.lnd_lender_id
LEFT JOIN lenders_to_ethnicities ON lenders.lnd_lender_id = lenders_to_ethnicities.lte_lender_id_fk
LEFT JOIN ethnicities AS lender_ethnicities ON lenders_to_ethnicities.lte_ethnicity_id_fk = lender_ethnicities.eth_ethnicity_id)

I've included lender ethnicities and lender "individual", even though no data has been entered for those yet.

We now have six views, which I've renamed to make them more obviously views in the phpMyAdmin interface:

  • VW_buyers_and_lenders
  • VW_buyers_and_sellers
  • VW_owners_full
  • VW_sellers_duration
  • VW_trans_by_date
  • VW_trans_by_property

I think these cover all the current needs. VW_owners_full is just a view of all the core data about owners; I was intending to use it as part of other views, but didn't need to. I'll leave it there in case it's useful.

All HCMC Blogs

Actions

Reports

Categories

All HCMC Blogs

Transformer blog

Work on this blogging tool

Image Markup Tool blog

HCMC Project Management

Nxaʔamxcín (Moses) Dictionary Blog

Maintenance

FrancoToile

Mariage

Administration

Academic

Depts

Scandinavian-Canadian Studies

EMLS

Scraps

Image Markup and Presentation

Update of Humanities Sites

viHistory

Vacation, Hours and Sickday Log

Times Colonist Transcript Database

Devonshire

CMC Research Collective

Moodle

Humanities Project Showcase

Peter's blog

teiJournal

Projects

Professional Development

Colonial Despatches

Coup De Des - GUI for concrete poem

Capital Trials at the Old Bailey

Agenda Class Timetabling

Lansdowne Lectures

German Medical Exams

Canadian Mysteries

Map Of London

MyNDIR

Canadian Journal of Buddhist Studies

Adaptive Database

Myths on Maps

Properties

Cascade

Vesalius

DHSI

History of the Philosophy of Language

A City Goes to War

Landscapes of Injustice

April 2011
Sun Mon Tue Wed Thu Fri Sat
 << < Current> >>
          1 2
3 4 5 6 7 8 9
10 11 12 13 14 15 16
17 18 19 20 21 22 23
24 25 26 27 28 29 30

XML Feeds