View In:   ArcGIS Online Map Viewer

Name: CompassGIS.DBO.CSSD_ACTIVE_GPS_POINTS

Display Field: messageType

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON

Min Scale: 0

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Supports Datum Transformation: true

Extent:

XMin: NaN
YMin: NaN
XMax: NaN
YMax: NaN
Spatial Reference: 102100  (3857)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [0, 133, 133, 255]
Size: 4.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[0, 0, 0, 255] Width: 1
Label:
Description:
Transparency: 0
Labeling Info:

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

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• messageType ( type: esriFieldTypeString, alias: messageType text deviceId text, editable: true, nullable: true, length: 50, defaultValue: null, modelName: messageType )
• deviceId ( type: esriFieldTypeString, alias: deviceId, editable: true, nullable: true, length: 50, defaultValue: null, modelName: deviceId )
• vehicleId ( type: esriFieldTypeString, alias: vehicleId, editable: true, nullable: true, length: 50, defaultValue: null, modelName: vehicleId )
• eventTimeStamp ( type: esriFieldTypeDate, alias: eventTimeStamp, editable: true, nullable: true, length: 8, defaultValue: null, modelName: eventTimeStamp )
• latitude ( type: esriFieldTypeString, alias: latitude, editable: true, nullable: true, length: 50, defaultValue: null, modelName: latitude )
• longitude ( type: esriFieldTypeString, alias: longitude, editable: true, nullable: true, length: 50, defaultValue: null, modelName: longitude )
• speed ( type: esriFieldTypeString, alias: speed, editable: true, nullable: true, length: 50, defaultValue: null, modelName: speed )
• heading ( type: esriFieldTypeSmallInteger, alias: heading, editable: true, nullable: true, defaultValue: null, modelName: heading )
• odometer ( type: esriFieldTypeString, alias: odometer, editable: true, nullable: true, length: 50, defaultValue: null, modelName: odometer )
• distanceTraveled ( type: esriFieldTypeDouble, alias: distanceTraveled, editable: true, nullable: true, defaultValue: null, modelName: distanceTraveled )
• fuelCounter ( type: esriFieldTypeString, alias: fuelCounter, editable: true, nullable: true, length: 50, defaultValue: null, modelName: fuelCounter )
• acceleration ( type: esriFieldTypeString, alias: acceleration, editable: true, nullable: true, length: 50, defaultValue: null, modelName: acceleration )
• lastIdleTimeStamp ( type: esriFieldTypeString, alias: lastIdleTimeStamp, editable: true, nullable: true, length: 50, defaultValue: null, modelName: lastIdleTimeStamp )
• lastIdleDuration ( type: esriFieldTypeString, alias: lastIdleDuration, editable: true, nullable: true, length: 50, defaultValue: null, modelName: lastIdleDuration )
• videoStatus ( type: esriFieldTypeString, alias: videoStatus, editable: true, nullable: true, length: 50, defaultValue: null, modelName: videoStatus )
• studentId ( type: esriFieldTypeString, alias: studentId, editable: true, nullable: true, length: 50, defaultValue: null, modelName: studentId )
• studentStatus ( type: esriFieldTypeString, alias: studentStatus, editable: true, nullable: true, length: 50, defaultValue: null, modelName: studentStatus )
• stopArm ( type: esriFieldTypeString, alias: stopArm, editable: true, nullable: true, length: 50, defaultValue: null, modelName: stopArm )
• entryDoor ( type: esriFieldTypeString, alias: entryDoor, editable: true, nullable: true, length: 50, defaultValue: null, modelName: entryDoor )
• stopLights ( type: esriFieldTypeString, alias: stopLights, editable: true, nullable: true, length: 50, defaultValue: null, modelName: stopLights )
• liftDoor ( type: esriFieldTypeString, alias: liftDoor, editable: true, nullable: true, length: 50, defaultValue: null, modelName: liftDoor )
• coldStart ( type: esriFieldTypeString, alias: coldStart, editable: true, nullable: true, length: 50, defaultValue: null, modelName: coldStart )
• powerOff ( type: esriFieldTypeString, alias: powerOff, editable: true, nullable: true, length: 50, defaultValue: null, modelName: powerOff )
• geofence ( type: esriFieldTypeString, alias: geofence, editable: true, nullable: true, length: 50, defaultValue: null, modelName: geofence )
• motionStop ( type: esriFieldTypeString, alias: motionStop, editable: true, nullable: true, length: 50, defaultValue: null, modelName: motionStop )
• motionStart ( type: esriFieldTypeString, alias: motionStart, editable: true, nullable: true, length: 50, defaultValue: null, modelName: motionStart )
• powerOn ( type: esriFieldTypeString, alias: powerOn, editable: true, nullable: true, length: 50, defaultValue: null, modelName: powerOn )
• panic ( type: esriFieldTypeString, alias: panic, editable: true, nullable: true, length: 50, defaultValue: null, modelName: panic )
• ignition ( type: esriFieldTypeString, alias: ignition, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ignition )
• flashers ( type: esriFieldTypeString, alias: flashers, editable: true, nullable: true, length: 50, defaultValue: null, modelName: flashers )
• amberLights ( type: esriFieldTypeString, alias: amberLights, editable: true, nullable: true, length: 50, defaultValue: null, modelName: amberLights )
• videoRecording ( type: esriFieldTypeString, alias: videoRecording, editable: true, nullable: true, length: 50, defaultValue: null, modelName: videoRecording )
• videoLoss ( type: esriFieldTypeString, alias: videoLoss, editable: true, nullable: true, length: 50, defaultValue: null, modelName: videoLoss )
• videoHdd ( type: esriFieldTypeString, alias: videoHdd, editable: true, nullable: true, length: 50, defaultValue: null, modelName: videoHdd )
• videoHddLock ( type: esriFieldTypeString, alias: videoHddLock, editable: true, nullable: true, length: 50, defaultValue: null, modelName: videoHddLock )
• liveVideoSupport ( type: esriFieldTypeString, alias: liveVideoSupport, editable: true, nullable: true, length: 50, defaultValue: null, modelName: liveVideoSupport )
• custom1 ( type: esriFieldTypeString, alias: custom1, editable: true, nullable: true, length: 50, defaultValue: null, modelName: custom1 )
• custom2 ( type: esriFieldTypeString, alias: custom2, editable: true, nullable: true, length: 50, defaultValue: null, modelName: custom2 )
• custom3 ( type: esriFieldTypeString, alias: custom2, editable: true, nullable: true, length: 50, defaultValue: null, modelName: custom3 )
• custom4 ( type: esriFieldTypeString, alias: custom2, editable: true, nullable: true, length: 50, defaultValue: null, modelName: custom4 )
• custom5 ( type: esriFieldTypeString, alias: custom2, editable: true, nullable: true, length: 50, defaultValue: null, modelName: custom5 )
• custom6 ( type: esriFieldTypeString, alias: custom2, editable: true, nullable: true, length: 50, defaultValue: null, modelName: custom6 )
• custom7 ( type: esriFieldTypeString, alias: custom2, editable: true, nullable: true, length: 50, defaultValue: null, modelName: custom7 )
• custom8 ( type: esriFieldTypeString, alias: custom2, editable: true, nullable: true, length: 50, defaultValue: null, modelName: custom8 )
• custom9 ( type: esriFieldTypeString, alias: custom2, editable: true, nullable: true, length: 50, defaultValue: null, modelName: custom9 )
• custom10 ( type: esriFieldTypeString, alias: custom2, editable: true, nullable: true, length: 50, defaultValue: null, modelName: custom10 )
• provider ( type: esriFieldTypeString, alias: provider, editable: true, nullable: true, length: 50, defaultValue: null, modelName: provider )
• isAtYard ( type: esriFieldTypeString, alias: isAtYard, editable: true, nullable: true, length: 50, defaultValue: null, modelName: isAtYard )

Templates:

• Name: CompassGIS.DBO.CSSD_ACTIVE_GPS_POINTS
  Description:
  Prototype:
  provider: null
  isAtYard: null
  messageType: null
  deviceId: null
  vehicleId: null
  eventTimeStamp: null
  latitude: null
  longitude: null
  speed: null
  heading: null
  odometer: null
  distanceTraveled: null
  fuelCounter: null
  acceleration: null
  lastIdleTimeStamp: null
  lastIdleDuration: null
  videoStatus: null
  studentId: null
  studentStatus: null
  stopArm: null
  entryDoor: null
  stopLights: null
  liftDoor: null
  coldStart: null
  powerOff: null
  geofence: null
  motionStop: null
  motionStart: null
  powerOn: null
  panic: null
  ignition: null
  flashers: null
  amberLights: null
  videoRecording: null
  videoLoss: null
  videoHdd: null
  videoHddLock: null
  liveVideoSupport: null
  custom1: null
  custom2: null
  custom3: null
  custom4: null
  custom5: null
  custom6: null
  custom7: null
  custom8: null
  custom9: null
  custom10: null
  
  Drawing Tool: esriFeatureEditToolPoint

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

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

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