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]
Re: Map of MySQL Users
We do allow manual modifications to maps, through separate passwords for group moderators, members, and viewers. In our case, I have set the group password to 'mysqlmap'. Please feel free to add your entries to the map. This password will only allow you to add entries, or to modify existing entries. Currently we do not support modifying entry locations, so if you really want to change an entry, you will have to delete the existing entry. I've added a legend of 'red' = automatic, and 'blue' = manual. So, if you add your entry manually, please make its color blue. Let me know if this level of password management is not sufficient. Thanks for your encouragement. Claire On Oct 24, 2005, at 4:58 PM, J.R. Bullington wrote: 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]
Re: Map of MySQL Users
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]