About this Dataset

TRANSPORTATION Markings Specialty Line

Line 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 include delineators, curbs, raised pavement marking lane seperators, and concrete domes.
Organization: City of Austin
Last updated: 2022-12-23T08:53:49.700994
Tags: agoltosocrata, 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_line_data.table_1

1.08 MB
5,876 rows
30 columns

CREATE TABLE table_1 (
  "the_geom" VARCHAR,
  "objectid" BIGINT,
  "markings_specialty_line_id" BIGINT,
  "intersection_id" BIGINT,
  "segment_id" DOUBLE,
  "alternate_id" DOUBLE,
  "location_description" VARCHAR,
  "location_status" VARCHAR,
  "direction" VARCHAR,
  "specialty_line_type" VARCHAR,
  "number_of_assets" DOUBLE,
  "marking_text_note" VARCHAR,
  "material" VARCHAR,
  "color" VARCHAR,
  "install_date" VARCHAR,
  "asset_condition" VARCHAR,
  "crew_assigned" VARCHAR,
  "comments" VARCHAR,
  "created_by" VARCHAR,
  "created_date" VARCHAR,
  "modified_by" VARCHAR,
  "modified_date" VARCHAR,
  "globalid" VARCHAR,
  "shape_length" DOUBLE  -- Shape, Length,
  "school" VARCHAR,
  "hin" VARCHAR,
  "bike" VARCHAR,
  "other_area" VARCHAR,
  "signal_intersection" VARCHAR,
  "cbd" VARCHAR
);