Counties (December 2017) Boundaries EN BSC

Office for National Statistics

@ukgov.counties_december_2017_boundaries_en_bsc

Table List

1 table(10.23 KB)

Table 1

@ukgov.counties_december_2017_boundaries_en_bsc.table_1

10.23 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	1565973868.14224	326378.035031914	07a200e9-d41e-4613-be70-933cbe494c0f
2	E10000003	Cambridgeshire	520312	273864	-0.23506001	52.34965897	3052497033.05685	472909.209162759	c342c4d1-01e0-4a5f-977c-e7d2be7b3f15
3	E10000006	Cumbria	341868	527389	-2.90217996	54.63825989	6819216509.17668	804370.420158185	f9e3687e-f074-4abc-b08e-9cefadfc015f
4	E10000007	Derbyshire	426752	353556	-1.60210001	53.07857895	2549598975.05431	405442.148411525	a173de8c-82b1-4a4c-a0b4-f9b48c28f67f
5	E10000008	Devon	283141	93082	-3.65701008	50.72555923	6566188410.74466	857561.771407047	44a52cd6-c119-4a78-ac47-c9b94d14ee2a
6	E10000009	Dorset	370871	99796	-2.41466999	50.79697037	2544096096.09028	484325.493803855	ed98087a-518a-4adf-bf37-ab778c6f480b
7	E10000011	East Sussex	564120	118026	0.33453	50.93832016	1713883148.92615	307391.758327905	42ed446e-09ee-49f5-893c-94f3b2e94f8e
8	E10000012	Essex	575269	215407	0.54104602	51.80981827	3464859649.07743	878430.478621745	8b0e8ac5-d100-450d-b0ff-70a783144c1f
9	E10000013	Gloucestershire	389595	213465	-2.15234995	51.81970978	2652557929.67236	478449.319378807	5cde8f8f-9884-4449-9dbe-5ffee8e67007
10	E10000014	Hampshire	452858	127535	-1.24735999	51.04473114	3679003687.99673	564526.541052063	cf64702d-db28-47bd-821a-46711f7e1be4


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