Countries (December 2021) Boundaries UK BUC

Office for National Statistics

@ukgov.countries_december_2021_boundaries_uk_buc

Table List

1 table(8.34 KB)

Table 1

@ukgov.countries_december_2021_boundaries_uk_buc.table_1

8.34 KB
4 rows
11 columns

objectid OBJECTID	ctry21cd CTRY21CD	ctry21nm CTRY21NM	ctry21nmw CTRY21NMW	bng_e BNG E	bng_n BNG N	long LONG	lat LAT	globalid GlobalID	shape_area Shape, Area	shape_length Shape, Length
1	E92000001	England	Lloegr	394883	370883	-2.07811	53.23497	15bb8223-3421-462c-83fc-37997c1d8c0c	130681068179.636	4616391.86557974
2	N92000002	Northern Ireland	Gogledd Iwerddon	86544	535337	-6.8557	54.61501	8f120662-6c39-45a0-9905-3d3959cb8b33	14331860006.3007	829125.171864814
3	S92000003	Scotland	Yr Alban	277744	700060	-3.97094	56.17743	9efc94d1-5ce7-47ce-bd1e-90386def28e5	78654826320.8171	9816914.79833119
4	W92000004	Wales	Cymru	263405	242881	-3.99417	52.06741	9c744c29-5982-4386-9676-f1ec0dac6478	20818675970.9952	1555750.4331621


CREATE TABLE table_1 (
  "objectid" BIGINT,
  "ctry21cd" VARCHAR,
  "ctry21nm" VARCHAR,
  "ctry21nmw" VARCHAR,
  "bng_e" BIGINT,
  "bng_n" BIGINT,
  "long" DOUBLE,
  "lat" DOUBLE,
  "globalid" VARCHAR,
  "shape_area" DOUBLE,
  "shape_length" DOUBLE
);