Overview
State Models
IO Javascript
IO Charts

Profile Dev
IO Template
Profile YAML

Developing
Trade Flow Map
Chord (D3)
Sankey (eCharts)

YAML for SQL table names

The following YAML for the SQL insert resides at profile/impacts/exibase/US-source
Yaml-2-SQL table python from From ChatGPT which resides in the textarea below.
A version of the following resides in our generate_import_factors.py which we are replacing with a direct pull from the Exiobase API.

The previous Exiobase CSV file exports pulled by the US EPA code reside in impacts/exiobase/US-source. Initilly the following was created to use yaml to rename CSV columns when pulling into Supabase. We are aiming to avoid using the US EPA csv files with a new version of the Exiobase pull that works for all countries.

To reduce the size of our resulting SQL databases, the large FlowUUID values will be replaced with FactorID, a 1-based index relating the Factor table to 4 or more tables.

Our Exiobase To Github Pipeline pushes to Github using these steps...