Name: plEQUIPMENT

Display Field: Name

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: ce334058acb74448892fced75305a34f

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

Advanced Query Capabilities:

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

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: Subtype

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• FacilityID ( type: esriFieldTypeString, alias: FacilityID, length: 50 )
• PolyID ( type: esriFieldTypeString, alias: PolyID, length: 50 )
• Subtype ( type: esriFieldTypeInteger, alias: Subtype )
• Name ( type: esriFieldTypeString, alias: Name, length: 50 )
• Make ( type: esriFieldTypeString, alias: Make, length: 50 )
• Model ( type: esriFieldTypeString, alias: Model, length: 50 )
• Serial ( type: esriFieldTypeString, alias: Serial, length: 50 )
• Condition ( type: esriFieldTypeString, alias: Condition, length: 10 , Coded Values: [0: Unobtainable] , [1: Very Good. Like new] , [2: Good. Minor improvement required] , ...3 more... )
• ConditionDate ( type: esriFieldTypeDate, alias: ConditionDate, length: 8 )
• LifeCycle ( type: esriFieldTypeString, alias: LifeCycle, length: 50 , Coded Values: [Planning: Planning] , [Design: Design] , [Construction: Construction] , ...4 more... )
• StatusDate ( type: esriFieldTypeDate, alias: StatusDate, length: 8 )
• Comments ( type: esriFieldTypeString, alias: Comments, length: 255 )
• FunctionalAsset ( type: esriFieldTypeString, alias: FunctionalAsset, length: 50 )
• AssetCategory ( type: esriFieldTypeString, alias: AssetCategory, length: 25 , Coded Values: [Process Building: Process Building] , [Process Electrical: Process Electrical] , [Process Mechanical: Process Mechanical] , ...4 more... )
• InstallDate ( type: esriFieldTypeDate, alias: InstallDate, length: 8 )
• PlantType ( type: esriFieldTypeString, alias: PlantType, length: 25 , Coded Values: [Wastewater: Wastewater] , [Water: Water] , [Reuse: Reuse] , ...4 more... )
• UnitProcess ( type: esriFieldTypeString, alias: UnitProcess, length: 25 , Coded Values: [Advanced Treatment: Advanced Treatment] , [Dewatering: Dewatering] , [Disinfection: Disinfection] , ...8 more... )
• FacilityName ( type: esriFieldTypeString, alias: FacilityName, length: 150 , Coded Values: [Rotonda WRF: Rotonda WRF] , [West Port WRF: West Port WRF] , [East Port WRF: East Port WRF] , ...14 more... )
• OMLink ( type: esriFieldTypeString, alias: OMLink, length: 250 )
• Location ( type: esriFieldTypeString, alias: Location, length: 255 )
• Address ( type: esriFieldTypeString, alias: Address, length: 255 )
• LegacyID ( type: esriFieldTypeString, alias: LegacyID, length: 50 )
• MaintBy ( type: esriFieldTypeString, alias: MaintBy, length: 50 , Coded Values: [Charlotte County: Charlotte County] , [City: City] , [FDOT: FDOT] , ...8 more... )
• OwnedBy ( type: esriFieldTypeString, alias: OwnedBy, length: 50 , Coded Values: [FDOT: FDOT] , [COUNTY: COUNTY] , [CITY: CITY] , ...2 more... )
• WarrantyDate ( type: esriFieldTypeDate, alias: WarrantyDate, length: 8 )
• ConsequenceOfFailure ( type: esriFieldTypeSmallInteger, alias: ConsequenceOfFailure , Coded Values: [1: Very Minor] , [2: Minor] , [3: Moderate] , ...2 more... )
• ProbabilityOfFailure ( type: esriFieldTypeSmallInteger, alias: ProbabilityOfFailure , Coded Values: [1: Very Low: Failure is unlikely] , [2: Low: Failure might happen] , [3: Moderate: Failure could occur] , ...2 more... )
• Criticality ( type: esriFieldTypeSmallInteger, alias: Criticality , Coded Values: [1: Very Low] , [2: Very Low] , [3: Very Low] , ...22 more... )
• PurchasePrice ( type: esriFieldTypeDouble, alias: PurchasePrice )
• PurchaseDate ( type: esriFieldTypeDate, alias: PurchaseDate, length: 8 )
• LastInspectedDate ( type: esriFieldTypeDate, alias: LastInspectedDate, length: 8 )
• LifeExpectancy ( type: esriFieldTypeSmallInteger, alias: LifeExpectancy )
• ReplacementCost ( type: esriFieldTypeDouble, alias: ReplacementCost )
• AttachmentLink ( type: esriFieldTypeString, alias: AttachmentLink, length: 255 )
• ObjectCategory ( type: esriFieldTypeString, alias: ObjectCategory, length: 100 )
• ObjectClass ( type: esriFieldTypeString, alias: ObjectClass, length: 100 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )

Types:

ID: 0
Name: Undefined
Domains:
• Condition:
  Inherited
• LifeCycle:
  Inherited
• AssetCategory:
  Inherited
• PlantType:
  Inherited
• UnitProcess:
  Inherited
• FacilityName:
  Inherited
• MaintBy:
  Inherited
• OwnedBy:
  Inherited
• ConsequenceOfFailure:
  Inherited
• ProbabilityOfFailure:
  Inherited
• Criticality:
  Inherited

---

ID: 1
Name: Crane
Domains:
• Condition:
  Inherited
• LifeCycle:
  Inherited
• AssetCategory:
  Inherited
• PlantType:
  Inherited
• UnitProcess:
  Inherited
• FacilityName:
  Inherited
• MaintBy:
  Inherited
• OwnedBy:
  Inherited
• ConsequenceOfFailure:
  Inherited
• ProbabilityOfFailure:
  Inherited
• Criticality:
  Inherited

---

ID: 2
Name: Hoist
Domains:
• Condition:
  Inherited
• LifeCycle:
  Inherited
• AssetCategory:
  Inherited
• PlantType:
  Inherited
• UnitProcess:
  Inherited
• FacilityName:
  Inherited
• MaintBy:
  Inherited
• OwnedBy:
  Inherited
• ConsequenceOfFailure:
  Inherited
• ProbabilityOfFailure:
  Inherited
• Criticality:
  Inherited

---

ID: 3
Name: Misc
Domains:
• Condition:
  Inherited
• LifeCycle:
  Inherited
• AssetCategory:
  Inherited
• PlantType:
  Inherited
• UnitProcess:
  Inherited
• FacilityName:
  Inherited
• MaintBy:
  Inherited
• OwnedBy:
  Inherited
• ConsequenceOfFailure:
  Inherited
• ProbabilityOfFailure:
  Inherited
• Criticality:
  Inherited

---

ID: 4
Name: Fan
Domains:
• Condition:
  Inherited
• LifeCycle:
  Inherited
• AssetCategory:
  Inherited
• PlantType:
  Inherited
• UnitProcess:
  Inherited
• FacilityName:
  Inherited
• MaintBy:
  Inherited
• OwnedBy:
  Inherited
• ConsequenceOfFailure:
  Inherited
• ProbabilityOfFailure:
  Inherited
• Criticality:
  Inherited

---

ID: 5
Name: Diesel Radiator
Domains:
• Condition:
  Inherited
• LifeCycle:
  Inherited
• AssetCategory:
  Inherited
• PlantType:
  Inherited
• UnitProcess:
  Inherited
• FacilityName:
  Inherited
• MaintBy:
  Inherited
• OwnedBy:
  Inherited
• ConsequenceOfFailure:
  Inherited
• ProbabilityOfFailure:
  Inherited
• Criticality:
  Inherited

---

ID: 6
Name: Scale
Domains:
• Condition:
  Inherited
• LifeCycle:
  Inherited
• AssetCategory:
  Inherited
• PlantType:
  Inherited
• UnitProcess:
  Inherited
• FacilityName:
  Inherited
• MaintBy:
  Inherited
• OwnedBy:
  Inherited
• ConsequenceOfFailure:
  Inherited
• ProbabilityOfFailure:
  Inherited
• Criticality:
  Inherited

---

Relationships:

• wplMOTOR (54) -- Related To: wplMOTOR (5)
• wplTanks (13) -- Related To: wtpTanks (2)
• wplFacilities (36) -- Related To: wplFacilities (4)

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

  Iteminfo   Thumbnail   Metadata