Purpose <p>The rapid advancement of Internet of Things (IoT) technologies has significantly augmented data generation, particularly in the geographic sphere. This investigation confronts the pivotal issue of effective data management in IoT-integrated healthcare applications, with a specific emphasis on Telangana’s ‘Medicine from the Sky’ initiative, which employs Beyond Visual Line of Sight (BVLoS) flights to facilitate the delivery of medical supplies to isolated regions.</p> Methods <p>Acknowledging the constraints of prevailing data retrieval methodologies, this study introduces an innovative hybrid indexing approach that combines the advantages of bitmap indexing and R-tree indexing to enhance the data retrieval efficacy.</p> Results <p>The proposed methodology employs PostgreSQL in conjunction with the PostGIS extension and Python for performance assessment, illustrating the efficacy of the hybrid indexing technique.</p> Conclusions <p>The outcomes of this research contribute to the formulation of effective data management frameworks within IoT applications, especially in the healthcare sector, thereby improving the accessibility and prompt delivery of vital medical supplies to marginalized communities.</p>