Re: Resend: VSS/Vehicle data consideration

Thank you Hirabayashi-san!
This one is better.

Best regards,
Shinjiro Urata

2016-09-19 19:33 GMT+09:00 <ta-hirabayashi@kddi-ri.jp>:

> Urata-san
>
> Thanks!
>
> Hi, all
>
> I resend VSS exel file.
>
>
> T.Hirabayashi
>
> ----- Original Message -----
> > 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階
> > > ～～～～～～～～～～～～～～～～～～
> > >
> >
> > --
> > .
> >
> ～～～～～～～～～～～～～～～～～～
> ＫＤＤＩ総研
>
> 平林 立彦
> 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階
> ～～～～～～～～～～～～～～～～～～
>

-- 
.