Introduction
Date: 12 February, 2021
The following list of new features, tasks, and resolved bugs are in the latest Sprint Version 21.01.xx release:1 release. Please contact Helpdesk@fews.net or visit the Helpdesk Portal if you need assistance navigating or utilizing the FEWS NET Data Explorer (FDE) or Data Warehouse (FDW).
Features
Enhanced access control based on Data Usage Policy https://fewsnet.atlassian.net/browse/DATA-202
Develop a prototype of vector tiles serving using ST_AsMVT https://fewsnet.atlassian.net/browse/DATA-561
Move Indicator and Geographic Unit filters to Data Series and Data Point https://fewsnet.atlassian.net/browse/DATA-579
Make Geographic Unit Mandatory https://fewsnet.atlassian.net/browse/DATA-580
Enable production of Regional IPC pngs and shapefiles https://fewsnet.atlassian.net/browse/DATA-639
Import IPC Dataseries when importing Datapoints https://fewsnet.atlassian.net/browse/DATA-699
WorldPop Demography Cache Expiry and Repopulation https://fewsnet.atlassian.net/browse/DATA-714
Add 'pcgn_proper' and `pcgn_name` to Country Search https://fewsnet.atlassian.net/browse/DATA-720
Develop Prototype for Commodity Balance Sheet Domain https://fewsnet.atlassian.net/browse/DATA-722
Make Data Series lists in Admin screens into clickable links https://fewsnet.atlassian.net/browse/DATA-733
Consistent Labeling for Price Indexes https://fewsnet.atlassian.net/browse/DATA-746
Sub National Price Indexes https://fewsnet.atlassian.net/browse/DATA-747
Tasks
Investigate performance issues on export of TradeFlowQuanity and fix Add totals to Crop Production and Inventory dashboards https://fewsnet.atlassian.net/browse/DATA-710585
Tasks
Investigate performance issues on export of IPCClassificationResource TradeFlowQuanity and fix https://fewsnet.atlassian.net/browse/DATA-711
Add totals to Crop Production and Inventory dashboards https://fewsnet.atlassian.net/browse/DATA-585
Move LandScan rasters to S3 https://fewsnet.atlassian.net/browse/DATA-719 710
Bugs
Problem with scrolling in FDE Other domain https://fewsnet.atlassian.net/browse/DATA-572
/en/schema-ui doesn't populate Country Code lists https://fewsnet.atlassian.net/browse/DATA-581
Country names not appearing in FDE when filtering exchange rate data https://fewsnet.atlassian.net/browse/DATA-584
Some of the top menus of the Home page i.e (Change password , Recent Actions i.e (list) , Help with the current page) are not shown https://fewsnet.atlassian.net/browse/DATA-647
Production Time Series for Senegal appears incomplete https://fewsnet.atlassian.net/browse/DATA-697
The data extract buttons i.e ( Download & Browse) of the calculated data series page are not working https://fewsnet.atlassian.net/browse/DATA-702
PandasShapefileRenderer doesn't support multiple Geographic Unit Types https://fewsnet.atlassian.net/browse/DATA-704
MultipleObjectsReturned('get() returned more than one UnitOfMeasureConversion -- it returned 2 https://fewsnet.atlassian.net/browse/DATA-708
country_code missing from DataCollectionSerializer and DataCollectionPeriodSerializer https://fewsnet.atlassian.net/browse/DATA-718
Filtering by border point field of the trade data domain results in Impossible to fetch error message https://fewsnet.atlassian.net/browse/DATA-729
Metadata errors uploading FEWS NET/WFP/IAPRI Southern Africa, trade https://fewsnet.atlassian.net/browse/DATA-735Division by Zero error when refreshing materialized views https://fewsnet.atlassian.net/browse/DATA-751
Features
Enhanced access control based on Data Usage Policy https://fewsnet.atlassian.net/browse/DATA-202
This feature is about enhancing enables enhanced access control by defining new data usage policies and restricting the data access by allocating to specific Users or Groups. These controls can be given down to the country level so that certain data within certain countries can be properly protected and/or accessed.
...
Develop a prototype of vector tiles serving using ST_AsMVT https://fewsnet.atlassian.net/browse/DATA-561
This feature is about developing We have developed a prototype of vector tiles using
ST_AsMVT
with anMVTTileRenderer
which can be added to viewed on spatial viewsets. When users click on a country, it will show the Admin boundaries. This capability is still undergoing changes and may not be visible to FDE users on this release; however, the functionality has been developed.
Move Indicator and Geographic Unit filters to Data Series and Data Point https://fewsnet.atlassian.net/browse/DATA-579
This enhancing enhancement is about moving
Indicator
andGeographic unit
filters toDataSeries
andDataPoint
filters, which enables a better mechanism for searching among geographic units.
Make Geographic Unit Mandatory https://fewsnet.atlassian.net/browse/DATA-580
This feature is about making
Geographic Unit
a mandatory field for the data series of all the data domains, which will make all data series searchable within the Data Explorer. Previously, there were data series without geographic units attached to them, which made them difficult to locate and pull.
Enable production of Regional IPC pngs and shapefiles https://fewsnet.atlassian.net/browse/DATA-639
This feature is about enhancing the production of Regional IPC pngs and shapefiles packageshapefile packages. Previously we had to rely on using only country_code to create maps, now we can utilize country_group to create regional maps automatically.
Import IPC Dataseries when importing Datapoints https://fewsnet.atlassian.net/browse/DATA-699
This enhancement is about making the IPC Uploads uploads a one step process, i.e importing the data points will create the data series which saves time and prevent error errors which were caused due to sometimes missing dataseries.
WorldPop Demography Cache Expiry and Repopulation https://fewsnet.atlassian.net/browse/DATA-714
This feature is about prepopulate the WorldPop cache for all shapes and reprocessing individually when a given shape is added or changed.
data series.
Add 'pcgn_proper' and `pcgn_name` to Country Search https://fewsnet.atlassian.net/browse/DATA-720
This feature is about enhancing enhances the country search by adding the parameters '
pcgn_proper
' and `pcgnpcgn_
name`name
to (the API: https://fdw.fews.net/api/country/) which allows users to search , for instance, either by"pcgn_name": "Congo, Democratic Republic",
or"pcgn_proper": "Democratic Republic Congo
.
Develop Prototype for Commodity Balance Sheet Domain https://fewsnet.atlassian.net/browse/DATA-722
This feature is about developing The development team has produced a prototype for Commodity Balance Sheet data Domain (which will be accessible via FDW here: https://fdw.fews.net/en/admin/balance/commoditybalance/).. This capability is still undergoing changes and may not be visible to FDW users on this release; however, the functionality has been developed.
...
Make Data Series lists in Admin screens into clickable links https://fewsnet.atlassian.net/browse/DATA-733
This feature is was about making the dataseries links clickable clickable in all of all the admin pages (https://fdw.fews.net/en/admin/). This allows users to easily alter the Data Series belonging to a particular Data Source Document or Classified Product.
...
Consistent Labeling for Price Indexes https://fewsnet.atlassian.net/browse/DATA-746
This feature is was about making showing consistent labeling for the Price Index both in FDW and FDE i.e , as shown below:
FDE
- External Price Index
is has been renamed to Secondary Price Index
(https://fdw.fews.net/data-explorer/#/other)
FDW
- PriceIndex
is renamed to Secondary Price Index
and Secondary Price Indices
(https://fdw.fews.net/en/admin/price/priceindex/)
...
This feature is about enabling to create a sub-national Secondary Price Index (https://fdw.fews.net/en/admin/price/priceindex/) and Calculated Price Index (https://fdw.fews.net/en/admin/price/calculatedindex/) data series.
...
Investigate performance issues on export of TradeFlowQuanity and fix https://fewsnet.atlassian.net/browse/DATA-710
This task was about improving the performance issue of the export functionality of the
TradeFlowQuanity
(https://fdw.fews.net/en/admin/trade/tradeflowquantity/export/?).
Investigate performance issues on export of IPCClassificationResource and fix https://fewsnet.atlassian.net/browse/DATA-711
This task was about improving the performance issue of the export functionality of the ipcclassification (https://fdw.fews.net/en/admin/ipc/ipcclassification/export/?).
Add totals to Crop Production and Inventory dashboards https://fewsnet.atlassian.net/browse/DATA-585
This task was about adding totals to the Crop Production dashboard (https://fdw.fews.net/dashboard/crop-production/) and the
Inventory dashboard
(https://fdw.fews.net/dashboard/inventory/).
For crop the Crop Production dashboard, when no country is selected, the parameters below are displayed: -
A total number of countries
...
with crop data
...
that exists in FDW;
...
A total number of commodities;
...
First and last period dates.
...
When a country is selected, users will now see: -
A total number of commodities in the selected country
...
;
...
First and last period dates for the selected country
...
.
...
For the data inventory dashboard
, the "Number of data points by data domain" In the Data Inventory Dashboard, totals in the Number of Data Points by Data Domain table are summarized as shown below:
...
...
Tasks
Investigate performance issues on export of TradeFlowQuanity and fix https://fewsnet.atlassian.net/browse/DATA-
...
710
This task was about moving the LandScan data to S3 which is helpful in reducing storage costs and supporting alternate sources of population & other raster dataexploring the performance issue of the export functionality of the
TradeFlowQuanity
(https://fdw.fews.net/en/admin/trade/tradeflowquantity/export/?) and determining which items should be fixed.
Bugs
Problem with scrolling in FDE Other domain https://fewsnet.atlassian.net/browse/DATA-572
The select all Select All button of the
demographic
data of the other data domain, located within the Other (flexible) domain was not showing the correct selected dataseries count, and this was resolved . The and the functionality is working as expected.
...
/en/schema-ui doesn't populate Country Code lists https://fewsnet.atlassian.net/browse/DATA-581
This task was about adding the country code list to the Using the openapi/swagger end point, the "Try it out" option was not populating the Country Code select list (http://fdw.fews.net/en/schema-ui/ end point which shows all the list of available countries which has data for that specific end point) and this was resolved.
Country names not appearing in FDE when filtering exchange rate data https://fewsnet.atlassian.net/browse/DATA-584
The country names were not shown when filtering by the
Exchange rate subtype
of the Other data domain and this was resolved.
Some of the top menus of the Home page i.e (Change password , Recent Actions i.e (list) , Help with the current page) are not shown https://fewsnet.atlassian.net/browse/DATA-647
Some When navigating the FDW Admin page, some of the top menus menu information (https://fdw.fews.net/en/admin/) under the Welcome ( i.e Change password) , Recent Actions, Help i.e (
Help with the current page
and Help) were hidden and this was resolved.
...
Production Time Series for Senegal appears incomplete https://fewsnet.atlassian.net/browse/DATA-697
There was an issue in accessing the full time series extent of the timeseries crop data in the Data Explorer for the country Senegal, and this was resolved.
...
The data extract buttons (i.e
...
Download & Browse) of the calculated data series page are not working https://fewsnet.atlassian.net/browse/DATA-702
The data extract buttons ( , Download & and Browse ) , of the calculated data series page (located here: https://fdw.fews.net/en/admin/price/priceratio/) & ( and here: https://fdw.fews.net/en/admin/price/calculatedindex/) were not working and this was resolved.
PandasShapefileRenderer doesn't support multiple Geographic Unit Types https://fewsnet.atlassian.net/browse/DATA-704
There The system was throwing an error in when using more than one
Geographic Unit Type
parameters , for instance , /api/ipcphasemap/ parameter and this was resolved & can support multiple Geographic Unit Types.
MultipleObjectsReturned('get() returned more than one UnitOfMeasureConversion -- it returned 2 https://fewsnet.atlassian.net/browse/DATA-708
It The system was throwing the following error message:
MultipleObjectsReturned('get() returned more than one UnitOfMeasureConversion -- it returned 2
, which was returned happening for having two unit of measure conversion conversions for the same unit, and this was resolved & validation . Validation has also been added onUnitOfMeasureConversion
which prevents from duplicate entries entries. The duplicates which were previously showing in PROD the Production Environment are now cleared.
...
...
Country_code missing from DataCollectionSerializer and DataCollectionPeriodSerializer https://fewsnet.atlassian.net/browse/DATA-718
The parameter
country_code
was missing from the API links: https://fdw.fews.net/api/datacollection/ and (https://fdw.fews.net/api/datacollectionperiod) and this was resolved.
Filtering by border point field of the trade data domain results in Impossible to fetch error message https://fewsnet.atlassian.net/browse/DATA-729
Trying to filter the trade data by the
border point
field results was resulting in anImpossible to fetch
error, and this was resolved and the . The functionality is working as expected.
Metadata errors uploading FEWS NET/WFP/IAPRI Southern Africa, trade https://fewsnet.atlassian.net/browse/DATA-735
There was an issue on the import screen in uploading the metadata for of
FEWS NET/WFP/IAPRI Southern Africa
, trade and this was resolved.
Division by Zero error when refreshing materialized views https://fewsnet.atlassian.net/browse/DATA-751
There was an error division by zero both in refreshing materialized views of
MarketPriceFacts
andDataPointFacts
& that was causing unexpected results in FDW and this was resolved.