Re: Map of MySQL Users

[Robert L Cochran]

This shows me as being in Washington, DC. My ISP has a point-of-presence 
somewhere in the city. My physical location is Greenbelt, Maryland, USA.

Bob Cochran
Claire McLister wrote:

Peter,

 We try to take care of the situation where people are coming from an 
ISP account.

 Let me know if you think there is a specific case that is not right 
on our map. I searched for AOL in the map, and did not find a single 
entry from AOL.

 We do not use whois databases. As you correctly point out, those can 
be very misleading. We utilize a commercial service for mapping IP to 
location, and so far we've had very good success with them. For 
example, if you go to the web page, 
http://www.zeesource.net/maps/help.do, then in the paragraph under the 
heading "Automatic Maps" the last sentence should give you the 
location of your IP.

Claire

On Oct 24, 2005, at 5:12 PM, Peter J Milanese wrote:

This is particularly troublesome when it come to isp accounts. I.E., 
all aol users showing Reston as their base.

I tried something like this using whois databases and had the same 
issues. I canned the idea for now.

P

-----------------
Sent from my NYPL BlackBerry Handheld.


----- Original Message -----
From: "J.R. Bullington" [EMAIL PROTECTED]
Sent: 10/24/2005 07:58 PM
To: "'Claire McLister'" <[EMAIL PROTECTED]>
Cc: <mysql@lists.mysql.com>
Subject: RE: Map of MySQL Users

Thank you for your email.

It seems as though you are getting rave reviews from the list. I am sure
that if you want to make this really neat, try creating a simple web 
login
that allows for you to create an account using the email address, then
update your location so that it can be a little more accurate.

As stated in some of the posts, a lot of times your lat/long service 
may not
be entirely right as it is basing the lat/long off the mail carrier, not
necessarily the location of the user.

J.R.

PS -- Listers, sorry I didn't CC the list on my first correspondence. 
Here
it is with her answers.

GREAT JOB CLAIRE & COMPANY!

-----Original Message-----
From: Claire McLister [mailto:[EMAIL PROTECTED]
Sent: Monday, October 24, 2005 6:24 PM
To: [EMAIL PROTECTED]
Subject: Re: Map of MySQL Users

We use the origin IP and then convert it to a latitude/longitude using a
commercial service. There are several services available these days 
to do
this conversion.

We use any email posted to the list for which we can get  a decent IP 
value.
It could be from a registered MySQL user or not. Even a single post 
should
get you on the map. The only thing is a special email address needs 
to be
added to the list so that we can get location information from each 
email.

Thanks for your feedback. Yes, I think adding a geographical 
dimension to
the email lists brings up interesting possibilities.

Let me know if you want to see maps of other email lists.

Claire


On Oct 24, 2005, at 3:05 PM, J.R. Bullington wrote:

Couple of questions for you --

What are you using to keep pinpoint the origin of the submitted emails?
PING, TRACERT, WHOIS off the domain names?

Are you only doing original posts, or original & replies?
Do they need to be registered users of mySQL or just post to the list?
Do you have to post / reply a minimum number of times to be
"noticed"/added onto the list?

-- Now back to the original topic --

The popup JS is great (love the filter / search feature).
It's a great system and, if used, I think it will bring MySQL users
together and help in creating site/regional specific MySQL
lists/conferences.


Thanks for listening!

J.R.

-----Original Message-----
From: Claire McLister [mailto:[EMAIL PROTECTED]
Sent: Monday, October 24, 2005 5:19 PM
To: mysql@lists.mysql.com
Subject: Map of MySQL Users

Hi,

  We've developed an automatic email mapping capability from Google
Maps API.

  To try it out, we mapped origins of emails to this group from
October
3 through October 14th.

The result of this map is at:
http://www.zeesource.net/maps/map.do?group=460

  Would like to hear what you think of it.

  Best wishes

Claire

  --
  Claire McLister                        [EMAIL PROTECTED]
  1684 Nightingale Avenue     Suite 201
  Sunnyvale, CA 94087            408-733-2737(fax)

        http://www.zeemaps.com



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]






--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]