Countries (December 2018) Boundaries UK BFE

Office for National Statistics

@ukgov.countries_december_2018_boundaries_uk_bfe1

Table List

1 table(7.45 KB)

Table 1

@ukgov.countries_december_2018_boundaries_uk_bfe1.table_1

7.45 KB
4 rows
10 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
1	E92000001	England	Lloegr	394881	370341	-2.07813	53.230099	132943987431.042	4767312.78059446
2	N92000002	Northern Ireland	Gogledd Iwerddon	86544	535337	-6.8557	54.615009	14329763569.5934	1131048.15796771
3	S92000003	Scotland	Yr Alban	277746	700060	-3.97091	56.177429	80226472689.4522	17907764.6005498
4	W92000004	Wales	Cymru	263406	242881	-3.99416	52.06741	21224771399.9964	2027618.17946476


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
);