Project title:
SQL query + javascript function expert need
Posted by:
External project from PeoplePerHour
Started:
15-May-2020 13:34 GMT
Description:
From now soon, 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.
Project ID:
2986499
Project category:
Project budget:
Project
Started
Food/menus Finder Web App Developer
Category : Android, HTML5, IPhone, Mobile App Development, PHP Budget : €30 - €250 EUR
16-May-2024 22:03 GMT
Academic Copy-Editor for Journal Submission
Category : Article Rewriting, Copywriting, Editing, Proofreading, Research Writing Budget : $15 - $25 USD
16-May-2024 22:02 GMT
3D Logo Design for JigSpace
Category : 3D Animation, 3D Design, 3D Modelling, 3D Rendering, AutoCAD Budget : $30 - $250 USD
16-May-2024 22:02 GMT
Siemens PLC Programmer for Assembly Line Automation
Category : Electronics, Engineering, Microcontroller, PLC & SCADA Budget : $25 - $50 USD
16-May-2024 22:02 GMT
Fantasy Digital Illustrations in Realistic Style
Category : Book Artist, Graphic Design, Illustration, Visual Arts Budget : $30 - $250 USD
16-May-2024 22:01 GMT
Unique Mellow Remix Creation
Category : Audio Production, Audio Services, Music, Sound Design Budget : $10 - $30 USD
16-May-2024 22:00 GMT
Domain & Website Transfer to Shopify
Category : HTML, Shopify, Web Hosting, Web Design Budget : £20 - £250 GBP
16-May-2024 21:59 GMT
Real Estate Cold Calling for Sales
Category : Advertising, Leads, Sales, Telemarketing, Telephone Handling Budget : $2 - $8 USD
16-May-2024 21:58 GMT
Logo Refinement and Simplification
Category : Graphic Design, Illustration, Logo Design, Photoshop, T Shirts Budget : $30 - $250 USD
16-May-2024 21:57 GMT
Motivational Speaker Trailer Creation
Category : Audio Services, Video Editing, Video Production, Video Services, Videography Budget : $750 - $1500 USD
16-May-2024 21:55 GMT
Foundation Report for Structural Assessment
Category : Civil Engineering, Engineering, Mechanical Engineering, Report Writing, Structural Engineering Budget : $250 - $750 USD
16-May-2024 21:54 GMT
Movie Website Android App Development
Category : Android, HTML5, Mobile App Development, PHP Budget : ₹12500 - ₹37500 INR
16-May-2024 21:54 GMT
Animación para un video de caricaturas
Category : 3D Animation, After Effects, Animation, Video Editing, Video Services Budget : $8 - $15 USD
16-May-2024 21:52 GMT
Plant Gene Expression Data Extraction
Category : Big Data Sales, Data Entry, Data Mining, Data Processing, Excel Budget : $250 - $750 CAD
16-May-2024 21:52 GMT
Stock Market Trading Algorithm
Category : Algorithm, C, Programming, C++, Mathematics, Python Budget : $8 - $15 USD
16-May-2024 21:52 GMT
Browse All Projects