Questions tagged [relation]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
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 ...
user avatar
  • 328
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 ...
user avatar
  • 31
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 &...
user avatar
  • 445
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 ...
user avatar
  • 19
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 ...
user avatar
  • 1,478
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 ...
user avatar
  • 326
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 ...
user avatar
  • 121
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 ...
user avatar
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 ...
user avatar
  • 2,219
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 ...
user avatar
  • 1,001
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-...
user avatar
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 ...
user avatar
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 ...
user avatar
  • 1,054
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 ...
user avatar
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 ...
user avatar
  • 163
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&...
user avatar
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 ...
user avatar
  • 1,383
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: ...
user avatar
  • 11
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 ...
user avatar
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 ...
user avatar
  • 345
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?
user avatar
  • 21
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 ...
user avatar
  • 2,219