Name: CCTV Report

Display Field: ProjectName

Type: Table

Geometry Type: N/A

Description:

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

Drawing Info:

N/A

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
Supports Returning Geometry Centroid: false

HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:

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

Templates:

• Name: CCTV Report
  Description:
  Prototype:
  GUID: null
  TotalLength: null
  FacilityID: null
  USID: null
  DSID: null
  Date: null
  SurveyedBy: null
  City_Member: null
  KEM_Member: null
  Direction: null
  ProjectName: null
  Street: null
  PipeSize: null
  PipeMaterial: null
  Remarks: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

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

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

Sync Can Return Changes: true

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

Supports ApplyEdits By Upload Id: true

Supports Query With Historic Moment: false

Supports Coordinates Quantization: false

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