Baselight

Trees In Camden

London Borough of Camden

@ukgov.trees_in_camden_1

Loading...
Loading...

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
Loading...

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
);

Share link

Anyone who has the link will be able to view this.