Testing Produce Market Data Integration

1. Fetching Latest Terminal Market Reports...
✅ Success! Found 48 produce reports

Available Reports:
  - [2391] Fresno Shipping Point Vegetables Prices (FR_FV120)
    Published: 2026-09-11 08:54:50 MDT
  - [2412] YAKIMA Shipping Point Fruit Prices (YA_FV110)
    Published: 2026-09-10 16:21:30 MDT
  - [2403] Phoenix Shipping Point Vegetables Prices (IX_FV120)
    Published: 2026-09-10 16:12:08 MDT
  - [2402] Phoenix Shipping Point Fruit Prices (IX_FV110)
    Published: 2026-09-10 15:27:01 MDT
  - [2394] Inwood Shipping Point Fruit Prices (MB_FV110)
    Published: 2026-09-10 14:56:49 MDT
  - [2390] Fresno Shipping Point Fruit Prices (FR_FV110)
    Published: 2026-09-10 14:47:25 MDT
  - [2926] National Potato and Onion Report (FVDIDNOP)
    Published: 2026-09-10 14:30:56 MDT
  - [2393] Idaho Falls Shipping Point Onions and Potatoes Prices (IF_FV130)
    Published: 2026-09-10 14:18:04 MDT
  - [2306] Los Angeles Terminal Market Fruit Prices (HC_FV010)
    Published: 2026-09-10 14:06:44 MDT
  - [2303] Detroit Terminal Market Vegetables Prices (DU_FV020)
    Published: 2026-09-10 13:19:07 MDT

2. Getting Report Details (New York Fruit)...
✅ Report Found:
  - Title: New York Terminal Market Fruit Prices (NX_FV010)
  - File: nx_fv010.pdf
  - Date: 2026-09-10
  - Note: Actual prices are in PDF format

3. Getting Sample Produce Prices (Mock Data)...
Note: Real implementation would parse PDFs or use manual data entry

Sample Fruit Prices (New York Market):
  - Apples - Red Delicious (Washington)
    Package: 40 lb carton
    Price: $28.00 - $32.00/carton

  - Oranges - Navel (California)
    Package: 40 lb carton
    Price: $24.00 - $28.00/carton

  - Bananas (Ecuador)
    Package: 40 lb carton
    Price: $18.00 - $20.00/carton

  - Strawberries (California)
    Package: flat 8 1-lb containers
    Price: $14.00 - $18.00/flat

  - Avocados - Hass (Mexico)
    Package: 2 layer carton
    Price: $42.00 - $48.00/carton

Sample Vegetable Prices (New York Market):
  - Tomatoes - Vine Ripe (Florida)
    Package: 25 lb carton
    Price: $16.00 - $20.00/carton

  - Lettuce - Iceberg (California)
    Package: carton 24s
    Price: $22.00 - $26.00/carton

  - Broccoli - Crown Cut (California)
    Package: 20 lb carton
    Price: $24.00 - $28.00/carton

  - Carrots - Jumbo (California)
    Package: 50 lb sack
    Price: $26.00 - $30.00/sack

  - Peppers - Green Bell (Mexico)
    Package: 1 1/9 bushel carton
    Price: $18.00 - $24.00/carton

4. Testing Database Integration...
✅ Produce Service initialized
  - Market: new_york
  - Fruit items: 5
  - Vegetable items: 5
  - Latest reports: 48

Summary:
========
• USDA provides terminal market reports in PDF format
• Real-time JSON/CSV data not available for fruits/vegetables
• Reports available for major markets: NY, Chicago, LA, Miami, etc.
• Implementation options:
  1. PDF parsing (complex but automated)
  2. Manual data entry from PDFs
  3. Web scraping (if HTML version available)
  4. Third-party data providers

View Produce Dashboard | Livestock Dashboard