List of Automated Datasets

{"url":"https://data.cityofnewyork.us/d/feu5-w2e2"}

Registration Contacts

Contains information about organizations or individuals listed on a Multiple Dwelling Registration form.

Yes

Department of Housing Preservation and Development (HPD)

Monthly

Yes

{"url":"https://data.cityofnewyork.us/d/tesw-yqqr"}

Multiple Dwelling Registrations

Pursuant to New York City’s Housing Maintenance Code, the Department of Housing
Preservation and Development (HPD) collects registration information from owners of
residential rental units. Owners are required to register if they own residential buildings
with three or more units or if they own one- or two-family homes and neither they nor
members of their immediate family live there. Registrations are required upon taking
ownership of a qualifying building, and once a year thereafter.

Yes

Department of Housing Preservation and Development (HPD)

Monthly

Yes

{"url":"https://data.cityofnewyork.us/d/kj4p-ruqc"}

Buildings Subject to HPD Jurisdiction

Pursuant to New York City’s Housing Maintenance Code, the Department of Housing
Preservation and Development (HPD) collects information on multiple dwellings in New York
City, and other buildings that fall under its jurisdiction. HPD’s Buildings Open Data covers all
buildings which meet any of the following criteria:

a. HPD has required the owner to register the building under the Housing Maintenance
Code (HMC)
b. HPD has initiated a litigation action under the HMC
c. HPD has received a complaint for the building
d. HPD has initiated a work order for the purposes of emergency repair, demolition, or
the Alternative Enforcement Program (AEP) for the building
e. HPD has added the property to the AEP program

Buildings are identified by a BuildingID.

Yes

Department of Housing Preservation and Development (HPD)

Monthly

Yes

{"url":"https://data.cityofnewyork.us/d/wvxf-dwi5"}

Housing Maintenance Code Violations

Pursuant to New York City’s Housing Maintenance Code, the Department of Housing Preservation and Development (HPD) issues violations against conditions in rental dwelling units that have been verified to violate the New York City using Maintenance Code (HMC) or the New York State Multiple Dwelling Law (MDL). Violations are issued when an inspection verifies that a violation of the HMC or MDL exists. It is closed when the violation is corrected, as observed/verified by HPD or as certified by the landlord.

Yes

Department of Housing Preservation and Development (HPD)

Daily

Yes

{"url":"https://data.cityofnewyork.us/d/59kj-x8nc"}

Housing Litigations

The Department of Housing Preservation and Development (HPD) Housing Litigation Division (HLD) initiates' actions in the Housing Court against owners of privately-owned buildings to enforce compliance with the housing quality standards contained in the New York State Multiple Dwelling Law and the New York City Housing Maintenance Code. HLD attorneys also represent HPD when tenants initiate actions against private owners. HPD is automatically named as party to such actions. The goal of these court proceedings is to obtain enforceable Orders to Correct, Civil Penalties (fines) and Contempt Sanctions, compelling owners to comply with the Housing Code.

Yes

Department of Housing Preservation and Development (HPD)

Monthly

Yes

{"url":"https://data.cityofnewyork.us/d/5tqd-u88y"}

Local Law 251 of 2017: Published Data Asset Inventory

As per Local Law 251 of 2017, the Open Data plan is required to include the following comprehensive information on each dataset on the Open Data Portal:

- Most recent update date;
- URL;
- Whether it complies with data retention standard (which mandates that row-level data be maintained on the dataset);
- Whether it has a data dictionary;
- Whether it meets the geocoding standard, does not meet the geocoding, or is ineligible for the geospatial standard;
- Whether updates to the dataset are automated;
- Whether updates to the dataset “feasibly can be automated”.
-----
For a list of all datasets that were included on all the NYC Open Data plans (2013-2020) and their current release status, please refer to <a href="https://data.cityofnewyork.us/City-Government/Local-Law-251-of-2017-NYC-Open-Data-Plan-Tracker/qj2z-ibhs">Local Law 251 of 2017: NYC Open Data Plan Tracker</a>.

Yes

Department of Information Technology & Telecommunications (DoITT)

Daily

Yes

{"url":"https://data.cityofnewyork.us/d/wexi-2njw"}

2018 Orthoimagery Bronx

The Department of Information Technology and Telecommunications, GIS Unit, is providing the raw orthoimagery for download. This orthoimagery is used to create the Aerial Photography Tile Layer services described in further detail here: https://maps.nyc.gov/tiles/. Full metadata on the Aerial & Orthoimagery can be found at: https://github.com/CityOfNewYork/nyc-geo-metadata/blob/master/Metadata/Metadata_AerialImagery.md

Yes

Department of Information Technology & Telecommunications (DoITT)

Historical Data

Yes

{"url":"https://data.cityofnewyork.us/d/quxm-hmyr"}

LinkNYC Kiosk Status (Historical)

This dataset provides the most current listing of LinkNYC Kiosks, their location, and the status of the Link’s wifi, tablet, and phone.

Yes

Department of Information Technology & Telecommunications (DoITT)

Hourly

Yes

{"url":"https://data.cityofnewyork.us/d/n6c5-95xh"}

LinkNYC Kiosk Status

This dataset provides the most current listing of LinkNYC Kiosks, their location, and the status of the Link’s wifi, tablet, and phone.

Yes

Department of Information Technology & Telecommunications (DoITT)

Hourly

Yes

{"url":"https://data.cityofnewyork.us/d/7t2y-4fke"}

List of Automated Datasets

This dataset is an inventory of the automated assets on the portal.

Yes

Department of Information Technology & Telecommunications (DoITT)

Daily

Yes

{"url":"https://data.cityofnewyork.us/d/rxuy-2muj"}

Points Of Interest

The Points Of Interest points are a compilation of what the different city agencies consider to be a Common Place or Place/Point of Interest.

Previously posted versions of the data are retained to comply with Local Law 106 of 2015 and can be provided upon request made to Open Data.

Yes

Department of Information Technology & Telecommunications (DoITT)

Weekly

Yes

{"url":"https://data.cityofnewyork.us/d/nqwf-w8eh"}

Building Footprints

Shapefile of footprint outlines of buildings in New York City. Please see the following link for additional documentation- https://github.com/CityOfNewYork/nyc-geo-metadata/blob/master/Metadata/Metadata_BuildingFootprints.md

Previously posted versions of the data are retained to comply with Local Law 106 of 2015 and can be provided upon request made to Open Data.

Yes

Department of Information Technology & Telecommunications (DoITT)

Weekly

Yes

{"url":"https://data.cityofnewyork.us/d/s5zg-yzea"}

Building Footprints Historical Shape

Shapefile of historical footprint outlines of buildings in New York City. Please see the following link for additional documentation- https://github.com/CityOfNewYork/nyc-planimetrics/blob/master/Capture_Rules.md.

Previously posted versions of the data are retained to comply with Local Law 106 of 2015 and can be provided upon request made to Open Data.

Yes

Department of Information Technology & Telecommunications (DoITT)

Weekly

Yes

{"url":"https://data.cityofnewyork.us/d/ymvu-4x4s"}

.nyc Domain Registrations by Zip Code

.nyc domain registrations broken down by zip code. This list is updated monthly.

Yes

Department of Information Technology & Telecommunications (DoITT)

Monthly

No

{"url":"https://data.cityofnewyork.us/view/c3v8-5x25"}

.nyc Domain Registrations

A list of all .nyc domains registered along with the registration date and registrant type.

Yes

Department of Information Technology & Telecommunications (DoITT)

As needed

No

{"url":"https://data.cityofnewyork.us/d/9cw8-7heb"}

.nyc Domain Registrations

A list of all .nyc domains registered along with the registration date and registrant type. This list is updated daily.

Yes

Department of Information Technology & Telecommunications (DoITT)

As needed

No

{"url":"https://data.cityofnewyork.us/d/g6pj-hd8k"}

NYC Address Points

NYC Address Points

Previously posted versions of the data are retained to comply with Local Law 106 of 2015 and can be provided upon request made to Open Data.

Yes

Department of Information Technology & Telecommunications (DoITT)

Weekly

Yes

{"url":"https://data.cityofnewyork.us/d/exjm-f27b"}

NYC Street Centerline (CSCL)

The NYC Street Centerline (CSCL) is a road-bed representation of New York City streets containing address ranges and other information such as traffic directions, road types, segment types

Previously posted versions of the data are retained to comply with Local Law 106 of 2015 and can be provided upon request made to Open Data.

Yes

Department of Information Technology & Telecommunications (DoITT)

Weekly

Yes

{"url":"https://data.cityofnewyork.us/d/6z8x-wfk4"}

Evictions

This dataset lists pending, scheduled and executed evictions within the five boroughs, for the year 2017 - Present. The data fields may be sorted by Court Index Number, Docket Number, Eviction Address, Apartment Number, Executed Date, Marshal First Name, Marshal Last Name, Residential or Commercial (property type), Borough, Zip Code and Scheduled Status (Pending/Scheduled).

Eviction data is compiled from the majority of New York City Marshals. Marshals are independent public officials and should be contacted directly for more information at https://www1.nyc.gov/site/doi/offices/marshals-list.page Data prior to January 1 2017 is not currently available.

Yes

Department of Investigation (DOI)

Daily

Yes

{"url":"https://data.cityofnewyork.us/d/tqsy-2s6w"}

Block Pruning

Record of routine block pruning cycles by block segment.

Yes

Department of Parks and Recreation (DPR)

As needed

Yes

{"url":"https://data.cityofnewyork.us/d/v959-5k2w"}

Entitation Parsed Species

Entitation is a process of identifying and describing discrete vegetation units (entities). Essentially, it is a general inventory of an area's plant communities conducted by means of aerial photograph interpretation and field reconnaissance. The survey results in the identification of ecologically distinct plant communities based on species and structure.

A many-to-one listing of the species observed in each Entitation Unit. This dataset was derived from the original Entitation dataset through a thorough review process.

For an entitation manual, please follow <a href="https://drive.google.com/file/d/1YEyJ2JSRSRtWTRMw2RQwxNl_wAZwn5Pw/view">this link</a>

For the main Entitation dataset, please follow <a href="https://data.cityofnewyork.us/d/ud2m-5tb4">this link</a>

Yes

Department of Parks and Recreation (DPR)

As needed

Yes

{"url":"https://data.cityofnewyork.us/d/ud2m-5tb4"}

Entitation

Entitation is a process of identifying and describing discrete vegetation units (entities). Essentially, it is a general inventory of an area's plant communities conducted by means of aerial photograph interpretation and field reconnaissance. The survey results in the identification of ecologically distinct plant communities based on species and structure.

The main dataset containing data describing each distinct vegetation community.

For an entitation manual, please follow <a href="https://drive.google.com/file/d/1YEyJ2JSRSRtWTRMw2RQwxNl_wAZwn5Pw/view">this link</a>

For the Entitation Parsed Species dataset, please follow <a href="https://data.cityofnewyork.us/d/v959-5k2w">this link</a>

Yes

Department of Parks and Recreation (DPR)

As needed

Yes

{"url":"https://data.cityofnewyork.us/d/uisg-ivwv"}

Parks Inspection Program – PIP Plus

This dataset contains additional quality of experience issues observed during property inspections. Each row represents a single issue.

A complete list of all datasets in the series can be found <a href="https://data.cityofnewyork.us/browse?Data-Collection_Data-Collection=Parks%20Inspection%20Program%20(PIP)&sortBy=alpha">here</a>.

Yes

Department of Parks and Recreation (DPR)

Quarterly

Yes

{"url":"https://data.cityofnewyork.us/d/86a8-pqby"}

Parks Inspection Program – Inventory

This dataset contains property features by type and category. Each row represents a single feature.

A complete list of all datasets in the series can be found <a href="https://data.cityofnewyork.us/browse?Data-Collection_Data-Collection=Parks%20Inspection%20Program%20(PIP)&sortBy=alpha">here</a>.

Yes

Department of Parks and Recreation (DPR)

Quarterly

Yes

{"url":"https://data.cityofnewyork.us/d/yg3y-7juh"}

Parks Inspection Program – Inspections

This dataset contains overall ratings associated with property inspections. Each row represents an individual inspection.

A complete list of all datasets in the series can be found <a href="https://data.cityofnewyork.us/browse?Data-Collection_Data-Collection=Parks%20Inspection%20Program%20(PIP)&sortBy=alpha">here</a>.

Yes

Department of Parks and Recreation (DPR)

Quarterly

Yes

{"url":"https://data.cityofnewyork.us/d/2jvr-j6ne"}

Parks Inspection Program – Element Tracking

This dataset contains additional items that are counted, and in some cases evaluated during a property inspection. Examples include signs, flags and drinking fountains. Each row represents a single observation.

A complete list of all datasets in the series can be found <a href="https://data.cityofnewyork.us/browse?Data-Collection_Data-Collection=Parks%20Inspection%20Program%20(PIP)&sortBy=alpha">here</a>.

Yes

Department of Parks and Recreation (DPR)

Quarterly

Yes

{"url":"https://data.cityofnewyork.us/d/s6dm-mdan"}

Parks Inspection Program – Daily Immediate Attentions

This dataset contains immediate attention hazards. These include unacceptable situations that may be potentially hazardous, as well as graffiti that depicts profanity or hate speech. Each row represents a single "immediate attention."

A complete list of all datasets in the series can be found <a href="https://data.cityofnewyork.us/browse?Data-Collection_Data-Collection=Parks%20Inspection%20Program%20(PIP)&sortBy=alpha">here</a>.

Yes

Department of Parks and Recreation (DPR)

Quarterly

Yes

{"url":"https://data.cityofnewyork.us/d/9yid-w4y8"}

Parks Inspection Program – Construction Information

This dataset contains construction and closed site information observed during a property inspection. Each row represents a single inspection.

A complete list of all datasets in the series can be found <a href="https://data.cityofnewyork.us/browse?Data-Collection_Data-Collection=Parks%20Inspection%20Program%20(PIP)&sortBy=alpha">here</a>.

Yes

Department of Parks and Recreation (DPR)

Quarterly

Yes

{"url":"https://data.cityofnewyork.us/d/ibip-ftv5"}

Parks Inspection Program – Conditions & Hazards

This dataset contains hazards (i.e. situations that may be potentially hazardous as well as graffiti that depicts profanity or hate speech) and conditions (i.e. unacceptable non-hazardous situations) identified during property inspections. Each row represents a single condition or hazard.

A complete list of all datasets in the series can be found <a href="https://data.cityofnewyork.us/browse?Data-Collection_Data-Collection=Parks%20Inspection%20Program%20(PIP)&sortBy=alpha">here</a>.

Yes

Department of Parks and Recreation (DPR)

Quarterly

Yes

{"url":"https://data.cityofnewyork.us/d/5mma-5n3h"}

Parks Inspection Program – Feature Ratings

This dataset contains ratings for inspected property features. Each row represents a rating for a single feature.

A complete list of all datasets in the series can be found <a href="https://data.cityofnewyork.us/browse?Data-Collection_Data-Collection=Parks%20Inspection%20Program%20(PIP)&sortBy=alpha">here</a>.

Yes

Department of Parks and Recreation (DPR)

Quarterly

Yes

{"url":"https://data.cityofnewyork.us/d/xmiz-qy72"}

Parks Inspection Program – Comfort Station Feature Ratings

This dataset contains ratings for inspected comfort station features. Each row represents a rating for a single feature.

A complete list of all datasets in the series can be found <a href="https://data.cityofnewyork.us/browse?Data-Collection_Data-Collection=Parks%20Inspection%20Program%20(PIP)&sortBy=alpha">here</a>.

Yes

Department of Parks and Recreation (DPR)

Quarterly

Yes

{"url":"https://data.cityofnewyork.us/d/r8mb-budb"}

Parks Inspection Program – Comfort Station Conditions & Hazards

This dataset contains hazards (i.e. situations that may be potentially hazardous as well as graffiti that depicts profanity or hate speech) and conditions (i.e. unacceptable non-hazardous situations) identified during comfort station inspections. Each row represents a single condition or hazard.

A complete list of all datasets in the series can be found <a href="https://data.cityofnewyork.us/browse?Data-Collection_Data-Collection=Parks%20Inspection%20Program%20(PIP)&sortBy=alpha">here</a>.

Yes

Department of Parks and Recreation (DPR)

Quarterly

Yes

{"url":"https://data.cityofnewyork.us/d/mp8v-wjtf"}

Parks Inspection Program – Comfort Station Inspections

This dataset documents overall ratings associated with comfort station inspections. Each row represents a single comfort station.

A complete list of all datasets in the series can be found <a href="https://data.cityofnewyork.us/browse?Data-Collection_Data-Collection=Parks%20Inspection%20Program%20(PIP)&sortBy=alpha">here</a>.

Yes

Department of Parks and Recreation (DPR)

Quarterly

Yes

{"url":"https://data.cityofnewyork.us/d/buk3-3qpr"}

Parks Inspection Program – All Sites

This dataset contains properties eligible for inspection as part of the Parks Inspection Program, and contains internal directives and comments related to the inspection process. Each row represents a property or sub-property.

A complete list of all datasets in the series can be found <a href="https://data.cityofnewyork.us/browse?Data-Collection_Data-Collection=Parks%20Inspection%20Program%20(PIP)&sortBy=alpha">here</a>.

Yes

Department of Parks and Recreation (DPR)

Quarterly

Yes

{"url":"https://data.cityofnewyork.us/d/9byw-znpj"}

Parks Inspection Program – Comfort Stations

This dataset contains comfort stations eligible for inspection, and identifies extended comfort station closures. Each row represents a single comfort station.

A complete list of all datasets in the series can be found <a href="https://data.cityofnewyork.us/browse?Data-Collection_Data-Collection=Parks%20Inspection%20Program%20(PIP)&sortBy=alpha">here</a>.

Yes

Department of Parks and Recreation (DPR)

Quarterly

Yes

{"url":"https://data.cityofnewyork.us/d/yp6n-7jdy"}

Parks Inspection Program – Comfort Station Room Inspections

This dataset contains overall condition ratings for comfort station rooms and counts of room amenities/items. Each row represents a single room inspection.

A complete list of all datasets in the series can be found <a href="https://data.cityofnewyork.us/browse?Data-Collection_Data-Collection=Parks%20Inspection%20Program%20(PIP)&sortBy=alpha">here</a>.

Yes

Department of Parks and Recreation (DPR)

Quarterly

Yes

{"url":"https://data.cityofnewyork.us/d/k5ta-2trh"}

Forestry Tree Points

Record of Forestry tree points for NYC Parks & Recreation.

Tree Points and Planting Spaces form the basis of ForMS 2.0’s data inventory and are the core entities that all Service Requests, Inspections, and Work Orders are associated to. The system has built-in rules to ensure that every Tree Point has a Planting Space and each Planting Space can have no more than one active Tree Point at a given time. Locations that have had one tree removed and another tree replanted will appear in ForMS 2.0 as a single Planting Space associated with one retired Tree Point (that has a removal Work Order) and one active Tree Point.

This dataset can be joined to the Forestry Planting Spaces dataset by joining PlantingSpaceGlobalID from Forestry Tree Points to GLOBALID from Forestry Planting Spaces.

User guide: https://docs.google.com/document/d/1PVPWFi-WExkG3rvnagQDoBbqfsGzxCKNmR6n678nUeU/edit?usp=sharing

Data dictionary: https://docs.google.com/spreadsheets/d/1yMfZgcsrvx9M0b3-ZdEQ3WCk2dFxgitCWytTrJSwEAs/edit?usp=sharing

Yes

Department of Parks and Recreation (DPR)

Monthly

Yes

{"url":"https://data.cityofnewyork.us/d/4jyz-6b7u"}

Forestry Planting Spaces

Record of Forestry planting spaces for NYC Parks & Recreation.

Tree Points and Planting Spaces form the basis of ForMS 2.0’s data inventory and are the core entities that all Service Requests, Inspections, and Work Orders are associated to. The system has built-in rules to ensure that every Tree Point has a Planting Space and each Planting Space can have no more than one active Tree Point at a given time. Locations that have had one tree removed and another tree replanted will appear in ForMS 2.0 as a single Planting Space associated with one retired Tree Point (that has a removal Work Order) and one active Tree Point.

User guide: https://docs.google.com/document/d/1PVPWFi-WExkG3rvnagQDoBbqfsGzxCKNmR6n678nUeU/edit?usp=sharing

Data dictionary: https://docs.google.com/spreadsheets/d/1yMfZgcsrvx9M0b3-ZdEQ3WCk2dFxgitCWytTrJSwEAs/edit?usp=sharing

Yes

Department of Parks and Recreation (DPR)

Monthly

Yes

{"url":"https://data.cityofnewyork.us/d/k2ya-ucmv"}

ARCHIVED - Parks Properties

For up to date version see: https://nycopendata.socrata.com/Recreation/Parks-Properties/enfh-gkve

This data identifies City property under the jurisdiction of NYC Parks, which may be managed partially or solely by the Agency. This data has been produced in whole or part using secondary data. Data accuracy is limited by the scale and accuracy of the original sources. Site-specific conditions should be field-verified. For legal accuracy, refer to the maps that established parks and acquisition maps.

Yes

Department of Parks and Recreation (DPR)

Monthly

Yes

{"url":"https://data.cityofnewyork.us/d/mnkj-myjb"}

NYC Parks Events Listing – Event YouTube Links

The NYC Parks Events Listing database is used to store event information displayed on the Parks website, nyc.gov/parks. There are seven related tables that make up the this database:

1. Events_Events table (This is the primary table that contains basic data about every event. Each record is an event.)
2. Events_Categories (Each record is a category describing an event. One event can be in more than one category.)
3. Events_Images (Each record is an image related to an event. One event can have more than one image.)
4. Events_Links (Each record is a link with more information about an event. One event can have more than one link.)
5. Events_Locations (Each record is a location where an event takes place. One event can have more than one location.)
6. Events_Organizers (Each record contains a group or person organizing an event. One event can have more than one organizer.)
7. Events_YouTube (Each record is a link to a YouTube video about an event. One event can have more than one YouTube video.)

The Events_Events table is the primary table. All other tables can be related by joining on the event_id. This data contains records from 2013 and on. For a complete list of related datasets, please follow <a href="https://data.cityofnewyork.us/browse?Data-Collection_Data-Collection=NYC+Parks+Events&sortBy=alpha">This Link</a>

Yes

Department of Parks and Recreation (DPR)

As needed

Yes

{"url":"https://data.cityofnewyork.us/d/jk6k-yab4"}

NYC Parks Events Listing – Event Organizers

The NYC Parks Events Listing database is used to store event information displayed on the Parks website, nyc.gov/parks. There are seven related tables that make up the this database:

1. Events_Events table (This is the primary table that contains basic data about every event. Each record is an event.)
2. Events_Categories (Each record is a category describing an event. One event can be in more than one category.)
3. Events_Images (Each record is an image related to an event. One event can have more than one image.)
4. Events_Links (Each record is a link with more information about an event. One event can have more than one link.)
5. Events_Locations (Each record is a location where an event takes place. One event can have more than one location.)
6. Events_Organizers (Each record contains a group or person organizing an event. One event can have more than one organizer.)
7. Events_YouTube (Each record is a link to a YouTube video about an event. One event can have more than one YouTube video.)

The Events_Events table is the primary table. All other tables can be related by joining on the event_id. This data contains records from 2013 and on. For a complete list of related datasets, please follow <a href="https://data.cityofnewyork.us/browse?Data-Collection_Data-Collection=NYC+Parks+Events&sortBy=alpha">This Link</a>

Yes

Department of Parks and Recreation (DPR)

As needed

Yes

{"url":"https://data.cityofnewyork.us/d/cpcm-i88g"}

NYC Parks Events Listing – Event Locations

The NYC Parks Events Listing database is used to store event information displayed on the Parks website, nyc.gov/parks. There are seven related tables that make up the this database:

1. Events_Events table (This is the primary table that contains basic data about every event. Each record is an event.)
2. Events_Categories (Each record is a category describing an event. One event can be in more than one category.)
3. Events_Images (Each record is an image related to an event. One event can have more than one image.)
4. Events_Links (Each record is a link with more information about an event. One event can have more than one link.)
5. Events_Locations (Each record is a location where an event takes place. One event can have more than one location.)
6. Events_Organizers (Each record contains a group or person organizing an event. One event can have more than one organizer.)
7. Events_YouTube (Each record is a link to a YouTube video about an event. One event can have more than one YouTube video.)

The Events_Events table is the primary table. All other tables can be related by joining on the event_id. This data contains records from 2013 and on. For a complete list of related datasets, please follow <a href="https://data.cityofnewyork.us/browse?Data-Collection_Data-Collection=NYC+Parks+Events&sortBy=alpha">This Link</a>

Yes

Department of Parks and Recreation (DPR)

As needed

Yes

{"url":"https://data.cityofnewyork.us/d/6eti-k994"}

NYC Parks Events Listing – Event Images

The NYC Parks Events Listing database is used to store event information displayed on the Parks website, nyc.gov/parks. There are seven related tables that make up the this database:

1. Events_Events table (This is the primary table that contains basic data about every event. Each record is an event.)
2. Events_Categories (Each record is a category describing an event. One event can be in more than one category.)
3. Events_Images (Each record is an image related to an event. One event can have more than one image.)
4. Events_Links (Each record is a link with more information about an event. One event can have more than one link.)
5. Events_Locations (Each record is a location where an event takes place. One event can have more than one location.)
6. Events_Organizers (Each record contains a group or person organizing an event. One event can have more than one organizer.)
7. Events_YouTube (Each record is a link to a YouTube video about an event. One event can have more than one YouTube video.)

The Events_Events table is the primary table. All other tables can be related by joining on the event_id. This data contains records from 2013 and on. For a complete list of related datasets, please follow <a href="https://data.cityofnewyork.us/browse?Data-Collection_Data-Collection=NYC+Parks+Events&sortBy=alpha">This Link</a>

Yes

Department of Parks and Recreation (DPR)

As needed

Yes

{"url":"https://data.cityofnewyork.us/d/ridc-7qqg"}

NYC Parks Events Listing – Event Links

The NYC Parks Events Listing database is used to store event information displayed on the Parks website, nyc.gov/parks. There are seven related tables that make up the this database:

1. Events_Events table (This is the primary table that contains basic data about every event. Each record is an event.)
2. Events_Categories (Each record is a category describing an event. One event can be in more than one category.)
3. Events_Images (Each record is an image related to an event. One event can have more than one image.)
4. Events_Links (Each record is a link with more information about an event. One event can have more than one link.)
5. Events_Locations (Each record is a location where an event takes place. One event can have more than one location.)
6. Events_Organizers (Each record contains a group or person organizing an event. One event can have more than one organizer.)
7. Events_YouTube (Each record is a link to a YouTube video about an event. One event can have more than one YouTube video.)

The Events_Events table is the primary table. All other tables can be related by joining on the event_id. This data contains records from 2013 and on. For a complete list of related datasets, please follow <a href="https://data.cityofnewyork.us/browse?Data-Collection_Data-Collection=NYC+Parks+Events&sortBy=alpha">This Link</a>

Yes

Department of Parks and Recreation (DPR)

As needed

Yes

{"url":"https://data.cityofnewyork.us/d/fudw-fgrp"}

NYC Parks Events Listing – Event Listing

The NYC Parks Events Listing database is used to store event information displayed on the Parks website, nyc.gov/parks. There are seven related tables that make up the this database:

1. Events_Events table (This is the primary table that contains basic data about every event. Each record is an event.)
2. Events_Categories (Each record is a category describing an event. One event can be in more than one category.)
3. Events_Images (Each record is an image related to an event. One event can have more than one image.)
4. Events_Links (Each record is a link with more information about an event. One event can have more than one link.)
5. Events_Locations (Each record is a location where an event takes place. One event can have more than one location.)
6. Events_Organizers (Each record contains a group or person organizing an event. One event can have more than one organizer.)
7. Events_YouTube (Each record is a link to a YouTube video about an event. One event can have more than one YouTube video.)

The Events_Events table is the primary table. All other tables can be related by joining on the event_id. This data contains records from 2013 and on. For a complete list of related datasets, please follow <a href="https://data.cityofnewyork.us/browse?Data-Collection_Data-Collection=NYC+Parks+Events&sortBy=alpha">This Link</a>

Yes

Department of Parks and Recreation (DPR)

As needed

Yes

{"url":"https://data.cityofnewyork.us/d/xtsw-fqvh"}

NYC Parks Events Listing – Event Categories

The NYC Parks Events Listing database is used to store event information displayed on the Parks website, nyc.gov/parks. There are seven related tables that make up the this database:

1. Events_Events table (This is the primary table that contains basic data about every event. Each record is an event.)
2. Events_Categories (Each record is a category describing an event. One event can be in more than one category.)
3. Events_Images (Each record is an image related to an event. One event can have more than one image.)
4. Events_Links (Each record is a link with more information about an event. One event can have more than one link.)
5. Events_Locations (Each record is a location where an event takes place. One event can have more than one location.)
6. Events_Organizers (Each record contains a group or person organizing an event. One event can have more than one organizer.)
7. Events_YouTube (Each record is a link to a YouTube video about an event. One event can have more than one YouTube video.)

The Events_Events table is the primary table. All other tables can be related by joining on the event_id. This data contains records from 2013 and on. For a complete list of related datasets, please follow <a href="https://data.cityofnewyork.us/browse?Data-Collection_Data-Collection=NYC+Parks+Events&sortBy=alpha">This Link</a>

Yes

Department of Parks and Recreation (DPR)

As needed

Yes

{"url":"https://data.cityofnewyork.us/d/ub9z-gccp"}

Asset Management Parks System (AMPS) – Transaction Details

This table contains specific information about each part that is included in a transaction. Each record has information about one type of part in the transaction. A single transaction could have multiple lines (one for each type of part) in this table. The TRL_TRANS field can be joined to the Transactions table on TRA_CODE to know which parts were part the transaction.

For the User Guide, please follow <a href="https://docs.google.com/document/d/1UwyGGncb6oFMiOfgz73G-iM8Yea9ubz4931hPeBO9YQ/edit?usp=sharing">this link</a>
For the Data Dictionary, please follow <a href="https://docs.google.com/spreadsheets/d/1pDr-BUe4LS7DvATfbOnd8UrV6s77krJgzqdq_gVYWqc/edit?usp=sharing">this link </a>

Yes

Department of Parks and Recreation (DPR)

As needed

Yes

{"url":"https://data.cityofnewyork.us/d/xzj8-i3jk"}

Asset Management Parks System (AMPS) – Labor

This table contains work order labor records. Each record in this table corresponds to one labor entry and includes general information about that piece of labor. The primary key is BOO_CODE. The BOO_EVENT field can be joined to the Work Orders table on EVT_CODE to know how much labor was booked to each work order.

For the User Guide, please follow <a href="https://docs.google.com/document/d/1UwyGGncb6oFMiOfgz73G-iM8Yea9ubz4931hPeBO9YQ/edit?usp=sharing">this link</a>
For the Data Dictionary, please follow <a href="https://docs.google.com/spreadsheets/d/1pDr-BUe4LS7DvATfbOnd8UrV6s77krJgzqdq_gVYWqc/edit?usp=sharing">this link </a>

Yes

Department of Parks and Recreation (DPR)

As needed

Yes

{"url":"https://data.cityofnewyork.us/d/gcys-vvnq"}

Asset Management Parks System (AMPS) – Transactions

This table contains information about transactions. A transaction tracks the movement of parts and materials between store houses and work orders. Each record represents a single transaction. The primary key is TRA_CODE. When TRA_TOENTITY is “EVNT” then you can use the TRA_TOCODE field to join to the Work Orders table on EVT_CODE to know which transactions are associated with each work order.

For the User Guide, please follow <a href="https://docs.google.com/document/d/1UwyGGncb6oFMiOfgz73G-iM8Yea9ubz4931hPeBO9YQ/edit?usp=sharing">this link</a>
For the Data Dictionary, please follow <a href="https://docs.google.com/spreadsheets/d/1pDr-BUe4LS7DvATfbOnd8UrV6s77krJgzqdq_gVYWqc/edit?usp=sharing">this link </a>

Yes

Department of Parks and Recreation (DPR)

As needed

Yes

{"url":"https://data.cityofnewyork.us/d/kw9y-h36n"}

Asset Management Parks System (AMPS) – Comments

This table all comments for all tables in AMPS. The record for each comment indicates which record and table the comment pertains to. Each record is a single comment. The ADD_CODE field can be joined to another table according to the value in ADD_ENTITY.

For the User Guide, please follow <a href="https://docs.google.com/document/d/1UwyGGncb6oFMiOfgz73G-iM8Yea9ubz4931hPeBO9YQ/edit?usp=sharing">this link</a>
For the Data Dictionary, please follow <a href="https://docs.google.com/spreadsheets/d/1pDr-BUe4LS7DvATfbOnd8UrV6s77krJgzqdq_gVYWqc/edit?usp=sharing">this link </a>

Yes

Department of Parks and Recreation (DPR)

As needed

Yes