This post is an update of a previous project to create a markings asset counts for each street segment. This update will separate the assets into bike lane and non-bike lane assets.

Here is the link to notebook

The purpose is to estimate the total pavement markings asset counts over the next 5 years from fiscal year 2020 to 2024 using the markings asset feature layers from ArcGIS Online.

Disclaimer: This product is for informational purposes and may not have been prepared for or be suitable for legal, engineering, or surveying purposes. No warranty is made by the City of Austin regarding specific accuracy or completeness.

This project would not have been completed without the help from:

  • pandas to create dataframe of extracted table and transform the data
  • geopandas to access attribute table of 5 year selected segments for SBO
  • arcgis to search for markings feature layer dataset