Combined Authorities (December 2020) Boundaries EN BGC

Office for National Statistics

@ukgov.combined_authorities_december_2020_boundaries_en_bgc1

Table List

1 table(8.53 KB)

Table 1

@ukgov.combined_authorities_december_2020_boundaries_en_bgc1.table_1

8.53 KB
10 rows
10 columns

fid FID	cauth20cd CAUTH20CD	cauth20nm CAUTH20NM	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	1275916522.5007	242513.081813091	247319ad-5b41-4f7d-b328-2a58b22c4867
2	E47000002	Sheffield City Region	441052	398663	-1.38284	53.48311	1551480878.80183	281514.381096324	1066a611-82f0-4889-abd2-8478ad6e06ab
3	E47000003	West Yorkshire	418686	427238	-1.71817	53.7412	2029283766.86362	278457.524654844	e226a98b-2778-433c-9e39-0ddafcd4d01f
4	E47000004	Liverpool City Region	344342	390164	-2.83866	53.40536	731292215.54303	374414.838106809	0eb8661c-699a-4a39-ae5d-55da78e4843f
5	E47000006	Tees Valley	436953	521739	-1.42968	54.58951	795156282.771774	319956.458126502	195d1f1d-47d9-45e7-840b-14dbb137e5ae
6	E47000007	West Midlands	402507	289715	-1.96448	52.50534	901648135.389511	251141.971596295	929a3f9a-6c7d-471e-82bc-2f538a44a30b
7	E47000008	Cambridgeshire and Peterborough	536856	271834	0.006854	52.32755	3396115505.24882	522624.297288447	d1847e52-8052-4851-a889-0aa796fdc49e
8	E47000009	West of England	366423	173496	-2.48467	51.45943	957862420.981522	255157.825341622	05382851-c10e-4af6-a14d-c5d7af0d173a
9	E47000010	North East	413490	537463	-1.79204	54.73197	2575666383.17101	368763.991608017	e99b6c80-aaa5-4d8d-96ce-b9afa0f84a1b
10	E47000011	North of Tyne	397235	600993	-2.0451	55.30303	5228087059.87778	597073.620984635	80d591d7-7848-487b-92be-63ec3e23390d


CREATE TABLE table_1 (
  "fid" BIGINT,
  "cauth20cd" VARCHAR,
  "cauth20nm" VARCHAR,
  "bng_e" BIGINT,
  "bng_n" BIGINT,
  "long" DOUBLE,
  "lat" DOUBLE,
  "shape_area" DOUBLE,
  "shape_length" DOUBLE,
  "globalid" VARCHAR
);