Include initiatives' secondary activities in the map

[joebillings]

The Map App already knows about the secondary activities, we just need to alphabetise the structure that stores them before they are displayed in the directory.

It was suggested that we also have an indication of initiatives' activities in the initiative popup. Since we're using colours, this could be a row of coloured circles that each have a tooltip to display the activity when hovered over.

[joebillings]

Update: We removed Secondary Activities and Organisational Structure from the map shortly before releasing Solidarity Oxford.

The reason for this was twofold - sorting the data was taking too long and we were getting the data in a suboptimal way.

When sse_initiative.js processes the data it expects each datapoint to contain represent a unique initiative. Including organisational structure and secondary activities in the query will generate multiple datapoints for some initiatives because the respective fields can contain multiple values.

Instead of adding UID checking to see which initiative we were dealing with, we waited until the initiative had been generated and used a new query for it to find the organisational structure and secondary activities. This was at best resource intensive and slow and at worst generated browser errors due to the number of requests made.

I propose that we adapt the existing query to include the organisational struct and secondary activities and check the UID of each datapoint before processing to see if the values need adding to an existing initiative or not.

This should be possible by checking against the object initiativesByUid.

[sunnydean]

What are Secondary Activities?
Is this just another organisational structure value?
@ColmMassey

[ColmMassey]

If you look in the data for an Oxford initiative you will often see multiple activities for the initiative's economic sector,

<essglobal:economicSector rdf:resource='https://w3id.solidarityeconomy.coop/essglobal/V2a/standard/activities-modified/AM40' />
<essglobal:economicSector rdf:resource='https://w3id.solidarityeconomy.coop/essglobal/V2a/standard/activities-modified/AM60' />

and a single

<essglobal:primarySector rdf:resource='https://w3id.solidarityeconomy.coop/essglobal/V2a/standard/activities-modified/AM20' />

We seem to no longer use the term sector in the app, and use Activities only.

[sunnydean]

We should be actually querying them in the same SPARQL query, rather than working around and processing the data in the JS scripts.

But this will definitely require us to update Virtuoso (https://stackoverflow.com/questions/42010103/group-concat-in-sparql#comment71199775_42010103)

[sunnydean]

BTW should secondary activities be indexed in the Directory? (i.e. should get initiatives with education listed as a secondary activity when you click on Education in the directory?)

[sunnydean]

@ColmMassey
added the current hack here : https://dev.oxford.solidarityeconomy.coop/
We should update virtuoso though, it will allow us to query data in a bit more versatile way

We are essentially now processing the data in the js rather than the sparql processor

[ColmMassey]

BTW should secondary activities be indexed in the Directory? (i.e. should get initiatives with education listed as a secondary activity when you click on Education in the directory?)

I think, no. Let's review when we get to look at DigitalCommons/mykomap#53

[ColmMassey]

We should update virtuoso though, it will allow us to query data in a bit more versatile way
We are essentially now processing the data in the js rather than the sparql processor

Created this Issue for later. DigitalCommons/mykomap#62

[ColmMassey]

Can you remove the applied bold treatment from the Secondary Activities?

[sunnydean]

We need to update all the queries before we can fully close the issue, currently it works for oxford and newbridge.
Could you put in a new ticket to update mini-websites with latest sea map and reference this ticket? (or am I free to do that myself?)
THX
@ColmMassey

[ColmMassey]

Could you put in a new ticket to update mini-websites with latest sea map and reference this ticket? (or am I free to do that myself?)
THX

Go for it.