Create dynamic embeddable results of SQL queries in GRFF web pages.

[OpenOilUG]

• [x] Add a VM running the Strapi CMS for editorial pages on the site.
• [x] Extend Strapi with a component that allows the editor to pull in result from predefined SQL queries as a table into editorial pages.
• [x] Extend Strapi with a component that allows the editor to pull in single number results from predefined SQL queries into widgets.

Define queries:

• [ ] Asset / records count
• [ ] Project count

[OpenOilUG]

GEM Review 10.12.21 The “Status” paragraph raises many questions. First, it seems odd to only list the number of oil and gas assets that have been processed. What about coal? Second, what does it mean that assets have been “processed?” Are these results available somewhere on this website? Third, what does it mean that there are 450,000 “records” and “about five billion raw data points?” Since this is touted as an open project, all these things should be clearly defined and openly available.

[OpenOilUG]

Create a system where system information can be embedded dynamically, therefore needing no manual updates, to allow website editor to call a result of a given SQL query within the text of a page. This would suggest creation of simple public library of scripts, and some internal mechanism in front end which can call the results seamlessly into text,

[OpenOilUG]

e.g. from Data Documentation page https://dev.fossilfuelregistry.org/data: "As of November 3, 2021 the Registry has processed production history and reserves data for 14,138 oil and gas assets from 139 countries, creating 450,000 records from about five billion raw data points."

• [ ] "14,138 assets" involves counting number of distinct entities at both country and project level and adding them together. _select COUNT(distinct iso3166) from country_datapoint cdp ; yields 138 countries. plus select _COUNT(distinct project_id) from project_datapoint pdp ; yields 16,212 distinct project ids.
• [ ] "450,000 records" _select COUNT() from project_datapoint pdp ; yields 274,040 records and _select COUNT() from country_datapoint cdp ; yields 48,917 .

e.g. from country page USA https://dev.fossilfuelregistry.org/co2-forecast/us

• [ ] Number of projects in the USA select COUNT(*) from project where iso3166 = 'us' ; (7615) of which 2917 are sparse _select COUNT(*) from project where iso3166 = 'us' and "projecttype" = 'sparse' ; (and presumably 1 - that is dense)

[OpenOilUG]