Community Safety Partnerships (December 2017) EW BFE

Office for National Statistics

@ukgov.community_safety_partnerships_december_2017_ew_bfe1

Table List

1 table(41.13 KB)

Table 1

@ukgov.community_safety_partnerships_december_2017_ew_bfe1.table_1

41.13 KB
315 rows
10 columns

objectid OBJECTID	csp17cd Csp17cd	csp17nm Csp17nm	bng_e Bng E	bng_n Bng N	long Long	lat Lat	shape_area Shape, Area	shape_length Shape, Length	globalid GlobalID
1	E22000001	Bath and North East Somerset	366217	161999	-2.48654	51.356041	351123211.79723	141684.811213324	1e1ba44f-657c-41bb-9be3-a97bb4c6687c
2	E22000002	Bristol, City of	359990	174846	-2.57742	51.471149	235328573.155338	145315.850873026	260cf2e4-72f3-4138-9c60-9c3cd242d021
3	E22000003	North Somerset	347613	166719	-2.75439	51.397072	390815092.205837	139299.672855011	1cee3a2b-568c-47c9-8de6-6ca323717e28
4	E22000006	South Gloucestershire	367559	183196	-2.46922	51.546711	536645354.956581	158121.583206819	d482fee8-64a4-4dd0-b4c5-8f3803fc1bea
5	E22000009	Bedford	505721	256463	-0.45463	52.196281	476408299.033134	131721.247617066	9e67617d-9e30-45b3-b383-1bc1ac7a694a
6	E22000010	Luton	508606	222559	-0.42319	51.891022	43352491.5869598	34569.6599400224	80d0c576-bf97-4b13-8364-559c2c2f1dfc
7	E22000013	Cambridge	545420	257901	0.126436	52.200169	40698796.39151	37170.4518489422	90bde758-6fe5-46e2-b32a-105c293a3d6c
8	E22000014	East Cambridgeshire	555577	275765	0.283163	52.35788	651720403.682785	192583.13633378	74dfdb1f-a6fa-43e3-b8c6-99133b5ef015
9	E22000015	Fenland	536361	294959	0.009016	52.535439	547355394.778854	153633.525482492	663bb72d-d855-491d-971a-d120cf63cc4c
10	E22000016	Huntingdonshire	521010	274271	-0.22467	52.353168	912545829.399384	222221.609857046	99bc8e76-8f5d-40fb-8fd9-fa961334a753


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