Name: Borough Engineering Tracking System
Creator: US Government
License: https://www.usa.gov/government-works

About this Dataset

Borough Engineering Tracking System

Tracking system for sign related requests that are received by each borough engineering operation.
Organization: City of New York
Last updated: 2020-11-10T17:00:43.160378
Tags: bets, borough-engineering, signs, traffic-control

Tables

Table 1

@usgov.city_of_new_york_borough_engineering_tracking_system.table_1

4.58 MB
91,711 rows
24 columns

CREATE TABLE table_1 (
  "requestnumber" VARCHAR,
  "divisionname" VARCHAR,
  "status" VARCHAR,
  "channel" VARCHAR,
  "category" VARCHAR,
  "requesttype" VARCHAR,
  "priority" VARCHAR,
  "multiple" VARCHAR,
  "requestdetail" VARCHAR,
  "requestortypes" VARCHAR,
  "datereceived" TIMESTAMP,
  "datecreated" TIMESTAMP,
  "duedate" TIMESTAMP,
  "dateclosed" TIMESTAMP,
  "dateassigned" TIMESTAMP,
  "datereferred" TIMESTAMP,
  "datereferredtoccu" TIMESTAMP,
  "housenumber" VARCHAR,
  "mainstreet" VARCHAR,
  "mainstreetcode" VARCHAR,
  "crossstreet1" VARCHAR,
  "crossstreet1code" VARCHAR,
  "crossstreet2" VARCHAR,
  "crossstreet2code" VARCHAR
);