import folium import streamlit as st import pandas as pd from streamlit_folium import st_folium import time import requests st.set_page_config(layout="wide") if "sleep_time" not in st.session_state: st.session_state.sleep_time = 2 if "auto_refresh" not in st.session_state: st.session_state.auto_refresh = False auto_refresh = st.sidebar.checkbox("Auto Refresh?", st.session_state.auto_refresh) if auto_refresh: number = st.sidebar.number_input("Refresh rate in seconds", value=st.session_state.sleep_time) st.session_state.sleep_time = number #Logo st.markdown( """
""", unsafe_allow_html=True, ) st.title("Nt3awnou نتعاونو ") st.markdown(""" 📝 Help us report more people in need by filling this form: https://forms.gle/nZNCUVog9ka2Vdqu6 : ساعدونا نبلغو الناس ليمحتاجين فهاد الاستمارة ✉️ nt3awnou@annarabic.com المتطوعين ليبغاو يعاونوا يقدرو يتصلوا معنا عبر البريد """) def parse_gg_sheet_interventions(url): df = pd.read_csv(url) def parse_latlng_from_link(url): try: # extract latitude and longitude from gmaps link session = requests.Session() if "@" not in url: # We first need to get the redirect URL resp = session.head(url, allow_redirects=True) url = resp.url latlng = url.split('@')[1].split(',')[0:2] return [float(latlng[0]), float(latlng[1])] except Exception as e: print(f"Error parsing latlng from link: {e}") return None return df.assign(latlng=df.iloc[:, 3].apply(parse_latlng_from_link)) def parse_gg_sheet(url): url = url.replace("edit#gid=", "export?format=csv&gid=") df = pd.read_csv(url) # parse latlng (column 4) to [lat, lng] def parse_latlng(latlng): try: lat, lng = latlng.split(",") return [float(lat), float(lng)] except Exception as e: print(f"Error parsing latlng: {e}") return None return df.assign(latlng=df.iloc[:, 4].apply(parse_latlng)) df = parse_gg_sheet( "https://docs.google.com/spreadsheets/d/1gYoBBiBo1L18IVakHkf3t1fOGvHWb23loadyFZUeHJs/edit#gid=966953708" ) interventions_df = parse_gg_sheet_interventions( "https://docs.google.com/spreadsheets/d/1eXOTqunOWWP8FRdENPs4cU9ulISm4XZWYJJNR1-SrwY/gviz/tq?tqx=out:csv" ) # select requests headers_mapping = { "إغاثة": "Rescue/إغاثة", "مساعدة طبية": "Medical Assistance/مساعدة طبية", "مأوى": "Shelter/مأوى", "طعام وماء": "Food & Water/طعام وماء", "مخاطر (تسرب الغاز، تلف في الخدمات العامة...)": "Danger/مخاطر (تسرب الغاز، تلف في الخدمات العامة...)", } colors_mapping = { "إغاثة": "red", "مساعدة طبية": "orange", "مأوى": "yellow", "طعام وماء": "blue", "مخاطر (تسرب الغاز، تلف في الخدمات العامة...)": "grey", } icon_mapping = { "إغاثة": "bell", # life ring icon for rescue "مساعدة طبية": "heart", # medical kit for medical assistance "مأوى": "home", # home icon for shelter "طعام وماء": "cutlery", # cutlery (fork and knife) for food & water "مخاطر (تسرب الغاز، تلف في الخدمات العامة...)": "Warning" # warning triangle for dangers } options = ["إغاثة", "مساعدة طبية", "مأوى", "طعام وماء", "مخاطر (تسرب الغاز، تلف في الخدمات العامة...)"] selected_options = [] st.markdown("👉 **Choose request type / اختر نوع الطلب**") col1, col2, col3, col4, col5 = st.columns([2, 3, 2, 3, 4]) cols = [col1, col2, col3, col4, col5] for i, option in enumerate(options): checked = cols[i].checkbox(headers_mapping[option], value=True) if checked: selected_options.append(headers_mapping[option]) arabic_options = [e.split("/")[1] for e in selected_options] df['id'] = df.index filtered_df = df[df['ما هي احتياجاتك؟ (أضفها إذا لم يتم ذكرها)'].isin(arabic_options)] selected_headers = [headers_mapping[request] for request in arabic_options] # select interventions st.markdown("👇 **View past or planned interventions / عرض عمليات المساعدة السابقة أو المخطط لها**") show_interventions = st.checkbox("Display Interventions عرض التدخلات", value=True) m = folium.Map( location=[31.228674, -7.992047], zoom_start=8.5, min_zoom=8.5, max_lat=35.628674, min_lat=29.628674, max_lon=-4.992047, min_lon=-10.992047, max_bounds=True, ) if show_interventions: for index, row in interventions_df.iterrows(): status = "Done ✅" if row[interventions_df.columns[5]]=="Intervention prévue dans le futur / Planned future intervention" else "Planned ⌛" color_mk = "green" if row[interventions_df.columns[5]]=="Intervention prévue dans le futur / Planned future intervention" else "pink" intervention_type = row[interventions_df.columns[6]].split("/")[0].strip() org = row[interventions_df.columns[1]] city = row[interventions_df.columns[9]] date = row[interventions_df.columns[4]] intervention_info = f"Status: {status}
Org: {org}
Intervention: {intervention_type}
📅 Date: {date}" print(f"intervention_info: {intervention_info}") folium.Marker( location=row["latlng"], tooltip=city, popup=folium.Popup(intervention_info, max_width=300), icon=folium.Icon(color=color_mk) ).add_to(m) for index, row in filtered_df.iterrows(): request_type = row['ما هي احتياجاتك؟ (أضفها إذا لم يتم ذكرها)'] display_text = f"Request Type: {request_type}
Id: {row['id']}" icon_name = icon_mapping.get(request_type, 'info-sign') if row["latlng"] is None: continue folium.Marker( location=row["latlng"], tooltip=row[' لأي جماعة / قيادة / دوار تنتمون ؟'] if not pd.isna(row[' لأي جماعة / قيادة / دوار تنتمون ؟']) else None, popup=folium.Popup(display_text, max_width=300), icon=folium.Icon(color=colors_mapping.get(request_type, "blue"), icon=icon_name) ).add_to(m) st_data = st_folium(m, use_container_width=True) # Google Sheet Table st.subheader("📝 **Table of requests / جدول الطلبات**") st.markdown( """ """, unsafe_allow_html=True, ) # Google Sheet Table st.subheader("📝 **Table of interventions / جدول التدخلات**") st.markdown( """ """, unsafe_allow_html=True, ) # Google Form # st.markdown( # """ # # """, # unsafe_allow_html=True, # ) # Credits st.markdown( """

By Moroccans for Moroccans 🤝

Powered by Annarabic

Collaboration made possible thanks to AI Summer School

""", unsafe_allow_html=True, ) if auto_refresh: time.sleep(number) st.experimental_rerun()