From 38515b5c270ec9a668ff912878530d7aa180b697 Mon Sep 17 00:00:00 2001
From: Christian Cleberg <hello@cleberg.net>
Date: Wed, 24 Jan 2024 11:01:36 -0600
Subject: fix: restructure project around the dash app

---
 scripts/dashboard.py | 76 ----------------------------------------------------
 1 file changed, 76 deletions(-)
 delete mode 100644 scripts/dashboard.py

(limited to 'scripts/dashboard.py')

diff --git a/scripts/dashboard.py b/scripts/dashboard.py
deleted file mode 100644
index 23e72c4..0000000
--- a/scripts/dashboard.py
+++ /dev/null
@@ -1,76 +0,0 @@
-from dash import Dash, html, dcc, callback, Output, Input
-import plotly.express as px
-import pandas as pd
-import sqlite3
-
-# Connect to database and query all incidents
-connection = sqlite3.connect("../raw_data/ingress.db")
-cursor = connection.cursor()
-query = "SELECT * FROM incidents;"
-df = pd.read_sql_query(query, connection).sort_values(by="description")
-
-# Create custom YEAR column to use in dropdown
-df['year'] = df['date'].str[-4:]
-
-# Configure HTML layout
-app = Dash(__name__)
-app.layout = html.Div(children = [
-    html.Div([
-        html.H1(children="Omaha Police Invidents", style={"textAlign":"center"}),
-        dcc.Dropdown(df.sort_values("description").description.unique(), "INJURY", id="bar-dropdown"),
-        dcc.Dropdown(df.sort_values("year").year.unique(), "2023", id="bar-year-dropdown"),
-        dcc.Graph(id="bar-graph")
-    ]),
-    html.Div([
-        html.H2(children="Map Coordinates", style={"textAlign":"center"}),
-        dcc.Dropdown(df.sort_values("description").description.unique(), "INJURY", id="map-dropdown"),
-        dcc.Dropdown(df.sort_values("year").year.unique(), "2023", id="map-year-dropdown"),
-        dcc.Graph(id="map-graph")
-    ])
-])
-
-# Create bar graph
-@callback(
-    Output("bar-graph", "figure"),
-    Input("bar-dropdown", "value"),
-    Input("bar-year-dropdown", "value")
-)
-def update_bar_graph(description, year):
-    dff = df[df.year == year]
-    dff = dff.value_counts(subset=["description"])
-    dff = dff.reset_index()
-    dff = dff[dff.description == description]
-    return px.bar(dff, x="description", y="count")
-
-# Create map
-@callback(
-    Output("map-graph", "figure"),
-    Input("map-dropdown", "value"),
-    Input("map-year-dropdown", "value")
-)
-def update_map(description, year):
-    dff = df[df.year == year]
-    dff = dff.reset_index()
-    dff = dff[dff.description == description]
-
-    fig = px.scatter_mapbox(
-        dff,
-        lat="lat",
-        lon="lon",
-        color="description",
-        hover_name="description",
-        hover_data=["date", "time"],
-        title="Incident Count by Coordinates",
-        center={"lat": 41.257160, "lon": -95.995102},
-        zoom=10
-    )
-    
-    fig.update_layout(showlegend=False)
-    fig.update_layout(mapbox_style="open-street-map")
-    fig.update_layout(margin={"r": 0, "t": 0, "l": 0, "b": 0})
-    fig.update_layout(mapbox_bounds={"west": -180, "east": -50, "south": 20, "north": 90})
-
-    return fig
-
-if __name__ == "__main__":
-    app.run(debug=True)
-- 
cgit v1.2.3-70-g09d2