Closed akrherz closed 2 years ago
We now have SCN 22-81 and this PDF details which appears to match the above.
Probably a good time to inventory what we have accumulated for tags over the years
dbcol | warnings types | Domain |
---|---|---|
windtag | SV.W,TO.W,MA.W | number |
hailtag | SV.W,TO.W,MA.W | number |
tornadotag | SV.W,TO.W | Observed,Possible,Radar Indicated |
damagetag | SV.W,TO.W | Catastropic,considerable,destructive,significant |
waterspouttag | MA.W | Observed,Possible |
floodtag_heavyrain | FF.W | Freeform |
floodtag_flashflood | FF.W | Freeform |
floodtag_leeve | FF.W | Occuring |
floodtag_dam | FF.W | Imminent,Occurring |
windthreat | SV.W | Observed,Radar Indicated |
hailthreat | SV.W | Observed,Radar Indicated |
So it appears a squallthreat
column is warranted and shoehorn the impact value into the damagetag
column.
PDD
generally like so
At some point, we need to reconsidering the database storage of these as we don't want too much column sprawl.