View In:   ArcGIS Online Map Viewer

Name: Inspected Mains

Display Field: inspectionname

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description:

Service Item Id: a747320609974c87b6208c65c18852ea

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

MaxSelectionCount: 0

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

Extent:

XMin: 2211672.386453584
YMin: 648646.1464696378
XMax: 2213606.519068241
YMax: 650237.5937460661
Spatial Reference: 103122  (6543)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: lineinspected
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
Style: esriSLSSolid
Color: [169, 0, 230, 255]
Width: 3
Default Label: Unknown
UniqueValueInfos:
• Value: 0
  Label: Fully inspected
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [0, 92, 230, 255]
  Width: 3
• Value: 1
  Label: Partially inspected
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [255, 0, 0, 255]
  Width: 3
Transparency: 0
Labeling Info:

Feature Draw Order:

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

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: lineinspected

Fields:

• objectid ( nullable: false, defaultValue: null, editable: false, length: 4, type: esriFieldTypeOID, modelName: objectid, alias: OBJECTID )
• pcr ( modelName: pcr, nullable: true, editable: true, defaultValue: null, length: 255, alias: PCR, type: esriFieldTypeString )
• inspectionname ( modelName: inspectionname, nullable: true, editable: true, defaultValue: null, length: 255, alias: Inspection Name, type: esriFieldTypeString )
• uniqueinspectionid ( modelName: uniqueinspectionid, nullable: true, editable: true, defaultValue: null, length: 38, alias: Unique Inspection ID, type: esriFieldTypeGUID )
• conditioncount ( modelName: conditioncount, nullable: true, editable: true, defaultValue: null, alias: Number of Conditions, type: esriFieldTypeSmallInteger )
• inspectionid ( modelName: inspectionid, nullable: true, editable: true, defaultValue: null, alias: InspectionID, type: esriFieldTypeInteger )
• lineinspected ( modelName: lineinspected, nullable: true, editable: true, defaultValue: null, alias: Line Inspected?, type: esriFieldTypeSmallInteger , Coded Values: [0: Fully inspected] , [1: Partially inspected] )
• surveyed_by ( modelName: Surveyed By, nullable: true, editable: true, defaultValue: null, length: 50, alias: Surveyed By, type: esriFieldTypeString )
• certificate_number ( modelName: Certificate Number, nullable: true, editable: true, defaultValue: null, length: 30, alias: Certificate Number, type: esriFieldTypeString )
• reviewed_by ( modelName: Reviewed By, nullable: true, editable: true, defaultValue: null, length: 50, alias: Reviewed By, type: esriFieldTypeString )
• reviewer_certificate_number ( modelName: Reviewer Certificate Number, nullable: true, editable: true, defaultValue: null, length: 30, alias: Reviewer Certificate Number, type: esriFieldTypeString )
• owner ( modelName: Owner, nullable: true, editable: true, defaultValue: null, length: 60, alias: Owner, type: esriFieldTypeString )
• customer ( modelName: Customer, nullable: true, editable: true, defaultValue: null, length: 60, alias: Customer, type: esriFieldTypeString )
• po_number ( modelName: PO Number, nullable: true, editable: true, defaultValue: null, length: 30, alias: PO Number, type: esriFieldTypeString )
• workorder ( modelName: Work Order, nullable: true, editable: true, defaultValue: null, length: 40, alias: Work Order, type: esriFieldTypeString )
• media_label ( modelName: Media Label, nullable: true, editable: true, defaultValue: null, length: 125, alias: Media Label, type: esriFieldTypeString )
• project ( modelName: Project, nullable: true, editable: true, defaultValue: null, length: 125, alias: Project, type: esriFieldTypeString )
• inspection_date ( modelName: Inspection Date, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Inspection Date, type: esriFieldTypeDate )
• inspection_time ( modelName: Inspection Time, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Inspection Time, type: esriFieldTypeDate )
• sheet_number ( modelName: Sheet Number, nullable: true, editable: true, defaultValue: null, alias: Sheet Number, type: esriFieldTypeInteger )
• weather ( modelName: Weather, nullable: true, editable: true, defaultValue: null, length: 10, alias: Weather, type: esriFieldTypeString , Coded Values: [1: Dry - No precipitation during survey (1)] , [2: Heavy Rain (2)] , [3: Light Rain (3)] , ...2 more... )
• precleaning ( modelName: Pre-Cleaning, nullable: true, editable: true, defaultValue: null, length: 10, alias: Pre-Cleaning, type: esriFieldTypeString , Coded Values: [H: Heavy Cleaning (H)] , [L: Light Cleaning (L)] , [N: No Pre-Cleaning (N)] , ...2 more... )
• date_cleaned ( modelName: Date Cleaned, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Date Cleaned, type: esriFieldTypeDate )
• flow_control ( modelName: Flow Control, nullable: true, editable: true, defaultValue: null, length: 10, alias: Flow Control, type: esriFieldTypeString , Coded Values: [B: Bypassed (B)] , [D: De-Watered using Jetter (D)] , [L: Lift Station (L)] , ...2 more... )
• purpose ( modelName: Purpose, nullable: true, editable: true, defaultValue: null, length: 10, alias: Purpose, type: esriFieldTypeString , Coded Values: [A: Maintenance Related (A)] , [B: Infiltration/Inflow Investigation (B)] , [C: Post Rehabilitation Survey (C)] , ...9 more... )
• direction ( modelName: Direction, nullable: true, editable: true, defaultValue: null, length: 10, alias: Direction, type: esriFieldTypeString , Coded Values: [D: Downstream (D)] , [U: Upstream (U)] )
• inspection_technology_used_cctv ( modelName: Used CCTV?, nullable: true, editable: true, defaultValue: null, alias: Used CCTV?, type: esriFieldTypeSmallInteger , Coded Values: [0: False] , [1: True] )
• inspection_technology_used_lase ( modelName: Used Laser?, nullable: true, editable: true, defaultValue: null, alias: Used Laser?, type: esriFieldTypeSmallInteger , Coded Values: [0: False] , [1: True] )
• inspection_technology_used_sona ( modelName: Used Sonar?, nullable: true, editable: true, defaultValue: null, alias: Used Sonar?, type: esriFieldTypeSmallInteger , Coded Values: [0: False] , [1: True] )
• inspection_technology_used_side ( modelName: Used Sidewall?, nullable: true, editable: true, defaultValue: null, alias: Used Sidewall?, type: esriFieldTypeSmallInteger , Coded Values: [0: False] , [1: True] )
• inspection_technology_used_zoom ( modelName: Used Zoom?, nullable: true, editable: true, defaultValue: null, alias: Used Zoom?, type: esriFieldTypeSmallInteger , Coded Values: [0: False] , [1: True] )
• inspection_technology_used_othe ( modelName: Used Other?r, nullable: true, editable: true, defaultValue: null, alias: Used Other?, type: esriFieldTypeSmallInteger , Coded Values: [0: False] , [1: True] )
• inspection_status ( modelName: Inspection Status, nullable: true, editable: true, defaultValue: null, length: 10, alias: Inspection Status, type: esriFieldTypeString , Coded Values: [BM: Buried and Marked (BM)] , [CI: Complete Inspection (CI)] , [NA: No Access (NA)] , ...5 more... )
• consequence_of_failure ( modelName: Consequence of Failure, nullable: true, editable: true, defaultValue: null, length: 10, alias: Consequence of Failure, type: esriFieldTypeString )
• pressure_value ( modelName: Pressure_Value, nullable: true, editable: true, defaultValue: null, alias: Pressure Value, type: esriFieldTypeDouble )
• drainage_area ( modelName: Drainage Area, nullable: true, editable: true, defaultValue: null, length: 30, alias: Drainage Area, type: esriFieldTypeString )
• pipe_segment_reference ( modelName: Pipe Segment Reference, nullable: true, editable: true, defaultValue: null, length: 100, alias: Pipe Segment Reference, type: esriFieldTypeString )
• street ( modelName: Street, nullable: true, editable: true, defaultValue: null, length: 125, alias: Street, type: esriFieldTypeString )
• city ( modelName: City, nullable: true, editable: true, defaultValue: null, length: 125, alias: City, type: esriFieldTypeString )
• location_code ( modelName: Location Code, nullable: true, editable: true, defaultValue: null, length: 10, alias: Location Code, type: esriFieldTypeString , Coded Values: [A: Main highway - interstate (A)] , [B: Main highway - suburban/rural (B)] , [C: Light highway (C)] , ...15 more... )
• location_details ( modelName: Location Details, nullable: true, editable: true, defaultValue: null, length: 500, alias: Location Details, type: esriFieldTypeString )
• pipe_use ( modelName: Pipe Use, nullable: true, editable: true, defaultValue: null, length: 10, alias: Pipe Use, type: esriFieldTypeString , Coded Values: [CB: Combined Pipe (CB)] , [DP: Dam Pipe (DP)] , [FM: Force Main (FM)] , ...7 more... )
• height ( modelName: Height, nullable: true, editable: true, defaultValue: null, alias: Height, type: esriFieldTypeInteger )
• width ( modelName: Width, nullable: true, editable: true, defaultValue: null, alias: Width, type: esriFieldTypeInteger )
• shape_1 ( modelName: Shape, nullable: true, editable: true, defaultValue: null, length: 10, alias: Shape, type: esriFieldTypeString , Coded Values: [A: Arched (A)] , [B: Barrel (B)] , [C: Circular (C)] , ...8 more... )
• material ( modelName: Material, nullable: true, editable: true, defaultValue: null, length: 10, alias: Material, type: esriFieldTypeString , Coded Values: [ABS: Acrylonitrile Butadiene Styrene (ABS)] , [AC: Asbestos Cement (AC)] , [BR: Brick (BR)] , ...24 more... )
• lining_method ( modelName: Lining Method, nullable: true, editable: true, defaultValue: null, length: 10, alias: Lining Method, type: esriFieldTypeString , 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 ( modelName: Coating Method, nullable: true, editable: true, defaultValue: null, length: 10, alias: Coating Method, type: esriFieldTypeString , Coded Values: [CM: Cement Mortar (CM)] , [CT: Coal Tar or Bituminous (CT)] , [EP: Epoxy (EP)] , ...6 more... )
• pipe_joint_length ( modelName: Pipe Joint Length, nullable: true, editable: true, defaultValue: null, alias: Pipe Joint Length, type: esriFieldTypeDouble )
• total_length ( modelName: Total Length, nullable: true, editable: true, defaultValue: null, alias: Total Length, type: esriFieldTypeDouble )
• length_surveyed ( modelName: Length Surveyed, nullable: true, editable: true, defaultValue: null, alias: Length Surveyed, type: esriFieldTypeDouble )
• year_constructed ( modelName: Year Constructed, nullable: true, editable: true, defaultValue: null, alias: Year Constructed, type: esriFieldTypeInteger )
• year_renewed ( modelName: Year Renewed, nullable: true, editable: true, defaultValue: null, alias: Year Renewed, type: esriFieldTypeInteger )
• upstream_mh ( modelName: Upstream MH, nullable: true, editable: true, defaultValue: null, length: 50, alias: Upstream Manhole, type: esriFieldTypeString )
• up_rim_to_invert ( modelName: Up Rim to Invert, nullable: true, editable: true, defaultValue: null, alias: Up Rim to Invert, type: esriFieldTypeDouble )
• up_rim_to_grade ( modelName: Up Rim to Grade, nullable: true, editable: true, defaultValue: null, alias: Up Rim to Grade, type: esriFieldTypeDouble )
• up_grade_to_invert ( modelName: Up Grade to Invert, nullable: true, editable: true, defaultValue: null, alias: Up Grade to Invert, type: esriFieldTypeDouble )
• up_northing ( modelName: Up Northing, nullable: true, editable: true, defaultValue: null, length: 100, alias: Up Northing, type: esriFieldTypeString )
• up_easting ( modelName: Up Easting, nullable: true, editable: true, defaultValue: null, length: 100, alias: Up Easting, type: esriFieldTypeString )
• up_elevation ( modelName: Up Elevation, nullable: true, editable: true, defaultValue: null, length: 100, alias: Up Elevation, type: esriFieldTypeString )
• downstream_mh ( modelName: Downstream MH, nullable: true, editable: true, defaultValue: null, length: 50, alias: Downstream Manhole, type: esriFieldTypeString )
• down_rim_to_invert ( modelName: Down Rim to Invert, nullable: true, editable: true, defaultValue: null, alias: Down Rim to Invert, type: esriFieldTypeDouble )
• down_rim_to_grade ( modelName: Down Rim to Grade, nullable: true, editable: true, defaultValue: null, alias: Down Rim to Grade, type: esriFieldTypeDouble )
• down_grade_to_invert ( modelName: Down Grade to Invert, nullable: true, editable: true, defaultValue: null, alias: Down Grade to Invert, type: esriFieldTypeDouble )
• down_northing ( modelName: Down Northing, nullable: true, editable: true, defaultValue: null, length: 100, alias: Down Northing, type: esriFieldTypeString )
• down_easting ( modelName: Down Easting, nullable: true, editable: true, defaultValue: null, length: 100, alias: Down Easting, type: esriFieldTypeString )
• down_elevation ( modelName: Down Elevation, nullable: true, editable: true, defaultValue: null, length: 100, alias: Down Elevation, type: esriFieldTypeString )
• mh_coordinate_system ( modelName: MH Coordinate System, nullable: true, editable: true, defaultValue: null, length: 100, alias: Manhole Coordinate System, type: esriFieldTypeString )
• vertical_datum ( modelName: Vertical Datum, nullable: true, editable: true, defaultValue: null, length: 100, alias: Vertical Datum, type: esriFieldTypeString )
• gps_accuracy ( modelName: GPS Accuracy, nullable: true, editable: true, defaultValue: null, length: 10, alias: GPS Accuracy, type: esriFieldTypeString , Coded Values: [L: Survey Level (L)] , [M: Sub-Meter (M)] , [N: Nearest Meter (N)] )
• additional_info ( modelName: Additional Info, nullable: true, editable: true, defaultValue: null, length: 500, alias: Additional Info, type: esriFieldTypeString )
• reverse_setup ( modelName: Reverse Setup, nullable: true, editable: true, defaultValue: null, alias: Reverse Setup, type: esriFieldTypeInteger )
• isimperial ( modelName: Is Imperial?, nullable: true, editable: true, defaultValue: null, alias: Imperial Units?, type: esriFieldTypeSmallInteger , Coded Values: [0: False] , [1: True] )
• mediaid ( modelName: Media ID, nullable: true, editable: true, defaultValue: null, alias: Media ID, type: esriFieldTypeInteger )
• video_name ( modelName: Video Name, nullable: true, editable: true, defaultValue: null, length: 500, alias: Video Name, type: esriFieldTypeString )
• video_location ( modelName: Video Location, nullable: true, editable: true, defaultValue: null, length: 500, alias: Video Location, type: esriFieldTypeString )
• videourl ( modelName: videourl, nullable: true, editable: true, defaultValue: null, length: 1000, alias: VideoURL, type: esriFieldTypeString )
• globalid ( nullable: false, editable: false, defaultValue: null, length: 38, type: esriFieldTypeGlobalID, modelName: globalid, alias: globalid )
• SHAPE__Length ( virtual: true, nullable: true, editable: false, defaultValue: null, alias: SHAPE__Length, type: esriFieldTypeDouble )

Types:

ID: 0
Name: Fully inspected
Domains:
• lineinspected:
  Inherited
• purpose:
  Inherited
• inspection_technology_used_cctv:
  Inherited
• coating_method:
  Inherited
• isimperial:
  Inherited
• precleaning:
  Inherited
• inspection_technology_used_sona:
  Inherited
• inspection_technology_used_zoom:
  Inherited
• inspection_technology_used_side:
  Inherited
• lining_method:
  Inherited
• material:
  Inherited
• location_code:
  Inherited
• gps_accuracy:
  Inherited
• weather:
  Inherited
• pipe_use:
  Inherited
• inspection_technology_used_othe:
  Inherited
• shape_1:
  Inherited
• flow_control:
  Inherited
• direction:
  Inherited
• inspection_technology_used_lase:
  Inherited
• inspection_status:
  Inherited
Templates:
• Name: Fully inspected
  Description:
  Prototype:
  lineinspected: 0
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: 1
Name: Partially inspected
Domains:
• lineinspected:
  Inherited
• purpose:
  Inherited
• inspection_technology_used_cctv:
  Inherited
• coating_method:
  Inherited
• isimperial:
  Inherited
• precleaning:
  Inherited
• inspection_technology_used_sona:
  Inherited
• inspection_technology_used_zoom:
  Inherited
• inspection_technology_used_side:
  Inherited
• lining_method:
  Inherited
• material:
  Inherited
• location_code:
  Inherited
• gps_accuracy:
  Inherited
• weather:
  Inherited
• pipe_use:
  Inherited
• inspection_technology_used_othe:
  Inherited
• shape_1:
  Inherited
• flow_control:
  Inherited
• direction:
  Inherited
• inspection_technology_used_lase:
  Inherited
• inspection_status:
  Inherited
Templates:
• Name: Partially inspected
  Description:
  Prototype:
  lineinspected: 1
  
  Drawing Tool: esriFeatureEditToolLine

---

Relationships:

• CCTVConditions (0) -- Related To: CCTV Conditions (1)
• ContinuousDefects (2) -- Related To: Continuous Defects (2)

Capabilities: Query

Sync Can Return Changes: true

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: true

Supports ApplyEdits By Upload Id: true

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Child Resources:

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