|
  |
|
|
| Author |
Message |
Guest
|
 Posted: Thu Jan 10, 2008 6:38 pm Post subject: Mapping project update |
 |
|
It's been a while since I've mentioned this so I guess I'll mention a
small update.
http://toastmasters.sysadmininc.com btw, is my unofficial Toastmasters
club mapping project.
However, not every club location is accurate on the map. Only those that
have been entered manually or moved by submitting the location from
Google Maps, or those submitted to be via a spreadsheet are considered
accurate.
When a user clicks on club into, it'll tell them if the location has
been verified, if so it'll tell them when, otherwise warm them to
contact the club before turning up.
Always open to more suggestions for the club mapping project.
Some districts name their divisions, for example in District 50 we have
Eastern, Plains, Town North, Southern, etc...
Would it be useful to be able to put your division names into the
system?
Do you think it'd be a good idea for me to email every club contact and
ask them to verify their club, and how to check their address to make
sure it's in a reliable form for processing?
Anything else?
--
Nigel Reed ACS, oCL (It's really an ATM-S in an ideal world)
District 50 Public Relations Officer http://www.toastmastersd50.org
http://www.toastytips.com - Tips of Toastmasters (submissions welcome)
http://toastmasters.sysadmininc.com - Toastmasters Club Mapping Project
Unofficial Area Motto: "I'm sure there's a speech in that somewhere" |
|
| Back to top |
|
Mark
Guest
|
| Posted: Mon Jan 14, 2008 6:10 am Post subject: Re: Mapping project update |
|
|
nigel@sysadmininc.com wrote:
| Quote: | http://toastmasters.sysadmininc.com btw, is my unofficial Toastmasters
club mapping project.
|
Now that break is over, I'm working again on the district 39 website.
Did I mention that our maps are located at http://www.district39.org/maps
| Quote: | Always open to more suggestions for the club mapping project.
|
How about displaying the maps by day of the week when the club meets as
well as dividing it up by the time of day.
| Quote: | Some districts name their divisions, for example in District 50 we have
Eastern, Plains, Town North, Southern, etc...
|
Fortunately, we just use division letters.
| Quote: | Do you think it'd be a good idea for me to email every club contact and
ask them to verify their club, and how to check their address to make
sure it's in a reliable form for processing?
|
No, because some of the e-mail contacts are not up to date. I discovered
this when I set up the district database.
Anyways, on your website, you state...
| Quote: | To submit a spreadsheet simply put the club number, longitude and latitude in and email it to me! Make sure you mark the columns so I know which is lat. and which is lon. I can then load them into the database and mark them verified.
|
Well, I have set up two links for you to use that pull from the District
39 database...
http://www.district39.org/maps/csv_screen.php
http://www.district39.org/maps/csv_download.php
Mind you, I supplied more info than you requested, but it includes the
latitude and longitude. Enjoy. |
|
| Back to top |
|
Guest
|
| Posted: Mon Jan 14, 2008 8:10 am Post subject: Re: Mapping project update |
|
|
Mark <dontbother@surewest.net> wrote:
| Quote: | nigel@sysadmininc.com wrote:
http://toastmasters.sysadmininc.com btw, is my unofficial Toastmasters
club mapping project.
Now that break is over, I'm working again on the district 39 website.
Did I mention that our maps are located at http://www.district39.org/maps
Always open to more suggestions for the club mapping project.
How about displaying the maps by day of the week when the club meets as
well as dividing it up by the time of day.
|
Not as easy as it seems. I would have to do a massive amount of parsing.
As you can see here, there's many different formats, this is just 50 out
of 11,000+ clubs.
mysql> select tm_club_meettime from clubs limit 25;
+----------------------------------------+
| tm_club_meettime |
+----------------------------------------+
| 11:30 a.m., Mon |
| 11:30 a.m., Thurs |
| 8:30 am, Saturday |
| 12:00 pm, Wednesday |
| Noon - 1:00 PM, Thursday |
| 7:30 a.m., Tues |
| 9:00 pm, Wednesday |
| 7 pm, Wednesday |
| 9:00 a.m., 1st Sat |
| 12:00 - 1:00 p.m., First 3 Thursdays |
| 10:30 am, Saturday |
| 11:15 a.m., Sat |
| 7:00 pm, 2nd & 4th Tuesday |
| 12:00 pm, 1st & 3rd Thursday |
| 12:00 pm, 2nd & 4th Tuesday |
| 7:00 am, 1st, 2nd, 3rd, 4th Wednesday |
| 11:15 a.m., 2nd & 4th Thurs |
| 11:30 am, 2nd & 4th Thursday |
| 5:45 pm, Thursday |
| 12:00 p.m., 2nd & 4th Wednesday |
| 7:00 pm, 2nd Friday |
| 12:00 pm, Wednesday |
| 12:15 p.m., 1st, 2nd and 3rd Wednesday |
| 11:30 am, Once a month Thursday |
| 7:30 pm, 3rd Friday |
+----------------------------------------+
| Quote: | Do you think it'd be a good idea for me to email every club contact and
ask them to verify their club, and how to check their address to make
sure it's in a reliable form for processing?
No, because some of the e-mail contacts are not up to date. I discovered
this when I set up the district database.
|
If it's not up-to-date then it'll maybe get them to update it or, at
least, pass the message on to the right person.
| Quote: | Anyways, on your website, you state...
To submit a spreadsheet simply put the club number, longitude and latitude in and email it to me! Make sure you mark the columns so I know which is lat. and which is lon. I can then load them into the database and mark them verified.
Well, I have set up two links for you to use that pull from the District
39 database...
Mind you, I supplied more info than you requested, but it includes the
latitude and longitude. Enjoy.
|
That's ok. I can just hide the columns I don't need and we're done. Your
clubs have been imported into the database. Thanks for that information.
--
Nigel Reed ACS, oCL (It's really an ATM-S in an ideal world)
District 50 Public Relations Officer http://www.toastmastersd50.org
http://www.toastytips.com - Tips of Toastmasters (submissions welcome)
http://toastmasters.sysadmininc.com - Toastmasters Club Mapping Project
Unofficial Area Motto: "I'm sure there's a speech in that somewhere" |
|
| Back to top |
|
Mark
Guest
|
| Posted: Fri Jan 18, 2008 1:31 am Post subject: Re: Mapping project update |
|
|
nigel@sysadmininc.com wrote:
| Quote: | How about displaying the maps by day of the week when the club meets as
well as dividing it up by the time of day.
Not as easy as it seems. I would have to do a massive amount of parsing.
As you can see here, there's many different formats, this is just 50 out
of 11,000+ clubs.
|
Let see if my rules apply to your sample. I defined morning clubs as
clubs whose meeting time is before 10 AM and evening clubs as starting
after 4 PM. The rest would be defined as midday. Lets see how it works.
| Quote: | mysql> select tm_club_meettime from clubs limit 25;
+----------------------------------------+
| tm_club_meettime |
+----------------------------------------+
|
Morning...
| Quote: | | 7:00 am, 1st, 2nd, 3rd, 4th Wednesday |
| 7:30 a.m., Tues |
| 8:30 am, Saturday |
| 9:00 a.m., 1st Sat |
|
Afternoon...
| Quote: | | 10:30 am, Saturday |
| 11:15 a.m., Sat |
| 11:15 a.m., 2nd & 4th Thurs |
| 11:30 a.m., Mon |
| 11:30 a.m., Thurs |
| 11:30 am, 2nd & 4th Thursday |
| 11:30 am, Once a month Thursday |
| 12:00 pm, Wednesday |
| 12:00 pm, 1st & 3rd Thursday |
| 12:00 pm, 2nd & 4th Tuesday |
| 12:00 p.m., 2nd & 4th Wednesday |
| Noon - 1:00 PM, Thursday |
| 12:00 - 1:00 p.m., First 3 Thursdays |
| 12:00 pm, Wednesday |
| 12:15 p.m., 1st, 2nd and 3rd Wednesday |
|
Evening...
| Quote: | | 5:45 pm, Thursday |
| 7 pm, Wednesday |
| 7:00 pm, 2nd & 4th Tuesday |
| 7:00 pm, 2nd Friday |
| 7:30 pm, 3rd Friday |
| 9:00 pm, Wednesday |
+----------------------------------------+
|
I've coded our club database to just enter in the start time. So far,
nobody's complained.
| Quote: | That's ok. I can just hide the columns I don't need and we're done. Your
clubs have been imported into the database. Thanks for that information.
|
No problem. Pull down updates anytime. I'm about to add a new club. |
|
| Back to top |
|
Guest
|
| Posted: Fri Jan 18, 2008 9:20 am Post subject: Re: Mapping project update |
|
|
Mark <dontbother@surewest.net> wrote:
| Quote: | How about displaying the maps by day of the week when the club meets as
well as dividing it up by the time of day.
|
Times aren't so much of a problem. It's the days.
Don't list this on a 5th Wednesday
| Quote: | | 7:00 am, 1st, 2nd, 3rd, 4th Wednesday |
|
I have to deal with Saturday and Sat
| Quote: | | 8:30 am, Saturday |
| 9:00 a.m., 1st Sat |
|
I'd never make it on the right day to this one
| 12:00 - 1:00 pm, 1st & 3rd Tues, 2nd & 4th Wed |
Spanish never was my strong subject. By the way, if I take the first
time, this would be a club that meets at 6am.
| 6:00 - 8:00 pm, Jueves |
Some clubs help me out.
| 6:00 pm to 8:00 pm, Miercoles (Wednesday) |
Some people can't type. this would never show up on the list for the 2ne
Wed.
| 6:00 - 7:00 pm, 2ne & 4th Wednesday |
Do we know which is the other Thursday?
| 12:30 pm, Every other Thursday |
Here's another 02:00 hours meeting
| 2:00 - 4:00 p.m., 2nd & 4th Saturdays |
Too ealy in the morning to figure out which Thursday
| 9:00 am, Recurrence Thursdays/Biweekly |
I bet this is in district 71 
| 12:30 pm, Tuesday, fortnightly |
Now we're getting complicated.
| 1:30 pm, 1st & 3rd Thurs. exc Jan & Feb |
My head hurts!
| 6:30 pm & 11:00 am, 1st & 3rd Wed & 2nd & 4th Wed |
Surprised some clubs get any visitors
| 12:00 pm, 1st & 3rd Wednesdsay |
| 6:45 pm for 7:00 pm start., Every Thurdsay |
Novel way of doing it
| 4th Tues@4:10, 2nd Tues@4:10,3rd Tues@noon, |
Love clubs at military air bases
| 1st @ 16h15 / 3rd @ 11h30, 1st & 3rd Tuesday |
Got to get up early for this club
| 12:00 am, Wednesday |
I rest my as case as to why I'm not bothering with time/date of
meetings. I'd rather give no information than bad information.
--
Nigel Reed ACS, oCL (It's really an ATM-S in an ideal world)
District 50 Public Relations Officer http://www.toastmastersd50.org
http://www.toastytips.com - Tips of Toastmasters (submissions welcome)
http://toastmasters.sysadmininc.com - Toastmasters Club Mapping Project
Unofficial Area Motto: "I'm sure there's a speech in that somewhere" |
|
| Back to top |
|
Mark
Guest
|
| Posted: Fri Jan 18, 2008 1:20 pm Post subject: Re: Mapping project update |
|
|
nigel@sysadmininc.com wrote:
| Quote: | Mark <dontbother@surewest.net> wrote:
How about displaying the maps by day of the week when the club meets as
well as dividing it up by the time of day.
Times aren't so much of a problem. It's the days.
|
As currently designed, the District 39 DB has the clubs selecting the
meeting days and start time. If they have a special meeting schedule,
they enter that into a text field.
Problem solved.... if they search for a club that meets on a Wednesday,
any club which meets on Wednesdays shows up in the search... even a club
that meets on 1st Mondays and 3rd Wednesdays. |
|
| Back to top |
|
Joy
Guest
|
| Posted: Fri Jan 18, 2008 7:12 pm Post subject: Re: Mapping project update |
|
|
LOL! Some of those are hilarious!
--
Joy
"Listen for differences. Seek them out. Don't surround yourself only with
those who see the world as you do." - Grant Cornwell
<nigel@sysadmininc.com> wrote in message
news:vv6665-i72.ln1@news.sysadmininc.com...
| Quote: | Mark <dontbother@surewest.net> wrote:
How about displaying the maps by day of the week when the club meets
as
well as dividing it up by the time of day.
Times aren't so much of a problem. It's the days.
Don't list this on a 5th Wednesday
| 7:00 am, 1st, 2nd, 3rd, 4th Wednesday |
I have to deal with Saturday and Sat
| 8:30 am, Saturday |
| 9:00 a.m., 1st Sat |
I'd never make it on the right day to this one
| 12:00 - 1:00 pm, 1st & 3rd Tues, 2nd & 4th Wed |
Spanish never was my strong subject. By the way, if I take the first
time, this would be a club that meets at 6am.
| 6:00 - 8:00 pm, Jueves |
Some clubs help me out.
| 6:00 pm to 8:00 pm, Miercoles (Wednesday) |
Some people can't type. this would never show up on the list for the 2ne
Wed.
| 6:00 - 7:00 pm, 2ne & 4th Wednesday |
Do we know which is the other Thursday?
| 12:30 pm, Every other Thursday |
Here's another 02:00 hours meeting
| 2:00 - 4:00 p.m., 2nd & 4th Saturdays |
Too ealy in the morning to figure out which Thursday
| 9:00 am, Recurrence Thursdays/Biweekly |
I bet this is in district 71
| 12:30 pm, Tuesday, fortnightly |
Now we're getting complicated.
| 1:30 pm, 1st & 3rd Thurs. exc Jan & Feb |
My head hurts!
| 6:30 pm & 11:00 am, 1st & 3rd Wed & 2nd & 4th Wed |
Surprised some clubs get any visitors
| 12:00 pm, 1st & 3rd Wednesdsay |
| 6:45 pm for 7:00 pm start., Every Thurdsay |
Novel way of doing it
| 4th Tues@4:10, 2nd Tues@4:10,3rd Tues@noon, |
Love clubs at military air bases
| 1st @ 16h15 / 3rd @ 11h30, 1st & 3rd Tuesday |
Got to get up early for this club
| 12:00 am, Wednesday |
I rest my as case as to why I'm not bothering with time/date of
meetings. I'd rather give no information than bad information.
--
Nigel Reed ACS, oCL (It's really an ATM-S in an ideal world)
District 50 Public Relations Officer http://www.toastmastersd50.org
http://www.toastytips.com - Tips of Toastmasters (submissions welcome)
http://toastmasters.sysadmininc.com - Toastmasters Club Mapping Project
Unofficial Area Motto: "I'm sure there's a speech in that somewhere" |
|
|
| Back to top |
|
Guest
|
| Posted: Fri Jan 18, 2008 10:01 pm Post subject: Re: Mapping project update |
|
|
Mark <dontbother@surewest.net> wrote:
| Quote: | As currently designed, the District 39 DB has the clubs selecting the
meeting days and start time. If they have a special meeting schedule,
they enter that into a text field.
Problem solved.... if they search for a club that meets on a Wednesday,
any club which meets on Wednesdays shows up in the search... even a club
that meets on 1st Mondays and 3rd Wednesdays.
|
I'm only taking data from WHQ for reasons I've explained before. The
only items in my database that are not from WHQ are the geocoding
information. I can't start letting people enter their own information or
get it from other places then WHQ.
I'd love to do it, but just can't with unreliable data.
--
Nigel Reed ACS, oCL (It's really an ATM-S in an ideal world)
District 50 Public Relations Officer http://www.toastmastersd50.org
http://www.toastytips.com - Tips of Toastmasters (submissions welcome)
http://toastmasters.sysadmininc.com - Toastmasters Club Mapping Project
Unofficial Area Motto: "I'm sure there's a speech in that somewhere" |
|
| Back to top |
|
Rick
Guest
|
| Posted: Sat Jan 19, 2008 6:40 am Post subject: Re: Mapping project update |
|
|
nigel@sysadmininc.com wrote:
| Quote: | My head hurts!
| 6:30 pm & 11:00 am, 1st & 3rd Wed & 2nd & 4th Wed |
|
We have a club like that in our district, except the 1st & 3rd they meet
at one time and the 2nd & 4th they meet at the other time. Don't
forget, they meet in different buildings at the different times. Our
data base chair lists it as "call for meeting time & place".
We had one club that just listed the business park for the location.
They would meet at one of the conference rooms in the park. There is a
reason they were named Noontime Nomads. A year or so ago, they moved to
a location that gives them a fixed meeting room.
| Quote: | Got to get up early for this club
| 12:00 am, Wednesday |
|
Actually, AM is before noon and PM is after noon. So, there isn't a 12
AM or 12 PM.
Rick Clements |
|
| Back to top |
|
Guest
|
| Posted: Sat Jan 19, 2008 9:40 pm Post subject: Re: Mapping project update |
|
|
Rick <Rick.Clements2@verizon.net> wrote:
| Quote: | Got to get up early for this club
| 12:00 am, Wednesday |
Actually, AM is before noon and PM is after noon. So, there isn't a 12
AM or 12 PM.
|
By my watch if the big hand is pointy uppy and the little hand is also
pointy uppy and it's dark outside, I make that 12 hours before noon.
--
Nigel Reed ACS, oCL (It's really an ATM-S in an ideal world)
District 50 Public Relations Officer http://www.toastmastersd50.org
http://www.toastytips.com - Tips of Toastmasters (submissions welcome)
http://toastmasters.sysadmininc.com - Toastmasters Club Mapping Project
Unofficial Area Motto: "I'm sure there's a speech in that somewhere" |
|
| Back to top |
|
Joy
Guest
|
| Posted: Sun Jan 20, 2008 12:20 am Post subject: Re: Mapping project update |
|
|
<nigel@sysadmininc.com> wrote in message
news:i96a65-3kq.ln1@news.sysadmininc.com...
| Quote: | Rick <Rick.Clements2@verizon.net> wrote:
Got to get up early for this club
| 12:00 am, Wednesday |
Actually, AM is before noon and PM is after noon. So, there isn't a 12
AM or 12 PM.
By my watch if the big hand is pointy uppy and the little hand is also
pointy uppy and it's dark outside, I make that 12 hours before noon.
--
Nigel Reed ACS, oCL (It's really an ATM-S in an ideal world)
District 50 Public Relations Officer http://www.toastmastersd50.org
http://www.toastytips.com - Tips of Toastmasters (submissions welcome)
http://toastmasters.sysadmininc.com - Toastmasters Club Mapping Project
Unofficial Area Motto: "I'm sure there's a speech in that somewhere"
|
However, almost any time you see 12:00 listed without "noon" or "midnight",
noon is shown as 12:00 PM and midnight as 12:00 AM.
Joy |
|
| Back to top |
|
Mark
Guest
|
| Posted: Sun Jan 20, 2008 4:20 am Post subject: Re: Mapping project update |
|
|
Joy wrote:
| Quote: | However, almost any time you see 12:00 listed without "noon" or "midnight",
noon is shown as 12:00 PM and midnight as 12:00 AM.
|
Rather than put up an argument in the District 39 database, I just said
"to heck with it", and did a substr of 12:00 PM with noon.
It's a California thing. |
|
| Back to top |
|
Rick
Guest
|
| Posted: Sun Jan 20, 2008 7:20 am Post subject: Re: Mapping project update |
|
|
Joy wrote:
| Quote: | However, almost any time you see 12:00 listed without "noon" or "midnight",
noon is shown as 12:00 PM and midnight as 12:00 AM.
|
People also refer to the lectern as a podium much of the time.
Rick Clements, DTM
VPM Daylighters |
|
| Back to top |
|
Guest
|
| Posted: Sun Jan 20, 2008 7:20 am Post subject: Re: Mapping project update |
|
|
Rick <Rick.Clements2@verizon.net> wrote:
| Quote: | Joy wrote:
However, almost any time you see 12:00 listed without "noon" or "midnight",
noon is shown as 12:00 PM and midnight as 12:00 AM.
People also refer to the lectern as a podium much of the time.
|
And they are rightly corrected, usually by the GE, in the clubs I've
been to.
--
Nigel Reed ACS, oCL (It's really an ATM-S in an ideal world)
District 50 Public Relations Officer http://www.toastmastersd50.org
http://www.toastytips.com - Tips of Toastmasters (submissions welcome)
http://toastmasters.sysadmininc.com - Toastmasters Club Mapping Project
Unofficial Area Motto: "I'm sure there's a speech in that somewhere" |
|
| Back to top |
|
Mark Perew
Guest
|
| Posted: Sun Jan 20, 2008 4:20 pm Post subject: Re: Mapping project update |
|
|
nigel@sysadmininc.com wrote:
| Quote: | People also refer to the lectern as a podium much of the time.
And they are rightly corrected, usually by the GE, in the clubs I've
been to.
|
I suspect we're going to lose this one. Defintions are determined by usage,
not by history. If you check dictionary.com, they've already as much as
admitted that people use the words interchangably.
--
Mark Perew <perew@squeep.com>
To the world you may be just one person,
but to one person you may be the world. (Source Unknown)
--
Posted via a free Usenet account from http://www.teranews.com |
|
| Back to top |
|
|
|
|
"Toastmasters
International", "Toastmasters" and the Toastmasters
International emblem are trademarks protected in the United
States, Canada and other countries where Toastmasters Clubs
exist. Unauthorized use is strictly prohibited.
|
|
|
