View In:   ArcGIS Online Map Viewer

Name: CCTV Inspection Last Updated 8-7-24

Display Field: templatename

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description: Geospatial Geographic Information System (GIS) Utility Asset Infrastructure mapping combines survey grade traditional and global positioning system (GPS) utility asset infrastructure data, and object data tables to create accurate utility asset infrastructure system feature base maps.

Service Item Id: e2f400f02e264b858c166531e6e8efad

Copyright Text: Drafting Services, Capital Projects & Transportation

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

XMin: -1.35297379272E7
YMin: 4658933.005500004
XMax: -1.35278153137E7
YMax: 4661145.3314
Spatial Reference: 102100  (3857)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: maintscore
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
N/A
Default Label: N/A
UniqueValueInfos:
• Value: 0
  Label: 0 (Worst)
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [230, 0, 0, 255]
  Width: 2
• Value: 1
  Label: 1
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [255, 0, 197, 255]
  Width: 2
• Value: 2
  Label: 2
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [230, 152, 0, 255]
  Width: 2
• Value: 3
  Label: 3
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [230, 230, 0, 255]
  Width: 2
• Value: 4
  Label: 4
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [38, 115, 0, 255]
  Width: 2
• Value: 5
  Label: 5 (Best)
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [0, 77, 168, 255]
  Width: 2
• Value:
  Label: Not Inspected
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [52, 52, 52, 255]
  Width: 4
Transparency: 0
Labeling Info:
Label Placement: esriServerLinePlacementAboveAlong
Label Expression: N/A
Use Coded Values: true
Symbol:
Color: [0, 0, 0, 255]
Background Color: N/A
Outline Color: N/A
Vertical Alignment: bottom
Horizontal Alignment: left
Right to Left: false
Angle: 0
XOffset: 0
YOffset: 0
Size: 12
Font Family: Tahoma
Font Style: normal
Font Weight: normal
Font Decoration: none

Min. Scale: 0.0
Max. Scale: 0.0

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: true
Supports Returning Geometry Centroid: false
Supports Binning LOD: true
Supports Query With LOD Spatial Reference: true
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: maintscore

Fields:

• objectid ( nullable: false, defaultValue: null, editable: false, length: 4, type: esriFieldTypeOID, modelName: OBJECTID, alias: OBJECTID )
• fme_date ( modelName: fme_date, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: FME date, type: esriFieldTypeDate )
• wsid ( modelName: wsid, nullable: true, editable: true, defaultValue: null, length: 25, alias: WSID, type: esriFieldTypeString )
• tbl_sewermain_int ( modelName: tbl_sewermain_int, nullable: true, editable: true, defaultValue: null, alias: tbl_SewerMain_int, type: esriFieldTypeDouble )
• material ( modelName: material, nullable: true, editable: true, defaultValue: null, length: 10, alias: Material, type: esriFieldTypeString )
• diameter ( modelName: diameter, nullable: true, editable: true, defaultValue: null, length: 10, alias: Diameter, type: esriFieldTypeString )
• subtype ( modelName: subtype, nullable: true, editable: true, defaultValue: null, length: 25, alias: Subtype, type: esriFieldTypeString )
• recdwg ( modelName: recdwg, nullable: true, editable: true, defaultValue: null, length: 25, alias: RecDwg, type: esriFieldTypeString )
• locationdescription ( modelName: locationdescription, nullable: true, editable: true, defaultValue: null, length: 25, alias: LocationDescription, type: esriFieldTypeString )
• lifecyclestatus ( modelName: lifecyclestatus, nullable: true, editable: true, defaultValue: null, length: 25, alias: LifecycleStatus, type: esriFieldTypeString )
• enabled ( modelName: enabled, nullable: true, editable: true, defaultValue: null, length: 10, alias: Enabled, type: esriFieldTypeString )
• dateinstalled ( modelName: dateinstalled, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: DateInstalled, type: esriFieldTypeDate )
• specialfieldid ( modelName: specialfieldid, nullable: true, editable: true, defaultValue: null, alias: SpecialFieldID, type: esriFieldTypeInteger )
• sessionid ( modelName: sessionid, nullable: true, editable: true, defaultValue: null, alias: SessionID, type: esriFieldTypeInteger )
• templatename ( modelName: templatename, nullable: true, editable: true, defaultValue: null, length: 50, alias: TemplateName, type: esriFieldTypeString )
• projectname ( modelName: projectname, nullable: true, editable: true, defaultValue: null, length: 100, alias: ProjectName, type: esriFieldTypeString )
• operatorname ( modelName: operatorname, nullable: true, editable: true, defaultValue: null, length: 100, alias: OperatorName, type: esriFieldTypeString )
• useofsewer ( modelName: useofsewer, nullable: true, editable: true, defaultValue: null, length: 100, alias: UseOfSewer, type: esriFieldTypeString )
• flowdirection ( modelName: flowdirection, nullable: true, editable: true, defaultValue: null, length: 100, alias: FlowDirection, type: esriFieldTypeString )
• workordernumber ( modelName: workordernumber, nullable: true, editable: true, defaultValue: null, length: 100, alias: WorkOrderNumber, type: esriFieldTypeString )
• city ( modelName: city, nullable: true, editable: true, defaultValue: null, length: 100, alias: City, type: esriFieldTypeString )
• state ( modelName: state, nullable: true, editable: true, defaultValue: null, length: 100, alias: State, type: esriFieldTypeString )
• assetid ( modelName: assetid, nullable: true, editable: true, defaultValue: null, length: 100, alias: AssetID, type: esriFieldTypeString )
• material_1 ( modelName: material_1, nullable: true, editable: true, defaultValue: null, length: 100, alias: Material, type: esriFieldTypeString )
• inspdate ( modelName: inspdate, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: INSPDate, type: esriFieldTypeDate )
• assetsize ( modelName: assetsize, nullable: true, editable: true, defaultValue: null, length: 100, alias: AssetSize, type: esriFieldTypeString )
• asset_shape ( modelName: asset_shape, nullable: true, editable: true, defaultValue: null, length: 100, alias: Asset_Shape, type: esriFieldTypeString )
• assetlocation ( modelName: assetlocation, nullable: true, editable: true, defaultValue: null, length: 100, alias: AssetLocation, type: esriFieldTypeString )
• startid ( modelName: startid, nullable: true, editable: true, defaultValue: null, length: 100, alias: StartID, type: esriFieldTypeString )
• startdepth ( modelName: startdepth, nullable: true, editable: true, defaultValue: null, length: 100, alias: StartDepth, type: esriFieldTypeString )
• endid ( modelName: endid, nullable: true, editable: true, defaultValue: null, length: 100, alias: EndID, type: esriFieldTypeString )
• enddepth ( modelName: enddepth, nullable: true, editable: true, defaultValue: null, length: 100, alias: EndDepth, type: esriFieldTypeString )
• lengthsurveryed ( modelName: lengthsurveryed, nullable: true, editable: true, defaultValue: null, alias: LengthSurveryed, type: esriFieldTypeDouble )
• fullsegmentinspectioncomplete ( modelName: fullsegmentinspectioncomplete, nullable: true, editable: true, defaultValue: null, alias: FullSegmentInspectionComplete, type: esriFieldTypeSmallInteger )
• pacpquickstructrating ( modelName: pacpquickstructrating, nullable: true, editable: true, defaultValue: null, length: 4, alias: PacpQuickStructRating, type: esriFieldTypeString )
• structscore ( modelName: structscore, nullable: true, editable: true, defaultValue: null, length: 1, alias: StructScore, type: esriFieldTypeString )
• maintscore ( modelName: maintscore, nullable: true, editable: true, defaultValue: null, length: 1, alias: MaintScore, type: esriFieldTypeString )
• htmlreports ( modelName: htmlreports, nullable: true, editable: true, defaultValue: null, length: 255, alias: HTMLReports, type: esriFieldTypeString )
• webpathtovideo ( modelName: webpathtovideo, nullable: true, editable: true, defaultValue: null, length: 255, alias: WebPathToVideo, type: esriFieldTypeString )
• numtaps ( modelName: numtaps, nullable: true, editable: true, defaultValue: null, alias: NumTaps, type: esriFieldTypeInteger )
• numroots ( modelName: numroots, nullable: true, editable: true, defaultValue: null, alias: NumRoots, type: esriFieldTypeInteger )
• numcrfr ( modelName: numcrfr, nullable: true, editable: true, defaultValue: null, alias: NumCrFr, type: esriFieldTypeInteger )
• numbrholescol ( modelName: numbrholescol, nullable: true, editable: true, defaultValue: null, alias: NumBrHolesCol, type: esriFieldTypeInteger )
• numdeposits ( modelName: numdeposits, nullable: true, editable: true, defaultValue: null, alias: NumDeposits, type: esriFieldTypeInteger )
• numobstruction ( modelName: numobstruction, nullable: true, editable: true, defaultValue: null, alias: NumObstruction, type: esriFieldTypeInteger )
• numabndsurvey ( modelName: numabndsurvey, nullable: true, editable: true, defaultValue: null, alias: NumAbndSurvey, type: esriFieldTypeInteger )
• crossborefound ( modelName: crossborefound, nullable: true, editable: true, defaultValue: null, length: 25, alias: CrossBoreFound, type: esriFieldTypeString )
• reasonnotcomplete ( modelName: reasonnotcomplete, nullable: true, editable: true, defaultValue: null, length: 255, alias: ReasonNotComplete, type: esriFieldTypeString )
• certificate_number ( modelName: certificate_number, nullable: true, editable: true, defaultValue: null, length: 100, alias: Certificate_Number, type: esriFieldTypeString )
• resurveyrequired ( modelName: resurveyrequired, nullable: true, editable: true, defaultValue: null, alias: ResurveyRequired, type: esriFieldTypeSmallInteger )
• lofpacp ( modelName: lofpacp, nullable: true, editable: true, defaultValue: null, alias: LoFPACP, type: esriFieldTypeDouble )
• risk ( modelName: risk, nullable: true, editable: true, defaultValue: null, alias: Risk, type: esriFieldTypeDouble )
• islatestinspection ( modelName: islatestinspection, nullable: true, editable: true, defaultValue: null, alias: IsLatestInspection, type: esriFieldTypeSmallInteger )
• SHAPE__Length ( virtual: true, nullable: true, editable: false, defaultValue: null, alias: SHAPE__Length, type: esriFieldTypeDouble )

Types:

ID: 0
Name: 0 (Worst)
Domains:
Templates:
• Name: 0
  Description:
  Prototype:
  flowdirection: null
  assetsize: null
  sessionid: null
  specialfieldid: null
  fullsegmentinspectioncomplete: null
  numbrholescol: null
  diameter: null
  startid: null
  material_1: null
  state: null
  tbl_sewermain_int: null
  resurveyrequired: null
  projectname: null
  htmlreports: null
  inspdate: null
  numdeposits: null
  reasonnotcomplete: null
  structscore: null
  asset_shape: null
  lofpacp: null
  islatestinspection: null
  operatorname: null
  wsid: null
  numabndsurvey: null
  numcrfr: null
  city: null
  pacpquickstructrating: null
  fme_date: null
  enabled: null
  certificate_number: null
  lifecyclestatus: null
  webpathtovideo: null
  enddepth: null
  subtype: null
  dateinstalled: null
  templatename: null
  startdepth: null
  assetlocation: null
  recdwg: null
  lengthsurveryed: null
  maintscore: null
  crossborefound: null
  numobstruction: null
  locationdescription: null
  material: null
  endid: null
  assetid: null
  workordernumber: null
  risk: null
  numtaps: null
  numroots: null
  useofsewer: null
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: 1
Name: 1
Domains:
Templates:
• Name: 1
  Description:
  Prototype:
  flowdirection: null
  assetsize: null
  sessionid: null
  specialfieldid: null
  fullsegmentinspectioncomplete: null
  numbrholescol: null
  diameter: null
  startid: null
  material_1: null
  state: null
  tbl_sewermain_int: null
  resurveyrequired: null
  projectname: null
  htmlreports: null
  inspdate: null
  numdeposits: null
  reasonnotcomplete: null
  structscore: null
  asset_shape: null
  lofpacp: null
  islatestinspection: null
  operatorname: null
  wsid: null
  numabndsurvey: null
  numcrfr: null
  city: null
  pacpquickstructrating: null
  fme_date: null
  enabled: null
  certificate_number: null
  lifecyclestatus: null
  webpathtovideo: null
  enddepth: null
  subtype: null
  dateinstalled: null
  templatename: null
  startdepth: null
  assetlocation: null
  recdwg: null
  lengthsurveryed: null
  maintscore: null
  crossborefound: null
  numobstruction: null
  locationdescription: null
  material: null
  endid: null
  assetid: null
  workordernumber: null
  risk: null
  numtaps: null
  numroots: null
  useofsewer: null
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: 2
Name: 2
Domains:
Templates:
• Name: 2
  Description:
  Prototype:
  flowdirection: null
  assetsize: null
  sessionid: null
  specialfieldid: null
  fullsegmentinspectioncomplete: null
  numbrholescol: null
  diameter: null
  startid: null
  material_1: null
  state: null
  tbl_sewermain_int: null
  resurveyrequired: null
  projectname: null
  htmlreports: null
  inspdate: null
  numdeposits: null
  reasonnotcomplete: null
  structscore: null
  asset_shape: null
  lofpacp: null
  islatestinspection: null
  operatorname: null
  wsid: null
  numabndsurvey: null
  numcrfr: null
  city: null
  pacpquickstructrating: null
  fme_date: null
  enabled: null
  certificate_number: null
  lifecyclestatus: null
  webpathtovideo: null
  enddepth: null
  subtype: null
  dateinstalled: null
  templatename: null
  startdepth: null
  assetlocation: null
  recdwg: null
  lengthsurveryed: null
  maintscore: null
  crossborefound: null
  numobstruction: null
  locationdescription: null
  material: null
  endid: null
  assetid: null
  workordernumber: null
  risk: null
  numtaps: null
  numroots: null
  useofsewer: null
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: 3
Name: 3
Domains:
Templates:
• Name: 3
  Description:
  Prototype:
  flowdirection: null
  assetsize: null
  sessionid: null
  specialfieldid: null
  fullsegmentinspectioncomplete: null
  numbrholescol: null
  diameter: null
  startid: null
  material_1: null
  state: null
  tbl_sewermain_int: null
  resurveyrequired: null
  projectname: null
  htmlreports: null
  inspdate: null
  numdeposits: null
  reasonnotcomplete: null
  structscore: null
  asset_shape: null
  lofpacp: null
  islatestinspection: null
  operatorname: null
  wsid: null
  numabndsurvey: null
  numcrfr: null
  city: null
  pacpquickstructrating: null
  fme_date: null
  enabled: null
  certificate_number: null
  lifecyclestatus: null
  webpathtovideo: null
  enddepth: null
  subtype: null
  dateinstalled: null
  templatename: null
  startdepth: null
  assetlocation: null
  recdwg: null
  lengthsurveryed: null
  maintscore: null
  crossborefound: null
  numobstruction: null
  locationdescription: null
  material: null
  endid: null
  assetid: null
  workordernumber: null
  risk: null
  numtaps: null
  numroots: null
  useofsewer: null
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: 4
Name: 4
Domains:
Templates:
• Name: 4
  Description:
  Prototype:
  flowdirection: null
  assetsize: null
  sessionid: null
  specialfieldid: null
  fullsegmentinspectioncomplete: null
  numbrholescol: null
  diameter: null
  startid: null
  material_1: null
  state: null
  tbl_sewermain_int: null
  resurveyrequired: null
  projectname: null
  htmlreports: null
  inspdate: null
  numdeposits: null
  reasonnotcomplete: null
  structscore: null
  asset_shape: null
  lofpacp: null
  islatestinspection: null
  operatorname: null
  wsid: null
  numabndsurvey: null
  numcrfr: null
  city: null
  pacpquickstructrating: null
  fme_date: null
  enabled: null
  certificate_number: null
  lifecyclestatus: null
  webpathtovideo: null
  enddepth: null
  subtype: null
  dateinstalled: null
  templatename: null
  startdepth: null
  assetlocation: null
  recdwg: null
  lengthsurveryed: null
  maintscore: null
  crossborefound: null
  numobstruction: null
  locationdescription: null
  material: null
  endid: null
  assetid: null
  workordernumber: null
  risk: null
  numtaps: null
  numroots: null
  useofsewer: null
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: 5
Name: 5 (Best)
Domains:
Templates:
• Name: 5
  Description:
  Prototype:
  flowdirection: null
  assetsize: null
  sessionid: null
  specialfieldid: null
  fullsegmentinspectioncomplete: null
  numbrholescol: null
  diameter: null
  startid: null
  material_1: null
  state: null
  tbl_sewermain_int: null
  resurveyrequired: null
  projectname: null
  htmlreports: null
  inspdate: null
  numdeposits: null
  reasonnotcomplete: null
  structscore: null
  asset_shape: null
  lofpacp: null
  islatestinspection: null
  operatorname: null
  wsid: null
  numabndsurvey: null
  numcrfr: null
  city: null
  pacpquickstructrating: null
  fme_date: null
  enabled: null
  certificate_number: null
  lifecyclestatus: null
  webpathtovideo: null
  enddepth: null
  subtype: null
  dateinstalled: null
  templatename: null
  startdepth: null
  assetlocation: null
  recdwg: null
  lengthsurveryed: null
  maintscore: null
  crossborefound: null
  numobstruction: null
  locationdescription: null
  material: null
  endid: null
  assetid: null
  workordernumber: null
  risk: null
  numtaps: null
  numroots: null
  useofsewer: null
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: null
Name: Not Inspected
Domains:
Templates:
• Name:
  Description:
  Prototype:
  flowdirection: null
  assetsize: null
  sessionid: null
  specialfieldid: null
  fullsegmentinspectioncomplete: null
  numbrholescol: null
  diameter: null
  startid: null
  material_1: null
  state: null
  tbl_sewermain_int: null
  resurveyrequired: null
  projectname: null
  htmlreports: null
  inspdate: null
  numdeposits: null
  reasonnotcomplete: null
  structscore: null
  asset_shape: null
  lofpacp: null
  islatestinspection: null
  operatorname: null
  wsid: null
  numabndsurvey: null
  numcrfr: null
  city: null
  pacpquickstructrating: null
  fme_date: null
  enabled: null
  certificate_number: null
  lifecyclestatus: null
  webpathtovideo: null
  enddepth: null
  subtype: null
  dateinstalled: null
  templatename: null
  startdepth: null
  assetlocation: null
  recdwg: null
  lengthsurveryed: null
  maintscore: null
  crossborefound: null
  numobstruction: null
  locationdescription: null
  material: null
  endid: null
  assetid: null
  workordernumber: null
  risk: null
  numtaps: null
  numroots: null
  useofsewer: null
  
  Drawing Tool: esriFeatureEditToolLine

---

Capabilities: Query,Extract

Sync Can Return Changes: true

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: false

Supports ApplyEdits By Upload Id: true

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Child Resources:   Field Groups   Contingent Values

Supported Operations:   Query   Query Attachments   Query Analytic   Query Top Features   Query Bins   Append   Validate SQL   Generate Renderer   Return Updates   Metadata   Update Metadata