Trees In Camden

London Borough of Camden

@ukgov.trees_in_camden_1

Table List

1 table(1.59 MB)

Table 1

@ukgov.trees_in_camden_1.table_1

1.59 MB
25477 rows
35 columns

number_of_trees Number Of Trees	sequence Sequence	site_name Site Name	contract_area Contract Area	scientific_name Scientific Name	common_name Common Name	inspection_date Inspection Date	inspection_due_date Inspection Due Date	height_in_metres Height In Metres	spread_in_metres Spread In Metres	diameter_in_centimetres_at_breast_height Diameter In Centimetres At Breast Height	maturity Maturity	physiological_condition Physiological Condition	tree_set_to_be_removed Tree Set To Be Removed	newly_planted Newly Planted	capital_asset_value_for_amenity_trees Capital Asset Value For Amenity Trees	carbon_storage_in_kilograms Carbon Storage In Kilograms	gross_carbon_sequestration_per_year_in_kilograms Gross Carbon Sequestration Per Year In Kilograms	pollution_removal_per_year_in_grams Pollution Removal Per Year In Grams	ward_code Ward Code	ward_name Ward Name	easting Easting	northing Northing	longitude Longitude	latitude Latitude	location Location	identifier Identifier	spatial_accuracy Spatial Accuracy	last_uploaded Last Uploaded	organisation_uri Organisation URI
1	8	Bells Hill Estate	Housing	Fraxinus excelsior	Ash	Thu Aug 03 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	2026/2027	18	12	70	Mature	Good	No	Not Applicable	39646.12						523936	196127	-0.209969	51.650287	(51.650287, -0.209969)	00044995	Captured By Camden Officer	19/04/2025 08:30:29 PM	http://opendatacommunities.org/id/london-borough-council/camden
1	2	GORDON HOUSE ROAD	Highways	Acer campestre Elegant	Maple - Field			3	2	4	Young	Good	No	1st year					E05013661	Highgate	528534	185776	-0.147326	51.556234	(51.556234, -0.147326)	00065701	Captured By Camden Officer	19/04/2025 08:30:33 PM	http://opendatacommunities.org/id/london-borough-council/camden
1	28	GOWER PLACE	Highways	Ulmus New Horizon	Elm			3	1.5	4	Young	Good	No	2nd year					E05013653	Bloomsbury	529554	182394	-0.133873	51.525612	(51.525612, -0.133873)	00064707	Captured By Camden Officer	19/04/2025 08:30:33 PM	http://opendatacommunities.org/id/london-borough-council/camden
1	66	Ferdinand Estate 2	Housing	Parrotia persica vanessa	Persian Ironwood	Fri Sep 13 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	2027/2028	3	1	7	Young	Good	No	Not Applicable	469.88				E05013660	Haverstock	528517	184464	-0.148052	51.544446	(51.544446, -0.148052)	00061227	Captured By Camden Officer	19/04/2025 08:30:32 PM	http://opendatacommunities.org/id/london-borough-council/camden
1	76	MAYGROVE ROAD	Highways	Tilia henryana	Lime - Henry's	Wed Aug 21 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	2027/2028	3	1.5	7	Young	Good	No	Not Applicable	475.76				E05013656	Fortune Green	524949	184778	-0.199365	51.548076	(51.548076, -0.199365)	00057846	Captured By Camden Officer	19/04/2025 08:30:36 PM	http://opendatacommunities.org/id/london-borough-council/camden
1	28	WATERLOW PARK (LS)	Parks	Quercus rubra	Oak - Red	Tue Apr 12 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	2025/2026	18	15	79	Mature	Fair	No	Not Applicable	60595.43	1478.3	23.6	595	E05013661	Highgate	528621	187091	-0.145603	51.568032	(51.568032, -0.145603)	00020822	Captured By Camden Officer	19/04/2025 08:30:39 PM	http://opendatacommunities.org/id/london-borough-council/camden
1	35	FORTUNE GREEN ROAD	Highways	Corylus colurna	Hazel - Turkish			3	2	4	Young	Good	No	1st year					E05013656	Fortune Green	525239	185369	-0.194982	51.553318	(51.553318, -0.194982)	00065690	Captured By Camden Officer	19/04/2025 08:30:32 PM	http://opendatacommunities.org/id/london-borough-council/camden
1	40	KING HENRY'S ROAD	Highways	Corylus colurna	Hazel - Turkish	Fri Jul 29 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	2025/2026				Young	Good	No	Not Applicable					E05013667	Primrose Hill	527895	184244	-0.157095	51.542613	(51.542613, -0.157095)	00059344	Captured By Camden Officer	19/04/2025 08:30:34 PM	http://opendatacommunities.org/id/london-borough-council/camden
	10	Estate 37-43 Lupton Street (odd)	Housing	Buddleia Species	Butterfly bush	Mon Jul 17 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	2026/2027					Not applicable	No						E05013663	Kentish Town North	529141	185720	-0.1386	51.555599	(51.555599, -0.1386)	00063866	Captured By Camden Officer	19/04/2025 08:30:32 PM	http://opendatacommunities.org/id/london-borough-council/camden
1	306	Branch Hill Estate	Housing	Sambucus nigra	Elder	Tue Apr 02 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	2027/2028	7	6	23	Mature	Good	No	Not Applicable	3804.59				E05013657	Frognal	526032	186019	-0.183321	51.558986	(51.558986, -0.183321)	00060851	Captured By Camden Officer	19/04/2025 08:30:29 PM	http://opendatacommunities.org/id/london-borough-council/camden


CREATE TABLE table_1 (
  "number_of_trees" DOUBLE,
  "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
);