Name: Operations.GIS_ADMIN.Lateral_CCTV_Reference

Display Field: STREET_NAME

Type: Table

Geometry Type: N/A

Description: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON

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

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• LAST_USER ( type: esriFieldTypeString, alias: LAST_USER, length: 20 )
• EDIT_DATE ( type: esriFieldTypeDate, alias: EDIT_DATE, length: 8 )
• VIDEO_ID ( type: esriFieldTypeInteger, alias: VIDEO_ID )
• VIDEO_FILE ( type: esriFieldTypeString, alias: VIDEO_FILE, length: 100 )
• VIDEO_FILE_PATH ( type: esriFieldTypeString, alias: VIDEO_FILE_PATH, length: 255 )
• CCTV_DATE ( type: esriFieldTypeDate, alias: CCTV_DATE, length: 8 )
• CCTV_TIME ( type: esriFieldTypeDate, alias: CCTV_TIME, length: 8 )
• POINT_ID ( type: esriFieldTypeInteger, alias: POINT_ID )
• ADDRESS ( type: esriFieldTypeString, alias: ADDRESS, length: 100 )
• HSE_NUMBER ( type: esriFieldTypeInteger, alias: HSE_NUMBER )
• STREET_NAME ( type: esriFieldTypeString, alias: STREET_NAME, length: 50 )
• WO_ID ( type: esriFieldTypeInteger, alias: WO_ID )
• SOURCE ( type: esriFieldTypeString, alias: SOURCE, length: 30 , Coded Values: [MNT: DPW Maintenance Division] , [LIRP: Lateral Inspection and Renewal Program] , [SSO/WIC: Contractor CCTV for SSO/WIC Investigation] )
• SURVEY_LENGTH ( type: esriFieldTypeDouble, alias: SURVEY_LENGTH )
• TOTAL_LENGTH ( type: esriFieldTypeDouble, alias: TOTAL_LENGTH )
• PURPOSE ( type: esriFieldTypeString, alias: PURPOSE, length: 1 , Coded Values: [B: I/I Investigation] , [C: Post Rehab Survey] , [D: Pre-Rehab Survey] , ...7 more... )
• PRECLEANING ( type: esriFieldTypeString, alias: PRECLEANING, length: 1 , Coded Values: [H: Heavy Clean] , [J: Jetting] , [N: No Pre-Cleaning] , ...1 more... )
• OPERATOR ( type: esriFieldTypeString, alias: OPERATOR, length: 50 )
• DIAMETER ( type: esriFieldTypeInteger, alias: DIAMETER )
• MATERIAL_OBSERVED ( type: esriFieldTypeString, alias: MATERIAL_OBSERVED, length: 10 )
• LINING_OBSERVED ( type: esriFieldTypeString, alias: LINING_OBSERVED, length: 10 )
• LENGTH_PROPERTY_LINE ( type: esriFieldTypeDouble, alias: LENGTH_PROPERTY_LINE )
• TAP_LOCATION ( type: esriFieldTypeString, alias: TAP_LOCATION, length: 38 )
• US_MH ( type: esriFieldTypeString, alias: US_MH, length: 20 )
• DS_MH ( type: esriFieldTypeString, alias: DS_MH, length: 20 )
• SURVEY_DIRECTION ( type: esriFieldTypeString, alias: SURVEY_DIRECTION, length: 10 )
• STRUCT_QUICK_RATING ( type: esriFieldTypeString, alias: STRUCT_QUICK_RATING, length: 10 )
• OM_QUICK_RATING ( type: esriFieldTypeString, alias: OM_QUICK_RATING, length: 10 )
• WORK_PACKAGE_ID ( type: esriFieldTypeInteger, alias: WORK_PACKAGE_ID )
• PRIORITY_STATUS ( type: esriFieldTypeString, alias: PRIORITY_STATUS, length: 3 , Coded Values: [P1: P1] , [P2: P2] , [P3: P3] , ...3 more... )
• NO_REVIEW_NEEDED ( type: esriFieldTypeSmallInteger, alias: NO_REVIEW_NEEDED , Coded Values: [0: False] , [1: True] )
• NO_CCTV_AS_OF ( type: esriFieldTypeDate, alias: NO_CCTV_AS_OF, length: 8 )
• CCTV_DATABASE ( type: esriFieldTypeString, alias: CCTV_DATABASE, length: 25 )
• DATABASE_PROJECT ( type: esriFieldTypeString, alias: DATABASE_PROJECT, length: 25 )

Supported Operations:   Query   Query Attachments   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata