Multi-Layered Network of Map Collections at Seattle Public Library
MAT 259, 2019
This project builds upon my last and creates a multi-layered network where layers represent different map collections at Seattle Public Library. Within each collection and across collections, nodes are represented by titles and an edge is drawn for titles that have the same subject. The goal for the visualization is that it communicates which titles are grouped together by subjects within and across collections.
SELECT DISTINCT title, subject, collectionCode
FROM title, subject, itemType, itemToBib, collectionCode
WHERE itemType.itemtype LIKE '%map' AND
collectionCode IN ("camap", "canf", "camapr") AND
subject.subject != "" AND
collectionCode.itemNumber = itemType.itemNumber AND
itemType.itemNumber = itemToBib.itemNumber AND
itemToBib.bibNumber = subject.bibNumber AND
subject.bibNumber = title.bibNumber
ORDER BY collectionCode ASC;
I very much wanted to extend my second assignment into a 3-dimensional representation of networks, so in my initial sketch, you can see how I simply turned my 2D project into an idea in 3 dimensions, with the added connections between collection layers. I also dabbled with looking at other variables and ways to look at these other variables, but opted for what can be seen in my final images.