Capital Projects by US Government | Finance and Economics

About this Dataset

Capital Projects

City of Pittsburgh Capital Projects Budgets

NOTE: The data in this dataset has not updated since 2021 because of a broken data feed. We're working to fix it.
Organization: Allegheny County / City of Pittsburgh / Western PA Regional Data Center
Last updated: 2023-01-24T18:06:00.257837
Tags: _etl, assets, capital-projects, facilities, facility, infrastructure, investment, mobility

Tables

Capital Projects

@usgov.allegheny_county_city_of_pitts_capital_projects_cfebb.capital_projects

68.52 KB
1002 rows
22 columns


CREATE TABLE capital_projects (
  "n__id" BIGINT,
  "id" BIGINT,
  "name" VARCHAR,
  "task_description" VARCHAR,
  "area" VARCHAR,
  "budgeted_amount" DOUBLE,
  "status" VARCHAR,
  "asset_id" VARCHAR,
  "asset_type" VARCHAR,
  "fiscal_year" BIGINT,
  "start_date" TIMESTAMP,
  "inactive" VARCHAR,
  "neighborhood" VARCHAR,
  "council_district" DOUBLE,
  "ward" DOUBLE,
  "tract" DOUBLE,
  "public_works_division" DOUBLE,
  "pli_division" DOUBLE,
  "police_zone" DOUBLE,
  "fire_zone" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE
);

Capital Projects Data Dictionary

@usgov.allegheny_county_city_of_pitts_capital_projects_cfebb.capital_projects_data_dictionary

8.84 KB
21 rows
10 columns


CREATE TABLE capital_projects_data_dictionary (
  "name" VARCHAR,
  "fieldname" VARCHAR,
  "fielddescription" VARCHAR,
  "fielddescription_1" VARCHAR,
  "dataformat" VARCHAR,
  "length" VARCHAR,
  "uniqueid" VARCHAR,
  "permittedvalues" VARCHAR,
  "fieldpublicaccesslevel" VARCHAR,
  "fieldpublicaccesslevelcomment" VARCHAR
);