Name: MLI

Display Field: inspection_name

Type: Table

Geometry Type: N/A

Description:

Service Item Id: d207dd603c2642efb6c9064e4806e244

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

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:

• objectid ( type: esriFieldTypeOID, alias: objectid, editable: false, nullable: false, defaultValue: null, modelName: objectid )
• mli_id ( type: esriFieldTypeDouble, alias: MLI_ID, editable: true, nullable: true, defaultValue: null, modelName: mli_id )
• ml_id ( type: esriFieldTypeDouble, alias: ML_ID, editable: true, nullable: true, defaultValue: null, modelName: ml_id )
• inspection_name ( type: esriFieldTypeString, alias: Inspection_Name, editable: true, nullable: true, length: 255, defaultValue: null, modelName: inspection_name )
• operator ( type: esriFieldTypeString, alias: Operator, editable: true, nullable: true, length: 255, defaultValue: null, modelName: operator )
• remark ( type: esriFieldTypeString, alias: Remark, editable: true, nullable: true, length: 255, defaultValue: null, modelName: remark )
• reason_of_inspection ( type: esriFieldTypeString, alias: Reason_of_Inspection, editable: true, nullable: true, length: 255, defaultValue: null, modelName: reason_of_inspection )
• wo_number ( type: esriFieldTypeString, alias: WO_Number, editable: true, nullable: true, length: 255, defaultValue: null, modelName: wo_number )
• cleaned ( type: esriFieldTypeString, alias: Cleaned, editable: true, nullable: true, length: 255, defaultValue: null, modelName: cleaned )
• clean_date ( type: esriFieldTypeString, alias: Clean_Date, editable: true, nullable: true, length: 255, defaultValue: null, modelName: clean_date )
• flow_control ( type: esriFieldTypeString, alias: Flow_Control, editable: true, nullable: true, length: 255, defaultValue: null, modelName: flow_control )
• inspection_direction ( type: esriFieldTypeString, alias: Inspection_Direction, editable: true, nullable: true, length: 255, defaultValue: null, modelName: inspection_direction )
• inspected_length ( type: esriFieldTypeDouble, alias: Inspected_Length, editable: true, nullable: true, defaultValue: null, modelName: inspected_length )
• start_time ( type: esriFieldTypeDate, alias: Start_Time, editable: true, nullable: true, length: 8, defaultValue: null, modelName: start_time )
• po_number ( type: esriFieldTypeString, alias: PO_Number, editable: true, nullable: true, length: 255, defaultValue: null, modelName: po_number )
• creation_date ( type: esriFieldTypeDate, alias: Creation_Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: creation_date )
• sheet_number ( type: esriFieldTypeString, alias: Sheet_Number, editable: true, nullable: true, length: 255, defaultValue: null, modelName: sheet_number )
• weather ( type: esriFieldTypeString, alias: Weather, editable: true, nullable: true, length: 255, defaultValue: null, modelName: weather )
• present ( type: esriFieldTypeString, alias: Present, editable: true, nullable: true, length: 255, defaultValue: null, modelName: present )
• completed ( type: esriFieldTypeDouble, alias: Completed, editable: true, nullable: true, defaultValue: null, modelName: completed )
• camera ( type: esriFieldTypeString, alias: Camera, editable: true, nullable: true, length: 255, defaultValue: null, modelName: camera )
• end_time ( type: esriFieldTypeDate, alias: End_Time, editable: true, nullable: true, length: 8, defaultValue: null, modelName: end_time )
• inspection_date ( type: esriFieldTypeDate, alias: Inspection_Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: inspection_date )
• last_modified_date ( type: esriFieldTypeDate, alias: Last_Modified_Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: last_modified_date )
• status ( type: esriFieldTypeString, alias: Status, editable: true, nullable: true, length: 255, defaultValue: null, modelName: status )
• vehicle ( type: esriFieldTypeString, alias: Vehicle, editable: true, nullable: true, length: 255, defaultValue: null, modelName: vehicle )
• van ( type: esriFieldTypeString, alias: Van, editable: true, nullable: true, length: 255, defaultValue: null, modelName: van )
• tally_4 ( type: esriFieldTypeDouble, alias: Tally_4, editable: true, nullable: true, defaultValue: null, modelName: tally_4 )
• tally_3 ( type: esriFieldTypeDouble, alias: Tally_3, editable: true, nullable: true, defaultValue: null, modelName: tally_3 )
• tally_2 ( type: esriFieldTypeDouble, alias: Tally_2, editable: true, nullable: true, defaultValue: null, modelName: tally_2 )
• tally_1 ( type: esriFieldTypeDouble, alias: Tally_1, editable: true, nullable: true, defaultValue: null, modelName: tally_1 )
• spri ( type: esriFieldTypeString, alias: SPRI, editable: true, nullable: true, length: 255, defaultValue: null, modelName: spri )
• mpri ( type: esriFieldTypeString, alias: MPRI, editable: true, nullable: true, length: 255, defaultValue: null, modelName: mpri )
• mpr ( type: esriFieldTypeString, alias: MPR, editable: true, nullable: true, length: 255, defaultValue: null, modelName: mpr )
• opr ( type: esriFieldTypeString, alias: OPR, editable: true, nullable: true, length: 255, defaultValue: null, modelName: opr )
• spr ( type: esriFieldTypeString, alias: SPR, editable: true, nullable: true, length: 255, defaultValue: null, modelName: spr )
• total_gallon ( type: esriFieldTypeString, alias: Total_Gallon, editable: true, nullable: true, length: 255, defaultValue: null, modelName: total_gallon )
• joint_unrepair ( type: esriFieldTypeString, alias: Joint_Unrepair, editable: true, nullable: true, length: 255, defaultValue: null, modelName: joint_unrepair )
• joint_failed ( type: esriFieldTypeString, alias: Joint_Failed, editable: true, nullable: true, length: 255, defaultValue: null, modelName: joint_failed )
• pressure_value ( type: esriFieldTypeDouble, alias: Pressure_Value, editable: true, nullable: true, defaultValue: null, modelName: pressure_value )
• situation ( type: esriFieldTypeString, alias: Situation, editable: true, nullable: true, length: 255, defaultValue: null, modelName: situation )
• joint_tested ( type: esriFieldTypeString, alias: Joint_Tested, editable: true, nullable: true, length: 255, defaultValue: null, modelName: joint_tested )
• joint_passed ( type: esriFieldTypeString, alias: Joint_Passed, editable: true, nullable: true, length: 255, defaultValue: null, modelName: joint_passed )
• opri ( type: esriFieldTypeString, alias: OPRI, editable: true, nullable: true, length: 255, defaultValue: null, modelName: opri )
• inspection_result ( type: esriFieldTypeString, alias: Inspection_Result, editable: true, nullable: true, length: 255, defaultValue: null, modelName: inspection_result )
• customer ( type: esriFieldTypeString, alias: Customer, editable: true, nullable: true, length: 255, defaultValue: null, modelName: customer )
• client_id ( type: esriFieldTypeString, alias: Client_ID, editable: true, nullable: true, length: 255, defaultValue: null, modelName: client_id )
• wo_status ( type: esriFieldTypeString, alias: WO_Status, editable: true, nullable: true, length: 255, defaultValue: null, modelName: wo_status )
• grade ( type: esriFieldTypeDouble, alias: Grade, editable: true, nullable: true, defaultValue: null, modelName: grade )
• mli_level ( type: esriFieldTypeString, alias: MLI_Level, editable: true, nullable: true, length: 255, defaultValue: null, modelName: mli_level )
• measure_1 ( type: esriFieldTypeString, alias: Measure_1, editable: true, nullable: true, length: 255, defaultValue: null, modelName: measure_1 )
• additional_info ( type: esriFieldTypeString, alias: Additional_Info, editable: true, nullable: true, length: 255, defaultValue: null, modelName: additional_info )
• tally_5 ( type: esriFieldTypeDouble, alias: Tally_5, editable: true, nullable: true, defaultValue: null, modelName: tally_5 )
• isimperial ( type: esriFieldTypeDouble, alias: IsImperial, editable: true, nullable: true, defaultValue: null, modelName: isimperial )
• insp_notes ( type: esriFieldTypeString, alias: INSP_NOTES, editable: true, nullable: true, length: 255, defaultValue: null, modelName: insp_notes )
• certificate_number ( type: esriFieldTypeString, alias: Certificate_Number, editable: true, nullable: true, length: 255, defaultValue: null, modelName: certificate_number )
• media_number ( type: esriFieldTypeString, alias: Media_Number, editable: true, nullable: true, length: 255, defaultValue: null, modelName: media_number )
• template_name ( type: esriFieldTypeString, alias: Template_Name, editable: true, nullable: true, length: 255, defaultValue: null, modelName: template_name )
• current_status ( type: esriFieldTypeString, alias: Current_Status, editable: true, nullable: true, length: 255, defaultValue: null, modelName: current_status )
• qor ( type: esriFieldTypeString, alias: QOR, editable: true, nullable: true, length: 255, defaultValue: null, modelName: qor )
• qsr ( type: esriFieldTypeString, alias: QSR, editable: true, nullable: true, length: 255, defaultValue: null, modelName: qsr )
• qmr ( type: esriFieldTypeString, alias: QMR, editable: true, nullable: true, length: 255, defaultValue: null, modelName: qmr )
• reverse_setup ( type: esriFieldTypeString, alias: Reverse_Setup, editable: true, nullable: true, length: 255, defaultValue: null, modelName: reverse_setup )
• merge_guid ( type: esriFieldTypeString, alias: Merge_GUID, editable: true, nullable: true, length: 255, defaultValue: null, modelName: merge_guid )
• qc_status ( type: esriFieldTypeString, alias: QC_Status, editable: true, nullable: true, length: 255, defaultValue: null, modelName: qc_status )
• ams_inspectiontype ( type: esriFieldTypeString, alias: AMS_InspectionType, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ams_inspectiontype )
• inspection_time ( type: esriFieldTypeDouble, alias: Inspection_Time, editable: true, nullable: true, defaultValue: null, modelName: inspection_time )
• inspection_valid ( type: esriFieldTypeString, alias: Inspection_Valid, editable: true, nullable: true, length: 255, defaultValue: null, modelName: inspection_valid )
• inspection_sync_error ( type: esriFieldTypeString, alias: Inspection_Sync_Error, editable: true, nullable: true, length: 255, defaultValue: null, modelName: inspection_sync_error )
• syncdate ( type: esriFieldTypeString, alias: SyncDate, editable: true, nullable: true, length: 255, defaultValue: null, modelName: syncdate )
• ml_assetid ( type: esriFieldTypeString, alias: ML_ASSETID, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ml_assetid )
• needs_lining ( type: esriFieldTypeString, alias: NEEDS_LINING, editable: true, nullable: true, length: 255, defaultValue: null, modelName: needs_lining )

Templates:

• Name: MLI
  Description:
  Prototype:
  Drawing Tool: esriFeatureEditToolNone

Capabilities: Query

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: false

Supports Query With Historic Moment: false

Supports Coordinates Quantization: false

Supported Operations:   Query   Query Attachments   Query Analytic   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata