Water Framework Directive 2nd Cycle Interim Status

OpenDataNI

@ukgov.water_framework_directive_2nd_cycle_interim_status5

Table List

1 table(82.07 KB)

Table 1

@ukgov.water_framework_directive_2nd_cycle_interim_status5.table_1

82.07 KB
496 rows
18 columns

objectid_12 OBJECTID 12	objectid_1 OBJECTID 1	objectid OBJECTID	localid LocalId	namespace Namespace	spzonetype SpZoneType	sizevalue SizeValue	shape_leng Shape Leng	shape_star Shape STAr	shape_stle Shape STLe	index Index	uk_cd UK CD	f2018_statu F2018 Statu	ruleid RuleID	override Override	globalid GlobalID	shape_area Shape, Area	shape_length Shape, Length
1	1	1	UKGBNI6NB020	Mourne Coast	coastalWaterBody	60.67319826	65075.1687926	60703038.4174	65075.1687926	479	UKGBNI6NB020	GOOD	2	System.Byte[]	ced4cf33-f8d8-421b-9cc5-ec6290d60c33	60703038.4174271	65075.1687925949
2	2	4	UKGBNI1NW363604083	Woodford River	riverWaterBody	23.16457975	51188.109838	23166734.4805	51188.109838	447	UKGBNI1NW363604083	GOOD	2	System.Byte[]	4605b49b-9c08-404f-af4f-d8fae7a4ccf0	23166734.4804535	51188.1098379612
3	3	5	UKGBNI1NW363604064	Termon River (Pettigoe)	riverWaterBody	29.57782351	52987.9134255	29579093.4069	52987.9134255	439	UKGBNI1NW363604064	GOOD	2	System.Byte[]	be532cb5-afa2-407e-82a2-243e985d1da1	29579093.4069366	52987.9134255464
4	4	7	UKGBNI1NW363604066	Lacky River	riverWaterBody	48.49140292	55965.3342494	48497627.8104	55965.3342494	440	UKGBNI1NW363604066	MODERATE	3	System.Byte[]	7570c921-c400-4a7e-ae0d-d2af23bb6ffe	48497627.810379	55965.334249442
5	5	8	UKGBNI1NW010102056	Derg River (Legvin)	riverWaterBody	13.03195524	20243.8442651	13032930.3665	20243.8442651	318	UKGBNI1NW010102056	MODERATE	3	System.Byte[]	f7d79832-fe65-4ad6-b01c-bd6c95e4d935	13032930.3665161	20243.8442650931
6	6	9	UKGBNI6NE040	Maiden Islands	coastalWaterBody	29.96760696	21594.6282612	29985200.7601	21594.6282612	484	UKGBNI6NE040	GOOD	2	System.Byte[]	4c34e78f-ba19-4940-aa6c-1116c88f7dd4	29985200.7600708	21594.6282612228
7	7	10	UKGBNI6NE010	North Coast	coastalWaterBody	88.59339583	115211.476162	88621700.3212	115211.476162	481	UKGBNI6NE010	GOOD	2	System.Byte[]	1756a589-b702-4d3c-a68b-b15fd282a439	88621700.3211899	115211.476161773
8	8	11	UKGBNI6NE030	North Channel	coastalWaterBody	141.83765224	159567.96071	141910033.792	159567.96071	483	UKGBNI6NE030	GOOD	2	System.Byte[]	91b7e6a7-ccf9-48b2-b37d-9eea8717a7d4	141910033.791916	159567.960709562
9	9	12	UKGBNI6NE050	Larne Lough North	coastalWaterBody	1.28583273	10001.6784697	1286550.22058	10001.6784697	485	UKGBNI6NE050	MEP	7	System.Byte[]	8554eccd-05eb-4837-8bc7-f975ef5932fd	1286550.22058105	10001.6784696694
10	10	13	UKGBNI6NE060	Larne Lough Mid	coastalWaterBody	6.5193797	11603.6768265	6523088.24435	11603.6768265	486	UKGBNI6NE060	MODERATE	3	System.Byte[]	f406b1ba-c5bb-4361-beea-f8ccbbb0d022	6523088.24434662	11603.6768265212


CREATE TABLE table_1 (
  "objectid_12" BIGINT,
  "objectid_1" BIGINT,
  "objectid" BIGINT,
  "localid" VARCHAR,
  "namespace" VARCHAR,
  "spzonetype" VARCHAR,
  "sizevalue" DOUBLE,
  "shape_leng" DOUBLE,
  "shape_star" DOUBLE,
  "shape_stle" DOUBLE,
  "index" BIGINT,
  "uk_cd" VARCHAR,
  "f2018_statu" VARCHAR,
  "ruleid" BIGINT,
  "override" VARCHAR,
  "globalid" VARCHAR,
  "shape_area" DOUBLE,
  "shape_length" DOUBLE
);