TRANSPORTATION.markings Short Line by US Government | Demographics and Population Studies

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.11 MB
16308 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,
  "marking_size" VARCHAR,
  "number_of_assets" DOUBLE,
  "globalid" VARCHAR,
  "last_work_date" VARCHAR,
  "hin" VARCHAR
);