Database Of Registered Common Land In England

CREATE TABLE biological_attributes_england_2000 (
  "commoncd" BIGINT,
  "county" VARCHAR,
  "number_of_commons_in_registers" VARCHAR,
  "registration_authority" VARCHAR,
  "district_former" VARCHAR  -- District (former),
  "details_of_fauna_where_available" VARCHAR  -- Details Of Fauna (where Available),
  "description_of_vegetation_phase1_habitats" VARCHAR  -- Description Of Vegetation (Phase1 Habitats),
  "observations_on_management_where_available" VARCHAR  -- Observations On Management (where Available)
);

CREATE TABLE biological_survey_england_2000 (
  "commoncd" BIGINT,
  "county" VARCHAR,
  "district" VARCHAR,
  "number_of_commons_in_registers" BIGINT,
  "registration_authority" VARCHAR,
  "vice_county_code_number" DOUBLE,
  "date_survey_visit" VARCHAR,
  "general_comments" VARCHAR,
  "summary_owners_statements" VARCHAR,
  "calculated_area_of_common_land_hectares" DOUBLE  -- Calculated Area Of Common Land (hectares),
  "additional_notes_from_registers" VARCHAR,
  "evidence_of_hay_making" VARCHAR,
  "evidence_of_cattle_grazing" VARCHAR,
  "evidence_of_coppicing" VARCHAR,
  "evidence_of_mowing" VARCHAR,
  "evidence_of_sheep_grazing" VARCHAR,
  "evidence_of_plantations" VARCHAR,
  "evidence_of_burning" VARCHAR,
  "evidence_of_horses" VARCHAR,
  "evidence_of_thinning" VARCHAR,
  "evidence_of_recreational_activities" VARCHAR,
  "evidence_of_rabbits" VARCHAR,
  "evidence_of_pollarding" VARCHAR,
  "evidence_of_fishing_activities" VARCHAR,
  "evidence_of_grouse" VARCHAR,
  "evidence_of_dumping_activities" VARCHAR,
  "field_survey_or_other_sources_consulted" VARCHAR,
  "evidence_of_flooding" VARCHAR,
  "evidence_of_scrub" VARCHAR,
  "evidence_of_flush" VARCHAR,
  "evidence_of_deadwood" VARCHAR,
  "evidence_of_trees" VARCHAR,
  "general_notes" VARCHAR,
  "evidence_of_fencing" VARCHAR,
  "evidence_of_gardens" VARCHAR,
  "evidence_of_rubbish_dumping" VARCHAR,
  "evidence_of_vehicular_damage" VARCHAR,
  "evidence_of_new_road_construction" VARCHAR,
  "evidence_of_encroachments" VARCHAR,
  "no_rights_recorded_in_registers" VARCHAR,
  "rights_of_pasture_recorded_in_registers" VARCHAR,
  "rights_to_graze_sheep_recorded_in_registers" VARCHAR,
  "rights_to_graze_cattle_recorded_in_registers" VARCHAR,
  "rights_to_graze_horses_and_or_ponies_recorded_in_registers" VARCHAR,
  "rights_for_other_livestock_recorded_in_registers" VARCHAR,
  "rights_of_estovers_recorded_in_registers" VARCHAR,
  "rights_of_piscary_recorded_in_registers" VARCHAR,
  "rights_of_pannage_recorded_in_registers" VARCHAR,
  "rights_of_turbary_recorded_in_registers" VARCHAR,
  "rights_of_common_in_the_soil_recorded_in_registers" VARCHAR,
  "other_types_of_rights_recorded_in_registers" VARCHAR
);

CREATE TABLE common_in_association_with_other_protected_areas (
  "commoncd" BIGINT,
  "registered_area_hectares" DOUBLE  -- Registered Area (hectares),
  "easting_co_ordinate" BIGINT,
  "northing_co_ordinate" BIGINT,
  "name_of_national_park" VARCHAR,
  "name_of_aonb" VARCHAR,
  "name_of_country_park" VARCHAR,
  "code_number_for_natural_areas" BIGINT,
  "name_of_natural_area" VARCHAR,
  "county_wildlife_trust" VARCHAR,
  "environmentally_sensitive_area" VARCHAR,
  "heritage_coast" VARCHAR,
  "local_nature_reserve" VARCHAR,
  "nature_conservation_review_site" VARCHAR,
  "national_nature_reserve" VARCHAR,
  "national_trust" VARCHAR,
  "other_conservation_sites" VARCHAR,
  "ramsar_site" VARCHAR,
  "rspb_site" VARCHAR,
  "special_protection_area" VARCHAR,
  "site_of_special_scientific_interest" VARCHAR
);

CREATE TABLE commons_register_england_2000 (
  "commoncd" BIGINT,
  "county" VARCHAR,
  "district_boroughregistration_number" VARCHAR,
  "number_of_commons_in_registers" BIGINT,
  "registration_authority" VARCHAR,
  "registered_area_in_hectares" DOUBLE,
  "os_1_50_000_sheet_number" BIGINT,
  "n_10km_grid_square" VARCHAR  -- 10km Grid Square,
  "easting" BIGINT,
  "northing" BIGINT,
  "common_land_name" VARCHAR,
  "parish" VARCHAR,
  "site" VARCHAR,
  "contiguous_register_unit" VARCHAR,
  "stock" VARCHAR,
  "other_rights" VARCHAR,
  "contiguous_common_land" VARCHAR,
  "min_contour" DOUBLE,
  "max_contour" DOUBLE,
  "median_elevation" DOUBLE,
  "date" VARCHAR,
  "unnamed_21" VARCHAR  -- Unnamed: 21
);

CREATE TABLE phase_1_for_each_common_land_england_2000 (
  "common_land_id" BIGINT,
  "county" VARCHAR,
  "registration_number" BIGINT,
  "area_in_hectares" DOUBLE,
  "east" BIGINT,
  "north" BIGINT,
  "a_woodland_and_scrub" DOUBLE,
  "a111_broad_leaved_semi_natural_woodland" DOUBLE,
  "a112_broad_leaved_plantation" DOUBLE,
  "a121_coniferous_semi_natural" DOUBLE,
  "a122_coniferous_plantation" DOUBLE,
  "a131_mixed_semi_natural" DOUBLE,
  "a132_mixed_plantation" DOUBLE,
  "a21_dense_scrub" DOUBLE,
  "a22_scattered_scrub" DOUBLE,
  "a3_parkland_scattered_trees" DOUBLE,
  "a31" DOUBLE,
  "a32" DOUBLE,
  "a33" DOUBLE,
  "a4_recently_felled" DOUBLE,
  "a41" DOUBLE,
  "a42" DOUBLE,
  "a43" DOUBLE,
  "aa3" DOUBLE,
  "aa4" DOUBLE,
  "b_grassland_and_marsh" DOUBLE,
  "b11_acidic_grassland_unimproved" DOUBLE  -- B11 Acidic Grassland : Unimproved,
  "b12_acidic_grassland_semi_improved" DOUBLE  -- B12 Acidic Grassland : Semi-improved,
  "b21_neutral_grassland_unimproved" DOUBLE  -- B21 Neutral Grassland : Unimproved,
  "b22_neutral_grassland_semi_improved" DOUBLE  -- B22 Neutral Grassland : Semi-Improved,
  "b31_calcareous_grassland_unimproved" DOUBLE,
  "b32_calcareous_grassland_semi_improved" DOUBLE,
  "b4_improved_grassland" DOUBLE,
  "b5_marsh_marshy_grassland" DOUBLE,
  "b6_poor_semi_improved_grassland" DOUBLE,
  "c_tall_herb_and_fern" DOUBLE,
  "c11_bracken_continuous" DOUBLE  -- C11 Bracken : Continuous,
  "c12_bracken_scattered" DOUBLE  -- C12 Bracken : Scattered,
  "c2" VARCHAR,
  "c22_upland_species_rich_ledges" DOUBLE,
  "c31_other_tall_ruderal" DOUBLE  -- C31 Other : Tall Ruderal,
  "c32_other_non_ruderal" DOUBLE  -- C32 Other : Non-ruderal,
  "d11_dry_dwarf_shrub_heath_acidic" DOUBLE  -- D11 Dry Dwarf Shrub Heath : Acidic,
  "d12_dry_dwarf_shrub_heath_basic" DOUBLE  -- D12 Dry Dwarf Shrub Heath : Basic,
  "d2_wet_dwarf_shrub_heath" DOUBLE,
  "d3_lichen_bryophyte_heath" DOUBLE,
  "d5_dry_heath_acidic_mosaic" DOUBLE,
  "d6_wet_heath_acidic_grassland_mosaic" DOUBLE,
  "e_mire" DOUBLE,
  "e161_blanket_bog" DOUBLE,
  "e162_raised_bog" DOUBLE,
  "e17_bog_wet_modified" DOUBLE  -- E17 Bog : Wet Modified,
  "e18_bog_dry_modified" DOUBLE  -- E18 Bog : Dry Modified,
  "e21_flush_spring_acid_neutral" DOUBLE  -- E21 Flush/Spring : Acid/Neutral,
  "e22_flush_spring_basic" DOUBLE  -- E22 Flush/Spring : Basic,
  "e23_flush_spring_bryophyte_dominant" DOUBLE,
  "e3" VARCHAR,
  "e31_fen_valley_mire" DOUBLE  -- E31 Fen : Valley Mire,
  "e32_fen_basin_mire" DOUBLE  -- E32 Fen : Basin Mire,
  "e33_fen_flood_plain" DOUBLE,
  "e4_bare_peat" DOUBLE,
  "f_swamp_marginal_habitats" DOUBLE  -- F Swamp & Marginal Habitats,
  "f1_swamp" DOUBLE,
  "f12" VARCHAR,
  "f21_marginal" DOUBLE,
  "f22_inundation" DOUBLE,
  "g_open_water" DOUBLE,
  "g1_standing_water" DOUBLE,
  "g11" DOUBLE,
  "g111" DOUBLE,
  "g112" DOUBLE,
  "g113" DOUBLE,
  "g115" DOUBLE,
  "g12" DOUBLE,
  "g121" DOUBLE,
  "g122" DOUBLE,
  "g123" DOUBLE,
  "g125" DOUBLE,
  "g13" DOUBLE,
  "g15" DOUBLE,
  "g16" DOUBLE,
  "g2_running_water" DOUBLE,
  "g21" DOUBLE,
  "g211" DOUBLE,
  "g22" DOUBLE,
  "g221" DOUBLE,
  "g222" DOUBLE,
  "g23" VARCHAR,
  "g24" VARCHAR,
  "g25" DOUBLE,
  "g26" DOUBLE,
  "garea_1" DOUBLE,
  "gg1" DOUBLE,
  "gg2" DOUBLE,
  "h_1_coastland" DOUBLE  -- H 1 Coastland ?,
  "h11_intertidal_mud_sand" DOUBLE,
  "h12_intertidal_shingle" DOUBLE,
  "h13_intertidal_rocks" DOUBLE,
  "h23_saltmarsh_dunes" DOUBLE  -- H23 Saltmarsh /Dunes,
  "h24_saltmarsh_plants" DOUBLE
);

CREATE TABLE phase_1_habitats_within_commons (
  "commoncd" BIGINT,
  "phase_1_habitat_code" VARCHAR,
  "description_of_phase_1_code" VARCHAR,
  "area_of_phase_1_habitat_in_hectares" DOUBLE,
  "type_of_protected_area" DOUBLE,
  "n__with_c1_designation" DOUBLE  -- With C1 Designation
);