Questions tagged [null]
NULL is a value for an attribute value that contains no data. Sometimes not allowed due to 'not null constraints' or slt.
190
questions
1
vote
1
answer
37
views
I can't update any attribute values in PyQGIS
I've been using PyQGIS for a few of weeks. I'd write a script which shows all earthshakes responding to given parameters, so I wrote this code:
from PyQt5.QtGui import *
from PyQt5.QtCore import ...
1
vote
0
answers
57
views
Remove all null values from attribute table and move all the other values to the left
I use ArcGIS Pro and have over 50 shapefiles. I used the Union tool to merge all the Features in one map including all the attributes.
Now I have like 10.000 Features with way too many columns.
On the ...
0
votes
2
answers
61
views
reduceRegion works but reduceRegions returns null values for all reducer
When using ee.reduceRegions() I try to estimate the mean values of copernicus landcover values within all features in a feature collection I get 'null' as a result for all reducers I have tried (mean,...
3
votes
1
answer
105
views
Missing values (NULL) handling in QGIS Statistics Panel
The handy Statistics Panel in QGIS 3.34.3-Prizren (accessible from the summation button) does not seem to recognize NULL values. I have a layer with about 10% NULL values but the Statistics Panel ...
1
vote
1
answer
59
views
Setting a Boolean field to be empty
I have a layer with a Boolean field called bool.
I can set the field value to NULL, e.g. using the Field Calculator.
When printed via Python, the values are correctly shown as None:
>>> layer ...
0
votes
1
answer
121
views
ArcGIS Pro 3.1.2 change only blank selected cells in attribute table
I am using ArcGIS Pro 3.1.2. Is it possible to change only the null values cell in a selected dataset? I could have export the selected features as a new shapefile. Select the null values and replace ...
2
votes
0
answers
56
views
Handling Nulls with QgsVectorLayer.getFeatures() and GeoDataFrame.from_features()
I am trying to convert selected features in a QgsVectorLayer to a GeoDataFrame. The input layer contains values including nulls across multiple floating, integer or string columns.
For Example:
When ...
3
votes
2
answers
214
views
QGIS expressions: creating an array based on integer fields returns 0 for field value NULL
Problem
I use QGIS expressions (tested in QGIS 3.32.3 Lima and 3.34.0 Prizren on Win 10) to create an array based on attribute fields like array("field1,"field2"). I have fields of type ...
2
votes
2
answers
240
views
Writing GeoDataFrame to GeoJSON without Null values in GeoPandas
I have a GeoPandas GeoDataFrame:
geometry col0 col1 col2 col3
0 POINT (0.00000 3.00000) A A A NaN
1 POINT (1.00000 4.00000) B B NaN NaN
2 POINT (2.00000 5....
3
votes
1
answer
92
views
Remove columns with NULL values from QGIS print layout attribute table
I have an attribute table in my QGIS print layout that only includes features within the map extent. I want that table to only show columns that have non-NULL values for that feature set, i.e. if the ...
2
votes
1
answer
56
views
Allowing null outputs when mapping over FeatureCollection in Google Earth Engine
I have code working that extracts the area of forest loss from the Hansen Global Forest Change dataset for each available year and attaches it to the properties of a mapped FeatureCollection. This ...
0
votes
0
answers
70
views
Why gdal_calc.py returns 0 (Zeros) instead of NaN in the output?
Why this gdal command returns 0 (zeros) instead of NaN in the outfile?
gdal_calc.py -A aa.tif --outfile="out.tif" --type=Float64 --NoDataValue=nan --co="COMPRESS=DEFLATE" --format ...
4
votes
1
answer
116
views
Deleting NULL geometries and duplicate nodes from table using PostGIS
I run the command to delete null geometry from a table:
delete from table where geom is null
And delete duplicate nodes by running the command:
update table set geom = ST_Multi(ST_Simplify(geom,0));
...
3
votes
2
answers
154
views
Deleting contents of all entries in field in QGIS Attribute table
In QGIS, how can you delete all of the entries in a field in an attribute table? If you go to a particular entry in a field, you can delete that entry, but how can you delete all of the entries in the ...
0
votes
0
answers
31
views
Gstat outputs NULL when using variogram() function
I am trying to do a kriging interpolation on a fake data set to familiarize myself with gstat. This code has worked before on a larger df but for some reason when I try to make the variogram, the ...