#! /usr/bin/perl use warnings; use strict; use feature qw'say'; use DBI; # source: New1229dbWithDblQuotes.sqlite; output: 1231STM.htm # TBD: see pod at LN 150 BEGIN { warn "Exe:$^X , Ver:$^V , File:$0 \n" } # get data from db my $db = 'DBI'->connect('dbi:SQLite:dbname=New1229dbWithDblQuotes.sqlite', q(), q(), { RaiseError => 1, }); my $select = $db->prepare(<< '__SQL__'); SELECT events.item, events.type, events.note, events.longdesc, times.starttime, times.endtime, times.place, times.who, times.note, times.extra FROM events, times WHERE times.starttime LIKE "2016-08-0_ %" AND events.link_id = times.link_id ORDER BY times.starttime __SQL__ my ($link_id, $events_item, $events_type, $events_note, $events_longdesc, $starttime, $endtime, $place, $who, $note, $extra, %skedhash, $skedhash, $FH_out); my $old_daymarker = '2016-08-03'; # 1 day before ofcl CVN start; flag for day dividers; see Ln 74 et seq my $daymarker; # tested (in truncated form) for equality to $old_daymarker $select->execute or die $DBI::errstr; # Create html #LN 32 my $file="1231STM.htm"; open ($FH_out, ">", $file) or die "Can not open $file", $!; # masthead print $FH_out <<__HEADER__; Doublequotetest
Stellafane LittleMan   Convention Schedule Header for 2017

2017 Stellafane Convention Schedule

__HEADER__ print $FH_out <<__STARTTABLE__; \n \n\n __STARTTABLE__ #################################################### sub sked { #LN 67 no warnings "uninitialized"; %skedhash = @_; if ($skedhash{'who'} ne '') { $skedhash{'who'} = "Hosted by $skedhash{'who'}"; } # next LN = 74 $daymarker = substr $skedhash{"starttime"}, 0, 10; # truncate to date element only; omit time if ( $daymarker !~ /$old_daymarker.*/ ) { $old_daymarker = $daymarker; # update the flag # daymarker used in Date::Day (needs an array mm,dd,yyyy or string: mm,dd,yyyy ## my @orig = split /-/, $skedhash{"starttime"}, 3; # split only first 3 elements my @fixed; push @fixed, $orig[1]; push @fixed, $orig[2]; push @fixed, $orig[0]; my $newday; $newday = &day(@fixed); use Date::Day; my $display_date = "$orig[1]-$orig[2]-$orig[0]"; my $STM_day = &day(@fixed); # 3 or 4 letter day !!Date::Day needs array mm,dd,yyyy ### my $ID_day; $ID_day = qq[]; # for anchor; say $FH_out <<__DAYDIVIDER__; __DAYDIVIDER__ } print $FH_out qq[ \n \n \n ]; use warnings "all"; } ### END sub sked() ######## my $sql = qq/SELECT events.link_id, events.item, events.type, events.note, events.longdesc, times.starttime, times.endtime, times.place, times.who, times.note, times.extra FROM events, times WHERE events.link_id = times.link_id ORDER BY starttime/; my $sth = $db->prepare($sql); # LN125 $sth->execute(); while ( my ($events_link_id, $events_item, $events_type, $events_note, $events_longdesc, $starttime, $endtime, $place, $who, $note, $extra) = $sth->fetchrow_array ) { my %skedrow = ( 'events_link_id' => $events_link_id, 'events_item' => $events_item, 'events_type' => $events_type, 'events_note' => $events_note, 'events_longdesc' => $events_longdesc, 'starttime' => $starttime, 'endtime' => $endtime, 'place' => $place, 'who' => $who, 'note' => $note, 'extra' => $extra, ); sked(%skedrow); } # wrap up the html say $FH_out '
Event, Type, Host or Moderator, When & WhereAdditional Info
$ID_day

$STM_day, $display_date


$skedhash{"events_item"} $skedhash{"events_type"}
\n $skedhash{"who"}\n
\n $skedhash{"starttime"} - $skedhash{"endtime"}
$skedhash{"place"}
$skedhash{"note"}
$skedhash{"events_longdesc"}

More to come

'; ### End of program close $FH_out; =head TBD: make html table of events by type of event by: SELECT link_id, item, type FROM events ORDER BY type; 40|Collimation and Maintenance of a Cassegrain-Type System|A 41|Taking ATM Techniques To The APO Level|A ... 12|Hartness House Workshop: Sub-Arcsecond Spatial Resolution Imaging|W 44|Stellafane New Horizons Project|Y 45|’Scope Making For Teens|Y .... (and, similarly, a table of 'types)... #### #! /usr/bin/perl use warnings; use strict; use feature qw{ say }; use Cwd; my $pwd = cwd(); if ( $pwd ne 'D:/_STM_work' ) { warn "Execute this file ONLY from 'D:/_STM_work/'"; exit; } my $filename = 'New1229dbWithDblQuotes.sqlite'; # database if (-e $filename) { rename ("$filename", "$filename.bak"); } else { say "$filename does not exist, Creating it now"; } use DBI; my $db = 'DBI'->connect( "dbi:SQLite:dbname=$filename", q(), q(), { RaiseError => 1, } ); $db->do(<< '__SQL__'); CREATE TABLE events ( ID INTEGER PRIMARY KEY AUTOINCREMENT, link_id INTEGER, item VARCHAR NOT NULL, type VARCHAR, note TEXT, longdesc TEXT) __SQL__ $db->do(<< '__SQL__'); CREATE TABLE times ( ID INTEGER PRIMARY KEY AUTOINCREMENT, link_id INTEGER, starttime VARCHAR NOT NULL, endtime VARCHAR NOT NULL, place VARCHAR NOT NULL, who VARCHAR, note TEXT, extra TEXT) __SQL__ my $insert = $db->prepare(<< '__SQL__'); INSERT INTO events(link_id, item, type, note, longdesc) VALUES(?, ?, ?, ?, ?) __SQL__ $insert->execute(@$_) for [ 1, 'Large RV Permit Holders must arrive', 'H', 'Hours', 'Large RVs must be pre-registered and must arrive between Noon and 4PM on Thursday. Do not arrive early: we have large trucks making food deliveries and installing sanitation facilities before then.' ], [ 2, 'Early Entry Permit Holders can arrive', 'H', 'Hours', 'Please do not arrive before 3:00 PM and do not park on Jordan Road. The large RVs come in before you. You will not be admitted before 3:00 PM because our gate staff will be busy getting the RVs safely in place.' ], [ 3, 'Registration Gate', 'H', 'Staff', 'Hours' ], [ 4, 'Shuttle Bus Operates', 'H', 'Stellafane East - Breezy Hill Clubhouse', 'The Shuttle Bus makes two stops in Stellafane East; one by the Food Tent and one by the main Camping Area. See
Stellafane East Site Map (pdf). It makes one stop on Breezy Hill near the Clubhouse. CHARTER SERVICE: Tips encouraged!' ], [ 5, 'Tee Shirt Booth in Tuthill Towers', 'H', 'Staff', 'Tee Shirts; hats; sweats; bumper stickers; and Raffle Tickets.' ], [ 6, 'Historic Clubhouse', 'H', 'Staff', 'The historic Pink Clubhouse is available for tours; talk; and shady relaxation.' ], [ 7, 'Porter Turret Telescope', 'H', 'Visit & Observe', 'The Porter Turret Telescope is open for tours and solar/stellar observing.' ], [ 8, 'McGregor Observatory and Schupmann Telescope', 'H', 'Visit & Observe', 'The McGregor Observatory is open for tours and observing through the Schupmann Telescope.' ], [ 9, 'Raffle Tickets at the Tee Shirt Booth', 'H', 'Staff', 'Purchase tickets for the famous Stellafane Raffle. Many thanks to our generous donors!' ], [ 10, 'Ice Cream Shop in the Flanders Pavilion', 'H', 'Staff', 'Hot and muggy? Need a cool treat for yourself and the kids?.' ], [ 11, 'Breuning Observatory and Argentini Telescope', 'H', 'Staff', 'The domed Breuning Observatory with the Argentini Ritchey-Chretien Telescope is open for tours and observing.' ], [ 12, 'Hartness House Workshop: Sub-Arcsecond Spatial Resolution Imaging', 'W', 'Symposium', 'Follow this link for Workshop and Dinner information. Separate registration and fees apply. We ’ll also have an observing session with the Hartness Turret Telescope (Weather permitting).' ], [ 13, 'Hartness-Porter ATM Museum Open', 'M', 'Free Admission', 'The Porter-Hartness Museum of Amateur Telescope Making is located in the underground rooms at the Hartness House Inn. Admission is free. Follow the signs in town to the Hartness House at 30 Orchard Street of VT-143 (Map). Many of the items on display are by or about Russell W. Porter, including the Springfield and Garden telescopes. His artwork traces his arctic exploration years to his work on the 200-inch Palomar telescope, culminating in his famous cutaway drawings. Other items of interest include early telescopes and mirror making parts. Visitors may also be able to inspect the Hartness Turret telescope (with a 10-inch Brashear objective).' ], [ 14, 'Friday Evening Videos', 'E', 'Videos', 'Short astronomy documentaries for the whole family.' ], [ 15, 'Friday Evening Informal Talks', 'M', 'If you wish to contribute a short talk during this session, please register online. Talks are limited to 10 minutes and 20 slides. THE TIME LIMIT WILL BE STRICTLY ENFORCED! A 35-mm slide projector, overhead projector, VCR, and a digital projector will be available for your use.', 'Note that if you plan to use the digital projector, you must bring your own laptop.' ], [ 16, 'Swap Tables', 'M', '7A-Noon', 'Swap Tables (at the northeast edge of the main camping/parking area) are provided to give amateurs an opportunity to trade, buy or sell their surplus astronomical and telescope related items.

POLICY OF THE SPRINGFIELD TELESCOPE MAKERS REGARDING COMMERCIALISM
AND THE SWAP TABLES AT THE CONVENTION

The Springfield Telescope Makers, Inc. has clarified its policy regarding commercialism and Swap Table sales at the Stellafane convention. For the sake of historical continuity, to preserve the uniqueness of the Stellafane convention and to encourage conventioneers to build their own instruments, the Springfield Telescope Makers, Inc. do not allow commercial sales, of any kind, at the Stellafane convention. All swap table sales must comply, in concept, with the above objective but are also specifically subject to the following criteria:
  1. Only surplus astronomical, telescope and telescope-making related items may be sold.
  2. Each person will be allowed 16 square feet of table or ground space.
  3. Items which have the appearance of being specifically purchased or manufactured for sale at the Swap Tables may not be sold.
  4. All sales must take place within the designated Swap Table area only between 7 a.m. and noon, the Saturday of the Stellafane convention.
The Springfield Telescope Makers, Inc. may choose to grant a limited exception to the above policies to astronomy related organizations for their fundraising. Any request for an exemption must be made - in writing - at least one month prior to the convention. The President of the Springfield Telescope Makers, Inc. will notify the requesting organization in writing if a request is approved.
 
Any member of the Springfield Telescope Makers, Inc. has the authority to determine whether a party is in compliance with the established regulations. Any person who is found to be in violation of the stated policies will be required to comply. In the event compliance is not achieved: the offending party will be asked to leave the convention and may be escorted from the premises by convention security.
 
The Springfield Telescope Makers encourages those with questions regarding this policy to contact the Club via the Stellafane web page (http://Stellafane.org). During the convention any questions regarding this policy; the appropriateness of items being displayed; or any information being disseminated should be directed to a member of the Springfield Telescope Makers.' ], [ 17, 'Saturday Evening Program & Keynote Talk', 'M', 'Hours', 'The evening program will begin at 7:00 p.m. in the hillside amphitheater. In case of inclement weather the program will be held inside the Flanders Pavilion.' ], [ 18, 'Telescope Competition', 'C', 'Hours', 'Details are on the Telescope Competition Page Convention Highlight!' ], [ 19, 'Breezy Hill Rocks!', 'E', 'Walking Tour', 'Johnson will give a brief, basic background on the overall geology of the area near the Pink Clubhouse and then guide the group around Breezy Hill identifying some of the cool rocks and minerals that can be found here.' ], [ 20, 'Free Time', 'E', 'Un-lax!', 'Run a little ragged by the many events? This hour is kept free for relaxation or a leisurely dinner.' ], [ 21, 'Observing Olympics Pin Awards', 'E', 'Award Distribution', 'Anyone who checks off 15 or more objects on the Observing Olympics List may claim their pin.' ], [ 22, 'Convention Cleanup', 'E', 'Please clean up around your campsite and parking area. All trash should be deposited in one of the large dumpsters by the Food Tent or Exit Lane. Please make sure there are no obstacles to grass mowing in the fields - anything which might be a hazard should be returned to the woods or taken to the dumpsters. We welcome and appreciate help taking down rebar and string. Pile rebar and string on the side of the road where it will be easy for us to find and pick up.', 'Thank you very much for making convention cleanup easier on all of us.' ], [ 23, 'Solar Observing Hour', 'S', 'Hours', 'All attendees with solar filters or projection set-ups are encouraged to share the sun with other attendees. The McGregor and Porter Turret will be set up for solar observing as well.' ], [ 24, 'The Evolution of the Telescope', 'B', 'Talk', 'Join Carl as he explores the telescope and its evolution though out history. We'll explore the changes; the folks who helped bring them to fruition; touch on some of the more peculiar designs; and how development of the telescope helped form the knowledge of our universe we have today.' ], [ 25, 'Solar System Walk', 'B', 'A Walk from the Sun to Nepture', 'To illustrate the vast size of outer space, the Springfield Telescope Makers have constructed a scale model of the solar system based on the Sun being 12 inches in diameter. At that scale the Earth would be approximately 107 feet from the Sun and just 1/10 of an inch in diameter. Jupiter would be 1.2 inches in diameter and approximately 560 feet from the Sun. The "Solar System Walk" begins behind the Pink Clubhouse and proceeds down the road going towards the camping area. At scale-model distances from the model Sun, there are stations for each planet (with a a short description & also built to scale). The Solar System walk can be taken on your own at any time during the convention. However, a guided walk is available at the times mentioned above: docent Jessica Johnson will provide additional information about the "Solar System Walkquot; & each planet.
 
The walk will take approximately 45 minutes if you walk all the way to the planet Neptune, with a total distance of 3,232 feet or a little over half a mile.' ], [ 26, 'Introduction to Stellafane', 'B', 'For newcomers', 'Are you familiar with these terms: "The Pink" or "Tent Talks" or "The Turret?" This presentation is for you if this is your first time attending the Stellafane convention or if you are returning and want to learn more about who the Springfield Telescope Makers are and activities during the convention. Topics include (among others): A short history of Stellafane; a description of our site including the buildings and landmarks; descriptions of the scheduled talks and activities; services available at Stellafane; local services off site. Kim & Dennis will also answer any questions you may have about the convention.' ], [ 27, 'Telescope Field Walk', 'B', 'Learn more about the competition ’scopes', 'During the Telescope Field Walk experienced Amateur Telescope Makers will guide small groups through the fields around the Pink Clubhouse, where the telescopes that will be participating in the mechanical competition will be set up. They will describe the various types of optical designs and mounting configurations that will be on display, point out the subtle details that go into award winning telescopes and be available to answer your questions.' ], [ 28, 'Dipper Full of Stars', 'B', 'The sky', 'Using stunning images of constellations, planets, and celestial objects, Sanderson will lead an interpretive tour of the summer nighttime sky. He will describe how the sky appears to move throughout the night and from season to season, and explain the significance of the North Star. He will speculate about life on other worlds and show many of the prominent summer constellations. The presentation is aimed at beginners of all ages.' ], [ 29, 'An Introduction to Telescopes For All Ages', 'B', 'About ’Scopes, Part 1', 'Adults and youngsters often become interested in astronomy and acquiring a telescope for exploring the heavens. With the plethora of telescopes on the market, buying your first telescope, or a telescope for a child, can be intimidating. In this program Alan French will cover telescope basics (types, mounts, and eyepieces), telescopes suitable for children in Part 1, and Glenn Chaple will follow in the next hour to introduce you to what the novice can find and see with a common backyard telescope.' ], [ 30, 'An Introduction to Telescopes For All Ages', 'B', 'About ’Scopes, Part 2', 'Glenn Chaple will immediately follow up on what you learn in Part I of the "Introduction..." by explaining what the novice can find and see with a common backyard telescope.' ], [ 31, 'Observing Earth Satelites', 'I', 'The sky', 'Every astronomer has, from time to time, noticed satellites crossing the night skies. Since the dawn of the Space Age low earth orbit has become quite cluttered with these easily observable and fascinating objects. This talk is for both beginners and more seasoned amateur astronomers. Topics include: observing basics, oldies but goodies, the ISS, the more challenging geostationary satellites, and Apps and web sites to make observing satellites fun and exciting.' ], [ 32, 'To Bino Or Not To Bino?', 'I', 'Constructing Large Binoculars', 'Have you ever stood by two 10-inch Dobsonian telescopes, side by side, and wondered: "What if. . . ?" This talk will cover personal journey Paul took -- from conception to design requirements, compromises, construction, and the unforgettable experiences of building a 10-inch binocular telescope. There will be a chance to examine this Stellafane award winning instrument and ask questions. Since words don’t come close to the actual experience, all are invited to come by the Pink Clubhouse at night and look through this one-of-a-kind instrument.' ], [ 33, 'Astronomy in Motion', 'I', 'Talk & Demo', 'A single image captures an object in one moment. However, by adding the dimension of time, we can study how the object interacts with its surroundings. A single photo can be marvelous to look at, but movies can bring the subject to life. In his presentation, Al Takeda will discuss how to make motion pictures of astronomical objects. Topics will include the subjects that lend themselves to movement, the type of telescopes and lenses to use, cameras to use, and how to assemble the pictures to create a movie. Al will demonstrate some of these techniques in real time Friday evening only, using his own astro‐imaging system.
 
The evening demonstration will be presented next to the domed observatory.' ], [ 34, 'Chasing Shadows: Getting on Occultation Timing', 'I', 'Observing challenges', 'Ted will focus on how asteroids sometimes interrupt the passage of light from a star to our cameras or eyes. Such an event is called an occultation and can last from a fraction of a second up to a good portion of a minute (for large asteroids like Ceres). Measuring the duration of the disappearance turns out to be an inexpensive yet incredibly accurate way to measure the diameter of the asteroid. If the occultation event is recorded on video, tiny details in the light curve can also tell us a lot about the star. We can learn whether it is a binary system with components too close to be resolved optically and the relative brightness of each. Asteroid ring systems have been discovered this way as well as indications that some asteroids might have their own moons. Ted will describe how you can get started measuring occultations. He will show the results of some recent measurements, describe the techniques and equipment used and demonstrate the free software tools available to let you know where and when to observe. Professional astronomers are waiting to use your measurements as an input to their studies of the Solar System origins.' ], [ 35, 'Human and Environmental Effects of LED Street Lighting', 'I', 'Dark (not!) Skies', 'Light pollution is becoming a significant problem across the globe as more people recognize the loss of our heritage of a beautiful night sky. In addition, over the past 20 years considerable evidence has accumulated that shows that the most important reason to control light pollution may be our own health. Newer LED lighting can be a solution but only if designed properly, and limited in excess blue emission. Light at night has been proposed as an explanation for the rise of certain human health issues, by glare and melatonin suppression. A considerable amount of research has firmly placed this concept on the map as a real and very vexing problem. While clearly it is not practical to imagine going back to a world without nighttime lighting, we can and should demand that night lighting have proper shielding, and that our night lighting is designed in a way to minimize deleterious human effects.' ], [ 36, 'Mirror Testing: See How It’s Really Done', 'I', 'Telescope Making Demo', 'You read about mirror testing, but its not easy to visualize what it really looks like and how it is actually done. In this session, we will demonstrate a variety of mirror testing techniques, where you can see, hands-on, how Foucault, Ronchi, and null testing are performed, what the shadows and patterns look like, and how to interpret them.' ], [ 37, 'Where Have All The (Bright) Novae Gone?', 'I', '...and Why?', 'In the first half of the 20th century, seven bright novae were discovered. Since 1950 that figure is just one. In this talk, John will discuss the lack of recent bright novae discoveries and some of the possible explainations for this. Along the way, he will also touch on what novae are and how you might search for them. He will also recall the excitement of some of the bright novae discoveries of the past.' ], [ 38, 'White Dwarf Destroying A Planet', 'I', 'Amateur Roles in Professional Astronomy', 'Last year analysis of data from the Kepler K2 mission uncovered a strange signal from a white dwarf star - WD1145+017 - 570 light years away in Virgo. A grad student at Harvard, Andrew Vandenburg, decided to look deeply into the abnormal photometric flickering from this star, and realized he needed more info. Initially he used Kepler and Mt Whipple data, but quickly realized much more monitoring was needed. Andrew got several advanced amateurs to collect photometric data on this object over the winter and spring of 2016. Armed with that data, an amazing story of a star that is destroying a Ceres sized planetoid that is spiraling in to the star has emerged. For years it was not understood why some white dwarfs have heavy metal signatures in their spectra, an astronomical mystery. Now that we are catching a white dwarf in the act of eating a planet, with a similar spectral signal from the star, we seem to have a mechanism of how this develops and evidence that this not a rare event. Dr. Motta will describe the science of why this is occurring, and the importance of amateur professional collaboration in astronomy.' ], [ 39, 'Observing Programs of the AAVSO', 'I', 'Variable Stars', 'The president of the American Association of Variable Star Observers will describe the wide variety of the organization's observing programs, from visual binocular and telescopic observing through PEP, DSLR, and CCD (with a sneak peak of what is coming in the future).' ], [ 40, 'Collimation and Maintenance of a Cassegrain-Type System', 'A', 'Advanced Topics', 'Professional optician Phil will give us the lowdown on the simple steps we can take to get the best performance from these instruments by collimation and maintenance.' ], [ 41, 'Taking ATM Techniques To The APO Level', 'A', 'Advanced Topics', 'This presentation captures the journey into the realm of design and construction of both a 6-inch f/15 and a 4-inch f/12 three-element oil-spaced apochromatic refractor, along with an analysis of the design criteria required to optimize for a visual instrument. From his personal perspective, Alan will share his remarkable account about the motivation, collaboration, knowledge, and experience acquired by a couple of passionate amateur telescope makers in their quest in building the ultimate refractor.' ], [ 42, 'The Golden Era of Soviet Astronomy', 'A', 'The Science of Byurakan', 'Larry plans to share just some of the vast store of knowledge that has come out of the Byurakan Observatory. A lot of the knowledge of the science of astronomy that we take for granted now was discovered by Byurakan observers and scientists years ago. Viktor Ambartsumian, for example, was an Einstein-level genius and his colleagues and followers were and are extraordinary astronomers and scientists but their work is largely unknown in amateur circles in the west.
 
The astronomers of Byurakan are still at it and have kindly assisted Larry with this presentation by providing little known information.' ], [ 43, 'Astro Activities for Children', 'K', 'Hours', 'Four 1-hour astronomy workshops geared to children ages 4 to 11. This year they are all related to our solar system. Each session has a different activity. Held annually as Stellafane since 1995, these workshops are led by Dr. Kristine Larsen, Professor of Astronomy at Central Connecticut State University and a member of the Springfield Telescope Makers. Because we have space limitations, each workshop is limited to 20 children on a first-come basis. Children younger than 4 are welcome but will need help from a parent.' ], [ 44, 'Stellafane New Horizons Project', 'Y', 'Hours', 'Our program will be modeling technology from the New Horizons probe which so spectacularly flew by Pluto in 2015.
This will be a hands-on class where the group will work together to construct a New Horizons inspired system that will be demonstrated at the Convention. Each participant will have the opportunity to fine tune or modify their take home project during a special dinner hour session.
Attendance will be first-come, first-served. If you are 100% sure your teen will attend convention and will want to attend this event, then your teen needs to get on the list. Please email us directly at robots@stellafane.org. Please make the subject line read "New Horizons Registration." You will receive a (NON-automated) reply to let you know your status. When space is filled, we will add the next two names to a waiting list. If space is not filled through preregistration we will accept others first-come, first served at the event, until the class is full.
PLEASE NOTE: There will be a lot of specialized instruction so participants will need to be on time!' ], [ 45, '’Scope Making For Teens', 'Y', 'Help build your own Dob!', 'With Steve providing guidance, the group will build an 8-inch Dobsonian Newtonian telescope. Teens aged 12-16 who take part in the entire activity (stay the whole 90 minutes) will receive a special raffle ticket. The winner of the telescope will be drawn at the Saturday night program. You must be present to win and must take the telescope home with you (no shipping is available). PARTICPATION LIMITED to the first 12 participants so arrive early!' ], [ 46, '’Scope Making Demo', 'T', 'Overview', 'This is a HANDS-ON mirror making demonstration - Gain first-hand experience working on mirrors at every stage of grinding, polishing and testing. Experienced ATMs will help explain each step of the process and answer any questions you may have. Details of each one-hour session are listed by time.
The 24-inch mirror we have been working on for several years will be available for grinding - please sign the log book when you work on it - and also note that you can bring your own mirror for testing between 2:00 and 4:00 PM either day.' ]; my $insert2 = $db->prepare(<< '__SQL__'); INSERT INTO times (link_id, starttime, endtime, place, who, note, extra) VALUES(?, ?, ?, ?, ?, ?, ?) __SQL__ $insert2->execute(@$_) for [ 1, '2016-08-04 12:00', '2016-08-04 16:00', 'Entry Gate', 'Staff', 'Please don’t arrive before Noon!', '' ], [ 2, '2016-08-04 15:00', '2016-08-04 22:00', 'Entry Gate', 'Staff', 'Please don’t arrive before 3pm!', '' ], [ 3, '2016-08-05 09:00', '2016-08-05 22:00', 'Entry Gate', 'Staff', 'Hours', 'Registration Gate in operation (open).' ], [ 3, '2016-08-06 07:00', '2016-08-06 19:00', 'Entry Gate', 'Staff', 'Hours', 'Registration Gate in operation (open).' ], [ 4, '2016-08-05 10:00', '2016-08-05 18:00', 'Bus Stops', 'Chartered', 'Bus Stops: Pine Island, Food Tent, Pink Clubhouse', 'Tips encouraged' ], [ 5, '2016-08-05 09:00', '2016-08-05 18:00', 'Swag Shop', 'Staff', 'You know you want a souvenir!', 'Hours' ], [ 5, '2016-08-06 09:00', '2016-08-06 18:00', 'Swag Shop', 'Staff', 'Can you really go home without Stellafane memoribilia for yourself and others?', 'Hours' ], [ 6, '2016-08-05 09:00', '2016-08-05 20:00', 'Clubhouse', 'Staff', 'Sit where Porter sat.', 'Hours' ], [ 6, '2016-08-06 08:00', '2016-08-06 18:00', 'Clubhouse', 'Staff', 'Enjoy a break!', 'Hours' ], [ 7, '2016-08-05 09:00', '2016-08-05 23:59', 'Porter Turret Telescope', 'Hours', 'Members', 'The Porter Turret Telescope is open for tours and solar-stellar observing.' ], [ 7, '2016-08-06 08:00', '2016-08-06 18:00', 'Porter Turret Telescope', 'Hours', 'Members', 'The Porter Turret Telescope is open for tours and solar-stellar observing.' ], [ 8, '2016-08-05 10:00', '2016-08-05 23:59', 'McGregor Observatory', 'Members', 'Why is the ’scope here so significant', 'Hours' ], [ 9, '2016-08-05 09:00', '2016-08-05 18:00', 'Raffle Tickets', 'Staff','Hours', '' ], [ 9, '2016-08-06 09:00', '2016-08-06 18:00', 'Raffle Tickets', 'Staff', 'Hours', '' ], [ 10, '2016-08-05 10:00', '2016-08-05 18:00', 'Ice Cream Shop', 'Staff', 'Hours', '' ], [ 10, '2016-08-06 10:00', '2016-08-06 18:00', 'Ice Cream Shop', 'Staff', 'Hours', '' ], [ 11, '2016-08-05 14:00', '2016-08-05 18:00', 'Breuning Observatory', 'Staff', 'Hours', '' ], [ 11, '2016-08-05 21:00', '2016-08-05 23:59', 'Breuning Observatory', 'Staff', 'Hours', '' ], [ 11, '2016-08-06 14:00', '2016-08-06 18:00', 'Breuning Observatory', 'Staff', 'Hours', '' ], [ 11, '2016-08-06 21:00', '2016-08-06 23:59', 'Breuning Observatory', 'Staff', 'Hours', '' ], [ 12, '2016-08-04 08:30', '2016-08-04 17:00', 'Hartness House', 'Tom Spirok', 'Workshop (Separate Registration)', '' ], [ 12, '2016-08-04 18:00', '2016-08-04 20:00', 'Hartness House', 'Tom Spirok', 'Dinner (Separate Registration)', '' ], [ 13, '2016-08-05 17:00', '2016-08-05 20:00', 'Hartness House', 'Bert Willard, Curator', '', '' ], [ 13, '2016-08-07 09:00', '2016-08-07 12:00', 'Hartness House', 'Bert Willard, Curator', '', '' ], [ 14, '2016-08-05 19:00', '2016-08-05 20:30', 'Flanders Pavilion', '', 'Astronomy documentaries for the whole family', '' ], [ 15, '2016-08-05 20:30', '2016-08-05 TillDone', 'Flanders Pavilion', 'MC: Bruce Beford', 'Short presentations by Convention Attendees', '' ], [ 16, '2016-08-06 07:00', '2016-08-06 12:00', 'Swap Table Area - North of Main Camping Area', '', '', 'Please read the policy, below, carefully.Please clean up around your campsite', 'YOU!', '', 'Please put trash in the dumpsters' ], [ 23, '2016-08-05 13:00', '2016-08-05 14:00', 'Observing Fields', '', 'Please set up your Solar ’Scope and Share', '' ], [ 23, '2016-08-06 14:00', '2016-08-06 15:00', 'Observing Fields', '', 'Please set up your Solar ’Scope and Share', '' ], [ 24, '2016-08-05 11:00', '2016-08-05 12:00', 'Flanders Pavilion', 'Carl Malikowski', '', '' ], [ 25, '2016-08-05 13:00', '2016-08-05 14:00', 'Meet at Green Shed near Clubhouse', 'Jessica Johnson', '', '' ], [ 25, '2016-08-06 13:00', '2016-08-06 14:00', 'Meet at Green Shed near Clubhouse', 'Jessica Johnson', '', '' ], [ 26, '2016-08-05 16:00', '2016-08-05 17:00', 'McGregor Observatory Library', 'Kim & Dennis Cassia', '', '' ], [ 26, '2016-08-06 11:00', '2016-08-06 12:00', 'McGregor Observatory Library', 'Kim & Dennis Cassia', '', '' ], [ 27, '2016-08-06 10:00', '2016-08-05 TillDone', 'Meet at Front of Clubhouse', 'Carl Malikowski', '', '' ], [ 28, '2016-08-06 10:00', '2016-08-06 11:00', 'Flanders Pavilion', 'Richard Sanderson', '', '' ], [ 29, '2016-08-06 15:00', '2016-08-06 16:00', 'McGregor Library', 'Alan French', '', '' ], [ 30, '2016-08-06 16:00', '2016-08-06 17:00', 'McGregor Library', 'Glenn Chaple', '', '' ], [ 31, '2016-08-05 13:00', '2016-08-05 14:00', 'McGregor Library', 'Rich Nugent', '', '' ], [ 32, '2016-08-05 13:00', '2016-08-05 14:00', 'Flanders Pavilion', 'Paul Courtemanche', '', '' ], [ 33, '2016-08-05 14:00', '2016-08-06 15:00', 'Flanders Pavilion', 'Al Takeda', 'Talk', '' ], [ 33, '2016-08-05 20:00', '2016-08-05 21:00', 'Near Domed Observatory', 'Al Takeda', 'Demo', '' ], [ 34, '2016-08-05 15:00', '2016-08-05 16:00', 'Flanders Pavilion', 'Ted Blank', '', '' ], [ 35, '2016-08-05 16:00', '2016-08-05 17:00', 'Flanders Pavilion', 'Mario Motta, M.D.', '', '' ], [ 36, '2016-08-06 11:00', '2016-08-06 12:00', 'Flanders Pavilion', 'Douglas Arion, PhD', '', '' ], [ 37, '2016-08-06 13:00', '2016-08-06 14:00', 'McGregor Library', 'John O’Neill', '', '' ], [ 38, '2016-08-06 13:00', '2016-08-06 14:00', 'Flanders Pavilion', 'Mario Motta, M.D.', 'How Pro-Am Collaboration Helped Solve A Mystery: ', '' ], [ 39, '2016-08-06 16:30', '2016-08-05 17:30', 'Flanders Pavilion', 'Kris Larsen', '', '' ], [ 40, '2016-08-05 15:00', '2016-08-05 16:00', 'McGregor Library', 'Phil Rounesville', '', '' ], [ 41, '2016-08-06 14:00', '2016-08-06 15:00', 'Flanders Pavilion', 'Alan Ward', '', '' ], [ 42, '2016-08-06 15:00', '2016-08-06 16:30', 'Flanders Pavilion', 'Larry Mitchell', '', '' ], [ 43, '2016-08-05 11:00', '2016-08-05 12:00', 'McGregor Observatory Library', 'Kris Larsen', 'Ages 4-11; Limited to first 20', 'Models of the Moon' ], [ 43, '2016-08-05 14:00', '2016-08-05 15:00', 'McGregor Observatory Library', 'Kris Larsen', 'Ages 4-11; Limited to first 20', 'Models of Comets (and Real Meteorites' ], [ 43, '2016-08-06 10:00', '2016-08-06 11:00', 'McGregor Observatory Library', 'Kris Larsen', 'Ages 4-11; Limited to first 20', 'Models of the Planets' ], [ 43, '2016-08-06 14:00', '2016-08-06 15:00', 'McGregor Observatory Library', 'Kris Larsen', 'Ages 4-11; Limited to first 20', 'Models of the Sun' ], [ 44, '2016-08-05 13:00', '2016-08-05 17:00', 'Bunkhouse', 'Paul Fucile and James Lee', '(Teens 12-16)(Requires Signup)', 'Modeling technology from the New Horizons' ], [ 45, '2016-08-06 11:00', '2016-08-06 12:30', 'Bunkhouse', '"Stargazer" Steve Dodson', 'Ages 12-16', 'Build-a-Dob Time' ], [ 46, '2016-08-05 10:00', '2016-08-05 16:00', 'Tent north of Pavilion', 'Ray Morits', 'Fri. ATM Demo Hours - Details by time are below', 'TM Demo' ], [ 46, '2016-08-06 10:00', '2016-08-06 16:00', 'Tent north of Pavilion', 'Ray Morits', 'Sat. ATM Demo Hours - Details by time are below', 'TM Demo' ], [ 46, '2016-08-05 10:01', '2016-08-05 10:30', 'Tent north of Pavilion', 'Ray Morits', 'Intro & Rough Grinding', 'TM Demo' ], [ 46, '2016-08-06 10:01', '2016-08-06 10:30', 'Tent north of Pavilion', 'Ray Morits', 'Intro & Rough Grinding', 'TM Demo' ], [ 46, '2016-08-05 10:30', '2016-08-05 11:00', 'Tent north of Pavilion', 'Rick Hunter', 'Fine Grinding', 'TM Demo' ], [ 46, '2016-08-06 10:30', '2016-08-06 11:00', 'Tent north of Pavilion', 'Rick Hunter', 'Fine Grinding', 'TM Demo' ], [ 46, '2016-08-05 11:00', '2016-08-05 13:30', 'Tent north of Pavilion', 'Junie Esslinger', 'Making Dental Stone Tools', 'TM Demo' ], [ 46, '2016-08-06 11:00', '2016-08-06 11:30', 'Tent north of Pavilion', 'Junie Esslinger', 'Making Dental Stone Tools', 'TM Demo' ], [ 46, '2016-08-05 11:30', '2016-08-05 12:00', 'Tent north of Pavilion', 'Phil Rounseville', 'Making Pitch Laps', 'TM Demo' ], [ 46, '2016-08-06 11:30', '2016-08-06 12:00', 'Tent north of Pavilion', 'Phil Rounseville', 'Making Pitch Laps', 'TM Demo' ], [ 46, '2016-08-05 13:00', '2016-08-05 14:00', 'Tent north of Pavilion', 'Dave Groski', 'Polishing & Figuring', 'TM Demo' ], [ 46, '2016-08-06 13:00', '2016-08-06 14:00', 'Tent north of Pavilion', 'Dave Groski', 'Polishing & Figuring', 'TM Demo' ], [ 46, '2016-08-05 14:00', '2016-08-05 16:00', 'Mirror Lab Room in Pavilion', 'Dave Kelly', 'Testing (Bring your own mirror)', 'Testing (Bring your own mirror)' ], [ 46, '2016-08-06 14:00', '2016-08-06 16:00', 'Tent north of Pavilion', 'Ken Slater', 'Dobsonian Basics', 'TM Demo' ];