About this Dataset

Sidewalks

Inventory of absent and existing sidewalks, driveways and pedestrian facilities for the City of Austin.
This layer depicts an inventory of sidewalk infrastructure. This data was collected in 2006/2007 as part of the sidewalk master plan.
Organization: City of Austin
Last updated: 2022-12-23T08:55:58.612343
Tags: agoltosocrata, infrastructure, mobility, network, pedestrian, sidewalk, sidewalks, transportation

Tables

Table 1

@usgov.city_of_austin_sidewalks_eb9f5.table_1

71.64 MB
351,464 rows
62 columns

CREATE TABLE table_1 (
  "the_geom" VARCHAR,
  "objectid" BIGINT,
  "sidewalks_id" BIGINT,
  "full_street_name" VARCHAR,
  "pedestrian_facility_type" VARCHAR,
  "created_by" VARCHAR,
  "created_date" VARCHAR,
  "modified_by" VARCHAR,
  "modified_date" VARCHAR,
  "shape_length" DOUBLE  -- Shape, Length,
  "functional_condition" VARCHAR,
  "public_works_id" DOUBLE,
  "address_description" VARCHAR,
  "rating_overall" DOUBLE,
  "rating_no_veg" DOUBLE,
  "assessment_date" VARCHAR,
  "ada_year_route_checked" DOUBLE,
  "width" DOUBLE,
  "width_sidewalk" DOUBLE,
  "sidewalk_segments_length" DOUBLE,
  "back_of_curb" VARCHAR,
  "sidewalk_surface" VARCHAR,
  "colored_finish" VARCHAR,
  "stamped_finish" VARCHAR,
  "year_built" DOUBLE,
  "managing_agency" VARCHAR,
  "planning_status" DOUBLE,
  "planning_status_rehab" DOUBLE,
  "sub_project_id" DOUBLE,
  "fund_department_unit" VARCHAR,
  "contract" VARCHAR,
  "work_assignment" VARCHAR,
  "construction_constraint" DOUBLE,
  "assigned_for_construction_date" VARCHAR,
  "construction_start" DOUBLE,
  "date_construction_completed" VARCHAR,
  "functional_improve_rehab" VARCHAR,
  "functional_improve_lift" VARCHAR,
  "functional_improve_grind" VARCHAR,
  "functional_improve_cut" VARCHAR,
  "notes" VARCHAR,
  "council_district" DOUBLE,
  "mapsco" VARCHAR,
  "zipcode" VARCHAR,
  "mxaddresscode" DOUBLE,
  "mxlocation" DOUBLE,
  "status" VARCHAR,
  "globalid" VARCHAR,
  "rating_curbramp" DOUBLE,
  "rating_final" DOUBLE,
  "rating_curbramp_id" DOUBLE,
  "project_manager" VARCHAR,
  "construction_manager" VARCHAR,
  "mobility_annual_plan" VARCHAR,
  "assessment_type" DOUBLE,
  "core_sw_network" VARCHAR,
  "leveraging" VARCHAR,
  "service_plan_note" VARCHAR,
  "created_user" VARCHAR,
  "last_edited_user" VARCHAR,
  "last_edited_date" VARCHAR,
  "urban_trail_network" VARCHAR
);