Normalizing data

This page displays information about the task of harmonizing and structuring data from the data providers, as OEMs or hardware providers partners, into a standardized format.

Normalizing data from multiple providers involves standardizing and cleaning data to ensure consistency and reliability. This process includes establishing uniform and consistent naming conventions, converting units, handling missing values, and transforming data for unified analysis.

Nomenclature

astara Connect uses the arrangement of sensors, signals, features or the driving behaviour as a basis for structuring keys. These are the main groups of categories or domains:

  • Behaviour: capabilities encompasses evaluating a driver's skills, attitudes, and habits during the driving on the road.
  • Charging/Consumption: capabilities highlights how the vehicle is powered and its energy efficiency related to its driving.
  • Device: capabilities related to the device installed within the vehicle and the values computed by this device.
  • Doors/Engine/Ignition/Lights/Odometer/Position/Wheels/Windows: each group of capabilities are providing information about their sensors and signals condition at the time of the data collection.
  • Service: capabilities about the vehicle's maintenance needs.
  • Secure: capabilities designed to protect the occupants and prevent theft, as the anti-theft systems installed in the vehicle.

Define a standardized terminology for each property to ensure consistency and eliminate ambiguity. Therefore we have a maximum of three levels in the nomenclature of a property.

first Level . second level . third level
category . component/functionality . specification/status/sensor

Units

astara Connect employs a diverse set of quantitative values to describe properties and uses UN/CEFACT Common Code for the units of measurement for these values.

Some of the values, that we ingest from the providers, require an ETL (Extract, Transform, Load) process. This process ensures that the data is accessible, accurate, and ready for analysis or use in applications.

Available keys

πŸ“˜

Note:

The listed keys can be available in vehicles equipped with the respective sensor or signal, and, in certain instances, if the vehicle has an active manufacturer's service package.

For detailed information, please refer to the conditions specified by each manufacturer.

Available keys by providerMercedes-Benz / SmartBWM / MINIAstrataCartrack
behaviour.distance.electric:white-check-mark:
behaviour.distance.electricReset:white-check-mark:
behaviour.distance.fuel:white-check-mark:
behaviour.distance.fuelReset:white-check-mark:
behaviour.distance.zeroEmissions:white-check-mark:
behaviour.distance.zeroEmissionsReset:white-check-mark:
behaviour.score.acceleration:white-check-mark:
behaviour.score.constancy:white-check-mark:
behaviour.score.freewheel:white-check-mark:
behaviour.score.range:white-check-mark:
behaviour.seatbelt.frontLeft.buckledUp:white-check-mark:
behaviour.speed.average:white-check-mark:
behaviour.speed.averageReset:white-check-mark:
behaviour.speed.current:white-check-mark:
behaviour.time.driving:white-check-mark:
behaviour.time.drivingReset:white-check-mark:
behaviour.time.zeroEmissions:white-check-mark:
behaviour.time.zeroEmissionsReset:white-check-mark:
charging.amperage.current (coming soon)
charging.energy.charged (coming soon)
charging.energy.discharged (coming soon)
charging.energy.regenerated (coming soon)
charging.plugged:white-check-mark::white-check-mark:
charging.power.current:white-check-mark:
charging.preconditioning.remaining:white-check-mark:
charging.preconditioning.status:white-check-mark:
charging.remaining.time:white-check-mark:
consumption.adBlue.percentage:white-check-mark:
consumption.adBlue.range:white-check-mark:
consumption.electric.average:white-check-mark::white-check-mark:
consumption.electric.averageReset:white-check-mark:
consumption.electric.drainCurrent (coming soon)
consumption.electric.instant (coming soon)
consumption.electric.max:white-check-mark:
consumption.electric.percentage:white-check-mark::white-check-mark::white-check-mark:
consumption.electric.range:white-check-mark::white-check-mark:
consumption.fuel.average:white-check-mark:
consumption.fuel.averageReset:white-check-mark:
consumption.fuel.instant
consumption.fuel.percentage:white-check-mark::white-check-mark::white-check-mark:
consumption.fuel.range:white-check-mark::white-check-mark:
consumption.fuel.rangeWarning:white-check-mark:
consumption.fuel.tank:white-check-mark::white-check-mark:
consumption.fuel.warning:white-check-mark:
device.battery.percentage:white-check-mark:
device.battery.voltage:white-check-mark:
device.gps.odometer:white-check-mark:
device.gps.speed:white-check-mark::white-check-mark:
doors.frontLeft.locked:white-check-mark:
doors.frontLeft.open:white-check-mark::white-check-mark:
doors.frontRight.locked:white-check-mark:
doors.frontRight.open:white-check-mark::white-check-mark:
doors.hood.open:white-check-mark:
doors.locked:white-check-mark:
doors.rearLeft.locked:white-check-mark:
doors.rearLeft.open:white-check-mark::white-check-mark:
doors.rearRight.locked:white-check-mark:
doors.rearRight.open:white-check-mark::white-check-mark:
doors.rooftop.open:white-check-mark::white-check-mark:
doors.tankcap.open:white-check-mark:
doors.trunk.locked:white-check-mark:
doors.trunk.open:white-check-mark::white-check-mark:
engine.brakes.fluid.warning:white-check-mark:
engine.brakes.pads.prewarning:white-check-mark:
engine.brakes.pads.warning:white-check-mark:
engine.brakes.park:white-check-mark:
engine.coolant.temperature:white-check-mark:
engine.coolant.warning:white-check-mark:
engine.dashboard (coming soon)
engine.electric.mode (coming soon)
engine.electric.temperature (coming soon)
engine.electric.temperatureMax(coming soon)
engine.electric.temperatureMin (coming soon)
engine.electric.voltage (coming soon)
engine.limpMode.status:white-check-mark:
engine.oil.percentage:white-check-mark:
engine.oil.warning:white-check-mark:
engine.supplyBattery.voltage:white-check-mark::white-check-mark:
engine.supplyBattery.warning:white-check-mark:
engine.washWater.warning:white-check-mark:
ignition.status:white-check-mark::white-check-mark::white-check-mark:
lights.interior.front.on:white-check-mark:
lights.interior.readingFrontLeft.on:white-check-mark:
lights.interior.readingFrontRight.on:white-check-mark:
lights.interior.rear.on:white-check-mark:
odometer:white-check-mark::white-check-mark::white-check-mark:
position.altitude:white-check-mark::white-check-mark:
position.heading:white-check-mark::white-check-mark::white-check-mark:
security.alarm.status:white-check-mark:
security.alarm.warning:white-check-mark:
security.interior.status:white-check-mark:
security.interior.warning:white-check-mark:
security.tow.status:white-check-mark:
security.tow.warning:white-check-mark:
service.distance:white-check-mark::white-check-mark:
service.time:white-check-mark::white-check-mark:
wheels.frontLeft.pressure.:white-check-mark::white-check-mark:
wheels.frontLeft.warning:white-check-mark:
wheels.frontRight.pressure:white-check-mark::white-check-mark:
wheels.frontRight.warning:white-check-mark:
wheels.rearLeft.pressure:white-check-mark::white-check-mark:
wheels.rearLeft.warning:white-check-mark:
wheels.rearRight.pressure:white-check-mark::white-check-mark:
wheels.rearRight.warning:white-check-mark:
windows.frontLeft.open:white-check-mark::white-check-mark:
windows.frontRight.open:white-check-mark::white-check-mark:
windows.rearLeft.open:white-check-mark::white-check-mark:
windows.rearRight.open:white-check-mark::white-check-mark:
windows.sunroof.open:white-check-mark::white-check-mark:

What’s Next