Capital Project Tracker by US Government | Finance and Economics

About this Dataset

Capital Project Tracker

A listing of all capital projects managed by NYC Parks, and a timeline for their completion.

Supporting documentation can be found at the following link (http://www.nycgovparks.org/bigapps/desc/DPR_CapitalProjectTracker_001.txt).

See JSON and XML feeds here https://data.cityofnewyork.us/Recreation/Capital-Project-Tracker/qiwj-i2jk
Organization: City of New York
Last updated: 2020-11-10T17:00:40.300879
Tags: capital-projects, parks

Tables

Table 1

@usgov.city_of_new_york_capital_projects_tracker.table_1

314.92 KB
2620 rows
29 columns


CREATE TABLE table_1 (
  "trackerid" BIGINT,
  "fmsid" VARCHAR,
  "title" VARCHAR,
  "summary" VARCHAR,
  "currentphase" VARCHAR,
  "designpercentcomplete" BIGINT,
  "procurementpercentcomplete" BIGINT,
  "constructionpercentcomplete" DOUBLE,
  "designstart" VARCHAR,
  "designprojectedcompletion" VARCHAR,
  "designadjustedcompletion" VARCHAR,
  "designactualcompletion" VARCHAR,
  "procurementstart" VARCHAR,
  "procurementprojectedcompletion" VARCHAR,
  "procurementadjustedcompletion" VARCHAR,
  "procurementactualcompletion" VARCHAR,
  "constructionstart" VARCHAR,
  "constructionprojectedcompletion" VARCHAR,
  "constructionadjustedcompletion" VARCHAR,
  "constructionactualcompletion" VARCHAR,
  "totalfunding" VARCHAR,
  "projectliaison" VARCHAR,
  "lastupdated" VARCHAR,
  "fundingsource" VARCHAR,
  "name" VARCHAR,
  "parkid" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "borough" VARCHAR
);