-
Notifications
You must be signed in to change notification settings - Fork 1
PAME Evaluation Notes
A Protected Areas Management Effectiveness (PAME) evaluation is "the assessment of how well protected areas are being managed – primarily the extent to which management is protecting values and achieving goals and objectives".
PAMEEvaluations:
- optionally belong_to ProtectedAreas
- has_and_belongs_to_many Countries
Notes:
- A PAMEEvaluation could just apply to one country, not necessarily all of those for the ProtectedArea to which it belongs
- The countries for a PAMEEvaluation may not be the same as the countries for its ProtectedArea, so we need the direct country association - e.g. if there is a national and international evaluation
ProtectedAreas:
- has_and_belongs_to_many Countries
- may have multiple PAMEEvaluations
In several locations the number of PAMEEvaluations for a given country is displayed or can be derived:
- Country page
- PAME table
- API (pame_statistic.assessments)
This shows the number of ProtectedAreas with PAMEEvaluations - note this is not the number of PAMEEvaluations for the given country as one ProtectedArea may have multiple PAMEEvaluations.
The table can be filtered by country to show a list of all PAMEEvaluations. The total count will equal the number of PAMEEvaluations listed for the given country.
This list is obtained by SQL union of country-pame-evaluation and protected-area-pame-evaluation (for all ProtectedAreas belonging to given country) joins. So in summary the table combines PEs of the PAs for given country and PEs directly of the country. The latter relationship is stored in the countries_pame_evaluations table.
Note the country shown in the table for a PE is the country of the attached PA and if it gets none via this method it defaults to looking for direct relationship between PE and country. (It doesn't combine the two). This shows as 'multiple' in the table if there are more than one, however you can still filter by iso3 for these.
TBC: I think the assessments count with the PAME statistic of the countries endpoint is derived from the country-pame-evaluation join table.
BUG: currently it does not filter out PAMEEvaluations that have a nil ProtectedArea.