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: cdf5db1f0ee741ed9b2b0f5b9b8a4f01

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

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: 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: 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: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• Status ( type: esriFieldTypeString, alias: status, editable: true, nullable: true, length: 10, defaultValue: New, modelName: Status , Coded Values: [New: New] , [Working: Working] , [Completed: Completed] )
• Description ( type: esriFieldTypeString, alias: description, editable: true, nullable: true, length: 1000, defaultValue: null, modelName: Description )
• LocationDescription ( type: esriFieldTypeString, alias: locationDescription, editable: true, nullable: true, length: 200, defaultValue: null, modelName: LocationDescription )
• LocationDescriptionShort ( type: esriFieldTypeString, alias: locationDescriptionShort, editable: true, nullable: true, length: 100, defaultValue: null, modelName: LocationDescriptionShort )
• LocationAccuracy ( type: esriFieldTypeInteger, alias: locationAccuracy, editable: true, nullable: true, defaultValue: null, modelName: LocationAccuracy )
• SubmittedBy ( type: esriFieldTypeString, alias: submittedBy, editable: true, nullable: true, length: 100, defaultValue: null, modelName: SubmittedBy )
• SubmittedDate ( type: esriFieldTypeDate, alias: submittedDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: SubmittedDate )
• ChangedDate ( type: esriFieldTypeDate, alias: changedDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: ChangedDate )
• ResponsibleEntity ( type: esriFieldTypeString, alias: responsibleEntity, editable: true, nullable: true, length: 10, defaultValue: null, modelName: ResponsibleEntity )
• Confirmation ( type: esriFieldTypeString, alias: confirmation, editable: true, nullable: true, length: 20, defaultValue: null, modelName: Confirmation )
• Inappropriate ( type: esriFieldTypeString, alias: inappropriate, editable: true, nullable: true, length: 1, defaultValue: N, modelName: Inappropriate , Coded Values: [N: No] , [Y: Yes] )
• RequestType ( type: esriFieldTypeString, alias: requestType, editable: true, nullable: true, length: 255, defaultValue: null, modelName: RequestType )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• ResolvedBy ( type: esriFieldTypeString, alias: resolvedBy, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ResolvedBy )
• ExternalWorkOrderId ( type: esriFieldTypeString, alias: externalWorkOrderId, editable: true, nullable: true, length: 36, defaultValue: null, modelName: ExternalWorkOrderId )
Templates:
• Name: LUKE_development.GISOWNER.requests_dev
  Description:
  Prototype:
  ResolvedBy: null
  Status: New
  Description: null
  LocationDescription: null
  LocationDescriptionShort: null
  LocationAccuracy: null
  SubmittedBy: null
  SubmittedDate: null
  ChangedDate: null
  ResponsibleEntity: null
  Confirmation: null
  Inappropriate: N
  RequestType: null
  ExternalWorkOrderId: null
  
  Drawing Tool: esriFeatureEditToolPoint

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: cdf5db1f0ee741ed9b2b0f5b9b8a4f01

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

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: 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: 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: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

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

Relationships:

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

Tables:

Table: comments (2)

Name: comments

Display Field: SubmittedDate

Type: Table

Geometry Type: N/A

Description:

Service Item Id: cdf5db1f0ee741ed9b2b0f5b9b8a4f01

Copyright Text:

Default Visibility: false

MaxRecordCount: 1000

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:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• RequestId ( type: esriFieldTypeInteger, alias: requestId, editable: true, nullable: true, defaultValue: null, modelName: RequestId )
• Comment ( type: esriFieldTypeString, alias: comment, editable: true, nullable: true, length: 1000, defaultValue: null, modelName: Comment )
• SubmittedBy ( type: esriFieldTypeString, alias: submittedBy, editable: true, nullable: true, length: 100, defaultValue: null, modelName: SubmittedBy )
• SubmittedDate ( type: esriFieldTypeDate, alias: submittedDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: SubmittedDate )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• ExternalMessageId ( type: esriFieldTypeString, alias: externalMessageId, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ExternalMessageId )
Templates:
• Name: comments
  Description:
  Prototype:
  ExternalMessageId: null
  SubmittedDate: null
  RequestId: null
  Comment: null
  SubmittedBy: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

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

Table: requestchanges (3)

Name: requestchanges

Display Field: RequestID

Type: Table

Geometry Type: N/A

Description:

Service Item Id: cdf5db1f0ee741ed9b2b0f5b9b8a4f01

Copyright Text:

Default Visibility: false

MaxRecordCount: 1000

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:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• RequestID ( type: esriFieldTypeInteger, alias: requestId, editable: true, nullable: false, defaultValue: null, modelName: RequestID )
• ChangeType ( type: esriFieldTypeString, alias: changeType, editable: true, nullable: true, length: 1, defaultValue: null, modelName: ChangeType , Coded Values: [A: Request Created] , [U: Attribute Update] , [C: Comment Added] )
• SubmittedBy ( type: esriFieldTypeString, alias: submittedBy, editable: true, nullable: true, length: 100, defaultValue: null, modelName: SubmittedBy )
• SubmittedDate ( type: esriFieldTypeDate, alias: submittedDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: SubmittedDate )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
Templates:
• Name: requestchanges
  Description:
  Prototype:
  SubmittedDate: null
  SubmittedBy: null
  RequestID: 0
  ChangeType: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

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

Table: workordercomments (4)

Name: workordercomments

Display Field: SubmittedBy

Type: Table

Geometry Type: N/A

Description:

Service Item Id: cdf5db1f0ee741ed9b2b0f5b9b8a4f01

Copyright Text:

Default Visibility: false

MaxRecordCount: 1000

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:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• WorkOrderId ( type: esriFieldTypeInteger, alias: workOrderId, editable: true, nullable: true, defaultValue: null, modelName: RequestId )
• SubmittedBy ( type: esriFieldTypeString, alias: submittedBy, editable: true, nullable: true, length: 100, defaultValue: null, modelName: SubmittedBy )
• SubmittedDate ( type: esriFieldTypeDate, alias: submittedDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: SubmittedDate )
• Comment ( type: esriFieldTypeString, alias: comment, editable: true, nullable: true, length: 1000, defaultValue: null, modelName: Comment )
Templates:
• Name: workordercomments
  Description:
  Prototype:
  SubmittedDate: null
  Comment: null
  WorkOrderId: null
  SubmittedBy: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

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

Table: workorderrequests (5)

Name: workorderrequests

Display Field: OBJECTID

Type: Table

Geometry Type: N/A

Description:

Service Item Id: cdf5db1f0ee741ed9b2b0f5b9b8a4f01

Copyright Text:

Default Visibility: false

MaxRecordCount: 1000

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:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• WorkOrderID ( type: esriFieldTypeInteger, alias: workOrderId, editable: true, nullable: false, defaultValue: null, modelName: WorkOrderID )
• RequestID ( type: esriFieldTypeInteger, alias: requestId, editable: true, nullable: false, defaultValue: null, modelName: RequestID )
Templates:
• Name: workorderrequests
  Description:
  Prototype:
  WorkOrderID: 0
  RequestID: 0
  
  Drawing Tool: esriFeatureEditToolNone