Name: PSS Public Bid Point
Creator: US Government
License: http://creativecommons.org/licenses/by/4.0/legalcode

About this Dataset

PSS Public Bid Point

Iowa DOT project data from Project Scheduling System (PSS) data.
Organization: State of Iowa
Last updated: 2024-04-12T12:48:55.374138
Tags: asset, asset-improvement, improvement, project-scheduling, projects, pss

Tables

Table 1

@usgov.state_of_iowa_pss_public_bid_point_data.table_1

108.21 kB
362 rows
49 columns

CREATE TABLE table_1 (
  "the_geom" VARCHAR,
  "objectid" BIGINT,
  "status" VARCHAR,
  "district" BIGINT,
  "county_number" BIGINT,
  "county_name" VARCHAR,
  "route_system" VARCHAR,
  "route_name" VARCHAR,
  "traveled_way" VARCHAR,
  "pin" VARCHAR,
  "project_number" VARCHAR,
  "assigned_to" VARCHAR,
  "location" VARCHAR,
  "work_description" VARCHAR,
  "design_number" BIGINT,
  "design_number_county" BIGINT,
  "design_number_description" VARCHAR,
  "station_number" VARCHAR,
  "existing_fhwa_number" DOUBLE,
  "replacment_fhwa_number" DOUBLE,
  "maintenance_number" VARCHAR,
  "letting_fiscal_year" BIGINT,
  "contract_awarded_utc" VARCHAR  -- Contract Awarded (UTC),
  "construction_actual_start_utc" VARCHAR  -- Construction Actual Start (UTC),
  "program_estimate" BIGINT,
  "awarded" DOUBLE,
  "final_contract" DOUBLE,
  "abstract_utc" VARCHAR  -- Abstract (UTC),
  "rce" VARCHAR,
  "rce_engineer" VARCHAR,
  "contract_id" VARCHAR,
  "contract_description" VARCHAR,
  "contract_id_2" DOUBLE,
  "contractor" VARCHAR,
  "district_435" TIMESTAMP,
  "materials_436" TIMESTAMP,
  "district_436" TIMESTAMP,
  "final_central_office" TIMESTAMP,
  "as_built" TIMESTAMP,
  "utility_assigned_to" VARCHAR,
  "railroad_involved" VARCHAR,
  "railroad_agreement" VARCHAR,
  "ukey" BIGINT,
  "route_id" VARCHAR,
  "pss_from_measure" VARCHAR,
  "pss_to_measure" VARCHAR,
  "rest_service_last_updated_utc" VARCHAR  -- Rest Service Last Updated (UTC),
  "rest_utc_offset" VARCHAR,
  "globalid" VARCHAR
);