Date   

Re: #rdf #issues #exiobase #rdf #issues #exiobase

 

Sorry for chiming in late here.

+1 to the idea of only using the publicly available data, it seems to
me a very unnecessary and dangerous step to start using private (and
unlicensed!) data at the beginning of our journey.

I have, after some effort, convert the hybrid IO table to a tidy
format, with proper packaging and metadata in the data package format.
The data is here:
http://files.brightwaylca.org/exiobase-3.3.17-hybrid.tar, the code is
here: https://github.com/brightway-lca/mrio_common_metadata/tree/master/mrio_common_metadata/conversion/exiobase_3_hybrid.
I would be happy to do this for the SU tables as well.

Using the tidy format, and standards packaging, would allow us to have
one importer that would work for multiple MRIO/SU databases, which
seems to me to be a big win.

Agneta, your diagrams are great, but could you explain *why* we would
want to separate out the individual country tables? Is this just to
get the raw country data before it is processed by the EXIOBASE
balancing algorithm? Separating out the country tables from the
provided data seems easy but unnecessary.

-C

On Mon, 4 Nov 2019 at 16:35, Bo Weidema <bo.weidema@...> wrote:

Dear Stefano,

Thanks for your reflections. In the long run, BONSAI should of course not rely on Exiobase or any other processed data, but on as a "raw" data source as possible. For IO tables, this means national Supply Use data, obtained directly from the national statistical agencies etc. Back-calulating these from Exiobase would in all cases just be a temporary solution to get a good start with a relatively complete database.

Best regards

Bo

Den 2019-11-04 kl. 11.16 skrev Stefano Merciai:

Hi all,

I can provide the Exiobase hybrid version of national tables but I wonder whether this is the way to go. I try to explain it better.

Exiobase is a multi-regional IO database, therefore on the website you can only download MR-tables. Of course who contributes to Exiobase has as intermediate result the national tables stored somewhere but not on the official Exiobase website. But then, does Bonsai rely on publicly available data or on 'confidential' data? In the light of future updates, what is the best way to go?

And what if we intend to use other world IO databases such as the WIOD? We will have the same problem.

However, moving from MR-tables to a national table is a quite simple procedure because we just need to aggregate rows and columns. This procedure could be easily generalized for future imports of multi-regional databases. The only issue I see here is that Exiobase will be stored twice on the Bonsai storage.

Best,

Stefano




On 01/11/2019 15:45, Bo Weidema wrote:

I am aware that we have priority access as consortium members. I was hinting to making this publicly available...

Bo

Den 2019-11-01 kl. 15.28 skrev Konstantin Stadler:

Hi Bo/2.0 LCA Team

You (trough Stefano) have access to the repository having the country SUT tables. I can add more people to the box account if needed.

Best
Konstantin

On 30/10/2019 17:35, Bo Weidema wrote:

Den 2019-10-30 kl. 16.07 skrev Agneta:

Do we need to have a separate repo that breaks the exiobase SUT from the website ? We could also get these country specific tables directly from Stefano.

Why do the EXIOBASE consortium not just publish these on the website, saving us the hazzle of re-constructing the original data?

Bo






--


--

--
--
############################
Chris Mutel
Technology Assessment Group, LEA
Paul Scherrer Institut
OHSA D22
5232 Villigen PSI
Switzerland
http://chris.mutel.org
Telefon: +41 56 310 5787
############################


Re: Categories for Exiobase Activities and Flow Objects to enable Exploration #ontology #toolbox

Miguel Fernández Astudillo
 

True, I did the correspondence to the label not the code. Currently it looks like this:

 

https://github.com/BONSAMURAIS/rdf/blob/master/activitytype/exiobase3_3_17/exiobase3_3_17.ttl

 

brdfat:A_ALUM a bont:ActivityType

rdfs:label "Aluminium production"

 

the correspondence between the code and the label is in an excel file in native format as extracted from Exiobase official version.

 

https://github.com/BONSAMURAIS/arborist/tree/master/arborist/data

 

for the final correspondence table we’d need the uris for the nace2 division… I think there is not a defined ontology for that and we may need to create our own.

 

Miguel

 

Miguel-Astudillo-vcard

 

From: main@bonsai.groups.io <main@bonsai.groups.io> On Behalf Of Matteo Lissandrini (AAU)
Sent: 05 November 2019 16:22
To: main@bonsai.groups.io
Subject: Re: [bonsai] Categories for Exiobase Activities and Flow Objects to enable Exploration #ontology #toolbox

 

Thanks Miguel,

 

I will work on the activity one for now then.

 

In the current one I see tare only strings, isn't there a "code" for these ? Like for activities we have the Exiobase code right?

 

---
Matteo Lissandrini

Department of Computer Science
Aalborg University

http://people.cs.aau.dk/~matteo





From: main@bonsai.groups.io <main@bonsai.groups.io> on behalf of miguel.astudillo via Groups.Io <miguel.astudillo@...>
Sent: Tuesday, November 5, 2019 4:02:49 PM
To: main@bonsai.groups.io
Subject: Re: [bonsai] Categories for Exiobase Activities and Flow Objects to enable Exploration #ontology #toolbox

 

Hi Matteo

 

I think that would be the different sections of the CPC (central product classification). Classifing by “sections” is quite crude but relatively easy.

 

https://unstats.un.org/unsd/classifications/Econ/Download/In%20Text/CPCv2.1_complete(PDF)_English.pdf

 

I think (well, rather hope) there is a 1-1 correspondence with nace 2 / isic sections.

 

For example :

 

CPC section 0 : “agriculture, forestry and fishery products” corresponds to the activity “agriculture, forestry and fishing”

 

We have not done that correspondence yet.

 

Miguel

Miguel-Astudillo-vcard

 

From: main@bonsai.groups.io <main@bonsai.groups.io> On Behalf Of Matteo Lissandrini (AAU)
Sent: 05 November 2019 15:42
To: main@bonsai.groups.io
Subject: Re: [bonsai] Categories for Exiobase Activities and Flow Objects to enable Exploration #ontology #toolbox

 

Thanks Miguel, this is great.

 

I don't remember, what do we need for the FlowObject instead?

 

---
Matteo Lissandrini

Department of Computer Science
Aalborg University

http://people.cs.aau.dk/~matteo




From: main@bonsai.groups.io <main@bonsai.groups.io> on behalf of miguel.astudillo via Groups.Io <miguel.astudillo@...>
Sent: Tuesday, November 5, 2019 3:02:42 PM
To: main@bonsai.groups.io
Subject: Re: [bonsai] Categories for Exiobase Activities and Flow Objects to enable Exploration #ontology #toolbox

 

Hi

I did a correspondence between exiobase activities and nace 2 sections
(highest level of aggregation). It's in the repo now.

https://github.com/BONSAMURAIS/Correspondence-tables/blob/master/raw/exiobas
e%20act%20to%20nace2%20section.csv

best, Miguel



-----Original Message-----
From: main@bonsai.groups.io <main@bonsai.groups.io> On Behalf Of Konstantin
Stadler
Sent: 01 November 2019 15:32
To: main@bonsai.groups.io
Subject: Re: [bonsai] Categories for Exiobase Activities and Flow Objects to
enable Exploration #ontology #toolbox

Hi,

All available EXIOBASE concordances are gathered here
https://ntnu.app.box.com/s/ziox4zmkgt3cdsg549brr0qaecskgjsd/folder/478553424
20

In the folder "other_ind_prod" you will find NACE and ISIC (keep in mind
that EXIOBASE2 and 3 have the same product classification).

You can also find the link at
https://environmentalfootprints.org/exiobase3/

Best
Konstantin

On 30/10/2019 14:06, miguel.astudillo@... wrote:
> Hi
>
> This is an open issue
> https://github.com/BONSAMURAIS/Correspondence-tables/issues/10
>
> The correspondence between exiobase activities and isic "codes" does
> not exist. It is not trivial problem because some activities
> correspond to different "hierarchival levels". Some are quite broad,
> others are more specific.
>
> For this very broad classification, the easiest would be to use the
> highest level of aggregation (isic sections).
>
> Best,
>
> Miguel
>
> Miguel-Astudillo-vcard
>
> *From:*main@bonsai.groups.io <main@bonsai.groups.io> *On Behalf Of *Bo
> Weidema
> *Sent:* 30 October 2019 13:25
> *To:* main@bonsai.groups.io
> *Subject:* Re: [bonsai] Categories for Exiobase Activities and Flow
> Objects to enable Exploration #ontology #toolbox
>
> He, he, ideally they would be in our correspondence table collection...
>
> But here:
> https://sdmx.org/wp-content/uploads/CL_ACTIVITY_ISIC4_1.0.xls
>
> Bo
>
> Den 2019-10-30 kl. 12.10 skrev Matteo Lissandrini (AAU):
>
>     That would be great,
>
>     where do I find them?
>
>     ---
>     Matteo Lissandrini
>
>     Department of Computer Science
>     Aalborg University
>
>     http://people.cs.aau.dk/~matteo
>
>
>
>
>    
> ----------------------------------------------------------------------
> --
>
>     *From:* main@bonsai.groups.io <mailto:main@bonsai.groups.io>
>     <main@bonsai.groups.io> <mailto:main@bonsai.groups.io> on behalf of
>     Bo Weidema via Groups.Io <bo.weidema@...>
>     <mailto:bo.weidema@...>
>     *Sent:* Wednesday, October 30, 2019 11:50:33 AM
>     *To:* main@bonsai.groups.io <mailto:main@bonsai.groups.io>
>     *Subject:* Re: [bonsai] Categories for Exiobase Activities and Flow
>     Objects to enable Exploration #ontology #toolbox
>
>     Hi Matteo,
>
>     Would it not be smartest to use the top categories from one of the
>     classifications, such as ISIC4?
>
>     Best regards
>
>     Bo
>
>     Den 2019-10-30 kl. 11.23 skrev Matteo Lissandrini (AAU):
>
>         Sorry, now is open to anyone for comment,
>
>         let me know your email for edit acces.
>
>         Thanks,
>
>         Matteo
>
>         ---
>         Matteo Lissandrini
>
>         Department of Computer Science
>         Aalborg University
>
>         http://people.cs.aau.dk/~matteo
>
>
>
>
>        
> ----------------------------------------------------------------------
> --
>
>         *From:* main@bonsai.groups.io <mailto:main@bonsai.groups.io>
>         <main@bonsai.groups.io> <mailto:main@bonsai.groups.io> on behalf
>         of Agneta via Groups.Io <agneta.20@...>
>         <mailto:agneta.20@...>
>         *Sent:* Wednesday, October 30, 2019 10:47:09 AM
>         *To:* main@bonsai.groups.io <mailto:main@bonsai.groups.io>
>         *Subject:* Re: [bonsai] Categories for Exiobase Activities and
>         Flow Objects to enable Exploration #ontology #toolbox
>
>         Could you please provide access to the document?
>         \Agneta
>
>     --
>
> --
>
>






Re: Categories for Exiobase Activities and Flow Objects to enable Exploration #ontology #toolbox

Matteo Lissandrini (AAU)
 

Thanks Miguel,


I will work on the activity one for now then.


In the current one I see tare only strings, isn't there a "code" for these ? Like for activities we have the Exiobase code right?


---
Matteo Lissandrini

Department of Computer Science
Aalborg University

http://people.cs.aau.dk/~matteo






From: main@bonsai.groups.io <main@bonsai.groups.io> on behalf of miguel.astudillo via Groups.Io <miguel.astudillo@...>
Sent: Tuesday, November 5, 2019 4:02:49 PM
To: main@bonsai.groups.io
Subject: Re: [bonsai] Categories for Exiobase Activities and Flow Objects to enable Exploration #ontology #toolbox
 

Hi Matteo

 

I think that would be the different sections of the CPC (central product classification). Classifing by “sections” is quite crude but relatively easy.

 

https://unstats.un.org/unsd/classifications/Econ/Download/In%20Text/CPCv2.1_complete(PDF)_English.pdf

 

I think (well, rather hope) there is a 1-1 correspondence with nace 2 / isic sections.

 

For example :

 

CPC section 0 : “agriculture, forestry and fishery products” corresponds to the activity “agriculture, forestry and fishing”

 

We have not done that correspondence yet.

 

Miguel

Miguel-Astudillo-vcard

 

From: main@bonsai.groups.io <main@bonsai.groups.io> On Behalf Of Matteo Lissandrini (AAU)
Sent: 05 November 2019 15:42
To: main@bonsai.groups.io
Subject: Re: [bonsai] Categories for Exiobase Activities and Flow Objects to enable Exploration #ontology #toolbox

 

Thanks Miguel, this is great.

 

I don't remember, what do we need for the FlowObject instead?

 

---
Matteo Lissandrini

Department of Computer Science
Aalborg University

http://people.cs.aau.dk/~matteo





From: main@bonsai.groups.io <main@bonsai.groups.io> on behalf of miguel.astudillo via Groups.Io <miguel.astudillo@...>
Sent: Tuesday, November 5, 2019 3:02:42 PM
To: main@bonsai.groups.io
Subject: Re: [bonsai] Categories for Exiobase Activities and Flow Objects to enable Exploration #ontology #toolbox

 

Hi

I did a correspondence between exiobase activities and nace 2 sections
(highest level of aggregation). It's in the repo now.

https://github.com/BONSAMURAIS/Correspondence-tables/blob/master/raw/exiobas
e%20act%20to%20nace2%20section.csv

best, Miguel



-----Original Message-----
From: main@bonsai.groups.io <main@bonsai.groups.io> On Behalf Of Konstantin
Stadler
Sent: 01 November 2019 15:32
To: main@bonsai.groups.io
Subject: Re: [bonsai] Categories for Exiobase Activities and Flow Objects to
enable Exploration #ontology #toolbox

Hi,

All available EXIOBASE concordances are gathered here
https://ntnu.app.box.com/s/ziox4zmkgt3cdsg549brr0qaecskgjsd/folder/478553424
20

In the folder "other_ind_prod" you will find NACE and ISIC (keep in mind
that EXIOBASE2 and 3 have the same product classification).

You can also find the link at
https://environmentalfootprints.org/exiobase3/

Best
Konstantin

On 30/10/2019 14:06, miguel.astudillo@... wrote:
> Hi
>
> This is an open issue
> https://github.com/BONSAMURAIS/Correspondence-tables/issues/10
>
> The correspondence between exiobase activities and isic "codes" does
> not exist. It is not trivial problem because some activities
> correspond to different "hierarchival levels". Some are quite broad,
> others are more specific.
>
> For this very broad classification, the easiest would be to use the
> highest level of aggregation (isic sections).
>
> Best,
>
> Miguel
>
> Miguel-Astudillo-vcard
>
> *From:*main@bonsai.groups.io <main@bonsai.groups.io> *On Behalf Of *Bo
> Weidema
> *Sent:* 30 October 2019 13:25
> *To:* main@bonsai.groups.io
> *Subject:* Re: [bonsai] Categories for Exiobase Activities and Flow
> Objects to enable Exploration #ontology #toolbox
>
> He, he, ideally they would be in our correspondence table collection...
>
> But here:
> https://sdmx.org/wp-content/uploads/CL_ACTIVITY_ISIC4_1.0.xls
>
> Bo
>
> Den 2019-10-30 kl. 12.10 skrev Matteo Lissandrini (AAU):
>
>     That would be great,
>
>     where do I find them?
>
>     ---
>     Matteo Lissandrini
>
>     Department of Computer Science
>     Aalborg University
>
>     http://people.cs.aau.dk/~matteo
>
>
>
>
>    
> ----------------------------------------------------------------------
> --
>
>     *From:* main@bonsai.groups.io <mailto:main@bonsai.groups.io>
>     <main@bonsai.groups.io> <mailto:main@bonsai.groups.io> on behalf of
>     Bo Weidema via Groups.Io <bo.weidema@...>
>     <mailto:bo.weidema@...>
>     *Sent:* Wednesday, October 30, 2019 11:50:33 AM
>     *To:* main@bonsai.groups.io <mailto:main@bonsai.groups.io>
>     *Subject:* Re: [bonsai] Categories for Exiobase Activities and Flow
>     Objects to enable Exploration #ontology #toolbox
>
>     Hi Matteo,
>
>     Would it not be smartest to use the top categories from one of the
>     classifications, such as ISIC4?
>
>     Best regards
>
>     Bo
>
>     Den 2019-10-30 kl. 11.23 skrev Matteo Lissandrini (AAU):
>
>         Sorry, now is open to anyone for comment,
>
>         let me know your email for edit acces.
>
>         Thanks,
>
>         Matteo
>
>         ---
>         Matteo Lissandrini
>
>         Department of Computer Science
>         Aalborg University
>
>         http://people.cs.aau.dk/~matteo
>
>
>
>
>        
> ----------------------------------------------------------------------
> --
>
>         *From:* main@bonsai.groups.io <mailto:main@bonsai.groups.io>
>         <main@bonsai.groups.io> <mailto:main@bonsai.groups.io> on behalf
>         of Agneta via Groups.Io <agneta.20@...>
>         <mailto:agneta.20@...>
>         *Sent:* Wednesday, October 30, 2019 10:47:09 AM
>         *To:* main@bonsai.groups.io <mailto:main@bonsai.groups.io>
>         *Subject:* Re: [bonsai] Categories for Exiobase Activities and
>         Flow Objects to enable Exploration #ontology #toolbox
>
>         Could you please provide access to the document?
>         \Agneta
>
>     --
>
> --
>
>







Re: Categories for Exiobase Activities and Flow Objects to enable Exploration #ontology #toolbox

Miguel Fernández Astudillo
 

Hi Matteo

 

I think that would be the different sections of the CPC (central product classification). Classifing by “sections” is quite crude but relatively easy.

 

https://unstats.un.org/unsd/classifications/Econ/Download/In%20Text/CPCv2.1_complete(PDF)_English.pdf

 

I think (well, rather hope) there is a 1-1 correspondence with nace 2 / isic sections.

 

For example :

 

CPC section 0 : “agriculture, forestry and fishery products” corresponds to the activity “agriculture, forestry and fishing”

 

We have not done that correspondence yet.

 

Miguel

Miguel-Astudillo-vcard

 

From: main@bonsai.groups.io <main@bonsai.groups.io> On Behalf Of Matteo Lissandrini (AAU)
Sent: 05 November 2019 15:42
To: main@bonsai.groups.io
Subject: Re: [bonsai] Categories for Exiobase Activities and Flow Objects to enable Exploration #ontology #toolbox

 

Thanks Miguel, this is great.

 

I don't remember, what do we need for the FlowObject instead?

 

---
Matteo Lissandrini

Department of Computer Science
Aalborg University

http://people.cs.aau.dk/~matteo





From: main@bonsai.groups.io <main@bonsai.groups.io> on behalf of miguel.astudillo via Groups.Io <miguel.astudillo@...>
Sent: Tuesday, November 5, 2019 3:02:42 PM
To: main@bonsai.groups.io
Subject: Re: [bonsai] Categories for Exiobase Activities and Flow Objects to enable Exploration #ontology #toolbox

 

Hi

I did a correspondence between exiobase activities and nace 2 sections
(highest level of aggregation). It's in the repo now.

https://github.com/BONSAMURAIS/Correspondence-tables/blob/master/raw/exiobas
e%20act%20to%20nace2%20section.csv

best, Miguel



-----Original Message-----
From: main@bonsai.groups.io <main@bonsai.groups.io> On Behalf Of Konstantin
Stadler
Sent: 01 November 2019 15:32
To: main@bonsai.groups.io
Subject: Re: [bonsai] Categories for Exiobase Activities and Flow Objects to
enable Exploration #ontology #toolbox

Hi,

All available EXIOBASE concordances are gathered here
https://ntnu.app.box.com/s/ziox4zmkgt3cdsg549brr0qaecskgjsd/folder/478553424
20

In the folder "other_ind_prod" you will find NACE and ISIC (keep in mind
that EXIOBASE2 and 3 have the same product classification).

You can also find the link at
https://environmentalfootprints.org/exiobase3/

Best
Konstantin

On 30/10/2019 14:06, miguel.astudillo@... wrote:
> Hi
>
> This is an open issue
> https://github.com/BONSAMURAIS/Correspondence-tables/issues/10
>
> The correspondence between exiobase activities and isic "codes" does
> not exist. It is not trivial problem because some activities
> correspond to different "hierarchival levels". Some are quite broad,
> others are more specific.
>
> For this very broad classification, the easiest would be to use the
> highest level of aggregation (isic sections).
>
> Best,
>
> Miguel
>
> Miguel-Astudillo-vcard
>
> *From:*main@bonsai.groups.io <main@bonsai.groups.io> *On Behalf Of *Bo
> Weidema
> *Sent:* 30 October 2019 13:25
> *To:* main@bonsai.groups.io
> *Subject:* Re: [bonsai] Categories for Exiobase Activities and Flow
> Objects to enable Exploration #ontology #toolbox
>
> He, he, ideally they would be in our correspondence table collection...
>
> But here:
> https://sdmx.org/wp-content/uploads/CL_ACTIVITY_ISIC4_1.0.xls
>
> Bo
>
> Den 2019-10-30 kl. 12.10 skrev Matteo Lissandrini (AAU):
>
>     That would be great,
>
>     where do I find them?
>
>     ---
>     Matteo Lissandrini
>
>     Department of Computer Science
>     Aalborg University
>
>     http://people.cs.aau.dk/~matteo
>
>
>
>
>    
> ----------------------------------------------------------------------
> --
>
>     *From:* main@bonsai.groups.io <mailto:main@bonsai.groups.io>
>     <main@bonsai.groups.io> <mailto:main@bonsai.groups.io> on behalf of
>     Bo Weidema via Groups.Io <bo.weidema@...>
>     <mailto:bo.weidema@...>
>     *Sent:* Wednesday, October 30, 2019 11:50:33 AM
>     *To:* main@bonsai.groups.io <mailto:main@bonsai.groups.io>
>     *Subject:* Re: [bonsai] Categories for Exiobase Activities and Flow
>     Objects to enable Exploration #ontology #toolbox
>
>     Hi Matteo,
>
>     Would it not be smartest to use the top categories from one of the
>     classifications, such as ISIC4?
>
>     Best regards
>
>     Bo
>
>     Den 2019-10-30 kl. 11.23 skrev Matteo Lissandrini (AAU):
>
>         Sorry, now is open to anyone for comment,
>
>         let me know your email for edit acces.
>
>         Thanks,
>
>         Matteo
>
>         ---
>         Matteo Lissandrini
>
>         Department of Computer Science
>         Aalborg University
>
>         http://people.cs.aau.dk/~matteo
>
>
>
>
>        
> ----------------------------------------------------------------------
> --
>
>         *From:* main@bonsai.groups.io <mailto:main@bonsai.groups.io>
>         <main@bonsai.groups.io> <mailto:main@bonsai.groups.io> on behalf
>         of Agneta via Groups.Io <agneta.20@...>
>         <mailto:agneta.20@...>
>         *Sent:* Wednesday, October 30, 2019 10:47:09 AM
>         *To:* main@bonsai.groups.io <mailto:main@bonsai.groups.io>
>         *Subject:* Re: [bonsai] Categories for Exiobase Activities and
>         Flow Objects to enable Exploration #ontology #toolbox
>
>         Could you please provide access to the document?
>         \Agneta
>
>     --
>
> --
>
>







Re: Categories for Exiobase Activities and Flow Objects to enable Exploration #ontology #toolbox

Matteo Lissandrini (AAU)
 

Thanks Miguel, this is great.


I don't remember, what do we need for the FlowObject instead?


---
Matteo Lissandrini

Department of Computer Science
Aalborg University

http://people.cs.aau.dk/~matteo






From: main@bonsai.groups.io <main@bonsai.groups.io> on behalf of miguel.astudillo via Groups.Io <miguel.astudillo@...>
Sent: Tuesday, November 5, 2019 3:02:42 PM
To: main@bonsai.groups.io
Subject: Re: [bonsai] Categories for Exiobase Activities and Flow Objects to enable Exploration #ontology #toolbox
 
Hi

I did a correspondence between exiobase activities and nace 2 sections
(highest level of aggregation). It's in the repo now.

https://github.com/BONSAMURAIS/Correspondence-tables/blob/master/raw/exiobas
e%20act%20to%20nace2%20section.csv

best, Miguel



-----Original Message-----
From: main@bonsai.groups.io <main@bonsai.groups.io> On Behalf Of Konstantin
Stadler
Sent: 01 November 2019 15:32
To: main@bonsai.groups.io
Subject: Re: [bonsai] Categories for Exiobase Activities and Flow Objects to
enable Exploration #ontology #toolbox

Hi,

All available EXIOBASE concordances are gathered here
https://ntnu.app.box.com/s/ziox4zmkgt3cdsg549brr0qaecskgjsd/folder/478553424
20

In the folder "other_ind_prod" you will find NACE and ISIC (keep in mind
that EXIOBASE2 and 3 have the same product classification).

You can also find the link at
https://environmentalfootprints.org/exiobase3/

Best
Konstantin

On 30/10/2019 14:06, miguel.astudillo@... wrote:
> Hi
>
> This is an open issue
> https://github.com/BONSAMURAIS/Correspondence-tables/issues/10
>
> The correspondence between exiobase activities and isic "codes" does
> not exist. It is not trivial problem because some activities
> correspond to different "hierarchival levels". Some are quite broad,
> others are more specific.
>
> For this very broad classification, the easiest would be to use the
> highest level of aggregation (isic sections).
>
> Best,
>
> Miguel
>
> Miguel-Astudillo-vcard
>
> *From:*main@bonsai.groups.io <main@bonsai.groups.io> *On Behalf Of *Bo
> Weidema
> *Sent:* 30 October 2019 13:25
> *To:* main@bonsai.groups.io
> *Subject:* Re: [bonsai] Categories for Exiobase Activities and Flow
> Objects to enable Exploration #ontology #toolbox
>
> He, he, ideally they would be in our correspondence table collection...
>
> But here:
> https://sdmx.org/wp-content/uploads/CL_ACTIVITY_ISIC4_1.0.xls
>
> Bo
>
> Den 2019-10-30 kl. 12.10 skrev Matteo Lissandrini (AAU):
>
>     That would be great,
>
>     where do I find them?
>
>     ---
>     Matteo Lissandrini
>
>     Department of Computer Science
>     Aalborg University
>
>     http://people.cs.aau.dk/~matteo
>
>
>
>
>    
> ----------------------------------------------------------------------
> --
>
>     *From:* main@bonsai.groups.io <mailto:main@bonsai.groups.io>
>     <main@bonsai.groups.io> <mailto:main@bonsai.groups.io> on behalf of
>     Bo Weidema via Groups.Io <bo.weidema@...>
>     <mailto:bo.weidema@...>
>     *Sent:* Wednesday, October 30, 2019 11:50:33 AM
>     *To:* main@bonsai.groups.io <mailto:main@bonsai.groups.io>
>     *Subject:* Re: [bonsai] Categories for Exiobase Activities and Flow
>     Objects to enable Exploration #ontology #toolbox
>
>     Hi Matteo,
>
>     Would it not be smartest to use the top categories from one of the
>     classifications, such as ISIC4?
>
>     Best regards
>
>     Bo
>
>     Den 2019-10-30 kl. 11.23 skrev Matteo Lissandrini (AAU):
>
>         Sorry, now is open to anyone for comment,
>
>         let me know your email for edit acces.
>
>         Thanks,
>
>         Matteo
>
>         ---
>         Matteo Lissandrini
>
>         Department of Computer Science
>         Aalborg University
>
>         http://people.cs.aau.dk/~matteo
>
>
>
>
>        
> ----------------------------------------------------------------------
> --
>
>         *From:* main@bonsai.groups.io <mailto:main@bonsai.groups.io>
>         <main@bonsai.groups.io> <mailto:main@bonsai.groups.io> on behalf
>         of Agneta via Groups.Io <agneta.20@...>
>         <mailto:agneta.20@...>
>         *Sent:* Wednesday, October 30, 2019 10:47:09 AM
>         *To:* main@bonsai.groups.io <mailto:main@bonsai.groups.io>
>         *Subject:* Re: [bonsai] Categories for Exiobase Activities and
>         Flow Objects to enable Exploration #ontology #toolbox
>
>         Could you please provide access to the document?
>         \Agneta
>
>     --
>
> --
>
>








Re: Categories for Exiobase Activities and Flow Objects to enable Exploration #ontology #toolbox

Miguel Fernández Astudillo
 

Hi

I did a correspondence between exiobase activities and nace 2 sections
(highest level of aggregation). It's in the repo now.

https://github.com/BONSAMURAIS/Correspondence-tables/blob/master/raw/exiobas
e%20act%20to%20nace2%20section.csv

best, Miguel

-----Original Message-----
From: main@bonsai.groups.io <main@bonsai.groups.io> On Behalf Of Konstantin
Stadler
Sent: 01 November 2019 15:32
To: main@bonsai.groups.io
Subject: Re: [bonsai] Categories for Exiobase Activities and Flow Objects to
enable Exploration #ontology #toolbox

Hi,

All available EXIOBASE concordances are gathered here
https://ntnu.app.box.com/s/ziox4zmkgt3cdsg549brr0qaecskgjsd/folder/478553424
20

In the folder "other_ind_prod" you will find NACE and ISIC (keep in mind
that EXIOBASE2 and 3 have the same product classification).

You can also find the link at
https://environmentalfootprints.org/exiobase3/

Best
Konstantin

On 30/10/2019 14:06, miguel.astudillo@... wrote:
Hi

This is an open issue
https://github.com/BONSAMURAIS/Correspondence-tables/issues/10

The correspondence between exiobase activities and isic "codes" does
not exist. It is not trivial problem because some activities
correspond to different "hierarchival levels". Some are quite broad,
others are more specific.

For this very broad classification, the easiest would be to use the
highest level of aggregation (isic sections).

Best,

Miguel

Miguel-Astudillo-vcard

*From:*main@bonsai.groups.io <main@bonsai.groups.io> *On Behalf Of *Bo
Weidema
*Sent:* 30 October 2019 13:25
*To:* main@bonsai.groups.io
*Subject:* Re: [bonsai] Categories for Exiobase Activities and Flow
Objects to enable Exploration #ontology #toolbox

He, he, ideally they would be in our correspondence table collection...

But here:
https://sdmx.org/wp-content/uploads/CL_ACTIVITY_ISIC4_1.0.xls

Bo

Den 2019-10-30 kl. 12.10 skrev Matteo Lissandrini (AAU):

That would be great,

where do I find them?

---
Matteo Lissandrini

Department of Computer Science
Aalborg University

http://people.cs.aau.dk/~matteo





----------------------------------------------------------------------
--

*From:* main@bonsai.groups.io <mailto:main@bonsai.groups.io>
<main@bonsai.groups.io> <mailto:main@bonsai.groups.io> on behalf of
Bo Weidema via Groups.Io <bo.weidema=bonsai.uno@groups.io>
<mailto:bo.weidema=bonsai.uno@groups.io>
*Sent:* Wednesday, October 30, 2019 11:50:33 AM
*To:* main@bonsai.groups.io <mailto:main@bonsai.groups.io>
*Subject:* Re: [bonsai] Categories for Exiobase Activities and Flow
Objects to enable Exploration #ontology #toolbox

Hi Matteo,

Would it not be smartest to use the top categories from one of the
classifications, such as ISIC4?

Best regards

Bo

Den 2019-10-30 kl. 11.23 skrev Matteo Lissandrini (AAU):

Sorry, now is open to anyone for comment,

let me know your email for edit acces.

Thanks,

Matteo

---
Matteo Lissandrini

Department of Computer Science
Aalborg University

http://people.cs.aau.dk/~matteo





----------------------------------------------------------------------
--

*From:* main@bonsai.groups.io <mailto:main@bonsai.groups.io>
<main@bonsai.groups.io> <mailto:main@bonsai.groups.io> on behalf
of Agneta via Groups.Io <agneta.20=gmail.com@groups.io>
<mailto:agneta.20=gmail.com@groups.io>
*Sent:* Wednesday, October 30, 2019 10:47:09 AM
*To:* main@bonsai.groups.io <mailto:main@bonsai.groups.io>
*Subject:* Re: [bonsai] Categories for Exiobase Activities and
Flow Objects to enable Exploration #ontology #toolbox

Could you please provide access to the document?
\Agneta

--

--


Re: #rdf #issues #exiobase #rdf #issues #exiobase

Bo Weidema
 

Dear Stefano,

Thanks for your reflections. In the long run, BONSAI should of course not rely on Exiobase or any other processed data, but on as a "raw" data source as possible. For IO tables, this means national Supply Use data, obtained directly from the national statistical agencies etc. Back-calulating these from Exiobase would in all cases just be a temporary solution to get a good start with a relatively complete database.

Best regards

Bo

Den 2019-11-04 kl. 11.16 skrev Stefano Merciai:

Hi all,

I can provide the Exiobase hybrid version of national tables but I wonder whether this is the way to go. I try to explain it better.

Exiobase is a multi-regional IO database, therefore on the website you can only download MR-tables. Of course who contributes to Exiobase has as intermediate result the national tables stored somewhere but not on the official Exiobase website. But then, does Bonsai rely on publicly available data or on 'confidential' data? In the light of future updates, what is the best way to go?

And what if we intend to use other world IO databases such as the WIOD? We will have the same problem.

However, moving from MR-tables to a national table is a quite simple procedure because we just need to aggregate rows and columns. This procedure could be easily generalized for future imports of multi-regional databases. The only issue I see here is that Exiobase will be stored twice on the Bonsai storage.

Best,

Stefano




On 01/11/2019 15:45, Bo Weidema wrote:

I am aware that we have priority access as consortium members. I was hinting to making this publicly available...

Bo

Den 2019-11-01 kl. 15.28 skrev Konstantin Stadler:
Hi Bo/2.0 LCA Team

You (trough Stefano) have access to the repository having the country SUT tables. I can add more people to the box account if needed.

Best
Konstantin

On 30/10/2019 17:35, Bo Weidema wrote:
Den 2019-10-30 kl. 16.07 skrev Agneta:

Do we need to have a separate repo that breaks the exiobase SUT from the website ? We could also get these country specific tables directly from Stefano.
Why do the EXIOBASE consortium not just publish these on the website, saving us the hazzle of re-constructing the original data?

Bo






--

--
--


Re: #rdf #issues #exiobase #rdf #issues #exiobase

Stefano Merciai
 

Hi all,

I can provide the Exiobase hybrid version of national tables but I wonder whether this is the way to go. I try to explain it better.

Exiobase is a multi-regional IO database, therefore on the website you can only download MR-tables. Of course who contributes to Exiobase has as intermediate result the national tables stored somewhere but not on the official Exiobase website. But then, does Bonsai rely on publicly available data or on 'confidential' data? In the light of future updates, what is the best way to go?

And what if we intend to use other world IO databases such as the WIOD? We will have the same problem.

However, moving from MR-tables to a national table is a quite simple procedure because we just need to aggregate rows and columns. This procedure could be easily generalized for future imports of multi-regional databases. The only issue I see here is that Exiobase will be stored twice on the Bonsai storage.

Best,

Stefano




On 01/11/2019 15:45, Bo Weidema wrote:

I am aware that we have priority access as consortium members. I was hinting to making this publicly available...

Bo

Den 2019-11-01 kl. 15.28 skrev Konstantin Stadler:
Hi Bo/2.0 LCA Team

You (trough Stefano) have access to the repository having the country SUT tables. I can add more people to the box account if needed.

Best
Konstantin

On 30/10/2019 17:35, Bo Weidema wrote:
Den 2019-10-30 kl. 16.07 skrev Agneta:

Do we need to have a separate repo that breaks the exiobase SUT from the website ? We could also get these country specific tables directly from Stefano.
Why do the EXIOBASE consortium not just publish these on the website, saving us the hazzle of re-constructing the original data?

Bo






--

--


Re: #rdf #issues #exiobase #rdf #issues #exiobase

Konstantin Stadler
 

Hi Bo,

That's muddy waters. The version on exiobase.eu has a licence which applies to the data there. This is the outcome of the EU-funded project.

The data on box is without licence. We worked on that without funding and share it with colleagues bona fides - either for collaborations on research or b/c they contributed to the db. The bona fides part is that they apply the same rules before sharing the data further.

Anyway, the details here are something not in my hand - at the end the consortium (afak including 2.0 LCA) needs to decide. Perhaps have a chat with Richard/Arnold?

Best
kst



On 1 November 2019 19:09:39 CET, Bo Weidema <bo.weidema@...> wrote:

Dear Konstantin,

This is good news to me! This implies that anyone who cares can re-publish them under the same license...

Best regards

Bo

Den 2019-11-01 kl. 15.49 skrev Konstantin Stadler:
These folders are as public as the updates of EXIOBASE (for everyone who contacts us) - they are in the public folder. I know that this is not the most elegant solution (not much I can do...).


On 01/11/2019 15:45, Bo Weidema wrote:
I am aware that we have priority access as consortium members. I was hinting to making this publicly available...

Bo

Den 2019-11-01 kl. 15.28 skrev Konstantin Stadler:
Hi Bo/2.0 LCA Team

You (trough Stefano) have access to the repository having the country SUT tables. I can add more people to the box account if needed.

Best
Konstantin

On 30/10/2019 17:35, Bo Weidema wrote:
Den 2019-10-30 kl. 16.07 skrev Agneta:

Do we need to have a separate repo that breaks the exiobase SUT from the website ? We could also get these country specific tables directly from Stefano.
Why do the EXIOBASE consortium not just publish these on the website, saving us the hazzle of re-constructing the original data?

Bo






-- 




--


Re: #rdf #issues #exiobase #rdf #issues #exiobase

Bo Weidema
 

Dear Konstantin,

This is good news to me! This implies that anyone who cares can re-publish them under the same license...

Best regards

Bo

Den 2019-11-01 kl. 15.49 skrev Konstantin Stadler:

These folders are as public as the updates of EXIOBASE (for everyone who contacts us) - they are in the public folder. I know that this is not the most elegant solution (not much I can do...).


On 01/11/2019 15:45, Bo Weidema wrote:
I am aware that we have priority access as consortium members. I was hinting to making this publicly available...

Bo

Den 2019-11-01 kl. 15.28 skrev Konstantin Stadler:
Hi Bo/2.0 LCA Team

You (trough Stefano) have access to the repository having the country SUT tables. I can add more people to the box account if needed.

Best
Konstantin

On 30/10/2019 17:35, Bo Weidema wrote:
Den 2019-10-30 kl. 16.07 skrev Agneta:

Do we need to have a separate repo that breaks the exiobase SUT from the website ? We could also get these country specific tables directly from Stefano.
Why do the EXIOBASE consortium not just publish these on the website, saving us the hazzle of re-constructing the original data?

Bo






-- 




--


Re: #rdf #issues #exiobase #rdf #issues #exiobase

Konstantin Stadler
 

These folders are as public as the updates of EXIOBASE (for everyone who contacts us) - they are in the public folder. I know that this is not the most elegant solution (not much I can do...).

On 01/11/2019 15:45, Bo Weidema wrote:
I am aware that we have priority access as consortium members. I was hinting to making this publicly available...
Bo
Den 2019-11-01 kl. 15.28 skrev Konstantin Stadler:
Hi Bo/2.0 LCA Team

You (trough Stefano) have access to the repository having the country SUT tables. I can add more people to the box account if needed.

Best
Konstantin

On 30/10/2019 17:35, Bo Weidema wrote:
Den 2019-10-30 kl. 16.07 skrev Agneta:

Do we need to have a separate repo that breaks the exiobase SUT from the website ? We could also get these country specific tables directly from Stefano.
Why do the EXIOBASE consortium not just publish these on the website, saving us the hazzle of re-constructing the original data?

Bo



--


Re: #rdf #issues #exiobase #rdf #issues #exiobase

Bo Weidema
 

I am aware that we have priority access as consortium members. I was hinting to making this publicly available...

Bo

Den 2019-11-01 kl. 15.28 skrev Konstantin Stadler:

Hi Bo/2.0 LCA Team

You (trough Stefano) have access to the repository having the country SUT tables. I can add more people to the box account if needed.

Best
Konstantin

On 30/10/2019 17:35, Bo Weidema wrote:
Den 2019-10-30 kl. 16.07 skrev Agneta:

Do we need to have a separate repo that breaks the exiobase SUT from the website ? We could also get these country specific tables directly from Stefano.
Why do the EXIOBASE consortium not just publish these on the website, saving us the hazzle of re-constructing the original data?

Bo






--


Re: Categories for Exiobase Activities and Flow Objects to enable Exploration #ontology #toolbox

Konstantin Stadler
 

Hi,

All available EXIOBASE concordances are gathered here
https://ntnu.app.box.com/s/ziox4zmkgt3cdsg549brr0qaecskgjsd/folder/47855342420

In the folder "other_ind_prod" you will find NACE and ISIC (keep in mind that EXIOBASE2 and 3 have the same product classification).

You can also find the link at
https://environmentalfootprints.org/exiobase3/

Best
Konstantin

On 30/10/2019 14:06, miguel.astudillo@... wrote:
Hi
This is an open issue https://github.com/BONSAMURAIS/Correspondence-tables/issues/10
The correspondence between exiobase activities and isic “codes” does not exist. It is not trivial problem because some activities correspond to different “hierarchival levels”. Some are quite broad, others are more specific.
For this very broad classification, the easiest would be to use the highest level of aggregation (isic sections).
Best,
Miguel
Miguel-Astudillo-vcard
*From:*main@bonsai.groups.io <main@bonsai.groups.io> *On Behalf Of *Bo Weidema
*Sent:* 30 October 2019 13:25
*To:* main@bonsai.groups.io
*Subject:* Re: [bonsai] Categories for Exiobase Activities and Flow Objects to enable Exploration #ontology #toolbox
He, he, ideally they would be in our correspondence table collection...
But here: https://sdmx.org/wp-content/uploads/CL_ACTIVITY_ISIC4_1.0.xls
Bo
Den 2019-10-30 kl. 12.10 skrev Matteo Lissandrini (AAU):
That would be great,
where do I find them?
---
Matteo Lissandrini
Department of Computer Science
Aalborg University
http://people.cs.aau.dk/~matteo
------------------------------------------------------------------------
*From:* main@bonsai.groups.io <mailto:main@bonsai.groups.io>
<main@bonsai.groups.io> <mailto:main@bonsai.groups.io> on behalf of
Bo Weidema via Groups.Io <bo.weidema=bonsai.uno@groups.io>
<mailto:bo.weidema=bonsai.uno@groups.io>
*Sent:* Wednesday, October 30, 2019 11:50:33 AM
*To:* main@bonsai.groups.io <mailto:main@bonsai.groups.io>
*Subject:* Re: [bonsai] Categories for Exiobase Activities and Flow
Objects to enable Exploration #ontology #toolbox
Hi Matteo,
Would it not be smartest to use the top categories from one of the
classifications, such as ISIC4?
Best regards
Bo
Den 2019-10-30 kl. 11.23 skrev Matteo Lissandrini (AAU):
Sorry, now is open to anyone for comment,
let me know your email for edit acces.
Thanks,
Matteo
---
Matteo Lissandrini
Department of Computer Science
Aalborg University
http://people.cs.aau.dk/~matteo
------------------------------------------------------------------------
*From:* main@bonsai.groups.io <mailto:main@bonsai.groups.io>
<main@bonsai.groups.io> <mailto:main@bonsai.groups.io> on behalf
of Agneta via Groups.Io <agneta.20=gmail.com@groups.io>
<mailto:agneta.20=gmail.com@groups.io>
*Sent:* Wednesday, October 30, 2019 10:47:09 AM
*To:* main@bonsai.groups.io <mailto:main@bonsai.groups.io>
*Subject:* Re: [bonsai] Categories for Exiobase Activities and
Flow Objects to enable Exploration #ontology #toolbox
Could you please provide access to the document?
\Agneta
--
--


Re: #rdf #issues #exiobase #rdf #issues #exiobase

Konstantin Stadler
 

Hi Bo/2.0 LCA Team

You (trough Stefano) have access to the repository having the country SUT tables. I can add more people to the box account if needed.

Best
Konstantin

On 30/10/2019 17:35, Bo Weidema wrote:
Den 2019-10-30 kl. 16.07 skrev Agneta:

Do we need to have a separate repo that breaks the exiobase SUT from the website ? We could also get these country specific tables directly from Stefano.
Why do the EXIOBASE consortium not just publish these on the website, saving us the hazzle of re-constructing the original data?
Bo


Re: #rdf #issues #exiobase #rdf #issues #exiobase

Bo Weidema
 

Den 2019-10-30 kl. 16.07 skrev Agneta:

Do we need to have a separate repo that breaks the exiobase SUT from the website ? We could also get these country specific tables directly from Stefano.
Why do the EXIOBASE consortium not just publish these on the website, saving us the hazzle of re-constructing the original data?

Bo


Re: #rdf #issues #exiobase #rdf #issues #exiobase

Agneta
 

Hi everyone

Stefano and I were having a discussion on the current and prospective conversion of Exiobase to RDF. Last week we concluded that we will not include the location on flowobject in the exiobase data (look here for details) . 
With respect to this we chalked out the possible workflows.

Currently we use the exiobase SUT  obtained directly from the website, convert it to rdf, load it in the triplestore to be queried by mojo and converted to MRIO table using algoritms (for e.g. by-product technology model). The workflow is given in figure below:



What we are now suggesting is that the large exiobase MRIO tables could be broken down to individual country SUT and individual trade matrices (step 1). Each of these are to be converted into rdf triples (step 2). imported to the triplestore (step 3). Queried by MOJO (Step 4). Apply the necessary algorithms (Step 5) and import it back to the triplestore (Step 6). Please see the diagram below and check if that is correct.  

Specific questions:
  1. Do we need to have a separate repo that breaks the exiobase SUT from the website ? We could also get these country specific tables directly from Stefano. 
  2. Also at what point do we want arrange the data in tidy format instead of a matrix? 


 

If the workflow seems ok Stefano is ready to work on the MOJO repository.


Re: Categories for Exiobase Activities and Flow Objects to enable Exploration #ontology #toolbox

Bo Weidema
 

Maybe better go for the official: https://unstats.un.org/unsd/classifications/Econ/cpc

Bo

Den 2019-10-30 kl. 15.57 skrev Bo Weidema:

CPC product classification is here: http://www.statistics.gov.rw/publication/customized-central-product-classification-cpc

although I am unsure if it is a Rwandan customization?

Bo

Den 2019-10-30 kl. 15.28 skrev miguel.astudillo@...:

Hi Mateo

 

I can give it a go for the isic section, that should be straight forward. I have many nace rev 2 activities “mapped” to exiobase activity names, reverse it to get the section should be easy.

 

Products are a different kettle of fish, I have not yet worked with product classifications.

 

Best, Miguel

 

Miguel-Astudillo-vcard

 

From: main@bonsai.groups.io <main@bonsai.groups.io> On Behalf Of Konstantin Stadler
Sent: 30 October 2019 15:19
To: main@bonsai.groups.io; Matteo Lissandrini (AAU) <matteo@...>; main@bonsai.groups.io
Subject: Re: [bonsai] Categories for Exiobase Activities and Flow Objects to enable Exploration #ontology #toolbox

 

Hi.
I am currently on sick-leave but I can send you tables we used during the compilation on Friday/start next week.

Best
Konstantin

On 30 October 2019 14:39:24 CET, "Matteo Lissandrini (AAU)" <matteo@...> wrote:

Thanks Bo, Miguel,

 

do you think you can help me materialize this high-level correspondence table then?

 

Also, this is for activity or flow objects? We would need both..

 

Thanks,

Matteo

 

---
Matteo Lissandrini

Department of Computer Science
Aalborg University

http://people.cs.aau.dk/~matteo





From: main@bonsai.groups.io <main@bonsai.groups.io> on behalf of miguel.astudillo via Groups.Io <miguel.astudillo@...>
Sent: Wednesday, October 30, 2019 2:06:10 PM
To: main@bonsai.groups.io
Subject: Re: [bonsai] Categories for Exiobase Activities and Flow Objects to enable Exploration #ontology #toolbox

 

Hi

 

This is an open issue https://github.com/BONSAMURAIS/Correspondence-tables/issues/10

 

The correspondence between exiobase activities and isic “codes” does not exist. It is not trivial problem because some activities correspond to different “hierarchival levels”. Some are quite broad, others are more specific.

 

For this very broad classification, the easiest would be to use the highest level of aggregation (isic sections).

 

 

Best,

 

Miguel

 

From: main@bonsai.groups.io <main@bonsai.groups.io> On Behalf Of Bo Weidema
Sent: 30 October 2019 13:25
To: main@bonsai.groups.io
Subject: Re: [bonsai] Categories for Exiobase Activities and Flow Objects to enable Exploration #ontology #toolbox

 

He, he, ideally they would be in our correspondence table collection...

 

But here: https://sdmx.org/wp-content/uploads/CL_ACTIVITY_ISIC4_1.0.xls

 

Bo

 

Den 2019-10-30 kl. 12.10 skrev Matteo Lissandrini (AAU):

That would be great,

where do I find them?

 

---
Matteo Lissandrini

Department of Computer Science
Aalborg University

http://people.cs.aau.dk/~matteo




From: main@bonsai.groups.io <main@bonsai.groups.io> on behalf of Bo Weidema via Groups.Io <bo.weidema@...>
Sent: Wednesday, October 30, 2019 11:50:33 AM
To: main@bonsai.groups.io
Subject: Re: [bonsai] Categories for Exiobase Activities and Flow Objects to enable Exploration #ontology #toolbox

 

Hi Matteo,

 

Would it not be smartest to use the top categories from one of the classifications, such as ISIC4?

 

Best regards

 

Bo

 

Den 2019-10-30 kl. 11.23 skrev Matteo Lissandrini (AAU):

Sorry, now is open to anyone for comment,

let me know your email for edit acces.

 

Thanks,

Matteo

 

---
Matteo Lissandrini

Department of Computer Science
Aalborg University

http://people.cs.aau.dk/~matteo




From: main@bonsai.groups.io <main@bonsai.groups.io> on behalf of Agneta via Groups.Io <agneta.20@...>
Sent: Wednesday, October 30, 2019 10:47:09 AM
To: main@bonsai.groups.io
Subject: Re: [bonsai] Categories for Exiobase Activities and Flow Objects to enable Exploration #ontology #toolbox

 

Could you please provide access to the document?
\Agneta

--

--

--
--


Re: Categories for Exiobase Activities and Flow Objects to enable Exploration #ontology #toolbox

Bo Weidema
 

CPC product classification is here: http://www.statistics.gov.rw/publication/customized-central-product-classification-cpc

although I am unsure if it is a Rwandan customization?

Bo

Den 2019-10-30 kl. 15.28 skrev miguel.astudillo@...:

Hi Mateo

 

I can give it a go for the isic section, that should be straight forward. I have many nace rev 2 activities “mapped” to exiobase activity names, reverse it to get the section should be easy.

 

Products are a different kettle of fish, I have not yet worked with product classifications.

 

Best, Miguel

 

Miguel-Astudillo-vcard

 

From: main@bonsai.groups.io <main@bonsai.groups.io> On Behalf Of Konstantin Stadler
Sent: 30 October 2019 15:19
To: main@bonsai.groups.io; Matteo Lissandrini (AAU) <matteo@...>; main@bonsai.groups.io
Subject: Re: [bonsai] Categories for Exiobase Activities and Flow Objects to enable Exploration #ontology #toolbox

 

Hi.
I am currently on sick-leave but I can send you tables we used during the compilation on Friday/start next week.

Best
Konstantin

On 30 October 2019 14:39:24 CET, "Matteo Lissandrini (AAU)" <matteo@...> wrote:

Thanks Bo, Miguel,

 

do you think you can help me materialize this high-level correspondence table then?

 

Also, this is for activity or flow objects? We would need both..

 

Thanks,

Matteo

 

---
Matteo Lissandrini

Department of Computer Science
Aalborg University

http://people.cs.aau.dk/~matteo





From: main@bonsai.groups.io <main@bonsai.groups.io> on behalf of miguel.astudillo via Groups.Io <miguel.astudillo@...>
Sent: Wednesday, October 30, 2019 2:06:10 PM
To: main@bonsai.groups.io
Subject: Re: [bonsai] Categories for Exiobase Activities and Flow Objects to enable Exploration #ontology #toolbox

 

Hi

 

This is an open issue https://github.com/BONSAMURAIS/Correspondence-tables/issues/10

 

The correspondence between exiobase activities and isic “codes” does not exist. It is not trivial problem because some activities correspond to different “hierarchival levels”. Some are quite broad, others are more specific.

 

For this very broad classification, the easiest would be to use the highest level of aggregation (isic sections).

 

 

Best,

 

Miguel

 

From: main@bonsai.groups.io <main@bonsai.groups.io> On Behalf Of Bo Weidema
Sent: 30 October 2019 13:25
To: main@bonsai.groups.io
Subject: Re: [bonsai] Categories for Exiobase Activities and Flow Objects to enable Exploration #ontology #toolbox

 

He, he, ideally they would be in our correspondence table collection...

 

But here: https://sdmx.org/wp-content/uploads/CL_ACTIVITY_ISIC4_1.0.xls

 

Bo

 

Den 2019-10-30 kl. 12.10 skrev Matteo Lissandrini (AAU):

That would be great,

where do I find them?

 

---
Matteo Lissandrini

Department of Computer Science
Aalborg University

http://people.cs.aau.dk/~matteo




From: main@bonsai.groups.io <main@bonsai.groups.io> on behalf of Bo Weidema via Groups.Io <bo.weidema@...>
Sent: Wednesday, October 30, 2019 11:50:33 AM
To: main@bonsai.groups.io
Subject: Re: [bonsai] Categories for Exiobase Activities and Flow Objects to enable Exploration #ontology #toolbox

 

Hi Matteo,

 

Would it not be smartest to use the top categories from one of the classifications, such as ISIC4?

 

Best regards

 

Bo

 

Den 2019-10-30 kl. 11.23 skrev Matteo Lissandrini (AAU):

Sorry, now is open to anyone for comment,

let me know your email for edit acces.

 

Thanks,

Matteo

 

---
Matteo Lissandrini

Department of Computer Science
Aalborg University

http://people.cs.aau.dk/~matteo




From: main@bonsai.groups.io <main@bonsai.groups.io> on behalf of Agneta via Groups.Io <agneta.20@...>
Sent: Wednesday, October 30, 2019 10:47:09 AM
To: main@bonsai.groups.io
Subject: Re: [bonsai] Categories for Exiobase Activities and Flow Objects to enable Exploration #ontology #toolbox

 

Could you please provide access to the document?
\Agneta

--

--

--


Re: Categories for Exiobase Activities and Flow Objects to enable Exploration #ontology #toolbox

Matteo Lissandrini (AAU)
 

Thank Miguel!


---
Matteo Lissandrini

Department of Computer Science
Aalborg University

http://people.cs.aau.dk/~matteo






From: main@bonsai.groups.io <main@bonsai.groups.io> on behalf of miguel.astudillo via Groups.Io <miguel.astudillo@...>
Sent: Wednesday, October 30, 2019 3:28:59 PM
To: main@bonsai.groups.io
Subject: Re: [bonsai] Categories for Exiobase Activities and Flow Objects to enable Exploration #ontology #toolbox
 

Hi Mateo

 

I can give it a go for the isic section, that should be straight forward. I have many nace rev 2 activities “mapped” to exiobase activity names, reverse it to get the section should be easy.

 

Products are a different kettle of fish, I have not yet worked with product classifications.

 

Best, Miguel

 

Miguel-Astudillo-vcard

 

From: main@bonsai.groups.io <main@bonsai.groups.io> On Behalf Of Konstantin Stadler
Sent: 30 October 2019 15:19
To: main@bonsai.groups.io; Matteo Lissandrini (AAU) <matteo@...>; main@bonsai.groups.io
Subject: Re: [bonsai] Categories for Exiobase Activities and Flow Objects to enable Exploration #ontology #toolbox

 

Hi.
I am currently on sick-leave but I can send you tables we used during the compilation on Friday/start next week.

Best
Konstantin

On 30 October 2019 14:39:24 CET, "Matteo Lissandrini (AAU)" <matteo@...> wrote:

Thanks Bo, Miguel,

 

do you think you can help me materialize this high-level correspondence table then?

 

Also, this is for activity or flow objects? We would need both..

 

Thanks,

Matteo

 

---
Matteo Lissandrini

Department of Computer Science
Aalborg University

http://people.cs.aau.dk/~matteo





From: main@bonsai.groups.io <main@bonsai.groups.io> on behalf of miguel.astudillo via Groups.Io <miguel.astudillo@...>
Sent: Wednesday, October 30, 2019 2:06:10 PM
To: main@bonsai.groups.io
Subject: Re: [bonsai] Categories for Exiobase Activities and Flow Objects to enable Exploration #ontology #toolbox

 

Hi

 

This is an open issue https://github.com/BONSAMURAIS/Correspondence-tables/issues/10

 

The correspondence between exiobase activities and isic “codes” does not exist. It is not trivial problem because some activities correspond to different “hierarchival levels”. Some are quite broad, others are more specific.

 

For this very broad classification, the easiest would be to use the highest level of aggregation (isic sections).

 

 

Best,

 

Miguel

 

From: main@bonsai.groups.io <main@bonsai.groups.io> On Behalf Of Bo Weidema
Sent: 30 October 2019 13:25
To: main@bonsai.groups.io
Subject: Re: [bonsai] Categories for Exiobase Activities and Flow Objects to enable Exploration #ontology #toolbox

 

He, he, ideally they would be in our correspondence table collection...

 

But here: https://sdmx.org/wp-content/uploads/CL_ACTIVITY_ISIC4_1.0.xls

 

Bo

 

Den 2019-10-30 kl. 12.10 skrev Matteo Lissandrini (AAU):

That would be great,

where do I find them?

 

---
Matteo Lissandrini

Department of Computer Science
Aalborg University

http://people.cs.aau.dk/~matteo




From: main@bonsai.groups.io <main@bonsai.groups.io> on behalf of Bo Weidema via Groups.Io <bo.weidema@...>
Sent: Wednesday, October 30, 2019 11:50:33 AM
To: main@bonsai.groups.io
Subject: Re: [bonsai] Categories for Exiobase Activities and Flow Objects to enable Exploration #ontology #toolbox

 

Hi Matteo,

 

Would it not be smartest to use the top categories from one of the classifications, such as ISIC4?

 

Best regards

 

Bo

 

Den 2019-10-30 kl. 11.23 skrev Matteo Lissandrini (AAU):

Sorry, now is open to anyone for comment,

let me know your email for edit acces.

 

Thanks,

Matteo

 

---
Matteo Lissandrini

Department of Computer Science
Aalborg University

http://people.cs.aau.dk/~matteo




From: main@bonsai.groups.io <main@bonsai.groups.io> on behalf of Agneta via Groups.Io <agneta.20@...>
Sent: Wednesday, October 30, 2019 10:47:09 AM
To: main@bonsai.groups.io
Subject: Re: [bonsai] Categories for Exiobase Activities and Flow Objects to enable Exploration #ontology #toolbox

 

Could you please provide access to the document?
\Agneta

--

--


Re: Categories for Exiobase Activities and Flow Objects to enable Exploration #ontology #toolbox

Matteo Lissandrini (AAU)
 

Thanks Konstantin, really appreciated,

where are this tables from?


Best wishes,

Matteo

 


---
Matteo Lissandrini

Department of Computer Science
Aalborg University

http://people.cs.aau.dk/~matteo






From: Konstantin Stadler <konstantin.stadler@...>
Sent: Wednesday, October 30, 2019 3:18:46 PM
To: main@bonsai.groups.io; Matteo Lissandrini; main@bonsai.groups.io
Subject: Re: [bonsai] Categories for Exiobase Activities and Flow Objects to enable Exploration #ontology #toolbox
 
Hi.
I am currently on sick-leave but I can send you tables we used during the compilation on Friday/start next week.

Best
Konstantin

On 30 October 2019 14:39:24 CET, "Matteo Lissandrini (AAU)" <matteo@...> wrote:

Thanks Bo, Miguel,


do you think you can help me materialize this high-level correspondence table then?


Also, this is for activity or flow objects? We would need both..


Thanks,

Matteo


---
Matteo Lissandrini

Department of Computer Science
Aalborg University

http://people.cs.aau.dk/~matteo






From: main@bonsai.groups.io <main@bonsai.groups.io> on behalf of miguel.astudillo via Groups.Io <miguel.astudillo@...>
Sent: Wednesday, October 30, 2019 2:06:10 PM
To: main@bonsai.groups.io
Subject: Re: [bonsai] Categories for Exiobase Activities and Flow Objects to enable Exploration #ontology #toolbox
 

Hi

 

This is an open issue https://github.com/BONSAMURAIS/Correspondence-tables/issues/10

 

The correspondence between exiobase activities and isic “codes” does not exist. It is not trivial problem because some activities correspond to different “hierarchival levels”. Some are quite broad, others are more specific.

 

For this very broad classification, the easiest would be to use the highest level of aggregation (isic sections).

 

 

Best,

 

Miguel

 

From: main@bonsai.groups.io <main@bonsai.groups.io> On Behalf Of Bo Weidema
Sent: 30 October 2019 13:25
To: main@bonsai.groups.io
Subject: Re: [bonsai] Categories for Exiobase Activities and Flow Objects to enable Exploration #ontology #toolbox

 

He, he, ideally they would be in our correspondence table collection...

 

But here: https://sdmx.org/wp-content/uploads/CL_ACTIVITY_ISIC4_1.0.xls

 

Bo

 

Den 2019-10-30 kl. 12.10 skrev Matteo Lissandrini (AAU):

That would be great,

where do I find them?

 

---
Matteo Lissandrini

Department of Computer Science
Aalborg University

http://people.cs.aau.dk/~matteo





From: main@bonsai.groups.io <main@bonsai.groups.io> on behalf of Bo Weidema via Groups.Io <bo.weidema@...>
Sent: Wednesday, October 30, 2019 11:50:33 AM
To: main@bonsai.groups.io
Subject: Re: [bonsai] Categories for Exiobase Activities and Flow Objects to enable Exploration #ontology #toolbox

 

Hi Matteo,

 

Would it not be smartest to use the top categories from one of the classifications, such as ISIC4?

 

Best regards

 

Bo

 

Den 2019-10-30 kl. 11.23 skrev Matteo Lissandrini (AAU):

Sorry, now is open to anyone for comment,

let me know your email for edit acces.

 

Thanks,

Matteo

 

---
Matteo Lissandrini

Department of Computer Science
Aalborg University

http://people.cs.aau.dk/~matteo





From: main@bonsai.groups.io <main@bonsai.groups.io> on behalf of Agneta via Groups.Io <agneta.20@...>
Sent: Wednesday, October 30, 2019 10:47:09 AM
To: main@bonsai.groups.io
Subject: Re: [bonsai] Categories for Exiobase Activities and Flow Objects to enable Exploration #ontology #toolbox

 

Could you please provide access to the document?
\Agneta

--

--