Abstraction Licensing

OpenDataNI

@ukgov.abstraction_licensing3

Table List

1 table(91.72 KB)

Table 1

@ukgov.abstraction_licensing3.table_1

91.72 KB
853 rows
16 columns

x X	y Y	objectid OBJECTID	apprefno Apprefno	igr Igr	eastings Eastings	northings Northings	source Source	abstr_sour Abstr Sour	vol_perday Vol Perday	sectorid Sectorid	date_licen Date Licen	date_appli Date Appli	date_notif Date Notif	dataset_da Dataset Da	globalid GlobalID
226920	323286	5404	AIL/2007/0001	H2692023286	226920	323286	Groundwater	borehole	1500	Industrial	Thu Jun 23 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	Tue Feb 06 2007 00:00:00 GMT+0000 (Coordinated Universal Time)		Tue May 16 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	7292291d-f52b-4ab9-aec9-8b5b741a0ef5
227316	323427	5405	AIL/2007/0001	H2731623427	227316	323427	Groundwater	borehole	1500	Industrial	Thu Jun 23 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	Tue Feb 06 2007 00:00:00 GMT+0000 (Coordinated Universal Time)		Tue May 16 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	f9b80f2a-cb27-42f5-a04d-f82b15950e85
286103	431989	5406	AIL/2007/0002	C8610331989	286103	431989	Groundwater	Borehole	300	Industrial	Fri Oct 21 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	Thu Feb 08 2007 00:00:00 GMT+0000 (Coordinated Universal Time)		Tue May 16 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	9be97cbb-f1e7-4fcb-b088-1ecb22299ee8
286107	431968	5407	AIL/2007/0002	C8610731968	286107	431968	Groundwater	Borehole	300	Industrial	Fri Oct 21 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	Thu Feb 08 2007 00:00:00 GMT+0000 (Coordinated Universal Time)		Tue May 16 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	cdaba854-e636-4607-911c-df139b8b2f67
287700	344070	5408	AIL/2007/0003	H8770044070	287700	344070	Groundwater	borehole	15	Local Councils & Health Trusts		Mon Feb 12 2007 00:00:00 GMT+0000 (Coordinated Universal Time)	Wed Feb 14 2007 00:00:00 GMT+0000 (Coordinated Universal Time)	Tue May 16 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	0dd0ebfe-ffa1-4011-9240-7193ca6c1a01
336400	353700	5409	AIL/2007/0004	J3640053700	336400	353700	Groundwater	quarry sump	19	Quarrying/Mineral Washing		Mon Feb 12 2007 00:00:00 GMT+0000 (Coordinated Universal Time)	Tue Feb 13 2007 00:00:00 GMT+0000 (Coordinated Universal Time)	Tue May 16 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	1ed7d6bd-190f-453e-b50d-590793d08f78
293960	440380	5410	AIL/2007/0005	C9396040380	293960	440380	Surface water	watercourse	10000	Fish Farms & Hatcheries	Tue Oct 25 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri Feb 16 2007 00:00:00 GMT+0000 (Coordinated Universal Time)		Tue May 16 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	92909814-15a7-461c-8a2f-28708856fcaf
284396	362265	5411	AIL/2007/0006	H8439662265	284396	362265	Groundwater	groundwater	15	Agricultural-Livestock		Tue Feb 20 2007 00:00:00 GMT+0000 (Coordinated Universal Time)	Wed Feb 21 2007 00:00:00 GMT+0000 (Coordinated Universal Time)	Tue May 16 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	ac34025a-a09e-4ee8-a7e2-72a11bcd1e15
330130	382810	5412	AIL/2007/0007	J3013082810	330130	382810	Groundwater	Borehole	15	Industrial		Mon Feb 19 2007 00:00:00 GMT+0000 (Coordinated Universal Time)	Wed Feb 21 2007 00:00:00 GMT+0000 (Coordinated Universal Time)	Tue May 16 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	927a7425-cdfd-4e5a-8678-104ade161111
330130	383050	5413	AIL/2007/0007	J3013083050	330130	383050	Groundwater	Borehole	15	Industrial		Mon Feb 19 2007 00:00:00 GMT+0000 (Coordinated Universal Time)	Wed Feb 21 2007 00:00:00 GMT+0000 (Coordinated Universal Time)	Tue May 16 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	ea6f9d1f-1e4f-4e17-b2b6-0d0eef90049e


CREATE TABLE table_1 (
  "x" BIGINT,
  "y" BIGINT,
  "objectid" BIGINT,
  "apprefno" VARCHAR,
  "igr" VARCHAR,
  "eastings" BIGINT,
  "northings" BIGINT,
  "source" VARCHAR,
  "abstr_sour" VARCHAR,
  "vol_perday" BIGINT,
  "sectorid" VARCHAR,
  "date_licen" TIMESTAMP,
  "date_appli" TIMESTAMP,
  "date_notif" TIMESTAMP,
  "dataset_da" TIMESTAMP,
  "globalid" VARCHAR
);