Exceptional Trees On Oahu
City of Honolulu
@usgov.city_of_honolulu_exceptional_trees_on_oahu
City of Honolulu
@usgov.city_of_honolulu_exceptional_trees_on_oahu
CREATE TABLE table_1 (
"latitude" DOUBLE,
"longitude" DOUBLE,
"name" DOUBLE,
"species_code" VARCHAR,
"scientific_name" VARCHAR,
"common_name" VARCHAR,
"height_ft" VARCHAR,
"diameter_in" VARCHAR,
"gross_carbon_sequestered_lb_yr" VARCHAR,
"o2_produced_lb_yr" VARCHAR,
"storm_water_avoided_gal_yr" VARCHAR,
"storm_water_intercepted_gal_yr" VARCHAR,
"date_assessed" VARCHAR,
"crown_spread_l_ft" VARCHAR,
"crown_spread_s_ft" VARCHAR,
"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
);
Anyone who has the link will be able to view this.