About this Dataset

Closed Circuit TV Street Cameras

Closed Circuit TV Street Cameras locations. The dataset contains locations and attributes of CCTV and other cameras, created as part of the DC Geographic Information System (DC GIS) for the D.C. Office of the Chief Technology Officer (OCTO) and participating D.C. government agencies.
Organization: District of Columbia
Last updated: 2024-04-30T17:37:51.644357
Tags: camera, cctv, commuter, congestion, d-c, dc, dc-gis, dcgis, district-of-columbia, public-safety, street, traffic, transportation, washington, washington-dc

Tables

Table 1

@usgov.district_of_columbia_closed_circuit_tv_street_cameras.table_1

119.84 kB
932 rows
32 columns

CREATE TABLE table_1 (
  "id" DOUBLE,
  "name" VARCHAR,
  "address" VARCHAR,
  "ward" VARCHAR,
  "police_district" DOUBLE,
  "psa" DOUBLE,
  "department" VARCHAR,
  "install_year" DOUBLE,
  "ps_14" DOUBLE,
  "ps_32" DOUBLE,
  "vdrvp_w_s" DOUBLE,
  "total_site_servers" DOUBLE,
  "monitor" DOUBLE,
  "exterior_cam" DOUBLE,
  "interior_cam" DOUBLE,
  "ptz_cam" DOUBLE,
  "total_stationary_cam" DOUBLE,
  "total_site_camera" DOUBLE,
  "total_site_camera2" DOUBLE,
  "available_camera_port" DOUBLE,
  "description" VARCHAR,
  "x" DOUBLE,
  "y" DOUBLE,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "mar_id" DOUBLE,
  "created_user" VARCHAR,
  "created_date" TIMESTAMP,
  "last_edited_user" VARCHAR,
  "last_edited_date" TIMESTAMP,
  "globalid" VARCHAR,
  "objectid" BIGINT
);