Baselight

Countries (December 2022) Boundaries GB BGC

Office for National Statistics

@ukgov.countries_december_2022_boundaries_gb_bgc

Table 1
@ukgov.countries_december_2022_boundaries_gb_bgc.table_1

  • 8.16 KB
  • 3 rows
  • 11 columns
fid

FID

ctry22cd

CTRY22CD

ctry22nm

CTRY22NM

ctry22nmw

CTRY22NMW

bng_e

BNG E

bng_n

BNG N

long

LONG

lat

LAT

shape_area

Shape, Area

shape_length

Shape, Length

globalid

GlobalID

1E92000001EnglandLloegr394883370883-2.0781153.23497130457690292.67912457736.23571247acd3011-0b95-4082-a751-646803b80992
2S92000003ScotlandYr Alban277744700060-3.9709456.1774378795210370.523217027898.730671228fd394f-9ae7-4b8e-adf2-861efa4bd0c6
3W92000004WalesCymru263405242881-3.9941752.0674120782231543.07153027698.264177350f36f3f7-eba9-416b-8163-300f954d08bf

CREATE TABLE table_1 (
  "fid" BIGINT,
  "ctry22cd" VARCHAR,
  "ctry22nm" VARCHAR,
  "ctry22nmw" 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.