Interagency Coordination And Construction Permits Data (MOSYS) by US Government | Finance and Economics

About this Dataset

Interagency Coordination And Construction Permits Data (MOSYS)

NYC Parks' database of external capital projects affecting parkland.

Data Dictionary and User Guide: https://docs.google.com/spreadsheets/d/1Xx4yDs00L2ab8M4HH9GLTF47Fkt8oXDvr8WtSpTFsm8/edit?usp=sharing
Organization: City of New York
Last updated: 2020-11-10T17:06:01.997567
Tags: bt, capital, coned, dcula, ddc, dep, dot, edc, lirr, mta, national-grid, panynj, parkland, parks, rioc, sca

Tables

Table 1

@usgov.city_of_new_york_interagency_coordination_and_construc_a5afffb8.table_1

331.7 KB
952 rows
56 columns


CREATE TABLE table_1 (
  "project_name" VARCHAR,
  "project_received_date" TIMESTAMP,
  "project_id_number_op" VARCHAR,
  "project_description" VARCHAR,
  "impacted_park_id_s" VARCHAR,
  "impacted_park_name_s" VARCHAR,
  "address_or_intersection" VARCHAR,
  "borough" VARCHAR,
  "multisite_project" VARCHAR,
  "sponsoring_entity" VARCHAR,
  "primary_scope_of_work" VARCHAR,
  "impacted_parks_division_s" VARCHAR,
  "park_impact_type" VARCHAR,
  "contract_value_op" DOUBLE,
  "current_phase" VARCHAR,
  "scoping_initiated_kick_off_op" VARCHAR,
  "scoping_response_due_date_op" TIMESTAMP,
  "design_consultant_op" VARCHAR,
  "pdc_approval_required" VARCHAR,
  "preliminary_pdc_approval" VARCHAR,
  "final_pdc_approval" VARCHAR,
  "mass_mailing_1_received_date" VARCHAR,
  "mass_mailing_2_received_date" TIMESTAMP,
  "mass_mailing_3_received_date" VARCHAR,
  "design_completion_date_op" VARCHAR,
  "construction_manager_op" VARCHAR,
  "construction_manager_company_op" VARCHAR,
  "construction_kickoff" TIMESTAMP,
  "expected_construction_end_date_op" TIMESTAMP,
  "actual_construction_end_date_op" TIMESTAMP,
  "contractor_for_construction_permit_firm_name" VARCHAR,
  "construction_permit_request_received_date" TIMESTAMP,
  "construction_permit_id" VARCHAR,
  "latest_site_visit" TIMESTAMP,
  "forestry_permit_status" VARCHAR,
  "forestry_permit_id_number" VARCHAR,
  "construction_permit_special_conditions" VARCHAR,
  "borough_approval_date" VARCHAR,
  "permit_issuance_date" TIMESTAMP,
  "permit_start_date" TIMESTAMP,
  "original_permit_expiration_date" VARCHAR,
  "latest_permit_extension_amendment_request_date" TIMESTAMP,
  "latest_permit_extension_amendment_issuance_date" TIMESTAMP,
  "latest_permit_expiration_date" TIMESTAMP,
  "permit_amendment_content" VARCHAR,
  "exploratory_permit_id" VARCHAR,
  "substantial_completion_date" TIMESTAMP,
  "final_inspection_date" TIMESTAMP,
  "latest_inspection_site_visit" TIMESTAMP,
  "punchlist_generated" TIMESTAMP,
  "conditional_letter_issued" TIMESTAMP,
  "final_acceptance_of_park_by_borough" VARCHAR,
  "final_acceptance_letter_date" VARCHAR,
  "created" TIMESTAMP,
  "modified" TIMESTAMP,
  "coordinates" VARCHAR
);