About this Dataset

Street And Highway Capital Reconstruction Projects - Block

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-07T17:14:24.883548
Tags: capital-projects, construction, highway, roadbed, sidewalk, street

Tables

Table 1

@usgov.city_of_new_york_street_and_highway_capital_reconstruc_74f63c7c.table_1

973.3 kB
11,669 rows
27 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" DOUBLE,
  "oversallscope" VARCHAR,
  "otherscope" VARCHAR,
  "projectjustification" VARCHAR,
  "onstreetname" VARCHAR,
  "fromstreetname" VARCHAR,
  "tostreetname" VARCHAR,
  "boroughname" VARCHAR,
  "oftcode" BIGINT,
  "locationgeometry_stlength" DOUBLE  -- LocationGeometry.STLength(),
  "designfy" BIGINT,
  "safetyscope" VARCHAR
);