Providence Tree Dataset by US Government | Environmental and Climate Sciences

About this Dataset

Providence Tree Dataset

In 2006, a complete inventory of all the City’s street trees, including trees located within sidewalks, between sidewalks and curbs, or within 6 feet of the street if no sidewalk existed was conducted. One hundred volunteers were trained to record address, location, tree species, tree diameter, condition, and other related information. Trees located in parks and other public property were not included. Approximately 25,000 street trees were counted and the data was loaded into a tree database that the Forestry Division uses daily to manage the trees, track tree work, and record constituent concerns.
Organization: City of Providence
Last updated: 2021-08-07T10:04:44.693367
Tags: sustainability, trees

Tables

Table 1

@usgov.city_of_providence_providence_tree_dataset.table_1

1.09 MB
27250 rows
14 columns


CREATE TABLE table_1 (
  "the_geom" VARCHAR,
  "address" BIGINT,
  "suffix" VARCHAR,
  "street" VARCHAR,
  "onstr" VARCHAR,
  "fromstr" VARCHAR,
  "tostr" VARCHAR,
  "side" VARCHAR,
  "site" BIGINT,
  "spp" VARCHAR,
  "dbh" DOUBLE,
  "wires" VARCHAR,
  "pittype" VARCHAR,
  "ward" BIGINT
);