import streamlit as st
import streamlit.components.v1 as components
import pandas as pd
import json
st.set_page_config(layout="wide")
st.title("🧲 CesiumJS Footfall Drag-Drop Demo")
# Load footfall data
df = pd.read_excel("data/jj_with_footfall.xlsx").dropna(subset=["latitude", "longitude"])
features = [
{
"type": "Feature",
"geometry": {
"type": "Point",
"coordinates": [row["longitude"], row["latitude"]],
}
}
for _, row in df.iterrows()
]
geojson_str = json.dumps({"type": "FeatureCollection", "features": features})
html_code = f"""
Cesium Draggable Footfall
"""
components.html(html_code, height=700)