Baselight

Combined Authorities (December 2021) Boundaries EN BFC

Office for National Statistics

@ukgov.combined_authorities_december_2021_boundaries_en_bfc

Table 1
@ukgov.combined_authorities_december_2021_boundaries_en_bfc.table_1

  • 8.58 KB
  • 10 rows
  • 10 columns
objectid

OBJECTID

cauth21cd

CAUTH21CD

cauth21nm

CAUTH21NM

bng_e

BNG E

bng_n

BNG N

long

LONG

lat

LAT

globalid

GlobalID

shape_area

Shape, Area

shape_length

Shape, Length

1E47000001Greater Manchester377940401102-2.3340753.50615e8fabe10-6d2f-4f5d-80fb-8203874fdfa41275981137.97517248705.59357712
2E47000002South Yorkshire441052398663-1.3828453.4831185305bbb-17c9-4310-a2e5-11b19082c68e1551548380.1179287906.916820067
3E47000003West Yorkshire418686427238-1.7181753.74129b440256-baf2-4c79-96d3-ba7640d2a07a2029258668.6001282889.642770856
4E47000004Liverpool City Region344342390164-2.8386653.4053610671114-0627-4fd2-8ca9-3ac8b844a288731278717.128838389169.635274239
5E47000006Tees Valley436953521739-1.4296854.5895179fb1737-bbc2-43ad-ab2d-10748ab9fd69795078822.79715329094.099502494
6E47000007West Midlands402507289715-1.9644852.505348f3f7cd4-0016-4c8d-9094-553eb9267b9a901639655.574951256429.951040257
7E47000008Cambridgeshire and Peterborough5368562718340.00685452.3275531382957-f889-4497-9379-ff20ab3e17ce3395893082.72808529550.435314361
8E47000009West of England366423173496-2.4846751.45943a6792aa8-27ee-4cd2-aaa8-fd1323a62bce957838856.095921264570.241080265
9E47000010North East413490537463-1.7920454.73197dfba8198-06c4-4b23-9be1-8ba4f3f9f30e2575668660.93848378143.748443783
10E47000011North of Tyne397235600993-2.045155.303035ad6c0b3-4e7c-455e-ba5b-384777b636cd5228027093.9653617749.77147808

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

Share link

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