2D Spatial Map: What’s your Second Language Seattle?
MAT 259, 2014
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.
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
I have used 4 Dewey classes: 430: German, 440: French, 450: Italian
,460 : Spanish.
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)
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.