STP (Feb 2017) Generalised Clipped Boundaries In England

Office for National Statistics

@ukgov.stp_feb_2017_generalised_clipped_boundaries_in_england

Table List

1 table(12.49 KB)

Table 1

@ukgov.stp_feb_2017_generalised_clipped_boundaries_in_england.table_1

12.49 KB
44 rows
10 columns

objectid OBJECTID	stp17cd Stp17cd	stp17nm Stp17nm	bng_e Bng E	bng_n Bng N	long Long	lat LAT	shape_area Shape, Area	shape_length Shape, Length	globalid GlobalID
1	E54000005	West Yorkshire	411733	442600	-1.82300997	53.87950134	4378684300.71144	436670.436100621	dc1e8b6e-d504-4d59-9a3d-46c51c00c93b
2	E54000006	Humber, Coast and Vale	492430	462485	-0.58972001	54.05009842	6504402579.57011	1094523.76594043	f1a1e909-5962-4e0c-b537-31a0dee8dac8
3	E54000007	Greater Manchester	383161	401102	-2.25535011	53.50640106	1402014904.63066	252276.294863881	3624d625-4256-4710-a76b-4c6778283d62
4	E54000008	Cheshire and Merseyside	374405	380936	-2.38572001	53.3246994	2987664965.31345	600821.030869921	992cee9f-22fc-4d70-8206-19013d63c6d8
5	E54000009	South Yorkshire and Bassetlaw	447764	393041	-1.28255999	53.43199921	2189405536.21901	355238.438388387	7bca9088-1da5-4395-8649-487ff645abf0
6	E54000010	Staffordshire	398243	334651	-2.02756	52.90930176	2716723279.21507	425675.990232556	5f196a14-82d7-409b-8f76-874b086b8943
7	E54000011	Shropshire and Telford and Wrekin	350226	302960	-2.73668003	52.62210083	3487673955.42449	479479.632394605	58c5b3a5-b5bb-4289-a85a-0fe6a5f83590
8	E54000012	Derbyshire	426752	353558	-1.60210001	53.07860184	2502756290.98907	385881.437936832	aed9dc22-ccc7-4c4f-9dc8-c3b5986b6cf7
9	E54000013	Lincolnshire	517985	358542	-0.23882	53.11100006	5937095478.52623	702200.216937734	d4d2531f-d8e6-4ca5-b94d-2a193fa0230f
10	E54000014	Nottinghamshire	466571	348422	-1.00882995	53.02899933	1521492077.11179	242148.557985086	e47a94f7-75bc-42ef-89c0-0acbf1982814


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