Agricultural Critical Risk Areas

OpenDataNI

@ukgov.agricultural_critical_risk_areas5

Table List

1 table(17.29 MB)

Table 1

@ukgov.agricultural_critical_risk_areas5.table_1

17.29 MB
172265 rows
22 columns

objectid OBJECTID	land_use Land Use	shape_area Shape Area	shape_lenght Shape Lenght	hydrologically_connected Hydrologically Connected	rainfall_score Rainfall Score	slope_score Slope Score	soilp_score SoilP Score	q10_score Q10 Score	river_buffer_score River Buffer Score	rwb_2015_status_score RWB 2015 Status Score	erosion_score Erosion Score	risk_score Risk Score	ruleid RuleID	override Override	shape_length SHAPE, Length	shape_area_ff76ca SHAPE, Area	globalid GlobalID	shape_area_2 Shape, Area 2	shape_length_2 Shape, Length 2
1	Arable and horticulture	63695.1500957	1254.83350361	Yes	0.1	0.05	0.3	0.3				0.75	1	System.Byte[]	1254.83350361	63695.15070595	afbb3e2a-df25-4a23-8a7b-d0e995ac6a6c	63695.1507110596	1254.83350360768
2	Arable and horticulture	155836.755583	2616.62084579	Yes	0.1	0.15	0.3	0.3	0.3			1.15	2	System.Byte[]	2616.62084579	155836.7557082	169cd584-25a4-46cc-9a07-61e9544ac3d3	155836.755706787	2616.62084578501
3	Arable and horticulture	90309.1439421	1470.59230567	Yes	0.1	0.15	0.3		0.3	0.2	0.2	1.25	2	System.Byte[]	1470.59230567	90309.14344622	7f481dc5-6494-4e9b-8bed-6d89b7d0f379	90309.1434326172	1470.59230567351
4	Arable and horticulture	109736.216445	1751.86609808	Yes	0.05	0.1	0.3	0.3	0.3	0.2		1.25	2	System.Byte[]	1751.86609808	109736.21728409	7aded0db-1f73-4fcc-af83-c6c3cf839b15	109736.217300415	1751.86609808012
5	Arable and horticulture	116909.747101	1869.42456012	Yes	0.05	0.1	0.3	0.3	0.3	0.1		1.15	2	System.Byte[]	1869.42456012	116909.74540169	50132661-e8c3-4941-a01b-b220d46d326a	116909.745384216	1869.42456012373
6	Arable and horticulture	139214.650228	3180.00843915	Yes	0.1	0.15	0.2	0.3	0.3	0.3		1.35	2	System.Byte[]	3180.00843915	139214.65391186	2f8cda13-9506-46a1-a44b-95222656f1a7	139214.653923035	3180.00843914996
7	Arable and horticulture	76178.4425327	1122.87815277	Yes	0.1	0.15	0.3			0.1		0.65	1	System.Byte[]	1122.87815277	76178.44317045	7dde9067-95a4-4627-98a7-42bf5074dc7c	76178.4431686401	1122.87815277288
8	Arable and horticulture	48690.7046536	967.87954452	Yes	0.1	0.1	0.3			0.2		0.7	1	System.Byte[]	967.87954452	48690.70487288	b655cc69-3db3-4ec8-b62f-6d5858479c55	48690.704864502	967.879544520548
9	Arable and horticulture	37022.0547491	967.47199123	Yes	0.1	0.1	0.3			0.2		0.7	1	System.Byte[]	967.47199122	37022.05479324	36ddf9c1-c05a-41d6-83db-335362000c47	37022.0548095703	967.471991224737
10	Arable and horticulture	41308.5692131	898.69733755	Yes	0.1	0.1	0.3	0.3	0.3	0.1		1.2	2	System.Byte[]	898.69733755	41308.56933157	2530fe85-f9ce-4aa9-b641-a1dc9136ad8b	41308.5693359375	898.697337547496


CREATE TABLE table_1 (
  "objectid" BIGINT,
  "land_use" VARCHAR,
  "shape_area" DOUBLE,
  "shape_lenght" DOUBLE,
  "hydrologically_connected" VARCHAR,
  "rainfall_score" DOUBLE,
  "slope_score" DOUBLE,
  "landclass_score" DOUBLE,
  "host_score" DOUBLE,
  "soilp_score" DOUBLE,
  "q10_score" DOUBLE,
  "river_buffer_score" DOUBLE,
  "rwb_2015_status_score" DOUBLE,
  "erosion_score" DOUBLE,
  "risk_score" DOUBLE,
  "ruleid" BIGINT,
  "override" VARCHAR,
  "shape_length" DOUBLE,
  "shape_area_ff76ca" DOUBLE,
  "globalid" VARCHAR,
  "shape_area_2" DOUBLE,
  "shape_length_2" DOUBLE
);