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
0
votes
0answers
20 views

QGIS field-calculator time formating produces NULL

I'm struggling to format a QString attribute field to a DateTime or Date field. I've been trying the built in functions to_date to_time to_datetime of QGIS 3.10.14 and none of them seem to do the ...
1
vote
1answer
15 views

Tried to Mosaic Sentinel 2 images but my final image appeared with some overlapping Null data

I'm working on an area that required me to use three sentinel images to fully cover it, I used the "mosaic to new raster" tool in ArcGIS to merge the three images and was surprised to find ...
1
vote
1answer
21 views

Calculating only values that are not null in field using ArcGIS Pro

I'm using ArcGIS Pro, the field calculator. I want to populate a hydrant layer with hydrant inspection data. I have two fields from a joined table: field 1 and field 2. I want to populate field 1 ...
0
votes
0answers
20 views

Tabulate intersection, but I need it with null values too, not just with matching intersect

I have problem with tabulate intersection tool (In ArcGIS - ArcMap 10.7.1). The number of data is 1298 with 500 m buffer. Then i have polygons, that I need to process. I run the tool, but get the ...
0
votes
0answers
43 views

QGIS Vector Geometry Vanished

I've been working on a project, in QGIS 3.16 Hannover (we started the project a while ago, in the Bonn version, but upgraded during the duration of project). Upon project completion we've been asked ...
0
votes
1answer
30 views

Replacing Null attribute with the value of the nearest feature

I have several polygons with "Null" values that I would like to give them the "Name' of their nearest polygonal feature. As you see in the photo, the light green polygon is actually a ...
1
vote
1answer
19 views

Adding two fields in attribute table and assigning result to third field if some cells contain null values using ArcGIS Pro Field Calculator

I am using ArcGIS Pro, field calculator to add the values of two fields (Result_A and Result_B) and assign the value to new Field Combined_Result. The type for all three fields is "double". ...
2
votes
1answer
45 views

When calculating a field in an attribute table, how can I find one value out of many fields when every other field has a null value?

I have 4,018 rows of data with about 50 fields. About 45 of those fields are the same variable, but the data came from different layers, so out of those 45 fields, only one has a value for the row, ...
4
votes
1answer
28 views

Fill combobox with NULL values in PyQGIS

I'm writing a plugin that has a form with a combo box that I fill with the unique values in a field of a vector layer in the project. The problem is that there are NULL values in that column and I get ...
4
votes
3answers
132 views

Replacing all “NULL” values in multiple rows with “0”

I am looking for a way to replace all "NULL"-Values throughout multiple rows/ all "NULL"-Values in an attribute table. The table is from a SHP-File (shapefile). Is there any easy ...
2
votes
1answer
35 views

Count Blanks, Spaces, and Hardcoded Nulls

I want to get counts of Blanks, Spaces, and Hardcoded Nulls in fields using arcpy.SearchCursor. Is it possible? When I try to filter am getting None values only. I tried the below code. cursorfields ...
-1
votes
1answer
28 views

Removing 0 (NODATA) from Combochart in FeatureCollection in Google Earth Engine

I'm trying to make a combo chart based on two properties of a FeatureCollection. However, one of the properties is full of 0 which I don't want to show them on the chart. How can I not showing those ...
1
vote
0answers
38 views

AGOL “Update Data” from Excel import numeric columns with some NULL rows?

I need to append some new features into an ArcGIS Online hosted feature layer. The data has been supplied to me in an Excel file (including X/Y columns). I was intending to import it as-is using the ...
1
vote
0answers
41 views

Problem with containers in combination with the remember button

I've been searching for a solution for days. I'm using QGIS 3.14.15 on Windows 10 and created a point layer to take points with QField. I created a container with several options. In QField the ...
1
vote
0answers
38 views

QGIS: How to avoid using coalesce() in GPKG query layer for correct type casting?

I query the following layer via DB Manager: select fid, geom, cast((field2*100/field1-100) as double) as dev from table field1 and field2 are integers and have NULL values. Now in the DB manager's ...
0
votes
0answers
29 views

Inserting/Update a polygon into a field with null geometry in Oracle

How can I copy a previously created polygon that is in a temporary layer, to a field with null geometry in Oracle? I can view the field in the table, use the "Add Part" tool to create a new ...
1
vote
1answer
82 views

QGIS: Change attribute values from NULL to 0 for all attributes using Python [closed]

I have an attribute table where I have occurrences of NULL spread throughout in different attributes and features. How can I change NULL to 0 using Python for all attributes?
1
vote
1answer
196 views

Earth Engine, how to convert 0 pixel values to transparent or nodata?

I'm using the following snippet to convert canny edges to black and white to highlight boundaries. However, I want to fill the black area with transparent or NODATA, is there a way to do this in EE? ...
0
votes
1answer
168 views

Google earth engine: count number of null values per region

Following a previous post I now have some code which sets null values in an image collection to zero. I have used this code on several variables, however, I'd like to know which variables have null ...
1
vote
1answer
196 views

Google earth engine - set null band values as zero

I have a function which assigns a score depend on the value of a band, which I then map to an image collection. However, in some cases, I have null values, where no value is given. In these cases I'd ...
1
vote
2answers
165 views

PyQGIS: Inline function to replace NULL values with 0 in all fields (not coalesce)?

Now I know there are several ways to tackle this problem but so far none of the following worked for me. I got a huge attribute table out of various spatial joins so pretty much all of the fields have ...
0
votes
1answer
39 views

How to set all raster pixels within a shapefile to null?

I'm working with ArcGIS Pro 2.4.0. I have a raster dataset consisting of several plots of crops. Within each plot, there is a small ground target that has differing reflective values than the ...
0
votes
1answer
500 views

Why are values coming in as <Null> when importing table from Excel?

I'm importing a CSV file into ArcGIS Pro, I've used geoprocessing tool XY Table to Point but values have come in null. Column type is double in ArcGIS Pro. Highlighted is the column which imports null ...
0
votes
0answers
24 views

QGIS: display polygons with null attributes

I still have some polygons that have null value for the attribute "$area". I have run the geometry validation tool and it says that there are one or more polygons with errors despite none of them are ...
0
votes
0answers
77 views

Add Join of data table to shapefile in ArcGIS Pro results in “<Null>” values for 90% of the records

I'm new to ArcGIS and in over my head. I'm trying to join a shape file with a data table. The data table contains a calculated value I created in Excel. I thought this was going to be an easy, 5 ...
2
votes
1answer
354 views

Joining tables results in null values within joined part using ArcGIS Pro

I have tried various geoprocessing tools, read through the stack exchange, googled questions, and I still have not figured this out. I am trying to join a table based on GEOID field. I made sure ...
1
vote
1answer
129 views

Handling NULL values in QGIS

I am using QGIS to make some boundaries adjustments of the Italian provinces over the years. I have a shapefile with the provincial boundaries in 1961 and another one with the boundaries in 2001. No ...
2
votes
2answers
312 views

Manually adding a Null value to a string field in an attribute table in ArcGIS

When I'm in an editing session and I manually delete a value from a numeric field the value turns to null (<Null>). Manually deleting a value in a string field creates an empty string, not a ...
2
votes
1answer
556 views

ArcGIS Raster Calculator Con() set 0 values to null

In some vides appear a process separated and I would like to do this two steps in one step: set all values greater or equal to a number to 0: Con("MyRaster" >= 2800, 0 , 1) the result is called ...
2
votes
2answers
36 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
70 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
52 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] "...
2
votes
1answer
997 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
36 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
56 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'...
4
votes
1answer
118 views

Summarize bad handling of null values? [closed]

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 ...
5
votes
1answer
274 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
166 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
101 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
506 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
1answer
79 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
71 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
166 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
520 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 ...
2
votes
2answers
295 views

Join attributes by location (summary) returns NULL

I am trying to count points within polygons (311 calls by Census tract). Both shapefiles are EPSG:4326, and I've done define projection just to double-check. Every time I run "Join attributes by ...
1
vote
1answer
109 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...
5
votes
1answer
677 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 ...
3
votes
1answer
2k 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
97 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
173 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 (...