Name: Inspections

Display Field: inspection_name

Type: Table

Geometry Type: N/A

Description:

Service Item Id: 9a910b1ea32d49d58d056d82f16329ec

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

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: false
Supports Returning Query Extent: true
Supports Query With Distance: false
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: false
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: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:

• objectid ( nullable: false, defaultValue: null, editable: false, length: 4, type: esriFieldTypeOID, modelName: objectid, alias: OBJECTID )
• additional_info ( modelName: additional_info, nullable: true, editable: true, defaultValue: null, length: 255, alias: Additional_Info, type: esriFieldTypeString )
• ams_inspectiontype ( modelName: ams_inspectiontype, nullable: true, editable: true, defaultValue: null, length: 255, alias: AMS_InspectionType, type: esriFieldTypeString )
• camera ( modelName: camera, nullable: true, editable: true, defaultValue: null, length: 50, alias: Camera, type: esriFieldTypeString )
• certificate_number ( modelName: certificate_number, nullable: true, editable: true, defaultValue: null, length: 50, alias: Certificate_Number, type: esriFieldTypeString )
• clean_date ( modelName: clean_date, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Clean_Date, type: esriFieldTypeDate )
• cleaned ( modelName: cleaned, nullable: true, editable: true, defaultValue: null, length: 50, alias: Cleaned, type: esriFieldTypeString )
• client_id ( modelName: client_id, nullable: true, editable: true, defaultValue: null, length: 255, alias: Client_ID, type: esriFieldTypeString )
• completed ( modelName: completed, nullable: true, editable: true, defaultValue: null, alias: Completed, type: esriFieldTypeSmallInteger )
• consequence_of_failure ( modelName: consequence_of_failure, nullable: true, editable: true, defaultValue: null, length: 50, alias: Consequence_Of_Failure, type: esriFieldTypeString )
• creation_date ( modelName: creation_date, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Creation_Date, type: esriFieldTypeDate )
• current_status ( modelName: current_status, nullable: true, editable: true, defaultValue: null, length: 50, alias: Current_Status, type: esriFieldTypeString )
• customer ( modelName: customer, nullable: true, editable: true, defaultValue: null, length: 255, alias: Customer, type: esriFieldTypeString )
• end_time ( modelName: end_time, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: End_Time, type: esriFieldTypeDate )
• flow_control ( modelName: flow_control, nullable: true, editable: true, defaultValue: null, length: 50, alias: Flow_Control, type: esriFieldTypeString )
• grade ( modelName: grade, nullable: true, editable: true, defaultValue: null, alias: Grade, type: esriFieldTypeDouble )
• inspected_length ( modelName: inspected_length, nullable: true, editable: true, defaultValue: null, alias: Inspected_Length, type: esriFieldTypeDouble )
• inspection_date ( modelName: inspection_date, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Inspection_Date, type: esriFieldTypeDate )
• inspection_direction ( modelName: inspection_direction, nullable: true, editable: true, defaultValue: null, length: 50, alias: Inspection_Direction, type: esriFieldTypeString )
• inspection_name ( modelName: inspection_name, nullable: true, editable: true, defaultValue: null, length: 50, alias: Inspection_Name, type: esriFieldTypeString )
• inspection_result ( modelName: inspection_result, nullable: true, editable: true, defaultValue: null, length: 255, alias: Inspection_Result, type: esriFieldTypeString )
• inspection_status ( modelName: inspection_status, nullable: true, editable: true, defaultValue: null, length: 50, alias: Inspection_Status, type: esriFieldTypeString )
• inspection_technology_used_cctv ( modelName: inspection_technology_used_cctv, nullable: true, editable: true, defaultValue: null, alias: Inspection_Technology_Used_CCTV, type: esriFieldTypeSmallInteger )
• inspection_technology_used_lase ( modelName: inspection_technology_used_lase, nullable: true, editable: true, defaultValue: null, alias: Inspection_Technology_Used_Laser, type: esriFieldTypeSmallInteger )
• inspection_technology_used_othe ( modelName: inspection_technology_used_othe, nullable: true, editable: true, defaultValue: null, alias: Inspection_Technology_Used_Other, type: esriFieldTypeSmallInteger )
• inspection_technology_used_side ( modelName: inspection_technology_used_side, nullable: true, editable: true, defaultValue: null, alias: Inspection_Technology_Used_Sidewall, type: esriFieldTypeSmallInteger )
• inspection_technology_used_sona ( modelName: inspection_technology_used_sona, nullable: true, editable: true, defaultValue: null, alias: Inspection_Technology_Used_Sonar, type: esriFieldTypeSmallInteger )
• inspection_technology_used_zoom ( modelName: inspection_technology_used_zoom, nullable: true, editable: true, defaultValue: null, alias: Inspection_Technology_Used_Zoom, type: esriFieldTypeSmallInteger )
• isimperial ( modelName: isimperial, nullable: true, editable: true, defaultValue: null, alias: IsImperial, type: esriFieldTypeSmallInteger )
• joint_failed ( modelName: joint_failed, nullable: true, editable: true, defaultValue: null, length: 4, alias: Joint_Failed, type: esriFieldTypeString )
• joint_passed ( modelName: joint_passed, nullable: true, editable: true, defaultValue: null, length: 4, alias: Joint_Passed, type: esriFieldTypeString )
• joint_tested ( modelName: joint_tested, nullable: true, editable: true, defaultValue: null, length: 4, alias: Joint_Tested, type: esriFieldTypeString )
• joint_unrepair ( modelName: joint_unrepair, nullable: true, editable: true, defaultValue: null, length: 4, alias: Joint_Unrepair, type: esriFieldTypeString )
• last_modified_date ( modelName: last_modified_date, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Last_Modified_Date, type: esriFieldTypeDate )
• measure_1 ( modelName: measure_1, nullable: true, editable: true, defaultValue: null, alias: Measure_1, type: esriFieldTypeDouble )
• media_number ( modelName: media_number, nullable: true, editable: true, defaultValue: null, length: 50, alias: Media_Number, type: esriFieldTypeString )
• merge_guid ( modelName: merge_guid, nullable: true, editable: true, defaultValue: null, length: 255, alias: Merge_GUID, type: esriFieldTypeString )
• ml_id ( modelName: ml_id, nullable: true, editable: true, defaultValue: null, alias: ML_ID, type: esriFieldTypeInteger )
• mli_level ( modelName: mli_level, nullable: true, editable: true, defaultValue: null, length: 50, alias: MLI_Level, type: esriFieldTypeString )
• mpr ( modelName: mpr, nullable: true, editable: true, defaultValue: null, alias: MPR, type: esriFieldTypeDouble )
• mpri ( modelName: mpri, nullable: true, editable: true, defaultValue: null, alias: MPRI, type: esriFieldTypeDouble )
• operator ( modelName: operator, nullable: true, editable: true, defaultValue: null, length: 50, alias: Operator, type: esriFieldTypeString )
• opr ( modelName: opr, nullable: true, editable: true, defaultValue: null, alias: OPR, type: esriFieldTypeDouble )
• opri ( modelName: opri, nullable: true, editable: true, defaultValue: null, alias: OPRI, type: esriFieldTypeDouble )
• pacp_custom_1 ( modelName: pacp_custom_1, nullable: true, editable: true, defaultValue: null, length: 255, alias: PACP_Custom_1, type: esriFieldTypeString )
• pacp_custom_10 ( modelName: pacp_custom_10, nullable: true, editable: true, defaultValue: null, length: 255, alias: PACP_Custom_10, type: esriFieldTypeString )
• pacp_custom_2 ( modelName: pacp_custom_2, nullable: true, editable: true, defaultValue: null, length: 255, alias: PACP_Custom_2, type: esriFieldTypeString )
• pacp_custom_3 ( modelName: pacp_custom_3, nullable: true, editable: true, defaultValue: null, length: 255, alias: PACP_Custom_3, type: esriFieldTypeString )
• pacp_custom_4 ( modelName: pacp_custom_4, nullable: true, editable: true, defaultValue: null, length: 255, alias: PACP_Custom_4, type: esriFieldTypeString )
• pacp_custom_5 ( modelName: pacp_custom_5, nullable: true, editable: true, defaultValue: null, length: 255, alias: PACP_Custom_5, type: esriFieldTypeString )
• pacp_custom_6 ( modelName: pacp_custom_6, nullable: true, editable: true, defaultValue: null, length: 255, alias: PACP_Custom_6, type: esriFieldTypeString )
• pacp_custom_7 ( modelName: pacp_custom_7, nullable: true, editable: true, defaultValue: null, length: 255, alias: PACP_Custom_7, type: esriFieldTypeString )
• pacp_custom_8 ( modelName: pacp_custom_8, nullable: true, editable: true, defaultValue: null, length: 255, alias: PACP_Custom_8, type: esriFieldTypeString )
• pacp_custom_9 ( modelName: pacp_custom_9, nullable: true, editable: true, defaultValue: null, length: 255, alias: PACP_Custom_9, type: esriFieldTypeString )
• po_number ( modelName: po_number, nullable: true, editable: true, defaultValue: null, length: 50, alias: PO_Number, type: esriFieldTypeString )
• present ( modelName: present, nullable: true, editable: true, defaultValue: null, length: 50, alias: Present, type: esriFieldTypeString )
• pressure_value ( modelName: pressure_value, nullable: true, editable: true, defaultValue: null, alias: Pressure_Value, type: esriFieldTypeDouble )
• qmr ( modelName: qmr, nullable: true, editable: true, defaultValue: null, length: 10, alias: QMR, type: esriFieldTypeString )
• qor ( modelName: qor, nullable: true, editable: true, defaultValue: null, length: 10, alias: QOR, type: esriFieldTypeString )
• qsr ( modelName: qsr, nullable: true, editable: true, defaultValue: null, length: 10, alias: QSR, type: esriFieldTypeString )
• reason_of_inspection ( modelName: reason_of_inspection, nullable: true, editable: true, defaultValue: null, length: 100, alias: Reason_of_Inspection, type: esriFieldTypeString )
• remark ( modelName: remark, nullable: true, editable: true, defaultValue: null, length: 2147483647, alias: Remark, type: esriFieldTypeString )
• reverse_setup ( modelName: reverse_setup, nullable: true, editable: true, defaultValue: null, alias: Reverse_Setup, type: esriFieldTypeSmallInteger )
• reviewed_by ( modelName: reviewed_by, nullable: true, editable: true, defaultValue: null, length: 25, alias: Reviewed_By, type: esriFieldTypeString )
• reviewed_date ( modelName: reviewed_date, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Reviewed_Date, type: esriFieldTypeDate )
• reviewer_certificate_number ( modelName: reviewer_certificate_number, nullable: true, editable: true, defaultValue: null, length: 15, alias: Reviewer_Certificate_Number, type: esriFieldTypeString )
• sheet_number ( modelName: sheet_number, nullable: true, editable: true, defaultValue: null, alias: Sheet_Number, type: esriFieldTypeInteger )
• situation ( modelName: situation, nullable: true, editable: true, defaultValue: null, length: 255, alias: Situation, type: esriFieldTypeString )
• spr ( modelName: spr, nullable: true, editable: true, defaultValue: null, alias: SPR, type: esriFieldTypeDouble )
• spri ( modelName: spri, nullable: true, editable: true, defaultValue: null, alias: SPRI, type: esriFieldTypeDouble )
• start_easting ( modelName: start_easting, nullable: true, editable: true, defaultValue: null, length: 50, alias: Start_Easting, type: esriFieldTypeString )
• start_elevation ( modelName: start_elevation, nullable: true, editable: true, defaultValue: null, length: 50, alias: Start_Elevation, type: esriFieldTypeString )
• start_northing ( modelName: start_northing, nullable: true, editable: true, defaultValue: null, length: 50, alias: Start_Northing, type: esriFieldTypeString )
• start_time ( modelName: start_time, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Start_Time, type: esriFieldTypeDate )
• status ( modelName: status, nullable: true, editable: true, defaultValue: null, length: 50, alias: Status, type: esriFieldTypeString )
• tally_1 ( modelName: tally_1, nullable: true, editable: true, defaultValue: null, alias: Tally_1, type: esriFieldTypeDouble )
• tally_2 ( modelName: tally_2, nullable: true, editable: true, defaultValue: null, alias: Tally_2, type: esriFieldTypeDouble )
• tally_3 ( modelName: tally_3, nullable: true, editable: true, defaultValue: null, alias: Tally_3, type: esriFieldTypeDouble )
• tally_4 ( modelName: tally_4, nullable: true, editable: true, defaultValue: null, alias: Tally_4, type: esriFieldTypeDouble )
• tally_5 ( modelName: tally_5, nullable: true, editable: true, defaultValue: null, alias: Tally_5, type: esriFieldTypeDouble )
• template_name ( modelName: template_name, nullable: true, editable: true, defaultValue: null, length: 50, alias: Template_Name, type: esriFieldTypeString )
• total_gallon ( modelName: total_gallon, nullable: true, editable: true, defaultValue: null, alias: Total_Gallon, type: esriFieldTypeDouble )
• van ( modelName: van, nullable: true, editable: true, defaultValue: null, length: 50, alias: Van, type: esriFieldTypeString )
• vehicle ( modelName: vehicle, nullable: true, editable: true, defaultValue: null, length: 50, alias: Vehicle, type: esriFieldTypeString )
• weather ( modelName: weather, nullable: true, editable: true, defaultValue: null, length: 50, alias: Weather, type: esriFieldTypeString )
• wo_number ( modelName: wo_number, nullable: true, editable: true, defaultValue: null, length: 50, alias: WO_Number, type: esriFieldTypeString )
• wo_status ( modelName: wo_status, nullable: true, editable: true, defaultValue: null, length: 255, alias: WO_Status, type: esriFieldTypeString )
• qc_status ( modelName: qc_status, nullable: true, editable: true, defaultValue: null, length: 20, alias: QC_Status, type: esriFieldTypeString )
• inspection_time ( modelName: inspection_time, nullable: true, editable: true, defaultValue: null, alias: Inspection_Time, type: esriFieldTypeInteger )
• inspection_valid ( modelName: inspection_valid, nullable: true, editable: true, defaultValue: null, alias: Inspection_Valid, type: esriFieldTypeSmallInteger )
• inspection_sync_error ( modelName: inspection_sync_error, nullable: true, editable: true, defaultValue: null, length: 50, alias: Inspection_Sync_Error, type: esriFieldTypeString )
• syncdate ( modelName: syncdate, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: SyncDate, type: esriFieldTypeDate )
• email_sent ( modelName: email_sent, nullable: true, editable: true, defaultValue: null, length: 100, alias: Email_Sent, type: esriFieldTypeString )
• submitcomment ( modelName: submitcomment, nullable: true, editable: true, defaultValue: null, length: 500, alias: SubmitComment, type: esriFieldTypeString )
• submithyperlink ( modelName: submithyperlink, nullable: true, editable: true, defaultValue: null, length: 500, alias: SubmitHyperlink, type: esriFieldTypeString )
• gis_receive_date ( modelName: gis_receive_date, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: GIS_Receive_Date, type: esriFieldTypeDate )
• gis_asset_doesnt_exist ( modelName: gis_asset_doesnt_exist, nullable: true, editable: true, defaultValue: null, alias: GIS_Asset_Doesnt_Exist, type: esriFieldTypeSmallInteger )
• inspectionmediaexists ( modelName: inspectionmediaexists, nullable: true, editable: true, defaultValue: null, alias: InspectionMediaExists, type: esriFieldTypeSmallInteger )
• syncstatus ( modelName: syncstatus, nullable: true, editable: true, defaultValue: null, length: 50, alias: SyncStatus, type: esriFieldTypeString )
• syncstatusmessage ( modelName: syncstatusmessage, nullable: true, editable: true, defaultValue: null, length: 500, alias: SyncStatusMessage, type: esriFieldTypeString )
• syncretrycount ( modelName: syncretrycount, nullable: true, editable: true, defaultValue: null, alias: SyncRetryCount, type: esriFieldTypeInteger )
• gis_asset_up_to_date ( modelName: gis_asset_up_to_date, nullable: true, editable: true, defaultValue: null, alias: GIS_Asset_Up_To_Date, type: esriFieldTypeSmallInteger )
• mli_id ( modelName: mli_id, nullable: true, editable: true, defaultValue: null, alias: MLI_ID_First, type: esriFieldTypeInteger )

Templates:

• Name: Inspections
  Description:
  Prototype:
  inspection_technology_used_cctv: null
  reverse_setup: null
  inspection_result: null
  total_gallon: null
  qor: null
  weather: null
  inspectionmediaexists: null
  van: null
  inspection_technology_used_zoom: null
  consequence_of_failure: null
  mpri: null
  completed: null
  creation_date: null
  mpr: null
  inspection_direction: null
  additional_info: null
  grade: null
  qc_status: null
  inspection_valid: null
  current_status: null
  status: null
  isimperial: null
  inspection_date: null
  certificate_number: null
  vehicle: null
  pacp_custom_8: null
  pacp_custom_7: null
  pacp_custom_6: null
  pacp_custom_5: null
  gis_asset_doesnt_exist: null
  pacp_custom_9: null
  camera: null
  pacp_custom_4: null
  pacp_custom_3: null
  pacp_custom_2: null
  situation: null
  pacp_custom_1: null
  inspection_time: null
  mli_level: null
  spri: null
  ams_inspectiontype: null
  end_time: null
  inspection_technology_used_sona: null
  joint_tested: null
  pacp_custom_10: null
  template_name: null
  inspection_sync_error: null
  flow_control: null
  reviewed_date: null
  start_northing: null
  last_modified_date: null
  measure_1: null
  ml_id: null
  client_id: null
  operator: null
  qsr: null
  clean_date: null
  wo_status: null
  syncdate: null
  inspected_length: null
  inspection_name: null
  syncstatus: null
  joint_passed: null
  sheet_number: null
  wo_number: null
  pressure_value: null
  inspection_technology_used_side: null
  opr: null
  start_elevation: null
  start_time: null
  reason_of_inspection: null
  spr: null
  reviewer_certificate_number: null
  cleaned: null
  present: null
  media_number: null
  merge_guid: null
  email_sent: null
  reviewed_by: null
  start_easting: null
  remark: null
  po_number: null
  gis_receive_date: null
  qmr: null
  submithyperlink: null
  submitcomment: null
  tally_4: null
  tally_3: null
  inspection_status: null
  inspection_technology_used_lase: null
  joint_failed: null
  tally_5: null
  tally_2: null
  tally_1: null
  gis_asset_up_to_date: null
  opri: null
  joint_unrepair: null
  mli_id: null
  syncstatusmessage: null
  syncretrycount: null
  inspection_technology_used_othe: null
  customer: null
  
  Drawing Tool: esriFeatureEditToolNone

Capabilities: Query

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