Baselight

Countries (December 2019) Boundaries GB BUC

Office for National Statistics

@ukgov.countries_december_2019_boundaries_gb_buc

Table 1
@ukgov.countries_december_2019_boundaries_gb_buc.table_1

  • 8.21 KB
  • 3 rows
  • 11 columns
objectid

OBJECTID

ctry19cd

CTRY19CD

ctry19nm

CTRY19NM

ctry19nmw

CTRY19NMW

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.23497130651141779.4095017042.24287512a6bca30d-1647-43c7-9f03-8834b99f46a7
2S92000003ScotlandYr Alban277744700060-3.9709456.17742978981340581.9769639570.04320457696b3643-e06b-4d2f-974e-14725a6f95b3
3W92000004WalesCymru263405242881-3.9941752.0674120809306607.22431691390.103769376eb2bca4-8c3f-4b9c-9ff7-52927b7f6536

CREATE TABLE table_1 (
  "objectid" BIGINT,
  "ctry19cd" VARCHAR,
  "ctry19nm" VARCHAR,
  "ctry19nmw" 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.