over 7 years on 2010-05-02

LOCATION-DATA DATA FREESTYLE: WHO IN NYC GETS UP EARLY, WHO PARTIES LATE, GOOD SPOTS, AND MORE.


location data is awesome... i have been obsessed with it for a while -- i got my first gps for my bar-mitzvah in 1996 (it was the only thing i asked for other than night vision), in v1 of the internet i got to hang out with early innovators like john ellenby / geovector, and then guys like mao/sense networks in 2005 ... the first real post on this blog was about location and i have kept on posting graphs off my garmin watch. when foursquare came out last year the first thing i did was start logging all the checkins i could get my hands on and trying to use the data for stuff like this, and then with bill piel and john steinberg socialgreat started logging millions of them as *i believe* the first released foursquare app. everyone knows that conceptually location is a huge deal because it is an enormously relevant and relatively un-captured dataset...

the question is, after a decade of trial, is there finally usable sample/insight in the noise? are we finally getting to the point where 'location' is both as ubiquitous and as usable as timestamps?

last weekend my girlfriend and i were trying to figure out what to do on a sunday afternoon, and out of that i was pushed back to looking at my personal foursquare data-set for insights. this is some of the stuff i found using the 27k check-ins logged by a few hundred nyc forusquare 'friends' from 2/8/2010 to 5/15/2010 (i use csvemail.com + email - the most basic api - to continuously log everything in an easy to manipulate format) -- i was going to use the 5m checkins logged in socialgreat, but i didn't feel like opening anything more serious than excel, and heck - 27k data-points from early adopting new yorkers seems like a good start to me...

checkins per day in the set

stuff i learned from my cut of 27k checkins at 6.7k locations:1. the top 5% of my friends drive 25% of all checkins (10% -gt 38%)
2. the top 1% of locations drive 20% of all checkins (5% -gt 43%)

people who get up early (check in highest % of the time between 5 and 9am)
1. andy weissman
2. darren herman
3. blake robinson
4. fred wilson
5. jon steinberg
6. roger ehrenberg
7. jim moran

people who party late
(check in highest % of the time 10pm - 5am)
1. andrew stillman
2. james nord
3. grellan harty
4. ken zamkow
5. drew grant
6. tina hui
7. josh newman

popular early morning spots1. naples 45
2. cafe bacio
3. mendez boxing
4. hospital for joint diseases
5. carrot creative
6. tony dapolito recreation center
7. irving farm
8. 9th stree espresso

popular late night spots
1. the wiskey ward
2. planet rose
3. the commodore
4. bleecker street pizza
5. home sweet home
6. maracuja
7. tappan zee bridge
8. amsterdam billards and bar

overall if i gut check this, some of it feels right -- like the 'early riser' list -- those are definitely the 'up and at them folk i would think of in the nyc tech scene that use foursquare... others i am just not hip enough to know about...

but the point (other than that data is fun) -- looks like there is some useable data in there... soon enough, location will be every bit as tied to status/sentiment/etc as time is now, and the more dimensions the better in our information.

i will be playing with more location data and publishing findings athttp://letter.ly/lessin in the coming weeks


original swl blogposts and letters 2007-2010