Combined Authorities (December 2022) Boundaries EN BUC

Office for National Statistics

@ukgov.combined_authorities_december_2022_boundaries_en_buc

Table List

1 table(8.53 KB)

Table 1

@ukgov.combined_authorities_december_2022_boundaries_en_buc.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	1273598614.92433	206057.696755372	592b1ec4-09a4-4da7-b87d-059a793c66de
2	E47000002	South Yorkshire	441052	398663	-1.38284	53.48311	1550442683.13785	213421.784328055	22a7a841-484f-47bb-8c5f-e9f4c9c28019
3	E47000003	West Yorkshire	418686	427238	-1.71817	53.7412	2029160702.45679	240287.479480822	98123037-0e99-472a-9f2d-9b758d5b7ea0
4	E47000004	Liverpool City Region	344342	390164	-2.83866	53.40536	728077454.971169	260917.062510707	fcd7cc0e-dd5e-43ed-99c9-729dcabd48ce
5	E47000006	Tees Valley	436953	521739	-1.42968	54.58951	804156179.207291	225786.037732126	2a545448-6433-4bbe-b178-65cf78167351
6	E47000007	West Midlands	402507	289715	-1.96448	52.50534	902348355.020409	206334.519532563	b3ba8cc8-44f1-443f-a3c8-654f31705c6c
7	E47000008	Cambridgeshire and Peterborough	536856	271834	0.006854	52.32755	3397592666.65897	369777.108917918	a94bf676-42ef-407a-9feb-7a466713e1ef
8	E47000009	West of England	366423	173496	-2.48467	51.45943	959384341.346916	176526.926112794	019695b8-4af3-4976-a91b-81b718248530
9	E47000010	North East	413490	537463	-1.79204	54.73197	2576825914.07376	277942.546750462	96155608-d52a-4429-a520-4d73562b4d36
10	E47000011	North of Tyne	397235	600991	-2.0451	55.30301	5228242686.67899	457634.700063238	1851cc87-2ec7-40d8-9638-5866fb7d0962


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