Name: public.geotab_live

Display Field: id

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: This feature layer generated with Koop PostGIS Provider (koop-provider-pg), for more information visit https://github.com/doneill/koop-provider-pg

Copyright Text: Copyright information varies by provider. For more information please contact the source of this data.

Min. Scale: 0

Max. Scale: 0

Default Visibility: true

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: -102.473022
YMin: 32.2328339
XMax: -96.2623291
YMax: 34.4272881
Spatial Reference: 4326 (4326)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"color":[247,150,70,161],"outline":{"color":[190,190,190,105],"width":0.5,"type":"esriSLS","style":"esriSLSSolid"},"size":7.5,"type":"esriSMS","style":"esriSMSCircle"}},"labelingInfo":null}

HasZ: true

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Object ID Field: id

Unique ID Field:

Name : id

IsSystemMaintained : True

Global ID Field:

Type ID Field:

Fields:

• id (type: esriFieldTypeOID, alias: id, SQL Type: sqlTypeInteger, length: 0, nullable: false, editable: false)
• lat_1 (type: esriFieldTypeDouble, alias: lat_1, SQL Type: sqlTypeOther, nullable: false, editable: false)
• lat_2 (type: esriFieldTypeDouble, alias: lat_2, SQL Type: sqlTypeOther, nullable: false, editable: false)
• speed (type: esriFieldTypeInteger, alias: speed, SQL Type: sqlTypeOther, nullable: false, editable: false)
• long_1 (type: esriFieldTypeDouble, alias: long_1, SQL Type: sqlTypeOther, nullable: false, editable: false)
• long_2 (type: esriFieldTypeDouble, alias: long_2, SQL Type: sqlTypeOther, nullable: false, editable: false)
• Time_Up (type: esriFieldTypeInteger, alias: Time_Up, SQL Type: sqlTypeOther, nullable: false, editable: false)
• bearing (type: esriFieldTypeInteger, alias: bearing, SQL Type: sqlTypeOther, nullable: false, editable: false)
• Button_Up (type: esriFieldTypeInteger, alias: Button_Up, SQL Type: sqlTypeOther, nullable: false, editable: false)
• Time_Down (type: esriFieldTypeInteger, alias: Time_Down, SQL Type: sqlTypeOther, nullable: false, editable: false)
• Time_Plus (type: esriFieldTypeInteger, alias: Time_Plus, SQL Type: sqlTypeOther, nullable: false, editable: false)
• device_id (type: esriFieldTypeString, alias: device_id, SQL Type: sqlTypeOther, length: 128, nullable: false, editable: false)
• Plow_State (type: esriFieldTypeString, alias: Plow_State, SQL Type: sqlTypeOther, length: 128, nullable: false, editable: false)
• Time_Minus (type: esriFieldTypeInteger, alias: Time_Minus, SQL Type: sqlTypeOther, nullable: false, editable: false)
• is_driving (type: esriFieldTypeString, alias: is_driving, SQL Type: sqlTypeOther, length: 128, nullable: false, editable: false)
• time_delta (type: esriFieldTypeInteger, alias: time_delta, SQL Type: sqlTypeOther, nullable: false, editable: false)
• vehicle_id (type: esriFieldTypeString, alias: vehicle_id, SQL Type: sqlTypeOther, length: 128, nullable: false, editable: false)
• Auger_State (type: esriFieldTypeString, alias: Auger_State, SQL Type: sqlTypeOther, length: 128, nullable: false, editable: false)
• Button_Down (type: esriFieldTypeInteger, alias: Button_Down, SQL Type: sqlTypeOther, nullable: false, editable: false)
• Cum_Time_Up (type: esriFieldTypeInteger, alias: Cum_Time_Up, SQL Type: sqlTypeOther, nullable: false, editable: false)
• date_time_1 (type: esriFieldTypeDate, alias: date_time_1, SQL Type: sqlTypeOther, length: 36, nullable: false, editable: false)
• date_time_2 (type: esriFieldTypeDate, alias: date_time_2, SQL Type: sqlTypeOther, length: 36, nullable: false, editable: false)
• Cum_Time_Down (type: esriFieldTypeInteger, alias: Cum_Time_Down, SQL Type: sqlTypeOther, nullable: false, editable: false)
• bearing_delta (type: esriFieldTypeString, alias: bearing_delta, SQL Type: sqlTypeOther, length: 128, nullable: false, editable: false)
• distance_delta (type: esriFieldTypeString, alias: distance_delta, SQL Type: sqlTypeOther, length: 128, nullable: false, editable: false)
• DiagnosticAux1Id (type: esriFieldTypeInteger, alias: DiagnosticAux1Id, SQL Type: sqlTypeOther, nullable: false, editable: false)
• DiagnosticAux2Id (type: esriFieldTypeInteger, alias: DiagnosticAux2Id, SQL Type: sqlTypeOther, nullable: false, editable: false)
• DiagnosticAux3Id (type: esriFieldTypeInteger, alias: DiagnosticAux3Id, SQL Type: sqlTypeOther, nullable: false, editable: false)
• DiagnosticAux4Id (type: esriFieldTypeInteger, alias: DiagnosticAux4Id, SQL Type: sqlTypeOther, nullable: false, editable: false)
• Latest_Trip_Stop (type: esriFieldTypeDate, alias: Latest_Trip_Stop, SQL Type: sqlTypeOther, length: 36, nullable: false, editable: false)
• is_device_communicating (type: esriFieldTypeString, alias: is_device_communicating, SQL Type: sqlTypeOther, length: 128, nullable: false, editable: false)
• esrignss_speed (type: esriFieldTypeDouble, alias: Speed (km/h), SQL Type: sqlTypeOther, nullable: true, editable: true)
• esrignss_direction (type: esriFieldTypeDouble, alias: Direction of travel (°), SQL Type: sqlTypeOther, nullable: true, editable: true)
• esrisnsr_azimuth (type: esriFieldTypeDouble, alias: Compass reading (°), SQL Type: sqlTypeOther, nullable: true, editable: true)
• esrignss_positionsourcetype (type: esriFieldTypeInteger, alias: Position source type, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [1: User defined], [2: Integrated (System) Location Provider], ... 3 more ...)
• esrignss_receiver (type: esriFieldTypeString, alias: Receiver Name, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• esrignss_h_rms (type: esriFieldTypeDouble, alias: Horizontal Accuracy (m), SQL Type: sqlTypeOther, nullable: true, editable: true)
• esrignss_v_rms (type: esriFieldTypeDouble, alias: Vertical Accuracy (m), SQL Type: sqlTypeOther, nullable: true, editable: true)
• esrignss_latitude (type: esriFieldTypeDouble, alias: Latitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
• esrignss_longitude (type: esriFieldTypeDouble, alias: Longitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
• esrignss_altitude (type: esriFieldTypeDouble, alias: Altitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
• esrignss_pdop (type: esriFieldTypeDouble, alias: PDOP, SQL Type: sqlTypeOther, nullable: true, editable: true)
• esrignss_hdop (type: esriFieldTypeDouble, alias: HDOP, SQL Type: sqlTypeOther, nullable: true, editable: true)
• esrignss_vdop (type: esriFieldTypeDouble, alias: VDOP, SQL Type: sqlTypeOther, nullable: true, editable: true)
• esrignss_fixtype (type: esriFieldTypeSmallInteger, alias: Fix Type, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: NoFix], [1: GPS], [2: DifferentialGPS], ... 3 more ...)
• esrignss_correctionage (type: esriFieldTypeDouble, alias: Correction Age, SQL Type: sqlTypeOther, nullable: true, editable: true)
• esrignss_stationid (type: esriFieldTypeSmallInteger, alias: Station ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• esrignss_numsats (type: esriFieldTypeSmallInteger, alias: Number of Satellites, SQL Type: sqlTypeOther, nullable: true, editable: true, Range: [0 - 99])
• esrignss_fixdatetime (type: esriFieldTypeDate, alias: Fix Time, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• esrignss_avg_h_rms (type: esriFieldTypeDouble, alias: Average Horizontal Accuracy (m), SQL Type: sqlTypeOther, nullable: true, editable: true)
• esrignss_avg_v_rms (type: esriFieldTypeDouble, alias: Average Vertical Accuracy (m), SQL Type: sqlTypeOther, nullable: true, editable: true)
• esrignss_avg_positions (type: esriFieldTypeInteger, alias: Averaged Positions, SQL Type: sqlTypeOther, nullable: true, editable: true)
• esrignss_h_stddev (type: esriFieldTypeDouble, alias: Standard Deviation (m), SQL Type: sqlTypeOther, nullable: true, editable: true)

Templates:

Name: New Feature
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 7/6/2026 7:40:12 PM

Schema Last Edit Date: 7/6/2026 7:40:12 PM

Data Last Edit Date: 7/6/2026 7:40:12 PM

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