Name: Overhead Electronic Signs
Creator: US Government
License: https://www.usa.gov/government-works

About this Dataset

Overhead Electronic Signs

Electronic Signs are used to display dynamic messages that advise drivers of street closures, delays, severe weather, and other road conditions.
Organization: City of New York
Last updated: 2020-11-10T17:06:24.202491
Tags: 311-message-board-variable-message-sign-vms

Tables

Table 1

@usgov.city_of_new_york_overhead_electronic_signs.table_1

23.07 KB
145 rows
19 columns


CREATE TABLE table_1 (
  "vms" VARCHAR,
  "main_roadway" VARCHAR,
  "direction" VARCHAR,
  "cross_street" VARCHAR,
  "borough" VARCHAR,
  "borocode" BIGINT,
  "borocd" DOUBLE,
  "coundist" DOUBLE,
  "assemdist" DOUBLE,
  "stsendist" DOUBLE,
  "congdist" DOUBLE,
  "type" VARCHAR,
  "owner" VARCHAR,
  "femafldz" VARCHAR,
  "femafldt" VARCHAR,
  "hrcevac" DOUBLE,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "the_geom" VARCHAR
);