Name: HPMS Statewide Statistics (2024)

Display Field: Name

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description:

Copyright Text:

Min. Scale: 0

Max. Scale: 0

Default Visibility: true

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: 132261.644440978
YMin: 127339.747173712
XMax: 797760.36791159
YMax: 779163.113473096
Spatial Reference: 102123 (3078)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[42,132,147,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)
• route_id (type: esriFieldTypeString, alias: Route ID, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• from_date (type: esriFieldTypeDate, alias: From Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• to_date (type: esriFieldTypeDate, alias: To Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• from_measure (type: esriFieldTypeDouble, alias: From Measure, SQL Type: sqlTypeOther, nullable: true, editable: true)
• to_measure (type: esriFieldTypeDouble, alias: To Measure, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Aadt (type: esriFieldTypeInteger, alias: AADT TDMS.Aadt, SQL Type: sqlTypeOther, nullable: true, editable: true)
• AadtCommercial (type: esriFieldTypeInteger, alias: Commercial AADT.AadtCommercial, SQL Type: sqlTypeOther, nullable: true, editable: true)
• AadtSingleUnit (type: esriFieldTypeInteger, alias: SingleUnitCommercialAADT.AadtSingleUnit, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PercentPeakSingleUnit (type: esriFieldTypeDouble, alias: Percent Peak Single Unit.PercentPeakSingleUnit, SQL Type: sqlTypeOther, nullable: true, editable: true)
• AadtCombinationUnit (type: esriFieldTypeInteger, alias: Combination Unit AADT.AadtCombinationUnit, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PercentPeakCombinationUnit (type: esriFieldTypeDouble, alias: PercentPeakCombinationUnit.PercentPeakCombinationUnit, SQL Type: sqlTypeOther, nullable: true, editable: true)
• KFactor (type: esriFieldTypeDouble, alias: K Factor.KFactor, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DirectionalFactor (type: esriFieldTypeDouble, alias: Directional Factor.DirectionalFactor, SQL Type: sqlTypeOther, nullable: true, editable: true)
• AadtFutureYear (type: esriFieldTypeInteger, alias: Future Year AADT.AadtFutureYear, SQL Type: sqlTypeOther, nullable: true, editable: true)
• FutureAadtDate (type: esriFieldTypeDate, alias: Future Year AADT.FutureAadtDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• FunctionalSystem (type: esriFieldTypeSmallInteger, alias: Functional System.FunctionalSystem, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: 0 - Non-Certified Roadway], [1: 1 - Interstate], [2: 2 - Other Freeway], ... 5 more ...)
• FacilityType (type: esriFieldTypeSmallInteger, alias: Facility Type.FacilityType, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: 0 - Non-Public Roadway], [1: 1 - One-Way Roadway], [2: 2 - Two-Way Roadway], ... 4 more ...)
• ThroughLanes (type: esriFieldTypeInteger, alias: Through Lane HPMS.ThroughLanes, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: 1], [2: 2], [3: 3], ... 13 more ...)
• UrbanCode (type: esriFieldTypeInteger, alias: Urban Code.UrbanCode, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [2602: Ann Arbor, MI], [5707: Battle Creek, MI], [5869: Bay City, MI], ... 21 more ...)
• RuralUrban (type: esriFieldTypeSmallInteger, alias: Rural Urban.RuralUrban, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: 1 - Rural Area], [2: 2 - Small Urban Area], [3: 3 - Small Urbanized Area], ... 1 more ...)
• Acub (type: esriFieldTypeSmallInteger, alias: ACUB.Acub, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [2062: Adrian], [2027: Albion], [2079: Allegan], ... 97 more ...)
• RouteNumber (type: esriFieldTypeSmallInteger, alias: Route Number.RouteNumber, SQL Type: sqlTypeOther, nullable: true, editable: true)
• RouteSigning (type: esriFieldTypeSmallInteger, alias: Route Signing.RouteSigning, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: 1 - Not Signed], [2: 2 - Interstate], [3: 3 - U.S.], ... 7 more ...)
• RouteQualifier (type: esriFieldTypeSmallInteger, alias: Route Qualifier.RouteQualifier, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: 1 - No Qualifier or Not Signed], [2: 2 - Alternate], [3: 3 - Business Route], ... 7 more ...)
• SampleId (type: esriFieldTypeString, alias: Sample Section.SampleId, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• Ownership (type: esriFieldTypeSmallInteger, alias: Ownership.Ownership, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: State Highway Agency], [2: County Highway Agency], [3: Town or Township Highway Agency], ... 24 more ...)
• Nhs (type: esriFieldTypeSmallInteger, alias: Nhs.Nhs, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: 0 - Not NHS], [1: 1 - Non-connector NHS], [2: 2 - Major Airport], ... 7 more ...)
• LegalSystem (type: esriFieldTypeSmallInteger, alias: Legal System.LegalSystem, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: 0 - None], [1: 1 - State Trunkline], [2: 2 - County Primary], ... 5 more ...)
• JurisdictionCounty (type: esriFieldTypeString, alias: Jurisdiction County.JurisdictionCounty, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true, Coded Values: [01: Alcona], [02: Alger], [03: Allegan], ... 81 more ...)
• JurisdictionCity (type: esriFieldTypeString, alias: Jurisdiction City.JurisdictionCity, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true, Coded Values: [0026: Addison ], [0030: Adrian ], [0046: Ahmeek ], ... 531 more ...)
• Jurisdiction1 (type: esriFieldTypeString, alias: Jurisdiction Shared.Jurisdiction1, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true, Coded Values: [01: Alcona County], [02: Alger County], [03: Allegan County], ... 613 more ...)
• Jurisdiction2 (type: esriFieldTypeString, alias: Jurisdiction Shared.Jurisdiction2, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true, Coded Values: [01: Alcona County], [02: Alger County], [03: Allegan County], ... 613 more ...)
• SharedLength1 (type: esriFieldTypeDouble, alias: Jurisdiction Shared.SharedLength1, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SharedLength2 (type: esriFieldTypeDouble, alias: Jurisdiction Shared.SharedLength2, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SurfaceType (type: esriFieldTypeInteger, alias: Surface Type.SurfaceType, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: 1 - Unpaved], [2: 2 - Bituminous], [3: 3 - JPCP – Jointed Plain Concrete Pavement], ... 8 more ...)
• LaneNumber (type: esriFieldTypeInteger, alias: Lane.LaneNumber, SQL Type: sqlTypeOther, nullable: true, editable: true)
• LaneMiles (type: esriFieldTypeDouble, alias: Lane.LaneMiles, SQL Type: sqlTypeOther, nullable: true, editable: true)
• FipsMcdLeft (type: esriFieldTypeInteger, alias: MCD Left Right.FipsMcdLeft, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [200: Acme Twp - Grand Traverse], [240: Ada Twp - Kent], [280: Adams Twp - Arenac], ... 1517 more ...)
• FipsMcdRight (type: esriFieldTypeInteger, alias: MCD Left Right.FipsMcdRight, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [200: Acme Twp - Grand Traverse], [240: Ada Twp - Kent], [280: Adams Twp - Arenac], ... 1517 more ...)
• CountyCode (type: esriFieldTypeString, alias: County Code.CountyCode, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [001: Alcona], [003: Alger], [005: Allegan], ... 80 more ...)
• Name (type: esriFieldTypeString, alias: MDOT Region.Name, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [Superior: Superior], [North: North], [Grand: Grand], ... 4 more ...)
• Code (type: esriFieldTypeSmallInteger, alias: MDOT Region.Code, SQL Type: sqlTypeOther, nullable: true, editable: true)
• FipsCountyCode (type: esriFieldTypeSmallInteger, alias: MDOT Region.FipsCountyCode, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PlanningRegion (type: esriFieldTypeSmallInteger, alias: Planning Region.PlanningRegion, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: SEMCOG - Southeast Michigan Council of Governments], [2: R2PC - Region 2 Planning Commission], [3: SCMPC - Southcentral Michigan Planning Council], ... 11 more ...)
• Mpo (type: esriFieldTypeSmallInteger, alias: MPO.Mpo, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [3: BCATS - Battle Creek Area Transportation Study], [4: BCATS - Bay City Area Transportation Study], [8: GCMPC - Genesee County Metropolitan Planning Commission], ... 12 more ...)
• MpoStudy (type: esriFieldTypeSmallInteger, alias: MPO Study.MpoStudy, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: WATS - Washtenaw Area Transportation Study], [3: SCCOTS - St. Clair County Transportation Study])
• CenterlineMiles (type: esriFieldTypeDouble, alias: CenterlineMiles, SQL Type: sqlTypeOther, nullable: true, editable: true)
• HpmsLaneMiles (type: esriFieldTypeDouble, alias: HpmsLaneMiles, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DailyVehicleMiles (type: esriFieldTypeDouble, alias: DailyVehicleMiles, SQL Type: sqlTypeOther, nullable: true, editable: true)
• AnnualVehicleMiles (type: esriFieldTypeDouble, alias: AnnualVehicleMiles, SQL Type: sqlTypeOther, nullable: true, editable: true)
• IsSample (type: esriFieldTypeSmallInteger, alias: IsSample, SQL Type: sqlTypeOther, nullable: true, editable: true)
• VMT (type: esriFieldTypeDouble, alias: VMT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• AVMT (type: esriFieldTypeDouble, alias: AVMT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CDVMT (type: esriFieldTypeDouble, alias: CDVMT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CAVMT (type: esriFieldTypeDouble, alias: CAVMT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CDVMT_3dec (type: esriFieldTypeDouble, alias: CDVMT_3dec, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CAVMT_3dec (type: esriFieldTypeDouble, alias: CAVMT_3dec, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PlanningOrganization (type: esriFieldTypeString, alias: PlanningOrganization, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• TAMPTier (type: esriFieldTypeDouble, alias: TAMPTier, SQL Type: sqlTypeOther, nullable: true, editable: true)
• FAE (type: esriFieldTypeDouble, alias: FAE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Shape__Length (type: esriFieldTypeDouble, alias: Shape__Length, SQL Type: sqlTypeDouble, nullable: true, editable: false)

Templates:

Name: MdotTampHpmsStatewideStatistics
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 8/13/2026 2:14:20 PM

Schema Last Edit Date: 8/10/2026 7:30:55 PM

Data Last Edit Date: 8/10/2026 7:30:55 PM

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