Baselight

Counties (December 2021) Boundaries EN BUC

Office for National Statistics

@ukgov.counties_december_2021_boundaries_en_buc

Table 1
@ukgov.counties_december_2021_boundaries_en_buc.table_1

  • 9.88 KB
  • 24 rows
  • 10 columns
objectid

OBJECTID

cty21cd

CTY21CD

cty21nm

CTY21NM

bng_e

BNG E

bng_n

BNG N

long

LONG

lat

LAT

globalid

GlobalID

shape_area

Shape, Area

shape_length

Shape, Length

1E10000003Cambridgeshire520312273864-0.2350652.3496670cfc71d-7517-48e1-98b6-09b2b3f1fb933056053132.91615366338.051142091
2E10000006Cumbria341868527180-2.9021354.63638abf536cc-d431-4a7f-94ae-60c46ff2ac846832513382.76744542080.49545509
3E10000007Derbyshire426752353556-1.602153.07858acf0c07f-5cfa-4362-9794-34666c1d17932549660378.18987372264.838782947
4E10000008Devon28314393085-3.6569850.72558d16e6f8f-6e9e-423f-aecf-b8d32fa5a7036584991274.36257596829.069285223
5E10000011East Sussex5641231179960.33455950.938055ea13fda-e011-4f5c-9163-5e714863e0161721427361.80535220343.072799337
6E10000012Essex5752702154070.5410651.80982561fc164-0493-4068-9d3b-bba84593f40e3469601037.97041555794.930567141
7E10000013Gloucestershire389595213465-2.1523551.81971d40fbe15-efc2-447f-982b-e2106cab0cea2697361011.24324350832.894734173
8E10000014Hampshire452859127536-1.2473551.04474350b13f0-ec18-4624-83e3-00446ab484b33676624676.439473806.600566658
9E10000015Hertfordshire518883213642-0.2769951.808794eb3357f-ad28-4855-89e5-e70773f4712f1642273719.28583260398.418146271
10E10000016Kent5902491472680.7213751.19295ad1c5955-40f9-42c5-9255-0ed88ef8f45d3543552715.83951422943.878148242

CREATE TABLE table_1 (
  "objectid" BIGINT,
  "cty21cd" VARCHAR,
  "cty21nm" 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.