Baselight

Countries (December 2021) Boundaries UK BFC

Office for National Statistics

@ukgov.countries_december_2021_boundaries_uk_bfc

Table 1
@ukgov.countries_december_2021_boundaries_uk_bfc.table_1

  • 7.45 KB
  • 4 rows
  • 10 columns
objectid

OBJECTID

ctry21cd

CTRY21CD

ctry21nm

CTRY21NM

ctry21nmw

CTRY21NMW

bng_e

BNG E

bng_n

BNG N

long

LONG

lat

LAT

shape_area

Shape, Area

shape_length

Shape, Length

1E92000001EnglandLloegr394883370883-2.0781153.23497130462340814.05813589476.971018
2N92000002Northern IrelandGogledd Iwerddon86544535337-6.855754.6150114329763570.5751131044.59311699
3S92000003ScotlandYr Alban277744700060-3.9709456.1774378801216461.994818902340.5545423
4W92000004WalesCymru263405242881-3.9941752.0674120782601865.16743273759.93763554

CREATE TABLE table_1 (
  "objectid" BIGINT,
  "ctry21cd" VARCHAR,
  "ctry21nm" VARCHAR,
  "ctry21nmw" VARCHAR,
  "bng_e" BIGINT,
  "bng_n" BIGINT,
  "long" DOUBLE,
  "lat" DOUBLE,
  "shape_area" DOUBLE,
  "shape_length" DOUBLE
);

Share link

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