Name: Drainage_Structure_Inspection_Form

Display Field: Name

Type: Table

Is View: true

Is Updatable View: true

Source Schema Changes Allowed: true

Sources

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: esriServerHTMLPopupTypeAsHTMLText

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)
• LOCATION (type: esriFieldTypeString, alias: Location, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [ABIGAILS WAY: ABIGAILS WAY], [ACADEMY ROAD: ACADEMY ROAD], [AGNUS STREET: AGNUS STREET], ... 722 more ...)
• inspector (type: esriFieldTypeString, alias: Inspector Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• structure_condition (type: esriFieldTypeString, alias: Structure Condition, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Good: Good], [Fair: Fair], [Poor: Poor], ... 1 more ...)
• depth_to_water_ft (type: esriFieldTypeDouble, alias: Depth to Water (ft):, SQL Type: sqlTypeOther, nullable: true, editable: true)
• depth_to_sediment_ft (type: esriFieldTypeDouble, alias: Depth to Sediment (ft):, SQL Type: sqlTypeOther, nullable: true, editable: true)
• sediment_properties (type: esriFieldTypeString, alias: Sediment Properties:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• sediment_buildup (type: esriFieldTypeString, alias: Sediment Buildup?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• sediment_buildup_depth (type: esriFieldTypeString, alias: Sediment Buildup Depth:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [0_6_in: 0-6 in], [6_12_in: 6-12 in], [18_24_in: 18-24 in], ... 2 more ...)
• sump_pump_connection (type: esriFieldTypeString, alias: Sump Pump Connection, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• required_maintenanceproblems (type: esriFieldTypeString, alias: Required Maintenance/Problems, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• other_maintenance_problems (type: esriFieldTypeString, alias: Other Maintenance/Problem, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• structure_casting_type (type: esriFieldTypeString, alias: Structure Casting Type:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Bar: Bar], [Cascade: Cascade], [Other: Other], ... 2 more ...)
• structure_casting_type_other (type: esriFieldTypeString, alias: Other Casting Type (describe), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• properly_aligned (type: esriFieldTypeString, alias: Properly Aligned:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• OUTLET_FLOW_PRESENT (type: esriFieldTypeString, alias: Outlet Flow Present?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• description_of_flow (type: esriFieldTypeString, alias: Description of Flow:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Heavy: Heavy], [Moderate: Moderate], [Slight: Slight], ... 2 more ...)
• is_the_outlet_submerged (type: esriFieldTypeString, alias: Is the Outlet Submerged?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• height_above_invert_in (type: esriFieldTypeString, alias: Height above invert (in):, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• color (type: esriFieldTypeString, alias: Color, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• odor (type: esriFieldTypeString, alias: Odor, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• other_conditions_observed (type: esriFieldTypeString, alias: Other conditions observed with flow:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• sample_collected_for_analysis (type: esriFieldTypeString, alias: Sample Collected for Analysis?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• weather_conditions (type: esriFieldTypeString, alias: Weather Conditions:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [dry24hours: Dry>24Hours], [wet: Wet])
• comments (type: esriFieldTypeString, alias: Comments, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• globalid (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• NewGUID (type: esriFieldTypeGUID, alias: NewGUID, SQL Type: sqlTypeOther, length: 38, 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: Drainage_Structure_Inspection_Form
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Relationships:

• (0) -- Related To: StormwaterPoint (10)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 6/17/2026 7:41:41 PM

Schema Last Edit Date: 6/17/2026 7:41:41 PM

Data Last Edit Date: 7/31/2026 6:46:36 PM

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