Dev-->Master May 2024 Release

[AlexandracmONRR]

:sunglasses: PREVIEW

Use the following checklist to check features on the website when updating data files.

• [x] What's New Box @lpgoldstein
• [x] Version release (link) @cthomasONRR
• [x] No Fear Act added to footer @cthomasONRR
• [x] Updated the BIA FAQ link in Native American Ownership and Governance webpage @cthomasONRR
• [x] Removed the "train the trainer" link in Plan Language webpage @cthomasONRR
• [x] Removed extra sitemap.xml file @eelzi-ONRR
• [ ] Updated robots.txt to remove archived site, added pattern library to be disallowed, and changed sitemap to the one we are keeping @eelzi-ONRR
• [x] Added robots-dev.txt to block preview & dev sites from being crawled @eelzi-ONRR

Production Monthly @AlexandracmONRR

• [x] Make sure the downloaded data matches the raw data.

Homepage - Yearly Breakdown

• Select a year and verify the amounts and comparisons are correct for the conditions below. Repeat with the most recent year.
  • [x] Period - Calendar Year
  • [x] Commodity - Oil (bbl)
  • [x] Commodity - Gas (mcf)
  • [x] Commodity - Coal (tons)

Homepage - Monthly Breakdown

• Select a month and verify the amounts and comparisons are correct for the conditions below. Repeat with the most recent month. Be sure to verify negative numbers are correct if applicable
  • [x] Period - Most recent 12 months
  • [x] Period - Fiscal Year
  • [x] Period - Calendar Year
  • [x] Commodity - Oil (bbl)
  • [x] Commodity - Gas (mcf)
  • [x] Commodity - Coal (tons)

Homepage - Source File

• [x] Check source file links are correct.

Query Data - In the 'Period' category, filter to 'Monthly' and check the following:

• [x] One Land Type filter
• [x] One to three Products
• [x] Downloads matches filtered data

Download Page

• [x] Dates and file size are correct for csv and excel

Monthly Snap Shot

• [x] Check graphs match homepage

OGOR-B @cthomasONRR

• [x] OGOB-B excel
• [x] OGOB-B csv
• [x] Historical OGOR-B excel
• [x] Historical OGOR-B csv

Production Calendar Year @cthomasONRR
NOTE: "Mixed Exploratory" land category is removed from the product totals seen in Query and Explore.

• [x] Make sure the downloaded data matches the raw data. Raw data saved here (Insert Teams link to raw file)

Explore Data - Map and Detail Card

• Select a year and select a state with data, verify information on the detail cards are correct as well as the Production Over Time line graph. Repeat with the latest available year.

  • [x] Period - Calendar Year
  • [x] With 2-3 additional commodities

• Select a year and select a county with data, verify information on the detail cards are correct as well as the Production Over Time line graph. Repeat with the latest available year.

  • [x] Period - Calendar Year
  • [x] With 2-3 additional commodities

• Select a year and select an offshore area, verify information on the detail cards are correct as well as the Production Over Time line graph. Repeat with the latest available year.

  • [x] Period - Calendar Year
  • [x] With 2-3 additional commodities

• [x] Select a state and county without data and verify the expected information is displayed.

• [x] Add Nationwide Federal Card and verify the expected information is displayed

• [x] Add Native American Card and verify the expected information is displayed

Explore Data - Nationwide Production Summary and Top Nationwide Locations

• Verify breakdowns by production type and source are correct as well nationwide locations for the conditions below.
  • [x] Not current Calendar Year
  • [x] Current Calendar Year

Query Data, in the 'Period' category, filter to either 'Calendar Year' or 'Fiscal Year' and check the following:

• [x] One Land Type filter
• [x] One State
• [x] One Offshore Region
• [x] One to three Product
• [x] Downloads matches filtered data

Download Page

• [x] Dates and file size are correct for csv and excel

Revenue Monthly @eelzi-ONRR

• [x] Make sure the downloaded data matches the raw data. Raw data saved here (Insert Teams link to raw file)

Homepage - Yearly Breakdown

• Select a year and verify the amounts and comparisons are correct for the conditions below. Repeat with the most recent year.
  • [x] Period - Fiscal Year
  • [x] Period - Calendar Year
  • [x] Breakout - Source
  • [x] Breakout - Revenue Type
  • [x] Breakout - Commodity

Homepage - Monthly Breakdown

• Select a month and verify the amounts and comparisons are correct for the conditions below. Repeat with the most recent month. Be sure to verify negative numbers are correct if applicable
  • [x] Period - Most recent 12 months
  • [x] Period - Fiscal Year
  • [x] Period - Calendar Year
  • [x] Breakout - Source
  • [x] Breakout - Revenue Type
  • [x] Breakout Commodity

Homepage - Source File

• [x] Check source file links are correct.

Query Data - In the 'Period' category, filter to 'Monthly' and check the following:

• [x] One Land Type filter
• [x] One Revenue Type filter
• [x] One State
• [x] One Offshore Region
• [x] One to three Commodities
• [x] Clear All and change grouping
• [x] Downloads matches filtered data

Download Page

• [x] Dates and file size are correct for csv and excel

Monthly Snap Shot

• [x] Check graphs match homepage

Disbursements Monthly @lpgoldstein

• [x] Make sure the downloaded data matches the raw data. Raw data saved here (Insert Teams link to raw file)
  • Note: Make sure both datasets have the same sum. If there are line items that have the same fund type, revenue type, and location, they will be 'rolled up' together so the line item count may differ between the raw data and downloaded data.
• [x] Check Treasury Fund column is deleted
• [x] Check Hidalgo Caounty is changed to Hidalgo County under county column
• [x] Check "BLM - Permit Processing and Improvement" is changed to to "Lease Processing and Improvement" (BLM) under fund type column

Homepage - Yearly Breakdown

• Select a year and verify the amounts and comparisons are correct for the conditions below. Repeat with the most recent year.
• [x] Breakout - Source
• [x] Breakout - Recipient

Homepage - Monthly Breakdown

• Select a month and verify the amounts and comparisons are correct for the conditions below. Repeat with the most recent month. Be sure to verify negative numbers are correct if applicable
  • [x] Period - Most recent 12 months
  • [x] Period - Fiscal Year
  • [x] Period - Calendar Year
  • [x] Breakout - Source
  • [x] Breakout - Recipient

Query Data - In the 'Period' category, filter to 'Monthly' and check the following:

• [x] One Recipient
• [x] One Source
• [x] One State
• [x] One to three Commodities if applicable
• [x] Clear All and change grouping
• [x] Downloads matches filtered data

Download Page

• [x] Dates and file size are correct for csv and excel

Monthly Snap Shot

• [x] Check graphs match homepage

[eelzi-ONRR]

Just a reminder that we need to double check the robots.txt file once it goes live - I can't check the changes to robots.txt in this PR. This looks good for the robots-dev file, just want to double check the correct robots files are pushed to dev and main.