Name: Street Centerline
Creator: US Government
License: https://www.usa.gov/government-works

About this Dataset

Street Centerline

Street Segments
Organization: City of Austin
Last updated: 2022-12-23T08:40:44.088468
Tags: agoltosocrata, segment

Tables

Table 1

@usgov.city_of_austin_street_centerline_data.table_1

15.01 MB
67,770 rows
33 columns

CREATE TABLE table_1 (
  "the_geom" VARCHAR,
  "object_id" BIGINT,
  "segment_id" BIGINT,
  "prefix_direction" VARCHAR,
  "prefix_type" VARCHAR,
  "street_name" VARCHAR,
  "street_type" VARCHAR,
  "suffix_direction" VARCHAR,
  "left_from_address" BIGINT,
  "left_to_address" BIGINT,
  "right_from_address" BIGINT,
  "right_to_address" BIGINT,
  "left_block_from" DOUBLE,
  "left_block_to" DOUBLE,
  "right_block_from" DOUBLE,
  "right_block_to" DOUBLE,
  "full_street_name" VARCHAR,
  "road_class" BIGINT,
  "speed_limit" BIGINT,
  "elevation_from" DOUBLE,
  "elevation_to" DOUBLE,
  "one_way" VARCHAR,
  "cad_id" BIGINT,
  "street_place_id" BIGINT,
  "created_date" VARCHAR,
  "created_by" VARCHAR,
  "modified_by" VARCHAR,
  "modified_date" VARCHAR,
  "miles" DOUBLE,
  "seconds" DOUBLE,
  "built_status" BIGINT,
  "shape_length" DOUBLE  -- Shape, Length,
  "posted_speed_limit" DOUBLE
);