DEBUG
6
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 'NPS')
),
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
;
Programs
5160310 / Nature PlaySchool Fall 2024
Hike the trails around the pond, prairie, and woodland, draw in their journals, turn over logs to look for insects and worms, and get to know the animals at Wildwood all while developing lifelong learning skills in the classroom and outside. Nature PlaySchool rotates curriculum, exploring different seasonal topics each year and different curriculum each day. This allows your child to attend a unique program for multiple individual days and for two years. All children must be completely toilet trained to participate. Age is 3-4 years old as of September 1.
Priority Registration for currently enrolled students begins Friday, February 9th at 10:00 am online.
Open registration for all new students begins Friday, March 1st at 10:00 am online.
5160310-1 - Nature PlaySchool Tue am
Res/NonRes
$365.00/$442.00
9/3/2024 - 12/17/2024
9:00 am - 11:30 am
Location
Wildwood Nature Center
5160310-2 - Nature PlaySchool Thurs am
Res/NonRes
$365.00/$442.00
9/5/2024 - 12/19/2024
9:00 am - 11:30 am
Location
Wildwood Nature Center
5160310-5 - Nature PlaySchool Friday am
Res/NonRes
$365.00/$442.00
9/6/2024 - 12/20/2024
9:00 am - 11:30 am
Location
Wildwood Nature Center
5160320 / NPS MWF
Wildwood's nature focused program for children ages 3-4 infuses traditional readiness learning and preschool activities with an emphasis on the natural world and daily outdoor discovery. The curriculum incorporates the Illinois Early Learning and Development Standards. In addition to their ABC’s and 123’s, preschoolers hike the trails around the pond, prairie, and woodland, draw in their journals, turn over logs to look for insects and worms, and get to know the animals at Wildwood all while developing lifelong learning skills in the classroom and outside. Nature Preschool rotates curriculum, exploring different seasonal topics. This allows your child to attend a unique program for two years. All children must be completely toilet trained to participate. Age is 3-4 years old as of September 1.
Priority Registration for students currently enrolled begins Friday, February 9th at 10:00 am online
Open Registration for new students begins Friday, March 1st at 10:00 am online
No Class No Class October 14, November 25-29, December 23- January 3, January 20, February 17, March 24-28.
Registration for the program is online. If you have never registered for a Park District program, you will need to set up your Household account with the Park Ridge Park District to create an account.
5160320-1 - Nature Preschool MWF am
Res/NonRes
$2209.00/$2654.00
9/4/2024 - 5/7/2025
9:00 am - 11:30 am
Ages
Age 3-4 as of Septem
5160320-2 - Nature Preschool MWF pm
Res/NonRes
$2209.00/$2654.00
9/4/2024 - 5/7/2025
12:30 pm - 3:00 pm
Ages
Age 3-4 as of Septem
5160330 / NPS TTh
Wildwood's nature focused program for children ages 3-4 infuses traditional readiness learning and preschool activities with an emphasis on the natural world and daily outdoor discovery. The curriculum incorporates the Illinois Early Learning and Development Standards. In addition to their ABC’s and 123’s, preschoolers hike the trails around the pond, prairie, and woodland, draw in their journals, turn over logs to look for insects and worms, and get to know the animals at Wildwood all while developing lifelong learning skills in the classroom and outside. Nature Preschool rotates curriculum, exploring different seasonal topics. This allows your child to attend a unique program for two years. All children must be completely toilet trained to participate. Age is 3-4 years old as of September 1.
Priority Registration for students currently enrolled begins Friday, February 9th at 10:00 am online
Open Registration for new students begins Friday, March 1st at 10:00 am online
No Class No Class October 14, November 25-29, December 23- January 3, January 20, February 17, March 24-28.
Registration for the program is online. If you have never registered for a Park District program, you will need to set up your Household account with the Park Ridge Park District to create an account.
5160330-1 - Nature Preschool TuTh am
Res/NonRes
$1554.00/$1868.00
9/3/2024 - 5/8/2025
9:00 am - 11:30 am
Ages
Age 3-4 as of Septem
5160330-2 - Nature Preschool TuTh pm
Res/NonRes
$1554.00/$1868.00
9/3/2024 - 5/8/2025
12:30 pm - 3:00 pm
Ages
Age 3-4 as of Septem
5160342 / Lunch Bunch
Extend your Preschool or PlaySchool day at Lunch Bunch. Bring your lunch then enjoy free play indoors and outdoors after your meal. Children are escorted to and from lunch and the Nature Preschool and Nature PlaySchool program by staff. No class on days that Preschool or Playschool are not in session.
Priority registration begins for students currently enrolled on Friday, February 9th at 10:00 am online.
Open registration for new students begins in Friday, March 1st at 10:00 am online.
5160342-1 - Lunch Bunch Fri
Res/NonRes
$129.00/$178.00
9/6/2024 - 12/20/2024
11:30 am - 12:30 pm
Ages
Age 3-4 as of Septem
5160342-2 - Lunch Bunch Mon
Res/NonRes
$112.00/$155.00
9/9/2024 - 12/16/2024
11:30 am - 12:30 pm
Ages
Age 3-4 as of Septem
5160342-12 - Lunch Bunch Tu
Res/NonRes
$129.00/$178.00
9/3/2024 - 12/17/2024
11:30 am - 12:30 pm
Ages
Age 3-4 as of Septem
5160342-13 - Lunch Bunch Wed
Res/NonRes
$129.00/$178.00
9/4/2024 - 12/18/2024
11:30 am - 12:30 pm
Ages
Age 3-4 as of Septem
5160342-14 - Lunch Bunch Th
Res/NonRes
$129.00/$178.00
9/5/2024 - 12/19/2024
11:30 am - 12:30 pm
Ages
Age 3-4 as of Septem
5160352 / NPS M-F
Wildwood's nature focused program for children ages 3-4 infuses traditional readiness learning and preschool activities with an emphasis on the natural world and daily outdoor discovery. The curriculum incorporates the Illinois Early Learning and Development Standards. In addition to their ABC’s and 123’s, preschoolers hike the trails around the pond, prairie, and woodland, draw in their journals, turn over logs to look for insects and worms, and get to know the animals at Wildwood all while developing lifelong learning skills in the classroom and outside. Nature Preschool rotates curriculum, exploring different seasonal topics. This allows your child to attend a unique program for two years. All children must be completely toilet trained to participate. Age is 3-4 years old as of September 1.
Priority Registration for students currently enrolled begins Friday, February 9th at 10:00 am online
Open Registration for new students begins Friday, March 1st at 10:00 am online
No Class No Class October 14, November 25-29, December 23- January 3, January 20, February 17, March 24-28.
Registration for the program is online. If you have never registered for a Park District program, you will need to set up your Household account with the Park Ridge Park District to create an account.
5160352-1 - Nature Preschool M-F am
Res/NonRes
$3761.00/$4517.00
9/3/2024 - 5/8/2025
9:00 am - 11:30 am
Ages
Age 3-4 as of Septem