Name: ITSSQLSandbox.dbo.ATSPM_Detectors

Display Field: DetectorID

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: 4ddfe04b6d40430290e7d6cb76b687cf

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 1000

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:

• ITSSQLSandbox.dbo.ATSPM_Detectors.OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• ITSSQLSandbox.dbo.ATSPM_Detectors.ID ( type: esriFieldTypeDouble, alias: ID )
• ITSSQLSandbox.dbo.ATSPM_Detectors.DetectorID ( type: esriFieldTypeString, alias: DetectorID, length: 1073741822 )
• ITSSQLSandbox.dbo.ATSPM_Detectors.DetChannel ( type: esriFieldTypeDouble, alias: DetChannel )
• ITSSQLSandbox.dbo.ATSPM_Detectors.DistanceFromStopBar ( type: esriFieldTypeDouble, alias: DistanceFromStopBar )
• ITSSQLSandbox.dbo.ATSPM_Detectors.MinSpeedFilter ( type: esriFieldTypeDouble, alias: MinSpeedFilter )
• ITSSQLSandbox.dbo.ATSPM_Detectors.DateAdded ( type: esriFieldTypeDate, alias: DateAdded, length: 8 )
• ITSSQLSandbox.dbo.ATSPM_Detectors.DateDisabled ( type: esriFieldTypeDate, alias: DateDisabled, length: 8 )
• ITSSQLSandbox.dbo.ATSPM_Detectors.LaneNumber ( type: esriFieldTypeDouble, alias: LaneNumber )
• ITSSQLSandbox.dbo.ATSPM_Detectors.MovementTypeID ( type: esriFieldTypeDouble, alias: MovementTypeID )
• ITSSQLSandbox.dbo.ATSPM_Detectors.LaneTypeID ( type: esriFieldTypeDouble, alias: LaneTypeID )
• ITSSQLSandbox.dbo.ATSPM_Detectors.DecisionPoint ( type: esriFieldTypeDouble, alias: DecisionPoint )
• ITSSQLSandbox.dbo.ATSPM_Detectors.MovementDelay ( type: esriFieldTypeDouble, alias: MovementDelay )
• ITSSQLSandbox.dbo.ATSPM_Detectors.ApproachID ( type: esriFieldTypeDouble, alias: ApproachID )
• ITSSQLSandbox.dbo.ATSPM_Detectors.DetectionHardwareID ( type: esriFieldTypeDouble, alias: DetectionHardwareID )
• ITSSQLSandbox.dbo.ATSPM_Detectors.LatencyCorrection ( type: esriFieldTypeDouble, alias: LatencyCorrection )
• ITSSQLSandbox.dbo.ATSPM_Approaches.OBJECTID ( type: esriFieldTypeInteger, alias: OBJECTID )
• ITSSQLSandbox.dbo.ATSPM_Approaches.ApproachID ( type: esriFieldTypeInteger, alias: ApproachID )
• ITSSQLSandbox.dbo.ATSPM_Approaches.SignalID ( type: esriFieldTypeString, alias: SignalID, length: 10 )
• ITSSQLSandbox.dbo.ATSPM_Approaches.DirectionTypeID ( type: esriFieldTypeInteger, alias: DirectionTypeID )
• ITSSQLSandbox.dbo.ATSPM_Approaches.Description ( type: esriFieldTypeString, alias: Description, length: 1073741822 )
• ITSSQLSandbox.dbo.ATSPM_Approaches.MPH ( type: esriFieldTypeInteger, alias: MPH )
• ITSSQLSandbox.dbo.ATSPM_Approaches.ProtectedPhaseNumber ( type: esriFieldTypeInteger, alias: ProtectedPhaseNumber )
• ITSSQLSandbox.dbo.ATSPM_Approaches.IsProtectedPhaseOverlap ( type: esriFieldTypeSmallInteger, alias: IsProtectedPhaseOverlap )
• ITSSQLSandbox.dbo.ATSPM_Approaches.PermissivePhaseNumber ( type: esriFieldTypeInteger, alias: PermissivePhaseNumber )
• ITSSQLSandbox.dbo.ATSPM_Approaches.VersionID ( type: esriFieldTypeInteger, alias: VersionID )
• ITSSQLSandbox.dbo.ATSPM_Approaches.IsPermissivePhaseOverlap ( type: esriFieldTypeSmallInteger, alias: IsPermissivePhaseOverlap )

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

  Iteminfo   Thumbnail   Metadata