Take a Hike Message Board › Slide shows - easy to create

Slide shows - easy to create

Glen F.
gfullmer
Phoenix, AZ
Post #: 17
Hi Folks,

Given enough data and the right programs it is easy to create photo slide shows of any person in meetup. Here is one of Yvonne:

http://www.youtube.co...­

Using Picasa (free from Google) and a download program I came up with some interesting statistics, like the more prolific Take A Hike Photographers:

mysql> Select Photographer, Count(Photographer) AS NumOccurences from Photo where Grp = "Take A Hike" group by Photographer order by NumOccurences desc;
+--------------------------------+----­-----------+
| Photographer | NumOccurences |
+--------------------------------+----­-----------+
| Kevin | 1605 |
| Charles | 1094 |
| Karen | 915 |
| jan | 393 |
| Carolyn | 362 |
| Former Members or unknown | 325 |
| Scott | 270 |
| Ann Marie | 246 |
| LaDawn | 239 |
| Randy | 228 |

And one can find out the location of all pictures for a particular photographer for example:

mysql> select Location from Photo where Grp = 'Take A Hike' and Photographer = 'Colleen The Flutterby';+----------------------------­----------------------------------------­-------+
| Location |
+-------------------------------------­--------------------------------------+
| http://photos2.meetup...­ |
| http://photos2.meetup...­ |
| http://photos2.meetup...­ |
| http://photos2.meetup...­ |
| http://photos2.meetup...­ |
| http://photos2.meetup...­ |
| http://photos2.meetup...­ |
| http://photos2.meetup...­ |
| http://photos3.meetup...­ |
| http://photos3.meetup...­ |
| http://photos4.meetup...­ |
| http://photos4.meetup...­ |
| http://photos4.meetup...­ |
| http://photos4.meetup...­ |
| http://photos4.meetup...­ |
| http://photos4.meetup...­ |
+-------------------------------------­--------------------------------------+
16 rows in set (0.63 sec)

By the way Take A Hike has:

mysql> select count(*) from Photo where Grp = 'Take A Hike';
+----------+
| count(*) |
+----------+
| 9574 |
+----------+
1 row in set (0.07 sec)

Photos on Meetup.

Or the events in which one has taken pictures. Karen for example:

mysql> select distinct Event from Photo where Photographer = 'Karen' and Grp = 'Take A Hike';
+-------------------------------------­-----------------+
| Event |
+-------------------------------------­-----------------+
| http://www.meetup.com...­ |
| http://www.meetup.com...­ |
| http://www.meetup.com...­ |
| http://www.meetup.com...­ |
| http://www.meetup.com...­ |
| http://www.meetup.com...­ |
| |
| http://www.meetup.com...­ |
| http://www.meetup.com...­ |
| http://www.meetup.com...­ |
| http://www.meetup.com...­ |
| http://www.meetup.com...­ |
| http://www.meetup.com...­ |
| http://www.meetup.com...­ |
| http://www.meetup.com...­ |
| http://www.meetup.com...­ |
| http://www.meetup.com...­ |
| http://www.meetup.com...­ |
| http://www.meetup.com...­ |
| http://www.meetup.com...­ |
+-------------------------------------­-----------------+
20 rows in set (0.55 sec)

If this is of interest to anyone, let me know,
Glen



Powered by mvnForum

People in this
Meetup are also in:

Sign up

Meetup members, Log in

By clicking "Sign up" or "Sign up using Facebook", you confirm that you accept our Terms of Service & Privacy Policy