WFD River Water Bodies 2nd Cycle

OpenDataNI

@ukgov.wfd_river_water_bodies_2nd_cycle31

Table List

1 table(65.67 KB)

Table 1

@ukgov.wfd_river_water_bodies_2nd_cycle31.table_1

65.67 KB
450 rows
12 columns

objectid OBJECTID	identification_code Identification Code	water_body_name Water Body Name	water_body_type Water Body Type	area_km2 Area Km2	shape_star Shape STAr	shape_stle Shape STLe	shape_length SHAPE, Length	shape_area SHAPE, Area	globalid GlobalID	shape_area_2 Shape, Area 2	shape_length_2 Shape, Length 2
1	UKGBNI1NW363604083	Woodford River	riverWaterBody	23.16673	23166734.4805	51188.109838	51188.10983797	23166734.4801345	9ac3f49c-b949-47b6-8277-25ebd49308f4	23166734.4804535	51188.1098379612
2	UKGBNI1NW363604064	Termon River (Pettigoe)	riverWaterBody	29.57909	29579093.4069	52987.9134255	52987.91342555	29579093.406973	6fa43dbe-5add-49e8-8d54-939737a0354d	29579093.4069366	52987.9134255464
3	UKGBNI1NW363604066	Lacky River	riverWaterBody	48.49763	48497627.8104	55965.3342494	55965.33424943	48497627.8103866	4e701503-30c5-4572-b76d-793f5c6388a9	48497627.810379	55965.334249442
4	UKGBNI1NW010102056	Derg River (Legvin)	riverWaterBody	13.03293	13032930.3665	20243.8442651	20243.84426509	13032930.366534	47703057-6422-413f-a4c6-e7e2cc967e78	13032930.3665161	20243.8442650931
5	UKGBNI1NB030302234	Cloghmills Water	riverWaterBody	26.10417	26104170.1951	35416.3933431	35416.39334313	26104170.1950877	a02fb2d9-14f7-492d-be68-27437949e850	26104170.1951218	35416.3933431283
6	UKGBNI1NB030308244	River Main (Dunloy)	riverWaterBody	30.06194	30061935.5634	38483.7692804	38483.76928042	30061935.5631851	67047c72-9a10-4a04-8eb3-47db44d1c45e	30061935.5633774	38483.7692804099
7	UKGBNI1NB030302237	Skerry Water	riverWaterBody	11.77838	11778376.3466	22480.0547196	22480.05471962	11778376.3466451	ec954db3-04eb-4aaa-8cf5-1222b00a858b	11778376.3466415	22480.0547196123
8	UKGBNI1NB030302233	Glenravel Water	riverWaterBody	31.32757	31327567.5713	32491.3544219	32491.35442192	31327567.5713617	cf850102-e5be-408e-a7a2-595e627f06ca	31327567.5713272	32491.3544219162
9	UKGBNI1NB030308210	River Main (Glarryford)	riverWaterBody	25.26505	25265050.2652	35899.1798432	35899.17984321	25265050.2652431	1e692c3c-cc9a-456e-81de-5f7e9acc82bd	25265050.2652435	35899.1798432023
10	UKGBNI1NB030308211	Clogh River	riverWaterBody	65.32162	65321619.3455	67798.47537	67798.47537003	65321619.3454916	92d841cd-c428-467e-b077-2abddc49e9b5	65321619.3455353	67798.4753700301


CREATE TABLE table_1 (
  "objectid" BIGINT,
  "identification_code" VARCHAR,
  "water_body_name" VARCHAR,
  "water_body_type" VARCHAR,
  "area_km2" DOUBLE,
  "shape_star" DOUBLE,
  "shape_stle" DOUBLE,
  "shape_length" DOUBLE,
  "shape_area" DOUBLE,
  "globalid" VARCHAR,
  "shape_area_2" DOUBLE,
  "shape_length_2" DOUBLE
);