Dataset: Forestry Planting Spaces

About this Dataset

Forestry Planting Spaces

Context

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

Public: This dataset is intended for public access and use.
License: No license information was provided.

Tables

Forestry Planting Spaces

@kaggle.saurabhshahane_forestry_planting_space.forestry_planting_spaces

152.31 MB
992056 rows
35 columns


CREATE TABLE forestry_planting_spaces (
  "objectid" BIGINT,
  "borough" VARCHAR,
  "number" VARCHAR,
  "street" VARCHAR,
  "pssite" VARCHAR,
  "plantingspaceonstreet" VARCHAR,
  "width" DOUBLE,
  "length" DOUBLE,
  "parkname" VARCHAR,
  "parkzone" VARCHAR,
  "crossstreet1" VARCHAR,
  "crossstreet2" VARCHAR,
  "communityboard" BIGINT,
  "sanitationzone" VARCHAR,
  "postcode" BIGINT,
  "council_district" BIGINT,
  "statesenate" BIGINT,
  "stateassembly" BIGINT,
  "congressional" BIGINT,
  "physicalid" DOUBLE,
  "psstatus" VARCHAR,
  "geometry" VARCHAR,
  "globalid" VARCHAR,
  "createddate" VARCHAR,
  "updateddate" VARCHAR,
  "jurisdiction" VARCHAR,
  "overheadutilities" BIGINT,
  "treeguard" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "census_tract" DOUBLE,
  "bin" DOUBLE,
  "bbl" DOUBLE,
  "nta" VARCHAR,
  "location" VARCHAR
);