Name: Recent_Gully_Visits
Display Field: Symlink
Type: Feature Layer
Geometry Type: esriGeometryPoint
Is View: true
Is Updatable View: false
Source Schema Changes Allowed: false
Sources
Description: AttributeJoin
Copyright Text:
Min. Scale: 0
Max. Scale: 0
Default Visibility: true
Max Record Count: 2000
Supported query Formats: JSON, geoJSON, PBF
Use Standardized Queries: True
Extent:
XMin: 233235.5
YMin: 655797.1
XMax: 252824
YMax: 673518.6
Spatial Reference: 27700 (27700)
Drawing Info:
{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[87,136,175,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.7}}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}
HasZ: false
HasM: false
Has Attachments: false
Has Geometry Properties: false
HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText
Object ID Field: ObjectId
Unique ID Field:
IsSystemMaintained : True
Global ID Field: GlobalID
Type ID Field:
Fields:
- Symlink (type: esriFieldTypeInteger, alias: Symlink, SQL Type: sqlTypeOther, nullable: true, editable: true)
- Unit_Number (type: esriFieldTypeString, alias: Unit Number, SQL Type: sqlTypeOther, length: 18, nullable: true, editable: true)
- Unique_ID (type: esriFieldTypeString, alias: Unique ID, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
- Location (type: esriFieldTypeString, alias: Location, SQL Type: sqlTypeOther, length: 70, nullable: true, editable: true)
- Type (type: esriFieldTypeString, alias: Type, SQL Type: sqlTypeOther, length: 40, nullable: true, editable: true, Coded Values: [SIDE: SIDE ENTRY], [TOP: TOP ENTRY], [Other: OTHER])
- Covers (type: esriFieldTypeString, alias: Covers, SQL Type: sqlTypeOther, length: 40, nullable: true, editable: true, Coded Values: [SNGL: SINGLE], [SPLT: SPLIT], [TEMP: TEMPORARY], ... 1 more ...)
- Position (type: esriFieldTypeString, alias: Position, SQL Type: sqlTypeOther, length: 40, nullable: true, editable: true, Coded Values: [CRGWY: CARRIAGEWAY], [CHNL: CHANNEL], [STBCK: SET BACK], ... 1 more ...)
- Access (type: esriFieldTypeString, alias: Access, SQL Type: sqlTypeOther, length: 40, nullable: true, editable: true, Coded Values: [HGD: HINGED], [LFT: LIFT OUT], [Other: OTHER])
- Class (type: esriFieldTypeString, alias: Class, SQL Type: sqlTypeOther, length: 40, nullable: true, editable: true, Coded Values: [HD: HEAVY DUTY], [MD: MEDIUM DUTY], [LD: LIGHT DUTY], ... 1 more ...)
- Ward (type: esriFieldTypeString, alias: Ward, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
- GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, 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_1656079504404 (type: esriFieldTypeGUID, 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])
- ObjectId (type: esriFieldTypeOID, alias: ObjectId, SQL Type: sqlTypeOther, length: 8, nullable: false, editable: false)
Templates:
Name: Gullies_Cleaning_2021_Points
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:
Is Data Versioned: false
Has Contingent Values: false
Supports Rollback On Failure Parameter: true
Last Edit Date: 4/16/2025 1:07:06 PM
Schema Last Edit Date: 4/16/2025 1:07:06 PM
Data Last Edit Date: 4/16/2025 1:07:06 PM
Supported Operations:
Query
Query Top Features
Query Analytic
Query Bins
Generate Renderer
Validate SQL
Get Estimates
ConvertFormat