Geoplotting...
-
Continuing the discussion from Double spinners, double busy?:
Now there is an evil idea if I have ever heard one...
Random selection of 100 users:
-
Not a bad spread; we truly are an international community
-
Holy shit, you mean to tell me there are at least 3 people in Australia that are intelligent enough to turn on a computer and connect it to the internet?
-
Can we have a link to the map so I can zoom and enhance?
-
-
and maybe a version with all the IPs of anyone who is active here? (active being defined as at least one post in the last 365 days)
-
-
Can we have a link to the map so I can zoom and enhance?
Not without handing out the IP addresses, it doesn't appear so.
-
lucky.... i'm not on there at all (no pins in Maine)
-
I'll see if I can get a kml file together tomorrow.
-
I might be; there are pins roughly where Manchester is, but the pin density is too high to be sure. Plus I'm not currently in Manchester (where I live); I'm in Haydock (where I work). And even if I was in Manchester, there's no guarantee geo-location will get it right; sometimes Facebook thinks I'm in London
-
I might be; there are pins roughly where Manchester is, but the pin density is too high to be sure.
I'm not on there:
-
Google thinks I'm in a totally different state when I'm at work. So I don't put much stock in the accuracy of the map.
-
Yeah, turns out neither am I. Unless I'm actually one of the London pins
-
Just had a look at a geo-location website; it got within a mile or two
-
IDK why but Google is quite accurate (like the router is in the living room and I'm in the kitchen accurate) with my location and that's very scary.
-
Ah - I might be in that list; just put my (work's) public IP address in there...
Way off.
-
IDK why but Google is quite accurate (like the router is in the living room and I'm in the kitchen accurate) with my location and that's very scary.
Android phones geo pin wifi hotspots
-
I'm on that one.
-
Google thinks I'm in a totally different state when I'm at work. So I don't put much stock in the accuracy of the map.
Do you have an office in that state? Some companies' intranets join the internet from one place, and route all company traffic to that point—Google thinks I'm in a different country if I use it from work...
-
Yeah - Google Maps defaults to where our head office is when accessing it from work.
That's not actually where any of traffic touches the internet though, so there's clearly something else going on.
-
I'm at our corporate HQ; we have warehouses and so forth all over the country, but our primary datacenter is in the same state I'm in. It's possible there's another datacenter where Google thinks I am, but it seems kind of silly to be routing our traffic that far away. But then, being silly doesn't mean it's not true XD
-
Is @Nagesh still in Britain?
-
I'm not there, but I see a dot which I presume is @ben_lubar. I'm surprised his Internet is fast enough to send his IP address to Discourse.
-
Just had a look at a geo-location website; it got within a mile or two
I'm in Kent, http://www.ipligence.com/geolocation thinks I'm in Doncaster...
-
That one has me (well, work's public IP) in Oxford. The one in @PJH's post has me in Skipton.
Neither of those are even vaguely right.
-
Do you have an office in that state? Some companies' intranets join the internet from one place, and route all company traffic to that point—Google thinks I'm in a different country if I use it from work...
Over here it's not even consistent - depending on how the wind blows I may be assigned an exit proxy in the UK or in denmark.
-
Looks like my work IP is misdetected; ip-to-location says “Rueil-malmaison, Ile-de-France, France” which is ~700km from where I am. Not sure why it doesn’t show up on the map...
-
Random selection of 100 users:
-
As pointed out above, that's only a sample. The site I used had a limit of 100 so I simply took the first 100 postgres gave me.
-
stop using the IPs and use the groups that exist for that exact reason.
-
area_gbr_ne1
...
-
Can you map it for 100 most active or something?
-
I could, yes. But that would reduce some of the anonymity...
-
Hmm, I thought everyone pretty much fessed up where they live.
How about in the lounge?
-
Can you map it for 100 most active or something?
And with dot size scaled to activity rank!
-
Hmm, I thought everyone pretty much fessed up where they live.
where we work at least. I'm fairly positive i havent narrowed down my actual home location nearly as much as i have my work location. ;-)
-
Nobody knows where I live.
Fortunately, I know from experience my IP geo-locates about 45 miles away from where I actually am in all of the popular geo-location databases.
-
-
Sorry, @mott555, but discourse doesn't find me worthy to like your post:
-
I'm fairly positive i havent narrowed down my actual home location nearly as much as i have my work location.
Presumably you don't commute from Nevada, so...
-
That one has me in … Middletown, New Jersey‽
Well that's wrong.
-
Presumably you don't commute from Nevada, so...
if you've been paying attention you'll see i narrowed it down to about 15 buildings recently. for my office at least. :-P
but yeah. i'm pretty well localized either way.
-
And with dot size scaled to activity rank!
There would just be two huge dots for @FrostCat and @accalia covering the world map.
-
have you seen the rankings lately? @FrostCat has slipped a fair bit. it's @boomzilla that's giving me a run for my spoon now.
-
Hmm, I thought everyone pretty much fessed up where they live.
I've named the city in which I live, but given it's the third largest city in England, it's not exactly giving away that much
@accalia said:I'm fairly positive i havent narrowed down my actual home location nearly as much as i have my work location.
Somewhere int he state of Maine, I presume?
@Keith said:There's would just be two huge dots for @boomzilla and @accalia covering the world map.
FTFY. And the dot for me wouldn't be far behind ;)
@accalia said:it's @boomzilla that's giving me a run for my spoon now.
I'm comin' for both o' ya!
-
And the dot for me wouldn't be far behind
Have you kicked me out of third place yet? Last time I checked, I was about 3 posts ahead of you...
-
Have you kicked me out of third place yet? Last time I checked, I was about 3 posts ahead of you...
@shadowmod monthposts
-
MonthPosts WITH exclusions AS ( /* Which categories to exclude from counters */ SELECT user_id, id, topic_id, post_number FROM posts WHERE raw LIKE '%[Magic Exclusion UUID]%' AND user_id IN ( SELECT gu.user_id FROM group_users gu WHERE group_id IN( SELECT g.id FROM groups g WHERE g.name IN ('admins') ) ) ), LastMonth AS ( /* Count eligible posts from last month */ SELECT row_number() OVER (ORDER BY count(*) DESC, bp.user_id), u.username, bp.user_id, count(*) FROM badge_posts bp JOIN users u on u.id=bp.user_id AND bp.user_id NOT IN ( /* ignore bots */ SELECT gu.user_id FROM group_users gu WHERE group_id IN( SELECT g.id FROM groups g WHERE g.name IN ('bots') ) ) WHERE topic_id NOT IN ( /* short topics */ SELECT topic_id FROM badge_posts GROUP BY topic_id HAVING count(topic_id) <10 ) AND topic_id NOT IN ( /* Ineligible topics */ SELECT topic_id FROM exclusions ) AND bp.created_at > CURRENT_DATE - INTERVAL '1 month' GROUP BY u.username, bp.user_id HAVING count(*) > 1 ORDER BY count(*) DESC, bp.user_id ), TotalUsers AS ( SELECT max(row_number) from LastMonth ), QUERY AS ( SELECT username, row_number, cast(row_number*100.0/TotalUsers.max AS numeric(36,2)) as percent, count, CURRENT_DATE granted_at FROM LastMonth, TotalUsers WHERE cast(row_number*100.0/TotalUsers.max AS numeric(36,2)) <= 25) SELECT row_number as rank, username, percent, count FROM QUERY Backup Date: 2015-02-25 03:55:45
-
Somewhere int he state of Maine, I presume?
rather narrower than that actually.
excellent @accalia-ing of the spellar there BTW. :-D