Counties (December 2018) Boundaries EN BGC

Office for National Statistics

@ukgov.counties_december_2018_boundaries_en_bgc1

Table List

1 table(10.23 KB)

Table 1

@ukgov.counties_december_2018_boundaries_en_bgc1.table_1

10.23 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	1564968339.8982	354461.33847898	985128a8-f6c9-4c85-a048-402d7855110a
2	E10000003	Cambridgeshire	520312	273864	-0.23506001	52.34965897	3052752305.75826	501420.039369954	e61b811d-1dda-4952-9888-1a299b1cba0b
3	E10000006	Cumbria	341868	527389	-2.90217996	54.63825989	6822193757.77209	952990.617982732	a8617067-1153-4c76-b8cb-a7ab21be9f0b
4	E10000007	Derbyshire	426752	353556	-1.60210001	53.07857895	2550841712.88206	454889.972913867	1f7d57c9-bea9-4019-9946-d0e4ed967db4
5	E10000008	Devon	283141	93082	-3.65701008	50.72555923	6567262638.62478	1002339.97473754	88f79b99-e132-4c4b-869d-f8ef7f419b15
6	E10000009	Dorset	370871	99796	-2.41466999	50.79697037	2541994583.68824	549084.966424568	30aabdbd-fb84-4aab-929a-5f1af73ad8a4
7	E10000011	East Sussex	564120	118026	0.33453	50.93832016	1712679130.99076	334997.62420828	df43705c-bdf9-4800-8413-ed2314a47eb6
8	E10000012	Essex	575269	215407	0.54104602	51.80981827	3472274848.23962	1010681.34309843	982fecd3-75ca-4648-850f-083bf4a6c2d0
9	E10000013	Gloucestershire	389595	213465	-2.15234995	51.81970978	2653279490.47882	519004.94411769	27060602-a68b-40de-bd12-95064cda6d15
10	E10000014	Hampshire	452858	127535	-1.24735999	51.04473114	3678942252.96151	662280.610834179	5e03c839-bc61-4674-8686-8ed897933f2b


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