Name: Structure Inspection/Maintenance

Display Field: INSPDATE

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: 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)
• INSPECTOR (type: esriFieldTypeString, alias: Inspector or Contractor Name, SQL Type: sqlTypeOther, length: 45, nullable: true, editable: true, Coded Values: [Sam's Catch Basin Cleaning: Sam's Catch Basin Cleaning], [Maynard Public Works: Maynard Public Works], [Maynard Highway Department: Maynard Highway Department], ... 2 more ...)
• STRUCTURE_FOUND (type: esriFieldTypeString, alias: Structure Found, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• VISIT_TYPE (type: esriFieldTypeString, alias: Visit Type, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true, Coded Values: [Inspection and Maintenance: Inspection and Maintenance], [Maintenance Only: Maintenance Only], [Inspection Only: Inspection Only])
• VISIT_REASON (type: esriFieldTypeString, alias: Visit Reason, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true, Coded Values: [Corrective Maintenance: Corrective Maintenance], [Post Construction Inspection: Post Construction Inspection], [Public Complaint: Public Complaint], ... 3 more ...)
• GRATE_CONDITION (type: esriFieldTypeSmallInteger, alias: Grate Condition, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Good: Inspect Within 2 Years], [1: Fair: Inspect Within 1 Year], [2: Poor: Requires Maintenance], ... 2 more ...)
• DEBRIS (type: esriFieldTypeString, alias: Debris present?, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• DRYWEATHER_FLOW (type: esriFieldTypeString, alias: Was Dry Weather Flow Observed?, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• SURFACE_OIL (type: esriFieldTypeString, alias: Oil Sheen visible?, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• SURFACE_FOAM (type: esriFieldTypeString, alias: Foam present?, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• HOOD_CONDITION (type: esriFieldTypeSmallInteger, alias: Hood Condition, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No hood], [1: Good- inspect within 2 years], [2: Damaged-requires maintenance])
• SEDIMENT_ACCUM (type: esriFieldTypeSmallInteger, alias: Sediment Accumulation in Sump, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No sediment], [1: Sump less than half full], [2: Sump half full], ... 2 more ...)
• STRUCTURE_CONDITION (type: esriFieldTypeSmallInteger, alias: Overall Condition, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Good: Inspect Within 2 Years], [1: Fair: Inspect Within 1 Year], [2: Poor: Requires Maintenance], ... 2 more ...)
• CLEAN_STRUCTURE (type: esriFieldTypeSmallInteger, alias: Structure Cleaning , SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Needed], [1: Completed], [2: NA])
• CLEAN_PIPE (type: esriFieldTypeSmallInteger, alias: Pipe Cleaning , SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Needed], [1: Completed], [2: NA])
• REMOVE_DEBRIS (type: esriFieldTypeSmallInteger, alias: Debris Removal , SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Needed], [1: Completed], [2: NA])
• REPAIR_STRUCTURE (type: esriFieldTypeSmallInteger, alias: Repair Structural Damage, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Needed], [1: Completed], [2: NA])
• REPLACE_GRATE_FRAME (type: esriFieldTypeSmallInteger, alias: Frame/Grate Replacement, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Needed], [1: Completed], [2: NA])
• REPAIR_HOOD (type: esriFieldTypeSmallInteger, alias: Hood Repair , SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Needed], [1: Completed], [2: NA])
• REPLACE_HOOD (type: esriFieldTypeSmallInteger, alias: Hood Replacement , SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Needed], [1: Completed], [2: NA])
• REBUILD_STRUCTURES (type: esriFieldTypeSmallInteger, alias: Rebuild Structures, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Needed], [1: Completed], [2: NA])
• FOLLOW_UP_NEEDED (type: esriFieldTypeString, alias: Follow Up Needed?, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• OTHER (type: esriFieldTypeString, alias: Other Work Completed/Needed, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true)
• NOTES (type: esriFieldTypeString, alias: Notes, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true)
• ASSETGUID (type: esriFieldTypeGUID, alias: ASSETGUID, SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)
• last_edited_date (type: esriFieldTypeDate, alias: last_edited_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• last_edited_user (type: esriFieldTypeString, alias: last_edited_user, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
• created_date (type: esriFieldTypeDate, alias: created_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• created_user (type: esriFieldTypeString, alias: created_user, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
• DEBRIS_AMOUNT (type: esriFieldTypeSmallInteger, alias: Debris Amount Removed (scoops), SQL Type: sqlTypeOther, nullable: true, editable: true, Range: [0 - 20])
• GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)

Templates:

Name: Structure Inspection/Maintenance
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Relationships:

• Structures (1) -- Related To: Structures (5)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 7/29/2023 1:43:28 AM

Schema Last Edit Date: 7/29/2023 1:43:28 AM

Data Last Edit Date: 7/29/2023 1:39:48 AM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Query Related Records   Query Attachments   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat