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
道路封闭数据集（Road Closure Data） 数据源地址：https://gis.charleston-sc.gov/road-closures-regional/ 该数据集由美国查尔斯顿市于2015年10月在应对千年一遇洪水事件期间启动采集工作，后续持续优化道路封闭信息的采集流程与历史留存机制。应急性道路封闭信息基于一线应急人员及市政外勤人员的现场上报生成。本数据用于工作人员与公众在洪水事件期间开展态势感知，并非对受淹道路的详尽完整普查；并非所有洪水事件均会被主动标注，亦非所有受影响道路均会被纳入采集范围，仅可作为通用信息工具使用。 潮汐与气象数据 潮汐与气象数据采集自NOAA官方数据源，并通过道路封闭事件的开始日期与时间与道路封闭数据集进行关联匹配。当前关联潮汐与气象数据的流程处于试验阶段，后续可能进行调整。 1. NOAA气象数据源：https://www.ncdc.noaa.gov/cdo-web/datasets/GHCND/stations/GHCND:USW00013782/detail 2. NOAA潮汐数据API（站点编号=8665530）：https://api.tidesandcurrents.noaa.gov/api/prod/ 数据字段说明 1. STREET：测绘人员记录的道路名称 2. REASON：道路封闭原因，可选值包括洪水（Flood）、施工（Construction）、应急（Emergency）、预警（Warning） 3. SOURCE：信息上报来源，例如CPD等 4. TYPE：道路封闭类型，可选值包括全封闭（Full）、半封闭（Partial）、预警（Warning） 5. ROADCLOSUREDATE：道路封闭开始的日期与时间 6. ROADCLOSUREEND：道路封闭结束的日期与时间 7. INDIDENTDATE：事件开始日期（不含具体时间） 8. YEAR：事件开始日期对应的年份 9. RoadClosureHours：计算字段，为道路封闭持续时长（单位：小时，即封闭开始与结束的时间差） 10. CommuteHours：计算字段，用于标记封闭时段是否属于早高峰（6:00-10:00）或晚高峰（15:00-19:00） 11. TideDate：距离封闭事件最近的高潮/低潮潮汐时间与日期 12. MinsUntilTide：计算字段，为封闭开始时间至最近一次高潮/低潮潮汐的间隔分钟数 13. FloodRisk：基于最近一次高潮/低潮潮汐计算的洪水风险等级：≥8为重大（Major），≥7.5为中等（Moderate），≥7为轻度（Minor） 14. NearestHighLowTide：最近一次高潮/低潮潮汐的平均低潮面（Mean Lower Low Water, MLLW）高度 15. MaxTide：当日最高MLLW潮汐高度 16. TideType：最近一次高潮/低潮潮汐的类型（高潮或低潮） 17. TideHeight：最近一次6分钟间隔的潮汐读数 18. MoonPhase：以小数形式表示的月相相位值 19. MoonPhaseDesc：计算得到的月相描述：≤0.05或=1为新月（New Moon），0.45至0.6之间为满月（Full Moon），其余为其他月相 20. DailyPrecipitation _Downtown：市中心区域日降水量（源自NOAA） 21. PrecipitationCat_Downtown：市中心区域日降水量等级（计算字段） 22. Fastest2minWindDirection_Downtown：市中心区域2分钟持续最大风速的风向方位角 23. Fastest2minWindSpeed_Downtown：市中心区域2分钟持续最大风速 24. Fastest2minWindDirectionDesc_Downtown：基于风向方位角计算得到的风向描述 25. FloodReason_6MIN– Downtown：基于NOAA市中心气象数据与6分钟间隔潮汐数据分类得到的洪水成因，共四类： - 高潮位+强降雨：降雨量≥0.5英尺且潮汐高度≥6英尺 - 非高潮位+强降雨：降雨量≥0.5英尺且潮汐类型为低潮 - 高潮位+弱降雨：降雨量<0.5英尺且潮汐高度≥6英尺 - 弱降雨+低潮：无上述组合情况 26. FloodReason_Day：基于当日NOAA最高高潮潮位计算得到的洪水成因 27. EventName：对应命名事件的事件名称
