About this Dataset

Forestry Risk Assessments

Risk Assessments are sub-components of Inspection records where Type = Level 2. Trees are inspected in accordance with Parks' Tree Risk Management program. For a given defect identified on a tree, 3 rating variables are selected to arrive at a Total Rating. Because multiple defects can be noted on a tree, multiple Risk Assessment records can be related to one Inspection.

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:14.598635
Tags: forestry, inspection, risk, trees

Tables

Table 1

@usgov.city_of_new_york_forestry_risk_assessments.table_1

106.11 MB
1,160,715 rows
12 columns

CREATE TABLE table_1 (
  "objectid" BIGINT,
  "radefect" VARCHAR,
  "radefectlocation" VARCHAR,
  "failure" DOUBLE,
  "impacttarget" DOUBLE,
  "consequence" DOUBLE,
  "riskrating" DOUBLE,
  "inspectionglobalid" VARCHAR,
  "globalid" VARCHAR,
  "createddate" TIMESTAMP,
  "failureimpact" DOUBLE,
  "workorderglobalid" VARCHAR
);