Combined Authorities (March 2017) Boundaries EN BUC

Office for National Statistics

@ukgov.combined_authorities_march_2017_boundaries_en_buc

Table List

1 table(8.48 KB)

Table 1

@ukgov.combined_authorities_march_2017_boundaries_en_buc.table_1

8.48 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	1273598326.11227	206057.368353583	bf0c2fb1-5c9d-499c-9b42-705e2b21fad8
2	E47000002	Sheffield City Region	441052	398663	-1.38284004	53.48310852	1550439664.64723	213333.845468222	340fadbe-e816-4452-9675-c593bad27013
3	E47000003	West Yorkshire	418686	427238	-1.71817005	53.74119949	2029163316.89679	240199.026406699	26a998f2-f628-4c93-a1fd-3261fef5ac2a
4	E47000004	Liverpool City Region	344324	390164	-2.83892989	53.40534973	728396751.926147	244672.062205927	173d874e-37ea-4211-9d0c-6e277e449133
5	E47000005	North East	402553	577597	-1.96153998	55.09280014	7804859018.37575	549655.139649226	597564b8-5c5a-443d-bde3-36beb75be542
6	E47000006	Tees Valley	436951	521739	-1.42972004	54.58951187	803038098.934113	220103.507784359	838f504d-39f2-44bb-a005-471154fa022b
7	E47000007	West Midlands	402507	289715	-1.96448004	52.50534058	902348992.75824	206334.877425549	d01abbf8-dae8-4c08-8026-53c2d485623b
8	E47000008	Cambridgeshire and Peterborough	536856	271834	0.006854	52.32754898	3398163796.92032	369787.637768624	77fd51e1-1ad3-43ad-9481-e33210c9c0a2
9	E47000009	West of England	366423	173496	-2.48466992	51.45943069	982177878.103298	183572.068138713	82001f0c-6e8e-40de-b15f-4cb19bb63e3a


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