LEPNOP (Apr 2017) Generalised Clipped Boundaries In England

Office for National Statistics

@ukgov.lepnop_apr_2017_generalised_clipped_boundaries_in_england

Table List

1 table(9.73 KB)

Table 1

@ukgov.lepnop_apr_2017_generalised_clipped_boundaries_in_england.table_1

9.73 KB
18 rows
10 columns

objectid OBJECTID	lepnop17cd Lepnop17cd	lepnop17nm Lepnop17nm	bng_e Bng E	bng_n Bng N	long Long	lat Lat	shape_area Shape, Area	shape_length Shape, Length	globalid GlobalID
1	E53000001	Buckinghamshire Thames Valley (LEPNOP)	487650	193560	-0.73492998	51.63402939	662280737.217255	188899.465999907	64926e19-afba-46d7-be50-04f2ce64bb97
2	E53000002	Coast to Capital (LEPNOP)	510425	129072	-0.42596	51.05038071	2743414057.59912	555871.478185096	719e18be-5c98-4464-8767-9bd2d4876c75
3	E53000003	Derby, Derbyshire, Nottingham and Nottinghamshire (LEPNOP)	454359	342671	-1.19185996	52.97864914	2852912444.32462	546825.324937749	1e9ad770-5f0e-478c-ad52-83ed14cf842e
4	E53000004	Greater Birmingham and Solihull (LEPNOP)	412789	287491	-1.81308997	52.48519897	446041671.761841	149546.310180664	424e0a21-c45b-48c2-980a-6ef13f00811b
5	E53000005	Greater Cambridge and Greater Peterborough (LEPNOP)	536856	271834	0.006854	52.32754898	3789922421.54291	643104.924518265	1765254f-d4ef-4fc1-96e0-2e34a17ce5e3
6	E53000006	Greater Lincolnshire (LEPNOP)	517985	358543	-0.23882	53.11104965	5936968662.12613	707776.083969837	6439dd8b-87f9-46a5-843d-2ecac6939470
7	E53000007	Hertfordshire (LEPNOP)	518452	212531	-0.28362	51.79888916	1267630254.03857	284134.192868487	cd18a0a5-fa29-475a-9a66-90cf7cfe00c9
8	E53000008	Humber (LEPNOP)	511894	431716	-0.30379999	53.76979065	71455773.0755615	63330.2402773071	f183a59e-9edb-45b3-8260-9ba18e47c8df
9	E53000009	Leeds City Region (LEPNOP)	418686	427238	-1.71817005	53.74119949	2029285981.66772	278440.252221398	b66b9b46-c268-41ae-826e-77bc092cd1b5
10	E53000010	London (LEPNOP)	517606	178707	-0.30724001	51.49507904	1486962764.47104	423057.313384239	d1b77101-1131-42a3-b146-99c1f846c2a0


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