System design for physical AI: one agriculture data dashboard the operator fully owns

Farm sensor feeds, historical datasets and an analytics repository joined into a twelve object model in PostgreSQL with PostGIS, on the operator's own servers, with the source code handed over.