Counties (December 2022) Boundaries EN BGC

Office for National Statistics

@ukgov.counties_december_2022_boundaries_en_bgc

Table List

1 table(9.85 KB)

Table 1

@ukgov.counties_december_2022_boundaries_en_bgc.table_1

9.85 KB
24 rows
10 columns

fid FID	cty22cd CTY22CD	cty22nm CTY22NM	bng_e BNG E	bng_n BNG N	long LONG	lat LAT	shape_area Shape, Area	shape_length Shape, Length	globalid GlobalID
1	E10000003	Cambridgeshire	520312	273864	-0.23506	52.3497	3052712187.6045	507267.1104929	b805e7d3-5fa7-4fb6-9ce4-0c1689957bbf
2	E10000006	Cumbria	341868	527180	-2.90213	54.6364	6823157859.86453	977770.561632857	0ec28b88-80cd-4648-87de-a4d0b7e7b55e
3	E10000007	Derbyshire	426752	353556	-1.6021	53.0786	2550831544.71253	454847.071113902	8277d58b-0250-4842-a6f3-904179ec33b2
4	E10000008	Devon	283143	93085	-3.65698	50.7256	6566721367.31461	1032057.94639803	5aa2ab06-0c09-446d-89bc-a0b83000f7ab
5	E10000011	East Sussex	564123	117996	0.334559	50.938	1712853241.11264	339483.803928181	ba0d0f75-3d38-4edf-be51-443864f61927
6	E10000012	Essex	575270	215407	0.54106	51.8098	3464891882.82345	1538506.5694825	ca5cc4ce-141f-415a-a57a-080f0d146e32
7	E10000013	Gloucestershire	389595	213465	-2.15235	51.8197	2652610990.43665	520164.567073298	d6f16b2c-10f2-49a5-9093-1d92ed3a5c73
8	E10000014	Hampshire	452859	127536	-1.24735	51.0447	3678217538.60278	722029.814509945	c9b8eeb9-3801-42be-ba1a-02cc15552715
9	E10000015	Hertfordshire	518883	213642	-0.27699	51.8088	1642992356.84235	298554.012784738	9ebf1f90-b057-4b0e-aa0d-395024566601
10	E10000016	Kent	590249	147268	0.72137	51.193	3545283279.59322	723493.716461116	5415eec8-5494-43af-845e-133354c78f12


CREATE TABLE table_1 (
  "fid" BIGINT,
  "cty22cd" VARCHAR,
  "cty22nm" VARCHAR,
  "bng_e" BIGINT,
  "bng_n" BIGINT,
  "long" DOUBLE,
  "lat" DOUBLE,
  "shape_area" DOUBLE,
  "shape_length" DOUBLE,
  "globalid" VARCHAR
);