Layers:

Layer: CCTV_Inspected_Mains_Export (0)

Name: CCTV_Inspected_Mains_Export

Display Field: InspectionName

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description: GIS_Edits.SDE.CCTV_Inspected_Mains_Export

Service Item Id: 1c7134893cd9486bbf044e8a0bf044dc

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0.0

Max Scale: 0.0

Supports Advanced Queries: true

Supports Statistics: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Supports Datum Transformation: true

Extent:
XMin: 951801.8691261113
YMin: 565392.9881730974
XMax: 982829.0114680231
YMax: 602801.817226693
Spatial Reference: 102719  (2264)  VCSWkid(115702)  LatestVCSWkid(115702)



Drawing Info:
Renderer:
Simple Renderer:
Symbol:
Style: esriSLSSolid
Color: [147, 68, 117, 255]
Width: 1
Label: N/A
Description: N/A
Transparency: 0
Labeling Info:
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
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
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:

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• FacilityID ( type: esriFieldTypeString, alias: FacilityID, editable: true, nullable: true, length: 30, defaultValue: null, modelName: FacilityID )
• InspectionName ( type: esriFieldTypeString, alias: Inspection Name, editable: true, nullable: true, length: 255, defaultValue: null, modelName: InspectionName )
• UniqueInspectionID ( type: esriFieldTypeGUID, alias: Unique Inspection ID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: UniqueInspectionID )
• ConditionCount ( type: esriFieldTypeSmallInteger, alias: Number of Conditions, editable: true, nullable: true, defaultValue: null, modelName: ConditionCount )
• InspectionID ( type: esriFieldTypeInteger, alias: InspectionID, editable: true, nullable: true, defaultValue: null, modelName: InspectionID )
• LineInspected ( type: esriFieldTypeSmallInteger, alias: Line Inspected?, editable: true, nullable: true, defaultValue: null, modelName: LineInspected , Coded Values: [0: Fully inspected] , [1: Partially inspected] )
• Surveyed_By ( type: esriFieldTypeString, alias: Surveyed By, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Surveyed By )
• Certificate_Number ( type: esriFieldTypeString, alias: Certificate Number, editable: true, nullable: true, length: 30, defaultValue: null, modelName: Certificate Number )
• Reviewed_By ( type: esriFieldTypeString, alias: Reviewed By, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Reviewed By )
• Reviewer_Certificate_Number ( type: esriFieldTypeString, alias: Reviewer Certificate Number, editable: true, nullable: true, length: 30, defaultValue: null, modelName: Reviewer Certificate Number )
• Owner ( type: esriFieldTypeString, alias: Owner, editable: true, nullable: true, length: 60, defaultValue: null, modelName: Owner )
• Customer ( type: esriFieldTypeString, alias: Customer, editable: true, nullable: true, length: 60, defaultValue: null, modelName: Customer )
• PO_Number ( type: esriFieldTypeString, alias: PO Number, editable: true, nullable: true, length: 30, defaultValue: null, modelName: PO Number )
• WorkOrder ( type: esriFieldTypeString, alias: Work Order, editable: true, nullable: true, length: 40, defaultValue: null, modelName: Work Order )
• Media_Label ( type: esriFieldTypeString, alias: Media Label, editable: true, nullable: true, length: 125, defaultValue: null, modelName: Media Label )
• Project ( type: esriFieldTypeString, alias: Project, editable: true, nullable: true, length: 125, defaultValue: null, modelName: Project )
• Inspection_Date ( type: esriFieldTypeDate, alias: Inspection Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Inspection Date )
• Inspection_Time ( type: esriFieldTypeDate, alias: Inspection Time, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Inspection Time )
• Sheet_Number ( type: esriFieldTypeInteger, alias: Sheet Number, editable: true, nullable: true, defaultValue: null, modelName: Sheet Number )
• Weather ( type: esriFieldTypeString, alias: Weather, editable: true, nullable: true, length: 10, defaultValue: null, modelName: Weather , Coded Values: [1: Dry - No precipitation during survey (1)] , [2: Heavy Rain (2)] , [3: Light Rain (3)] , ...2 more... )
• PreCleaning ( type: esriFieldTypeString, alias: Pre-Cleaning, editable: true, nullable: true, length: 10, defaultValue: null, modelName: Pre-Cleaning , Coded Values: [H: Heavy Cleaning (H)] , [L: Light Cleaning (L)] , [N: No Pre-Cleaning (N)] , ...2 more... )
• Date_Cleaned ( type: esriFieldTypeDate, alias: Date Cleaned, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Date Cleaned )
• Flow_Control ( type: esriFieldTypeString, alias: Flow Control, editable: true, nullable: true, length: 10, defaultValue: null, modelName: Flow Control , Coded Values: [B: Bypassed (B)] , [D: De-Watered using Jetter (D)] , [L: Lift Station (L)] , ...2 more... )
• Purpose ( type: esriFieldTypeString, alias: Purpose, editable: true, nullable: true, length: 10, defaultValue: null, modelName: Purpose , Coded Values: [A: Maintenance Related (A)] , [B: Infiltration/Inflow Investigation (B)] , [C: Post Rehabilitation Survey (C)] , ...9 more... )
• Direction ( type: esriFieldTypeString, alias: Direction, editable: true, nullable: true, length: 10, defaultValue: null, modelName: Direction , Coded Values: [D: Downstream (D)] , [U: Upstream (U)] )
• Inspection_Technology_Used_CCTV ( type: esriFieldTypeSmallInteger, alias: Used CCTV?, editable: true, nullable: true, defaultValue: null, modelName: Used CCTV? , Coded Values: [0: False] , [1: True] )
• Inspection_Technology_Used_Lase ( type: esriFieldTypeSmallInteger, alias: Used Laser?, editable: true, nullable: true, defaultValue: null, modelName: Used Laser? , Coded Values: [0: False] , [1: True] )
• Inspection_Technology_Used_Sona ( type: esriFieldTypeSmallInteger, alias: Used Sonar?, editable: true, nullable: true, defaultValue: null, modelName: Used Sonar? , Coded Values: [0: False] , [1: True] )
• Inspection_Technology_Used_Side ( type: esriFieldTypeSmallInteger, alias: Used Sidewall?, editable: true, nullable: true, defaultValue: null, modelName: Used Sidewall? , Coded Values: [0: False] , [1: True] )
• Inspection_Technology_Used_Zoom ( type: esriFieldTypeSmallInteger, alias: Used Zoom?, editable: true, nullable: true, defaultValue: null, modelName: Used Zoom? , Coded Values: [0: False] , [1: True] )
• Inspection_Technology_Used_Othe ( type: esriFieldTypeSmallInteger, alias: Used Other?, editable: true, nullable: true, defaultValue: null, modelName: Used Other?r , Coded Values: [0: False] , [1: True] )
• Inspection_Status ( type: esriFieldTypeString, alias: Inspection Status, editable: true, nullable: true, length: 10, defaultValue: null, modelName: Inspection Status , Coded Values: [BM: Buried and Marked (BM)] , [CI: Complete Inspection (CI)] , [NA: No Access (NA)] , ...5 more... )
• Consequence_Of_Failure ( type: esriFieldTypeString, alias: Consequence of Failure, editable: true, nullable: true, length: 10, defaultValue: null, modelName: Consequence of Failure )
• Pressure_Value ( type: esriFieldTypeDouble, alias: Pressure Value, editable: true, nullable: true, defaultValue: null, modelName: Pressure_Value )
• Drainage_Area ( type: esriFieldTypeString, alias: Drainage Area, editable: true, nullable: true, length: 30, defaultValue: null, modelName: Drainage Area )
• Pipe_Segment_Reference ( type: esriFieldTypeString, alias: Pipe Segment Reference, editable: true, nullable: true, length: 100, defaultValue: null, modelName: Pipe Segment Reference )
• Street ( type: esriFieldTypeString, alias: Street, editable: true, nullable: true, length: 125, defaultValue: null, modelName: Street )
• City ( type: esriFieldTypeString, alias: City, editable: true, nullable: true, length: 125, defaultValue: null, modelName: City )
• Location_Code ( type: esriFieldTypeString, alias: Location Code, editable: true, nullable: true, length: 10, defaultValue: null, modelName: Location Code , Coded Values: [A: Main highway - interstate (A)] , [B: Main highway - suburban/rural (B)] , [C: Light highway (C)] , ...15 more... )
• Location_Details ( type: esriFieldTypeString, alias: Location Details, editable: true, nullable: true, length: 500, defaultValue: null, modelName: Location Details )
• Pipe_Use ( type: esriFieldTypeString, alias: Pipe Use, editable: true, nullable: true, length: 10, defaultValue: null, modelName: Pipe Use , Coded Values: [CB: Combined Pipe (CB)] , [DP: Dam Pipe (DP)] , [FM: Force Main (FM)] , ...7 more... )
• Height ( type: esriFieldTypeInteger, alias: Height, editable: true, nullable: true, defaultValue: null, modelName: Height )
• Width ( type: esriFieldTypeInteger, alias: Width, editable: true, nullable: true, defaultValue: null, modelName: Width )
• Shape_1 ( type: esriFieldTypeString, alias: Shape, editable: true, nullable: true, length: 10, defaultValue: null, modelName: Shape , Coded Values: [A: Arched (A)] , [B: Barrel (B)] , [C: Circular (C)] , ...8 more... )
• Material ( type: esriFieldTypeString, alias: Material, editable: true, nullable: true, length: 10, defaultValue: null, modelName: Material , Coded Values: [ABS: Acrylonitrile Butadiene Styrene (ABS)] , [AC: Asbestos Cement (AC)] , [BR: Brick (BR)] , ...24 more... )
• Lining_Method ( type: esriFieldTypeString, alias: Lining Method, editable: true, nullable: true, length: 10, defaultValue: null, modelName: Lining Method , Coded Values: [CIP: Cured-In-Place Pipe (CIP)] , [FF: Fold and Form or Deform/Reform (FF)] , [FP: Formed-In-Place Liner (FP)] , ...11 more... )
• Coating_Method ( type: esriFieldTypeString, alias: Coating Method, editable: true, nullable: true, length: 10, defaultValue: null, modelName: Coating Method , Coded Values: [CM: Cement Mortar (CM)] , [CT: Coal Tar or Bituminous (CT)] , [EP: Epoxy (EP)] , ...6 more... )
• Pipe_Joint_Length ( type: esriFieldTypeDouble, alias: Pipe Joint Length, editable: true, nullable: true, defaultValue: null, modelName: Pipe Joint Length )
• Total_Length ( type: esriFieldTypeDouble, alias: Total Length, editable: true, nullable: true, defaultValue: null, modelName: Total Length )
• Length_Surveyed ( type: esriFieldTypeDouble, alias: Length Surveyed, editable: true, nullable: true, defaultValue: null, modelName: Length Surveyed )
• Year_Constructed ( type: esriFieldTypeInteger, alias: Year Constructed, editable: true, nullable: true, defaultValue: null, modelName: Year Constructed )
• Year_Renewed ( type: esriFieldTypeInteger, alias: Year Renewed, editable: true, nullable: true, defaultValue: null, modelName: Year Renewed )
• Upstream_MH ( type: esriFieldTypeString, alias: Upstream Manhole, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Upstream MH )
• Up_Rim_to_Invert ( type: esriFieldTypeDouble, alias: Up Rim to Invert, editable: true, nullable: true, defaultValue: null, modelName: Up Rim to Invert )
• Up_Rim_to_Grade ( type: esriFieldTypeDouble, alias: Up Rim to Grade, editable: true, nullable: true, defaultValue: null, modelName: Up Rim to Grade )
• Up_Grade_to_Invert ( type: esriFieldTypeDouble, alias: Up Grade to Invert, editable: true, nullable: true, defaultValue: null, modelName: Up Grade to Invert )
• Up_Northing ( type: esriFieldTypeString, alias: Up Northing, editable: true, nullable: true, length: 100, defaultValue: null, modelName: Up Northing )
• Up_Easting ( type: esriFieldTypeString, alias: Up Easting, editable: true, nullable: true, length: 100, defaultValue: null, modelName: Up Easting )
• Up_Elevation ( type: esriFieldTypeString, alias: Up Elevation, editable: true, nullable: true, length: 100, defaultValue: null, modelName: Up Elevation )
• Downstream_MH ( type: esriFieldTypeString, alias: Downstream Manhole, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Downstream MH )
• Down_Rim_to_Invert ( type: esriFieldTypeDouble, alias: Down Rim to Invert, editable: true, nullable: true, defaultValue: null, modelName: Down Rim to Invert )
• Down_Rim_to_Grade ( type: esriFieldTypeDouble, alias: Down Rim to Grade, editable: true, nullable: true, defaultValue: null, modelName: Down Rim to Grade )
• Down_Grade_to_Invert ( type: esriFieldTypeDouble, alias: Down Grade to Invert, editable: true, nullable: true, defaultValue: null, modelName: Down Grade to Invert )
• Down_Northing ( type: esriFieldTypeString, alias: Down Northing, editable: true, nullable: true, length: 100, defaultValue: null, modelName: Down Northing )
• Down_Easting ( type: esriFieldTypeString, alias: Down Easting, editable: true, nullable: true, length: 100, defaultValue: null, modelName: Down Easting )
• Down_Elevation ( type: esriFieldTypeString, alias: Down Elevation, editable: true, nullable: true, length: 100, defaultValue: null, modelName: Down Elevation )
• MH_Coordinate_System ( type: esriFieldTypeString, alias: Manhole Coordinate System, editable: true, nullable: true, length: 100, defaultValue: null, modelName: MH Coordinate System )
• Vertical_Datum ( type: esriFieldTypeString, alias: Vertical Datum, editable: true, nullable: true, length: 100, defaultValue: null, modelName: Vertical Datum )
• GPS_Accuracy ( type: esriFieldTypeString, alias: GPS Accuracy, editable: true, nullable: true, length: 10, defaultValue: null, modelName: GPS Accuracy , Coded Values: [L: Survey Level (L)] , [M: Sub-Meter (M)] , [N: Nearest Meter (N)] )
• Additional_Info ( type: esriFieldTypeString, alias: Additional Info, editable: true, nullable: true, length: 500, defaultValue: null, modelName: Additional Info )
• Reverse_Setup ( type: esriFieldTypeInteger, alias: Reverse Setup, editable: true, nullable: true, defaultValue: null, modelName: Reverse Setup )
• IsImperial ( type: esriFieldTypeSmallInteger, alias: Imperial Units?, editable: true, nullable: true, defaultValue: null, modelName: Is Imperial? , Coded Values: [0: False] , [1: True] )
• MediaID ( type: esriFieldTypeInteger, alias: Media ID, editable: true, nullable: true, defaultValue: null, modelName: Media ID )
• Video_Name ( type: esriFieldTypeString, alias: Video Name, editable: true, nullable: true, length: 500, defaultValue: null, modelName: Video Name )
• Video_Location ( type: esriFieldTypeString, alias: Video Location, editable: true, nullable: true, length: 500, defaultValue: null, modelName: Video Location )
• VideoURL ( type: esriFieldTypeString, alias: VideoURL, editable: true, nullable: true, length: 1000, defaultValue: null, modelName: VideoURL )
• Shape__Length ( type: esriFieldTypeDouble, alias: Shape.STLength(), editable: false, nullable: true, defaultValue: null, modelName: Shape.STLength(), required: true )
Templates:
• Name: CCTV_Inspected_Mains_Export
  Description:
  Prototype:
  VideoURL: null
  Video_Location: null
  FacilityID: null
  InspectionName: null
  UniqueInspectionID: null
  ConditionCount: null
  InspectionID: null
  LineInspected: null
  Surveyed_By: null
  Certificate_Number: null
  Reviewed_By: null
  Reviewer_Certificate_Number: null
  Owner: null
  Customer: null
  PO_Number: null
  WorkOrder: null
  Media_Label: null
  Project: null
  Inspection_Date: null
  Inspection_Time: null
  Sheet_Number: null
  Weather: null
  PreCleaning: null
  Date_Cleaned: null
  Flow_Control: null
  Purpose: null
  Direction: null
  Inspection_Technology_Used_CCTV: null
  Inspection_Technology_Used_Lase: null
  Inspection_Technology_Used_Sona: null
  Inspection_Technology_Used_Side: null
  Inspection_Technology_Used_Zoom: null
  Inspection_Technology_Used_Othe: null
  Inspection_Status: null
  Consequence_Of_Failure: null
  Pressure_Value: null
  Drainage_Area: null
  Pipe_Segment_Reference: null
  Street: null
  City: null
  Location_Code: null
  Location_Details: null
  Pipe_Use: null
  Height: null
  Width: null
  Shape_1: null
  Material: null
  Lining_Method: null
  Coating_Method: null
  Pipe_Joint_Length: null
  Total_Length: null
  Length_Surveyed: null
  Year_Constructed: null
  Year_Renewed: null
  Upstream_MH: null
  Up_Rim_to_Invert: null
  Up_Rim_to_Grade: null
  Up_Grade_to_Invert: null
  Up_Northing: null
  Up_Easting: null
  Up_Elevation: null
  Downstream_MH: null
  Down_Rim_to_Invert: null
  Down_Rim_to_Grade: null
  Down_Grade_to_Invert: null
  Down_Northing: null
  Down_Easting: null
  Down_Elevation: null
  MH_Coordinate_System: null
  Vertical_Datum: null
  GPS_Accuracy: null
  Additional_Info: null
  Reverse_Setup: null
  IsImperial: null
  MediaID: null
  Video_Name: null
  
  Drawing Tool: esriFeatureEditToolLine