Date   

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@lca-net.com 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

--

--


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

Miguel Fernández 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

Konstantin Stadler
 

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 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

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 <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

Miguel Fernández Astudillo
 

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 <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
 

It "covers" in the sense "includes" all economic ("industrial") activities, but Exiobase may in some cases be more detailed, in which case this is just an additional hierarchical level. In the same way, levels above could be added (to cover add markets and consumption activities to the industrial, thus to cover all human activities, and anotehr level even higher to cover also environmental mechanisms).


Best regards


Bo


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

Thanks Bo,


it seems this does not cover all that we have  in Exiobase though...?


---
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 1:25:23 PM
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 Bo,


it seems this does not cover all that we have  in Exiobase though...?


---
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 1:25:23 PM
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
 

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)
 

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
 

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)
 

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

Agneta
 

Could you please provide access to the document?
\Agneta


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

Matteo Lissandrini (AAU)
 

Hi all,

as mentioned already to some of you,  I'm working on a tool that helps people without SPARQL know-how to explore large RDF data (like our Bonsai triplestore)

This tool works best when the objects to explore have assigned one or more categories (e.g., Italy is an EU country, while Canada is a North America).
Having these categories will also enable me to enrich the dataset with QB[1] and QB4OLAP annotations[2].

I've prepared an initial temporary categorization of Activity Types and Flow Objects in this google spreadsheet (2 sheets).
They are likely to be very wrong.
https://docs.google.com/spreadsheets/d/1In-ACKI3ddMwpmMpSplw0JzaliPy-kku2Xbto_CzYpk/edit?usp=sharing

Could you please provide me some better alternatives?
Now you should be able to comment, but if you provide me with an email address I will add you with edit permission.

If you have any further question, please let me know.
Thanks,
Matteo

[1] https://www.w3.org/TR/vocab-data-cube/
[2] https://github.com/lorenae/qb4olap

161 - 180 of 303