Name: CCTV Data Table

Display Field: streetName

Type: Table

Geometry Type: N/A

Description:

Copyright Text:

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON

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: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• Contractor ( type: esriFieldTypeString, alias: Contractor, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Contractor )
• YearStarted ( type: esriFieldTypeInteger, alias: YearStarted, editable: true, nullable: true, defaultValue: null, modelName: YearStarted )
• YearComplete ( type: esriFieldTypeInteger, alias: YearComplete, editable: true, nullable: true, defaultValue: null, modelName: YearComplete )
• fromNode ( type: esriFieldTypeString, alias: fromNode, editable: true, nullable: true, length: 255, defaultValue: null, modelName: fromNode )
• toNode ( type: esriFieldTypeString, alias: toNode, editable: true, nullable: true, length: 255, defaultValue: null, modelName: toNode )
• pipeFacilityID ( type: esriFieldTypeString, alias: pipeFacilityID, editable: true, nullable: true, length: 255, defaultValue: null, modelName: pipeFacilityID )
• flowDirection ( type: esriFieldTypeString, alias: flowDirection, editable: true, nullable: true, length: 255, defaultValue: null, modelName: flowDirection )
• Material ( type: esriFieldTypeString, alias: Material, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Material )
• innerDiameter ( type: esriFieldTypeSmallInteger, alias: innerDiameter, editable: true, nullable: true, defaultValue: null, modelName: innerDiameter )
• Condition ( type: esriFieldTypeString, alias: Condition, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Condition )
• timeStampOnVideo ( type: esriFieldTypeString, alias: timeStampOnVideo, editable: true, nullable: true, length: 255, defaultValue: null, modelName: timeStampOnVideo )
• TotalPipeSegmentLengthFT ( type: esriFieldTypeDouble, alias: TotalPipeSegmentLengthFT, editable: true, nullable: true, defaultValue: null, modelName: TotalPipeSegmentLengthFT )
• featureDescription ( type: esriFieldTypeString, alias: featureDescription, editable: true, nullable: true, length: 255, defaultValue: null, modelName: featureDescription )
• featureLocationFT ( type: esriFieldTypeDouble, alias: featureLocationFT, editable: true, nullable: true, defaultValue: null, modelName: featureLocationFT )
• featurePositionClockBearing ( type: esriFieldTypeInteger, alias: featurePositionClockBearing, editable: true, nullable: true, defaultValue: null, modelName: featurePositionClockBearing )
• featureSizeIN ( type: esriFieldTypeInteger, alias: featureSizeIN, editable: true, nullable: true, defaultValue: null, modelName: featureSizeIN )
• featureRepairDesc ( type: esriFieldTypeString, alias: featureRepairDesc, editable: true, nullable: true, length: 255, defaultValue: null, modelName: featureRepairDesc )
• tapStatus ( type: esriFieldTypeString, alias: tapStatus, editable: true, nullable: true, length: 255, defaultValue: null, modelName: tapStatus )
• materialChange ( type: esriFieldTypeString, alias: materialChange, editable: true, nullable: true, length: 255, defaultValue: null, modelName: materialChange )
• percentObstructed ( type: esriFieldTypeInteger, alias: percentObstructed, editable: true, nullable: true, defaultValue: null, modelName: percentObstructed )
• surveyAbandoned ( type: esriFieldTypeString, alias: surveyAbandoned, editable: true, nullable: true, length: 255, defaultValue: null, modelName: surveyAbandoned )
• surveyAbandonedReason ( type: esriFieldTypeString, alias: surveyAbandonedReason, editable: true, nullable: true, length: 255, defaultValue: null, modelName: surveyAbandonedReason )
• nasscoCode ( type: esriFieldTypeString, alias: nasscoCode, editable: true, nullable: true, length: 255, defaultValue: null, modelName: nasscoCode )
• Notes ( type: esriFieldTypeString, alias: Notes, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Notes )
• streetName ( type: esriFieldTypeString, alias: Street Name, editable: true, nullable: true, length: 500, defaultValue: null, modelName: streetName )
• Utility ( type: esriFieldTypeString, alias: Utility System, editable: true, nullable: true, length: 100, defaultValue: null, modelName: Utility )
• QAnodeMismatch ( type: esriFieldTypeString, alias: QA Node Mismatch, editable: true, nullable: true, length: 255, defaultValue: null, modelName: QAnodeMismatch )
• diameterChange ( type: esriFieldTypeInteger, alias: Diameter Change, editable: true, nullable: true, defaultValue: null, modelName: diameterChange )
• MissingLocation ( type: esriFieldTypeString, alias: QA Missing Location, editable: true, nullable: true, length: 255, defaultValue: null, modelName: MissingLocation )
• instrusionSizeInch ( type: esriFieldTypeInteger, alias: Intrusion Size (in.), editable: true, nullable: true, defaultValue: null, modelName: instrusionSizeInch )
• dateInspection ( type: esriFieldTypeDate, alias: dateInspection, editable: true, nullable: true, length: 8, defaultValue: null, modelName: dateInspection )
• dateSubmittedToTown ( type: esriFieldTypeDate, alias: dateSubmittedToTown, editable: true, nullable: true, length: 8, defaultValue: null, modelName: dateSubmittedToTown )
• submittedBy ( type: esriFieldTypeString, alias: submittedBy, editable: true, nullable: true, length: 255, defaultValue: null, modelName: submittedBy )
• nasscoGroup ( type: esriFieldTypeString, alias: nasscoGroup, editable: true, nullable: true, length: 255, defaultValue: null, modelName: nasscoGroup )
• nasscoDescription ( type: esriFieldTypeString, alias: nasscoDescription, editable: true, nullable: true, length: 255, defaultValue: null, modelName: nasscoDescription )
• created_user ( type: esriFieldTypeString, alias: created_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: created_user )
• created_date ( type: esriFieldTypeDate, alias: created_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created_date )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
• streetNameGIS ( type: esriFieldTypeString, alias: streetNameGIS, editable: true, nullable: true, length: 255, defaultValue: null, modelName: streetNameGIS )
• assetFACILITYID ( type: esriFieldTypeString, alias: assetFACILITYID, editable: true, nullable: true, length: 255, defaultValue: null, modelName: assetFACILITYID )
• sewerShed ( type: esriFieldTypeString, alias: sewerShed, editable: true, nullable: true, length: 255, defaultValue: null, modelName: sewerShed )
• issueGroup ( type: esriFieldTypeString, alias: issueGroup, editable: true, nullable: true, length: 255, defaultValue: null, modelName: issueGroup )
• OCIRating ( type: esriFieldTypeInteger, alias: OCIRating, editable: true, nullable: true, defaultValue: null, modelName: OCIRating )

Templates:

• Name: CCTV Data Table
  Description:
  Prototype:
  issueGroup: null
  OCIRating: null
  Contractor: null
  YearStarted: null
  YearComplete: null
  fromNode: null
  toNode: null
  pipeFacilityID: null
  flowDirection: null
  Material: null
  innerDiameter: null
  Condition: null
  timeStampOnVideo: null
  TotalPipeSegmentLengthFT: null
  featureDescription: null
  featureLocationFT: null
  featurePositionClockBearing: null
  featureSizeIN: null
  featureRepairDesc: null
  tapStatus: null
  materialChange: null
  percentObstructed: null
  surveyAbandoned: null
  surveyAbandonedReason: null
  nasscoCode: null
  Notes: null
  streetName: null
  Utility: null
  QAnodeMismatch: null
  diameterChange: null
  MissingLocation: null
  instrusionSizeInch: null
  dateInspection: null
  dateSubmittedToTown: null
  submittedBy: null
  nasscoGroup: null
  nasscoDescription: null
  sewerShed: null
  assetFACILITYID: null
  streetNameGIS: null
  
  Drawing Tool: esriFeatureEditToolNone

Capabilities: Query,Create,Update,Uploads,Editing

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: false

Edit Fields Info:

• Creation Date Field: created_date
• Creator Field: created_user
• Edit Date Field: last_edited_date
• Editor Field: last_edited_user

Supports Query With Historic Moment: false

Supports Coordinates Quantization: false

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