Name: MIRE_TBL_Segment

Display Field: RouteName

Type: Table

Geometry Type: N/A

Description: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:

N/A

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: true
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• RoadElementID ( type: esriFieldTypeInteger, alias: RoadElementID )
• RouteNumer ( type: esriFieldTypeInteger, alias: Route Number )
• RouteName ( type: esriFieldTypeString, alias: Route/Street Name, length: 100 )
• BeginPoint ( type: esriFieldTypeDouble, alias: Begin Point Segment Descriptor )
• EndPoint ( type: esriFieldTypeDouble, alias: End Point Segment Descriptor )
• SegmentID_T ( type: esriFieldTypeString, alias: Unique segment identifier, length: 50 )
• SegmentLength ( type: esriFieldTypeDouble, alias: Segment Length (miles) )
• DirInventory ( type: esriFieldTypeString, alias: Direction of Inventory, length: 50 )
• FuncClass ( type: esriFieldTypeSmallInteger, alias: Functional Class )
• AccessControl ( type: esriFieldTypeSmallInteger, alias: Access Control )
• SurfaceType ( type: esriFieldTypeSmallInteger, alias: Surface Type )
• NumThroughLn ( type: esriFieldTypeInteger, alias: Number of Through Lanes )
• AADT ( type: esriFieldTypeInteger, alias: Annual Average Daily Traffic )
• AADTYr ( type: esriFieldTypeInteger, alias: Year of AADT )
• CountyName ( type: esriFieldTypeString, alias: CountyName, length: 50 )
• CountyCode ( type: esriFieldTypeInteger, alias: County Code )
• HwyDistrict ( type: esriFieldTypeInteger, alias: Highway District )
• SpGovOwner ( type: esriFieldTypeString, alias: Specific Governental Ownership, length: 255 )
• CityLocalJurisdiction ( type: esriFieldTypeString, alias: City/Local Jurisdiction Name, length: 255 )
• UrbanCode ( type: esriFieldTypeInteger, alias: UrbanCode )
• CoincidingRouteIDMinor ( type: esriFieldTypeString, alias: Coinciding Route Indicator - Minor Route Information, length: 255 )
• PavementWidth ( type: esriFieldTypeDouble, alias: Total Paved Surface Width )
• SurfaceFriction ( type: esriFieldTypeInteger, alias: Surface Friction )
• SurfaceFrictionDate ( type: esriFieldTypeDateOnly, alias: Surface Friction Date )
• IRI ( type: esriFieldTypeDouble, alias: International Roughness Index )
• IRIDate ( type: esriFieldTypeDateOnly, alias: International Roughness Index Date )
• PaveCondDate ( type: esriFieldTypeDate, alias: Pavement Condition Date, length: 8 )
• OutsideThroughLaneWidth ( type: esriFieldTypeDouble, alias: Outside Through Lane Width )
• InsideThroughLaneWidth ( type: esriFieldTypeDouble, alias: Inside Through Lane Width )
• CrossSlope ( type: esriFieldTypeDouble, alias: Cross Slope )
• AuxLaneLength ( type: esriFieldTypeDouble, alias: Auxiliary Lane Length )
• MangedLaneType ( type: esriFieldTypeInteger, alias: Managed Lane Operations Type )
• NumManagedLanes ( type: esriFieldTypeInteger, alias: Number of Managed Lanes )
• NumRevLanes ( type: esriFieldTypeInteger, alias: Number of Reversible Lanes )
• BikeFacWidth ( type: esriFieldTypeDouble, alias: Width of Bicycle Facility )
• NumPeakThruLn ( type: esriFieldTypeInteger, alias: Number of Peak Period Through Lanes )
• RightShoulderTotWidth ( type: esriFieldTypeDouble, alias: Right Shoulder Total Width )
• RightPavedShoulderWidth ( type: esriFieldTypeDouble, alias: Right Paved Shoulder Width )
• LeftShoulderTotWidth ( type: esriFieldTypeDouble, alias: Left Shoulder Total Width )
• LeftPavedShoulderWidth ( type: esriFieldTypeDouble, alias: Left Paved Shoulder Width )
• MedianWidth ( type: esriFieldTypeDouble, alias: Median Width )
• MedianPavedShoulderWidth ( type: esriFieldTypeDouble, alias: Median (Inner) Paved Shoulder Width )
• MedianSideSlope ( type: esriFieldTypeDouble, alias: Median Sideslope )
• MedianSideslopeWidth ( type: esriFieldTypeDouble, alias: Median Sideslope Width )
• RoadsideClearZoneWidth ( type: esriFieldTypeDouble, alias: Roadside Clear Zone Width )
• RightSideslope ( type: esriFieldTypeDouble, alias: Right Sideslope )
• RightSideslopeWidth ( type: esriFieldTypeDouble, alias: Right Sideslope Width )
• LeftSideslope ( type: esriFieldTypeDouble, alias: Left Sideslope )
• LeftSideslopeWidth ( type: esriFieldTypeDouble, alias: Left Sideslope Width )
• NumMajorComDriveway ( type: esriFieldTypeInteger, alias: Major Commercial Driveway Count )
• NumMinorComDriveway ( type: esriFieldTypeInteger, alias: Minor Commercial Driveway Count )
• NumMajorResDriveway ( type: esriFieldTypeInteger, alias: Major Residential Driveway Count )
• NumMinorResDriveway ( type: esriFieldTypeInteger, alias: Minor Residential Driveway Count )
• NumMajorIndDriveway ( type: esriFieldTypeInteger, alias: Major Industrial/Institutional Driveway Count )
• NumMinorIndDriveway ( type: esriFieldTypeInteger, alias: Minor Industrial/Institutional Driveway Count )
• NumOtDriveway ( type: esriFieldTypeInteger, alias: Other Driveway Count )
• AADTGrowthPct ( type: esriFieldTypeDouble, alias: AADT Annual Escalation Percentage )
• STruckAADTPct ( type: esriFieldTypeDouble, alias: Percent Single Unit Trucks or Single Unit Truck AADT )
• CTruckAADTPct ( type: esriFieldTypeDouble, alias: Percent Combination Trucks or Combination Truck AADT )
• TruckAADTPct ( type: esriFieldTypeDouble, alias: Percentage Trucks or Truck AADT )
• NumTotDailyPed ( type: esriFieldTypeInteger, alias: Total Daily Two-Way Pedestrian Count )
• NumTotDailyBike ( type: esriFieldTypeInteger, alias: Bicycle Count )
• MotorcycleCntPct ( type: esriFieldTypeInteger, alias: Motorcycle Count or Percentage )
• HourlyTraffic ( type: esriFieldTypeInteger, alias: Hourly Traffic Volumes )
• KFactor ( type: esriFieldTypeDouble, alias: K-Factor )
• DHDFactor ( type: esriFieldTypeDouble, alias: Design Hour Directional Factor )
• SpeedLimit ( type: esriFieldTypeDouble, alias: Speed Limit (mph) )
• SpeedLimitTruck ( type: esriFieldTypeDouble, alias: Truck Speed Limit (mph) )
• SpeedLimitNT ( type: esriFieldTypeInteger, alias: Night Time Speed Limit )
• Speed85Pct ( type: esriFieldTypeInteger, alias: 85th Percentile Speed )
• SpeedMean ( type: esriFieldTypeInteger, alias: Mean Speed )
• EdgelinePresenceWidth ( type: esriFieldTypeDouble, alias: Presence and width of marked edgeline )
• CenterlinePresenceWidth ( type: esriFieldTypeDouble, alias: Presence and width of marked centerline )
• PassZonePct ( type: esriFieldTypeDouble, alias: Passing Zone Percentage )
• BridgeNumber ( type: esriFieldTypeString, alias: Bridge number(s), length: 50 )
• AuxLaneType ( type: esriFieldTypeSmallInteger, alias: Auxilary Lane Presence/Type , Coded Values: [1: Climbing lane] , [2: Passing lane] , [3: Exclusive continuous right-turn lane] , ...4 more... )
• MedianType ( type: esriFieldTypeSmallInteger, alias: Median Type , Coded Values: [1: Undivided] , [2: Flush paved median (at least 4 ft in width)] , [3: Raised median with curb] , ...6 more... )
• OneTwoWay ( type: esriFieldTypeSmallInteger, alias: One/Two-Way Operations , Coded Values: [1: One-way] , [2: Two-way] , [3: One direction of travel for divided roadways] )
• RouteSigning ( type: esriFieldTypeSmallInteger, alias: Route Signing , Coded Values: [1: Interstate] , [2: U.S. Highway] , [3: U.S. Highway] , ...10 more... )
• RouteSigningQualifier ( type: esriFieldTypeSmallInteger, alias: Route Signing Qualifier , Coded Values: [1: No qualifier or not signed] , [2: Alternate] , [3: Business route] , ...7 more... )
• CoincidingRouteID ( type: esriFieldTypeSmallInteger, alias: Coinciding Route Indicator , Coded Values: [1: Segment does not contain coinciding routes] , [2: Coinciding route – Primary (i.e., crashes linked to this route and attributes included for segment)] , [3: Coinciding route – Minor (i.e., crashes not linked to this route)] )
• PaveCond ( type: esriFieldTypeSmallInteger, alias: Pavement Condition , Coded Values: [1: 4.0 - 5.0] , [2: 3.0 - 4.0] , [3: 2.0 - 3.0] , ...2 more... )
• ManagedLaneType ( type: esriFieldTypeSmallInteger, alias: Managed Lane Operations Type , Coded Values: [1: Full-time Managed Lanes] , [2: Part-time Managed Lanes – Normal Lanes] , [3: Part-time Managed Lanes – Shoulder or Parking Lanes] )
• BikeFacType ( type: esriFieldTypeSmallInteger, alias: Presence/Type of Bicycle Facility , Coded Values: [1: None] , [2: Wide curb lane with no bicycle markings] , [3: Wide curb lane with bicycle markings (e.g., sharrows)] , ...6 more... )
• RightShoulderType ( type: esriFieldTypeSmallInteger, alias: Right Shoulder Type , Coded Values: [1: None] , [2: Surfaced shoulder exists – asphalt pavement] , [3: Surfaced shoulder exists – concrete pavement] , ...4 more... )
• RightShoulderRumbleStripType ( type: esriFieldTypeSmallInteger, alias: Right Shoulder Rumble Strip Presence/Type , Coded Values: [1: None] , [2: Milled adjacent to centerline] , [3: Rolled adjacent to centerline] , ...2 more... )
• LeftShoulderType ( type: esriFieldTypeSmallInteger, alias: Left Shoulder Type , Coded Values: [1: None] , [2: Surfaced shoulder exists – asphalt pavement] , [3: Surfaced shoulder exists – concrete pavement] , ...4 more... )
• LeftShoulderRumbleStripType ( type: esriFieldTypeSmallInteger, alias: Left Shoulder Rumble Strip Presence/Type , Coded Values: [1: None] , [2: Milled beyond edgeline] , [3: Rolled beyond edgeline] , ...2 more... )
• SidewalkPresence ( type: esriFieldTypeSmallInteger, alias: Sidewalk Presence , Coded Values: [1: None] , [2: Continuous left-side] , [3: Discontinuous left-side] , ...4 more... )
• CurbPresence ( type: esriFieldTypeSmallInteger, alias: Curb Presence , Coded Values: [1: No curb] , [2: Curb on left] , [3: Curb on right] , ...1 more... )
• CurbType ( type: esriFieldTypeSmallInteger, alias: Curb Type , Coded Values: [1: No curb] , [2: Sloping curb] , [3: Vertical curb] )
• MedianBarrierType ( type: esriFieldTypeSmallInteger, alias: Median Barrier Presence/Type , Coded Values: [1: None] , [2: Unprotected] , [3: Curbed] , ...4 more... )
• MedianShoulderRumbleStripType ( type: esriFieldTypeSmallInteger, alias: Median Shoulder Rumble Strip Presence/Type , Coded Values: [1: None] , [2: Milled beyond edgeline] , [3: Rolled beyond edgeline] , ...2 more... )
• MedianCrossoverLeftTurnLnType ( type: esriFieldTypeSmallInteger, alias: Median Crossover/Left-Turn Lane Type , Coded Values: [1: None] , [2: Median crossover, no left-turn bay] , [3: Median crossover, left-turn bay] , ...2 more... )
• RoadsideRating ( type: esriFieldTypeSmallInteger, alias: Roadside Rating , Coded Values: [1: 1] , [2: 2] , [3: 3] , ...4 more... )
• TypeGovOwnership ( type: esriFieldTypeSmallInteger, alias: Type of Governmental Ownership , Coded Values: [1: State Highway Agency] , [2: County Highway Agency] , [3: Town or Township Highway] , ...24 more... )
• RuralUrban ( type: esriFieldTypeSmallInteger, alias: Rural/Urban Designation , Coded Values: [1: Rural] , [2: Urban] )
• FedAid ( type: esriFieldTypeSmallInteger, alias: Federal-Aid , Coded Values: [1: Route is non-Federal-aid] , [2: Route is Federal-aid, but not on the NHS] , [3: Route is on NHS] )
• RouteType ( type: esriFieldTypeSmallInteger, alias: Route Type , Coded Values: [1: Non-Connector NHS] , [2: Major Airport] , [3: Major Port Facility] , ...6 more... )
• TaperedEdge ( type: esriFieldTypeSmallInteger, alias: Tapered Edge , Coded Values: [1: Yes] , [2: No] )
• TerrainType ( type: esriFieldTypeSmallInteger, alias: Terrain Type , Coded Values: [1: Level] , [2: Rolling] , [3: Mountainous] )
• SchoolZoneIndicator ( type: esriFieldTypeSmallInteger, alias: School Zone Indicator , Coded Values: [1: Yes] , [2: No] )
• OnStreetParkingPresence ( type: esriFieldTypeSmallInteger, alias: On-Street Parking Presence , Coded Values: [1: Permitted 24 hrs/day] , [2: Prohibited 24 hrs/day] , [3: Permitted during specified times] )
• OnStreetParkingType ( type: esriFieldTypeSmallInteger, alias: On-Street Parking Type , Coded Values: [1: No parking allowed or none available] , [2: Head-in/back-out angle parking on one side] , [3: Head-in/back-out angle parking on both sides] , ...4 more... )
• RoadwayLighting ( type: esriFieldTypeSmallInteger, alias: Roadway Lighting , Coded Values: [1: None] , [2: Spot on one side] , [3: Spot on both sides] , ...2 more... )
• TollCharged ( type: esriFieldTypeSmallInteger, alias: Presence and type of toll facility , Coded Values: [1: Toll charged in one direction only] , [2: Toll charged in both directions] , [3: No toll charged] )
• TollType ( type: esriFieldTypeSmallInteger, alias: Presence of special tolls , Coded Values: [1: Has toll lanes but no special tolls (e.g., HOT lanes)] , [2: Has HOT lanes] , [3: Has other special tolls] )
• CenterlineRumbleStripPresenceWi ( type: esriFieldTypeSmallInteger, alias: Presence and type of centerline rumble strips , Coded Values: [1: None] , [2: Milled adjacent to centerline] , [3: Rolled adjacent to centerline] , ...2 more... )

Supported Operations:   Query   Query Attachments   Query Analytic   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata