Countries (December 2017) Boundaries UK BUC

Office for National Statistics

@ukgov.countries_december_2017_boundaries_uk_buc

Table List

1 table(8.34 KB)

Table 1

@ukgov.countries_december_2017_boundaries_uk_buc.table_1

8.34 KB
4 rows
11 columns

objectid OBJECTID	ctry17cd Ctry17cd	ctry17nm Ctry17nm	ctry17nmw Ctry17nmw	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	50	130714112659.389	4534777.69571751	1277674d-5d60-457d-9322-833b31f77014
2	N92000002	Northern Ireland	Gogledd Iwerddon	86544	535337	-6.85570002	54.61500931	14330323225.1302	824738.385223497	5f8b1656-05fb-4ee3-b287-f0788ce98ac2
3	S92000003	Scotland	Yr Alban	277746	700060	-3.97091007	56.1774292	78864938234.0759	8889898.2871899	129d0e48-ea8b-4053-819e-f701f6bdae1e
4	W92000004	Wales	Cymru	263406	242881	-3.99415994	52.06740952	20810903673.1135	1522184.03953367	5c60f94c-5e65-4c9c-920d-4bb22b3e0e45


CREATE TABLE table_1 (
  "objectid" BIGINT,
  "ctry17cd" VARCHAR,
  "ctry17nm" VARCHAR,
  "ctry17nmw" VARCHAR,
  "bng_e" BIGINT,
  "bng_n" BIGINT,
  "long" DOUBLE,
  "lat" DOUBLE,
  "shape_area" DOUBLE,
  "shape_length" DOUBLE,
  "globalid" VARCHAR
);