Whereabouts Software, Part 2 - Fetch Locations

-
The server-side collection and processing is done with a PHP script on a LAMP (Linux, Apache, MySQL, PHP) server and is executed by cron.  I set mine to query the phone data every 15 minutes, and it didn't seem to kill my battery any more than normal.  Increase or decrease the timing as you see fit.

The script is dependent on the work of Tyler Hall and his Sosumi PHP library to get the location data from the Find my iPhone service.  You will need to download the class from his website.

The script included below will query the phone data for users in the database whose 'location_source' is 'GPS'.  You will need to modify the following in the script to get the location grabbing code to work:

// Enter your iCloud username and password
$ssm = new Sosumi('your_apple_id', 'your_password');

 // Database connection information
$db_hostname = "your_database_host";
$db_username = "db_username";
$db_password = "db_password";
$db_database = "whereabouts";

Once this is completed, run the script with `php fetch_locations.php` and observe the output.  You should see something similar to this:

CURRENT TIMESTAMPS:
Timestamp: 1381456148
Date Time: 2013-10-10 20:49:08
 LAST DATA: USER1                      | PHONE DATA: USER1                     
--------------------------------------------------------------------------------
 Timestamp: 1381454227                 |  Timestamp: 1381455996                
  DateTime: 2013-10-10 20:17:07        |   DateTime: 2013-10-10 20:46:36       
  Latitude: xx.xxxxxxxx                |   Latitude: xx.xxxxxxxxx           
 Longitude: yy.yyyyyyyy                |  Longitude: yy.yyyyyyyyyyy          
  Accuracy: zz                         |   Accuracy: zzz                       
  Location: home                       |   Location: home                      
--------------------------------------------------------------------------------
            NEW PHONE DATA!            | No change.  Still at: home            
 LAST DATA: USER2                      | PHONE DATA: USER2                   
--------------------------------------------------------------------------------
 Timestamp: 1381455883                 |  Timestamp: 1381455907                
  DateTime: 2013-10-10 20:44:43        |   DateTime: 2013-10-10 20:45:07       
  Latitude: xx.xxxxxxxxxxx             |   Latitude: xx.xxxxxxxxx           
 Longitude: yy.yyyyyyyyyyy             |  Longitude: yy.yyyyyyyyy          
  Accuracy: yy                         |   Accuracy: yy                        
  Location: home                       |   Location: home                      
--------------------------------------------------------------------------------
            NEW PHONE DATA!            | No change.  Still at: home            

Here's the source code:  fetch_locations.php

Comments

Post a Comment

Popular posts from this blog

V-22 Osprey Project - Design Changes for v3

-
Image
It's been a busy end of 2021, and as we start 2022 I'm getting closer to building version 3 of the Osprey wing.  The single biggest problem I've faced is the amount of backlash in the direct spur gear drive of the tilt mechanism.  It introduces some nasty instability that, left unchecked, would likely destroy the model in flight. I've investigated other tilt mechanisms, but the one I keep coming back to is the rack and pinion design that Tom Mast uses in his model at Rotormast.  His design uses a high-torque digital servo with a small pinion gear driving a rack attached to the rotor nacelle.  The servo has been modified with an external potentiometer that's driven by a gear on the translation tube to give positional feedback to the servo.  I like this design a lot because 1) It works, and his model is proof, and 2) it requires less torque from the servo and has less backlash. I ordered the pair of modified servos, potentiometer, and rack from Tom's site and star...
Read more

Whereabouts Clock Update

-
Image
After a few months, Life360 has gone the way of Apple and locked down the API I used to get location data from the phones.  This is disappointing, but inevitable. I found on a forum for Home Assistant that the app OwnTracks might be a suitable alternative. It's a neat little app that will trigger the phone to send its location data via MQTT to a server that you specify. I had to rework the code a bit, but the new operation is as follows: OwnTracks on the phone will push location data per its configuration to the MQTT server (Docker container) The Mosquitto (MQTT Broker) container will receive the data and forward the data to its subscribers The MQTTWarn container is a subscriber and translates the received data and adds it to the MariaDB database The Apache web server hosts a Python CGI script that is checked each minute by the Arduino microcontroller.  If the data has changed, the hands are moved to the new location. The only exposed port to the Internet is TCP 1883 for...
Read more

Whereabouts Clock: New Clock Mechanism

-
Image
 When I made the first mechanism of the Whereabouts Clock I utilized sail winch servos to get a motion that was at least 360 degrees.  Most RC servos are limited to about 180 degrees before they hit a physical limit.  I always wanted to create a clock with motors that weren't limited in the number of rotations, such as a stepper motor. However, stepper motors don't retain positional accuracy after a power loss.  The motor drivers only know "left" or "right" and a number of steps.  If the motor is moved, or power is lost, it has no idea where the motors are any longer.  In most control systems using stepper motors there are limit switches that are triggered to "home" the motors to a known position. Also, the Arduino Uno is limited in the number of IO pins.  Most stepper motor control requires at least 4 pins and additional lines for motor enable, micro switches for positioning, etc. A while back I purchased an Arduino Mega and a six-pack of 28BYJ48 ...
Read more