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.
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
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)
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.
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