Skip to content

Case study · Conversational explorer for ARGO ocean data

Float-Chat

Ask about ARGO ocean data in plain English: a local LLM writes PostgreSQL/PostGIS queries with RAG context from ChromaDB, and a Streamlit dashboard plots the results. Built for Smart India Hackathon 2025.

By · Updated

Float-Chat dashboard answering “What are the nearest floats to Delhi, India?” and plotting ARGO float locations on a map

The problem

ARGO floats record temperature, salinity and pressure across the world’s oceans, but the data ships as multidimensional NetCDF files that take both oceanography and programming skills to explore.

Smart India Hackathon 2025 problem SIH25040, from the Ministry of Earth Sciences, asked for a conversational interface to this data. In Float-Chat, anyone from researchers to policymakers asks a question in plain English and gets an answer, the data behind it and charts.

Data pipeline

  • xarray reads each ARGO NetCDF file; temperature, salinity, pressure, time and location are flattened into tables with pandas.
  • Rows are bulk inserted into PostgreSQL with a PostGIS geometry column, so location questions become fast spatial queries.
  • Each float gets a short plain English summary of its metadata, embedded and stored in ChromaDB as retrieval context.

How a question is answered

  • The question is embedded and matched against the float summaries in ChromaDB (retrieval augmented generation, or RAG).
  • The prompt (SQL rules and examples, the schema, the retrieved context and the question) goes to a local LLM through LangChain and Ollama.
  • The model returns a PostgreSQL query, which runs against the database.
  • The model summarises the results in plain language, and the Streamlit dashboard shows the answer, a table and Plotly charts: a map, depth profiles and time series.

Design decisions

  • SQL instead of recall. The vector store holds only float metadata for context; exact values come from SQL over the measurements, so answers are computed from the data.
  • PostGIS for spatial questions such as “What are the nearest floats to this location?”.
  • Local and private. The model runs through Ollama on the same machine, so there are no paid API keys and the data stays local.

Limitations and next steps

Float-Chat is a hackathon prototype that runs locally with PostgreSQL and Ollama installed. Next steps listed in the repository: NetCDF and ASCII export, more in situ datasets (BGC floats, gliders, buoys), satellite data and caching frequent questions.