STP (Apr 2020) Full Extent Boundaries In England

Office for National Statistics

@ukgov.stp_apr_2020_full_extent_boundaries_in_england

Table List

1 table(12.54 KB)

Table 1

@ukgov.stp_apr_2020_full_extent_boundaries_in_england.table_1

12.54 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	1402057510.69281	258431.704568869	1ff256e7-79d2-4a07-9991-0f2793b54ff9
2	E54000008	Cheshire and Merseyside	374405	380936	-2.38572	53.32473	3196448980.52466	478112.996706774	08c06aa2-711a-4ba9-b4e1-e3e818e388f6
3	E54000009	South Yorkshire and Bassetlaw	447764	393041	-1.28256	53.432011	2191616483.49821	321123.722006424	d8cf5bed-c1fc-4809-a217-3f5041c77c12
4	E54000010	Staffordshire and Stoke on Trent	398243	334651	-2.02756	52.909302	2716766581.59096	437360.146621383	4b516de8-2d1e-4cea-8e8b-91b960c31bb1
5	E54000011	Shropshire and Telford and Wrekin	350226	302960	-2.73668	52.62212	3487616586.65537	497026.935577437	de914fdb-dbbb-4c47-bcaf-1a834a10ee2a
6	E54000012	Joined Up Care Derbyshire	426752	353558	-1.6021	53.078602	2502707042.50641	398175.602142323	ca3c9b1b-ace5-48c5-b1bf-909b21bbd049
7	E54000013	Lincolnshire	517985	358542	-0.23882	53.111038	6106595229.45972	585298.884721731	2e0a35b8-947f-470f-9d4d-03302e1a56f1
8	E54000014	Nottingham and Nottinghamshire Health and Care	466571	348422	-1.00883	53.028969	1522012358.06198	242114.439951502	04acd845-1639-41a2-8db4-fad755462d47
9	E54000015	Leicester, Leicestershire and Rutland	466552	310188	-1.0169	52.685322	2550866048.00472	342565.518671311	0d155bd9-626e-43e1-82e3-952f4be948ad
10	E54000016	The Black Country and West Birmingham	397824	291641	-2.03349	52.522652	389855758.067337	139598.445712787	375a73d2-e4c8-456d-ace0-98fcb1c15579


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
);