Combined Authorities (December 2018) Boundaries EN BGC

Office for National Statistics

@ukgov.combined_authorities_december_2018_boundaries_en_bgc1

Table List

1 table(8.59 KB)

Table 1

@ukgov.combined_authorities_december_2018_boundaries_en_bgc1.table_1

8.59 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	1275932420.1203	242578.835961122	43362323-46c7-46d1-954a-3fa0b2e0a793
2	E47000002	Sheffield City Region	441052	398663	-1.38284	53.483109	1551508800.79716	281616.606926106	977ab230-658e-40d4-8703-4b7c15ab226d
3	E47000003	West Yorkshire	418686	427238	-1.71817	53.741199	2029277826.47903	278438.193432412	64d0cc10-bcbd-47cd-b341-60bf6ba4e06c
4	E47000004	Liverpool City Region	344324	390164	-2.83893	53.40535	725859161.908615	311853.866001179	17be35f7-62f7-456a-8167-21ebee6eb07d
5	E47000006	Tees Valley	436951	521739	-1.42972	54.589512	794848198.985184	314341.372046141	38254820-e9c6-4599-9108-c7ae24c08afd
6	E47000007	West Midlands	402507	289715	-1.96448	52.505341	901652435.742752	251091.993269042	6c1bd51e-a9f8-4664-9e5a-fe43fd163e00
7	E47000008	Cambridgeshire and Peterborough	536856	271834	0.006854	52.327549	3396195676.65439	523043.387013936	38faafb3-3397-4b41-8ce6-56d7b7e1a15e
8	E47000009	West of England	366423	173496	-2.48467	51.459431	957821783.658249	257850.934037066	bc5cde23-9b01-4400-8349-dc43c23fcf8f
9	E47000010	North East	413482	537463	-1.79217	54.731972	2575771991.85806	368349.64808263	71950c7a-3569-4ba1-b688-997b07f0637f
10	E47000011	North of Tyne	397234	600992	-2.04512	55.30302	5222178353.71954	580022.655024987	57758d67-be61-4587-8564-4876490cd3a2


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