May-24-Data-Uploads

[cthomasONRR]

:sunglasses: PREVIEW

Changes proposed in this pull request:

• CY23 production data
• Jan 24 monthly production data
• Jan 24 monthly OGOR-B data
• Moved 2013 OGOR-B data into the Historical file (DORC will only be updating from 2014 onward now).
• April 24 monthly revenue data
• April 24 monthly disbursement data
• Updated the BIA FAQ link in Native American Ownership and Governance webpage
• Removed the "train the trainer" link in Plan Language webpage
• Removed extra sitemap.xml file
• Updated robots.txt to remove archived site, added pattern library to be disallowed, and changed sitemap to the one we are keeping
• Added robots-dev.txt to block preview & dev sites from being crawled
• Added No Fear Act link to footer

[cthomasONRR]

Production Calendar Year 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

[cthomasONRR]

@greensomes This doesn't need to be fixed today. Just want to give you a heads up that I uploaded the new calendar year production data, and I'm not seeing CY23 present in Query Data. For Explore, the year slider at the top shows CY23, but no data is present when you select it. This dataset adds CY23 but also updates previous CYs. I updated the .yaml in changelog-data. Please let me know if there's anything I can do to help!

[cthomasONRR]

@greensomes Also, it looks like "Geothermal - Direct Use, Millions of Gallons (cgal)" within the raw data did not make it to the PR

[cthomasONRR]

CY23 production data looks good!

[cthomasONRR]

Production Monthly

• [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] 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

[cthomasONRR]

Revenue Monthly

• [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

[cthomasONRR]

@greensomes I added April monthly revenue data... the April data is present in the PR but the March data disappeared:

The file is still in the database though:

[cthomasONRR]

@lpgoldstein The No Fear footer link is ready for your review. Thanks!

[cthomasONRR]

@greensomes I now see March monthly revenue in Homepage & Query data, but it is not present in the download files https://nrrd-preview.app.cloud.gov/sites/May-24-Data-Uploads/downloads/revenue/

[cthomasONRR]

Monthly revenue and production data look good!

[lpgoldstein]

Disbursements Monthly April 2024 @lpgoldstein

• [x] Make sure the downloaded data matches the raw data. Raw data
• 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

[lpgoldstein]

@AlexandracmONRR disbursements looks good as well. I think we can merge this to dev. Do you want me to do that?