Layers:
-
Value: 0
Label: Horticulture
Description: N/A
Symbol:
-
Value: 1
Label: Maintenance
Description: N/A
Symbol:
-
Value: 2
Label: Signals
Description: N/A
Symbol:
-
Value: 3
Label: Storm Water
Description: N/A
Symbol:
-
Value: 4
Label: Administration
Description: N/A
Symbol:
-
Value: 5
Label: Test
Description: N/A
Symbol:
-
Value: 6
Label: Sanitation
Description: N/A
Symbol:
-
Value: 7
Label: Parks and Recreation
Description: N/A
Symbol:
-
Value: 8
Label: Streets, Sidewalks, Signs
Description: N/A
Symbol:
-
Value: 10
Label: Engineering
Description: N/A
Symbol:
-
Value: 11
Label: Code Enforcement
Description: N/A
Symbol:
-
Value: 12
Label: Storm
Description: N/A
Symbol:
-
Value: 13
Label: Storm Water Inspections
Description: N/A
Symbol:
-
Value: 15
Label: Riverfront Park and Naval Complex
Description: N/A
Symbol:
-
Value: 16
Label: PW Training
Description: N/A
Symbol:
-
Value: 17
Label: Garage Group
Description: N/A
Symbol:
-
Value: 18
Label: ELDT Training
Description: N/A
Symbol:
-
Value: 19
Label: Meetings
Description: N/A
Symbol:
-
Value: 20
Label: Contractor
Description: N/A
Symbol:
-
Value: 21
Label: Purchasing
Description: N/A
Symbol:
-
Value: 22
Label: Questions
Description: N/A
Symbol:
- OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
- DateReceived ( type: esriFieldTypeDate, alias: DateReceived, length: 8 )
- Location_Area ( type: esriFieldTypeString, alias: Location_Area, length: 100 )
- Address ( type: esriFieldTypeString, alias: Address, length: 100 )
- Facilty_Zone ( type: esriFieldTypeString, alias: Facilty_Zone, length: 100 )
- Requesting_Department ( type: esriFieldTypeSmallInteger, alias: Requesting_Department , Coded Values: [401: EXECUTIVE] , [410: COUNCIL] , [415: FINANCE] , ...28 more... )
- ProblemDescription ( type: esriFieldTypeString, alias: ProblemDescription, length: 1500 )
- RequestedCompletionDate ( type: esriFieldTypeDate, alias: RequestedCompletionDate, length: 8 )
- Status ( type: esriFieldTypeString, alias: Status, length: 50 , Coded Values: [Active: Active] , [On-Hold: On-Hold] , [Closed: Closed] , ...2 more... )
- Type ( type: esriFieldTypeSmallInteger, alias: Type )
- TeamLeader ( type: esriFieldTypeString, alias: TeamCoordinator, length: 50 )
- WorkNumID ( type: esriFieldTypeInteger, alias: WorkNumID )
- WorkorderID ( type: esriFieldTypeString, alias: WorkorderID, length: 50 )
- WorkComplete ( type: esriFieldTypeDate, alias: WorkComplete, length: 8 )
- Comments ( type: esriFieldTypeString, alias: Comments, length: 255 )
- PreExMaterial ( type: esriFieldTypeDouble, alias: Pre-ExMaterial )
- PurchasedMaterial ( type: esriFieldTypeDouble, alias: PurchasedMaterial )
- ServiceContract ( type: esriFieldTypeDouble, alias: ServiceContract )
- Labor ( type: esriFieldTypeDouble, alias: Labor )
- CouncilDistrict ( type: esriFieldTypeString, alias: CouncilDistrict, length: 50 )
- CallerNumber ( type: esriFieldTypeString, alias: CallerNumber, length: 20 )
- CallerEmail ( type: esriFieldTypeString, alias: CallerEmail, length: 250 )
- SHAPE ( type: esriFieldTypeGeometry, alias: SHAPE )
- TeamAssigned ( type: esriFieldTypeString, alias: TeamAssigned, length: 50 )
- ParentWorkorderID ( type: esriFieldTypeString, alias: ParentWorkorderID, length: 50 )
- AssignedAssetType ( type: esriFieldTypeString, alias: AssignedAssetType, length: 50 , Coded Values: [Facility: Facility] , [Street: Street] , [Address: Address] )
- WorkCompletedSummary ( type: esriFieldTypeString, alias: WorkCompletedSummary, length: 255 )
- CallerName ( type: esriFieldTypeString, alias: CallerName, length: 50 )
- Emailed ( type: esriFieldTypeString, alias: Emailed, length: 5 )
- EmailedDate ( type: esriFieldTypeDate, alias: EmailedDate, length: 8 )
- Source ( type: esriFieldTypeString, alias: Source, length: 50 )
- PurchasedMaterialsDescription ( type: esriFieldTypeString, alias: PurchasedMaterialsDescription, length: 1000 )
- Ownership ( type: esriFieldTypeString, alias: Ownership, length: 50 , Coded Values: [Berkeley County: Berkeley County] , [Charleston County: Charleston County] , [Community: Community] , ...9 more... )
- SpEmailGIS ( type: esriFieldTypeString, alias: SpEmailGIS, length: 5 )
- SpEmailTeamLeader ( type: esriFieldTypeString, alias: SpEmailTeamLeader, length: 5 )
- SpEmailTeamAssigned ( type: esriFieldTypeString, alias: SpEmailTeamAssigned, length: 5 )
- SpPrevTeamLeader ( type: esriFieldTypeString, alias: SpPrevTeamLeader, length: 50 )
- SpAssignedTeamLeader ( type: esriFieldTypeString, alias: SpAssignedTeamLeader, length: 5 )
- SpEmailParksRec ( type: esriFieldTypeString, alias: SpEmailParksRec, length: 5 )
- PipeMaterial ( type: esriFieldTypeString, alias: PipeMaterial, length: 50 , Coded Values: [CMP: CMP] , [CPP: CPP] , [Iron: Iron] , ...5 more... )
- PipeSize ( type: esriFieldTypeString, alias: PipeSize, length: 50 , Coded Values: [0: Unknown] , [.5: 1/2"] , [.75: 3/4"] , ...27 more... )
- PipeShape ( type: esriFieldTypeString, alias: PipeShape, length: 50 , Coded Values: [Arch: Arch] , [Circular: Circular] , [Elliptical: Elliptical] , ...2 more... )
- PipeType ( type: esriFieldTypeString, alias: PipeType, length: 50 )
- PipeLength ( type: esriFieldTypeDouble, alias: PipeLength )
- CityTeamLeader ( type: esriFieldTypeString, alias: CityTeamLeader, length: 50 )
- PRTeamLeader ( type: esriFieldTypeString, alias: PRTeamLeader, length: 50 )
- EMFEMA ( type: esriFieldTypeString, alias: EMFEMA, length: 50 , Coded Values: [Imelda-September-2025: Imelda-September-2025] , [None: None] , [Unknown Storm: Unknown Storm] )
- GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
- WorkStart ( type: esriFieldTypeDate, alias: WorkStart, length: 8 )
- WorkDiff ( type: esriFieldTypeDouble, alias: WorkDiff )
- SandbagVolume ( type: esriFieldTypeString, alias: SandbagAmount, length: 255 )
- AssetCondition ( type: esriFieldTypeString, alias: AssetCondition, length: 255 , Coded Values: [Good: Good] , [Fair: Fair] , [Poor: Poor] )
- AssetNotes ( type: esriFieldTypeString, alias: AssetConditionNotes, length: 1500 )
- ProblemType ( type: esriFieldTypeString, alias: ProblemType, length: 255 , Coded Values: [Assessment: Assessment] , [Deliver: Deliver] , [General Tasks: General Tasks] , ...19 more... )
- IllicitDischarge ( type: esriFieldTypeString, alias: IllicitDischarge, length: 255 , Coded Values: [yes: Yes] , [no: No] )
- DateClosed ( type: esriFieldTypeDate, alias: DateClosed, length: 8 )
- SpEmailRequestingDept ( type: esriFieldTypeSmallInteger, alias: SpEmailRequestingDept )
- created_user ( type: esriFieldTypeString, alias: created_user, length: 255 )
- created_date ( type: esriFieldTypeDate, alias: created_date, length: 8 )
- last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, length: 255 )
- last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, length: 8 )
-
Requesting_Department:
Inherited -
Status:
Inherited -
TeamLeader:
Coded Values: [Brian Welch: Brian Welch] , [Michael Smith: Michael Smith] , [Timothy Hutchinson: Timothy Hutchinson] -
TeamAssigned:
Coded Values: [HT Mowing 1: HT Mowing 1] , [HT Mowing 2: HT Mowing 2] , [HT Mowing 3: HT Mowing 3] , ...8 more... -
AssignedAssetType:
Inherited -
Ownership:
Inherited -
PipeMaterial:
Inherited -
PipeSize:
Inherited -
PipeShape:
Inherited -
EMFEMA:
Inherited -
ProblemType:
Inherited -
Requesting_Department:
Inherited -
Status:
Inherited -
TeamLeader:
Coded Values: [Robert Williams: Robert Williams] -
TeamAssigned:
Coded Values: [Benjamin Brown: Benjamin Brown] , [Contractor: Contractor] , [Eric Ethridge: Eric Ethridge] , ...5 more... -
AssignedAssetType:
Inherited -
Ownership:
Inherited -
PipeMaterial:
Inherited -
PipeSize:
Inherited -
PipeShape:
Inherited -
EMFEMA:
Inherited -
ProblemType:
Inherited -
Requesting_Department:
Inherited -
Status:
Inherited -
TeamLeader:
Coded Values: [BRIAN WELCH: BRIAN WELCH] , [DAN GOVER: DAN GOVER] , [EDGAR JENNINGS: EDGAR JENNINGS] , ...12 more... -
TeamAssigned:
Coded Values: [BROOKS, TERESA: BROOKS, TERESA] , [DAVOL, TOM: DAVOL, TOM] , [default: default] , ...7 more... -
AssignedAssetType:
Inherited -
Ownership:
Inherited -
PipeMaterial:
Inherited -
PipeSize:
Inherited -
PipeShape:
Inherited -
EMFEMA:
Inherited -
ProblemType:
Inherited -
Status:
Inherited -
ProblemType:
Inherited -
Requesting_Department:
Inherited -
Status:
Inherited -
TeamLeader:
Coded Values: [Antonio Tyler: Antonio Tyler] , [Carolina Waste: Carolina Waste] , [Donald Perry: Donald Perry] , ...4 more... -
TeamAssigned:
Coded Values: [Litter Team 1: Litter Team 1] , [Litter Team 2: Litter Team 2] , [ST Garbage CW: ST Garbage CW] , ...10 more... -
AssignedAssetType:
Inherited -
Ownership:
Inherited -
PipeMaterial:
Inherited -
PipeSize:
Inherited -
PipeShape:
Inherited -
EMFEMA:
Inherited -
ProblemType:
Inherited -
Requesting_Department:
Inherited -
Status:
Inherited -
TeamLeader:
Coded Values: [Carey Grant: Carey Grant] , [Micah Espiritu: Micah Espiritu] , [Mike Maksim: Mike Maksim] , ...1 more... -
TeamAssigned:
Coded Values: [North: North] , [South: South] -
AssignedAssetType:
Inherited -
Ownership:
Inherited -
PipeMaterial:
Inherited -
PipeSize:
Inherited -
PipeShape:
Inherited -
EMFEMA:
Inherited -
ProblemType:
Inherited -
Requesting_Department:
Inherited -
Status:
Inherited -
TeamLeader:
Coded Values: [Bernard Leach: Bernard Leach] , [Dan Gover: Dan Gover] , [Dennis Maxwell: Dennis Maxwell] , ...4 more... -
TeamAssigned:
Coded Values: [SW CCTV Pole: SW CCTV Pole] , [SW Construction: SW Construction] , [SW Equipment 0 A : SW Equipment 0 A] , ...21 more... -
AssignedAssetType:
Inherited -
Ownership:
Inherited -
PipeMaterial:
Inherited -
PipeSize:
Inherited -
PipeShape:
Inherited -
EMFEMA:
Inherited -
ProblemType:
Inherited -
Requesting_Department:
Inherited -
Status:
Inherited -
TeamLeader:
Coded Values: [Antonio Green: Antonio Green] , [Henry Smoke: Henry Smoke] , [James Shaw: James Shaw] -
TeamAssigned:
Coded Values: [PW Sweeper 1: PW Sweeper 1] , [Signs Team 1: Signs Team 1] , [Signs Team 2: Signs Team 2] , ...10 more... -
AssignedAssetType:
Inherited -
Ownership:
Inherited -
PipeMaterial:
Inherited -
PipeSize:
Inherited -
PipeShape:
Inherited -
EMFEMA:
Inherited -
ProblemType:
Inherited -
Requesting_Department:
Inherited -
Status:
Inherited -
TeamLeader:
Coded Values: [JC West: JC West] , [Robert Williams: Robert Williams] -
TeamAssigned:
Coded Values: [Contractor: Contractor] , [JC West: JC West] , [John Miller: John Miller] , ...2 more... -
AssignedAssetType:
Inherited -
Ownership:
Inherited -
PipeMaterial:
Inherited -
PipeSize:
Inherited -
PipeShape:
Inherited -
EMFEMA:
Inherited -
ProblemType:
Inherited -
Requesting_Department:
Inherited -
Status:
Inherited -
TeamLeader:
Coded Values: [Barry Givens: Barry Givens] , [Hunter Walker: Hunter Walker] , [James Hull: James Hull] , ...4 more... -
TeamAssigned:
Coded Values: [Barry Givens: Barry Givens] , [Hunter Walker: Hunter Walker] , [James Hull: James Hull] , ...4 more... -
AssignedAssetType:
Inherited -
Ownership:
Inherited -
PipeMaterial:
Inherited -
PipeSize:
Inherited -
PipeShape:
Inherited -
EMFEMA:
Inherited -
ProblemType:
Inherited -
Requesting_Department:
Inherited -
Status:
Inherited -
TeamLeader:
Coded Values: [Humberto Pelay: Humberto Pelay] -
TeamAssigned:
Coded Values: [Humberto Pelay: Humberto Pelay] -
AssignedAssetType:
Inherited -
Ownership:
Inherited -
PipeMaterial:
Inherited -
PipeSize:
Inherited -
PipeShape:
Inherited -
EMFEMA:
Inherited -
ProblemType:
Inherited -
Requesting_Department:
Inherited -
Status:
Inherited -
TeamLeader:
Coded Values: [Heath, Amy: Heath, Amy] , [Hiott, Bobby: Hiott, Bobby] , [McDonald, Paul: McDonald, Paul] , ...3 more... -
TeamAssigned:
Coded Values: [Heath, Amy: Heath, Amy] , [Hiott, Bobby: Hiott, Bobby] , [McDonald, Paul: McDonald, Paul] , ...3 more... -
AssignedAssetType:
Inherited -
Ownership:
Inherited -
PipeMaterial:
Inherited -
PipeSize:
Inherited -
PipeShape:
Inherited -
EMFEMA:
Inherited -
ProblemType:
Inherited -
Requesting_Department:
Inherited -
Status:
Inherited -
TeamLeader:
Coded Values: [Bernard Leach: Bernard Leach] , [Dan Gover: Dan Gover] , [Dennis Maxwell: Dennis Maxwell] , ...4 more... -
TeamAssigned:
Coded Values: [SW CCTV Pole: SW CCTV Pole] , [SW Construction: SW Construction] , [SW Equipment 0 A : SW Equipment 0 A] , ...21 more... -
AssignedAssetType:
Inherited -
Ownership:
Inherited -
PipeMaterial:
Inherited -
PipeSize:
Inherited -
PipeShape:
Inherited -
EMFEMA:
Inherited -
ProblemType:
Inherited -
Requesting_Department:
Inherited -
Status:
Inherited -
TeamLeader:
Coded Values: [Bernard Leach: Bernard Leach] , [Dan Gover: Dan Gover] , [Edgar Jennings: Edgar Jennings] , ...6 more... -
TeamAssigned:
Coded Values: [Sanitation: Sanitation] , [Storm Water: Storm Water] , [Horticulture: Horticulture] , ...3 more... -
AssignedAssetType:
Inherited -
Ownership:
Inherited -
PipeMaterial:
Inherited -
PipeSize:
Inherited -
PipeShape:
Inherited -
EMFEMA:
Inherited -
ProblemType:
Inherited -
Requesting_Department:
Inherited -
Status:
Inherited -
TeamLeader:
Coded Values: [BRIAN WELCH: BRIAN WELCH] , [DAN GOVER: DAN GOVER] , [EDGAR JENNINGS: EDGAR JENNINGS] , ...12 more... -
TeamAssigned:
Coded Values: [Brian Klinger: Brian Klinger] , [Clinton Young: Clinton Young] , [Devonte Jennings: Devonte Jennings] , ...20 more... -
AssignedAssetType:
Inherited -
Ownership:
Inherited -
PipeMaterial:
Inherited -
PipeSize:
Inherited -
PipeShape:
Inherited -
EMFEMA:
Inherited -
ProblemType:
Inherited -
Requesting_Department:
Inherited -
Status:
Inherited -
TeamLeader:
Coded Values: [Dan Gover: Dan Gover] , [Ethan Shaw: Ethan Shaw] , [Bernard Leach: Bernard Leach] , ...2 more... -
AssignedAssetType:
Inherited -
Ownership:
Inherited -
PipeMaterial:
Inherited -
PipeSize:
Inherited -
PipeShape:
Inherited -
EMFEMA:
Inherited -
AssetCondition:
Inherited -
ProblemType:
Inherited -
Requesting_Department:
Inherited -
Status:
Inherited -
TeamLeader:
Coded Values: [Bernard Leach: Bernard Leach] , [Dan Gover: Dan Gover] , [Edgar Jennings: Edgar Jennings] , ...14 more... -
TeamAssigned:
Coded Values: [Sanitation: Sanitation] , [Storm Water: Storm Water] , [Horticulture: Horticulture] , ...3 more... -
AssignedAssetType:
Inherited -
Ownership:
Inherited -
PipeMaterial:
Inherited -
PipeSize:
Inherited -
PipeShape:
Inherited -
EMFEMA:
Inherited -
AssetCondition:
Inherited -
ProblemType:
Inherited -
Status:
Inherited -
TeamLeader:
Coded Values: [Stormwater: Stormwater] -
TeamAssigned:
Coded Values: [SW Construction: SW Construction] -
AssignedAssetType:
Inherited -
Ownership:
Inherited -
PipeMaterial:
Inherited -
PipeSize:
Inherited -
PipeShape:
Inherited -
EMFEMA:
Inherited -
AssetCondition:
Inherited -
ProblemType:
Inherited -
Status:
Inherited -
CallerEmail:
Coded Values: [amancha2288@gmail.com: amancha2288@gmail.com] , [andrewparker@thegreeneryinc.com: andrewparker@thegreeneryinc.com] , [caseye@russelllandscape.com: caseye@russelllandscape.com] , ...18 more... -
AssignedAssetType:
Inherited -
CallerName:
Coded Values: [Alex Mancha : Alex Mancha] , [Andrew Parker : Andrew Parker] , [Carl Rokes : Carl Rokes] , ...18 more... -
Ownership:
Inherited -
PipeMaterial:
Inherited -
PipeSize:
Inherited -
PipeShape:
Inherited -
EMFEMA:
Inherited -
AssetCondition:
Inherited -
ProblemType:
Inherited -
Requesting_Department:
Inherited -
Status:
Inherited -
TeamLeader:
Coded Values: [Bernard Leach: Bernard Leach] , [Brian Welch: Brian Welch] , [Dan Gover: Dan Gover] , ...15 more... -
TeamAssigned:
Coded Values: [Assessment: Assessment] , [Debris Pickup: Debris Pickup] , [Sandbag Operations: Sandbag Operations] , ...2 more... -
AssignedAssetType:
Inherited -
Ownership:
Inherited -
PipeMaterial:
Inherited -
PipeSize:
Inherited -
PipeShape:
Inherited -
EMFEMA:
Inherited -
AssetCondition:
Inherited -
ProblemType:
Inherited -
IllicitDischarge:
Inherited -
Requesting_Department:
Inherited -
Status:
Inherited -
TeamLeader:
Coded Values: [Angela Cartrette: Court] , [Angela Johnson: Police] , [Angela Wimberly: Human Resources] , ...12 more... -
TeamAssigned:
Coded Values: [Chad Kurp: Chad Kurp] , [John Murdaugh: John Murdaugh] , [Robin Sullivan: Robin Sullivan] , ...37 more... -
AssignedAssetType:
Inherited -
Ownership:
Inherited -
PipeMaterial:
Inherited -
PipeSize:
Inherited -
PipeShape:
Inherited -
EMFEMA:
Inherited -
AssetCondition:
Inherited -
ProblemType:
Inherited -
IllicitDischarge:
Inherited -
Requesting_Department:
Inherited -
Status:
Inherited -
TeamLeader:
Coded Values: [Melissa Pate: Melissa Pate] -
AssignedAssetType:
Inherited -
Ownership:
Inherited -
PipeMaterial:
Inherited -
PipeSize:
Inherited -
PipeShape:
Inherited -
EMFEMA:
Inherited -
AssetCondition:
Inherited -
ProblemType:
Inherited -
IllicitDischarge:
Inherited
Layer: Active Workorders (0)
Name: Active WorkordersDisplay Field: CallerName
Type: Feature Layer
Geometry Type: esriGeometryPoint
Description:
Copyright Text:
Default Visibility: true
MaxRecordCount: 2000
Supported Query Formats: JSON, geoJSON, PBF
Min Scale: 0.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: -3.525748439829396E7
YMin: -2.0482259373031497E7
XMax: 3.331561123884514E7
YMax: 3.778407497703412E7
Spatial Reference: 2273 (2273) LatestVCSWkid(0)
Drawing Info:
-
Renderer:
- Unique Value Renderer:
Field 1: Type
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
- N/A
UniqueValueInfos:
Labeling Info:
-
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: Type
Fields:
-
ID: 0
Name: Horticulture
Domains:
ID: 1
Name: Maintenance
Domains:
ID: 4
Name: Administration
Domains:
ID: 5
Name: Test
Domains:
ID: 6
Name: Sanitation
Domains:
ID: 7
Name: Parks and Recreation
Domains:
ID: 3
Name: Storm Water
Domains:
ID: 8
Name: Streets, Sidewalks, Signs
Domains:
ID: 2
Name: Signals
Domains:
ID: 10
Name: Engineering
Domains:
ID: 11
Name: Code Enforcement
Domains:
ID: 15
Name: Riverfront Park and Naval Complex
Domains:
ID: 13
Name: Storm Inspections
Domains:
ID: 16
Name: PW Training
Domains:
ID: 17
Name: Garage Group
Domains:
ID: 18
Name: ELDT Training
Domains:
ID: 19
Name: Meetings
Domains:
ID: 20
Name: Contractor
Domains:
ID: 21
Name: Purchasing
Domains:
ID: 12
Name: Storm
Domains:
ID: 22
Name: Questions
Domains:
ID: 23
Name: Grocery Carts
Domains:
- SDE.Equipment (0) -- Related To: Equipment (4)
- SDE.Trailers (1) -- Related To: Trailers (2)
- SDE.Vehicles (2) -- Related To: Vehicles (1)
- SDE.Staff (4) -- Related To: Staff (3)
Tables:
- OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
- Subtype ( type: esriFieldTypeSmallInteger, alias: Subtype )
- Equipment ( type: esriFieldTypeString, alias: Equipment, length: 50 )
- TotalHours ( type: esriFieldTypeDouble, alias: TotalHours )
- Comments ( type: esriFieldTypeString, alias: CommentsE, length: 255 )
- WorkOrderObjID ( type: esriFieldTypeInteger, alias: WorkOrderObjID )
- created_user ( type: esriFieldTypeString, alias: created_user, length: 255 )
- created_date ( type: esriFieldTypeDate, alias: created_date, length: 8 )
- last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, length: 255 )
- last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, length: 8 )
- GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
- WorkOrderGlobalId ( type: esriFieldTypeGUID, alias: WorkOrderGlobalId, length: 38 )
-
Equipment:
Coded Values: [621-5614 Exmark Mower: 621-5614 Exmark Mower] , [621-5615 Exmark mower: 621-5615 Exmark mower] , [621-5658 Tracked Lift: 621-5658 Tracked Lift] , ...38 more... -
Equipment:
Coded Values: [2 ½” trash pump: 2 ½” trash pump] , [3/8 inch diameter sewer machine: 3/8 inch diameter sewer machine] , [4000 psi pressure washer: 4000 psi pressure washer] , ...4 more... -
Equipment:
Coded Values: [Misc: Misc] -
Equipment:
Coded Values: [621-0104 Pro Patch Pothole Patcher Asphalt Trailer: 621-0104 Pro Patch Pothole Patcher Asphalt Trailer] , [621-0109 Infrared Trailer: 621-0109 Infrared Trailer] , [621-0111 Caterpillar Roller: 621-0111 Caterpillar Roller] , ...31 more... -
Equipment:
Coded Values: [630-001 SW Chainsaw 001: 630-001 SW Chainsaw 001] , [630-002 SW Chainsaw 002: 630-002 SW Chainsaw 002] , [630-003 SW Chainsaw 003: 630-003 SW Chainsaw 003] , ...86 more... -
Equipment:
Coded Values: [Backpack Blower: Backpack Blower] , [Chainsaw: Chainsaw] , [Litter Vac: Litter Vac] -
Equipment:
Coded Values: [630-001 SW Chainsaw 001: 630-001 SW Chainsaw 001] , [630-160 Concrete Saw - 1: 630-160 Concrete Saw - 1] , [630-161 Concrete Saw - 2: 630-161 Concrete Saw - 2] , ...87 more... -
Equipment:
Coded Values: [PW Training Equipment: PW Training Equipment] -
Equipment:
Coded Values: [Admin equipment: Admin equipment]
Table: Equipment (4)
Name: EquipmentDisplay Field: Equipment
Type: Table
Geometry Type: N/A
Description: null
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
-
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: true
HTML Popup Type: esriServerHTMLPopupTypeNone
Type ID Field: Subtype
Fields:
-
ID: 0
Name: Horticulture
Domains:
ID: 1
Name: Maintenance
Domains:
ID: 3
Name: Signals Signs
Domains:
ID: 4
Name: Streets, Sidewalks and Signs
Domains:
ID: 2
Name: Storm Water
Domains:
ID: 5
Name: Sanitation
Domains:
ID: 6
Name: Storm Debris
Domains:
ID: 7
Name: PW Training
Domains:
ID: 8
Name: Administration
Domains:
ID: 12
Name: Storm
Domains:
- SDE.Workorder (0) -- Related To: Active Workorders (0)
- OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
- Name ( type: esriFieldTypeString, alias: Name, length: 255 , Coded Values: [ALSTON, SHANNAH: ALSTON, SHANNAH] , [ANDREWS, RAQUAN: ANDREWS, RAQUAN] , [ARNOLD, HUNTER: ARNOLD, HUNTER] , ...135 more... )
- Note ( type: esriFieldTypeString, alias: Note, length: 255 )
- WorkOrderObjID ( type: esriFieldTypeInteger, alias: WorkOrderObjID )
- Subtype ( type: esriFieldTypeSmallInteger, alias: Subtype )
- GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
- WorkOrderGlobalId ( type: esriFieldTypeGUID, alias: WorkOrderGlobalId, length: 38 )
-
Name:
Coded Values: [CHISOLM, ANTWAIN: CHISOLM, ANTWAIN] , [DANIELS SR, DWAYNE L: DANIELS SR, DWAYNE L] , [DOEBLER, DONNA: DOEBLER, DONNA] , ...20 more... -
Name:
Coded Values: [BARFIELD, WILLIAM: BARFIELD, WILLIAM] , [BENKA, ANDY: BENKA, ANDY] , [BLUNT, ALBERT S: BLUNT, ALBERT S] , ...11 more... -
Name:
Coded Values: [BAKER, RASHIDI P: BAKER, RASHIDI P] , [BENNETT, MILEAK: BENNETT, MILEAK] , [BLAKE, KEITH: BLAKE, KEITH] , ...56 more... -
Name:
Coded Values: [ALSTON, SHANNAH: ALSTON, SHANNAH] , [ANCRUM, BRANDON: ANCRUM, BRANDON] , [BLAKE, DISHONE: BLAKE, DISHONE] , ...44 more... -
Name:
Coded Values: [BROWN, QUANTARIUS: BROWN, QUANTARIUS] , [GREEN JR, ANTONIO L: GREEN JR, ANTONIO L] , [GREEN, ANTONIO L: GREEN, ANTONIO L] , ...9 more... -
Name:
Coded Values: [Barry Givens: Barry Givens] , [Hunter Walker: Hunter Walker] , [James Hull: James Hull] , ...4 more... -
Name:
Coded Values: [CHISOLM, ANTWAIN: CHISOLM, ANTWAIN] , [DANIELS SR, DWAYNE L: DANIELS SR, DWAYNE L] , [DOEBLER, DONNA: DOEBLER, DONNA] , ...80 more... -
Name:
Coded Values: [BROOKS, TERESA: BROOKS, TERESA] , [DAVOL, TOM: DAVOL, TOM] , [default: default] , ...7 more... -
Name:
Coded Values: [Brian Klinger: Brian Klinger] , [Clinton Young: Clinton Young] , [Devonte Jennings: Devonte Jennings] , ...20 more... -
Name:
Inherited
Table: Staff (3)
Name: StaffDisplay Field: Name
Type: Table
Geometry Type: N/A
Description: null
Service Item Id: 872ce9edd5cc4cf2bd87bf857756054b
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
-
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: true
HTML Popup Type: esriServerHTMLPopupTypeNone
Type ID Field: Subtype
Fields:
-
ID: 0
Name: Horticulture
Domains:
ID: 1
Name: Maintenance
Domains:
ID: 6
Name: Sanitation
Domains:
ID: 7
Name: Parks and Recreation
Domains:
ID: 3
Name: Storm Water
Domains:
ID: 8
Name: Streets, Sidewalks, Signs
Domains:
ID: 2
Name: Signals
Domains:
ID: 10
Name: Engineering
Domains:
ID: 12
Name: Storm Debris
Domains:
ID: 13
Name: Administration
Domains:
ID: 14
Name: Garage Group
Domains:
ID: 15
Name: PW Training
Domains:
ID: 16
Name: Storm
Domains:
- SDE.Workorder (4) -- Related To: Active Workorders (0)
- OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
- GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
- Unit ( type: esriFieldTypeString, alias: Unit, length: 255 , Coded Values: [637-0100 : 637-0100] , [637-0101: 637-0101] , [637-0102 : 637-0102] , ...41 more... )
- SerialNum ( type: esriFieldTypeString, alias: SerialNum, length: 255 )
- MfgYear ( type: esriFieldTypeDate, alias: MfgYear, length: 8 )
- VehMake ( type: esriFieldTypeString, alias: VehicleMake, length: 255 )
- WorkOrderObjID ( type: esriFieldTypeInteger, alias: WorkOrderObjID )
- Subtype ( type: esriFieldTypeSmallInteger, alias: Subtype )
- Comments ( type: esriFieldTypeString, alias: Comments, length: 255 )
- created_user ( type: esriFieldTypeString, alias: created_user, length: 255 )
- created_date ( type: esriFieldTypeDate, alias: created_date, length: 8 )
- last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, length: 255 )
- last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, length: 8 )
- WorkOrderGlobalId ( type: esriFieldTypeGUID, alias: WorkOrderGlobalId, length: 38 )
-
Unit:
Coded Values: [621-0724 Trailer: 621-0724 Trailer] , [630-9711 Landscape Trailer : 630-9711 Landscape Trailer] , [621-5659T trailer: 621-5659T trailer] -
Unit:
Coded Values: [630-9714 Towmaster: 630-9714 Towmaster] -
Unit:
Coded Values: [621-0103 Trailer: 621-0103 Trailer] , [621-0920 Trailer: 621-0920 Trailer] -
Unit:
Inherited -
Unit:
Coded Values: [PPW Training Trailer: PPW Training Trailer] -
Unit:
Coded Values: [Admin Trailer: Admin Trailer]
Table: Trailers (2)
Name: TrailersDisplay Field: Unit
Type: Table
Geometry Type: N/A
Description: null
Service Item Id: 872ce9edd5cc4cf2bd87bf857756054b
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
-
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: true
HTML Popup Type: esriServerHTMLPopupTypeNone
Type ID Field: Subtype
Fields:
-
ID: 0
Name: Horticulture
Domains:
ID: 1
Name: Maintenance
Domains:
ID: 2
Name: Signals Signs
Domains:
ID: 3
Name: Storm Water
Domains:
ID: 4
Name: Streets
Domains:
ID: 5
Name: Sanitation
Domains:
ID: 6
Name: PW Training
Domains:
ID: 7
Name: Administration
Domains:
ID: 12
Name: Storm
Domains:
- SDE.Workorder (1) -- Related To: Active Workorders (0)
- OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
- Subtype ( type: esriFieldTypeSmallInteger, alias: Subtype )
- Vehicle ( type: esriFieldTypeString, alias: Vehicle, length: 50 )
- TotalHours ( type: esriFieldTypeDouble, alias: TotalHours )
- TotalMiles ( type: esriFieldTypeDouble, alias: TotalMiles )
- Comments ( type: esriFieldTypeString, alias: Comments, length: 255 )
- WorkOrderObjID ( type: esriFieldTypeInteger, alias: WorkOrderObjID )
- created_user ( type: esriFieldTypeString, alias: created_user, length: 255 )
- created_date ( type: esriFieldTypeDate, alias: created_date, length: 8 )
- last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, length: 255 )
- last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, length: 8 )
- GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
- WorkOrderGlobalId ( type: esriFieldTypeGUID, alias: WorkOrderGlobalId, length: 38 )
-
Vehicle:
Coded Values: [621-0701: 621-0701] , [621-0702: 621-0702] , [621-0703: 621-0703] , ...26 more... -
Vehicle:
Coded Values: [TK 600: TK 600] , [TK 602: TK 602] , [TK 603: TK 603] , ...7 more... -
Vehicle:
Coded Values: [TK 345: TK 345] , [TK 346: TK 346] , [TK 349: TK 349] , ...3 more... -
Vehicle:
Coded Values: [621-0753: 621-0753] , [630-0001: 630-0001] , [630-0003: 630-0003] , ...49 more... -
Vehicle:
Coded Values: [630-0880: 630-0880] , [630-0877: 630-0877] , [630-0876: 630-0876] , ...18 more... -
Vehicle:
Coded Values: [637-0201: 637-0201 Take home F-150] , [637-0202: 637-0202 Take Home F-150] , [637-0209 : 637-0209 - Take Home (dodge pickup)] , ...46 more... -
Vehicle:
Coded Values: [620-0001: 620-0001] , [620-0002: 620-0002] , [620-0003: 620-0003] , ...15 more... -
Vehicle:
Coded Values: [637-0835: 637-0835] , [630-0861: 630-0861] , [630-0860: 630-0860] , ...100 more... -
Vehicle:
Coded Values: [PPW Training Vehicle: PW Training Vehicle]
Table: Vehicles (1)
Name: VehiclesDisplay Field: Vehicle
Type: Table
Geometry Type: N/A
Description: null
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
-
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: true
HTML Popup Type: esriServerHTMLPopupTypeNone
Type ID Field: Subtype
Fields:
-
ID: 0
Name: Horticulture
Domains:
ID: 1
Name: Maintenance
Domains:
ID: 3
Name: Signals Signs
Domains:
ID: 2
Name: Storm Water
Domains:
ID: 4
Name: Streets
Domains:
ID: 6
Name: Sanitation
Domains:
ID: 7
Name: Administration
Domains:
ID: 8
Name: Storm Debris
Domains:
ID: 9
Name: PW Training
Domains:
ID: 12
Name: Storm
Domains:
- SDE.Workorder (2) -- Related To: Active Workorders (0)
- ATTACHMENTID ( type: esriFieldTypeOID, alias: ATTACHMENTID )
- REL_GLOBALID ( type: esriFieldTypeGUID, alias: REL_GLOBALID, length: 38 )
- CONTENT_TYPE ( type: esriFieldTypeString, alias: CONTENT_TYPE, length: 150 )
- ATT_NAME ( type: esriFieldTypeString, alias: ATT_NAME, length: 250 )
- DATA_SIZE ( type: esriFieldTypeInteger, alias: DATA_SIZE )
- DATA ( type: esriFieldTypeBlob, alias: DATA )
- GLOBALID ( type: esriFieldTypeGlobalID, alias: GLOBALID, length: 38 )
Table: SDE.Workorder__ATTACH (8)
Name: SDE.Workorder__ATTACHDisplay Field: ATT_NAME
Type: Table
Geometry Type: N/A
Description: null
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
-
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: