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