Presented by:

Aabe002254f14a9aa9d8d7fb64d6d3d4

Asim Rama Praveen

from IIT Bombay

As a software consultant aka project staff at Department of Computer Science and Engineering, IIT Bombay, I write software for developmental problems with a team of multidisciplinary professionals, academicians and students. Previously, I was a Greenplum (fork of PostgreSQL for MPP) developer.

GitLab, GitHub: asimrp

8b174a0f5114ac88eebebf08c3bb3c34

Sameer Mannava

from Indian Institute of Technology Bombay

I'm an undergraduate student in the Electrical Engineering Department at the Indian Institute of Technology, Bombay. I develop software at a research level in the fields of geographic information systems and robotics.

No video of the event yet, sorry!

At IIT Bombay, we are working with the Maharashtra Department of Agriculture on building climate resilience in agriculture of rural Maharashtra. A crucial input for agriculture is rainfall. We've built a model to compute distribution of rainfall into various components such as crop water uptake, soil moisture, groundwater recharge and surface runoff. Using PostgreSQL and PostGIS, we are able to deploy this model at scale, to ingest hourly rainfall data from 1400+ weather stations on a daily basis, spanning more than 20,000 villages within Maharashtra. The results are providing key insights into the state of agriculture at village level. PostgreSQL enables aggregation of the results over any administrative region, such as a village, a revenue circle, a taluka or a district. Using pg_tileserv exetnsion and GeoServer, the results can be rendered as maps, suitable for decision making at various levels within the DoA.

As part of this talk, we look forward to sharing technical details of our geospatial stack, a sample of spatial queries we are using, and a few lessons learned.

Co-authored-by: Sameer Mannava sameer.mannava7@gmail.com, B.Tech. student at IIT Bombay.

Date:
2024 February 29 - 15:30
Duration:
40 min
Room:
Robusta + Arabica
Conference:
PGConf India, 2024
Language:
Track:
Case Study
Difficulty:
Easy

Happening at the same time:

  1. How to Unleash the Power of PostgreSQL in the Cloud
  2. Start Time:
    2024 February 29 15:30

    Room:
    Grand Victoria B

  3. PostgreSQL parameter performance optimization: From manual tuning to autotuning
  4. Start Time:
    2024 February 29 15:30

    Room:
    Grand Victoria A