Name: CCTV Report

Display Field: ProjectName

Type: Table

Geometry Type: N/A

Description: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 2000

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

HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• FacilityID ( type: esriFieldTypeString, alias: Facility ID, length: 255 )
• USID ( type: esriFieldTypeString, alias: Upstream ID, length: 255 )
• DSID ( type: esriFieldTypeString, alias: Downstream ID, length: 255 )
• Date ( type: esriFieldTypeDate, alias: Date, length: 8 )
• SurveyedBy ( type: esriFieldTypeString, alias: Surveyed By, length: 255 , Coded Values: [City: City of Mansfield] , [KEM: K.E. McCartney] , [I&I: Lining Contractor] , ...1 more... )
• City_Member ( type: esriFieldTypeString, alias: City Member, length: 255 )
• KEM_Member ( type: esriFieldTypeString, alias: KEM Member, length: 255 , Coded Values: [BL: Brandon Luers] , [DU: Dan Utt] , [JH: Jason Hartman] , ...4 more... )
• Direction ( type: esriFieldTypeString, alias: Direction, length: 255 , Coded Values: [US: Upstream] , [DS: Downstream] )
• ProjectName ( type: esriFieldTypeString, alias: Project Name, length: 255 )
• Street ( type: esriFieldTypeString, alias: Street/Location, length: 255 )
• PipeSize ( type: esriFieldTypeDouble, alias: Pipe Size , Coded Values: [0.75: 3/4"] , [1: 1"] , [1.25: 1 1/4"] , ...32 more... )
• PipeMaterial ( type: esriFieldTypeString, alias: Pipe Material, length: 255 , Coded Values: [CIP: Cast Iron] , [CMP: Corrugated Metal Pipe] , [COP: Copper] , ...19 more... )
• Remarks ( type: esriFieldTypeString, alias: Remarks, length: 255 )
• TotalLength ( type: esriFieldTypeString, alias: Total Length, length: 255 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• GUID ( type: esriFieldTypeGUID, alias: GUID, length: 38 )

Relationships:

• UTILITY_MASTER_SDE.DBO.dGravityMain (1) -- Related To: Gravity Main (8)

Supported Operations:   Query   Query Attachments   Query Related Records   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata