Combined Authorities (March 2017) Boundaries EN BGC

Office for National Statistics

@ukgov.combined_authorities_march_2017_boundaries_en_bgc

Table List

1 table(8.48 KB)

Table 1

@ukgov.combined_authorities_march_2017_boundaries_en_bgc.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	1275916502.73192	242513.080214229	f0b73842-d97b-4cf5-be12-1a21f1c68f28
2	E47000002	Sheffield City Region	441052	398663	-1.38284004	53.48310852	1551480881.8644	281514.406565744	21862c91-e141-47c1-955f-391855cd5918
3	E47000003	West Yorkshire	418686	427238	-1.71817005	53.74119949	2029285981.66772	278440.252221398	ee78e2e8-5748-48db-b99f-2caf3bf2a7c4
4	E47000004	Liverpool City Region	344324	390164	-2.83892989	53.40534973	725886772.923325	312479.354291226	d14e8a05-4117-4275-bf18-be816b784deb
5	E47000005	North East	402553	577597	-1.96153998	55.09280014	7797780478.81902	815132.481078973	93584fe3-16a7-4c24-a50c-3f6800c95ee9
6	E47000006	Tees Valley	436951	521739	-1.42972004	54.58951187	794734328.623825	314878.763960957	25e0da78-fc0b-4a1b-bcbe-2ec4fa540cf3
7	E47000007	West Midlands	402507	289715	-1.96448004	52.50534058	901639673.439377	251137.796285273	29b1b357-769d-4c1d-815f-2df49ba17ca9
8	E47000008	Cambridgeshire and Peterborough	536856	271834	0.006854	52.32754898	3396178995.15849	522822.496975156	f0c12703-1430-45a2-b340-5a081bcd5f66
9	E47000009	West of England	366423	173496	-2.48466992	51.45943069	957807721.124401	257988.57077181	b7afe0db-7fc7-47c0-9902-9ac049aacbc7


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