Dataset: Forestry Service Requests

About this Dataset

Forestry Service Requests

Record of Forestry service requests for NYC Parks & Recreation.

Two-way integration with 311 is maintained in ForMS 2.0. Forestry related Service Requests (SRs) created by a 311 operator or submitted by the caller through either the 311 website, 311 phone app, or the Parks website stream into the system. Conversely, updates are sent from ForMS 2.0 to 311 when SRs are actioned.

Service Requests can be created directly in ForMS 2.0, however, it is important to note that they will NOT receive a 311 SEIBEL number or be visible in 311. Internally generated SRs should be used to track correspondence, commissioner, or other requests that do not originate from 311.

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:04:16.340159

Tables

Table 1

@usgov.city_of_new_york_forestry_service_requests.table_1

276.9 MB
981941 rows
47 columns


CREATE TABLE table_1 (
  "objectid" BIGINT,
  "complaintnumber" VARCHAR,
  "srcategory" VARCHAR,
  "srtype" VARCHAR,
  "srpriority" VARCHAR,
  "srsource" VARCHAR,
  "srstatus" VARCHAR,
  "srresolution" VARCHAR,
  "boroughcode" VARCHAR,
  "communityboard" DOUBLE,
  "buildingnumber" VARCHAR,
  "streetname" VARCHAR,
  "crossstreet1" VARCHAR,
  "crossstreet2" VARCHAR,
  "taxclass" DOUBLE,
  "locationdetails" VARCHAR,
  "complaintdetails" VARCHAR,
  "parkname" VARCHAR,
  "parkzone" VARCHAR,
  "notestocustomer" VARCHAR,
  "postcode" DOUBLE,
  "council_district" DOUBLE,
  "statesenate" DOUBLE,
  "stateassembly" DOUBLE,
  "congressional" DOUBLE,
  "sanitationzone" VARCHAR,
  "physicalid" DOUBLE,
  "servicerequestparentglobalid" VARCHAR,
  "geometry" VARCHAR,
  "globalid" VARCHAR,
  "initiateddate" TIMESTAMP,
  "closeddate" TIMESTAMP,
  "createddate" TIMESTAMP,
  "updateddate" TIMESTAMP,
  "descriptor1" VARCHAR,
  "complainttype" VARCHAR,
  "callerzipcode" VARCHAR,
  "srcallertype" VARCHAR,
  "callercity" VARCHAR,
  "callerstate" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "census_tract" DOUBLE,
  "bin" DOUBLE,
  "bbl" DOUBLE,
  "nta" VARCHAR,
  "location" VARCHAR
);