Travel Tracking With Carto DB

408

12

3

Introduction: Travel Tracking With Carto DB

For this project, what I did is to pull metadata from all pictures shoot by my current cell phone (being used since 2014_Sept.) with terminal tool -exiftool and map it based on timeline.

Travel_tracking

Step 1: 1.Pull Meta Data From Your Pictures

1.Using terminal tool -exiftool with following comand:

exiftool -csv -CreateDate -GPSLatitude -GPSLongitude *.jpg > metadata.csv

You will get something like this:

Step 2: 2.Converting Data With Processing.

Converting data to the format that cartodb can read.

2.1, Manually delete the NULL data for your GPS doesn't work sometimes.

2.2,Run processing sketch to convert data format from "31 deg 13' 59.65" N" to "31.233236", copy paste into new column in excel.

You will get something like this

Step 3: 3.Map It With CartoDB: Www.cartodb.com

I chose to do heat map with animation.

And some of the key parameters for understanding the animation is:

steps: divide the whole process into how may steps

durations: animation time
resolution: decide how isolate the cluster should be.

Be the First to Share

    Recommendations

    • Make it Glow Contest

      Make it Glow Contest
    • First Time Author Contest

      First Time Author Contest
    • PCB Challenge

      PCB Challenge

    3 Discussions

    0
    resorts155
    resorts155

    5 years ago

    Enjoyed every bit of your blog.


    http://treehousecottages.co.in/

    0
    amberrayh
    amberrayh

    5 years ago

    This is a neat idea! Thanks for sharing.

    0
    aaaven
    aaaven

    Reply 5 years ago

    Sure thing, thank you for comment