Categories for Exiobase Activities and Flow Objects to enable Exploration #toolbox #ontology
|
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
|
|
|
|
Could you please provide access to the document?
\Agneta
|
|
|
|
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
|
|
|
|
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):
--
|
|
|
|
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):
--
|
|
|
|
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):
--
|
|
|
|
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):
--
|
|
|
|
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):
--
|
|
|
|
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
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):
--
|
|
|
|
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
From: main@bonsai.groups.io <main@bonsai.groups.io>
On Behalf Of 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):
--
|
|
|
|
Konstantin Stadler
Hi.
toggle quoted messageShow quoted text
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:
|
|
|
|
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
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. On 30 October 2019 14:39:24 CET, "Matteo Lissandrini (AAU)" <matteo@...> wrote:
|
|
|
|
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:
|
|
|
|
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
From: main@bonsai.groups.io <main@bonsai.groups.io>
On Behalf Of Konstantin Stadler
Hi. On 30 October 2019 14:39:24 CET, "Matteo Lissandrini (AAU)" <matteo@...> wrote:
|
|
|
|
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@...:
--
|
|
|
|
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:
--
|
|
|
|
Konstantin Stadler
Hi,
toggle quoted messageShow quoted text
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
|
|
|
|
Miguel Fernández Astudillo
Hi
toggle quoted messageShow quoted text
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@lca-net.com wrote: Hi
|
|
|
|
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 > > -- > > -- > >
|
|
|
|
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.
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
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?
--- From: main@bonsai.groups.io <main@bonsai.groups.io> on behalf of miguel.astudillo via Groups.Io <miguel.astudillo@...>
Hi
|
|
|