Skip to main content

Questions tagged [autoincrement]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0 votes
0 answers
48 views

Autoincrementing new features in text field for QGIS and QFIELD

I am trying to build a project/template for QFIELD for our data collection in the field. I got most of it working but one feature seems to challenge me beyond my comprehension. My layer file has ...
Johannes314's user avatar
0 votes
1 answer
55 views

How to generate sequential numbers for list of input table fields written to a text file (ArcMap script tool)?

In order for a script tool I'm writing in ArcMap to read fields in a source CSV correctly as text, I need to automate the writing of a shema.ini file in the source directory. In order to do that I ...
Paul DiGirolamo's user avatar
1 vote
1 answer
212 views

Auto-increment with expression, depending on other fields, in QField

I'm trying to auto-increment a field "ID-Station" by using an expression. The expression depends on another field, "Sampler". These are my fields : Sampler : picklist with ...
Fred's user avatar
  • 31
5 votes
1 answer
1k views

Adding automatic numbering of the "id" field in QGIS

I'm working on QGIS 3.22.6 and I would like to find a way for my "id" column to be automatically numbered as geometry is added. I am currently using maximum("id") + 1 within the '...
joeliketoe's user avatar
3 votes
2 answers
160 views

Adding parcel number to site when there are many sites in QGIS

I have a PostgreSQL table with 7000 records relating to grounds maintenance. Each site has a site reference number and I want to assign a sequential parcel number within each site starting at 1 to n. ...
RBCMark's user avatar
  • 397
1 vote
2 answers
284 views

How to set up incremental unique ID grouped by devices in QGIS form?

I'm building a huge form to be used in QField for wetland surveys. The form will be used by several people on different devices at the same time, on the same project. The project is composed of a ...
Matpar_McWolfie's user avatar
0 votes
1 answer
1k views

Calculate Field in ArcGIS Pro with autoIncrement based on another attribute [duplicate]

I want to use Calculate Field in ArcGIS Pro to count up sequentially, but start over with each new group. The groups are defined by FEATUREID. Example of desired output: FEATUREID GEOMETRYID A ...
mil's user avatar
  • 11
2 votes
1 answer
71 views

How to use the field calculator to generate an autoID

I am trying to get the Field Calculator on QGIS to create an autoID and I am using this expression '5EL_' ||@row_number It works in the preview, but when executed the field is blank. How do I fix ...
Janine McMahon's user avatar
1 vote
3 answers
163 views

Auto Incrementing ID based on repetitive sequential ID and conditional parameter (ID based on two fields - arcpy) - Update Cursor

I am currently trying to generate an ID based on two conditions but I am having troubles to achieve that since I am failing to make my script work. Below the explanation and my code, I apologies if ...
cerroGIS's user avatar
0 votes
1 answer
405 views

Create field with sequential automatic alphanumeric name in QField

I've created a series of layers in QGIS to collect data in field with mobile app QField. Each layer have a rule to make its names. For example, one layer is modeled to collect corn fields. It has ...
Marcelo Franco Patané Júnior's user avatar
3 votes
1 answer
98 views

Autoincrement in pairs in QGIS

Is there a way to count in pairs in attribute table? For example to be attribute like that: 2, 4, 6, 8, 10 and so on, or 1,3,5,7.
Sorin Duru's user avatar
5 votes
3 answers
443 views

Generating unique code for features via grouping by several attributes

I have features with 3 columns of information ("material", "name", "dimension") in the Attribute table. I need these features to group - to create 4th column where ...
pazelvak's user avatar
  • 415
0 votes
0 answers
154 views

QGIS autoincrementing primary key, unique constraint error

We changed our format for our layers from GPKG to SpatiaLite. A few Layers made some problems with an unique constraint error. Funny thing, saving them as SpatiaLite again did the job most of the time....
Guest No. 1534's user avatar
1 vote
0 answers
41 views

Adding an incrementor in CalculateField_managment() expression

I am trying to recalculate a value for a field using arcpy.CalculateField_management() using a tricky expression. Currently, I am recalculating one field named REACH_ID, using another field ('CO_FIPS')...
gwydion93's user avatar
  • 1,903
9 votes
2 answers
700 views

Adding auto incremented value to existing ID

I am having a table where two columns are "ID" and "maintenance_ID". The "ID" column is unchangeable and comes from another table but the "maintenance_ID" is ...
Serggg182's user avatar
  • 621
0 votes
1 answer
234 views

Auto Increment Only Specific Features?

I'm using QField to collect geologic data in the Outback. I'm creating point data, with various fields for rock type etc. Occasionally I take samples of the rocks, and want a field that auto-...
Mike's user avatar
  • 39
4 votes
1 answer
234 views

Group by 2 fields in "Add autoincremental field" in QGIS Modeler

I'm creating a model in Modeler in QGIS3.4. I want to use a "Add autoincremental field" tool. I want to group my field by two other fields (it works when I set it "normally", not in Modeler). I think ...
ann's user avatar
  • 205
0 votes
0 answers
38 views

AutoIncrement based on Field Value [duplicate]

Is there any way to automatically restart the AutoIncrement () function based on the Field Value on ArcMap? I am developing a model in ModelBuilder to name parcels automatically. The polygons are ...
Guilherme Braghirolli's user avatar
1 vote
1 answer
213 views

Using Attribute Assistant's Autonumber or GenerateID tools in a versioned environment

Is there a workaround for using Esri's Attribute Assistant's Autonumber or GenerateID in a versioned environment without creating duplicates? re: Attribute Assistant and Versioning could Python ...
sirgeo's user avatar
  • 2,029
-1 votes
1 answer
29 views

Auto incrementing start form the second row and every second row in ArcGIS Desktop? [closed]

Subsequent to Auto incrementing every second row in ArcGIS Desktop? , how can i start the auto increment from the second field (i work with 150 fields) so the result will be:
newGIS's user avatar
  • 4,062
1 vote
1 answer
102 views

Auto incrementing every second row in ArcGIS Desktop?

How do I auto increment every second row (field type is short and I work with 150 fields) in ArcGIS Desktop 10.3.1? I saw this code in https://support.esri.com/en/technical-article/000011137 rec=0 ...
newGIS's user avatar
  • 4,062
0 votes
1 answer
3k views

How to create sequential numbers in a field by defining automatically the start, end and interval numbers?

I would like to create sequential numbers in a field called "virtual _Li". I have used the field calculator using def autoincrement() function and manually calculate the interval number. https://...
Anahita Kp's user avatar
0 votes
0 answers
138 views

How to add row number based on distinct attribute value in QGIS (version 2.18.13)? [duplicate]

I have several layers (shapefiles) that have data in groups. Each group has a distinct group name. I am trying to number each item in the layer based on its distinct group name. So, for each group ...
mapperx's user avatar
  • 1,427
11 votes
4 answers
9k views

Creating shapefile with auto increment primary key in QGIS

Is there a way to create an auto increment primary key column when creating a new Shapefile in QGIS?
mattwigway's user avatar
  • 2,937