Name: Cameras
Creator: US Government
License: http://creativecommons.org/licenses/by/4.0/legalcode

About this Dataset

Cameras

Dataset provides data from the Iowa Department of Transportation's Intelligent Transportation System (ITS) CCTV Cameras. Data includes location of cameras, static image URL, and motion video URL where available.
Organization: State of Iowa
Last updated: 2024-04-12T12:46:29.251321
Tags: asset, atms, camera, cctv, freeway, ground, highway, inventory, its, operations, road, tms, traffic, video

Tables

Table 1

@usgov.state_of_iowa_cameras_data.table_1

137.12 kB
1,193 rows
35 columns

CREATE TABLE table_1 (
  "the_geom" VARCHAR,
  "desc" VARCHAR,
  "updatedate" BIGINT,
  "updatetime" BIGINT,
  "utcoffset" BIGINT,
  "linear_reference" DOUBLE,
  "route" VARCHAR,
  "imagename" VARCHAR,
  "imageurl" VARCHAR,
  "videourl" VARCHAR,
  "org" VARCHAR,
  "type" VARCHAR,
  "fid" BIGINT,
  "region" VARCHAR,
  "is_camera_recorded" VARCHAR  -- Is Camera Recorded?,
  "common_camera_id" VARCHAR,
  "function" VARCHAR,
  "item" VARCHAR,
  "device_id" BIGINT,
  "device_id1" VARCHAR,
  "updatedate1" VARCHAR,
  "updatetime1" VARCHAR,
  "utcoffset1" VARCHAR,
  "lat" VARCHAR,
  "lat1" VARCHAR,
  "long" VARCHAR,
  "long1" VARCHAR,
  "linear_reference1" VARCHAR,
  "link" VARCHAR,
  "oid" VARCHAR,
  "oid1" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "high_bandwidth_video_url" VARCHAR,
  "high_definition_video_url" VARCHAR
);