3182 Beach Patrol 3182 Beach Patrol looks after the St Kilda Beaches, from Fraser Street to St Kilda Marina. These are some of the busiest beaches on Port Phillip Bay and capture a lot of litter from the Yarra River and large drains that empty onto the beach and due to the presence of the Harbour and Marina. If you live in 3182 or just love St Kilda beach and want to meet some enthusiastic like minded people who care for the beach and bay then contact the 3182 Beach Patrol and join us on our monthly beach cleans, at 9am on the second Saturday of each month. We clean a given section of the beach for an hour and then have a well earned coffee at one of the beach side cafes. Bring your own gloves, collection bags and litter pickers are provided but by all means bring your own. Visit and like us on Facebook too!
How much difference has 3182 group made in this year? Search Submit First Prev Next Last Kgs of rubbish collectedShopping bags of rubbishVolunteer HoursBottles & cans 588120463342 Standard Loaded - Standard Alternate Loaded - Executed SQL - SELECT SUM([est_kgs]) AS 'Kgs of rubbish collected', SUM([no_bags]) AS 'Shopping bags of rubbish', SUM([time_spent]) AS 'Volunteer Hours', SUM([no_bottles]) AS 'Bottles & cans' FROM [dbo].[webstun_beach_clean_activities] WHERE year([activity_date]) = year(getdate()) AND [zone_zip_code] like '3182' Select rows above and then selection an action from below to execute on your data: Copy Record Execute Selected Action
How much difference has 3182 group made in Previous years? Search Submit First Prev Next Last Kgs of rubbish collectedShopping bags of rubbishVolunteer HoursBottles & cans 6435135427462061 Standard Loaded - Standard Alternate Loaded - Executed SQL - SELECT SUM([est_kgs]) AS 'Kgs of rubbish collected', SUM([no_bags]) AS 'Shopping bags of rubbish', SUM([time_spent]) AS 'Volunteer Hours', SUM([no_bottles]) AS 'Bottles & cans' FROM [dbo].[webstun_beach_clean_activities] WHERE year([activity_date]) != year(getdate()) AND [zone_zip_code] like '3182' Select rows above and then selection an action from below to execute on your data: Copy Record Execute Selected Action
Most Recent 3182 Group Activities 3182 St Kilda Beach Clean - 13 May 2017 by 3182@beachpatrol.com.au 31 volunteers removed 65kg of rubbish from St Kilda West beach. 3182 St Kilda Beach Clean - 11 March 2017 by 3182@beachpatrol.com.au 30 volunteers removed 37kg of litter from Turkey Toms beach. 3182 St Kilda Beach Clean - 11 February 2017 by 3182@beachpatrol.com.au 40 volunteers removed 126kg of rubbish from St Kilda West beach. Page 11 of 26First Previous 6 7 8 9 10 [11] 12 13 14 15 Next Last
3182 BP Contact details If you want to contribute to keeping St Kilda beaches clean then Sign up with 3182 Beach Patrol to become a member. As a member you will get: Email updates on news and upcoming activities Free 3182 Beach Patrol Tee shirt and cap Share some together time at a local cafe after the beach cleaning session Participate in 3182 Beach Patrol social functions
Go to my Beach Group Albert Park3206 GroupPort Melbourne3207 GroupElwood3184 GroupSt Kilda3182 GroupBrighton3186 GroupSo. Melbourne3205 GroupSandringham3191 GroupMentone3194 GroupRicketts Point3193 GroupHampton3188 GroupParkdale3195ParkdaleAspendale3195AspendaleChelsea3196 GroupWilliamstown3016 GroupRye3941Rye GroupSeaford3198 GroupFrankston3199 GroupWerribee3030 GroupMordialloc3195 MordiAltona3018 GroupTootgarook3941TootgarookDromana3936 GroupMt Eliza3930 GroupRosebud/McCrae3939_3938Carrum3197 GroupMornington3931 GroupGeelong City3220 GroupBellarine322B GroupMt Martha3934 GroupWarrnambool3280-3284 Group
Next 3182 Beach Clean Search Submit First Prev Next Last Cleaning DateTimeActivity Details 14-Dec-20199 amMeeting at Marina Reserve Standard Loaded - Standard Alternate Loaded - Executed SQL - SELECT TOP 1 [Id], (SELECT REPLACE(CONVERT(VARCHAR(11), [Clean_Date], 106), ' ', '-')) AS 'Cleaning Date' ,[Starting_Time] AS 'Time' ,[Activity_Details] AS 'Activity Details' FROM [dbo].[webstun_beach_cleans_upcoming] WHERE [Clean_Date] >= getdate() AND [Zone_zip_Code] = '3182' ORDER BY [Clean_Date],[Starting_Time] DESC Hide Column - Id Select rows above and then selection an action from below to execute on your data: Copy Record Copy Record Copy Record Execute Selected Action
Last 3182 Group Data Search Submit First Prev Next Last Activity DateNo. bagslitter - KgHrs 09-Nov-201925106100 Standard Loaded - Standard Alternate Loaded - Executed SQL - SELECT TOP 1 [Id], (SELECT REPLACE(CONVERT(VARCHAR(11), [activity_date], 106), ' ', '-')) AS 'Activity Date' --,[zone_zip_code] AS 'Beach' --,[activity_summary] AS 'Today’s story' --,[activity_story] AS '' ,[no_bags] AS 'No. bags' ,[est_kgs] AS 'litter - Kg' ,[time_spent] AS 'Hrs' -- ,[Common_item_1] -- ,[Common_item_2] -- ,[Common_item_3] FROM [dbo].[webstun_beach_clean_activities] WHERE [zone_zip_code] like '3182' ORDER BY [activity_date] DESC Hide Column - Id Select rows above and then selection an action from below to execute on your data: Copy Record Copy Record Execute Selected Action
Last 3182 Group Activity 3182 St Kilda Beach Clean - 9 November 2019 by 3182@beachpatrol.com.au100 volunteers removed 106kg of rubbish from St Kilda West beach.
In this year Search Submit First Prev Next Last Most Common Items selected Cigarette butts Plastic chip bags and confectionary wrappers Plastic fragments >5 cm Standard Loaded - Standard Alternate Loaded - Executed SQL - SELECT TOP 3 [Common_item_1] AS 'Most Common Items selected ' FROM (SELECT [Common_item_1] FROM [dbo].[webstun_beach_clean_activities] WHERE id > 120 AND [zone_zip_code] like '3182' UNION ALL SELECT [Common_item_2] FROM [dbo].[webstun_beach_clean_activities] WHERE id > 120 AND [zone_zip_code] like '3182' UNION ALL SELECT [Common_item_3] FROM [dbo].[webstun_beach_clean_activities] WHERE id > 120 AND [zone_zip_code] like '3182' ) t GROUP BY [Common_item_1] order by count ('Most Common Items selected') desc Select rows above and then selection an action from below to execute on your data: Copy Record Execute Selected Action
Spotting plastic nurdles This year todate - Recording started after Oct 2015 Search Submit First Prev Next Last None100+1000+ 1000 Standard Loaded - Standard Alternate Loaded - Executed SQL - SELECT SUM (CAST([nurdles_none] as int)) AS 'None', SUM (CAST([nurdles_100] as int)) AS '100+', SUM (CAST([nurdles_1000] as int)) AS '1000+' FROM [dbo].[webstun_beach_clean_activities] WHERE --[activity_date] > DATEADD(year,-1,GETDATE()) year([activity_date]) = year(getdate()) AND [zone_zip_code] like '3182' Select rows above and then selection an action from below to execute on your data: Copy Record Execute Selected Action
In previous years Search Submit First Prev Next Last None100+1000+ 6540 Standard Loaded - Standard Alternate Loaded - Executed SQL - SELECT SUM (CAST([nurdles_none] as int)) AS 'None', SUM (CAST([nurdles_100] as int)) AS '100+', SUM (CAST([nurdles_1000] as int)) AS '1000+' FROM [dbo].[webstun_beach_clean_activities] WHERE year([activity_date]) != year(getdate()) AND [zone_zip_code] like '3182' Select rows above and then selection an action from below to execute on your data: Copy Record Execute Selected Action