Name: HydrantPaintInsp

Display Field: PROJNAME

Type: Table

Description:

Copyright Text:

Max Record Count: 10000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

HasZ: false

HasM: false

Has Attachments: true

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)
• INSPDATE (type: esriFieldTypeDate, alias: Inspection Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• PROJNAME (type: esriFieldTypeString, alias: Project Name, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• INSPECTOR (type: esriFieldTypeString, alias: Inspector, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [KenSpecker: Ken Specker], [ParkerPeluso: Parker Peluso], [Other: Other])
• II_POSHS (type: esriFieldTypeString, alias: Is there paint on the surrounding hard surface?, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Y: Yes], [N: No])
• II_POSHS_COMMENT (type: esriFieldTypeString, alias: If yes, provide detail below, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• II_POFHT (type: esriFieldTypeString, alias: Is there paint on the fire hydrant threads?, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Y: Yes], [N: No])
• II_POFHT_COMMENT (type: esriFieldTypeString, alias: If yes, provide detail below, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• II_BS (type: esriFieldTypeString, alias: Are there any bare spots, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Y: Yes], [N: No])
• II_BS_COMMENT (type: esriFieldTypeString, alias: If yes, provide detail below, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• II_TS (type: esriFieldTypeString, alias: Are there any thin spots?, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Y: Yes], [N: No])
• II_TS_COMMENT (type: esriFieldTypeString, alias: If yes, provide detail below, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• II_FOPC (type: esriFieldTypeString, alias: Were the flanges and overhangs properly coated?, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Y: Yes], [N: No])
• II_FOPC_COMMENT (type: esriFieldTypeString, alias: If no, provide detail below, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• II_PPORS (type: esriFieldTypeString, alias: Was the peeling paint and/or rust spots adequately removed/cleaned?, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Y: Yes], [N: No])
• II_PPORS_COMMENT (type: esriFieldTypeString, alias: If no, provide detail below, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• II_PLOBCL (type: esriFieldTypeString, alias: Was paint left on the bar code label?, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Y: Yes], [N: No])
• II_PLOBCL_COMMENT (type: esriFieldTypeString, alias: If no, provide detail below, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• II_DPDEOOPD (type: esriFieldTypeString, alias: Are dried paint drippings evident or other paint defects?, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Y: Yes], [N: No])
• II_DPDEOOPD_COMMENT (type: esriFieldTypeString, alias: If yes, provide detail below, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• II_IDPFH (type: esriFieldTypeString, alias: If inspecting decoratively painted fire hydrant, are the glass beads evident on the bonnet?, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Y: Yes], [N: No])
• II_DIATSWLIO (type: esriFieldTypeString, alias: Does it appear the site was left in order?, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Y: Yes], [N: No])
• II_DIATSWLIO_COMMENT (type: esriFieldTypeString, alias: If no, provide detail below, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• II_ADDITIONAL_COMMENTS (type: esriFieldTypeString, alias: Comments and Details, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• PARENTFACILITY (type: esriFieldTypeString, alias: RELATE, SQL Type: sqlTypeOther, length: 99, nullable: true, editable: true)
• GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• INSPECTOROTHER (type: esriFieldTypeString, alias: Name of Other Inspector, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• HYDRANTPAINTED (type: esriFieldTypeString, alias: Does Hydrant Still Need Painted, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Y: Yes], [N: No])

Templates:

Name: HydrantPaintInsp
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

• HYDRANTPAINTED: N

Relationships:

• WaterFireHydrant (0) -- Related To: Fire Hydrant (0)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 6/24/2025 9:09:19 PM

Schema Last Edit Date: 6/24/2025 9:09:19 PM

Data Last Edit Date: 6/24/2025 9:09:19 PM

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