Community Safety Partnerships (December 2017) EW BSC

Office for National Statistics

@ukgov.community_safety_partnerships_december_2017_ew_bsc1

Table List

1 table(41.13 KB)

Table 1

@ukgov.community_safety_partnerships_december_2017_ew_bsc1.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	350388516.986717	119168.288470602	2ade093a-e4e8-47fb-9902-868ef4c27cf7
2	E22000002	Bristol, City of	359990	174846	-2.57742	51.471149	109928065.623486	93258.5861100779	020a7aeb-6439-4860-bbbb-e4c047f1ea46
3	E22000003	North Somerset	347613	166719	-2.75439	51.397072	373719566.40852	128457.00759626	a75d8f4b-bdac-4e18-b9f7-5a1147c8ba14
4	E22000006	South Gloucestershire	367559	183196	-2.46922	51.546711	496705833.94352	124684.157513496	3b8401dc-cbe5-453e-9eea-0e48b59c18d5
5	E22000009	Bedford	505721	256463	-0.45463	52.196281	475130655.211266	122777.241674208	54add272-d1d4-48a9-89c4-fb43bca33005
6	E22000010	Luton	508606	222559	-0.42319	51.891022	43625821.8849564	32658.7573745844	15e6a07c-62b3-4ddc-9aea-b54eaa6947ff
7	E22000013	Cambridge	545420	257901	0.126436	52.200169	41281108.1912384	32837.2864619979	4d75be39-dbe8-444d-80c9-a21aa3f7827d
8	E22000014	East Cambridgeshire	555577	275765	0.283163	52.35788	652091308.279526	219542.568456317	03ad7032-a083-4f81-b11d-c14083e4110a
9	E22000015	Fenland	536361	294959	0.009016	52.535439	543637271.52095	179855.067234582	b574c6db-4250-4831-b965-05bd486b33e4
10	E22000016	Huntingdonshire	521010	274271	-0.22467	52.353168	913212415.228683	205460.110728349	ec82cae6-d737-4879-86b4-43a772330543


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