View In:   ArcGIS Online Map Viewer

Name: Grit Bin Inspections - 2021 Programme

Display Field: Road_Name

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Supports Datum Transformation: true

Extent:

XMin: 481763
YMin: 131747
XMax: 542444
YMax: 174886
Spatial Reference: 27700  (27700)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: Work_Stat
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
N/A
Default Label: N/A
UniqueValueInfos:
• Value: Pending
  Label: Pending
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [0, 112, 255, 255]
  Size: 7.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 1
• Value: Completed
  Label: Completed
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [255, 0, 0, 255]
  Size: 7.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 1
Transparency: 0
Labeling Info:

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: Work_Stat

Fields:

• Asset_ID ( type: esriFieldTypeString, alias: Asset ID, editable: true, nullable: true, length: 30, defaultValue: null, modelName: Asset_ID )
• Plaque_ID ( type: esriFieldTypeString, alias: Bin Plaque Number, editable: true, nullable: true, length: 10, defaultValue: null, modelName: Plaque_ID )
• Score ( type: esriFieldTypeDouble, alias: Score, editable: true, nullable: true, defaultValue: null, modelName: Score )
• Road_Name ( type: esriFieldTypeString, alias: Road Name, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Road_Name )
• insp_s_dat ( type: esriFieldTypeDate, alias: Inspection Start Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: insp_s_dat )
• insp_e_dat ( type: esriFieldTypeDate, alias: Inspection End Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: insp_e_dat )
• Work_Req ( type: esriFieldTypeString, alias: Work Request, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Work_Req )
• Grit_Level ( type: esriFieldTypeString, alias: Grit Bin Fill Level, editable: true, nullable: true, length: 10, defaultValue: null, modelName: Grit_Level , Coded Values: [Empty-25%: Empty-25%] , [26%-50%: 26%-50%] , [51%-75%: 51%-75%] , ...2 more... )
• Loc_Status ( type: esriFieldTypeString, alias: Bin Location Status, editable: true, nullable: true, length: 10, defaultValue: null, modelName: Loc_Status , Coded Values: [AsExpected: AsExpected] , [Moved: Moved] , [Removed: Removed] )
• Bin_Cond ( type: esriFieldTypeString, alias: Bin Condition, editable: true, nullable: true, length: 15, defaultValue: null, modelName: Bin_Cond , Coded Values: [Excellent: Excellent] , [Fair: Fair] , [RepairNeeded: RepairNeeded] , ...1 more... )
• Photo_Plaq ( type: esriFieldTypeString, alias: Photo of Bin Plaque Taken?, editable: true, nullable: false, length: 10, defaultValue: null, modelName: Photo_Plaq , Coded Values: [Y: Y] , [N: N] )
• Photo_Fill ( type: esriFieldTypeString, alias: Photo of Bin Fill Level Taken?, editable: true, nullable: false, length: 10, defaultValue: null, modelName: Photo_Fill , Coded Values: [Y: Y] , [N: N] )
• Complete_D ( type: esriFieldTypeDate, alias: Inspection Completed Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Complete_D )
• Work_Stat ( type: esriFieldTypeString, alias: Work Status, editable: true, nullable: true, length: 15, defaultValue: null, modelName: Work_Stat , Coded Values: [Pending: Pending] , [Completed: Completed] )
• Work_Req_N ( type: esriFieldTypeString, alias: Work Request Notes, editable: true, nullable: true, length: 300, defaultValue: null, modelName: Work_Req_N )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• USRN ( type: esriFieldTypeString, alias: USRN, editable: true, nullable: true, length: 50, defaultValue: null, modelName: USRN )
• District ( type: esriFieldTypeString, alias: District, editable: true, nullable: true, length: 100, defaultValue: null, modelName: District )
• Priority ( type: esriFieldTypeString, alias: Priority, editable: true, nullable: true, length: 10, defaultValue: null, modelName: Priority , Coded Values: [1: 1] , [2: 2] , [3: 3] , ...2 more... )
• Notes ( type: esriFieldTypeString, alias: Notes, editable: true, nullable: true, length: 300, defaultValue: null, modelName: Notes )
• Validated ( type: esriFieldTypeString, alias: Validated, editable: true, nullable: true, length: 25, defaultValue: null, modelName: Validated , Coded Values: [Y: Y] , [N: N] )
• Grit_Water_Solid ( type: esriFieldTypeString, alias: Grit_Water_Solid, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Grit_Water_Solid , Coded Values: [Waterlogged: Waterlogged] , [Solidified: Solidified] , [Other: Other] )
• created_user ( type: esriFieldTypeString, alias: created_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: created_user )
• created_date ( type: esriFieldTypeDate, alias: created_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created_date )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )

Types:

ID: Pending
Name: Pending
Domains:
• Grit_Level:
  Inherited
• Loc_Status:
  Inherited
• Bin_Cond:
  Inherited
• Photo_Plaq:
  Inherited
• Photo_Fill:
  Inherited
• Work_Stat:
  Inherited
• Priority:
  Inherited
• Validated:
  Inherited
• Grit_Water_Solid:
  Inherited
Templates:
• Name: Pending
  Description:
  Prototype:
  Bin_Cond: null
  Photo_Plaq:
  Complete_D: null
  Grit_Water_Solid: null
  Asset_ID: null
  Plaque_ID: null
  Score: null
  Road_Name: null
  insp_s_dat: null
  insp_e_dat: null
  Work_Req: null
  Grit_Level: null
  Loc_Status: null
  Photo_Fill:
  Work_Stat: Pending
  Work_Req_N: null
  Validated: null
  USRN: null
  District: null
  Priority: null
  Notes: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: Completed
Name: Completed
Domains:
• Grit_Level:
  Inherited
• Loc_Status:
  Inherited
• Bin_Cond:
  Inherited
• Photo_Plaq:
  Inherited
• Photo_Fill:
  Inherited
• Work_Stat:
  Inherited
• Priority:
  Inherited
• Validated:
  Inherited
• Grit_Water_Solid:
  Inherited
Templates:
• Name: Completed
  Description:
  Prototype:
  Bin_Cond: null
  Photo_Plaq:
  Complete_D: null
  Grit_Water_Solid: null
  Asset_ID: null
  Plaque_ID: null
  Score: null
  Road_Name: null
  insp_s_dat: null
  insp_e_dat: null
  Work_Req: null
  Grit_Level: null
  Loc_Status: null
  Photo_Fill:
  Work_Stat: Completed
  Work_Req_N: null
  Validated: null
  USRN: null
  District: null
  Priority: null
  Notes: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

Capabilities: Query,Create,Update,Uploads,Editing,Extract

Sync Can Return Changes: true

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

Edit Fields Info:

• Creation Date Field: created_date
• Creator Field: created_user
• Edit Date Field: last_edited_date
• Editor Field: last_edited_user

Supports Query With Historic Moment: true

Supports Coordinates Quantization: true

Supported Operations:   Query   Query Analytic   Apply Edits   Add Features   Update Features   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata