Surface Water Bodies Status 2015

OpenDataNI

@ukgov.surface_water_bodies_status_201531

Table List

1 table(67.24 KB)

Table 1

@ukgov.surface_water_bodies_status_201531.table_1

67.24 KB
496 rows
15 columns

objectid_1 OBJECTID 1	objectid OBJECTID	localid LocalId	namespace Namespace	spzonetype SpZoneType	sizevalue SizeValue	shape_leng Shape Leng	area_km2 Area Km2	stat_2015 Stat 2015	obj_2021 Obj 2021	ruleid RuleID	override Override	globalid GlobalID	shape_area Shape, Area	shape_length Shape, Length
1	1	UKGBNI6NB020	Mourne Coast	coastalWaterBody	60.67319826	65075.1687926	60.703038	MODERATE	GOOD	3	System.Byte[]	30fdb108-fb2e-42ad-b6af-cf01587e8e04	60703038.4174271	65075.1687925949
2	4	UKGBNI1NW363604083	Woodford River	riverWaterBody	23.16457975	51188.109838	23.166734	HIGH	HIGH	1	System.Byte[]	a352b5df-b7c9-4abc-ba52-1ed1d097ef9f	23166734.4804535	51188.1098379612
3	5	UKGBNI1NW363604064	Termon River (Pettigoe)	riverWaterBody	29.57782351	52987.9134255	29.580053	MODERATE	GOOD	3	System.Byte[]	c24a10f6-20ea-43c8-ae45-9ffeb4ec5a1f	29579093.4069366	52987.9134255464
4	7	UKGBNI1NW363604066	Lacky River	riverWaterBody	48.49140292	55965.3342494	48.497628	MODERATE	GOOD	3	System.Byte[]	d6754f31-f745-4612-90e4-611238c05ca5	48497627.810379	55965.334249442
5	8	UKGBNI1NW010102056	Derg River (Legvin)	riverWaterBody	13.03195524	20243.8442651	13.03293	MODERATE	GOOD	3	System.Byte[]	f35c5e87-6a35-4ae9-92c9-e8df1ed9cf64	13032930.3665161	20243.8442650931
6	9	UKGBNI6NE040	Maiden Islands	coastalWaterBody	29.96760696	21594.6282612	29.985201	HIGH	HIGH	1	System.Byte[]	05563f5d-b752-41b5-82b1-e9220f8cfbc6	29985200.7600708	21594.6282612228
7	10	UKGBNI6NE010	North Coast	coastalWaterBody	88.59339583	115211.476162	88.6217	MODERATE	GOOD	3	System.Byte[]	05e3f800-5e3f-456b-82cc-4235b517f236	88621700.3211899	115211.476161773
8	11	UKGBNI6NE030	North Channel	coastalWaterBody	141.83765224	159567.96071	141.910034	GOOD	GOOD	2	System.Byte[]	54544efe-01d9-4b07-ba22-c5510c9cfb74	141910033.791916	159567.960709562
9	12	UKGBNI6NE050	Larne Lough North	coastalWaterBody	1.28583273	10001.6784697	1.28655	MEP	GEP	7	System.Byte[]	0c9b259a-8406-4849-a922-4f4bbcd07cb3	1286550.22058105	10001.6784696694
10	13	UKGBNI6NE060	Larne Lough Mid	coastalWaterBody	6.5193797	11603.6768265	6.523088	MODERATE	GOOD	3	System.Byte[]	66f0240f-5732-4241-8631-ddb5ee23ab57	6523088.24434662	11603.6768265212


CREATE TABLE table_1 (
  "objectid_1" BIGINT,
  "objectid" BIGINT,
  "localid" VARCHAR,
  "namespace" VARCHAR,
  "spzonetype" VARCHAR,
  "sizevalue" DOUBLE,
  "shape_leng" DOUBLE,
  "area_km2" DOUBLE,
  "stat_2015" VARCHAR,
  "obj_2021" VARCHAR,
  "ruleid" BIGINT,
  "override" VARCHAR,
  "globalid" VARCHAR,
  "shape_area" DOUBLE,
  "shape_length" DOUBLE
);