Re: VSS/Vehicle data consideration

Rudi-san and all

I appreciate your understanding and cooperation.

Attached is the excel file highlighted in yellow / light-blue 
lines and reversed characters as well as summary slides of powerpoint,
just in case.

BTW, Rudi-san, can you remotely join VSS consideration session 
starting from 10:00 in Lisbon time? 

I'm looking forward to seeing you in WebEX online.

Best regards,

T.Hirabayashi

----- Original Message -----
> Thank you very much, Hirabayashi-san and Urata-san,
> 
> I am going to add the missing signals indicated by the red background 
to
> VSS.
> 
> Best regards,
> Rudi
> 
> On Mon, Sep 19, 2016 at 1:49 AM, Shinjiro Urata <
> shinjiro.urata@access-company.com> wrote:
> 
> > Hirabayashi-san,
> >
> > Thank you very much for the comparizon.
> > By the way, it looks yellow-painted line is missing in  "160919_vss.
csv".
> > (This is because csv format can't hold background color info.
> >  It should be saved as .xlsx. or something.)
> >
> > I think I painted again the newly added lines.
> > Please check the attached.
> >
> > Best regards,
> > Shinjiro Urata
> >
> >
> >
> >
> > 2016-09-19 15:13 GMT+09:00 <ta-hirabayashi@kddi-ri.jp>:
> >
> >> Hi, Rudi-san, Urata-san and all
> >>
> >> Urata-san's CSV file is really helpful! Thank you very much.
> >>
> >> Tentative summary I have reviewed the current VSS and Vehicle data 
spec
> >> comparing each other are as follows:
> >>
> >> * Missing Data/Signal in VSS
> >>   - Highlighted in a yellow line in vss.csv
> >>   - The following data/signal of the Vehicle data should be at 
least
> >> added
> >>     to VSS;
> >>     > VIN,WMI, brand, model, vehicle type, year
> >>     > Accelerator/brake pedal position, steering wheel angle, tire
> >> pressure
> >>     > Fuel level, average/instant consumption
> >>     > ABS, TCS, ESC, odometer, trip meter
> >>     > Acceleration (x, y, z), gyro-data (yaw, pitch, roll), 
location
> >> accuracy
> >>     > Ignition on/off time, airbag deployment, cruise control, etc.
> >>
> >> * Changes of Data Type
> >>   - Location data signal should comply with Section 5.4 of W3C
> >> Geolocation
> >>     API REC
> >>     (https://www.w3.org/TR/2013/REC-geolocation-API-20131024/#position)

> >>   - Other signals to be reviewed are shown in reversed characters 
in vss.
> >> csv
> >>
> >> * New Data/Signal to be Added
> >>   - Some data has been missing in both VSS and Vehicle data.
> >>     e.g. Fuel tank capacity, number of tires are highlighted in a
> >>          light-blued line in vss.csv
> >>
> >> We would like to discuss the above issues in Lisbon if possible.
> >>
> >> Thanks,
> >>
> >> T.Hirabayashi, KDDI
> >>
> >> ----- Original Message -----
> >> > Urata-san,
> >> >
> >> > Thank you very much. This is looking really good. There are two 
more
> >> things
> >> > I would like you to consider and I apologize for not bringing 
them up
> >> > earlier:
> >> >
> >> >
> >> > 1. Using the vss2json.py tool
> >> > <https://github.com/GENIVI/vehicle_signal_specification/blob
> >> /develop/tools/vspec2json.py>
> >>
> >> > as
> >> > a template
> >> >
> >> > We already have three conversion tools that directly convert VSS 
into
> >> > different output formats in the GENIVI Github repository
> >> > <https://github.com/GENIVI/vehicle_signal_specification>. I would 
like
> >> to
> >> > add your tool to the repo but it would be very beneficial if it
> >> followed
> >> > the same template as the other tools. These tools directly read 
the
> >> VSS
> >> > files. It's easy since the core of it is a converter that reads 
VSS
> >> YAML
> >> > hierarchy into a JSON structure. All you have to do is
> >> >
> >> > import vspec
> >> >
> >> > tree = vspec.load(<vspec_file>, <include_dirs>)
> >> >
> >> > tree then contains the JSON tree structure alleviating you from
> >> reading the
> >> > JSON file and omitting the vspec2json step. The vspec2json.py
> >> converter
> >> > also contains the code to create the signal ID database.
> >> >
> >> >
> >> > 2. Splitting up the signal names into individual nodes
> >> >
> >> > Your tool is currently splitting up the signal names and places 
the
> >> > individual nodes each into their own column in the csv file. I 
have
> >> been
> >> > thinking about it. The biggest problem is that the tree is not 
limited
> >> in
> >> > depth. There  can be any depth and you don't know how many 
columns are
> >> > needed. The second problem is that you cannot easily look up a 
signal
> >> by
> >> > its name because you have to search across columns. Maybe it's 
better
> >> to
> >> > just put the signal name in its entirety into a single column? 
The csv
> >> file
> >> > structure would then be:
> >> >
> >> > [Signal] ,[ID], [Type], [Unit], [Min], [Max], [Description]
> >> >
> >> >
> >> >
> >> > Others, please weigh in here too.
> >> >
> >> > Thanks,
> >> > Rudi
> >> >
> >> >
> >> >
> >> >
> >> > On Sun, Sep 11, 2016 at 6:04 PM, Shinjiro Urata <
> >> > shinjiro.urata@access-company.com> wrote:
> >> >
> >> > > Rudi-san,
> >> > >
> >> > > Thanks for the suggestion.
> >> > > Hirabayashi-san gave me similar comment.
> >> > >
> >> > > Attahced is the format modified version (and omitted repetitive 
part
> >> such
> >> > > as seat/door's Row2,3,..etc.).
> >> > >
> >> > > Thanks and regards,
> >> > > Shinjiro Urata
> >> > >
> >> > >
> >> > > 2016-09-08 3:22 GMT+09:00 Streif, Rudolf <rstreif@
jaguarlandrover.
> >> com>:
> >> > >
> >> > >> Thank you, Urata-san.
> >> > >>
> >> > >> We would probably want to output the expanded fields of the 
leaf
> >> nodes in
> >> > >> the form of:
> >> > >>
> >> > >> [ Attribute ], [ Cabin ], [ Seat ], [ DriverPostiion ], ...
> >> > >> [ Attribute ], [ Cabin ], [ Seat ], [ Row1PosCount ], ...
> >> > >> [ Attribute ], [ Cabin ], [ Seat ], [ Row2PosCount ], ...
> >> > >>
> >> > >> otherwise we will have this sparsely populated spreadsheet.
> >> Furthermore,
> >> > >> with the current format the order of the lines in the file is
> >> essential
> >> > >> otherwise the hierarchy is lost. Which means the file/
spreadsheet
> >> cannot be
> >> > >> sorted.
> >> > >>
> >> > >> BTW, yes, the vehicle speed was missing which was a blunt 
oversight.
> >>  It's
> >> > >> fixed now:
> >> > >>
> >> > >> Signal.Drivetrain.Transmission.Speed
> >> > >> Signal.Cabin.Infotainment.Navigation.CurrentLocation.Speed
> >> > >>
> >> > >> Best regards,
> >> > >> Rudi
> >> > >>
> >> > >> On Wed, Sep 7, 2016 at 1:51 AM, Shinjiro Urata <
> >> > >> shinjiro.urata@access-company.com> wrote:
> >> > >>
> >> > >>> Hirabayashi-san, Rudi-san
> >> > >>>
> >> > >>> I tried conversion from vss_rel_1.json to csv with small 
script.
> >> > >>> I don't know if this converted file fits to the needs.
> >> > >>> Please have a look at attached file.
> >> > >>>
> >> > >>> >Hirabayashi-san
> >> > >>> Since I omitted all other information except data point name,
> >> > >>>  this may not very goot for cross check with older Vehicle 
Data
> >> Spec.
> >> > >>> In that case, by modifiying the script, it is possible to
> >> > >>>  add more information such as datatype, min/max, etc.
> >> > >>>
> >> > >>> Kind regards,
> >> > >>> Shinjiro Urata
> >> > >>>
> >> > >>>
> >> > >>>
> >> > >>> 2016-09-07 10:30 GMT+09:00 <ta-hirabayashi@kddi-ri.jp>:
> >> > >>>
> >> > >>>> Rudi,
> >> > >>>>
> >> > >>>> Thanks, I got it in Paris f2f meeting.
> >> > >>>>
> >> > >>>> We need list of all vehicle signals/data as soon as possible 
to
> >> make
> >> > >>>> sure
> >> > >>>> overs and shorts comparing with the previous vehicle data 
specs.
> >> > >>>>
> >> > >>>> Vocabulary (data naming) list would be helpful in excel or 
csv
> >> format.
> >> > >>>>
> >> > >>>> Thank you in advance for your help.
> >> > >>>>
> >> > >>>> T.Hirabayashi
> >> > >>>>
> >> > >>>>
> >> > >>>> ----- Original Message -----
> >> > >>>> > --
> >> > >>>> > *Rudolf J Streif*
> >> > >>>> > System Architect - Open Source Initiative
> >> > >>>> > Open Source Technology Centre
> >> > >>>> >
> >> > >>>> > *M:* +1.619.631.5383
> >> > >>>> > *Email:*  rstreif@jaguarlandrover.com
> >> > >>>> >
> >> > >>>> >
> >> > >>>> >
> >> > >>>> > UK: G/26/2 G02 Building 523, Engineering Centre, Gaydon,
> >> Warwick, CV35
> >> > >>>> ORR
> >> > >>>> > US: 1419 NW 14th Ave, Portland, OR 97209
> >> > >>>> > jaguar.com | landrover.com
> >> > >>>> > -------------------
> >> > >>>> > Business Details:
> >> > >>>> > Jaguar Land Rover Limited
> >> > >>>> > Registered Office: Abbey Road, Whitley, Coventry CV3 4LF
> >> > >>>> > Registered in England No: 1672070
> >> > >>>> >
> >> > >>>> > This e-mail and any attachments contain confidential
> >> information for a
> >> > >>>> > specific individual and purpose.  The information is 
private
> >> and
> >> > >>>> privileged
> >> > >>>> > and intended solely for the use of the individual to whom 
it is
> >> > >>>> addressed.
> >> > >>>> > If you are not the intended recipient, please e-mail us
> >> immediately.
> >> > >>>> We
> >> > >>>> > apologise for any inconvenience caused but you are hereby
> >> notified
> >> > >>>> that any
> >> > >>>> > disclosure, copying or distribution or the taking of any 
action
> >> in
> >> > >>>> reliance
> >> > >>>> > on the information contained herein is strictly prohibited.
> >> > >>>> >
> >> > >>>> > This e-mail does not constitute an order for goods or 
services
> >> unless
> >> > >>>> > accompanied by an official purchase order.
> >> > >>>> >
> >> > >>>> 〜〜〜〜〜〜〜〜〜〜〜〜〜〜〜〜〜〜
> >> > >>>> ＫＤＤＩ総研
> >> > >>>>
> >> > >>>> 平林 立彦
> >> > >>>> HIRABAYASHI Tatsuhiko
> >> > >>>> Tel: 03-6678-1946(代表)
> >> > >>>> Mobile: 080-5941-4506
> >> > >>>> Fax: 03-6678-0339
> >> > >>>> E-mail: ta-hirabayashi@kddi.com
> >> > >>>> Address: 〒102‐8460
> >> > >>>> 東京都千代田区飯田橋3-10-10
> >> > >>>> ガーデンエアタワー33階
> >> > >>>> 〜〜〜〜〜〜〜〜〜〜〜〜〜〜〜〜〜〜
> >> > >>>>
> >> > >>>>
> >> > >>>>
> >> > >>>>
> >> > >>>
> >> > >>> .
> >> > >>
> >> > >>
> >> > >>
> >> > >>
> >> > >> --
> >> > >> *Rudolf J Streif*
> >> > >> System Architect - Open Source Initiative
> >> > >> Open Source Technology Centre
> >> > >>
> >> > >> *M:* +1.619.631.5383
> >> > >> *Email:*  rstreif@jaguarlandrover.com
> >> > >>
> >> > >>
> >> > >>
> >> > >> UK: G/26/2 G02 Building 523, Engineering Centre, Gaydon, 
Warwick,
> >> CV35 ORR
> >> > >> US: 1419 NW 14th Ave, Portland, OR 97209
> >> > >> jaguar.com | landrover.com
> >> > >> -------------------
> >> > >> Business Details:
> >> > >> Jaguar Land Rover Limited
> >> > >> Registered Office: Abbey Road, Whitley, Coventry CV3 4LF
> >> > >> Registered in England No: 1672070
> >> > >>
> >> > >> This e-mail and any attachments contain confidential 
information
> >> for a
> >> > >> specific individual and purpose.  The information is private 
and
> >> privileged
> >> > >> and intended solely for the use of the individual to whom it 
is
> >> addressed.
> >> > >> If you are not the intended recipient, please e-mail us 
immediately.
> >>   We
> >> > >> apologise for any inconvenience caused but you are hereby 
notified
> >> that any
> >> > >> disclosure, copying or distribution or the taking of any 
action in
> >> reliance
> >> > >> on the information contained herein is strictly prohibited.
> >> > >>
> >> > >> This e-mail does not constitute an order for goods or services
> >> unless
> >> > >> accompanied by an official purchase order.
> >> > >>
> >> > >>
> >> > >
> >> > > .
> >> >
> >> >
> >> >
> >> >
> >> > --
> >> > *Rudolf J Streif*
> >> > System Architect - Open Source Initiative
> >> > Open Source Technology Centre
> >> >
> >> > *M:* +1.619.631.5383
> >> > *Email:*  rstreif@jaguarlandrover.com
> >> >
> >> >
> >> >
> >> > UK: G/26/2 G02 Building 523, Engineering Centre, Gaydon, Warwick, 
CV35
> >> ORR
> >> > US: 1419 NW 14th Ave, Portland, OR 97209
> >> > jaguar.com | landrover.com
> >> > -------------------
> >> > Business Details:
> >> > Jaguar Land Rover Limited
> >> > Registered Office: Abbey Road, Whitley, Coventry CV3 4LF
> >> > Registered in England No: 1672070
> >> >
> >> > This e-mail and any attachments contain confidential information 
for a
> >> > specific individual and purpose.  The information is private and
> >> privileged
> >> > and intended solely for the use of the individual to whom it is
> >> addressed.
> >> > If you are not the intended recipient, please e-mail us 
immediately.
> >> We
> >> > apologise for any inconvenience caused but you are hereby 
notified
> >> that any
> >> > disclosure, copying or distribution or the taking of any action 
in
> >> reliance
> >> > on the information contained herein is strictly prohibited.
> >> >
> >> > This e-mail does not constitute an order for goods or services 
unless
> >> > accompanied by an official purchase order.
> >> >
> >> 〜〜〜〜〜〜〜〜〜〜〜〜〜〜〜〜〜〜
> >> ＫＤＤＩ総研
> >>
> >> 平林 立彦
> >> HIRABAYASHI Tatsuhiko
> >> Tel: 03-6678-1946(代表)
> >> Mobile: 080-5941-4506
> >> Fax: 03-6678-0339
> >> E-mail: ta-hirabayashi@kddi.com
> >> Address: 〒102‐8460
> >> 東京都千代田区飯田橋3-10-10
> >> ガーデンエアタワー33階
> >> 〜〜〜〜〜〜〜〜〜〜〜〜〜〜〜〜〜〜
> >>
> >
> >
> > .
> 
> 
> 
> 
> -- 
> *Rudolf J Streif*
> System Architect - Open Source Initiative
> Open Source Technology Centre
> 
> *M:* +1.619.631.5383
> *Email:*  rstreif@jaguarlandrover.com
> 
> 
> 
> UK: G/26/2 G02 Building 523, Engineering Centre, Gaydon, Warwick, CV35 
ORR
> US: 1419 NW 14th Ave, Portland, OR 97209
> jaguar.com | landrover.com
> -------------------
> Business Details:
> Jaguar Land Rover Limited
> Registered Office: Abbey Road, Whitley, Coventry CV3 4LF
> Registered in England No: 1672070
> 
> This e-mail and any attachments contain confidential information for a
> specific individual and purpose.  The information is private and 
privileged
> and intended solely for the use of the individual to whom it is 
addressed.
> If you are not the intended recipient, please e-mail us immediately.  
We
> apologise for any inconvenience caused but you are hereby notified 
that any
> disclosure, copying or distribution or the taking of any action in 
reliance
> on the information contained herein is strictly prohibited.
> 
> This e-mail does not constitute an order for goods or services unless
> accompanied by an official purchase order.
> 
　　　　　　　　　　〜〜〜〜〜〜〜〜〜〜〜〜〜〜〜〜〜〜
　　　　　　　　　　ＫＤＤＩ総研

　　　　　　　　　　平林　立彦
　　　　　　　　　　HIRABAYASHI Tatsuhiko
　　　　　　　　　　Tel: 03-6678-1946(代表)
　　　　　　　　　　Mobile: 080-5941-4506
　　　　　　　　　　Fax: 03-6678-0339
　　　　　　　　　　E-mail: ta-hirabayashi@kddi.com
　　　　　　　　　　Address: 〒102‐8460
　　　　　　　　　　東京都千代田区飯田橋3-10-10
　　　　　　　　　　ガーデンエアタワー33階
　　　　　　　　　　〜〜〜〜〜〜〜〜〜〜〜〜〜〜〜〜〜〜