{"id":18405,"date":"2020-06-23T11:34:04","date_gmt":"2020-06-23T15:34:04","guid":{"rendered":"http:\/\/studentwork.prattsi.org\/infovis\/?p=18405"},"modified":"2020-06-23T11:34:08","modified_gmt":"2020-06-23T15:34:08","slug":"the-nypd-and-summonses-for-victimless-crimes","status":"publish","type":"post","link":"https:\/\/studentwork.prattsi.org\/infovis\/labs\/the-nypd-and-summonses-for-victimless-crimes\/","title":{"rendered":"The NYPD and Summonses for Victimless Crimes"},"content":{"rendered":"\n<p>Tableau Public Lab Report by Kyle Palermo, June 23, 2020.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"840\" height=\"500\" src=\"https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2020\/06\/Screen-Shot-2020-06-23-at-7.37.46-AM.png?resize=840%2C500\" alt=\"\" class=\"wp-image-18408\" srcset=\"https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2020\/06\/Screen-Shot-2020-06-23-at-7.37.46-AM.png?resize=1024%2C610&amp;ssl=1 1024w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2020\/06\/Screen-Shot-2020-06-23-at-7.37.46-AM.png?resize=300%2C179&amp;ssl=1 300w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2020\/06\/Screen-Shot-2020-06-23-at-7.37.46-AM.png?resize=768%2C458&amp;ssl=1 768w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2020\/06\/Screen-Shot-2020-06-23-at-7.37.46-AM.png?resize=1536%2C915&amp;ssl=1 1536w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2020\/06\/Screen-Shot-2020-06-23-at-7.37.46-AM.png?resize=2048%2C1221&amp;ssl=1 2048w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2020\/06\/Screen-Shot-2020-06-23-at-7.37.46-AM.png?resize=800%2C477&amp;ssl=1 800w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2020\/06\/Screen-Shot-2020-06-23-at-7.37.46-AM.png?resize=302%2C180&amp;ssl=1 302w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2020\/06\/Screen-Shot-2020-06-23-at-7.37.46-AM.png?w=1680 1680w\" sizes=\"auto, (max-width: 840px) 100vw, 840px\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">Background<\/h3>\n\n\n\n<p>Criminal summonses are one of four primary enforcement actions at the NYPD\u2019s disposal (in addition to what happens off-the-books or results in death). Rather than protecting life or property, a plurality of these summonses are issued for marijuana possession or various alcohol consumption offenses (excluding the highest single offense category, federal motor vehicle violations). Looking at criminal summons data for 2019, this visualization shows that the NYPD pays a surprising amount of attention to marijuana and alcohol consumption and that their efforts to suppress these rather ordinary vices target specific neighborhoods and, overwhelmingly, people of color. Police murders remind us that no matter how innocuous the pretext, any encounter with law enforcement can turn deadly, making this small war against victimless non-crime all the more troubling.&nbsp;&nbsp;<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Process Documentation<\/h3>\n\n\n\n<p><a href=\"https:\/\/public.tableau.com\/\">Tableau Public<\/a> is a free, cloud-based application for filtering, analyzing, and visualizing data, and is capable of handling large data sets that might choke more vanilla spreadsheet applications like Excel or Google Sheets. Rather than importing a data source, Tableau links to it and provides an interface for previewing and filtering down rows to quickly mute extraneous data without altering your source file. From there, users can create additional worksheets to explore and visualize the data, including the standard array of charts familiar to spreadsheet users and some more advanced visualizations such as packed circle charts and tree maps. Users can then aggregate their visualizations into dashboards, and all of their work is housed as a single workbook which can be saved to a profile on Tableau Public\u2019s <a href=\"https:\/\/public.tableau.com\/en-us\/s\/authors#!\/\">online community<\/a>. The public version pens users into Tableau\u2019s proprietary environment, and exporting data or visualizations to other formats largely off limits.<\/p>\n\n\n\n<figure class=\"wp-block-gallery columns-2 is-cropped wp-block-gallery-1 is-layout-flex wp-block-gallery-is-layout-flex\"><ul class=\"blocks-gallery-grid\"><li class=\"blocks-gallery-item\"><figure><img loading=\"lazy\" decoding=\"async\" width=\"3102\" height=\"2008\" src=\"https:\/\/i1.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2020\/06\/Screen-Shot-2020-06-23-at-7.00.14-AM.png?fit=840%2C544&amp;ssl=1\" alt=\"\" data-id=\"18416\" data-full-url=\"https:\/\/i1.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2020\/06\/Screen-Shot-2020-06-23-at-7.00.14-AM.png?fit=3102%2C2008&amp;ssl=1\" data-link=\"https:\/\/studentwork.prattsi.org\/infovis\/?attachment_id=18416\" class=\"wp-image-18416\" srcset=\"https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2020\/06\/Screen-Shot-2020-06-23-at-7.00.14-AM.png?w=3102&amp;ssl=1 3102w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2020\/06\/Screen-Shot-2020-06-23-at-7.00.14-AM.png?resize=300%2C194&amp;ssl=1 300w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2020\/06\/Screen-Shot-2020-06-23-at-7.00.14-AM.png?resize=1024%2C663&amp;ssl=1 1024w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2020\/06\/Screen-Shot-2020-06-23-at-7.00.14-AM.png?resize=768%2C497&amp;ssl=1 768w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2020\/06\/Screen-Shot-2020-06-23-at-7.00.14-AM.png?resize=1536%2C994&amp;ssl=1 1536w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2020\/06\/Screen-Shot-2020-06-23-at-7.00.14-AM.png?resize=2048%2C1326&amp;ssl=1 2048w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2020\/06\/Screen-Shot-2020-06-23-at-7.00.14-AM.png?resize=800%2C518&amp;ssl=1 800w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2020\/06\/Screen-Shot-2020-06-23-at-7.00.14-AM.png?resize=278%2C180&amp;ssl=1 278w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2020\/06\/Screen-Shot-2020-06-23-at-7.00.14-AM.png?w=1680 1680w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2020\/06\/Screen-Shot-2020-06-23-at-7.00.14-AM.png?w=2520 2520w\" sizes=\"auto, (max-width: 840px) 100vw, 840px\" \/><\/figure><\/li><li class=\"blocks-gallery-item\"><figure><img loading=\"lazy\" decoding=\"async\" width=\"3102\" height=\"2008\" src=\"https:\/\/i1.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2020\/06\/Screen-Shot-2020-06-23-at-7.00.36-AM.png?fit=840%2C544&amp;ssl=1\" alt=\"\" data-id=\"18417\" data-full-url=\"https:\/\/i1.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2020\/06\/Screen-Shot-2020-06-23-at-7.00.36-AM.png?fit=3102%2C2008&amp;ssl=1\" data-link=\"https:\/\/studentwork.prattsi.org\/infovis\/?attachment_id=18417\" class=\"wp-image-18417\" srcset=\"https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2020\/06\/Screen-Shot-2020-06-23-at-7.00.36-AM.png?w=3102&amp;ssl=1 3102w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2020\/06\/Screen-Shot-2020-06-23-at-7.00.36-AM.png?resize=300%2C194&amp;ssl=1 300w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2020\/06\/Screen-Shot-2020-06-23-at-7.00.36-AM.png?resize=1024%2C663&amp;ssl=1 1024w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2020\/06\/Screen-Shot-2020-06-23-at-7.00.36-AM.png?resize=768%2C497&amp;ssl=1 768w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2020\/06\/Screen-Shot-2020-06-23-at-7.00.36-AM.png?resize=1536%2C994&amp;ssl=1 1536w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2020\/06\/Screen-Shot-2020-06-23-at-7.00.36-AM.png?resize=2048%2C1326&amp;ssl=1 2048w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2020\/06\/Screen-Shot-2020-06-23-at-7.00.36-AM.png?resize=800%2C518&amp;ssl=1 800w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2020\/06\/Screen-Shot-2020-06-23-at-7.00.36-AM.png?resize=278%2C180&amp;ssl=1 278w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2020\/06\/Screen-Shot-2020-06-23-at-7.00.36-AM.png?w=1680 1680w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2020\/06\/Screen-Shot-2020-06-23-at-7.00.36-AM.png?w=2520 2520w\" sizes=\"auto, (max-width: 840px) 100vw, 840px\" \/><\/figure><\/li><\/ul><figcaption class=\"blocks-gallery-caption\">Some examples of Tableau&#8217;s UI, including the data source preview interface and a basic worksheet.<\/figcaption><\/figure>\n\n\n\n<p>Before beginning my visualization I reviewed projects featured on Tableau Public\u2019s <a href=\"https:\/\/public.tableau.com\/en-us\/gallery\/?tab=viz-of-the-day&amp;type=viz-of-the-day\">Viz of the Day\/Gallery<\/a> including \u201c<a href=\"https:\/\/public.tableau.com\/en-us\/gallery\/black-owned-eateries-us?tab=viz-of-the-day&amp;type=viz-of-the-day\">Black Owned Eateries in the US<\/a>,\u201d \u201c<a href=\"https:\/\/public.tableau.com\/en-us\/gallery\/international-astronauts-0?tab=viz-of-the-day&amp;type=viz-of-the-day\">International Astronauts<\/a>,\u201d and \u201c<a rel=\"noreferrer noopener\" href=\"https:\/\/public.tableau.com\/en-us\/gallery\/color-covid-19?tab=viz-of-the-day&amp;type=viz-of-the-day\" target=\"_blank\">The Color of COVID-19<\/a>,\u201d as well as Tableau\u2019s <a href=\"https:\/\/public.tableau.com\/s\/resources#currentTraining\">how-to resources<\/a>.\u00a0<\/p>\n\n\n\n<figure class=\"wp-block-gallery columns-3 is-cropped wp-block-gallery-2 is-layout-flex wp-block-gallery-is-layout-flex\"><ul class=\"blocks-gallery-grid\"><li class=\"blocks-gallery-item\"><figure><img loading=\"lazy\" decoding=\"async\" width=\"2458\" height=\"1510\" src=\"https:\/\/i2.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2020\/06\/Screen-Shot-2020-06-23-at-8.07.58-AM.png?fit=840%2C516&amp;ssl=1\" alt=\"\" data-id=\"18409\" data-full-url=\"https:\/\/i2.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2020\/06\/Screen-Shot-2020-06-23-at-8.07.58-AM.png?fit=2458%2C1510&amp;ssl=1\" data-link=\"https:\/\/studentwork.prattsi.org\/infovis\/?attachment_id=18409\" class=\"wp-image-18409\" srcset=\"https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2020\/06\/Screen-Shot-2020-06-23-at-8.07.58-AM.png?w=2458&amp;ssl=1 2458w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2020\/06\/Screen-Shot-2020-06-23-at-8.07.58-AM.png?resize=300%2C184&amp;ssl=1 300w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2020\/06\/Screen-Shot-2020-06-23-at-8.07.58-AM.png?resize=1024%2C629&amp;ssl=1 1024w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2020\/06\/Screen-Shot-2020-06-23-at-8.07.58-AM.png?resize=768%2C472&amp;ssl=1 768w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2020\/06\/Screen-Shot-2020-06-23-at-8.07.58-AM.png?resize=1536%2C944&amp;ssl=1 1536w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2020\/06\/Screen-Shot-2020-06-23-at-8.07.58-AM.png?resize=2048%2C1258&amp;ssl=1 2048w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2020\/06\/Screen-Shot-2020-06-23-at-8.07.58-AM.png?resize=800%2C491&amp;ssl=1 800w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2020\/06\/Screen-Shot-2020-06-23-at-8.07.58-AM.png?resize=293%2C180&amp;ssl=1 293w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2020\/06\/Screen-Shot-2020-06-23-at-8.07.58-AM.png?w=1680 1680w\" sizes=\"auto, (max-width: 840px) 100vw, 840px\" \/><\/figure><\/li><li class=\"blocks-gallery-item\"><figure><img loading=\"lazy\" decoding=\"async\" width=\"1798\" height=\"1522\" src=\"https:\/\/i1.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2020\/06\/Screen-Shot-2020-06-23-at-8.08.11-AM.png?fit=840%2C711&amp;ssl=1\" alt=\"\" data-id=\"18410\" data-full-url=\"https:\/\/i1.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2020\/06\/Screen-Shot-2020-06-23-at-8.08.11-AM.png?fit=1798%2C1522&amp;ssl=1\" data-link=\"https:\/\/studentwork.prattsi.org\/infovis\/?attachment_id=18410\" class=\"wp-image-18410\" srcset=\"https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2020\/06\/Screen-Shot-2020-06-23-at-8.08.11-AM.png?w=1798&amp;ssl=1 1798w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2020\/06\/Screen-Shot-2020-06-23-at-8.08.11-AM.png?resize=300%2C254&amp;ssl=1 300w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2020\/06\/Screen-Shot-2020-06-23-at-8.08.11-AM.png?resize=1024%2C867&amp;ssl=1 1024w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2020\/06\/Screen-Shot-2020-06-23-at-8.08.11-AM.png?resize=768%2C650&amp;ssl=1 768w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2020\/06\/Screen-Shot-2020-06-23-at-8.08.11-AM.png?resize=1536%2C1300&amp;ssl=1 1536w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2020\/06\/Screen-Shot-2020-06-23-at-8.08.11-AM.png?resize=800%2C677&amp;ssl=1 800w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2020\/06\/Screen-Shot-2020-06-23-at-8.08.11-AM.png?resize=213%2C180&amp;ssl=1 213w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2020\/06\/Screen-Shot-2020-06-23-at-8.08.11-AM.png?w=1680 1680w\" sizes=\"auto, (max-width: 840px) 100vw, 840px\" \/><\/figure><\/li><li class=\"blocks-gallery-item\"><figure><img loading=\"lazy\" decoding=\"async\" width=\"2414\" height=\"1342\" src=\"https:\/\/i1.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2020\/06\/Screen-Shot-2020-06-23-at-8.08.21-AM.png?fit=840%2C467&amp;ssl=1\" alt=\"\" data-id=\"18411\" data-full-url=\"https:\/\/i1.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2020\/06\/Screen-Shot-2020-06-23-at-8.08.21-AM.png?fit=2414%2C1342&amp;ssl=1\" data-link=\"https:\/\/studentwork.prattsi.org\/infovis\/?attachment_id=18411\" class=\"wp-image-18411\" srcset=\"https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2020\/06\/Screen-Shot-2020-06-23-at-8.08.21-AM.png?w=2414&amp;ssl=1 2414w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2020\/06\/Screen-Shot-2020-06-23-at-8.08.21-AM.png?resize=300%2C167&amp;ssl=1 300w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2020\/06\/Screen-Shot-2020-06-23-at-8.08.21-AM.png?resize=1024%2C569&amp;ssl=1 1024w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2020\/06\/Screen-Shot-2020-06-23-at-8.08.21-AM.png?resize=768%2C427&amp;ssl=1 768w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2020\/06\/Screen-Shot-2020-06-23-at-8.08.21-AM.png?resize=1536%2C854&amp;ssl=1 1536w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2020\/06\/Screen-Shot-2020-06-23-at-8.08.21-AM.png?resize=2048%2C1139&amp;ssl=1 2048w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2020\/06\/Screen-Shot-2020-06-23-at-8.08.21-AM.png?resize=800%2C445&amp;ssl=1 800w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2020\/06\/Screen-Shot-2020-06-23-at-8.08.21-AM.png?resize=324%2C180&amp;ssl=1 324w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2020\/06\/Screen-Shot-2020-06-23-at-8.08.21-AM.png?w=1680 1680w\" sizes=\"auto, (max-width: 840px) 100vw, 840px\" \/><\/figure><\/li><\/ul><figcaption class=\"blocks-gallery-caption\">Some standout visualizations made with and featured by Tableau Public.<\/figcaption><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Results and Discussion<\/h3>\n\n\n\n<p>My <a href=\"https:\/\/public.tableau.com\/profile\/kyle.palermo#!\/vizhome\/NYPDandSummonsesforVictimlessCrimes\/Dashboard1\">Tableau project<\/a> includes eight worksheets and one dashboard visualizing the NYPD\u2019s distribution of criminal summonses. The source data is saved from the City of New York\u2019s <a href=\"https:\/\/opendata.cityofnewyork.us\/\">open data portal<\/a>, which provides a variety of open-source data sourced from various city agencies for free public download. The first worksheet sums each distinct offense documented in the data and sorts them from most to least prevalent. I then manually identified and grouped categories that describe alcohol consumption and marijuana possession, and filtered out federal motor vehicle safety code violations, which represent the single largest category of offenses but skew the visualization away from street-level law enforcement. A subsequent sheet compares the number of summonses in 2019 for alcohol, marijuana, and all other offenses, using a tree map to maximize visibility and economize on space in a dashboard view. Three subsequent maps show the geographic distribution of summonses in each of these categories across the five-borough area, with dots set to a low opacity to provide a heat map effect wherever summonses are highly concentrated. Three further visualizations break summonses down by race of the recipient (using the NYPD\u2019s race categories but combining \u201cWhite Hispanic\u201d and \u201cBlack Hispanic\u201d into a single category). A dashboard compiles each visualization into a three-column display.\u00a0<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/public.tableau.com\/profile\/kyle.palermo#!\/vizhome\/NYPDandSummonsesforVictimlessCrimes\/Dashboard1\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"840\" height=\"508\" src=\"https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2020\/06\/Screen-Shot-2020-06-23-at-7.36.27-AM-1.png?resize=840%2C508&#038;ssl=1\" alt=\"\" class=\"wp-image-18414\" srcset=\"https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2020\/06\/Screen-Shot-2020-06-23-at-7.36.27-AM-1.png?w=2552&amp;ssl=1 2552w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2020\/06\/Screen-Shot-2020-06-23-at-7.36.27-AM-1.png?resize=300%2C181&amp;ssl=1 300w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2020\/06\/Screen-Shot-2020-06-23-at-7.36.27-AM-1.png?resize=1024%2C619&amp;ssl=1 1024w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2020\/06\/Screen-Shot-2020-06-23-at-7.36.27-AM-1.png?resize=768%2C464&amp;ssl=1 768w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2020\/06\/Screen-Shot-2020-06-23-at-7.36.27-AM-1.png?resize=1536%2C928&amp;ssl=1 1536w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2020\/06\/Screen-Shot-2020-06-23-at-7.36.27-AM-1.png?resize=2048%2C1237&amp;ssl=1 2048w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2020\/06\/Screen-Shot-2020-06-23-at-7.36.27-AM-1.png?resize=800%2C483&amp;ssl=1 800w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2020\/06\/Screen-Shot-2020-06-23-at-7.36.27-AM-1.png?resize=298%2C180&amp;ssl=1 298w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2020\/06\/Screen-Shot-2020-06-23-at-7.36.27-AM-1.png?w=1680 1680w\" sizes=\"auto, (max-width: 840px) 100vw, 840px\" \/><\/a><figcaption>View the interactive viz <a href=\"https:\/\/public.tableau.com\/profile\/kyle.palermo#!\/vizhome\/NYPDandSummonsesforVictimlessCrimes\/Dashboard1\">here<\/a>. <\/figcaption><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">Reflection<\/h3>\n\n\n\n<p>My visualization succeeded in manipulating the data and forming it into a legible story, however it would benefit from a more holistic design and more visual development. Rather than breaking up my visualization into distinct chunks, I think the story would be better told on a single map with accompanying charts. Also, the visuals are polished but very basic. Tableau Public\u2019s <a href=\"https:\/\/public.tableau.com\/en-us\/gallery\">gallery<\/a> shows that more advanced visualizations are possible but I frequently hit roadblocks while attempting to manipulate my dashboard and often imagined myself needing to redraw the visualizations in illustrator.\u00a0\u00a0Rather than try to hack together a more visually designed presentation I decided it would be best to learn more about properly manipulating visuals in Tableau and then return to it later.<\/p>\n\n\n\n<p>This visualization would also be improved through a more comprehensive approach to the data, including coding the more than 550 distinct offenses to remove all moving violations&#8211;rather than only those that are covered under the federal motor vehicle safety code&#8211;and to more systematically include\/exclude the less common alcohol-related offenses in the data\u2019s tail. Also, criminal summonses are just one part of the picture. Arrests and desk appearance tickets, civil summonses, and stop-and-frisk data are all available to help tell a more complete story about predatory police behavior, but would require a larger effort to harmonize and combine several different data sets. I discovered that neither Tableau nor <a href=\"https:\/\/openrefine.org\/\">OpenRefine<\/a> offer any simple, automated process for joining distinct data sets, so I tabled any thoughts of a more comprehensive data set.&nbsp;<\/p>\n\n\n\n<p>As an Excel native, I often find Tableau difficult to navigate and catch myself searching through forums to figure out how to complete even simple tasks like changing the contents of data labels. But, despite my frequent head scratching, I&#8217;ve generally acquiesced to Tableau\u2019s way of doing things and find it to be a very effective tool for taking control of large data sets and creating visualizations in a few clicks.\u00a0<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Tableau Public Lab Report by Kyle Palermo, June 23, 2020. Background Criminal summonses are one of four primary enforcement actions at the NYPD\u2019s disposal (in addition to what happens off-the-books or results in death). Rather than protecting life or property, a plurality of these summonses are issued for marijuana possession or various alcohol consumption offenses&hellip;<\/p>\n","protected":false},"author":719,"featured_media":18408,"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":[340,149],"tags":[],"coauthors":[530],"class_list":["post-18405","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-charts","category-labs"],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2020\/06\/Screen-Shot-2020-06-23-at-7.37.46-AM.png?fit=2094%2C1248&ssl=1","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/paBdcV-4MR","_links":{"self":[{"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/posts\/18405","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\/719"}],"replies":[{"embeddable":true,"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/comments?post=18405"}],"version-history":[{"count":1,"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/posts\/18405\/revisions"}],"predecessor-version":[{"id":18419,"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/posts\/18405\/revisions\/18419"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/media\/18408"}],"wp:attachment":[{"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/media?parent=18405"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/categories?post=18405"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/tags?post=18405"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/coauthors?post=18405"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}