Baselight

Combined Authorities (December 2019) Boundaries EN BFE

Office for National Statistics

@ukgov.combined_authorities_december_2019_boundaries_en_bfe1

Table 1
@ukgov.combined_authorities_december_2019_boundaries_en_bfe1.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

1E47000001Greater Manchester377940401102-2.3340753.5061491275981137.66568248706.0748621270efad239-b064-43f9-a24c-168508a6021f
2E47000002Sheffield City Region441052398663-1.3828453.4831091552093262.20369251952.6190916919805ee73-ecc7-4d8f-b17a-31b44e6d45df
3E47000003West Yorkshire418686427238-1.7181753.7411992029258666.12323282889.993363596c366bf1f-b748-4ae8-9766-b4ed5462d2ac
4E47000004Liverpool City Region344342390164-2.8386653.405361902716001.734947274039.01617025641698336-44da-424d-a841-4fe3de9657ce
5E47000006Tees Valley436953521739-1.4296854.589512813892118.080856257028.500995919b7696df0-ade8-435f-aecc-e37f3b1cbce9
6E47000007West Midlands402507289715-1.9644852.505341901639656.935059256430.292771641ea2779e5-fd49-4174-acdb-593475814cac
7E47000008Cambridgeshire and Peterborough5368562718340.00685452.3275493397445441.42753428253.1719528370f0fa34d-eb24-44ca-9d12-b7d9330200ab
8E47000009West of England366423173496-2.4846751.4594311122970364.5533310818.6390632496d9c9c49-d108-4f63-a961-39f6be45c349
9E47000010North East413490537463-1.7920454.7319722583383674.01537328782.2114271731cef2954-d02e-4eb6-a342-549731a2c09b
10E47000011North of Tyne397235600993-2.045155.3030285277416541.66968576441.011776106ebaa6506-0eb0-4477-ab25-1fabd23f20d9

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

Share link

Anyone who has the link will be able to view this.