CCTV Cameras

Leicester City Council

@ukgov.cctv_cameras5

Table List

1 table(34.55 KB)

Table 1

@ukgov.cctv_cameras5.table_1

CCTV Cameras (csv)

34.55 KB
554 rows
8 columns

camera_no Camera No	location_detail Location Detail	camera_type Camera Type	easting Easting	northing Northing	latitude Latitude	longitude Longitude	location Location
1	PTZ North	Haymarket Bus Station	458865	304875	52.63844	-1.13156	52.63844, -1.13156
2	PTZ Central	Haymarket Bus Station	458869	304832	52.63805	-1.13151	52.63805, -1.13151
14	Ext LHS Yard	Haymarket Bus Station	458873	304884	52.63852	-1.13144	52.63852, -1.13144
15	Ext RHS Yard	Haymarket Bus Station	458883	304846	52.63817	-1.1313	52.63817, -1.1313
20	Regent Road/De Montfort St	Traffic/Public Space Camera	459256	303606	52.62699	-1.12601	52.62699, -1.12601
26	Melton Road/Lanesborough Road	Traffic/Public Space Camera	460052	307406	52.66106	-1.11357	52.66106, -1.11357
27	Red Hill Way	Traffic/Public Space Camera	459004	307782	52.66455	-1.12899	52.66455, -1.12899
29	Uppingham Road/Colchester Road	Traffic/Public Space Camera	462807	304826	52.63756	-1.07333	52.63756, -1.07333
37	Northgate/Sanvey Gate	Traffic/Public Space Camera	458206	304956	52.63924	-1.14129	52.63924, -1.14129
43	Derby Rd/Belton Road, Loughboro'	Traffic/Public Space Camera	452119	319924	52.7744	-1.22886	52.7744, -1.22886


CREATE TABLE table_1 (
  "camera_no" VARCHAR,
  "location_detail" VARCHAR,
  "camera_type" VARCHAR,
  "easting" BIGINT,
  "northing" BIGINT,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "location" VARCHAR
);

Share link

Anyone who has the link will be able to view this.