Special Areas For Conservation (SAC) Basic Site Details
Joint Nature Conservation Committee
@ukgov.special_areas_for_conservation_sac_basic_site_details
Joint Nature Conservation Committee
@ukgov.special_areas_for_conservation_sac_basic_site_details
CREATE TABLE natura2000_tranche50_sacbasic (
"site_code" VARCHAR,
"site_name" VARCHAR,
"country_code" VARCHAR,
"zone" VARCHAR,
"is_marine" BIGINT,
"site_marine_area_of_site" DOUBLE,
"country_name" VARCHAR,
"local_authority" VARCHAR,
"site_area_ha" DOUBLE,
"site_length_km" DOUBLE,
"grid_reference" VARCHAR,
"site_latitude" DOUBLE,
"site_longitude" DOUBLE,
"easting" BIGINT,
"northing" BIGINT,
"designation_status_code" VARCHAR,
"site_comp_date" TIMESTAMP,
"site_sci_prop_date" TIMESTAMP,
"site_sci_conf_date" TIMESTAMP,
"site_sac_date" TIMESTAMP,
"site_quality" VARCHAR,
"site_characteristics" VARCHAR,
"designation_type_code" VARCHAR,
"site_sac_legal_ref" VARCHAR,
"site_explanations" VARCHAR
);
Anyone who has the link will be able to view this.