About this Dataset

Arterial Management Materials Warehouse Inventory

This dataset contains information about the materials warehouse for the City of Austin Transportation Department's Arterial Management Division.

It is updated daily and provides a running count of materials on-hand, and is used for internal reporting purposes.
Organization: City of Austin
Last updated: 2022-01-24T23:23:25.672036
Tags: infrastructure-maintenance, physical-materials, transportation

Tables

Table 1

@usgov.city_of_austin_arterial_management_materials_warehouse_44c82028.table_1

1.11 MB
346,662 rows
17 columns

CREATE TABLE table_1 (
  "financial_name" VARCHAR,
  "common_name" VARCHAR,
  "tracking_type" VARCHAR,
  "stock_number" VARCHAR,
  "category" VARCHAR,
  "object" VARCHAR,
  "unit_cost" DOUBLE,
  "unit_of_measure" VARCHAR,
  "status" VARCHAR,
  "re_order_threshold" DOUBLE,
  "total_on_hand" DOUBLE,
  "total_value" DOUBLE,
  "modified_date" TIMESTAMP,
  "published_date" VARCHAR,
  "record_id" VARCHAR,
  "re_order_turnaround_time" VARCHAR,
  "re_order_status" VARCHAR
);