Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [unique-id]

Unique identifier is any identifier which is guaranteed to be unique among all identifiers used for those objects and for a specific purpose.

2
votes
1answer
22 views

How to export a unique ID field of a geopackage

When I am converting my geopackage file in shapefile, the unique ID field is not exported. I could duplicate it before exportation, but I wanted to know if it could be done in one step, in order not ...
1
vote
1answer
34 views

New ID in QGIS not duplicated [closed]

I work mainly with ArcGIS in backoffice, but use QGIS for some field data maintenance, the challenge is that: The info worked in office has about 4.5M records, but for maintenance purposes, we create ...
0
votes
0answers
34 views

Keeping Unique Polygon ID to new output feature using SAGA?

I'm currently trying to clip multiple polygons with an underlying vector layer. I'm doing this with SAGA | Vector polygon tools | Polygon clipping. But when it gives me the output feature, it doesn't ...
1
vote
0answers
109 views

Make Query Layer - field not available as unique identifier when using NVL [duplicate]

I need to create a spatial view with Make Query Layer. My query includes outer joins, so I must combine every table's ID field to create a unique identifier. Since there might not always be a child ...
0
votes
1answer
37 views

Field Calculator: Prefixed, padded IDs from a number field

Using the Field Calculator, I want to create prefixed, padded IDs from an existing number field. By "padded", I mean I want the IDs to have a specific number of characters, regardless of how many ...
0
votes
3answers
231 views

Sequential IDs with field calculator: Pad a prefixed field to specific length

I have an ID field that is a text datatype. The IDs in the field have a prefix, and are padded with zeros to always be a specific length. Examples: INSP000098 INSP000099 INSP000100 INSP000101 I ...
1
vote
1answer
112 views

Find records with highest value based on unique ID

I'm trying to find a way to return all records that have the highest value in a field for each set of unique IDs. The attached table shows what I'm trying to achieve. The highlighted records would be ...
2
votes
1answer
158 views

non-editable date / UUID is not saved in attribute table

I'm using QGis 2.14.12 Essen on Windows 7 Professional. I want to set up a project that includes a feature class which has a non-editable° creation_date field and a non-editable UUID field. I have ...
1
vote
1answer
83 views

Split line with UNIQUE NOT NULL attribute

I have the same problem described here I am working with QGIS 2.18.10 and postgis 9.4. Is there a way to make QGIS able to split the line and insert in the constrained field the expression "nextval('...
1
vote
0answers
36 views

Why do the values of fields change after choosing unique identifer , SDE

I have a large dataset table from an SDE (SDE is the term my company uses to refer to this .under its properties (Oracle Enterprise Geodatabase). When initiated adding the table dataset to my ArcMap....
1
vote
0answers
54 views

Auto-populate “from” and “to” attribute fields of line layer with Unique IDs of points from point layer?

I have a line layer where each line segment is snapped to 2 of the points from our point layer in QGIS. Each point has a Unique ID which I need to carry over automatically to a "from_point" field and ...
1
vote
1answer
419 views

Is gid field guaranteed to exist in PostGIS?

I've seen the gid field/column in a lot of PostGIS tables and questions. It seems to be a unique ID often available (see e.g. In PostGIS is it possible to create a View with a unique ID?) My ...
1
vote
0answers
334 views

Load PostgreSQL table with composite primary key to QGIS

I would like to load a PostgreSQL table without geometry and with a composite primary key in QGIS (there is no unique column, see below). This yields “ERROR” in all cells. It is not resolved by adding ...
2
votes
1answer
125 views

Desired Unique ID Field not showing

I am trying to do an ordinary least squares on some data, and the value field for the 'Unique ID Field' that I want to select isn't appearing, so I'm not able to run my ols. Has anyone encountered ...
1
vote
1answer
171 views

Need unique id and to select for polygons by size after ST_Dump, ST_Intersection

I have two polygon tables, 'aa_poly_edited' and 'fields'. I am reducing the size of both (ST_Buffer), then intersecting, then using ST_Dump because after the intersection I am getting a couple of ...
1
vote
1answer
247 views

How can I create a numeric field (not ObjectID) with a unique number for each record?

I need to do some analysis in ArcGIS, export the data to Excel, do some more analysis, import the results back to ArcGIS, and join the resulting table back to one of the original feature classes. Am I ...
10
votes
2answers
857 views

Polygon intersection using QGIS virtual layers

I'm trying to intersect polygon geometries in QGIS by using a virtual layer: SELECT sbqry.rowid AS gid, sbqry.geom FROM (SELECT ST_Intersection(land_parcels.geometry, flood_zone....
2
votes
0answers
30 views

numbering of features when dissolving non-contiguous polygons

I have dissolved polygons together to make feature A. Some of the polygons are contiguous and some are not. Therefore, there is a unique row for each feature (singlepart to multipart). In ArcGIS or ...
2
votes
0answers
147 views

QGIS - Split a line having attributes with UNIQUE constraint

I am using QGIS with a PostgreSQL/PostGIS database, where the lines table (named 'segments'), besides the integer serial primary key, has a UUID column having a UNIQUE constraint. Trying to split a ...
1
vote
1answer
79 views

Coding names with a uniqueid starting form 001 but not exceeding three digits

I'm trying to code the names from geo database the total records of names are 957 and i want each name to have the uniqueID and it should not exceed three digits. starting from 001. The below script ...
1
vote
1answer
193 views

using qgis to split geometry in postgis: how to add unique id and copy original data in linked tables

We have set up a postgis database to manage all our old shapefiles. There is one table that contains the geometry and some basic information. There are several tables linked to that in a 1:m ...
6
votes
1answer
794 views

How to create a sequential unique id by groups?

I'd like to use the field calculator in QGIS to create a unique feature (polygon) id that reflects different levels in a geographic hierarchy. So say I have a REGION attribute within which there are ...
1
vote
1answer
293 views

How to calculate sum for unique values in a model?

I have two layers. A layer represented by a fishnet and a layer represented by certain boat routes. After I intersect them I want to be able to calculate the sum and max value for certain ...
0
votes
1answer
1k views

Unique ID script field calculator

I need to generate a unique id using field calculator in ArcMap. I am a student and I am having problems finding the script or getting auto increment to work or anything else.
0
votes
2answers
111 views

How to make interactive OpenStreetMap layers in TileMill?

If I'm reading the UTFGrid spec right, you can only have 65,501 different interactive features. Or more precisely, every feature needs a unique ID in the range 0-65501. TileMill uses UTFGrid for its ...
4
votes
2answers
1k views

Calculating unique ID value for a field in QGIS using python

I am trying to calculate a unique ID field for a vector layer in qgis, using python. I found some code to calculate attribute values, and tried to increment the value in the expression, but it doesn't ...
4
votes
2answers
3k views

Enforcing unique values in field when editing in ArcMap?

I am working on a geodatabase. In some of my features, I would like to add a field, in which I will type the values on my own. On this field no duplicates must be allowed. In other words I want it to ...
16
votes
8answers
16k views

Is there a way of auto_increment for the ID column in QGIS

I'm creating a fictive map and so I need to create lots of points, lines and for sure polygons. Later on I export my data as geojson. But before that I aways have to go and give every element an ...
1
vote
1answer
398 views

How to symbolize based on feature class and assign a unique value per point?

I am trying to produce a map in ArcGIS 10.1 that symbolizes by feature class but also assigns a unique number (as part of the symbol) to each location that will relate to a table embedded in the map ...
1
vote
2answers
587 views

Is there a way to add an autoincrementing primary key field to an existing spatialite table/layer?

I know that I can add a new column to a spatialite table either through the Database Manager (Edit Table – Add Column) or through the Attribute Table – Field Calculator (create new field) but I don´t ...
1
vote
0answers
54 views

Unique ID in ArcMap 10.2 [duplicate]

In an attribute table, how should I go about adding a Unique ID into a field? For example, I have a Water Meter points layer with an attribute table but I need a field that list them numerically with ...
3
votes
1answer
888 views

How to add an ID based on attributes in ArcMap 10.1

Given are: a polygon shapefile/feature class (FC) containing municipal districts a point shapefile/FC containing locations of, lets say, trees. My goal is to append an unique value (1, 2, 3, ...) to ...
1
vote
1answer
3k views

add unique IDs to mutiple polygons using loop or apply function

I want to add a unique ID (row number) for each polygon in a SpatialPolygonsDataFrame. I'm new at working with spatial data (and programming) so bear with me please. The goal is to merge all polygons ...
6
votes
1answer
352 views

Calculating a Unique ID on a Subgroup of Polygons

I would like to assign a unique ID to polygons in a dataset. The catch to my issue is that I would like polygons that fall within a polygon to have the same unique ID. My example is related to ...
3
votes
2answers
1k views

Creating a new integer field based on text in a different field - ArcGIS 10.1

I need to create a new integer field based on another text field. All instances of a the same text string in the existing field should be assigned the same number (starting at number 1). Can I do this ...