Dataset: Trees In Camden

About this Dataset

Trees In Camden

This dataset contains locations of Council owned trees on highways and in parks and open spaces in the borough. The data is collected during cyclical tree inspections by Camden tree officers. Each point contains tree species, height, spread, diameter at breast height (DBH), and maturity. Tree sequence number attached to each tree is site specific.
Publisher name: London Borough of Camden
Last updated: 2025-06-06T04:00:25Z

Tables

Table 1

@ukgov.trees_in_camden_1.table_1

1.72 MB
27546 rows
35 columns


CREATE TABLE table_1 (
  "number_of_trees" BIGINT,
  "sequence" DOUBLE,
  "site_name" VARCHAR,
  "contract_area" VARCHAR,
  "scientific_name" VARCHAR,
  "common_name" VARCHAR,
  "inspection_date" TIMESTAMP,
  "inspection_due_date" VARCHAR,
  "height_in_metres" DOUBLE,
  "spread_in_metres" DOUBLE,
  "diameter_in_centimetres_at_breast_height" DOUBLE,
  "maturity" VARCHAR,
  "physiological_condition" VARCHAR,
  "tree_set_to_be_removed" VARCHAR,
  "removal_reason" VARCHAR,
  "newly_planted" VARCHAR,
  "outstanding_job_count" DOUBLE,
  "outstanding_job_number" VARCHAR,
  "outstanding_job_description" VARCHAR,
  "capital_asset_value_for_amenity_trees" DOUBLE,
  "carbon_storage_in_kilograms" DOUBLE,
  "gross_carbon_sequestration_per_year_in_kilograms" DOUBLE,
  "pollution_removal_per_year_in_grams" DOUBLE,
  "blossom_map" VARCHAR,
  "ward_code" VARCHAR,
  "ward_name" VARCHAR,
  "easting" BIGINT,
  "northing" BIGINT,
  "longitude" DOUBLE,
  "latitude" DOUBLE,
  "location" VARCHAR,
  "identifier" VARCHAR,
  "spatial_accuracy" VARCHAR,
  "last_uploaded" VARCHAR,
  "organisation_uri" VARCHAR
);