Name: PW.WASHOE.ASSETS_SEWER_EQUIPMENT
Display Field: NAME
Type: Table
Geometry Type: N/A
Description: null
Copyright Text: N/A
Default Visibility: false
MaxRecordCount: 2000
Supported Query Formats: JSON, PBF
Supports Advanced Queries: true
Supports Statistics: true
Extent:
Drawing Info:
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
HasZ: false
HasM: false
Has Attachments: true
HTML Popup Type: esriServerHTMLPopupTypeNone
Type ID Field: null
Fields:
-
OBJECTID
(
type: esriFieldTypeOID, alias: OBJECTID
)
-
BUILDING
(
type: esriFieldTypeString, alias: BUILDING, length: 100
)
-
FLOOR
(
type: esriFieldTypeString, alias: FLOOR, length: 2
, Coded Values:
[B: Basement]
, [R: Roof]
, [1: Ground Floor]
, ...11 more...
)
-
ROOM
(
type: esriFieldTypeString, alias: ROOM, length: 20
)
-
SPECIFIC_LOCATION
(
type: esriFieldTypeString, alias: SPECIFIC_LOCATION, length: 50
)
-
SERVICE_AREA
(
type: esriFieldTypeString, alias: SERVICE_AREA, length: 20
)
-
CLASS
(
type: esriFieldTypeString, alias: CLASS, length: 12
, Coded Values:
[PLUM: PLUMBING]
, [HVAC: HVAC]
, [FIRE: FIRE]
, ...3 more...
)
-
TYPE
(
type: esriFieldTypeString, alias: TYPE, length: 50
, Coded Values:
[AHU: AHU]
, [AIR BLOWER VENTILATOR: AIR BLOWER VENTILATOR]
, [AIR COMPRESSOR: AIR COMPRESSOR]
, ...88 more...
)
-
MP2_ID
(
type: esriFieldTypeString, alias: MP2_ID, length: 255
)
-
MANUFACTURER
(
type: esriFieldTypeString, alias: MANUFACTURER, length: 40
)
-
SCADA_ID
(
type: esriFieldTypeString, alias: SCADA_ID, length: 50
)
-
MODEL_NUM
(
type: esriFieldTypeString, alias: MODEL_NUM, length: 50
)
-
SERIAL_NUM
(
type: esriFieldTypeString, alias: SERIAL_NUM, length: 50
)
-
SUPPLIER
(
type: esriFieldTypeString, alias: SUPPLIER, length: 40
)
-
COST_ORIGINAL
(
type: esriFieldTypeDouble, alias: COST_ORIGINAL
)
-
ACQU_DATE
(
type: esriFieldTypeDate, alias: ACQU_DATE, length: 8
)
-
INST_DATE
(
type: esriFieldTypeDate, alias: INST_DATE, length: 8
)
-
REMV_DATE
(
type: esriFieldTypeDate, alias: REMV_DATE, length: 8
)
-
WAR_EXP_DATE
(
type: esriFieldTypeDate, alias: WAR_EXP_DATE, length: 8
)
-
EUL
(
type: esriFieldTypeSmallInteger, alias: EUL
)
-
EQUIPMENT_NOTES
(
type: esriFieldTypeString, alias: EQUIPMENT_NOTES, length: 255
)
-
GlobalID
(
type: esriFieldTypeGlobalID, alias: GlobalID, length: 38
)
-
SECTION
(
type: esriFieldTypeString, alias: SECTION, length: 50
)
-
MAN_DATE
(
type: esriFieldTypeDate, alias: MANUFACTURER_DATE, length: 8
)
-
CRITICALITY
(
type: esriFieldTypeSmallInteger, alias: CRITICALITY
, Coded Values:
[0: MOST CRITICAL, $50k+ impact]
, [25: ESSENTIAL, $25k impact]
, [50: IMPORTANT, $10k impact]
, ...2 more...
)
-
CONDITION
(
type: esriFieldTypeSmallInteger, alias: CONDITION
, Coded Values:
[0: F – Need replaced to 20% useful life remaining]
, [25: D - 20% to 40% useful life remaining]
, [50: C - 40% to 60% useful life remaining]
, ...2 more...
)
-
CREATION_DATE
(
type: esriFieldTypeDate, alias: CREATION_DATE, length: 8
)
-
LAST_EDIT_DATE
(
type: esriFieldTypeDate, alias: LAST_EDIT_DATE, length: 8
)
-
EDIT_FLAG
(
type: esriFieldTypeString, alias: EDIT_FLAG, length: 20
, Coded Values:
[!: !]
, [-: .]
)
-
BLDG_GIS_ID
(
type: esriFieldTypeGUID, alias: BLDG_GIS_ID, length: 38
)
-
TAG_ID
(
type: esriFieldTypeString, alias: TAG_ID, length: 15
)
-
PANELCIRCUIT
(
type: esriFieldTypeSmallInteger, alias: PANEL_CIRCUIT
)
-
PANELSPACE
(
type: esriFieldTypeSmallInteger, alias: PANEL_SPACES
)
-
NEMA
(
type: esriFieldTypeString, alias: NEMA, length: 3
)
-
HP
(
type: esriFieldTypeSingle, alias: HP
)
-
VOLT
(
type: esriFieldTypeSmallInteger, alias: VOLT
)
-
PHASE
(
type: esriFieldTypeSmallInteger, alias: PHASE
)
-
FUSE_TYPE
(
type: esriFieldTypeString, alias: FUSE_TYPE, length: 50
)
-
RATING
(
type: esriFieldTypeString, alias: RATING, length: 15
)
-
STYLE
(
type: esriFieldTypeString, alias: STYLE, length: 40
)
-
FRAME
(
type: esriFieldTypeString, alias: FRAME, length: 10
)
-
RPM
(
type: esriFieldTypeSmallInteger, alias: RPM
)
-
SOURCE
(
type: esriFieldTypeString, alias: SOURCE, length: 10
)
-
AMP
(
type: esriFieldTypeSingle, alias: AMP
)
-
GPM
(
type: esriFieldTypeSmallInteger, alias: GPM
)
-
HZ
(
type: esriFieldTypeSmallInteger, alias: HZ
)
-
STATUS
(
type: esriFieldTypeString, alias: STATUS, length: 10
, Coded Values:
[RETIRED: RETIRED]
, [INVENTORY: INVENTORY]
, [IN SERVICE: IN SERVICE]
)
-
INST_DATE_INT
(
type: esriFieldTypeSmallInteger, alias: INST_DATE_INT
)
-
NAME
(
type: esriFieldTypeString, alias: NAME, length: 50
)
-
REPLACE_COST
(
type: esriFieldTypeInteger, alias: REPLACE_COST
)
-
REPLACE_NOTE
(
type: esriFieldTypeString, alias: REPLACE_NOTE, length: 250
)
-
ASSET_COMP
(
type: esriFieldTypeString, alias: ASSET_COMP, length: 3
, Coded Values:
[COM: COMPONENT]
, [ASS: PARENT ASSET]
)
-
PARENT
(
type: esriFieldTypeString, alias: PARENT, length: 50
)
Relationships:
Supported Operations:
Query
Query Attachments
Query Analytic
Query Related Records
Generate Renderer
Return Updates
Iteminfo
Thumbnail
Metadata