Hi Chris,
for the warning if a user is within a mile of the warned area, you could
use ST_DWithin instead of ST_Within.
Since you have EPSG 4326, I would convert the geometries into geography
types because then you can define the distance in meters (not in
degrees), perhaps like:
ST_DWithi
I'm trying to put what the warning is for the point in the polygon, I have
my wwmaster which is where all the warnings are stored, my mastergistmp
where my users are stored, I know if a user is in a severe thunderstorm
warning and a tornado warning the tornado warning will override the severe
storm
