About this Dataset

Street And Highway Capital Reconstruction Projects - Intersection

This data is a spatial representation of street construction projects. Street and Highway capital projects are major street reconstruction projects, ranging from general street resurfacing projects to full reconstruction of the roadbed, sidewalks, sewer and water pipes and other utilities. Capital projects are essential to keep the City's infrastructure in a state of good repair.
Organization: City of New York
Last updated: 2021-08-07T16:38:04.140389
Tags: capital-projects, construction, highway, roadbed, sidewalk, street

Tables

Table 1

@usgov.city_of_new_york_street_and_highway_capital_reconstruc_9847c26f.table_1

735.11 kB
7,624 rows
30 columns

CREATE TABLE table_1 (
  "the_geom" VARCHAR,
  "projectid" BIGINT,
  "projtitle" VARCHAR,
  "fmsid" VARCHAR,
  "fmsagencyid" BIGINT,
  "leadagency" VARCHAR,
  "managing_agency" BIGINT,
  "projectdescription" VARCHAR,
  "projecttypecode" VARCHAR,
  "projecttype" VARCHAR,
  "projectstatus" VARCHAR,
  "constructionfy" BIGINT,
  "designstartdate" VARCHAR,
  "constructionenddate" VARCHAR,
  "currentfunding" BIGINT,
  "projectcost" BIGINT,
  "oversallscope" VARCHAR,
  "safetyscope" VARCHAR,
  "otherscope" VARCHAR,
  "projectjustification" VARCHAR,
  "onstreetname" VARCHAR,
  "fromstreetname" VARCHAR,
  "tostreetname" VARCHAR,
  "boroughname" VARCHAR,
  "oftcode" BIGINT,
  "designfy" BIGINT,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "x" DOUBLE,
  "y" DOUBLE
);