/*
When it rains does it pour?
*/<p>SELECT
date,
wban,
stn,
year,
mo,
da,
temp,
count_temp,
dewp,
count_dewp,
slp,
count_slp,
stp,
count_stp,
visib,
count_visib,
wdsp,
count_wdsp,
mxpsd,
gust,
max,
flag_max,
min,
flag_min,
prcp,
flag_prcp,
sndp,
fog,
rain_drizzle,
snow_ice_pellets,
hail,
thunder,
tornado_funnel_cloud,
usaf,
name,
country,
state,
call,
lat,
lon,
elev,
begin,
end,
point_gis,
fake_date
FROM
`fh-bigquery.weather_gsod.all_geoclustered`
WHERE
lat IS NOT NULL
AND lon IS NOT NULL
AND lat != 0
AND lon != 0
AND lat != 1
AND lon != 1
AND lat != -1
AND lon != -1
AND lat != 2
AND lon != 2
AND lat != -2
AND lon != -2
AND lat != 3
AND lon != 3
AND lat != -3
AND lon != -3
AND lat != 4
AND lon != 4
AND lat != -4
AND lon != -4
AND lat != 5
AND lon != 5
AND lat != -5
AND lon != -5
AND lat != 6
AND lon != 6
AND lat != -6
AND lon != -6
AND lat != 7
AND lon != 7
AND lat != -7
AND lon != -7
AND lat != 8
AND lon != 8
AND lat != -8
AND lon