History Flood Closures with Conditions

Road Closure Data https://gis.charleston-sc.gov/road-closures-regional/ The city began capturing road closure data in October 2015 while responding to the 1000 year flood event. Since then, the City has been refining the process to capture and retain a history of city street closures. Emergency closures are reported based on field reports from first responders and city staff operating in the field. This data is used for situation awareness during flooding events by staff and the public This is not a detailed and complete survey of inundated roads. Not all flooding events are actively mapped and not all streets impacted are captured. This information should be used as a general information tool. Tide and Weather Data Tide and weather data is collected and processed from NOAA sources and joined to the road closures using the closure start date and time. The process of calculating the joining the tide and weather data is experimental and subject to change. NOAA Weather https://www.ncdc.noaa.gov/cdo-web/datasets/GHCND/stations/GHCND:USW00013782/detail NOAA tide data api (station=8665530) https://api.tidesandcurrents.noaa.gov/api/prod/ Fields STREET – Street name as recorded by the mapper REASON – Flood, Construction, Emergency, Warning SOURCE – CPD, etc. Type – Full, partial, warning ROADCLOSUREDATE - Start Datetime ROADCLOSUREEND - End Datetime INDIDENTDATE - Start Date (no time) YEAR – Start Date Year RoadClosureHours – Calculated (Hours between start and end) CommuteHours – Calculated (6AM-10AM = Morning Commute and 3PM-7PM= Evening Commute) TideDate - Nearest High / Low tide time and date MinsUntilTide – Calculated (minutes from start to nearest High / Low tide past or future) FloodRisk Calculated for nearest high / low tide: >=8 (Major), >= 7.5 (Moderate), and >=7 (Minor) NearestHighLowTide – MLLW height of nearest high or low tide MaxTide – Highest MLLW tide of the day TideType – Tide type of nearest high or low tide TideHeight - nearest 6 minute tide reading MoonPhase - moon phase in decimal MoonPhaseDesc - Calculated <=.05 or = 1 = New Moon, between .45 and .6 = Full Moon, else Other DailyPrecipitation _Downtown – Noaa DailyPrecipitationCat_Downtown – Calculated rain categories Fastest2minWindDirection_Downtown - wind direction bearing Fastest2minWindSpeed_Downtown Fastest2minWindDirectionDesc_Downtown – calculated directionals FloodReason_6MIN– Downtown NOAA weather and 6 minute tide categories. High Tide / Rain: Rain > =.5 and tide >= 6’ , Rain / Non-High Tide: Rain >= .5’ and tide type = low , High Tide / No Rain: Rain < .5 AND tide >= 6’ , No Rain/Low Tide: FloodReason_Day – Using NOAA Max high tide for the day EventName – event name for named events