Questions tagged [autoincrement]
The autoincrement tag has no usage guidance.
26
questions
1
vote
0
answers
35
views
Calculating values incremented by geographic location in QGIS [closed]
I have a vector layer of points and I need to perform an analysis that allows me to differentiate the direction of travel and the trip number.
I thought of two ways to develop the solution but I'm ...
- 11
0
votes
0
answers
47
views
Auto-Incrementation of custom ID numbers for new entries in an ArcGIS Survey123 Form?
ArcGIS Survey123 is being used as a Public Data Entry tool that exports PDF reports. As part of the process, it is required that auto-incremented ID #'s are assigned to new entries.
The form is set ...
- 140
0
votes
0
answers
31
views
I want to increase a sample number from the last used value rather than the highest in the dataset
I have a QField project with multiple users syncing data to one cloud project. I would like to auto-increment the sample number to the last used value of the particular user rather than the last ...
0
votes
1
answer
61
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 ...
1
vote
1
answer
306
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 ...
- 31
5
votes
1
answer
2k
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 '...
- 97
3
votes
2
answers
166
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.
...
- 397
1
vote
2
answers
322
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 ...
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 ...
- 11
2
votes
1
answer
74
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 ...
- 325
1
vote
3
answers
198
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 ...
- 49
0
votes
1
answer
468
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 ...
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.
- 31
5
votes
3
answers
449
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 ...
- 415
0
votes
0
answers
165
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....
1
vote
0
answers
43
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')...
- 1,933
9
votes
2
answers
751
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 ...
- 621
0
votes
1
answer
240
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-...
- 39
4
votes
1
answer
265
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 ...
- 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 ...
1
vote
1
answer
219
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 ...
- 2,049
-1
votes
1
answer
31
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:
- 4,082
1
vote
1
answer
108
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
...
- 4,082
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://...
- 171
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 ...
- 1,447
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?
- 2,937