Combined Authorities (Latest) Boundaries EN BFC

Office for National Statistics

@ukgov.combined_authorities_latest_boundaries_en_bfc

Table List

1 table(8.67 KB)

Table 1

@ukgov.combined_authorities_latest_boundaries_en_bfc.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	1275966380.86494	250388.200438828	dfc4ff69-0589-43a3-aa31-2bab26aa6973
2	E47000002	South Yorkshire	441052	398663	-1.38284	53.48311	1551536333.98315	288022.161280523	fcb47571-a19b-4c41-a2a7-48c37f38e19f
3	E47000003	West Yorkshire	418683	427238	-1.71822	53.7412	2029208950.11124	283435.795099879	cfac7328-c6bf-4fa1-bc23-8369b126b185
4	E47000004	Liverpool City Region	344345	390165	-2.83861	53.40536	731295634.533119	389408.226945504	02318212-b5ff-4024-90a7-92db7180e511
5	E47000006	Tees Valley	436953	521739	-1.42968	54.58951	795308408.360474	333361.605522105	2a50e6d0-ea7c-4c0e-aea1-c58253d6f8ed
6	E47000007	West Midlands	402503	289718	-1.96454	52.50536	901712786.763481	256729.235120198	f6296b98-0ab9-4d6e-b9fb-1a5212afc56e
7	E47000008	Cambridgeshire and Peterborough	536856	271837	0.006855	52.32758	3395878479.68833	530316.160529901	09c6c1ff-a790-407c-a393-99a23a525453
8	E47000009	West of England	366422	173495	-2.48469	51.45942	957833784.655411	265893.587830104	98d4c6f9-6fce-43d8-b3b5-e5798a633ce4
9	E47000012	York and North Yorkshire	429508	466514	-2	50	8311976861.20692	816468.152748157	87aeb545-250e-4833-b439-67dd3cbff988
10	E47000013	East Midlands	449616	357963	-1.26015	53.11656	4788143140.70382	584530.011021294	6c3aa5f4-663c-45cb-8f47-4ee5bc6f6167


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