In South Africa, we have loadshedding which turns off the power for 2 hours at a specified time during the day. I'm trying to build a loadshedding schedule and was wondering how i could put these times, areas and stages combined together to give me a result - lets say i search for zone 8, it will only display the times associated with zone 8. I would also like for the user to enter the day as well. I'm trying to put this in an sql database or maybe a text file if that works better?
Here is the schedule : https://www.capetown.gov.za/Loadshedding1/loadshedding/maps/Load_Shedding_All_Areas_Schedule_and_Map.pdf
Thanks in advance