Layers:

Layer: SCC_ASSET_CH (0)

Name: SCC_ASSET_CH

Display Field: roadName

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description:

Service Item Id: 3efec8729f794e7a86718ff7f5769e14

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

Has Labels: false

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: 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: false
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: true
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: null

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• assetID ( type: esriFieldTypeInteger, alias: Asset ID )
• externalID ( type: esriFieldTypeString, alias: External ID, length: 50 )
• assetType ( type: esriFieldTypeString, alias: Asset type, length: 20 , Coded Values: [AcoDrain: AcoDrain] , [BeanieBlocks: BeanieBlocks] , [Culvert: Culvert] , ...8 more... )
• roadName ( type: esriFieldTypeString, alias: Road name, length: 150 )
• roadClassNo ( type: esriFieldTypeString, alias: Road class number, length: 7 )
• tmRequiredCrew ( type: esriFieldTypeString, alias: Crew suggested TM requirements, length: 30 , 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, length: 30 , 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, length: 14 )
• usrn ( type: esriFieldTypeInteger, alias: USRN )
• ward ( type: esriFieldTypeString, alias: Ward, length: 50 , Coded Values: [Not Set: Not Set] , [Addlestone Bourneside: Addlestone Bourneside] , [Addlestone North: Addlestone North] , ...231 more... )
• parish ( type: esriFieldTypeString, alias: Parish, length: 50 , Coded Values: [Not Set: Not Set] , [Abinger CP: Abinger CP] , [Albury CP: Albury CP] , ...87 more... )
• district ( type: esriFieldTypeString, alias: District, length: 30 , Coded Values: [Not Set: Not Set] , [Elmbridge: Elmbridge] , [Epsom and Ewell: Epsom and Ewell] , ...9 more... )
• maintainedBy ( type: esriFieldTypeString, alias: Maintained by, length: 20 , Coded Values: [Not Set: Not Set] , [Archived: Archived] , [Borough Council: Borough Council] , ...3 more... )
• archiveReason ( type: esriFieldTypeString, alias: Approved archive reason, length: 20 , Coded Values: [Duplicate: Duplicate] , [Not Found: Not Found] , [Not Local Authority: Not Local Authority] , ...1 more... )
• lvInspArcReason ( type: esriFieldTypeString, alias: Crew suggested archive reason, length: 20 )
• cycle ( type: esriFieldTypeSmallInteger, alias: Cycle , Coded Values: [99: Not set] , [6: Six Month] , [12: Annual] , ...3 more... )
• highSpeed ( type: esriFieldTypeString, alias: High Speed Section, length: 7 , Coded Values: [no: no] , [yes: yes] )
• floodzone ( type: esriFieldTypeSmallInteger, alias: Flood zone , Coded Values: [0: Not Set] , [100: 100 years] , [1000: 1000 years] , ...1 more... )
• material ( type: esriFieldTypeString, alias: Material, length: 40 , Coded Values: [Not Set: Not Set] , [Brick: Brick] , [Clay: Clay] , ...4 more... )
• diameter ( type: esriFieldTypeInteger, alias: Diameter )
• lining ( type: esriFieldTypeString, alias: Lining, length: 15 , Coded Values: [Not Set: Not Set] , [All: All] , [None: None] , ...2 more... )
• usage ( type: esriFieldTypeString, alias: Channel usage, length: 20 , Coded Values: [Not Set: Not Set] , [Carrier: Carrier] , [Combined: Combined] , ...5 more... )
• upID ( type: esriFieldTypeInteger, alias: Upstream asset ID )
• upType ( type: esriFieldTypeString, alias: Upstream asset type, length: 20 )
• dnID ( type: esriFieldTypeInteger, alias: Downstream asset ID )
• dnType ( type: esriFieldTypeString, alias: Downstream asset type, length: 20 )
• lvinspWorkType ( type: esriFieldTypeString, alias: Last visit inspection type, length: 20 , Coded Values: [Not Set: Not Set] , [Cyclical: Cyclical] , [CycRemote: Cyclical - Remote] , ...2 more... )
• lvinspUser ( type: esriFieldTypeString, alias: Last inspected by, length: 255 )
• lvinspAccessible ( type: esriFieldTypeString, alias: Access condition, length: 20 , Coded Values: [Not Set: Not Set] , [Excavation Required: Excavation Required] , [Inaccessible: Inaccessible] , ...5 more... )
• lvinspOpLeave ( type: esriFieldTypeString, alias: Last visit operational on leaving, length: 30 )
• lvinspCleaned ( type: esriFieldTypeString, alias: Last visit clean status, length: 7 , Coded Values: [Not Set: Not Set] , [no: no] , [yes: yes] )
• lvinspJetted ( type: esriFieldTypeString, alias: Jetting carried out, length: 7 , Coded Values: [Not Set: Not Set] , [no: no] , [yes: yes] )
• lvinspJetTime ( type: esriFieldTypeSmallInteger, alias: Time spent jetting , Coded Values: [15: 15 Mins] , [30: 30 Mins] , [45: 45 Mins] , ...5 more... )
• lvinspJetComment ( type: esriFieldTypeString, alias: Jetting related comments, length: 255 )
• lvinspComments ( type: esriFieldTypeString, alias: Last inspection comments, length: 350 )
• lvinspDate ( type: esriFieldTypeDate, alias: Last inspected on, length: 8 )
• lvinspDefect ( type: esriFieldTypeString, alias: Last visit defect status, length: 50 , Coded Values: [Not Set: Not Set] , [Ditch Maintenance Required: Ditch Maintenance Required] , [Domestic Refuse: Domestic Refuse] , ...13 more... )
• lvcondition ( type: esriFieldTypeSmallInteger, alias: Condition , Coded Values: [99: Not Set] , [0: Good] , [1: Average] , ...4 more... )
• lineString ( type: esriFieldTypeString, alias: Line string, length: 1073741822 )
• sourceGlobalID ( type: esriFieldTypeGUID, alias: sourceGlobalID, length: 38 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• created_user ( type: esriFieldTypeString, alias: created_user, length: 255 )
• created_date ( type: esriFieldTypeDate, alias: created_date, length: 8 )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, length: 255 )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, length: 8 )
• SHAPE ( type: esriFieldTypeGeometry, alias: SHAPE )
• SHAPE.STLength() ( type: esriFieldTypeDouble, alias: SHAPE.STLength() )
• adHocWorks ( type: esriFieldTypeString, alias: Ad Hoc Works, length: 40 )

Relationships:

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

Layer: SCC_ASSET_CN (1)

Name: SCC_ASSET_CN

Display Field: roadName

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: 3efec8729f794e7a86718ff7f5769e14

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

Has Labels: false

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:
XMin: 501720.05069999956
YMin: 152327.93090000004
XMax: 502913.1032999996
YMax: 161932.83750000037
Spatial Reference: 27700  (27700)  LatestVCSWkid(0)



Drawing Info:
Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [77, 142, 62, 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: false
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: true
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: null

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

Relationships:

• ASSET_CN_INSP (1) -- Related To: SCC_ASSET_CN_INSP (21)

Layer: SCC_ASSET_CP (2)

Name: SCC_ASSET_CP

Display Field: roadName

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: 3efec8729f794e7a86718ff7f5769e14

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

Has Labels: false

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:
XMin: 481561.0
YMin: 132097.17400000058
XMax: 543226.8190000001
YMax: 175095.71199999936
Spatial Reference: 27700  (27700)  LatestVCSWkid(0)



Drawing Info:
Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [87, 175, 168, 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: false
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: true
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: null

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

Relationships:

• ASSET_CP_INSP (2) -- Related To: SCC_ASSET_CP_INSP (22)
• INSP_IRONWORK (3) -- Related To: SCC_ASSETS_INSP_IRONWORK (39)

Layer: SCC_ASSET_CV (3)

Name: SCC_ASSET_CV

Display Field: roadName

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: 3efec8729f794e7a86718ff7f5769e14

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

Has Labels: false

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:
XMin: 481589.0
YMin: 132242.0
XMax: 541799.0
YMax: 172219.32410000078
Spatial Reference: 27700  (27700)  LatestVCSWkid(0)



Drawing Info:
Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [105, 72, 175, 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: false
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: true
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: null

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

Relationships:

• ASSET_CV_INSP (4) -- Related To: SCC_ASSET_CV_INSP (23)

Layer: SCC_ASSET_GN (4)

Name: SCC_ASSET_GN

Display Field: roadName

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: 3efec8729f794e7a86718ff7f5769e14

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

Has Labels: false

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:
XMin: 487976.10500000045
YMin: 148373.26630000025
XMax: 487976.10500000045
YMax: 148373.26630000025
Spatial Reference: 27700  (27700)  LatestVCSWkid(0)



Drawing Info:
Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [175, 171, 77, 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: false
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: true
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: null

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

Relationships:

• ASSET_GN_INSP (5) -- Related To: SCC_ASSET_GN_INSP (24)

Layer: SCC_ASSET_GY (5)

Name: SCC_ASSET_GY

Display Field: roadName

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: 3efec8729f794e7a86718ff7f5769e14

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

Has Labels: false

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:
XMin: 481202.0
YMin: 130801.0
XMax: 544251.0
YMax: 175502.41249999963
Spatial Reference: 27700  (27700)  LatestVCSWkid(0)



Drawing Info:
Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [150, 122, 75, 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: false
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: true
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: null

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

Relationships:

• ASSET_GY_INSP (6) -- Related To: SCC_ASSET_GY_INSP (25)
• INSP_IRONWORK (7) -- Related To: SCC_ASSETS_INSP_IRONWORK (39)

Layer: SCC_ASSET_HB (6)

Name: SCC_ASSET_HB

Display Field: roadName

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: 3efec8729f794e7a86718ff7f5769e14

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

Has Labels: false

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:
XMin: 503353.84520000033
YMin: 159060.45340000093
XMax: 521542.3613
YMax: 171616.4821000006
Spatial Reference: 27700  (27700)  LatestVCSWkid(0)



Drawing Info:
Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [170, 57, 37, 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: false
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: true
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: null

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

Relationships:

• ASSET_HB_INSP (8) -- Related To: SCC_ASSET_HB_INSP (26)

Layer: SCC_ASSET_HW (7)

Name: SCC_ASSET_HW

Display Field: roadName

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: 3efec8729f794e7a86718ff7f5769e14

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

Has Labels: false

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:
XMin: 482065.9118999997
YMin: 132508.06079999916
XMax: 541568.7939999998
YMax: 171578.66410000063
Spatial Reference: 27700  (27700)  LatestVCSWkid(0)



Drawing Info:
Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [153, 58, 70, 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: false
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: true
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: null

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

Relationships:

• ASSET_HW_INSP (9) -- Related To: SCC_ASSET_HW_INSP (27)

Layer: SCC_ASSET_IC (8)

Name: SCC_ASSET_IC

Display Field: roadName

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: 3efec8729f794e7a86718ff7f5769e14

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

Has Labels: false

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:
XMin: 483045.0
YMin: 145277.73299999908
XMax: 536419.8819000004
YMax: 171575.23530000076
Spatial Reference: 27700  (27700)  LatestVCSWkid(0)



Drawing Info:
Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [170, 157, 68, 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: false
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: true
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: null

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

Relationships:

• ASSET_IC_INSP (10) -- Related To: SCC_ASSET_IC_INSP (28)

Layer: SCC_ASSET_IL (9)

Name: SCC_ASSET_IL

Display Field: roadName

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: 3efec8729f794e7a86718ff7f5769e14

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

Has Labels: false

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:
XMin: 490417.6160000004
YMin: 133571.46140000038
XMax: 538978.9691000003
YMax: 172177.30920000002
Spatial Reference: 27700  (27700)  LatestVCSWkid(0)



Drawing Info:
Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [54, 150, 57, 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: false
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: true
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: null

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

Relationships:

• ASSET_IL_INSP (11) -- Related To: SCC_ASSET_IL_INSP (29)

Layer: SCC_ASSET_MH (10)

Name: SCC_ASSET_MH

Display Field: roadName

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: 3efec8729f794e7a86718ff7f5769e14

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

Has Labels: false

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:
XMin: 481332.33999999985
YMin: 131219.70289999992
XMax: 542324.0
YMax: 174992.5360000003
Spatial Reference: 27700  (27700)  LatestVCSWkid(0)



Drawing Info:
Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [132, 64, 93, 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: false
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: true
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: null

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

Relationships:

• ASSET_MH_INSP (12) -- Related To: SCC_ASSET_MH_INSP (30)

Layer: SCC_ASSET_OF (11)

Name: SCC_ASSET_OF

Display Field: roadName

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: 3efec8729f794e7a86718ff7f5769e14

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

Has Labels: false

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:
XMin: 484064.5898000002
YMin: 139102.66090000048
XMax: 536419.7093000002
YMax: 171476.4503000006
Spatial Reference: 27700  (27700)  LatestVCSWkid(0)



Drawing Info:
Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [168, 123, 82, 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: false
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: true
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: null

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

Relationships:

• ASSET_OF_INSP (13) -- Related To: SCC_ASSET_OF_INSP (31)

Layer: SCC_ASSET_OL (12)

Name: SCC_ASSET_OL

Display Field: roadName

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: 3efec8729f794e7a86718ff7f5769e14

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

Has Labels: false

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:
XMin: 482560.23280000035
YMin: 132507.3563000001
XMax: 532176.0
YMax: 172178.61519999988
Spatial Reference: 27700  (27700)  LatestVCSWkid(0)



Drawing Info:
Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [63, 98, 132, 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: false
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: true
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: null

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

Relationships:

• ASSET_OL_INSP (14) -- Related To: SCC_ASSET_OL_INSP (32)

Layer: SCC_ASSET_PS (13)

Name: SCC_ASSET_PS

Display Field: roadName

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: 3efec8729f794e7a86718ff7f5769e14

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

Has Labels: false

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:
XMin: 498999.21779999975
YMin: 151000.55760000087
XMax: 502818.2402999997
YMax: 171048.76479999907
Spatial Reference: 27700  (27700)  LatestVCSWkid(0)



Drawing Info:
Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [135, 67, 82, 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: false
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: true
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: null

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

Relationships:

• ASSET_PS_INSP (15) -- Related To: SCC_ASSET_PS_INSP (33)

Layer: SCC_ASSET_RE (14)

Name: SCC_ASSET_RE

Display Field: roadName

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: 3efec8729f794e7a86718ff7f5769e14

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

Has Labels: false

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:
XMin: 494479.63939999975
YMin: 144201.7957000006
XMax: 529027.6798
YMax: 169313.4254999999
Spatial Reference: 27700  (27700)  LatestVCSWkid(0)



Drawing Info:
Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [158, 74, 141, 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: false
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: true
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: null

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

Relationships:

• ASSET_RE_INSP (16) -- Related To: SCC_ASSET_RE_INSP (34)

Layer: SCC_ASSET_SA (15)

Name: SCC_ASSET_SA

Display Field: roadName

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: 3efec8729f794e7a86718ff7f5769e14

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

Has Labels: false

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:
XMin: 482541.9199999999
YMin: 132868.6649999991
XMax: 542299.0
YMax: 175197.75840000063
Spatial Reference: 27700  (27700)  LatestVCSWkid(0)



Drawing Info:
Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [96, 158, 49, 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: false
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: true
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: null

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• assetID ( type: esriFieldTypeInteger, alias: Asset ID )
• externalID ( type: esriFieldTypeString, alias: External ID, length: 50 )
• assetType ( type: esriFieldTypeString, alias: Asset type, length: 20 , Coded Values: [AcoDrain: AcoDrain] , [BeanieBlocks: BeanieBlocks] , [Catchpit: Catchpit] , ...24 more... )
• roadName ( type: esriFieldTypeString, alias: Road name, length: 150 )
• roadClassNo ( type: esriFieldTypeString, alias: Road class number, length: 7 )
• tmRequiredCrew ( type: esriFieldTypeString, alias: Crew suggested TM requirements, length: 30 , 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, length: 30 , 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, length: 30 , 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, length: 14 )
• usrn ( type: esriFieldTypeInteger, alias: USRN )
• ward ( type: esriFieldTypeString, alias: Ward, length: 50 , Coded Values: [Not Set: Not Set] , [Addlestone Bourneside: Addlestone Bourneside] , [Addlestone North: Addlestone North] , ...231 more... )
• parish ( type: esriFieldTypeString, alias: Parish, length: 50 , Coded Values: [Not Set: Not Set] , [Abinger CP: Abinger CP] , [Albury CP: Albury CP] , ...87 more... )
• district ( type: esriFieldTypeString, alias: District, length: 30 , Coded Values: [Not Set: Not Set] , [Elmbridge: Elmbridge] , [Epsom and Ewell: Epsom and Ewell] , ...9 more... )
• districtSchedule ( type: esriFieldTypeString, alias: Schedule district, length: 30 , Coded Values: [Not Set: Not Set] , [Elmbridge: Elmbridge] , [Epsom and Ewell: Epsom and Ewell] , ...9 more... )
• maintainedBy ( type: esriFieldTypeString, alias: Maintained by, length: 20 , Coded Values: [Not Set: Not Set] , [Archived: Archived] , [Borough Council: Borough Council] , ...3 more... )
• archiveReason ( type: esriFieldTypeString, alias: Approved archive reason, length: 20 , Coded Values: [Duplicate: Duplicate] , [Not Found: Not Found] , [Not Local Authority: Not Local Authority] , ...1 more... )
• lvInspArcReason ( type: esriFieldTypeString, alias: Crew suggested archive reason, length: 20 , Coded Values: [Duplicate: Duplicate] , [Not Found: Not Found] , [Not Local Authority: Not Local Authority] , ...1 more... )
• cycle ( type: esriFieldTypeSmallInteger, alias: Cycle , Coded Values: [99: Not set] , [6: Six Month] , [12: Annual] , ...3 more... )
• highSpeed ( type: esriFieldTypeString, alias: High Speed Section, length: 7 , Coded Values: [no: no] , [yes: yes] )
• targetDate ( type: esriFieldTypeDate, alias: Target date of next inspection, length: 8 )
• progType ( type: esriFieldTypeString, alias: Programme type, length: 20 , Coded Values: [Not Set: Not Set] , [Adhoc: Adhoc] , [Cyclical: Cyclical] , ...2 more... )
• priority ( type: esriFieldTypeSmallInteger, alias: Priority )
• floodzone ( type: esriFieldTypeSmallInteger, alias: Flood zone , Coded Values: [0: Not Set] , [100: 100 years] , [1000: 1000 years] , ...1 more... )
• gullyType ( type: esriFieldTypeString, alias: Type of gully, length: 20 , Coded Values: [Not Set: Not Set] , [Chute: Chute] , [Costa: Costa] , ...12 more... )
• lvinspWorkType ( type: esriFieldTypeString, alias: Last visit inspection type, length: 20 , Coded Values: [Not Set: Not Set] , [Cyclical: Cyclical] , [CycRemote: Cyclical - Remote] , ...2 more... )
• lvinspUser ( type: esriFieldTypeString, alias: Last inspected by, length: 255 )
• lvinspAccessible ( type: esriFieldTypeString, alias: Access condition, length: 20 , Coded Values: [Not Set: Not Set] , [Excavation Required: Excavation Required] , [Inaccessible: Inaccessible] , ...5 more... )
• lvinspSilt ( type: esriFieldTypeSmallInteger, alias: Last visit depth to Base after Clean (mm) )
• lvCoverCon ( type: esriFieldTypeString, alias: Cover condition when last visited, length: 20 , 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, length: 30 , Coded Values: [Not Set: Not Set] , [No: No] , [Slow Runner: Slow Runner] , ...1 more... )
• lvinspCleaned ( type: esriFieldTypeString, alias: Last visit clean status, length: 7 , Coded Values: [Not Set: Not Set] , [no: no] , [yes: yes] )
• lvinspJetted ( type: esriFieldTypeString, alias: Jetting carried out, length: 7 , Coded Values: [Not Set: Not Set] , [no: no] , [yes: yes] )
• lvinspJetTime ( type: esriFieldTypeSmallInteger, alias: Time spent jetting )
• lvinspJetComment ( type: esriFieldTypeString, alias: Jetting related comments, length: 460 )
• lvinspComments ( type: esriFieldTypeString, alias: Last inspection comments, length: 680 )
• lvinspAP2 ( type: esriFieldTypeString, alias: Last visit AP2 required, length: 7 , Coded Values: [Not Set: Not Set] , [no: no] , [yes: yes] )
• lvinspWeep ( type: esriFieldTypeString, alias: Last visit weep holes cleaned, length: 10 )
• lvinspDate ( type: esriFieldTypeDate, alias: Last inspected on, length: 8 )
• lvinspDefect ( type: esriFieldTypeString, alias: Last visit defect status, length: 50 , 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, length: 8 )
• POINT_X ( type: esriFieldTypeDouble, alias: Easting )
• POINT_Y ( type: esriFieldTypeDouble, alias: Northing )
• sourceGlobalID ( type: esriFieldTypeGUID, alias: sourceGlobalID, length: 38 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• created_user ( type: esriFieldTypeString, alias: created_user, length: 255 )
• created_date ( type: esriFieldTypeDate, alias: created_date, length: 8 )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, length: 255 )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, length: 8 )
• SHAPE ( type: esriFieldTypeGeometry, alias: SHAPE )
• lvinspAP2Used ( type: esriFieldTypeString, alias: Last visit AP2 used, length: 7 , Coded Values: [Not Set: Not Set] , [no: no] , [yes: yes] )
• adHocWorks ( type: esriFieldTypeString, alias: Ad Hoc Works, length: 40 )

Relationships:

• INSP_IRONWORK (17) -- Related To: SCC_ASSETS_INSP_IRONWORK (39)
• ASSET_SA_INSP (18) -- Related To: SCC_ASSET_SA_INSP (35)

Layer: SCC_ASSET_TS (16)

Name: SCC_ASSET_TS

Display Field: roadName

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: 3efec8729f794e7a86718ff7f5769e14

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

Has Labels: false

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: 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: false
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: true
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: null

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

Relationships:

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

Layer: Network (17)

Name: Network

Display Field: ROADNAME

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description:

Service Item Id: 3efec8729f794e7a86718ff7f5769e14

Copyright Text:

Default Visibility: false

MaxRecordCount: 200000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0.0

Max Scale: 0.0

Supports Advanced Queries: true

Supports Statistics: true

Has Labels: false

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:
XMin: 480703.7559999991
YMin: 131049.99999999814
XMax: 548422.0166999986
YMax: 176173.99999999814
Spatial Reference: 27700  (27700)  LatestVCSWkid(0)



Drawing Info:
Renderer:
Simple Renderer:
Symbol:
Style: esriSLSSolid
Color: [150, 36, 79, 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: false
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: true
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

Fields:
• ESU ( type: esriFieldTypeString, alias: ESU, length: 14 )
• USRN ( type: esriFieldTypeString, alias: USRN, length: 9 )
• highSpeed ( type: esriFieldTypeString, alias: High Speed Section, length: 7 , Coded Values: [no: no] , [yes: yes] )
• cycle ( type: esriFieldTypeSmallInteger, alias: cycle , Coded Values: [99: Not set] , [6: Six Month] , [12: Annual] , ...3 more... )
• progType ( type: esriFieldTypeString, alias: Programme type, length: 20 , Coded Values: [Not Set: Not Set] , [Adhoc: Adhoc] , [Cyclical: Cyclical] , ...2 more... )
• ROADNAME ( type: esriFieldTypeString, alias: ROADNAME, length: 150 )
• DISTRICT ( type: esriFieldTypeString, alias: DISTRICT, length: 20 )
• districtSchedule ( type: esriFieldTypeString, alias: schedulingDistrict, length: 30 , Coded Values: [Not Set: Not Set] , [Elmbridge: Elmbridge] , [Epsom and Ewell: Epsom and Ewell] , ...9 more... )
• POSTTOWN ( type: esriFieldTypeString, alias: POSTTOWN, length: 20 )
• VILLAGE ( type: esriFieldTypeString, alias: VILLAGE, length: 30 )
• DIRECTION ( type: esriFieldTypeString, alias: DIRECTION, length: 10 )
• SPEEDLIMIT ( type: esriFieldTypeString, alias: SPEEDLIMIT, length: 10 )
• LANES ( type: esriFieldTypeString, alias: LANES, length: 10 )
• ROAD_TYPE ( type: esriFieldTypeString, alias: ROAD_TYPE, length: 21 )
• PUBLIC_MAINT ( type: esriFieldTypeString, alias: PUBLIC_MAINT, length: 3 )
• MAINTAINED_BY ( type: esriFieldTypeString, alias: MAINTAINED_BY, length: 30 )
• DUAL ( type: esriFieldTypeString, alias: DUAL, length: 4 )
• TRUNK ( type: esriFieldTypeString, alias: TRUNK, length: 1 )
• PRIMARY_ROUTE ( type: esriFieldTypeString, alias: PRIMARY_ROUTE, length: 1 )
• SURFACE ( type: esriFieldTypeString, alias: SURFACE, length: 3 )
• CLASS ( type: esriFieldTypeString, alias: CLASS, length: 2 )
• NUMBER_ ( type: esriFieldTypeString, alias: NUMBER_, length: 7 )
• CLASS_NUMBER ( type: esriFieldTypeString, alias: CLASS_NUMBER, length: 10 )
• SPN_TYPE ( type: esriFieldTypeString, alias: SPN_TYPE, length: 5 )
• SPN_BUS ( type: esriFieldTypeDouble, alias: SPN_BUS )
• SPN_BUS_CONTINUITY ( type: esriFieldTypeDouble, alias: SPN_BUS_CONTINUITY )
• SPN_PROPERTY ( type: esriFieldTypeDouble, alias: SPN_PROPERTY )
• SPN_INDUSTRIAL ( type: esriFieldTypeDouble, alias: SPN_INDUSTRIAL )
• SPN_AE_HOSPITAL ( type: esriFieldTypeDouble, alias: SPN_AE_HOSPITAL )
• SPN_HA_DIVERSION ( type: esriFieldTypeDouble, alias: SPN_HA_DIVERSION )
• SPN_TOURISM ( type: esriFieldTypeDouble, alias: SPN_TOURISM )
• SPN_CONTINUITY ( type: esriFieldTypeDouble, alias: SPN_CONTINUITY )
• SPN_STRATEGIC ( type: esriFieldTypeDouble, alias: SPN_STRATEGIC )
• SPN_CYCLE ( type: esriFieldTypeDouble, alias: SPN_CYCLE )
• SPN_PRIMARY ( type: esriFieldTypeDouble, alias: SPN_PRIMARY )
• SPN_PRIMARY_ADJ ( type: esriFieldTypeDouble, alias: SPN_PRIMARY_ADJ )
• AADT_COUNT ( type: esriFieldTypeInteger, alias: AADT_COUNT )
• SPN_AADT ( type: esriFieldTypeDouble, alias: SPN_AADT )
• SPN_AADT_OVERRIDE ( type: esriFieldTypeDouble, alias: SPN_AADT_OVERRIDE )
• HGV_COUNT ( type: esriFieldTypeInteger, alias: HGV_COUNT )
• SPN_HGV ( type: esriFieldTypeDouble, alias: SPN_HGV )
• SPN_HGV_OVERRIDE ( type: esriFieldTypeDouble, alias: SPN_HGV_OVERRIDE )
• START_DATE ( type: esriFieldTypeDate, alias: START_DATE, length: 8 )
• ROUTE_STATUS ( type: esriFieldTypeString, alias: ROUTE_STATUS, length: 10 )
• LASTUPDATE ( type: esriFieldTypeDate, alias: LASTUPDATE, length: 8 )
• OLD_2012_SPN ( type: esriFieldTypeString, alias: OLD_2012_SPN, length: 2 )
• SPN_BUS_OLD ( type: esriFieldTypeDouble, alias: SPN_BUS_OLD )
• AADT_COUNT_DATE ( type: esriFieldTypeDate, alias: AADT_COUNT_DATE, length: 8 )
• PreviousCalc ( type: esriFieldTypeString, alias: PreviousCalc, length: 5 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• created_user ( type: esriFieldTypeString, alias: created_user, length: 255 )
• created_date ( type: esriFieldTypeDate, alias: created_date, length: 8 )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, length: 255 )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, length: 8 )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• Shape ( type: esriFieldTypeGeometry, alias: Shape )
• Shape.STLength() ( type: esriFieldTypeDouble, alias: Shape.STLength() )
• targetDate ( type: esriFieldTypeDate, alias: targetDate, length: 8 )

Layer: Parishes (18)

Name: Parishes

Display Field: Name

Type: Feature Layer

Geometry Type: esriGeometryPolygon

Description:

Service Item Id: 3efec8729f794e7a86718ff7f5769e14

Copyright Text:

Default Visibility: false

MaxRecordCount: 200000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0.0

Max Scale: 0.0

Supports Advanced Queries: true

Supports Statistics: true

Has Labels: false

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:
XMin: 480501.5033
YMin: 131048.39709999971
XMax: 543813.2993000001
YMax: 175767.69639999978
Spatial Reference: 27700  (27700)  LatestVCSWkid(0)



Drawing Info:
Renderer:
Simple Renderer:
Symbol:
Style: esriSFSSolid
Color: [179, 252, 184, 255]
Outline:
Style: esriSLSSolid
Color: [110, 110, 110, 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: false
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: true
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

Fields:
• Name ( type: esriFieldTypeString, alias: Name, length: 100 )
• Area_Code ( type: esriFieldTypeString, alias: Area_Code, length: 3 )
• Area_Description ( type: esriFieldTypeString, alias: Area_Description, length: 50 )
• File_Name ( type: esriFieldTypeString, alias: File_Name, length: 100 )
• Feature_Serial_Number ( type: esriFieldTypeInteger, alias: Feature_Serial_Number )
• Collection_Serial_Number ( type: esriFieldTypeInteger, alias: Collection_Serial_Number )
• Global_Polygon_ID ( type: esriFieldTypeInteger, alias: Global_Polygon_ID )
• Admin_Unit_ID ( type: esriFieldTypeInteger, alias: Admin_Unit_ID )
• Census_Code ( type: esriFieldTypeString, alias: Census_Code, length: 9 )
• Hectares ( type: esriFieldTypeDouble, alias: Hectares )
• Non_Inland_Area ( type: esriFieldTypeDouble, alias: Non_Inland_Area )
• Area_Type_Code ( type: esriFieldTypeString, alias: Area_Type_Code, length: 2 )
• Area_Type_Description ( type: esriFieldTypeString, alias: Area_Type_Description, length: 25 )
• Non_Area_Type_Code ( type: esriFieldTypeString, alias: Non_Area_Type_Code, length: 3 )
• Non_Area_Type_Description ( type: esriFieldTypeString, alias: Non_Area_Type_Description, length: 36 )
• STLength__ ( type: esriFieldTypeDouble, alias: STLength() )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• created_user ( type: esriFieldTypeString, alias: created_user, length: 255 )
• created_date ( type: esriFieldTypeDate, alias: created_date, length: 8 )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, length: 255 )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, length: 8 )
• Shape ( type: esriFieldTypeGeometry, alias: Shape )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• Shape.STArea() ( type: esriFieldTypeDouble, alias: Shape.STArea() )
• Shape.STLength() ( type: esriFieldTypeDouble, alias: Shape.STLength() )

Layer: Wards (19)

Name: Wards

Display Field: Name

Type: Feature Layer

Geometry Type: esriGeometryPolygon

Description:

Service Item Id: 3efec8729f794e7a86718ff7f5769e14

Copyright Text:

Default Visibility: false

MaxRecordCount: 200000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0.0

Max Scale: 0.0

Supports Advanced Queries: true

Supports Statistics: true

Has Labels: false

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:
XMin: 480501.5033
YMin: 131048.39709999971
XMax: 543813.2993000001
YMax: 175767.69639999978
Spatial Reference: 27700  (27700)  LatestVCSWkid(0)



Drawing Info:
Renderer:
Simple Renderer:
Symbol:
Style: esriSFSSolid
Color: [252, 206, 204, 255]
Outline:
Style: esriSLSSolid
Color: [110, 110, 110, 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: false
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: true
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

Fields:
• Name ( type: esriFieldTypeString, alias: Name, length: 100 )
• Area_Code ( type: esriFieldTypeString, alias: Area_Code, length: 3 )
• Area_Description ( type: esriFieldTypeString, alias: Area_Description, length: 50 )
• File_Name ( type: esriFieldTypeString, alias: File_Name, length: 100 )
• Feature_Serial_Number ( type: esriFieldTypeInteger, alias: Feature_Serial_Number )
• Collection_Serial_Number ( type: esriFieldTypeInteger, alias: Collection_Serial_Number )
• Global_Polygon_ID ( type: esriFieldTypeInteger, alias: Global_Polygon_ID )
• Admin_Unit_ID ( type: esriFieldTypeInteger, alias: Admin_Unit_ID )
• Census_Code ( type: esriFieldTypeString, alias: Census_Code, length: 9 )
• Hectares ( type: esriFieldTypeDouble, alias: Hectares )
• Non_Inland_Area ( type: esriFieldTypeDouble, alias: Non_Inland_Area )
• Area_Type_Code ( type: esriFieldTypeString, alias: Area_Type_Code, length: 2 )
• Area_Type_Description ( type: esriFieldTypeString, alias: Area_Type_Description, length: 25 )
• Non_Area_Type_Code ( type: esriFieldTypeString, alias: Non_Area_Type_Code, length: 3 )
• Non_Area_Type_Description ( type: esriFieldTypeString, alias: Non_Area_Type_Description, length: 36 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• created_user ( type: esriFieldTypeString, alias: created_user, length: 255 )
• created_date ( type: esriFieldTypeDate, alias: created_date, length: 8 )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, length: 255 )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, length: 8 )
• domainCode ( type: esriFieldTypeSmallInteger, alias: domainCode )
• Shape ( type: esriFieldTypeGeometry, alias: Shape )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• Shape.STArea() ( type: esriFieldTypeDouble, alias: Shape.STArea() )
• Shape.STLength() ( type: esriFieldTypeDouble, alias: Shape.STLength() )

Layer: Districts (38)

Name: Districts

Display Field: Name_district

Type: Feature Layer

Geometry Type: esriGeometryPolygon

Description:

Service Item Id: 3efec8729f794e7a86718ff7f5769e14

Copyright Text:

Default Visibility: false

MaxRecordCount: 200000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0.0

Max Scale: 0.0

Supports Advanced Queries: true

Supports Statistics: true

Has Labels: false

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:
XMin: 480500.7999999998
YMin: 131049.75999999978
XMax: 543812.9000000004
YMax: 175769.6099999994
Spatial Reference: 27700  (27700)  LatestVCSWkid(0)



Drawing Info:
Renderer:
Simple Renderer:
Symbol:
Style: esriSFSSolid
Color: [210, 252, 209, 255]
Outline:
Style: esriSLSSolid
Color: [110, 110, 110, 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: false
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: true
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

Fields:
• Website ( type: esriFieldTypeString, alias: Website, length: 50 )
• Code ( type: esriFieldTypeString, alias: Code, length: 9 )
• Name_district ( type: esriFieldTypeString, alias: Name_district, length: 30 , Coded Values: [Not Set: Not Set] , [Elmbridge: Elmbridge] , [Epsom and Ewell: Epsom and Ewell] , ...9 more... )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• created_user ( type: esriFieldTypeString, alias: created_user, length: 255 )
• created_date ( type: esriFieldTypeDate, alias: created_date, length: 8 )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, length: 255 )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, length: 8 )
• domainCode ( type: esriFieldTypeSmallInteger, alias: domainCode )
• Shape ( type: esriFieldTypeGeometry, alias: Shape )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• Shape.STArea() ( type: esriFieldTypeDouble, alias: Shape.STArea() )
• Shape.STLength() ( type: esriFieldTypeDouble, alias: Shape.STLength() )

Tables:

Table: SCC_ASSET_CH_INSP (20)

Name: SCC_ASSET_CH_INSP

Display Field: created_date

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: 3efec8729f794e7a86718ff7f5769e14

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 200000

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
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: true
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true


HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:
• inspAssetNo ( type: esriFieldTypeInteger, alias: Asset ID )
• inspId ( type: esriFieldTypeInteger, alias: Legacy Inspection ID )
• externalID ( type: esriFieldTypeString, alias: External ID, length: 50 )
• inspAssetType ( type: esriFieldTypeString, alias: Asset type, length: 20 , Coded Values: [AcoDrain: AcoDrain] , [BeanieBlocks: BeanieBlocks] , [Catchpit: Catchpit] , ...24 more... )
• crewArcReason ( type: esriFieldTypeString, alias: Crew archive reason, length: 20 , Coded Values: [Local Authority: Yes, Found] , [Not Found: Not Found] , [Duplicate: Duplicate] )
• inspAccessible ( type: esriFieldTypeString, alias: Access condition, length: 20 , Coded Values: [Excavation Required: Excavation Required] , [Inaccessible: Inaccessible] , [OK: OK] , ...4 more... )
• inspTm ( type: esriFieldTypeString, alias: What TM was used, length: 30 , Coded Values: [15 Min Delay Boards: 15 Min Delay Boards] , [2-Way Lights: 2-Way Lights] , [Lane Closure: Lane Closure] , ...8 more... )
• inspWorkType ( type: esriFieldTypeString, alias: Inspection type, length: 20 , Coded Values: [Cyclical: Cyclical] , [CycRemote: Cyclical - Remote] , [Day Works: Day Works] , ...1 more... )
• inspshift ( type: esriFieldTypeString, alias: Day or night shift, length: 12 )
• inspOpArrive ( type: esriFieldTypeString, alias: Operational on arrival, length: 30 , Coded Values: [No: No] , [Slow Runner: Slow Runner] , [Yes: Yes - Junction Flowing] )
• inspGenCon ( type: esriFieldTypeSmallInteger, alias: Condition of structure , Coded Values: [99: Not Set] , [0: Good] , [1: Average] , ...4 more... )
• inspCctv ( type: esriFieldTypeString, alias: CCTV Survey, length: 25 )
• inspSiltDefect ( type: esriFieldTypeString, alias: Specify if defective, length: 40 , Coded Values: [Ditch Maintenance Required: Ditch Maintenance Required] , [Domestic Refuse: Domestic Refuse] , [Excessive Debris: Excessive Debris] , ...12 more... )
• inspRunning ( type: esriFieldTypeString, alias: Running, length: 7 , Coded Values: [no: no] , [yes: yes] )
• inspCleaned ( type: esriFieldTypeString, alias: Drainage cleaned, length: 7 , Coded Values: [no: no] , [yes: yes] )
• inspComments ( type: esriFieldTypeString, alias: Inspection related comments, length: 50 , Coded Values: [3rd Party site blocking access: 3rd Party site blocking access] , [Can't reach with gully boom: Can't reach with gully boom] , [Filled with concrete: Filled with concrete] , ...6 more... )
• inspCommentsOther ( type: esriFieldTypeString, alias: Other inspection related comments, length: 350 )
• inspJetCompleted ( type: esriFieldTypeString, alias: Jetted, length: 7 , Coded Values: [no: no] , [yes: yes] )
• inspJettingTime ( type: esriFieldTypeSmallInteger, alias: Jetting time , Coded Values: [15: 15 Mins] , [30: 30 Mins] , [45: 45 Mins] , ...5 more... )
• inspJettingComments ( type: esriFieldTypeString, alias: Jetting related comments, length: 50 , Coded Values: [No access to jet: No access to jet] , [Suspected collapsed pipe: Suspected collapsed pipe] , [Jetted 1m to blockage: Jetted 1m to blockage] , ...15 more... )
• inspJettingCommentsOther ( type: esriFieldTypeString, alias: Other jetting related comments, length: 255 )
• inspOpLeave ( type: esriFieldTypeString, alias: Was drainage operational on departure, length: 30 , Coded Values: [No: No] , [Slow Runner: Slow Runner] , [Yes: Yes - Junction Flowing] )
• inspPhotoComments ( type: esriFieldTypeString, alias: Photo related comments, length: 255 )
• lineString ( type: esriFieldTypeString, alias: Line string, length: 1073741822 )
• inspRelGlobalID ( type: esriFieldTypeGUID, alias: Asset GlobalID, length: 38 )
• sourceGlobalID ( type: esriFieldTypeGUID, alias: sourceGlobalID, length: 38 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• created_user ( type: esriFieldTypeString, alias: created_user, length: 255 )
• created_date ( type: esriFieldTypeDate, alias: created_date, length: 8 )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, length: 255 )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, length: 8 )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• inspTmReq ( type: esriFieldTypeString, alias: TM is required, length: 30 , Coded Values: [15 Min Delay Boards: 15 Min Delay Boards] , [2-Way Lights: 2-Way Lights] , [Lane Closure: Lane Closure] , ...8 more... )
• duplicate ( type: esriFieldTypeString, alias: duplicate, length: 5 , Coded Values: [no: no] , [yes: yes] )

Relationships:

• ASSET_CH (0) -- Related To: SCC_ASSET_CH (0)

Table: SCC_ASSET_CN_INSP (21)

Name: SCC_ASSET_CN_INSP

Display Field: created_date

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: 3efec8729f794e7a86718ff7f5769e14

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 200000

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
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: true
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true


HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• inspAssetNo ( type: esriFieldTypeInteger, alias: Asset ID )
• inspTargetDate ( type: esriFieldTypeDate, alias: Target date of inspection, length: 8 )
• inspId ( type: esriFieldTypeInteger, alias: Legacy Inspection ID )
• externalID ( type: esriFieldTypeString, alias: External ID, length: 40 )
• inspAssetType ( type: esriFieldTypeString, alias: Asset type, length: 20 , Coded Values: [AcoDrain: AcoDrain] , [BeanieBlocks: BeanieBlocks] , [Catchpit: Catchpit] , ...24 more... )
• crewArcReason ( type: esriFieldTypeString, alias: Crew archive reason, length: 20 , Coded Values: [Local Authority: Yes, Found] , [Not Found: Not Found] , [Duplicate: Duplicate] )
• inspAccessible ( type: esriFieldTypeString, alias: Access condition, length: 20 , Coded Values: [Excavation Required: Excavation Required] , [Inaccessible: Inaccessible] , [OK: OK] , ...4 more... )
• inspTm ( type: esriFieldTypeString, alias: What TM was used, length: 30 , Coded Values: [15 Min Delay Boards: 15 Min Delay Boards] , [2-Way Lights: 2-Way Lights] , [Lane Closure: Lane Closure] , ...8 more... )
• inspWorkType ( type: esriFieldTypeString, alias: Inspection type, length: 20 , Coded Values: [Cyclical: Cyclical] , [CycRemote: Cyclical - Remote] , [Day Works: Day Works] , ...1 more... )
• inspshift ( type: esriFieldTypeString, alias: Day or night shift, length: 12 , Coded Values: [Day shift: Day shift] , [Night shift: Night shift] )
• inspOpArrive ( type: esriFieldTypeString, alias: Operational on arrival, length: 30 , Coded Values: [No: No] , [Slow Runner: Slow Runner] , [Yes: Yes - Junction Flowing] )
• inspGenCon ( type: esriFieldTypeString, alias: Condition of structure, length: 30 , Coded Values: [Average: Average] , [Good: Good] , [Needs Attention / Repair: Needs Attention / Repair] )
• inspCoverCon ( type: esriFieldTypeString, alias: Condition of cover, length: 20 , Coded Values: [Broken Lid: Broken Lid] , [Buried on Arrival: Buried on Arrival] , [Missing: Missing] , ...3 more... )
• inspSiltDefect ( type: esriFieldTypeString, alias: Specify if defective, length: 40 , Coded Values: [Ditch Maintenance Required: Ditch Maintenance Required] , [Domestic Refuse: Domestic Refuse] , [Excessive Debris: Excessive Debris] , ...12 more... )
• inspSiltArrive ( type: esriFieldTypeSmallInteger, alias: Silt Level , Coded Values: [0: 0%] , [25: 25%] , [50: 50%] , ...2 more... )
• inspSiltDepart ( type: esriFieldTypeSmallInteger, alias: Depth to base after clean (%) , Coded Values: [0: 0%] , [25: 25%] , [50: 50%] , ...2 more... )
• inspCleaned ( type: esriFieldTypeString, alias: Drainage cleaned, length: 7 , Coded Values: [no: no] , [yes: yes] )
• inspComments ( type: esriFieldTypeString, alias: Inspection related comments, length: 50 , Coded Values: [3rd Party site blocking access: 3rd Party site blocking access] , [Can't reach with gully boom: Can't reach with gully boom] , [Filled with concrete: Filled with concrete] , ...6 more... )
• inspCommentsOther ( type: esriFieldTypeString, alias: Other inspection related comments, length: 680 )
• inspJetCompleted ( type: esriFieldTypeString, alias: Jetted, length: 7 , Coded Values: [no: no] , [yes: yes] )
• inspJettingTime ( type: esriFieldTypeSmallInteger, alias: Jetting time , Coded Values: [15: 15 Mins] , [30: 30 Mins] , [45: 45 Mins] , ...5 more... )
• inspJettingComments ( type: esriFieldTypeString, alias: Jetting related comments, length: 50 , Coded Values: [No access to jet: No access to jet] , [Suspected collapsed pipe: Suspected collapsed pipe] , [Jetted 1m to blockage: Jetted 1m to blockage] , ...15 more... )
• inspJettingCommentsOther ( type: esriFieldTypeString, alias: Other jetting related comments, length: 1000 )
• inspAP2 ( type: esriFieldTypeString, alias: AP2 required, length: 7 , Coded Values: [no: no] , [yes: yes] )
• inspWeep ( type: esriFieldTypeString, alias: Weep holes cleaned, length: 10 , Coded Values: [Clear: Clear] , [Blocked: Blocked] )
• inspOpLeave ( type: esriFieldTypeString, alias: Was drainage operational on departure, length: 30 , Coded Values: [No: No] , [Slow Runner: Slow Runner] , [Yes: Yes - Junction Flowing] )
• inspPhotoComments ( type: esriFieldTypeString, alias: Photo related comments, length: 700 )
• inspAuditDate ( type: esriFieldTypeDate, alias: Inspection audit date, length: 8 )
• auditState ( type: esriFieldTypeString, alias: Result of audit, length: 7 , Coded Values: [Fail: Fail] , [Pass: Pass] )
• POINT_X ( type: esriFieldTypeDouble, alias: Easting )
• POINT_Y ( type: esriFieldTypeDouble, alias: Northing )
• inspRelGlobalID ( type: esriFieldTypeGUID, alias: Asset GlobalID, length: 38 )
• sourceGlobalID ( type: esriFieldTypeGUID, alias: sourceGlobalID, length: 38 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• created_user ( type: esriFieldTypeString, alias: created_user, length: 255 )
• created_date ( type: esriFieldTypeDate, alias: created_date, length: 8 )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, length: 255 )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, length: 8 )
• inspTmReq ( type: esriFieldTypeString, alias: TM is required, length: 30 , Coded Values: [15 Min Delay Boards: 15 Min Delay Boards] , [2-Way Lights: 2-Way Lights] , [Lane Closure: Lane Closure] , ...8 more... )
• duplicate ( type: esriFieldTypeString, alias: duplicate, length: 5 , Coded Values: [no: no] , [yes: yes] )

Relationships:

• ASSET_CN (1) -- Related To: SCC_ASSET_CN (1)

Table: SCC_ASSET_CP_INSP (22)

Name: SCC_ASSET_CP_INSP

Display Field: created_date

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: 3efec8729f794e7a86718ff7f5769e14

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 200000

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
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: true
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true


HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• inspAssetNo ( type: esriFieldTypeInteger, alias: Asset ID )
• inspTargetDate ( type: esriFieldTypeDate, alias: Target date of inspection, length: 8 )
• inspId ( type: esriFieldTypeInteger, alias: Legacy Inspection ID )
• externalID ( type: esriFieldTypeString, alias: External ID, length: 40 )
• inspAssetType ( type: esriFieldTypeString, alias: Asset type, length: 20 , Coded Values: [AcoDrain: AcoDrain] , [BeanieBlocks: BeanieBlocks] , [Catchpit: Catchpit] , ...24 more... )
• crewArcReason ( type: esriFieldTypeString, alias: Crew archive reason, length: 20 , Coded Values: [Local Authority: Yes, Found] , [Not Found: Not Found] , [Duplicate: Duplicate] )
• inspAccessible ( type: esriFieldTypeString, alias: Access condition, length: 20 , Coded Values: [Excavation Required: Excavation Required] , [Inaccessible: Inaccessible] , [OK: OK] , ...4 more... )
• inspTm ( type: esriFieldTypeString, alias: What TM was used, length: 30 , Coded Values: [15 Min Delay Boards: 15 Min Delay Boards] , [2-Way Lights: 2-Way Lights] , [Lane Closure: Lane Closure] , ...8 more... )
• inspWorkType ( type: esriFieldTypeString, alias: Inspection type, length: 20 , Coded Values: [Cyclical: Cyclical] , [CycRemote: Cyclical - Remote] , [Day Works: Day Works] , ...1 more... )
• inspshift ( type: esriFieldTypeString, alias: Day or night shift, length: 12 , Coded Values: [Day shift: Day shift] , [Night shift: Night shift] )
• inspOpArrive ( type: esriFieldTypeString, alias: Operational on arrival, length: 30 , Coded Values: [No: No] , [Slow Runner: Slow Runner] , [Yes: Yes - Junction Flowing] )
• inspGenCon ( type: esriFieldTypeString, alias: Condition of structure, length: 30 , Coded Values: [Average: Average] , [Good: Good] , [Needs Attention / Repair: Needs Attention / Repair] )
• inspCoverCon ( type: esriFieldTypeString, alias: Condition of cover, length: 20 , Coded Values: [Broken Lid: Broken Lid] , [Buried on Arrival: Buried on Arrival] , [Missing: Missing] , ...3 more... )
• inspSiltDefect ( type: esriFieldTypeString, alias: Specify if defective, length: 40 , Coded Values: [Ditch Maintenance Required: Ditch Maintenance Required] , [Domestic Refuse: Domestic Refuse] , [Excessive Debris: Excessive Debris] , ...12 more... )
• inspSiltArrive ( type: esriFieldTypeSmallInteger, alias: Silt Level , Coded Values: [0: 0%] , [25: 25%] , [50: 50%] , ...2 more... )
• inspSiltDepart ( type: esriFieldTypeSmallInteger, alias: Depth to Base after Clean (%) , Coded Values: [0: 0%] , [25: 25%] , [50: 50%] , ...2 more... )
• inspCleaned ( type: esriFieldTypeString, alias: Drainage cleaned, length: 7 , Coded Values: [no: no] , [yes: yes] )
• inspComments ( type: esriFieldTypeString, alias: Inspection related comments, length: 50 , Coded Values: [3rd Party site blocking access: 3rd Party site blocking access] , [Can't reach with gully boom: Can't reach with gully boom] , [Filled with concrete: Filled with concrete] , ...6 more... )
• inspCommentsOther ( type: esriFieldTypeString, alias: Other inspection related comments, length: 680 )
• inspJetCompleted ( type: esriFieldTypeString, alias: Jetted, length: 7 , Coded Values: [no: no] , [yes: yes] )
• inspJettingTime ( type: esriFieldTypeSmallInteger, alias: Jetting time , Coded Values: [15: 15 Mins] , [30: 30 Mins] , [45: 45 Mins] , ...5 more... )
• inspJettingComments ( type: esriFieldTypeString, alias: Jetting related comments, length: 50 , Coded Values: [No access to jet: No access to jet] , [Suspected collapsed pipe: Suspected collapsed pipe] , [Jetted 1m to blockage: Jetted 1m to blockage] , ...15 more... )
• inspJettingCommentsOther ( type: esriFieldTypeString, alias: Other jetting related comments, length: 1000 )
• inspAP2 ( type: esriFieldTypeString, alias: AP2 Required, length: 7 , Coded Values: [no: no] , [yes: yes] )
• inspWeep ( type: esriFieldTypeString, alias: Weep Holes Cleaned, length: 10 , Coded Values: [Clear: Clear] , [Blocked: Blocked] )
• inspOpLeave ( type: esriFieldTypeString, alias: Was drainage operational on departure, length: 30 , Coded Values: [No: No] , [Slow Runner: Slow Runner] , [Yes: Yes - Junction Flowing] )
• inspPhotoComments ( type: esriFieldTypeString, alias: Photo related comments, length: 700 )
• inspAuditDate ( type: esriFieldTypeDate, alias: Inspection audit date, length: 8 )
• auditState ( type: esriFieldTypeString, alias: Result of audit, length: 7 , Coded Values: [Fail: Fail] , [Pass: Pass] )
• POINT_X ( type: esriFieldTypeDouble, alias: Easting )
• POINT_Y ( type: esriFieldTypeDouble, alias: Northing )
• inspRelGlobalID ( type: esriFieldTypeGUID, alias: Asset GlobalID, length: 38 )
• sourceGlobalID ( type: esriFieldTypeGUID, alias: sourceGlobalID, length: 38 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• created_user ( type: esriFieldTypeString, alias: created_user, length: 255 )
• created_date ( type: esriFieldTypeDate, alias: created_date, length: 8 )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, length: 255 )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, length: 8 )
• inspTmReq ( type: esriFieldTypeString, alias: TM is required, length: 30 , Coded Values: [15 Min Delay Boards: 15 Min Delay Boards] , [2-Way Lights: 2-Way Lights] , [Lane Closure: Lane Closure] , ...8 more... )
• duplicate ( type: esriFieldTypeString, alias: duplicate, length: 5 , Coded Values: [no: no] , [yes: yes] )

Relationships:

• ASSETS_INSP_AUDIT (20) -- Related To: SCC_ASSETS_INSP_AUDIT (37)
• ASSET_CP (2) -- Related To: SCC_ASSET_CP (2)

Table: SCC_ASSET_CV_INSP (23)

Name: SCC_ASSET_CV_INSP

Display Field: created_date

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: 3efec8729f794e7a86718ff7f5769e14

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 200000

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
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: true
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true


HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• inspAssetNo ( type: esriFieldTypeInteger, alias: Asset ID )
• inspTargetDate ( type: esriFieldTypeDate, alias: Target date of inspection, length: 8 )
• inspId ( type: esriFieldTypeInteger, alias: Legacy Inspection ID )
• externalID ( type: esriFieldTypeString, alias: External ID, length: 40 )
• inspAssetType ( type: esriFieldTypeString, alias: Asset type, length: 20 , Coded Values: [AcoDrain: AcoDrain] , [BeanieBlocks: BeanieBlocks] , [Catchpit: Catchpit] , ...24 more... )
• crewArcReason ( type: esriFieldTypeString, alias: Crew archive reason, length: 20 , Coded Values: [Local Authority: Yes, Found] , [Not Found: Not Found] , [Duplicate: Duplicate] )
• inspAccessible ( type: esriFieldTypeString, alias: Access condition, length: 20 , Coded Values: [Excavation Required: Excavation Required] , [Inaccessible: Inaccessible] , [OK: OK] , ...4 more... )
• inspTm ( type: esriFieldTypeString, alias: What TM was used, length: 30 , Coded Values: [15 Min Delay Boards: 15 Min Delay Boards] , [2-Way Lights: 2-Way Lights] , [Lane Closure: Lane Closure] , ...8 more... )
• inspWorkType ( type: esriFieldTypeString, alias: Inspection type, length: 20 , Coded Values: [Cyclical: Cyclical] , [CycRemote: Cyclical - Remote] , [Day Works: Day Works] , ...1 more... )
• inspshift ( type: esriFieldTypeString, alias: Day or night shift, length: 12 , Coded Values: [Day shift: Day shift] , [Night shift: Night shift] )
• inspOpArrive ( type: esriFieldTypeString, alias: Operational on arrival, length: 30 , Coded Values: [No: No] , [Slow Runner: Slow Runner] , [Yes: Yes - Junction Flowing] )
• inspGenCon ( type: esriFieldTypeString, alias: Condition of structure, length: 30 , Coded Values: [Average: Average] , [Good: Good] , [Needs Attention / Repair: Needs Attention / Repair] )
• inspCoverCon ( type: esriFieldTypeString, alias: Condition of cover, length: 20 , Coded Values: [Broken Lid: Broken Lid] , [Buried on Arrival: Buried on Arrival] , [Missing: Missing] , ...3 more... )
• inspSiltDefect ( type: esriFieldTypeString, alias: Specify if defective, length: 40 , Coded Values: [Ditch Maintenance Required: Ditch Maintenance Required] , [Domestic Refuse: Domestic Refuse] , [Excessive Debris: Excessive Debris] , ...12 more... )
• inspSiltArrive ( type: esriFieldTypeSmallInteger, alias: Silt Level , Coded Values: [0: 0%] , [25: 25%] , [50: 50%] , ...2 more... )
• inspSiltDepart ( type: esriFieldTypeSmallInteger, alias: Depth to Base after Clean (%) , Coded Values: [0: 0%] , [25: 25%] , [50: 50%] , ...2 more... )
• inspCleaned ( type: esriFieldTypeString, alias: Drainage cleaned, length: 7 , Coded Values: [no: no] , [yes: yes] )
• inspComments ( type: esriFieldTypeString, alias: Inspection related comments, length: 50 , Coded Values: [3rd Party site blocking access: 3rd Party site blocking access] , [Can't reach with gully boom: Can't reach with gully boom] , [Filled with concrete: Filled with concrete] , ...6 more... )
• inspCommentsOther ( type: esriFieldTypeString, alias: Other inspection related comments, length: 680 )
• inspJetCompleted ( type: esriFieldTypeString, alias: Jetted, length: 7 , Coded Values: [no: no] , [yes: yes] )
• inspJettingTime ( type: esriFieldTypeSmallInteger, alias: Jetting time , Coded Values: [15: 15 Mins] , [30: 30 Mins] , [45: 45 Mins] , ...5 more... )
• inspJettingComments ( type: esriFieldTypeString, alias: Jetting related comments, length: 50 , Coded Values: [No access to jet: No access to jet] , [Suspected collapsed pipe: Suspected collapsed pipe] , [Jetted 1m to blockage: Jetted 1m to blockage] , ...15 more... )
• inspJettingCommentsOther ( type: esriFieldTypeString, alias: Other jetting related comments, length: 1000 )
• inspAP2 ( type: esriFieldTypeString, alias: AP2 Required, length: 7 , Coded Values: [no: no] , [yes: yes] )
• inspWeep ( type: esriFieldTypeString, alias: Weep Holes Cleaned, length: 10 , Coded Values: [Clear: Clear] , [Blocked: Blocked] )
• inspOpLeave ( type: esriFieldTypeString, alias: Was drainage operational on departure, length: 30 , Coded Values: [No: No] , [Slow Runner: Slow Runner] , [Yes: Yes - Junction Flowing] )
• inspPhotoComments ( type: esriFieldTypeString, alias: Photo related comments, length: 700 )
• inspAuditDate ( type: esriFieldTypeDate, alias: Inspection audit date, length: 8 )
• auditState ( type: esriFieldTypeString, alias: Result of audit, length: 7 , Coded Values: [Fail: Fail] , [Pass: Pass] )
• POINT_X ( type: esriFieldTypeDouble, alias: Easting )
• POINT_Y ( type: esriFieldTypeDouble, alias: Northing )
• inspRelGlobalID ( type: esriFieldTypeGUID, alias: Asset GlobalID, length: 38 )
• sourceGlobalID ( type: esriFieldTypeGUID, alias: sourceGlobalID, length: 38 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• created_user ( type: esriFieldTypeString, alias: created_user, length: 255 )
• created_date ( type: esriFieldTypeDate, alias: created_date, length: 8 )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, length: 255 )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, length: 8 )
• inspTmReq ( type: esriFieldTypeString, alias: TM is required, length: 30 , Coded Values: [15 Min Delay Boards: 15 Min Delay Boards] , [2-Way Lights: 2-Way Lights] , [Lane Closure: Lane Closure] , ...8 more... )
• duplicate ( type: esriFieldTypeString, alias: duplicate, length: 5 , Coded Values: [no: no] , [yes: yes] )

Relationships:

• ASSET_CV (4) -- Related To: SCC_ASSET_CV (3)

Table: SCC_ASSET_GN_INSP (24)

Name: SCC_ASSET_GN_INSP

Display Field: created_date

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: 3efec8729f794e7a86718ff7f5769e14

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 200000

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
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: true
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true


HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• inspAssetNo ( type: esriFieldTypeInteger, alias: Asset ID )
• inspTargetDate ( type: esriFieldTypeDate, alias: Target date of inspection, length: 8 )
• inspId ( type: esriFieldTypeInteger, alias: Legacy Inspection ID )
• externalID ( type: esriFieldTypeString, alias: External ID, length: 40 )
• inspAssetType ( type: esriFieldTypeString, alias: Asset type, length: 20 , Coded Values: [AcoDrain: AcoDrain] , [BeanieBlocks: BeanieBlocks] , [Catchpit: Catchpit] , ...24 more... )
• crewArcReason ( type: esriFieldTypeString, alias: Crew archive reason, length: 20 , Coded Values: [Local Authority: Yes, Found] , [Not Found: Not Found] , [Duplicate: Duplicate] )
• inspAccessible ( type: esriFieldTypeString, alias: Access condition, length: 20 , Coded Values: [Excavation Required: Excavation Required] , [Inaccessible: Inaccessible] , [OK: OK] , ...4 more... )
• inspTm ( type: esriFieldTypeString, alias: What TM was used, length: 30 , Coded Values: [15 Min Delay Boards: 15 Min Delay Boards] , [2-Way Lights: 2-Way Lights] , [Lane Closure: Lane Closure] , ...8 more... )
• inspWorkType ( type: esriFieldTypeString, alias: Inspection type, length: 20 , Coded Values: [Cyclical: Cyclical] , [CycRemote: Cyclical - Remote] , [Day Works: Day Works] , ...1 more... )
• inspshift ( type: esriFieldTypeString, alias: Day or night shift, length: 12 , Coded Values: [Day shift: Day shift] , [Night shift: Night shift] )
• inspOpArrive ( type: esriFieldTypeString, alias: Operational on arrival, length: 30 , Coded Values: [No: No] , [Slow Runner: Slow Runner] , [Yes: Yes - Junction Flowing] )
• inspGenCon ( type: esriFieldTypeString, alias: Condition of structure, length: 30 , Coded Values: [Average: Average] , [Good: Good] , [Needs Attention / Repair: Needs Attention / Repair] )
• inspCoverCon ( type: esriFieldTypeString, alias: Condition of cover, length: 20 , Coded Values: [Broken Lid: Broken Lid] , [Buried on Arrival: Buried on Arrival] , [Missing: Missing] , ...3 more... )
• inspSiltDefect ( type: esriFieldTypeString, alias: Specify if defective, length: 40 , Coded Values: [Ditch Maintenance Required: Ditch Maintenance Required] , [Domestic Refuse: Domestic Refuse] , [Excessive Debris: Excessive Debris] , ...12 more... )
• inspSiltArrive ( type: esriFieldTypeSmallInteger, alias: Silt Level , Coded Values: [0: 0%] , [25: 25%] , [50: 50%] , ...2 more... )
• inspSiltDepart ( type: esriFieldTypeSmallInteger, alias: Depth to Base after Clean (%) , Coded Values: [0: 0%] , [25: 25%] , [50: 50%] , ...2 more... )
• inspCleaned ( type: esriFieldTypeString, alias: Drainage cleaned, length: 7 , Coded Values: [no: no] , [yes: yes] )
• inspComments ( type: esriFieldTypeString, alias: Inspection related comments, length: 50 , Coded Values: [3rd Party site blocking access: 3rd Party site blocking access] , [Can't reach with gully boom: Can't reach with gully boom] , [Filled with concrete: Filled with concrete] , ...6 more... )
• inspCommentsOther ( type: esriFieldTypeString, alias: Other inspection related comments, length: 680 )
• inspJetCompleted ( type: esriFieldTypeString, alias: Jetted, length: 7 , Coded Values: [no: no] , [yes: yes] )
• inspJettingTime ( type: esriFieldTypeSmallInteger, alias: Jetting time , Coded Values: [15: 15 Mins] , [30: 30 Mins] , [45: 45 Mins] , ...5 more... )
• inspJettingComments ( type: esriFieldTypeString, alias: Jetting related comments, length: 50 , Coded Values: [No access to jet: No access to jet] , [Suspected collapsed pipe: Suspected collapsed pipe] , [Jetted 1m to blockage: Jetted 1m to blockage] , ...15 more... )
• inspJettingCommentsOther ( type: esriFieldTypeString, alias: Other jetting related comments, length: 1000 )
• inspAP2 ( type: esriFieldTypeString, alias: AP2 Required, length: 7 , Coded Values: [no: no] , [yes: yes] )
• inspWeep ( type: esriFieldTypeString, alias: Weep Holes Cleaned, length: 10 , Coded Values: [Clear: Clear] , [Blocked: Blocked] )
• inspOpLeave ( type: esriFieldTypeString, alias: Was drainage operational on departure, length: 30 , Coded Values: [No: No] , [Slow Runner: Slow Runner] , [Yes: Yes - Junction Flowing] )
• inspPhotoComments ( type: esriFieldTypeString, alias: Photo related comments, length: 700 )
• inspAuditDate ( type: esriFieldTypeDate, alias: Inspection audit date, length: 8 )
• auditState ( type: esriFieldTypeString, alias: Result of audit, length: 7 , Coded Values: [Fail: Fail] , [Pass: Pass] )
• POINT_X ( type: esriFieldTypeDouble, alias: Easting )
• POINT_Y ( type: esriFieldTypeDouble, alias: Northing )
• inspRelGlobalID ( type: esriFieldTypeGUID, alias: Asset GlobalID, length: 38 )
• sourceGlobalID ( type: esriFieldTypeGUID, alias: sourceGlobalID, length: 38 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• created_user ( type: esriFieldTypeString, alias: created_user, length: 255 )
• created_date ( type: esriFieldTypeDate, alias: created_date, length: 8 )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, length: 255 )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, length: 8 )
• inspTmReq ( type: esriFieldTypeString, alias: TM is required, length: 30 , Coded Values: [15 Min Delay Boards: 15 Min Delay Boards] , [2-Way Lights: 2-Way Lights] , [Lane Closure: Lane Closure] , ...8 more... )
• duplicate ( type: esriFieldTypeString, alias: duplicate, length: 5 , Coded Values: [no: no] , [yes: yes] )

Relationships:

• ASSET_GN (5) -- Related To: SCC_ASSET_GN (4)

Table: SCC_ASSET_GY_INSP (25)

Name: SCC_ASSET_GY_INSP

Display Field: created_date

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: 3efec8729f794e7a86718ff7f5769e14

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 200000

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
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: true
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true


HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• inspAssetNo ( type: esriFieldTypeInteger, alias: Asset ID )
• inspTargetDate ( type: esriFieldTypeDate, alias: Target date of inspection, length: 8 )
• inspId ( type: esriFieldTypeInteger, alias: Legacy Inspection ID )
• externalID ( type: esriFieldTypeString, alias: External ID, length: 40 )
• inspAssetType ( type: esriFieldTypeString, alias: Asset type, length: 20 , Coded Values: [AcoDrain: AcoDrain] , [BeanieBlocks: BeanieBlocks] , [Catchpit: Catchpit] , ...24 more... )
• crewArcReason ( type: esriFieldTypeString, alias: Crew archive reason, length: 20 , Coded Values: [Local Authority: Yes, Found] , [Not Found: Not Found] , [Duplicate: Duplicate] )
• inspAccessible ( type: esriFieldTypeString, alias: Access condition, length: 20 , Coded Values: [Excavation Required: Excavation Required] , [Inaccessible: Inaccessible] , [OK: OK] , ...4 more... )
• inspTm ( type: esriFieldTypeString, alias: What TM was used, length: 30 , Coded Values: [15 Min Delay Boards: 15 Min Delay Boards] , [2-Way Lights: 2-Way Lights] , [Lane Closure: Lane Closure] , ...8 more... )
• inspWorkType ( type: esriFieldTypeString, alias: Inspection type, length: 20 , Coded Values: [Cyclical: Cyclical] , [CycRemote: Cyclical - Remote] , [Day Works: Day Works] , ...1 more... )
• inspshift ( type: esriFieldTypeString, alias: Day or night shift, length: 12 , Coded Values: [Day shift: Day shift] , [Night shift: Night shift] )
• inspOpArrive ( type: esriFieldTypeString, alias: Operational on arrival, length: 30 , Coded Values: [No: No] , [Slow Runner: Slow Runner] , [Yes: Yes - Junction Flowing] )
• inspGenCon ( type: esriFieldTypeString, alias: Condition of structure, length: 30 , Coded Values: [Average: Average] , [Good: Good] , [Needs Attention / Repair: Needs Attention / Repair] )
• inspCoverCon ( type: esriFieldTypeString, alias: Condition of cover, length: 20 , Coded Values: [Broken Lid: Broken Lid] , [Buried on Arrival: Buried on Arrival] , [Missing: Missing] , ...3 more... )
• inspSiltDefect ( type: esriFieldTypeString, alias: Specify if defective, length: 40 , Coded Values: [Ditch Maintenance Required: Ditch Maintenance Required] , [Domestic Refuse: Domestic Refuse] , [Excessive Debris: Excessive Debris] , ...12 more... )
• inspSiltArrive ( type: esriFieldTypeSmallInteger, alias: Silt Level , Coded Values: [0: 0%] , [25: 25%] , [50: 50%] , ...2 more... )
• inspSiltDepart ( type: esriFieldTypeSmallInteger, alias: Depth to Base after Clean (%) , Coded Values: [0: 0%] , [25: 25%] , [50: 50%] , ...2 more... )
• inspCleaned ( type: esriFieldTypeString, alias: Drainage cleaned, length: 7 , Coded Values: [no: no] , [yes: yes] )
• inspComments ( type: esriFieldTypeString, alias: Inspection related comments, length: 50 , Coded Values: [3rd Party site blocking access: 3rd Party site blocking access] , [Can't reach with gully boom: Can't reach with gully boom] , [Filled with concrete: Filled with concrete] , ...6 more... )
• inspCommentsOther ( type: esriFieldTypeString, alias: Other inspection related comments, length: 680 )
• inspJetCompleted ( type: esriFieldTypeString, alias: Jetted, length: 7 , Coded Values: [no: no] , [yes: yes] )
• inspJettingTime ( type: esriFieldTypeSmallInteger, alias: Jetting time , Coded Values: [15: 15 Mins] , [30: 30 Mins] , [45: 45 Mins] , ...5 more... )
• inspJettingComments ( type: esriFieldTypeString, alias: Jetting related comments, length: 50 , Coded Values: [No access to jet: No access to jet] , [Suspected collapsed pipe: Suspected collapsed pipe] , [Jetted 1m to blockage: Jetted 1m to blockage] , ...15 more... )
• inspJettingCommentsOther ( type: esriFieldTypeString, alias: Other jetting related comments, length: 1000 )
• inspAP2 ( type: esriFieldTypeString, alias: AP2 Required, length: 7 , Coded Values: [no: no] , [yes: yes] )
• inspWeep ( type: esriFieldTypeString, alias: Weep Holes Cleaned, length: 10 , Coded Values: [Clear: Clear] , [Blocked: Blocked] )
• inspOpLeave ( type: esriFieldTypeString, alias: Was drainage operational on departure, length: 30 , Coded Values: [No: No] , [Slow Runner: Slow Runner] , [Yes: Yes - Junction Flowing] )
• inspPhotoComments ( type: esriFieldTypeString, alias: Photo related comments, length: 700 )
• inspAuditDate ( type: esriFieldTypeDate, alias: Inspection audit date, length: 8 )
• auditState ( type: esriFieldTypeString, alias: Result of audit, length: 7 , Coded Values: [Fail: Fail] , [Pass: Pass] )
• POINT_X ( type: esriFieldTypeDouble, alias: Easting )
• POINT_Y ( type: esriFieldTypeDouble, alias: Northing )
• inspRelGlobalID ( type: esriFieldTypeGUID, alias: Asset GlobalID, length: 38 )
• sourceGlobalID ( type: esriFieldTypeGUID, alias: sourceGlobalID, length: 38 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• created_user ( type: esriFieldTypeString, alias: created_user, length: 255 )
• created_date ( type: esriFieldTypeDate, alias: created_date, length: 8 )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, length: 255 )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, length: 8 )
• inspTmReq ( type: esriFieldTypeString, alias: TM is required, length: 30 , Coded Values: [15 Min Delay Boards: 15 Min Delay Boards] , [2-Way Lights: 2-Way Lights] , [Lane Closure: Lane Closure] , ...8 more... )
• duplicate ( type: esriFieldTypeString, alias: duplicate, length: 5 , Coded Values: [no: no] , [yes: yes] )

Relationships:

• ASSETS_INSP_AUDIT (21) -- Related To: SCC_ASSETS_INSP_AUDIT (37)
• ASSET_GY (6) -- Related To: SCC_ASSET_GY (5)

Table: SCC_ASSET_HB_INSP (26)

Name: SCC_ASSET_HB_INSP

Display Field: created_date

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: 3efec8729f794e7a86718ff7f5769e14

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 200000

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
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: true
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true


HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• inspAssetNo ( type: esriFieldTypeInteger, alias: Asset ID )
• inspTargetDate ( type: esriFieldTypeDate, alias: Target date of inspection, length: 8 )
• inspId ( type: esriFieldTypeInteger, alias: Legacy Inspection ID )
• externalID ( type: esriFieldTypeString, alias: External ID, length: 40 )
• inspAssetType ( type: esriFieldTypeString, alias: Asset type, length: 20 , Coded Values: [AcoDrain: AcoDrain] , [BeanieBlocks: BeanieBlocks] , [Catchpit: Catchpit] , ...24 more... )
• crewArcReason ( type: esriFieldTypeString, alias: Crew archive reason, length: 20 , Coded Values: [Local Authority: Yes, Found] , [Not Found: Not Found] , [Duplicate: Duplicate] )
• inspAccessible ( type: esriFieldTypeString, alias: Access condition, length: 20 , Coded Values: [Excavation Required: Excavation Required] , [Inaccessible: Inaccessible] , [OK: OK] , ...4 more... )
• inspTm ( type: esriFieldTypeString, alias: What TM was used, length: 30 , Coded Values: [15 Min Delay Boards: 15 Min Delay Boards] , [2-Way Lights: 2-Way Lights] , [Lane Closure: Lane Closure] , ...8 more... )
• inspWorkType ( type: esriFieldTypeString, alias: Inspection type, length: 20 , Coded Values: [Cyclical: Cyclical] , [CycRemote: Cyclical - Remote] , [Day Works: Day Works] , ...1 more... )
• inspshift ( type: esriFieldTypeString, alias: Day or night shift, length: 12 , Coded Values: [Day shift: Day shift] , [Night shift: Night shift] )
• inspOpArrive ( type: esriFieldTypeString, alias: Operational on arrival, length: 30 , Coded Values: [No: No] , [Slow Runner: Slow Runner] , [Yes: Yes - Junction Flowing] )
• inspGenCon ( type: esriFieldTypeString, alias: Condition of structure, length: 30 , Coded Values: [Average: Average] , [Good: Good] , [Needs Attention / Repair: Needs Attention / Repair] )
• inspCoverCon ( type: esriFieldTypeString, alias: Condition of cover, length: 20 , Coded Values: [Broken Lid: Broken Lid] , [Buried on Arrival: Buried on Arrival] , [Missing: Missing] , ...3 more... )
• inspSiltDefect ( type: esriFieldTypeString, alias: Specify if defective, length: 40 , Coded Values: [Ditch Maintenance Required: Ditch Maintenance Required] , [Domestic Refuse: Domestic Refuse] , [Excessive Debris: Excessive Debris] , ...12 more... )
• inspSiltArrive ( type: esriFieldTypeSmallInteger, alias: Silt Level , Coded Values: [0: 0%] , [25: 25%] , [50: 50%] , ...2 more... )
• inspSiltDepart ( type: esriFieldTypeSmallInteger, alias: Depth to Base after Clean (%) , Coded Values: [0: 0%] , [25: 25%] , [50: 50%] , ...2 more... )
• inspCleaned ( type: esriFieldTypeString, alias: Drainage cleaned, length: 7 , Coded Values: [no: no] , [yes: yes] )
• inspComments ( type: esriFieldTypeString, alias: Inspection related comments, length: 50 , Coded Values: [3rd Party site blocking access: 3rd Party site blocking access] , [Can't reach with gully boom: Can't reach with gully boom] , [Filled with concrete: Filled with concrete] , ...6 more... )
• inspCommentsOther ( type: esriFieldTypeString, alias: Other inspection related comments, length: 680 )
• inspJetCompleted ( type: esriFieldTypeString, alias: Jetted, length: 7 , Coded Values: [no: no] , [yes: yes] )
• inspJettingTime ( type: esriFieldTypeSmallInteger, alias: Jetting time , Coded Values: [15: 15 Mins] , [30: 30 Mins] , [45: 45 Mins] , ...5 more... )
• inspJettingComments ( type: esriFieldTypeString, alias: Jetting related comments, length: 50 , Coded Values: [No access to jet: No access to jet] , [Suspected collapsed pipe: Suspected collapsed pipe] , [Jetted 1m to blockage: Jetted 1m to blockage] , ...15 more... )
• inspJettingCommentsOther ( type: esriFieldTypeString, alias: Other jetting related comments, length: 1000 )
• inspAP2 ( type: esriFieldTypeString, alias: AP2 Required, length: 7 , Coded Values: [no: no] , [yes: yes] )
• inspWeep ( type: esriFieldTypeString, alias: Weep Holes Cleaned, length: 10 , Coded Values: [Clear: Clear] , [Blocked: Blocked] )
• inspOpLeave ( type: esriFieldTypeString, alias: Was drainage operational on departure, length: 30 , Coded Values: [No: No] , [Slow Runner: Slow Runner] , [Yes: Yes - Junction Flowing] )
• inspPhotoComments ( type: esriFieldTypeString, alias: Photo related comments, length: 700 )
• inspAuditDate ( type: esriFieldTypeDate, alias: Inspection audit date, length: 8 )
• auditState ( type: esriFieldTypeString, alias: Result of audit, length: 7 , Coded Values: [Fail: Fail] , [Pass: Pass] )
• POINT_X ( type: esriFieldTypeDouble, alias: Easting )
• POINT_Y ( type: esriFieldTypeDouble, alias: Northing )
• inspRelGlobalID ( type: esriFieldTypeGUID, alias: Asset GlobalID, length: 38 )
• sourceGlobalID ( type: esriFieldTypeGUID, alias: sourceGlobalID, length: 38 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• created_user ( type: esriFieldTypeString, alias: created_user, length: 255 )
• created_date ( type: esriFieldTypeDate, alias: created_date, length: 8 )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, length: 255 )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, length: 8 )
• inspTmReq ( type: esriFieldTypeString, alias: TM is required, length: 30 , Coded Values: [15 Min Delay Boards: 15 Min Delay Boards] , [2-Way Lights: 2-Way Lights] , [Lane Closure: Lane Closure] , ...8 more... )
• duplicate ( type: esriFieldTypeString, alias: duplicate, length: 5 , Coded Values: [no: no] , [yes: yes] )

Relationships:

• ASSET_HB (8) -- Related To: SCC_ASSET_HB (6)

Table: SCC_ASSET_HW_INSP (27)

Name: SCC_ASSET_HW_INSP

Display Field: created_date

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: 3efec8729f794e7a86718ff7f5769e14

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 200000

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
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: true
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true


HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• inspAssetNo ( type: esriFieldTypeInteger, alias: Asset ID )
• inspTargetDate ( type: esriFieldTypeDate, alias: Target date of inspection, length: 8 )
• inspId ( type: esriFieldTypeInteger, alias: Legacy Inspection ID )
• externalID ( type: esriFieldTypeString, alias: External ID, length: 40 )
• inspAssetType ( type: esriFieldTypeString, alias: Asset type, length: 20 , Coded Values: [AcoDrain: AcoDrain] , [BeanieBlocks: BeanieBlocks] , [Catchpit: Catchpit] , ...24 more... )
• crewArcReason ( type: esriFieldTypeString, alias: Crew archive reason, length: 20 , Coded Values: [Local Authority: Yes, Found] , [Not Found: Not Found] , [Duplicate: Duplicate] )
• inspAccessible ( type: esriFieldTypeString, alias: Access condition, length: 20 , Coded Values: [Excavation Required: Excavation Required] , [Inaccessible: Inaccessible] , [OK: OK] , ...4 more... )
• inspTm ( type: esriFieldTypeString, alias: What TM was used, length: 30 , Coded Values: [15 Min Delay Boards: 15 Min Delay Boards] , [2-Way Lights: 2-Way Lights] , [Lane Closure: Lane Closure] , ...8 more... )
• inspWorkType ( type: esriFieldTypeString, alias: Inspection type, length: 20 , Coded Values: [Cyclical: Cyclical] , [CycRemote: Cyclical - Remote] , [Day Works: Day Works] , ...1 more... )
• inspshift ( type: esriFieldTypeString, alias: Day or night shift, length: 12 , Coded Values: [Day shift: Day shift] , [Night shift: Night shift] )
• inspOpArrive ( type: esriFieldTypeString, alias: Operational on arrival, length: 30 , Coded Values: [No: No] , [Slow Runner: Slow Runner] , [Yes: Yes - Junction Flowing] )
• inspGenCon ( type: esriFieldTypeString, alias: Condition of structure, length: 30 , Coded Values: [Average: Average] , [Good: Good] , [Needs Attention / Repair: Needs Attention / Repair] )
• inspCoverCon ( type: esriFieldTypeString, alias: Condition of cover, length: 20 , Coded Values: [Broken Lid: Broken Lid] , [Buried on Arrival: Buried on Arrival] , [Missing: Missing] , ...3 more... )
• inspSiltDefect ( type: esriFieldTypeString, alias: Specify if defective, length: 40 , Coded Values: [Ditch Maintenance Required: Ditch Maintenance Required] , [Domestic Refuse: Domestic Refuse] , [Excessive Debris: Excessive Debris] , ...12 more... )
• inspSiltArrive ( type: esriFieldTypeSmallInteger, alias: Silt Level , Coded Values: [0: 0%] , [25: 25%] , [50: 50%] , ...2 more... )
• inspSiltDepart ( type: esriFieldTypeSmallInteger, alias: Depth to Base after Clean (%) , Coded Values: [0: 0%] , [25: 25%] , [50: 50%] , ...2 more... )
• inspCleaned ( type: esriFieldTypeString, alias: Drainage cleaned, length: 7 , Coded Values: [no: no] , [yes: yes] )
• inspComments ( type: esriFieldTypeString, alias: Inspection related comments, length: 50 , Coded Values: [3rd Party site blocking access: 3rd Party site blocking access] , [Can't reach with gully boom: Can't reach with gully boom] , [Filled with concrete: Filled with concrete] , ...6 more... )
• inspCommentsOther ( type: esriFieldTypeString, alias: Other inspection related comments, length: 680 )
• inspJetCompleted ( type: esriFieldTypeString, alias: Jetted, length: 7 , Coded Values: [no: no] , [yes: yes] )
• inspJettingTime ( type: esriFieldTypeSmallInteger, alias: Jetting time , Coded Values: [15: 15 Mins] , [30: 30 Mins] , [45: 45 Mins] , ...5 more... )
• inspJettingComments ( type: esriFieldTypeString, alias: Jetting related comments, length: 50 , Coded Values: [No access to jet: No access to jet] , [Suspected collapsed pipe: Suspected collapsed pipe] , [Jetted 1m to blockage: Jetted 1m to blockage] , ...15 more... )
• inspJettingCommentsOther ( type: esriFieldTypeString, alias: Other jetting related comments, length: 1000 )
• inspAP2 ( type: esriFieldTypeString, alias: AP2 Required, length: 7 , Coded Values: [no: no] , [yes: yes] )
• inspWeep ( type: esriFieldTypeString, alias: Weep Holes Cleaned, length: 10 , Coded Values: [Clear: Clear] , [Blocked: Blocked] )
• inspOpLeave ( type: esriFieldTypeString, alias: Was drainage operational on departure, length: 30 , Coded Values: [No: No] , [Slow Runner: Slow Runner] , [Yes: Yes - Junction Flowing] )
• inspPhotoComments ( type: esriFieldTypeString, alias: Photo related comments, length: 700 )
• inspAuditDate ( type: esriFieldTypeDate, alias: Inspection audit date, length: 8 )
• auditState ( type: esriFieldTypeString, alias: Result of audit, length: 7 , Coded Values: [Fail: Fail] , [Pass: Pass] )
• POINT_X ( type: esriFieldTypeDouble, alias: Easting )
• POINT_Y ( type: esriFieldTypeDouble, alias: Northing )
• inspRelGlobalID ( type: esriFieldTypeGUID, alias: Asset GlobalID, length: 38 )
• sourceGlobalID ( type: esriFieldTypeGUID, alias: sourceGlobalID, length: 38 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• created_user ( type: esriFieldTypeString, alias: created_user, length: 255 )
• created_date ( type: esriFieldTypeDate, alias: created_date, length: 8 )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, length: 255 )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, length: 8 )
• inspTmReq ( type: esriFieldTypeString, alias: TM is required, length: 30 , Coded Values: [15 Min Delay Boards: 15 Min Delay Boards] , [2-Way Lights: 2-Way Lights] , [Lane Closure: Lane Closure] , ...8 more... )
• duplicate ( type: esriFieldTypeString, alias: duplicate, length: 5 , Coded Values: [no: no] , [yes: yes] )

Relationships:

• ASSET_HW (9) -- Related To: SCC_ASSET_HW (7)

Table: SCC_ASSET_IC_INSP (28)

Name: SCC_ASSET_IC_INSP

Display Field: created_date

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: 3efec8729f794e7a86718ff7f5769e14

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 200000

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
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: true
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true


HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• inspAssetNo ( type: esriFieldTypeInteger, alias: Asset ID )
• inspTargetDate ( type: esriFieldTypeDate, alias: Target date of inspection, length: 8 )
• inspId ( type: esriFieldTypeInteger, alias: Legacy Inspection ID )
• externalID ( type: esriFieldTypeString, alias: External ID, length: 40 )
• inspAssetType ( type: esriFieldTypeString, alias: Asset type, length: 20 , Coded Values: [AcoDrain: AcoDrain] , [BeanieBlocks: BeanieBlocks] , [Catchpit: Catchpit] , ...24 more... )
• crewArcReason ( type: esriFieldTypeString, alias: Crew archive reason, length: 20 , Coded Values: [Local Authority: Yes, Found] , [Not Found: Not Found] , [Duplicate: Duplicate] )
• inspAccessible ( type: esriFieldTypeString, alias: Access condition, length: 20 , Coded Values: [Excavation Required: Excavation Required] , [Inaccessible: Inaccessible] , [OK: OK] , ...4 more... )
• inspTm ( type: esriFieldTypeString, alias: What TM was used, length: 30 , Coded Values: [15 Min Delay Boards: 15 Min Delay Boards] , [2-Way Lights: 2-Way Lights] , [Lane Closure: Lane Closure] , ...8 more... )
• inspWorkType ( type: esriFieldTypeString, alias: Inspection type, length: 20 , Coded Values: [Cyclical: Cyclical] , [CycRemote: Cyclical - Remote] , [Day Works: Day Works] , ...1 more... )
• inspshift ( type: esriFieldTypeString, alias: Day or night shift, length: 12 , Coded Values: [Day shift: Day shift] , [Night shift: Night shift] )
• inspOpArrive ( type: esriFieldTypeString, alias: Operational on arrival, length: 30 , Coded Values: [No: No] , [Slow Runner: Slow Runner] , [Yes: Yes - Junction Flowing] )
• inspGenCon ( type: esriFieldTypeString, alias: Condition of structure, length: 30 , Coded Values: [Average: Average] , [Good: Good] , [Needs Attention / Repair: Needs Attention / Repair] )
• inspCoverCon ( type: esriFieldTypeString, alias: Condition of cover, length: 20 , Coded Values: [Broken Lid: Broken Lid] , [Buried on Arrival: Buried on Arrival] , [Missing: Missing] , ...3 more... )
• inspSiltDefect ( type: esriFieldTypeString, alias: Specify if defective, length: 40 , Coded Values: [Ditch Maintenance Required: Ditch Maintenance Required] , [Domestic Refuse: Domestic Refuse] , [Excessive Debris: Excessive Debris] , ...12 more... )
• inspSiltArrive ( type: esriFieldTypeSmallInteger, alias: Silt Level , Coded Values: [0: 0%] , [25: 25%] , [50: 50%] , ...2 more... )
• inspSiltDepart ( type: esriFieldTypeSmallInteger, alias: Depth to Base after Clean (%) , Coded Values: [0: 0%] , [25: 25%] , [50: 50%] , ...2 more... )
• inspCleaned ( type: esriFieldTypeString, alias: Drainage cleaned, length: 7 , Coded Values: [no: no] , [yes: yes] )
• inspComments ( type: esriFieldTypeString, alias: Inspection related comments, length: 50 , Coded Values: [3rd Party site blocking access: 3rd Party site blocking access] , [Can't reach with gully boom: Can't reach with gully boom] , [Filled with concrete: Filled with concrete] , ...6 more... )
• inspCommentsOther ( type: esriFieldTypeString, alias: Other inspection related comments, length: 680 )
• inspJetCompleted ( type: esriFieldTypeString, alias: Jetted, length: 7 , Coded Values: [no: no] , [yes: yes] )
• inspJettingTime ( type: esriFieldTypeSmallInteger, alias: Jetting time , Coded Values: [15: 15 Mins] , [30: 30 Mins] , [45: 45 Mins] , ...5 more... )
• inspJettingComments ( type: esriFieldTypeString, alias: Jetting related comments, length: 50 , Coded Values: [No access to jet: No access to jet] , [Suspected collapsed pipe: Suspected collapsed pipe] , [Jetted 1m to blockage: Jetted 1m to blockage] , ...15 more... )
• inspJettingCommentsOther ( type: esriFieldTypeString, alias: Other jetting related comments, length: 1000 )
• inspAP2 ( type: esriFieldTypeString, alias: AP2 Required, length: 7 , Coded Values: [no: no] , [yes: yes] )
• inspWeep ( type: esriFieldTypeString, alias: Weep Holes Cleaned, length: 10 , Coded Values: [Clear: Clear] , [Blocked: Blocked] )
• inspOpLeave ( type: esriFieldTypeString, alias: Was drainage operational on departure, length: 30 , Coded Values: [No: No] , [Slow Runner: Slow Runner] , [Yes: Yes - Junction Flowing] )
• inspPhotoComments ( type: esriFieldTypeString, alias: Photo related comments, length: 700 )
• inspAuditDate ( type: esriFieldTypeDate, alias: Inspection audit date, length: 8 )
• auditState ( type: esriFieldTypeString, alias: Result of audit, length: 7 , Coded Values: [Fail: Fail] , [Pass: Pass] )
• POINT_X ( type: esriFieldTypeDouble, alias: Easting )
• POINT_Y ( type: esriFieldTypeDouble, alias: Northing )
• inspRelGlobalID ( type: esriFieldTypeGUID, alias: Asset GlobalID, length: 38 )
• sourceGlobalID ( type: esriFieldTypeGUID, alias: sourceGlobalID, length: 38 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• created_user ( type: esriFieldTypeString, alias: created_user, length: 255 )
• created_date ( type: esriFieldTypeDate, alias: created_date, length: 8 )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, length: 255 )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, length: 8 )
• inspTmReq ( type: esriFieldTypeString, alias: TM is required, length: 30 , Coded Values: [15 Min Delay Boards: 15 Min Delay Boards] , [2-Way Lights: 2-Way Lights] , [Lane Closure: Lane Closure] , ...8 more... )
• duplicate ( type: esriFieldTypeString, alias: duplicate, length: 5 , Coded Values: [no: no] , [yes: yes] )

Relationships:

• ASSET_IC (10) -- Related To: SCC_ASSET_IC (8)

Table: SCC_ASSET_IL_INSP (29)

Name: SCC_ASSET_IL_INSP

Display Field: created_date

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: 3efec8729f794e7a86718ff7f5769e14

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 200000

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
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: true
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true


HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• inspAssetNo ( type: esriFieldTypeInteger, alias: Asset ID )
• inspTargetDate ( type: esriFieldTypeDate, alias: Target date of inspection, length: 8 )
• inspId ( type: esriFieldTypeInteger, alias: Legacy Inspection ID )
• externalID ( type: esriFieldTypeString, alias: External ID, length: 40 )
• inspAssetType ( type: esriFieldTypeString, alias: Asset type, length: 20 , Coded Values: [AcoDrain: AcoDrain] , [BeanieBlocks: BeanieBlocks] , [Catchpit: Catchpit] , ...24 more... )
• crewArcReason ( type: esriFieldTypeString, alias: Crew archive reason, length: 20 , Coded Values: [Local Authority: Yes, Found] , [Not Found: Not Found] , [Duplicate: Duplicate] )
• inspAccessible ( type: esriFieldTypeString, alias: Access condition, length: 20 , Coded Values: [Excavation Required: Excavation Required] , [Inaccessible: Inaccessible] , [OK: OK] , ...4 more... )
• inspTm ( type: esriFieldTypeString, alias: What TM was used, length: 30 , Coded Values: [15 Min Delay Boards: 15 Min Delay Boards] , [2-Way Lights: 2-Way Lights] , [Lane Closure: Lane Closure] , ...8 more... )
• inspWorkType ( type: esriFieldTypeString, alias: Inspection type, length: 20 , Coded Values: [Cyclical: Cyclical] , [CycRemote: Cyclical - Remote] , [Day Works: Day Works] , ...1 more... )
• inspshift ( type: esriFieldTypeString, alias: Day or night shift, length: 12 , Coded Values: [Day shift: Day shift] , [Night shift: Night shift] )
• inspOpArrive ( type: esriFieldTypeString, alias: Operational on arrival, length: 30 , Coded Values: [No: No] , [Slow Runner: Slow Runner] , [Yes: Yes - Junction Flowing] )
• inspGenCon ( type: esriFieldTypeString, alias: Condition of structure, length: 30 , Coded Values: [Average: Average] , [Good: Good] , [Needs Attention / Repair: Needs Attention / Repair] )
• inspCoverCon ( type: esriFieldTypeString, alias: Condition of cover, length: 20 , Coded Values: [Broken Lid: Broken Lid] , [Buried on Arrival: Buried on Arrival] , [Missing: Missing] , ...3 more... )
• inspSiltDefect ( type: esriFieldTypeString, alias: Specify if defective, length: 40 , Coded Values: [Ditch Maintenance Required: Ditch Maintenance Required] , [Domestic Refuse: Domestic Refuse] , [Excessive Debris: Excessive Debris] , ...12 more... )
• inspSiltArrive ( type: esriFieldTypeSmallInteger, alias: Silt Level , Coded Values: [0: 0%] , [25: 25%] , [50: 50%] , ...2 more... )
• inspSiltDepart ( type: esriFieldTypeSmallInteger, alias: Depth to Base after Clean (%) , Coded Values: [0: 0%] , [25: 25%] , [50: 50%] , ...2 more... )
• inspCleaned ( type: esriFieldTypeString, alias: Drainage cleaned, length: 7 , Coded Values: [no: no] , [yes: yes] )
• inspComments ( type: esriFieldTypeString, alias: Inspection related comments, length: 50 , Coded Values: [3rd Party site blocking access: 3rd Party site blocking access] , [Can't reach with gully boom: Can't reach with gully boom] , [Filled with concrete: Filled with concrete] , ...6 more... )
• inspCommentsOther ( type: esriFieldTypeString, alias: Other inspection related comments, length: 680 )
• inspJetCompleted ( type: esriFieldTypeString, alias: Jetted, length: 7 , Coded Values: [no: no] , [yes: yes] )
• inspJettingTime ( type: esriFieldTypeSmallInteger, alias: Jetting time , Coded Values: [15: 15 Mins] , [30: 30 Mins] , [45: 45 Mins] , ...5 more... )
• inspJettingComments ( type: esriFieldTypeString, alias: Jetting related comments, length: 50 , Coded Values: [No access to jet: No access to jet] , [Suspected collapsed pipe: Suspected collapsed pipe] , [Jetted 1m to blockage: Jetted 1m to blockage] , ...15 more... )
• inspJettingCommentsOther ( type: esriFieldTypeString, alias: Other jetting related comments, length: 1000 )
• inspAP2 ( type: esriFieldTypeString, alias: AP2 Required, length: 7 , Coded Values: [no: no] , [yes: yes] )
• inspWeep ( type: esriFieldTypeString, alias: Weep Holes Cleaned, length: 10 , Coded Values: [Clear: Clear] , [Blocked: Blocked] )
• inspOpLeave ( type: esriFieldTypeString, alias: Was drainage operational on departure, length: 30 , Coded Values: [No: No] , [Slow Runner: Slow Runner] , [Yes: Yes - Junction Flowing] )
• inspPhotoComments ( type: esriFieldTypeString, alias: Photo related comments, length: 700 )
• inspAuditDate ( type: esriFieldTypeDate, alias: Inspection audit date, length: 8 )
• auditState ( type: esriFieldTypeString, alias: Result of audit, length: 7 , Coded Values: [Fail: Fail] , [Pass: Pass] )
• POINT_X ( type: esriFieldTypeDouble, alias: Easting )
• POINT_Y ( type: esriFieldTypeDouble, alias: Northing )
• inspRelGlobalID ( type: esriFieldTypeGUID, alias: Asset GlobalID, length: 38 )
• sourceGlobalID ( type: esriFieldTypeGUID, alias: sourceGlobalID, length: 38 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• created_user ( type: esriFieldTypeString, alias: created_user, length: 255 )
• created_date ( type: esriFieldTypeDate, alias: created_date, length: 8 )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, length: 255 )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, length: 8 )
• inspTmReq ( type: esriFieldTypeString, alias: TM is required, length: 30 , Coded Values: [15 Min Delay Boards: 15 Min Delay Boards] , [2-Way Lights: 2-Way Lights] , [Lane Closure: Lane Closure] , ...8 more... )
• duplicate ( type: esriFieldTypeString, alias: duplicate, length: 5 , Coded Values: [no: no] , [yes: yes] )

Relationships:

• ASSET_IL (11) -- Related To: SCC_ASSET_IL (9)

Table: SCC_ASSET_MH_INSP (30)

Name: SCC_ASSET_MH_INSP

Display Field: created_date

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: 3efec8729f794e7a86718ff7f5769e14

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 200000

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
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: true
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true


HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• inspAssetNo ( type: esriFieldTypeInteger, alias: Asset ID )
• inspTargetDate ( type: esriFieldTypeDate, alias: Target date of inspection, length: 8 )
• inspId ( type: esriFieldTypeInteger, alias: Legacy Inspection ID )
• externalID ( type: esriFieldTypeString, alias: External ID, length: 40 )
• inspAssetType ( type: esriFieldTypeString, alias: Asset type, length: 20 , Coded Values: [AcoDrain: AcoDrain] , [BeanieBlocks: BeanieBlocks] , [Catchpit: Catchpit] , ...24 more... )
• crewArcReason ( type: esriFieldTypeString, alias: Crew archive reason, length: 20 , Coded Values: [Local Authority: Yes, Found] , [Not Found: Not Found] , [Duplicate: Duplicate] )
• inspAccessible ( type: esriFieldTypeString, alias: Access condition, length: 20 , Coded Values: [Excavation Required: Excavation Required] , [Inaccessible: Inaccessible] , [OK: OK] , ...4 more... )
• inspTm ( type: esriFieldTypeString, alias: What TM was used, length: 30 , Coded Values: [15 Min Delay Boards: 15 Min Delay Boards] , [2-Way Lights: 2-Way Lights] , [Lane Closure: Lane Closure] , ...8 more... )
• inspWorkType ( type: esriFieldTypeString, alias: Inspection type, length: 20 , Coded Values: [Cyclical: Cyclical] , [CycRemote: Cyclical - Remote] , [Day Works: Day Works] , ...1 more... )
• inspshift ( type: esriFieldTypeString, alias: Day or night shift, length: 12 , Coded Values: [Day shift: Day shift] , [Night shift: Night shift] )
• inspOpArrive ( type: esriFieldTypeString, alias: Operational on arrival, length: 30 , Coded Values: [No: No] , [Slow Runner: Slow Runner] , [Yes: Yes - Junction Flowing] )
• inspGenCon ( type: esriFieldTypeString, alias: Condition of structure, length: 30 , Coded Values: [Average: Average] , [Good: Good] , [Needs Attention / Repair: Needs Attention / Repair] )
• inspCoverCon ( type: esriFieldTypeString, alias: Condition of cover, length: 20 , Coded Values: [Broken Lid: Broken Lid] , [Buried on Arrival: Buried on Arrival] , [Missing: Missing] , ...3 more... )
• inspSiltDefect ( type: esriFieldTypeString, alias: Specify if defective, length: 40 , Coded Values: [Ditch Maintenance Required: Ditch Maintenance Required] , [Domestic Refuse: Domestic Refuse] , [Excessive Debris: Excessive Debris] , ...12 more... )
• inspSiltArrive ( type: esriFieldTypeSmallInteger, alias: Silt Level , Coded Values: [0: 0%] , [25: 25%] , [50: 50%] , ...2 more... )
• inspSiltDepart ( type: esriFieldTypeSmallInteger, alias: Depth to Base after Clean (%) , Coded Values: [0: 0%] , [25: 25%] , [50: 50%] , ...2 more... )
• inspCleaned ( type: esriFieldTypeString, alias: Drainage cleaned, length: 7 , Coded Values: [no: no] , [yes: yes] )
• inspComments ( type: esriFieldTypeString, alias: Inspection related comments, length: 50 , Coded Values: [3rd Party site blocking access: 3rd Party site blocking access] , [Can't reach with gully boom: Can't reach with gully boom] , [Filled with concrete: Filled with concrete] , ...6 more... )
• inspCommentsOther ( type: esriFieldTypeString, alias: Other inspection related comments, length: 680 )
• inspJetCompleted ( type: esriFieldTypeString, alias: Jetted, length: 7 , Coded Values: [no: no] , [yes: yes] )
• inspJettingTime ( type: esriFieldTypeSmallInteger, alias: Jetting time , Coded Values: [15: 15 Mins] , [30: 30 Mins] , [45: 45 Mins] , ...5 more... )
• inspJettingComments ( type: esriFieldTypeString, alias: Jetting related comments, length: 50 , Coded Values: [No access to jet: No access to jet] , [Suspected collapsed pipe: Suspected collapsed pipe] , [Jetted 1m to blockage: Jetted 1m to blockage] , ...15 more... )
• inspJettingCommentsOther ( type: esriFieldTypeString, alias: Other jetting related comments, length: 1000 )
• inspAP2 ( type: esriFieldTypeString, alias: AP2 Required, length: 7 , Coded Values: [no: no] , [yes: yes] )
• inspWeep ( type: esriFieldTypeString, alias: Weep Holes Cleaned, length: 10 , Coded Values: [Clear: Clear] , [Blocked: Blocked] )
• inspOpLeave ( type: esriFieldTypeString, alias: Was drainage operational on departure, length: 30 , Coded Values: [No: No] , [Slow Runner: Slow Runner] , [Yes: Yes - Junction Flowing] )
• inspPhotoComments ( type: esriFieldTypeString, alias: Photo related comments, length: 700 )
• inspAuditDate ( type: esriFieldTypeDate, alias: Inspection audit date, length: 8 )
• auditState ( type: esriFieldTypeString, alias: Result of audit, length: 7 , Coded Values: [Fail: Fail] , [Pass: Pass] )
• POINT_X ( type: esriFieldTypeDouble, alias: Easting )
• POINT_Y ( type: esriFieldTypeDouble, alias: Northing )
• inspRelGlobalID ( type: esriFieldTypeGUID, alias: Asset GlobalID, length: 38 )
• sourceGlobalID ( type: esriFieldTypeGUID, alias: sourceGlobalID, length: 38 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• created_user ( type: esriFieldTypeString, alias: created_user, length: 255 )
• created_date ( type: esriFieldTypeDate, alias: created_date, length: 8 )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, length: 255 )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, length: 8 )
• inspTmReq ( type: esriFieldTypeString, alias: TM is required, length: 30 , Coded Values: [15 Min Delay Boards: 15 Min Delay Boards] , [2-Way Lights: 2-Way Lights] , [Lane Closure: Lane Closure] , ...8 more... )
• duplicate ( type: esriFieldTypeString, alias: duplicate, length: 5 , Coded Values: [no: no] , [yes: yes] )

Relationships:

• ASSET_MH (12) -- Related To: SCC_ASSET_MH (10)

Table: SCC_ASSET_OF_INSP (31)

Name: SCC_ASSET_OF_INSP

Display Field: created_date

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: 3efec8729f794e7a86718ff7f5769e14

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 200000

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
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: true
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true


HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• inspAssetNo ( type: esriFieldTypeInteger, alias: Asset ID )
• inspTargetDate ( type: esriFieldTypeDate, alias: Target date of inspection, length: 8 )
• inspId ( type: esriFieldTypeInteger, alias: Legacy Inspection ID )
• externalID ( type: esriFieldTypeString, alias: External ID, length: 40 )
• inspAssetType ( type: esriFieldTypeString, alias: Asset type, length: 20 , Coded Values: [AcoDrain: AcoDrain] , [BeanieBlocks: BeanieBlocks] , [Catchpit: Catchpit] , ...24 more... )
• crewArcReason ( type: esriFieldTypeString, alias: Crew archive reason, length: 20 , Coded Values: [Local Authority: Yes, Found] , [Not Found: Not Found] , [Duplicate: Duplicate] )
• inspAccessible ( type: esriFieldTypeString, alias: Access condition, length: 20 , Coded Values: [Excavation Required: Excavation Required] , [Inaccessible: Inaccessible] , [OK: OK] , ...4 more... )
• inspTm ( type: esriFieldTypeString, alias: What TM was used, length: 30 , Coded Values: [15 Min Delay Boards: 15 Min Delay Boards] , [2-Way Lights: 2-Way Lights] , [Lane Closure: Lane Closure] , ...8 more... )
• inspWorkType ( type: esriFieldTypeString, alias: Inspection type, length: 20 , Coded Values: [Cyclical: Cyclical] , [CycRemote: Cyclical - Remote] , [Day Works: Day Works] , ...1 more... )
• inspshift ( type: esriFieldTypeString, alias: Day or night shift, length: 12 , Coded Values: [Day shift: Day shift] , [Night shift: Night shift] )
• inspOpArrive ( type: esriFieldTypeString, alias: Operational on arrival, length: 30 , Coded Values: [No: No] , [Slow Runner: Slow Runner] , [Yes: Yes - Junction Flowing] )
• inspGenCon ( type: esriFieldTypeString, alias: Condition of structure, length: 30 , Coded Values: [Average: Average] , [Good: Good] , [Needs Attention / Repair: Needs Attention / Repair] )
• inspCoverCon ( type: esriFieldTypeString, alias: Condition of cover, length: 20 , Coded Values: [Broken Lid: Broken Lid] , [Buried on Arrival: Buried on Arrival] , [Missing: Missing] , ...3 more... )
• inspSiltDefect ( type: esriFieldTypeString, alias: Specify if defective, length: 40 , Coded Values: [Ditch Maintenance Required: Ditch Maintenance Required] , [Domestic Refuse: Domestic Refuse] , [Excessive Debris: Excessive Debris] , ...12 more... )
• inspSiltArrive ( type: esriFieldTypeSmallInteger, alias: Silt Level , Coded Values: [0: 0%] , [25: 25%] , [50: 50%] , ...2 more... )
• inspSiltDepart ( type: esriFieldTypeSmallInteger, alias: Depth to Base after Clean (%) , Coded Values: [0: 0%] , [25: 25%] , [50: 50%] , ...2 more... )
• inspCleaned ( type: esriFieldTypeString, alias: Drainage cleaned, length: 7 , Coded Values: [no: no] , [yes: yes] )
• inspComments ( type: esriFieldTypeString, alias: Inspection related comments, length: 50 , Coded Values: [3rd Party site blocking access: 3rd Party site blocking access] , [Can't reach with gully boom: Can't reach with gully boom] , [Filled with concrete: Filled with concrete] , ...6 more... )
• inspCommentsOther ( type: esriFieldTypeString, alias: Other inspection related comments, length: 680 )
• inspJetCompleted ( type: esriFieldTypeString, alias: Jetted, length: 7 , Coded Values: [no: no] , [yes: yes] )
• inspJettingTime ( type: esriFieldTypeSmallInteger, alias: Jetting time , Coded Values: [15: 15 Mins] , [30: 30 Mins] , [45: 45 Mins] , ...5 more... )
• inspJettingComments ( type: esriFieldTypeString, alias: Jetting related comments, length: 50 , Coded Values: [No access to jet: No access to jet] , [Suspected collapsed pipe: Suspected collapsed pipe] , [Jetted 1m to blockage: Jetted 1m to blockage] , ...15 more... )
• inspJettingCommentsOther ( type: esriFieldTypeString, alias: Other jetting related comments, length: 1000 )
• inspAP2 ( type: esriFieldTypeString, alias: AP2 Required, length: 7 , Coded Values: [no: no] , [yes: yes] )
• inspWeep ( type: esriFieldTypeString, alias: Weep Holes Cleaned, length: 10 , Coded Values: [Clear: Clear] , [Blocked: Blocked] )
• inspOpLeave ( type: esriFieldTypeString, alias: Was drainage operational on departure, length: 30 , Coded Values: [No: No] , [Slow Runner: Slow Runner] , [Yes: Yes - Junction Flowing] )
• inspPhotoComments ( type: esriFieldTypeString, alias: Photo related comments, length: 700 )
• inspAuditDate ( type: esriFieldTypeDate, alias: Inspection audit date, length: 8 )
• auditState ( type: esriFieldTypeString, alias: Result of audit, length: 7 , Coded Values: [Fail: Fail] , [Pass: Pass] )
• POINT_X ( type: esriFieldTypeDouble, alias: Easting )
• POINT_Y ( type: esriFieldTypeDouble, alias: Northing )
• inspRelGlobalID ( type: esriFieldTypeGUID, alias: Asset GlobalID, length: 38 )
• sourceGlobalID ( type: esriFieldTypeGUID, alias: sourceGlobalID, length: 38 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• created_user ( type: esriFieldTypeString, alias: created_user, length: 255 )
• created_date ( type: esriFieldTypeDate, alias: created_date, length: 8 )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, length: 255 )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, length: 8 )
• inspTmReq ( type: esriFieldTypeString, alias: TM is required, length: 30 , Coded Values: [15 Min Delay Boards: 15 Min Delay Boards] , [2-Way Lights: 2-Way Lights] , [Lane Closure: Lane Closure] , ...8 more... )
• duplicate ( type: esriFieldTypeString, alias: duplicate, length: 5 , Coded Values: [no: no] , [yes: yes] )

Relationships:

• ASSET_OF (13) -- Related To: SCC_ASSET_OF (11)

Table: SCC_ASSET_OL_INSP (32)

Name: SCC_ASSET_OL_INSP

Display Field: created_date

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: 3efec8729f794e7a86718ff7f5769e14

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 200000

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
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: true
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true


HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• inspAssetNo ( type: esriFieldTypeInteger, alias: Asset ID )
• inspTargetDate ( type: esriFieldTypeDate, alias: Target date of inspection, length: 8 )
• inspId ( type: esriFieldTypeInteger, alias: Legacy Inspection ID )
• externalID ( type: esriFieldTypeString, alias: External ID, length: 40 )
• inspAssetType ( type: esriFieldTypeString, alias: Asset type, length: 20 , Coded Values: [AcoDrain: AcoDrain] , [BeanieBlocks: BeanieBlocks] , [Catchpit: Catchpit] , ...24 more... )
• crewArcReason ( type: esriFieldTypeString, alias: Crew archive reason, length: 20 , Coded Values: [Local Authority: Yes, Found] , [Not Found: Not Found] , [Duplicate: Duplicate] )
• inspAccessible ( type: esriFieldTypeString, alias: Access condition, length: 20 , Coded Values: [Excavation Required: Excavation Required] , [Inaccessible: Inaccessible] , [OK: OK] , ...4 more... )
• inspTm ( type: esriFieldTypeString, alias: What TM was used, length: 30 , Coded Values: [15 Min Delay Boards: 15 Min Delay Boards] , [2-Way Lights: 2-Way Lights] , [Lane Closure: Lane Closure] , ...8 more... )
• inspWorkType ( type: esriFieldTypeString, alias: Inspection type, length: 20 , Coded Values: [Cyclical: Cyclical] , [CycRemote: Cyclical - Remote] , [Day Works: Day Works] , ...1 more... )
• inspshift ( type: esriFieldTypeString, alias: Day or night shift, length: 12 , Coded Values: [Day shift: Day shift] , [Night shift: Night shift] )
• inspOpArrive ( type: esriFieldTypeString, alias: Operational on arrival, length: 30 , Coded Values: [No: No] , [Slow Runner: Slow Runner] , [Yes: Yes - Junction Flowing] )
• inspGenCon ( type: esriFieldTypeString, alias: Condition of structure, length: 30 , Coded Values: [Average: Average] , [Good: Good] , [Needs Attention / Repair: Needs Attention / Repair] )
• inspCoverCon ( type: esriFieldTypeString, alias: Condition of cover, length: 20 , Coded Values: [Broken Lid: Broken Lid] , [Buried on Arrival: Buried on Arrival] , [Missing: Missing] , ...3 more... )
• inspSiltDefect ( type: esriFieldTypeString, alias: Specify if defective, length: 40 , Coded Values: [Ditch Maintenance Required: Ditch Maintenance Required] , [Domestic Refuse: Domestic Refuse] , [Excessive Debris: Excessive Debris] , ...12 more... )
• inspSiltArrive ( type: esriFieldTypeSmallInteger, alias: Silt Level , Coded Values: [0: 0%] , [25: 25%] , [50: 50%] , ...2 more... )
• inspSiltDepart ( type: esriFieldTypeSmallInteger, alias: Depth to Base after Clean (%) , Coded Values: [0: 0%] , [25: 25%] , [50: 50%] , ...2 more... )
• inspCleaned ( type: esriFieldTypeString, alias: Drainage cleaned, length: 7 , Coded Values: [no: no] , [yes: yes] )
• inspComments ( type: esriFieldTypeString, alias: Inspection related comments, length: 50 , Coded Values: [3rd Party site blocking access: 3rd Party site blocking access] , [Can't reach with gully boom: Can't reach with gully boom] , [Filled with concrete: Filled with concrete] , ...6 more... )
• inspCommentsOther ( type: esriFieldTypeString, alias: Other inspection related comments, length: 680 )
• inspJetCompleted ( type: esriFieldTypeString, alias: Jetted, length: 7 , Coded Values: [no: no] , [yes: yes] )
• inspJettingTime ( type: esriFieldTypeSmallInteger, alias: Jetting time , Coded Values: [15: 15 Mins] , [30: 30 Mins] , [45: 45 Mins] , ...5 more... )
• inspJettingComments ( type: esriFieldTypeString, alias: Jetting related comments, length: 50 , Coded Values: [No access to jet: No access to jet] , [Suspected collapsed pipe: Suspected collapsed pipe] , [Jetted 1m to blockage: Jetted 1m to blockage] , ...15 more... )
• inspJettingCommentsOther ( type: esriFieldTypeString, alias: Other jetting related comments, length: 1000 )
• inspAP2 ( type: esriFieldTypeString, alias: AP2 Required, length: 7 , Coded Values: [no: no] , [yes: yes] )
• inspWeep ( type: esriFieldTypeString, alias: Weep Holes Cleaned, length: 10 , Coded Values: [Clear: Clear] , [Blocked: Blocked] )
• inspOpLeave ( type: esriFieldTypeString, alias: Was drainage operational on departure, length: 30 , Coded Values: [No: No] , [Slow Runner: Slow Runner] , [Yes: Yes - Junction Flowing] )
• inspPhotoComments ( type: esriFieldTypeString, alias: Photo related comments, length: 700 )
• inspAuditDate ( type: esriFieldTypeDate, alias: Inspection audit date, length: 8 )
• auditState ( type: esriFieldTypeString, alias: Result of audit, length: 7 , Coded Values: [Fail: Fail] , [Pass: Pass] )
• POINT_X ( type: esriFieldTypeDouble, alias: Easting )
• POINT_Y ( type: esriFieldTypeDouble, alias: Northing )
• inspRelGlobalID ( type: esriFieldTypeGUID, alias: Asset GlobalID, length: 38 )
• sourceGlobalID ( type: esriFieldTypeGUID, alias: sourceGlobalID, length: 38 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• created_user ( type: esriFieldTypeString, alias: created_user, length: 255 )
• created_date ( type: esriFieldTypeDate, alias: created_date, length: 8 )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, length: 255 )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, length: 8 )
• inspTmReq ( type: esriFieldTypeString, alias: TM is required, length: 30 , Coded Values: [15 Min Delay Boards: 15 Min Delay Boards] , [2-Way Lights: 2-Way Lights] , [Lane Closure: Lane Closure] , ...8 more... )
• duplicate ( type: esriFieldTypeString, alias: duplicate, length: 5 , Coded Values: [no: no] , [yes: yes] )

Relationships:

• ASSET_OL (14) -- Related To: SCC_ASSET_OL (12)

Table: SCC_ASSET_PS_INSP (33)

Name: SCC_ASSET_PS_INSP

Display Field: created_date

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: 3efec8729f794e7a86718ff7f5769e14

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 200000

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
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: true
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true


HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• inspAssetNo ( type: esriFieldTypeInteger, alias: Asset ID )
• inspTargetDate ( type: esriFieldTypeDate, alias: Target date of inspection, length: 8 )
• inspId ( type: esriFieldTypeInteger, alias: Legacy Inspection ID )
• externalID ( type: esriFieldTypeString, alias: External ID, length: 40 )
• inspAssetType ( type: esriFieldTypeString, alias: Asset type, length: 20 , Coded Values: [AcoDrain: AcoDrain] , [BeanieBlocks: BeanieBlocks] , [Catchpit: Catchpit] , ...24 more... )
• crewArcReason ( type: esriFieldTypeString, alias: Crew archive reason, length: 20 , Coded Values: [Local Authority: Yes, Found] , [Not Found: Not Found] , [Duplicate: Duplicate] )
• inspAccessible ( type: esriFieldTypeString, alias: Access condition, length: 20 , Coded Values: [Excavation Required: Excavation Required] , [Inaccessible: Inaccessible] , [OK: OK] , ...4 more... )
• inspTm ( type: esriFieldTypeString, alias: What TM was used, length: 30 , Coded Values: [15 Min Delay Boards: 15 Min Delay Boards] , [2-Way Lights: 2-Way Lights] , [Lane Closure: Lane Closure] , ...8 more... )
• inspWorkType ( type: esriFieldTypeString, alias: Inspection type, length: 20 , Coded Values: [Cyclical: Cyclical] , [CycRemote: Cyclical - Remote] , [Day Works: Day Works] , ...1 more... )
• inspshift ( type: esriFieldTypeString, alias: Day or night shift, length: 12 , Coded Values: [Day shift: Day shift] , [Night shift: Night shift] )
• inspOpArrive ( type: esriFieldTypeString, alias: Operational on arrival, length: 30 , Coded Values: [No: No] , [Slow Runner: Slow Runner] , [Yes: Yes - Junction Flowing] )
• inspGenCon ( type: esriFieldTypeString, alias: Condition of structure, length: 30 , Coded Values: [Average: Average] , [Good: Good] , [Needs Attention / Repair: Needs Attention / Repair] )
• inspCoverCon ( type: esriFieldTypeString, alias: Condition of cover, length: 20 , Coded Values: [Broken Lid: Broken Lid] , [Buried on Arrival: Buried on Arrival] , [Missing: Missing] , ...3 more... )
• inspSiltDefect ( type: esriFieldTypeString, alias: Specify if defective, length: 40 , Coded Values: [Ditch Maintenance Required: Ditch Maintenance Required] , [Domestic Refuse: Domestic Refuse] , [Excessive Debris: Excessive Debris] , ...12 more... )
• inspSiltArrive ( type: esriFieldTypeSmallInteger, alias: Silt Level , Coded Values: [0: 0%] , [25: 25%] , [50: 50%] , ...2 more... )
• inspSiltDepart ( type: esriFieldTypeSmallInteger, alias: Depth to Base after Clean (%) , Coded Values: [0: 0%] , [25: 25%] , [50: 50%] , ...2 more... )
• inspCleaned ( type: esriFieldTypeString, alias: Drainage cleaned, length: 7 , Coded Values: [no: no] , [yes: yes] )
• inspComments ( type: esriFieldTypeString, alias: Inspection related comments, length: 50 , Coded Values: [3rd Party site blocking access: 3rd Party site blocking access] , [Can't reach with gully boom: Can't reach with gully boom] , [Filled with concrete: Filled with concrete] , ...6 more... )
• inspCommentsOther ( type: esriFieldTypeString, alias: Other inspection related comments, length: 680 )
• inspJetCompleted ( type: esriFieldTypeString, alias: Jetted, length: 7 , Coded Values: [no: no] , [yes: yes] )
• inspJettingTime ( type: esriFieldTypeSmallInteger, alias: Jetting time , Coded Values: [15: 15 Mins] , [30: 30 Mins] , [45: 45 Mins] , ...5 more... )
• inspJettingComments ( type: esriFieldTypeString, alias: Jetting related comments, length: 50 , Coded Values: [No access to jet: No access to jet] , [Suspected collapsed pipe: Suspected collapsed pipe] , [Jetted 1m to blockage: Jetted 1m to blockage] , ...15 more... )
• inspJettingCommentsOther ( type: esriFieldTypeString, alias: Other jetting related comments, length: 1000 )
• inspAP2 ( type: esriFieldTypeString, alias: AP2 Required, length: 7 , Coded Values: [no: no] , [yes: yes] )
• inspWeep ( type: esriFieldTypeString, alias: Weep Holes Cleaned, length: 10 , Coded Values: [Clear: Clear] , [Blocked: Blocked] )
• inspOpLeave ( type: esriFieldTypeString, alias: Was drainage operational on departure, length: 30 , Coded Values: [No: No] , [Slow Runner: Slow Runner] , [Yes: Yes - Junction Flowing] )
• inspPhotoComments ( type: esriFieldTypeString, alias: Photo related comments, length: 700 )
• inspAuditDate ( type: esriFieldTypeDate, alias: Inspection audit date, length: 8 )
• auditState ( type: esriFieldTypeString, alias: Result of audit, length: 7 , Coded Values: [Fail: Fail] , [Pass: Pass] )
• POINT_X ( type: esriFieldTypeDouble, alias: Easting )
• POINT_Y ( type: esriFieldTypeDouble, alias: Northing )
• inspRelGlobalID ( type: esriFieldTypeGUID, alias: Asset GlobalID, length: 38 )
• sourceGlobalID ( type: esriFieldTypeGUID, alias: sourceGlobalID, length: 38 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• created_user ( type: esriFieldTypeString, alias: created_user, length: 255 )
• created_date ( type: esriFieldTypeDate, alias: created_date, length: 8 )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, length: 255 )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, length: 8 )
• inspTmReq ( type: esriFieldTypeString, alias: TM is required, length: 30 , Coded Values: [15 Min Delay Boards: 15 Min Delay Boards] , [2-Way Lights: 2-Way Lights] , [Lane Closure: Lane Closure] , ...8 more... )
• duplicate ( type: esriFieldTypeString, alias: duplicate, length: 5 , Coded Values: [no: no] , [yes: yes] )

Relationships:

• ASSET_PS (15) -- Related To: SCC_ASSET_PS (13)

Table: SCC_ASSET_RE_INSP (34)

Name: SCC_ASSET_RE_INSP

Display Field: created_date

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: 3efec8729f794e7a86718ff7f5769e14

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 200000

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
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: true
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true


HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• inspAssetNo ( type: esriFieldTypeInteger, alias: Asset ID )
• inspTargetDate ( type: esriFieldTypeDate, alias: Target date of inspection, length: 8 )
• inspId ( type: esriFieldTypeInteger, alias: Legacy Inspection ID )
• externalID ( type: esriFieldTypeString, alias: External ID, length: 40 )
• inspAssetType ( type: esriFieldTypeString, alias: Asset type, length: 20 , Coded Values: [AcoDrain: AcoDrain] , [BeanieBlocks: BeanieBlocks] , [Catchpit: Catchpit] , ...24 more... )
• crewArcReason ( type: esriFieldTypeString, alias: Crew archive reason, length: 20 , Coded Values: [Local Authority: Yes, Found] , [Not Found: Not Found] , [Duplicate: Duplicate] )
• inspAccessible ( type: esriFieldTypeString, alias: Access condition, length: 20 , Coded Values: [Excavation Required: Excavation Required] , [Inaccessible: Inaccessible] , [OK: OK] , ...4 more... )
• inspTm ( type: esriFieldTypeString, alias: What TM was used, length: 30 , Coded Values: [15 Min Delay Boards: 15 Min Delay Boards] , [2-Way Lights: 2-Way Lights] , [Lane Closure: Lane Closure] , ...8 more... )
• inspWorkType ( type: esriFieldTypeString, alias: Inspection type, length: 20 , Coded Values: [Cyclical: Cyclical] , [CycRemote: Cyclical - Remote] , [Day Works: Day Works] , ...1 more... )
• inspshift ( type: esriFieldTypeString, alias: Day or night shift, length: 12 , Coded Values: [Day shift: Day shift] , [Night shift: Night shift] )
• inspOpArrive ( type: esriFieldTypeString, alias: Operational on arrival, length: 30 , Coded Values: [No: No] , [Slow Runner: Slow Runner] , [Yes: Yes - Junction Flowing] )
• inspGenCon ( type: esriFieldTypeString, alias: Condition of structure, length: 30 , Coded Values: [Average: Average] , [Good: Good] , [Needs Attention / Repair: Needs Attention / Repair] )
• inspCoverCon ( type: esriFieldTypeString, alias: Condition of cover, length: 20 , Coded Values: [Broken Lid: Broken Lid] , [Buried on Arrival: Buried on Arrival] , [Missing: Missing] , ...3 more... )
• inspSiltDefect ( type: esriFieldTypeString, alias: Specify if defective, length: 40 , Coded Values: [Ditch Maintenance Required: Ditch Maintenance Required] , [Domestic Refuse: Domestic Refuse] , [Excessive Debris: Excessive Debris] , ...12 more... )
• inspSiltArrive ( type: esriFieldTypeSmallInteger, alias: Silt Level , Coded Values: [0: 0%] , [25: 25%] , [50: 50%] , ...2 more... )
• inspSiltDepart ( type: esriFieldTypeSmallInteger, alias: Depth to Base after Clean (%) , Coded Values: [0: 0%] , [25: 25%] , [50: 50%] , ...2 more... )
• inspCleaned ( type: esriFieldTypeString, alias: Drainage cleaned, length: 7 , Coded Values: [no: no] , [yes: yes] )
• inspComments ( type: esriFieldTypeString, alias: Inspection related comments, length: 50 , Coded Values: [3rd Party site blocking access: 3rd Party site blocking access] , [Can't reach with gully boom: Can't reach with gully boom] , [Filled with concrete: Filled with concrete] , ...6 more... )
• inspCommentsOther ( type: esriFieldTypeString, alias: Other inspection related comments, length: 680 )
• inspJetCompleted ( type: esriFieldTypeString, alias: Jetted, length: 7 , Coded Values: [no: no] , [yes: yes] )
• inspJettingTime ( type: esriFieldTypeSmallInteger, alias: Jetting time , Coded Values: [15: 15 Mins] , [30: 30 Mins] , [45: 45 Mins] , ...5 more... )
• inspJettingComments ( type: esriFieldTypeString, alias: Jetting related comments, length: 50 , Coded Values: [No access to jet: No access to jet] , [Suspected collapsed pipe: Suspected collapsed pipe] , [Jetted 1m to blockage: Jetted 1m to blockage] , ...15 more... )
• inspJettingCommentsOther ( type: esriFieldTypeString, alias: Other jetting related comments, length: 1000 )
• inspAP2 ( type: esriFieldTypeString, alias: AP2 Required, length: 7 , Coded Values: [no: no] , [yes: yes] )
• inspWeep ( type: esriFieldTypeString, alias: Weep Holes Cleaned, length: 10 , Coded Values: [Clear: Clear] , [Blocked: Blocked] )
• inspOpLeave ( type: esriFieldTypeString, alias: Was drainage operational on departure, length: 30 , Coded Values: [No: No] , [Slow Runner: Slow Runner] , [Yes: Yes - Junction Flowing] )
• inspPhotoComments ( type: esriFieldTypeString, alias: Photo related comments, length: 700 )
• inspAuditDate ( type: esriFieldTypeDate, alias: Inspection audit date, length: 8 )
• auditState ( type: esriFieldTypeString, alias: Result of audit, length: 7 , Coded Values: [Fail: Fail] , [Pass: Pass] )
• POINT_X ( type: esriFieldTypeDouble, alias: Easting )
• POINT_Y ( type: esriFieldTypeDouble, alias: Northing )
• inspRelGlobalID ( type: esriFieldTypeGUID, alias: Asset GlobalID, length: 38 )
• sourceGlobalID ( type: esriFieldTypeGUID, alias: sourceGlobalID, length: 38 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• created_user ( type: esriFieldTypeString, alias: created_user, length: 255 )
• created_date ( type: esriFieldTypeDate, alias: created_date, length: 8 )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, length: 255 )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, length: 8 )
• inspTmReq ( type: esriFieldTypeString, alias: TM is required, length: 30 , Coded Values: [15 Min Delay Boards: 15 Min Delay Boards] , [2-Way Lights: 2-Way Lights] , [Lane Closure: Lane Closure] , ...8 more... )
• duplicate ( type: esriFieldTypeString, alias: duplicate, length: 5 , Coded Values: [no: no] , [yes: yes] )

Relationships:

• ASSET_RE (16) -- Related To: SCC_ASSET_RE (14)

Table: SCC_ASSET_SA_INSP (35)

Name: SCC_ASSET_SA_INSP

Display Field: created_date

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: 3efec8729f794e7a86718ff7f5769e14

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 200000

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
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: true
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true


HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• inspAssetNo ( type: esriFieldTypeInteger, alias: Asset ID )
• inspTargetDate ( type: esriFieldTypeDate, alias: Target date of inspection, length: 8 )
• inspId ( type: esriFieldTypeInteger, alias: Legacy Inspection ID )
• externalID ( type: esriFieldTypeString, alias: External ID, length: 40 )
• inspAssetType ( type: esriFieldTypeString, alias: Asset type, length: 20 , Coded Values: [AcoDrain: AcoDrain] , [BeanieBlocks: BeanieBlocks] , [Catchpit: Catchpit] , ...24 more... )
• crewArcReason ( type: esriFieldTypeString, alias: Crew archive reason, length: 20 , Coded Values: [Local Authority: Yes, Found] , [Not Found: Not Found] , [Duplicate: Duplicate] )
• inspAccessible ( type: esriFieldTypeString, alias: Access condition, length: 20 , Coded Values: [Excavation Required: Excavation Required] , [Inaccessible: Inaccessible] , [OK: OK] , ...4 more... )
• inspTm ( type: esriFieldTypeString, alias: What TM was used, length: 30 , Coded Values: [15 Min Delay Boards: 15 Min Delay Boards] , [2-Way Lights: 2-Way Lights] , [Lane Closure: Lane Closure] , ...8 more... )
• inspWorkType ( type: esriFieldTypeString, alias: Inspection type, length: 20 , Coded Values: [Cyclical: Cyclical] , [CycRemote: Cyclical - Remote] , [Day Works: Day Works] , ...1 more... )
• inspshift ( type: esriFieldTypeString, alias: Day or night shift, length: 12 , Coded Values: [Day shift: Day shift] , [Night shift: Night shift] )
• inspOpArrive ( type: esriFieldTypeString, alias: Operational on arrival, length: 30 , Coded Values: [No: No] , [Slow Runner: Slow Runner] , [Yes: Yes - Junction Flowing] )
• inspGenCon ( type: esriFieldTypeString, alias: Condition of structure, length: 30 , Coded Values: [Average: Average] , [Good: Good] , [Needs Attention / Repair: Needs Attention / Repair] )
• inspCoverCon ( type: esriFieldTypeString, alias: Condition of cover, length: 20 , Coded Values: [Broken Lid: Broken Lid] , [Buried on Arrival: Buried on Arrival] , [Missing: Missing] , ...3 more... )
• inspSiltDefect ( type: esriFieldTypeString, alias: Specify if defective, length: 40 , Coded Values: [Ditch Maintenance Required: Ditch Maintenance Required] , [Domestic Refuse: Domestic Refuse] , [Excessive Debris: Excessive Debris] , ...12 more... )
• inspDepBaseArrive ( type: esriFieldTypeSmallInteger, alias: Depth to Base before Clean (mm) )
• inspDepBaseDepart ( type: esriFieldTypeSmallInteger, alias: Depth to Base after Clean (mm) )
• inspCleaned ( type: esriFieldTypeString, alias: Drainage cleaned, length: 7 , Coded Values: [no: no] , [yes: yes] )
• inspComments ( type: esriFieldTypeString, alias: Inspection related comments, length: 50 , Coded Values: [3rd Party site blocking access: 3rd Party site blocking access] , [Can't reach with gully boom: Can't reach with gully boom] , [Filled with concrete: Filled with concrete] , ...6 more... )
• inspCommentsOther ( type: esriFieldTypeString, alias: Other inspection related comments, length: 680 )
• inspJetCompleted ( type: esriFieldTypeString, alias: Jetted, length: 7 , Coded Values: [no: no] , [yes: yes] )
• inspJettingTime ( type: esriFieldTypeSmallInteger, alias: Jetting time , Coded Values: [15: 15 Mins] , [30: 30 Mins] , [45: 45 Mins] , ...5 more... )
• inspJettingComments ( type: esriFieldTypeString, alias: Jetting related comments, length: 50 , Coded Values: [No access to jet: No access to jet] , [Suspected collapsed pipe: Suspected collapsed pipe] , [Jetted 1m to blockage: Jetted 1m to blockage] , ...15 more... )
• inspJettingCommentsOther ( type: esriFieldTypeString, alias: Other jetting related comments, length: 1000 )
• inspAP2 ( type: esriFieldTypeString, alias: AP2 Required, length: 7 , Coded Values: [no: no] , [yes: yes] )
• inspWeep ( type: esriFieldTypeString, alias: Weep Holes Cleaned, length: 10 , Coded Values: [Clear: Clear] , [Blocked: Blocked] )
• inspOpLeave ( type: esriFieldTypeString, alias: Was drainage operational on departure, length: 30 , Coded Values: [No: No] , [Slow Runner: Slow Runner] , [Yes: Yes - Junction Flowing] )
• inspPhotoComments ( type: esriFieldTypeString, alias: Photo related comments, length: 700 )
• inspAuditDate ( type: esriFieldTypeDate, alias: Inspection audit date, length: 8 )
• auditState ( type: esriFieldTypeString, alias: Result of audit, length: 7 , Coded Values: [Fail: Fail] , [Pass: Pass] )
• POINT_X ( type: esriFieldTypeDouble, alias: Easting )
• POINT_Y ( type: esriFieldTypeDouble, alias: Northing )
• inspRelGlobalID ( type: esriFieldTypeGUID, alias: Asset GlobalID, length: 38 )
• sourceGlobalID ( type: esriFieldTypeGUID, alias: sourceGlobalID, length: 38 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• created_user ( type: esriFieldTypeString, alias: created_user, length: 255 )
• created_date ( type: esriFieldTypeDate, alias: created_date, length: 8 )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, length: 255 )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, length: 8 )
• inspAP2Used ( type: esriFieldTypeString, alias: AP2 Used, length: 7 , Coded Values: [no: no] , [yes: yes] )
• inspTmReq ( type: esriFieldTypeString, alias: TM is required, length: 30 , Coded Values: [15 Min Delay Boards: 15 Min Delay Boards] , [2-Way Lights: 2-Way Lights] , [Lane Closure: Lane Closure] , ...8 more... )
• duplicate ( type: esriFieldTypeString, alias: duplicate, length: 5 , Coded Values: [no: no] , [yes: yes] )

Relationships:

• ASSET_SA (18) -- Related To: SCC_ASSET_SA (15)

Table: SCC_ASSET_TS_INSP (36)

Name: SCC_ASSET_TS_INSP

Display Field: created_date

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: 3efec8729f794e7a86718ff7f5769e14

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 200000

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
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: true
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true


HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• inspAssetNo ( type: esriFieldTypeInteger, alias: Asset ID )
• inspTargetDate ( type: esriFieldTypeDate, alias: Target date of inspection, length: 8 )
• inspId ( type: esriFieldTypeInteger, alias: Legacy Inspection ID )
• externalID ( type: esriFieldTypeString, alias: External ID, length: 40 )
• inspAssetType ( type: esriFieldTypeString, alias: Asset type, length: 20 , Coded Values: [AcoDrain: AcoDrain] , [BeanieBlocks: BeanieBlocks] , [Catchpit: Catchpit] , ...24 more... )
• crewArcReason ( type: esriFieldTypeString, alias: Crew archive reason, length: 20 , Coded Values: [Local Authority: Yes, Found] , [Not Found: Not Found] , [Duplicate: Duplicate] )
• inspAccessible ( type: esriFieldTypeString, alias: Access condition, length: 20 , Coded Values: [Excavation Required: Excavation Required] , [Inaccessible: Inaccessible] , [OK: OK] , ...4 more... )
• inspTm ( type: esriFieldTypeString, alias: What TM was used, length: 30 , Coded Values: [15 Min Delay Boards: 15 Min Delay Boards] , [2-Way Lights: 2-Way Lights] , [Lane Closure: Lane Closure] , ...8 more... )
• inspWorkType ( type: esriFieldTypeString, alias: Inspection type, length: 20 , Coded Values: [Cyclical: Cyclical] , [CycRemote: Cyclical - Remote] , [Day Works: Day Works] , ...1 more... )
• inspshift ( type: esriFieldTypeString, alias: Day or night shift, length: 12 , Coded Values: [Day shift: Day shift] , [Night shift: Night shift] )
• inspOpArrive ( type: esriFieldTypeString, alias: Operational on arrival, length: 30 , Coded Values: [No: No] , [Slow Runner: Slow Runner] , [Yes: Yes - Junction Flowing] )
• inspGenCon ( type: esriFieldTypeString, alias: Condition of structure, length: 30 , Coded Values: [Average: Average] , [Good: Good] , [Needs Attention / Repair: Needs Attention / Repair] )
• inspCoverCon ( type: esriFieldTypeString, alias: Condition of cover, length: 20 , Coded Values: [Broken Lid: Broken Lid] , [Buried on Arrival: Buried on Arrival] , [Missing: Missing] , ...3 more... )
• inspSiltDefect ( type: esriFieldTypeString, alias: Specify if defective, length: 40 , Coded Values: [Ditch Maintenance Required: Ditch Maintenance Required] , [Domestic Refuse: Domestic Refuse] , [Excessive Debris: Excessive Debris] , ...12 more... )
• inspSiltArrive ( type: esriFieldTypeSmallInteger, alias: Silt Level , Coded Values: [0: 0%] , [25: 25%] , [50: 50%] , ...2 more... )
• inspSiltDepart ( type: esriFieldTypeSmallInteger, alias: Depth to Base after Clean (%) , Coded Values: [0: 0%] , [25: 25%] , [50: 50%] , ...2 more... )
• inspCleaned ( type: esriFieldTypeString, alias: Drainage cleaned, length: 7 , Coded Values: [no: no] , [yes: yes] )
• inspComments ( type: esriFieldTypeString, alias: Inspection related comments, length: 50 , Coded Values: [3rd Party site blocking access: 3rd Party site blocking access] , [Can't reach with gully boom: Can't reach with gully boom] , [Filled with concrete: Filled with concrete] , ...6 more... )
• inspCommentsOther ( type: esriFieldTypeString, alias: Other inspection related comments, length: 680 )
• inspJetCompleted ( type: esriFieldTypeString, alias: Jetted, length: 7 , Coded Values: [no: no] , [yes: yes] )
• inspJettingTime ( type: esriFieldTypeSmallInteger, alias: Jetting time , Coded Values: [15: 15 Mins] , [30: 30 Mins] , [45: 45 Mins] , ...5 more... )
• inspJettingComments ( type: esriFieldTypeString, alias: Jetting related comments, length: 50 , Coded Values: [No access to jet: No access to jet] , [Suspected collapsed pipe: Suspected collapsed pipe] , [Jetted 1m to blockage: Jetted 1m to blockage] , ...15 more... )
• inspJettingCommentsOther ( type: esriFieldTypeString, alias: Other jetting related comments, length: 1000 )
• inspAP2 ( type: esriFieldTypeString, alias: AP2 Required, length: 7 , Coded Values: [no: no] , [yes: yes] )
• inspWeep ( type: esriFieldTypeString, alias: Weep Holes Cleaned, length: 10 , Coded Values: [Clear: Clear] , [Blocked: Blocked] )
• inspOpLeave ( type: esriFieldTypeString, alias: Was drainage operational on departure, length: 30 , Coded Values: [No: No] , [Slow Runner: Slow Runner] , [Yes: Yes - Junction Flowing] )
• inspPhotoComments ( type: esriFieldTypeString, alias: Photo related comments, length: 700 )
• inspAuditDate ( type: esriFieldTypeDate, alias: Inspection audit date, length: 8 )
• auditState ( type: esriFieldTypeString, alias: Result of audit, length: 7 , Coded Values: [Fail: Fail] , [Pass: Pass] )
• POINT_X ( type: esriFieldTypeDouble, alias: Easting )
• POINT_Y ( type: esriFieldTypeDouble, alias: Northing )
• inspRelGlobalID ( type: esriFieldTypeGUID, alias: Asset GlobalID, length: 38 )
• sourceGlobalID ( type: esriFieldTypeGUID, alias: sourceGlobalID, length: 38 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• created_user ( type: esriFieldTypeString, alias: created_user, length: 255 )
• created_date ( type: esriFieldTypeDate, alias: created_date, length: 8 )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, length: 255 )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, length: 8 )
• inspTmReq ( type: esriFieldTypeString, alias: TM is required, length: 30 , Coded Values: [15 Min Delay Boards: 15 Min Delay Boards] , [2-Way Lights: 2-Way Lights] , [Lane Closure: Lane Closure] , ...8 more... )
• duplicate ( type: esriFieldTypeString, alias: duplicate, length: 5 , Coded Values: [no: no] , [yes: yes] )

Relationships:

• ASSET_TS (19) -- Related To: SCC_ASSET_TS (16)

Table: SCC_ASSETS_INSP_AUDIT (37)

Name: SCC_ASSETS_INSP_AUDIT

Display Field: created_date

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: 3efec8729f794e7a86718ff7f5769e14

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 200000

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
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: true
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true


HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:
• assetID ( type: esriFieldTypeInteger, alias: Asset ID )
• auditMembers ( type: esriFieldTypeString, alias: Audited, length: 15 , Coded Values: [Drainline: Drainline] , [Joint: Joint] , [Ringway: Ringway] )
• auditState ( type: esriFieldTypeString, alias: Audit result, length: 7 , Coded Values: [Fail: Fail] , [Pass: Pass] )
• failReason ( type: esriFieldTypeString, alias: Reason for fail, length: 35 , Coded Values: [Not Set: Not Set] , [Not Cleaned to Specification: Not Cleaned to Specification] , [Not Jetted: Not Jetted] , ...2 more... )
• comment ( type: esriFieldTypeString, alias: Comments, length: 255 )
• relGlobalID ( type: esriFieldTypeGUID, alias: Related Guid, length: 38 )
• POINT_X ( type: esriFieldTypeDouble, alias: Easting )
• POINT_Y ( type: esriFieldTypeDouble, alias: Northing )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• created_user ( type: esriFieldTypeString, alias: created_user, length: 255 )
• created_date ( type: esriFieldTypeDate, alias: created_date, length: 8 )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, length: 255 )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, length: 8 )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )

Relationships:

• ASSET_CP_INSP (20) -- Related To: SCC_ASSET_CP_INSP (22)
• ASSET_GY_INSP (21) -- Related To: SCC_ASSET_GY_INSP (25)

Table: SCC_ASSETS_INSP_IRONWORK (39)

Name: SCC_ASSETS_INSP_IRONWORK

Display Field: created_date

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: 3efec8729f794e7a86718ff7f5769e14

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 200000

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
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: true
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true


HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:
• inspAssetNo ( type: esriFieldTypeInteger, alias: Asset ID )
• inspCommence ( type: esriFieldTypeString, alias: Can the works commence, length: 7 , Coded Values: [no: no] , [yes: yes] )
• inspReason ( type: esriFieldTypeString, alias: Abortion reason, length: 20 , Coded Values: [TM Req: TM required] , [No Defect: No defect found] , [Other: Other] )
• inspOthReason ( type: esriFieldTypeString, alias: Abortion reason other, length: 255 )
• inspTMReg ( type: esriFieldTypeString, alias: TM required , length: 30 , Coded Values: [15 Min Delay Boards: 15 Min Delay Boards] , [2-Way Lights: 2-Way Lights] , [Lane Closure: Lane Closure] , ...8 more... )
• inspRepair ( type: esriFieldTypeString, alias: Repair type, length: 15 , Coded Values: [Unjammed: Unjammed] , [Replaced: Replaced] , [DOA: Done on Arrival] )
• inspTMUsed ( type: esriFieldTypeString, alias: What TM was used, length: 30 , Coded Values: [15 Min Delay Boards: 15 Min Delay Boards] , [2-Way Lights: 2-Way Lights] , [Lane Closure: Lane Closure] , ...8 more... )
• inspMatGY100 ( type: esriFieldTypeSmallInteger, alias: Standard Gully 100mm , Coded Values: [0: None] , [1: Quantity used 1] , [2: Quantity used 2] , ...8 more... )
• inspMatGY150 ( type: esriFieldTypeSmallInteger, alias: Standard Gully 150mm , Coded Values: [0: None] , [1: Quantity used 1] , [2: Quantity used 2] , ...8 more... )
• inspMatGYse ( type: esriFieldTypeSmallInteger, alias: Side Entry Gully , Coded Values: [0: None] , [1: Quantity used 1] , [2: Quantity used 2] , ...8 more... )
• inspMatMH ( type: esriFieldTypeSmallInteger, alias: Manhole Cover/Frame , Coded Values: [0: None] , [1: Quantity used 1] , [2: Quantity used 2] , ...8 more... )
• inspMatM60 ( type: esriFieldTypeSmallInteger, alias: M60 , Coded Values: [0: None] , [1: Quantity used 1] , [2: Quantity used 2] , ...8 more... )
• inspMatQC10 ( type: esriFieldTypeSmallInteger, alias: QC10 , Coded Values: [0: None] , [1: Quantity used 1] , [2: Quantity used 2] , ...8 more... )
• inspMatCement ( type: esriFieldTypeSmallInteger, alias: Cement , Coded Values: [0: None] , [1: Quantity used 1] , [2: Quantity used 2] , ...8 more... )
• inspMatTarmac ( type: esriFieldTypeSmallInteger, alias: Tarmac Tubs/Bags , Coded Values: [0: None] , [1: Quantity used 1] , [2: Quantity used 2] , ...8 more... )
• inspMatShim12 ( type: esriFieldTypeSmallInteger, alias: Shim Pack 12mm , Coded Values: [0: None] , [1: Quantity used 1] , [2: Quantity used 2] , ...8 more... )
• inspMatShim24 ( type: esriFieldTypeSmallInteger, alias: Shim Pack 24mm , Coded Values: [0: None] , [1: Quantity used 1] , [2: Quantity used 2] , ...8 more... )
• inspMatShim36 ( type: esriFieldTypeSmallInteger, alias: Shim Pack 36mm , Coded Values: [0: None] , [1: Quantity used 1] , [2: Quantity used 2] , ...8 more... )
• inspMatBrick ( type: esriFieldTypeSmallInteger, alias: Bricks , Coded Values: [0: None] , [1: Quantity used 1] , [2: Quantity used 2] , ...8 more... )
• inspMatLintel ( type: esriFieldTypeSmallInteger, alias: Lintels , Coded Values: [0: None] , [1: Quantity used 1] , [2: Quantity used 2] , ...8 more... )
• inspComments ( type: esriFieldTypeString, alias: Inspection comments, length: 255 )
• inspRelGlobalID ( type: esriFieldTypeGUID, alias: Asset GlobalID, length: 38 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• created_user ( type: esriFieldTypeString, alias: created_user, length: 255 )
• created_date ( type: esriFieldTypeDate, alias: created_date, length: 8 )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, length: 255 )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, length: 8 )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )

Relationships:

• ASSET_CP (3) -- Related To: SCC_ASSET_CP (2)
• ASSET_SA (17) -- Related To: SCC_ASSET_SA (15)
• ASSET_GY (7) -- Related To: SCC_ASSET_GY (5)