Name: GIS.GISADMIN.Jet_Truck_Protocol

Display Field: PIPE_SEGMENT

Type: Table

Geometry Type: N/A

Description:

Service Item Id: 7d3b5505374645de8a416add50b878a1

Copyright Text:

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: false

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 )
• PIPE_SEGMENT ( type: esriFieldTypeString, alias: PIPE_SEGMENT, editable: true, nullable: true, length: 10, defaultValue: null, modelName: PIPE_SEGMENT )
• DATE ( type: esriFieldTypeDate, alias: DATE, editable: true, nullable: false, length: 8, defaultValue: null, modelName: DATE )
• OPERATOR1 ( type: esriFieldTypeString, alias: OPERATOR1, editable: true, nullable: false, length: 50, defaultValue: null, modelName: OPERATOR1 , Coded Values: [CM: CM] , [DS: DS] , [GO: GO] , ...15 more... )
• OPERATOR2 ( type: esriFieldTypeString, alias: OPERATOR2, editable: true, nullable: false, length: 50, defaultValue: null, modelName: OPERATOR2 , Coded Values: [CM: CM] , [DS: DS] , [GO: GO] , ...15 more... )
• TRUCK_NUMBER ( type: esriFieldTypeSmallInteger, alias: TRUCK_NUMBER, editable: true, nullable: false, defaultValue: null, modelName: TRUCK_NUMBER , Coded Values: [691: 691] , [692: 692] )
• NOZZLE_TYPE ( type: esriFieldTypeString, alias: NOZZLE_TYPE, editable: true, nullable: true, length: 20, defaultValue: null, modelName: NOZZLE_TYPE , Coded Values: [Sewer: Sewer] , [Grease: Grease] , [Root Saw & Sewer: Root Saw & Sewer] , ...1 more... )
• MH_FROM_CONDITION ( type: esriFieldTypeString, alias: MH_FROM_CONDITION, editable: true, nullable: true, length: 10, defaultValue: null, modelName: MH_FROM_CONDITION , Coded Values: [Good: Good] , [Fair: Fair] , [Poor: Poor] , ...1 more... )
• MH_TO_CONDITION ( type: esriFieldTypeString, alias: MH_TO_CONDITION, editable: true, nullable: true, length: 10, defaultValue: null, modelName: MH_TO_CONDITION , Coded Values: [Good: Good] , [Fair: Fair] , [Poor: Poor] , ...1 more... )
• PRESSURE_UPSTREAM_PSI_ ( type: esriFieldTypeString, alias: PRESSURE_UPSTREAM(PSI), editable: true, nullable: true, length: 20, defaultValue: null, modelName: PRESSURE_UPSTREAM_PSI_ )
• PRESSURE_DOWNSTREAM_PSI_ ( type: esriFieldTypeString, alias: PRESSURE_DOWNSTREAM(PSI), editable: true, nullable: true, length: 20, defaultValue: null, modelName: PRESSURE_DOWNSTREAM_PSI_ )
• MATERIAL_REMOVED ( type: esriFieldTypeString, alias: MATERIAL_REMOVED, editable: true, nullable: true, length: 250, defaultValue: null, modelName: MATERIAL_REMOVED , Coded Values: [Grease: Grease] , [Sediment: Sediment] , [Roots: Roots] , ...1 more... )
• COMMENTS ( type: esriFieldTypeString, alias: COMMENTS, editable: true, nullable: true, length: 500, defaultValue: null, modelName: COMMENTS )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• created_user ( type: esriFieldTypeString, alias: created_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: created_user )
• created_date ( type: esriFieldTypeDate, alias: created_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created_date )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
• TIME_UPSTREAM_MIN ( type: esriFieldTypeSmallInteger, alias: TIME_UPSTREAM_MIN, editable: true, nullable: true, defaultValue: null, modelName: TIME_UPSTREAM_MIN )
• TIME_UPSTREAM_SEC ( type: esriFieldTypeSmallInteger, alias: TIME_UPSTREAM_SEC, editable: true, nullable: true, defaultValue: null, modelName: TIME_UPSTREAM_SEC )
• TIME_DOWNSTREAM_MIN ( type: esriFieldTypeSmallInteger, alias: TIME_DOWNSTREAM_MIN, editable: true, nullable: true, defaultValue: null, modelName: TIME_DOWNSTREAM_MIN )
• TIME_DOWNSTREAM_SEC ( type: esriFieldTypeSmallInteger, alias: TIME_DOWNSTREAM_SEC, editable: true, nullable: true, defaultValue: null, modelName: TIME_DOWNSTREAM_SEC )

Templates:

• Name: GIS.GISADMIN.Jet_Truck_Protocol
  Description:
  Prototype:
  TIME_DOWNSTREAM_MIN: null
  TIME_UPSTREAM_SEC: null
  PIPE_SEGMENT: null
  DATE: -2209161600000
  OPERATOR1:
  OPERATOR2:
  TRUCK_NUMBER: 0
  NOZZLE_TYPE: null
  MH_FROM_CONDITION: null
  MH_TO_CONDITION: null
  PRESSURE_UPSTREAM_PSI_: null
  PRESSURE_DOWNSTREAM_PSI_: null
  MATERIAL_REMOVED: null
  COMMENTS: null
  TIME_DOWNSTREAM_SEC: null
  TIME_UPSTREAM_MIN: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• Sewer_Line (0) -- Related To: Sewer Line (4)

Capabilities: Query,Create,Update,Delete,Uploads,Editing

Sync Can Return Changes: true

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

Edit Fields Info:

• Creation Date Field: created_date
• Creator Field: created_user
• Edit Date Field: last_edited_date
• Editor Field: last_edited_user

Supports Query With Historic Moment: false

Supports Coordinates Quantization: false

Supported Operations:   Query   Query Attachments   Query Related Records   Apply Edits   Add Features   Update Features   Delete Features   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata