UK Ramsar Sites by UK Government | Finance and Economics

About this Dataset

UK Ramsar Sites

Ramsar sites are wetlands of international importance designated under the Ramsar Convention. This dataset contains basic site details for all designated Ramsar sites within the UK and its Overseas Territories and Crown Dependencies. This contains the following columns. SITECODE NAME STATUS (always classified/designated) COUNTRY - Overseas Territory sites have code OT. UK Countries have first letter of name eg S for Scotland. AREA_GIS SITE_LENGTH LOCAL_AUTHORITY DESIG_DATE - date designated as Ramsar LATITUDE LONGITUDE X_COORDINATE - eastings based on GB grid Y_COORDINATE - northings based on GB grid GRID_REF ALTITUDE_MIN (in meters) ALTITUDE_MAX ALTITUDE_MEAN OVERVIEW JUSTIFICATION LOCATION - discription of location ECO_FEATURES - ecological features of interest on the site FLORA - noteworthy flora FAUNA - noteworthy fauna RESEARCH EDUCATION RECREATION REFERENCES EXTENSION_DATE - date site extended where applicable.
Publisher name: Joint Nature Conservation Committee
Last updated: 2024-09-14T19:07:22Z

Tables

UK-Ramsar-basic-site-data-201510

@ukgov.uk_ramsar_sites.uk_ramsar_basic_site_data_201510

679.88 KB
249 rows
30 columns


CREATE TABLE uk_ramsar_basic_site_data_201510 (
  "site" DOUBLE,
  "sitecode" VARCHAR,
  "name" VARCHAR,
  "status" VARCHAR,
  "country" VARCHAR,
  "area_gis" DOUBLE,
  "site_length" DOUBLE,
  "local_authority" VARCHAR,
  "desig_date" TIMESTAMP,
  "latitude" VARCHAR,
  "longitude" VARCHAR,
  "x_coordinate" DOUBLE,
  "y_coordinate" DOUBLE,
  "grid_ref" VARCHAR,
  "altitude_min" DOUBLE,
  "altitude_max" DOUBLE,
  "altitude_mean" DOUBLE,
  "overview" VARCHAR,
  "justification" VARCHAR,
  "location" VARCHAR,
  "eco_features" VARCHAR,
  "flora" VARCHAR,
  "fauna" VARCHAR,
  "research" VARCHAR,
  "education" VARCHAR,
  "recreation" VARCHAR,
  "references" VARCHAR,
  "extension_date" TIMESTAMP,
  "unnamed_28" VARCHAR,
  "unnamed_29" VARCHAR
);