Introduction
The following list of new features,tasks and resolved bugs are included in the Sprint 20.05 release:
Features
Revisit Crosstab extracts for Crop Production https://fewsnet.atlassian.net/browse/DATA-234
Prototype of automated creation of IPC Classification maps https://fewsnet.atlassian.net/browse/DATA-260
Create an IPCPhaseMapViewSet https://fewsnet.atlassian.net/browse/DATA-261
Return JSON error message for API calls https://fewsnet.atlassian.net/browse/DATA-279
Make Layer.geometry_type a ChoiceField https://fewsnet.atlassian.net/browse/DATA-280
Make is_staple_food visible through the browseable API and /en/schema-ui interfaces https://fewsnet.atlassian.net/browse/DATA-292
Enhanced Geographic Unit Map View in FDE https://fewsnet.atlassian.net/browse/DATA-293
Prototype: Interactive Map Visualization for COVID-19 website page https://fewsnet.atlassian.net/browse/DATA-303
Add a country_code filter to CountryFilter https://fewsnet.atlassian.net/browse/DATA-310
Unaccented search in FDE Geography Filter https://fewsnet.atlassian.net/browse/DATA-321
Update all DataSeries subclass Admins to show facts https://fewsnet.atlassian.net/browse/DATA-327
Add caching to /api/ipcphasemap https://fewsnet.atlassian.net/browse/DATA-331
Tasks
Investigate the completeness of the Geographic Unit Relationships at the Country level https://fewsnet.atlassian.net/browse/DATA-268
Remove Search for Crop Production Indicator and Crop Production Indicator Value https://fewsnet.atlassian.net/browse/DATA-286
Peak needs API end point https://fewsnet.atlassian.net/browse/DATA-335
Covid 19 cases/deaths API end point https://fewsnet.atlassian.net/browse/DATA-336
Remove the Search box from the Crop production tab of the FDE https://fewsnet.atlassian.net/browse/DATA-356
Bugs
Fix "[invalid name]" filter labels https://fewsnet.atlassian.net/browse/DATA-285
Dataset 981 pulling wrong/unknown CPI data https://fewsnet.atlassian.net/browse/DATA-289
FDE Spatial map view doesn't work for Kenya FSC Units 2016 https://fewsnet.atlassian.net/browse/DATA-290
Spatial view has unusual behaviour around selected Versionshttps://fewsnet.atlassian.net/browse/DATA-291
All the season records of the Crop Production data domain do not show the specific data domain i.e (Crop Production)https://fewsnet.atlassian.net/browse/DATA-297
Unable to access Geographical Unit Set Versions that contain Markets via the API https://fewsnet.atlassian.net/browse/DATA-300
500 error on /api/geographicunit/ with both unit_type and used_for parameters https://fewsnet.atlassian.net/browse/DATA-322
Placeholder text on Trade domain search bar says "report country" instead of "reporting country" https://fewsnet.atlassian.net/browse/DATA-323
Accessing the https://fdw.fews.net/dashboard/inventory/ with out a superuser right results in 403 Forbidden pagehttps://fewsnet.atlassian.net/browse/DATA-328
Incorrect FDW calculations (Forex) https://fewsnet.atlassian.net/browse/DATA-329
The UI Screen of the Trade data domain of the FDE does not show data for the Trade status / Trade type column information https://fewsnet.atlassian.net/browse/DATA-334
Unable to save Livelihood Zones when a GeographicUnitVersion is saved https://fewsnet.atlassian.net/browse/DATA-337
Features
Revisit Crosstab extracts for Crop Production
This feature is about implementing a single cross-tabbed output for the multiple output is displayed for the multiple indicators of the crop data domain i.e ( Area Planted, Quantity Produced, Yield ) per row.
Prototype of automated creation of IPC Classification maps
This feature is a prototype for creating the IPC Classification maps using the dashboard.
Create an IPCPhaseMapViewSet
This feature is about creating an /api/ipcphasemap endpoint that returns multipolygons for the dissolved Features that share the same Phase to provide access to the correctly formatted map data of the IPC Classification data domain.
Return JSON error message for API calls
Make Layer.geometry_type a ChoiceField
Make is_staple_food visible through the browseable API and /en/schema-ui interfaces
This feature is allowing the filter is_staple_food accessible through the browseable APIs’ of https://fdw.fews.net/api/marketprice/?is_staple_food , https://fdwdev.fews.net/api/marketproduct/?is_staple_food and https://fdw.fews.net/api/marketprice/?is_staple_food=0 , https://fdw.fews.net/api/marketproduct/?is_staple_food=0
Enhanced Geographic Unit Map View in FDE
This enhancement is about including the Estimated Population, Area and Estimated Population Density filelds on the tabular view of the spatial data domain and adding the Export tab that shows a download button with the refreshable links for extracting the selected units either using `format=geojson` or `format=shapefile` .
Prototype: Interactive Map Visualization for COVID-19 website page
This feature is a prototype for visualizing the covid-19 stats through interactive maps by implementing the Peak needs API end point and Covid 19 cases/deaths API end point.
Add a country_code filter to CountryFilter
This feature allows to filter list of countries either using the codes of the countries https://fdw.fews.net/api/country/?country_code=KE&country_code=TZ&country_code=UG&country_code=ET) or name of the countries https://fdw.fews.net/api/country/?country=Kenya&country=Tanzania,%20United%20Republic%20of&country=Uganda&country=Ethiopia)
Unaccented search in FDE Geography Filter
This feature is about enhancing the search capability of the FDE i.e the FDE make a search both with the accented and unaccented versions of characters.
Update all DataSeries subclass Admins to show facts
This feauture is about showing the facts period date, last period date and datapoint count on all DataSeries subclass Admins of all the data domains.
Add caching to /api/ipcphasemap
This feature is about implementing caching for the /api/ipcphasemap endpoint which returns in faster response time of the queries .
Tasks
Investigate the completeness of the Geographic Unit Relationships at the Country level
This task was about showing the current Geographic Unit Relationships at the country level which helps to assess the completeness of the Geographic Unit Relationships of the different countries.
Remove Search for Crop Production Indicator and Crop Production Indicator Value
Since the current generic search box of the Crop Production Indicator and Crop Production Indicator Value is unusably slow due to the volume of the Crop production data , this task was about removing the Search box from the(https://fdw.fews.net/en/admin/survey/cropproductionindicator/) and (https://fdw.fews.net/en/admin/survey/cropproductionindicatorvalue/)
Peak needs API end point
This task was about creating API end point that read the google sheet (https://docs.google.com/spreadsheets/d/1honKsI13RIkwB-DTJg7SqVHkqPgKjOsiljzUkJSqj2s/edit#gid=0 ) and returns the whole countries data at (https://fdw.fews.net/api/efapeakneeds/) or if a specific country_code is passed , for instance, (https://fdw.fews.net/api/efapeakneeds/?format=api&country_code=AF) then that specific country’s data will be returned as well.
Covid 19 cases/deaths API end point
This task was about adding the API end points i.e (https://api.covid19api.com/all ) which returns the whole countries data and in addition to this if a country_code parameter is passed to the query such as (https://fdw.fews.net/api/covid19/?country_code=ET ) then the data of this specific country will be returned as a result.
Remove the Search box from the Crop production tab of the FDE
Since the crop Production data can be searched using an individual filters, this task was about removing the Search bar from the FDE of the crop data domain.
Bugs
Fix "[invalid name]" filter labels
A number of Browseable API end points had an incorrect label and this was resolved .
Dataset 981 pulling wrong/unknown CPI data
The CPI data of the country Haiti had shown incorrect values and this was resolved and the dataset is pulling the correct value.
FDE Spatial map view doesn't work for Kenya FSC Units 2016
There were issue in viewing the Kenya FSC Units 2016 Spatial map and this was resolved .
Spatial view has unusual behaviour around selected Versions
There was an issue in deselecting the data series records from the list of the Available Geo unit set versions page and this was resolved and the functionality is working as expected.
All the season records of the Crop Production data domain do not show the specific data domain i.e (Crop Production)
The season records of the crop production data domain was missing the column information of the specific data domain name and this was resolved and all the season records shows the data domain types.
Unable to access Geographical Unit Set Versions that contain Markets via the API
It was the no result error message that was displayed upon trying to access the Geographic Unit Set Vesrions that contain Markets using the API , for instance , https://fdw.fews.net/api/geographicunitsetversion/365 , this was resolved . The Geographical Unit Set Versions that contain Markets can now be accessible through the API.
500 error on /api/geographicunit/ with both unit_type and used_for parameters
Tying to access an API (/api/geographicunit/) with a combination of the parameters unit_type and used_for , for example, https://fdw.fews.net/api/geographicunit/?unit_type=admin3&used_for=CropProductionIndicator , was shown a 500 Internal Server error and this was resolved and the api is now accessible.
Placeholder text on Trade domain search bar says "report country" instead of "reporting country"
The placeholder text for the Trade data domain search bar were displayed as report country and now it ir renamed to the correct saying “reporting country"
Accessing the https://fdw.fews.net/dashboard/inventory/ with out a superuser right results in 403 Forbidden page
It was the 403 Forbidden page which results in accessing the https://fdw.fews.net/dashboard/inventory/ without a superuser right and this was resolved . The Inventory Dashboard is now accessible without a superuser right access.
Incorrect FDW calculations (Forex)
There was an incorrect inverse_value calculated fileld which were shown in the data extracts and this was resolved
The UI Screen of the Trade data domain of the FDE does not show data for the Trade status / Trade type column information
The UI Screen of the Trade data domain of the FDE did not show the data for the Trade status / Trade type column information and this was resolved.
Unable to save Livelihood Zones when a Geographic Unit Version is saved
When a GeograhicUnitSetVersion was saved with Livelihood zone data in the shape file then the corresponding values of the `LivelihoodZone` did not saved and this was resolved and the list of the livelihood zones data are shown i.e (https://fdw.fews.net/en/admin/spatial/livelihoodzone/?q=kenya) after saving the Geographic unit set version of the livelihood zone shapefile data (https://fdw.fews.net/en/admin/spatial/geographicunitsetversion/1350/change/).