Name: ESR_PROD

Display Field: LoggedByName

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: d50fc7a53a1a4a4db0279a4ae66833fc

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:

• ID ( type: esriFieldTypeOID, alias: ID )
• ServiceRequestID ( type: esriFieldTypeString, alias: ServiceRequestID, length: 100 )
• LoggedByName ( type: esriFieldTypeString, alias: LoggedByName, length: 50 )
• Logged_Date ( type: esriFieldTypeDate, alias: Logged_Date, length: 8 )
• TypeName ( type: esriFieldTypeString, alias: TypeName, length: 50 )
• DepartmentName ( type: esriFieldTypeString, alias: DepartmentName, length: 80 )
• GroupName ( type: esriFieldTypeString, alias: GroupName, length: 50 )
• IssueID ( type: esriFieldTypeInteger, alias: IssueID )
• Location ( type: esriFieldTypeString, alias: Location, length: 128 )
• AssignedToName ( type: esriFieldTypeString, alias: AssignedToName, length: 100 )
• Assigned_Date ( type: esriFieldTypeDate, alias: Assigned_Date, length: 8 )
• StatusName ( type: esriFieldTypeString, alias: StatusName, length: 6 )
• Opened_Date ( type: esriFieldTypeDate, alias: Opened_Date, length: 8 )
• Resolved_Date ( type: esriFieldTypeDate, alias: Resolved_Date, length: 8 )
• Closed_Date ( type: esriFieldTypeDate, alias: Closed_Date, length: 8 )
• ClosedByName ( type: esriFieldTypeString, alias: ClosedByName, length: 50 )
• Duration ( type: esriFieldTypeInteger, alias: Duration )
• BohRoadOpsAssignment ( type: esriFieldTypeString, alias: BohRoadOpsAssignment, length: 150 )
• BohAddressNo ( type: esriFieldTypeString, alias: BohAddressNo, length: 50 )
• BohAddressStreet ( type: esriFieldTypeString, alias: BohAddressStreet, length: 150 )
• BohAddressStreetType ( type: esriFieldTypeString, alias: BohAddressStreetType, length: 50 )
• BohAddressCity ( type: esriFieldTypeString, alias: BohAddressCity, length: 50 )
• BohAddressZip ( type: esriFieldTypeString, alias: BohAddressZip, length: 50 )
• BohSubdivision ( type: esriFieldTypeString, alias: BohSubdivision, length: 150 )
• BohIntersection1 ( type: esriFieldTypeString, alias: BohIntersection1, length: 150 )
• BohIntersection2 ( type: esriFieldTypeString, alias: BohIntersection2, length: 150 )
• BohLocationDescription ( type: esriFieldTypeString, alias: BohLocationDescription, length: 1024 )
• Description ( type: esriFieldTypeString, alias: Description, length: 2048 )
• BohAdcMapPageGrid ( type: esriFieldTypeString, alias: BohAdcMapPageGrid, length: 50 )
• BohEsrRoadPassable ( type: esriFieldTypeString, alias: BohEsrRoadPassable, length: 150 )
• BohEsrRoadClosedby ( type: esriFieldTypeString, alias: BohEsrRoadClosedby, length: 50 )
• BohEsrSnowIce ( type: esriFieldTypeSmallInteger, alias: BohEsrSnowIce )
• BohEsrTrees ( type: esriFieldTypeSmallInteger, alias: BohEsrTrees )
• BohEsrFlooded ( type: esriFieldTypeSmallInteger, alias: BohEsrFlooded )
• BohEsrWires ( type: esriFieldTypeSmallInteger, alias: BohEsrWires )
• BohEsrBgeContacted ( type: esriFieldTypeSmallInteger, alias: BohEsrBgeContacted )
• BohEsrBgeRef ( type: esriFieldTypeString, alias: BohEsrBgeRef, length: 50 )
• BohSnowContractorCode ( type: esriFieldTypeString, alias: BohSnowContractorCode, length: 50 )
• BohSnowRemovalPriorityLos ( type: esriFieldTypeString, alias: BohSnowRemovalPriorityLos, length: 50 )
• BohSegidNo ( type: esriFieldTypeString, alias: BohSegidNo, length: 50 )
• BohRoadOwnership ( type: esriFieldTypeString, alias: BohRoadOwnership, length: 50 )
• BuoWaterEmergency ( type: esriFieldTypeSmallInteger, alias: BuoWaterEmergency )
• BuoSewerEmergency ( type: esriFieldTypeSmallInteger, alias: BuoSewerEmergency )
• BuoRoadClosedBy ( type: esriFieldTypeString, alias: BuoRoadClosedBy, length: 150 )
• Latitude ( type: esriFieldTypeDouble, alias: Latitude )
• Longitude ( type: esriFieldTypeDouble, alias: Longitude )

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

  Iteminfo   Thumbnail   Metadata