Community Safety Partnerships (December 2022) EW BFE

Office for National Statistics

@ukgov.community_safety_partnerships_december_2022_ew_bfe

Table List

1 table(45.37 KB)

Table 1

@ukgov.community_safety_partnerships_december_2022_ew_bfe.table_1

45.37 KB
314 rows
12 columns

fid FID	csp22cd CSP22CD	csp22nm CSP22NM	bng_e BNG E	bng_n BNG N	long LONG	lat LAT	shape_leng Shape Leng	shape_area Shape, Area	shape_length Shape, Length	globalid GlobalID
1	E22000001	Bath and North East Somerset	366217	161999	-2.48654	51.356	141674.070852	351123167.510914	141674.070852301	e93a1e35-1e53-45c8-96ab-6857c3375203
2	E22000002	Bristol, City of	359990	174846	-2.57742	51.4711	145449.691825	235441930.467381	145449.691824655	7030d0d1-4b18-4447-a3be-340f4e0982ff
3	E22000003	North Somerset	347614	166718	-2.75438	51.3971	140519.82791	390467165.644604	140519.82790951	f0faf998-74c6-4f96-aa1b-bdb66e47ec07
4	E22000006	South Gloucestershire	367559	183198	-2.46922	51.5467	159811.066254	536758456.066868	159811.066254149	055d40ca-8c99-43aa-ada2-b372b2af8468
5	E22000009	Bedford	505721	256463	-0.45463	52.1963	131719.278583	476408313.625572	131719.278582535	32a46b94-8ddf-486a-b883-9f847d4b0749
6	E22000010	Luton	508606	222559	-0.42319	51.891	34569.1847139	43352485.6740799	34569.1847138739	031cd480-e961-4802-baa3-25aaa8d94312
7	E22000013	Cambridge	545420	257901	0.126436	52.2002	37169.17552	40698821.5531006	37169.1755199722	ea1cd991-ff19-4d2a-9380-28215f683a14
8	E22000014	East Cambridgeshire	555576	275765	0.283149	52.3579	192581.077013	651720387.873184	192581.077013441	21d4bc95-cc1c-423c-8366-24430b53b622
9	E22000015	Fenland	536361	294959	0.009016	52.5354	153632.167779	547355452.617844	153632.167779412	2ae1ecf8-d642-47b9-a19a-0d8d58e52361
10	E22000016	Huntingdonshire	521008	274269	-0.2247	52.3531	222217.159234	912545809.879631	222217.159233559	48a3e566-4cfd-459f-92d3-24bee84036c3


CREATE TABLE table_1 (
  "fid" BIGINT,
  "csp22cd" VARCHAR,
  "csp22nm" VARCHAR,
  "csp22nmw" VARCHAR,
  "bng_e" BIGINT,
  "bng_n" BIGINT,
  "long" DOUBLE,
  "lat" DOUBLE,
  "shape_leng" DOUBLE,
  "shape_area" DOUBLE,
  "shape_length" DOUBLE,
  "globalid" VARCHAR
);