File size: 1,808 Bytes
4d0d437 | 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 | import streamlit as st
st.markdown(
"""
# Multi Points Distance Calculator Documentation
## 1. Objective
Calculate distances between two datasets of points and identify closest matches.
## 2. When to use this tool
Use this page to compare reference sites against candidate/neighbor sites and find nearest pairs.
## 3. Input files and accepted formats
- Required: Dataset 1 in `.xlsx`
- Required: Dataset 2 in `.xlsx`
- Samples: `samples/Dataset1.xlsx`, `samples/Dataset2.xlsx`
## 4. Required columns/fields
For each dataset, select:
- code column
- latitude column
- longitude column
## 5. Step-by-step usage
1. Open `Apps > Multi Points Distance Calculator`.
2. Upload both Excel datasets.
3. Select code/latitude/longitude columns for each dataset.
4. Set minimum distance threshold (km).
5. Click `Calculate Distances`.
6. Review closest matches and download CSV outputs.
## 6. Outputs generated
- closest matches table
- closest matches below threshold table
- downloadable files:
- `all_distances.csv`
- `closest_matches.csv`
- `closest_matches_<threshold>km.csv`
## 7. Frequent errors and fixes
- Processing error after upload.
- Fix: verify selected columns and coordinate formats.
- No close matches below threshold.
- Fix: increase threshold value.
- Unexpected distances.
- Fix: ensure coordinates are decimal degrees.
## 8. Minimal reproducible example
- Input: `Dataset1.xlsx` and `Dataset2.xlsx` samples.
- Action: select columns and run with threshold `5 km`.
- Expected result: closest matches plus downloadable CSV files.
## 9. Known limitations
- Only `.xlsx` inputs are supported.
- Quality depends on coordinate accuracy.
- Large datasets may take longer to compute.
## 10. Version and update date
- Documentation version: 1.0
- Last update: 2026-02-23
"""
)
|