About this Dataset

TRANSPORTATION Marking Long Line Dates

This dataset contains information about long line markings work performed since 2019 by the Signs and Markings Division in the Transportation and Public Works Department. Related table of long line markings dates. The work order ID originated from the roadway markings work orders and the contractor work order dataset that pulls from the Signs and Markings Operations Work Order tracking system. The work dates originate from data tracker or were collected in GIS prior to the association of work order IDs to long line markings assets. Long line includes high level location information about which roadways have long line markings.

The spatial geometry of the Long Line Markings Data along with the related table holding the work dates information is available publicly in ArcGIS Online -
https://austin.maps.arcgis.com/home/item.html?id=6fb83b60b8b841529336b5becbe9dd36
Organization: City of Austin
Last updated: 2024-11-25T12:13:39.428342
Tags: atd, austin, dates, lane-lines, long-line, markings, pavement-marking, roadway-markings, signs-and-markings, transportation, transportation-and-public-works

Tables

Table 1

@usgov.city_of_austin_transportation_marking_long_line_dates.table_1

898.66 kB
16,975 rows
14 columns

CREATE TABLE table_1 (
  "objectid" BIGINT,
  "markings_long_line_id" VARCHAR,
  "ctn_segment_id" BIGINT,
  "atd_work_order_id" VARCHAR,
  "type_work" VARCHAR,
  "work_date" VARCHAR,
  "date_source" VARCHAR,
  "work_origin" VARCHAR,
  "asset_condition" VARCHAR,
  "created_by" VARCHAR,
  "created_date" DOUBLE,
  "modified_by" VARCHAR,
  "modified_date" BIGINT,
  "globalid" VARCHAR
);