Geo-analytic Patient Tracking Web-App Development

Project Title Web-Based Patient Location Mapping App (Excel Upload + Heatmap) Project Description I am looking for an experienced web developer to build a web-based application that allows me to upload an Excel file containing patient details (Name + Pincode) and automatically generate a map showing where my patients are coming from. The purpose of this app is to analyze patient distribution geographically, identify areas with high patient density, and understand which locations need more advertising and outreach. Core Features Required 1. Excel File Upload Upload Excel files (.xlsx or .csv) File will contain: Patient Name Pincode (Indian postal codes) The system should validate the file and handle basic errors (missing pincode, invalid format) 2. Pincode-to-Location Mapping Convert pincodes into geographic coordinates (latitude & longitude) Use a reliable geolocation API (Google Maps, OpenStreetMap, Mapbox, etc.) Handle duplicate pincodes efficiently 3. Interactive Map Visualization Display an interactive map with: Pins showing patient locations Clustering for areas with many patients Ability to zoom in/out Hover or click on pins to see: Number of patients from that area (Optional) List of patient names 4. Patient Density / Heatmap View Heatmap to visualize: Areas with the highest patient concentration Areas with low or no patient presence Toggle between: Pin view Heatmap view 5. Insights & Analysis Summary showing: Top pincodes/areas by patient count Total number of patients uploaded This data will help identify: High-performing areas Locations where more advertising is needed Technical Requirements Web-based app (desktop & mobile friendly) Backend for file processing and data handling Frontend with clean, easy-to-use UI Secure handling of uploaded files Prefer scalable and well-documented code Preferred Tech Stack (Open to Suggestions): Frontend: React / Vue / HTML + JS Backend: Node.js / Python (Flask or Django) Mapping: Google Maps API / OpenStreetMap / Mapbox Database (optional for saving uploads): MySQL / PostgreSQL / MongoDB Optional Features (Bonus) Filter by date (if future uploads include visit dates) Export map or reports as PDF/image Save multiple uploads and compare different time periods Admin login system

Proje No: 40083230