About this Dataset

Forestry Inspections

Record of Forestry inspections for NYC Parks & Recreation. Inspections are initiated by a service request or internal process and may result in a work order.

Inspections are used to record field observations. ForMS 2.0 requires that Inspections can only be created from either a Tree Point or Planting Space based on the asset in question. Inspection types vary depending on the inspector’s workflow:
• level 1 (limited visual)
• level 2 (basic)
• level 3 (advanced)
• Re-inspection
• Sidewalk Rating (Trees and Sidewalks Inspections)
• General – Planting Space (Street Tree Planting Inspections)

This dataset can be joined to the Forestry Tree Points dataset by joining TreePointGlobalID from Forestry Inspections to GLOBALID from Forestry Tree Points.

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
Organization: City of New York
Last updated: 2020-11-10T17:00:42.211183

Tables

Table 1

@usgov.city_of_new_york_forestry_inspections.table_1

367.55 MB
1730696 rows
25 columns


CREATE TABLE table_1 (
  "objectid" BIGINT,
  "inspectiontype" VARCHAR,
  "inspectionstatus" VARCHAR,
  "inspectiontpcondition" VARCHAR,
  "inspectiontpstructure" VARCHAR,
  "treepointdbh" DOUBLE,
  "swtreeconditionrating" DOUBLE,
  "swlocationrating" DOUBLE,
  "swclearancerating" DOUBLE,
  "swdamagerating" DOUBLE,
  "swdamagedflagstonesrating" DOUBLE,
  "swratingtotal" DOUBLE,
  "treepointglobalid" VARCHAR,
  "plantingspaceglobalid" VARCHAR,
  "servicerequestglobalid" VARCHAR,
  "geometry" VARCHAR,
  "globalid" VARCHAR,
  "inspectiondate" VARCHAR,
  "closeddate" TIMESTAMP,
  "createddate" TIMESTAMP,
  "updateddate" TIMESTAMP,
  "parentinspectionglobalid" VARCHAR,
  "reinspectiondate" TIMESTAMP,
  "swtotaltrees" DOUBLE,
  "location" VARCHAR
);