This page houses a list of digital research tools and datasets including links to Census data, ACS, and NYC OpenData in addition to handouts, instructor tutorials, and any other links that may helpful to your success in this course.

IN-CLASS ACTIVITIES
Weeks 2&3_ResearchQuestions & Methods [PDF]
Week 5_Neighborhood Profile Outline [PDF]

HANDOUTS & TUTORIALS
Census Geography: https://share.vidyard.com/watch/DhJGiV8maQQ2ZZbeYk3gnJ?
Searching for Census Data: https://share.vidyard.com/watch/8WFVw8v3K8jGfc33PNm9wh?Searching NYC OpenData: https://share.vidyard.com/watch/JL3vkzDXJvi4cTZHpf3ECa?
Cleaning Datasets in Excel: https://share.vidyard.com/watch/eBn3a9PfwXf5YMB5zGg58q?Making Graphs in Excel: https://share.vidyard.com/watch/j5SUSCrB3qLdASBeBPgqBo?
      > 00:00 Reading your data – making sense of what you’re looking at
      >  5:00 Prepping data to graph it
      >  12:20: Making graphs

Youtube Videos to Learn Excel (there’s a ton out there, feel free to search):
Excel 2010 Tutorial For Beginners #1 – Overview (Microsoft Excel)        
Excel Quick and Simple Charts Tutorial
How to graph changing data in Excel

QGIS Mapping Step-by-step guide [PDF]

QGIS Tutorial Videos:
     > Importing shapefile & .csv file into QGIS:  https://share.vidyard.com/watch/7USaL4ptHjvzYzzkLnyRRr?
     >  Extracting Queens County from NYS shapefile
https://share.vidyard.com/watch/CU1yCi6VrrRrzZpjpUjD6R?
     >  TROUBLE SHOOT: Refactor fields: when you can’t find your data to map
https://share.vidyard.com/watch/pfPJDeddxkuvTBL34YapcC?
     >  Visualizing the Map and Exporting
https://share.vidyard.com/watch/wP8skcpEhznEbmCjmzJHrd?

CENSUS DATA
On the Map: https://onthemap.ces.census.gov/
Advanced Search: https://data.census.gov/cedsci/advanced
Quick Facts: https://www.census.gov/quickfacts/fact/table/US/PST045221
American Community Survey (ACS): https://www.census.gov/population/www/censusdata/hiscendata.html
Census Topics: https://censusreporter.org/topics/
NYC Population Fact Finder: https://popfactfinder.planning.nyc.gov/#12.25/40.724/-73.9868
Census Tracts and NTA equivalents: https://www1.nyc.gov/site/planning/data-maps/open-data/census-download-metadata.page
Neighborhood Tabulation Areas (NTAs): https://popfactfinder.planning.nyc.gov/#11.67/40.7198/-73.9515

NYC OPEN DATA https://data.cityofnewyork.us/browse

SPATIAL/GIS TOOLS
NYS 2019 Census tracts shapefile [download from BlackBoard]
Shape Files: https://www.census.gov/cgi-bin/geo/shapefiles/index.php
https://www.census.gov/geographies/mapping-files/time-series/geo/tiger-line-file.html

NEIGHBORHOOD INFORMATION & MAPS
NYU Furman Center: https://furmancenter.org/stateofthecity
Social Explorer: https://www.socialexplorer.com/a9676d974c/explore
Social Vulnerability & Legacy of Redlining: https://dsl.richmond.edu/socialvulnerability/
Eviction Data: https://council.nyc.gov/data/evictions/#residential-evictions

EXAMPLES TO INSPIRE THE LAYOUT OF YOUR PROFILE
*these examples aren’t necessarily neighborhood profiles, but they convey similar information*

• https://furmancenter.org/files/publications/ERAP_Falling_Through_the_Cracks__Final.pdf
• https://comptroller.nyc.gov/wp-content/uploads/documents/NYC_Neighborhood_Economic_Profiles_2017.pdf
• https://furmancenter.org/files/publications/Rent_Payments_in_Affordable_Housing_During_the_Pandemic_Terner_Center__Final.pdf
• https://furmancenter.org/files/Floodplain_HurricaneBrief_12DEC2017.pdf
• https://mentalhealth.cityofnewyork.us/wp-content/uploads/2021/02/ThriveNYC-ProgressReport-2021.pdf
• https://www.brooklyncommunityfoundation.org/insights-impact-2017
• https://www.osc.state.ny.us/files/reports/osdc/pdf/report-2-2023.pdf