import firebase_admin from firebase_admin import credentials from firebase_admin import db import streamlit as st # Fetch the credential JSON file from your Firebase project settings # and upload it to Google Colab, then provide the path here cred = credentials.Certificate("/cid1234-firebase-adminsdk-o0jz2-ddc0afe71d.json") # Initialize the app with the credentials and your database URL firebase_admin.initialize_app(cred, { 'databaseURL': 'https://cid1234-default-rtdb.firebaseio.com/' }) # Reference to your Firebase database ref = db.reference('/') # Listen for changes in the database in real-time def on_change(event): st.write('Data changed:', event.path, event.data) ref.listen(on_change) import requests def get_coordinates(location): """ Get latitude and longitude of a location using OpenStreetMap Nominatim API """ # URL for OpenStreetMap Nominatim API url = f'https://nominatim.openstreetmap.org/search?format=json&q={location}' # Send request to the API response = requests.get(url) # Parse JSON response data = response.json() # Check if response is not empty if data: # Extract latitude and longitude from the first result lat = float(data[0]['lat']) lon = float(data[0]['lon']) return lat, lon else: st.write("No results found for the location.") return None # Example usage location = input("Enter Location: ") latitude, longitude = get_coordinates(location) if latitude and longitude: st.write(f"Latitude: {latitude}, Longitude: {longitude}") else: st.write("Failed to retrieve coordinates for the location.") crimes = pd.DataFrame(columns=['Name', 'Lat', 'Lon', 'Intensity']) query = "" while(query != 'N'): location = input("Enter Location: ") crime = input("Enter Crime: ") intensity = int(input("Enter Intensity: ")) latitude, longitude = get_coordinates(location) data = [{'Name': crime, 'Lat': latitude, 'Lon': longitude, 'Intensity': intensity}] query = input("Enter Y to continue and N to stop: ") crimes = pd.concat([crimes, pd.DataFrame(data)], ignore_index=True) st.write(crimes)