View In:   ArcGIS Online Map Viewer

Name: SCC_ASSET_TS

Display Field: roadName

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: 341471e9de4144e399c8134b0faa2e8e

Copyright Text:

Default Visibility: true

MaxRecordCount: 200000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0.0

Max Scale: 0.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: 482566.83999999985
YMin: 143213.8445999995
XMax: 521023.1695999997
YMax: 154719.5800999999
Spatial Reference: 27700  (27700)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [111, 69, 160, 255]
Size: 4.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[0, 0, 0, 255] Width: 0
Label: N/A
Description: N/A
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
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true

HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• assetID ( type: esriFieldTypeInteger, alias: Asset ID, editable: false, nullable: true, defaultValue: null, modelName: assetID )
• externalID ( type: esriFieldTypeString, alias: External ID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: externalID )
• assetType ( type: esriFieldTypeString, alias: Asset type, editable: true, nullable: true, length: 20, defaultValue: TrashScreen, modelName: assetType , Coded Values: [AcoDrain: AcoDrain] , [BeanieBlocks: BeanieBlocks] , [Catchpit: Catchpit] , ...24 more... )
• roadName ( type: esriFieldTypeString, alias: Road name, editable: true, nullable: true, length: 150, defaultValue: null, modelName: roadName )
• roadClassNo ( type: esriFieldTypeString, alias: Road class number, editable: true, nullable: true, length: 7, defaultValue: null, modelName: roadClassNo )
• tmRequiredCrew ( type: esriFieldTypeString, alias: Crew suggested TM requirements, editable: true, nullable: true, length: 30, defaultValue: Not Set, modelName: tmRequiredCrew , Coded Values: [Not Set: Not Set] , [15 Min Delay Boards: 15 Min Delay Boards] , [2-Way Lights: 2-Way Lights] , ...9 more... )
• tmRequiredAdmin ( type: esriFieldTypeString, alias: Fixed TM requirements, editable: true, nullable: true, length: 30, defaultValue: Not Set, modelName: tmRequiredAdmin , Coded Values: [Not Set: Not Set] , [15 Min Delay Boards: 15 Min Delay Boards] , [2-Way Lights: 2-Way Lights] , ...9 more... )
• tmRequiredRepair ( type: esriFieldTypeString, alias: Ironwork replacement TM, editable: true, nullable: true, length: 30, defaultValue: Not Set, modelName: tmRequiredRepair , Coded Values: [Not Set: Not Set] , [15 Min Delay Boards: 15 Min Delay Boards] , [2-Way Lights: 2-Way Lights] , ...9 more... )
• esu ( type: esriFieldTypeString, alias: ESU, editable: true, nullable: true, length: 14, defaultValue: null, modelName: esu )
• usrn ( type: esriFieldTypeInteger, alias: USRN, editable: true, nullable: true, defaultValue: null, modelName: usrn )
• ward ( type: esriFieldTypeString, alias: Ward, editable: true, nullable: true, length: 50, defaultValue: Not Set, modelName: ward , Coded Values: [Not Set: Not Set] , [Addlestone Bourneside: Addlestone Bourneside] , [Addlestone North: Addlestone North] , ...231 more... )
• parish ( type: esriFieldTypeString, alias: Parish, editable: true, nullable: true, length: 50, defaultValue: Not Set, modelName: parish , Coded Values: [Not Set: Not Set] , [Abinger CP: Abinger CP] , [Albury CP: Albury CP] , ...87 more... )
• district ( type: esriFieldTypeString, alias: District, editable: true, nullable: true, length: 30, defaultValue: Not Set, modelName: district , Coded Values: [Not Set: Not Set] , [Elmbridge: Elmbridge] , [Epsom and Ewell: Epsom and Ewell] , ...9 more... )
• districtSchedule ( type: esriFieldTypeString, alias: Schedule district, editable: true, nullable: true, length: 30, defaultValue: Not Set, modelName: districtSchedule , Coded Values: [Not Set: Not Set] , [Elmbridge: Elmbridge] , [Epsom and Ewell: Epsom and Ewell] , ...9 more... )
• maintainedBy ( type: esriFieldTypeString, alias: Maintained by, editable: true, nullable: true, length: 20, defaultValue: Local Authority, modelName: maintainedBy , Coded Values: [Not Set: Not Set] , [Archived: Archived] , [Borough Council: Borough Council] , ...3 more... )
• archiveReason ( type: esriFieldTypeString, alias: Approved archive reason, editable: true, nullable: true, length: 20, defaultValue: Not Set, modelName: archiveReason , Coded Values: [Duplicate: Duplicate] , [Not Found: Not Found] , [Not Local Authority: Not Local Authority] , ...1 more... )
• lvInspArcReason ( type: esriFieldTypeString, alias: Crew suggested archive reason, editable: true, nullable: true, length: 20, defaultValue: Not Set, modelName: lvInspArcReason , Coded Values: [Duplicate: Duplicate] , [Not Found: Not Found] , [Not Local Authority: Not Local Authority] , ...1 more... )
• cycle ( type: esriFieldTypeSmallInteger, alias: Cycle, editable: true, nullable: true, defaultValue: null, modelName: cycle , Coded Values: [99: Not set] , [6: Six Month] , [12: Annual] , ...3 more... )
• highSpeed ( type: esriFieldTypeString, alias: High Speed Section, editable: true, nullable: true, length: 7, defaultValue: null, modelName: highSpeed , Coded Values: [no: no] , [yes: yes] )
• targetDate ( type: esriFieldTypeDate, alias: Target date of next inspection, editable: true, nullable: true, length: 8, defaultValue: null, modelName: targetDate )
• progType ( type: esriFieldTypeString, alias: Programme type, editable: true, nullable: true, length: 20, defaultValue: Cyclical, modelName: progType , Coded Values: [Not Set: Not Set] , [Adhoc: Adhoc] , [Cyclical: Cyclical] , ...2 more... )
• priority ( type: esriFieldTypeSmallInteger, alias: Priority, editable: true, nullable: true, defaultValue: null, modelName: priority )
• floodzone ( type: esriFieldTypeSmallInteger, alias: Flood zone, editable: true, nullable: true, defaultValue: 0, modelName: floodzone , Coded Values: [0: Not Set] , [100: 100 years] , [1000: 1000 years] , ...1 more... )
• gullyType ( type: esriFieldTypeString, alias: Type of gully, editable: true, nullable: true, length: 20, defaultValue: Not Set, modelName: gullyType , Coded Values: [Not Set: Not Set] , [Chute: Chute] , [Costa: Costa] , ...12 more... )
• lvinspWorkType ( type: esriFieldTypeString, alias: Last visit inspection type, editable: true, nullable: true, length: 20, defaultValue: Not Set, modelName: lvinspWorkType , Coded Values: [Not Set: Not Set] , [Cyclical: Cyclical] , [CycRemote: Cyclical - Remote] , ...2 more... )
• lvinspUser ( type: esriFieldTypeString, alias: Last inspected by, editable: true, nullable: true, length: 255, defaultValue: Not Set, modelName: lvinspUser )
• lvinspAccessible ( type: esriFieldTypeString, alias: Access condition, editable: true, nullable: true, length: 20, defaultValue: Not Set, modelName: lvinspAccessible , Coded Values: [Not Set: Not Set] , [Excavation Required: Excavation Required] , [Inaccessible: Inaccessible] , ...5 more... )
• lvinspSilt ( type: esriFieldTypeSmallInteger, alias: Last visit silt level, editable: true, nullable: true, defaultValue: 99, modelName: lvinspSilt , Coded Values: [99: Not Set] , [999: Not Measured] , [0: 0%] , ...4 more... )
• lvCoverCon ( type: esriFieldTypeString, alias: Cover condition when last visited, editable: true, nullable: true, length: 20, defaultValue: null, modelName: lvCoverCon , Coded Values: [Broken Lid: Broken Lid] , [Buried on Arrival: Buried on Arrival] , [Missing: Missing] , ...3 more... )
• lvinspOpLeave ( type: esriFieldTypeString, alias: Last visit operational on leaving, editable: true, nullable: true, length: 30, defaultValue: Not Set, modelName: lvinspOpLeave , Coded Values: [Not Set: Not Set] , [No: No] , [Slow Runner: Slow Runner] , ...1 more... )
• lvinspCleaned ( type: esriFieldTypeString, alias: Last visit clean status, editable: true, nullable: true, length: 7, defaultValue: Not Set, modelName: lvinspCleaned , Coded Values: [Not Set: Not Set] , [no: no] , [yes: yes] )
• lvinspJetted ( type: esriFieldTypeString, alias: Jetting carried out, editable: true, nullable: true, length: 7, defaultValue: Not Set, modelName: lvinspJetted , Coded Values: [Not Set: Not Set] , [no: no] , [yes: yes] )
• lvinspJetTime ( type: esriFieldTypeSmallInteger, alias: Time spent jetting, editable: true, nullable: true, defaultValue: null, modelName: lvinspJetTime )
• lvinspJetComment ( type: esriFieldTypeString, alias: Jetting related comments, editable: true, nullable: true, length: 460, defaultValue: null, modelName: lvinspJetComment )
• lvinspComments ( type: esriFieldTypeString, alias: Last inspection comments, editable: true, nullable: true, length: 680, defaultValue: null, modelName: lvinspComments )
• lvinspDate ( type: esriFieldTypeDate, alias: Last inspected on, editable: true, nullable: true, length: 8, defaultValue: null, modelName: lvinspDate )
• lvinspDefect ( type: esriFieldTypeString, alias: Last visit defect status, editable: true, nullable: true, length: 50, defaultValue: Not Set, modelName: lvinspDefect , Coded Values: [Not Set: Not Set] , [Ditch Maintenance Required: Ditch Maintenance Required] , [Domestic Refuse: Domestic Refuse] , ...13 more... )
• lvauditDate ( type: esriFieldTypeDate, alias: Last audited on, editable: true, nullable: true, length: 8, defaultValue: null, modelName: lvauditDate )
• POINT_X ( type: esriFieldTypeDouble, alias: Easting, editable: true, nullable: true, defaultValue: null, modelName: POINT_X )
• POINT_Y ( type: esriFieldTypeDouble, alias: Northing, editable: true, nullable: true, defaultValue: null, modelName: POINT_Y )
• sourceGlobalID ( type: esriFieldTypeGUID, alias: sourceGlobalID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: sourceGlobalID )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• 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 )
• adHocWorks ( type: esriFieldTypeString, alias: Ad Hoc Works, editable: true, nullable: true, length: 40, defaultValue: null, modelName: adHocWorks )

Templates:

• Name: SCC_ASSET_TS
  Description:
  Prototype:
  POINT_Y: null
  sourceGlobalID: null
  adHocWorks: null
  externalID: null
  assetType: TrashScreen
  roadName: null
  roadClassNo: null
  tmRequiredCrew: Not Set
  tmRequiredAdmin: Not Set
  tmRequiredRepair: Not Set
  esu: null
  usrn: null
  ward: Not Set
  parish: Not Set
  district: Not Set
  districtSchedule: Not Set
  maintainedBy: Local Authority
  archiveReason: Not Set
  lvInspArcReason: Not Set
  cycle: null
  highSpeed: null
  targetDate: null
  progType: Cyclical
  priority: null
  floodzone: 0
  gullyType: Not Set
  lvinspWorkType: Not Set
  lvinspUser: Not Set
  lvinspAccessible: Not Set
  lvinspSilt: 99
  lvCoverCon: null
  lvinspOpLeave: Not Set
  lvinspCleaned: Not Set
  lvinspJetted: Not Set
  lvinspJetTime: null
  lvinspJetComment: null
  lvinspComments: null
  lvinspDate: null
  lvinspDefect: Not Set
  lvauditDate: null
  POINT_X: null
  
  Drawing Tool: esriFeatureEditToolPoint

Relationships:

• ASSET_TS_INSP (19) -- Related To: SCC_ASSET_TS_INSP (36)

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

Sync Can Return Changes: true

Is Data Versioned: false

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: true

Supports ApplyEdits By Upload Id: true

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

Child Resources:   Field Groups   Contingent Values

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