Combined Authorities (December 2022) Boundaries EN BGC

Office for National Statistics

@ukgov.combined_authorities_december_2022_boundaries_en_bgc

Table List

1 table(8.53 KB)

Table 1

@ukgov.combined_authorities_december_2022_boundaries_en_bgc.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	1275922070.78374	242517.649365212	29c41bb8-e7fe-40d9-8473-df91ac6b7888
2	E47000002	South Yorkshire	441052	398663	-1.38284	53.48311	1551468458.84933	281530.360689408	661fb55a-ad90-4b9b-b1fc-429ea7fa06cc
3	E47000003	West Yorkshire	418686	427238	-1.71817	53.7412	2029277350.07707	278457.787113898	b3779b6a-a940-4800-b7c8-937aff98f9eb
4	E47000004	Liverpool City Region	344342	390164	-2.83866	53.40536	731264299.12616	374178.25299769	2086d567-fb82-48af-8a3a-659ca7f996a4
5	E47000006	Tees Valley	436953	521739	-1.42968	54.58951	795164451.438507	319494.101431803	430a0037-ab61-46d9-81ab-e82a5c5f95ad
6	E47000007	West Midlands	402507	289715	-1.96448	52.50534	901648846.446785	251139.419941939	52e37905-a004-4404-a858-182179441340
7	E47000008	Cambridgeshire and Peterborough	536856	271834	0.006854	52.32755	3396123206.05039	522645.581348319	bb3b5aef-cbc0-47b4-9b98-7282c076bce0
8	E47000009	West of England	366423	173496	-2.48467	51.45943	957860180.551456	254509.327750682	ccfb17b0-7e67-483e-a92e-6391387321ad
9	E47000010	North East	413490	537463	-1.79204	54.73197	2575611737.63258	368525.336264647	442588be-b538-4173-8ac9-a0b0a24218d4
10	E47000011	North of Tyne	397235	600991	-2.0451	55.30301	5228125060.06357	596097.146451068	2448d50a-c758-4daf-ab1b-2d0bc2e58172


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