remote_access | remotely control your android / mac / windows from browser | Automation library

The issue here is how the netCDF is written. It comes in the discrete sampling geometry (DSG) format, which is different than the typical gridded format. As a result, the mask computed here is only valid for the Lat and Long variables. For the data variables, a new mask has to be computed, based on the valid stations that remain after the initial mask is calculated. The following code adapts the original code to demonstrate this full process. Note that the loop is slow, and maybe could be refactored.

We have various "regridding" methods in Iris, if that isn't too much of a context switch for you.
Xarray explains its relationship to Iris here, and provides a to_iris() method.

Your methodology was correct, but you have to use pcolormesh instead of imshow.

This should work:

Please try with the following query

You can't specify data types for the columns when using create table as.

So I think the main thing to understand, which is explained here: is how projections are declared. The elements (e.g. Image, Points etc.) in GeoViews have a parameter called crs which declares the coordinate system the data is in, while the projection plot option declares what to project the data to for display.

In your case I think you want to display the image in the same coordinate system it is already in (Lambert Conformal), so technically you don't have to declare the coordinate system (crs) on the element at all and can just use a hv.Image (which is entirely unaware of projections).

As far as I can tell your code should already work as expected if you are using GeoViews 1.5, but here is what I would do: