The Observing Asset Inventory requirements can be found on the bottom of page 4 of the Cooperative Agreement Progress Report Guidance document. In this document, guidance is provided on what assets to include, what assets not to include, and what specific fields should be populated. The inventories cover the entire calendar year (CY), for the year they are reporting (eg. for 2020 the period of time is Jan 1 2020 - Dec 31 2020).
When the inventories are received for the progress reports, they will be made available through Google Drive. Below is a step-by-step walkthrough of the initial review for an Asset Inventory.
- Pick an RA to review. Typically this will be the first RA to submit their progress report.
- Download the associated inventory spreadsheet. This is typically in MS Excel format as a workbook.
- Open the spreadsheet and review the headers to ensure the appropriate columns exist and are populated. See the README in this repository for a summary of the fields and their contents.
- If any columns are missing or entirely empty, send a note to the RA about the missing information. See Sending a request for more information.
- Review changes from last year's inventory
- Review any comments provided in the Additional notes column.
- Review any notes, added as comments, for cells in the inventory.
- In some cases, changes from last year's inventory will be indicated with syntax formatting (strikethrough, bold, highlighted).
- Clean up the inventory.
- Create a copy of the source workbook and store it in
[year]/data/processed/[RA].xlsx
(eg. 2023/data/processed/AOOS.xlsx) - Run spot_check_stations.ipynb (https://github.com/ioos/ioos-asset-inventory/blob/main/spot_check_stations.ipynb). In Cell[2] Edit
ra =
to identify the RA your reviewing and run the notebook.- This gives you a quick sense of if the data in the spreadsheet can be read and if those stations are available via an RA ERDDAP or the IOOS Catalog.
- What NOT to include:
Assets that are not publicly served/disseminated by the RA (e.g. assets used only for internal purposes).
▪ Federal stations that are solely owned, operated, maintained, and funded by the federal group (i.e. the RA has no involvement in the operations).
▪ Servers, vehicles used to deploy/conduct maintenance, a laboratory, etc.
▪ HF Radar and Gliders, since these inventories are already captured separately.
- Create a new sheet in the Excel Workbook and name it IOOS Removals.
- This is where the stations that shouldn't be considered for the CY Inventory will be moved to.
- If a station is indicated to not have observations for the Calendar Year of reporting, move the row to the IOOS Removals sheet.
- Move any stations with
Platform Type
ofsatellite
,glider
,HF-radar
, orsurface_current_radar
to the IOOS Removals sheet. - Check the
Latitude
andLongitude
columns to ensure there are valid values and those coordinates are expected (decimal point in correct place, missing negative for West, etc).- This checking is done in
spot_check_stations.ipynb
. - Any issues with coordinates should be relayed back to the RA.
- This checking is done in
- Check the
Variable Names
for any out of the ordinary names. The goal is to be provided CF standard names, if possible. Otherwise, a descriptive term is sufficient.
- Create a copy of the source workbook and store it in
- Spot check a couple of the stations to ensure data are available.
- Using the
RA
,Station ID
,WMO ID
,Station Long Name
, orStation Description
the station and associated data should be discoverable from the RA website and the IOOS Catalog. - This checking is done in
spot_check_stations.ipynb
.
- Using the
- If no issues are found,
- Save the processed spreadsheet
[year]/data/processed/[RA].xlsx
(eg. 2023/data/processed/AOOS.xlsx) - Save the most recent run of
spot_check_stations.ipynb
. - Run
inventory_creation.ipynb
to update inventory files. git add
,git commit
, andgit push
changes to the repository- Update the appropriate GitHub issue for the yearly inventory indicating which RA is complete.
- update the Trello card with the text
[RA]: Asset Inventory meets the requirements.
(replacing RA with the RA name)
- Save the processed spreadsheet
In some cases, the IOOS Office needs more information from the Regional Association to complete the inventory. If this is the case, the IOOS reviewer will add a comment to the appropriate Trello card. Indicating the RA and including a concise description of what is missing.