Name: StormTrak Dispatch

Display Field: ROUTE_NAME

Type: Table

Geometry Type: N/A

Description:

Copyright Text:

Default Visibility: false

MaxRecordCount: 1000

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

Type ID Field:

Fields:

• STORMTRAK_DISPATCH_ID ( type: esriFieldTypeInteger, alias: STORMTRAK_DISPATCH_ID, editable: true, nullable: false, defaultValue: null, modelName: STORMTRAK_DISPATCH_ID )
• EVENT_ID ( type: esriFieldTypeInteger, alias: EVENT_ID, editable: true, nullable: false, defaultValue: null, modelName: EVENT_ID )
• SHIFT_ID ( type: esriFieldTypeInteger, alias: SHIFT_ID, editable: true, nullable: true, defaultValue: null, modelName: SHIFT_ID )
• VEHICLE_ID ( type: esriFieldTypeString, alias: VEHICLE_ID, editable: true, nullable: true, length: 100, defaultValue: null, modelName: VEHICLE_ID )
• PERSON_ID ( type: esriFieldTypeInteger, alias: PERSON_ID, editable: true, nullable: true, defaultValue: null, modelName: PERSON_ID )
• ROUTE_ID ( type: esriFieldTypeString, alias: ROUTE_ID, editable: true, nullable: true, length: 100, defaultValue: null, modelName: ROUTE_ID )
• SNOW_TITLE ( type: esriFieldTypeString, alias: SNOW_TITLE, editable: true, nullable: true, length: 100, defaultValue: null, modelName: SNOW_TITLE )
• STATUS ( type: esriFieldTypeString, alias: STATUS, editable: true, nullable: true, length: 100, defaultValue: null, modelName: STATUS )
• VEHICLE_VIN ( type: esriFieldTypeString, alias: VEHICLE_VIN, editable: true, nullable: true, length: 100, defaultValue: null, modelName: VEHICLE_VIN )
• DISPATCHED_AT ( type: esriFieldTypeDate, alias: DISPATCHED_AT, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DISPATCHED_AT )
• RECALLED_AT ( type: esriFieldTypeDate, alias: RECALLED_AT, editable: true, nullable: true, length: 8, defaultValue: null, modelName: RECALLED_AT )
• ZONE ( type: esriFieldTypeInteger, alias: ZONE, editable: true, nullable: true, defaultValue: null, modelName: ZONE )
• ROUTE_NAME ( type: esriFieldTypeString, alias: ROUTE_NAME, editable: true, nullable: true, length: 100, defaultValue: null, modelName: ROUTE_NAME )
• DRIVER_NAME ( type: esriFieldTypeString, alias: DRIVER_NAME, editable: true, nullable: true, length: 100, defaultValue: null, modelName: DRIVER_NAME )
• STORMTRAK_VEHICLE_ID ( type: esriFieldTypeString, alias: STORMTRAK_VEHICLE_ID, editable: true, nullable: true, length: 100, defaultValue: null, modelName: STORMTRAK_VEHICLE_ID )
• AGENCY ( type: esriFieldTypeString, alias: AGENCY, editable: true, nullable: true, length: 100, defaultValue: null, modelName: AGENCY )
• ALTERNATE_VEHICLE_ID ( type: esriFieldTypeString, alias: ALTERNATE_VEHICLE_ID, editable: true, nullable: true, length: 100, defaultValue: null, modelName: ALTERNATE_VEHICLE_ID )
• EMPLOYEE_ID ( type: esriFieldTypeString, alias: EMPLOYEE_ID, editable: true, nullable: true, length: 100, defaultValue: null, modelName: EMPLOYEE_ID )
• DRIVER_PHONE_NUMBER ( type: esriFieldTypeString, alias: DRIVER_PHONE_NUMBER, editable: true, nullable: true, length: 100, defaultValue: null, modelName: DRIVER_PHONE_NUMBER )
• NORMALIZED_ROUTE_NAME ( type: esriFieldTypeString, alias: NORMALIZED_ROUTE_NAME, editable: true, nullable: true, length: 100, defaultValue: null, modelName: NORMALIZED_ROUTE_NAME )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )

Templates:

• Name: StormTrak Dispatch
  Description:
  Prototype:
  DRIVER_PHONE_NUMBER: null
  STORMTRAK_DISPATCH_ID: 0
  EVENT_ID: 0
  SHIFT_ID: null
  VEHICLE_ID: null
  PERSON_ID: null
  ROUTE_ID: null
  SNOW_TITLE: null
  STATUS: null
  VEHICLE_VIN: null
  DISPATCHED_AT: null
  RECALLED_AT: null
  ZONE: null
  ROUTE_NAME: null
  DRIVER_NAME: null
  STORMTRAK_VEHICLE_ID: null
  AGENCY: null
  ALTERNATE_VEHICLE_ID: null
  EMPLOYEE_ID: null
  NORMALIZED_ROUTE_NAME: null
  
  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

Child Resources:   Field Groups   Contingent Values

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