Name: CCTV Data Table

Display Field: streetName

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 )
• Contractor ( type: esriFieldTypeString, alias: Contractor, length: 255 )
• YearStarted ( type: esriFieldTypeInteger, alias: YearStarted )
• YearComplete ( type: esriFieldTypeInteger, alias: YearComplete )
• fromNode ( type: esriFieldTypeString, alias: fromNode, length: 255 )
• toNode ( type: esriFieldTypeString, alias: toNode, length: 255 )
• pipeFacilityID ( type: esriFieldTypeString, alias: pipeFacilityID, length: 255 )
• flowDirection ( type: esriFieldTypeString, alias: flowDirection, length: 255 )
• Material ( type: esriFieldTypeString, alias: Material, length: 255 )
• innerDiameter ( type: esriFieldTypeSmallInteger, alias: innerDiameter )
• Condition ( type: esriFieldTypeString, alias: Condition, length: 255 )
• timeStampOnVideo ( type: esriFieldTypeString, alias: timeStampOnVideo, length: 255 )
• TotalPipeSegmentLengthFT ( type: esriFieldTypeDouble, alias: TotalPipeSegmentLengthFT )
• featureDescription ( type: esriFieldTypeString, alias: featureDescription, length: 255 )
• featureLocationFT ( type: esriFieldTypeDouble, alias: featureLocationFT )
• featurePositionClockBearing ( type: esriFieldTypeInteger, alias: featurePositionClockBearing )
• featureSizeIN ( type: esriFieldTypeInteger, alias: featureSizeIN )
• featureRepairDesc ( type: esriFieldTypeString, alias: featureRepairDesc, length: 255 )
• tapStatus ( type: esriFieldTypeString, alias: tapStatus, length: 255 )
• materialChange ( type: esriFieldTypeString, alias: materialChange, length: 255 )
• percentObstructed ( type: esriFieldTypeInteger, alias: percentObstructed )
• surveyAbandoned ( type: esriFieldTypeString, alias: surveyAbandoned, length: 255 )
• surveyAbandonedReason ( type: esriFieldTypeString, alias: surveyAbandonedReason, length: 255 )
• nasscoCode ( type: esriFieldTypeString, alias: nasscoCode, length: 255 )
• Notes ( type: esriFieldTypeString, alias: Notes, length: 255 )
• streetName ( type: esriFieldTypeString, alias: Street Name, length: 500 )
• Utility ( type: esriFieldTypeString, alias: Utility System, length: 100 )
• QAnodeMismatch ( type: esriFieldTypeString, alias: QA Node Mismatch, length: 255 )
• diameterChange ( type: esriFieldTypeInteger, alias: Diameter Change )
• MissingLocation ( type: esriFieldTypeString, alias: QA Missing Location, length: 255 )
• instrusionSizeInch ( type: esriFieldTypeInteger, alias: Intrusion Size (in.) )
• dateInspection ( type: esriFieldTypeDate, alias: dateInspection, length: 8 )
• dateSubmittedToTown ( type: esriFieldTypeDate, alias: dateSubmittedToTown, length: 8 )
• submittedBy ( type: esriFieldTypeString, alias: submittedBy, length: 255 )
• nasscoGroup ( type: esriFieldTypeString, alias: nasscoGroup, length: 255 )
• nasscoDescription ( type: esriFieldTypeString, alias: nasscoDescription, length: 255 )
• 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 )
• streetNameGIS ( type: esriFieldTypeString, alias: streetNameGIS, length: 255 )
• assetFACILITYID ( type: esriFieldTypeString, alias: assetFACILITYID, length: 255 )
• sewerShed ( type: esriFieldTypeString, alias: sewerShed, length: 255 )
• issueGroup ( type: esriFieldTypeString, alias: issueGroup, length: 255 )
• OCIRating ( type: esriFieldTypeInteger, alias: OCIRating )

Supported Operations:   Query   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata