About this Dataset

Street Tree Removal Notifications

A. SUMMARY Street Tree Removal public notifications managed by San Francisco Public Works. B. HOW THE DATASET IS CREATED Data is based on 24-hour, 15-day, or 30-day public notices posted on the trees after a Street Tree Removal Permit was issued by the City. C. UPDATE PROCESS Updated daily and uses Safe FME to automate publishing. D. HOW TO USE THIS DATASET Each record is a street tree removal public notice after a permit was issued and the tree was recommended for removal.
Organization: City of San Francisco
Last updated: 2020-11-10T16:56:50.894352
Tags: notification, posting, removal, schedule, tree, trees

Tables

Table 1

@usgov.city_of_san_francisco_street_tree_removal_notifications.table_1

482.36 kB
5,207 rows
25 columns

CREATE TABLE table_1 (
  "actiontype" VARCHAR,
  "actiondate" TIMESTAMP,
  "treeid" BIGINT,
  "supervisordistrict" DOUBLE,
  "addressno" BIGINT,
  "altdescription" VARCHAR,
  "legalstatus" VARCHAR,
  "ownername" VARCHAR,
  "siteorder" DOUBLE,
  "locsite" VARCHAR,
  "sitetype" VARCHAR,
  "planttype" VARCHAR,
  "scientificname" VARCHAR,
  "commonname" VARCHAR,
  "treephoto" VARCHAR,
  "x" DOUBLE,
  "y" DOUBLE,
  "lat" DOUBLE,
  "long" DOUBLE,
  "point" VARCHAR,
  "neighborhoods" DOUBLE,
  "sf_find_neighborhoods" DOUBLE,
  "current_police_districts" DOUBLE,
  "current_supervisor_districts" DOUBLE,
  "analysis_neighborhoods" DOUBLE
);