Searching in D-Portal by Policy Marker


(Aria Grabowski) #1

So I recently discovered that the standard includes the OECD policy markers. The one of interest for me is the gender marker, but I am sure other users or potential users are interested in other markers. To my amazement/joy the standard not only includes the policy marker but also if it is principal or significant. I couldn’t figure out any way to search d-portal for the policy markers though, and then I wondered if any publish actually publishes the information, or its just code that is there because it should be used. So I searched Canada’s xml and found 895 mentions of the gender policy marker (@YohannaLoucheur congrats), but outside of that I have no idea how to access that information. I think finding projects by their gender policy marker could be a massively helpful tool for users (myself included), so I have two questions:

  1. Is there a way to search activities by policy markers currently besides via the xml?
  2. What would it take to make them easily searchable in D-portal?
    @AkermanMartin @AVaughn @stevieflow @JohnAdams @Melinda @bill_anderson

Happy to walk through use cases or why I think this information is super important to have.


(Melinda Cuzner) #2

I agree, it would be useful for many to search on policy markers. We have started to publish them on our national portal https://openaid.se/aid/2017/ but we haven’t added the possibility to search by PM. And it is only possible to extract an Excel with the PM’s for the climate data.

Have you looked into SAVi at all? I reckon most of the publishers that publish to DAC publish their PM’s here as well since they already have the data available.


(Andy Lulham) #3

The IATI Datastore is filterable by policy marker, but there some issues:

  • the policy marker filter doesn’t appear on the query builder, so there’s no friendly interface for it
  • policy marker doesn’t appear in the output CSV (@stevieflow has raised that one)
  • you can’t specify the policy marker @vocabulary
  • you can’t specify the policy marker @significance (e.g. to ignore PolicySignificance code 0)

Anyway, by way of example, here are 50 of Canada’s activities that include policy marker 1 (“Gender Equality”):

http://datastore.iatistandard.org/api/1/access/activity.xml?policy-marker=1&reporting-org=CA-3

^^ According to this, the number of CA-3 activities with the gender equality policy marker is closer to 2,315.


(Yohanna Loucheur) #4

That seems low to me, actually. :slight_smile: Gender Equality has been an important topic for Canada even before our recently-published Feminist International Assistance Policy, so I would expect all our projects to have the GE policy marker (if only to indicate that a given project does not have GE as a principal or significant dimension). I seem to recall there were changes in the GE policy marker at some point, so perhaps we cannot publish them for older projects.

I wish I could point you to our Project Browser http://w05.international.gc.ca/projectbrowser-banqueprojets/filter-filtre to play with data with the GE marker, but unfortunately our Browser does not yet provide a policy marker filter (though they are displayed on project profiles). I would definitely echo calls to make policy markers searchable on the Datastore and D-Portal.


(Yohanna Loucheur) #5

Aria, the easiest way to find the answer to this may be to check the Dashboard [http://dashboard.iatistandard.org/element/iati-activity_policy-marker.html ] The data is not searchable, but it would help you identify which publishers use policy markers. Or perhaps even narrow the number down to those who use the “significance”
attribute. http://dashboard.iatistandard.org/element/iati-activity_policy-marker_@significance.html


(Aria Grabowski) #6

This is awesome, and the amounts of files that are listed by a lot of the big donors, just further highlights the opportunity lost by not having a search by policy marker feature. We can only use data we can find.


(Aria Grabowski) #7

Even if it appeared on the query builder, the important connection of what did that project do would still be lost because results and the documents attached to the activity don’t show up (at least they didn’t in the past). Your power of fancy data stuff beats out my command f and the code I am searching for in the xml file. :slight_smile: I am going to be greedy and say I want easy access to those 2,315 activities so that my Oxfam Canada colleagues can go nuts with them, and I can show them to civil society in Uganda including women’s rights organizations.


(Yohanna Loucheur) #8

I am going to be greedy and say I would like 1) your input on the Datastore ToR (it’s really important to have user input!) and 2) data from your Oxfam Canada colleagues so we can get a more complete picture of activities and results on the ground, and all go nuts with them thanks to the (future) improved Datastore and D-Portal!


(shi) #9

We’ll need some development time to add it to D-portal as a filter.

In the meantime, here’s two ways to get a list of activities from Canada that report policy-marker:

CSV
JSON

Looks like there are 2935 activities found in d-portal using policy-marker.


(Yohanna Loucheur) #10

I find quite fascinating that we all get a slightly different answer to the question “how many GAC activities use policy markers” (2,935 in yours, 2,931 on the Dashboard; Andy said 2,315, but that was specific to the GE marker, which may explain the difference).

The answers are close to each other, but you’d think they would be identical since it’s about the same dataset. Thought I’d flag as it may matter in creating the D-portal filter.


(Aria Grabowski) #11

I have never heard of SAVi and google wasn’t super helpful in teaching me about it. Are your IATI files linked to the Swedish open aid portal so the policy markers will also appear in IATI?


(Kate) #12

Hi @ariag,

If you raise an issue for this in Github: https://github.com/devinit/D-Portal/issues then Kris and Shi can take a look at it for you.

I spoke with them today and it is only a couple of days of work so they should be able to do it for you.

K


(shi) #13

Thanks, @YohannaLoucheur - it is quite common for the full IATI dataset to differ simply depending on what time the data is fetched into respective databases.

For instance, the current database in d-portal informs me that all WHO activities have been missing since the end of January.


XML Errors all the way down

Other databases may have cached versions from before that so their numbers will be different from other databases that are trying to get the most up-to-date data from the WHO.


(Andy Lulham) #14

Straying off-topic, but… All the content appears to have moved from e.g.:
http://open.who.int/api/iatiFiles/iati-file-content/DZA

…to:
http://open.who.int/api/iatiFiles/iati-file-content/2016-17/DZA

I’ve emailed the WHO contact address and IATI secretariat support about this.

But yeah – I agree that this sort of thing could account for numeric differences. Honestly, so many bits of IATI tech are either undergoing major overhauls or are otherwise in limbo (rather than being incrementally maintained) that it’s difficult to think about addressing this.


(Melinda Cuzner) #15

Hi, sorry for the late reply. Well, the SAVi i read about on the d-portal about page (http://www.d-portal.org/about.html). I have never looked into it myself so I will be of no help to you there, sorry!

And yes, our Openaid.se is actually built on or IATI files, and the policy markers have been published for quite some time according to the standard. I hope you find what you are looking for.