Name: MIRE_TBL_IntersectionLeg

Display Field: ApproachID_T

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 )
• IntersectionID ( type: esriFieldTypeInteger, alias: IntersectionID )
• ApproachID ( type: esriFieldTypeInteger, alias: ApproachID )
• ApproachID_T ( type: esriFieldTypeString, alias: Unique ID for each approach (text), length: 50 )
• IntersectionID_T ( type: esriFieldTypeString, alias: Intersection Idenifier (text), length: 50 )
• ApproachAADT ( type: esriFieldTypeInteger, alias: Approach AADT )
• ApproachAADTYR ( type: esriFieldTypeInteger, alias: Approach AADT Year )
• ApproachMode ( type: esriFieldTypeSmallInteger, alias: Approach Mode , Coded Values: [1: Vehicles only or shared use (e.g., vehicles, pedestrians, bicyclists)] , [2: Pedestrians only] , [3: Bicycles only] , ...3 more... )
• ApproachDirFlow ( type: esriFieldTypeSmallInteger, alias: ApproachDirFlow , Coded Values: [1: One-way] , [2: Two-way] )
• NumAppThruLanes ( type: esriFieldTypeInteger, alias: Number of Approach Through Lanes )
• LeftTurnLaneType ( type: esriFieldTypeSmallInteger, alias: Left Turn Lane Type , Coded Values: [1: No left-turn lanes] , [2: Conventional left-turn lane(s)] , [3: U-turn followed by right-turn] , ...5 more... )
• NumExclLeftTurnLanes ( type: esriFieldTypeInteger, alias: Number of Exclusive Left Turn Lanes )
• LengthExclLeftTurnLanes ( type: esriFieldTypeDouble, alias: Length of Exclusive Left Turn Lanes (feet) )
• AmtLeftTurnLaneOff ( type: esriFieldTypeDouble, alias: Amount of Left Turn Lane Offset )
• RightTurnChann ( type: esriFieldTypeSmallInteger, alias: Right Turn Channelization , Coded Values: [1: None] , [2: Painted island with receiving lane] , [3: Painted island without receiving lane] , ...2 more... )
• RightTurnTrafficControl ( type: esriFieldTypeSmallInteger, alias: Traffic Control of Exclusive Right Turn Lanes , Coded Values: [1: Unsignalized] , [2: Permissive signal] , [3: Protected all day(s)] , ...8 more... )
• NumExclRightTurnLanes ( type: esriFieldTypeInteger, alias: Number of Exclusive Right Turn Lanes )
• LengthExclRightTurnLanes ( type: esriFieldTypeDouble, alias: Length of Exclusive Right Turn Lanes (feet) )
• ApproachMedianType ( type: esriFieldTypeSmallInteger, alias: Approach Median Type , Coded Values: [1: Undivided] , [2: Flush paved median (at least 4 ft in width)] , [3: Raised median with curb] , ...4 more... )
• ApproachTrafficControl ( type: esriFieldTypeSmallInteger, alias: Approach Traffic Control , Coded Values: [1: Uncontrolled] , [2: Stop sign] , [3: Yield sign] , ...6 more... )
• ApproachLeftTurnProtection ( type: esriFieldTypeSmallInteger, alias: Approach Left Turn Protection , Coded Values: [1: Unsignalized] , [2: Permissive signal] , [3: Protected all day(s)] , ...6 more... )
• SignalProgression ( type: esriFieldTypeSmallInteger, alias: Signal Progression , Coded Values: [1: Unsignalized] , [2: Uncoordinated fixed time] , [3: Uncoordinated traffic actuated] , ...3 more... )
• CrosswalkType ( type: esriFieldTypeSmallInteger, alias: Crosswalk Presence/Type , Coded Values: [1: Unmarked crosswalk] , [2: Marked crosswalk and style (parallel bars, continental, etc.)] , [3: Marked crosswalk with supplemental devices (e.g., in-street yield signs, in-] , ...5 more... )
• PedSignalActType ( type: esriFieldTypeSmallInteger, alias: Pedestrian Signal Activation Type , Coded Values: [1: None] , [2: Constant activation by traffic signal (e.g., ped recall)] , [3: Pushbutton actuated] , ...2 more... )
• PedSignalType ( type: esriFieldTypeSmallInteger, alias: Pedestrian Signal Presence/Type , Coded Values: [1: None] , [2: Pedestrian Signal with countdown indicator (with APS)] , [3: Pedestrian Signal with countdown indicator (without APS)] , ...2 more... )
• PedCount ( type: esriFieldTypeInteger, alias: Crossing Pedestrian Count )
• LeftRightTurnProhibition ( type: esriFieldTypeSmallInteger, alias: Left/Right Turn Prohibitions , Coded Values: [1: Not applicable] , [2: No prohibitions] , [3: No left-turns permitted at any time] , ...6 more... )
• RTORProhibition ( type: esriFieldTypeSmallInteger, alias: Right Turn On Red Prohibitions , Coded Values: [1: RTOR allowed at all times] , [2: RTOR prohibited at all times] , [3: RTOR prohibited during certain portions of the day] , ...1 more... )
• LeftTurnCount ( type: esriFieldTypeDouble, alias: Left Turn Counts/Percent )
• LeftTurnCountYR ( type: esriFieldTypeInteger, alias: Year of Left Turn Counts/Percent )
• RightTurnCount ( type: esriFieldTypeDouble, alias: Right Turn Counts/Percent )
• RightTurnCountYR ( type: esriFieldTypeInteger, alias: Year of Right Turn Counts/Percent )
• TraRumblStripPresence ( type: esriFieldTypeSmallInteger, alias: Transverse Rumble Strip Presence , Coded Values: [1: Yes] , [2: No] )
• CirIntEntryWidth ( type: esriFieldTypeDouble, alias: Circular Intersection - Entry Width (feet) )
• CirIntNumEntryLanes ( type: esriFieldTypeInteger, alias: Circular Intersection - Number of Entry Lanes )
• CirIntExclRightTurnLaneType ( type: esriFieldTypeSmallInteger, alias: Circular Intersection - Presence/Type of Exclusive Right Turn Lane , Coded Values: [1: None] , [2: Exclusive right-turn bypass/slip lane with separating island] , [3: Exclusive right-turn bypass/slip lane without separating island] )
• CirIntEntryRadius ( type: esriFieldTypeDouble, alias: Circular Intersection - Entry Radius (feet) )
• CirIntExitWidth ( type: esriFieldTypeDouble, alias: Circular Intersection - Exit Width (feet) )
• CirIntNumExitLanes ( type: esriFieldTypeInteger, alias: Circular Intersection - Number of Exit Lanes )
• CirIntExitRadius ( type: esriFieldTypeDouble, alias: Circular Intersection - Exit Radius (feet) )
• CirIntPedFacility ( type: esriFieldTypeSmallInteger, alias: Circular Intersection - Pedestrian Facility , Coded Values: [1: Marked crosswalk with raised island] , [2: Marked crosswalk with flush island] , [3: Marked crosswalk with no island] , ...5 more... )
• CirIntCrosswalkLocation ( type: esriFieldTypeDouble, alias: Circular Intersection - Crosswalk Location (feet) )
• CirIntIslandWidth ( type: esriFieldTypeDouble, alias: CirIntIslandWidth )

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

  Iteminfo   Thumbnail   Metadata