Layers:

Layer: Workorder (0)

Name: Workorder

Display 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
Default Label: N/A
UniqueValueInfos:
• Value: 4
  Label: Administration
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [184, 252, 195, 255]
  Size: 6.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [255, 255, 255, 255] Width: 0
• Value: 11
  Label: Code Enforcement
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [255, 115, 223, 255]
  Size: 6.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [255, 255, 255, 255] Width: 0
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: Type

Fields:
• 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 )
Types:
ID: 0
Name: Horticulture
Domains:
• 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

---

ID: 1
Name: Maintenance
Domains:
• 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

---

ID: 4
Name: Administration
Domains:
• 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

---

ID: 5
Name: Test
Domains:
• Status:
  Inherited
• ProblemType:
  Inherited

---

ID: 6
Name: Sanitation
Domains:
• 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

---

ID: 7
Name: Parks and Recreation
Domains:
• 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

---

ID: 3
Name: Storm Water
Domains:
• 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

---

ID: 8
Name: Streets, Sidewalks, Signs
Domains:
• 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

---

ID: 2
Name: Signals
Domains:
• 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

---

ID: 10
Name: Engineering
Domains:
• 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

---

ID: 11
Name: Code Enforcement
Domains:
• 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

---

ID: 15
Name: Riverfront Park and Naval Complex
Domains:
• 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

---

ID: 13
Name: Storm Inspections
Domains:
• 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

---

ID: 16
Name: PW Training
Domains:
• 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

---

ID: 17
Name: Garage Group
Domains:
• 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

---

ID: 18
Name: ELDT Training
Domains:
• 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

---

ID: 19
Name: Meetings
Domains:
• 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

---

ID: 20
Name: Contractor
Domains:
• 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

---

ID: 21
Name: Purchasing
Domains:
• 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

---

ID: 12
Name: Storm
Domains:
• 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

---

ID: 22
Name: Questions
Domains:
• 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

---

ID: 23
Name: Grocery Carts
Domains:
• 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

---