English

How To: Create a time attribute for a network dataset

Summary

Instructions provided shows how to create a time attribute for a network dataset when a MPH and Length field exist.

Procedure

  1. Calculate the length of the street segments. Perform this one of two ways:
    · Import the shapefile into a personal geodatabase.
    · Create a new double field and use the field calculator.
    <a href='http://support.esri.com/en/knowledgebase/techarticles/detail/18675' target='_blank'>FAQ: Can a field be calculated as the area, length, or perimeter of a shape?</a>
  2. Create a new double field in the attribute table.
  3. Right-click on the field and select Calculate Values.
  4. Calculate the time using the following formula in the field calculator:

    [Length_field] / [MPH_field] * 60

    The time is provided in minutes using this formula. It is usually necessary to adjust for another value. For example, multiply by 60 again to receive the time in seconds.