{ "currentVersion": 10.81, "id": 7, "name": "CompassGIS.DBO.CSSD_ACTIVE_GPS_POINTS", "type": "Feature Layer", "parentLayer": null, "defaultVisibility": false, "minScale": 0, "maxScale": 0, "canScaleSymbols": false, "geometryType": "esriGeometryPoint", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [], "isDataVersioned": false, "isDataArchived": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": true, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": true, "supportsCalculate": true, "supportsDatumTransformation": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsQueryWithDatumTransformation": true }, "extent": { "xmin": "NaN", "ymin": "NaN", "xmax": "NaN", "ymax": "NaN", "spatialReference": { "wkid": 102100, "latestWkid": 3857 } }, "sourceSpatialReference": { "wkid": 102100, "latestWkid": 3857 }, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSMS", "style": "esriSMSCircle", "color": [ 0, 133, 133, 255 ], "size": 4, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": { "color": [ 0, 0, 0, 255 ], "width": 1 } }, "label": "", "description": "" }, "transparency": 0, "labelingInfo": null }, "hasM": false, "hasZ": false, "allowGeometryUpdates": true, "allowTrueCurvesUpdates": false, "onlyAllowTrueCurveUpdatesByTrueCurveClients": false, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "messageType", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "messageType", "type": "esriFieldTypeString", "alias": "messageType\n\ntext\n\ndeviceId\n\n\ntext", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "messageType" }, { "name": "deviceId", "type": "esriFieldTypeString", "alias": "deviceId", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "deviceId" }, { "name": "vehicleId", "type": "esriFieldTypeString", "alias": "vehicleId", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "vehicleId" }, { "name": "eventTimeStamp", "type": "esriFieldTypeDate", "alias": "eventTimeStamp", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "eventTimeStamp" }, { "name": "latitude", "type": "esriFieldTypeString", "alias": "latitude", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "latitude" }, { "name": "longitude", "type": "esriFieldTypeString", "alias": "longitude", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "longitude" }, { "name": "speed", "type": "esriFieldTypeString", "alias": "speed", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "speed" }, { "name": "heading", "type": "esriFieldTypeSmallInteger", "alias": "heading", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "heading" }, { "name": "odometer", "type": "esriFieldTypeString", "alias": "odometer", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "odometer" }, { "name": "distanceTraveled", "type": "esriFieldTypeDouble", "alias": "distanceTraveled", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "distanceTraveled" }, { "name": "fuelCounter", "type": "esriFieldTypeString", "alias": "fuelCounter", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "fuelCounter" }, { "name": "acceleration", "type": "esriFieldTypeString", "alias": "acceleration", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "acceleration" }, { "name": "lastIdleTimeStamp", "type": "esriFieldTypeString", "alias": "lastIdleTimeStamp", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "lastIdleTimeStamp" }, { "name": "lastIdleDuration", "type": "esriFieldTypeString", "alias": "lastIdleDuration", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "lastIdleDuration" }, { "name": "videoStatus", "type": "esriFieldTypeString", "alias": "videoStatus", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "videoStatus" }, { "name": "studentId", "type": "esriFieldTypeString", "alias": "studentId", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "studentId" }, { "name": "studentStatus", "type": "esriFieldTypeString", "alias": "studentStatus", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "studentStatus" }, { "name": "stopArm", "type": "esriFieldTypeString", "alias": "stopArm", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "stopArm" }, { "name": "entryDoor", "type": "esriFieldTypeString", "alias": "entryDoor", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "entryDoor" }, { "name": "stopLights", "type": "esriFieldTypeString", "alias": "stopLights", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "stopLights" }, { "name": "liftDoor", "type": "esriFieldTypeString", "alias": "liftDoor", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "liftDoor" }, { "name": "coldStart", "type": "esriFieldTypeString", "alias": "coldStart", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "coldStart" }, { "name": "powerOff", "type": "esriFieldTypeString", "alias": "powerOff", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "powerOff" }, { "name": "geofence", "type": "esriFieldTypeString", "alias": "geofence", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "geofence" }, { "name": "motionStop", "type": "esriFieldTypeString", "alias": "motionStop", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "motionStop" }, { "name": "motionStart", "type": "esriFieldTypeString", "alias": "motionStart", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "motionStart" }, { "name": "powerOn", "type": "esriFieldTypeString", "alias": "powerOn", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "powerOn" }, { "name": "panic", "type": "esriFieldTypeString", "alias": "panic", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "panic" }, { "name": "ignition", "type": "esriFieldTypeString", "alias": "ignition", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "ignition" }, { "name": "flashers", "type": "esriFieldTypeString", "alias": "flashers", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "flashers" }, { "name": "amberLights", "type": "esriFieldTypeString", "alias": "amberLights", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "amberLights" }, { "name": "videoRecording", "type": "esriFieldTypeString", "alias": "videoRecording", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "videoRecording" }, { "name": "videoLoss", "type": "esriFieldTypeString", "alias": "videoLoss", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "videoLoss" }, { "name": "videoHdd", "type": "esriFieldTypeString", "alias": "videoHdd", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "videoHdd" }, { "name": "videoHddLock", "type": "esriFieldTypeString", "alias": "videoHddLock", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "videoHddLock" }, { "name": "liveVideoSupport", "type": "esriFieldTypeString", "alias": "liveVideoSupport", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "liveVideoSupport" }, { "name": "custom1", "type": "esriFieldTypeString", "alias": "custom1", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "custom1" }, { "name": "custom2", "type": "esriFieldTypeString", "alias": "custom2", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "custom2" }, { "name": "custom3", "type": "esriFieldTypeString", "alias": "custom2", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "custom3" }, { "name": "custom4", "type": "esriFieldTypeString", "alias": "custom2", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "custom4" }, { "name": "custom5", "type": "esriFieldTypeString", "alias": "custom2", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "custom5" }, { "name": "custom6", "type": "esriFieldTypeString", "alias": "custom2", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "custom6" }, { "name": "custom7", "type": "esriFieldTypeString", "alias": "custom2", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "custom7" }, { "name": "custom8", "type": "esriFieldTypeString", "alias": "custom2", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "custom8" }, { "name": "custom9", "type": "esriFieldTypeString", "alias": "custom2", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "custom9" }, { "name": "custom10", "type": "esriFieldTypeString", "alias": "custom2", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "custom10" }, { "name": "provider", "type": "esriFieldTypeString", "alias": "provider", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "provider" }, { "name": "isAtYard", "type": "esriFieldTypeString", "alias": "isAtYard", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "isAtYard" } ], "geometryField": { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "SHAPE" }, "indexes": [ { "name": "R5277_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "S5227_idx", "fields": "SHAPE", "isAscending": true, "isUnique": true, "description": "" } ], "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "types": [], "templates": [ { "name": "CompassGIS.DBO.CSSD_ACTIVE_GPS_POINTS", "description": "", "prototype": { "attributes": { "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 } }, "drawingTool": "esriFeatureEditToolPoint" } ], "maxRecordCount": 1000, "supportedQueryFormats": "JSON, geoJSON", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 8000, "standardMaxRecordCountNoGeometry": 32000, "maxRecordCountFactor": 1 }