Layers:

Layer: requests (0)

Name: requests

Display Field: LocationDescriptionShort

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: LUKE maintenance request features for development use

Service Item Id: 51659035edda4390915f6fe9f8d3572e

Copyright Text:

Default Visibility: true

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Has Labels: false

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:
XMin: -2.0037507067161843E7
YMin: -4166735.2858659313
XMax: 2.0037507067161843E7
YMax: 7300007.61237569
Spatial Reference: 102100  (3857)



Drawing Info:
Renderer:
Simple Renderer:
Symbol:
Label: N/A
Description: N/A
Transparency: 0
Labeling Info:
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: 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: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• Status ( type: esriFieldTypeString, alias: status, length: 10 , Coded Values: [New: New] , [Working: Working] , [Completed: Completed] )
• Description ( type: esriFieldTypeString, alias: description, length: 1000 )
• LocationDescription ( type: esriFieldTypeString, alias: locationDescription, length: 200 )
• LocationDescriptionShort ( type: esriFieldTypeString, alias: locationDescriptionShort, length: 100 )
• LocationAccuracy ( type: esriFieldTypeInteger, alias: locationAccuracy )
• SubmittedBy ( type: esriFieldTypeString, alias: submittedBy, length: 100 )
• SubmittedDate ( type: esriFieldTypeDate, alias: submittedDate, length: 8 )
• ChangedDate ( type: esriFieldTypeDate, alias: changedDate, length: 8 )
• ResponsibleEntity ( type: esriFieldTypeString, alias: responsibleEntity, length: 10 )
• Confirmation ( type: esriFieldTypeString, alias: confirmation, length: 20 )
• Inappropriate ( type: esriFieldTypeString, alias: inappropriate, length: 1 , Coded Values: [N: No] , [Y: Yes] )
• Shape ( type: esriFieldTypeGeometry, alias: Shape )
• RequestType ( type: esriFieldTypeString, alias: requestType, length: 255 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• ResolvedBy ( type: esriFieldTypeString, alias: resolvedBy, length: 255 )
• ExternalWorkOrderId ( type: esriFieldTypeString, alias: externalWorkOrderId, length: 36 )

Relationships:

• comments (0) -- Related To: comments (2)
• Changes (1) -- Related To: requestchanges (3)

Layer: workorders (1)

Name: workorders

Display Field: Title

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: 51659035edda4390915f6fe9f8d3572e

Copyright Text:

Default Visibility: true

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Has Labels: false

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:
XMin: -1.0920117316733541E7
YMin: 2061525.762051801
XMax: -7352592.406321791
YMax: 4710529.803007883
Spatial Reference: 102100  (3857)



Drawing Info:
Renderer:
Simple Renderer:
Symbol:
Label: N/A
Description: N/A
Transparency: 0
Labeling Info:
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: 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: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

Fields:
• SubmittedDate ( type: esriFieldTypeDate, alias: submittedDate, length: 8 )
• ChangedDate ( type: esriFieldTypeDate, alias: changedDate, length: 8 )
• ClosedDate ( type: esriFieldTypeDate, alias: closedDate, length: 8 )
• Status ( type: esriFieldTypeString, alias: status, length: 12 , Coded Values: [New: New] , [Working: Working] , [Completed: Completed] , ...1 more... )
• Title ( type: esriFieldTypeString, alias: title, length: 800 )
• Description ( type: esriFieldTypeString, alias: description, length: 1073741822 )
• LocationDescription ( type: esriFieldTypeString, alias: locationDescription, length: 800 )
• EffortLevel ( type: esriFieldTypeString, alias: effortLevel, length: 50 )
• ResponsibleEntity ( type: esriFieldTypeString, alias: responsibleEntity, length: 10 )
• Worker ( type: esriFieldTypeString, alias: worker, length: 100 )
• SubmittedBy ( type: esriFieldTypeString, alias: submittedBy, length: 100 )
• ClosedBy ( type: esriFieldTypeString, alias: closedBy, length: 100 )
• Confirmation ( type: esriFieldTypeString, alias: confirmation, length: 20 )
• WorkOrderType ( type: esriFieldTypeString, alias: workOrderType, length: 255 , Coded Values: [Manhole: Manhole] , [Pothole: Pothole] , [Sidewalk Condition: Sidewalk Condition] , ...16 more... )
• RequestType ( type: esriFieldTypeString, alias: requestType, length: 255 )
• ResolvedBy ( type: esriFieldTypeString, alias: resolvedBy, length: 255 )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• SHAPE ( type: esriFieldTypeGeometry, alias: SHAPE )

Relationships:

• comments (2) -- Related To: workordercomments (4)

Tables:

Table: comments (2)

Name: comments

Display Field: SubmittedDate

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: 51659035edda4390915f6fe9f8d3572e

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:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• RequestId ( type: esriFieldTypeInteger, alias: requestId )
• Comment ( type: esriFieldTypeString, alias: comment, length: 1000 )
• SubmittedBy ( type: esriFieldTypeString, alias: submittedBy, length: 100 )
• SubmittedDate ( type: esriFieldTypeDate, alias: submittedDate, length: 8 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• ExternalMessageId ( type: esriFieldTypeString, alias: externalMessageId, length: 255 )

Relationships:

• request (0) -- Related To: requests (0)

Table: requestchanges (3)

Name: requestchanges

Display Field: RequestID

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: 51659035edda4390915f6fe9f8d3572e

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:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• RequestID ( type: esriFieldTypeInteger, alias: requestId )
• ChangeType ( type: esriFieldTypeString, alias: changeType, length: 1 , Coded Values: [A: Request Created] , [U: Attribute Update] , [C: Comment Added] )
• SubmittedBy ( type: esriFieldTypeString, alias: submittedBy, length: 100 )
• SubmittedDate ( type: esriFieldTypeDate, alias: submittedDate, length: 8 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )

Relationships:

• Request (1) -- Related To: requests (0)

Table: workordercomments (4)

Name: workordercomments

Display Field: SubmittedBy

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: 51659035edda4390915f6fe9f8d3572e

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:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• WorkOrderId ( type: esriFieldTypeInteger, alias: workOrderId )
• SubmittedBy ( type: esriFieldTypeString, alias: submittedBy, length: 100 )
• SubmittedDate ( type: esriFieldTypeDate, alias: submittedDate, length: 8 )
• Comment ( type: esriFieldTypeString, alias: comment, length: 1000 )

Relationships:

• workorder (2) -- Related To: workorders (1)

Table: workorderrequests (5)

Name: workorderrequests

Display Field: OBJECTID

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: 51659035edda4390915f6fe9f8d3572e

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:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• WorkOrderID ( type: esriFieldTypeInteger, alias: workOrderId )
• RequestID ( type: esriFieldTypeInteger, alias: requestId )