Baselight
Sign In

CCTV Cameras

Plymouth City Council

@ukgov.cctv_locations_in_plymouth

Redeployable Cameras
@ukgov.cctv_locations_in_plymouth.redeployable_cameras

  • 6.04 KB
  • 14 rows
  • 7 columns
fid

Fid

camera_num

Camera Num

camera_loc

Camera Loc

easting

Easting

northing

Northing

x

X

y

Y

12011Biddick Drive24581156749-4.17048750.39034
22012Killerton Lane25056854058-4.10255350.367388
32016Martin Street24704354307-4.15217950.368717
42015North Road East24703754996-4.15254350.374907
52020Whitleigh Bridge24722859594-4.15173150.416281
62021Elphinstone Carpark24827853778-4.1346150.364285
72022Bretonside24824354482-4.13538450.370597
82023Coypool Carpark25205256926-4.08282650.393536
92025North Down Cresent24560056839-4.17348950.391091
102026Royal Parade24775154449-4.14228850.37018

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