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]