{"id":6848,"date":"2017-06-28T12:23:41","date_gmt":"2017-06-28T16:23:41","guid":{"rendered":"http:\/\/research.prattsils.org\/?p=6848"},"modified":"2017-06-28T12:23:41","modified_gmt":"2017-06-28T16:23:41","slug":"visualization-new-york-city-hall-library-publications","status":"publish","type":"post","link":"https:\/\/studentwork.prattsi.org\/infovis\/visualization\/visualization-new-york-city-hall-library-publications\/","title":{"rendered":"Visualization of New York City Hall Library Publications"},"content":{"rendered":"<h2>Introduction<\/h2>\n<p>In local government, agencies file various types of reports on their activities to organize information and to inform the public and elected officials of the work they are doing and the progress they&#8217;re making. \u00a0These reports include everything from\u00a0budget reports to legislative documentation. \u00a0From these reports, it is possible to detect trends which can inform future government actions. \u00a0 This presentation\u00a0seeks to show how many reports are filed each year, what are the most common types of reports filed, and which agencies are the most active in New York&#8217;s City Hall.<\/p>\n<h2>Materials<\/h2>\n<p>To best represent all of the information for this presentation, the program\u00a0<a href=\"https:\/\/public.tableau.com\/\">TableauPublic<\/a>\u00a0was utilized. \u00a0The information for this presentation was drawn from the <a href=\"https:\/\/opendata.cityofnewyork.us\">NYC Open Data<\/a>, a\u00a0compilation\u00a0of various datasets that were collected from New York City government agencies.<\/p>\n<h2>Methods<\/h2>\n<p>This presentation uses three visualizations. \u00a0The first is a line graph representing the number of publications made by City Hall over time. \u00a0The second is a bar graph showing how many publications were produced by the top ten most active agencies. \u00a0The third is a packed bubble chart showing what types of reports were made for the different topics.<\/p>\n<p>User testing was conducted both face-to-face\u00a0and through social media. \u00a0The tests included one interview, two observations, and a Likart scale. \u00a0All of the testers come from different backgrounds and have varying degrees of experience with regard\u00a0to data visualization, local government, and library publications. \u00a0For example, one tester is a journalist who has covered events at City Hall before, but otherwise has no experience with the institution. \u00a0Another tester is a grant writer for non-profit organizations with a background in law. \u00a0The third tester is knowledgeable about statistics\u00a0and has experience in creating information visualization. \u00a0The Likart scale was sent to an educator who had experience with colorblind people.<\/p>\n<h2>Design Choice Rational<\/h2>\n<p>The line graph was chosen for the first chart because it is the easiest way to showcase the number of publications filed over time. \u00a0It&#8217;s simple, easy to read, and provides context for the two graphs below it. \u00a0The only difficulty was that one user felt the title of the presentation was the title of that first graph alone. \u00a0Because of this, he didn&#8217;t realize\u00a0that the other two graphs were connected. \u00a0To rectify this, the main title was bolded and centered to clarify the information for the reader.<\/p>\n<p>Due to the vast number of agencies who published their works to the New York City Hall library, the number of agencies on the second graph was reduced to the top ten. \u00a0Initially, the graph was created through vertical bars, but one user felt that horizontal bars were easier to understand because they could be read. Color-coding was also provided in the first draft of the graph to show the range of topics. \u00a0However, one user who didn&#8217;t have a strong affinity for color found it confusing that two graphs were color-coded. \u00a0Because of this, the color-coding was removed from the second graph. \u00a0It was also moved above to make more room for the third graph.<\/p>\n<p>The packed bubble graph was perhaps the most complicated to work with, but in turn, it became the most interesting. \u00a0Initially, several visualizations were examined to determine which would best represent the information. \u00a0The packed bubble graph was chosen because it was the easiest to interpret. \u00a0The size of the bubbles related to the number of publications regarding specific topics, and they were also color-coded by the types of reports published under each topic. \u00a0One user felt that sharp contrast between colors would be better than a standard pallet. \u00a0As such, a gradient between green and gold was used for the color-coding.<\/p>\n<p>One tester suggested a certain degree of interactivity to better read the information provided by the graphs. \u00a0Since TableauPublic has an inherent interactivity function, more direct action did not appear to be necessary. \u00a0However, another tester who was unfamiliar with the software was unaware that one could hover over different points on the graph and gain specific insight on each point, bar, and bubble. \u00a0For the purposes of further clarification, clickable filters and instructions were added.<\/p>\n<h2>Results<\/h2>\n<p>The final presentation has some rather intriguing results, as shown below:<\/p>\n<p><a href=\"https:\/\/public.tableau.com\/views\/CityHallLibraryPublications\/Dashboard1?:embed=y&amp;:display_count=yes&amp;publish=yes\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-6930\" src=\"https:\/\/i0.wp.com\/studentwork.prattsi.org\/infoshow\/wp-content\/uploads\/sites\/2\/2017\/06\/Dashboard-1-1-620x725.png?resize=620%2C725\" alt=\"\" width=\"620\" height=\"725\" \/><\/a><\/p>\n<p>The most salient information shown in the first graph is a sudden spike in the number of publications starting in 2004. \u00a0Before then, City Hall was publishing under one article per year. \u00a0After this time period, the trend shows peaks and valleys, with a sharper decline after 2008. \u00a0One can only speculate as to the reason behind this trend. \u00a0The only indication of a cause is an increase in Housing and Building legislative documents in 2003. \u00a0Otherwise, there are no readily-available articles from 2004 or 2008 that would suggest any significant events that would warrant these changes. \u00a0In addition, it is not clear whether this decline continues after 2010. \u00a0This is due to the fact that there is no further data after 2010.<\/p>\n<p>The second graph suggests\u00a0some interesting implications. \u00a0While each of the top ten agencies publish a few hundred reports in total, the department of City Planning outpaces them all with total reports numbering in the thousands. \u00a0This holds significance\u00a0when viewed in conjunction with the information displayed on the third graph about topics and report types.<\/p>\n<p>The randomized appearance of the third visualization is\u00a0due to the nature of the packed bubble format. \u00a0Nevertheless, there is interesting information that can be derived from it. \u00a0For example, the biggest bubble shows that most legislative documents are related to housing and buildings. \u00a0The size of this bubble correlates with the overwhelming number of articles published by the agency of City Planning that is shown in the second graph. \u00a0It is possible that this correlation is linked to New York City&#8217;s housing market, which favors landlords\u00a0over small businesses. \u00a0The displacement of power renders many small businesses unable to pay their rent, hence the overwhelming number of legislative documents. \u00a0The correlation may suggest a causal relationship, but more research is necessary for further investigation.<\/p>\n<h2>User Testing Results<\/h2>\n<p>User testing highlighted some of the limitations of TableauPublic. \u00a0As stated before, one user felt that there was no real indication that the graphs were interactive. \u00a0That same user felt that the layout would have been more easily read if stacked vertically. \u00a0However, if that design were chosen, all of the relevant information would be compressed to the point where it would be\u00a0rendered illegible. \u00a0The best solution was to insert blank spaces between each of the graphs to clear up the confusion.<\/p>\n<p>The\u00a0spacial restriction that cut off some of the labels was a point of contention brought up by another user. \u00a0Initial drafts compressed the legends of the second and third graphs so that they wouldn&#8217;t detract from the main visualizations. \u00a0This led to labels\u00a0being cut off, which in turn made the user frustrated. \u00a0With the packed bubble graph, certain bubbles were simply too small to properly show labels without hovering over them. \u00a0Removing the labels on the packed bubble graph was considered, but it only served to make the graph more chaotic. \u00a0As such, there wasn&#8217;t an easy fix to this complaint. \u00a0The full legend on the right was the best tactic to alleviate the problem.<\/p>\n<h2>Moving Forward<\/h2>\n<p>While the dataset up to 2010 is complete, there is surprising little analytical research completed with regard to the conclusions drawn from this information. \u00a0In particular, the spike in publications in the year 2004 and subsequent decline after 2008 have no firm explanation. \u00a0To fully understand why this trend exists, further research into the subject may be required. \u00a0Additional information may discern whether\u00a0this decline continues after 2010 and why.<\/p>\n<p>The graphs in this presentation have shown the information supplied in the dataset. \u00a0Nevertheless, the limitations of TableauPublic prevented full comprehensive display of visualization of the data. \u00a0Visual borders around each graph or presenting them in a stacked vertical fashion may in turn make the visualization more accessible. \u00a0However, space limitations and format restrictions would not allow for this particular design. \u00a0Perhaps user testing of the application may lead to further advancement in visualization and allow analysts to showcase their datasets in a manner that is easier to comprehend.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Introduction In local government, agencies file various types of reports on their activities to organize information and to inform the public and elected officials of the work they are doing and the progress they&#8217;re making. \u00a0These reports include everything from\u00a0budget reports to legislative documentation. \u00a0From these reports, it is possible to detect trends which can&hellip;<\/p>\n","protected":false},"author":52,"featured_media":6930,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[1],"tags":[],"coauthors":[],"class_list":["post-6848","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-visualization"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/paBdcV-1Ms","_links":{"self":[{"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/posts\/6848","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/users\/52"}],"replies":[{"embeddable":true,"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/comments?post=6848"}],"version-history":[{"count":0,"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/posts\/6848\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/"}],"wp:attachment":[{"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/media?parent=6848"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/categories?post=6848"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/tags?post=6848"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/coauthors?post=6848"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}