> **From:** Assel Nurzhanova <a.nurzhanova@astanagrain.kz> > **Subject:** Data project -- storage + weather correlation > > Hello, > > I am Assel Nurzhanova, Operations Director at Astana Grain Terminal. We operate two grain elevators in Kostanay region -- 120,000 tonnes combined capacity, primarily wheat, barley, and flax for export. > > We have a storage management system that logs everything: bin occupancy, grain type, moisture readings, farmer accounts, arrival and dispatch dates. The system exports CSV files daily. I have 18 months of these exports. > > My problem is spoilage. We lost approximately 800 tonnes over the past two years to moisture damage and temperature-related degradation. I believe this correlates with weather patterns -- sudden temperature drops, humidity spikes -- but I have no way to prove it because our weather data is someone writing numbers from a website into a notebook. > > I need two things combined: our storage data and weather data for our location. I want weather data pulled automatically from a weather API -- daily temperature (min, max, average), humidity, and precipitation. I want to see this alongside our storage readings so I can identify which conditions cause spoilage. > > I also need proper reporting on storage utilization -- which bins are full, what grain is where, how long it has been stored, whose grain it is. Right now I have this in CSV files but I cannot easily query across months or across both elevators. > > I have attached one month of storage data from Elevator A as a sample. Elevator B follows a similar format. I can provide the full 18-month archive when we start. > > We need this running as a daily process. Monthly reports are too slow -- spoilage happens in days. > > Regards, > Assel Nurzhanova