Combined Authorities (March 2017) Boundaries EN BSC

Office for National Statistics

@ukgov.combined_authorities_march_2017_boundaries_en_bsc

Table List

1 table(8.47 KB)

Table 1

@ukgov.combined_authorities_march_2017_boundaries_en_bsc.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	1275897947.38605	218582.613758037	521962c1-7c66-4fd1-bc5b-c46c922a7480
2	E47000002	Sheffield City Region	441052	398663	-1.38284004	53.48310852	1552231060.29016	228536.04906403	ea5d5c2b-a4ad-4e5a-9e95-726cc06f91df
3	E47000003	West Yorkshire	418686	427238	-1.71817005	53.74119949	2030532460.93398	259510.470555145	de5855e4-2072-45ba-9126-ed3ec68b7a75
4	E47000004	Liverpool City Region	344324	390164	-2.83892989	53.40534973	723672979.455452	276615.121602058	760bd5f8-5585-4f5e-865b-5a1067340a51
5	E47000005	North East	402553	577597	-1.96153998	55.09280014	7801700397.32629	664598.575749803	7a6703de-a456-4861-9735-676029705c97
6	E47000006	Tees Valley	436951	521739	-1.42972004	54.58951187	795173730.028168	273479.6461149	a59a3d3b-1bf0-43cc-97ab-9d0b218e30ef
7	E47000007	West Midlands	402507	289715	-1.96448004	52.50534058	900858099.192085	225620.965269894	e871415d-d075-471d-a587-77f30739a7a0
8	E47000008	Cambridgeshire and Peterborough	536856	271834	0.006854	52.32754898	3400325473.90472	392669.186683188	313fab00-2a58-43c6-8f45-9ad31568f279
9	E47000009	West of England	366423	173496	-2.48466992	51.45943069	957436603.780025	210253.49431006	d43c25f6-b3d0-481c-891a-7427ce4f95b1


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