Name: On_inspection_table

Display Field: inspector_name

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)
• globalid (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• guid (type: esriFieldTypeGUID, alias: GUID, SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)
• project_id (type: esriFieldTypeString, alias: project_id, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• dam_id (type: esriFieldTypeString, alias: Dam ID, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• inspection_date (type: esriFieldTypeDate, alias: Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• inspector_name (type: esriFieldTypeString, alias: Inspector Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Andrew_ Riddell: Andrew Riddell], [Elise_Macleod: Elise Macleod], [Graham_Janson: Graham Janson], ... 6 more ...)
• survey_type (type: esriFieldTypeString, alias: What type of survey?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [HAM: HAM], [Engineering: Engineering])
• what_infrastructure (type: esriFieldTypeString, alias: What infrastructure requires inspection?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• ham_inspection_condition (type: esriFieldTypeString, alias: General Condition of Works, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Good: Good], [Fair: Fair], [Poor: Poor], ... 3 more ...)
• ham_inspection_maintance (type: esriFieldTypeString, alias: Is maintenance required?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [TBD: TBD by others])
• ham_inspection_urgency (type: esriFieldTypeString, alias: Urgency of required maintance?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Immediate: Immediate], [WithinYear: Within a year], [Low: Low], ... 1 more ...)
• ham_comments (type: esriFieldTypeString, alias: Comments on condition of works:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• acc_con_condition (type: esriFieldTypeString, alias: General Condition of Access, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Good: Good], [Fair: Fair], [Poor: Poor], ... 3 more ...)
• acc_con_comments (type: esriFieldTypeString, alias: Comments on condition of Access:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• acc_con_maintance (type: esriFieldTypeString, alias: Is maintenance required?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [TBD: TBD by others])
• acc_con_urgency (type: esriFieldTypeString, alias: Urgency of required maintance?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Immediate: Immediate], [WithinYear: Within a year], [Low: Low], ... 1 more ...)
• control_condition (type: esriFieldTypeString, alias: General Condition of Control, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Good: Good], [Fair: Fair], [Poor: Poor], ... 3 more ...)
• control_comments (type: esriFieldTypeString, alias: Comments on condition of Control:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• control_maintance (type: esriFieldTypeString, alias: Is maintenance required?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [TBD: TBD by others])
• control_urgency (type: esriFieldTypeString, alias: Urgency of required maintance?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Immediate: Immediate], [WithinYear: Within a year], [Low: Low], ... 1 more ...)
• beaver_fence_condition (type: esriFieldTypeString, alias: General Condition of Beaver Fence & Baffler, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Good: Good], [Fair: Fair], [Poor: Poor], ... 3 more ...)
• beaver_fence_comments (type: esriFieldTypeString, alias: Comments on condition of Beaver Fence & Baffler:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• beaver_fence_maintance (type: esriFieldTypeString, alias: Is maintenance required?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [TBD: TBD by others])
• beaver_fence_urgency (type: esriFieldTypeString, alias: Urgency of required maintance?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Immediate: Immediate], [WithinYear: Within a year], [Low: Low], ... 1 more ...)
• culvert_condition (type: esriFieldTypeString, alias: General Condition of Culvert, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Good: Good], [Fair: Fair], [Poor: Poor], ... 3 more ...)
• culvert_comments (type: esriFieldTypeString, alias: Comments on condition of Culvert:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• culvert_maintance (type: esriFieldTypeString, alias: Is maintenance required?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [TBD: TBD by others])
• culvert_urgency (type: esriFieldTypeString, alias: Urgency of required maintance?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Immediate: Immediate], [WithinYear: Within a year], [Low: Low], ... 1 more ...)
• spillway_condition (type: esriFieldTypeString, alias: General Condition of Spillway, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Good: Good], [Fair: Fair], [Poor: Poor], ... 3 more ...)
• spillway_comments (type: esriFieldTypeString, alias: Comments on condition of Spillway:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• spillway_maintance (type: esriFieldTypeString, alias: Is maintenance required?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [TBD: TBD by others])
• spillway_urgency (type: esriFieldTypeString, alias: Urgency of required maintance?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Immediate: Immediate], [WithinYear: Within a year], [Low: Low], ... 1 more ...)
• dyke_crest_condition (type: esriFieldTypeString, alias: General Condition of Dyke Crest, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Good: Good], [Fair: Fair], [Poor: Poor], ... 3 more ...)
• dyke_crest_comments (type: esriFieldTypeString, alias: Comments on condition of Dyke Crest:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• dyke_crest_maintance (type: esriFieldTypeString, alias: Is maintenance required?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [TBD: TBD by others])
• dyke_crest_urgency (type: esriFieldTypeString, alias: Urgency of required maintance?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Immediate: Immediate], [WithinYear: Within a year], [Low: Low], ... 1 more ...)
• dyke_slope_condition (type: esriFieldTypeString, alias: General Condition of Dyke Slope, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Good: Good], [Fair: Fair], [Poor: Poor], ... 3 more ...)
• dyke_slope_comments (type: esriFieldTypeString, alias: Comments on condition of Dyke Slope:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• dyke_slope_maintance (type: esriFieldTypeString, alias: Is maintenance required?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [TBD: TBD by others])
• dyke_slope_urgency (type: esriFieldTypeString, alias: Urgency of required maintance?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Immediate: Immediate], [WithinYear: Within a year], [Low: Low], ... 1 more ...)
• plug_dyke_slope_condition (type: esriFieldTypeString, alias: General Condition of Plug Dyke Slope, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Good: Good], [Fair: Fair], [Poor: Poor], ... 3 more ...)
• plug_dyke_slope_comments (type: esriFieldTypeString, alias: Comments on condition of Plug Dyke Slope:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• plug_dyke_slope_maintance (type: esriFieldTypeString, alias: Is maintenance required?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [TBD: TBD by others])
• plug_dyke_slope_urgency (type: esriFieldTypeString, alias: Urgency of required maintance?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Immediate: Immediate], [WithinYear: Within a year], [Low: Low], ... 1 more ...)
• plug_dyke_crest_condition (type: esriFieldTypeString, alias: General Condition of Plug Dyke Crest, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Good: Good], [Fair: Fair], [Poor: Poor], ... 3 more ...)
• plug_dyke_crest_comments (type: esriFieldTypeString, alias: Comments on condition of Plug Dyke Crest:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• plug_dyke_crest_maintance (type: esriFieldTypeString, alias: Is maintenance required?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [TBD: TBD by others])
• plug_dyke_crest_urgency (type: esriFieldTypeString, alias: Urgency of required maintance?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Immediate: Immediate], [WithinYear: Within a year], [Low: Low], ... 1 more ...)
• beaver_activity_comments (type: esriFieldTypeString, alias: Is beaver or muskrat activity present?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• beaver_maintenance (type: esriFieldTypeString, alias: Is maintenance required?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [TBD: TBD by others])
• beaver_urgency (type: esriFieldTypeString, alias: Urgency of required maintance?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Immediate: Immediate], [WithinYear: Within a year], [Low: Low], ... 1 more ...)
• waterlevelcond (type: esriFieldTypeString, alias: Water level?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Good: Good], [Fair: Fair], [Poor: Poor], ... 3 more ...)
• water_level_comments (type: esriFieldTypeString, alias: Comments on Water Level:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• publically_accessible (type: esriFieldTypeString, alias: Is the site publically accessible?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• fence_cond (type: esriFieldTypeString, alias: General condition of fence and gate?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• fence_comments (type: esriFieldTypeString, alias: Comments on condition of fence and gate:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• lock_cond (type: esriFieldTypeString, alias: General condition of Lock?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• lock_comments (type: esriFieldTypeString, alias: Comments on condition of lock:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• signs_cond (type: esriFieldTypeString, alias: General condition of signs?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• signs_comments (type: esriFieldTypeString, alias: Comments on condition of signs:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• railings_cond (type: esriFieldTypeString, alias: General condition of railings?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• raillings_comment (type: esriFieldTypeString, alias: Comments on condition of railings:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• public_safety_yn (type: esriFieldTypeString, alias: Is there a risk to public safety?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• public_safety_comment (type: esriFieldTypeString, alias: General Safety comments:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• created_user (type: esriFieldTypeString, alias: created_user, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• created_date (type: esriFieldTypeDate, alias: created_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• last_edited_user (type: esriFieldTypeString, alias: last_edited_user, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• last_edited_date (type: esriFieldTypeDate, alias: last_edited_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• inspection_year (type: esriFieldTypeInteger, alias: Inspection Year, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ham_id (type: esriFieldTypeString, alias: ham_id, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• 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: On_inspection_table
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

Relationships:

• ON_Inspection_Points (0) -- Related To: ON_Inspection_Points (14)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 9/25/2025 7:12:03 PM

Schema Last Edit Date: 9/25/2025 7:12:03 PM

Data Last Edit Date: 9/25/2025 7:12:03 PM

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