Dataset: Columbus, OH - Public Owned Trees

About this Dataset

Columbus, OH - Public Owned Trees

Content

This dataset contains information on the publicly owned trees located in parks, public grounds, and streetscapes in Columbus, OH. Over 150,000 rows of data are available and contain information such as the latitude and longitude, condition, diameter, and more for each individual tree. The Columbus Recreation and Parks Department Urban Forestry program is responsible for the maintenance and data collection on these trees.

The bounding coordinates for this data is as follows:

West: -91.967252
East: -82.73498
North: 57.720042
South: 37.795918

Acknowledgements

Dataset from the City of Columbus Department of Technology
Cover image by Matt Artz released under the Unsplash License

Tables

Public Owned Trees

@kaggle.tjkyner_columbus_oh_public_owned_trees.public_owned_trees

5.85 MB
153141 rows
22 columns


CREATE TABLE public_owned_trees (
  "x" DOUBLE,
  "y" DOUBLE,
  "objectid" BIGINT,
  "site_class" DOUBLE,
  "address" VARCHAR,
  "zip" DOUBLE,
  "diam_breast_height" DOUBLE,
  "maintenance" DOUBLE,
  "planting_date" VARCHAR,
  "inspection_date" VARCHAR,
  "retired" VARCHAR,
  "condition1" DOUBLE,
  "life_stage1" DOUBLE,
  "planning_area" VARCHAR,
  "park" VARCHAR,
  "sp_code" VARCHAR,
  "addr_num" DOUBLE,
  "str_pre_dir" VARCHAR,
  "str_name" VARCHAR,
  "str_type" VARCHAR,
  "str_suf_dir" VARCHAR,
  "height" VARCHAR
);