Baselight

Combined Authorities (December 2023) Boundaries EN BFE

Office for National Statistics

@ukgov.combined_authorities_december_2023_boundaries_en_bfe

Table 1
@ukgov.combined_authorities_december_2023_boundaries_en_bfe.table_1

  • 8.54 KB
  • 10 rows
  • 10 columns
fid

FID

cauth23cd

CAUTH23CD

cauth23nm

CAUTH23NM

bng_e

BNG E

bng_n

BNG N

long

LONG

lat

LAT

shape_area

Shape, Area

shape_length

Shape, Length

globalid

GlobalID

1E47000001Greater Manchester377929401095-2.3342353.506091275966379.66261250386.779256902cccb426a-9240-4fb9-92e9-a5209501db9d
2E47000002South Yorkshire441052398663-1.3828453.483111552065363.62308252111.1805855341aadf273-6ff2-4115-b80a-232d13e7fbe4
3E47000003West Yorkshire418683427238-1.7182253.74122029207949.36984283437.438986907fe12dcca-d8c1-4d80-bea1-112d90fbe922
4E47000004Liverpool City Region344345390165-2.8386153.40536902523436.230919273753.640958164a1e55a64-b5c3-4266-8cde-c674c54838f8
5E47000006Tees Valley436953521739-1.4296854.58951813926940.503571257260.955464224ece6f163-dccc-41c9-a5f8-693fcc26ee37
6E47000007West Midlands402503289718-1.9645452.50536901699100.399864256682.62643565401da62b3-688d-4ebc-b53d-eebbf8f6b80f
7E47000008Cambridgeshire and Peterborough5368562718370.00685552.327583397424506.95264429024.55272555764271016-56e1-4ae1-9225-11fe8d45c2fe
8E47000009West of England366422173495-2.4846951.459421123897012.58618312204.837996951fcae9f13-c23c-423b-abd8-64b1d431503e
9E47000010North East413490537463-1.7920454.731972583334099.04152329086.447984631e93d70e4-8a38-40a0-b698-e9597b952381
10E47000011North of Tyne397235600991-2.045155.303015278278812.71542566965.0979144247ccddd51-feca-4a4b-a4d1-d59ab4866a1e

CREATE TABLE table_1 (
  "fid" BIGINT,
  "cauth23cd" VARCHAR,
  "cauth23nm" 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.