View In:   ArcGIS Online Map Viewer

Name: SCC_ASSET_CH

Display Field: roadName

Type: Feature Layer

Geometry Type: esriGeometryPolyline

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: 481292.2599999998
YMin: 131211.26889999956
XMax: 543233.2246000003
YMax: 175267.1308999993
Spatial Reference: 27700  (27700)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSLSSolid
Color: [88, 173, 62, 255]
Width: 1
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: null, modelName: assetType , Coded Values: [AcoDrain: AcoDrain] , [BeanieBlocks: BeanieBlocks] , [Culvert: Culvert] , ...8 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... )
• 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: null, 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: null, 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: null, modelName: district , 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: null, 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: New Asset, modelName: lvInspArcReason )
• cycle ( type: esriFieldTypeSmallInteger, alias: Cycle, editable: true, nullable: true, defaultValue: 96, 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] )
• 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... )
• material ( type: esriFieldTypeString, alias: Material, editable: true, nullable: true, length: 40, defaultValue: null, modelName: material , Coded Values: [Not Set: Not Set] , [Brick: Brick] , [Clay: Clay] , ...4 more... )
• diameter ( type: esriFieldTypeInteger, alias: Diameter, editable: true, nullable: true, defaultValue: null, modelName: diameter )
• lining ( type: esriFieldTypeString, alias: Lining, editable: true, nullable: true, length: 15, defaultValue: Not Set, modelName: lining , Coded Values: [Not Set: Not Set] , [All: All] , [None: None] , ...2 more... )
• usage ( type: esriFieldTypeString, alias: Channel usage, editable: true, nullable: true, length: 20, defaultValue: null, modelName: usage , Coded Values: [Not Set: Not Set] , [Carrier: Carrier] , [Combined: Combined] , ...5 more... )
• upID ( type: esriFieldTypeInteger, alias: Upstream asset ID, editable: true, nullable: true, defaultValue: null, modelName: upID )
• upType ( type: esriFieldTypeString, alias: Upstream asset type, editable: true, nullable: true, length: 20, defaultValue: null, modelName: upType )
• dnID ( type: esriFieldTypeInteger, alias: Downstream asset ID, editable: true, nullable: true, defaultValue: null, modelName: dnID )
• dnType ( type: esriFieldTypeString, alias: Downstream asset type, editable: true, nullable: true, length: 20, defaultValue: null, modelName: dnType )
• 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... )
• lvinspOpLeave ( type: esriFieldTypeString, alias: Last visit operational on leaving, editable: true, nullable: true, length: 30, defaultValue: Not Set, modelName: lvinspOpLeave )
• 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 , Coded Values: [15: 15 Mins] , [30: 30 Mins] , [45: 45 Mins] , ...5 more... )
• lvinspJetComment ( type: esriFieldTypeString, alias: Jetting related comments, editable: true, nullable: true, length: 255, defaultValue: null, modelName: lvinspJetComment )
• lvinspComments ( type: esriFieldTypeString, alias: Last inspection comments, editable: true, nullable: true, length: 350, 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... )
• lvcondition ( type: esriFieldTypeSmallInteger, alias: Condition, editable: true, nullable: true, defaultValue: 99, modelName: lvcondition , Coded Values: [99: Not Set] , [0: Good] , [1: Average] , ...4 more... )
• lineString ( type: esriFieldTypeString, alias: Line string, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: lineString )
• 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 )
• Shape__Length ( type: esriFieldTypeDouble, alias: SHAPE.STLength(), editable: false, nullable: true, defaultValue: null, modelName: SHAPE.STLength(), required: true )
• adHocWorks ( type: esriFieldTypeString, alias: Ad Hoc Works, editable: true, nullable: true, length: 40, defaultValue: null, modelName: adHocWorks )

Templates:

• Name: SCC_ASSET_CH
  Description:
  Prototype:
  sourceGlobalID: null
  lineString: null
  adHocWorks: null
  externalID: null
  assetType: null
  roadName: null
  roadClassNo: null
  tmRequiredCrew: Not Set
  tmRequiredAdmin: Not Set
  esu: null
  usrn: null
  ward: null
  parish: null
  district: null
  maintainedBy: Local Authority
  archiveReason: null
  lvInspArcReason: New Asset
  cycle: 96
  highSpeed: null
  floodzone: 0
  material: null
  diameter: null
  lining: Not Set
  usage: null
  upID: null
  upType: null
  dnID: null
  dnType: null
  lvinspWorkType: Not Set
  lvinspUser: Not Set
  lvinspAccessible: Not Set
  lvinspOpLeave: Not Set
  lvinspCleaned: Not Set
  lvinspJetted: Not Set
  lvinspJetTime: null
  lvinspJetComment: null
  lvinspComments: null
  lvinspDate: null
  lvinspDefect: Not Set
  lvcondition: 99
  
  Drawing Tool: esriFeatureEditToolLine

Relationships:

• ASSET_CH_INSP (0) -- Related To: SCC_ASSET_CH_INSP (20)

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