CCTV Cameras

Plymouth City Council

@ukgov.cctv_locations_in_plymouth

Table List

5 tables(36.15 KB)

Traffic Cameras

@ukgov.cctv_locations_in_plymouth.traffic_cameras

7.59 KB
43 rows
7 columns

fid Fid	camera_num Camera Num	camera_loc Camera Loc	easting Easting	northing Northing	x X	y Y
1	1002	Cattedown Roundabout	248978	54397	-4.125025	50.370026
2	1040	Chales Church/ edbrington street	248211	54676	-4.135915	50.372335
3	1041	Viaduct North	248183	54585	-4.136269	50.371514
4	1042	Viaduct South	248057	54488	-4.13801	50.370604
5	1013	Western Approach/Union Street	247298	54442	-4.148655	50.369995
6	1010	Northcross Roubdabout	247773	55093	-4.142235	50.375967
7	1031	Heles Terrace	249768	54464	-4.113951	50.370831
8	1032	Laira Bridge	250026	54309	-4.110267	50.369506
9	1003	Camels Head Junction	245240	57366	-4.178778	50.395738
10	1001	Exeter Street	248290	54600	-4.134781	50.371672


CREATE TABLE traffic_cameras (
  "fid" BIGINT,
  "camera_num" BIGINT,
  "camera_loc" VARCHAR,
  "easting" BIGINT,
  "northing" BIGINT,
  "x" DOUBLE,
  "y" DOUBLE
);