Counties (December 2018) Boundaries EN BFE

Office for National Statistics

@ukgov.counties_december_2018_boundaries_en_bfe1

Table List

1 table(10.25 KB)

Table 1

@ukgov.counties_december_2018_boundaries_en_bfe1.table_1

10.25 KB
27 rows
10 columns

objectid OBJECTID	cty18cd Cty18cd	cty18nm Cty18nm	bng_e Bng E	bng_n Bng N	long Long	lat Lat	shape_area Shape, Area	shape_length Shape, Length	globalid GlobalID
1	E10000002	Buckinghamshire	482506	208561	-0.80568999	51.76966095	1564949144.27465	361853.598103102	9397fb12-ccd7-48aa-aae3-b4baea33133d
2	E10000003	Cambridgeshire	520312	273864	-0.23506001	52.34965897	3054007577.19549	421461.095199034	616c871b-6b49-4caa-b937-3f671c33859a
3	E10000006	Cumbria	341868	527389	-2.90217996	54.63825989	7182472589.15013	580154.222991679	d8579acf-d769-4bf2-860f-157a859ba923
4	E10000007	Derbyshire	426752	353556	-1.60210001	53.07857895	2550762423.13187	469169.950255933	a35e9ac6-654a-4a2c-8c8a-6207850746b4
5	E10000008	Devon	283141	93082	-3.65701008	50.72555923	6636103043.91496	769794.551002391	ccf466c3-ecb5-41bc-b255-5e757f99441f
6	E10000009	Dorset	370871	99796	-2.41466999	50.79697037	2572973689.85391	442369.610825084	24abb7be-be2c-4f5c-be7a-052bbf2f0ceb
7	E10000011	East Sussex	564120	118026	0.33453	50.93832016	1725168831.34883	271729.720944238	173f5384-e485-4347-822f-294d93a4d1b4
8	E10000012	Essex	575269	215407	0.54104602	51.80981827	3695309516.66691	556494.124828264	588b46be-f630-41f3-afe9-511c245d69f9
9	E10000013	Gloucestershire	389595	213465	-2.15234995	51.81970978	2704528507.41716	424961.443282497	7d142bdb-063e-4ac2-9fc0-a5b7dff01b7b
10	E10000014	Hampshire	452858	127535	-1.24735999	51.04473114	3737906116.17798	503984.151413438	5fd15599-6429-432e-a39b-b7a251eb4025


CREATE TABLE table_1 (
  "objectid" BIGINT,
  "cty18cd" VARCHAR,
  "cty18nm" VARCHAR,
  "bng_e" BIGINT,
  "bng_n" BIGINT,
  "long" DOUBLE,
  "lat" DOUBLE,
  "shape_area" DOUBLE,
  "shape_length" DOUBLE,
  "globalid" VARCHAR
);