DEBUG
8
WITH cteSection AS
(
/* OG
SELECT ROW_NUMBER() OVER (
PARTITION BY JSON_VALUE(AccuRecTrac.DataJSON, '$.arsection_activitycode')
Order BY JSON_VALUE(AccuRecTrac.DataJSON, '$.arsection_activitycode'),
JSON_VALUE(AccuRecTrac.DataJSON, '$.arsection_section')
) AS RowNum,
JSON_VALUE(AccuRecTrac.DataJSON, '$.arsection_activitycode') AS ActivityCode,
JSON_VALUE(AccuRecTrac.DataJSON, '$.arsection_section') AS SectionNum,
JSON_VALUE(AccuRecTrac.DataJSON, '$.arsection_brochurecode') AS BrochureCode,
JSON_VALUE(AccuRecTrac.DataJSON, '$.arsection_brochuretext') AS ActivityDescription,
JSON_VALUE(AccuRecTrac.DataJSON, '$.arsection_facilitylocation') AS LocationCode,
JSON_VALUE(AccuRecTrac.DataJSON, '$.arsection_displayonweb') AS Display
FROM AccuRecTrac
WHERE AccuRecTrac.TableName LIKE 'arsection'
-- [X] TODO - move to api filter
AND JSON_VALUE(AccuRecTrac.DataJSON, '$.arsection_archived') = 'false'
--AND JSON_VALUE(AccuRecTrac.DataJSON, '$.arsection_displayonweb') LIKE 'Yes'
*/
SELECT ROW_NUMBER() OVER (
PARTITION BY activitycode
Order BY activitycode,
section
) AS RowNum,
activitycode AS ActivityCode,
section AS SectionNum,
brochurecode AS BrochureCode,
brochuretext AS ActivityDescription,
facilitylocation AS LocationCode
FROM AccuRecTrac_arsection
),
cteSectionFilter AS
(
/* OG
SELECT DISTINCT JSON_VALUE(AccuRecTrac.DataJSON, '$.arsection_activitycode') AS ActivityCode
FROM AccuRecTrac
WHERE AccuRecTrac.TableName LIKE 'arsection'
-- [X] TODO - move to api filter
AND JSON_VALUE(AccuRecTrac.DataJSON, '$.arsection_displayonweb') LIKE 'Yes'
*/
SELECT DISTINCT activitycode AS ActivityCode
FROM AccuRecTrac_arsection
WHERE 1 = 1
AND (subtype LIKE 'EC w Adult'OR subtype LIKE 'EC wout Adult')
),
cteBrochure AS
(
SELECT JSON_VALUE(AccuRecTrac.DataJSON, '$.sacommentcode_commentcode') AS BrochureCode,
JSON_VALUE(AccuRecTrac.DataJSON, '$.sacommentcode_comments') AS ActivityDescription
FROM AccuRecTrac
WHERE AccuRecTrac.TableName LIKE 'sacommentcode'
)
/* OG
SELECT DISTINCT JSON_VALUE(ART.DataJSON, '$.aractivity_activitycode') AS ActivityCode,
JSON_VALUE(ART.DataJSON, '$.aractivity_shortdescription') AS Title,
JSON_VALUE(ART.DataJSON, '$.aractivity_typecode') AS TypeCode,
CASE WHEN Brochure.ActivityDescription IS NOT NULL THEN Brochure.ActivityDescription ELSE SecDesc.ActivityDescription END AS ActivityDescription,
SecDesc.SectionNum as SectionNum,
SecDesc.RowNum
FROM AccuRecTrac AS ART
INNER JOIN cteSection AS SecDesc ON SecDesc.ActivityCode = JSON_VALUE(ART.DataJSON, '$.aractivity_activitycode')
LEFT JOIN cteBrochure AS Brochure ON Brochure.BrochureCode = SecDesc.BrochureCode
-- [] TODO - uncomment as the fallback skip activities with no sections returned will mess with pagination by possibly having less than rpp on a page
--INNER JOIN cteSectionFilter AS Filter ON Filter.ActivityCode = SecDesc.ActivityCode
WHERE ART.TableName LIKE 'aractivity'
-- [X] TODO - move to api filter
AND JSON_VALUE(ART.DataJSON, '$.aractivity_activitycode') <> ''
-- [X] TODO - move to api filter
AND SecDesc.ActivityDescription <> ''
AND RowNum = 1
-- [X] TODO - move to api filter
AND SecDesc.Display LIKE 'Yes'
*/
SELECT DISTINCT ART.activitycode AS ActivityCode,
ART.shortdescription AS Title,
ART.typecode AS TypeCode,
CASE WHEN Brochure.ActivityDescription IS NOT NULL THEN Brochure.ActivityDescription ELSE SecDesc.ActivityDescription END AS ActivityDescription,
SecDesc.SectionNum as SectionNum,
SecDesc.RowNum
FROM AccuRecTrac_aractivity AS ART
INNER JOIN cteSection AS SecDesc ON SecDesc.ActivityCode = ART.activitycode
LEFT JOIN cteBrochure AS Brochure ON Brochure.BrochureCode = SecDesc.BrochureCode
-- [] TODO - uncomment as the fallback skip activities with no sections returned will mess with pagination by possibly having less than rpp on a page
INNER JOIN cteSectionFilter AS Filter ON Filter.ActivityCode = SecDesc.ActivityCode
WHERE SecDesc.RowNum = 1
AND (/* OG JSON_VALUE(ART.DataJSON, '$.aractivity_typecode') LIKE 'Nature' */ ART.typecode LIKE 'Nature')
/* OG
ORDER BY JSON_VALUE(ART.DataJSON, '$.aractivity_typecode')
*/
ORDER BY ART.typecode
;
Early Childhood Nature Programs
3200218 / Camp S'more
Looking for to extend your preschoolers camp day S'MORE? Explore at Wildwood, go on outdoor hikes, and dive into nature and animal themes each week. Children must be completely toilet trained by the first day of camp. Camp will be held primarily outdoors, and head inside in the event of inclement weather. If attending a morning camp that ends at 1:30pm at Maine Park, camp staff will escort your child to Camp S’more, located in the same building. Age for camp is age as of the first day of each session.
3200218-1 - Camp S'more MWF Jul 22- Jul 26
7/22/2024 - 7/26/2024
1:30 pm - 3:30 pm
3200218-2 - Camp S'more T/TH Jul 23 - Jul 25
7/23/2024 - 7/25/2024
1:30 pm - 3:30 pm
3200218-3 - Camp S'more MWF Jul 29- Aug 2
7/29/2024 - 8/2/2024
1:30 pm - 3:30 pm
3200218-4 - Camp S'more T/TH Jul 30 - Aug 1
7/30/2024 - 8/1/2024
1:30 pm - 3:30 pm
3200218-5 - Camp S'more MWF Aug 5- Aug 9
8/5/2024 - 8/9/2024
1:30 pm - 3:30 pm
3200218-6 - Camp S'more T/TH Aug 6- Aug 8
8/6/2024 - 8/8/2024
1:30 pm - 3:30 pm
4160101 / Wild Ones
Spark the natural curiosity in your “Wild One” as we take in the beauty of the natural world. Discover water, fish, flowers, and other surprises with a visit to the animal room, stories, songs, themed activities, and nature walks. Dress for a mess.
6/18/2024 - 7/16/2024
4:00 pm - 5:00 pm
Location
Wildwood Nature Center
4160103 / Deep Sea Divers
Dive deep into the sea and discover ocean animals. Enjoy ocean themed crafts, activities, and stories as we learn about sea horses, manta rays, sea stars, and sharks. Visit Wildwood’s underwater critters and head outside for a hike each week. No class July 4.
4160103-1 - Deep Sea Divers
6/20/2024 - 7/18/2024
4:00 pm - 5:00 pm
Location
Wildwood Nature Center
4160202 / Science Kids
See the world through science goggles. Uncover the natural, physical and earth sciences with fun experiments, observations, games, crafts, and outdoor hikes. No class July 5.
6/17/2024 - 7/15/2024
4:00 pm - 5:30 pm
Location
Wildwood Nature Center
5160201 / Nature Friends
Experience the wonders of animals, plants, and the outdoors with fun games, crafts, experiments, and activities. We are all about hands-on learning and discovery and venture outside for nature hikes. Different topics each session.
No class Oct 14 or Nov 25.
5160201-1 - Nature Friends Monday AM (Full Semester)
Res/NonRes
$316.00/$379.00
9/9/2024 - 12/16/2024
9:00 am - 11:30 am
Location
Wildwood Nature Center
5160201-2 - Nature Friends Mon AM Session 1
Res/NonRes
$170.00/$204.00
9/9/2024 - 10/28/2024
9:00 am - 11:30 am
Location
Wildwood Nature Center
5160201-3 - Nature Friends Monday AM Session 2
Res/NonRes
$146.00/$170.00
11/4/2024 - 12/16/2024
9:00 am - 11:30 am
Location
Wildwood Nature Center
5160201-11 - Nature Friends Monday PM (Full Semester)
Res/NonRes
$316.00/$379.00
9/9/2024 - 12/16/2024
12:30 pm - 3:00 pm
Location
Wildwood Nature Center
5160201-12 - Nature Friends Mon PM Session 1
Res/NonRes
$170.00/$204.00
9/9/2024 - 10/28/2024
12:30 pm - 3:00 pm
Location
Wildwood Nature Center
5160201-13 - Nature Friends Monday PM Session 2
Res/NonRes
$146.00/$170.00
11/4/2024 - 12/16/2024
12:30 pm - 3:00 pm
Location
Wildwood Nature Center