Baselight

Special Areas For Conservation (SAC) Basic Site Details

Joint Nature Conservation Committee

@ukgov.special_areas_for_conservation_sac_basic_site_details

Loading...
Loading...

About this Dataset

Special Areas For Conservation (SAC) Basic Site Details

Special Areas of Conservation (SACs) are strictly protected sites designated under the EC Habitats Directive. This dataset is derived from the UK wide data submitted to the EU Commmission in cumulative batches known as Tranches. A substantial update to these data was done as part of the Standard Data Form updating exercise on 22 December 2015 (Tranche 50) . It contains basic site details for each and every SAC - there is one row in the dataset for each individual site. The data here are for the following sections of the standard data form. Sections 1, 2 (except 2.5) + sections 4.2 (quality and importance) and 4.1 - site characteristics. Notes on specific columns: IS_MARINE This indicates that the site contains marine habitat (below high water) AND supports one or more qualifying marine species. The definitions of marine components are shown on the JNCC website. 0 = Not considered to be a Marine Protected Area 1= Marine Protected Area. DESIGNATION_STATUS_CODE cSAC = submitted to the EU as a candidate site but not yet adopted by the EU as an SCI SCI= Site of Community Importance - a status conferred by the EU Commission. SAC = Designated SAC. The final stage in the process SITE_COMP_DATE compilation data of original Standard Data Form SITE_SCI_PROP_DATE Date submitted to the EU as a candidate SAC. SITE_QUALITY this is extracted from Section 4.2 of the Standard Data Form. It is a statement of the qualify and importance of the site. All qualifying interest features are listed, with a qualifying phrase to justify the inclusion of each feature. Archived versions of this dataset are also available as part of a time series. These may be useful in determining how many sites there were at a given point of time, and also how some of the detailed information might have changed over time. Note that the data columns in this series of datasets were revised slightly in December 2015. Each archived version corresponds to a European submission. A record of the changes made at each submisison is shown here. http://jncc.defra.gov.uk/page-1488
Publisher name: Joint Nature Conservation Committee
Last updated: 2024-09-14T19:09:41Z

Tables

Natura2000-tranche50-SACbasic

@ukgov.special_areas_for_conservation_sac_basic_site_details.natura2000_tranche50_sacbasic
  • 132.09 KB
  • 652 rows
  • 25 columns
Loading...

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

Share link

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