Name: Gullies_Cleaning_2022_Table

Display Field: OBJECTID

Type: Table

Has Views: true

Source Schema Changes Allowed: false

Views

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)
• DateTime_Visit (type: esriFieldTypeDate, alias: DateTime Visited, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Cleaned (type: esriFieldTypeString, alias: Cleaned on visit, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• ReplaceCover (type: esriFieldTypeString, alias: Cover Replacement, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• 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)
• GUID (type: esriFieldTypeGUID, alias: GUID, SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)
• NotCleanReason (type: esriFieldTypeString, alias: Reason for Not Cleaning, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [Gully blocked by vehicle: Gully blocked by vehicle], [Gully cover stuck or tight: Gully cover stuck or tight], [Roadworks: Roadworks], ... 1 more ...)
• FilterCleaned (type: esriFieldTypeString, alias: Filter Cleaned, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [NoInvestigate: No - further investigation required])
• CleanedReason (type: esriFieldTypeString, alias: Reason for Cleaning, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [Silted 25%: Silted 25%], [Silted 50%: Silted 50%], [Silted 75%: Silted 75%], ... 6 more ...)
• CleanAction (type: esriFieldTypeString, alias: Cleaning Action, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [Jetted: Jetted], [Silt Removed: Silt Removed], [Back Blow: Back Blow], ... 4 more ...)
• QC_Checked (type: esriFieldTypeString, alias: QC - Checked, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• QC_DateChecked (type: esriFieldTypeDate, alias: QC - Date Checked, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• QC_GullyCleaned (type: esriFieldTypeString, alias: QC - Gully Cleaned, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• QC_ReasonNotCleaned (type: esriFieldTypeString, alias: QC - Reason Not Cleaned, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true, Coded Values: [Gully blocked by vehicle: Gully blocked by vehicle], [Gully cover stuck or tight: Gully cover stuck or tight], [Roadworks: Roadworks], ... 1 more ...)
• QC_CoverReplace (type: esriFieldTypeString, alias: QC - Cover Replacement Required, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• QC_BucketReplace (type: esriFieldTypeString, alias: QC - Bucket Replacement Required, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• QC_GullySurroundWork (type: esriFieldTypeString, alias: QC - Gully Surround Requires Work, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• QC_TTRO (type: esriFieldTypeString, alias: QC - TTRO Required, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• QC_StreetSwept (type: esriFieldTypeString, alias: QC - Street sweep required, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• QC_Comments (type: esriFieldTypeString, alias: QC - Comments, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• CleaningOperator (type: esriFieldTypeString, alias: Cleaning Operator, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true, Coded Values: [ADAM,_S.: ADAM, S.], [ALLEN,_M.: ALLEN, M.], [BREEN,_E.: BREEN, E.], ... 41 more ...)
• VehicleReg (type: esriFieldTypeString, alias: Vehicle Reg, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true, Coded Values: [DK20 ZWV: DK20 ZWV], [SV22 LWR: SV22 LWR], [Other - use comments: Other - use comments])

Templates:

Name: Gullies_Cleaning_2021_Table
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

Relationships:

• Gullies_Cleaning_2021_Points (0) -- Related To: Gullies_Cleaning_2022_Points (0)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 4/22/2025 2:09:21 PM

Schema Last Edit Date: 4/22/2025 2:09:21 PM

Data Last Edit Date: 4/22/2025 2:09:21 PM

Supported Operations:   Query   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