View In:   ArcGIS Online Map Viewer

Name: Workorder

Display Field: CallerName

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: b8d65d986b4a4cf382b2f1a017c4051f

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

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

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

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• DateReceived ( type: esriFieldTypeDate, alias: DateReceived, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DateReceived )
• Location_Area ( type: esriFieldTypeString, alias: Location_Area, editable: true, nullable: true, length: 100, defaultValue: null, modelName: Location_Area )
• Address ( type: esriFieldTypeString, alias: Address, editable: true, nullable: true, length: 100, defaultValue: null, modelName: Address )
• Facilty_Zone ( type: esriFieldTypeString, alias: Facilty_Zone, editable: true, nullable: true, length: 100, defaultValue: null, modelName: Facilty_Zone )
• Requesting_Department ( type: esriFieldTypeSmallInteger, alias: Requesting_Department, editable: true, nullable: true, defaultValue: null, modelName: Requesting_Department , Coded Values: [401: EXECUTIVE] , [410: COUNCIL] , [415: FINANCE] , ...28 more... )
• ProblemDescription ( type: esriFieldTypeString, alias: ProblemDescription, editable: true, nullable: true, length: 1500, defaultValue: null, modelName: ProblemDescription )
• RequestedCompletionDate ( type: esriFieldTypeDate, alias: RequestedCompletionDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: RequestedCompletionDate )
• Status ( type: esriFieldTypeString, alias: Status, editable: true, nullable: true, length: 50, defaultValue: Active, modelName: Status , Coded Values: [Active: Active] , [On-Hold: On-Hold] , [Closed: Closed] , ...2 more... )
• Type ( type: esriFieldTypeSmallInteger, alias: Type, editable: true, nullable: true, defaultValue: 4, modelName: Type )
• TeamLeader ( type: esriFieldTypeString, alias: TeamCoordinator, editable: true, nullable: true, length: 50, defaultValue: None, modelName: TeamLeader )
• WorkNumID ( type: esriFieldTypeInteger, alias: WorkNumID, editable: true, nullable: true, defaultValue: null, modelName: WorkNumID )
• WorkorderID ( type: esriFieldTypeString, alias: WorkorderID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: WorkorderID )
• WorkComplete ( type: esriFieldTypeDate, alias: WorkComplete, editable: true, nullable: true, length: 8, defaultValue: null, modelName: WorkComplete )
• Comments ( type: esriFieldTypeString, alias: Comments, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Comments )
• PreExMaterial ( type: esriFieldTypeDouble, alias: Pre-ExMaterial, editable: true, nullable: true, defaultValue: null, modelName: PreExMaterial )
• PurchasedMaterial ( type: esriFieldTypeDouble, alias: PurchasedMaterial, editable: true, nullable: true, defaultValue: null, modelName: PurchasedMaterial )
• ServiceContract ( type: esriFieldTypeDouble, alias: ServiceContract, editable: true, nullable: true, defaultValue: null, modelName: ServiceContract )
• Labor ( type: esriFieldTypeDouble, alias: Labor, editable: true, nullable: true, defaultValue: null, modelName: Labor )
• CouncilDistrict ( type: esriFieldTypeString, alias: CouncilDistrict, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CouncilDistrict )
• CallerNumber ( type: esriFieldTypeString, alias: CallerNumber, editable: true, nullable: true, length: 20, defaultValue: null, modelName: CallerNumber )
• CallerEmail ( type: esriFieldTypeString, alias: CallerEmail, editable: true, nullable: true, length: 250, defaultValue: null, modelName: CallerEmail )
• TeamAssigned ( type: esriFieldTypeString, alias: TeamAssigned, editable: true, nullable: true, length: 50, defaultValue: null, modelName: TeamAssigned )
• ParentWorkorderID ( type: esriFieldTypeString, alias: ParentWorkorderID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ParentWorkorderID )
• AssignedAssetType ( type: esriFieldTypeString, alias: AssignedAssetType, editable: true, nullable: true, length: 50, defaultValue: null, modelName: AssignedAssetType , Coded Values: [Facility: Facility] , [Street: Street] , [Address: Address] )
• WorkCompletedSummary ( type: esriFieldTypeString, alias: WorkCompletedSummary, editable: true, nullable: true, length: 255, defaultValue: null, modelName: WorkCompletedSummary )
• CallerName ( type: esriFieldTypeString, alias: CallerName, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CallerName )
• Emailed ( type: esriFieldTypeString, alias: Emailed, editable: true, nullable: true, length: 5, defaultValue: null, modelName: Emailed )
• EmailedDate ( type: esriFieldTypeDate, alias: EmailedDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: EmailedDate )
• Source ( type: esriFieldTypeString, alias: Source, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Source )
• PurchasedMaterialsDescription ( type: esriFieldTypeString, alias: PurchasedMaterialsDescription, editable: true, nullable: true, length: 1000, defaultValue: null, modelName: PurchasedMaterialsDescription )
• Ownership ( type: esriFieldTypeString, alias: Ownership, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Ownership , Coded Values: [Berkeley County: Berkeley County] , [Charleston County: Charleston County] , [Community: Community] , ...9 more... )
• SpEmailGIS ( type: esriFieldTypeString, alias: SpEmailGIS, editable: true, nullable: true, length: 5, defaultValue: null, modelName: SpEmailGIS )
• SpEmailTeamLeader ( type: esriFieldTypeString, alias: SpEmailTeamLeader, editable: true, nullable: true, length: 5, defaultValue: null, modelName: SpEmailTeamLeader )
• SpEmailTeamAssigned ( type: esriFieldTypeString, alias: SpEmailTeamAssigned, editable: true, nullable: true, length: 5, defaultValue: null, modelName: SpEmailTeamAssigned )
• SpPrevTeamLeader ( type: esriFieldTypeString, alias: SpPrevTeamLeader, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SpPrevTeamLeader )
• SpAssignedTeamLeader ( type: esriFieldTypeString, alias: SpAssignedTeamLeader, editable: true, nullable: true, length: 5, defaultValue: null, modelName: SpAssignedTeamLeader )
• SpEmailParksRec ( type: esriFieldTypeString, alias: SpEmailParksRec, editable: true, nullable: true, length: 5, defaultValue: null, modelName: SpEmailParksRec )
• PipeMaterial ( type: esriFieldTypeString, alias: PipeMaterial, editable: true, nullable: true, length: 50, defaultValue: null, modelName: PipeMaterial , Coded Values: [CMP: CMP] , [CPP: CPP] , [Iron: Iron] , ...5 more... )
• PipeSize ( type: esriFieldTypeString, alias: PipeSize, editable: true, nullable: true, length: 50, defaultValue: null, modelName: PipeSize , Coded Values: [0: Unknown] , [.5: 1/2"] , [.75: 3/4"] , ...27 more... )
• PipeShape ( type: esriFieldTypeString, alias: PipeShape, editable: true, nullable: true, length: 50, defaultValue: null, modelName: PipeShape , Coded Values: [Arch: Arch] , [Circular: Circular] , [Elliptical: Elliptical] , ...2 more... )
• PipeType ( type: esriFieldTypeString, alias: PipeType, editable: true, nullable: true, length: 50, defaultValue: null, modelName: PipeType )
• PipeLength ( type: esriFieldTypeDouble, alias: PipeLength, editable: true, nullable: true, defaultValue: null, modelName: PipeLength )
• CityTeamLeader ( type: esriFieldTypeString, alias: CityTeamLeader, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CityTeamLeader )
• PRTeamLeader ( type: esriFieldTypeString, alias: PRTeamLeader, editable: true, nullable: true, length: 50, defaultValue: null, modelName: PRTeamLeader )
• EMFEMA ( type: esriFieldTypeString, alias: EMFEMA, editable: true, nullable: true, length: 50, defaultValue: null, modelName: EMFEMA , Coded Values: [Imelda-September-2025: Imelda-September-2025] , [None: None] , [Unknown Storm: Unknown Storm] )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• WorkStart ( type: esriFieldTypeDate, alias: WorkStart, editable: true, nullable: true, length: 8, defaultValue: null, modelName: WorkStart )
• WorkDiff ( type: esriFieldTypeDouble, alias: WorkDiff, editable: true, nullable: true, defaultValue: null, modelName: WorkDiff )
• SandbagVolume ( type: esriFieldTypeString, alias: SandbagAmount, editable: true, nullable: true, length: 255, defaultValue: null, modelName: SandbagVolume )
• AssetCondition ( type: esriFieldTypeString, alias: AssetCondition, editable: true, nullable: true, length: 255, defaultValue: null, modelName: AssetCondition , Coded Values: [Good: Good] , [Fair: Fair] , [Poor: Poor] )
• AssetNotes ( type: esriFieldTypeString, alias: AssetConditionNotes, editable: true, nullable: true, length: 1500, defaultValue: null, modelName: AssetNotes )
• ProblemType ( type: esriFieldTypeString, alias: ProblemType, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ProblemType , Coded Values: [Assessment: Assessment] , [Deliver: Deliver] , [General Tasks: General Tasks] , ...19 more... )
• IllicitDischarge ( type: esriFieldTypeString, alias: IllicitDischarge, editable: true, nullable: true, length: 255, defaultValue: null, modelName: IllicitDischarge , Coded Values: [yes: Yes] , [no: No] )
• DateClosed ( type: esriFieldTypeDate, alias: DateClosed, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DateClosed )
• SpEmailRequestingDept ( type: esriFieldTypeSmallInteger, alias: SpEmailRequestingDept, editable: true, nullable: true, defaultValue: 0, modelName: SpEmailRequestingDept )
• created_user ( type: esriFieldTypeString, alias: created_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: created_user )
• created_date ( type: esriFieldTypeDate, alias: created_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created_date )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )

Types:

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
Templates:
• Name: Administration
  Description:
  Prototype:
  DateClosed: null
  SpEmailRequestingDept: null
  DateReceived: null
  Location_Area: null
  Address: null
  Facilty_Zone: null
  Requesting_Department: null
  ProblemDescription: null
  RequestedCompletionDate: null
  Status: Active
  Type: 4
  TeamLeader: null
  WorkNumID: null
  WorkorderID: null
  WorkComplete: null
  Comments: null
  PreExMaterial: null
  PurchasedMaterial: null
  ServiceContract: null
  Labor: null
  CouncilDistrict: null
  CallerNumber: null
  CallerEmail: null
  TeamAssigned: null
  ParentWorkorderID: null
  AssignedAssetType: null
  WorkCompletedSummary: null
  CallerName: null
  Emailed: null
  EmailedDate: null
  Source: null
  PurchasedMaterialsDescription: null
  Ownership: null
  SpEmailGIS: null
  SpEmailTeamLeader: null
  SpEmailTeamAssigned: null
  SpPrevTeamLeader: null
  SpAssignedTeamLeader: null
  SpEmailParksRec: null
  PipeMaterial: null
  PipeSize: null
  PipeShape: null
  PipeType: null
  PipeLength: null
  CityTeamLeader: null
  PRTeamLeader: null
  EMFEMA: null
  IllicitDischarge: null
  WorkStart: null
  WorkDiff: null
  SandbagVolume: null
  AssetCondition: null
  AssetNotes: null
  ProblemType: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

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
Templates:
• Name: Code Enforcement
  Description:
  Prototype:
  DateClosed: null
  SpEmailRequestingDept: null
  DateReceived: null
  Location_Area: null
  Address: null
  Facilty_Zone: null
  Requesting_Department: null
  ProblemDescription: null
  RequestedCompletionDate: null
  Status: Active
  Type: 11
  TeamLeader: null
  WorkNumID: null
  WorkorderID: null
  WorkComplete: null
  Comments: null
  PreExMaterial: null
  PurchasedMaterial: null
  ServiceContract: null
  Labor: null
  CouncilDistrict: null
  CallerNumber: null
  CallerEmail: null
  TeamAssigned: null
  ParentWorkorderID: null
  AssignedAssetType: Address
  WorkCompletedSummary: null
  CallerName: null
  Emailed: null
  EmailedDate: null
  Source: null
  PurchasedMaterialsDescription: null
  Ownership: null
  SpEmailGIS: null
  SpEmailTeamLeader: null
  SpEmailTeamAssigned: null
  SpPrevTeamLeader: null
  SpAssignedTeamLeader: null
  SpEmailParksRec: null
  PipeMaterial: null
  PipeSize: null
  PipeShape: null
  PipeType: null
  PipeLength: null
  CityTeamLeader: null
  PRTeamLeader: null
  EMFEMA: null
  IllicitDischarge: null
  WorkStart: null
  WorkDiff: null
  SandbagVolume: null
  AssetCondition: null
  AssetNotes: null
  ProblemType: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

Capabilities: Query,Create,Update,Uploads,Editing,Extract

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: true

Supports ApplyEdits By Upload Id: true

Edit Fields Info:

• Creation Date Field: created_date
• Creator Field: created_user
• Edit Date Field: last_edited_date
• Editor Field: last_edited_user

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Child Resources:   Field Groups   Contingent Values

Supported Operations:   Query   Query Attachments   Query Analytic   Apply Edits   Add Features   Update Features   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata   Update Metadata