Questions tagged [relates]
The process of connecting two or more datasets having one-to-many or many-to-many relationships based on a common attribute.
181 questions
0 votes
1 answer
68 views
Foreign key disappearing in attribute table
I'm using QField to collect data in two tables which are related with a 1 to many relationship where the primary & foreign keys are a UUID. I've found that after importing my data back into QGIS, ...
0 votes
0 answers
26 views
Redirect a relationship class to a new field (same data, different type) in ArcGIS Online
I’ve got a feature layer in ArcGIS Online related to several tables using the assetid field. It looked fine on the surface until I started pushing data into the related tables via script and realized ...
0 votes
0 answers
44 views
QField crashes when adding data, QGIS not (attribute joins and relates involved)
Since I have been comparing values across two joined tables, QField crashes with any input in an attribute field, but QGIS does not. I run Win11 and QGIS 3.42.2 as well as QField 3.5.5 The project ...
0 votes
0 answers
50 views
Multiple photos added to point layer in QField Cloud project; photos being erased from referenced layer and referencing field not populating
I have a QField Cloud project on my device. In the project, there is a geopackage layer (Point Layer) that has a relation set up to take multiple photos. The relation is to a table (Table Layer). The ...
- 11
0 votes
1 answer
184 views
Appending related tables in ArcGIS Pro gives Error 999999
I am trying to append data from an old Survey123/feature layer to a new one I created last year. The main complication appears to revolve around the data having a related table. The "Update Data&...
5 votes
2 answers
346 views
Multiple names in a point
New to QGIS. Is there a way to create a Point with multiple Names in a column?
1 vote
0 answers
47 views
Auto-populating foreign keys in child table with two parent tables in QGIS form of child table
I’m working with a parent-child relationship in QGIS, where I have two parent tables (ANZ and PI) and one child table (GEOM). The GEOM table contains foreign keys "anz_id" and "pi_id&...
- 11
0 votes
0 answers
156 views
Join/relate with one to many relation
Took GIS in undergrad 10 years ago and now trying to relearn some skills for my job in urban planning. Working in ArcGIS Pro, I've got a standalone table of historic permit data that I'd like to join ...
0 votes
0 answers
137 views
Relating attachments table with a new GlobalID in ArcGIS Pro
I am not familiar with ArcGIS at all, I come from a simple QGIS background. I do not code. I have data that was collected in Survey123 using a device that did not have geolocation enabled. Instead, ...
0 votes
0 answers
44 views
QGIS Python Script for loading MS-Server Tables and create relates and Attribute Form Widgets
I have the following Python script for QGIS3, which is supposed to load spatial and non-spatial tables into a new project. Relationships are then to be set and certain links are to be created in the ...
- 17
2 votes
1 answer
410 views
How to store relationships in geopackage with QGIS
How can I store relationship in GeoPackage with QGIS and how does it function? It is hard to find an example in the help program.
1 vote
1 answer
80 views
Creating relation for duplicate lines
I have two datasets with some duplicate lines. I can select the duplicates with GRASS v.select: v.select ainput=map1 binput=map2 output=duplicates operator=equals or QGIS Select by Location: ...
- 178
2 votes
0 answers
45 views
QGIS not showing cascading relations in identify
I have 3 tables that are related as shown in figure below: I added two relaltions. The first one between Table1 and Table2 and the other one between Table2 and Table3 as shown in figure below: On ...
- 83
0 votes
0 answers
370 views
Populating field from related records on AGOL
I have a layer I would like to visualize based on related records. I understand this cannot be done directly in ArcGIS Online based on this article: Visualize data from related records using Arcade. I ...
- 338
1 vote
1 answer
98 views
Select and display 1-n relations between shape and CSV table
I have a shapefile containing parcels borders (polygons) and a csv table with owner information. I can relate these (1:n) by the parcelnumber. So by identification I can see by clicking on the ...
- 631