About this Dataset

TRANSPORTATION Markings Specialty Point

Point feature class of specialty markings on the City of Austin maintained streets. The assets were referenced using NearMap imagery and work orders submitted through the Signs and Markings Data Tracker. The dataset use segment ID and intersection ID as a spatial reference. Specialty markings are seperated into types that include arrows, word legends, parking space boundaries, raised pavement markings (RPM), symbols, and other pavement markings.
Organization: City of Austin
Last updated: 2022-12-23T08:37:54.587638
Tags: arrows, atd, legends, marking, parking, pavement-marking, point, raised-pavement-marking, rpm, specialty-markings, symbols, word

Tables

Table 1

@usgov.city_of_austin_transportation_markings_specialty_point_e3a73.table_1

3.93 MB
43,429 rows
29 columns

CREATE TABLE table_1 (
  "the_geom" VARCHAR,
  "objectid" BIGINT,
  "markings_specialty_point_id" BIGINT,
  "intersection_id" BIGINT,
  "segment_id" DOUBLE,
  "alternate_id" VARCHAR,
  "location_description" VARCHAR,
  "location_status" VARCHAR,
  "direction" VARCHAR,
  "specialty_point_type" DOUBLE,
  "specialty_point_sub_type" DOUBLE,
  "marking_text_note" VARCHAR,
  "material" VARCHAR,
  "color" VARCHAR,
  "last_work_date" VARCHAR,
  "asset_condition" VARCHAR,
  "crew_assigned" VARCHAR,
  "comments" VARCHAR,
  "created_by" VARCHAR,
  "created_date" VARCHAR,
  "modified_by" VARCHAR,
  "modified_date" VARCHAR,
  "globalid" VARCHAR,
  "school" VARCHAR,
  "hin" VARCHAR,
  "bike" VARCHAR,
  "other_area" VARCHAR,
  "signal_intersection" VARCHAR,
  "cbd" VARCHAR
);