STP (Apr 2020) Generalised Clipped Boundaries In England

Office for National Statistics

@ukgov.stp_apr_2020_generalised_clipped_boundaries_in_england

Table List

1 table(12.57 KB)

Table 1

@ukgov.stp_apr_2020_generalised_clipped_boundaries_in_england.table_1

12.57 KB
42 rows
10 columns

objectid OBJECTID	stp20cd STP20CD	stp20nm STP20NM	bng_e BNG E	bng_n BNG N	long LONG	lat LAT	shape_area Shape, Area	shape_length Shape, Length	globalid GlobalID
1	E54000007	Greater Manchester Health and Social Care Partnership	383161	401102	-2.25535	53.506351	1402014904.63066	252276.294863881	46c517b5-dbe1-4f8f-9838-cc18749592a0
2	E54000008	Cheshire and Merseyside	374405	380936	-2.38572	53.32473	2987865520.56804	594930.723866864	56ca1fd7-77b6-46af-9d33-141c306569b9
3	E54000009	South Yorkshire and Bassetlaw	447764	393041	-1.28256	53.432011	2189405536.21901	355238.438388387	2842bbc3-69e7-4bff-b622-500c66ebe3ff
4	E54000010	Staffordshire and Stoke on Trent	398243	334651	-2.02756	52.909302	2716723279.21507	425675.990232556	fd7685bc-63e6-4400-b7aa-9c5b32dc12a3
5	E54000011	Shropshire and Telford and Wrekin	350226	302960	-2.73668	52.62212	3487673955.42449	479479.632394605	f5a68bbd-e71a-4af8-8939-b75dc6456bd1
6	E54000012	Joined Up Care Derbyshire	426752	353558	-1.6021	53.078602	2502756290.98907	385881.437936832	eeb67819-84d4-4ccc-aaea-5eb20c8f948a
7	E54000013	Lincolnshire	517985	358542	-0.23882	53.111038	5920601875.14149	730634.838483717	7c2cec37-baac-4700-82a0-63e256fba194
8	E54000014	Nottingham and Nottinghamshire Health and Care	466571	348422	-1.00883	53.028969	1521492077.11179	242148.557985086	ae097e6b-be86-49ed-88ab-79a7cb927686
9	E54000015	Leicester, Leicestershire and Rutland	466552	310188	-1.0169	52.685322	2550908379.58192	331489.280332287	85b7e677-d9c2-4845-b185-f94abd8826b4
10	E54000016	The Black Country and West Birmingham	397824	291641	-2.03349	52.522652	389857597.697159	136065.859181892	67afb22b-d09e-4a3a-9958-213c0657a6d0


CREATE TABLE table_1 (
  "objectid" BIGINT,
  "stp20cd" VARCHAR,
  "stp20nm" VARCHAR,
  "bng_e" BIGINT,
  "bng_n" BIGINT,
  "long" DOUBLE,
  "lat" DOUBLE,
  "shape_area" DOUBLE,
  "shape_length" DOUBLE,
  "globalid" VARCHAR
);