{"id":8928,"date":"2018-04-05T12:13:32","date_gmt":"2018-04-05T16:13:32","guid":{"rendered":"http:\/\/studentwork.prattsi.org\/infovis\/?p=8928"},"modified":"2018-05-02T01:45:58","modified_gmt":"2018-05-02T05:45:58","slug":"visualizing-nyc-lower-manhattan-retailers-carto","status":"publish","type":"post","link":"https:\/\/studentwork.prattsi.org\/infovis\/labs\/visualizing-nyc-lower-manhattan-retailers-carto\/","title":{"rendered":"Visualizing NYC Lower Manhattan Retailers with Carto"},"content":{"rendered":"<p>Lower Manhattan is one of New York City\u2019s most affluent and crowded districts. It is not only a financial district where Wall Street locates and highly-educated people stay, but also a must-see tourist destination. Therefore, as a business district, Lower Manhattan is highly competitive, and also full of opportunities.<\/p>\n<p>To better understand\u00a0 the retailer market in this neighborhood, I found a dataset of \u201c<a href=\"https:\/\/data.cityofnewyork.us\/Business\/Lower-Manhattan-Retailers\/cw88-qpsr\" target=\"_blank\" rel=\"noopener\">NYC Lower Manhattan Retailers<\/a>\u201d from <a href=\"https:\/\/opendata.cityofnewyork.us\/\" target=\"_blank\" rel=\"noopener\">NYC Opendata<\/a>, and used <a href=\"https:\/\/carto.com\/\" target=\"_blank\" rel=\"noopener\">Carto<\/a> to visualize how retailers in different categories located in the district. Since Lower Manhattan is also a transportation hub, especially the subway system. I added two datasets of \u201c<a href=\"https:\/\/data.cityofnewyork.us\/Transportation\/Subway-Lines\/3qz8-muuu\" target=\"_blank\" rel=\"noopener\">NYC Subway Lines<\/a>\u201d and \u201c<a href=\"https:\/\/data.cityofnewyork.us\/Transportation\/Subway-Stations\/arq3-7z49\" target=\"_blank\" rel=\"noopener\">NYC Subway Stations<\/a>\u201d to see how the retail locations are related to the subway.<\/p>\n<p>Before creating my own visualizations, I gathered some visualization examples for design inspirations. The first one is a typical Carto dashboard which includes a map and some widgets by the side to add more description and detail about the dataset. The second one is from a Carto analysis tutorial about creating travel\/distance buffers. The third one is a visualization of NYC subway line, the color scheme (black background) contrast the subway line very well.<\/p>\n<div id=\"attachment_8931\" style=\"width: 2582px\" class=\"wp-caption aligncenter\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-8931\" class=\"wp-image-8931 size-full\" src=\"https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2018\/04\/Design-Examples.jpg?resize=840%2C164\" alt=\"\" width=\"840\" height=\"164\" srcset=\"https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2018\/04\/Design-Examples.jpg?w=2582&amp;ssl=1 2582w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2018\/04\/Design-Examples.jpg?resize=300%2C59&amp;ssl=1 300w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2018\/04\/Design-Examples.jpg?resize=768%2C150&amp;ssl=1 768w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2018\/04\/Design-Examples.jpg?resize=1024%2C200&amp;ssl=1 1024w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2018\/04\/Design-Examples.jpg?w=1680 1680w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2018\/04\/Design-Examples.jpg?w=2520 2520w\" sizes=\"auto, (max-width: 840px) 100vw, 840px\" \/><p id=\"caption-attachment-8931\" class=\"wp-caption-text\">(Design Inspirations)<\/p><\/div>\n<h2><strong>Categorizing and Labeling the Retailers<\/strong><\/h2>\n<p>When starting the project, I first imported the dataset of <a href=\"https:\/\/data.cityofnewyork.us\/Business\/Lower-Manhattan-R\" target=\"_blank\" rel=\"noopener\">Lower Manhattan Retailers<\/a>. Then I labeled each retailer with their name, address, primary and secondary categories. Therefore, the audience of the map can click each retailer spots to view the detail information.<\/p>\n<p>In order to better contrast retailer location, I rendered a flat and dark basemap so the audience can focus on the key information. I also added three widgets to display the total number of retailers in Lower Manhattan (703) and the bar charts of primary and secondary retailer categories.<\/p>\n<p>From the bar chart, we can see \u201cshopping\u201d (212), \u201ccasual eating &amp; takeout\u201d (211) and \u201cpersonal and professional services\u201d (199) are the top three primary categories of the retailers. Within \u201cpersonal and professional services\u201d, \u201cbanks and check cashing\u201d (39) , \u201chair salon &amp; barber shop\u201d (27) and \u201cnewsstand\u201d (24) are the most common types of business. In terms of food, \u201cDeli\u201d (38) and \u201cFast Food\u201d (28) are the most common types of retailers. It matches the needs of two major target customers in Lower Manhattan: worker and tourist.<\/p>\n<p><a href=\"https:\/\/elisefu.carto.com\/builder\/3fd621f2-07fd-4d36-9c1c-049b5e00a557\/embed\" target=\"_blank\" rel=\"noopener\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-8932\" src=\"https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2018\/04\/NYC-Lower-Manhattan-Retailers.png?resize=840%2C473\" alt=\"\" width=\"840\" height=\"473\" srcset=\"https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2018\/04\/NYC-Lower-Manhattan-Retailers.png?w=3460&amp;ssl=1 3460w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2018\/04\/NYC-Lower-Manhattan-Retailers.png?resize=300%2C169&amp;ssl=1 300w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2018\/04\/NYC-Lower-Manhattan-Retailers.png?resize=768%2C433&amp;ssl=1 768w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2018\/04\/NYC-Lower-Manhattan-Retailers.png?resize=1024%2C577&amp;ssl=1 1024w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2018\/04\/NYC-Lower-Manhattan-Retailers.png?w=1680 1680w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2018\/04\/NYC-Lower-Manhattan-Retailers.png?w=2520 2520w\" sizes=\"auto, (max-width: 840px) 100vw, 840px\" \/><\/a><\/p>\n<h2><strong>Import Dataset of Subway Lines and Stations<\/strong><\/h2>\n<p>To understand how the retailer locations are related to the subway system, I further imported the dataset of <a href=\"https:\/\/data.cityofnewyork.us\/Transportation\/Subway-Lines\/3qz8-muuu\" target=\"_blank\" rel=\"noopener\">NYC subway lines<\/a> and <a href=\"https:\/\/data.cityofnewyork.us\/Transportation\/Subway-Stations\/arq3-7z49\" target=\"_blank\" rel=\"noopener\">station<\/a>. Each subway station is labeled with the name on the map, and the subway line is labeled with a pop-up window. The subway lines are colored based on the lines, while some lines are categorized by the system as \u201cothers\u201d, so they are displayed with the same color.<\/p>\n<p><a href=\"https:\/\/elisefu.carto.com\/builder\/3fd621f2-07fd-4d36-9c1c-049b5e00a557\/embed\" target=\"_blank\" rel=\"noopener\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-8934\" src=\"https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2018\/04\/NYC-Subway-Line-and-Station-with-lower-manhattan-retailers.png?resize=840%2C546\" alt=\"NYC Subway Line and Station (with lower manhattan retailers)\" width=\"840\" height=\"546\" srcset=\"https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2018\/04\/NYC-Subway-Line-and-Station-with-lower-manhattan-retailers.png?w=2710&amp;ssl=1 2710w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2018\/04\/NYC-Subway-Line-and-Station-with-lower-manhattan-retailers.png?resize=300%2C195&amp;ssl=1 300w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2018\/04\/NYC-Subway-Line-and-Station-with-lower-manhattan-retailers.png?resize=768%2C499&amp;ssl=1 768w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2018\/04\/NYC-Subway-Line-and-Station-with-lower-manhattan-retailers.png?resize=1024%2C666&amp;ssl=1 1024w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2018\/04\/NYC-Subway-Line-and-Station-with-lower-manhattan-retailers.png?w=1680 1680w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2018\/04\/NYC-Subway-Line-and-Station-with-lower-manhattan-retailers.png?w=2520 2520w\" sizes=\"auto, (max-width: 840px) 100vw, 840px\" \/><\/a><\/p>\n<p>The result shows the retailer location is highly related to the subway lines and stations. Many retailers are overlapping the subway line, and there are more retailers near subway stations than those not, especially the shopping business.<\/p>\n<p><a href=\"https:\/\/elisefu.carto.com\/builder\/3fd621f2-07fd-4d36-9c1c-049b5e00a557\/embed\" target=\"_blank\" rel=\"noopener\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-8935\" src=\"https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2018\/04\/NYC-Subway-Line-and-Station-with-lower-manhattan-retailers1.png?resize=840%2C570\" alt=\"NYC Subway Line and Station (with lower manhattan retailers)\" width=\"840\" height=\"570\" srcset=\"https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2018\/04\/NYC-Subway-Line-and-Station-with-lower-manhattan-retailers1.png?w=1938&amp;ssl=1 1938w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2018\/04\/NYC-Subway-Line-and-Station-with-lower-manhattan-retailers1.png?resize=300%2C203&amp;ssl=1 300w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2018\/04\/NYC-Subway-Line-and-Station-with-lower-manhattan-retailers1.png?resize=768%2C521&amp;ssl=1 768w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2018\/04\/NYC-Subway-Line-and-Station-with-lower-manhattan-retailers1.png?resize=1024%2C694&amp;ssl=1 1024w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2018\/04\/NYC-Subway-Line-and-Station-with-lower-manhattan-retailers1.png?w=1680 1680w\" sizes=\"auto, (max-width: 840px) 100vw, 840px\" \/><\/a><\/p>\n<h2><strong>Create Travel Buffers (50m) around Subway Stations<\/strong><\/h2>\n<p>Carto has many useful analysis tools which can add more insights to the dataset. \u201cCreate Travel or Distance Buffers\u201d is one of the great tools which creates buffers of distance in meters, kilometers, or miles, so the audience can have a clearer understanding about how one location is related to others. For this project, I created buffers of 50 meters for each subway stations. I found \u201cFulton St\u201d station has the most retailers around within 50m, followed by \u201cPark PI\u201d, \u201cRector St\u201d and \u201cWall St\u201d.<\/p>\n<p><a href=\"https:\/\/elisefu.carto.com\/builder\/3fd621f2-07fd-4d36-9c1c-049b5e00a557\/embed\" target=\"_blank\" rel=\"noopener\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-8933\" src=\"https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2018\/04\/NYC-Lower-Manhattan-Retailers-Subway-Station-Travel-Distance.png?resize=840%2C512\" alt=\"NYC Lower Manhattan Retailers (Subway Station Travel Distance)\" width=\"840\" height=\"512\" srcset=\"https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2018\/04\/NYC-Lower-Manhattan-Retailers-Subway-Station-Travel-Distance.png?w=2262&amp;ssl=1 2262w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2018\/04\/NYC-Lower-Manhattan-Retailers-Subway-Station-Travel-Distance.png?resize=300%2C183&amp;ssl=1 300w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2018\/04\/NYC-Lower-Manhattan-Retailers-Subway-Station-Travel-Distance.png?resize=768%2C468&amp;ssl=1 768w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2018\/04\/NYC-Lower-Manhattan-Retailers-Subway-Station-Travel-Distance.png?resize=1024%2C624&amp;ssl=1 1024w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2018\/04\/NYC-Lower-Manhattan-Retailers-Subway-Station-Travel-Distance.png?w=1680 1680w\" sizes=\"auto, (max-width: 840px) 100vw, 840px\" \/><\/a><\/p>\n<h2><strong>Future Directions<\/strong><\/h2>\n<p>By going forward, I would like to conduct more analysis for the retailer category. In the map widget, Carto only shows the top 5 categories and categorizes the remaining data in \u201cothers\u201d, which is not very accurate and satisfying. I want to see the ratio of all categories and look for what kind of business might be missing there.<\/p>\n<p>I also look forward to adding more dataset to provide more context and comparison for the current data. Here are some datasets I\u2019m very interested in including: First, the divide of sub-districts of Lower Manhattan (e.g. Lower Broadway, WTC\/Tribeca South, Fulton, Financial District, etc.); Second, the median household income in each neighborhood; Third, the data of office building in Lower Manhattan.<\/p>\n<p>Besides dataset, Carto itself is a powerful tool for mapping with many features that I haven\u2019t explored, especially the analysis tool. It will be worthwhile to learn more about Carto and apply as many functions as possible that work for the dataset I use. For example, Carto has a very cool feature which can <a href=\"https:\/\/carto.com\/learn\/guides\/styling\/animating-maps-with-point-data\/\" target=\"_blank\" rel=\"noopener\">animate maps with time data<\/a>. If I were able to find the dataset of the established time of the retailers, I can use Carto to create a map which animates how the retailers were built as time goes.<\/p>\n<p>GIS visualization reveals and exams how geographic relations affect the world around us, which is the most straightforward way to display geographic data. When creating the visualization, it is important to consider how to help the audience relate the data with its context and compare in different ways. Choosing right color scheme and proper size of elements are also important to deliver the messages to the audience clearly. It is fine to explore different features of the software when creating the visualization, but having some goals in mind is a more efficient way to build a meaningful visualization.<\/p>\n<h3><strong><a href=\"https:\/\/elisefu.carto.com\/builder\/3fd621f2-07fd-4d36-9c1c-049b5e00a557\/embed\" target=\"_blank\" rel=\"noopener\">View and play around with the visualization result here<\/a><\/strong><\/h3>\n<p><strong>References:<\/strong><br \/>\n1. NYC Open Data-Lower Manhattan Retailers (2017, September 8). Retrieved from <a href=\"https:\/\/data.cityofnewyork.us\/Business\/Lower-Manhattan-Retailers\/cw88-qpsr\" target=\"_blank\" rel=\"noopener\">https:\/\/data.cityofnewyork.us\/Business\/Lower-Manhattan-Retailers\/cw88-qpsr<\/a><\/p>\n<p>2. NYC Open Data-Subway Stations. Retrieved from <a href=\"https:\/\/data.cityofnewyork.us\/Transportation\/Subway-Stations\/arq3-7z49\" target=\"_blank\" rel=\"noopener\">https:\/\/data.cityofnewyork.us\/Transportation\/Subway-Stations\/arq3-7z49<\/a><\/p>\n<p>3. NYC Open Data-Subway Lines. Retrieved from <a href=\"https:\/\/data.cityofnewyork.us\/Transportation\/Subway-Lines\/3qz8-muuu\" target=\"_blank\" rel=\"noopener\">https:\/\/data.cityofnewyork.us\/Transportation\/Subway-Lines\/3qz8-muuu<\/a><\/p>\n<p>4. First Design Example: <a href=\"https:\/\/libraries.mit.edu\/news\/online-intro-carto-2\/25850\/\" target=\"_blank\" rel=\"noopener\">https:\/\/libraries.mit.edu\/news\/online-intro-carto-2\/25850\/<\/a><\/p>\n<p>5. Second Design Example: <a href=\"https:\/\/www.youtube.com\/watch?v=S_kNe24cO18\" target=\"_blank\" rel=\"noopener\">https:\/\/www.youtube.com\/watch?v=S_kNe24cO18<\/a><\/p>\n<p>6. Third Design Example: <a href=\"https:\/\/carto.com\/blog\/mow-subway\/\" target=\"_blank\" rel=\"noopener\">https:\/\/carto.com\/blog\/mow-subway\/<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Lower Manhattan is one of New York City\u2019s most affluent and crowded districts. It is not only a financial district where Wall Street locates and highly-educated people stay, but also a must-see tourist destination. Therefore, as a business district, Lower Manhattan is highly competitive, and also full of opportunities. To better understand\u00a0 the retailer market&hellip;<\/p>\n","protected":false},"author":257,"featured_media":8932,"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],"tags":[],"coauthors":[],"class_list":["post-8928","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-labs"],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2018\/04\/NYC-Lower-Manhattan-Retailers.png?fit=3460%2C1950&ssl=1","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/paBdcV-2k0","_links":{"self":[{"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/posts\/8928","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\/257"}],"replies":[{"embeddable":true,"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/comments?post=8928"}],"version-history":[{"count":9,"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/posts\/8928\/revisions"}],"predecessor-version":[{"id":8955,"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/posts\/8928\/revisions\/8955"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/media\/8932"}],"wp:attachment":[{"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/media?parent=8928"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/categories?post=8928"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/tags?post=8928"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/coauthors?post=8928"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}