Open Data Week Events (2017–Present)

Data Science at UConn with NYC Open Data

This event is a showcase of student projects from the Introduction to Data Science course at UConn in Spring 2023. Students are assigned to work on problems from NYC 311, Department of Buildings inspections and NYPD motor vehicle crashes datasets. Selected groups will present their works including data preparation, data visualization, and data analyses at this workshop. The class-notes co-developed by the professor and the students are publicly available at https://statds.github.io/ids-s23/.

Jun Yan, UConn Statistical Data Science Lab

2023

Motor Vehicle Collisions - Crashes [https://data.cityofnewyork.us/d/h9gi-nx95]

Virtual

Showcase

{"url":"https://youtu.be/YV_SC3SS8mg?si=ITdv5dR5re1ObSBm","description":"https://youtu.be/YV_SC3SS8mg?si=ITdv5dR5re1ObSBm"}

IOT Water Quality Monitoring in NYC

Join this hands-on workshop on Randall's Island to learn about Internet of Things (IoT) water quality monitoring technologies. Visit a sampling site along the Harlem River; learn how dissolved oxygen and pH are monitored; and explore how this data is processed, shared, and used. Students can explore the environmental sciences, and everyone will gain an understanding of the importance of water testing.

Duro UAS is a Bronx-based company that develops and builds environmental sensors. The Randall's Island Park Alliance (RIPA) is a non-profit organization that works with the City of New York to steward Randall’s Island Park. The Alliance sustains, maintains, develops and programs the Park to support the well being of all New Yorkers.

Brian Wilson, Duro UAS; Fernando Baez, Duro UAS; Bradley Kaufman, Duro UAS; Christopher Girgenti, Randalls Island Park Alliance

2023

Watershed Water Quality - Hydrology [https://data.cityofnewyork.us/d/e3xf-jwmj]

In-Person

Workshop

From Deficits to Strengths: Reimagining How to Measure Child and Family Well-being

Citizens’ Committee for Children of New York (CCC) is a non-profit child advocacy organization that combines public policy research and data analysis with citizen action to ensure that every New York City child is healthy, housed, educated and safe. Each year, CCC produces its Child and Family Well-Being Index (CFWBI) for New York City, and more recently for New York State. These indices analyze where risks to child and family well-being concentrate across the New York City Community Districts and across all counties in New York State. They offer a monitoring tool to measure progress on the conditions within and inequities between communities, illustrating how community conditions are shaped by structural racism, drawing attention to where greater investments would promote health equity and well-being. 
We have grown critical of this tool because of the deficit-based focus on risk. Deficit-based approaches, including those that come from a place of benevolence, have historically framed communities of color as pathologized and broken, often obscuring the systemic influences that create harmful conditions in these communities. We seek to strengthen this analytic tool and others like it with input from organizations working in underserved communities. We invite you to think about your own experiences and how deficit-based thinking might be present or challenged in your work. We will transition to break out rooms to discuss strategies for making a shift toward strength-based narratives.

Bijan Kimiagar, Citizens’ Committee for Children; Cristina Onea, Citizens’ Committee for Children; Marija Drobnjak, Citizens’ Committee for Children; Rimsha Khan, Citizens’ Committee for Children

2023

NYPD Complaint Data Historic [https://data.cityofnewyork.us/d/qgea-i56i]

Virtual

Workshop

{"url":"https://youtu.be/QFxT4gN9UBM?si=bxYthFndY2Zcg9hH","description":"https://youtu.be/QFxT4gN9UBM?si=bxYthFndY2Zcg9hH"}

NYC Agency Maps, Tools, & Geospatial Data for 2023

New York City agencies create and publish a huge volume of geospatial data each year. We use Geographic information Systems (GIS), computer-based tools to store, visualize, and analyze this geographic data. This panel will review publicly-available tools and data sets, discuss the state of GIS technology in the city, and consider how the City uses geospatial data to serve NYC residents. Join this conversation with agency GIS leaders about new maps & tools, geospatial data, and initiatives for 2023.

Moderator:
Lee Ilan, Mayor's Office of Environmental Remediation

Panelists:
Josh Friedman, NYC Emergency Management
Matthew Croswell, Department of City Planning
P’arry Drew, Department of Transportation
Chris RIce, Mayor's Office of Climate & Environmental Justice

Lee Ilan, NYC Mayor's Office of Environmental Remediation (OER);
Josh Friedman, NYC Emergency Management (NYCEM);
Matthew Croswell, NYC Department of City Planning (DCP);
Chris Rice, NYC Mayor’s Office of Climate & Environmental Justice (MOCEJ);
P’arry Drew, NYC Department of Transportation (DOT)

2023

OER Cleanup Sites [https://data.cityofnewyork.us/d/3279-pp7v]

Virtual

Panel Discussion

{"url":"https://youtu.be/6Yh97LbENsQ?si=CSBx3RReJS2w3NDF","description":"https://youtu.be/6Yh97LbENsQ?si=CSBx3RReJS2w3NDF"}

Moving NYC Department of Sanitation - Managed Waste Through and Out of NYC

Ever wonder how the NYC Department of Sanitation (DSNY) manages the millions of tons per year that it collects from the curb? Join this session to learn about the network of contractors that DSNY uses to handle the refuse, recyclables, and organic materials that it collects from NYC residents, agencies, and institutions. DSNY will also explain why these vendors are used and how it is decided which NYC districts will use a specific vendor. The history of moving DSNY-managed waste through and out of NYC involves politics, a consideration of impacts and equity, high-tech solutions, and long-term public and private partnerships which most New Yorkers don't even realize when they deposit their discards down the chute or place them at the curb.

Marni Aaron, Adam Conanan, Sarah Dolinar & Jen McDonnell, NYC Department of Sanitation (DSNY)

2023

DSNY Districts With Disposal Vendor Assignments [https://data.cityofnewyork.us/d/fpv2-r9br]

Virtual

Office Hours

{"url":"https://youtu.be/4luqEFHuz_E?si=R2tWBokHf8y-qTw5","description":"https://youtu.be/4luqEFHuz_E?si=R2tWBokHf8y-qTw5"}

Unlocking Capital Project Mysteries with NYC Open Data

The WeGovNYC Databook (databook.wegov.nyc) is a set of software and data tools that index, normalize, republish and visualize more than 30 NYC Open Data datasets to give New Yorkers a better understanding of how our city works. During this session we'll review how the Databook's data pipeline works, how we prototype and build out our interface, tour you through the existing Capital Projects directory, and analyze new datasets that we're adding to it. We'd love to hear your thoughts, ideas, feedback and more.

The Databook's most popular interface is the Capital Project Directory, which combines four city open datasets to generate a profile page for every capital project in NYC. These pages compare a project's original planned budget and work timeline to its current one, revealing if projects are over budget or late. The city recently released more data related to the capital budget, so we're in the process of expanding the directory and upgrading its design. And we'd love your help!

Some questions that will be explored during this session:
* How can we use open data to make the City's capital budgeting process more understandable?
* How can we help you track capital projects that you care about?
* What can we do to help our city better manage our precious capital budget and execute projects more efficiently?
* What should we do, with whom should we partner, and how can we make NYC better using all of the City's fantastic open data!?

Devin Balkind, WeGovNYC, Sarapis

2023

Capital Project Detail Data - Milestones [https://data.cityofnewyork.us/d/s7yh-frbm]

Virtual

Workshop

{"url":"https://youtu.be/bwIRI0-Ej5A?si=tR4FaqMTZxUxt9L6","description":"https://youtu.be/bwIRI0-Ej5A?si=tR4FaqMTZxUxt9L6"}

Data Thinking in the Era of ChatGPT

Design thinking has transformed the way products and services are built, and influences many aspects of our lives. As artificial intelligence, analytics, and data become pervasive, data thinking is transforming how we make decisions, gather information about the world, and live our lives.
This workshop will begin with a presentation on the principles of data thinking, ranging from talking to the people affected by the data artifacts you create, visualizing early and often, using simple models before advanced AI, writing math before code, using open source, and making data-to-decision maps.

Next, we will empower the audience with tools such as ChatGPT and Google Colaboratory and in an interactive workshop explore a case study using NYC Open Data. Everyone in the audience will be able to download a dataset using prepared Jupyter notebooks, and we will walk them through a visualization.

After this simple illustration of the principles of data thinking, we will hold office hours where participants can immediately apply the skills they learned and analyze any dataset from NYC Open Data (or any other dataset of interest), and ai@columbia organizers from the Zuckerman Institute and the One Fact Foundation staff will be on hand to answer any questions and help transfer these skills.

Please email hello@onefact.org with any questions.

Tim Harris, One Fact Foundation; Jaan Altosaar, One Fact Foundation; Columbia University Zuckerman Institute; ai@columbia

2023

In-Person

Workshop

Making the Poverty Report Digital

The Mayor’s Office for Economic Opportunity is committed to the use of data and evidence in formulating poverty reduction policies. Its Poverty Research Team generates the alternative poverty measure for New York City, a keystone in innovative, rigorous data analysis. 

We cordially invite you to attend our “Making the Poverty Report Digital” session, where you get an introduction to the NYCgov poverty measure, understand its use in crafting data-informed policies, and help us co-design a digital and more accessible version of the report. This session will provide information on how to access the relevant data and a comprehensive understanding of poverty measurement in the city. To learn more, visit https://www.nyc.gov/site/opportunity/poverty-in-nyc/poverty-measure.page

Anne Hill, NYC Mayor's Office for Economic Opportunity; Bermet Kydykova, NYC Mayor's Office for Economic Opportunity

2023

NYCgov Poverty Measure Data (2018) [https://data.cityofnewyork.us/d/cts7-vksw]

Virtual

Workshop

{"url":"https://youtu.be/T2dxIrOEgx4?si=hCzEIJY48ORoav7S","description":"https://youtu.be/T2dxIrOEgx4?si=hCzEIJY48ORoav7S"}

New Yorkie: Let's Design a Dog-Friendly New York with Data

<p class="p1">In NYC, it's estimated that there are more than 600,000+ dogs. So, why is finding a dog-friendly restaurant so ruff? With your help, let's show our four-legged friends that New York City can be their fur-ever home with the power of 10 Open Data sets. Our data jam will showcase open data's potential fur real. Data has the power to improve pawlicy—and that's something that every city dog can get behind! Bring along your dog and questions! The answers and more lie right under our noses.</p>
<p class="p1">Using the datasets from squirrels to open streets, this interactive workshop/data jam will help design a more dog-friendly New York.</p>

Jason Block

2022

Mapping for Equity in the Park

Join BetaNYC's Civic Innovation fellows at Maria Hernandez Park to learn about the Mapping for Equity project they've piloted this semester! The project centers around mapping public amenities, from public bathrooms to wheelchair-accessible play equipment to benches, with a focus on creating more equitable public spaces. We are partnered with North Brooklyn Parks Alliance and Council Member Jennifer Gutiérrez District 34's office to achieve building a comprehensive public space data playbook that empowers community organizations & individuals to collect, verify, and analyze public realm data.

Attendees will shadow fellows as they map on paper where the location of each amenity is and what each amenities' features are. After the workshop, fellows will upload this information into OpenStreetMap, an open data platform for community data, but attendees will get a look into the data-gathering process while they're outside. Prepare to walk, talk, and spot features to map Maria Hernandez Park.

Jazzy Smith, BetaNYC; Dimitri Mimy, BetaNYC

2023

In-Person

Workshop

Department of Records and Information Services (DORIS)- Managing records for NYC Government

What is NYC archiving and how do you access that information? What gets stored in the Municipal Archives huge warehouse and in the cloud? How does the Municipal Library preserve agency reports and publications? Join us to learn the many types of historical records the agency makes available to the public.  

- Learn how you can search more than 10 million digitized historical vital records, such as birth, death and marriage certificates dating from 1855 through 1949.  
- Explore our massive digital collection of images, including the 1940s and 1980s tax collection photographs, historic maps of New York City’s shoreline, and the records of poverty contained in the Almshouse Ledgers.  
- Search the Archives’ collection guides and dig into the Government Publications Portal, the searchable online repository for New York City government’s publications.  

Looking for more current records? We’ll show you how to use the OpenRecords portal to request records from agencies under the Freedom of Information Law and how the OpenData portal can help you track down much of this information in data format!

Ridhdhi Patel, NYC Department of Records and Information Services (DORIS); Julia Robbins, NYC Department of Records and Information Services (DORIS); Sylvia Kollar, NYC Department of Records and Information Services (DORIS)

2023

New York City Historical Vital Records - Digitized Certificates [https://data.cityofnewyork.us/d/xdc2-zgy3]

Virtual

Office Hours

{"url":"https://youtu.be/idWtVbSvWo4?si=6doxnXi23qxYq-nP","description":"https://youtu.be/idWtVbSvWo4?si=6doxnXi23qxYq-nP"}

The Role of Open Data in Advancing Environmental Justice

Interested in environmental justice, and how government and advocates use open data to advance this cause? Join the Mayor’s Office of Climate & Environmental Justice for a conversation and open Q&A with expert panelists, and a preview of an upcoming environmental justice mapping tool.

The panel will focus on the impact of data accessibility and open data tools on environmental justice (EJ) work. Panelists are Manny Salgado, EJ Research Analyst for West Harlem Environmental Action Inc (WEACT) specializing in geosciences; Tai Lung, Environmental Protection Specialist for the Environmental Protection Agency (EPA), who led all internal aspects of EJSCREEN, the EPA’s EJ mapping and screening tool; and Dave LaShell, NYC Manager for Esri, the world's leading supplier of GIS software, web GIS and geodatabase management applications.

Carlos Piedad, New York City Mayor's Office of Climate & Environmental Justice (MOCEJ);
Manual Salgado, WE ACT for Environmental Justice;
Tai Lung, United States Environmental Protection Agency (EPA);
Dave LaShell, ESRI

2023

Virtual

Panel Discussion

{"url":"https://youtu.be/e00mDpnPpuw?si=z3zRo7WGSP_P5YHV","description":"https://youtu.be/e00mDpnPpuw?si=z3zRo7WGSP_P5YHV"}

Using Open Data to Enable Civic Trust in New York City

Please register for this event at: https://www.eventbrite.com/e/open-data-civic-trust-tickets-568851609477

Civic trust is vital for people to engage with the institutions and community around them. Yet, there is no consensus on how to establish it or how to measure it. Can open data be used to both establish and understand civic trust?
In collaboration with the NYC Civic Engagement Commission, The GovLab and the Center for Urban Science + Progress are hosting a workshop during NYC Open Data Week that begins a conversation on these issues.
The event will begin with a short panel discussion on the current landscape of open data and local civic trust with officials representing the New York City government, civil society groups, and data practitioners. Speakers will include:
- Stefaan Verhulst, The GovLab
- Randy Plemel, Expedition Works
- Alli Finn and Maia Woluchem, Surveillance Resistance Labs
- Oscar Romero, NYC Civic Engagement Commission
- Betsy MacLean, NYC Chief Engagement Officer

After this panel discussion on the current landscape of open data and local civic trust with officials representing the New York City government, civil society groups, and data practitioners, attendees will breakout into mini “civic assemblies” where they will have a chance to discuss and come up with ways that data might be used to inform or enable this work in line with a general Civic Trust Data Standard.

Key questions undergird the interactive session:
How do you measure civic trust? What data sets, tools and methodologies are required? What types of policy considerations and recommendations are needed in order to achieve the connections between open data and civic trust?

Light bites will be served at an after-hours mixer at Circa Brewery Drink tickets will be provided on a first-come-first-serve basis.

Stefaan Verhulst, The GovLab; Randy Plemel, Expedition Works; Alli Finn, NYC Civic Engagement Commission; Maia Woluchem, Surveillance Resistance Labs; Oscar Romero, NYC Civic Engagement Commission; Betsy MacLean, NYC Office of Engagement

2023

In-Person

Workshop

How can open data on school buses improve the health of NYC students?

More than 20 million children ride the bus to school, and most of those buses run on diesel. Diesel exhaust is a carcinogen with links to asthma, cognitive development impacts and other health issues. Children from low-income communities and communities of color are disproportionately subjected to this harmful air pollution. For these reasons, the World Resources Institute's Electric School Bus Initiative set out to help electrify all U.S. school buses.

We soon discovered a major data gap: there was no publicly available, nation-wide dataset of school districts' bus fleets. This data is needed to determine which school districts have the oldest, most polluting buses, enabling clean school bus funding programs to target districts with the greatest need. It can also help communities and advocates target their campaigns to create the most impact, and help utilities plan the grid upgrades needed to electrify transportation.

To fill this data gap, we spent nine months submitting public records requests (FOIAs) to government agencies in every state, and compiled a first-of-its-kind dataset containing almost 480,000 buses owned by over 12,000 school districts and other entities in 46 states and the District of Columbia. The dataset includes approximately 30 variables that describing the buses and their owners, such as the model year and fuel type. (https://datasets.wri.org/dataset/school_bus_fleets)

This presentation will offer lessons learned our experience navigating the states' public records request process: How can government agencies make this data more useful and accessible? How can people more effectively seek out similar datasets from government agencies? It will also include a case study of findings on NYC's school bus fleet. How does it stack up against other New York state school districts and other major cities? What are the environmental and health benefits and harms of the current NYC school bus fleet, and what could be improved? Participants will be invited to brainstorm uses and research questions that this dataset could address.

Leah Lazer, Electric School Bus Initiative - World Resources Institute

2023

Dataset of U.S. School Bus Fleets ( https://datasets.wri.org/dataset/school_bus_fleets), Dataset of Electric School Bus Adoption in the United States (https://datasets.wri.org/dataset/electric_school_bus_adoption)

Virtual

Presentation

{"url":"https://youtu.be/fpcikSkR7po?si=vKtEX3wCko1MaF_z","description":"https://youtu.be/fpcikSkR7po?si=vKtEX3wCko1MaF_z"}

Where Does the City's Money Go? NYC Housing Authority (NYCHA) Spending and Contracts in Checkbook NYC

Checkbook NYC, is an online transparency tool that makes the City’s day-to-day spending available to the public.

Take a tour of the new NYC Housing Authority (NYCHA) integration into Checkbook. We will take a look at NYCHA financial spending data, contract information, and vendors. We will explain the accounting hierarchy and how to track spending transactions to Responsibility Centers. The addition of this information will enable the general public, good government groups and government officials and to review how and where budgeted dollars are spent within NYCHA.

Nicole Boone, Edward Sokolowski, Office of the New York City Comptroller

2023

Checkbook NYC (https://www.checkbooknyc.com)

Virtual

Presentation

{"url":"https://youtu.be/rLhkgxXxO3M?si=p9LKJgj74OCcPtn_","description":"https://youtu.be/rLhkgxXxO3M?si=p9LKJgj74OCcPtn_"}

How does your neighborhood think about Real Estate Developments? - A fuller spectrum of community voices via Machine Learning

The event showcases a data-driven approach using machine learning to analyze and present data on neighborhood sentiments towards real estate development projects across New York City. 
 
For government agencies, the real estate profession, and community stakeholders involved in new developments, getting reliable information on neighborhood sentiments toward new projects costs immense human and monetary resources and presents major political and financial risks. We propose a data analytics framework to detect pre-existing community sentiments toward different aspects of new developments by processing data from a variety of City records, 311 complaints, demographic and neighborhood characteristics, and online information (news, op-ed columns, discussions, social media). Most of the public data are available from NYC Open Data platform, and we have to explore other available data that will help enhance our research and better understand the biases of different sets of data. The research will explore the sentiments towards a variety of core issues associated with new development by New York City neighborhoods.
 
By mitigating risks associated with the failure for public and private sectors to fully grasp and work with community voices, this project increases the efficiency for community engagement during the early stage of the real estate development process and contributes to a built environment that is better aligned with neighborhood sentiments.
 
Format:
The event will be a combination of a 30min presentation and a 30-45min discussion. We will share the explorations, analyses, and findings regarding the research, and we would want to open up the discussions to the audience and collect their questions, ideas, and thoughts.
 
The goals of the event: 
Through this engagement, community members will learn more about their neighborhood’s collective sentiments toward new development. Public and private sectors in real estate developers will learn about how to better detect such concerns and improve the plan and process for developments.
 
As for the project team, we look forward to receiving feedback on 1) what other areas of concern that communities and developers need to incorporate before and during the project planning and development process, 2) what other ways there are in which we can collect and analyze non-quantifiable data, and 3) the audience’s thoughts on whether this approach will produce trustworthy results.
 
Expect to see:
We would love to have neighbors, community members, Real Estate developers, city employees, anyone who is interested in new developments and machine learning join our event.

Individuals: Betty Difei Chen, Bowen Deng, Yuxiang Luo | Organizations: Sidewalk Labs, Snap Inc., James Lima Planning + Development

2021

{"url":"https://www.youtube.com/watch?v=RVEHrnl10Ys","description":"https://www.youtube.com/watch?v=RVEHrnl10Ys"}

Capturing volunteers' impact in communities

NYC Emergency Management (NYCEM) is excited to share some best practices and the impact data has on Community Emergency Response Team (CERT), a city-wide volunteer program. The NYC CERT program is celebrating 20 years and there are so many lessons learned.
In this presentation learn how NYCEM leverages data to report out critical operations and promote the impact of CERT volunteers as they support emergency preparedness and response efforts throughout all five boroughs.

Anthony Escoto, CERT Training and Exercises Program Manager, NYCEM
Shelly Bradshaw, Geospatial Data Program Manager, NYCEM

Anthony Escoto, New York City Emergency Management (NYCEM); Shelly Bradshaw, New York City Emergency Management (NYCEM)

2023

Community Emergency Response Team (CERT) [https://data.cityofnewyork.us/d/b2gb-nkrq], Partners in Preparedness [https://data.cityofnewyork.us/d/h4jn-x3ty], Hurricane Evacuation Centers [https://data.cityofnewyork.us/d/p5md-weyf]

Virtual

Presentation

{"url":"https://youtu.be/E34YjoGm8vw?si=WRr6O-6n6SpO44xI","description":"https://youtu.be/E34YjoGm8vw?si=WRr6O-6n6SpO44xI"}

NYC Health Data Tour from the NYC Health Department

Learn how to access and navigate epidemiological, environmental, and COVID-specific data offered by the NYC Health Department from staff who work on these shared data resources! Use these resources alone or in combination to inform policy to promote health equity across NYC. Resources covered include:
- EpiQuery, https://a816-health.nyc.gov/hdi/epiquery/
- Community Health Profiles, https://a816-health.nyc.gov/hdi/profiles/
- Environment and Health Data Portal, https://a816-dohbesp.nyc.gov/indicatorpublic/beta/
- COVID-19 Data pages, https://www.nyc.gov/site/doh/covid/covid-19-data.page
- NYC Open Data resources from DOHMH, https://data.cityofnewyork.us/browse?Dataset-Information_Agency=Department+of+Health+and+Mental+Hygiene+%28DOHMH%29

Charles Ko, Hilary Parton, Kemi Eguaze, Martha Alexander, & Matthew Montesano, NYC Department of Health and Mental Hygiene (DOHMH)

2023

Mosquito control events in NYC – Adult Mosquito Truck Spraying and Aerial Larviciding Events [https://data.cityofnewyork.us/d/msid-end4], DOHMH COVID-19 Antibody-by-Borough [https://data.cityofnewyork.us/d/x98t-3bbk], New York City Work and Family Leave Survey (WFLS) 2014 [https://data.cityofnewyork.us/d/grnn-mvqe], Children Under 6 yrs with Elevated Blood Lead Levels (BLL) [https://data.cityofnewyork.us/d/tnry-kwh5], DOHMH Indoor Environmental Complaints [https://data.cityofnewyork.us/d/9jgj-bmct], Beach Water Samples [https://data.cityofnewyork.us/d/2xir-kwzz], Collisions involving vehicles managed by Department of Health and Mental Hygiene (DOHMH) [https://data.cityofnewyork.us/d/knr6-vurn], Blood pressure checks on NYC HealthMap [https://data.cityofnewyork.us/d/8eux-rfe8], NYC Pool Inspections [https://data.cityofnewyork.us/d/3kfa-rvez], Permitted Nonpotable Wells [https://data.cityofnewyork.us/d/gnyq-kf2y], DOHMH Cryptosporidiosis by Race/Ethnicity, Age Group, and Borough of Residence [https://data.cityofnewyork.us/d/fkec-mjr6], DOHMH Severe Maternal Morbidity [https://data.cityofnewyork.us/d/g5gn-bmye], DOHMH COVID-19 Antibody-by-Neighborhood Poverty [https://data.cityofnewyork.us/d/vajk-p37e], Infant Mortality [https://data.cityofnewyork.us/d/fcau-jc6k], Pregnancy Risk Assessment Monitoring System (PRAMS) [https://data.cityofnewyork.us/d/rqgf-94xs], Self-Reported Drinking Water Tank Inspection Results [https://data.cityofnewyork.us/d/gjm4-k24g], DOHMH COVID-19 Antibody-by-Week [https://data.cityofnewyork.us/d/cqhz-kkvd], HIV/AIDS Diagnoses by Neighborhood, Age Group, and Race/Ethnicity (Historical) [https://data.cityofnewyork.us/d/dxnu-p2qd], New York City Community Health Survey [https://data.cityofnewyork.us/d/csut-3wpr], DOHMH New York City Restaurant Inspection Results [https://data.cityofnewyork.us/d/43nn-pn8j], NYC Dog Licensing Dataset [https://data.cityofnewyork.us/d/nu7n-tubp], Modified Zip Code Tabulation Areas (MODZCTA) Map [https://data.cityofnewyork.us/d/5fzm-kpwv], DOHMH MenuStat (Historical) [https://data.cityofnewyork.us/d/qgc5-ecnb], Hepatitis B & C Surveillance Registry [https://data.cityofnewyork.us/d/5tgd-xk3z], Pregnancy-Associated Mortality [https://data.cityofnewyork.us/d/27x4-cbi6], NYC Cooling Tower Registrations [https://data.cityofnewyork.us/d/y4fw-iqfr], Percent Live Births by Infant Sex and Mother’s Race/Ethnicity [https://data.cityofnewyork.us/d/wffy-3iyg], Hyperlocal Temperature Monitoring [https://data.cityofnewyork.us/d/qdq3-9eqn], Children Tested for Lead by Age 3 [https://data.cityofnewyork.us/d/fzh2-sxib], DOHMH Covid-19 Milestone Data: New Cases of Covid-19 (7 Day Average) [https://data.cityofnewyork.us/d/xwtc-hedq], DOHMH COVID-19 Antibody-by-Modified ZIP Code Tabulation Area [https://data.cityofnewyork.us/d/6qs8-44ki], DOHMH Covid-19 Milestone Data: Daily Number of People Admitted to NYC hospitals for Covid-19 like Illness [https://data.cityofnewyork.us/d/sj3k-gzyx], Youth Risk Behavior Survey (Middle School) [https://data.cityofnewyork.us/d/uqmk-4y2w], NYC Cooling Tower System Inspection Results [https://data.cityofnewyork.us/d/f9wb-g8mb], DOHMH Community Mental Health Survey [https://data.cityofnewyork.us/d/wi3r-8uzb], New York City Automated External Defibrillator (AED) Inventory [https://data.cityofnewyork.us/d/2er2-jqsx], DOHMH and DEP Waterborne Disease Risk Assessment Program Annual Report Data: Percentage of interviewed cryptosporidiosis case-patients reporting selected potential risk exposures before disease onset, by Immune Status [https://data.cityofnewyork.us/d/ws4r-n9v4], 2017-2021 NYC KIDS Survey [https://data.cityofnewyork.us/d/u7vp-i37z], HIV Testing Locations [https://data.cityofnewyork.us/d/72ss-25qh], SARS-CoV-2 concentrations measured in NYC Wastewater [https://data.cityofnewyork.us/d/f7dc-2q9f], DOHMH Health Map - Hepatitis [https://data.cityofnewyork.us/d/nk7g-qeep], DOHMH Childcare Center Inspections (Historical) [https://data.cityofnewyork.us/d/dsg6-ifza], Equitable Health Systems - Health Insurance Enrollment [https://data.cityofnewyork.us/d/gfej-by6h], Popular Baby Names [https://data.cityofnewyork.us/d/25th-nujf], Heat Vulnerability Index Rankings [https://data.cityofnewyork.us/d/4mhf-duep], DOHMH and DEP Waterborne Disease Risk Assessment Program Annual Report Data: Percentage of interviewed cryptosporidiosis case-patients by type of tap water exposure before disease onset, by Immune Status [https://data.cityofnewyork.us/d/at9c-pdf7], Adding Chemicals to Water Supply Permits [https://data.cityofnewyork.us/d/v8i9-yfpr], DOHMH COVID-19 Antibody-by-Sex [https://data.cityofnewyork.us/d/bhau-5xgs], COVID-19 Outcomes by Testing Cohorts: Cases, Hospitalizations, and Deaths [https://data.cityofnewyork.us/d/cwmx-mvra], DOHMH Dog Bite Data [https://data.cityofnewyork.us/d/rsgh-akpg], DOHMH School Cafeteria Inspections (2020-Present) [https://data.cityofnewyork.us/d/5ery-qagt], Rodent Inspection [https://data.cityofnewyork.us/d/p937-wjvj], Radiation Producing Equipment [https://data.cityofnewyork.us/d/i595-2byq], NYC REACH Members [https://data.cityofnewyork.us/d/7btz-mnc8], Active NYC Health Code Regulated Child Care Programs [https://data.cityofnewyork.us/d/gy3q-4tzp], Directory of Requests for Telephonic Interpretation [https://data.cityofnewyork.us/d/fydx-dgvr], DOHMH Call Center Summary [https://data.cityofnewyork.us/d/wymh-dvmd], Youth Behavior Risk Survey (High School) [https://data.cityofnewyork.us/d/3qty-g4aq], New York City Leading Causes of Death [https://data.cityofnewyork.us/d/jb7j-dtam], Recognized Shop Healthy Stores [https://data.cityofnewyork.us/d/ud4g-9x9z], New York City Health Opinion Poll [https://data.cityofnewyork.us/d/67up-ztdf], DOHMH COVID Antibody-by-Age [https://data.cityofnewyork.us/d/7umd-hdjb], DOHMH HIV Service Directory [https://data.cityofnewyork.us/d/pwts-g83w], Metal Content of Consumer Products Tested by the NYC Health Department [https://data.cityofnewyork.us/d/da9u-wz3r], DOHMH HIV/AIDS Annual Report [https://data.cityofnewyork.us/d/fju2-rdad], Modified Zip Code Tabulation Areas (MODZCTA) [https://data.cityofnewyork.us/d/pri4-ifjk], HIV/AIDS Diagnoses by Neighborhood, Sex, and Race/Ethnicity (Historical) [https://data.cityofnewyork.us/d/ykvb-493p], NYC Condom Availability Program - HIV condom distribution locations [https://data.cityofnewyork.us/d/4kpn-sezh], 2015 Child Health, Emotional Wellness, and Development Survey (CHEWDS) [https://data.cityofnewyork.us/d/uzg5-56gw], DOHMH Covid-19 Milestone Data: Percent of NYC residents tested who tested positive [https://data.cityofnewyork.us/d/7434-7ua6], DOHMH Tuberculosis Surveillance: Data from the Tuberculosis Control Annual Summary [https://data.cityofnewyork.us/d/ax85-bzte], NYC Early Interventions: Local Early Intervention Coordinating Council (LEICC) Report [https://data.cityofnewyork.us/d/brud-mdtt], NYC Automated External Defibrillator (AED) Map [https://data.cityofnewyork.us/d/2ync-kihj], NYCCAS Air Pollution Rasters [https://data.cityofnewyork.us/d/q68s-8qxv], COVID-19 Daily Counts of Cases, Hospitalizations, and Deaths [https://data.cityofnewyork.us/d/rc75-m7u3], NYC Farmers Markets [https://data.cityofnewyork.us/d/8vwk-6iz2], New York City Locations Providing Seasonal Flu Vaccinations [https://data.cityofnewyork.us/d/w9ei-idxz], Emergency Department Visits and Admissions for Influenza-like Illness and/or Pneumonia [https://data.cityofnewyork.us/d/2nwg-uqyg], Air Quality [https://data.cityofnewyork.us/d/c3uy-2p5r], DOHMH School Cafeteria Inspections (Historical) [https://data.cityofnewyork.us/d/9hxz-c2kj]

EpiQuery (https://a816-health.nyc.gov/hdi/epiquery/), Community Health Profiles (https://a816-health.nyc.gov/hdi/profiles/), Environment and Health Data Portal (https://a816-dohbesp.nyc.gov/indicatorpublic/beta/), COVID-19 Data pages (https://www.nyc.gov/site/doh/covid/covid-19-data.page)

Virtual

Office Hours

{"url":"https://youtu.be/TeSEq3Jjk8s?si=MZzn_tpf82XRS9Gq","description":"https://youtu.be/TeSEq3Jjk8s?si=MZzn_tpf82XRS9Gq"}

MTA Open Data Office Hours

Meet the team behind Metropolitan Transportation Authority's (MTA) blossoming open data program and learn about their plans to make more MTA's data more accessible to interested users like you. This virtual office hours event will be led by MTA staff Jon Kaufman (Chief, Strategic Initiatives), Andy Kuziemko (Head, Data & Analytics) and Lisa Mae Fiedler (Open Data Lead). Come with questions and suggestions, or simply to listen!

The MTA is a public benefit corporation responsible for public transportation in the state of New York, carrying over five million passenger journeys and more than 800,000 vehicles on its seven toll bridges and two tunnels on the average weekday.

Jon Kaufman, Andy Kuziemko & Lisa Mae Fiedler, Metropolitan Transportation Authority (MTA),

2023

MTA Datasets (https://data.ny.gov/browse?Dataset-Information_Agency=Metropolitan+Transportation+Authority)

Virtual

Office Hours

{"url":"https://youtu.be/5c5CJ87fDL0?si=D5ZEgvuRqxrbLGSd","description":"https://youtu.be/5c5CJ87fDL0?si=D5ZEgvuRqxrbLGSd"}

Bridging the Gap Between Academia + Government via Open Data

This session presents successes and challenges of academic research collaborations with government, from innovative data science to building products. A set of presenters from government and academia will discuss: How do we move from academic research to having tangible impact and building sustainable things with the government? How does Open Data facilitate collaborations between academia and government?

We'll have a panel of leaders and practitioners across government/academia, as well as a couple of presentations.

REGISTER FOR THIS EVENT ON EVENTBRITE: https://www.eventbrite.com/e/academiagovernment-open-data-bridging-the-gap-between-universities-gov-tickets-560771401357

Nikhil Garg, Cornell Tech: The Jacobs Urban Tech Hub and Public Interest Tech; Nneka Sobers, Cornell Tech: The Jacobs Urban Tech Hub and Public Interest Tech

2023

Hybrid

Panel Discussion

Transit Access to Essential Services in the face of Climate Change

In this hybrid in-person and virtual presentation, the <a href="https://www.twosigma.com/data-clinic/" target="_blank">Data Clinic</a> team will demonstrate their latest open source tool, TREC: Transit Resiliency for Essential Commuting. TREC was built to help planners and advocates prioritize improvements to transportation stations that provide critical access to vital services such as hospitals and essential job centers, and that are at elevated risk of experiencing a climate-related disaster such as flooding. Developed as part of <a href="https://opportunity.census.gov/sprints/" target="_blank">The Opportunity Project</a>’s Fall 2022 sprint led by the Census and the Federal Transit Administration, this tool helps users understand the intersectional impact between climate-related risks, transit, and communities; and demonstrates the power open data has to inform planning and advocacy action. Data Clinic will share their process, from finding relevant open datasets, describing the data's advantages and disadvantages, and meeting with user advocates, to how they made crucial decisions and assumptions in the development process to produce a cohesive set of insights. Data Clinic will end the session with an opportunity to ask questions and share how attendees can contribute to the tool. Following the presentation, there will be an opportunity to mingle with the Data Clinic team and fellow attendees.

Canyon Foot, Erin Stein, Indraneel Purohit & Kaushik Mohan, Two Sigma Data Clinic

2023

New York City Transit Stops (https://www.mta.info/developers), New York City Stormwater Flood Map (https://experience.arcgis.com/experience/6f4cc60710dc433585790cd2b4b5dd0e)

Hybrid

Presentation

Identifying Areas of Underinvestment in Black Businesses Using Open Data

Using several open data sources, DataKind and the Black Wealth Data Center have started building a tool to facilitate the targeting of business capital investment into Black-owned businesses in underinvested localities. The racial wealth gap and the gap in assets accrued by households between races is representative of, and interrelated with, many inequalities experienced between races: income, wealth, education opportunities, and housing. Successful business ownership is considered to be a key way to close the racial wealth gap. Expanding business capital investment opportunities including making fair loan application processes and providing other financial access, will increase the number and size of Black-owned businesses.

The tool combines open source indicators, identified through data science, to rank communities by need for investment, and it will be open for all to use. This means that groups including Community Development Financial Institutions (“CDFIs”) and Minority Depository Institutions (“MDIs”), government entities, and researchers will be able to not only use a data-driven tool but also cite the tool in grants and applications to show they are making data-driven decisions to target efforts. CDFIs serve the communities they work within, and have been a key component of increasing investment in Black businesses, but often as nonprofits themselves, they lack the time to focus on sophisticated targeting, advertising, and evaluation. This tool will allow them to use a sophisticated approach quickly and easily.

This event will be a presentation of the open data and indicators we have explored and determined are most useful in predicting underinvestment in the Black community. The tool can operate at several geographic levels including census tract, county, state, and nation; we will delve into the output for the NYC area during the event and show how NYC tracts compare to others across the state and nation. Attendees will have the opportunity to use the Tableau tool and share feedback.

Kayla Wilding, Data Scientist, DataKind; Harsha Mallajosyula, Director of Data, Black Wealth Data Center

2023

United States Census: sociodemographic and socioeconomic datasets (https://data.census.gov/table), United States Census: business formation applications and formations (https://www.census.gov/econ/bfs/index.html), HUD Opportunity Zone data (https://opportunityzones.hud.gov/), FDIC CDFI and MDI data (https://www.fdic.gov/minority-depository-institutions-program/minority-depository-institutions-list)

Virtual

Presentation

{"url":"https://youtu.be/RnmYu-cz1SI?si=_279wHO_N4TN69m0","description":"https://youtu.be/RnmYu-cz1SI?si=_279wHO_N4TN69m0"}

Mapping Rooftop Topography

This event will be a demonstration of how to generate topographic maps of New York City's building rooftops by combining multiple large NYC Open Data datasets. We will present a detailed walkthrough of how to use the scientific/geospatial Python stack to produce customized maps. We will also discuss what tools to use to work with data that won't fit in memory, and demonstrate how to combine vector and raster geospatial data. The end result will be topographic images of the heights of building rooftops above sea level, an interesting new way of visualizing New York's iconic geography.

Patrick Maher

2022

{"url":"https://www.youtube.com/watch?v=qKl3BbKdsRQ","description":"https://www.youtube.com/watch?v=qKl3BbKdsRQ"}

An Exploration of NYPD Open Data for Place-Based Research Studies

Over the span of various projects, John Jay College's Research and Evaluation Center(REC) has developed a rigorous data inspection and cleaning process to create research-ready data sets for community-level analysis. These projects have involved understanding the effects of interventions focused on specific communities in New York City. Join this session to learn how this team has explored NYPD data and the process it has developed to make publicly available crime-related data useable for research studies - including how it handles likely errors and overcomes dataset limitations.

Fidel Osorio, John Jay College Research and Evaluation Center; Sheyla Delgado, John Jay College Research and Evaluation Center; Richard Espinobarros, John Jay College Research and Evaluation Center; Gina Moreno, John Jay College Research and Evaluation Center

2023

NYPD Criminal Court Summons (Historic) [https://data.cityofnewyork.us/d/sv2w-rv3k], NYPD Criminal Court Summons Incident Level Data (Year To Date) [https://data.cityofnewyork.us/d/mv4k-y93f]

Virtual

Presentation

{"url":"https://youtu.be/MveW9PDAZ04?si=g_sZwVxA_muHuMB-","description":"https://youtu.be/MveW9PDAZ04?si=g_sZwVxA_muHuMB-"}

Visualizing School Meal Participation in New York City

School meals are an important source of nutrition for the approximately 1.1 million students who attend New York City's public schools, especially for those students who come from very low-income households. Since the 2017-2018 academic year, New York City has adopted universal free school lunch throughout the city's more than 1,000 public elementary, middle and high schools. Despite the provision of free lunch (and free breakfast which has been available since the 2003-2004 academic year), the rate of childhood food insecurity in New York City tends to be higher than the overall NYC population, and school meal participation rates vary significantly from school to school, even within the same district and in areas of high potential need. 

In this session, participants will hear from researchers at CUNY Urban Food Policy Institute and invited guests, including a community/parent advocate, a student, and other experts, on how data from NYC Open Data were used to develop a dashboard prototype to visualize school meal participation rates in NYC's public schools. The prototype was developed as part of a larger project to visualize aspects of food insecurity, in collaboration with a wide range of academic, government, and non-profit experts. Participants who attend this session will also hear from a range of individuals with varying perspectives on factors influencing participation and discuss how we can utilize this information to better support initiatives to increase school meal participation.

CUNY Urban Food Policy Institute, Nevin Cohen, Rositsa Ilieva, & Yvette Ng

2023

2019 School Food Report LL215 [https://data.cityofnewyork.us/d/biv6-d9zt]

Virtual

Panel Discussion

{"url":"https://youtu.be/p4mCr6Ss2qs?si=bxi4VqeLkQe792ZB","description":"https://youtu.be/p4mCr6Ss2qs?si=bxi4VqeLkQe792ZB"}

The potential of data use cases - The Use Case Observatory and NYC use cases

The potential of open data relies on our ability to use it to create a positive impact in our society. In this session, we will explore how different groups outside of government make use of open data in both the European Union and New York City

The session will feature a presentation of the research project and first volume of the European Union's Use Case Observatory. This project features examples of how open data has been used by organizations across Europe - including uses to advance health and wellness, social services, environment and planning, and government operation.

Two NYC-based groups will also share how they use open data: the Citizen’s Committee for Children, an organization that works with social services data in order to advance well-being, equity and justice for all New York’s children, and JustFix, a non-profit that builds free tools for tenants to exercise their rights to a livable home using housing data.

Following these presentations, the speakers will engage in a panel discussion on the key aspects of working with open data from both a NYC and EU perspective. The panel will touch upon the role of public entities and private organizations in opening up data as well as the importance of data quality requirements. The session will conclude with a Q&A session open to the audience.

Giuseppe Ascone Modica, European Commission - Publications Office of the European;
Maxwell Austensen, JustFix;
Bijan Kimiagar, Citizens’ Committee for Children of New York;
Miwon Seo & Willy Duville, Medicatio;
Clara Bracklo, Integreat

2023

Virtual

Panel Discussion

{"url":"https://youtu.be/hlYSpeQRrMY?si=dEIhW6Dfc6Jk5yPp","description":"https://youtu.be/hlYSpeQRrMY?si=dEIhW6Dfc6Jk5yPp"}

Women Remembered - Celebrating Women’s History Month through Open Data

Only five out of New York City’s 150 monuments of historic figures honor women. But New York City is not alone - fewer than 8% of historic monuments across the country represent women. From monuments to street names to how we dedicate our public libraries, the underrepresentation of prominent women contributes to a gap in our cultural understanding of what women have been able to accomplish. Mapping the locations of these monuments and dedications though, has the power of helping us close both the gaps in the physical representation as well as our documentation of their lives. In celebration of International Women’s Day and Women’s History Month, we will talk about how OpenStreetMap data can help us understand gaps in diverse historic representation in New York City, of women and other historically excluded groups. At the end of this session, attendees will have had a hands-on experience contributing to OpenStreetMap for better representation on the map.

Maggie Cawley, OpenStreetMap US; Jess Beutler, OpenStreetMap US

2023

Virtual

Workshop

{"url":"https://youtu.be/f6so-k59q7Q?si=1dWa9PR3ImP57ZE0","description":"https://youtu.be/f6so-k59q7Q?si=1dWa9PR3ImP57ZE0"}

Learning Python and Data Science with Adelphi's NYC Schools Open Data Portal

Data can be a crucial tool for understanding and managing our schools, and its analysis and interpretation have powerful consequences. The mission of Adelphi University's NYC Schools Open Data Portal is to make open public school data in New York available to everyone interested in improving our schools, regardless of their technical background or familiarity with data analysis. To broaden the reach of this open data, we have two goals: help more people acquire the technical skills to effectively work with the data while also lowering the technical requirements to use the data.

In this hands-on session we will discuss the variety of open data available regarding schools, demonstrate the types of questions this data can help us explore, and help you get started writing your own simple (or complex) programs to analyze, visualize, and map this data.

For more information about the project, visit its Github page: https://github.com/adelphi-ed-tech/nycschools

The core project team for this project come from Adelphi University's graduate programs in Computer Science Education, Applied Math, and Educational Technology.

Matthew Curinga, Adelphi University; Taye Johnson, Adelphi University; Kavindra Sahabir, Adelphi University; Robert Wilcox, Adelphi University; Henry Choi, Adelphi University; Antonios Saravanos, Adelphi University

2023

2020-2021 Demographic Snapshot School [https://data.cityofnewyork.us/d/vmmu-wj3w]

In-Person

Class / Training

NYC Housing Preservation and Development Data Deep Dive: Affordable Housing Production

Learn about the Department of Housing Preservation & Development's (HPD) various open datasets with a dedicated deep dive into the Affordable Housing Production datasets. Join staff from HPD's Division of Strategic Operations & Analytics (SOA) to explore how you can leverage HPD’s datasets and engage with the HPD Open Data Team! 

The Department of Housing Preservation & Development (HPD) works to promote quality and affordability in the city's housing, and diversity and strength in the city’s neighborhoods. This is done by maintaining the safety and health of residential housing, creating opportunities for New Yorkers through housing affordability, and engaging New Yorkers to build and sustain neighborhood strength and diversity.

Habiba Musah & Yuki Mitsuda, NYC Department of Housing Preservation & Development (HPD)

2023

Affordable Housing Production by Building [https://data.cityofnewyork.us/d/hg8x-zxpr]

Virtual

Office Hours

{"url":"https://youtu.be/MJG26fzS1CA?si=41xAACwmMx4e4jaa","description":"https://youtu.be/MJG26fzS1CA?si=41xAACwmMx4e4jaa"}

Crowdsourcing the Future of Government Data: OpenStreetMap in the Public Domain

Is your government utilizing OpenStreetMap data in their workflows? How can crowdsourcing be leveraged to improve the completeness, freshness, and breadth of government geospatial data? As the world’s largest crowdsourced geospatial database, OpenStreetMap is poised to serve this need. Two years ago, OpenStreetMap US formed a Government Working Group to seek out mutually beneficial relationships between the public and open data communities. As part of this effort, OSM community members and representatives from federal agencies have been investigating solutions for feature collection. This collaboration has led to the development of Public Domain Map, which connects OpenStreetMap and government datasets.
Through the Public Domain Map workflow, OpenStreetMap and government open geospatial data becomes more complete, current and readily usable by government agencies and the millions of users relying on both datasets. In this session, learn about the journey of Public Domain Map, how the project is bringing together US federal agencies and open source contributors to meet this goal, and how it could be used in NYC to collect data for the community AND the government.

Maggie Cawley, OpenStreetMap US; Jess Beutler, OpenStreetMap US

2023

Virtual

Presentation

{"url":"https://youtu.be/mM3JnB8H-Wg?si=OM6s-88GO41pSep6","description":"https://youtu.be/mM3JnB8H-Wg?si=OM6s-88GO41pSep6"}

How can Open Data continue to improve? Lessons from the European Union and NYC

Have you ever wondered how NYC Open Data compares to other places around the world? In this event, you can learn about data.europa.eu's annual assessment of European open data, hear how NYC is making its public data more available and accessible, and join a discussion about Open Data best practices and how to better measure its impact.
 
Data.europa.eu, the official portal for European data, conducts an annual open-data maturity assessment to take stock of national open data practices in European countries and gain insights into the achievements and evolutions in open data in Europe. The outcomes and conclusions of the assessment are published in its yearly Open Data Maturity report. In the last report published in 2022, 35 European countries participated to track their progress on open data against the dimensions of policy, portal, quality and impact. Join Inmaculada Farfan Velasco from data.europa.eu and Zachary Feder from NYC Open Data as they explore these dimensions and how they apply to New York City.

Inma Farfan Velasco, Publications Office of the European Union

2023

Open Data Maturity Assessment 2022 (https://data.europa.eu/data/datasets/open-data-maturity-assessment-results-2022?locale=en)

Virtual

Panel Discussion

{"url":"https://youtu.be/UMIoYJPjBD8?si=8QSaA9MqKnLRlc_m","description":"https://youtu.be/UMIoYJPjBD8?si=8QSaA9MqKnLRlc_m"}

NYC311 Service Request Data: Learning about your Community

Learn why 311’s Service Request dataset among the most popular datasets for New Yorkers to learn about what is happening in their community. Elected officials, community boards, neighborhood associations, civic-minded individuals, and many more create their own filters or maps to stay informed of trends in their community.
In this session, you will learn what 311’s role is in city government, how service requests are created, routed and addressed by the responding agency and how it provides valuable information about a community.

Bill Reda, NYC 311

2023

311 Service Requests from 2020 to Present [https://data.cityofnewyork.us/d/erm2-nwe9]

Virtual

Presentation

{"url":"https://youtu.be/sTi28NDDyog?si=VLjYozz8vIU0sgsK","description":"https://youtu.be/sTi28NDDyog?si=VLjYozz8vIU0sgsK"}

Have your data silos and eat your cake too: Using Meta open source technologies to simplify and accelerate utilization of complex, large, public data sets.

Please register for this event using this link: https://forms.gle/JkaCxet5S7auhZVP7

Presto [https://prestodb.io/] is an open source SQL engine for querying and analyzing large data sets from multiple sources. In this session, you'll use NYC Open Data to learn some basics of how to connect to any data source, query, and distribute data. Presto avoids the complexity and cost of ingesting and duplicating data to enable data driven decision making. This can benefit organizations of any size, whether they are for-profit or not-for-profit, government or private, by enabling faster and more efficient utilization of data. No prior experience is necessary!

The session will be led by Philip Bell, Developer Advocate from Meta Open Source. We will also discuss why you should use open source, principles for keeping data secure and private, and how to scale community efforts around data. Philip started his career in big data and cybersecurity in the Department of Defense and teaches introductory cybersecurity courses at a community college in addition to his role at Meta.

Note that this workshop is designed to take no longer than an hour, but attendees are welcome to take extra time to continue their work.

To attend you must pre-register using this link:
https://forms.gle/JkaCxet5S7auhZVP7

Philip Bell

2023

311 Service Requests from 2020 to Present [https://data.cityofnewyork.us/d/erm2-nwe9]

Hybrid

Workshop

NYC Open Data Case Studies from Introduction to Data Science at UConn

Using NYC Open Data provides opportunities for data scientists to make real-life impacts. Students taking Introduction to Data Science (STAT3255/5255) in Spring 2022 at UConn have studied two NYC open datasets closely: Motor Vehicle Collisions and Department of Buildings (DOB) Job Application Filings. For each dataset, two groups of students will present their works, one on visualization and the other on analytics. Students will use the fresh data science skills they learned since the beginning of the Spring 2022 semester. Stories will be told based on the discoveries, and the code will be made publicly available on GitHub as part of the open-source class notes.

The presentations are oriented to the general public with no technical pre-requisites. The session demonstrates the usage of real-life open data projects in college data science education.

University of Connecticut

2022

{"url":"https://www.youtube.com/watch?v=aWcgzC554Dg","description":"https://www.youtube.com/watch?v=aWcgzC554Dg"}

Not All Streets Are Created Equal: How Transportation Advocates are Using Data to Find and Address Spatial Inequities

There are evident inequities in how public space is distributed, restricted, used, and made unusable, and how this results in clear disparities in public health, mobility and environmental justice for New Yorkers, across all New York neighborhoods. Spatial Equity NYC, a new tool developed by Transportation Alternatives and MIT, reveals these inequities through the visualization of open-access spatial data, providing policymakers and the public with critical access to knowledge in advocating for and implementing necessary change.

The Spatial Equity NYC tool visualizes this key data by mobility, environment and health categories, and indicates where spatial inequities are most prevalent. Users can compare their neighborhoods and see how community boards and council districts rank amongst each other. The tool also presents potential solutions related to spatial equity indicators, and invites users to interface directly with their elected officials in advocating for more equitable solutions. Spatial Equity NYC tells a story of public space, and how we can all work toward a more equitable city for all New Yorkers.

This demonstration will explain why such a tool was so necessary, how it came about, why relying on NYC's Open Data was so integral to not just building it, but building trust in the analysis, and how it will and already has shaped advocacy.  As part of this event, we’ll also discuss limitations in the source Open Data in both frequency and level of detail, and how changes here might further improve the Spatial Equity NYC tool. Additionally, there will be a live demo of the website showing attendees how to use the tool, all the different features, and explain what changes are expected next.

Philip Miatkowski, Transportation Alternatives

2023

Bus Lanes - Local Streets [https://data.cityofnewyork.us/d/ycrg-ses3]

Virtual

Presentation

{"url":"https://youtu.be/8d8T9QwXtJw?si=snzm29W5Ld6V58U2","description":"https://youtu.be/8d8T9QwXtJw?si=snzm29W5Ld6V58U2"}

Visualizing MTA Performance Data with Python

The Metropolitan Transportation Authority (MTA) runs the largest public transportation system in North America, spanning twelve counties and serving over 15 million people. The organization's network includes the nation's largest bus fleet, and the most subway and rail cars. 
In this session, MTA data scientists will teach attendees how to visualize MTA performance data, using Python’s pandas and streamlit packages to build interactive webpages. Our session will use the open-source Visual Studio Code (https://code.visualstudio.com) Integrated Development Environment (IDE), where we’ll go over how you can build your very own streamlit web app using python and MTA Open Data. 
This session will be led by Dan Powers, Senior Data Scientist, and Rahnuma Tarannum, a graduate student at NYU and an intern in the MTA Data & Analytics Team. 
Some previous programming experience is recommended, but not required!

Lisa Mae Fiedler, Dan Powers, & Rahnuma Tarannum, Metropolitan Transportation Authority (MTA),

2023

Subway Service Delivered (https://data.ny.gov/Transportation/MTA-Subway-Service-Delivered-Beginning-2015/32ch-sei3), Bus Speeds (https://data.ny.gov/Transportation/MTA-Bus-Speeds-Beginning-2015/cudb-vcni)

Virtual

Class / Training

{"url":"https://youtu.be/KoO0G-Yqy0o?si=X4zNwanKCZwE8aec","description":"https://youtu.be/KoO0G-Yqy0o?si=X4zNwanKCZwE8aec"}

Where Does the City's Money Go? Advanced Search Techniques for Checkbook NYC

Checkbook NYC, is an online transparency tool that makes the City’s day-to-day spending available to the public.

This will contain an overview of the Smart Search, Advanced Search, Narrow-down faceted search and data feed search mechanisms within Checkbook NYC. The objective of this session is to expand user understanding of what type of search technique is best suited for your query. We will use some sample searches and take actual user examples to understand how to refine your inquiry. We will also review how to gain insight from the contract detail pages.

Nicole Boone, Edward Sokolowski, Office of the New York City Comptroller

2023

Checkbook NYC (https://www.checkbooknyc.com)

Virtual

Presentation

{"url":"https://youtu.be/SfZwNPXMc6g?si=HpZhuPGyyxtF9t7C","description":"https://youtu.be/SfZwNPXMc6g?si=HpZhuPGyyxtF9t7C"}

The NYC Tree Map and How You Can Branch Out with Parks Open Data 🌳

Join this conversation with NYC Parks data and technology leaders to learn about the agency's Open Data and how the NYC Tree Map was built. City residents can use the interactive tree map to learn about the City's urban forest.

As part of this session, you'll hear how NYC Parks uses geospatial enterprise asset management systems and web and mobile applications to collect, update, manage, visualize, and analyze data on the City's trees and tree work operations.

Uma Bhandaram, Adam Cohen, Sara Esquibel, NYC Department of Parks & Recreation

2023

Forestry Tree Points [https://data.cityofnewyork.us/d/hn5i-inap]

Virtual

Presentation

{"url":"https://youtu.be/UNUo2jFk_04?si=FgA-iYLe2WG1fhKN","description":"https://youtu.be/UNUo2jFk_04?si=FgA-iYLe2WG1fhKN"}

Ethical Open Data: Ensuring Responsibility and Privacy in Open Data Sets

Open data is an invaluable resource for the public and researchers but making information about people publicly available comes with ethical concerns. For example, while NYC taxi pickup and dropoff data has been used for the good to map and understand NYC's diverse communities, it's also been used to identify and shame New Yorkers. In the same vein, while the City Council's move to make water consumption data publicly available may benefit certain businesses, this data unintentionally publicizes personal information about households, including real-time data indicating when a utility customer may be home or their daily life patterns. In this presentation Gale Brewer, Adrienne Schmoeker, Eleni Manis, and Albert Fox Cahn will use New York City as the prime example to discuss the ethical risks of open data. After a discussion, the forum will open to attendees to propose and workshop solutions to eliminate these risks and make the most of open data.

Hon. Gale Brewer, NYC Council; Evan Enzer, Surveillance Technology Oversight Project (STOP.); Adrienne Schmoeker, Surveillance Technology Oversight Project (STOP); Eleni Manis, Surveillance Technology Oversight Project (STOP); Albert Fox Cahn, Surveillance Technology Oversight Project (STOP)

2023

Civil Service Exams for NYCHA Residents - Local Law 163 [https://data.cityofnewyork.us/d/vyk9-wyct]

Virtual

Panel Discussion

{"url":"https://youtu.be/TKXgTCWUkOc?si=qpQIvQDapdzluOEN","description":"https://youtu.be/TKXgTCWUkOc?si=qpQIvQDapdzluOEN"}

Explore Census Business Builder with the U.S. Census Bureau

Join us to take a dive into Census Business Builder, which is a free platform of rich economic and business-related data. The redesigned portal offers a more user-friendly experience with new graphics, display and easier to access free information. Explore business related data with Data Dissemination Specialist Joli Golden by selected geographic levels, learn about NAICS codes and drill down on specific business topics. Additional data dissemination staff will be fielding questions live in the chat. This session will be helpful for those exploring starting a business or simply analyzing an area.

Joli Golden, U.S. Census Bureau

2023

Census Business Builder (https://cbb.census.gov), American Community Survey (https://data.census.gov/)

Virtual

Workshop

{"url":"https://youtu.be/lVLUSIKGqIc?si=SYOGQ4MaticuNa74","description":"https://youtu.be/lVLUSIKGqIc?si=SYOGQ4MaticuNa74"}

Virtual Scavenger Hunt – Collect Local Storefront Accessibility Data Using Crowdsourcing and AI

Storefront accessibility can substantially impact the way people who are blind or have low vision (BLV) travel in urban environments. Entrance localization is one of the biggest challenges to BLV people. Improperly designed staircases and obstructive store decorations can create considerable mobility challenges for BLV people, making it more difficult for them to navigate their community hence reducing their desire to travel. Existing digital map services don't include such storefront accessibility information.

We've developed a web application, DoorFront, to collect large-scale accessibility data of NYC storefronts using crowdsourcing and AI (Machine Learning) approach. DoorFront enables volunteers to validate the accessibility information labeled by AI right in their homes. We'll invite anyone who is interested in volunteering their time to helping the visually impaired participate in this Mapathon. We will offer incentives to 3 volunteers who have completed the most work.
<p dir="ltr"><strong>Rules:</strong></p>

<ul>
<li>Visit <a href="https://doofront-web-app-paw2roelga-uc.a.run.app/">https://doofront-web-app-paw2roelga-uc.a.run.app/</a> to begin!</li>
<li>The Mapathon starts at 3pm on 3/12 and ends at 3pm on 3/19. The three volunteers who have completed the most work will receive the following awards. Query image and Validation receive the same scores. Scores are based off of quality and accuracy.</li>
<li>The results will be announced on the app website (leaderboard) and the volunteers will also receive email notifications by 3/23.<a id="m_7062359172915746535LPlnk748531" href="https://doofront-web-app-paw2roelga-uc.a.run.app/" target="_blank" rel="noopener" data-saferedirecturl="https://www.google.com/url?q=https://doofront-web-app-paw2roelga-uc.a.run.app/&amp;source=gmail&amp;ust=1647452871253000&amp;usg=AOvVaw15BvO7AuDSbgWEPQwhpIyL"></a></li>
<li>Leaderboard shows the real-time scores, however our team will review the quality and accuracy of the work after the competition ends.</li>
<li>Make sure to sign up your account with accurate information.</li>
</ul>
<p dir="ltr"><strong>Rewards:</strong></p>

<ul>
<li><span id="m_7062359172915746535docs-internal-guid-fec62985-7fff-205b-9abf-b5ed5a4c3ac9">1st  place: $50 Amazon Gift Card</span></li>
<li><span id="m_7062359172915746535docs-internal-guid-fec62985-7fff-205b-9abf-b5ed5a4c3ac9">2nd  place: $30 Amazon Gift Card</span></li>
<li>3rd  place: $20 Amazon Gift Card</li>
</ul>

Hao Tang, CUNY; Jiawei Liu, CUNY; William Seiple, Lighthouse Guild

2022

{"url":"https://www.youtube.com/watch?v=hKR0OmRzu4Y","description":"https://www.youtube.com/watch?v=hKR0OmRzu4Y"}

Early Intervention Data – Impacting Advocacy and Community-Level Change

Are you interested in learning how local and municipal data can be used to inform community level change, advocacy, and equity for young children and families? Are you a passionate advocate or curious about how data can be used to improve a critical early childhood program for our youngest children?
Join Citizens’ Committee for Children of New York (CCC) to discover publicly available data on Early Intervention (EI), hear the most pressing issues that advocates are elevating to support young children and families, and learn about local efforts across NYC to use data to guide EI efforts.
Participants will also have an opportunity to walk through publicly available data, provided by the NYC Department of Health and Mental Hygiene's Bureau of Early Intervention and on CCC’s online database (data.cccnewyork.org), illustrating where and how over 30,000 young children under three years of age are being referred, evaluated, and receive services elevating how participation in the program varies across racial and ethnic groups, with children of color disproportionately being left behind.

Marija Drobnjak, Citizens’ Committee for Children; Jenny Veloz, Citizens’ Committee for Children; Carlos Rosales, Citizens’ Committee for Children

2023

NYC Early Interventions: Local Early Intervention Coordinating Council (LEICC) Report [https://data.cityofnewyork.us/d/brud-mdtt]

Virtual

Panel Discussion

{"url":"https://youtu.be/aP9U77RTYXo?si=ZF3ZXZ60Q126fTlX","description":"https://youtu.be/aP9U77RTYXo?si=ZF3ZXZ60Q126fTlX"}

Where Does the City's Money Go? Getting to Know Checkbook NYC

Checkbook NYC, is an online transparency tool that makes the City’s day-to-day spending available to the public.

This session will include a broad overview of the type of data that Checkbook offers and a guided tour of the site’s functionality. We will walk through the Spending and Contracts domains; the M/WBE and Subvendor Featured Dashboards; review the various search capabilities; ways to export data and creating customized alerts.

Nicole Boone, Edward Sokolowski, Office of the New York City Comptroller

2023

Checkbook NYC (https://www.checkbooknyc.com)

Virtual

Presentation

{"url":"https://youtu.be/q0So7TqmEbE?si=_0OMiH9aONnxiUgy","description":"https://youtu.be/q0So7TqmEbE?si=_0OMiH9aONnxiUgy"}

Creating a Smart Trucking Safety Android App with Unity

Using the goals set forth by the Truck Safety program from the NYC DOT's Freight Mobility team, this presentation will demonstrate a prototype Android application created using the Unity engine that will help users to navigate NYC's Truck Routes. By putting themselves in the driver's seat, users will learn about a truck's blind spots and how to best ensure their safety as a pedestrian, cyclist, and driver.

Maddalena Romano, NYC Department of Transportation (DOT); Hong Yuan, NYC Department of Transportation (DOT); Lisa Matthews, NYC Department of Transportation (DOT); Catherine Ponte, NYC Department of Transportation (DOT); Demel Gaillard, NYC Department of Transportation (DOT); Tahfimul Latif, NYC Department of Transportation (DOT)

2023

New York City Truck Routes [https://data.cityofnewyork.us/d/jjja-shxy]

Virtual

Demonstration

{"url":"https://youtu.be/2wqAFySiyKA?si=7yPdDn3uEAaHYR2_","description":"https://youtu.be/2wqAFySiyKA?si=7yPdDn3uEAaHYR2_"}

Office Hours with the NYC Mayor's Office Of Management and Budget (OMB)

OMB is on a mission to educate New Yorkers about the budget! Join this conversation to learn more about the Office Of Management and Budget's (OMB) role and responsibilities in City government, the budget cycle, and how budget data is reflected in Open Data sets.

Michael Greenburg, NYC Mayor's Office Of Management and Budget

2023

Expense Budget [https://data.cityofnewyork.us/d/mwzb-yiwb]

Virtual

Office Hours

{"url":"https://youtu.be/gtph6hW8tqs?si=mKNEBO0MMbRgQymq","description":"https://youtu.be/gtph6hW8tqs?si=mKNEBO0MMbRgQymq"}

Learn how to explore NYC Open Data with Python

Curious about open data but not sure how to get started? Join us for join this hands-on workshop exploring publicly available datasets using the Python programming language. No previous experience data analysis or programming experience needed. Through a series of browser-based activities, we will introduce the basics of accessing, analyzing, and visualizing OpenData. For the later activities, having a Gmail account will allow easier access to the Python notebooks which can accessed directly via Google Research's colab or can be downloaded from our github repo (stjohn/datasci/openDataWeek).

Katherine St. John, Department of Computer Science at Hunter College; Susan Sun, Department of Computer Science at Hunter College; Jack Cruse, Department of Computer Science at Hunter College

2023

Library [https://data.cityofnewyork.us/d/p4pf-fyc4]

Virtual

Workshop

{"url":"https://youtu.be/n2SrDnebS6U?si=D3m306hS3on53Mq6","description":"https://youtu.be/n2SrDnebS6U?si=D3m306hS3on53Mq6"}

Hidden in Plain Sight — Data Through Design Exhibition

2023

In-Person

Exhibition

Hidden in Plain Sight — Data Through Design Artist Panel

2023

In-Person

Panel Discussion

A Crash Course in Pandas

<a href="https://gcc02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fpandas.pydata.org%2F&amp;data=04%7C01%7COBjornsson%40analytics.nyc.gov%7C4be9bf2e7e38475f9f3508d9f88186aa%7C35c828166c56443bbaf68312163cadc1%7C0%7C0%7C637814057481083675%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000&amp;sdata=ohroHRBril13CYXYrRsy17Pp5ajyh%2Bz4P1YIEPZ2%2BxM%3D&amp;reserved=0">pandas</a> is a tool for working with data sets in Python. In this session, we'll learn some basics of how to load, manipulate, and display data, doing things with a bit of code that would be difficult with spreadsheets, using <a href="https://gcc02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fdata.cityofnewyork.us%2FSocial-Services%2F311-Service-Requests-from-2010-to-Present%2Ferm2-nwe9%2Fdata&amp;data=04%7C01%7COBjornsson%40analytics.nyc.gov%7C4be9bf2e7e38475f9f3508d9f88186aa%7C35c828166c56443bbaf68312163cadc1%7C0%7C0%7C637814057481083675%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000&amp;sdata=ow9SdZPIlrAxEkcGEw4pRNsTmrlg0FREIOd6JANl3CA%3D&amp;reserved=0">NYC's 311 dataset</a> as an example. No experience necessary.

The session will be led by Aidan Feldman, who has been a technologist working with government and non-profits for the past seven years. He also teaches Python Coding for Public Policy at NYU.

Aidan Feldman

2022

Class / Training

{"url":"https://www.youtube.com/watch?v=lLL_hnpamb0","description":"https://www.youtube.com/watch?v=lLL_hnpamb0"}

OpenStreetMap & Open Data: Mapping for Mobility in NYC (2 of 2)

This virtual workshop by TeachOSM is an introduction to open mapping using the OpenStreetMap platform. As a participant in this one-hour workshop, you will get an overview of how to add data to OpenStreetMap and then dive into adding bike racks &amp; pedestrian safety features to improve mobility in NYC.

OpenStreetMap US, TeachOSM

2022

{"url":"https://www.youtube.com/watch?v=ChGQqlMdfp8","description":"https://www.youtube.com/watch?v=ChGQqlMdfp8"}