From ce1c40b7dfccf62e4434795bf46dae27d1678a99 Mon Sep 17 00:00:00 2001
From: Christian Cleberg <hello@cleberg.net>
Date: Tue, 23 Jan 2024 16:16:25 -0600
Subject: initial commit

---
 scripts/dashboard.py | 76 ++++++++++++++++++++++++++++++++++++++++++++++++++++
 1 file changed, 76 insertions(+)
 create mode 100644 scripts/dashboard.py

(limited to 'scripts/dashboard.py')

diff --git a/scripts/dashboard.py b/scripts/dashboard.py
new file mode 100644
index 0000000..23e72c4
--- /dev/null
+++ b/scripts/dashboard.py
@@ -0,0 +1,76 @@
+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