Layers:

Layer: StormLiftStations (1)

Name: StormLiftStations

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.0787654443638813E7
YMin: 5889578.616458794
XMax: -1.0771357275676178E7
YMax: 5935813.691121449
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: 25 )
• Comments ( type: esriFieldTypeString, alias: Comments, length: 255 )
• OriginalProjectNumber ( type: esriFieldTypeString, alias: OriginalProjectNumber, length: 50 )
• YearInstalled ( type: esriFieldTypeString, alias: YearInstalled, length: 8 )
• YearImproved ( type: esriFieldTypeString, alias: YearImproved, length: 25 )
• ImprovementProjectNumber ( type: esriFieldTypeString, alias: ImprovementProjectNumber, length: 25 )
• 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: 25 )
• InsuranceNumbers ( type: esriFieldTypeString, alias: InsuranceNumbers, length: 25 )
• InsuranceLimit ( type: esriFieldTypeString, alias: InsuranceLimit, length: 25 )
• ConsequenceOfFailure ( type: esriFieldTypeDouble, alias: ConsequenceOfFailure ConsequenceOfFailure ConsequenceOfFailure 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_Type, length: 100 )
• ReplacementCost ( type: esriFieldTypeDouble, alias: ReplacementCost )
• CostingDate ( type: esriFieldTypeDate, alias: CostingDate, length: 8 )
• Location ( type: esriFieldTypeString, alias: Location, length: 100 )
• Status ( type: esriFieldTypeString, alias: Status, length: 25 , Coded Values: [Planned: Planned] , [Active: Active] , [Abandoned: Abandoned] , ...3 more... )
• Asset_ID ( type: esriFieldTypeString, alias: Asset_ID, length: 20 )
• LiftStationArea ( type: esriFieldTypeString, alias: LiftStationArea, length: 25 )
• 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 )
• HasSCADA ( type: esriFieldTypeSmallInteger, alias: HasSCADA , Coded Values: [1: Yes] , [0: No] )
• X ( type: esriFieldTypeDouble, alias: X )
• Y ( type: esriFieldTypeDouble, alias: Y )
• Private ( type: esriFieldTypeString, alias: Private, length: 50 , Coded Values: [Yes: Yes] , [No: No] )

Relationships:

• stLiftStationGenerator (0) -- Related To: FargoLiftStation.DBO.stLiftStationGenerator (4)
• stLiftStationPump (1) -- Related To: FargoLiftStation.DBO.stLiftStationPump (7)
• stLiftStationTransferSwitch (2) -- Related To: FargoLiftStation.DBO.stLiftStationTransferSwitch (11)
• stLiftStationRTU (3) -- Related To: FargoLiftStation.DBO.stLiftStationRTU (9)
• stLiftStationWetDryWell (4) -- Related To: FargoLiftStation.DBO.stLiftStationWetDryWell (12)
• stLiftStationControlPanel (5) -- Related To: FargoLiftStation.DBO.stLiftStationControlPanel (2)
• stLiftStationHVAC (6) -- Related To: FargoLiftStation.DBO.stLiftStationHVAC (5)
• stLiftStationGenReceptacle (7) -- Related To: Cityworks_sde.DBO.stLiftStationGenReceptacle (13)
• stLiftStationRiverGate (8) -- Related To: FargoLiftStation.DBO.stLiftStationRiverGate (8)
• stLiftStationStructure (9) -- Related To: FargoLiftStation.DBO.stLiftStationStructure (10)

Tables:

Table: FargoLiftStation.DBO.stLiftStationControlPanel (2)

Name: FargoLiftStation.DBO.stLiftStationControlPanel

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:
• 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 )
• 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 )
• 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 )
• LiftStationNumber ( type: esriFieldTypeString, alias: Lift Station Number, length: 50 )
• 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 )
• MainBreakerSize ( type: esriFieldTypeDouble, alias: Main Breaker Size )
• PumpBreakerManufacture ( type: esriFieldTypeString, alias: Pump Breaker Manufacture, length: 50 )
• PumpBreakerSize ( type: esriFieldTypeDouble, alias: PumpBreakerSize )
• GeneratorBreakerManufacture ( type: esriFieldTypeString, alias: Generator Breaker Manufacture, length: 50 )
• GeneratorBreakerSize ( type: esriFieldTypeDouble, alias: Generator Breaker Size )
• ControlPanelName ( type: esriFieldTypeString, alias: ControlPanelName, 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:

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

Table: FargoLiftStation.DBO.stLiftStationGate (3)

Name: FargoLiftStation.DBO.stLiftStationGate

Display Field: GateName

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 )
• Size_ ( type: esriFieldTypeDouble, alias: Size )
• Manufacture ( type: esriFieldTypeString, alias: Manufacture, length: 50 )
• Model ( type: esriFieldTypeString, alias: Model, length: 50 )
• EngProjectNumber ( type: esriFieldTypeString, alias: Engineering Project Number, length: 50 )
• SerialNumber ( type: esriFieldTypeString, alias: Serial Number, length: 50 )
• GeneralContractor ( type: esriFieldTypeString, alias: General Contractor, length: 50 )
• GateName ( type: esriFieldTypeString, alias: Gate, 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 )
• GateType ( type: esriFieldTypeString, alias: GateType, length: 50 , Coded Values: [Flap: Flap] , [Sluice: Sluice] )

Relationships:

• stLiftStationPump (10) -- Related To: FargoLiftStation.DBO.stLiftStationPump (7)

Table: FargoLiftStation.DBO.stLiftStationGenerator (4)

Name: FargoLiftStation.DBO.stLiftStationGenerator

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: kWkVARating )
• Voltage ( type: esriFieldTypeDouble, alias: Voltage )
• Phase ( type: esriFieldTypeDouble, alias: Phase )
• Manufacture ( type: esriFieldTypeString, alias: Manufacture, 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: GeneratorName, 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:

• StormLiftStations (0) -- Related To: StormLiftStations (1)

Table: FargoLiftStation.DBO.stLiftStationHVAC (5)

Name: FargoLiftStation.DBO.stLiftStationHVAC

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: General Contractor, 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:

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

Table: FargoLiftStation.DBO.stLiftStationMotor (6)

Name: FargoLiftStation.DBO.stLiftStationMotor

Display Field: MotorName

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: Installation Date, length: 8 )
• Material ( type: esriFieldTypeString, alias: Material, length: 100 )
• ReplacementCost ( type: esriFieldTypeDouble, alias: ReplacementCost )
• CostingDate ( type: esriFieldTypeDate, alias: CostingDate, length: 8 )
• 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:

• stLiftStationPump (11) -- Related To: FargoLiftStation.DBO.stLiftStationPump (7)

Table: FargoLiftStation.DBO.stLiftStationPump (7)

Name: FargoLiftStation.DBO.stLiftStationPump

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: Discharge Diameter )
• Horsepower ( type: esriFieldTypeDouble, alias: Horsepower (May be on Motor if separate Asset) )
• Voltage ( type: esriFieldTypeDouble, alias: Voltage (May be on Motor if separate Asset) )
• Phase ( type: esriFieldTypeDouble, alias: Phase (May be on Motor if separate Asset) )
• Frequency ( type: esriFieldTypeDouble, alias: Frequency (May be on Motor if separate Asset) )
• Speed ( type: esriFieldTypeDouble, alias: Speed (May be on Motor if separate Asset) )
• MaximumCurrent ( type: esriFieldTypeDouble, alias: Maximum Current (May be on Motor if separate Asset) )
• 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: General Contractor, length: 50 )
• EngProjectNumber ( type: esriFieldTypeString, alias: Engineering Project Number, length: 50 )
• PumpName ( type: esriFieldTypeString, alias: PumpName, length: 50 )
• Capacity ( type: esriFieldTypeDouble, alias: Capacity )
• TotalDynamicHead ( type: esriFieldTypeDouble, alias: Total Dynamic Head )
• ImpellerType ( type: esriFieldTypeString, alias: Impeller Type, length: 50 )
• MinimumSpherePassage ( type: esriFieldTypeDouble, alias: Minimum Sphere Passage )
• SuctionDiameter ( type: esriFieldTypeDouble, alias: Suction Diameter )
• 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:

• stLiftStationGate (10) -- Related To: FargoLiftStation.DBO.stLiftStationGate (3)
• stLiftStationMotor (11) -- Related To: FargoLiftStation.DBO.stLiftStationMotor (6)
• StormLiftStations (1) -- Related To: StormLiftStations (1)

Table: FargoLiftStation.DBO.stLiftStationRiverGate (8)

Name: FargoLiftStation.DBO.stLiftStationRiverGate

Display Field: RiverGateName

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 )
• Size_ ( type: esriFieldTypeDouble, alias: Size )
• Manufacture ( type: esriFieldTypeString, alias: Manufacture, length: 50 )
• Model ( type: esriFieldTypeString, alias: Model, length: 50 )
• RiverGateName ( type: esriFieldTypeString, alias: RiverGateName, length: 50 )
• EngProjectNumber ( type: esriFieldTypeString, alias: Engineering Project Number, length: 50 )
• SerialNumber ( type: esriFieldTypeString, alias: Serial Number, length: 50 )
• GeneralContractor ( type: esriFieldTypeString, alias: General Contractor, 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 )
• GateType ( type: esriFieldTypeString, alias: GateType, length: 50 , Coded Values: [Flap: Flap] , [Sluice: Sluice] )

Relationships:

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

Table: FargoLiftStation.DBO.stLiftStationRTU (9)

Name: FargoLiftStation.DBO.stLiftStationRTU

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: Memory Battery Manufacture (May be with Control Panel), length: 8 )
• GeneralContractor ( type: esriFieldTypeString, alias: General Contractor, length: 50 )
• EngProjectNumber ( type: esriFieldTypeString, alias: Engineering Project Number, length: 50 )
• Battery ( type: esriFieldTypeString, alias: Battery, length: 10 )
• MemoryBatteryModel ( type: esriFieldTypeString, alias: Memory Battery Model Number (May be with Control Panel), length: 50 )
• MemoryBatterySerialNumber ( type: esriFieldTypeString, alias: Memory Battery Serial Number (May be with Control Panel), length: 50 )
• RTU_Name ( type: esriFieldTypeString, alias: RTU_Name, length: 50 )
• MemoryBatteryManufacture ( type: esriFieldTypeString, alias: Memory Battery Manufacture (May be with Control Panel), 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:

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

Table: FargoLiftStation.DBO.stLiftStationStructure (10)

Name: FargoLiftStation.DBO.stLiftStationStructure

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: General Contractor, length: 50 )
• EngProjectNumber ( type: esriFieldTypeString, alias: Engineering Project Number, length: 50 )
• StructureName ( type: esriFieldTypeString, alias: Structure, 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:

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

Table: FargoLiftStation.DBO.stLiftStationTransferSwitch (11)

Name: FargoLiftStation.DBO.stLiftStationTransferSwitch

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 )
• Voltage ( type: esriFieldTypeSmallInteger, alias: Voltage )
• Manufacture ( type: esriFieldTypeString, alias: Manufacturer, 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 )
• TransistionType ( type: esriFieldTypeString, alias: Transition Type (Open or Closed), length: 50 )
• GeneralContractor ( type: esriFieldTypeString, alias: General Contractor, length: 50 )
• ManufacturingDate ( type: esriFieldTypeDate, alias: Manufacturing Date, length: 8 )
• AmpRating ( type: esriFieldTypeSmallInteger, alias: Amp Rating )
• ServicePointofContact ( type: esriFieldTypeString, alias: Service Point of Contact, length: 50 )
• SwitchName ( type: esriFieldTypeString, alias: SwitchName, length: 50 )
• Location ( type: esriFieldTypeString, alias: Location, length: 200 )
• Asset_ID ( type: esriFieldTypeString, alias: Asset_ID, length: 20 )
• Parent_ID ( type: esriFieldTypeString, alias: Parent_ID, length: 255 )
• Status ( type: esriFieldTypeString, alias: Status, length: 50 , Coded Values: [Planned: Planned] , [Active: Active] , [Abandoned: Abandoned] , ...3 more... )
• 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:

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

Table: FargoLiftStation.DBO.stLiftStationWetDryWell (12)

Name: FargoLiftStation.DBO.stLiftStationWetDryWell

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: WetDryWellName, length: 50 )
• WellName ( type: esriFieldTypeString, alias: WellName, 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:

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

Table: Cityworks_sde.DBO.stLiftStationGenReceptacle (13)

Name: Cityworks_sde.DBO.stLiftStationGenReceptacle

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:

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