Combined Authorities (December 2019) Boundaries EN BUC

Office for National Statistics

@ukgov.combined_authorities_december_2019_boundaries_en_buc1

Table List

1 table(8.58 KB)

Table 1

@ukgov.combined_authorities_december_2019_boundaries_en_buc1.table_1

8.58 KB
10 rows
10 columns

objectid OBJECTID	cauth19cd Cauth19cd	cauth19nm Cauth19nm	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.506149	1273598337.12234	206057.361351532	c81c3af9-6fde-466b-9b5e-905bfeb9dc16
2	E47000002	Sheffield City Region	441052	398663	-1.38284	53.483109	1550702087.69336	246729.646757873	d0269e28-542d-4a0d-be8d-92b2212abda2
3	E47000003	West Yorkshire	418686	427238	-1.71817	53.741199	2029163329.69075	240199.032682458	b6d07a18-78d1-46cf-af61-1f5d56125392
4	E47000004	Liverpool City Region	344342	390164	-2.83866	53.405361	725431719.271194	277591.950796423	c9a1c08d-13e3-404c-9cec-28a37d1e19a3
5	E47000006	Tees Valley	436953	521739	-1.42968	54.589512	800726497.472473	262771.757662375	e831ae1f-65eb-4e0b-84ca-494d0f6d3161
6	E47000007	West Midlands	402507	289715	-1.96448	52.505341	902348993.609993	206334.877572412	387e60a5-ae8f-44d4-aa72-7186bc63c89a
7	E47000008	Cambridgeshire and Peterborough	536856	271834	0.006854	52.327549	3392498024.99457	467271.972738427	47e8cfd2-0a7a-46e2-b6ae-593d196eb879
8	E47000009	West of England	366423	173496	-2.48467	51.459431	956558928.937706	186639.341190786	c8c411ab-27a0-4430-9b68-0cab198ef8fa
9	E47000010	North East	413490	537463	-1.79204	54.731972	2573573864.98219	315333.478121323	65eb1f32-80b3-4c52-aa35-515ea80184c7
10	E47000011	North of Tyne	397235	600993	-2.0451	55.303028	5224924224.6861	484466.684058905	89612042-179d-4ee7-a526-8d1fef6a0181


CREATE TABLE table_1 (
  "objectid" BIGINT,
  "cauth19cd" VARCHAR,
  "cauth19nm" VARCHAR,
  "bng_e" BIGINT,
  "bng_n" BIGINT,
  "long" DOUBLE,
  "lat" DOUBLE,
  "shape_area" DOUBLE,
  "shape_length" DOUBLE,
  "globalid" VARCHAR
);