About this Dataset

DOT In-house Street Resurfacing Projects

List of all New York City Department of Transportation (NYC DOT) in-house street paving and milling projects for a street block or at an intersection. For information, please the DOT website: https://www.nyc.gov/html/dot/html/motorist/resurfintro.shtml
Organization: City of New York
Last updated: 2024-09-20T20:13:37.568936
Tags: milling, pavement, paving, project, resurfacing, street

Tables

Table 1

@usgov.city_of_new_york_dot_in_house_street_resurfacing_projects.table_1

90.63 MB
590,890 rows
21 columns

CREATE TABLE table_1 (
  "oft_code" VARCHAR,
  "project_type" VARCHAR,
  "borough_code" VARCHAR,
  "location_on_street" VARCHAR,
  "location_from_street" VARCHAR,
  "location_to_street" VARCHAR,
  "project_id" VARCHAR,
  "project_status" VARCHAR,
  "project_speed_bumps" DOUBLE,
  "location_community_board" DOUBLE,
  "location_actual_milling_start_date" TIMESTAMP,
  "location_actual_milling_end_date" TIMESTAMP,
  "location_actual_paving_start_date" TIMESTAMP,
  "location_actual_paving_end_date" TIMESTAMP,
  "location_actual_protect_until" TIMESTAMP,
  "location_actual_lane_miles_paved" DOUBLE,
  "location_actual_paving_square_yard" DOUBLE,
  "location_status" VARCHAR,
  "location_segment_id" DOUBLE,
  "location_wkt" VARCHAR,
  "location_node_id" VARCHAR
);