Police Force Areas (Dec 2019) EW BUC

Office for National Statistics

@ukgov.police_force_areas_dec_2019_ew_buc

Table List

1 table(12.01 KB)

Table 1

@ukgov.police_force_areas_dec_2019_ew_buc.table_1

12.01 KB
43 rows
10 columns

objectid OBJECTID	pfa19cd PFA19CD	pfa19nm PFA19NM	bng_e BNG E	bng_n BNG N	long LONG	lat LAT	shape_area Shape, Area	shape_length Shape, Length	globalid GlobalID
1	E23000001	Metropolitan Police	517515	178392	-0.30866	51.492271	1580269249.39969	278070.91832314	375787a7-ebf6-4938-83b4-052f2aef6a39
2	E23000002	Cumbria	341868	527180	-2.90213	54.636379	6828753017.97516	552617.827159998	208e5ca2-b3e3-4ae7-8678-2612ea170092
3	E23000003	Lancashire	363725	441045	-2.55307	53.864349	3069683016.05293	428914.741059642	bc2f7236-3605-45e6-8a7e-90c5ed9459d0
4	E23000004	Merseyside	344342	390164	-2.83866	53.405361	645147927.312691	243131.508913933	e411b7ee-2dd7-4da8-8b1f-8515813d11ed
5	E23000005	Greater Manchester	377940	401102	-2.33407	53.506149	1273598337.12234	206057.361351532	9502349c-581d-47d5-83b0-b2a8890faab8
6	E23000006	Cheshire	368759	368676	-2.46927	53.21423	2346203706.00152	329150.156891153	b33d4d92-611c-4265-918a-722a46cd2f1a
7	E23000007	Northumbria	398895	602529	-2.01896	55.31683	5576317563.97832	505897.631580766	840643ee-17d6-4d2b-b5d3-7c693b931250
8	E23000008	Durham	410381	532242	-1.8405	54.685131	2429938288.03561	286768.199892384	a05c92aa-329b-41d1-8a57-9bada5a47c01
9	E23000009	North Yorkshire	429509	466515	-1.55032	54.093712	8328703994.10568	605803.483324213	539d978e-fc06-4da9-9beb-abe078a572e0
10	E23000010	West Yorkshire	418686	427238	-1.71817	53.741199	2029163329.69075	240199.032682458	b22f8463-f677-4477-ac78-68bafc4c61c8


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