This tutorial aims to offer test data obtained from freely available datasets from New York. Each dataset will be explained in detail for easy comprehension.
Overview of Data
| Dataset name | Type |
|---|---|
| airports | Point |
| boroughs | MultiPolygon |
| boroughs_label | Point |
| buildings | MultiPolygon |
| crime_2023 | MultiPolygon |
| crime_history | MultiPolygon |
| incidents | Point |
| noise | Point |
| population | MultiPolygon |
| potholes | Point |
| railways | LineString |
| rivers | MultiLineString |
| roads | LineString |
| seating | Point |
| squirrel_cencus | Point |
| subway_entrances | Point |
| tax_lots | MultiPolygon |
| water_bodies | Polygon |
| wifi_hotspots | Point |
Detailed Dataset information
Airports
Geometry type: Point
Size: 166 counts
Description: Airport locations in the New York metropolitan area
Source: https://geodata.bts.gov/search?tags=aviation
Boroughs
Geometry type: MultiPolygon
Size: 5 counts
Description: Districts of New York
Source: http://www.nyc.gov/html/dcp/html/bytes/applbyte.shtml
Special usage: Very small dataset ideal for testing or styling
Boroughs_label
Geometry type: Point
Size: 5 counts
Description: Centroid of the districts of New York
Source: http://www.nyc.gov/html/dcp/html/bytes/applbyte.shtml
Special usage: Ideal for labelling in combination with boroughs, as the label text will be displayed in the centerpoint of each boroughs' polygon.
Buildings
Geometry type: MultiPolygon
Size: 1 136 458 counts
Description: Building footprints of New York
Source: https://www.interline.io/osm/extracts/
Crime_2023
Geometry type: MultiPolygon
Size: 77 counts
Description: Absolute numbers of seven major felony offenses for each police precinct in 2023
Source: Revised from https://www.nyc.gov/site/nypd/stats/crime-statistics/historical.page
Special usage: Dashboard charts
Crime_history
Geometry type: MultiPolygon
Size: 77 counts
Description: Absolute numbers of seven major felony offenses all together for each police precinct between 2000 and 2023
Source: Revised from https://www.nyc.gov/site/nypd/stats/crime-statistics/historical.page
Special usage: Time series visualisation in Dashboard (Date widgets)
Incidents
Geometry type: Point
Size: 3 225 138 counts
Description: Incidents reported to hotline 311 in New York in 2023
Source: Revised from https://data.cityofnewyork.us/Social-Services/311-Service-Requests-from-2010-to-Present/erm2-nwe9/about_data
Noise
Geometry type: Point
Size: 686 231 counts
Description: Noise reported to hotline 311 in New York in 2023; Filtered from incidents dataset
Source: Revised from https://data.cityofnewyork.us/Social-Services/311-Service-Requests-from-2010-to-Present/erm2-nwe9/about_data
Special usage: Timestamp data to be used in Dashboard Date widgets
Population
Geometry type: MultiPolygon
Size: 39 148 counts
Description: Absolute numbers of New York's inhabitants per census block, divided by ethnicity in 2010
Source: https://www.nyc.gov/site/planning/data-maps/open-data/census-download-metadata.page & https://data.census.gov/
Potholes
Geometry type: Point
Size: 218 822 counts
Description: Potholes reported to hotline 311 in New York between 2021 and 2023; Filtered from incidents dataset
Source: Revised from https://data.cityofnewyork.us/Social-Services/311-Service-Requests-from-2010-to-Present/erm2-nwe9/about_data
Railways
Geometry type: Line String
Size: 14 774 counts
Description: All types of rails overground and underground in the New York metropolitan area
Source: https://www.interline.io/osm/extracts/
Rivers
Geometry type: MultiLineString
Size: 15 339 counts
Description: Contains all water lines within the New York metropolitan area
Source: https://www.interline.io/osm/extracts/
Roads
Geometry type: Line String
Size: 217 099 counts
Description: All types of roads and paths in the New York metropolitan area
Source: https://www.interline.io/osm/extracts/
Seating
Geometry type: Point
Size: 2 222 counts
Description: Seating locations (Benches) in New York
Source: https://data.cityofnewyork.us/Transportation/Seating-Locations/esmy-s8q5/about_data
Squirrel_census
Geometry type: Point
Size: 3 023 counts
Description: Squirrel sightings in Central Park; This table comprises data on 3,023 squirrel sightings, detailing location coordinates, age, primary and secondary fur color, elevation, activities, communications, and interactions with both other squirrels and humans.
Source: https://data.cityofnewyork.us/Environment/2018-Central-Park-Squirrel-Census-Squirrel-Data/vfnx-vebw/about_data
Subway_entrances
Geometry type: Point
Size: 1 904 counts
Description: New York City subway entrances
Source: https://nycopendata.socrata.com/Transportation/Subway-Entrances/drex-xx56
Tax_lots
Geometry type: MultiPolygon
Size: 858 572 counts
Description: Polygon data at the tax lot level with a number of taxlot features
Source:
Water_bodies
Geometry type: Polygon
Size: 7 138 counts
Description: All water areas in the greater New York metropolitan area as well as open waters
Source: Combination of two datasets: https://www.census.gov/cgi-bin/geo/shapefiles/index.php?year=2014&layergroup=Water & https://osmdata.openstreetmap.de/data/water-polygons.html
Wifi_spots
Geometry type: MultiPolygon
Size: 3 319 counts
Description: Public wifi hotspot locations and providers
Source: https://data.cityofnewyork.us/City-Government/NYC-Wi-Fi-Hotspot-Locations/yjub-udmw/data