@dapia-project/data-converter

Data-Converter

This conversion is for ADS-B data only.
This library contains several conversion tools for ADS-B messages. We find :

• SBS to JSON
• JSON to SBS
• SBS to NDJSON
• NDJSON to SBS
• CSV Opensky to JSON
• JSON to CSV Opensky
• CSV Opensky to NDJSON
• NDJSON to CSV Opensky
• SBS to CSV Opensky
• CSV Opensky to SBS
• CSV Drone to SBS
• SBS to CSV Drone
• CSV Drone to CSV Opensky
• CSV Opensky to CSV Drone
• CSV Drone to JSON
• JSON to CSV Drone
• CSV Drone to NDJSON
• NDJSON to CSV Drone
• JSON to NDJSON
• NDJSON to JSON

Setup

Via NPM

npm i @dapia-project/data-converter

By updating package.json

In your package.json, add the following:

{
  "dependencies": {
    "@dapia-project/data-converter": "^5.0.0"
  }
}

Initialization

Import SBS to JSON converter:

import { sbsToJson } from '@dapia-project/data-converter/src/sbsToJson'

const jsonData: string = sbsToJson(content, {saveExtraField : true, mustMerge: false})

Import JSON to SBS converter:

import { jsonToSbs } from '@dapia-project/data-converter/src/jsonToSbs'

const sbsData: string = jsonToSbs(content, {saveExtraField : true, mustMerge: false})

Import SBS to NDJSON converter:

import { sbsToNdjson } from '@dapia-project/data-converter/src/sbsToNdjson'

const ndjsonData: string = sbsToNdjson(content, {saveExtraField : true, mustMerge: false})

Import NDJSON to SBS converter:

import { ndjsonToSbs } from '@dapia-project/data-converter/src/ndjsonToSbs'

const sbsData: string = ndjsonToSbs(content, {saveExtraField : true, mustMerge: false})

Import CSV Opensky to JSON converter:

import { openskyCsvToJson } from '@dapia-project/data-converter/src/openskyCsvToJson'

const jsonData: string = openskyCsvToJson(content, {saveExtraField : true, mustMerge: false})

Import JSON to CSV Opensky converter:

import { jsonToOpenskyCsv } from '@dapia-project/data-converter/src/jsonToOpenskyCsv'

const openskyCsvData: string = jsonToOpenskyCsv(content, {saveExtraField : true, mustMerge: false})

Import CSV Opensky to NDJSON converter:

import { openskyCsvToNdjson } from '@dapia-project/data-converter/src/openskyCsvToNdjson'

const ndjsonData: string = openskyCsvToNdjson(content, {saveExtraField : true, mustMerge: false})

Import NDJSON to CSV Opensky converter:

import { ndjsonToOpenskyCsv } from '@dapia-project/data-converter/src/ndjsonToOpenskyCsv'

const openskyCsvData: string = ndjsonToOpenskyCsv(content, {saveExtraField : true, mustMerge: false})

Import CSV Opensky to SBS converter:

import { openskyCsvToSbs } from '@dapia-project/data-converter/src/openskyCsvToSbs'

const sbsData: string = openskyCsvToSbs(content, {saveExtraField : true, mustMerge: false})

Import SBS to CSV Opensky converter:

import { sbsToOpenskyCsv } from '@dapia-project/data-converter/src/sbsToOpenskyCsv'

const openskyCsvData: string = sbsToOpenskyCsv(content, {saveExtraField : true, mustMerge: false})

Import SBS to CSV Drone converter:

import { sbsToDroneCsv } from '@dapia-project/data-converter/src/sbsToDroneCsv'

const droneCsvData: string = sbsToDroneCsv(content, {saveExtraField : true, mustMerge: false})

Import JSON to CSV Drone converter:

import { jsonToDroneCsv } from '@dapia-project/data-converter/src/jsonToDroneCsv'

const droneCsvData: string = jsonToDroneCsv(content, {saveExtraField : true, mustMerge: false})

Import NDJSON to CSV Drone converter:

import { ndjsonToDroneCsv } from '@dapia-project/data-converter/src/ndjsonToDroneCsv'

const droneCsvData: string = ndjsonToDroneCsv(content, {saveExtraField : true, mustMerge: false})

Import CSV Opensky to CSV Drone converter:

import { openskyCsvToDroneCsv } from '@dapia-project/data-converter/src/openskyCsvToDroneCsv'

const droneCsvData: string = openskyCsvToDroneCsv(content, {saveExtraField : true, mustMerge: false})

Import CSV Drone to SBS converter:

import { droneCsvToSbs } from '@dapia-project/data-converter/src/droneCsvToSbs'

const sbsData: string = droneCsvToSbs(content, {saveExtraField : true, mustMerge: false})

Import CSV Drone to JSON converter:

import { droneCsvToJson } from '@dapia-project/data-converter/src/droneCsvToJson'

const jsonData: string = droneCsvToJson(content, {saveExtraField : true, mustMerge: false})

Import CSV Drone to NDJSON converter:

import { droneCsvToNdjson } from '@dapia-project/data-converter/src/droneCsvToNdjson'

const ndjsonData: string = droneCsvToNdjson(content, {saveExtraField : true, mustMerge: false})

Import CSV Drone to CSV Opensky converter:

import { droneCsvToOpenskyCSV } from '@dapia-project/data-converter/src/droneCsvToOpenskyCsv'

const openskyCsvData: string = droneCsvToOpenskyCsv(content, {saveExtraField : true, mustMerge: false})

Content

Content is a string who represent the content file to convert

Options

For all :

key	type	use	default value
mustMerge	boolean	Choice to merge messages who are present many times for one couple of icao/timestamp	false
saveExtraField?	boolean	Choice to have extraField of Format1 in Format2	false

Order of fields

For SBS files :

Number	Field
Field 1	messageType
Field 2	transmissionType
Field 3	sessionID
Field 4	aircraftID
Field 5	icao24
Field 6	flightID
Field 7	dateMessageGenerated (AAAA/MM/DD)
Field 8	timeMessageGenerated (HH:mm:ss.SSS)
Field 9	dateMessageLogged (AAAA/MM/DD)
Field 10	timeMessageLogged (HH:mm:ss.SSS)
Field 11	callsign
Field 12	geoaltitude
Field 13	groundspeed
Field 14	track
Field 15	latitude
Field 16	longitude
Field 17	vertical_rate
Field 18	squawk
Field 19	alert
Field 20	emergency
Field 21	spi
Field 22	onground
Field 23	haveLabel?
Field 24	label?
Field 23 or 25	extraField?

The HaveLabel and Label fields are not required. But if one is present then so is the other.
The ExtraField field is a JSON object that contains information present in a converted csv file not present in sbs file. Here is an example:

{
  "altitude": "",
  "last_position": "",
  "lastcontact": "",
  "hour": ""
}

You can find information about the SBS format here: http://woodair.net/sbs/Article/Barebones42_Socket_Data.htm

For CSV Opensky files :

The order of the fields below is the order when converting SBS to CSV Opensky. However, the order of fields in a CSV Opensky file during a CSV Opensky to SBS conversion does not follow a certain pattern.

Number	Field
Field 1	timestamp
Field 2	icao24
Field 3	latitude
Field 4	longitude
Field 5	groundspeed
Field 6	track
Field 7	vertical_rate
Field 8	callsign
Field 9	onground
Field 10	alert
Field 11	spi
Field 12	squawk
Field 13	altitude
Field 14	geoaltitude
Field 15	last_position?
Field 16	lastcontact?
Field 17	hour?
Field 18	extraField?

The ExtraField field is a JSON object that contains information present in a converted sbs file not present in csv file. It is not mandatory to add this field when converting. Here is an exemple:

{
  "messageType": "",
  "transmissionType": "",
  "sessionID": "",
  "aircraftID": "",
  "flightID": "",
  "emergency": ""
}

For CSV Drone files :

Number	Field
Field 1	name
Field 2	icao24
Field 3	date (AAAA-MM-DDTHH:mm:ss.SSSZ)
Field 4	fixName
Field 5	significantPoint
Field 6	timeElapsed
Field 7	position.latitude
Field 8	position.longitude
Field 9	position.altitude
Field 10	altitudeMax
Field 11	airSpeed
Field 12	cas
Field 13	mach
Field 14	heading
Field 15	groundspeed
Field 16	distanceToNextWaypoint
Field 17	flownDistance
Field 18	wind.eastward
Field 19	wind.northward
Field 20	wind.upward
Field 21	route
Field 22	mass
Field 23	isOneWay
Field 24	extraField?

For JSON and NDJSON files :

Field
timestamp?
icao24?
latitude?
longitude?
groundspeed?
track?
vertical_rate?
callsign?
onground?
alert?
spi?
squawk?
altitude?
geoaltitude?
last_position?
lastcontact?
hour?
messageType?
transmissionType?
sessionID?
aircraftID?
flightID?
emergency?
dateMessageGenerated?
timeMessageGenerated?
dateMessageLogged?
timeMessageLogged?
haveLabel?
label?
name?
date?
fixName?
significantPoint?
timeElapsed?
position.latitude?
position.longitude?
position.altitude?
altitudeMax?
airSpeed?
cas?
mach?
heading?
distanceToNextWaypoint?
flownDistance?
wind.eastward?
wind.northward?
wind.upward?
route?
mass?
isOneWay?

Commands line

You can also run a command line conversion like this:

First, download library globally :

npm i @dapia-project/data-converter -g

Then :

data-converter --file "path/to/fileToConvert.ext" --output "path/to/fileWillBeConvert.ext" [--fusion]

Possible extension types are .sbs, .csv, .json and .ndjson
The option --fusion allows you to merge duplicates.
If you wish to convert a file into a Drone CSV file please put the extension .drone.csv to the output file