[Qgis-user] Null values in PostGIS

Alex Mandel tech_dev at wildintellect.com
Wed Apr 2 20:31:12 PDT 2014


On 04/02/2014 08:19 PM, samuelmesa at gmail.com wrote:
> Hello. I have a layer of meteorological stations with temporal information
> in PostGIS. Some of the stations have variables with null values. In QGIS v2.3
> (Ubuntu 13.10), null values are displayed correctly in the attribute table.
> However, when displaying the label is treated as a value of 0, similarly when
> I perform an operation interpolation (IDW algorithm from the raster menu),
> where this result should ignore null values stations.
> 
> My question is, is this a bug in QGIS?.
> 
> Attached a screenshot trying to explain the results of interpolation and
> labeled, possibly wrong with null values.
> 
> https://drive.google.com/file/d/0B9J3L0xnIeLZLWRtSkJLeXp1RzA
> 
> regards,
> 
> Samuel Mesa,
> 

Might be a bug, I would suggest creating a Postgis View that filters out
the nulls and work with that.

Thanks,
Alex




More information about the Qgis-user mailing list