Combined Authorities (May 2024) Boundaries EN BFE

Office for National Statistics

@ukgov.combined_authorities_may_2024_boundaries_en_bfe

Table List

1 table(8.66 KB)

Table 1

@ukgov.combined_authorities_may_2024_boundaries_en_bfe.table_1

8.66 KB
11 rows
10 columns

fid FID	cauth24cd CAUTH24CD	cauth24nm CAUTH24NM	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	377929	401095	-2.33423	53.50609	1275966380.86494	250388.200438828	855bde22-7bb5-46f0-9180-b16aa2fd3dc8
2	E47000002	South Yorkshire	441052	398663	-1.38284	53.48311	1552065362.15318	252111.724818384	565378f0-2d9e-43eb-8c5e-287e11602e3e
3	E47000003	West Yorkshire	418683	427238	-1.71822	53.7412	2029208950.11124	283435.795099879	a15366c7-668d-4729-9a98-b1d1873dd2a3
4	E47000004	Liverpool City Region	344345	390165	-2.83861	53.40536	902528345.755951	273897.699358111	3e477c55-7bd3-4b4c-a422-a18481c7cec5
5	E47000006	Tees Valley	436953	521739	-1.42968	54.58951	813524593.963379	255054.778750063	d92bd722-69e2-45e5-b0a3-78d447771051
6	E47000007	West Midlands	402503	289718	-1.96454	52.50536	901712786.763481	256729.235120198	4fe163ce-b1be-4091-95b9-96ac0b59ff6d
7	E47000008	Cambridgeshire and Peterborough	536856	271837	0.006855	52.32758	3397430844.4035	429018.09230459	6089bcaf-c28b-482a-9b0a-09ddcd7aac6d
8	E47000009	West of England	366422	173495	-2.48469	51.45942	1123896889.66816	312216.43218153	a1d4d1e6-e81a-45e5-96d7-a466dc304410
9	E47000012	York and North Yorkshire	429508	466514	-1.55033	54.0937	8324201982.81871	755394.878433263	45c566cc-1220-48b8-8696-2f2f384e0eed
10	E47000013	East Midlands	449616	357963	-1.26015	53.11656	4790327018.67522	559531.392431702	f2aa58d5-55ad-4bbe-beef-9f8d448079bd


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