Baselight

Analysis And Interpretation Of Tree Audit Data For Cambridge City Council

Cambridgeshire Insight

@ukgov.analysis_and_interpretation_of_tree_audit_for_cambridg_bb4e4073

About this Dataset

Analysis And Interpretation Of Tree Audit Data For Cambridge City Council

Datasets produced as part of a report conducted by ADAS UK in 2013 examining urban tree stock within Cambridge city.

The full report can be accessed online here: https://www.cambridge.gov.uk/sites/default/files/analysis-and-interpreta...
Publisher name: Cambridgeshire Insight
Last updated: 2024-09-14T15:47:04Z

Tables

4a. Number Of Trees By Species And Council Land-use

@ukgov.analysis_and_interpretation_of_tree_audit_for_cambridg_bb4e4073.n_4a_number_of_trees_by_species_and_council_land_use
  • 93.42 KB
  • 15 rows
  • 107 columns
Loading...

CREATE TABLE n_4a_number_of_trees_by_species_and_council_land_use (
  "wards" VARCHAR,
  "ons_codes" VARCHAR,
  "county_highways_beech" BIGINT,
  "county_highways_cherry_spp" BIGINT,
  "county_highways_chestnut_spp" BIGINT,
  "county_highways_common_ash" BIGINT,
  "county_highways_english_oak" BIGINT,
  "county_highways_fastgiate_hornbeam" BIGINT,
  "county_highways_field_maple" BIGINT,
  "county_highways_hawthorn" BIGINT,
  "county_highways_lime_spp" BIGINT,
  "county_highways_london_plane" BIGINT,
  "county_highways_malus_spp" BIGINT,
  "county_highways_norway_maple" BIGINT,
  "county_highways_pear_spp" BIGINT,
  "county_highways_pillar_apple" BIGINT,
  "county_highways_rowan_spp" BIGINT,
  "county_highways_silver_birch" BIGINT,
  "county_highways_small_leaf_lime" BIGINT,
  "county_highways_swedish_whitebeam" BIGINT,
  "county_highways_sycamore" BIGINT,
  "county_highways_turkish_hazel" BIGINT,
  "county_highways_white_willow" BIGINT,
  "county_highways_whitebeam" BIGINT,
  "county_highways_wild_cherry" BIGINT,
  "county_highways_willow_spp" BIGINT,
  "county_highways_other" BIGINT,
  "county_highways_unknown" BIGINT,
  "city_public_open_space_beech" BIGINT,
  "city_public_open_space_cherry_spp" BIGINT,
  "city_public_open_space_chestnut_spp" BIGINT,
  "city_public_open_space_common_ash" BIGINT,
  "city_public_open_space_english_oak" BIGINT,
  "city_public_open_space_fastgiate_hornbeam" BIGINT,
  "city_public_open_space_field_maple" BIGINT,
  "city_public_open_space_hawthorn" BIGINT,
  "city_public_open_space_lime_spp" BIGINT,
  "city_public_open_space_london_plane" BIGINT,
  "city_public_open_space_malus_spp" BIGINT,
  "city_public_open_space_norway_maple" BIGINT,
  "city_public_open_space_pear_spp" BIGINT,
  "city_public_open_space_pillar_apple" BIGINT,
  "city_public_open_space_rowan_spp" BIGINT,
  "city_public_open_space_silver_birch" BIGINT,
  "city_public_open_space_small_leaf_lime" BIGINT,
  "city_public_open_space_swedish_whitebeam" BIGINT,
  "city_public_open_space_sycamore" BIGINT,
  "city_public_open_space_turkish_hazel" BIGINT,
  "city_public_open_space_white_willow" BIGINT,
  "city_public_open_space_whitebeam" BIGINT,
  "city_public_open_space_wild_cherry" BIGINT,
  "city_public_open_space_willow_spp" BIGINT,
  "city_public_open_space_other" BIGINT,
  "city_public_open_space_unknown" BIGINT,
  "city_council_other_beech" BIGINT,
  "city_council_other_cherry_spp" BIGINT,
  "city_council_other_chestnut_spp" BIGINT,
  "city_council_other_common_ash" BIGINT,
  "city_council_other_english_oak" BIGINT,
  "city_council_other_fastgiate_hornbeam" BIGINT,
  "city_council_other_field_maple" BIGINT,
  "city_council_other_hawthorn" BIGINT,
  "city_council_other_lime_spp" BIGINT,
  "city_council_other_london_plane" BIGINT,
  "city_council_other_malus_spp" BIGINT,
  "city_council_other_norway_maple" BIGINT,
  "city_council_other_pear_spp" BIGINT,
  "city_council_other_pillar_apple" BIGINT,
  "city_council_other_rowan_spp" BIGINT,
  "city_council_other_silver_birch" BIGINT,
  "city_council_other_small_leaf_lime" BIGINT,
  "city_council_other_swedish_whitebeam" BIGINT,
  "city_council_other_sycamore" BIGINT,
  "city_council_other_turkish_hazel" BIGINT,
  "city_council_other_white_willow" BIGINT,
  "city_council_other_whitebeam" BIGINT,
  "city_council_other_wild_cherry" BIGINT,
  "city_council_other_willow_spp" BIGINT,
  "city_council_other_other" BIGINT,
  "city_council_other_unknown" BIGINT,
  "total_stock_beech" BIGINT,
  "total_stock_cherry_spp" BIGINT,
  "total_stock_chestnut_spp" BIGINT,
  "total_stock_common_ash" BIGINT,
  "total_stock_english_oak" BIGINT,
  "total_stock_fastgiate_hornbeam" BIGINT,
  "total_stock_field_maple" BIGINT,
  "total_stock_hawthorn" BIGINT,
  "total_stock_lime_spp" BIGINT,
  "total_stock_london_plane" BIGINT,
  "total_stock_malus_spp" BIGINT,
  "total_stock_norway_maple" BIGINT,
  "total_stock_pear_spp" BIGINT,
  "total_stock_pillar_apple" BIGINT,
  "total_stock_rowan_spp" BIGINT,
  "total_stock_silver_birch" BIGINT,
  "total_stock_small_leaf_lime" BIGINT,
  "total_stock_swedish_whitebeam" BIGINT,
  "total_stock_sycamore" BIGINT,
  "total_stock_turkish_hazel" BIGINT
);

1c. Land Area By Conservation Area

@ukgov.analysis_and_interpretation_of_tree_audit_for_cambridg_bb4e4073.n_1c_land_area_by_conservation_area
  • 2.62 KB
  • 12 rows
  • 2 columns
Loading...

CREATE TABLE n_1c_land_area_by_conservation_area (
  "conservation_area" VARCHAR,
  "land_area_ha" DOUBLE
);

1b. Land Area By Ward For Private Conservation Areas Only

@ukgov.analysis_and_interpretation_of_tree_audit_for_cambridg_bb4e4073.n_1b_land_area_by_ward_for_private_conservation_areas_only
  • 3.37 KB
  • 15 rows
  • 3 columns
Loading...

CREATE TABLE n_1b_land_area_by_ward_for_private_conservation_areas_only (
  "wards" VARCHAR,
  "ons_codes" VARCHAR,
  "private_conservation_land_area_ha" DOUBLE
);

4b. Number Of Trees By Genus

@ukgov.analysis_and_interpretation_of_tree_audit_for_cambridg_bb4e4073.n_4b_number_of_trees_by_genus
  • 176.64 KB
  • 15 rows
  • 212 columns
Loading...

CREATE TABLE n_4b_number_of_trees_by_genus (
  "wards" VARCHAR,
  "ons_codes" VARCHAR,
  "county_highways_acer" BIGINT,
  "county_highways_aesculus" BIGINT,
  "county_highways_ailanthus" BIGINT,
  "county_highways_alnus" BIGINT,
  "county_highways_amelanchier" BIGINT,
  "county_highways_aralia" BIGINT,
  "county_highways_arbutus" BIGINT,
  "county_highways_betula" BIGINT,
  "county_highways_carpinus" BIGINT,
  "county_highways_catalpa" BIGINT,
  "county_highways_cedrus" BIGINT,
  "county_highways_cercis" BIGINT,
  "county_highways_chamaecyparis" BIGINT,
  "county_highways_corylus" BIGINT,
  "county_highways_cotinus" BIGINT,
  "county_highways_cotoneaster" BIGINT,
  "county_highways_crataegus" BIGINT,
  "county_highways_cryptomeria" BIGINT,
  "county_highways_cupressus" BIGINT,
  "county_highways_davidia" BIGINT,
  "county_highways_fagus" BIGINT,
  "county_highways_ficus" BIGINT,
  "county_highways_fraxinus" BIGINT,
  "county_highways_gingko" BIGINT,
  "county_highways_gledista" BIGINT,
  "county_highways_ilex" BIGINT,
  "county_highways_juglans" BIGINT,
  "county_highways_koelreuteria" BIGINT,
  "county_highways_laburnum" BIGINT,
  "county_highways_larix" BIGINT,
  "county_highways_ligustrum" BIGINT,
  "county_highways_liquidambar" BIGINT,
  "county_highways_liriodendron" BIGINT,
  "county_highways_magnolia" BIGINT,
  "county_highways_malus" BIGINT,
  "county_highways_mespilus" BIGINT,
  "county_highways_metasequioa" BIGINT,
  "county_highways_morus" BIGINT,
  "county_highways_nothofagus" BIGINT,
  "county_highways_ostrya" BIGINT,
  "county_highways_parrotia" BIGINT,
  "county_highways_paulownia" BIGINT,
  "county_highways_phillyrea" BIGINT,
  "county_highways_picea" BIGINT,
  "county_highways_pinus" BIGINT,
  "county_highways_platanus" BIGINT,
  "county_highways_populus" BIGINT,
  "county_highways_prunus" BIGINT,
  "county_highways_pseudotsuga" BIGINT,
  "county_highways_pterocarya" BIGINT,
  "county_highways_pyrus" BIGINT,
  "county_highways_quercus" BIGINT,
  "county_highways_rhus" BIGINT,
  "county_highways_robinia" BIGINT,
  "county_highways_salix" BIGINT,
  "county_highways_sambucus" BIGINT,
  "county_highways_sciadopteris" BIGINT,
  "county_highways_sequoia" BIGINT,
  "county_highways_sophora" BIGINT,
  "county_highways_sorbus" BIGINT,
  "county_highways_syringa" BIGINT,
  "county_highways_tamarix" BIGINT,
  "county_highways_taxus" BIGINT,
  "county_highways_thuja" BIGINT,
  "county_highways_tilia" BIGINT,
  "county_highways_tsuga" BIGINT,
  "county_highways_ulmus" BIGINT,
  "county_highways_viburnum" BIGINT,
  "county_highways_zelkova" BIGINT,
  "county_highways_other" BIGINT,
  "city_public_open_space_acer" BIGINT,
  "city_public_open_space_aesculus" BIGINT,
  "city_public_open_space_ailanthus" BIGINT,
  "city_public_open_space_alnus" BIGINT,
  "city_public_open_space_amelanchier" BIGINT,
  "city_public_open_space_aralia" BIGINT,
  "city_public_open_space_arbutus" BIGINT,
  "city_public_open_space_betula" BIGINT,
  "city_public_open_space_carpinus" BIGINT,
  "city_public_open_space_catalpa" BIGINT,
  "city_public_open_space_cedrus" BIGINT,
  "city_public_open_space_cercis" BIGINT,
  "city_public_open_space_chamaecyparis" BIGINT,
  "city_public_open_space_corylus" BIGINT,
  "city_public_open_space_cotinus" BIGINT,
  "city_public_open_space_cotoneaster" BIGINT,
  "city_public_open_space_crataegus" BIGINT,
  "city_public_open_space_cryptomeria" BIGINT,
  "city_public_open_space_cupressus" BIGINT,
  "city_public_open_space_davidia" BIGINT,
  "city_public_open_space_fagus" BIGINT,
  "city_public_open_space_ficus" BIGINT,
  "city_public_open_space_fraxinus" BIGINT,
  "city_public_open_space_gingko" BIGINT,
  "city_public_open_space_gledista" BIGINT,
  "city_public_open_space_ilex" BIGINT,
  "city_public_open_space_juglans" BIGINT,
  "city_public_open_space_koelreuteria" BIGINT
);

4c. Number Of Trees By Genus In Total Council Land

@ukgov.analysis_and_interpretation_of_tree_audit_for_cambridg_bb4e4073.n_4c_number_of_trees_by_genus_in_total_council_land
  • 61.07 KB
  • 15 rows
  • 72 columns
Loading...

CREATE TABLE n_4c_number_of_trees_by_genus_in_total_council_land (
  "wards" VARCHAR,
  "ons_codes" VARCHAR,
  "total_council_land_acer" BIGINT,
  "total_council_land_aesculus" BIGINT,
  "total_council_land_ailanthus" BIGINT,
  "total_council_land_alnus" BIGINT,
  "total_council_land_amelanchier" BIGINT,
  "total_council_land_aralia" BIGINT,
  "total_council_land_arbutus" BIGINT,
  "total_council_land_betula" BIGINT,
  "total_council_land_carpinus" BIGINT,
  "total_council_land_catalpa" BIGINT,
  "total_council_land_cedrus" BIGINT,
  "total_council_land_cercis" BIGINT,
  "total_council_land_chamaecyparis" BIGINT,
  "total_council_land_corylus" BIGINT,
  "total_council_land_cotinus" BIGINT,
  "total_council_land_cotoneaster" BIGINT,
  "total_council_land_crataegus" BIGINT,
  "total_council_land_cryptomeria" BIGINT,
  "total_council_land_cupressus" BIGINT,
  "total_council_land_davidia" BIGINT,
  "total_council_land_fagus" BIGINT,
  "total_council_land_ficus" BIGINT,
  "total_council_land_fraxinus" BIGINT,
  "total_council_land_gingko" BIGINT,
  "total_council_land_gledista" BIGINT,
  "total_council_land_ilex" BIGINT,
  "total_council_land_juglans" BIGINT,
  "total_council_land_koelreuteria" BIGINT,
  "total_council_land_laburnum" BIGINT,
  "total_council_land_larix" BIGINT,
  "total_council_land_ligustrum" BIGINT,
  "total_council_land_liquidambar" BIGINT,
  "total_council_land_liriodendron" BIGINT,
  "total_council_land_magnolia" BIGINT,
  "total_council_land_malus" BIGINT,
  "total_council_land_mespilus" BIGINT,
  "total_council_land_metasequioa" BIGINT,
  "total_council_land_morus" BIGINT,
  "total_council_land_nothofagus" BIGINT,
  "total_council_land_ostrya" BIGINT,
  "total_council_land_parrotia" BIGINT,
  "total_council_land_paulownia" BIGINT,
  "total_council_land_phillyrea" BIGINT,
  "total_council_land_picea" BIGINT,
  "total_council_land_pinus" BIGINT,
  "total_council_land_platanus" BIGINT,
  "total_council_land_populus" BIGINT,
  "total_council_land_prunus" BIGINT,
  "total_council_land_pseudotsuga" BIGINT,
  "total_council_land_pterocarya" BIGINT,
  "total_council_land_pyrus" BIGINT,
  "total_council_land_quercus" BIGINT,
  "total_council_land_rhus" BIGINT,
  "total_council_land_robinia" BIGINT,
  "total_council_land_salix" BIGINT,
  "total_council_land_sambucus" BIGINT,
  "total_council_land_sciadopteris" BIGINT,
  "total_council_land_sequoia" BIGINT,
  "total_council_land_sophora" BIGINT,
  "total_council_land_sorbus" BIGINT,
  "total_council_land_syringa" BIGINT,
  "total_council_land_tamarix" BIGINT,
  "total_council_land_taxus" BIGINT,
  "total_council_land_thuja" BIGINT,
  "total_council_land_tilia" BIGINT,
  "total_council_land_tsuga" BIGINT,
  "total_council_land_ulmus" BIGINT,
  "total_council_land_viburnum" BIGINT,
  "total_council_land_zelkova" BIGINT,
  "total_council_land_other" BIGINT
);

4e. Number Of Trees By Condition And Council Land-use

@ukgov.analysis_and_interpretation_of_tree_audit_for_cambridg_bb4e4073.n_4e_number_of_trees_by_condition_and_council_land_use
  • 18.56 KB
  • 15 rows
  • 22 columns
Loading...

CREATE TABLE n_4e_number_of_trees_by_condition_and_council_land_use (
  "wards" VARCHAR,
  "ons_codes" VARCHAR,
  "county_highways" BIGINT,
  "county_highways_1" BIGINT,
  "county_highways_2" BIGINT,
  "county_highways_3" BIGINT,
  "county_highways_4" BIGINT,
  "city_public_open_space" BIGINT,
  "city_public_open_space_1" BIGINT,
  "city_public_open_space_2" BIGINT,
  "city_public_open_space_3" BIGINT,
  "city_public_open_space_4" BIGINT,
  "city_council_other" BIGINT,
  "city_council_other_1" BIGINT,
  "city_council_other_2" BIGINT,
  "city_council_other_3" BIGINT,
  "city_council_other_4" BIGINT,
  "total_council_land" BIGINT,
  "total_council_land_1" BIGINT,
  "total_council_land_2" BIGINT,
  "total_council_land_3" BIGINT,
  "total_council_land_4" BIGINT
);

3d. Canopy Density (m2/ Ha) By Conservation Areas

@ukgov.analysis_and_interpretation_of_tree_audit_for_cambridg_bb4e4073.n_3d_canopy_density_m2_ha_by_conservation_areas
  • 2.71 KB
  • 12 rows
  • 2 columns
Loading...

CREATE TABLE n_3d_canopy_density_m2_ha_by_conservation_areas (
  "wards" VARCHAR,
  "conservation_areas_privately_owned" DOUBLE
);

4d. Number Of Trees By Family, By Ward And Council Land-use

@ukgov.analysis_and_interpretation_of_tree_audit_for_cambridg_bb4e4073.n_4d_number_of_trees_by_family_by_ward_and_council_land_use
  • 113.6 KB
  • 15 rows
  • 130 columns
Loading...

CREATE TABLE n_4d_number_of_trees_by_family_by_ward_and_council_land_use (
  "wards" VARCHAR,
  "ons_codes" VARCHAR,
  "county_highways_aceraceae" BIGINT,
  "county_highways_anacardiaceae" BIGINT,
  "county_highways_aquifoliaceae" BIGINT,
  "county_highways_araliaceae" BIGINT,
  "county_highways_betulaceae" BIGINT,
  "county_highways_bignoniaceae" BIGINT,
  "county_highways_caprifoliaceae" BIGINT,
  "county_highways_cupressaceae" BIGINT,
  "county_highways_ericaceae" BIGINT,
  "county_highways_fagaceae" BIGINT,
  "county_highways_gingkoaceae" BIGINT,
  "county_highways_hamamelidaceae" BIGINT,
  "county_highways_hippocastanaceae" BIGINT,
  "county_highways_juglandaceae" BIGINT,
  "county_highways_leguminosae" BIGINT,
  "county_highways_magnoliaceae" BIGINT,
  "county_highways_moraceae" BIGINT,
  "county_highways_nyssaceae" BIGINT,
  "county_highways_oleaceae" BIGINT,
  "county_highways_piceaceae" BIGINT,
  "county_highways_pinaceae" BIGINT,
  "county_highways_platanaceae" BIGINT,
  "county_highways_rosaceae" BIGINT,
  "county_highways_salicaceae" BIGINT,
  "county_highways_sapindaceae" BIGINT,
  "county_highways_scrophulariaceae" BIGINT,
  "county_highways_simaroubaceae" BIGINT,
  "county_highways_tamaricaceae" BIGINT,
  "county_highways_taxodiaceae" BIGINT,
  "county_highways_tiliaceae" BIGINT,
  "county_highways_ulmaceae" BIGINT,
  "county_highways_other" BIGINT,
  "city_public_open_space_aceraceae" BIGINT,
  "city_public_open_space_anacardiaceae" BIGINT,
  "city_public_open_space_aquifoliaceae" BIGINT,
  "city_public_open_space_araliaceae" BIGINT,
  "city_public_open_space_betulaceae" BIGINT,
  "city_public_open_space_bignoniaceae" BIGINT,
  "city_public_open_space_caprifoliaceae" BIGINT,
  "city_public_open_space_cupressaceae" BIGINT,
  "city_public_open_space_ericaceae" BIGINT,
  "city_public_open_space_fagaceae" BIGINT,
  "city_public_open_space_gingkoaceae" BIGINT,
  "city_public_open_space_hamamelidaceae" BIGINT,
  "city_public_open_space_hippocastanaceae" BIGINT,
  "city_public_open_space_juglandaceae" BIGINT,
  "city_public_open_space_leguminosae" BIGINT,
  "city_public_open_space_magnoliaceae" BIGINT,
  "city_public_open_space_moraceae" BIGINT,
  "city_public_open_space_nyssaceae" BIGINT,
  "city_public_open_space_oleaceae" BIGINT,
  "city_public_open_space_piceaceae" BIGINT,
  "city_public_open_space_pinaceae" BIGINT,
  "city_public_open_space_platanaceae" BIGINT,
  "city_public_open_space_rosaceae" BIGINT,
  "city_public_open_space_salicaceae" BIGINT,
  "city_public_open_space_sapindaceae" BIGINT,
  "city_public_open_space_scrophulariaceae" BIGINT,
  "city_public_open_space_simaroubaceae" BIGINT,
  "city_public_open_space_tamaricaceae" BIGINT,
  "city_public_open_space_taxodiaceae" BIGINT,
  "city_public_open_space_tiliaceae" BIGINT,
  "city_public_open_space_ulmaceae" BIGINT,
  "city_public_open_space_other" BIGINT,
  "city_council_other_aceraceae" BIGINT,
  "city_council_other_anacardiaceae" BIGINT,
  "city_council_other_aquifoliaceae" BIGINT,
  "city_council_other_araliaceae" BIGINT,
  "city_council_other_betulaceae" BIGINT,
  "city_council_other_bignoniaceae" BIGINT,
  "city_council_other_caprifoliaceae" BIGINT,
  "city_council_other_cupressaceae" BIGINT,
  "city_council_other_ericaceae" BIGINT,
  "city_council_other_fagaceae" BIGINT,
  "city_council_other_gingkoaceae" BIGINT,
  "city_council_other_hamamelidaceae" BIGINT,
  "city_council_other_hippocastanaceae" BIGINT,
  "city_council_other_juglandaceae" BIGINT,
  "city_council_other_leguminosae" BIGINT,
  "city_council_other_magnoliaceae" BIGINT,
  "city_council_other_moraceae" BIGINT,
  "city_council_other_nyssaceae" BIGINT,
  "city_council_other_oleaceae" BIGINT,
  "city_council_other_piceaceae" BIGINT,
  "city_council_other_pinaceae" BIGINT,
  "city_council_other_platanaceae" BIGINT,
  "city_council_other_rosaceae" BIGINT,
  "city_council_other_salicaceae" BIGINT,
  "city_council_other_sapindaceae" BIGINT,
  "city_council_other_scrophulariaceae" BIGINT,
  "city_council_other_simaroubaceae" BIGINT,
  "city_council_other_tamaricaceae" BIGINT,
  "city_council_other_taxodiaceae" BIGINT,
  "city_council_other_tiliaceae" BIGINT,
  "city_council_other_ulmaceae" BIGINT,
  "city_council_other_other" BIGINT,
  "total_council_land_aceraceae" BIGINT,
  "total_council_land_anacardiaceae" BIGINT
);

3b. Canopy Density (m2/ Ha) By Ward For Private Conservation Areas

@ukgov.analysis_and_interpretation_of_tree_audit_for_cambridg_bb4e4073.n_3b_canopy_density_m2_ha_by_ward_for_private_conserva_5195dc2e
  • 3.31 KB
  • 15 rows
  • 3 columns
Loading...

CREATE TABLE n_3b_canopy_density_m2_ha_by_ward_for_private_conserva_5195dc2e (
  "wards" VARCHAR,
  "ons_codes" VARCHAR,
  "conservation_areas_privately_owned" VARCHAR
);