Name: ESR_Documents_Sorted

Display Field: Name

Type: Table

Geometry Type: N/A

Description:

Service Item Id: 2ed2c3de76a74f1dad90089cef1a461f

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

Drawing Info:

N/A

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
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: false
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:

Fields:

• ServiceRequestID ( type: esriFieldTypeString, alias: ServiceRequestID, editable: false, nullable: true, length: 100, defaultValue: null, modelName: ServiceRequestID )
• id ( type: esriFieldTypeOID, alias: id, editable: false, nullable: false, defaultValue: null, modelName: id )
• LoggedByName ( type: esriFieldTypeString, alias: LoggedByName, editable: false, nullable: true, length: 50, defaultValue: null, modelName: LoggedByName )
• LoggedDate ( type: esriFieldTypeDate, alias: LoggedDate, editable: false, nullable: true, length: 8, defaultValue: null, precision: 1, modelName: LoggedDate )
• TypeName ( type: esriFieldTypeString, alias: TypeName, editable: false, nullable: true, length: 50, defaultValue: null, modelName: TypeName )
• DepartmentName ( type: esriFieldTypeString, alias: DepartmentName, editable: false, nullable: true, length: 80, defaultValue: null, modelName: DepartmentName )
• GroupName ( type: esriFieldTypeString, alias: GroupName, editable: false, nullable: true, length: 50, defaultValue: null, modelName: GroupName )
• IssueID ( type: esriFieldTypeInteger, alias: IssueID, editable: false, nullable: true, defaultValue: null, modelName: IssueID )
• Location ( type: esriFieldTypeString, alias: Location, editable: false, nullable: true, length: 128, defaultValue: null, modelName: Location )
• AssignedToName ( type: esriFieldTypeString, alias: AssignedToName, editable: false, nullable: true, length: 100, defaultValue: null, modelName: AssignedToName )
• AssignedDate ( type: esriFieldTypeDate, alias: AssignedDate, editable: false, nullable: true, length: 8, defaultValue: null, precision: 1, modelName: AssignedDate )
• StatusName ( type: esriFieldTypeString, alias: StatusName, editable: false, nullable: false, length: 6, defaultValue: null, modelName: StatusName )
• OpenedDate ( type: esriFieldTypeDate, alias: OpenedDate, editable: false, nullable: true, length: 8, defaultValue: null, precision: 1, modelName: OpenedDate )
• ResolvedDate ( type: esriFieldTypeDate, alias: ResolvedDate, editable: false, nullable: true, length: 8, defaultValue: null, precision: 1, modelName: ResolvedDate )
• ClosedDate ( type: esriFieldTypeDate, alias: ClosedDate, editable: false, nullable: true, length: 8, defaultValue: null, precision: 1, modelName: ClosedDate )
• ClosedByName ( type: esriFieldTypeString, alias: ClosedByName, editable: false, nullable: true, length: 50, defaultValue: null, modelName: ClosedByName )
• Duration ( type: esriFieldTypeInteger, alias: Duration, editable: false, nullable: true, defaultValue: null, modelName: Duration )
• BohRoadOpsAssignment ( type: esriFieldTypeString, alias: BohRoadOpsAssignment, editable: false, nullable: true, length: 150, defaultValue: null, modelName: BohRoadOpsAssignment )
• BohAddressNo ( type: esriFieldTypeString, alias: BohAddressNo, editable: false, nullable: true, length: 50, defaultValue: null, modelName: BohAddressNo )
• BohAddressStreet ( type: esriFieldTypeString, alias: BohAddressStreet, editable: false, nullable: true, length: 150, defaultValue: null, modelName: BohAddressStreet )
• BohAddressStreetType ( type: esriFieldTypeString, alias: BohAddressStreetType, editable: false, nullable: true, length: 50, defaultValue: null, modelName: BohAddressStreetType )
• BohAddressCity ( type: esriFieldTypeString, alias: BohAddressCity, editable: false, nullable: true, length: 50, defaultValue: null, modelName: BohAddressCity )
• BohAddressZip ( type: esriFieldTypeString, alias: BohAddressZip, editable: false, nullable: true, length: 50, defaultValue: null, modelName: BohAddressZip )
• BohSubdivision ( type: esriFieldTypeString, alias: BohSubdivision, editable: false, nullable: true, length: 150, defaultValue: null, modelName: BohSubdivision )
• BohIntersection1 ( type: esriFieldTypeString, alias: BohIntersection1, editable: false, nullable: true, length: 150, defaultValue: null, modelName: BohIntersection1 )
• BohIntersection2 ( type: esriFieldTypeString, alias: BohIntersection2, editable: false, nullable: true, length: 150, defaultValue: null, modelName: BohIntersection2 )
• BohLocationDescription ( type: esriFieldTypeString, alias: BohLocationDescription, editable: false, nullable: true, length: 1024, defaultValue: null, modelName: BohLocationDescription )
• Description ( type: esriFieldTypeString, alias: Description, editable: false, nullable: true, length: 2048, defaultValue: null, modelName: Description )
• BohAdcMapPageGrid ( type: esriFieldTypeString, alias: BohAdcMapPageGrid, editable: false, nullable: true, length: 50, defaultValue: null, modelName: BohAdcMapPageGrid )
• BohEsrRoadPassable ( type: esriFieldTypeString, alias: BohEsrRoadPassable, editable: false, nullable: true, length: 150, defaultValue: null, modelName: BohEsrRoadPassable )
• BohEsrRoadClosedby ( type: esriFieldTypeString, alias: BohEsrRoadClosedby, editable: false, nullable: true, length: 50, defaultValue: null, modelName: BohEsrRoadClosedby )
• BohEsrSnowIce ( type: esriFieldTypeSmallInteger, alias: BohEsrSnowIce, editable: false, nullable: true, defaultValue: null, modelName: BohEsrSnowIce )
• BohEsrTrees ( type: esriFieldTypeSmallInteger, alias: BohEsrTrees, editable: false, nullable: true, defaultValue: null, modelName: BohEsrTrees )
• BohEsrFlooded ( type: esriFieldTypeSmallInteger, alias: BohEsrFlooded, editable: false, nullable: true, defaultValue: null, modelName: BohEsrFlooded )
• BohEsrWires ( type: esriFieldTypeSmallInteger, alias: BohEsrWires, editable: false, nullable: true, defaultValue: null, modelName: BohEsrWires )
• BohEsrBgeContacted ( type: esriFieldTypeSmallInteger, alias: BohEsrBgeContacted, editable: false, nullable: true, defaultValue: null, modelName: BohEsrBgeContacted )
• BohEsrBgeRef ( type: esriFieldTypeString, alias: BohEsrBgeRef, editable: false, nullable: true, length: 50, defaultValue: null, modelName: BohEsrBgeRef )
• BohSnowContractorCode ( type: esriFieldTypeString, alias: BohSnowContractorCode, editable: false, nullable: true, length: 50, defaultValue: null, modelName: BohSnowContractorCode )
• BohSnowRemovalPriorityLos ( type: esriFieldTypeString, alias: BohSnowRemovalPriorityLos, editable: false, nullable: true, length: 50, defaultValue: null, modelName: BohSnowRemovalPriorityLos )
• BohSegidNo ( type: esriFieldTypeString, alias: BohSegidNo, editable: false, nullable: true, length: 50, defaultValue: null, modelName: BohSegidNo )
• BohRoadOwnership ( type: esriFieldTypeString, alias: BohRoadOwnership, editable: false, nullable: true, length: 50, defaultValue: null, modelName: BohRoadOwnership )
• BuoWaterEmergency ( type: esriFieldTypeSmallInteger, alias: BuoWaterEmergency, editable: false, nullable: true, defaultValue: null, modelName: BuoWaterEmergency )
• BuoSewerEmergency ( type: esriFieldTypeSmallInteger, alias: BuoSewerEmergency, editable: false, nullable: true, defaultValue: null, modelName: BuoSewerEmergency )
• BuoRoadClosedBy ( type: esriFieldTypeString, alias: BuoRoadClosedBy, editable: false, nullable: true, length: 150, defaultValue: null, modelName: BuoRoadClosedBy )
• Latitude ( type: esriFieldTypeDouble, alias: Latitude, editable: false, nullable: true, defaultValue: null, modelName: Latitude )
• Longitude ( type: esriFieldTypeDouble, alias: Longitude, editable: false, nullable: true, defaultValue: null, modelName: Longitude )
• Attachments ( type: esriFieldTypeString, alias: Attachments, editable: false, nullable: true, length: 2147483647, defaultValue: null, modelName: Attachments )
• Name ( type: esriFieldTypeString, alias: Name, editable: false, nullable: true, length: 2147483647, defaultValue: null, modelName: Name )
• DocumentType ( type: esriFieldTypeString, alias: DocumentType, editable: false, nullable: true, length: 2147483647, defaultValue: null, modelName: DocumentType )

Templates:

• Name: ESR_Documents_Sorted
  Description:
  Prototype:
  Drawing Tool: esriFeatureEditToolNone

Capabilities: Query

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: false

Supports Query With Historic Moment: false

Supports Coordinates Quantization: false

Child Resources:   Field Groups   Contingent Values

Supported Operations:   Query   Query Analytic   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata   Update Metadata