Counties (December 2017) Boundaries EN BGC

Office for National Statistics

@ukgov.counties_december_2017_boundaries_en_bgc

Table List

1 table(10.24 KB)

Table 1

@ukgov.counties_december_2017_boundaries_en_bgc.table_1

10.24 KB
27 rows
10 columns

objectid OBJECTID	cty17cd Cty17cd	cty17nm Cty17nm	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	1564968343.28395	354461.339150174	8c25fc94-5459-4835-8eb4-1fbad54273ec
2	E10000003	Cambridgeshire	520312	273864	-0.23506001	52.34965897	3052755140.37003	501301.352272918	74327c43-8b5b-4b6a-896c-31b816971799
3	E10000006	Cumbria	341868	527389	-2.90217996	54.63825989	6822192760.1628	955512.888482688	a64ad3bc-7ec1-43c8-a5ad-16150e5e8555
4	E10000007	Derbyshire	426752	353556	-1.60210001	53.07857895	2550841721.83669	454887.427251401	92b6052e-148a-400d-a3d2-e0236e97af52
5	E10000008	Devon	283141	93082	-3.65701008	50.72555923	6567231242.93631	1004228.63044859	185767b6-b2aa-4889-b687-b62cac465a78
6	E10000009	Dorset	370871	99796	-2.41466999	50.79697037	2541966735.84566	550742.071688915	20c14c27-a524-47b2-b962-329574d50f95
7	E10000011	East Sussex	564120	118026	0.33453	50.93832016	1712681891.4724	335010.672911057	f5d3830b-66c8-4990-8366-b4763e2bf4af
8	E10000012	Essex	575269	215407	0.54104602	51.80981827	3471603019.18699	1053049.71202463	f6b5a088-08aa-4e48-999d-fd9684095763
9	E10000013	Gloucestershire	389595	213465	-2.15234995	51.81970978	2653079864.76426	518997.222550722	d7de997c-64f9-41e0-aacd-585f0de538df
10	E10000014	Hampshire	452858	127535	-1.24735999	51.04473114	3678859101.44667	664438.070107893	4381c62d-6756-44e1-8879-6f39c225bc77


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