The metadata management module allows users with appropriate permissions to add new baseline data, or view, modify, and delete existing baseline data within the system. In addition, users can search and filter baseline data or export and download baseline data in various formats including CSV, XLS, XLSX, TSV, ODS, JSON, YAML and HTML.
Module organization
Within the Metadata management module, metadata is organized across the following pages:
Audited: An administrative system to view and track user actions and for the purposes of auditing user actions within the system.
Auth Token: Management of tokens assigned to allow sign in to FDW without a username and password. This is especially useful for connecting to refreshable Excel workbooks, particularly for older Excel versions.
Common: A metadata grouping that applies to all domains across the database. This high-level menu contains the commands that enable users to add, edit, delete, or bulk import the baseline records that are commonly used by all data domains in the database.
IPC: Management of the various scenarios for the Integrated Food Security Phase Classification system (IPC).
News Articles: Management of the list of news sources from which the system automatically saves and translates news articles.
Notifications: Management of the list of subscriptions for automated email notifications about changes in specified system data.
Publications: Contains metadata for scientific publications that have been produced by FEWS NET funded projects.
Response: Management of the list of Operators that provide humanitarian assistance (Responses) in various parts of the world.
Spatial: Allows the management of the baseline data that pertain to, or have geographic components. This includes the management of various levels of administrative boundaries, market locations, seasons, etc.
Survey: The management of baseline data pertaining to Surveys, including data source documents for surveys, and the list of Localities along with their dominant livelihood zone and population group.
Warehouse: Provides the management of the core baseline records that are essential for the proper functioning of the Data warehouse system. These include the data usage policies, document types, indicator types, indicators, license types, source organizations, data source documents, and web services.
Audited metadata
Audited > Logged actions
Allows users with administrative privileges to view the database transaction audits along with the actions that have been performed by users against various database objects (tables). This information is categorized on a monthly basis with an individual tab for each month, and includes the following fields:
Table name
Row Identifier
Action (against the table)
Username
Timestamp - user action date and time
Controller
Action (performed by the user, eg. login)
A free-text search box allows users to search for specific records from the log records in the database.
The filter option allows users to filter the data by one or more of the following:
Table name
Action
Username
Auth Token
Auth Token > Tokens
Provides administrators with the ability to add, edit, and delete a token providing access to FDW for a given user.
Common metadata
Common > Narrative metadata
Enables users to add, edit and delete metadata in the form of narrative text. This type of metadata is stored for use in reports such as the Price Bulletin and Acute Food Insecurity Classification visualizations.
For example, when adding narrative metadata for a country or region’s Price Bulletin Report, select common | country for the Content Type and Price Bulletin Report for Narrative Metadata Type.
Narrative metadata fields include:
Start: Enter the first date this metadata is relevant.
End: If the text for a report is being revised, enter the end date on the current narrative metadata and create a new narrative metadata for the revision. This allows for preservation of previous versions.
Content type: Common | country should be used for country reports. Common | country group should be used for regional reports.
Object ID: Enter the code of the country or country group.
Narrative metadata type: Choose the type of narrative metadata.
Text fields: The Text field supports rich text and has a toolbar with formatting options. Users can view and edit HTML by clicking the Source button. The Text field should be used for English narrative. The other text fields should be used for their corresponding translations.
Common > Narrative metadata type
Provides administrators with the ability to add, edit, and delete the narrative metadata types that are available in the drop-down list when adding and editing narrative metadata.
Common > Classified products
Shows a hierarchical view of the individual product data that have been entered into the system. It displays the more than 5,600 classified products that are currently available in the system along with their corresponding higher level categories that contain one or more products within them. To view a description, various naming conventions and aliases for each individual classified product within the database, simply select it from the column labeled CPC V2.
The classified products page allows users to perform the following actions:
Add a new product
Edit the attributes of an existing product
Delete one or more products from the list of available products
Export one or more products data into the following standard file formats: .XLS, XLSX, .TSV, .ODS, .JSON, .YAML, and .HTML
Note: Standard free-text search functionality is also available from this page.
Common > Countries
Displays the current list of countries available in the system and allows users to:
Add a new country
Edit an existing country information/attributes
Delete one or more country records
Import country records from a file in various formats, including .XLS, .CSV, .TSV, .JSON, and YAML
Search country data using free-text search
Filter by country group
Common > Country groups
Create country groups that are used to categorize countries based on their geographic locations or non-geographic attributes. Geographically based country groups are continents, sub-continental regions and non-geographic country regions that can be based on the level of economic development or on whether the country is landlocked or not.
The country groups function in the system allows system administrators to create country groups to which one or more countries can later be added. Country groups can be nested inside one another to form a hierarchy. For example, the country group East Africa is contained within the group Africa, which in turn is contained within the top level group World.
The grouping of countries into such hierarchical levels is used within the Geographic filters to simplify the process of selecting multiple countries at once by users within the FEWS NET Data Explorer application.
From the country groups page, administrators can perform the following actions:
Add a new country group.
Edit an existing country group record.
Delete one or more existing group records.
Export all the country group records in the database.
Search and display the list of matching country group records using the open-text search functionality.
Common > Currencies
Provides the basic functionality used by administrators to add/introduce a new currency, modify, or delete existing currency records in the system.
Common > Unit of measure conversions
Enable administrators to set the equivalency between the various units of measures of the same category, so that one unit can be converted into the other using the conversion factor set by the administrator. This allows system users to select a common unit of measure so that the results containing data from various sources, that use different units of measures, can be shown by the unit of measure the user specified.
From this page, a user with administrative permissions can:
Add a record with a conversion factor between two units of measurements
Edit or delete an existing conversion factor data
Import a list of unit of measures conversions from a file
Search existing units of measures conversion factors by a free text style search
Filter the conversion factor records by the unit type such as Weight, Volume, or by source and destination units measures.
Common > Units of measure
Manage all standard and non-standard units of measures used in the system to record all the detailed data available for all domains. Administrators can specify a quantity for various items tracked in the system and the list includes units of measures for weights, volumes, packaging of items, area, and more.
From this page, a user with administrative permissions can:
Add a new unit of measure
Edit or delete an existing unit of measure record
Import a list of unit of measures from a file
Search existing units of measures by a free text style search
Filter the records by the unit type such as Weight or Volume, etc.
IPC
IPC > Scenarios
Enter new data, edit existing data, or delete existing IPC scenarios that are applicable either for Acute Food Insecurity Classification, Acutely Food Insecure Population Estimates or Humanitarian Food Assistance domains. The domain to which the scenario applies is specified in the Purpose column when adding a new scenario.
The possible actions that can be performed from this page are:
Add a new scenario.
Edit an existing scenario.
Delete an existing scenario.
Search scenarios using a free text search.
Filter scenarios by the purpose they are used (IPC or FIPE domain).
News articles
News articles > Sources
Add, edit, and delete news sources from which the system automatically saves and translates news articles.
The possible actions that can be performed from this page are:
Add a new news source by selecting the Add source button.
Edit an existing news source by selecting the name of the news source.
Delete an existing news source. To delete multiple sources at once, select the sources then select Action > Delete selected sources.
Search news sources using a free text search.
Add/Edit a News Source
When adding or editing a news source, the following fields are available:
Name: name of the news source.
URL: URL of the news source.
Translated: when this box is selected, the system will automatically produce an English translation of the article text and an English summary for the article. This box should be checked if the news source does not publish all articles in English.
Active: this box indicates if the news source is actively being combed for new articles. If this box is not checked, the system will not check the source.
Country: the country of origin for the news source. Leave blank for multi-country or international news sources.
Tags: comma separated tags to associate with the news source.
Notification
Notification > Subscriptions
Add, edit, and delete subscriptions for automated email notifications about changes in specified system data.
The possible actions that can be performed from this page are:
Add a new email subscription.
Edit an existing email subscription.
Delete an existing email subscription.
Search the list of email subscriptions using a free text search.
Publications
Publications > Authors
Manage the list of authors for scientific publications that have been produced by FEWS NET-funded projects.
Publications > Journal articles
Manage the list of journal articles produced by FEWS NET-funded projects.
The possible actions that can be performed from this page are:
Add a new journal article.
Edit an existing journal article.
Delete an existing journal article.
Search operators using a free text search.
Filter by journal, author, and publication date.
Publications > Journals
Manage the list of journals where articles produced by FEWS NET-funded projects are published.
The possible actions that can be performed from this page are:
Add a new journal.
Edit an existing journal.
Delete an existing journal.
Filter by subject focus, publication frequency, and whether the journal is public.
Response
Response > Operators
Manage the list of FEWS-monitored organizations/operators that provide humanitarian assistance.
The possible actions that can be performed from this page are:
Add a new operator.
Edit an existing operator.
Delete an existing operator.
Search operators using a free text search.
Spatial
Spatial > Administrative units
Manage the multi-level administrative units existing in a specific country. From this page, administrators can perform the following actions:
Add a new administrative unit in a country under a specified Layer.
Edit one of more existing administrative units.
Delete one of more existing administrative units.
Import administrative units from a file containing administrative unit data.
Export the current list of administrative units into a file.
Search the current list of administrative units by using a free text search criteria.
Filter by unit type (unit level) and country
View a map of selected administrative units.
Spatial > Features
Manage Geographic features within a Layer. A feature is defined as a single entry among several records available within a Layer of a Geographic unit. For example, among a Water Bodies Layer, a single Feature can be a record for the Nile river. Features are hosted within a Layer, and Geographic Units can contain one or more Layers.
Using this page, administrators can perform the following actions:
Add a new feature record.
Import features from a file.
Export features into a file.
Search features using the free text search feature.
Filter by unit type and country.
View list of features by applying.
Spatial > Geographic unit relationship types
Manage Geographic unit relationship types, including the relationships that define hierarchy or direction of aggregation.
For example, Admin 2 is contained within Admin 1 and Admin 0, or an Admin 1 geographic unit can be aggregated into Admin 0.
This page allows administrators to perform the following tasks on Geographic Unit relationship types:
Add a new Geographic unit relationship type.
Edit existing Geographic unit relationship types.
Delete existing Geographic unit relationship types.
Search existing Geographic unit relationship types using a free-text search criteria
Spatial > Geographic unit relationships
Manage the relationship between Geographic units. For example, geographic units often experience name changes as in the case of Horo Guduru, Ethiopia updating its name to Horo Gudru Wallega, Ethiopia. In such a case, the relationship type of the two units would be Successor.
From this page, administrators can perform the following tasks:
Add a new Geographic unit relationship.
Edit an existing Geographic unit relationship.
Delete an existing Geographic unit relationship
Import geographic unit relationships from file.
Export geographic unit relationships into a file.
Search geographic unit relationships using a free text criteria.
Filter the geographic unit relationship records by relationship type, unit type, or country.
Spatial > Geographic unit sets
Manage collections of geographic units for a specific country that have been obtained from a particular data source. For example, Ethiopia FEWS NET Admin Boundaries are a geographic unit set containing admin boundaries for Ethiopia, sourced from FEWS NET.
This page allows administrators to perform the following data management functions:
Add a new geographic unit set.
Modify an existing geographic unit set.
Delete an existing geographic unit set.
Filter and view existing geographic unit set data by country.
Spatial > Geographic unit set versions
Manage geographic unit set versions. A version of a geographic unit set used in the past, can be a different version than is used at present. As admin boundaries continue to change/evolve, new versions continuously become available. Geographic unit set versions have a start and end date to indicate their validity period. The most recent geographic unit sets have an empty end date, indicating that it is the most current.
This page enables administrators to manage geographic unit set versions in the following ways:
Add a new geographic unit set version.
Edit an existing geographic unit set version.
Delete an existing geographic unit set version.
View and manage layer details of the geographic unit set version.
Search geographic unit set version records using free text search.
Filter geographic unit set version records by country or unit type.
Spatial > Geographic unit types
Geographic unit types specify the categories for geographic units into different types such as the administrative level (Admin 0, Admin 1, …), border point, or market.
Administrators can manage the geographic unit types data by performing the following activities using this page:
Add a new geographic unit type
Edit or delete existing geographic unit type records
Search geographic unit type records using free text search
Spatial > Geographic units
Manage geographic units in the system. A geographic unit contains information about a geographic location such as a country or an admin unit along with its geographic feature that enables it to be presented on a map.
From this page, the administrator is able to:
Add a new geographic unit to the system
Edit or delete existing geographic units in the system
Import one or more geographic units into the system from file
Export the existing geographic units into a file
Search and view geographic units existing in the system using free text search
Filter and view geographic units by country or unit type
Spatial > Livelihood zones
Manage livelihood zones in the system. Livelihood zones are geographic units in a country that are characterized by a single dominant livelihood activity. Using this page, administrators are able to:
Add a new livelihood zone
Edit or delete existing livelihood data
Import one or more livelihood zones into the system from file
Export the existing livelihood zones into a file
Search and view livelihood zones existing in the system using free text search criteria
Filter and view livelihood zones by country or by zone type
Spatial > Livelihood zone types
Management of livelihood zone types in the system. Livelihood zone types list contains the values used to specify the dominant livelihood activity in a Livelihood zone. This is the page where administrators can add, edit, delete, search and display existing livelihood zone types data in the system.
Spatial > Markets
Manage the list of Markets that are available in the system along with related market attributes. The market record also contains a geographic reference that allows the market location to be shown on a map.
Using this page, administrators are able to perform the following tasks:
Add a new market in a country
Edit or delete existing market data in the system
Import market records from a file
Export market records into a file
Search and view market data in the system by using a free text search criteria
Filter and view existing market data in the system by specifying a country
Spatial > Seasonal crop activities
Management of seasonal crop activity dates (e.g., harvest start day and harvest end day) for a given season, data source document, and product. Administrators can add, edit, delete, search, and filter seasonal crop activities in the system.
Spatial > Seasons
Management of the list of seasons that exist in the system for each country. Administrators can access the standard system functions to add, edit, delete, import, export, search, and filter existing season data in the system.
Survey
Survey > Localities
Manage the list of localities data in the system by providing the standard system functions to add, edit, delete, import, export, search, and filter existing locality records in the system.
A locality is a geographic location with additional information of population group, dominant livelihood zone, and description.
Survey > Surveys
Displays the list and allows for management of survey records in countries that are the original sources for the various data source organizations that provide data to FEWS NET. This page allows administrators to perform the following tasks:
Add a new survey data in the system
Edit or delete existing survey data in the system
Import surveys from a file
Export surveys in the system into a file
Search and view survey records using a free text search criteria
Filter and view survey records by data domain
Warehouse
Warehouse > Data maintainers
Provides the ability to specify a data maintainer, such as an external organization or individual without an FDW account, that can be associated with a data source document.
Warehouse > Data usage policies
Manage the data usage policies in the system. Data usage policies are attached to data source documents and are used to specify the data access permission for the data obtained from the data source.
There are three data usage policies in the system. Others may have to be added in the future as needed. This page allows administrators to perform the following action in the system:
View existing data usage policies in the system
Add a new data usage policy
Modify the descriptions of an existing data usage policy
Delete one or more data usage policy in the system
Search data usage policies in the system
Warehouse > Data usage policy reasons
Manage the list of data usage policy reasons in the system. Data usage policy reasons are attached to data source documents as an explanation about why a specific data usage policy has been assigned to the data source document.
From this page, administrators are able to the following actions:
Add a new data usage policy reason
Edit existing data usage policy reason description
Delete one or more data usage policy reason description
Search data policy reason records using a free text search criteria
Warehouse > Document types
In addition to the data domain, the system further classifies the data in the database by using document types. The document type indicates the last detail the system needs when data is imported into the database. For instance, under the population domain, the data is further divided into either a census data or a population estimate data.
This page enables administrators to manage the document types under each domain as necessary and administrators can:
Add new document type under the desired data domain
Edit and delete document type data as necessary
Search existing data using a free-text search criteria
Filter existing document type data using data domain
Warehouse > Indicator groups
Indicator groups provide a way of categorizing one or more indicators into a single category and indicator groups are used in reporting or summarizing information in the system. Indicator groups are specified under a data domain and indicators are classified into belonging to an indicator group.
This page allows administrators to manage a list of indicator groups by enabling them to:
Add a new indicator group to a data domain
Edit or delete existing indicator group
Search existing indicator group data using a free-text search criteria
Filter existing indicator group data using data domain
Warehouse > Indicators
Indicators are the most important attributes of the numeric data stored in the system. For example, for data under the crop domain, there are several indicators which accompany the data that is imported into the system: the area planted, area harvested, quantity produced, and yield.
Administrators use this page to manage the current list of indicators for each domain. The specific functionalities of this page are:
Adding a new indicator in a data domain, by specifying the indicator group and other attributes.
Edit or delete an existing indicator data in the system
Search existing indicator data using a free-text search criteria
Filter existing indicator data using the following indicator attributes: data domain, has confidence interval, has high value, or default indicator.
Warehouse > Licenses
A data source document license tells us what rights the FEWS NET project, and other users if applicable, have to use the data in the source document.
Administrators use this page to manage the current list of usage licenses. The specific functionalities of this page are:
Add a new license
Edit or delete an existing license
Search existing licenses using a free-text search criteria
Warehouse > Source documents
Manage the current list of data source documents in the system. One or more data source documents with a specified data usage policy and document type are created for each data source organization that provides data to FEWS NET.
The functionalities available from this page are:
Add a new data source document to the system
Import new records of data source document from a file
Edit or delete an existing data source document
Export the current list of data source document into a file
Search existing data source document using a free-text search criteria
Filter existing data source organization by data usage polity, data domain, country, or web service.
Warehouse > Source organizations
Manage the current list of data source organizations in the system. Data source organizations are organizations in different countries that provide data for a specific document type in a domain for a country.
The functionalities available from this page are:
Add a new data source organization to the system
Import new records of data source organizations from a file
Edit or delete an existing data source organization record
Export the current list of data source organizations into a file
Search existing data source organization using a free-text search criteria
Filter existing data source organization by country
Warehouse > Web services
Manage the list of web services used to import data into FDW.
The functionalities available from this page are:
Add a new web service
Edit or delete an existing web service record
Search existing web services using a free-text search criteria
Filter existing web services by name