Combined Authorities (March 2017) Boundaries EN BFE

Office for National Statistics

@ukgov.combined_authorities_march_2017_boundaries_en_bfe

Table List

1 table(8.47 KB)

Table 1

@ukgov.combined_authorities_march_2017_boundaries_en_bfe.table_1

8.47 KB
9 rows
10 columns

objectid OBJECTID	cauth17cd CAUTH17CD	cauth17nm CAUTH17NM	bng_e BNG E	bng_n BNG N	long LONG	lat LAT	shape_area Shape, Area	shape_length Shape, Length	globalid GlobalID
1	E47000001	Greater Manchester	377940	401102	-2.33406997	53.50614929	1275981133.87283	248705.576852058	cd6b5a1b-f2b5-4227-a4b5-bb8ddf257bee
2	E47000002	Sheffield City Region	441052	398663	-1.38284004	53.48310852	1552093015.14674	251953.567489806	c4104fdd-8fac-4cd4-bad5-31923d777371
3	E47000003	West Yorkshire	418686	427238	-1.71817005	53.74119949	2029258660.00085	282889.605715552	dccddd82-4b90-453a-9f7f-73e3043bf3c9
4	E47000004	Liverpool City Region	344324	390164	-2.83892989	53.40534973	907892930.545425	295471.672868953	9b9d04f3-2053-48ba-aabd-e9453ff63a41
5	E47000005	North East	402553	577597	-1.96153998	55.09280014	7861634296.51723	694110.324456572	959eb009-a4cc-457a-ad90-f7209bc1c11f
6	E47000006	Tees Valley	436951	521739	-1.42972004	54.58951187	814092711.907074	252093.698398122	036d07a4-2e74-4948-91ac-8d7562685a07
7	E47000007	West Midlands	402507	289715	-1.96448004	52.50534058	901639657.611725	256429.945450814	53c15492-a086-45bd-be15-12dd5742e8c9
8	E47000008	Cambridgeshire and Peterborough	536856	271834	0.006854	52.32754898	3397445436.16909	428252.457577556	4dff9259-9254-4918-8f35-ef67d4782bb4
9	E47000009	West of England	366423	173496	-2.48466992	51.45943069	1123097295.10501	309358.358446978	fb195779-2383-4242-803d-ea08ec118f77


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