Built-in JSON capabilities

In this scenario, we will use the EMS incidents by month from the official city of Austin open data portal (https://data.austintexas.gov/Public-Safety/EMS-Incidents-by-Month/gjtj-jt2d). The data essentially contains incident counts, broken down by location and priorities for the city of Austin and Travis County incidents, and the percentage of on-time compliance.

The following are the prerequisites to get started:

1. Download the data from https://data.austintexas.gov/resource/bpws-iwvb.json to a local path, such as C:\Temp\bpws-iwvb.json.
2. Grant read access to the directory; for example:

Figure 10.1 Granting access to C:\Temp for MS SQL Server

3. For ease of R visualization, we will use SQL Operations Studio. You can download SQL Ops Studio from: https://docs.microsoft.com/en-us/sql/sql-operations-studio/download.

The following is an excerpt of a JSON...