A message from our CEO about the future of Stack Overflow and Stack Exchange. Read now.

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.

Filter by
Sorted by
Tagged with
2
votes
2answers
30 views

Is there any way to force a loop to go until the last list object in R?

I am running a loop in R to rasterize a list of data frames and for comparison purposes I have to keep the same list length in the output. I am facing some problems with NULL objects on the list. I ...
0
votes
0answers
22 views

How can I remove missing values on QGIS?

I have a data set that uses the number -9999.000 to represent missing values. I need to remove these missing values in order to make some calculations, but I am unsure how to go about this.
1
vote
1answer
42 views

How to homogenize NA values within a .gpkg from R

I have created an SpatialPointsDataFrame in R with some data. Here is the outputs from R: > class(Fotos) [1] "SpatialPointsDataFrame" attr(,"package") [1] "sp" > class(Fotos$Azimuth) [1] "...
1
vote
1answer
53 views

Handling null inside .map in Google Earth Engine

I want to map over an ImageCollection and calculate percentiles of a region. Some images are empty for my area of interest, due to cloud masking. How do I handle something like: if variable ==null : ...
1
vote
0answers
21 views

Filtering data with NULL in QGIS [duplicate]

Working with QGIS Zanzibar. I have a data set where many values are NULL (or blank), I wish to filter the data to show only those with NULL. In the query builder I use "FieldName" = NULL, but this ...
0
votes
2answers
39 views

Replacing all <Null> values in the attribute tables of all feature classes in a FGDB with the blank (empty) ones

I need to iterate through a file GDB feature classes to replace values found in all the columns of attribute tables with the blank ones (empty''). Here is my code, that doesn't work. Truth be told I'...
5
votes
0answers
65 views

Summarize bad handling of null values?

Summarize by right clicking the field in the table of attributes is giving wrong calculations in some cases. We think is because of null values. The following table is a subset of a larger (>200k ...
3
votes
1answer
60 views

Adding id values in attribute table after digitization

I have digitized land use and land cover polygons and am curious as to why the "id" attribute (presumably automatically assigned and populated) is either NULL or blank for my polygons. Geometric ...
2
votes
1answer
78 views

Counting number of NULL values in each row using QGIS?

I'm new to QGIS and am trying to figure out how to count the number of NULL in each row and reflect the number in a new field. How would the expression look like? The image is what the table looks ...
0
votes
2answers
94 views

Trouble updating field calculatd by st_ functions

I had first run this code on several of my fields of my T1 table at the same time. UPDATE table_1 SET field_1 = liste.my_bool FROM( SELECT T1.id AS name, bool_or((ST_Contains(T2.geom, T1.geom)...
6
votes
2answers
187 views

QGIS: Cannot add negative numbers in a field

I am using QGIS 3.4 and when I finish drawing a feature (line), I try to add a negative value (-1) in the attribute dialog and it is automatically changed to NULL. The field is integer. Even if I ...
1
vote
0answers
34 views

Exporting empty fields as NULL

I am using QGIS 3.4 and I work with a shapefile and its Attribute Table with a few rows where some fields are just blank (no zero value or NULL). When I export the shapefile file to ArcGIS Pro all ...
3
votes
1answer
59 views

Converting 0 to NULL in attribute table

I am using QGIS 3.4 and I want to change all my 0 values to NULL. How can I do that in the attribute table?
3
votes
1answer
77 views

Most cells are “null” during join in QGIS?

I'm really new to QGIS and GIS software in general. I'm trying make a map travel time across different wards in a city, I have the average travel time and range between peak traffic and lowest traffic....
3
votes
1answer
241 views

Zonal Statistics is returning null values in ArcGIS Desktop?

I am using Zonal Statistics as Table to obtain the Max height from a DEM for each polygon (then Joined to the polygons). For some reason, a lot of the polygons get NULL returned. All the polygons ...
1
vote
1answer
82 views

Modifying null values in ArcPy for ArcGIS Pro?

How can I say in ArcGIS Pro if the field (String) is Null, then replace it with "No"? I was trying this: database_field.replace("Null","No") No error occurred, but the null values did not change...
2
votes
1answer
175 views

Handling field null values in PyQGIS?

I've wrote a plugin and when I was tested it I found a plugin's case of use that it has to handle with null values. I've had some research and doesnt found much about it in PyQGIS3 documentation, but ...
1
vote
1answer
497 views

Converting Text Field to Numeric in ArcGIS Pro?

I'm trying to convert text to numeric, but am unable to in ArcGIS Pro. Is there a Python function? I tried int(!FieldName!) but I think NULL values are messing it up?
0
votes
1answer
93 views

Concatenate five fields where some may be NULL

I have a trench containing five types of ducts. I have created fields the trenches: Type1, Type2, Type3, ... The values in each field are the numbers of each type of duct that the trench contains. ...
2
votes
0answers
55 views

Concatenating labels with some NULL values in QGIS? [duplicate]

I am trying to concatenate two fields into one label, where the second field sometimes has a NULL value. The first field is a numerical street address (ADR_NO) the second field is a text string (...
0
votes
0answers
64 views

Select Analysis Invalid Expression

I am attempting to select nulls from an in_memory feature layer using Arcpy's Select_analysis. Code example below, as well as, various iterations of attempts to alter the SQL query with no success. ...
2
votes
2answers
82 views

Selecting all values with <Null> by using SelectLayerByAttribute_management with input Parameter

I am trying to select all values with Null by using the SelectLayerByAttribute_management. But the Fieldname in the where-clause is alterable by using the input-parameter. That is what i tried: if ...
1
vote
3answers
63 views

Deleting blank fields in multiple shapefiles in folder using ArcPy?

I have some shapefiles and each shapefile is having some blank or zero value fields. My task is to delete blank/zero value fields for all shapefiles in the folder. I have searched for solution in ...
3
votes
1answer
235 views

Referring to Null value with ArcPy Expressions?

How do I refer to Null values in a field using an expression in Python? I've tried using the following as well as = None and =Null but nothing has worked yet: ScoreCondition = "Cond_Score(!"+...
2
votes
1answer
535 views

Blank values in attribute table don't work as null in QGIS?

I am using QGIS 3.4. I have a layer generated from the QuickOSM plugin with various pieces of OSM data. For lines 17-19 which do not have a value in the "name" attribute, I don't know why null ...
2
votes
2answers
160 views

Converting none to zero (0) in geodatabase table using ArcPy?

I have an attribute table looks like this How do I convert Nulls into 0? I've tried to set this table non nullable type but got this: while the official doc says this: At least one of them is ...
1
vote
3answers
408 views

Searching for NULL values in feature class table

I am looking for a way which I can search whole my feature class in ArcMap to find if has any NULL values on it. I know how can I do this with "Select By Attribute", but I am looking for a faster way ...
0
votes
2answers
214 views

Using cursor to delete rows with <Null> values in table using ArcPy?

I am trying to delete any record in my table that has a null value in a certain field (the Grid_Code field) and the code I have does not return any errors and seems to run fine, but doesn't actually ...
4
votes
1answer
159 views

Hiding NULL text in attributes using QGIS?

In QGIS 3, how do I hide the 'NULL' text from empty attributes? QGIS 2.18 has a setting for that, but can't find it in QGIS 3.4.
1
vote
0answers
110 views

Using Null Values in Raster To NumPy?

I am trying a convert a raster dataset [a simple 4 x 4] into a numpy array using RasterToNumPyArray. Here is my sample raster dataset: RasterToNumPyArray however, returns zero for Null values: ...
1
vote
2answers
57 views

Programmatically defining schema not working for nulls

I am attempting to create a table with appropriate schema. I have created a data dictionary with the appropriate values stored in a list. See below schema_dict = {"borough" : ["borough","TEXT","","",...
3
votes
2answers
108 views

Labeling vertical lines with Shape Length = 0 in ArcMap?

I am trying to add labels to my linear feature class. Some of my lines are vertical (i.e. I only see a point representing the start or end node of the line, because they have the same XY coordinates ...
2
votes
1answer
130 views

Condition if column from table is empty is not working?

I want to make a loop where if a column is empty in a row to do something else. The problem is that it can't determine the empty row. I tried as null, na , '',' ' and with double quotes and nothing. ...
1
vote
1answer
93 views

Why is there a NULL-entry in the “Fields and Values” section of the QGIS field calculator

In the QGIS field calculator you can choose the Fields you want to add to your field calculator expression. I wonder why there is also "NULL" listed as one option? Choosing NULL as a value makes ...
1
vote
1answer
64 views

Removing <Null> From all Fields and all Feature Classes in a GDB

Have a gdb with 13 FCs and 70 Fields in each FC (same fields). Some fields have 'Null with <> around', which I would like to remove. (Not the field itself or data point. As in set null to empty "") ...
0
votes
1answer
117 views

Changing -9999 into <null> using ArcGIS Desktop?

I am using ArcGIS Desktop 10.5. I have a shapefile with many -9999 values in multiple columns. Since I have to do mathematical calculations with the values (stuff like the numbers in row a are XY% ...
3
votes
1answer
1k views

QGIS: Delete all records/rows with NULL values

I have joined a CSV file to a shapefile by a common key in QGIS. Not all records in the shapefile and CSV had corresponding keys. This left some records in the shapefile as NULL. i.e. City ...
0
votes
1answer
80 views

ArcMap label expression returning NoneType error

I'm trying to create street range labels rounded to the nearest 100 unless a street range is less than 100 I'm using "50". I have a field l_refaddr that is a string with number ranges for a street ...
0
votes
0answers
38 views

Data type error in UpdateCursor [duplicate]

My issue is that I am getting an error statement that states the following: row[0] = row[2] / row[1] * 100 TypeError: unsupported operand type(s) for /: 'NoneType' and 'float' Here is the ...
1
vote
1answer
260 views

Meaning of NULL when using condition in gdal_calc

I am confused with the results of using a condition in gdal_calc. Initially I thought that gdal_calc was setting pixels to nodata where a condition is not met. In the documentation (http://www.gdal....
2
votes
2answers
751 views

Replace null pixels from one raster with values from another raster in QGIS

I have 2 rasters of the same area, one has some null pixels and the other one doesn't and I would like to fill in the nulls in raster 1 by values from raster 2. How to perform in raster calculator?
1
vote
1answer
58 views

Replace NULLs within a ListFields loop

I have some difficulties to change "NULL" values to zero in all "DOUBLE" fields in feature class. I have tried to make a script tool with the following Python code in ArcGIS 10.5 but it didn't work. ...
2
votes
1answer
596 views

Use gdal to set multiband raster values to no data

I need to set a 3 band multiband raster (GeoTIff) where band 1 = 0 AND band 2 = 0 AND band 3 = 0 then this is no data (0,0,0 is No Data). Not OR in each band but AND across the 3 bands. I think it is ...
1
vote
1answer
53 views

Can't assign a numeric value to a field that is set to <Null>

Within a feature class there's a number of records with a specific field (type double) set to . I've set up a cursor to assign those value a numeric number. However, I am getting an error. This is ...
0
votes
1answer
171 views

Null values being interpolates as 0 in QGIS

I have a file with data fields which I have imported as CSV. When I look at the Field Attribute Table, the empty fields appear clearly as NULL values. However when I interpolate the data, the NULL ...
2
votes
1answer
458 views

Understanding raster custom transparency options (making null data 100% transparent) in QGIS?

I have a raster with a large null area (see the solid black area in the image below). The "Band 1" value throughout this null area is -3.402823e+38. I'm trying to make sense of the result of my ...
5
votes
1answer
1k views

Batch removing null geometries

Is there a way batch remove or delete null geometries from hundreds of small polygon vector files in QGIS, while saving the new clean file to their original directories? I can't check for and fix ...
0
votes
1answer
82 views

Expression Area Statistic Results in NULL with Real Number Conversion

I am attempting to determine the ratio of a statistic to the area of corresponding geometry while accounting for outliers through a standard deviation filter. While the QGIS Expression Editor ...
3
votes
1answer
219 views

FME shapefile writer NULL values in date format fields

I have a data source with string fields containing dates formatted like 20180202120000 (YYYYMMDDhhmmss) and I would like to write these in date fields in a shapefile using FME (2016.1). UPDATE: ...
2
votes
1answer
74 views

QGIS - formula works in the attribute table fine but getting error when using the model builder

So I am using QGIS 2.18.15 Strange thing: If I go via the attribute table into the field calculator and use following formula it works just fine: if( "DB_arit" IS NULL, 0, "DB_arit" ) ...