Combined Authorities (December 2022) Boundaries EN BFC

Office for National Statistics

@ukgov.combined_authorities_december_2022_boundaries_en_bfc

Table List

1 table(8.53 KB)

Table 1

@ukgov.combined_authorities_december_2022_boundaries_en_bfc.table_1

8.53 KB
10 rows
10 columns

fid FID	cauth22cd CAUTH22CD	cauth22nm CAUTH22NM	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.33407	53.50615	1275981144.284	248689.705337219	c5674e59-255b-4a09-b899-3556de0ff936
2	E47000002	South Yorkshire	441052	398663	-1.38284	53.48311	1551548384.04128	287888.220891411	48ec2d3a-a9bd-4d73-b2dc-a36c614a027b
3	E47000003	West Yorkshire	418686	427238	-1.71817	53.7412	2029258521.09647	282884.856552968	46611bdd-275f-4b79-b9f9-fbb93c5590ed
4	E47000004	Liverpool City Region	344342	390164	-2.83866	53.40536	731278691.875908	389158.413072723	25301679-f70e-46fb-a771-7a148c02146b
5	E47000006	Tees Valley	436953	521739	-1.42968	54.58951	795078785.244064	329089.388033349	4daff102-aca2-455b-8540-66523eaacdc1
6	E47000007	West Midlands	402507	289715	-1.96448	52.50534	901639614.384499	256417.079090854	377531d4-89f3-4b96-9722-75f146825685
7	E47000008	Cambridgeshire and Peterborough	536856	271834	0.006854	52.32755	3395893069.41683	529543.02259421	86cecf97-8288-4ca1-a14d-134e4641404f
8	E47000009	West of England	366423	173496	-2.48467	51.45943	957838932.249435	264559.492540054	c05423cc-4ffe-4410-9c6a-cecfb90afa36
9	E47000010	North East	413490	537463	-1.79204	54.73197	2575628188.11502	378694.367373861	c6134585-fff4-4793-b3e5-2a9769ec3816
10	E47000011	North of Tyne	397235	600991	-2.0451	55.30301	5228065092.9863	618327.42315617	6be865cc-df47-4233-9849-6f28f5e1eddd


CREATE TABLE table_1 (
  "fid" BIGINT,
  "cauth22cd" VARCHAR,
  "cauth22nm" VARCHAR,
  "bng_e" BIGINT,
  "bng_n" BIGINT,
  "long" DOUBLE,
  "lat" DOUBLE,
  "shape_area" DOUBLE,
  "shape_length" DOUBLE,
  "globalid" VARCHAR
);