Combined Authorities (December 2018) Boundaries EN BFC

Office for National Statistics

@ukgov.combined_authorities_december_2018_boundaries_en_bfc1

Table List

1 table(8.58 KB)

Table 1

@ukgov.combined_authorities_december_2018_boundaries_en_bfc1.table_1

8.58 KB
10 rows
10 columns

objectid OBJECTID	cauth18cd Cauth18cd	cauth18nm Cauth18nm	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	1275981136.77104	248705.137914096	81985ac7-e5dd-4f0f-88cc-f32c5a701499
2	E47000002	Sheffield City Region	441052	398663	-1.38284	53.483109	1551564236.39377	287862.443098677	b552ed06-5911-4ca7-bedf-88dcc0cc352a
3	E47000003	West Yorkshire	418686	427238	-1.71817	53.741199	2029258668.11684	282889.596557914	82b805ec-67e8-4283-89a0-22119b624ce7
4	E47000004	Liverpool City Region	344324	390164	-2.83893	53.40535	725815778.892097	320423.660590688	6375c978-edc3-469c-981f-aa8842832d83
5	E47000006	Tees Valley	436951	521739	-1.42972	54.589512	794706288.351471	322512.911591188	6d42fb1e-1a3b-4c66-8114-221e298961d9
6	E47000007	West Midlands	402507	289715	-1.96448	52.505341	901639655.346085	256429.944855912	b8cc86af-8774-4264-b7eb-0da96b1329a5
7	E47000008	Cambridgeshire and Peterborough	536856	271834	0.006854	52.327549	3395891947.36118	529618.162822594	0c034fb7-47d0-4321-9cfc-5349733a013f
8	E47000009	West of England	366423	173496	-2.48467	51.459431	957768439.064709	266045.860700909	3b553530-eb73-4694-9ce6-5ff74cfae563
9	E47000010	North East	413482	537463	-1.79217	54.731972	2575734795.60112	378225.592912622	63c24ac7-fea5-4184-84b3-aeae881a2ffc
10	E47000011	North of Tyne	397234	600992	-2.04512	55.30302	5221988228.42313	596630.641858245	c91a6ef7-c432-465f-9f34-bca0763a8fa0


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