Surface Drinking Water Protected Areas

OpenDataNI

@ukgov.surface_drinking_water_protected_areas5

Table List

1 table(12.5 KB)

Table 1

@ukgov.surface_drinking_water_protected_areas5.table_1

12.5 KB
26 rows
14 columns

objectid_1 OBJECTID 1	objectid OBJECTID	thematic_id Thematic ID	area_name Area Name	desigbegin DesigBegin	desigend DesigEnd	zonetype ZoneType	sizevalue SizeValue	sizeuom SizeUoM	globalid GlobalID	shape_area_2 Shape, Area 2	shape_length_2 Shape, Length 2
1	13	UKGBNIPA1_10024	Foffany (Neagh Bann RBD)	2/1/2016 12:00:00 AM	1/1/2099 12:00:00 AM	drinkingWaterProtectionArea	20.4643387160198	km2	03c03b75-8e2f-4acc-bc7f-3a498d42cec2	20464338.6694412	30205.2826358505
2	12	UKGBNIPA1_10022	Dungonnel (Neagh Bann RBD)	2/1/2016 12:00:00 AM	1/1/2099 12:00:00 AM	drinkingWaterProtectionArea	31.3275673032827	km2	ff83c305-c686-4872-8f30-679cffe389fc	31327567.5713272	32491.3544219162
3	16	UKGBNIPA1_10027	Killylane	2/1/2016 12:00:00 AM	1/1/2099 12:00:00 AM	drinkingWaterProtectionArea	47.8898480963446	km2	94fdeb86-301c-4607-a455-c5f4c0b7fe6f	47889848.1336288	38976.6199256066
4	2	UKGBNIPA1_10012	Ballinrees	2/1/2016 12:00:00 AM	1/1/2099 12:00:00 AM	drinkingWaterProtectionArea	142.245180280536	km2	7378f63f-9f90-4781-8286-2b882f9ef75c	142245180.977036	136034.639642003
5	26	UKGBNIPA1_10037	Seaghan	2/1/2016 12:00:00 AM	1/1/2099 12:00:00 AM	drinkingWaterProtectionArea	28.6386191678847	km2	216f6387-d1c1-4783-b8f7-91f39fe6b1cc	28638619.3003006	40787.4469674053
6	8	UKGBNIPA1_10018	Derg/Strule (Newtownstewart, Bunderg)	2/1/2016 12:00:00 AM	1/1/2099 12:00:00 AM	drinkingWaterProtectionArea	145.660149118798	km2	bd61b920-004e-455d-99db-352aa3f3e55e	145660149.259659	149540.537977173
7	24	UKGBNIPA1_10035	Loughmacrory	2/1/2016 12:00:00 AM	1/1/2099 12:00:00 AM	drinkingWaterProtectionArea	64.9322927715327	km2	df7268ef-53ef-4c75-8b2c-2e9a1e14db38	64932292.9165039	50951.5154115031
8	17	UKGBNIPA1_10028	Lough Bradan	2/1/2016 12:00:00 AM	1/1/2099 12:00:00 AM	drinkingWaterProtectionArea	82.6318177825934	km2	afac852a-9334-4ee5-83ec-012b9b174a3f	82631817.3482971	97982.9084861611
9	15	UKGBNIPA1_10026	Glenhordial	2/1/2016 12:00:00 AM	1/1/2099 12:00:00 AM	drinkingWaterProtectionArea	70.0784707477642	km2	958ed095-12e8-4346-87de-ddbb051ba83f	70078470.918541	69001.9277851977
10	11	UKGBNIPA1_10023	Dungonnel (North Eastern RBD)	2/1/2016 12:00:00 AM	1/1/2099 12:00:00 AM	drinkingWaterProtectionArea	12.0872116218626	km2	29b42170-8b5d-48f2-8da7-4f82496b419b	12087211.5687485	19806.9498817281


CREATE TABLE table_1 (
  "objectid_1" BIGINT,
  "objectid" BIGINT,
  "thematic_id" VARCHAR,
  "area_name" VARCHAR,
  "desigbegin" VARCHAR,
  "desigend" VARCHAR,
  "zonetype" VARCHAR,
  "sizevalue" DOUBLE,
  "sizeuom" VARCHAR,
  "shape_length" VARCHAR,
  "shape_area" VARCHAR,
  "globalid" VARCHAR,
  "shape_area_2" DOUBLE,
  "shape_length_2" DOUBLE
);