Groundwater Drinking Water Protected Areas (DWPA's)

OpenDataNI

@ukgov.groundwater_drinking_water_protected_areas_dwpas5

Table List

1 table(16.42 KB)

Table 1

@ukgov.groundwater_drinking_water_protected_areas_dwpas5.table_1

16.42 KB
66 rows
14 columns

objectid_1 OBJECTID 1	objectid OBJECTID	localid LocalId	namespace Namespace	beginlife BeginLife	endlife EndLife	zonetype ZoneType	sizevalue SizeValue	sizeuom SizeUoM	globalid GlobalID	shape_area_2 Shape, Area 2	shape_length_2 Shape, Length 2
1	1	UKGBNIPA1_30001	Coleraine Kilrea	10/27/2006 12:00:00 AM	1/1/2099 12:00:00 AM	drinkingWaterProtectionArea	916.468923	km2	5a61612a-7342-4b9a-9130-3e6794e8e855	916468924.884888	278257.182609824
2	2	UKGBNIPA1_30002	Ballymena	3/1/2016 12:00:00 AM	1/1/2099 12:00:00 AM	drinkingWaterProtectionArea	776.079365	km2	244f1d77-a7ce-4bc0-927b-2380e1b0526f	797615820.225121	230419.694901137
3	3	UKGBNIPA1_30003	Cookstown	3/1/2016 12:00:00 AM	1/1/2099 12:00:00 AM	drinkingWaterProtectionArea	831.493372	km2	121ceb95-d00e-4ca6-ba73-f12ae30d4d71	831493373.49646	320783.466528031
4	4	UKGBNIPA1_30004	Moneymore	3/1/2016 12:00:00 AM	1/1/2099 12:00:00 AM	drinkingWaterProtectionArea	69.751095	km2	3a80a57a-7198-42f1-a8db-2d2907ec17cd	69751094.5230942	81690.2069947044
5	5	UKGBNIPA1_30005	Antrim	3/1/2016 12:00:00 AM	1/1/2099 12:00:00 AM	drinkingWaterProtectionArea	663.060966	km2	ab7ab4ba-d640-4817-964a-dd2df51fe335	663060966.701988	253180.104733069
6	6	UKGBNIPA1_30006	Moygashel	3/1/2016 12:00:00 AM	1/1/2099 12:00:00 AM	drinkingWaterProtectionArea	150.556421	km2	ed9d0074-5748-40dc-97fc-2128a23154bf	150556421.224487	95082.151234638
7	7	UKGBNIPA1_30007	Aughnacloy	10/27/2006 12:00:00 AM	1/1/2099 12:00:00 AM	drinkingWaterProtectionArea	633.722179	km2	e7d81bdd-412c-438e-a693-0dc9e8acdcad	633722179.907257	295945.896475399
8	8	UKGBNIPA1_30008	Tandragee	10/27/2006 12:00:00 AM	1/1/2099 12:00:00 AM	drinkingWaterProtectionArea	591.81461	km2	ea13673a-af8e-492b-90e6-d88edce97fba	591814611.176926	285262.799386463
9	9	UKGBNIPA1_30009	Newry	10/27/2006 12:00:00 AM	1/1/2099 12:00:00 AM	drinkingWaterProtectionArea	416.119939	km2	ecfce7e3-c1cf-4ab9-bf5c-eb6d18538213	416119940.485367	189096.533539779
10	10	UKGBNIPA1_30010	Keady	10/27/2006 12:00:00 AM	1/1/2099 12:00:00 AM	drinkingWaterProtectionArea	208.551565	km2	b5882ffc-db3a-4f31-8c96-5e1c15b0ed0d	208551565.482658	103769.512598316


CREATE TABLE table_1 (
  "objectid_1" BIGINT,
  "objectid" BIGINT,
  "localid" VARCHAR,
  "namespace" VARCHAR,
  "beginlife" VARCHAR,
  "endlife" VARCHAR,
  "zonetype" VARCHAR,
  "sizevalue" DOUBLE,
  "sizeuom" VARCHAR,
  "shape_length" VARCHAR,
  "shape_area" VARCHAR,
  "globalid" VARCHAR,
  "shape_area_2" DOUBLE,
  "shape_length_2" DOUBLE
);