create_sql_visits_query: Creates a query that returns the visits in each polygon
In alesaccoia/alexr: Common routines and datasets for GIS and Big Data Research

Description Usage Arguments Value Examples

Returns visits and dwell time in each polygon. Note that the name of the IDFA column must be 'aid'

create_sql_visits_query(
  places_table_name,
  ds_from,
  ds_to,
  location_table_name = "emr.dataset_accumulo",
  places_id_column_name = "id",
  places_wkt_column_name = "wkt",
  destination_table = NULL,
  places_options = "",
  aid_options = ""
)

`places_table_name`	the table with the polygons
`ds_from`	the day date for which we are retrieving the visits (for 1 day can be the same as ds_to)
`ds_to`	the day date for which we are retrieving the visits (for 1 day can be the same as ds_from)
`location_table_name`	the table that stores the ping (defaults emr.dataset_accumulo) (hardcoded columns lon, lat)
`places_id_column_name`	the name of the column containing the ID of the place (defaults to id)
`places_wkt_column_name`	the column containing the polygon in WKT format (defaults to wkt)
`destination_table`	a destination table for the INSERT, leave default NULL if you want to fetch the rows
`places_options`	can be a clause like WHERE places.bt_level4 = 'Q8'
`aid_options`	can be a clause like 'AND aid in = (SELECT aid from test.audience_table)'. Should contain AND because it's placed after the select