Register Login
Shop4Parts - UK's largest online superstore for FIAT and Alfa Romeo parts
Reply
 
Thread Tools
Old 10-06-2009   #1
Join Date: Aug 2007
Location: Scotland
Posts: 2,454
Thanks: 124
Trader Rating: 2
colin79666 has donated!
United Kingdom 
Post Ecodrive - what's it measuring?

Well to answer that I've found the database file held on your PC and taken a look with the help of the SQLiteManager extension for Firefox.

Makes for very interesting reading. There's fields for measuring oil levels, brake wear and even measurements held in the trip computer.
Code:
CREATE TABLE [AccelerationBandData]

(

    [JourneyId] integer NOT NULL,

    LowerSpeed integer NOT NULL,

    UpperSpeed integer NOT NULL,

    Acceleration FLOAT NOT NULL,

    Deceleration FLOAT NOT NULL,

    PRIMARY KEY ([JourneyId],[LowerSpeed], [UpperSpeed])

    /* Foreign keys */

      FOREIGN KEY (JourneyId) REFERENCES Journey(Id)

);
CREATE TABLE DatabaseVersion (SequenceNumber INTEGER NOT NULL PRIMARY KEY, Description TEXT NOT NULL, Signature VARCHAR(64) NOT NULL, DateAdded FLOAT);
CREATE TABLE [DrivingCategoryScore] (
  JourneyId          integer NOT NULL,
  JourneyCategoryId  integer NOT NULL,
  Score              numeric(50) NOT NULL,
  /* Foreign keys */
  FOREIGN KEY (JourneyId) REFERENCES Journey(Id)
);
CREATE TABLE [GearData] (
    [JourneyId] INTEGER  NOT NULL,
    [Gear] INTEGER  NOT NULL,
    [AverageAcceleration] FLOAT  NOT NULL,
    [AverageDownshiftRPM] FLOAT  NOT NULL,
    [AverageUpshiftRPM] FLOAT  NOT NULL,
    [PercentUsage] FLOAT  NOT NULL, AverageDeceleration FLOAT NULL,
    PRIMARY KEY ([JourneyId],[Gear])
    /* Foreign keys */
      FOREIGN KEY (JourneyId) REFERENCES Journey(Id)
);
CREATE TABLE [Journey] (
[Id] integer  PRIMARY KEY NOT NULL,
[UserLocalId] varchar(36)  NOT NULL,
[VehicleLocalId] varchar(36)  NOT NULL,
[StartTime] float  NOT NULL,
[StartDate] float  NOT NULL,
[EndTime] float  NULL,
[StartOdometer] float  NULL,
[EndOdometer] float  NULL,
[EcoIndex] int  NULL,
[EcoIndexServerId] varchar(36)  NULL,
[EcoIndexServerAlgorithmVersion] varchar(36)  NULL,
[PricePerUnit] float  NULL,
[FuelConsumed] float  NULL,
[JourneyType] varchar(16)  NULL,
[ComputedServerFuelConsumption] FLOAT  NULL,
[ConsumptionUnit] VARCHAR(64)  NULL,
[TripDataCount] INTEGER  NOT NULL
, OilLevelStatus INTEGER NULL);
CREATE TABLE [KeyOffData] (

[JourneyId] INTEGER  NOT NULL,

[DistanceUnit] INTEGER  NULL,

[DistanceToService] INTEGER  NULL,

[DistanceToServiceValidData] INTEGER  NULL,

[FuelLevel] INTEGER  NULL,

[FuelLevelFailSts] INTEGER  NULL,

[CNGFillingTank] INTEGER  NULL,

[AutonomyDistance] INTEGER  NULL,

[AutonomyDistanceValidData] INTEGER  NULL,

[OilLevelIndication] INTEGER  NULL,

[OilLifeSts] INTEGER  NULL,

[EngineWaterLevel] INTEGER  NULL,

[BrakeFluidLevelSts] INTEGER  NULL,

[BrakePadWearSts] INTEGER  NULL,

[TyreInflationState] INTEGER  NULL,

[TyrePressureSystemFailSts] INTEGER  NULL,

[DPFStatus] INTEGER  NULL,

/* Foreign keys */

FOREIGN KEY (JourneyId) REFERENCES Journey(Id)

);
CREATE TABLE [TripAComputerData] (
[JourneyId] integer  NOT NULL,
[DateTime] float  NOT NULL,
[PartialOdometer] float  NULL,
[AverageSpeed] float  NULL,
[AverageFuelConsumption] float  NULL,
[EventType] INTEGER  NOT NULL,
[DistanceUnit] VARCHAR(10)  NOT NULL
);
CREATE TABLE TripData (
  JourneyId                     integer NOT NULL,
  "DateTime"                    float NOT NULL,
  EngineSpeed                   float NOT NULL,
  VehicleSpeed                  float NOT NULL,
  InstantaneousFuelConsumption  float NOT NULL,
  AverageFuelConsumption        float NOT NULL,
  /* Foreign keys */
  FOREIGN KEY (JourneyId) REFERENCES Journey(Id)
);
CREATE TABLE TripStatusData (
  JourneyId            integer NOT NULL,
  "DateTime"           float NOT NULL,
  ExternalTemperature  float,
  CompressorSts        smallint,
  /* Foreign keys */
  FOREIGN KEY (JourneyId) REFERENCES Journey(Id)
);
makes interesting reading for fellow geeks
__________________
colin79666 is offline Reply With Quote Quote 
Old 12-06-2009   #2
Join Date: Jul 2008
Posts: 319
Thanks: 17
Trader Rating: 0
United Kingdom 
Re: Ecodrive - what's it measuring?

That *Is* quite a lot of data it's logging , quite a bit of it not directly related to your driving.

How detailed are the stats? Could you see what speed you were doing at any given time for example?
__________________
Alex

Dr Zoidberg is offline Reply With Quote Quote 
Old 12-06-2009   #3
Telford's Own...
 
Ffoxy's Avatar
Join Date: Apr 2007
Posts: 9,824
Thanks: 373
Trader Rating: 0
Ffoxy has donated!
United Kingdom 
Re: Ecodrive - what's it measuring?

Quote Originally Posted by Dr Zoidberg View Post
That *Is* quite a lot of data it's logging , quite a bit of it not directly related to your driving.

How detailed are the stats? Could you see what speed you were doing at any given time for example?
That is a great question, and could your dealer / Fiat see this if they wanted to... ? Anyone NOT see where I'm going with this?
__________________
Ex Suzuki SV1000S jockey, now a former 1.9 MJet Grande Punto Sporting pilot curently driving a Hyundai i30 1.6 Premium.
Ffoxy is offline Reply With Quote Quote 
Old 12-06-2009   #4
Join Date: Jul 2008
Posts: 319
Thanks: 17
Trader Rating: 0
United Kingdom 
Re: Ecodrive - what's it measuring?

As I understand it , the B&M system can log 8 hours of driving data before it overwrites the oldest information.

I wonder if that's actually purged when you insert your USB stick or if it's just flagged and left on there.

If you assume that Fiat can see at least this much of your history then you won't go far wrong - just have a few days of sedate driving before a trip to the dealer.

Nof if only I could get my score above 68 I'd be happy
__________________
Alex

Dr Zoidberg is offline Reply With Quote Quote 
Old 12-06-2009   #5
Telford's Own...
 
Ffoxy's Avatar
Join Date: Apr 2007
Posts: 9,824
Thanks: 373
Trader Rating: 0
Ffoxy has donated!
United Kingdom 
Re: Ecodrive - what's it measuring?

Has this "over-revving" only become an issue since the Eco-Drive launch?

Could Eco-Drive be a bit of a Trojan horse?

I love conspiracy theories!
__________________
Ex Suzuki SV1000S jockey, now a former 1.9 MJet Grande Punto Sporting pilot curently driving a Hyundai i30 1.6 Premium.
Ffoxy is offline Reply With Quote Quote 
Old 12-06-2009   #6
Join Date: Aug 2007
Location: Scotland
Posts: 2,454
Thanks: 124
Trader Rating: 2
colin79666 has donated!
United Kingdom 
Re: Ecodrive - what's it measuring?

Quote Originally Posted by Dr Zoidberg View Post
How detailed are the stats? Could you see what speed you were doing at any given time for example?
Yes - and I'm not going to post here what my max speed has been as I don't need to incriminate myself My highest revs have been 5376 rpm (and that's not normal for me) so at least I haven't been over revving it.

Timestamps appears to be the standard Unix format and speeds are in km/h.
__________________
colin79666 is offline Reply With Quote Quote 
Old 12-06-2009   #7
Join Date: Jul 2008
Posts: 319
Thanks: 17
Trader Rating: 0
United Kingdom 
Re: Ecodrive - what's it measuring?

Which specific file is it?
I fancy a nose at mine
__________________
Alex

Dr Zoidberg is offline Reply With Quote Quote 
Old 12-06-2009   #8
Join Date: Aug 2007
Location: Scotland
Posts: 2,454
Thanks: 124
Trader Rating: 2
colin79666 has donated!
United Kingdom 
Re: Ecodrive - what's it measuring?

C:\Documents and Settings\xxx\Application Data\com.fiat.convergence.xxx\Local Store\ecoDriveJourney.db

Make a copy so you don't mess up your data
__________________
colin79666 is offline Reply With Quote Quote 
Reply
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump
Similar Threads
Thread Thread Starter Forum Replies Last Post
Ecodrive in australia robertclarke Blue and Me 1 19-04-2009 10:53
ecodrive robertclarke Blue and Me 1 19-03-2009 14:57
(T) EcoDrive - Anyone Chiron Grande Punto 3 22-10-2008 13:00
(G) ecodrive plant38 500 10 29-05-2008 14:45
(T) gauge of sumsort for measuring air going thru the induction kit imola_fowkes Cinquecento / Seicento 3 10-09-2004 00:10