Name: NPD_AVL.dbo.unit_gps_history

Display Field: avlID

Type: Table

Description:

Copyright Text:

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Object ID Field: unit_gps_key

Unique ID Field:

Name : unit_gps_key

IsSystemMaintained : True

Global ID Field:

Type ID Field:

Fields:

• avlID (type: esriFieldTypeDouble, alias: avlID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• unit_gps_key (type: esriFieldTypeOID, alias: unit_gps_key, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• vehicle_id (type: esriFieldTypeString, alias: vehicle_id, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• unit_id (type: esriFieldTypeString, alias: unit_id, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• latitude (type: esriFieldTypeString, alias: latitude, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• longitude (type: esriFieldTypeString, alias: longitude, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• unit_ip (type: esriFieldTypeString, alias: unit_ip, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
• speed (type: esriFieldTypeInteger, alias: speed, SQL Type: sqlTypeOther, nullable: true, editable: true)
• heading (type: esriFieldTypeInteger, alias: heading, SQL Type: sqlTypeOther, nullable: true, editable: true)
• dtlchg (type: esriFieldTypeDate, alias: dtlchg, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• idlchg (type: esriFieldTypeString, alias: idlchg, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• location (type: esriFieldTypeString, alias: location, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• reporting_status (type: esriFieldTypeString, alias: reporting_status, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• vertical_speed (type: esriFieldTypeInteger, alias: vertical_speed, SQL Type: sqlTypeOther, nullable: true, editable: true)
• altitude (type: esriFieldTypeInteger, alias: altitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
• gps_time (type: esriFieldTypeInteger, alias: gps_time, SQL Type: sqlTypeOther, nullable: true, editable: true)
• error_msg (type: esriFieldTypeString, alias: error_msg, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• map_point (type: esriFieldTypeInteger, alias: map_point, SQL Type: sqlTypeOther, nullable: true, editable: true)
• gps_datetime (type: esriFieldTypeDate, alias: gps_datetime, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• gps_history_datetime (type: esriFieldTypeBlob, alias: gps_history_datetime, SQL Type: sqlTypeOther, nullable: true, editable: true)

Templates:

Name: NPD_AVL.dbo.unit_gps_history
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 4/23/2021 1:10:58 PM

Schema Last Edit Date: 4/23/2021 1:10:58 PM

Data Last Edit Date: 4/23/2021 1:10:58 PM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat