{"id":37556,"date":"2023-11-27T18:30:46","date_gmt":"2023-11-27T23:30:46","guid":{"rendered":"https:\/\/studentwork.prattsi.org\/infovis\/?p=37556"},"modified":"2023-12-05T13:26:07","modified_gmt":"2023-12-05T18:26:07","slug":"film-permits-in-new-york-city","status":"publish","type":"post","link":"https:\/\/studentwork.prattsi.org\/infovis\/labs\/film-permits-in-new-york-city\/","title":{"rendered":"Film Permits in New York City"},"content":{"rendered":"<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-medium\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"300\" height=\"276\" src=\"https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2023\/11\/Screen-Shot-2023-11-26-at-8.41.12-PM-300x276.png?resize=300%2C276&#038;ssl=1\" alt=\"\" class=\"wp-image-37557\" srcset=\"https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2023\/11\/Screen-Shot-2023-11-26-at-8.41.12-PM.png?resize=300%2C276&amp;ssl=1 300w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2023\/11\/Screen-Shot-2023-11-26-at-8.41.12-PM.png?resize=768%2C706&amp;ssl=1 768w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2023\/11\/Screen-Shot-2023-11-26-at-8.41.12-PM.png?resize=800%2C736&amp;ssl=1 800w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2023\/11\/Screen-Shot-2023-11-26-at-8.41.12-PM.png?resize=196%2C180&amp;ssl=1 196w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2023\/11\/Screen-Shot-2023-11-26-at-8.41.12-PM.png?w=1020&amp;ssl=1 1020w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><figcaption class=\"wp-element-caption\">Episode from Friends <\/figcaption><\/figure>\n<\/div>\n\n\n<p>During my time in New York City, I have seen many situations where productions are being installed for filming, acting the street in the middle of the day on a busy street. Is fascinating to see how many different movies, series, and documentaries are filmed across many different streets that I usually pass by or even live nearby.<\/p>\n\n\n\n<blockquote class=\"wp-block-quote is-style-plain is-layout-flow wp-block-quote-is-layout-flow\">\n<figure class=\"wp-block-pullquote has-small-font-size\" style=\"font-style:normal;font-weight:300\"><blockquote><p><em>&#8220;I can&#8217;t believe I&#8217;m here!&#8221; &#8220;Welcome to New York City! I should I say, &#8216;Ghe deu flooff New York City&#8217;?&#8221; &#8220;Why would you say that?&#8221;<\/em><br><em>-Erica (Anna Farris), Joey and Chandler, Friends.<\/em><\/p><\/blockquote><\/figure>\n<\/blockquote>\n\n\n\n<p>While looking for an inspirational topic for this lab, I was able to find NYC open data about NYC permits by the city government initiative, then proceeded to do more reading and research and found that there is a series of requisites by production to file a permit <a href=\"https:\/\/www.nyc.gov\/site\/mome\/permits\/when-permit-required.page\">here<\/a>. It happens that, there is a protocol to follow to plan a film which considers the category of production, borough, location, time, etc.&nbsp;<\/p>\n\n\n\n<p><strong>Open questions that I intend to address with this lab:<\/strong><\/p>\n\n\n\n<p>1. Where in the city these permits are issued the most?<\/p>\n\n\n\n<p>2. What are the implications of the insurance and liability of a permit?<\/p>\n\n\n\n<p>3. Which zip code are these permits issued the most?<\/p>\n\n\n\n<p><strong>Methodology<\/strong><\/p>\n\n\n\n<p>When downloading the data, I noticed it was composed of 3,420 rows and 14 columns. The data types were classified as a number, plain text, or date &amp; time.&nbsp;The data dictionary included the following description:<\/p>\n\n\n\n<figure class=\"wp-block-table is-style-regular\"><table><tbody><tr><td>Event ID<\/td><td>Auto-generated unique event identification number<\/td><\/tr><tr><td>Event Type<\/td><td>Type of Activity for this approved permit. Load in\/out&nbsp;<\/td><\/tr><tr><td>Start Date Time<\/td><td>Activity scheduled to begin<\/td><\/tr><tr><td>End Date Time<\/td><td>Activity scheduled to be completed<\/td><\/tr><tr><td>Entered On<\/td><td>Date permit request submitted to MOME<\/td><\/tr><tr><td>Event Agency<\/td><td>N\/A<\/td><\/tr><tr><td>Parking Help<\/td><td>Locations request to hold parking in advance for permitted filming activity.<\/td><\/tr><tr><td>Borough<\/td><td>First borough of activity for the day<\/td><\/tr><tr><td>Community Boards<\/td><td>First Community Board of activity for the day<\/td><\/tr><tr><td>Police Precincts<\/td><td>First Police precinct of activity for the day<\/td><\/tr><tr><td>Category<\/td><td>Description of production as selected by the permit applicant<\/td><\/tr><tr><td>SubCategory<\/td><td>A more specific description of production as selected by the permit applicant<\/td><\/tr><tr><td>Country<\/td><td>Project Origin<\/td><\/tr><tr><td>Zip Codes<\/td><td>First zip code of production activity<\/td><\/tr><\/tbody><\/table><figcaption class=\"wp-element-caption\">Data dictionary<\/figcaption><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<p><strong>Visualization<\/strong><\/p>\n\n\n\n<p>Based on the data provided by the data set, I proceeded to summarize in R Studio the data set by boroughs which gave a summary of total permits based between Manhattan, Brooklyn, Bronx, Queens, and Staten Island to be able to merge with Modified Zip Code Tabulation Areas (MODZCTA) Map provided by NYC Open Data <a href=\"https:\/\/data.cityofnewyork.us\/Health\/Modified-Zip-Code-Tabulation-Areas-MODZCTA-Map\/5fzm-kpwv\">here<\/a>.<\/p>\n\n\n\n<p>After summarizing them and importing to as a layer in QGIS visualize them based on a heatmap and have Manhattan as the highest with 1621 permits followed by Brooklyn with 1058 permits. This visualization helped me to address open questions #1 and #2.<\/p>\n\n\n\n<figure class=\"wp-block-table aligncenter\"><table><tbody><tr><td>Borough name<\/td><td>Number<\/td><\/tr><tr><td>Bronx (Blue)<\/td><td>131<\/td><\/tr><tr><td>Brooklyn (Light Green)<\/td><td>1058<\/td><\/tr><tr><td>Manhattan (Yellow)<\/td><td>1621<\/td><\/tr><tr><td>Queens (Teal)<\/td><td>493<\/td><\/tr><tr><td>Staten Island (Purple)<\/td><td>13<\/td><\/tr><\/tbody><\/table><figcaption class=\"wp-element-caption\">Legend<\/figcaption><\/figure>\n\n\n<div class=\"wp-block-image is-style-default\">\n<figure class=\"aligncenter size-large is-resized\"><img data-recalc-dims=\"1\" decoding=\"async\" src=\"https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2023\/11\/By_borough-edited-1.png?w=798&#038;ssl=1\" alt=\"\" class=\"wp-image-37565\"  srcset=\"https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2023\/11\/By_borough-edited-1.png?w=1635&amp;ssl=1 1635w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2023\/11\/By_borough-edited-1.png?resize=300%2C200&amp;ssl=1 300w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2023\/11\/By_borough-edited-1.png?resize=1024%2C684&amp;ssl=1 1024w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2023\/11\/By_borough-edited-1.png?resize=768%2C513&amp;ssl=1 768w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2023\/11\/By_borough-edited-1.png?resize=1536%2C1026&amp;ssl=1 1536w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2023\/11\/By_borough-edited-1.png?resize=800%2C534&amp;ssl=1 800w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2023\/11\/By_borough-edited-1.png?resize=270%2C180&amp;ssl=1 270w\" sizes=\"(max-width: 840px) 100vw, 840px\" \/><figcaption class=\"wp-element-caption\">Visualization #1 &#8211; Permits per borough <\/figcaption><\/figure>\n<\/div>\n\n\n<p>Visualization #2:<\/p>\n\n\n\n<p>Now that the previous data has indicated that the boroughs that have the most permits are Manhattan and Brooklyn, I proceed to summarize through R studio by zip code from Open Data <a href=\"https:\/\/data.cityofnewyork.us\/City-Government\/Film-Permits\/tg4x-b46p\" data-type=\"URL\" data-id=\"https:\/\/data.cityofnewyork.us\/City-Government\/Film-Permits\/tg4x-b46p\">here<\/a> to see where exactly in these boroughs have the most permits issued, also grouped by 5 zip codes that had the most quantity. <\/p>\n\n\n\n<figure class=\"wp-block-table aligncenter\"><table><tbody><tr><td>Zip Code<\/td><td>Permit Count<\/td><\/tr><tr><td>10001<\/td><td>64<\/td><\/tr><tr><td>11385<\/td><td>54<\/td><\/tr><tr><td>11222<\/td><td>483<\/td><\/tr><tr><td>11101<\/td><td>243<\/td><\/tr><tr><td>10023<\/td><td>131<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-medium_large\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"768\" height=\"584\" src=\"https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2023\/11\/Screen-Shot-2023-11-27-at-6.52.21-PM-768x584.png?resize=768%2C584&#038;ssl=1\" alt=\"\" class=\"wp-image-37582\" srcset=\"https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2023\/11\/Screen-Shot-2023-11-27-at-6.52.21-PM.png?resize=768%2C584&amp;ssl=1 768w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2023\/11\/Screen-Shot-2023-11-27-at-6.52.21-PM.png?resize=300%2C228&amp;ssl=1 300w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2023\/11\/Screen-Shot-2023-11-27-at-6.52.21-PM.png?resize=800%2C609&amp;ssl=1 800w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2023\/11\/Screen-Shot-2023-11-27-at-6.52.21-PM.png?resize=237%2C180&amp;ssl=1 237w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2023\/11\/Screen-Shot-2023-11-27-at-6.52.21-PM.png?w=970&amp;ssl=1 970w\" sizes=\"auto, (max-width: 768px) 100vw, 768px\" \/><figcaption class=\"wp-element-caption\">The most popular zip code:  11222 in Brooklyn with 483 permits | Google Maps resource<\/figcaption><\/figure>\n<\/div>\n\n\n<p><strong>Reflection<\/strong><\/p>\n\n\n\n<p>I had a difficult time visualizing with QGIS, it seems to be easy to do so but perhaps the complexity of merging variants such as boroughs and zip codes, didn&#8217;t help me in this instance. I would like to try in the future other geospatial visualizations such as ArcGIS.<\/p>\n\n\n\n<p><strong>References<\/strong><\/p>\n\n\n\n<p>&#8220;<em>When a Permit Is Required and Fee Info&#8221;<\/em> by MOME(n.d),<a href=\"https:\/\/www.nyc.gov\/site\/mome\/permits\/insurance.page\">https:\/\/www.nyc.gov\/site\/mome\/permits\/insurance.page<\/a><\/p>\n\n\n\n<p><em>&#8220;Film Permits&#8221;<\/em> by NYC Open Data (Nov 27th, 2023) <a href=\"https:\/\/data.cityofnewyork.us\/City-Government\/Film-Permits\/tg4x-b46p\">https:\/\/data.cityofnewyork.us\/City-Government\/Film-Permits\/tg4x-b46p<\/a><\/p>\n\n\n\n<p><em>&#8220;Modified Zip Code Tabulation Areas (MODZCTA) Map&#8221;<\/em> by NYC Open Data (May 15th, 2020) <a href=\"https:\/\/data.cityofnewyork.us\/Health\/Modified-Zip-Code-Tabulation-Areas-MODZCTA-Map\/5fzm-kpwv\">https:\/\/data.cityofnewyork.us\/Health\/Modified-Zip-Code-Tabulation-Areas-MODZCTA-Map\/5fzm-kpwv<\/a><\/p>\n\n\n\n<p><em>&#8220;The Legend Item&#8221;<\/em> by Documentation QGIS (n.d), <a href=\"https:\/\/docs.qgis.org\/2.18\/en\/docs\/user_manual\/print_composer\/composer_items\/composer_legend.html#legend-items\">https:\/\/docs.qgis.org\/2.18\/en\/docs\/user_manual\/print_composer\/composer_items\/composer_legend.html#legend-items<\/a><\/p>\n\n\n\n<p><em>&#8220;Borough Boundaries&#8221;<\/em> by NYC Open Data (n.d), <a href=\"https:\/\/data.cityofnewyork.us\/City-Government\/Borough-Boundaries\/tqmj-j8zm\" data-type=\"URL\" data-id=\"https:\/\/data.cityofnewyork.us\/City-Government\/Borough-Boundaries\/tqmj-j8zm\">https:data.cityofnewyork.us\/City-Goverment\/Borough-Boundaries\/tqmj-j8zm<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>During my time in New York City, I have seen many situations where productions are being installed for filming, acting the street in the middle of the day on a busy street. Is fascinating to see how many different movies, series, and documentaries are filmed across many different streets that I usually pass by or&hellip;<\/p>\n","protected":false},"author":4123,"featured_media":37557,"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],"tags":[],"coauthors":[1870],"class_list":["post-37556","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-labs","category-maps"],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2023\/11\/Screen-Shot-2023-11-26-at-8.41.12-PM.png?fit=1020%2C938&ssl=1","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/paBdcV-9LK","_links":{"self":[{"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/posts\/37556","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\/4123"}],"replies":[{"embeddable":true,"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/comments?post=37556"}],"version-history":[{"count":20,"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/posts\/37556\/revisions"}],"predecessor-version":[{"id":37632,"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/posts\/37556\/revisions\/37632"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/media\/37557"}],"wp:attachment":[{"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/media?parent=37556"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/categories?post=37556"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/tags?post=37556"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/coauthors?post=37556"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}