Layers:

Layer: SanitaryLiftStations (1)

Name: SanitaryLiftStations

Display Field: LiftStationNumber

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 500000.0

Max Scale: 0.0

Supports Advanced Queries: true

Supports Statistics: true

Has Labels: true

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:
XMin: -1.0788786561216032E7
YMin: 5888849.226719654
XMax: -1.0771643582211569E7
YMax: 5942677.278255591
Spatial Reference: 102100  (3857)  LatestVCSWkid(0)



Drawing Info:
Renderer:
Simple Renderer:
Symbol:
Label: N/A
Description: N/A
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: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

Fields:
• LiftStationNumber ( type: esriFieldTypeString, alias: LiftStationNumber, length: 100 )
• Comments ( type: esriFieldTypeString, alias: Comments, length: 255 )
• OriginalProjectNumber ( type: esriFieldTypeString, alias: OriginalProjectNumber, length: 25 )
• YearInstalled ( type: esriFieldTypeString, alias: YearInstalled, length: 16 )
• ImprovementProjectNumber ( type: esriFieldTypeString, alias: ImprovementProjectNumber, length: 16 )
• YearImproved ( type: esriFieldTypeString, alias: YearImproved, length: 16 )
• ProjectRetired ( type: esriFieldTypeString, alias: ProjectRetired, length: 50 )
• YearRetired ( type: esriFieldTypeString, alias: YearRetired, length: 8 )
• Material ( type: esriFieldTypeString, alias: Material, length: 100 )
• NumberOfPumps ( type: esriFieldTypeString, alias: NumberOfPumps, length: 25 )
• SizeOfPumps ( type: esriFieldTypeString, alias: SizeOfPumps, length: 25 )
• TypeOfPumps ( type: esriFieldTypeString, alias: TypeOfPumps, length: 25 )
• Manufacturer ( type: esriFieldTypeString, alias: Manufacturer, length: 25 )
• GallonsPerMinute ( type: esriFieldTypeString, alias: GallonsPerMinute, length: 25 )
• HP ( type: esriFieldTypeString, alias: HP, length: 16 )
• RPM ( type: esriFieldTypeString, alias: RPM, length: 16 )
• Volts ( type: esriFieldTypeString, alias: Volts, length: 16 )
• Building ( type: esriFieldTypeString, alias: Building, length: 16 )
• Power ( type: esriFieldTypeString, alias: Power, length: 25 )
• GenKW ( type: esriFieldTypeString, alias: GenKW, length: 25 )
• Head ( type: esriFieldTypeString, alias: Head, length: 25 )
• InsuranceNumbers ( type: esriFieldTypeString, alias: InsuranceNumbers, length: 25 )
• InsuranceLimit ( type: esriFieldTypeString, alias: InsuranceLimit, length: 25 )
• InterceptorArea ( type: esriFieldTypeString, alias: InterceptorArea , length: 50 )
• ConsequenceOfFailure ( type: esriFieldTypeDouble, alias: ConsequenceOfFailure )
• ProbabilityOfFailure ( type: esriFieldTypeDouble, alias: ProbabilityOfFailure )
• Mitigation ( type: esriFieldTypeDouble, alias: Mitigation )
• Risk ( type: esriFieldTypeDouble, alias: Risk )
• EstimatedLife ( type: esriFieldTypeSmallInteger, alias: EstimatedLife )
• InstallationDate ( type: esriFieldTypeDate, alias: InstallationDate, length: 8 )
• ReplacementCost ( type: esriFieldTypeDouble, alias: ReplacementCost )
• CostingDate ( type: esriFieldTypeDate, alias: CostingDate , length: 8 )
• LiftStationArea ( type: esriFieldTypeString, alias: LiftStationArea, length: 50 )
• Location ( type: esriFieldTypeString, alias: Location, length: 150 )
• Status ( type: esriFieldTypeString, alias: Status, length: 50 , Coded Values: [Planned: Planned] , [Active: Active] , [Abandoned: Abandoned] , ...3 more... )
• Asset_ID ( type: esriFieldTypeString, alias: Asset_ID , length: 20 )
• Parent_ID ( type: esriFieldTypeString, alias: Parent_ID, length: 50 )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• Shape ( type: esriFieldTypeGeometry, alias: Shape )
• 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 )
• Jurisdiction ( type: esriFieldTypeString, alias: Jurisdiction, length: 50 )
• X ( type: esriFieldTypeDouble, alias: X )
• Y ( type: esriFieldTypeDouble, alias: Y )
• Private ( type: esriFieldTypeString, alias: Private, length: 50 , Coded Values: [Yes: Yes] , [No: No] )

Relationships:

• ssLiftStationPump (0) -- Related To: FargoLiftStation.DBO.ssLiftStationPump (9)
• ssLiftStationOdorControlFilter (1) -- Related To: FargoLiftStation.DBO.ssLiftStationOdorControlFilter (6)
• ssLiftStationGenReceptacle (2) -- Related To: Cityworks_sde.DBO.ssLiftStationGenReceptacle (16)
• ssLiftStationFlowMeter (3) -- Related To: Cityworks_sde.DBO.ssLiftStationFlowMeter (17)
• ssLiftStationRTU (4) -- Related To: FargoLiftStation.DBO.ssLiftStationRTU (10)
• ssLiftStationControlPanel (5) -- Related To: FargoLiftStation.DBO.ssLiftStationControlPanel (2)
• ssLiftStationHVAC (6) -- Related To: FargoLiftStation.DBO.ssLiftStationHVAC (4)
• ssLiftStationGenerator (7) -- Related To: FargoLiftStation.DBO.ssLiftStationGenerator (3)
• ssLiftStationOdorControlPump (8) -- Related To: FargoLiftStation.DBO.ssLiftStationOdorControlPump (7)
• ssLiftStationValves (9) -- Related To: FargoLiftStation.DBO.ssLiftStationValves (13)
• ssLiftStationOdorControlTank (10) -- Related To: FargoLiftStation.DBO.ssLiftStationOdorControlTank (8)
• ssLiftStationStructure (11) -- Related To: FargoLiftStation.DBO.ssLiftStationStructure (11)
• ssLiftStationWetDryWell (12) -- Related To: FargoLiftStation.DBO.ssLiftStationWetDryWell (14)
• ssLiftStationUnitHeater (13) -- Related To: Cityworks_sde.DBO.ssLiftStationUnitHeater (15)
• ssLiftStationTransferSwitch (14) -- Related To: FargoLiftStation.DBO.ssLiftStationTransferSwitch (12)
• ssLiftStationOverheadHoist (15) -- Related To: Cityworks_sde.DBO.ssLiftStationOverheadHoist (18)

Tables:

Table: FargoLiftStation.DBO.ssLiftStationControlPanel (2)

Name: FargoLiftStation.DBO.ssLiftStationControlPanel

Display Field: ControlPanelName

Type: Table

Geometry Type: N/A

Description: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 1000

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
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:
• LiftStationNumber ( type: esriFieldTypeString, alias: Lift Station Number, length: 50 )
• ConsequenceOfFailure ( type: esriFieldTypeDouble, alias: ConsequenceOfFailure )
• ProbabilityOfFailure ( type: esriFieldTypeDouble, alias: ProbabilityOfFailure )
• Mitigation ( type: esriFieldTypeDouble, alias: Mitigation )
• Risk ( type: esriFieldTypeDouble, alias: Risk )
• EstimatedLife ( type: esriFieldTypeSmallInteger, alias: EstimatedLife )
• InstallationDate ( type: esriFieldTypeDate, alias: InstallationDate, length: 8 )
• Type ( type: esriFieldTypeString, alias: Material, length: 100 )
• ReplacementCost ( type: esriFieldTypeDouble, alias: ReplacementCost )
• CostingDate ( type: esriFieldTypeDate, alias: CostingDate, length: 8 )
• Voltage ( type: esriFieldTypeDouble, alias: Voltage )
• Phase ( type: esriFieldTypeDouble, alias: Phase )
• Frequency ( type: esriFieldTypeDouble, alias: Frequency )
• Manufacture ( type: esriFieldTypeString, alias: Manufacture, length: 50 )
• Model ( type: esriFieldTypeString, alias: Model, length: 50 )
• SerialNumber ( type: esriFieldTypeString, alias: Serial Number, length: 50 )
• GeneralContractor ( type: esriFieldTypeString, alias: General Contractor, length: 50 )
• EngProjectNumber ( type: esriFieldTypeString, alias: Engineering Project Number, length: 50 )
• USBManufacture ( type: esriFieldTypeString, alias: USB Manufacture (May be with RTU), length: 50 )
• USBInstallationDate ( type: esriFieldTypeDate, alias: USB Installation Date (May be with RTU), length: 8 )
• USBModel ( type: esriFieldTypeString, alias: USB Model Number (May be with RTU), length: 50 )
• USBSerialNumber ( type: esriFieldTypeString, alias: USB Serial Number (May be with RTU), length: 50 )
• MemoryBatteryManufacture ( type: esriFieldTypeString, alias: Memory Battery Manufacture (May be with RTU), length: 50 )
• MemoryBatteryModel ( type: esriFieldTypeString, alias: Memory Battery Model Number (May be with RTU), length: 50 )
• MemoryBatterySerialNumber ( type: esriFieldTypeString, alias: Memory Battery Serial Number (May be with RTU), length: 50 )
• MemoryBatteryInstallationDate ( type: esriFieldTypeDate, alias: Installation Date of Memory Battery (May be with RTU), length: 8 )
• USB_Battery ( type: esriFieldTypeString, alias: USB Battery, length: 10 , Coded Values: [Yes: Yes] , [No: No] )
• MemoryBattery ( type: esriFieldTypeString, alias: Memory Battery, length: 10 , Coded Values: [Yes: Yes] , [No: No] )
• MainBreakerManufacture ( type: esriFieldTypeString, alias: Main Breaker Manufacture, length: 50 )
• PumpBreakerManufacture ( type: esriFieldTypeString, alias: Pump Breaker Manufacture, length: 50 )
• GeneratorBreakerManufacture ( type: esriFieldTypeString, alias: Generator Breakder Manufacture, length: 50 )
• ControlPanelName ( type: esriFieldTypeString, alias: ControlPanelName, length: 50 )
• MainBreakerSize ( type: esriFieldTypeDouble, alias: Main Breaker Size )
• PumpBreakerSize ( type: esriFieldTypeDouble, alias: Pump Breaker Size )
• GeneratorBreakerSize ( type: esriFieldTypeDouble, alias: Generator Breaker Size )
• Location ( type: esriFieldTypeString, alias: Location, length: 200 )
• Status ( type: esriFieldTypeString, alias: Status, length: 50 , Coded Values: [Planned: Planned] , [Active: Active] , [Abandoned: Abandoned] , ...3 more... )
• Asset_ID ( type: esriFieldTypeString, alias: Asset_ID, length: 20 )
• Parent_ID ( type: esriFieldTypeString, alias: Parent_ID, length: 50 )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• 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 )
• OldParentID ( type: esriFieldTypeString, alias: OldParentID, length: 50 )

Relationships:

• SanitaryLiftStations (5) -- Related To: SanitaryLiftStations (1)

Table: FargoLiftStation.DBO.ssLiftStationGenerator (3)

Name: FargoLiftStation.DBO.ssLiftStationGenerator

Display Field: GeneratorName

Type: Table

Geometry Type: N/A

Description: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 1000

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
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:
• LiftStationNumber ( type: esriFieldTypeString, alias: LiftStationNumber, length: 255 )
• ConsequenceOfFailure ( type: esriFieldTypeDouble, alias: ConsequenceOfFailure )
• ProbabilityOfFailure ( type: esriFieldTypeDouble, alias: ProbabilityOfFailure )
• Mitigation ( type: esriFieldTypeDouble, alias: Mitigation )
• Risk ( type: esriFieldTypeDouble, alias: Risk )
• EstimatedLife ( type: esriFieldTypeSmallInteger, alias: EstimatedLife )
• InstallationDate ( type: esriFieldTypeDate, alias: InstallationDate, length: 8 )
• Material ( type: esriFieldTypeString, alias: Material, length: 100 )
• ReplacementCost ( type: esriFieldTypeDouble, alias: ReplacementCost )
• CostingDate ( type: esriFieldTypeDate, alias: CostingDate, length: 8 )
• kWkVARating ( type: esriFieldTypeDouble, alias: kW/kVA Rating )
• Voltage ( type: esriFieldTypeDouble, alias: Voltage )
• Phase ( type: esriFieldTypeDouble, alias: Phase )
• Manufacture ( type: esriFieldTypeString, alias: Manufacturer, length: 100 )
• Model ( type: esriFieldTypeString, alias: Model, length: 50 )
• SerialNumber ( type: esriFieldTypeString, alias: SerialNumber, length: 50 )
• EngProjectNumber ( type: esriFieldTypeString, alias: EngProjectNumber, length: 50 )
• FuelType ( type: esriFieldTypeString, alias: FuelType, length: 50 )
• FuelCapacity ( type: esriFieldTypeDouble, alias: FuelCapacity )
• GeneralContractor ( type: esriFieldTypeString, alias: GeneralContractor, length: 50 )
• Dealer ( type: esriFieldTypeString, alias: Dealer, length: 50 )
• GeneratorName ( type: esriFieldTypeString, alias: Generator, length: 50 )
• Location ( type: esriFieldTypeString, alias: Location, length: 200 )
• Status ( type: esriFieldTypeString, alias: Status, length: 50 , Coded Values: [Planned: Planned] , [Active: Active] , [Abandoned: Abandoned] , ...3 more... )
• Asset_ID ( type: esriFieldTypeString, alias: Asset_ID, length: 20 )
• Parent_ID ( type: esriFieldTypeString, alias: Parent_ID, length: 255 )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• 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 )
• OldParentID ( type: esriFieldTypeString, alias: OldParentID, length: 50 )

Relationships:

• SanitaryLiftStations (7) -- Related To: SanitaryLiftStations (1)

Table: FargoLiftStation.DBO.ssLiftStationHVAC (4)

Name: FargoLiftStation.DBO.ssLiftStationHVAC

Display Field: HVAC_Name

Type: Table

Geometry Type: N/A

Description: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 1000

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
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:
• LiftStationNumber ( type: esriFieldTypeString, alias: LiftStationNumber, length: 100 )
• ConsequenceOfFailure ( type: esriFieldTypeDouble, alias: ConsequenceOfFailure )
• ProbabilityOfFailure ( type: esriFieldTypeDouble, alias: ProbabilityOfFailure )
• Mitigation ( type: esriFieldTypeDouble, alias: Mitigation )
• Risk ( type: esriFieldTypeDouble, alias: Risk )
• EstimatedLife ( type: esriFieldTypeSmallInteger, alias: EstimatedLife )
• InstallationDate ( type: esriFieldTypeDate, alias: InstallationDate, length: 8 )
• Material ( type: esriFieldTypeString, alias: Material, length: 100 )
• ReplacementCost ( type: esriFieldTypeDouble, alias: ReplacementCost )
• CostingDate ( type: esriFieldTypeDate, alias: CostingDate, length: 8 )
• Voltage ( type: esriFieldTypeDouble, alias: Voltage )
• Phase ( type: esriFieldTypeDouble, alias: Phase )
• Frequency ( type: esriFieldTypeDouble, alias: Frequency )
• BTU ( type: esriFieldTypeDouble, alias: BTU )
• Manufacture ( type: esriFieldTypeString, alias: Manufacture, length: 100 )
• Model ( type: esriFieldTypeString, alias: Model, length: 100 )
• SerialNumber ( type: esriFieldTypeString, alias: Serial Number, length: 100 )
• GeneralContractor ( type: esriFieldTypeString, alias: GeneralContractor, length: 50 )
• EngProjectNumber ( type: esriFieldTypeString, alias: Engineering Project Number, length: 50 )
• HVAC_Name ( type: esriFieldTypeString, alias: HVAC_Name, length: 50 )
• Location ( type: esriFieldTypeString, alias: Location, length: 200 )
• Status ( type: esriFieldTypeString, alias: Status, length: 50 , Coded Values: [Planned: Planned] , [Active: Active] , [Abandoned: Abandoned] , ...3 more... )
• Asset_ID ( type: esriFieldTypeString, alias: Asset_ID, length: 20 )
• Parent_ID ( type: esriFieldTypeString, alias: Parent_ID, length: 50 )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• 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 )
• OldParentID ( type: esriFieldTypeString, alias: OldParentID, length: 50 )

Relationships:

• SanitaryLiftStations (6) -- Related To: SanitaryLiftStations (1)

Table: FargoLiftStation.DBO.ssLiftStationMotor (5)

Name: FargoLiftStation.DBO.ssLiftStationMotor

Display Field: PumpName

Type: Table

Geometry Type: N/A

Description: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 1000

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
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:
• LiftStationNumber ( type: esriFieldTypeString, alias: LiftStationNumber, length: 50 )
• ConsequenceOfFailure ( type: esriFieldTypeDouble, alias: ConsequenceOfFailure )
• ProbabilityOfFailure ( type: esriFieldTypeDouble, alias: ProbabilityOfFailure )
• Mitigation ( type: esriFieldTypeDouble, alias: Mitigation )
• Risk ( type: esriFieldTypeDouble, alias: Risk )
• EstimatedLife ( type: esriFieldTypeSmallInteger, alias: EstimatedLife )
• InstallationDate ( type: esriFieldTypeDate, alias: InstallationDate, length: 8 )
• Material ( type: esriFieldTypeString, alias: Material, length: 100 )
• ReplacementCost ( type: esriFieldTypeDouble, alias: ReplacementCost )
• CostingDate ( type: esriFieldTypeDate, alias: CostingDate, length: 8 )
• PumpName ( type: esriFieldTypeString, alias: Name, length: 50 )
• MaximumCurrent ( type: esriFieldTypeDouble, alias: Maximum Current )
• Manufacture ( type: esriFieldTypeString, alias: Manufacture, length: 50 )
• Model ( type: esriFieldTypeString, alias: Model, length: 50 )
• SerialNumber ( type: esriFieldTypeString, alias: Serial Number, length: 50 )
• GeneralContractor ( type: esriFieldTypeString, alias: General Contractor, length: 50 )
• EngProjectNumber ( type: esriFieldTypeString, alias: Engineering Project Number, length: 50 )
• MotorName ( type: esriFieldTypeString, alias: MotorName, length: 50 )
• Speed_RPM ( type: esriFieldTypeDouble, alias: Speed (RPM) )
• Frequency ( type: esriFieldTypeDouble, alias: Frequency )
• Phase ( type: esriFieldTypeDouble, alias: Phase )
• Voltage ( type: esriFieldTypeDouble, alias: Voltage )
• Horsepower ( type: esriFieldTypeDouble, alias: Horsepower )
• Location ( type: esriFieldTypeString, alias: Location, length: 200 )
• Status ( type: esriFieldTypeString, alias: Status, length: 50 , Coded Values: [Planned: Planned] , [Active: Active] , [Abandoned: Abandoned] , ...3 more... )
• Asset_ID ( type: esriFieldTypeString, alias: Asset_ID, length: 20 )
• Parent_ID ( type: esriFieldTypeString, alias: Parent_ID, length: 50 )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• 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 )
• OldParentID ( type: esriFieldTypeString, alias: OldParentID, length: 50 )

Relationships:

• ssLiftStationPump (16) -- Related To: FargoLiftStation.DBO.ssLiftStationPump (9)

Table: FargoLiftStation.DBO.ssLiftStationOdorControlFilter (6)

Name: FargoLiftStation.DBO.ssLiftStationOdorControlFilter

Display Field: FilterName

Type: Table

Geometry Type: N/A

Description: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 1000

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
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:
• LiftStationNumber ( type: esriFieldTypeString, alias: LiftStationNumber, length: 50 )
• ConsequenceOfFailure ( type: esriFieldTypeDouble, alias: ConsequenceOfFailure )
• ProbabilityOfFailure ( type: esriFieldTypeDouble, alias: ProbabilityOfFailure )
• Mitigation ( type: esriFieldTypeDouble, alias: Mitigation )
• Risk ( type: esriFieldTypeDouble, alias: Risk )
• EstimatedLife ( type: esriFieldTypeSmallInteger, alias: EstimatedLife )
• InstallationDate ( type: esriFieldTypeDate, alias: InstallationDate, length: 8 )
• Type ( type: esriFieldTypeString, alias: Type, length: 100 , Coded Values: [Tank: Tank] , [Filter: Filter] , [Motor: Motor] )
• ReplacementCost ( type: esriFieldTypeDouble, alias: ReplacementCost )
• CostingDate ( type: esriFieldTypeDate, alias: CostingDate, length: 8 )
• Manufacture ( type: esriFieldTypeString, alias: Manufacture, length: 50 )
• Model ( type: esriFieldTypeString, alias: Model, length: 50 )
• SerialNumber ( type: esriFieldTypeString, alias: SerialNumber, length: 50 )
• GeneralContractor ( type: esriFieldTypeString, alias: GeneralContractor, length: 50 )
• EngProjectNumber ( type: esriFieldTypeString, alias: Engineering Project Number, length: 50 )
• FilterName ( type: esriFieldTypeString, alias: FilterName, length: 50 )
• Location ( type: esriFieldTypeString, alias: Location, length: 200 )
• Status ( type: esriFieldTypeString, alias: Status, length: 50 , Coded Values: [Planned: Planned] , [Active: Active] , [Abandoned: Abandoned] , ...3 more... )
• Asset_ID ( type: esriFieldTypeString, alias: Asset_ID, length: 20 )
• Parent_ID ( type: esriFieldTypeString, alias: Parent_ID, length: 50 )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• 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 )
• OldParentID ( type: esriFieldTypeString, alias: OldParentID, length: 50 )

Relationships:

• SanitaryLiftStations (1) -- Related To: SanitaryLiftStations (1)

Table: FargoLiftStation.DBO.ssLiftStationOdorControlPump (7)

Name: FargoLiftStation.DBO.ssLiftStationOdorControlPump

Display Field: PumpName

Type: Table

Geometry Type: N/A

Description: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 1000

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
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:
• LiftStationNumber ( type: esriFieldTypeString, alias: LiftStationNumber, length: 50 )
• ConsequenceOfFailure ( type: esriFieldTypeDouble, alias: ConsequenceOfFailure )
• ProbabilityOfFailure ( type: esriFieldTypeDouble, alias: ProbabilityOfFailure )
• Mitigation ( type: esriFieldTypeDouble, alias: Mitigation )
• Risk ( type: esriFieldTypeDouble, alias: Risk )
• EstimatedLife ( type: esriFieldTypeSmallInteger, alias: EstimatedLife )
• InstallationDate ( type: esriFieldTypeDate, alias: InstallationDate, length: 8 )
• Type ( type: esriFieldTypeString, alias: Type, length: 100 , Coded Values: [Tank: Tank] , [Filter: Filter] , [Motor: Motor] )
• ReplacementCost ( type: esriFieldTypeDouble, alias: ReplacementCost )
• CostingDate ( type: esriFieldTypeDate, alias: CostingDate, length: 8 )
• Contents ( type: esriFieldTypeString, alias: Contents, length: 50 )
• Capacity ( type: esriFieldTypeDouble, alias: Capacity )
• Manufacture ( type: esriFieldTypeString, alias: Manufacture, length: 50 )
• Model ( type: esriFieldTypeString, alias: Model, length: 50 )
• SerialNumber ( type: esriFieldTypeString, alias: SerialNumber, length: 50 )
• GeneralContractor ( type: esriFieldTypeString, alias: GeneralContractor, length: 50 )
• Horsepower ( type: esriFieldTypeDouble, alias: Horsepower )
• Voltage ( type: esriFieldTypeDouble, alias: Voltage )
• Phase ( type: esriFieldTypeDouble, alias: Phase )
• Frequency ( type: esriFieldTypeDouble, alias: Frequency )
• Speed ( type: esriFieldTypeDouble, alias: Speed (RPM) )
• EngProjectNumber ( type: esriFieldTypeString, alias: Engineering Project Number, length: 50 )
• PumpName ( type: esriFieldTypeString, alias: PumpName, length: 50 )
• Location ( type: esriFieldTypeString, alias: Location, length: 200 )
• Status ( type: esriFieldTypeString, alias: Status, length: 50 , Coded Values: [Planned: Planned] , [Active: Active] , [Abandoned: Abandoned] , ...3 more... )
• Asset_ID ( type: esriFieldTypeString, alias: Asset_ID, length: 20 )
• Parent_ID ( type: esriFieldTypeString, alias: Parent_ID, length: 50 )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• 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 )
• OldParentID ( type: esriFieldTypeString, alias: OldParentID, length: 50 )

Relationships:

• SanitaryLiftStations (8) -- Related To: SanitaryLiftStations (1)

Table: FargoLiftStation.DBO.ssLiftStationOdorControlTank (8)

Name: FargoLiftStation.DBO.ssLiftStationOdorControlTank

Display Field: TankName

Type: Table

Geometry Type: N/A

Description: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 1000

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
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:
• LiftStationNumber ( type: esriFieldTypeString, alias: LiftStationNumber, length: 50 )
• ConsequenceOfFailure ( type: esriFieldTypeDouble, alias: ConsequenceOfFailure )
• ProbabilityOfFailure ( type: esriFieldTypeDouble, alias: ProbabilityOfFailure )
• Mitigation ( type: esriFieldTypeDouble, alias: Mitigation )
• Risk ( type: esriFieldTypeDouble, alias: Risk )
• EstimatedLife ( type: esriFieldTypeSmallInteger, alias: EstimatedLife )
• InstallationDate ( type: esriFieldTypeDate, alias: InstallationDate, length: 8 )
• Type ( type: esriFieldTypeString, alias: Type, length: 100 , Coded Values: [Tank: Tank] , [Filter: Filter] , [Motor: Motor] )
• ReplacementCost ( type: esriFieldTypeDouble, alias: ReplacementCost )
• CostingDate ( type: esriFieldTypeDate, alias: CostingDate, length: 8 )
• Contents ( type: esriFieldTypeString, alias: Contents, length: 50 )
• Capacity ( type: esriFieldTypeDouble, alias: Capacity )
• GeneralContractor ( type: esriFieldTypeString, alias: GeneralContractor, length: 50 )
• EngProjectNumber ( type: esriFieldTypeString, alias: Engineering Project Number, length: 50 )
• TankName ( type: esriFieldTypeString, alias: TankName, length: 50 )
• Location ( type: esriFieldTypeString, alias: Location, length: 200 )
• Status ( type: esriFieldTypeString, alias: Status, length: 50 , Coded Values: [Planned: Planned] , [Active: Active] , [Abandoned: Abandoned] , ...3 more... )
• Asset_ID ( type: esriFieldTypeString, alias: Asset_ID, length: 20 )
• Parent_ID ( type: esriFieldTypeString, alias: Parent_ID, length: 50 )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• 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 )
• OldParentID ( type: esriFieldTypeString, alias: OldParentID, length: 50 )

Relationships:

• SanitaryLiftStations (10) -- Related To: SanitaryLiftStations (1)

Table: FargoLiftStation.DBO.ssLiftStationPump (9)

Name: FargoLiftStation.DBO.ssLiftStationPump

Display Field: PumpName

Type: Table

Geometry Type: N/A

Description: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 1000

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
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:
• LiftStationNumber ( type: esriFieldTypeString, alias: LiftStationNumber, length: 50 )
• ConsequenceOfFailure ( type: esriFieldTypeDouble, alias: ConsequenceOfFailure )
• ProbabilityOfFailure ( type: esriFieldTypeDouble, alias: ProbabilityOfFailure )
• Mitigation ( type: esriFieldTypeDouble, alias: Mitigation )
• Risk ( type: esriFieldTypeDouble, alias: Risk )
• EstimatedLife ( type: esriFieldTypeSmallInteger, alias: EstimatedLife )
• InstallationDate ( type: esriFieldTypeDate, alias: InstallationDate, length: 8 )
• Material ( type: esriFieldTypeString, alias: Material, length: 100 )
• ReplacementCost ( type: esriFieldTypeDouble, alias: ReplacementCost )
• CostingDate ( type: esriFieldTypeDate, alias: CostingDate, length: 8 )
• DischargeDiameter ( type: esriFieldTypeDouble, alias: DischargeDiameter )
• Horsepower ( type: esriFieldTypeDouble, alias: Horsepower )
• Voltage ( type: esriFieldTypeDouble, alias: Voltage )
• Phase ( type: esriFieldTypeDouble, alias: Phase )
• Frequency ( type: esriFieldTypeDouble, alias: Frequency )
• Speed ( type: esriFieldTypeDouble, alias: Speed )
• MaximumCurrent ( type: esriFieldTypeDouble, alias: MaximumCurrent )
• Manufacture ( type: esriFieldTypeString, alias: Manufacture, length: 50 )
• Model ( type: esriFieldTypeString, alias: Model, length: 50 )
• SerialNumber ( type: esriFieldTypeString, alias: SerialNumber, length: 50 )
• GeneralContractor ( type: esriFieldTypeString, alias: GeneralContractor, length: 50 )
• EngProjectNumber ( type: esriFieldTypeString, alias: EngProjectNumber, length: 50 )
• PumpName ( type: esriFieldTypeString, alias: PumpName, length: 50 )
• Capacity ( type: esriFieldTypeDouble, alias: Capacity )
• TotalDynamicHead ( type: esriFieldTypeDouble, alias: TotalDynamicHead )
• ImpellerType ( type: esriFieldTypeString, alias: ImpellerType, length: 50 )
• MinimumSpherePassage ( type: esriFieldTypeDouble, alias: MinimumSpherePassage )
• SuctionDiameter ( type: esriFieldTypeDouble, alias: SuctionDiameter )
• Location ( type: esriFieldTypeString, alias: Location, length: 200 )
• Status ( type: esriFieldTypeString, alias: Status, length: 50 , Coded Values: [Planned: Planned] , [Active: Active] , [Abandoned: Abandoned] , ...3 more... )
• Asset_ID ( type: esriFieldTypeString, alias: Asset_ID, length: 20 )
• Parent_ID ( type: esriFieldTypeString, alias: Parent_ID, length: 50 )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• 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 )
• OldParentID ( type: esriFieldTypeString, alias: OldParentID, length: 50 )

Relationships:

• ssLiftStationMotor (16) -- Related To: FargoLiftStation.DBO.ssLiftStationMotor (5)
• SanitaryLiftStations (0) -- Related To: SanitaryLiftStations (1)

Table: FargoLiftStation.DBO.ssLiftStationRTU (10)

Name: FargoLiftStation.DBO.ssLiftStationRTU

Display Field: RTU_Name

Type: Table

Geometry Type: N/A

Description: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 1000

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
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:
• LiftStationNumber ( type: esriFieldTypeString, alias: LiftStationNumber, length: 50 )
• ConsequenceOfFailure ( type: esriFieldTypeDouble, alias: ConsequenceOfFailure )
• ProbabilityOfFailure ( type: esriFieldTypeDouble, alias: ProbabilityOfFailure )
• Mitigation ( type: esriFieldTypeDouble, alias: Mitigation )
• Risk ( type: esriFieldTypeDouble, alias: Risk )
• EstimatedLife ( type: esriFieldTypeSmallInteger, alias: EstimatedLife )
• InstallationDate ( type: esriFieldTypeDate, alias: InstallationDate, length: 8 )
• Type ( type: esriFieldTypeString, alias: Material, length: 100 )
• ReplacementCost ( type: esriFieldTypeDouble, alias: ReplacementCost )
• CostingDate ( type: esriFieldTypeDate, alias: CostingDate, length: 8 )
• Manufacture ( type: esriFieldTypeString, alias: Manufacture, length: 50 )
• Model ( type: esriFieldTypeString, alias: Model, length: 50 )
• SerialNumber ( type: esriFieldTypeString, alias: Serial Number, length: 50 )
• USBManufacture ( type: esriFieldTypeString, alias: USB Manufacture (May be with Control Panel), length: 50 )
• USBInstallationDate ( type: esriFieldTypeDate, alias: USB Installation Date (May be with Control Panel), length: 8 )
• USBModel ( type: esriFieldTypeString, alias: USB Model Number (May be with Control Panel), length: 50 )
• USBSerialNumber ( type: esriFieldTypeString, alias: USB Serial Number (May be with Control Panel), length: 50 )
• MemoryBatteryInstallationDate ( type: esriFieldTypeDate, alias: Installation Date of Memory Battery (May be with Control Panel), length: 8 )
• GeneralContractor ( type: esriFieldTypeString, alias: General Contractor, length: 50 )
• EngProjectNumber ( type: esriFieldTypeString, alias: Engineering Project Number, length: 50 )
• USB_Battery ( type: esriFieldTypeString, alias: USB_Battery, length: 10 , Coded Values: [Yes: Yes] , [No: No] )
• MemoryBatteryModel ( type: esriFieldTypeString, alias: Memory Battery Model Number (May be with Control Panel), length: 10 )
• MemoryBatterySerialNumber ( type: esriFieldTypeString, alias: Memory Battery Serial Number (May be with Control Panel), length: 50 )
• MemoryBatteryManufacture ( type: esriFieldTypeString, alias: Memory Battery Manufacture (May be with Control Panel), length: 50 )
• RTU_Name ( type: esriFieldTypeString, alias: RTU_Name, length: 50 )
• Location ( type: esriFieldTypeString, alias: Location, length: 200 )
• Status ( type: esriFieldTypeString, alias: Status, length: 50 , Coded Values: [Planned: Planned] , [Active: Active] , [Abandoned: Abandoned] , ...3 more... )
• Asset_ID ( type: esriFieldTypeString, alias: Asset_ID, length: 20 )
• Parent_ID ( type: esriFieldTypeString, alias: Parent_ID, length: 50 )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• 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 )
• OldParentID ( type: esriFieldTypeString, alias: OldParentID, length: 50 )

Relationships:

• SanitaryLiftStations (4) -- Related To: SanitaryLiftStations (1)

Table: FargoLiftStation.DBO.ssLiftStationStructure (11)

Name: FargoLiftStation.DBO.ssLiftStationStructure

Display Field: StructureName

Type: Table

Geometry Type: N/A

Description: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 1000

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
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:
• LiftStationNumber ( type: esriFieldTypeString, alias: LiftStationNumber, length: 100 )
• ConsequenceOfFailure ( type: esriFieldTypeDouble, alias: ConsequenceOfFailure )
• ProbabilityOfFailure ( type: esriFieldTypeDouble, alias: ProbabilityOfFailure )
• Mitigation ( type: esriFieldTypeDouble, alias: Mitigation )
• Risk ( type: esriFieldTypeDouble, alias: Risk )
• EstimatedLife ( type: esriFieldTypeSmallInteger, alias: EstimatedLife )
• InstallationDate ( type: esriFieldTypeDate, alias: InstallationDate, length: 8 )
• Material ( type: esriFieldTypeString, alias: Material, length: 100 )
• ReplacementCost ( type: esriFieldTypeDouble, alias: ReplacementCost )
• CostingDate ( type: esriFieldTypeDate, alias: CostingDate, length: 8 )
• StructureType ( type: esriFieldTypeString, alias: Structure Type, length: 50 )
• GeneralContractor ( type: esriFieldTypeString, alias: GeneralContractor, length: 50 )
• EngProjectNumber ( type: esriFieldTypeString, alias: EngProjectNumber, length: 50 )
• StructureName ( type: esriFieldTypeString, alias: StructureName, length: 50 )
• Location ( type: esriFieldTypeString, alias: Location, length: 200 )
• Status ( type: esriFieldTypeString, alias: Status, length: 50 , Coded Values: [Planned: Planned] , [Active: Active] , [Abandoned: Abandoned] , ...3 more... )
• Asset_ID ( type: esriFieldTypeString, alias: Asset_ID, length: 20 )
• Parent_ID ( type: esriFieldTypeString, alias: Parent_ID, length: 50 )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• 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 )
• OldParentID ( type: esriFieldTypeString, alias: OldParentID, length: 50 )

Relationships:

• SanitaryLiftStations (11) -- Related To: SanitaryLiftStations (1)

Table: FargoLiftStation.DBO.ssLiftStationTransferSwitch (12)

Name: FargoLiftStation.DBO.ssLiftStationTransferSwitch

Display Field: SwitchName

Type: Table

Geometry Type: N/A

Description: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 1000

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
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:
• LiftStationNumber ( type: esriFieldTypeString, alias: Lift Station Number, length: 255 )
• ConsequenceOfFailure ( type: esriFieldTypeDouble, alias: ConsequenceOfFailure )
• ProbabilityOfFailure ( type: esriFieldTypeDouble, alias: ProbabilityOfFailure )
• Mitigation ( type: esriFieldTypeDouble, alias: Mitigation )
• Risk ( type: esriFieldTypeDouble, alias: Risk )
• EstimatedLife ( type: esriFieldTypeSmallInteger, alias: EstimatedLife )
• InstallationDate ( type: esriFieldTypeDate, alias: InstallationDate, length: 8 )
• Material ( type: esriFieldTypeString, alias: Material, length: 100 )
• ReplacementCost ( type: esriFieldTypeDouble, alias: ReplacementCost )
• CostingDate ( type: esriFieldTypeDate, alias: CostingDate, length: 8 )
• ServicePointofContact ( type: esriFieldTypeString, alias: Service Point of Contact, length: 50 )
• Manufacture ( type: esriFieldTypeString, alias: Manufacturer, length: 100 )
• Model ( type: esriFieldTypeString, alias: Model, length: 50 )
• SerialNumber ( type: esriFieldTypeString, alias: Serial Number, length: 50 )
• Voltage ( type: esriFieldTypeSmallInteger, alias: Voltage )
• AmpRating ( type: esriFieldTypeSmallInteger, alias: Amp Rating )
• TransistionType ( type: esriFieldTypeString, alias: Transition Type (Open or Closed), length: 50 )
• EngProjectNumber ( type: esriFieldTypeString, alias: Engineering Project Number, length: 50 )
• GeneralContractor ( type: esriFieldTypeString, alias: General Contractor, length: 50 )
• ManufacturingDate ( type: esriFieldTypeDate, alias: Manufacturing Date, length: 8 )
• SwitchName ( type: esriFieldTypeString, alias: SwitchName, length: 50 )
• Location ( type: esriFieldTypeString, alias: Location, length: 200 )
• Status ( type: esriFieldTypeString, alias: Status, length: 50 , Coded Values: [Planned: Planned] , [Active: Active] , [Abandoned: Abandoned] , ...3 more... )
• Asset_ID ( type: esriFieldTypeString, alias: Asset_ID, length: 20 )
• Parent_ID ( type: esriFieldTypeString, alias: Parent_ID, length: 255 )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• 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 )
• OldParentID ( type: esriFieldTypeString, alias: OldParentID, length: 50 )

Relationships:

• SanitaryLiftStations (14) -- Related To: SanitaryLiftStations (1)

Table: FargoLiftStation.DBO.ssLiftStationValves (13)

Name: FargoLiftStation.DBO.ssLiftStationValves

Display Field: ValveName

Type: Table

Geometry Type: N/A

Description: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 1000

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
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:
• LiftStationNumber ( type: esriFieldTypeString, alias: LiftStationNumber, length: 50 )
• ConsequenceOfFailure ( type: esriFieldTypeDouble, alias: ConsequenceOfFailure )
• ProbabilityOfFailure ( type: esriFieldTypeDouble, alias: ProbabilityOfFailure )
• Mitigation ( type: esriFieldTypeDouble, alias: Mitigation )
• Risk ( type: esriFieldTypeDouble, alias: Risk )
• EstimatedLife ( type: esriFieldTypeSmallInteger, alias: EstimatedLife )
• InstallationDate ( type: esriFieldTypeDate, alias: InstallationDate, length: 8 )
• Material ( type: esriFieldTypeString, alias: Material, length: 100 )
• ReplacementCost ( type: esriFieldTypeDouble, alias: ReplacementCost )
• CostingDate ( type: esriFieldTypeDate, alias: CostingDate, length: 8 )
• Speed ( type: esriFieldTypeDouble, alias: Speed )
• MaximumCurrent ( type: esriFieldTypeDouble, alias: MaximumCurrent )
• Model ( type: esriFieldTypeString, alias: Model, length: 50 )
• SerialNumber ( type: esriFieldTypeString, alias: SerialNumber, length: 50 )
• GeneralContractor ( type: esriFieldTypeString, alias: GeneralContractor, length: 50 )
• EngProjectNumber ( type: esriFieldTypeString, alias: EngProjectNumber, length: 50 )
• ValveName ( type: esriFieldTypeString, alias: ValveName, length: 50 )
• Type ( type: esriFieldTypeString, alias: Type, length: 50 , Coded Values: [Check: Check] , [AirRelief: AirRelief] , [Inlet: Inlet] , ...2 more... )
• Location ( type: esriFieldTypeString, alias: Location, length: 200 )
• Status ( type: esriFieldTypeString, alias: Status, length: 50 , Coded Values: [Planned: Planned] , [Active: Active] , [Abandoned: Abandoned] , ...3 more... )
• Asset_ID ( type: esriFieldTypeString, alias: Asset_ID, length: 20 )
• Parent_ID ( type: esriFieldTypeString, alias: Parent_ID, length: 50 )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• Manufacturer ( type: esriFieldTypeString, alias: Manufacturer, length: 50 )
• Size ( type: esriFieldTypeDouble, alias: Size )
• 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 )
• OldParentID ( type: esriFieldTypeString, alias: OldParentID, length: 50 )

Relationships:

• SanitaryLiftStations (9) -- Related To: SanitaryLiftStations (1)

Table: FargoLiftStation.DBO.ssLiftStationWetDryWell (14)

Name: FargoLiftStation.DBO.ssLiftStationWetDryWell

Display Field: WetDryWellName

Type: Table

Geometry Type: N/A

Description: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 1000

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
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:
• LiftStationNumber ( type: esriFieldTypeString, alias: LiftStationNumber, length: 50 )
• ConsequenceOfFailure ( type: esriFieldTypeDouble, alias: ConsequenceOfFailure )
• ProbabilityOfFailure ( type: esriFieldTypeDouble, alias: ProbabilityOfFailure )
• Mitigation ( type: esriFieldTypeDouble, alias: Mitigation )
• Risk ( type: esriFieldTypeDouble, alias: Risk )
• EstimatedLife ( type: esriFieldTypeSmallInteger, alias: EstimatedLife )
• InstallationDate ( type: esriFieldTypeDate, alias: InstallationDate, length: 8 )
• Material ( type: esriFieldTypeString, alias: Material, length: 100 )
• ReplacementCost ( type: esriFieldTypeDouble, alias: ReplacementCost )
• CostingDate ( type: esriFieldTypeDate, alias: CostingDate, length: 8 )
• Diameter ( type: esriFieldTypeDouble, alias: Diameter )
• Depth ( type: esriFieldTypeDouble, alias: Depth )
• Type ( type: esriFieldTypeString, alias: Type of Wet Well, length: 50 )
• GeneralContractor ( type: esriFieldTypeString, alias: General Contractor, length: 50 )
• EngProjectNumber ( type: esriFieldTypeString, alias: Engineering Project Number, length: 50 )
• WetDryWellName ( type: esriFieldTypeString, alias: WetDryWell, length: 50 )
• Location ( type: esriFieldTypeString, alias: Location, length: 200 )
• Status ( type: esriFieldTypeString, alias: Status, length: 50 , Coded Values: [Planned: Planned] , [Active: Active] , [Abandoned: Abandoned] , ...3 more... )
• Asset_ID ( type: esriFieldTypeString, alias: Asset_ID, length: 20 )
• Parent_ID ( type: esriFieldTypeString, alias: ParentID, length: 50 )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• 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 )
• OldParentID ( type: esriFieldTypeString, alias: OldParentID, length: 50 )

Relationships:

• SanitaryLiftStations (12) -- Related To: SanitaryLiftStations (1)

Table: Cityworks_sde.DBO.ssLiftStationUnitHeater (15)

Name: Cityworks_sde.DBO.ssLiftStationUnitHeater

Display Field: HeaterName

Type: Table

Geometry Type: N/A

Description: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 1000

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
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:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• LiftStationNumber ( type: esriFieldTypeString, alias: LiftStationNumber, length: 16 )
• Voltage ( type: esriFieldTypeDouble, alias: Voltage )
• kW_kVARating ( type: esriFieldTypeString, alias: kW_kVARating, length: 50 )
• Phase ( type: esriFieldTypeString, alias: Phase, length: 100 )
• Dealer ( type: esriFieldTypeString, alias: Dealer, length: 50 )
• HeaterName ( type: esriFieldTypeString, alias: HeaterName, length: 50 )
• HeaterLocation ( type: esriFieldTypeString, alias: HeaterLocation, length: 50 , Coded Values: [Main Floor: Main Floor] , [Basement: Basement] , [Scrubber Room: Scrubber Room] , ...3 more... )
• Manufacturer ( type: esriFieldTypeString, alias: Manufacturer, length: 50 )
• Model ( type: esriFieldTypeString, alias: Model, length: 50 )
• SerialNumber ( type: esriFieldTypeString, alias: SerialNumber, length: 50 )
• Warranty ( type: esriFieldTypeString, alias: Warranty, length: 255 )
• LifeExpectancy ( type: esriFieldTypeString, alias: LifeExpectancy, length: 255 )
• EngProjectNumber ( type: esriFieldTypeString, alias: EngProjectNumber, length: 50 )
• GeneralContractor ( type: esriFieldTypeString, alias: GeneralContractor, length: 50 )
• Location ( type: esriFieldTypeString, alias: Location, length: 50 )
• Comments ( type: esriFieldTypeString, alias: Comments, length: 255 )
• Status ( type: esriFieldTypeString, alias: Status, length: 50 , Coded Values: [Planned: Planned] , [Active: Active] , [Abandoned: Abandoned] , ...3 more... )
• ConsequenceOfFailure ( type: esriFieldTypeDouble, alias: ConsequenceOfFailure )
• ProbabilityOfFailure ( type: esriFieldTypeDouble, alias: ProbabilityOfFailure )
• Mitigation ( type: esriFieldTypeDouble, alias: Mitigation )
• Risk ( type: esriFieldTypeDouble, alias: Risk )
• EstimatedLife ( type: esriFieldTypeSmallInteger, alias: EstimatedLife )
• InstallationDate ( type: esriFieldTypeDate, alias: InstallationDate, length: 8 )
• Material ( type: esriFieldTypeString, alias: Material, length: 50 )
• ReplacementCost ( type: esriFieldTypeDouble, alias: ReplacementCost )
• CostingDate ( type: esriFieldTypeDate, alias: CostingDate, length: 8 )
• Asset_ID ( type: esriFieldTypeString, alias: Asset_ID, length: 20 )
• Parent_ID ( type: esriFieldTypeString, alias: Parent_ID, length: 50 )
• 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: esriFieldTypeGUID, alias: GlobalID, length: 38 )
• OldParentID ( type: esriFieldTypeString, alias: OldParentID, length: 50 )

Relationships:

• SanitaryLiftStations (13) -- Related To: SanitaryLiftStations (1)

Table: Cityworks_sde.DBO.ssLiftStationGenReceptacle (16)

Name: Cityworks_sde.DBO.ssLiftStationGenReceptacle

Display Field: DockName

Type: Table

Geometry Type: N/A

Description: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 1000

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
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:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• ConsequenceOfFailure ( type: esriFieldTypeDouble, alias: ConsequenceOfFailure )
• ProbabilityOfFailure ( type: esriFieldTypeDouble, alias: ProbabilityOfFailure )
• Mitigation ( type: esriFieldTypeDouble, alias: Mitigation )
• Risk ( type: esriFieldTypeDouble, alias: Risk )
• EstimatedLife ( type: esriFieldTypeSmallInteger, alias: EstimatedLife )
• InstallationDate ( type: esriFieldTypeDate, alias: InstallationDate, length: 8 )
• Material ( type: esriFieldTypeString, alias: Material, length: 100 )
• ReplacementCost ( type: esriFieldTypeDouble, alias: ReplacementCost )
• CostingDate ( type: esriFieldTypeDate, alias: CostingDate, length: 8 )
• Asset_ID ( type: esriFieldTypeString, alias: Asset_ID, length: 20 )
• Status ( type: esriFieldTypeString, alias: Status, length: 50 , Coded Values: [Planned: Planned] , [Active: Active] , [Abandoned: Abandoned] , ...3 more... )
• Voltage ( type: esriFieldTypeSmallInteger, alias: Voltage )
• Manufacture ( type: esriFieldTypeString, alias: Manufacture, length: 100 )
• Model ( type: esriFieldTypeString, alias: Model, length: 50 )
• SerialNumber ( type: esriFieldTypeString, alias: Serial Number, length: 50 )
• EngProjectNumber ( type: esriFieldTypeString, alias: Engineering Project Number, length: 50 )
• GeneralContractor ( type: esriFieldTypeString, alias: General Contractor, length: 50 )
• Parent_ID ( type: esriFieldTypeString, alias: Parent_ID, length: 255 )
• LiftStationNumber ( type: esriFieldTypeString, alias: LiftStationNumber, length: 255 )
• Location ( type: esriFieldTypeString, alias: Location, length: 200 )
• ManufacturingDate ( type: esriFieldTypeDate, alias: Manufacturing Date, length: 8 )
• AmpRating ( type: esriFieldTypeSmallInteger, alias: Amp Rating )
• DockName ( type: esriFieldTypeString, alias: DockName, length: 50 )
• 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 )
• OldParentID ( type: esriFieldTypeString, alias: OldParentID, length: 50 )

Relationships:

• SanitaryLiftStations (2) -- Related To: SanitaryLiftStations (1)

Table: Cityworks_sde.DBO.ssLiftStationFlowMeter (17)

Name: Cityworks_sde.DBO.ssLiftStationFlowMeter

Display Field: Manufacturer

Type: Table

Geometry Type: N/A

Description: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 1000

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
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:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• Manufacturer ( type: esriFieldTypeString, alias: Manufacturer, length: 50 )
• Model ( type: esriFieldTypeString, alias: Model, length: 50 )
• CALNumber ( type: esriFieldTypeString, alias: CALNumber, length: 50 )
• SerialNumber ( type: esriFieldTypeString, alias: SerialNumber, length: 50 )
• TraceNumber ( type: esriFieldTypeString, alias: TraceNumber, length: 50 )
• VoltageInput ( type: esriFieldTypeString, alias: VoltageInput, length: 50 )
• VoltageOutput ( type: esriFieldTypeString, alias: VoltageOutput, length: 50 )
• CurrentInput ( type: esriFieldTypeString, alias: CurrentInput, length: 50 )
• CurrentOutput ( type: esriFieldTypeString, alias: CurrentOutput, length: 50 )
• PowerInput ( type: esriFieldTypeString, alias: PowerInput, length: 50 )
• PowerOutput ( type: esriFieldTypeString, alias: PowerOutput, length: 50 )
• Type ( type: esriFieldTypeString, alias: Type, length: 100 )
• Lighted ( type: esriFieldTypeSmallInteger, alias: Lighted , Coded Values: [1: Yes] , [0: No] )
• Location ( type: esriFieldTypeString, alias: Location, length: 200 )
• Comments ( type: esriFieldTypeString, alias: Comments, length: 255 )
• Status ( type: esriFieldTypeString, alias: Status, length: 50 , Coded Values: [Planned: Planned] , [Active: Active] , [Abandoned: Abandoned] , ...3 more... )
• ConsequenceOfFailure ( type: esriFieldTypeDouble, alias: ConsequenceOfFailure )
• ProbabilityOfFailure ( type: esriFieldTypeDouble, alias: ProbabilityOfFailure )
• Mitigation ( type: esriFieldTypeDouble, alias: Mitigation )
• Risk ( type: esriFieldTypeDouble, alias: Risk )
• EstimatedLife ( type: esriFieldTypeSmallInteger, alias: EstimatedLife )
• InstallationDate ( type: esriFieldTypeDate, alias: InstallationDate, length: 8 )
• ReplacementCost ( type: esriFieldTypeDouble, alias: ReplacementCost )
• CostingDate ( type: esriFieldTypeDate, alias: CostingDate, length: 8 )
• Asset_ID ( type: esriFieldTypeString, alias: Asset_ID, length: 20 )
• Parent_ID ( type: esriFieldTypeString, alias: Parent_ID, length: 50 )
• 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: esriFieldTypeGUID, alias: GlobalID, length: 38 )
• OldParentID ( type: esriFieldTypeString, alias: OldParentID, length: 50 )
• LiftStationNumber ( type: esriFieldTypeString, alias: LiftStationNumber, length: 50 )

Relationships:

• SanitaryLiftStations (3) -- Related To: SanitaryLiftStations (1)

Table: Cityworks_sde.DBO.ssLiftStationOverheadHoist (18)

Name: Cityworks_sde.DBO.ssLiftStationOverheadHoist

Display Field: Name

Type: Table

Geometry Type: N/A

Description: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 1000

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
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:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• Name ( type: esriFieldTypeString, alias: Name, length: 255 )
• Manufacturer ( type: esriFieldTypeString, alias: Manufacturer, length: 50 )
• ProductDescription ( type: esriFieldTypeString, alias: ProductDescription, length: 255 )
• Model ( type: esriFieldTypeString, alias: Model, length: 50 )
• HoistSerialNumber ( type: esriFieldTypeString, alias: SerialNumber, length: 50 )
• HoistHeightOfLift ( type: esriFieldTypeString, alias: HoistHeightOfLift, length: 50 )
• HoistLoad ( type: esriFieldTypeString, alias: HoistLoad, length: 50 )
• HoistDutyClass ( type: esriFieldTypeString, alias: HoistDutyClass, length: 50 )
• HoistLoadChainType ( type: esriFieldTypeString, alias: HoistLoadChainType, length: 50 )
• HoistReevingSystem ( type: esriFieldTypeString, alias: HoistReevingSystem, length: 50 )
• HoistChainLength ( type: esriFieldTypeString, alias: HoistChainLength, length: 50 )
• HoistChainSize ( type: esriFieldTypeString, alias: HoistChainSize, length: 50 )
• HoistChainClass ( type: esriFieldTypeString, alias: HoistChainClass, length: 50 )
• HoistChainGrade ( type: esriFieldTypeString, alias: HoistChainGrade, length: 50 )
• HoistChainMaxWorkLoad ( type: esriFieldTypeString, alias: HoistChainMaxWorkLoad, length: 50 )
• HoistChainBreakLoad ( type: esriFieldTypeString, alias: HoistChainBreakLoad, length: 50 )
• HoistChainTotalBreakingElongati ( type: esriFieldTypeString, alias: HoistChainTotalBreakingElongation, length: 50 )
• HoistingMachineryEDMax ( type: esriFieldTypeString, alias: HoistingMachineryEDMax, length: 50 )
• HoistingMachineryPower ( type: esriFieldTypeString, alias: HoistingMachineryPower, length: 50 )
• HoistingMachineryHoistingSpeed ( type: esriFieldTypeString, alias: HoistingMachineryHoistingSpeed, length: 50 )
• ControlsMainVoltage ( type: esriFieldTypeString, alias: ContolsMainVoltage, length: 50 )
• ControlsVoltage ( type: esriFieldTypeString, alias: ControlsVoltage, length: 50 )
• ControlsPhases ( type: esriFieldTypeString, alias: ControlsPhases, length: 50 )
• ControlsFrequency ( type: esriFieldTypeString, alias: ControlsFrequency, length: 50 )
• ControlsPendantType ( type: esriFieldTypeString, alias: ControlsPendantType, length: 50 )
• ControlsType ( type: esriFieldTypeString, alias: ControlsControlType, length: 50 )
• TrolleyType ( type: esriFieldTypeString, alias: TrolleyType, length: 50 )
• Warranty ( type: esriFieldTypeString, alias: Warranty, length: 255 )
• LifeExpectancy ( type: esriFieldTypeString, alias: LifeExpectancy, length: 255 )
• ParentType ( type: esriFieldTypeString, alias: ParentType, length: 50 )
• EngProjectNumber ( type: esriFieldTypeString, alias: EngProjectNumber, length: 50 )
• GeneralContractor ( type: esriFieldTypeString, alias: GeneralContractor, length: 50 )
• Comments ( type: esriFieldTypeString, alias: Comments, length: 255 )
• Status ( type: esriFieldTypeString, alias: Status, length: 50 , Coded Values: [Planned: Planned] , [Active: Active] , [Abandoned: Abandoned] , ...3 more... )
• Location ( type: esriFieldTypeString, alias: Location, length: 200 )
• ConsequenceOfFailure ( type: esriFieldTypeDouble, alias: ConsequenceOfFailure )
• ProbabilityOfFailure ( type: esriFieldTypeDouble, alias: ProbabilityOfFailure )
• Mitigation ( type: esriFieldTypeDouble, alias: Mitigation )
• Risk ( type: esriFieldTypeDouble, alias: Risk )
• EstimatedLife ( type: esriFieldTypeSmallInteger, alias: EstimatedLife )
• InstallationDate ( type: esriFieldTypeDate, alias: InstallationDate, length: 8 )
• ReplacementCost ( type: esriFieldTypeDouble, alias: ReplacementCost )
• CostingDate ( type: esriFieldTypeDate, alias: CostingDate, length: 8 )
• Asset_ID ( type: esriFieldTypeString, alias: Asset_ID, length: 20 )
• Parent_ID ( type: esriFieldTypeString, alias: Parent_ID, length: 50 )
• 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: esriFieldTypeGUID, alias: GlobalID, length: 38 )
• OldParentID ( type: esriFieldTypeString, alias: OldParentID, length: 50 )

Relationships:

• SanitaryLiftStations (15) -- Related To: SanitaryLiftStations (1)