Creating a map

Let's use a base map supplied by Google BigQuery that has all of the vehicular collisions that occurred in New York City. We are going to see whether there are any geographical relations between different types of collisions.

Loading geographical data

First of all, we need to change our script so that we can extract the coordinates (latitude and longitude) from each vehicular collision that happened in New York according to the dataset. The Google BigQuery dataset provides the latitude and longitude values for each collision, so we're going to use them in our SQL. Qlik Sense provides a function called GeoMakePoint(), which consolidates a pair of latitude and longitude values in a single field (a geometry...