Government Schools Distance Analysis System

System Overview

This system analyzes the distances between government schools and BEC, NHCD, and BEF schools to identify which schools are nearest to each government school.

Government Schools Data

Choose Government Schools File CSV or Excel

Expected Columns:

BemisCode
School Name
X-Cord, Y-Cord
District, Tehsil, UC
Level, Gender, Enrollmen
Space for new Rooms, Total Rooms
Toilets, Boundry wall, Drinking Water

BEC / NHCD / BEF Schools Data

Choose BEC/NHCD/BEF Schools File CSV or Excel

Expected Columns:

BemisCode
SchoolName
Division, District, Tehsil
Gender, SchoolLevel
FunctionalStatus
Student Count, Source
_xCord, _yCord
School Owned

Key Features

Distance Calculation

Precise haversine distance calculation between government schools and special schools

Nearest School Detection

Identifies the nearest BEC, NHCD, and BEF school for each government school

Comprehensive Analysis

Detailed summary statistics and distance range breakdowns

Interactive Map

Visual representation of all schools with distance connections

Excel Export

Download complete analysis report in Excel format

Map Export

Save interactive maps as HTML files for offline viewing