Crime Analysis

Automatic updates from SQL Server to an ArcGIS Online crime dashboard.

What I did

I built a workflow that turns SQL Server tables into ArcGIS Online layers and updates them automatically.

Result: The automated workflow kept the dashboard layers connected to their source database.

Tools

SQL Server
ETL
ArcGIS Online
Dashboards

This is a reporting workflow, not predictive policing or individual-risk scoring; incident records and authenticated dashboards are not included.

Open original application ↗

My contribution was the automated SQL Server to ArcGIS Online data workflow. The current dashboard credits Ashley Pavey; its interface is not presented as my design.

Loading the application connects to the external provider. If it cannot load here, use the original application link above.

Technical details

Historical GIS dashboard portfolio

The dashboard needed fresh data without repeated manual database exports.

Read records from SQL Server.
Convert the tables into GIS layers.
Update the hosted layers used by the dashboard.

← Back to projects