About this Dataset

Special Tree Permit

Residents and contractors who wish to plant, prune, or remove a tree within the public right of way must first obtain permission from the Department of Transportation and the Urban Forestry Division using the Transportation Online Permitting System (TOPS). The data here are points representing each permit which is extracted from Transportation Online Permitting System. The extraction is performed every night under the Transportation Integrated Enterprise System (TIES) framework. For more information visit trees.dc.gov.
Organization: District of Columbia
Last updated: 2024-04-30T17:50:08.723813
Tags: dc, ddot, district-of-columbia, environment, pruning, tree, tree-removal, urban-forestry, washington-dc

Tables

Table 1

@usgov.district_of_columbia_special_tree_permit.table_1

3.62 MB
19,996 rows
64 columns

CREATE TABLE table_1 (
  "x" DOUBLE,
  "y" DOUBLE,
  "objectid" BIGINT,
  "trackingnumber" BIGINT,
  "permitnumber" VARCHAR,
  "status" VARCHAR,
  "hazardoustreecount" BIGINT,
  "nonhazardoustreecount" BIGINT,
  "heritagehazardoustreecount" DOUBLE,
  "heritagenonhazardoustreecount" DOUBLE,
  "exemptedtreecount" BIGINT,
  "under55treecount" BIGINT,
  "totaltreecount" BIGINT,
  "circumferenceremoved" DOUBLE,
  "circumferenceplanted" DOUBLE,
  "circumferencepaid" DOUBLE,
  "treefundamount" DOUBLE,
  "treelocation" VARCHAR,
  "isaarborist" VARCHAR,
  "isaarboristcertno" VARCHAR,
  "assignedufaarborist" VARCHAR,
  "applicationdate" TIMESTAMP,
  "effectivedate" TIMESTAMP,
  "expirationdate" TIMESTAMP,
  "issuedate" TIMESTAMP,
  "lastupdatedate" TIMESTAMP,
  "treefundwaivedate" TIMESTAMP,
  "paymentdate" TIMESTAMP,
  "submissiondate" TIMESTAMP,
  "approvaldate" TIMESTAMP,
  "resubmissiondate" TIMESTAMP,
  "assigneddate" TIMESTAMP,
  "lastupdatedby" VARCHAR,
  "ward" BIGINT,
  "fiscalyear" BIGINT,
  "quadrant" VARCHAR,
  "zipcode" DOUBLE,
  "anc" VARCHAR,
  "smd" VARCHAR,
  "neighborhoodclusters" VARCHAR,
  "neighborhoodnames" VARCHAR,
  "bid" VARCHAR,
  "awi" VARCHAR,
  "edz" VARCHAR,
  "nif" VARCHAR,
  "historicdistrict" VARCHAR,
  "zoning" VARCHAR,
  "pud" VARCHAR,
  "cfar" VARCHAR,
  "psa" DOUBLE,
  "pd" DOUBLE,
  "daystoassign" DOUBLE,
  "daystoapprove" DOUBLE,
  "daystoissue" DOUBLE,
  "xcoord" DOUBLE,
  "ycoord" DOUBLE,
  "onsegx" DOUBLE,
  "onsegy" DOUBLE,
  "longitude" DOUBLE,
  "latitude" DOUBLE,
  "specialtreespreservationcount" DOUBLE,
  "specialtreesrelocationcount" DOUBLE,
  "heritagetreespreservationcount" DOUBLE,
  "heritagetreesrelocationcount" DOUBLE
);