2D Spatial Map: What’s your Second Language Seattle?
MAT 259, 2014
Mohit Hingorani

Concept
For this assignment I have studied the interest of Seattle’s citizens in learning a new European language. I have chosen to study French, German, Spanish & Italian over a 6 year period (2007-2013) The checkouts have been made in the following itemtype categories: books, cassettes & DVDs tapes. I intend to visualize not just the language trends but also the means of study employed.

Labels:
X-axis: Year (2007-2013)
Y-axis: Language (Dewey Class,Name)
( 438: German,448: French,458: Italian ,468 : Spanish )
Color: Intensity represents the number of checkouts

DATA:
I have used 4 Dewey classes: 430: German, 440: French, 450: Italian ,460 : Spanish.

Background
and Sketches

Query
SQL queries:
select month(cout),year(cout),sum(case when itemtype = "acbk" or "jcbk" then 1 else 0 end) as book,sum(case when itemtype="accas" or "jccas" then 1 else 0 end ) as cassette,sum(case when itemtype = "acdvd" or "jcdvd" then 1 else 0 end) as dvd from inraw where deweyClass>=450 and deweyClass<460 and date(cout) >= "2006-01- 01" and date(cout) <= "2013-12-31" group by month(cout),year(cout) order by year(cout), month(cout)
Results
According to the visualization, Spanish is the most popular language.This might be because it is widely spoken is and is not just limited to spain but also in central & south america as well as neighbouring mexico. Spanish is recorded the highest volume not just in the books section but also in Cassettes and DVDs. An interesting comparison would be with mandarain or possibly english which the most popular languages.

Another interesting observation was the number of checkouts drastically reducing as soon as DVDs were introduced in 2009.There has been a strong demand for spanish DVDsand the number of spanish books being checked out also increased during that period. The introduction in DVDs regained interest in Italian & French languages. There was a marginal incerease in the number of books checkout in this period. However no german DVDs were checkout indicating that they were never introduced to the library.

Final result


Code
I used Processing.

Run in Browser

Source Code