Name: swLinearFeatures_Form

Display Field: INSPDATE

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: 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 Name, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• ACCESSIBLE (type: esriFieldTypeString, alias: Structure Accessible?, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• ACCESS_NOTES (type: esriFieldTypeString, alias: Accessibility Notes, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• RAIN_24HR (type: esriFieldTypeString, alias: Rain in last 24 hours?, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• INSPECTOR_AFFILIATION (type: esriFieldTypeString, alias: Inspector Affiliation, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true, Coded Values: [VHB: VHB], [GHD: GHD], [Municipality: Municipality], ... 1 more ...)
• INSPECT_TYPE (type: esriFieldTypeString, alias: Inspection Type, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true, Coded Values: [Downstream End IDDE: Downstream End IDDE], [CCTV: CCTV], [Visual Condition Inspection: Visual Condition Inspection])
• STRUCTURE_ID (type: esriFieldTypeDouble, alias: Access Structure ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CONDITION_NOTES (type: esriFieldTypeString, alias: Condition Notes, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• ISSUE_TYPE (type: esriFieldTypeString, alias: Type of Issue, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true, Coded Values: [O+M: O+M], [Structural: Structural], [O+M/Structural: O+M/Structural], ... 1 more ...)
• REPAIR_NEEDED (type: esriFieldTypeString, alias: Type of Repair Needed, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [Point Repair: Point Repair], [Short Liner: Short Liner], [CIP Liner: CIP Liner], ... 2 more ...)
• BLOCKAGE (type: esriFieldTypeString, alias: Blockage, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• SED_PERCENT (type: esriFieldTypeString, alias: Sediment Percent Full, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [No sediment: No sediment], [< 25% accumulation: < 25% accumulation], [25- 50% accumulation: 25- 50% accumulation], ... 1 more ...)
• STANDING_WATER (type: esriFieldTypeString, alias: Standing Water Observed?, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• STANDING_WATER_COLOR (type: esriFieldTypeString, alias: Standing Water Color, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true, Coded Values: [Other (describe in notes): Other (describe in notes)], [Dark red: Dark red], [Blue: Blue], ... 11 more ...)
• FLOW (type: esriFieldTypeString, alias: Flow Observed?, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• FLOW_COLOR (type: esriFieldTypeString, alias: Color of Flow, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true, Coded Values: [Other (describe in notes): Other (describe in notes)], [Dark red: Dark red], [Blue: Blue], ... 11 more ...)
• FLOW_VOL (type: esriFieldTypeString, alias: Flow Volume, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [Low: Low], [Moderate: Moderate], [Heavy: Heavy], ... 1 more ...)
• FLOATABLES (type: esriFieldTypeString, alias: Floatables, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true, Coded Values: [None: None], [Oily Sheen: Oily Sheen], [Sewage: Sewage], ... 3 more ...)
• ODOR (type: esriFieldTypeString, alias: Odor, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true, Coded Values: [Sharp, pungent odor: Sharp, pungent odor], [Other (describe in notes): Other (describe in notes)], [None: None], ... 5 more ...)
• TEMP_CELS (type: esriFieldTypeDouble, alias: Temp (deg C), SQL Type: sqlTypeOther, nullable: true, editable: true)
• PH (type: esriFieldTypeDouble, alias: pH, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CONDUCTIVITY (type: esriFieldTypeDouble, alias: Conductivity (µS), SQL Type: sqlTypeOther, nullable: true, editable: true)
• SALINITY (type: esriFieldTypeDouble, alias: Salinity (ppt), SQL Type: sqlTypeOther, nullable: true, editable: true)
• AMMONIA (type: esriFieldTypeDouble, alias: Ammonia (mg/L), SQL Type: sqlTypeOther, nullable: true, editable: true)
• SURFACTANTS (type: esriFieldTypeDouble, alias: Surfactants (mg/L), SQL Type: sqlTypeOther, nullable: true, editable: true)
• CHLORINE (type: esriFieldTypeDouble, alias: Chlorine (mg/L), SQL Type: sqlTypeOther, nullable: true, editable: true)
• LAB_SAMPLE (type: esriFieldTypeString, alias: Lab Sample Collected?, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [NA: NA])
• LAB_SAMPLE1 (type: esriFieldTypeString, alias: Lab Sample 1 Type, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [Chromium, Total: Chromium, Total], [Nitrogen, Total: Nitrogen, Total], [Oil and Grease: Oil and Grease], ... 18 more ...)
• LAB_SAMPLE1_RESULTS (type: esriFieldTypeString, alias: Lab Sample 1 Results, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• LAB_SAMPLE2 (type: esriFieldTypeString, alias: Lab Sample 2 Type, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [Chromium, Total: Chromium, Total], [Nitrogen, Total: Nitrogen, Total], [Oil and Grease: Oil and Grease], ... 18 more ...)
• LAB_SAMPLE2_RESULTS (type: esriFieldTypeString, alias: Lab Sample 2 Results, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• SB_PLACE_DATE (type: esriFieldTypeDate, alias: Sandbag Place Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• SB_CHECK_DATE (type: esriFieldTypeDate, alias: Sandbag Check Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• SB_RECHECK_DATE (type: esriFieldTypeDate, alias: Sandbag Recheck Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• SB_FLOW_CAP (type: esriFieldTypeString, alias: Sandbag Flow Captured?, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Fouled: Fouled])
• CONATMINATION (type: esriFieldTypeString, alias: Contamination Findings, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [NA - Not Accessed: NA - Not Accessed], [NA - Pipe Submerged: NA - Pipe Submerged], [New Positive Test Kit - Municipality: New Positive Test Kit - Municipality], ... 7 more ...)
• NEEDS_FOLLOWUP (type: esriFieldTypeString, alias: Follow-up Needed?, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• CONDITION (type: esriFieldTypeString, alias: Linear Feature Condition, SQL Type: sqlTypeOther, length: 35, nullable: true, editable: true, Coded Values: [Good: Inspect Within 2 Years: Good: Inspect Within 2 Years], [Fair: Inspect Within 1 Year: Fair: Inspect Within 1 Year], [Poor: Requires Maintenance: Poor: Requires Maintenance], ... 3 more ...)
• FNOTES (type: esriFieldTypeString, alias: Follow-up Notes, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• NOTES (type: esriFieldTypeString, alias: Notes, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• ASSETGUID (type: esriFieldTypeGUID, alias: ASSETGUID, SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)
• SB_PLACED (type: esriFieldTypeString, alias: Sandbag Placed?, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• QC_COMPLETE (type: esriFieldTypeString, alias: QC Complete?, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• created_user (type: esriFieldTypeString, alias: created_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)
• last_edited_user (type: esriFieldTypeString, alias: last_edited_user, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
• last_edited_date (type: esriFieldTypeDate, alias: last_edited_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• ASSETGUID_Conveyance (type: esriFieldTypeGUID, alias: ASSETGUID, SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)
• ASSETGUID_Culvert (type: esriFieldTypeGUID, alias: ASSETGUID, SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)

Templates:

Name: swLinearFeatures_Form
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

Relationships:

• swOpenDrain (5) -- Related To: swOpenDrain (4)
• swCulvert (4) -- Related To: swCulvert (11)
• swGravityPipes (3) -- Related To: swGravityPipes (3)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 5/4/2026 5:18:10 PM

Schema Last Edit Date: 5/4/2026 5:18:10 PM

Data Last Edit Date: 5/4/2026 5:18:10 PM

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