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 driving behavior to structure keys. These are the main groups of categories or domains:

  • Behaviour: capabilities encompass evaluating a driver's skills, attitudes, and habits while driving.
  • Charging/Consumption: capabilities highlight how the vehicle is powered and how its energy efficiency is 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 capability group provides information about the condition of its sensors and signals at the time of data collection.
  • Service: capabilities related to 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 standardized terminology for each property to ensure consistency and eliminate ambiguity. Therefore, each property has a maximum of three levels in its nomencla.

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 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 / MINIStellantisSilenceTargaAstrataCartrack
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.frontCenter:white-check-mark:
behaviour.seatbelt.frontLeft:white-check-mark::white-check-mark::white-check-mark:
behaviour.seatbelt.frontRight:white-check-mark::white-check-mark::white-check-mark:
behaviour.seatbelt.lastCenter:white-check-mark:
behaviour.seatbelt.lastLeft:white-check-mark:
behaviour.seatbelt.lastRight:white-check-mark:
behaviour.seatbelt.rearCenter:white-check-mark::white-check-mark:
behaviour.seatbelt.rearLeft:white-check-mark::white-check-mark:
behaviour.seatbelt.rearRight:white-check-mark::white-check-mark:
behaviour.speed.average:white-check-mark::white-check-mark:
behaviour.speed.averageReset:white-check-mark:
behaviour.speed.current:white-check-mark::white-check-mark::white-check-mark:
behaviour.speed.rpm:white-check-mark::white-check-mark:
behaviour.time.driving:white-check-mark::white-check-mark::white-check-mark:
behaviour.time.drivingReset:white-check-mark:
behaviour.time.zeroEmissions:white-check-mark:
behaviour.time.zeroEmissionsReset:white-check-mark:
charging.active:white-check-mark::white-check-mark::white-check-mark::white-check-mark:
charging.amperage.current (coming soon)
charging.electric.percentageTarget:white-check-mark:
charging.energy.charged:white-check-mark:
charging.energy.discharged:white-check-mark:
charging.energy.regenerated:white-check-mark:
charging.plugged:white-check-mark::white-check-mark::white-check-mark::white-check-mark:
charging.plugged.locked:white-check-mark:
charging.power.current:white-check-mark:
charging.power.origin:white-check-mark::white-check-mark:
charging.preconditioning.remaining:white-check-mark:
charging.preconditioning.status:white-check-mark:
charging.remaining.energy:white-check-mark:
charging.remaining.time:white-check-mark::white-check-mark::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:white-check-mark:
consumption.electric.instant:white-check-mark:
consumption.electric.max:white-check-mark:
consumption.electric.percentage:white-check-mark::white-check-mark::white-check-mark::white-check-mark::white-check-mark::white-check-mark:
consumption.electric.range:white-check-mark::white-check-mark::white-check-mark::white-check-mark::white-check-mark:
consumption.fuel.average:white-check-mark::white-check-mark:
consumption.fuel.averageReset:white-check-mark:
consumption.fuel.instant:white-check-mark::white-check-mark:
consumption.fuel.percentage:white-check-mark::white-check-mark::white-check-mark::white-check-mark::white-check-mark:
consumption.fuel.range:white-check-mark::white-check-mark::white-check-mark::white-check-mark:
consumption.fuel.rangeWarning:white-check-mark:
consumption.fuel.tank:white-check-mark::white-check-mark::white-check-mark::white-check-mark:
consumption.fuel.warning:white-check-mark:
device.battery.percentage:white-check-mark::white-check-mark:
device.battery.voltage:white-check-mark:
device.gps.odometer:white-check-mark::white-check-mark:
device.gps.speed:white-check-mark::white-check-mark::white-check-mark::white-check-mark:
doors.frontLeft.locked:white-check-mark:
doors.frontLeft.open:white-check-mark::white-check-mark::white-check-mark:
doors.frontRight.locked:white-check-mark:
doors.frontRight.open:white-check-mark::white-check-mark::white-check-mark:
doors.hood.open:white-check-mark::white-check-mark:
doors.locked:white-check-mark::white-check-mark::white-check-mark::white-check-mark:
doors.rearLeft.locked:white-check-mark:
doors.rearLeft.open:white-check-mark::white-check-mark::white-check-mark:
doors.rearRight.locked:white-check-mark:
doors.rearRight.open:white-check-mark::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::white-check-mark:
engine.alternator.warning:white-check-mark:
engine.blocked:white-check-mark:
engine.brakes.fluid.warning:white-check-mark::white-check-mark:
engine.brakes.pads.prewarning:white-check-mark:
engine.brakes.pads.warning:white-check-mark::white-check-mark:
engine.brakes.park:white-check-mark::white-check-mark:
engine.brakes.warning:white-check-mark:
engine.checkEngineLight.warning:white-check-mark:
engine.coolant.temperature:white-check-mark::white-check-mark::white-check-mark::white-check-mark:
engine.coolant.warning:white-check-mark::white-check-mark:
engine.electric.mode (coming soon)
engine.electric.StateOfHealth:white-check-mark:
engine.electric.temperature (coming soon)
engine.electric.temperatureMax:white-check-mark:
engine.electric.temperatureMin:white-check-mark:
engine.electric.voltage:white-check-mark:
engine.limpMode.status:white-check-mark:
engine.motion.status:white-check-mark::white-check-mark:
engine.oil.percentage:white-check-mark::white-check-mark:
engine.oil.temperature:white-check-mark::white-check-mark:
engine.oil.warning:white-check-mark:
engine.oilPressure.warning:white-check-mark:
engine.powerSteering.warning:white-check-mark:
engine.powerSteeringFluid.warning:white-check-mark:
engine.status:white-check-mark::white-check-mark::white-check-mark:
engine.supplyBattery.percentage:white-check-mark:
engine.supplyBattery.voltage:white-check-mark::white-check-mark::white-check-mark:
engine.supplyBattery.warning:white-check-mark:
engine.washWater.warning:white-check-mark:
engine.temperature:white-check-mark:
engine.transmission.warning:white-check-mark:
engine.washWater.warning:white-check-mark::white-check-mark:
ignition.status:white-check-mark::white-check-mark::white-check-mark::white-check-mark::white-check-mark::white-check-mark:
lights.external.fogFront:white-check-mark:
lights.external.fogRear:white-check-mark:
lights.external.indicatorsWarnings:white-check-mark:
lights.external.status:white-check-mark:
lights.external.warning: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::white-check-mark::white-check-mark::white-check-mark:
position.altitude:white-check-mark::white-check-mark::white-check-mark::white-check-mark::white-check-mark:
position.heading:white-check-mark::white-check-mark::white-check-mark::white-check-mark::white-check-mark::white-check-mark:
position.latitude:white-check-mark::white-check-mark::white-check-mark::white-check-mark::white-check-mark::white-check-mark::white-check-mark:
position.longitude:white-check-mark::white-check-mark::white-check-mark::white-check-mark::white-check-mark::white-check-mark::white-check-mark:
position.temperature:white-check-mark::white-check-mark:
security.adas.abs:white-check-mark::white-check-mark:
security.adas.airbag:white-check-mark:
security.adas.airbagPassenger:white-check-mark:
security.adas.bsm:white-check-mark:
security.adas.esp: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::white-check-mark::white-check-mark:
service.oilChange:white-check-mark:
service.time:white-check-mark::white-check-mark::white-check-mark::white-check-mark:
wheels.frontLeft.pressure:white-check-mark::white-check-mark::white-check-mark:
wheels.frontLeft.target:white-check-mark:
wheels.frontLeft.warning:white-check-mark::white-check-mark:
wheels.frontRight.pressure:white-check-mark::white-check-mark:
wheels.frontRight.target:white-check-mark:
wheels.frontRight.warning:white-check-mark::white-check-mark:
wheels.rearLeft.pressure:white-check-mark::white-check-mark:
wheels.rearLeft.target:white-check-mark:
wheels.rearLeft.warning:white-check-mark::white-check-mark:
wheels.rearRight.pressure:white-check-mark::white-check-mark:
wheels.frontRight.target:white-check-mark:
wheels.rearRight.warning:white-check-mark::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::white-check-mark:
windows.sunroofTilt.open:white-check-mark:

Available commands.

πŸ“˜

Note:

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

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

Commands by providerMercedes-Benz / SmartBWM / MINIStellantisSilenceTargaAstrataCartrack
Engine (block-unblock):white-check-mark:
Doors (lock-unlock) (Keyless):white-check-mark::white-check-mark::white-check-mark:
Preconditioning (start-stop):white-check-mark:

What’s Next