[Script Info]
Title: 
[Events]
Format: Layer, Start, End, Style, Name, MarginL, MarginR, MarginV, Effect, Text
Dialogue: 0,0:00:02.07,0:00:04.53,Default,,0000,0000,0000,,Hi, this is Florian, speaking from Melbourne.
Dialogue: 0,0:00:04.53,0:00:09.70,Default,,0000,0000,0000,,In the series, "Searching with Picky", this is a little screencast I've put together.
Dialogue: 0,0:00:09.70,0:00:16.17,Default,,0000,0000,0000,,So, from the last blog post we know that Picky can search coordinates.
Dialogue: 0,0:00:16.17,0:00:21.67,Default,,0000,0000,0000,,What I'm using now is a radius of 25km, which is quite big.
Dialogue: 0,0:00:21.67,0:00:28.90,Default,,0000,0000,0000,,As you see, Switzerland is small, so you find a lot of stuff with just 25 kilometers.
Dialogue: 0,0:00:28.90,0:00:37.07,Default,,0000,0000,0000,,The data I'm using here is the iPhone data, the cell tower location data, which
Dialogue: 0,0:00:37.07,0:00:40.20,Default,,0000,0000,0000,,Apple is collecting.
Dialogue: 0,0:00:40.20,0:00:44.13,Default,,0000,0000,0000,,I describe how I extracted it, it's easy, it's an SQLite database.
Dialogue: 0,0:00:44.13,0:00:49.40,Default,,0000,0000,0000,,So I've extracted it and fed it into Picky.
Dialogue: 0,0:00:49.40,0:00:55.30,Default,,0000,0000,0000,,And now, as in the last blog post, you can search for these
Dialogue: 0,0:00:55.30,0:01:00.87,Default,,0000,0000,0000,,dots where I was, so apparently I was never here, but I was here.
Dialogue: 0,0:01:00.87,0:01:03.50,Default,,0000,0000,0000,,Once. Or here.
Dialogue: 0,0:01:03.50,0:01:10.71,Default,,0000,0000,0000,,So now let's enable the timestamp and disable the coordinates
Dialogue: 0,0:01:10.71,0:01:13.37,Default,,0000,0000,0000,,and enable the dates.
Dialogue: 0,0:01:13.37,0:01:16.13,Default,,0000,0000,0000,,So, when I bought the iPhone,
Dialogue: 0,0:01:16.13,0:01:23.43,Default,,0000,0000,0000,,I started out in Zürich, and then I moved quite a bit
Dialogue: 0,0:01:23.43,0:01:29.30,Default,,0000,0000,0000,,At the end of November, I've moved to
Dialogue: 0,0:01:29.30,0:01:34.00,Default,,0000,0000,0000,,Tessin. Some friends of mine have programmed a nice iPhone
Dialogue: 0,0:01:34.00,0:01:37.47,Default,,0000,0000,0000,,game. it's called iMapIt.
Dialogue: 0,0:01:37.47,0:01:40.30,Default,,0000,0000,0000,,You can learn about Switzerland, its places.
Dialogue: 0,0:01:40.30,0:01:42.60,Default,,0000,0000,0000,,It's quite nice, you can download it
Dialogue: 0,0:01:42.60,0:01:46.65,Default,,0000,0000,0000,,They'll be happy.
Dialogue: 0,0:01:46.65,0:01:50.73,Default,,0000,0000,0000,,And you can also see that for example
Dialogue: 0,0:01:50.73,0:02:00.05,Default,,0000,0000,0000,,I spent my new year's around here.
Dialogue: 0,0:02:00.05,0:02:03.97,Default,,0000,0000,0000,,Near St. Moritz.
Dialogue: 0,0:02:03.97,0:02:08.63,Default,,0000,0000,0000,,And then I went back again.
Dialogue: 0,0:02:08.63,0:02:10.77,Default,,0000,0000,0000,,But you don't see me
Dialogue: 0,0:02:10.77,0:02:13.10,Default,,0000,0000,0000,,on this January 9th.
Dialogue: 0,0:02:13.10,0:02:15.57,Default,,0000,0000,0000,,Fact is, I went to Berlin, and
Dialogue: 0,0:02:15.57,0:02:23.77,Default,,0000,0000,0000,,gave a talk at the excellent RUG Berlin, with my friends, which
Dialogue: 0,0:02:23.77,0:02:25.75,Default,,0000,0000,0000,,also came.
Dialogue: 0,0:02:25.75,0:02:28.83,Default,,0000,0000,0000,,It was a Swiss evening, quite cool.
Dialogue: 0,0:02:28.83,0:02:31.10,Default,,0000,0000,0000,,So yeah, as you can see
Dialogue: 0,0:02:31.10,0:02:33.60,Default,,0000,0000,0000,,how I've moved around, and at the end of the timeline
Dialogue: 0,0:02:33.60,0:02:38.73,Default,,0000,0000,0000,,which is about now, that I've moved to Australia.
Dialogue: 0,0:02:38.73,0:02:44.40,Default,,0000,0000,0000,,Melbourne.
Dialogue: 0,0:02:44.40,0:02:48.53,Default,,0000,0000,0000,,So, now let's combine these two attributes.
Dialogue: 0,0:02:48.53,0:02:57.93,Default,,0000,0000,0000,,What I can say now is, when was I around here?
Dialogue: 0,0:02:57.93,0:03:03.23,Default,,0000,0000,0000,,Aha, it was around new year's I was there.
Dialogue: 0,0:03:03.23,0:03:06.03,Default,,0000,0000,0000,,Just for me this doesn't make lots of sense.
Dialogue: 0,0:03:06.03,0:03:14.20,Default,,0000,0000,0000,,If I want to know if I was somewhere I can just disable the timestamp and click.
Dialogue: 0,0:03:14.20,0:03:16.53,Default,,0000,0000,0000,,But if you have lots of people
Dialogue: 0,0:03:16.53,0:03:23.67,Default,,0000,0000,0000,,Say, intersecting data, with lots of intersecting geospatial
Dialogue: 0,0:03:23.67,0:03:26.83,Default,,0000,0000,0000,,timestamped data.
Dialogue: 0,0:03:26.83,0:03:38.07,Default,,0000,0000,0000,,Could come quite handy if you can combine these or choose which you need.
Dialogue: 0,0:03:38.07,0:03:45.27,Default,,0000,0000,0000,,Or enable the latitude, or just the longitude.
Dialogue: 0,0:03:45.27,0:03:49.13,Default,,0000,0000,0000,,Hope it was fun, hope you learnt something.
Dialogue: 0,0:03:49.13,0:03:52.80,Default,,0000,0000,0000,,I'll describe how I did it in the blog post.
Dialogue: 0,0:03:52.80,9:59:59.99,Default,,0000,0000,0000,,Cheers!