Name: Work Orders

Display Field: WorkOrderID

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: This feature class represents parent Work Orders managed within the OpenGOV EAM platform. While individual Tasks represent discrete field actions, Work Orders aggregate related tasks, resources, assets, and costs under a unified project umbrella (e.g., major storm cleanup, annual sidewalk repair programs, or facility upgrades).Automated Sync & Workflow:Sync Mechanism: Updated automatically via a scheduled nightly synchronization process (ETL) connecting OpenGOV EAM to the enterprise geodatabase.Spatial Representation: Spatial geometries reflect associated asset locations, work order centroids, or defined project boundaries.Maintenance & Update Frequency: Daily (Nightly Automated Sync)Process Step (Lineage Description):Work Order Creation & Management: Operations managers create and assign Work Orders in OpenGOV EAM to bundle related maintenance activities and budget allocations.Nightly ETL Sync: Scheduled scripts query OpenGOV EAM for new, updated, or closed Work Orders and their associated spatial extents.Enterprise GIS Update: Records and key metrics (status, actual vs. estimated costs, completion dates) are refreshed in the enterprise geodatabase.

Service Item Id: 6c8a339f8d1d4673b98f150ccd9b90bd

Copyright Text: City of Grapevine Public Works Department, PW GIS Division, OpenGOV EAM.

Default Visibility: false

Max Result Window: N/A

Max Record Count: 2000

Standard Max Record Count No Geometry: 32000

Max Record Count Factor: 1

Standard MaxRecord Count: 32000

Tile Max Record Count: 8000

MaxSelectionCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 100000.0

Max Scale: 0.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: NaN
YMin: NaN
XMax: NaN
YMax: NaN
Spatial Reference: 102100  (3857)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [76, 139, 173, 255]
Size: 4.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[0, 0, 0, 255] Width: 0
Label: N/A
Description: N/A
Transparency: 0
Labeling Info:

Feature Draw Order:

N/A

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports Result Pagination Token: false
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: true
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Cache Hint: false
Supports Query With Current User: true
Supports Query With Result Type: true

HasZ: false

HasM: false

Has Attachments: false

Has Last Edit Time: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: N/A

Fields:

• OBJECTID ( nullable: false, alias: OBJECTID, type: esriFieldTypeOID )
• Shape ( nullable: true, alias: SHAPE, type: esriFieldTypeGeometry )
• WorkOrderID ( nullable: true, length: 30, alias: Work Order ID, type: esriFieldTypeString )
• Description ( nullable: true, length: 254, alias: Description, type: esriFieldTypeString )
• Status ( nullable: true, length: 25, alias: Status, type: esriFieldTypeString )
• Tasks ( nullable: true, alias: Tasks, type: esriFieldTypeInteger )
• Repeating ( nullable: true, length: 5, alias: Repeating, type: esriFieldTypeString )
• Department ( nullable: true, length: 50, alias: Department, type: esriFieldTypeString )
• FiscalYear ( nullable: true, length: 25, alias: Fiscal Year, type: esriFieldTypeString )
• Priority ( nullable: true, length: 50, alias: Priority, type: esriFieldTypeString )
• StartDate ( nullable: true, length: 8, alias: Start Date, type: esriFieldTypeDate )
• StopDate ( nullable: true, length: 8, alias: Stop Date, type: esriFieldTypeDate )
• WorkPlan ( nullable: true, length: 8, alias: Work Plan, type: esriFieldTypeString )
• GlobalID ( nullable: false, length: 38, alias: GlobalID, type: esriFieldTypeGlobalID )
• last_edited_user ( nullable: true, length: 255, alias: last_edited_user, type: esriFieldTypeString )
• last_edited_date ( nullable: true, length: 8, alias: last_edited_date, type: esriFieldTypeDate )
• TotalCost ( nullable: true, alias: Total Cost, type: esriFieldTypeDouble )
• TotalCostEstimated ( nullable: true, alias: Total Cost Estimated, type: esriFieldTypeDouble )
• TotalEquipmentCost ( nullable: true, alias: Total Equipment Cost, type: esriFieldTypeDouble )
• TotalEquipmentCostEstimated ( nullable: true, alias: Total Equipment Cost Estimated, type: esriFieldTypeDouble )
• TotalLaborCost ( nullable: true, alias: Total Labor Cost, type: esriFieldTypeDouble )
• TotalLaborCostEstimated ( nullable: true, alias: Total Labor Cost Estimated, type: esriFieldTypeDouble )
• TotalLaborHours ( nullable: true, alias: Total Labor Hours, type: esriFieldTypeDouble )
• TotalLaborHoursEstimated ( nullable: true, alias: Total Labor Hours Estimated, type: esriFieldTypeDouble )
• TotalMaterialCost ( nullable: true, alias: Total Material Cost, type: esriFieldTypeDouble )
• TotalMaterialCostEstimated ( nullable: true, alias: Total Material Cost Estimated, type: esriFieldTypeDouble )
• TotalOtherCost ( nullable: true, alias: Total Other Cost, type: esriFieldTypeDouble )
• TotalOtherCostEstimated ( nullable: true, alias: Total Other Cost Estimated, type: esriFieldTypeDouble )
• Notes ( nullable: true, length: 1000, alias: Notes, type: esriFieldTypeString )
• EntryDate ( nullable: true, length: 8, alias: Entry Date, type: esriFieldTypeDate )
• created_user ( nullable: true, length: 255, alias: created_user, type: esriFieldTypeString )
• created_date ( nullable: true, length: 8, alias: created_date, type: esriFieldTypeDate )

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

  Iteminfo   Thumbnail   Metadata