Combined Authorities (May 2024) Boundaries EN BGC

Office for National Statistics

@ukgov.combined_authorities_may_2024_boundaries_en_bgc

Table List

1 table(8.67 KB)

Table 1

@ukgov.combined_authorities_may_2024_boundaries_en_bgc.table_1

8.67 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	1275917684.91058	243300.396207067	38794324-ec57-4bea-bbc2-87024c0c6325
2	E47000002	South Yorkshire	441052	398663	-1.38284	53.48311	1551457642.91632	281657.359744149	0d5435c7-3de3-4942-9af1-e085504df421
3	E47000003	West Yorkshire	418683	427238	-1.71822	53.7412	2029239178.90118	278580.48895594	2c5962e5-fbb3-4932-9b6b-5eb37c0e840d
4	E47000004	Liverpool City Region	344345	390165	-2.83861	53.40536	731275541.862885	374245.246504848	d527ccbb-0f8d-4b5e-b113-17e6e2261329
5	E47000006	Tees Valley	436953	521739	-1.42968	54.58951	795338612.834869	320887.743208831	c6aa7ee2-a552-46bc-8d9d-258dbc2689f6
6	E47000007	West Midlands	402503	289718	-1.96454	52.50536	901742399.922089	250972.467839129	b946a6cc-a59b-43d2-8015-7051610f0d25
7	E47000008	Cambridgeshire and Peterborough	536856	271837	0.006855	52.32758	3396140489.85618	522920.357641816	88607fca-2307-47fe-b3dc-aedcb436ac3c
8	E47000009	West of England	366422	173495	-2.48469	51.45942	957880073.029583	255423.670755874	36ac8e45-5b5c-4283-970b-5160aa7eaa9b
9	E47000012	York and North Yorkshire	429508	466514	-1.55033	54.0937	8312138760.73016	800478.92367501	bfafaf01-694c-4be5-915e-c3e0160959a6
10	E47000013	East Midlands	449616	357963	-1.26015	53.11656	4788270044.09654	569579.115537467	dae62a10-3105-4e8c-9dec-6c49569bc67c


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