{"id":11710,"date":"2018-11-28T07:49:11","date_gmt":"2018-11-28T12:49:11","guid":{"rendered":"http:\/\/studentwork.prattsi.org\/infovis\/?p=11710"},"modified":"2019-01-10T23:51:57","modified_gmt":"2019-01-11T04:51:57","slug":"lithium-in-our-water","status":"publish","type":"post","link":"https:\/\/studentwork.prattsi.org\/infovis\/visualization\/lithium-in-our-water\/","title":{"rendered":"Personal Citibike Usage"},"content":{"rendered":"<p><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" class=\"alignnone  wp-image-11860\" src=\"https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2018\/11\/CITI-bike-rental.jpg?resize=499%2C331\" alt=\"\" width=\"499\" height=\"331\" srcset=\"https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2018\/11\/CITI-bike-rental.jpg?resize=300%2C199&amp;ssl=1 300w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2018\/11\/CITI-bike-rental.jpg?resize=768%2C508&amp;ssl=1 768w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2018\/11\/CITI-bike-rental.jpg?resize=1024%2C678&amp;ssl=1 1024w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2018\/11\/CITI-bike-rental.jpg?w=1580&amp;ssl=1 1580w\" sizes=\"auto, (max-width: 499px) 100vw, 499px\" \/><\/p>\n<p>Introduction:<\/p>\n<p>Citibike is the shared bike service that covers most of Manhattan and northern Brooklyn in New York City.\u00a0 For me, it is used primarily for local short transit, as I use my own bike for longer rides.\u00a0 This visualization captures starting and ending points over a three month period of my personal Citibike usage.\u00a0 These services have been an important effort for NYC as well as cities around the world to minimize taxi and ride share applications, decreasing congestion and curbing emissions.\u00a0 Perhaps even more importantly, they have been part of a citywide push to improve the bike lane network.<\/p>\n<p>Inspiration:<\/p>\n<p>This project is spawned out of the work of data diary projects, with a particular interest in some of the work by Nicholas Felton.\u00a0 It is a section of a longer data project I am collecting for.\u00a0 It will be particularly interesting when different circles appear depending on transit mode, i.e. the Citibike use with be the smallest circle, personal bike perhaps the next, subway, bus, plane, etc.\u00a0 Here are a couple of his visualizations.<\/p>\n<p><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-11851\" src=\"https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2018\/11\/03%402x.jpg?resize=294%2C368\" alt=\"\" width=\"294\" height=\"368\" srcset=\"https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2018\/11\/03%402x.jpg?resize=240%2C300&amp;ssl=1 240w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2018\/11\/03%402x.jpg?resize=768%2C960&amp;ssl=1 768w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2018\/11\/03%402x.jpg?resize=819%2C1024&amp;ssl=1 819w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2018\/11\/03%402x.jpg?w=1280&amp;ssl=1 1280w\" sizes=\"auto, (max-width: 294px) 100vw, 294px\" \/>\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 <img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-11852\" src=\"https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2018\/11\/04%402x.jpg?resize=256%2C454\" alt=\"\" width=\"256\" height=\"454\" srcset=\"https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2018\/11\/04%402x.jpg?resize=169%2C300&amp;ssl=1 169w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2018\/11\/04%402x.jpg?resize=768%2C1366&amp;ssl=1 768w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2018\/11\/04%402x.jpg?resize=576%2C1024&amp;ssl=1 576w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2018\/11\/04%402x.jpg?w=1280&amp;ssl=1 1280w\" sizes=\"auto, (max-width: 256px) 100vw, 256px\" \/><\/p>\n<p>Materials:<\/p>\n<p><a href=\"https:\/\/www.citibikenyc.com\/\">Citibike<\/a>&#8211; by logging into your account, you can access your personal data between dates<\/p>\n<p><a href=\"http:\/\/openrefine.org\/\">Openrefine<\/a>&#8211; used to parse data into appropriate columns from text file from Citibike<\/p>\n<p><a href=\"https:\/\/www.latlong.net\/convert-address-to-lat-long.html\">LongLat.net<\/a>&#8211; used to get coordinates of Citibike locations (not included in original dataset)<\/p>\n<p><a href=\"https:\/\/carto.com\/\">Carto<\/a>&#8211; mapping program used to build visualization<\/p>\n<p><a href=\"https:\/\/www.adobe.com\/products\/illustrator.html?sdid=KKQML&amp;mv=search&amp;s_kwcid=AL!3085!105!34046926702!s!298018736727&amp;ef_id=XAW5bQAAALspOU6V:20181203231701:s\">Illustrator<\/a>&#8211; postproduction layout work<\/p>\n<p>Methods:<\/p>\n<p>After deciding the lithium water concentration correlated to suicide project did not have nearly enough data to make any significant points, I changed over to look at my Citibike personal data.\u00a0 As mentioned in the Inspiration section, the work of Nicholas Felton figured heavily into this visualization.<\/p>\n<p><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-11857\" src=\"https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2018\/11\/Screen-Shot-2018-12-03-at-1.00.05-PM.png?resize=472%2C184\" alt=\"\" width=\"472\" height=\"184\" srcset=\"https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2018\/11\/Screen-Shot-2018-12-03-at-1.00.05-PM.png?resize=300%2C117&amp;ssl=1 300w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2018\/11\/Screen-Shot-2018-12-03-at-1.00.05-PM.png?resize=768%2C299&amp;ssl=1 768w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2018\/11\/Screen-Shot-2018-12-03-at-1.00.05-PM.png?resize=1024%2C398&amp;ssl=1 1024w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2018\/11\/Screen-Shot-2018-12-03-at-1.00.05-PM.png?w=1680 1680w\" sizes=\"auto, (max-width: 472px) 100vw, 472px\" \/><\/p>\n<p>Looking at the last 3 months of personal Citibike data was enough to show trends but also reasonable to geolocate using the tools currently known and available.\u00a0 OpenRefine was critical to change over the text file into a readable version for Carto.<\/p>\n<p><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-11856\" src=\"https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2018\/11\/Screen-Shot-2018-12-01-at-12.53.35-PM.png?resize=456%2C391\" alt=\"\" width=\"456\" height=\"391\" srcset=\"https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2018\/11\/Screen-Shot-2018-12-01-at-12.53.35-PM.png?resize=300%2C257&amp;ssl=1 300w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2018\/11\/Screen-Shot-2018-12-01-at-12.53.35-PM.png?resize=768%2C657&amp;ssl=1 768w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2018\/11\/Screen-Shot-2018-12-01-at-12.53.35-PM.png?resize=1024%2C877&amp;ssl=1 1024w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2018\/11\/Screen-Shot-2018-12-01-at-12.53.35-PM.png?w=1376&amp;ssl=1 1376w\" sizes=\"auto, (max-width: 456px) 100vw, 456px\" \/><\/p>\n<p>Using different layers in Carto I was able to assign color and opacity to different columns in the data (i.e. date and use).\u00a0 The final work in Illustrator was just to play with layout to give the visualization context and a key which I thought was more readable than what I was finding in the Carto legend section.<\/p>\n<p>Results:<\/p>\n<p><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-11853\" src=\"https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2018\/11\/citibike-2.1.png?resize=661%2C529\" alt=\"\" width=\"661\" height=\"529\" srcset=\"https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2018\/11\/citibike-2.1.png?resize=300%2C240&amp;ssl=1 300w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2018\/11\/citibike-2.1.png?resize=768%2C615&amp;ssl=1 768w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2018\/11\/citibike-2.1.png?resize=1024%2C820&amp;ssl=1 1024w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2018\/11\/citibike-2.1.png?w=1680 1680w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2018\/11\/citibike-2.1.png?w=2520 2520w\" sizes=\"auto, (max-width: 661px) 100vw, 661px\" \/><\/p>\n<p>The visualization shows my Citibike usage habits over the past three months.\u00a0 It is clear I typically use the service in one direction, taking a bike from near my apartment, and riding it to a location.\u00a0 Furthermore, locations I ride to more often are shown by a larger circle.\u00a0 What is lost in the way the visualization is shown however is time through opacity.\u00a0 For example, it is not clear if a opaque large circle has been used only often and recently, or consistently and throughout.\u00a0 These two scenarios are shown similarly and requires a different graphical representation method to create a unique look for each scenario.\u00a0 The paths were left out of the visualization because they were distracting and appeared &#8220;as the crow flies&#8221;, which in showing bike route data, is not particularly helpful.<\/p>\n<p>Future Thoughts:<\/p>\n<p>In order to show time, I believe a system of &#8220;stacking&#8221; circles may be better, so the most recent use (i.e. full opacity) does not block the underlying data, and like mentioned above, differentiates locations used consistently and locations used heavily recently.<\/p>\n<p>Further use of a similar technique for personal bike use, subways, walking, buses, etc. could be very interesting to show on the same map to view the circles of transportation modes used for various distances and parts of the city.\u00a0 This would be a more interesting study to understand both personal habits, and habits in general, in regards to efficient transportation options.<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Introduction: Citibike is the shared bike service that covers most of Manhattan and northern Brooklyn in New York City.\u00a0 For me, it is used primarily for local short transit, as I use my own bike for longer rides.\u00a0 This visualization captures starting and ending points over a three month period of my personal Citibike usage.\u00a0&hellip;<\/p>\n","protected":false},"author":551,"featured_media":11851,"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":[149,341,1],"tags":[],"coauthors":[324],"class_list":["post-11710","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-labs","category-maps","category-visualization"],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2018\/11\/03%402x.jpg?fit=1280%2C1600&ssl=1","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/paBdcV-32S","_links":{"self":[{"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/posts\/11710","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\/551"}],"replies":[{"embeddable":true,"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/comments?post=11710"}],"version-history":[{"count":6,"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/posts\/11710\/revisions"}],"predecessor-version":[{"id":11861,"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/posts\/11710\/revisions\/11861"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/media\/11851"}],"wp:attachment":[{"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/media?parent=11710"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/categories?post=11710"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/tags?post=11710"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/coauthors?post=11710"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}