Visual Field Example 4 - SF Police Crime Data 2018 to Present (by category). Drilldown Charts with Map (mini-app)

The source data this example is based upon

• Data SF Police Department Incident Reports: 2018 to Present CSV Dataset

Key aspects this example demonstrates

• Fetching a CSV dataset with a defined Cache Max-Age set to 3600 seconds (meaning the dataset won't be subsequently downloaded until 1 hour elapses)
• Creation of both a Custom Function to URI encode drilldown links and a database view to group by incident category
• Creation of a Bar Chart Visualization of Incidents by Category with drilldown links on the chart elements
• Creation of a second sequencing Pie Chart Visualization based on the passed Query String parameters from the Bar Chart drilldown
• Creation of another Custom Function to URI encode drilldown links and a database view to group by incident sub categories
• Creation of a third sequencing Map Visualization based on the passed Query String parameters from the Pie Chart drilldown
• Navigating of history between app "pages" should function correctly (ie, back history)
• Once the initial data is loaded, this entire mini-app can function offline (if loaded over a https:// protocol context)

Additional Information

• View this example stand alone
• View the metadata used in this example

visualfield.org