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-07-02T04:06:37Z

Tables

Table 1

@ukgov.trees_in_camden_1.table_1

1.81 MB
27,581 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
);