Community Safety Partnerships (December 2017) EW BFC

Office for National Statistics

@ukgov.community_safety_partnerships_december_2017_ew_bfc1

Table List

1 table(41.13 KB)

Table 1

@ukgov.community_safety_partnerships_december_2017_ew_bfc1.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	319094a3-25b1-4eee-bb24-57401c87b4b1
2	E22000002	Bristol, City of	359990	174846	-2.57742	51.471149	109700128.520718	109722.788796206	02a35bf1-64aa-49c0-8935-424864a73ef3
3	E22000003	North Somerset	347613	166719	-2.75439	51.397072	374639658.139839	153769.99393243	b42797a6-b8f8-4fc9-b07c-61bdcf07efb1
4	E22000006	South Gloucestershire	367559	183196	-2.46922	51.546711	496947069.465302	143123.787854349	68cbed70-c8f1-4627-8786-d64c9e4342b1
5	E22000009	Bedford	505721	256463	-0.45463	52.196281	476408299.033134	131721.247617066	4a520a9e-7ceb-46f1-8762-0f6ed93f30e5
6	E22000010	Luton	508606	222559	-0.42319	51.891022	43352491.5869598	34569.6599400224	323de51a-48a4-4173-974e-b263a5304fc0
7	E22000013	Cambridge	545420	257901	0.126436	52.200169	40698796.39151	37170.4518489422	e97fe4f9-ca45-46c1-b74e-0964756ac2d4
8	E22000014	East Cambridgeshire	555577	275765	0.283163	52.35788	651279308.430161	234016.18617852	ae467714-ccc8-41c2-ada7-99c46f53eaa9
9	E22000015	Fenland	536361	294959	0.009016	52.535439	546450053.41597	187882.165880436	670c8b66-bc5c-4343-88a4-823cab01121f
10	E22000016	Huntingdonshire	521010	274271	-0.22467	52.353168	912458404.508789	223626.365770821	8f0ac92f-9ac2-4b7c-8625-a82b596d0f41


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