Bathing Waters Directive - Protected Areas

OpenDataNI

@ukgov.bathing_waters_directive_protected_areas5

Table List

1 table(13.5 KB)

Table 1

@ukgov.bathing_waters_directive_protected_areas5.table_1

13.5 KB
26 rows
14 columns

objectid_1 OBJECTID 1	name Name	protected_area_code Protected Area Code	member_state_code Member State Code	hyperlink Hyperlink	river_basin_district_code River Basin District Code	designation_date Designation Date	begin_life Begin Life	end_life End Life	centroid_x Centroid X	centroid_y Centroid Y	globalid GlobalID	shape_area Shape, Area	shape_length Shape, Length
1	PORTBALLINTRAE SALMON ROCK	UKGBNIPA3_20021	PA3_20021	https://www.daera-ni.gov.uk/articles/bathing-water-quality	UKGBNINE	2008	6/30/2008 12:00:00 AM	1/1/2099 12:00:00 AM	-6.5437777	55.22036122	891fdf40-c9c7-453e-aa2c-f80ebef44dd1	37317.0170898438	858.127979210633
2	BALLYCASTLE	UKGBNIPA3_20001	PA3_20001	https://www.daera-ni.gov.uk/articles/bathing-water-quality	UKGBNINE	1988	6/1/1988 12:00:00 AM	1/1/2099 12:00:00 AM	-6.22927328	55.2062804	cfed0184-b191-4bdb-9de4-8ece9c0540f5	895775.173339844	6013.91547733239
3	BROWNS BAY	UKGBNIPA3_20002	PA3_20002	https://www.daera-ni.gov.uk/articles/bathing-water-quality	UKGBNINE	1988	6/1/1988 12:00:00 AM	1/1/2099 12:00:00 AM	-5.76659345	54.85372583	c8c45e86-443e-46de-8873-4cb925e89556	426984.438964844	3246.70194733753
4	BALLYGALLEY	UKGBNIPA3_20004	PA3_20004	https://www.daera-ni.gov.uk/articles/bathing-water-quality	UKGBNINE	2006	6/1/2006 12:00:00 AM	1/1/2099 12:00:00 AM	-5.85701246	54.89993639	f304b68d-8871-44d9-b4d9-5b0e1a8b0842	199322.507324219	2457.27263646977
5	WATERFOOT	UKGBNIPA3_20005	PA3_20005	https://www.daera-ni.gov.uk/articles/bathing-water-quality	UKGBNINE	2006	6/1/2006 12:00:00 AM	1/1/2099 12:00:00 AM	-6.05245557	55.06055297	97c6f025-7d61-4d3e-90fb-866e069e4a98	646762.713378906	4461.09585954729
6	CRANFIELD	UKGBNIPA3_20008	PA3_20008	https://www.daera-ni.gov.uk/articles/bathing-water-quality	UKGBNIIENB	1988	6/1/1988 12:00:00 AM	1/1/2099 12:00:00 AM	-6.0727537	54.02843721	0473cd68-5764-485a-9c55-61709efe6bcf	786858.400390625	5481.63696314186
7	CASTLEROCK	UKGBNIPA3_20009	PA3_20009	https://www.daera-ni.gov.uk/articles/bathing-water-quality	UKGBNIIENW	1988	6/1/1988 12:00:00 AM	1/1/2099 12:00:00 AM	-6.78220181	55.16938504	eb816d00-b304-4999-8f84-27df6c01e372	639228.455566406	4306.92918515138
8	PORTSTEWART	UKGBNIPA3_20025	PA3_20025	https://www.daera-ni.gov.uk/articles/bathing-water-quality	UKGBNINE	1988	6/1/1988 12:00:00 AM	1/1/2099 12:00:00 AM	-6.74774516	55.17010776	ad48b038-d5c3-4059-b36b-d0ccf817b4f8	1698258.22607422	10573.2017048855
9	CRAWFORDSBURN	UKGBNIPA3_20013	PA3_20013	https://www.daera-ni.gov.uk/articles/bathing-water-quality	UKGBNINE	1988	6/1/1988 12:00:00 AM	1/1/2099 12:00:00 AM	-5.72427497	54.66959404	817eee0b-a405-4f60-b601-e269635ab66d	536308.654296875	3881.64799964951
10	HELENS BAY	UKGBNIPA3_20014	PA3_20014	https://www.daera-ni.gov.uk/articles/bathing-water-quality	UKGBNINE	1988	6/1/1988 12:00:00 AM	1/1/2099 12:00:00 AM	-5.73544795	54.67382061	fdb37c79-78ef-4e0d-a1fa-0d13731bbcbe	322255.013183594	2597.73626745377


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