Task 1) In the HSDS tab of this Google Sheet (https://docs.google.com/spreadsheets/d/13uMtCLXOmrZezZP6n9Gj0LRZASOqoZUTrkfDUxMqW64/edit?usp=sharing), the "monday_hours" "tuesday_hours" "wednesday_hours" "thursday_hours" "friday_hours" "saturday_hours" "sunday_hours" fields are highlighted red. Convert their information into the "weekday" "opens_at" "closes_at" "add_day" "add_hours" columns highlighted yellow. Here's how:
The HSDS schedule format has a "weekday" field to be populated with "Monday" "Tuesday" Wednesday" "Thursday" "Friday" "Saturday" "Sunday" (separate by commas if multiple). For the days listed under "Weekday", show the times for which that service window opens under "opens_at" and closes under "closes_at". If there are additional service times that fall outside that consistent schedule, indicate the days of that service in "add_day" and the hours in "add_hours."
For example: To transform "M-F, 5:30-8:30pm; S & Su, 9am-12pm" to HSDS, you would do Weekday = ""Monday" "Tuesday" Wednesday" "Thursday" "Friday", opens_at = "5:30 PM" and closes_at = "8:30 PM". Add_day would be "Saturday" and "Sunday" and add_hour would be "9:00 AM - 12:00 PM".
Task 2) Split up the "geocode.coordinates" field (highlighted red) into the latitude and longitude fields (highlighted yellow). The first number of the pair (like -121.9059625] will be longitude and the second number (like 37.3401537]) will be latitude.
Task 1) In the HSDS tab of this Google Sheet (https://docs.google.com/spreadsheets/d/13uMtCLXOmrZezZP6n9Gj0LRZASOqoZUTrkfDUxMqW64/edit?usp=sharing), the "monday_hours" "tuesday_hours" "wednesday_hours" "thursday_hours" "friday_hours" "saturday_hours" "sunday_hours" fields are highlighted red. Convert their information into the "weekday" "opens_at" "closes_at" "add_day" "add_hours" columns highlighted yellow. Here's how:
The HSDS schedule format has a "weekday" field to be populated with "Monday" "Tuesday" Wednesday" "Thursday" "Friday" "Saturday" "Sunday" (separate by commas if multiple). For the days listed under "Weekday", show the times for which that service window opens under "opens_at" and closes under "closes_at". If there are additional service times that fall outside that consistent schedule, indicate the days of that service in "add_day" and the hours in "add_hours."
For example: To transform "M-F, 5:30-8:30pm; S & Su, 9am-12pm" to HSDS, you would do Weekday = ""Monday" "Tuesday" Wednesday" "Thursday" "Friday", opens_at = "5:30 PM" and closes_at = "8:30 PM". Add_day would be "Saturday" and "Sunday" and add_hour would be "9:00 AM - 12:00 PM".
Here is an example of the proper format: https://docs.google.com/spreadsheets/d/1Hxi1oHts9NNa0W-AsaN183DPzoPqTsuM5w4sgi3rmM8/edit?ts=5fc801c5#gid=554365392
Task 2) Split up the "geocode.coordinates" field (highlighted red) into the latitude and longitude fields (highlighted yellow). The first number of the pair (like -121.9059625] will be longitude and the second number (like 37.3401537]) will be latitude.