janvda/niamondo-deck repository overview

⁠niamondo-deck

Displays the deck for the game niamondo

Add /ui to the service URL to see the deck !

⁠GitHub location

janvda/niamondo:deck⁠

⁠docker-compose example

TO BE DONE

⁠Change History

• version 2.36.0 : niamondo.db: the 45 production_by_state rows for Australia (ids 133 to 177) were checked one by one against published Australian state data (ABS, USGS Minerals Yearbook, Geoscience Australia, WA statistics digest, Clean Energy Council, Office of the Chief Economist) and updated: real source URL, description, comment with confidence level, unit and country_total; 24 state allocations changed (for example zircon now led by South Australia, silicon in Western Australia, coal reserves led by Victoria); rows based on estimates (kaolin, gypsum, zircon, solar, roundwood and others) say so in their comment. Geojson files renamed to *_au_cn_in_us.geojson (Australia added).

• version 2.35.0 : niamondo.db: card 94 (bauxiet) corrected from alumina to bauxite mine production (USGS MCS 2026, 2024; China row recalculated, India row added); cards 62 (rijst) and 94 now active; 8 Australian states added to country; added 45 production_by_state rows for Australia (45 cards), 175 rows in total; see bauxite-card-94-plan.md⁠ and production-by-state-australia-plan.md⁠

• version 2.34.0 : documentation: added how cards are selected and shuffled⁠

• version 2.33.0 : niamondo.db: added 12 production_by_state rows (China, India and USA) for the cards aquacultuur, zilver, zout and hout (new card 224), with all columns filled (year, unit, source, description, comment, country_total, percentages); estimated splits are documented in the comment of the row (see production-by-state-aqua-silver-salt-tin-plan.md⁠ and production-by-state-wood-plan.md⁠); also moved the state data of cassava (CHN, row 51) and sweet potatoes (CHN, row 83) from 2021/2022 to the production year 2024, partly as documented estimates (see production-by-state-stale-year-plan.md⁠)

• version 2.32.0 : niamondo.db: added 30 production_by_state rows (China, India and USA) for the cards melk, eieren, rundvlees, gevogelte, varkensvlees, soja, maïs, sinaasappel, appel and druiven, with all columns filled (year, unit, source, description, comment, country_total, percentages); estimated splits are documented in the comment of the row (see production-by-state-new-cards-plan.md⁠)

• version 2.31.0 : niamondo.db: added 8 production_by_state rows for the cards yam (IND), zoete aardappel (CHN, IND), ferrochroom (IND), mangaan (IND), tin (CHN), natuurlijk grafiet (IND) and ferrosilicon (IND) (all columns filled, estimated splits documented in the comment)

• version 2.30.0 : refreshed the state/province data of all production_by_state rows with country_perc > 0 (China 32, India 23, USA 19) from the latest published state statistics (year, source, unit, country_total, description, comment and percentages); estimated splits are documented in the comment of the row (see state-source-refresh-plan.md⁠)

• version 2.29.0 : updated production cards based on https://www.usgs.gov/⁠ (latest available XLS tables, 2022-2024 MYB/ERT) and recalculated the corresponding state/province production percentages (China, India, USA)

• version 2.28.0 : niamondo.db: added updated_at (with triggers) to tables production and production_by_state, added missing country/state codes to the percentages of production cards, removed unused tables (see data-model.md⁠)

• version 2.27.0 : updated production cards based on https://ourworldindata.org/⁠ (latest year available, mostly 2024; uranium now from the OWID minerals explorer; hydro, wind, solar capped at 2024, biofuels 2025, nuclear 2024, coal/oil/gas production 2024, coal reserves 2023, fisheries 2024) and recalculated the corresponding state/province production percentages (China, India, USA)

• version 2.26.0 : updated production cards based on https://www.usgs.gove⁠

• version 2.25.1 : minor fixes / updates (including production cards)

• version 2.25.0 : updated production cards based on https://ourworldindata.org/⁠

• version 2.24.1 : slack messaging is removed which fixes issue #68 deck crashes⁠

• version 2.24.0 : based on image janvda/node-red-sqlite:4.0.2-22 (not for arm v7 architecture)

• version 2.23.O : further updated rule for drawing country cards.

• version 2.22.0 : added 10 new geography cards (see #16 add geography cards⁠)

• version 2.21.0 : based on image janvda/node-red-sqlite:3.1.0-18

• version 2.20.0 : #56 aardgas added⁠, updated rule for drawing country cards.

• version 2.19.0 : updated stats (and fixed state stats) for kobalt and lithium

• version 2.18.0 : beans and coffee updated with 2021 stats from owid.

• version 2.17.0 : #54 refresh production cards based on new owid statistics⁠ and #24 some minor card updates⁠

• version 2.16.1 : fixed some spelling errors in deck rules.

• version 2.16.0 : #37 for gas, oil and coal show MWh electricity and kg CO2/person⁠, card rules updated, updated production percentage with country code, renewed some production percentage with latest data.

• version 2.15.0 : documentation updates

• version 2.14.0 : all country stats updated in niamondo.db

• version 2.13.0 : added production by state statistics for sesame, beans, sugar cane, tea, tobacco, avocado.

• version 2.12.0 : by default: only produciont cards with state statistics

• version 2.11.0 : updated production by state stats (60 in total): coffee, cacao, palm oil, cashew, banana

• version 2.10.0 : updated several owid production statistis (from 2018 to 2020) + added several production by state (56 in total): rice, zinc, barley, ...

• version 2.9.0 : more production by state statistics (42 in total): cobalt, nickel, copper, lithium, wild fish catch.

• version 2.8.0 : more production by state statistics (33 in total): oil, gas, wind, solar, water power, nuclear, bio fuels, uranium, rare earths

• version 2.7.1 : fix bug in 2.7.0 that always shows same youtube video.

• version 2.7.0 : production card extended with percentages at state/province level if they are available in new SQLite table: production_by_state. This table already contains some production by state statistics.

• version 2.6.0 : added another 6 geography cards: Sebastopol, Ho Chi Minh, Lumumbashi, Samarkand, Manaus and Assouan

• version 2.5.0 : added geography cards

• version 2.4.0 : added buttons to energy production cards and low income production cards in configuration screen; added production card: oil reserves

• version 2.3.2 : production card updates (mainly cleanup)

• version 2.3.1 : new production cards: silver, salt, tin, copper, nickel, grahite, zinc, silicon, rare earth elements, uranium

• version 2.3.0 : configuration tab added allowing to select cards in deck at start of game

• version 2.2.0 : switched from mdashboard to dashboard #11⁠, production per person is put in proper unit, production cards for energy, fishery and aquaculture added.

• version 2.1.0 : use of niamondo.db (doesn't have the blobs)

• version 2.0.3 : when new game started send MQTT qr-scanner/reset

• version 2.0.2 : fixed the issue #4⁠ youtube video not displayed

• version 2.0.1 : based on docker image janvda/node-red-sqlite:3.0.2-16

• version 2.0.0 : First version after split of niamondo into 3 parts (deck, qr-scanner and map)