Re: Map of MySQL Users
Claire McLister [EMAIL PROTECTED] wrote on 10/24/2005 05:19:18 PM: 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 94087408-733-2737(fax) http://www.zeemaps.com I think your map is cool but you my information doesn't show up correctly. I know it's not your fault, It's my network's fault. Several people have tried to reverse my IP address into a real location and have thought I was anywhere from Nashville (where you found me), to Atlanta, to Raleigh. My actual location is in Spruce Pine, NC (USA) 28777 It's not important to me to get my flag in the correct place but this information may help you to refine your data mining techniques. Thank you and good job! Shawn Green Database Administrator Unimin Corporation - Spruce Pine
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
This is awesome! You missed me by 3 days. It looks like you can see the exact street and house that an email originated from. I like the mapping capability very much. Bob Cochran Claire McLister wrote: 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 94087408-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
That's awesome! I love it. Even though it didn't include me... :( How are you doing the geotargeting? -- 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
Hi Claire, I thought Daniel Kasak was in Sydney? It is about 2000kms from Alice Springs 8-) Apart from that, very good. Regards David Logan Database Administrator HP Managed Services 148 Frome Street, Adelaide 5000 Australia +61 8 8408 4273 - Work +61 417 268 665 - Mobile +61 8 8408 4259 - Fax -Original Message- From: Claire McLister [mailto:[EMAIL PROTECTED] Sent: Tuesday, 25 October 2005 6:49 AM 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
On Mon, 2005-10-24 at 14:19 -0700, Claire McLister wrote: 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. Very cool. You got me on the wrong island (I'm in Christchurch, South Island, New Zealand; not Wellington, North Island, New Zealand) but still very interesting. How exactly are you finding the geographical location of email senders? -- Jasper Bryant-Greene General Manager Album Limited e: [EMAIL PROTECTED] w: http://www.album.co.nz/ p: 0800 4 ALBUM (0800 425 286) or +64 21 232 3303 a: PO Box 579, Christchurch 8015, New Zealand -- 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
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] smime.p7s Description: S/MIME cryptographic signature
Re: Map of MySQL Users
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]
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]
Re: Map of MySQL Users
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 94087408-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
[posted only] On Oct 24, 2005, at 8:14 PM, Claire McLister wrote: 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. Hmm. That located me perfectly, but on the map, I was off by 2000km. However, I had just updated my location (deleted my entry and then created a new one with my correct address), so if that fed back into the location system, that might explain it. And this is great. -j -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]