Name: Annual_Average_Daily_Truck_Traffic__AADTT_

Display Field: ID

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description: This data contains information about all routes in the State of Iowa including Federal, State, County, Municipal, Institutional and Ramp systems. Data is maintained inside the Roadway Asset Management System (RAMS). It is recommended you use this dataset when working with Iowa DOT road network attributes. For additnional infromation on RAMS data, please see https://iowadot.gov/analytics#488921837-data-warehouse.

Copyright Text: Iowa Department of Transportation - Research & Analytics

Min. Scale: 0

Max. Scale: 0

Default Visibility: false

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: -10432725.8024529
YMin: 5153648.84439447
XMax: -10410658.5527556
YMax: 5179382.82021862
Spatial Reference: 102100 (3857)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[158,82,74,255],"width":1}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}

HasZ: true

HasM: true

Has Attachments: false

Has Geometry Properties: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: OBJECTID

Unique ID Field:

Name : OBJECTID

IsSystemMaintained : True

Global ID Field:

Type ID Field:

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• ID (type: esriFieldTypeString, alias: ID, SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)
• ROUTEID (type: esriFieldTypeString, alias: ROUTEID, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
• FROMMEASUR (type: esriFieldTypeDouble, alias: FROMMEASUR, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TOMEASURE (type: esriFieldTypeDouble, alias: TOMEASURE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• COUNTY_NUM (type: esriFieldTypeInteger, alias: COUNTY_NUM, SQL Type: sqlTypeOther, nullable: true, editable: true)
• OWNER_CODE (type: esriFieldTypeInteger, alias: OWNER_CODE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ROAD_SYSTE (type: esriFieldTypeInteger, alias: ROAD_SYSTE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ROAD_STATU (type: esriFieldTypeInteger, alias: ROAD_STATU, SQL Type: sqlTypeOther, nullable: true, editable: true)
• STATE_ROUT (type: esriFieldTypeString, alias: STATE_ROUT, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• STATE_RO_1 (type: esriFieldTypeString, alias: STATE_RO_1, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• SECONDARY_ (type: esriFieldTypeString, alias: SECONDARY_, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• SECONDARY1 (type: esriFieldTypeString, alias: SECONDARY1, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• MUNICIPAL_ (type: esriFieldTypeString, alias: MUNICIPAL_, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• MUNICIPAL1 (type: esriFieldTypeString, alias: MUNICIPAL1, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• COUNTY_SIG (type: esriFieldTypeString, alias: COUNTY_SIG, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• COUNTY_S_1 (type: esriFieldTypeString, alias: COUNTY_S_1, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• H_AND_T (type: esriFieldTypeInteger, alias: H_AND_T, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CITY_NUMBE (type: esriFieldTypeInteger, alias: CITY_NUMBE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ADJACENT_C (type: esriFieldTypeInteger, alias: ADJACENT_C, SQL Type: sqlTypeOther, nullable: true, editable: true)
• URBAN_AREA (type: esriFieldTypeInteger, alias: URBAN_AREA, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ADJACENT_1 (type: esriFieldTypeInteger, alias: ADJACENT_1, SQL Type: sqlTypeOther, nullable: true, editable: true)
• INSTITUTIO (type: esriFieldTypeInteger, alias: INSTITUTIO, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ROAD_FUNCT (type: esriFieldTypeInteger, alias: ROAD_FUNCT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TOLL_CHARG (type: esriFieldTypeInteger, alias: TOLL_CHARG, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TOLL_AUTHO (type: esriFieldTypeInteger, alias: TOLL_AUTHO, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TOLL_TYPE (type: esriFieldTypeInteger, alias: TOLL_TYPE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SPECIAL_SY (type: esriFieldTypeInteger, alias: SPECIAL_SY, SQL Type: sqlTypeOther, nullable: true, editable: true)
• NATIONAL_H (type: esriFieldTypeInteger, alias: NATIONAL_H, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ACCESS_CON (type: esriFieldTypeInteger, alias: ACCESS_CON, SQL Type: sqlTypeOther, nullable: true, editable: true)
• FED_FUNCTI (type: esriFieldTypeInteger, alias: FED_FUNCTI, SQL Type: sqlTypeOther, nullable: true, editable: true)
• HIGHWAY_RE (type: esriFieldTypeString, alias: HIGHWAY_RE, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• PLANNING_C (type: esriFieldTypeInteger, alias: PLANNING_C, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TRUCK_ROUT (type: esriFieldTypeInteger, alias: TRUCK_ROUT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• MEDIAN_TYP (type: esriFieldTypeInteger, alias: MEDIAN_TYP, SQL Type: sqlTypeOther, nullable: true, editable: true)
• MEDIAN_WID (type: esriFieldTypeInteger, alias: MEDIAN_WID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• NUMBER_LAN (type: esriFieldTypeInteger, alias: NUMBER_LAN, SQL Type: sqlTypeOther, nullable: true, editable: true)
• LANE_TYPE_ (type: esriFieldTypeString, alias: LANE_TYPE_, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• LANE_DIREC (type: esriFieldTypeString, alias: LANE_DIREC, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• LANE_TYPE1 (type: esriFieldTypeString, alias: LANE_TYPE1, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• LANE_DIR_1 (type: esriFieldTypeString, alias: LANE_DIR_1, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• LANE_TYP_1 (type: esriFieldTypeString, alias: LANE_TYP_1, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• LANE_DIR_2 (type: esriFieldTypeString, alias: LANE_DIR_2, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• LANE_TYP_2 (type: esriFieldTypeString, alias: LANE_TYP_2, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• LANE_DIR_3 (type: esriFieldTypeString, alias: LANE_DIR_3, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• LANE_TYP_3 (type: esriFieldTypeString, alias: LANE_TYP_3, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• LANE_DIR_4 (type: esriFieldTypeString, alias: LANE_DIR_4, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• LANE_TYP_4 (type: esriFieldTypeString, alias: LANE_TYP_4, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• LANE_DIR_5 (type: esriFieldTypeString, alias: LANE_DIR_5, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• LANE_TYP_5 (type: esriFieldTypeString, alias: LANE_TYP_5, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• LANE_DIR_6 (type: esriFieldTypeString, alias: LANE_DIR_6, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• LANE_TYP_6 (type: esriFieldTypeString, alias: LANE_TYP_6, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• LANE_DIR_7 (type: esriFieldTypeString, alias: LANE_DIR_7, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• LANE_TYP_7 (type: esriFieldTypeString, alias: LANE_TYP_7, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• LANE_DIR_8 (type: esriFieldTypeString, alias: LANE_DIR_8, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• TERRAIN (type: esriFieldTypeInteger, alias: TERRAIN, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TYPE_AREA (type: esriFieldTypeInteger, alias: TYPE_AREA, SQL Type: sqlTypeOther, nullable: true, editable: true)
• MAINTENANC (type: esriFieldTypeInteger, alias: MAINTENANC, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SURFACE_WI (type: esriFieldTypeInteger, alias: SURFACE_WI, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SURFACE_TY (type: esriFieldTypeInteger, alias: SURFACE_TY, SQL Type: sqlTypeOther, nullable: true, editable: true)
• RIGHT_SHOU (type: esriFieldTypeInteger, alias: RIGHT_SHOU, SQL Type: sqlTypeOther, nullable: true, editable: true)
• RIGHT_SH_1 (type: esriFieldTypeInteger, alias: RIGHT_SH_1, SQL Type: sqlTypeOther, nullable: true, editable: true)
• RIGHT_SH_2 (type: esriFieldTypeInteger, alias: RIGHT_SH_2, SQL Type: sqlTypeOther, nullable: true, editable: true)
• RIGHT_SH_3 (type: esriFieldTypeInteger, alias: RIGHT_SH_3, SQL Type: sqlTypeOther, nullable: true, editable: true)
• RIGHT_SH_4 (type: esriFieldTypeInteger, alias: RIGHT_SH_4, SQL Type: sqlTypeOther, nullable: true, editable: true)
• LEFT_SHOUL (type: esriFieldTypeInteger, alias: LEFT_SHOUL, SQL Type: sqlTypeOther, nullable: true, editable: true)
• LEFT_SHO_1 (type: esriFieldTypeInteger, alias: LEFT_SHO_1, SQL Type: sqlTypeOther, nullable: true, editable: true)
• LEFT_SHO_2 (type: esriFieldTypeInteger, alias: LEFT_SHO_2, SQL Type: sqlTypeOther, nullable: true, editable: true)
• LEFT_SHO_3 (type: esriFieldTypeInteger, alias: LEFT_SHO_3, SQL Type: sqlTypeOther, nullable: true, editable: true)
• LEFT_SHO_4 (type: esriFieldTypeInteger, alias: LEFT_SHO_4, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SPEED_LIMI (type: esriFieldTypeInteger, alias: SPEED_LIMI, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PARKING_TY (type: esriFieldTypeInteger, alias: PARKING_TY, SQL Type: sqlTypeOther, nullable: true, editable: true)
• STRATEGIC_ (type: esriFieldTypeInteger, alias: STRATEGIC_, SQL Type: sqlTypeOther, nullable: true, editable: true)
• AADT (type: esriFieldTypeInteger, alias: AADT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• MOTORCYCLE (type: esriFieldTypeInteger, alias: MOTORCYCLE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• AUTOMOBILE (type: esriFieldTypeInteger, alias: AUTOMOBILE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PICKUP (type: esriFieldTypeInteger, alias: PICKUP, SQL Type: sqlTypeOther, nullable: true, editable: true)
• BUS (type: esriFieldTypeInteger, alias: BUS, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SU2AXLE (type: esriFieldTypeInteger, alias: SU2AXLE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SU3AXLE (type: esriFieldTypeInteger, alias: SU3AXLE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SU4AXLE (type: esriFieldTypeInteger, alias: SU4AXLE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ST4AXLE (type: esriFieldTypeInteger, alias: ST4AXLE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ST5AXLE (type: esriFieldTypeInteger, alias: ST5AXLE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ST6AXLE (type: esriFieldTypeInteger, alias: ST6AXLE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• MT5AXLE (type: esriFieldTypeInteger, alias: MT5AXLE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• MT6AXLE (type: esriFieldTypeInteger, alias: MT6AXLE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• MT7AXLE (type: esriFieldTypeInteger, alias: MT7AXLE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SINGLEUNIT (type: esriFieldTypeInteger, alias: SINGLEUNIT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SINGMULTTR (type: esriFieldTypeInteger, alias: SINGMULTTR, SQL Type: sqlTypeOther, nullable: true, editable: true)
• EXPANDED_A (type: esriFieldTypeDouble, alias: EXPANDED_A, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ESTIMATE (type: esriFieldTypeString, alias: ESTIMATE, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• EXPANSION_ (type: esriFieldTypeDouble, alias: EXPANSION_, SQL Type: sqlTypeOther, nullable: true, editable: true)
• FACILITY_T (type: esriFieldTypeInteger, alias: FACILITY_T, SQL Type: sqlTypeOther, nullable: true, editable: true)
• MAINTENA_1 (type: esriFieldTypeInteger, alias: MAINTENA_1, SQL Type: sqlTypeOther, nullable: true, editable: true)
• MAINTENA_2 (type: esriFieldTypeString, alias: MAINTENA_2, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• COUNT_FHWA (type: esriFieldTypeInteger, alias: COUNT_FHWA, SQL Type: sqlTypeOther, nullable: true, editable: true)
• REST_UPDAT (type: esriFieldTypeDate, alias: REST_UPDAT, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• UTC_OFFSET (type: esriFieldTypeString, alias: UTC_OFFSET, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true)
• AADT_YEAR (type: esriFieldTypeInteger, alias: AADT_YEAR, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PERCENT_TR (type: esriFieldTypeInteger, alias: PERCENT_TR, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TRUCK_AADT (type: esriFieldTypeInteger, alias: TRUCK_AADT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TRUCK_AA_1 (type: esriFieldTypeInteger, alias: TRUCK_AA_1, SQL Type: sqlTypeOther, nullable: true, editable: true)
• GLOBALID (type: esriFieldTypeString, alias: GLOBALID, SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)
• EDITDATE (type: esriFieldTypeDate, alias: EDITDATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• RUN_DATE (type: esriFieldTypeDate, alias: RUN_DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• SHAPE_Leng (type: esriFieldTypeDouble, alias: SHAPE_Leng, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Shape__Length (type: esriFieldTypeDouble, alias: Shape__Length, SQL Type: sqlTypeDouble, nullable: true, editable: false)

Templates:

Name: Annual_Average_Daily_Truck_Traffic__AADTT_
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 10/20/2025 6:11:28 PM

Schema Last Edit Date: 10/20/2025 6:11:28 PM

Data Last Edit Date: 10/20/2025 6:11:28 PM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat