About this Dataset

Transportation Capital Project Financial Codes

This dataset contains financial tracking codes used by City of Austin staff to manage capital projects. Our internal project management application consumes data directly from this dataset. This data is subset of the canonical data maintained by the City of Austin Financial Services Division. https://www.austintexas.gov/fsd
Organization: City of Austin
Last updated: 2022-09-02T18:37:55.380572
Tags: capital-projects, mobility, transportation

Tables

Table 1

@usgov.city_of_austin_transportation_capital_project_financial_codes.table_1

158.61 kB
2,219 rows
16 columns

CREATE TABLE table_1 (
  "dept_code_name" VARCHAR,
  "sub_project_id" BIGINT,
  "subproject_id_uk" BIGINT,
  "sp_number_txt" DOUBLE,
  "fdu_id" BIGINT,
  "fdu" VARCHAR,
  "fund" VARCHAR,
  "fundname" VARCHAR,
  "dept" BIGINT,
  "dept_id" BIGINT,
  "dept_unit_id" BIGINT,
  "dept_unit_status" VARCHAR,
  "unit" VARCHAR,
  "unit_long_name" VARCHAR,
  "unit_short_name" VARCHAR,
  "sp_number_txt_txt" VARCHAR
);