Baselight
Sign In

Water Framework Directive Protected Area - Shellfish Waters

OpenDataNI

@ukgov.water_framework_directive_protected_area_shellfish_waters31

Table 1
@ukgov.water_framework_directive_protected_area_shellfish_waters31.table_1

  • 11.05 KB
  • 10 rows
  • 12 columns
objectid_1

OBJECTID 1

protected_area_code

Protected Area Code

member_state_code

Member State Code

name

Name

hyperlink

Hyperlink

river_basin_district_code

River Basin District Code

designation_date

Designation Date

begin_life

Begin Life

end_life

End Life

globalid

GlobalID

shape_area

Shape, Area

shape_length

Shape, Length

1UKGBNIPA2_40001PA2_40001Balls Point https://www.daera-ni.gov.uk/sites/default/files/publications/daera/shellfish-action-plans-2019-proof-2-lough-foyle.PDFUKGBNIIENWTue Nov 30 1999 00:00:00 GMT+0000 (Coordinated Universal Time)11/30/1999 12:00:00 AM1/1/2099 12:00:00 AMd8191fec-9165-4820-af91-e00495a0fac736555802.719726624338.2784467327
2UKGBNIPA2_40010PA2_40010Belfast Loughhttps://www.daera-ni.gov.uk/sites/default/files/publications/daera/shellfish-action-plans-2019-proof-1-belfast-lough.PDFUKGBNINEFri Jun 26 2009 00:00:00 GMT+0000 (Coordinated Universal Time)6/26/2009 12:00:00 AM1/1/2099 12:00:00 AMdd3e7b29-efe8-4f8c-ad7b-5d429988669368923647.865234438714.4531840275
3UKGBNIPA2_40011PA2_40011Carlingford Loughhttps://www.daera-ni.gov.uk/sites/default/files/publications/daera/shellfish-action-plans-2019-proof-1-carlingford-lough.PDFUKGBNIIENBFri Jun 26 2009 00:00:00 GMT+0000 (Coordinated Universal Time)6/26/2009 12:00:00 AM1/1/2099 12:00:00 AM7f70e9e3-77df-41f0-8cdf-34166b69486173362009.950683662814.2773819146
4UKGBNIPA2_40004PA2_40004Dundrum Bayhttps://www.daera-ni.gov.uk/sites/default/files/publications/daera/shellfish-action-plans-2019-proof-2-inner-dundrum-bay.PDFUKGBNINETue Nov 30 1999 00:00:00 GMT+0000 (Coordinated Universal Time)6/26/2009 12:00:00 AM1/1/2099 12:00:00 AMe8f4fdd8-c4b3-4ba5-a22f-ac5c12d357696522679.1967773413981.8545401833
5UKGBNIPA2_40012PA2_40012Killough Harbourhttps://www.daera-ni.gov.uk/sites/default/files/publications/daera/shellfish-action-plans-2019-proof-1-killough-harbour.PDFUKGBNINEFri Jun 26 2009 00:00:00 GMT+0000 (Coordinated Universal Time)6/26/2009 12:00:00 AM1/1/2099 12:00:00 AM876f32db-34b8-4def-8d61-a0c780c17142598879.253892.48391780842
6UKGBNIPA2_40006PA2_40006Longfield Bankhttps://www.daera-ni.gov.uk/sites/default/files/publications/daera/shellfish-action-plans-2019-proof-2-lough-foyle.PDFUKGBNIIENWTue Nov 30 1999 00:00:00 GMT+0000 (Coordinated Universal Time)6/26/2009 12:00:00 AM1/1/2099 12:00:00 AMe35f880c-5fe5-4478-8d58-e9aad1fd690641833711.604003932239.3676334652
7UKGBNIPA2_40005PA2_40005Larne Loughhttps://www.daera-ni.gov.uk/sites/default/files/publications/daera/shellfish-action-plans-2019-proof-2-larne-lough.PDFUKGBNINETue Nov 30 1999 00:00:00 GMT+0000 (Coordinated Universal Time)6/26/2009 12:00:00 AM1/1/2099 12:00:00 AM63050d01-d6a4-421d-809c-acf33e5113928003626.0039062522625.2960678308
8UKGBNIPA2_40007PA2_40007Marlfield Bayhttps://www.daera-ni.gov.uk/sites/default/files/publications/daera/shellfish-action-plans-2019-proof-2.PDFUKGBNINETue Nov 30 1999 00:00:00 GMT+0000 (Coordinated Universal Time)11/30/1999 12:00:00 AM1/1/2099 12:00:00 AM39bc7cab-0f26-4188-aa38-a06b00538d5310123527.318847716771.8070519636
9UKGBNIPA2_40009PA2_40009Skate Rockhttps://www.daera-ni.gov.uk/sites/default/files/publications/daera/shellfish-action-plans-2019-proof-2.PDFUKGBNINETue Nov 30 1999 00:00:00 GMT+0000 (Coordinated Universal Time)11/30/1999 12:00:00 AM1/1/2099 12:00:00 AM70ac5688-d7b7-4aae-a94c-f85d0ea4e9252306034.330566416298.49538169443
10UKGBNIPA2_40008PA2_40008Paddys Point & Reagh Bayhttps://www.daera-ni.gov.uk/sites/default/files/publications/daera/shellfish-action-plans-2019-proof-2.PDF UKGBNINETue Nov 30 1999 00:00:00 GMT+0000 (Coordinated Universal Time)6/26/2009 12:00:00 AM1/1/2099 12:00:00 AM1b411001-ce0b-45fa-befa-43758b18254e31641840.19970769217.2527060614

CREATE TABLE table_1 (
  "objectid_1" BIGINT,
  "protected_area_code" VARCHAR,
  "member_state_code" VARCHAR,
  "name" VARCHAR,
  "hyperlink" VARCHAR,
  "river_basin_district_code" VARCHAR,
  "designation_date" TIMESTAMP,
  "begin_life" VARCHAR,
  "end_life" VARCHAR,
  "globalid" VARCHAR,
  "shape_area" DOUBLE,
  "shape_length" DOUBLE
);

Share link

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