Name: Exceptional Trees On Oahu
Creator: US Government
License: http://creativecommons.org/publicdomain/zero/1.0/legalcode

About this Dataset

Exceptional Trees On Oahu

City & County of Honolulu exceptional tree database
Organization: City of Honolulu
Last updated: 2020-11-10T17:00:08.035875
Tags: park, trees

Tables

Table 1

@usgov.city_of_honolulu_exceptional_trees_on_oahu.table_1

64.92 kB
339 rows
38 columns

CREATE TABLE table_1 (
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "name" DOUBLE,
  "species_code" VARCHAR,
  "scientific_name" VARCHAR,
  "common_name" VARCHAR,
  "height_ft" VARCHAR  -- Height (ft),
  "diameter_in" VARCHAR  -- Diameter (in),
  "gross_carbon_sequestered_lb_yr" VARCHAR  -- Gross Carbon Sequestered (lb/yr),
  "o2_produced_lb_yr" VARCHAR  -- O2 Produced (lb/yr,
  "storm_water_avoided_gal_yr" VARCHAR  -- Storm Water Avoided (gal/yr),
  "storm_water_intercepted_gal_yr" VARCHAR  -- Storm Water Intercepted (gal/yr,
  "date_assessed" VARCHAR,
  "crown_spread_l_ft" VARCHAR  -- Crown Spread L (ft),
  "crown_spread_s_ft" VARCHAR  -- Crown Spread S (ft),
  "live_crown_ration" VARCHAR,
  "tree_condition" VARCHAR,
  "land_use" VARCHAR,
  "number" VARCHAR,
  "additional_information" VARCHAR,
  "location_description" VARCHAR,
  "island" VARCHAR,
  "military_base" VARCHAR,
  "accessibility" VARCHAR,
  "owner_name" VARCHAR,
  "location_address" VARCHAR,
  "owner_address" VARCHAR,
  "description" VARCHAR,
  "flag" VARCHAR,
  "tmk" VARCHAR,
  "trunk_circumference" VARCHAR,
  "city" VARCHAR,
  "old_id" VARCHAR,
  "variety_name" VARCHAR,
  "hawaiian_name" VARCHAR,
  "geometry_point" VARCHAR,
  "dead_tree_location" VARCHAR,
  "object_id" BIGINT
);