Name: Hydrant-Inspection

Display Field: t_hyd_insptype

Type: Table

Description:

Copyright Text:

Max Record Count: 2000

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)
• t_hyd_insptype (type: esriFieldTypeString, alias: Inspection Type, SQL Type: sqlTypeOther, length: 32, nullable: true, editable: true)
• t_hyd_press (type: esriFieldTypeInteger, alias: Hydrant Pressure, SQL Type: sqlTypeOther, nullable: true, editable: true)
• t_hyd_connct (type: esriFieldTypeString, alias: Supply Connection Type, SQL Type: sqlTypeOther, length: 32, nullable: true, editable: true, Coded Values: [20-Hydrant-Single_1-75: Single 1 3/4"], [21-Hydrant-Single_2-5: Single 2 1/2"], [22-Hydrant-Double_2-5: Double 2 1/2" (Villiage Hydrant)], ... 4 more ...)
• t_hyd_info (type: esriFieldTypeString, alias: Other Water Supply Information, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• t_hyd_gpm (type: esriFieldTypeInteger, alias: GPM, SQL Type: sqlTypeOther, nullable: true, editable: true)
• t_hyd_stat (type: esriFieldTypeString, alias: Hydrant Status, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• t_hyd_access (type: esriFieldTypeString, alias: Hydrant is Accessible, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• t_hyd_tight (type: esriFieldTypeString, alias: Hydrant Caps Hand Tight, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• t_hyd_leaks (type: esriFieldTypeString, alias: No Leaks in Hydrant, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• t_hyd_crack (type: esriFieldTypeString, alias: No Cracks in Hydrant Barell, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• t_hyd_nut (type: esriFieldTypeString, alias: Hydrant Nut in Working Order, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• t_hyd_thread (type: esriFieldTypeString, alias: Hydrant Threads in Working Order, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• t_hyd_work (type: esriFieldTypeString, alias: Hydrant in Good Working Condition, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• t_hyd_drain (type: esriFieldTypeString, alias: Hydrant Drains Appropriately, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• t_hyd_priv (type: esriFieldTypeString, alias: Hydrant is Private, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• created_user_wsinsp (type: esriFieldTypeString, alias: created_user_wsinsp, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• created_date_wsinsp (type: esriFieldTypeDate, alias: created_date_wsinsp, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• last_edited_user_wsinsp (type: esriFieldTypeString, alias: last_edited_user_wsinsp, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• last_edited_date_wsinsp (type: esriFieldTypeDate, alias: last_edited_date_wsinsp, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• rel_supply (type: esriFieldTypeGUID, alias: Water Supply Relate, SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)
• GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• CreationDate (type: esriFieldTypeDate, alias: CreationDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• Creator (type: esriFieldTypeString, alias: Creator, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)
• EditDate (type: esriFieldTypeDate, alias: EditDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• Editor (type: esriFieldTypeString, alias: Editor, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)

Templates:

Name: Hydrant-Inspection
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

• t_hyd_insptype: Hydrant Inspection
• t_hyd_stat: no
• t_hyd_access: yes
• t_hyd_tight: yes
• t_hyd_leaks: yes
• t_hyd_crack: yes
• t_hyd_nut: yes
• t_hyd_thread: yes
• t_hyd_work: yes
• t_hyd_drain: yes
• t_hyd_priv: no

Relationships:

• Supply (0) -- Related To: Supply (3)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 6/22/2024 6:01:12 AM

Schema Last Edit Date: 8/11/2023 4:10:55 PM

Data Last Edit Date: 6/22/2024 6:01:12 AM

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