Name: stp_DistributionEquipment

Display Field: SITE_NAME

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: 551ed99598bc4645bc48894460c82fc3

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON

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

HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• FACILITYID ( type: esriFieldTypeString, alias: Facility ID, length: 50 )
• LEGACY_ID ( type: esriFieldTypeString, alias: Legacy ID, length: 50 )
• CITY_ASSET_ID ( type: esriFieldTypeString, alias: City Asset ID, length: 50 )
• LOCATION ( type: esriFieldTypeString, alias: Location Description, length: 255 )
• PROJECT_NUMBER ( type: esriFieldTypeString, alias: Project Number, length: 50 )
• MANUFACTURER ( type: esriFieldTypeString, alias: Manufacturer, length: 50 )
• MODEL ( type: esriFieldTypeString, alias: Model, length: 50 )
• SERIAL_NUMBER ( type: esriFieldTypeString, alias: Serial Number, length: 50 )
• PURCHASE_DATE ( type: esriFieldTypeDate, alias: Purchase Date, length: 8 )
• INITIAL_COST ( type: esriFieldTypeInteger, alias: Initial Cost )
• INSTALLATION_DATE ( type: esriFieldTypeDate, alias: Installation Date, length: 8 )
• WARRANTYDATE ( type: esriFieldTypeDate, alias: Warranty Date, length: 8 )
• REPLACEMENT_COST ( type: esriFieldTypeInteger, alias: Replacement Cost )
• REMAINING_VALUE ( type: esriFieldTypeInteger, alias: Remaining Value )
• OWNED_BY ( type: esriFieldTypeString, alias: Owned By, length: 50 , Coded Values: [MyCodedValue: MyCodeName] , [HARRF_OPS: HARRF Operations] , [HARRF_PST: HARRF Plant Systems Technician] , ...7 more... )
• MAINTAINED_BY ( type: esriFieldTypeString, alias: Maintained By, length: 50 , Coded Values: [MyCodedValue: MyCodeName] , [HARRF_OPS: HARRF Operations] , [HARRF_PST: HARRF Plant Systems Technician] , ...7 more... )
• LIFECYCLE_STATUS ( type: esriFieldTypeString, alias: Lifecycle Status, length: 50 , Coded Values: [INSTALLED: Installed] , [UNINSTALLED: Uninstalled] , [ABANDONEDINPLACE: Abandoned-In-Place] , ...3 more... )
• CRITICAL ( type: esriFieldTypeString, alias: Critical?, length: 255 , Coded Values: [YES: Yes] , [NO: No] , [NA: Not Applicable] )
• CONDITION ( type: esriFieldTypeSmallInteger, alias: Condition )
• CONDITIONDATE ( type: esriFieldTypeDate, alias: Condition Date, length: 8 )
• YR_EXPECTED_END_PHYSICAL_LIFE ( type: esriFieldTypeSmallInteger, alias: Expected End of Physical Life )
• TYPICAL_YRS_FULLY_DEPRECIATE ( type: esriFieldTypeSmallInteger, alias: Typical Years to Fully Depreciate )
• DEPRECIATION_DETAILS ( type: esriFieldTypeString, alias: Depreciation Details, length: 50 )
• CONSEQUENCE_OF_FAILURE ( type: esriFieldTypeDouble, alias: Consequence of Failure (COF) )
• PROBABILITY_OF_FAILURE ( type: esriFieldTypeDouble, alias: Probability of Failure (POF) )
• BUSINESS_RISK_EXPOSURE ( type: esriFieldTypeDouble, alias: Business Risk Exposure (BRE) )
• DATE_CALCULATED ( type: esriFieldTypeDate, alias: COF, POF, and BRE Calculation, length: 8 )
• MAINTENANCE_DATE ( type: esriFieldTypeDate, alias: Maintenance Date, length: 8 )
• MAINTENANCE_COMMENTS ( type: esriFieldTypeString, alias: Maintenance Comments, length: 255 )
• IMAGE_URL ( type: esriFieldTypeString, alias: Image URL, length: 255 )
• COMMENTS ( type: esriFieldTypeString, alias: Comments, length: 255 )
• SITE_NAME ( type: esriFieldTypeString, alias: Site Name, length: 255 )
• PROCESS_NAME ( type: esriFieldTypeString, alias: System Name, length: 100 , Coded Values: [PRETREAT: Preliminary Treatment] , [PRIMTREAT: Primary Treatment] , [SECTREAT: Secondary Treatment] , ...13 more... )
• SUBPROCESS_NAME ( type: esriFieldTypeString, alias: Subsystem Name, length: 100 , Coded Values: [SCREENING: Screening] , [PUMPING: Pumping] , [GRITREMOVAL: Grit Removal] , ...48 more... )
• DISTRIBUTION_EQUIP_TYPE ( type: esriFieldTypeString, alias: Distribution Equipment Type, length: 50 , Coded Values: [SWITCHGEAR: Switchgear] , [MCC: Motor Control Center] , [ATS: Automatic Transfer Switch] )
• CIRCUIT_ID ( type: esriFieldTypeString, alias: Circuit ID, length: 50 )
• MCC_FO_NUMBER ( type: esriFieldTypeString, alias: MCC FO Number, length: 50 )
• VOLTAGE ( type: esriFieldTypeString, alias: Voltage (Volts), length: 50 , Coded Values: [12DC: 12 (DC)] , [24DC: 24 (DC)] , [24VDCLOOPEDWRD: 24 VDC (Loop Powered)] , ...26 more... )
• AMPERAGE ( type: esriFieldTypeDouble, alias: Amperage (Amps) )
• HORIZONTAL_BUS_AMPERAGE ( type: esriFieldTypeDouble, alias: Horizontal Bus Amperage (Amps) )
• VERTICAL_BUS_AMPERAGE ( type: esriFieldTypeDouble, alias: Vertical Bus Amperage (Amps) )
• NUMBER_VERTICAL_SECTIONS ( type: esriFieldTypeSmallInteger, alias: Number of Vertical Sections )
• AVAILABLE_FAULT_CURRENT ( type: esriFieldTypeDouble, alias: Available Fault Current (AIC) )
• NEMA_RATING ( type: esriFieldTypeString, alias: NEMA Rating, length: 50 , Coded Values: [GENPURPOSE: 1 General Purpose Primarily Prevents Contact with Live Parts] , [DRIPTIGHT: 2 Drip Tight] , [WEATHERRESIST: 3/3S Weather Resistant] , ...11 more... )
• ARC_FLASH_RATING ( type: esriFieldTypeSmallInteger, alias: Arc Flash Rating )
• WIRE_RATING ( type: esriFieldTypeString, alias: Wire Rating, length: 50 )
• DISTRIBUTION_POWER_SOURCE ( type: esriFieldTypeString, alias: Distribution Power Source, length: 50 , Coded Values: [UTILITY: Utility] , [DISTEQUIP: Distribution Equipment] , [MULTIPLE: Multiple] , ...1 more... )
• POINT_OF_INTEREST_ID ( type: esriFieldTypeString, alias: Position ID (Relate), length: 50 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• 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 )
• LASTUPDATE ( type: esriFieldTypeDate, alias: LASTUPDATE, length: 8 )
• LASTEDITOR ( type: esriFieldTypeString, alias: LASTEDITOR, length: 50 )
• ASSETSTATUS ( type: esriFieldTypeString, alias: ASSETSTATUS, length: 1 , Coded Values: [C: Current] , [R: Retired] , [A: Abandoned] , ...5 more... )

Relationships:

• tp_PointsOfInterest (35) -- Related To: Position (127)

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

  Iteminfo   Thumbnail   Metadata