Combined Authorities (March 2017) Boundaries EN BFC

Office for National Statistics

@ukgov.combined_authorities_march_2017_boundaries_en_bfc

Table List

1 table(8.48 KB)

Table 1

@ukgov.combined_authorities_march_2017_boundaries_en_bfc.table_1

8.48 KB
9 rows
10 columns

objectid OBJECTID	cauth17cd CAUTH17CD	cauth17nm CAUTH17NM	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.33406997	53.50614929	1275981133.87283	248705.576852058	aaea6c91-2a7c-4bf6-bf5f-4d6d2487b31f
2	E47000002	Sheffield City Region	441052	398663	-1.38284004	53.48310852	1551563987.65529	287864.015190747	5e7ccb7f-b330-4596-9550-3ec7792804f8
3	E47000003	West Yorkshire	418686	427238	-1.71817005	53.74119949	2029258660.00085	282889.605715552	07d029d4-a59d-41bd-bf26-3f77b6107cb3
4	E47000004	Liverpool City Region	344324	390164	-2.83892989	53.40534973	725815778.731903	320424.139752368	15ce16c6-3f40-4d4b-bb26-f7516d96bb1e
5	E47000005	North East	402553	577597	-1.96153998	55.09280014	7797722994.58316	836248.386746118	886047f8-1a40-4338-a5c0-193de6422f83
6	E47000006	Tees Valley	436951	521739	-1.42972004	54.58951187	794706294.317398	322512.98713321	f19b880e-6f0d-402e-9016-6f410214f721
7	E47000007	West Midlands	402507	289715	-1.96448004	52.50534058	901639657.611725	256429.945450814	3e793cf5-ea04-4735-b798-f36da8c1933d
8	E47000008	Cambridgeshire and Peterborough	536856	271834	0.006854	52.32754898	3395891918.89303	529618.158702784	b8c55064-f27a-4be1-a8b8-9d707c1b07ef
9	E47000009	West of England	366423	173496	-2.48466992	51.45943069	957770412.055378	266386.318677873	59e8d736-c431-49ee-88f5-281cbdf44f99


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