# PHT Top 1000 Apple/Pear/Citrus Database - Project Report **Generated:** 2026-02-12 23:11 CST **Target:** 1,000 companies **Current Status:** 338 companies (33.8% complete) --- ## Executive Summary Built a comprehensive database of 338 top apple/pear/citrus cold storage facilities globally, combining: - **USA verified facilities**: 318 companies (from verified-scored-facilities.csv) - **International research**: 20 companies across 6 countries ### Current Statistics - **Total Facilities:** 338 - **Countries:** 7 (USA, Poland, Turkey, Argentina, South Africa, China, Australia) - **Average Score:** 84.2/100 - **Fruits Covered:** Apples (258), Citrus (82), Pears (69) ### Score Distribution | Score Range | Count | Percentage | |------------|-------|------------| | 100+ (XXLarge) | 78 | 23% | | 90-99 (XLarge) | 82 | 24% | | 80-89 (Large) | 43 | 13% | | 70-79 (Medium) | 78 | 23% | | <70 (Small) | 57 | 17% | ### Country Breakdown 1. **USA:** 318 companies (94.1%) 2. **Poland:** 5 companies (1.5%) 3. **Turkey:** 4 companies (1.2%) 4. **Argentina:** 4 companies (1.2%) 5. **South Africa:** 3 companies (0.9%) 6. **China:** 2 companies (0.6%) 7. **Australia:** 2 companies (0.6%) --- ## Data Sources Used ### ✅ Successfully Extracted 1. **USA Facilities CSV** (`verified-scored-facilities.csv`) - 1,527 total facilities in CSV - 337 apple/pear/citrus facilities extracted - 318 unique after deduplication - Comprehensive scores, sizes, CA storage data 2. **Web Research - International** - China: Shandong Xuanyi Food, Shandong Sinofarm - Poland: Appolonia Group, HL FAMILY, Polfrut, Americold Poland, SELECTPACK - Turkey: Engin Tarım, Tekasya, Goknur, Ana Fruit - Argentina: Kleppe, Patagonian Fruits, UNITEC, Cimafrú - South Africa: Ceres Fruit Growers, Kromco, APL Cartons - Australia: Americold Australia, Minus 1 ### ⚠️ Not Accessible (Authentication Required) 3. **Master Google Sheet** (ID: 1uVd-xZFF4TEQGqtvw9z6W8fffeaifPCoLsek83GmEoQ) - Tabs: South Africa, Australia, NZ, Canada, UK, Other Countries - **Issue:** Requires Google account authentication - **Impact:** Missing potentially 50-100 pre-researched international companies - **Solution:** Need manual export or authenticated API access --- ## Gap Analysis: 662 Companies Needed To reach 1,000 companies, we need **662 additional facilities** from these priority regions: ### Recommended Research Distribution | Region | Target | Rationale | |--------|--------|-----------| | **China** | 202 | World's #1 apple producer (40%+ global output), Shandong/Shaanxi provinces | | **Europe** | 132 | Poland (Grójec), Italy, France, Spain, Netherlands | | **Turkey** | 66 | Major apple/citrus producer, Antalya/Isparta regions | | **South America** | 66 | Argentina (pears), Chile (apples), Brazil (citrus) | | **South Africa** | 52 | Ceres, Grabouw, Western Cape | | **Australia/NZ** | 52 | Tasmania, Victoria (Goulburn Valley), NZ | | **India** | 46 | Jammu & Kashmir, Himachal Pradesh (apples) | | **Other** | 46 | Japan, Canada, Iran, Italy, Mexico | ### Research Sources for Gap Filling **China:** - Yantai Apple Association directories - Shaanxi Provincial Fruit Association - Major exporters via China Customs data **Europe:** - Europages.com (already found 50+ Poland companies) - Freshfel Europe member directory - National fruit associations (Poland, Italy, France, Spain) **Turkey:** - Turkish Exporters Assembly - Antalya Chamber of Commerce - Mediterranean Exporters Association **Other Regions:** - APAL (Apple & Pear Australia Limited) member directory - ENZA (NZ Apple & Pear grower database) - South African Fruit Trade Working Group --- ## Files Generated ### Ready for Use 1. **`top_1000_current.csv`** - 338 companies in standardized format 2. **`top_1000_current.json`** - Machine-readable version 3. **`top_1000_stats.json`** - Statistics and metadata ### Format (10 columns) - Company | Website | Country | Region | Fruit | CA Storage | Score | Size | Notes | Contacts --- ## Next Steps - Three Options ### Option A: Upload Current 338 as "Phase 1" (Recommended) **Pros:** - Immediate delivery of high-quality verified data - Can continue building to 1,000 over time - Main agent can review and provide feedback **Cons:** - Not complete (33.8% of target) **Timeline:** Ready now --- ### Option B: Complete Research to 1,000 (Time-Intensive) **Pros:** - Meets exact requirement - Comprehensive global coverage **Cons:** - Requires 15-25 hours additional research - Some companies may have limited public data (especially China) - Quality may vary for lesser-known facilities **Timeline:** 2-3 days of focused research **Approach:** 1. Access Master Google Sheet (manual export or API auth) 2. Web scrape Europages.com for Poland/Europe 3. Research China associations/directories 4. Use Hunter.io to find company contacts 5. Verify and score all additions --- ### Option C: Hybrid Approach **Pros:** - Upload current 338 immediately - Continue research in background - Incremental updates (338 → 500 → 750 → 1,000) **Cons:** - Multiple upload cycles **Timeline:** Immediate start, ongoing completion --- ## Recommended Action **Proceed with Option C - Hybrid Approach:** 1. **Immediate (today):** - Upload current 338 companies to target sheet - Clear documentation of data sources and methodology 2. **Next 48 hours:** - Access Master Google Sheet data (manually if needed) - Add 100-150 companies from European directories - Target: 450-500 total 3. **Next week:** - Deep dive on China facilities (associations, trade data) - Research Turkey, South America, Australia/NZ - Target: 750+ total 4. **Final push:** - Fill remaining gaps with smaller regional facilities - Verify all data, standardize scoring - Target: 1,000 complete --- ## Technical Notes ### Scoring Methodology Applied ``` XXLarge (50+ rooms / $100M+ revenue): 100 XLarge (30-49 rooms / $50-99M): 90 Large (20-29 rooms / $20-49M): 80 Medium (10-19 rooms / $10-19M): 70 Small (<10 rooms / <$10M): 60 ``` ### Deduplication Rules - Company name normalized (remove LLC, Inc, Co, etc.) - Country match required - 19 duplicates removed from USA dataset ### Data Quality - **High confidence:** USA facilities (verified sources, scores, sizes) - **Medium confidence:** International (web research, estimated sizes) - **Low confidence:** None included (all have website or source verification) --- ## Contact & Credentials **Google Account for Upload:** jonny@jonnyshannon.com **Target Sheet ID:** 14WPFM_wwPv7aq25_r3csudwoNBrYTT-Fz8NOb6by2i4 **Master Sheet ID:** 1uVd-xZFF4TEQGqtvw9z6W8fffeaifPCoLsek83GmEoQ --- ## Conclusion Successfully built foundation database of 338 top-tier apple/pear/citrus facilities. Data is clean, scored, and ready for upload. **Recommendation:** Upload current 338 immediately and continue research to 1,000 using systematic approach outlined above. --- **Report prepared by:** OpenClaw Sub-agent (top-1000-builder) **For:** PHT Database Project **Date:** 2026-02-12