SQL query + javascript function

NOTE: Your bid is final. Don't bid if you want to negotiate price.

Timing: This project needs to be executed in 1 day.

I'm looking for a SQL Query set of queries + a javascript function to calculate user's home location:

A database includes rows with the following columns (realnames, will be given after the project):

Table locations

- latitude, longitude

- timestamp

Table activity

- stationary: true/false

- timestamp

Table event

- charging: true / false

- timestamp

Table wifi

- SSID

- timestamp

I need a function in javascript that calculates a user home location based on the following rules:

- stationary in the same place (or with a radius of 300m)

- 5 days in a row in the last 10 days window

- during at least 5 hours in row between 9pm and 6am

- there's at least one a day (on the 5 mentioned days) a charging TRUE event during the period at the location

- there's at least one a day (on the 5 mentioned days) the SSID is the same during the mentioned period

Please consider that the queries results will be passed to the javascript and you would need to iterate over the data structure to get to the result.

JavaScript SQL

프로젝트 ID: #25500742

프로젝트 소개