Community Safety Partnerships (December 2017) EW BGC

Office for National Statistics

@ukgov.community_safety_partnerships_december_2017_ew_bgc1

Table List

1 table(41.18 KB)

Table 1

@ukgov.community_safety_partnerships_december_2017_ew_bgc1.table_1

41.18 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	351163380.802296	137361.837176755	7a2538dc-14a2-478e-baad-b033a0efda7d
2	E22000002	Bristol, City of	359990	174846	-2.57742	51.471149	109720694.017338	106749.670910145	2c0fb46c-5379-45f0-9af2-dce6504e23b4
3	E22000003	North Somerset	347613	166719	-2.75439	51.397072	374629904.297523	148427.003177496	344154d2-6673-4493-aa7a-0f237f64d57f
4	E22000006	South Gloucestershire	367559	183196	-2.46922	51.546711	496933994.361542	138672.554485022	58e5c01d-077a-4229-b2ec-ff289ac68108
5	E22000009	Bedford	505721	256463	-0.45463	52.196281	476375539.392303	129918.51080216	3c3bee63-cedf-4b82-a0cc-fb4398a9c697
6	E22000010	Luton	508606	222559	-0.42319	51.891022	43359037.9946365	34269.128475714	9358580c-2077-4beb-a6e5-45d43aaa1322
7	E22000013	Cambridge	545420	257901	0.126436	52.200169	40705205.2167511	36895.0046777858	f0915db6-4ba2-4e5f-9f22-37be5e77865b
8	E22000014	East Cambridgeshire	555577	275765	0.283163	52.35788	651314504.485046	231623.855589119	81116c1b-6a94-4b0b-a2eb-04f16926ae70
9	E22000015	Fenland	536361	294959	0.009016	52.535439	546479193.881683	186340.690611194	3ad799aa-be03-4427-ac40-6d36f77f8f77
10	E22000016	Huntingdonshire	521010	274271	-0.22467	52.353168	912556058.464539	220623.99204723	5d361eaf-dcc1-4f5e-8481-4da2a948c9e3


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