About this Dataset

TRANSPORTATION.markings Short Line

Line feature class of short line markings. The assets were referenced using NearMap imagery and work orders submitted through the Signs and Markings Data Tracker. The short line assets use segment ID and intersection ID as a spatial reference. Short line includes crosswalks, stop lines, school zone lines, and yield lines.
Organization: City of Austin
Last updated: 2022-12-23T08:41:24.611032
Tags: agoltosocrata, atd, continental, crosswalks, marking, school-zone-line, stop-bar, stop-line, transverse, yield-lines

Tables

Table 1

@usgov.city_of_austin_transportation_markings_short_line_data.table_1

2.21 MB
16,308 rows
34 columns

CREATE TABLE table_1 (
  "the_geom" VARCHAR,
  "objectid" BIGINT,
  "intersection_id" BIGINT,
  "segment_id" DOUBLE,
  "description" VARCHAR,
  "comments" VARCHAR,
  "short_line_type" VARCHAR,
  "subtype" VARCHAR,
  "marking_text_note" VARCHAR,
  "cbd" VARCHAR,
  "signal_intersection" VARCHAR,
  "other_area" VARCHAR,
  "school" VARCHAR,
  "school_zone_id" DOUBLE,
  "school_name" VARCHAR,
  "school_desc" VARCHAR,
  "alternate_id" VARCHAR,
  "location_status" VARCHAR,
  "material" VARCHAR,
  "color" VARCHAR,
  "direction" VARCHAR,
  "asset_condition" VARCHAR,
  "crew_assigned" VARCHAR,
  "created_by" VARCHAR,
  "created_date" VARCHAR,
  "modified_by" VARCHAR,
  "modified_date" VARCHAR,
  "markings_short_line_id" BIGINT,
  "shape_length" DOUBLE  -- Shape, Length,
  "marking_size" VARCHAR,
  "number_of_assets" DOUBLE,
  "globalid" VARCHAR,
  "last_work_date" VARCHAR,
  "hin" VARCHAR
);