Google maps url to the coordinates

app.py

@@ -8,7 +8,6 @@ import streamlit as st
 from streamlit_folium import st_folium
 from utils import legend_macro
 from huggingface_hub import HfApi
-from folium import plugins
 
 
 TOKEN = os.environ.get("HF_TOKEN", None)
@@ -94,33 +93,28 @@ def parse_latlng_from_link(url):
         return None
     
 def parse_gg_sheet_interventions(url):
-    url = url.replace("edit#gid=", "export?format=csv&gid=")
-    print(url)
-    df = pd.read_csv(url, on_bad_lines='skip')
+    df = pd.read_csv(url)
     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=")
-    print(url)
-    df = pd.read_csv(url, on_bad_lines='warn')
+    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
-    if df.shape[1] > 4:
-        df = df.assign(latlng=df.iloc[:, 4].apply(parse_latlng))
-    return df
+        except Exception:
+            return parse_latlng_from_link(latlng)
+
+    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/edit#gid=2089222765"
+    "https://docs.google.com/spreadsheets/d/1eXOTqunOWWP8FRdENPs4cU9ulISm4XZWYJJNR1-SrwY/gviz/tq?tqx=out:csv"
 )
 
 # select requests
@@ -178,21 +172,6 @@ m = folium.Map(
     max_bounds=True,
 )
 
-# Add a search bar to the map
-plugins.Geocoder(
-    collapsed=False,
-    position="topright",
-    placeholder="Search | البحث",
-).add_to(m)
-
-# Add Fullscreen button to the map
-plugins.Fullscreen(
-    position='topright',
-    title='Expand me | تكبير الخريطة',
-    title_cancel='Exit me | تصغير الخريطة',
-    force_separate_button=True
-).add_to(m)
-
 #Satellite View from Mapbox 
 tileurl = 'https://api.mapbox.com/styles/v1/phd2020/clmer2mra01d001pbgjkictpt/tiles/256/{z}/{x}/{y}@2x?access_token=pk.eyJ1IjoicGhkMjAyMCIsImEiOiJja29lZzFwZmUwNHkzMm5wMjZnYjVvcGltIn0.tE0ritrelQOyLdKUH6hgOw'
 
@@ -228,7 +207,9 @@ if show_interventions:
 
 for index, row in filtered_df.iterrows():
     request_type = row['ما هي احتياجاتك؟ (أضفها إذا لم يتم ذكرها)']
-    display_text = f"<b>Request Type:</b> {request_type}<br><b>Id:</b> {row['id']}"
+    long_lat = row['هل يمكنك تقديم الإحداثيات الدقيقة للموقع؟ (ادا كنت لا توجد بعين المكان) متلاً 31.01837503440344,-6.781405948842175']
+    maps_url = f"https://maps.google.com/?q={long_lat}"
+    display_text = f'<b>Request Type:</b> {request_type}<br><b>Id:</b> {row["id"]}<br><a href="{maps_url}"><b>Google Maps</b></a>'
     icon_name = icon_mapping.get(request_type, 'info-sign') 
     if row["latlng"] is None:
         continue
@@ -302,4 +283,4 @@ st.markdown(
 )
 if auto_refresh:
     time.sleep(number)
-    st.experimental_rerun()
+    st.experimental_rerun()