KiwiChem is a database with a calculator attached, and two modelled tabs. Almost everything it shows is a published number reproduced faithfully; a small number of things it works out for you; and two tabs run a construction over the top — Cycle, a process model of where a chemical goes, and Orbitals, a molecular orbital calculation of why it bonds as it does. This note draws the line between them, sets out every equation on the calculated side, and says where each dataset is weakest.
KiwiChem 是一个附带计算器的数据库,另有两个建模标签页。它显示的几乎所有内容都是如实转载的已发表数值;少数内容由它替你算出;还有两个标签页在此之上运行一套构造——“循环”是描述化学物质去向的过程模型,“轨道”是解释其成键方式的分子轨道计算。本说明划清三者之间的界线,列出计算部分的每一个方程,并指出每个数据集最薄弱之处。
1What this is, and what it is not它是什么,不是什么
The application answers one question: what is known about this chemical in soil, and how does a concentration I have measured compare with it? It holds 273 contaminants, 943 soil guideline values across twelve jurisdictions, 389 drinking-water standards from nine sources, 661 food limits from eight, the New Zealand background distribution of 65 elements, and the plant interpretation ranges for 38.
本应用只回答一个问题:关于这种化学物质在土壤中的情况,已知些什么?我测得的浓度与之相比如何?它收录 273 种污染物、跨十二个管辖区的 943 条土壤指导值、来自九个来源的 389 条饮用水标准、来自八个来源的 661 条食品限值、新西兰 65 种元素的本底分布,以及 38 种元素的植物解读范围。
Every chemical in KiwiPest is here. 119 of the contaminants come from KiwiChem's own source workbooks; the other 154 are the pesticide active ingredients KiwiPest assesses that those workbooks do not hold, imported by the build (scripts/kiwipest_import.py) with KiwiPest's values for soil half-life, Koc, water solubility and log Kow. Few of them have a published soil, water or food guideline value anywhere, so most of their tables are empty, which is a finding in itself. KiwiPest's microbial products are organisms, not chemicals, and are not included. For the 21 chemicals both datasets held from their own sources, every value on which they disagreed was settled against the Pesticide Properties Database as it stood on 2 October 2026, using one rule (the PPDB headline DT50 and Koc, its solubility and log P), and written into both; scripts/harmonise.py records each change and the figure behind it, and the app's data carry the same log as KC_DATA.harmonised.
KiwiPest 中的每一种化学物质都在这里。其中 119 种污染物来自 KiwiChem 自己的源工作簿;其余 154 种是 KiwiPest 评估、而这些工作簿未收录的农药有效成分,由构建过程(scripts/kiwipest_import.py)导入,并带上 KiwiPest 的土壤半衰期、Koc、水溶解度和 log Kow 数值。它们当中很少有哪种在任何地方有已发表的土壤、水或食品指导值,所以它们的表格大多是空的,这本身就是一项发现。KiwiPest 的微生物产品是生物体而非化学物质,未予收录。对于两个数据集各自依据自身来源都收录的 21 种化学物质,凡两者有分歧的数值,均以 2026 年 10 月 2 日时的 Pesticide Properties Database 为准、按同一规则(PPDB 的主要 DT50 和 Koc,及其溶解度和 log P)裁定,并写入两个数据集;scripts/harmonise.py 记录每一处改动及其依据的数值,应用的数据也以 KC_DATA.harmonised 带有同一份记录。
It is not a risk assessment. There is no exposure model, no receptor, no site conceptualisation and no dose reconstruction. A hazard quotient here compares one number with another number; deciding whether that matters on a particular site is the work the application deliberately does not do.
它不是风险评估。这里没有暴露模型,没有受体,没有场地概念模型,也没有剂量重建。这里的危害商只是拿一个数字与另一个数字相比;判断这在某个具体场地上是否要紧,正是本应用刻意不做的工作。
Two tabs are deliberate exceptions. The first is Cycle. It answers a second question — where does this chemical go, and what moves it? — and it answers it with a model rather than with a lookup. It is kept visibly separate for that reason: its arrows carry their own two-scale convention, its assumptions are printed under every diagram, and section 8 sets out the whole of it. It is still not a risk assessment, and it is still not a description of anyone's paddock.
有两个标签页是刻意的例外。第一个是“循环”。它回答第二个问题——这种化学物质去往何处,又是什么在推动它?——而且是用模型而不是查表来回答。正因如此,它被明显地单独处理:它的箭头遵循自己的双尺度约定,它的假设印在每张图下方,第 8 节完整列出其全部内容。它仍然不是风险评估,也仍然不是对任何人家围场的描述。
The second is Orbitals, and it stands further from the data than anything else here. It answers a third question — why does this element bond to that one the way it does? — with a two-centre extended Hückel construction whose parameters are not measurements of anything. They were fitted so that the construction reproduces the second-row homonuclear diatomics in bond order, unpaired electrons and level ordering at once, which is the only claim they support and which KiwiChem.orbitalSelfTest() checks. It is in the application because the polarisation of a bond is the shortest honest answer to why cadmium follows sulphur and calcium does not; it is not in the application to produce numbers. The user guide sets it out in section 6.
第二个是“轨道”,它离数据比这里任何其他内容都更远。它回答第三个问题——为什么这种元素会以这样的方式与那种元素成键?——所用的是一种双中心扩展 Hückel 构造,其参数并不是对任何东西的测量。这些参数经过拟合,使该构造在键级、未成对电子数和能级次序上同时重现第二周期同核双原子分子,这是它们所能支持的唯一主张,也正是 KiwiChem.orbitalSelfTest() 所检验的内容。它之所以在应用里,是因为键的极化是对“为什么镉随硫走而钙不随”最简短的诚实回答;它不是为了产出数字而在应用里。用户指南在第 6 节中对其作了阐述。
2Where each number comes from每个数字从何而来
Every dataset in KiwiChem is in one of two categories, and every value carries which.
KiwiChem 中的每个数据集都属于两类之一,每个数值都标明它属于哪一类。
Reproduced from a source workbook
从源工作簿转载
The soil guideline values, drinking-water standards, food limits, health-based guidance values, soil half-lives, Koc and Kd values are read straight out of the three compiled workbooks now in archive/ by scripts/extract.py. Nothing is transformed on the way through except unit conversion the workbook itself carries. Each row keeps its own confidence flag:
土壤指导值、饮用水标准、食品限值、基于健康的指导值、土壤半衰期、Koc 和 Kd 值,都由 scripts/extract.py 直接从现存于 archive/ 的三份汇编工作簿中读取。除工作簿本身附带的单位换算外,途中不作任何转换。每一行都保留自己的可信度标记:
- Extracted from cited source
- Read directly from the instrument named in the Source column during compilation. Shown as cited.
- Compiled — verify against primary source
- From the standard literature, or from a guideline set that could not be machine-read in full. Believed correct, not checked cell by cell. Shown as verify.
- Checked against primary source
- Compared value by value with the instrument itself in September 2026 and found to agree. A stronger claim than cited, and made only for the scenario keys where the comparison was actually done. Shown as checked.
- Corrected against primary source
- The workbook and the instrument disagreed, and the instrument won. Shown as corrected; the tooltip carries the value the workbook had, and the Sources tab lists every one of them.
- 摘自所引来源
- 汇编时直接从“来源”列所列的文书中读取。显示为 引用。
- 汇编——需对照原始来源核实
- 取自标准文献,或取自无法完整机读的指导值集。相信是正确的,但未逐格核对。显示为 待核实。
- 已对照原始来源核对
- 2026 年 9 月逐值与文书本身比对,结果一致。这是比 引用 更强的声明,只针对确实做过比对的情景键作出。显示为 已核对。
- 已依据原始来源更正
- 工作簿与文书不一致,以文书为准。显示为 已更正;工具提示中给出工作簿原来的数值,“来源”标签页逐一列出所有此类更正。
The September 2026 check
2026 年 9 月的核对
Every soil guideline value was read against the instrument that publishes it. Eighty-five rows changed. Most were transcription slips of one column — the UK Category 4 Screening Levels had cadmium's commercial value filled with the old Soil Guideline Value of 230 mg/kg instead of 410, and four substances had their public-open-space values taken from the wrong column; the Finnish decree's benzene and cyanide rows were one column to the left, so the threshold value was reported as the lower guideline value; the lead rows filed under the LQM/CIEH S4ULs were C4SL values, and the S4ULs do not cover lead at all. Others were out of date: nickel and zinc to the current CCME guidelines, the German Prüfwerte to the 2021 ordinance in force since 2023, and eight US Regional Screening Levels to the November 2024 tables. The corrections are applied by scripts/sgv_corrections.py, which lists each one with the document it was read from; the source workbooks in archive/ are left exactly as they were supplied.
每一条土壤指导值都对照发布它的文书重新读过。共有八十五行发生改动。大多数是错了一列的转录失误——英国 Category 4 Screening Levels 中镉的商业用地值填成了旧的 Soil Guideline Value 230 mg/kg,而不是 410,另有四种物质的公共开放空间值取自错误的列;芬兰法令中苯和氰化物两行向左错了一列,于是把阈值报成了较低指导值;归在 LQM/CIEH S4ULs 名下的铅行实为 C4SL 值,而 S4ULs 根本不涵盖铅。其余则是已经过时:镍和锌更新为现行 CCME 指南,德国 Prüfwerte 更新为自 2023 年起施行的 2021 年条例,八项美国 Regional Screening Levels 更新为 2024 年 11 月的表格。这些更正由 scripts/sgv_corrections.py 施加,该脚本逐条列出每项更正及其所依据的文件;archive/ 中的源工作簿完全保持提供时的原样。
The drinking-water standards had the same check, for New Zealand and Australia. All 42 New Zealand maximum acceptable values agree with the Water Services (Drinking Water Standards for New Zealand) Regulations 2022. Sixteen Australian health-based guideline values did not agree with the NHMRC fact sheets: thirteen were wrong when compiled — arsenic was the 1996 value of 0.007 mg/L rather than 0.01, barium 0.7 rather than 2, and eleven pesticides were off by up to a factor of five — and lead, manganese and selenium were lowered by the 2025 revision of the guidelines. The trichloroethylene row is removed, because the Australian guidelines set no value for it. These are applied by scripts/water_corrections.py, and the soil–water equilibrium screen is recomputed from the corrected values.
饮用水标准也做了同样的核对,针对新西兰和澳大利亚。新西兰全部 42 项最大可接受值均与 Water Services (Drinking Water Standards for New Zealand) Regulations 2022 一致。有十六项澳大利亚基于健康的指导值与 NHMRC 情况说明书不符:其中十三项在汇编时就是错的——砷用的是 1996 年的 0.007 mg/L 而非 0.01,钡是 0.7 而非 2,另有十一种农药偏差最多达五倍——而铅、锰和硒则因 2025 年指南修订而下调。三氯乙烯一行已删除,因为澳大利亚指南没有为它设定数值。这些更正由 scripts/water_corrections.py 施加,土壤–水平衡筛查也按更正后的数值重新计算。
Notes belong to the row they are about
注释归属于它所针对的那一行
The workbooks carry one note per guideline set and repeat it on every row of that set, so a cadmium row from the Canadian guidelines said that the chromium value is listed against Cr(III) and that the BTEX values are for surface soil. Nothing there is false, but a table of cadmium values annotated with chromium and BTEX reads as though the rows were mixed up. scripts/note_relevance.py now splits each note into clauses and keeps, on each row, the clauses that name that chemical or name nothing; a clause that names only other substances is dropped. Every note survives in full on the Sources tab, once per instrument.
工作簿对每个指导值集只写一条注释,并在该集的每一行重复,于是加拿大指南中的一条镉记录会说铬值是按 Cr(III) 列出的、BTEX 值针对表层土壤。这些说法并无错误,但一张镉数值表上标注着铬和 BTEX,读起来就像行被弄混了。scripts/note_relevance.py 现在把每条注释拆分成分句,并在每一行只保留提到该化学物质或未提到任何物质的分句;只提到其他物质的分句被舍弃。每条注释都在“来源”标签页上完整保留,每部文书一次。
Compiled for this application
为本应用汇编
The three workbooks do not carry a periodic table, plant concentrations, physicochemical constants or toxicological reference values, and the application needs all four. Those were assembled from the standard compilations — Kabata-Pendias for the soil and plant figures, Markert for the Reference Plant, IAEA TRS-472 for transfer factors, the PPDB and US EPA Soil Screening Guidance for the physicochemical constants, IRIS and IARC for the toxicology. Every row built this way is flagged for verification without exception, because none of it was machine-read from the primary source. The full list is on the Data sources page.
三份工作簿不含元素周期表、植物浓度、物理化学常数或毒理学参考值,而本应用这四样都需要。这些数据是从标准汇编中整理的——土壤和植物数据取自 Kabata-Pendias,Reference Plant 取自 Markert,转移因子取自 IAEA TRS-472,物理化学常数取自 PPDB 和 US EPA Soil Screening Guidance,毒理学取自 IRIS 和 IARC。以这种方式构建的每一行都无一例外地标记为待核实,因为其中没有任何内容是从原始来源机读的。完整清单见数据来源页。
3Background concentrations本底浓度
Anthropogenic contamination is a departure from background, not an absolute number, so background has a tab of its own, and it is the first one after the overview. KiwiChem holds it three ways.
人为污染是相对于本底的偏离,而不是一个绝对数字,所以本底有自己的标签页,并且紧排在“概览”之后。KiwiChem 以三种方式收录本底。
New Zealand, by region
新西兰,按地区
From the GNS Geochemical atlas of Aotearoa New Zealand (2023): 676 topsoil samples at 2–20 cm depth, one per sampled meshblock, analysed for 65 elements by aqua regia digest and ICP-MS. scripts/extract.py reduces the sample table to a distribution per element — n, minimum, 5th, 25th, 50th, 75th, 90th, 95th and 98th percentiles, maximum, arithmetic mean and geometric mean — nationally and for each of the sixteen regions. Percentiles are linearly interpolated on the sorted values and rounded to three significant figures.
数据来自 GNS 的 Geochemical atlas of Aotearoa New Zealand(2023):676 个表土样品,深度 2–20 cm,每个采样的统计小区(meshblock)一个,以王水消解和 ICP-MS 分析了 65 种元素。scripts/extract.py 把样品表归约为每种元素的分布——n、最小值、第 5、25、50、75、90、95 和 98 百分位数、最大值、算术平均值和几何平均值——包括全国分布和十六个地区各自的分布。百分位数在排序后的数值上线性插值,并保留三位有效数字。
New Zealand, by parent material
新西兰,按母质
For arsenic, cadmium, copper, chromium, lead, nickel and zinc, the Eco-SGV dataset predicts background from the underlying geology rather than the region. This is the comparison the Eco-SGVs themselves are built on: the added-risk approach adds the contaminant limit to the background of the site under assessment, so the geology-specific median is what you should use to derive an Eco-SGV for a real site.
对于砷、镉、铜、铬、铅、镍和锌,Eco-SGV 数据集根据下伏地质而非地区来预测本底。这正是 Eco-SGV 本身所依据的比较:附加风险法把污染物限值加到被评估场地的本底上,所以要为真实场地推导 Eco-SGV,应当使用特定地质的中位数。
Global reference
全球参考值
The world soil mean (Kabata-Pendias) and the upper continental crust abundance (Rudnick & Gao) are shown alongside, with their ratio. A soil-to-crust ratio above 1 means the element concentrates during weathering and soil formation; below 1 means it is lost.
同时并列显示世界土壤平均值(Kabata-Pendias)和上部大陆地壳丰度(Rudnick & Gao),以及两者之比。土壤/地壳比大于 1,表示该元素在风化和成土过程中富集;小于 1 表示它在流失。
4Partitioning: Kd, and what follows from it分配:Kd 及其推论
For an organic compound, sorption is to soil organic matter, so the distribution coefficient scales with organic carbon:
对于有机化合物,吸附发生在土壤有机质上,所以分配系数与有机碳成比例:
Kd = Koc × foc
The tabulated columns are this equation at foc = 0.5%, 1% and 5%. Change the organic carbon on the Inputs tab and the application recomputes Kd at your value and says so in the Basis column.
表中各列就是该方程在 foc = 0.5%、1% 和 5% 时的值。在“输入”标签页上更改有机碳,应用就会按你的数值重新计算 Kd,并在“依据”列中注明。
For a metal or metalloid it does not work that way. Sorption is controlled by pH, by iron and aluminium oxides, by organic matter and by cation exchange capacity, and it is not proportional to any one of them. KiwiChem therefore does not hold a Kd for a metal: it holds the measured distribution, by soil group and by condition, on the Kd & mobility tab. Entering an organic carbon fraction changes nothing for a metal, and the application says so rather than silently applying the wrong equation.
对于金属或类金属,情况并非如此。吸附受 pH、铁铝氧化物、有机质和阳离子交换量控制,且不与其中任何一项成比例。因此 KiwiChem 不为金属保存单一的 Kd:它在“Kd 与迁移性”标签页上保存按土壤类别和按条件划分的实测分布。对金属而言,输入有机碳分数不会改变任何结果,应用也会如实说明,而不是悄悄套用错误的方程。
Kd by soil and by condition
按土壤和条件划分的 Kd
Five compilations, kept apart, because two of them measure one thing and three measure another:
共五套汇编,分开保存,因为其中两套测的是一回事,三套测的是另一回事:
| Source | What it measures | Coverage |
|---|---|---|
| IAEA TRS-472 (2010), Tables 12–14 | Sorption. Geometric mean by soil group — sand, loam, clay, organic — and, for nine elements, by pH, by cation exchange capacity or by organic matter | 68 elements |
| US EPA Soil Screening Guidance (1996), Table C-4 | Sorption, modelled with MINTEQA2 on an iron-oxide sorbent at 0.2% organic matter, at every tenth of a pH unit from 4.9 to 8.0 | 12 metals |
| US EPA 402-R-99-004B (1999) look-up tables | Sorption. Minimum and maximum by pH class, and for Cr(VI) by extractable iron and sulphate as well | Cd, Cr(VI), Pb, Sr, Th, U |
| Allison & Allison (2005), Table 1 | Whole-soil. Median and range of field soil/water Kd: the metal that is already there, against the whole solid | 16 metals |
| SKB R-11-24 (2011), Table 3-3 | Whole-soil. Desorption of the element already present, measured the same way in five contrasting soils from pH 4.5 to 8.2 and 3 to 92% organic matter | 71 elements |
| 来源 | 测量内容 | 覆盖范围 |
|---|---|---|
| IAEA TRS-472(2010),表 12–14 | 吸附。按土壤类别(砂土、壤土、黏土、有机土)的几何平均值;另有九种元素按 pH、阳离子交换量或有机质划分 | 68 种元素 |
| US EPA Soil Screening Guidance(1996),表 C-4 | 吸附,用 MINTEQA2 在有机质 0.2% 的铁氧化物吸附剂上建模,pH 从 4.9 到 8.0 每隔 0.1 个单位一个值 | 12 种金属 |
| US EPA 402-R-99-004B(1999)查找表 | 吸附。按 pH 等级的最小值和最大值;Cr(VI) 还按可提取铁和硫酸盐划分 | Cd、Cr(VI)、Pb、Sr、Th、U |
| Allison & Allison(2005),表 1 | 全土。田间土壤/水 Kd 的中位数和范围:针对已存在于土壤中的金属,相对于整个固相 | 16 种金属 |
| SKB R-11-24(2011),表 3-3 | 全土。已存在元素的解吸,以同一方法在五种差异明显的土壤中测定,pH 4.5 至 8.2,有机质 3% 至 92% | 71 种元素 |
The distinction matters more than any of the individual numbers. A sorption Kd is measured by adding the metal and letting it equilibrate: it describes a spill, a recent deposition, this season's fertiliser. A whole-soil Kd is measured on metal that has been in the soil long enough to age into forms that are not exchangeable, and for the same metal in the same soil it is commonly one to two orders of magnitude the larger. For cadmium the sorption values run from 15 L/kg below pH 6.5 to 4300 at pH 8; the whole-soil values from 330 in an acid clay to 13,000 in a peat. Neither set is wrong. Using one where the other belongs is wrong, and it is wrong by a factor of a hundred.
这一区别比任何单个数字都更重要。吸附 Kd 是通过加入金属并使其达到平衡来测定的:它描述的是一次泄漏、一次新近沉降、本季施下的肥料。全土 Kd 则是在土壤中存留已久、已老化为不可交换形态的金属上测定的;对同一土壤中的同一金属,它通常要大一到两个数量级。镉的吸附值从 pH 6.5 以下的 15 L/kg 到 pH 8 时的 4300;全土值从酸性黏土中的 330 到泥炭中的 13,000。两套数值都没有错。错的是把一套用在该用另一套的地方,而且一错就是一百倍。
Nothing in these tables is derived by KiwiChem except unit conversion: SKB's m³/kg to L/kg, Allison's log Kd to Kd, and a log-linear interpolation between two tabulated pH values in the EPA screening table, which the tab says it has done. Two entries are annotated rather than corrected: the IAEA's loam-and-clay mean for caesium is printed as 3.7 × 10², which is below both the sand and the all-soils means and cannot be right for a pooled geometric mean, and is read here as 3.7 × 10³; and the copper minima printed as 7.6 × 10² exceed the means they sit beside, so they are left out.
这些表中除单位换算外,没有任何数据是 KiwiChem 推导的:SKB 的 m³/kg 换算为 L/kg,Allison 的 log Kd 换算为 Kd,以及在 EPA 筛选表的两个列表 pH 值之间作对数线性插值——标签页会注明已这样做。有两处条目加了注释而未作更正:IAEA 的壤土与黏土铯平均值印作 3.7 × 10²,低于砂土平均值和全部土壤平均值,作为合并几何平均值不可能正确,这里按 3.7 × 10³ 读取;而印作 7.6 × 10² 的铜最小值超过了与其并列的平均值,因此未予采用。
For the elements none of the five covers — carbon, nitrogen, oxygen, fluorine and osmium — the tab says so. For the noble gases it says that nothing is sorbed, which is not a missing value but an answer.
对于五套汇编都未涵盖的元素——碳、氮、氧、氟和锇——标签页会如实说明。对于稀有气体,它说明不发生吸附,这不是缺失值,而是一个答案。
Solid–solution split
固–液分配
With bulk density ρ and volumetric water content θ, the fraction on the solid phase and the retardation factor follow directly:
已知容重 ρ 和体积含水量 θ,即可直接得出固相上的分数和阻滞因子:
fsorbed = ρKd / (θ + ρKd)R = 1 + ρKd / θ
R is the factor by which water outruns the contaminant front. A retardation factor of 2000 for cadmium at Kd = 500 means the front moves two thousand times slower than the drainage — which is why cadmium accumulates in topsoil for decades rather than leaching away.
R 是水流跑在污染物锋面前面的倍数。镉在 Kd = 500 时阻滞因子为 2000,意味着锋面移动比排水慢两千倍——这就是镉会在表土中累积数十年,而不是被淋失掉的原因。
Porewater
孔隙水
The concentration in soil solution implied by a total soil concentration:
由土壤全量浓度推得的土壤溶液浓度:
Cw = Ctρ / (θ + ρKd) (mg/kg → mg/L, reported in µg/L)(mg/kg → mg/L,以 µg/L 报告)
The application compares this with the most stringent drinking-water value it holds. That comparison is the crudest thing in KiwiChem: linear equilibrium partitioning ignores dilution and attenuation between the soil and the receptor, ignores ageing, and ignores the non-linearity of real sorption isotherms. It is deliberately conservative, it is a screen, and it is not a soil-to-groundwater guideline value.
应用把这一浓度与它所收录的最严格的饮用水值相比较。这个比较是 KiwiChem 中最粗糙的部分:线性平衡分配忽略了土壤与受体之间的稀释和衰减,忽略了老化,也忽略了真实吸附等温线的非线性。它是刻意保守的,它是一种筛查,而不是土壤–地下水指导值。
5Persistence持久性
Soil half-lives are first-order DT50 values in days. Time to any remaining fraction f:
土壤半衰期是以天为单位的一级 DT50 值。降至任一剩余分数 f 所需的时间为:
t = DT50 × ln(f) / ln(0.5)
The Fate & toxicity tab gives the time to a half, a tenth and a hundredth. Two cautions. First, real dissipation in field soil is rarely first order: an initial rapid phase is followed by a long tail as the residue ages into pores organisms cannot reach, so extrapolating a laboratory DT50 to 99% dissipation overstates how fast the last of it goes. Second, the low–high range spans laboratory and field studies at different temperatures and redox conditions, and for the chlorinated solvents the difference between aerobic and anaerobic is the difference between weeks and years.
“归趋与毒性”标签页给出降至一半、十分之一和百分之一所需的时间。有两点需要注意。第一,田间土壤中的实际消散很少是一级的:初始的快速阶段之后,残留物会老化进入生物无法到达的孔隙,形成长长的拖尾,所以把实验室 DT50 外推到 99% 消散,会高估最后那部分消失的速度。第二,低–高范围横跨在不同温度和氧化还原条件下进行的实验室研究和田间研究;对氯代溶剂而言,好氧与厌氧之别就是几周与几年之别。
Elements do not degrade. Their row says so, and their persistence is governed by leaching, erosion, volatilisation and plant uptake instead.
元素不会降解。它们那一行会这样注明,其持久性转而取决于淋失、侵蚀、挥发和植物吸收。
6Plant concentrations植物浓度
The plant table is the standard interpretation scheme for mature leaf tissue generalised across species, on a dry-matter basis: deficient, sufficient or normal, excessive or toxic, and the tolerable ceiling for agronomic crops. Alongside it sit Markert's Reference Plant figure, the total soil concentration considered phytotoxically excessive, the soil-to-plant transfer factor, and the hyperaccumulation threshold.
植物表采用通行的成熟叶片组织解读方案,跨物种通用,以干物质为基础:缺乏、充足或正常、过量或有毒,以及农作物的可耐受上限。与之并列的有 Markert 的 Reference Plant 数值、被认为对植物有毒害的过量土壤全量浓度、土壤–植物转移因子,以及超富集阈值。
The transfer factor is applied to a measured soil concentration if you enter one:
如果你输入了实测土壤浓度,就会对其应用转移因子:
Cplant = Csoil × TF
Note also that the phytotoxic soil concentrations predate most modern ecotoxicology and were compiled across six authorities who disagreed with each other by a factor of five in places. Where New Zealand Eco-SGVs exist — arsenic, boron, cadmium, chromium, copper, lead, zinc, DDT, TPH and PAH — those are the better number, and they are in the soil guideline table.
还需注意,植物毒性土壤浓度早于大多数现代生态毒理学研究,汇编自六个权威来源,而它们之间有些地方相差五倍。凡是有新西兰 Eco-SGV 的——砷、硼、镉、铬、铜、铅、锌、DDT、TPH 和 PAH——那些才是更好的数字,它们就在土壤指导值表中。
7The screening calculation筛查计算
Enter a measured soil concentration and the application does four things.
输入一个实测土壤浓度,应用会做四件事。
- Hazard quotient against every numeric guideline value, filtered by the jurisdiction and protection basis chosen on the Inputs tab.
HQ = Cmeasured / Cguideline. Values reported as “no limit” or exceeding a tabulated ceiling carry a > qualifier and are excluded: they cannot be divided by. - Position in the New Zealand background distribution for that element, nationally or in the region chosen. Above the 95th percentile is the usual threshold for treating a concentration as anthropogenic rather than natural.
- Implied porewater concentration, by section 4, against the most stringent drinking-water value.
- Indicative plant concentration, by section 6.
- 对照每一个数值型指导值的危害商,按“输入”标签页上所选的管辖区和保护依据筛选。
HQ = Cmeasured / Cguideline。报告为“无限值”或超过列表上限的数值带有 > 限定符,被排除在外:它们无法作除数。 - 在新西兰本底分布中的位置,针对该元素,全国范围或所选地区。高于第 95 百分位数是把某一浓度视为人为来源而非天然来源的常用阈值。
- 推算的孔隙水浓度,按第 4 节计算,并与最严格的饮用水值比较。
- 指示性植物浓度,按第 6 节计算。
A hazard quotient of 1.0 is not a threshold of harm. Most of these values already embed a safety factor of between 10 and 1000 between the effect concentration and the number published, and the size of that factor differs between jurisdictions. An HQ of 3 against a Danish soil quality criterion and an HQ of 3 against a US EPA screening level do not mean the same thing.
危害商为 1.0 并不是危害阈值。这些数值大多已在效应浓度与公布数值之间嵌入了 10 到 1000 的安全系数,而且该系数的大小因管辖区而异。对照丹麦土壤质量标准的 HQ 为 3,与对照 US EPA 筛选水平的 HQ 为 3,含义并不相同。
8The biogeochemical cycle生物地球化学循环
The Cycle tab is the one part of KiwiChem that is not a lookup. Everywhere else a number is something somebody published and the application's job is to find it and say where it came from. Here the application runs a process model, and the distinction matters enough that it is drawn on the diagram itself.
“循环”标签页是 KiwiChem 中唯一不是查表的部分。在其他所有地方,一个数字都是某人发表过的东西,应用的任务是找到它并说明它从何而来。在这里,应用运行的是一个过程模型,而这一区别重要到直接画在了图上。
Two kinds of number come off that tab, and they are never mixed. A quantified flux is in g/ha/yr, computed from a database value through a formula printed on the page, and is drawn as a solid arrow. An indicative flux is a relative index in which the reference soil is ×1, is drawn translucent and dashed, and is not a rate. Nothing on that tab is a measurement of anyone's paddock.
这个标签页给出两类数字,二者从不混用。定量通量以 g/ha/yr 为单位,由数据库数值通过页面上印出的公式计算,画成实线箭头。指示性通量是一个以参考土壤为 ×1 的相对指数,画成半透明的虚线,并且不是速率。这个标签页上没有任何东西是对任何人家围场的测量。
The reference soil
参考土壤
Every response function returns 1.0 at pH 6.0, Eh +450 mV, EC 0.2 dS/m, 13 °C and 400 mm/yr net drainage — a well-drained, non-saline New Zealand mineral topsoil. An index of ×1 means “as at the reference soil”, and the whole diagram is read as a departure from it.
每个响应函数在 pH 6.0、Eh +450 mV、EC 0.2 dS/m、13 °C 和 400 mm/yr 净排水时返回 1.0——这是一种排水良好、非盐渍的新西兰矿质表土。指数 ×1 表示“与参考土壤相同”,整张图都应作为相对于它的偏离来读。
What the five sliders do
五个滑块的作用
Sorption is moved from the published Kd by adding shifts in log10, which is the form the sorption literature reports and the form in which the terms simply add:
吸附在已发表 Kd 的基础上,以 log10 叠加位移来调整;这是吸附文献报告的形式,也是各项可以直接相加的形式:
log Kd = log Kd,published + apH(pH − 6) − aEC log(I/Iref) + fredox(Eh)
The pH slopes are of the order of half a log unit per pH unit for the cationic metals, after Sauvé et al. (2000), and carry the opposite sign for the oxyanions, which desorb from iron and aluminium oxides as pH rises. The redox terms are given as six control points read off the standard Eh–pH construction rather than as fitted equations, so that a reader can check six numbers instead of trusting a curve. Temperature does not enter Kd at all; it enters the microbial rates, the volatility of the organics and the growth of the crop, which is where it actually acts.
对阳离子金属,pH 斜率约为每个 pH 单位半个对数单位,依据 Sauvé et al.(2000);对含氧阴离子则符号相反,因为它们随 pH 升高从铁铝氧化物上解吸。氧化还原项以从标准 Eh–pH 图上读取的六个控制点给出,而不是拟合方程,这样读者可以核对六个数字,而不必信任一条曲线。温度完全不进入 Kd;它进入的是微生物速率、有机物的挥发性和作物的生长,那才是它实际起作用的地方。
What the diagram shows
图中显示什么
The boxes are the chemical species the element takes in the soil, and the arrows are the reactions that move it between them. For zinc that is Zn2+, Zn–DOM, exchangeable Zn, Zn–SOM, zinc held on the iron and manganese oxides, the carbonate and the sulphide. For nitrogen it is organic N, ammonium, nitrite, nitrate, the microbial biomass and clay-fixed ammonium, with mineralisation, nitrification, denitrification, immobilisation, DNRA, ammonia volatilisation and biological fixation between them.
方框是该元素在土壤中呈现的化学形态,箭头是使它在这些形态之间转移的反应。对锌而言,是 Zn2+、Zn–DOM、可交换态 Zn、Zn–SOM、铁锰氧化物上结合的锌、碳酸盐和硫化物。对氮而言,是有机氮、铵、亚硝酸盐、硝酸盐、微生物生物量和黏土固定态铵,它们之间有矿化、硝化、反硝化、固持、DNRA、氨挥发和生物固氮。
Four networks are written out in full — nitrogen, carbon, sulphur and phosphorus — because in those the transformations are the chemistry and no template can carry them. Everything else is generated from one of three: a cation, an oxyanion, or an organic contaminant. A pool an element cannot form is dropped rather than drawn, so aluminium gets no sulphide box and caesium no carbonate.
有四个网络是完整写出的——氮、碳、硫和磷——因为在这些元素中,转化本身就是化学,任何模板都承载不了。其余一切都由三种模板之一生成:阳离子、含氧阴离子或有机污染物。元素无法形成的库会被删去而不画出,所以铝没有硫化物框,铯没有碳酸盐框。
Arrows are coloured by what drives the reaction — microbial, physicochemical, plant, gaseous loss, leaching — because that is what decides whether temperature or pH is the lever to pull. A reaction running at under a tenth of its reference rate keeps its arrow but loses its label, so the diagram names the pathways actually working at the conditions set; move a slider and the labels reappear as those reactions start.
箭头按驱动反应的因素着色——微生物、物理化学、植物、气态损失、淋失——因为这决定了该拉动的杠杆是温度还是 pH。运行速率低于其参考速率十分之一的反应保留箭头但去掉标签,这样图上标出的是在所设条件下实际在运作的途径;移动滑块,随着这些反应启动,标签又会重新出现。
The quantified fluxes
定量通量
- Soil solution, for a trace contaminant.
Cw = Ctρ / (θ + ρKd), the same linear equilibrium partitioning as section 4, at the Kd the sliders imply. It is the right calculation here because the tabulated Kd is a total-to-solution partition coefficient; that is what Allison & Allison measured. - Soil solution, for a major or nutrient element. It is not the right calculation there. Nearly all the nitrogen in a soil is organic and nearly all the potassium is locked in feldspar, so partitioning the total would have the whole soil stock draining away every year. For those the model starts from the concentration actually measured in soil solution — 10 mg/L nitrate-N, 20 mg/L dissolved organic carbon, 0.03 mg/L dissolved reactive P — and moves it with the conditions. Those are directly checkable numbers, which is the reason for using them: at 400 mm of drainage the nitrogen figure gives about 40 kg N/ha/yr and a drainage concentration near the drinking-water limit, which is what is measured under New Zealand dairy.
- Leaching.
Cw × drainage × 10 = g/ha/yr, since 1 mm over 1 ha is 10 000 L. This is a matrix-flow estimate and therefore a lower bound: preferential flow down cracks, worm channels and old root holes moves solutes far faster than a Kd predicts, and for a strongly sorbed contaminant that is most of the loss. - Plant uptake of an element.
leaf = TF × soil × √availability × growth, thenofftake = leaf × yield. The square root is a damping term: uptake follows solution activity but is buffered by resupply off the solid phase and by the root's own regulation. It is not arbitrary — for cadmium it reproduces the halving of uptake per unit rise in pH that the plant dataset records independently, which is the closest thing to a calibration check the model has. - Plant uptake of a macronutrient.
offtake = tissue concentration × yield × growth, with the tissue concentration taken as the midpoint of the sufficiency range in the plant dataset. A plant regulates its own tissue concentration and takes up what it needs, so uptake follows the crop rather than the soil, and availability enters only as a supply limitation. For nitrogen that returns 420 kg N/ha/yr at 12 t DM/ha, which is a good pasture. - Plant uptake of an organic.
TSCF × Cw × transpiration × 10, with the transpiration stream concentration factor from Briggs, Bromilow & Evans (1982). Uptake peaks near log Kow 1.8: a very polar compound is not retained by the root and a very hydrophobic one never leaves it.
- 土壤溶液,针对痕量污染物。
Cw = Ctρ / (θ + ρKd),即与第 4 节相同的线性平衡分配,采用滑块所对应的 Kd。在这里这是正确的计算,因为列表中的 Kd 就是全量对溶液的分配系数;Allison & Allison 测的正是这个。 - 土壤溶液,针对主量元素或养分元素。在那里这就不是正确的计算了。土壤中的氮几乎全是有机态,钾几乎全锁在长石中,因此对全量作分配,会让整个土壤储量每年都排走。对这些元素,模型从土壤溶液中实际测得的浓度出发——10 mg/L 硝态氮、20 mg/L 溶解性有机碳、0.03 mg/L 溶解性活性磷——并随条件调整。这些都是可以直接核对的数字,这正是采用它们的理由:在 400 mm 排水量下,氮的数值给出约 40 kg N/ha/yr,排水浓度接近饮用水限值,这与新西兰奶牛场下的实测情况相符。
- 淋失。
Cw × drainage × 10 = g/ha/yr,因为 1 ha 上 1 mm 即 10 000 L。这是基质流估算,因此是下限:沿裂隙、蚯蚓通道和旧根孔的优先流使溶质移动得远比 Kd 预测的快,对强吸附污染物而言,这占了损失的大部分。 - 元素的植物吸收。
leaf = TF × soil × √availability × growth,然后offtake = leaf × yield。平方根是一个阻尼项:吸收随溶液活度变化,但受到固相补给和根系自身调节的缓冲。它并非随意设定——对镉而言,它重现了植物数据集独立记录的 pH 每升高一个单位吸收减半的规律,这是该模型最接近校准检验的东西。 - 大量元素的植物吸收。
offtake = tissue concentration × yield × growth,组织浓度取植物数据集中充足范围的中点。植物会调节自身的组织浓度、按需吸收,因此吸收跟随作物而非土壤,有效性只作为供应限制进入。对氮而言,在 12 t DM/ha 时得到 420 kg N/ha/yr,相当于一片好牧草。 - 有机物的植物吸收。
TSCF × Cw × transpiration × 10,蒸腾流浓度因子取自 Briggs, Bromilow & Evans(1982)。吸收在 log Kow 1.8 附近达到峰值:极性很强的化合物不被根系截留,疏水性很强的化合物则从不离开根系。
All of them depend on a soil concentration. If one has been entered on the Inputs tab that is what is used; otherwise the New Zealand background median for the element, and the tab says which in a flag above the diagram.
所有这些都依赖于一个土壤浓度。如果在“输入”标签页上输入了浓度,就用它;否则用该元素的新西兰本底中位数,标签页会在图上方的标记中注明采用的是哪一个。
Two elements have neither, because the trace-element survey never measured them, and both matter too much to leave blank. Carbon is taken straight from the organic-carbon fraction on the Inputs tab — 2% is 20 000 mg/kg, or 48 t C/ha over 20 cm. Nitrogen is derived from it at a C:N ratio of 12, the middle of the range for a New Zealand pasture topsoil, giving 0.17% total N at the default carbon. Both assumptions are stated on the page, and both follow the organic carbon: change it on the Inputs tab and the whole budget scales with it. A chemical with no concentration from any of these routes keeps its diagram, but every arrow on it becomes an index and no mass flux is reported.
有两种元素两者皆无,因为痕量元素调查从未测定它们,而它们又都重要到不能留空。碳直接取自“输入”标签页上的有机碳分数——2% 即 20 000 mg/kg,或 20 cm 深度内 48 t C/ha。氮由碳按 C:N 比 12 推得,这是新西兰牧场表土范围的中间值,在默认碳含量下得到 0.17% 全氮。两个假设都在页面上注明,而且都跟随有机碳:在“输入”标签页上更改有机碳,整个收支随之按比例变化。无法通过上述任何途径获得浓度的化学物质仍保留其图,但图上每个箭头都变成指数,不报告质量通量。
The rate functions
速率函数
- Microbial rates. Arrhenius, Ea = 65.4 kJ/mol referenced to 20 °C — the FOCUS (2006) kinetics convention — with no activity below 0 °C.
- Degradation. The FOCUS temperature and moisture corrections on the tabulated DT50 from section 5, then the redox regime. Most compounds here degrade aerobically and slow to roughly a sixth of that rate without oxygen; the chlorinated solvents and the organochlorines are dechlorinated reductively instead and speed up as the soil goes anaerobic.
- Salinity. Maas & Hoffman (1977): full yield to 2 dS/m, then 7% lost per dS/m, which is a moderately sensitive crop.
- Volatilisation. Henry's constant, van't Hoff-corrected for temperature, on the fraction in solution and suppressed by water-filled pores. Ammonia is the exception and is done properly, from the NH4+/NH3 equilibrium at pKa 9.25. All of these are indices: a volatilisation rate needs a wind speed and a boundary layer, and neither is on that page.
- 微生物速率。Arrhenius 关系,Ea = 65.4 kJ/mol,参考温度 20 °C——即 FOCUS(2006)的动力学约定——0 °C 以下无活性。
- 降解。先对第 5 节的列表 DT50 施加 FOCUS 温度和湿度校正,再考虑氧化还原状态。这里的大多数化合物是好氧降解的,缺氧时减慢到该速率的约六分之一;氯代溶剂和有机氯则改为还原脱氯,随着土壤变为厌氧反而加快。
- 盐度。Maas & Hoffman(1977):2 dS/m 以内产量不受影响,此后每 dS/m 损失 7%,相当于一种中度敏感作物。
- 挥发。基于亨利常数,按 van't Hoff 关系作温度校正,作用于溶液中的分数,并受充水孔隙抑制。氨是例外,处理得更严格,依据 pKa 9.25 时的 NH4+/NH3 平衡。所有这些都是指数:挥发速率需要风速和边界层,而那个页面上两者都没有。
Coverage
覆盖范围
Thirty-eight elements carry a curated parameterisation — the pH slope, the redox response, the species boundaries and the common New Zealand sources. Every other element in the periodic table falls back to the average behaviour of its class, inferred from the ionic form, and the tab shows a caution flag saying so rather than letting a generic figure pass as a curated one. The organic contaminants are handled from their own Koc, DT50, Henry constant and log Kow, so they need no curation beyond which degradation regime they are in and whether they ionise.
三十八种元素有经过人工整理的参数化——pH 斜率、氧化还原响应、形态边界和新西兰常见来源。元素周期表中的其他元素都退而采用其类别的平均行为,由离子形态推断,标签页会显示注意标记说明这一点,而不是让通用数值冒充经过整理的数值。有机污染物由其自身的 Koc、DT50、亨利常数和 log Kow 处理,因此除了确定其所属的降解状态以及是否电离之外,无需额外整理。
What the model does not do
模型不做什么
It has no time in it. Every flux is a steady-state rate at the conditions set, not a trajectory, and nothing accumulates — the tab will not tell you what a soil will look like in twenty years. It treats the topsoil as one well-mixed box, so preferential flow and the whole question of depth are outside it. Sorption is linear and reversible, which is a poor description of an aged contaminant, and the ageing arrow is drawn precisely to admit it. Competition between ions is not represented: phosphate displacing arsenate off an iron oxide is real, important, and not here. And the five sliders are not independent in the field — drainage sets redox, liming moves pH and conductivity together, and temperature and water flux covary through the season. Moving one at a time is a way of seeing what it does, not a description of a soil that could exist.
它没有时间维度。每个通量都是所设条件下的稳态速率,而不是变化轨迹,也没有任何东西会累积——这个标签页不会告诉你一块土壤二十年后会是什么样子。它把表土当作一个充分混合的箱体,因此优先流以及整个深度问题都在其范围之外。吸附是线性且可逆的,这对老化污染物是很差的描述,画出老化箭头正是为了承认这一点。离子间的竞争没有体现:磷酸盐把砷酸盐从铁氧化物上置换下来,是真实而重要的,但这里没有。而且五个滑块在田间并不相互独立——排水决定氧化还原状态,施石灰会同时改变 pH 和电导率,温度和水通量随季节共同变化。一次移动一个滑块,是观察它作用的一种方式,而不是对一块可能存在的土壤的描述。
9Where the database is weakest数据库最薄弱之处
- The compiled datasets. Plant concentrations, physicochemical constants and toxicological reference values were assembled from standard references rather than machine-read. They are flagged, and the flag is not decoration — check any of them against the primary source before it goes in a report.
- Guideline values go out of date. The US EPA RSLs are revised twice a year. PFAS values have moved by an order of magnitude in five years and will move again. Confirm against the current instrument.
- Soil-property dependence is not modelled. The UK S4ULs depend on organic matter, the New Zealand cadmium standards on pH, the Dutch intervention values on a standard-soil correction, and the Australian EILs for Cr, Cu, Ni and Zn are calculated from pH, CEC and clay content. KiwiChem shows the tabulated value and says so in the Notes column; it does not do the correction.
- PFAS coverage is thin. Only Australia, Canada and the United States have widely used numeric soil values, and US state values span two orders of magnitude for the same compound.
- Regional background is thin outside the four large regions. See section 3.
- Asbestos is absent. It is assessed as % w/w or fibre counts rather than mg/kg, has no meaningful half-life or Kd, and does not fit the data model.
- A Kd is not a constant. The Kd tab gives the measured spread rather than one value, but every row of it is still a generic soil somewhere else: the IAEA means are global, the EPA screening values are modelled on an iron oxide, and the five soils measured the same way are Swedish. New Zealand's allophanic and organic soils sorb most cations more strongly than any of them, and none of these sources measured one. Take the tab as the range to expect and the direction each condition pushes it, and measure the soil you care about if the answer matters.
- The Cycle tab is modelled, not measured. It is one of the two parts of the application where the numbers are not somebody's published values. Section 8 says what it does and what it cannot do; the short version is that it is for seeing which way a flux moves and roughly how far, and nothing off it belongs in a report without being derived properly for the site.
- The Orbitals tab is a construction, and further out still. Nothing on it is a measurement: the orbital energies are tabulated parameters of a semi-empirical method and the interaction terms were fitted to reproduce five textbook diatomics. Read the ordering of the levels and the polarisation of each orbital; treat the electronvolts as indicative; and do not read a bond energy, a bond length or a transition energy off it, because none of the three is computed. The user guide sets it out in section 6.
- No harmonised European values exist. The 2024/2025 Soil Monitoring Law sets monitoring obligations, not concentration limits, so the German, Dutch, Finnish, Swedish, Danish and Norwegian national values are used instead.
- 汇编的数据集。植物浓度、物理化学常数和毒理学参考值是从标准参考文献中整理的,而非机读。它们都带有标记,而这个标记不是装饰——任何一项写进报告之前,都要对照原始来源核实。
- 指导值会过时。US EPA RSL 每年修订两次。PFAS 数值五年内变动了一个数量级,而且还会再变。请对照现行文书确认。
- 未对土壤性质依赖性建模。英国 S4UL 取决于有机质,新西兰镉标准取决于 pH,荷兰干预值依赖标准土壤校正,澳大利亚 Cr、Cu、Ni 和 Zn 的 EIL 则由 pH、CEC 和黏粒含量计算。KiwiChem 显示列表值,并在“备注”列中注明;它不做校正。
- PFAS 覆盖薄弱。只有澳大利亚、加拿大和美国有广泛使用的土壤数值,而美国各州对同一化合物的数值相差两个数量级。
- 四个大区以外的地区本底数据薄弱。见第 3 节。
- 未收录石棉。它以 % w/w 或纤维计数而非 mg/kg 评估,没有有意义的半衰期或 Kd,不适合本数据模型。
- Kd 不是常数。Kd 标签页给出的是实测离散范围而非单一数值,但其中每一行仍然是别处的某种通用土壤:IAEA 平均值是全球性的,EPA 筛选值是在铁氧化物上建模的,按同一方法测定的五种土壤都是瑞典的。新西兰的 Allophanic Soils 和 Organic Soils 对大多数阳离子的吸附都比其中任何一种更强,而这些来源一种都没有测过。请把该标签页当作预期范围以及各条件推动方向的参考;如果答案要紧,就去测你关心的那块土壤。
- “循环”标签页是建模得出的,不是实测的。它是应用中数字并非他人已发表数值的两个部分之一。第 8 节说明它做什么、不能做什么;简而言之,它用来看清通量往哪个方向走、大致走多远,其中任何数字都不应未经针对场地的正规推导就写进报告。
- “轨道”标签页是一个构造,离数据更远。其上没有任何东西是测量值:轨道能量是一种半经验方法的列表参数,相互作用项是为重现五个教科书中的双原子分子而拟合的。请读能级的次序和每个轨道的极化;把电子伏特数值视为指示性的;不要从中读取键能、键长或跃迁能,因为三者都没有计算。用户指南在第 6 节中对其作了阐述。
- 不存在统一的欧洲数值。2024/2025 年的 Soil Monitoring Law 设定的是监测义务,而非浓度限值,因此改用德国、荷兰、芬兰、瑞典、丹麦和挪威的国家数值。
10Checking it yourself自行核查
Open the database, open the browser console, and type KiwiChem.selfTest(). It counts every dataset and verifies that every value in every table resolves to a contaminant in the registry and that every element–contaminant link points at something real. It should report an empty problems array.
打开数据库,打开浏览器控制台,输入 KiwiChem.selfTest()。它会统计每个数据集,并验证每张表中的每个数值都能对应到登记表中的某种污染物,每个元素–污染物链接都指向真实存在的对象。它应当报告一个空的 problems 数组。
To rebuild the data files from the sources in archive/:
要从 archive/ 中的源文件重建数据文件:
python3 scripts/extract.pypython3 scripts/build_elements.pypython3 scripts/build_properties.pypython3 scripts/build_kd.py
The first reads the three workbooks and the geochemical atlas CSV, applies the corrections in scripts/sgv_corrections.py and trims each note to the row it is about. The second builds the periodic table, the plant table and the geology-based background. The third builds the physicochemical and toxicological tables. The fourth builds the Kd tables, and reads data/elements.js, so it runs after the second. None of the generated files in data/ should be hand-edited — edit the source or the script and rebuild.
第一个脚本读取三份工作簿和地球化学图集 CSV,施加 scripts/sgv_corrections.py 中的更正,并把每条注释裁剪到它所针对的那一行。第二个构建元素周期表、植物表和基于地质的本底。第三个构建物理化学表和毒理学表。第四个构建 Kd 表,并读取 data/elements.js,所以要在第二个之后运行。data/ 中生成的文件都不应手工编辑——请编辑源文件或脚本,然后重建。