Counties (December 2016) Boundaries EN BGC

Office for National Statistics

@ukgov.counties_december_2016_boundaries_en_bgc

Table List

1 table(10.23 KB)

Table 1

@ukgov.counties_december_2016_boundaries_en_bgc.table_1

10.23 KB
27 rows
10 columns

objectid OBJECTID	cty16cd Cty16cd	cty16nm Cty16nm	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	0ada1510-ad5c-4ef0-b7c4-1e49023c2148
2	E10000003	Cambridgeshire	520312	273864	-0.23506001	52.34965897	3052755144.33014	501301.318061711	d385a689-a31b-44aa-8e41-c415a8debbad
3	E10000006	Cumbria	341868	527389	-2.90217996	54.63825989	6822173685.09421	954971.061384419	27c841df-d9d7-437c-95c3-3f072294b787
4	E10000007	Derbyshire	426752	353556	-1.60210001	53.07857895	2550841704.29258	454889.854873573	26a0d074-c72a-4ee8-b014-71abfc484cdf
5	E10000008	Devon	283141	93082	-3.65701008	50.72555923	6567155116.43907	1004518.71136682	6aadc91d-a0a6-46b2-9ce1-5fd19ee2c494
6	E10000009	Dorset	370871	99796	-2.41466999	50.79697037	2541969889.86591	550488.165099079	88a263d2-7753-4d71-bf41-e77349b40b1b
7	E10000011	East Sussex	564120	118026	0.33453	50.93832016	1712681330.85207	335001.407346433	48038d2a-34a1-4451-9d0e-7a3c44509dab
8	E10000012	Essex	575269	215407	0.54104602	51.80981827	3471597223.95755	1004483.73182712	c4e437c2-e591-4066-abfb-b5e253c02ec7
9	E10000013	Gloucestershire	389595	213465	-2.15234995	51.81970978	2653079840.90462	518997.184162863	5f86285c-ebdd-40c8-97de-a8aa799b35e4
10	E10000014	Hampshire	452858	127535	-1.24735999	51.04473114	3678844440.72967	664387.429596371	71d712e5-fe38-4c89-9419-2379e89488d5


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