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.
174
questions
2
votes
1
answer
68
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.
0
votes
0
answers
46
views
Troubleshoot Attribute Rule to Update Parent Table
I am using ArcGIS Pro 3.2.1 and working with an Arcade expression to update a parent layer when new inspections are performed in the related table.
I have tried a 1:M relationship class with GlobalIDs,...
- 1
0
votes
0
answers
22
views
Intergraph G-Technology Generating relationships
I have tried generating relationships on Intergraph G-Technology but every time it gets to 30, it comes up saying 0 features successfully generated relationships and at the bottom left, it says please ...
1
vote
1
answer
54
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:
...
- 169
0
votes
0
answers
83
views
QGIS - Select Features by Value issues
I have a point shapefile (parent) which is related to a CSV table (child) through a one-to-many relation (Project > Properties > Relations > relationship strength: association).
When I click ...
- 518
2
votes
0
answers
32
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
115
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
76
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 ...
- 537
5
votes
1
answer
887
views
Creating relationships at the database level using QGIS and Geopackages
I've been trying to work out a way to create relationships at the database level of geopackages.
Simple scenario for example - Table 'clearing' is related to table 'sourcefile'. The solution is to ...
- 3,576
1
vote
1
answer
762
views
ArcGIS Pro: Export file geodatabase feature class including JOINs and RELATEs
Question: Is there an approach to export a File Geodatabase Feature Class with the content resulting from all of its JOINs and RELATEs with File Geodatabase Tables from the same Esri geodatabase file ...
- 467
2
votes
1
answer
376
views
QGIS: Label features using field attributes from a one to many related table
Using QGIS it is possible to easily label features from related tables with a 1 to 1 JOIN. If the relationship is one to many and Project Properties RELATIONS are defined, then only the last related ...
- 23
0
votes
1
answer
106
views
Avoid adding a bunch of new features for one static location for repeat sampling efforts in Field Maps
I have built several maps and forms for their use in Field Maps for various projects. Most have been creating new features and filling out the form for the new location where we sampled. However, we ...
- 1
2
votes
0
answers
266
views
QGIS Linking multiple layers in polymorphic relationship
I am creating a tree survey system in QGIS. There will be three geometry layers (called 'Single Trees', 'Line of Trees & Hedges', 'Groups of Trees') and each of those layers has a 'TreeUUID' field ...
- 157
1
vote
0
answers
317
views
Auto-populate a field based on information in two different fields
I am attempting to auto-populate a field using matching information in two different fields in ArcGIS Pro.
The field that I am trying to populate is "Unique_ID." Table #1 includes three ...
- 11
1
vote
1
answer
693
views
QGIS aggregate expression to filter selected features in 2nd layer
I´m working with two layers in QGIS:
First one with point geometries representing water quality sampling places (LAYER A).
The second is a spreadsheet (no geometries) that contains pollution values ...
- 11