Baselight

Countries (December 2020) Boundaries UK BUC

Office for National Statistics

@ukgov.countries_december_2020_boundaries_uk_buc

Table 1
@ukgov.countries_december_2020_boundaries_uk_buc.table_1

  • 7.72 KB
  • 4 rows
  • 10 columns
objectid

OBJECTID

ctry20cd

CTRY20CD

ctry20nm

CTRY20NM

bng_e

BNG E

bng_n

BNG N

long

LONG

lat

LAT

shape_area

Shape, Area

shape_length

Shape, Length

globalid

GlobalID

1E92000001England394883370883-2.0781153.23497130681553811.4734616815.79617608aa482699-77af-4044-bf83-043315652181
2N92000002Northern Ireland86544535337-6.855754.6150114331860000.9046829125.182315612a869cc13-a87a-44da-80ba-e17e7eeaab05
3S92000003Scotland277744700060-3.9709456.1774378656638269.51119812084.365578354a2f21ae-0a8c-406d-8f8c-53134799220f
4W92000004Wales263405242881-3.9941752.0674120818923759.61611556249.38420021416bb98c-583e-4c23-b791-1d45bc0378ff

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