Questions tagged [relation]
The relation tag has no usage guidance.
22
questions
3
votes
1
answer
146
views
QGIS - Value relation values based on geometry
I am having a problem with last part of defining values in geopackage.
I have created relation values based on field values (drop-down values). Last one I want to create, is to make relation based on ...
1
vote
1
answer
86
views
ArcGIS Pro Attribute Rule to pass a value from child to parent
I have an ArcGIS geodatabase with a parent feature class related to a child stand alone table containing the various inspections made on each parent feature. Primary key is GlobalID and foreign key is ...
3
votes
1
answer
85
views
Using relations
I am using QGIS, version 3.24.0. I have a shapefile called "Map_CorrectionDEF", uniquely identify by fields "GID" and "unitcode". It is a grid cell, in which the field &...
0
votes
0
answers
12
views
ArcMap query layer versus geodatabase relationship discrepency
I have a geodatabase with relationships between tables.
objet_poly <-> objet_recense <-> detail_objet <-> mention
Now I need to filter out objects from one table based on the values ...
5
votes
1
answer
129
views
Automatically fill in attributes of parent feature in QGIS
I have a data table that holds different information about buildings in a GeoPackage. Different elements of the buildings can be entered, e.g. sometimes I only have the building as a whole, sometimes ...
0
votes
0
answers
37
views
QGIS, feature attributes form, how to configure the children table view (1-n relation)?
I have set a 1-n relation in the project properties and configured both layers' attributes forms. The children is a vector layer based on a .csv file, parent is .shp layer.
It seems to work well this ...
1
vote
0
answers
14
views
Merging queries to return ways/nodes that are within relations matching criteria using Overpass API
Motivation - I am currently processing a number of relations matching criteria and then doing an additional query to get all the ways/nodes within those relations. .
Goal - I'm trying to simplify this ...
1
vote
1
answer
21
views
Show selection of point in relation of a vector field?
I have two files,
vector "streets"
a series of point "civic numers" or "address"
I want to select a random street and have the field selection of the relative civic ...
4
votes
2
answers
199
views
QGIS Setup n:m relation to enable cross-layer search
In QGIS I want to set up a n:m relation between two tables "parcels" (polygons) and "owners" (no geometry). Both share a field index1 (containing of numbers and letters) by which ...
1
vote
1
answer
123
views
Expression-based table relation in QGIS, avoiding joins and relates
In QGIS 3.18. I have two tables, one as a part of a .shp and the other a tab-delimited .txt with no geometry:
my .shp attribute table contains a list of sites, and
my .txt table contains a list of ...
0
votes
0
answers
44
views
Opening one corresponding related table in attribute form for selected feature in multipolygon in QGIS
I have MultiPolygon A with 9 features, each feature should be described by one non-spatial attribute table with 10 - 500 features. I tried to create 9 relations like A-to-Table1, A-to_Table2 ...A-to-...
1
vote
1
answer
157
views
N:M relation in QGIS with custom form in Qt Designer
The manual: https://docs.qgis.org/3.16/en/docs/user_manual/working_with_vector/attribute_table.html#creating-one-or-many-to-many-relations describes how to create a N:M relation and how to use it with ...
3
votes
1
answer
55
views
Counting the number of relations
In QGIS I created a one-to-many relation between a polygon layer and a non-geometry table, so it has multiple lines for each feature in the polygon layer. My question now is how can I count how many ...
2
votes
0
answers
48
views
How to list relationed objects on QGIS expression for HTML tips
I have two layers with an 1-N relationship
The parent layer, "RADAR" is a point layer, while the child layer, "FAIXA_RADAR" is a tabular without geometry layer.
To make feature ...
1
vote
1
answer
137
views
QGIS best way for capturing features without geometry and child features
I have two (PostGIS) layers in my QGIS (3.18) project and I defined a relation between them.
The first layer PARENT has no geometry.
The second layer CHILD is the child layer and has a geometry.
In ...
0
votes
1
answer
115
views
Where are QuickOSM relations?
When I use quickOSM in QGIS to download OSM data, I check the "relations" option, but then?
My need is the following :
Download OSM data for a specific area
In the table for the "point&...
2
votes
0
answers
44
views
QGIS Hidden attributes not hidden in Relations
I have a PostGIS view, which a referencing layer for another layer for many to one relation in QGIS. I have hidden the following fields id, table_name, oid of the postgis view so that the user would ...
1
vote
2
answers
106
views
QGIS Atlas attributes
So I have two layers. First one is line layer (columns: id, length, address_id) and atlas is connected to it so when I change objects, map is zooming to next line. Secound is point layer (columns: ...
6
votes
0
answers
184
views
QGIS N:M relations - possibility to edit multiple features?
I have a working QGIS project with multiple relations and all is well until I try the Toggle multi edit mode for N:M relations. I'm working with QGIS 3.10+ (3.14.16) and Windows and PostGIS.
Is it ...
1
vote
1
answer
86
views
Report with relations
I collected field data containing general information about signpost sites (location, altitude, image) and specific information of the particular signs mounted to the singpost (image, direction). One ...
2
votes
1
answer
106
views
QGIS Cloud and relations
Does publishing to QGIS cloud preserve the established relations (1 to many relation) between layers? On the web map, can you see the embedded form of the Parent layer in the Child layer, for example?
2
votes
1
answer
1k
views
1-n relationship by location in QGIS
I have a polygon layer and a point layer. According to the QGIS documentation, the childlayer has to have a foreign key. Unfortunately, my child layer has none. Is there a way to form the relation by ...