Kepler.gl is a powerful open source geospatial analysis tool for large-scale data sets.
// SPDX-License-Identifier: MIT
// Copyright contributors to the kepler.gl project
// csv restul returned by loaders.gl
// Nulls are returned as string
import {geojsonData} from 'test/fixtures/geojson';
// TODO: this is result returned by loaders.gl
// ideally we would test loaders.gl from start to end
// need to upgrade JSDom to
export const csvWithNull = [
{
'gps_data.utc_timestamp': 'Null',
'gps_data.lat': 29.9900937,
'gps_data.lng': 31.2590542,
'gps_data.types': 'driver_analytics_0',
epoch: 1472688000000,
has_result: 'False',
id: 1,
time: '2016-09-23T00:00:00.000Z',
begintrip_ts_utc: '2016-10-01 09:41:39+00:00',
begintrip_ts_local: '2016-10-01 09:41:39+00:00',
date: '2016-09-23'
},
{
'gps_data.utc_timestamp': '2016-09-17 00:10:56',
'gps_data.lat': 29.9927699,
'gps_data.lng': 31.2461142,
'gps_data.types': 'null',
epoch: 1472688000000,
has_result: 'False',
id: 'null',
time: '2016-09-23T00:00:00.000Z',
begintrip_ts_utc: '2016-10-01 09:46:37+00:00',
begintrip_ts_local: '2016-10-01 16:46:37+00:00',
date: '2016-09-23'
},
{
'gps_data.utc_timestamp': '2016-09-17 00:11:56',
'gps_data.lat': 29.9907261,
'gps_data.lng': 'NaN',
'gps_data.types': 'driver_analytics',
epoch: 1472688000000,
has_result: 'False',
id: 3,
time: '2016-09-23T00:00:00.000Z',
begintrip_ts_utc: null,
begintrip_ts_local: null,
date: '2016-09-23'
},
{
'gps_data.utc_timestamp': '2016-09-17 00:12:58',
'gps_data.lat': 29.9870074,
'gps_data.lng': 31.2175827,
'gps_data.types': 'driver_gps',
epoch: 1472688000000,
has_result: 'False',
id: 4,
time: '2016-09-23T00:00:00.000Z',
begintrip_ts_utc: null,
begintrip_ts_local: null,
date: '2016-09-23'
},
{
'gps_data.utc_timestamp': '2016-09-17 00:14:00',
'gps_data.lat': 29.9923041,
'gps_data.lng': 31.2154899,
'gps_data.types': 'driver_analytics',
epoch: 1472688000000,
has_result: 1,
id: 5,
time: '2016-09-23T00:00:00.000Z',
begintrip_ts_utc: '2016-10-01 09:47:37+00:00',
begintrip_ts_local: '2016-10-01 16:47:37+00:00',
date: null
},
{
'gps_data.utc_timestamp': '2016-09-17 00:15:01',
'gps_data.lat': 29.9968249,
'gps_data.lng': 31.2149361,
'gps_data.types': 'driver_analytics',
epoch: 1472688000000,
has_result: 'False',
id: 12124,
time: '2016-09-23T05:00:00.000Z',
begintrip_ts_utc: null,
begintrip_ts_local: null,
date: null
},
{
'gps_data.utc_timestamp': '2016-09-17 00:16:03',
'gps_data.lat': 'Null',
'gps_data.lng': 31.2164035,
'gps_data.types': 'driver_analytics',
epoch: 1472688000000,
has_result: 'False',
id: 222,
time: '2016-09-23T05:00:00.000Z',
begintrip_ts_utc: null,
begintrip_ts_local: null,
date: null
},
{
'gps_data.utc_timestamp': '2016-09-17 00:17:05',
'gps_data.lat': 30.0116207,
'gps_data.lng': 31.2179346,
'gps_data.types': 'driver_analytics',
epoch: 1472688000000,
has_result: 'False',
id: 345,
time: '2016-09-23T00:00:00.000Z',
begintrip_ts_utc: null,
begintrip_ts_local: null,
date: '2016-09-24'
},
{
'gps_data.utc_timestamp': '2016-09-17 00:18:09',
'gps_data.lat': 30.0208925,
'gps_data.lng': 31.2179556,
'gps_data.types': 'driver_analytics',
epoch: 1472708000000,
has_result: 'False',
id: null,
time: '2016-09-23T00:00:00.000Z',
begintrip_ts_utc: null,
begintrip_ts_local: null,
date: '2016-09-24'
},
{
'gps_data.utc_timestamp': '2016-09-17 00:19:12',
'gps_data.lat': 30.0218999,
'gps_data.lng': 31.2178842,
'gps_data.types': 'driver_analytics',
epoch: 'NULL',
has_result: 0,
id: null,
time: '2016-09-23T06:00:00.000Z',
begintrip_ts_utc: null,
begintrip_ts_local: null,
date: '2016-09-24'
},
{
'gps_data.utc_timestamp': '2016-09-17 00:19:27',
'gps_data.lat': 30.0229344,
'gps_data.lng': 31.2179138,
'gps_data.types': 'driver_gps',
epoch: 1472708000000,
has_result: 'False',
id: null,
time: '2016-09-23T05:00:00.000Z',
begintrip_ts_utc: null,
begintrip_ts_local: null,
date: '2016-09-24'
},
{
'gps_data.utc_timestamp': '2016-09-17 00:20:14',
'gps_data.lat': 30.0264237,
'gps_data.lng': 31.2179415,
'gps_data.types': 'driver_gps',
epoch: 1472708000000,
has_result: 'False',
id: null,
time: null,
begintrip_ts_utc: null,
begintrip_ts_local: null,
date: '2016-09-24'
},
{
'gps_data.utc_timestamp': '2016-09-17 00:21:17',
'gps_data.lat': 30.0292134,
'gps_data.lng': 31.2181809,
'gps_data.types': 'driver_gps',
epoch: 1472754400000,
has_result: 'False',
id: null,
time: null,
begintrip_ts_utc: null,
begintrip_ts_local: null,
date: '2016-09-24'
}
];
// metaData batch csv
export const csvMetaDataBatch = {
batchType: 'metadata',
bytesUsed: 0,
data: [],
metadata: {
_context: {},
_loader: {}
}
};
export const csvSchema = {
'gps_data.utc_timestamp': {
name: 'gps_data.utc_timestamp',
index: 0
},
'gps_data.lat': {
name: 'gps_data.lat',
index: 1
},
'gps_data.lng': {
name: 'gps_data.lng',
index: 2
},
'gps_data.types': {
name: 'gps_data.types',
index: 3
},
epoch: {
name: 'epoch',
index: 4
},
has_result: {
name: 'has_result',
index: 5
},
id: {
name: 'id',
index: 6
},
time: {
name: 'time',
index: 7
},
begintrip_ts_utc: {
name: 'begintrip_ts_utc',
index: 8
},
begintrip_ts_local: {
name: 'begintrip_ts_local',
index: 9
},
date: {
name: 'date',
index: 10
}
};
// data batch csv
export const csvDataBatch0 = {
bytesUsed: 2000,
count: 0,
// cursor: 0
data: csvWithNull.slice(0, 6),
length: 6,
schema: csvSchema
};
export const csvDataBatch1 = {
bytesUsed: 3000,
count: 1,
// cursor: 0
data: csvWithNull.slice(6, 13),
length: 7,
schema: csvSchema
};
export const geojsonMetaBatch = {
batchType: 'metadata',
bytesUsed: 0,
// data is empty in metaBatch
data: [],
// omit loader
metadata: {_loader: {}, _context: {}},
progress: {
percent: 0,
rowCount: 0,
rowCountInBatch: 0
}
};
export const geoJsonPartialBatch = {
batchType: 'partial-result',
bytesUsed: 0,
container: {type: 'FeatureCollection', features: []},
data: [],
jsonpath: '$.features',
schema: {}
};
export const geoJsonDataBatch0 = {
bytesUsed: 2000,
count: 1,
cursor: 0,
data: geojsonData.features.slice(0, 2),
jsonpath: '$.features',
length: 5,
schema: null
};
export const geoJsonDataBatch1 = {
bytesUsed: 4000,
count: 2,
cursor: 0,
data: geojsonData.features.slice(2, 5),
jsonpath: '$.features',
length: 3,
schema: null
};
export const geoJsonFinalBatch = {
batchType: 'final-result',
container: {type: 'FeatureCollection', features: []},
data: [],
jsonpath: '$.features',
schema: null
};