Name: SDE.SDE.HYDRANT_INSPECTION

Display Field: INSPECTOR_NAME

Type: Table

Description:

Copyright Text:

Max Record Count: 1000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Object ID Field: OBJECTID

Unique ID Field:

Name : OBJECTID

IsSystemMaintained : True

Global ID Field: GlobalID

Type ID Field:

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• HYDRANT_INSPECTION_ID (type: esriFieldTypeInteger, alias: HYDRANT_INSPECTION_ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• INSPECTION_DATETIME (type: esriFieldTypeDate, alias: INSPECTION_DATETIME, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• WMNODENO (type: esriFieldTypeInteger, alias: WMNODENO, SQL Type: sqlTypeOther, nullable: true, editable: true)
• IN_SERVICE_INDICATOR (type: esriFieldTypeString, alias: IN_SERVICE_INDICATOR, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• PAINT_REQUIRED (type: esriFieldTypeString, alias: PAINT_REQUIRED, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• HYDRANT_COLOUR_COMMENT (type: esriFieldTypeString, alias: HYDRANT_COLOUR_COMMENT, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• DEAD_END_MARKED (type: esriFieldTypeString, alias: DEAD_END_MARKED, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• CHAINS_ATTACHED (type: esriFieldTypeString, alias: CHAINS_ATTACHED, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• GUARD_INSTALL_REQD (type: esriFieldTypeString, alias: GUARD_INSTALL_REQD, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• GUARD_TYPE_REQD (type: esriFieldTypeString, alias: GUARD_TYPE_REQD, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• OBSTRUCTION (type: esriFieldTypeString, alias: OBSTRUCTION, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• OBSTRUCTION_NOTIFICATION_REQD (type: esriFieldTypeString, alias: OBSTRUCTION_NOTIFICATION_REQD, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• STATIC_PRESSURE_PSI (type: esriFieldTypeInteger, alias: STATIC_PRESSURE_PSI, SQL Type: sqlTypeOther, nullable: true, editable: true)
• RESIDUAL_STATIC_PRE_PSI (type: esriFieldTypeInteger, alias: RESIDUAL_STATIC_PRE_PSI, SQL Type: sqlTypeOther, nullable: true, editable: true)
• OPERATING_PRESSURE_PSI (type: esriFieldTypeInteger, alias: OPERATING_PRESSURE_PSI, SQL Type: sqlTypeOther, nullable: true, editable: true)
• UDF_RUN (type: esriFieldTypeInteger, alias: UDF_RUN, SQL Type: sqlTypeOther, nullable: true, editable: true)
• UDF_SEQ (type: esriFieldTypeInteger, alias: UDF_SEQ, SQL Type: sqlTypeOther, nullable: true, editable: true)
• RESIDUAL_HYDR_WMNODENO (type: esriFieldTypeInteger, alias: RESIDUAL_HYDR_WMNODENO, SQL Type: sqlTypeOther, nullable: true, editable: true)
• RESIDUAL_STATIC_POST_PSI (type: esriFieldTypeInteger, alias: RESIDUAL_STATIC_POST_PSI, SQL Type: sqlTypeOther, nullable: true, editable: true)
• FLOW_RATE_USGAL (type: esriFieldTypeInteger, alias: FLOW_RATE_USGAL, SQL Type: sqlTypeOther, nullable: true, editable: true)
• FIRST_WATER_APPEARANCE (type: esriFieldTypeString, alias: FIRST_WATER_APPEARANCE, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• DEBRIS_FOUND (type: esriFieldTypeString, alias: DEBRIS_FOUND, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• INITIAL_TURBIDITY_NTU (type: esriFieldTypeDouble, alias: INITIAL_TURBIDITY_NTU, SQL Type: sqlTypeOther, nullable: true, editable: true)
• FINAL_TURBIDITY_NTU (type: esriFieldTypeDouble, alias: FINAL_TURBIDITY_NTU, SQL Type: sqlTypeOther, nullable: true, editable: true)
• FINAL_CHLORINE_PPM (type: esriFieldTypeDouble, alias: FINAL_CHLORINE_PPM, SQL Type: sqlTypeOther, nullable: true, editable: true)
• BACTERIA_SAMPLE_TAKEN (type: esriFieldTypeString, alias: BACTERIA_SAMPLE_TAKEN, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• TURNING_EASE (type: esriFieldTypeString, alias: TURNING_EASE, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SHUT_OFF_VIBRATION (type: esriFieldTypeString, alias: SHUT_OFF_VIBRATION, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SLAMS_SHUT (type: esriFieldTypeString, alias: SLAMS_SHUT, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• TROUBLE_CLOSING (type: esriFieldTypeString, alias: TROUBLE_CLOSING, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• DRAINAGE_CONDITION (type: esriFieldTypeString, alias: DRAINAGE_CONDITION, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• DRAINAGE_TAGGED (type: esriFieldTypeString, alias: DRAINAGE_TAGGED, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• FLUSH_TIMING_MIN (type: esriFieldTypeDouble, alias: FLUSH_TIMING_MIN, SQL Type: sqlTypeOther, nullable: true, editable: true)
• VEHICLE_HIT (type: esriFieldTypeString, alias: VEHICLE_HIT, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• BARREL_BROKEN (type: esriFieldTypeString, alias: BARREL_BROKEN, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• RUSTED_BOLTS (type: esriFieldTypeString, alias: RUSTED_BOLTS, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• CRACKED_SPINDLE (type: esriFieldTypeString, alias: CRACKED_SPINDLE, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• LEAKING_HOOD (type: esriFieldTypeString, alias: LEAKING_HOOD, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• LEAKING_FLANGE (type: esriFieldTypeString, alias: LEAKING_FLANGE, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• INITIAL_CHLORINE_PPM (type: esriFieldTypeDouble, alias: INITIAL_CHLORINE_PPM, SQL Type: sqlTypeOther, nullable: true, editable: true)
• LEAKING_DRAIN (type: esriFieldTypeString, alias: LEAKING_DRAIN, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• NOZZLE_REPLACEMENT_REQD (type: esriFieldTypeString, alias: NOZZLE_REPLACEMENT_REQD, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• BROKEN_SPINDLE (type: esriFieldTypeString, alias: BROKEN_SPINDLE, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• LEFT_PORT_CROSS_THREADED (type: esriFieldTypeString, alias: LEFT_PORT_CROSS_THREADED, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• LEFT_PORT_SEIZED (type: esriFieldTypeString, alias: LEFT_PORT_SEIZED, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• LEFT_PORT_LEAKS (type: esriFieldTypeString, alias: LEFT_PORT_LEAKS, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• LEFT_PORT_GOOD_CONDITION (type: esriFieldTypeString, alias: LEFT_PORT_GOOD_CONDITION, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• LEFT_PORT_RECORKED (type: esriFieldTypeString, alias: LEFT_PORT_RECORKED, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• LEFT_PORT_LUBRICATED (type: esriFieldTypeString, alias: LEFT_PORT_LUBRICATED, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• LEFT_GASKET_REPLACED (type: esriFieldTypeString, alias: LEFT_GASKET_REPLACED, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• LEFT_PORT_THREAD_REPAIRED (type: esriFieldTypeString, alias: LEFT_PORT_THREAD_REPAIRED, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• CENTER_PORT_CROSS_THREADED (type: esriFieldTypeString, alias: CENTER_PORT_CROSS_THREADED, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• CENTER_PORT_SEIZED (type: esriFieldTypeString, alias: CENTER_PORT_SEIZED, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• CENTER_PORT_LEAKS (type: esriFieldTypeString, alias: CENTER_PORT_LEAKS, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• CENTER_PORT_GOOD_CONDITION (type: esriFieldTypeString, alias: CENTER_PORT_GOOD_CONDITION, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• CENTER_PORT_RECORKED (type: esriFieldTypeString, alias: CENTER_PORT_RECORKED, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• CENTER_PORT_LUBRICATED (type: esriFieldTypeString, alias: CENTER_PORT_LUBRICATED, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• CENTER_GASKET_REPLACED (type: esriFieldTypeString, alias: CENTER_GASKET_REPLACED, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• CENTER_PORT_THREAD_REPAIRED (type: esriFieldTypeString, alias: CENTER_PORT_THREAD_REPAIRED, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• RIGHT_PORT_CROSS_THREADED (type: esriFieldTypeString, alias: RIGHT_PORT_CROSS_THREADED, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• RIGHT_PORT_SEIZED (type: esriFieldTypeString, alias: RIGHT_PORT_SEIZED, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• RIGHT_PORT_LEAKS (type: esriFieldTypeString, alias: RIGHT_PORT_LEAKS, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• RIGHT_PORT_GOOD_CONDITION (type: esriFieldTypeString, alias: RIGHT_PORT_GOOD_CONDITION, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• RIGHT_PORT_RECORKED (type: esriFieldTypeString, alias: RIGHT_PORT_RECORKED, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• RIGHT_PORT_LUBRICATED (type: esriFieldTypeString, alias: RIGHT_PORT_LUBRICATED, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• RIGHT_GASKET_REPLACED (type: esriFieldTypeString, alias: RIGHT_GASKET_REPLACED, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• RIGHT_PORT_THREAD_REPAIRED (type: esriFieldTypeString, alias: RIGHT_PORT_THREAD_REPAIRED, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• FURTHER_MAINTENANCE_REQD (type: esriFieldTypeString, alias: FURTHER_MAINTENANCE_REQD, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• FURTHER_MAINTENANCE_REMARK (type: esriFieldTypeString, alias: FURTHER_MAINTENANCE_REMARK, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• MEMO_NUMBER_COMMENT (type: esriFieldTypeString, alias: MEMO_NUMBER_COMMENT, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• TURBIDITY_10MIN_NTU (type: esriFieldTypeDouble, alias: TURBIDITY_10MIN_NTU, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TURBIDITY_20MIN_NTU (type: esriFieldTypeDouble, alias: TURBIDITY_20MIN_NTU, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TURBIDITY_30MIN_NTU (type: esriFieldTypeDouble, alias: TURBIDITY_30MIN_NTU, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TURBIDITY_40MIN_NTU (type: esriFieldTypeDouble, alias: TURBIDITY_40MIN_NTU, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TURBIDITY_50MIN_NTU (type: esriFieldTypeDouble, alias: TURBIDITY_50MIN_NTU, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TURBIDITY_60MIN_NTU (type: esriFieldTypeDouble, alias: TURBIDITY_60MIN_NTU, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TURBIDITY_70MIN_NTU (type: esriFieldTypeDouble, alias: TURBIDITY_70MIN_NTU, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TURBIDITY_80MIN_NTU (type: esriFieldTypeDouble, alias: TURBIDITY_80MIN_NTU, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TURBIDITY_90MIN_NTU (type: esriFieldTypeDouble, alias: TURBIDITY_90MIN_NTU, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TURBIDITY_100MIN_NTU (type: esriFieldTypeDouble, alias: TURBIDITY_100MIN_NTU, SQL Type: sqlTypeOther, nullable: true, editable: true)
• INSPECTOR_REMARK (type: esriFieldTypeString, alias: INSPECTOR_REMARK, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• INSPECTOR_NAME (type: esriFieldTypeString, alias: INSPECTOR_NAME, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• APP_VERSION (type: esriFieldTypeString, alias: APP_VERSION, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• ARCPAD_VERSION (type: esriFieldTypeString, alias: ARCPAD_VERSION, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• DB_VERSION (type: esriFieldTypeString, alias: DB_VERSION, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• PDA_UNIT_ID (type: esriFieldTypeString, alias: PDA_UNIT_ID, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• PDA_MAKE (type: esriFieldTypeString, alias: PDA_MAKE, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• PDA_MODEL (type: esriFieldTypeString, alias: PDA_MODEL, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• PDA_SERIAL_NUMBER (type: esriFieldTypeString, alias: PDA_SERIAL_NUMBER, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• CREATE_USER_ID (type: esriFieldTypeString, alias: CREATE_USER_ID, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• CREATE_USER_DOMAIN_NAME (type: esriFieldTypeString, alias: CREATE_USER_DOMAIN_NAME, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• CREATE_DATETIME (type: esriFieldTypeDate, alias: CREATE_DATETIME, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)

Templates:

Name: SDE.SDE.HYDRANT_INSPECTION
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

Relationships:

• Hydrant (3) -- Related To: Hydrants (5)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 2/12/2019 6:02:50 PM

Schema Last Edit Date: 2/12/2019 6:02:50 PM

Data Last Edit Date: 2/12/2019 6:02:50 PM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Query Related Records   Add Features   Update Features   Delete Features   Apply Edits   Calculate   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat