justin
b98965a68a
Adds the **first non-Syngenta trial coverage** to the corpus:
| Source | Docs | Publisher | URL pattern |
|---|---|---|---|
| lg_plot_reports | 1,304 | LG Seeds (AgReliant) | lgseeds.com/performance/{crop} JSON XHR |
| agrigold_plot_reports | 1,003 | AgriGold (AgReliant) | agrigold.com/{crop}/performance/{crop}-yield-results |
Total trial coverage now: gh_plot_reports (4,299) + agripro_trials (14) +
lg_plot_reports (1,304) + agrigold_plot_reports (1,003) = 6,620 trial docs.
**Both scrapers follow the gh_plot_reports template** — same RateLimitedSession
primitive, same TrialResult/PlotReport dataclass shape, same data_type="trial"
sidecar convention. The trial chunker (`rag/chunk.py:_render_trial_chunk`) is
extended to recognize both new sources; they share `_render_gh_plot_chunk`
since their sidecars are structurally identical (just different brand label).
**LG specifics:**
- POST `/performance/{crop}/GetPlots/` returns sparse listing (id, year, lat/lng)
- GET `/performance/{crop}/GetPlotData/?PlotId=X&IsSilage=Y` returns full detail
with state, cooperator, planting/harvest dates, and **top-5 hybrids** (LG +
competitors). Top-5 is what LG publishes publicly; not the full ranking.
- 4 crops: corn (963), soybeans (287), sorghum (10), silage (50) — first
alfalfa absent because LG doesn't run alfalfa plots; that's variety-only data.
- 301 gotcha: www.lgseeds.com redirects to lgseeds.com which drops POST body,
so the scraper hits the apex host directly.
**AgriGold specifics:**
- Listing: GET `/{crop}/performance/{crop}-yield-results?harvestYear={year}`
(server-rendered HTML, ~1MB; 408 corn plots in 2025 alone)
- Detail: GET `/{crop_url}/performance/{slug}/{plot_id}` returns the **full
ranking** (not just top-5) plus rich plot management metadata: tillage,
previous crop, fungicide, herbicide, insecticide, irrigation, soil type,
row width, population. Most metadata-rich of the three trial sources.
- Soybean URL slug is singular: `/soybeans/performance/soybean-yield-results/`
- Columns: Rank | Brand | Product | Trait | Ck | H20 (moisture) | Test Wt. |
Yield | Adj Yield (check-adjusted)
- 2 crops: corn (849) + soybeans (157)
**Indexer needs no changes** — `rag/index.py` auto-discovers any directory
under corpus/ and routes by data_type. Both new sources flow into the
existing trial collection and surface via `search_trials`.
Years scraped: 2024+2025 (matching gh_plot_reports baseline). 2023 is
available via `--include-2023` on either scraper for future backfill.
3.4 KiB
3.4 KiB
Soybean yield trial — Henderson, KY, 2024
- Source: AgriGold plot report (cross-vendor head-to-head)
- Vendor: AgReliant Genetics / AgriGold
- Crop: Soybean
- State: KY
- County: Henderson
- City: Henderson
- Year: 2024
- Plot ID: 144577
- Cooperator: PARRISH SHOP & SALES LLC
- Plot average: 89.08 BU/Ac
- Planted: 2024-06-07
- Harvested: 2024-10-18
- Population: 130,000 seeds/acre
- Row width: 15.0"
- Soil type: Silt Loam
- Tillage: Minimum
- Previous crop: Corn
- Irrigation: None
- Fungicide: Lucento
- Herbicide: Anthem
- Insecticide: Hero
- URL: https://www.agrigold.com/soybeans/performance/soybean-yield-results/144577
Results (by rank)
| Rank | Brand | Product | Trait | Ck | H20 | Test Wt. | Yield | Adj Yield |
|---|---|---|---|---|---|---|---|---|
| 1 | Pioneer | P47Z15BE | Enlist E3 | - | 10.5 | 55.5 | 101.9 | 101.9 |
| 2 | Pioneer | P48A14E | Enlist E3 | - | 10.3 | 56.1 | 97.7 | 97.7 |
| 3 | AgriGold | G4184XF | XTENDFlex | - | 10.8 | 54.8 | 94.9 | 94.9 |
| 4 | AgriGold | G4430XF | XTENDFlex | - | 11.1 | 54.8 | 94.8 | 94.8 |
| 5 | Catalyst | CT4413E3S | Enlist/STS | - | 10.8 | 55.0 | 94.0 | 94.0 |
| 6 | AgriGold | G4051E3 | Enlist E3 | - | 10.8 | 54.4 | 93.7 | 93.7 |
| 7 | Xitavo | XO4405E | Enlist E3 | - | 10.8 | 56.0 | 93.0 | 93.0 |
| 8 | Pioneer | P45A81E | Enlist E3 | - | 10.6 | 55.8 | 92.8 | 92.8 |
| 9 | Pioneer | P49Z02E | Enlist E3 | - | 10.6 | 55.1 | 92.6 | 92.6 |
| 10 | Revere | X39-E71 | Enlist E3 | - | 10.8 | 55.3 | 92.4 | 92.4 |
| 11 | Pioneer | P45Z75E | Enlist E3 | - | 10.6 | 55.0 | 92.1 | 92.1 |
| 12 | Pioneer | P42A84E | Enlist E3 | - | 10.7 | 55.7 | 91.8 | 91.8 |
| 13 | AgriGold | G4204E3 | Enlist E3 | - | 11.8 | 54.1 | 91.6 | 91.6 |
| 14 | Xitavo | XO4255E | Enlist E3 | - | 10.5 | 54.3 | 91.4 | 91.4 |
| 15 | Pioneer | P37A18E | Enlist E3 | - | 11.4 | 54.0 | 91.2 | 91.2 |
| 16 | Pioneer | P38A28E | Enlist E3 | - | 11.5 | 54.4 | 91.0 | 91.0 |
| 17 | Pioneer | P40Z57E | Enlist E3 | - | 11.1 | 53.0 | 90.1 | 90.1 |
| 18 | Revere | 44-F44 | XTENDFlex | - | 10.3 | 54.7 | 89.6 | 89.6 |
| 19 | Pioneer | P37Z06E | Enlist E3 | - | 11.1 | 55.5 | 88.7 | 88.7 |
| 20 | AgriGold | G3577E3 | Enlist E3 | - | 11.8 | 52.6 | 88.6 | 88.6 |
| 21 | AgriGold | G4459E3 | Enlist E3 | - | 10.9 | 55.7 | 88.5 | 88.5 |
| 22 | Pioneer | P43Z44SE | Enlist/STS | - | 10.7 | 55.4 | 88.2 | 88.2 |
| 23 | AgriGold | G3552XF | XTENDFlex | - | 12.0 | 53.7 | 86.8 | 86.8 |
| 24 | Pioneer | P38Z63 | Enlist E3 | - | 11.5 | 54.2 | 86.7 | 86.7 |
| 25 | AgriGold | G3854E3 | Enlist E3 | - | 11.6 | 53.0 | 85.9 | 85.9 |
| 26 | Revere | X36-E54 | Enlist E3 | - | 11.2 | 54.8 | 85.7 | 85.7 |
| 27 | AgriGold | G4094XF | XTENDFlex | - | 11.2 | 52.8 | 85.4 | 85.4 |
| 28 | Xitavo | XO3855E | Enlist E3 | - | 11.1 | 54.3 | 83.6 | 83.6 |
| 29 | Xitavo | XO4364E | Enlist E3 | - | 10.8 | 53.8 | 83.3 | 83.3 |
| 30 | AgriGold | G3724XF | XTENDFlex | - | 11.6 | 54.8 | 83.0 | 83.0 |
| 31 | AgriGold | G3804XF | XTENDFlex | - | 11.9 | 53.3 | 82.1 | 82.1 |
| 32 | Pioneer | P34A98E | Enlist E3 | - | 11.1 | 54.2 | 81.8 | 81.8 |
| 33 | Revere | 3908XFS | XTENDFlex/STS | - | 10.6 | 54.4 | 81.6 | 81.6 |
| 34 | Xitavo | XO3655E | Enlist E3 | - | 11.4 | 54.3 | 81.4 | 81.4 |
| 35 | Apex | AE4341S | Enlist/STS | - | 10.9 | 54.5 | 79.8 | 79.8 |
Top 5 by Yield: P47Z15BE (Pioneer) 101.9, P48A14E (Pioneer) 97.7, G4184XF (AgriGold) 94.9, G4430XF (AgriGold) 94.8, CT4413E3S (Catalyst) 94.0.