Countries (December 2018) Boundaries UK BUC

Office for National Statistics

@ukgov.countries_december_2018_boundaries_uk_buc1

Table List

1 table(8.34 KB)

Table 1

@ukgov.countries_december_2018_boundaries_uk_buc1.table_1

8.34 KB
4 rows
11 columns

objectid OBJECTID	ctry18cd Ctry18cd	ctry18nm Ctry18nm	ctry18nmw Ctry18nmw	bng_e Bng E	bng_n Bng N	long Long	lat Lat	shape_area Shape, Area	shape_length Shape, Length	globalid GlobalID
1	E92000001	England	Lloegr	394881	370341	-2.07813	53.230099	130719484272.148	4609371.56225744	c6ab3eb8-0675-4978-b78f-14364dc64051
2	N92000002	Northern Ireland	Gogledd Iwerddon	86544	535337	-6.8557	54.615009	14331860003.6621	829125.182162857	f0411bcd-7086-4246-b64d-58812306f911
3	S92000003	Scotland	Yr Alban	277746	700060	-3.97091	56.177429	79058411762.5053	9319953.4324747	7b7ceada-1a61-432e-bbf1-9a813232a25d
4	W92000004	Wales	Cymru	263406	242881	-3.99416	52.06741	20835134712.6849	1533204.620764	ff20f987-6640-41b0-ab0e-0dcd790565a4


CREATE TABLE table_1 (
  "objectid" BIGINT,
  "ctry18cd" VARCHAR,
  "ctry18nm" VARCHAR,
  "ctry18nmw" VARCHAR,
  "bng_e" BIGINT,
  "bng_n" BIGINT,
  "long" DOUBLE,
  "lat" DOUBLE,
  "shape_area" DOUBLE,
  "shape_length" DOUBLE,
  "globalid" VARCHAR
);