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.

Filter by
Sorted by
Tagged with
0 votes
0 answers
18 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,...
Mikhayla's user avatar
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 ...
Luke Smith's user avatar
1 vote
1 answer
50 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: ...
Jeshua Lacock's user avatar
0 votes
0 answers
72 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 ...
HyPhens's user avatar
  • 516
2 votes
0 answers
30 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 ...
Sajjad's user avatar
  • 83
0 votes
0 answers
32 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 ...
RossV's user avatar
  • 328
0 votes
0 answers
38 views

Symbology showing dyadic relationships between polygons using QGIS

I have an interesting styling challenge which I don't know how to begin to solve. I have polygons which have qualitative (string) dyadic relationships with each other, and I need to make a series of ...
veryloudcartographer's user avatar
1 vote
1 answer
74 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 ...
Marek's user avatar
  • 547
4 votes
1 answer
553 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 ...
nr_aus's user avatar
  • 3,455
1 vote
1 answer
484 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 ...
stonebe's user avatar
  • 445
2 votes
1 answer
268 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 ...
Zapper's user avatar
  • 23
0 votes
1 answer
83 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 ...
Ken's user avatar
  • 1
2 votes
0 answers
210 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 ...
Nathan's user avatar
  • 157
1 vote
0 answers
265 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 ...
ajstokes's user avatar
1 vote
1 answer
552 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 ...
janavaarro's user avatar
1 vote
1 answer
368 views

QGIS - expressions with fields from a related layer

In QGIS I have: a point layer; a table; a relation (Project > Properties > Relations) 1 to many between the points and the table; What I need to do is to set a graduated symbology on the layer ...
HyPhens's user avatar
  • 516
1 vote
1 answer
66 views

Can I save nested Layers in a long format table?

I want to create a QGIS project for sampling crustaceans in rivers using Qfield. I want to collect environmental data as well as the abundance of each species found in different microhabitats. So far ...
Daniel97's user avatar
2 votes
1 answer
160 views

Filtering an aggregate function in a many to many relationship to only records related to current record in QGIS

I have two tables related as an N-M relationship: Sites: id, geometry Jobs: id, jobnum, ..... Sites_Jobs: id, site_id, job_id I want to define a label for the Sites layer that displays all the ...
Andrew Toole's user avatar
3 votes
2 answers
168 views

Building a WFS whose features hold lists of records

I've got two tables in a PostgreSQL/PostGIS database: UTM (geom geometry(Polygon,25830),utmcode character varying(6)) Species (species_name character varying(50), utmcode character varying(6), ...
jpinilla's user avatar
  • 3,230
0 votes
0 answers
37 views

Formulating Table Relate using ArcMap

I'm moving our floorplans for a major organization into GIS to take advantage of analytical capabilities. I've prepared and figured polygons for each classification layer I want but when it comes to ...
MCon's user avatar
  • 13
1 vote
0 answers
48 views

Relate two tables with different number of entities

I want to join two layers: One which has information about the height and width of the wind turbines (fields to join) with only 4 or 5 entities or sometimes less, and the other is a layer with lots of ...
DobleG_95's user avatar
0 votes
0 answers
98 views

Filter by field value in a child table

In QGIS, I would like to filter the display of a parent table in (a postgis point theme) by the values in a field from a child table (a postgresql table in the same db). The parent table and child ...
Steve Wernke's user avatar
1 vote
1 answer
853 views

List string values from multiple related tables in ArcGIS Pro popup

I have a polygon feature class (BIA tribal boundaries) with three relationship classes set up to relate to three separate tables, each with a 1:M cardinality from the feature class to the table. I ...
Anna Riling's user avatar
0 votes
1 answer
247 views

Exporting 1:M relate in ArcMap

I am using ArcMap 10.8. I have a relate established between a US Census shapefile and other US federal data (FCC form 477). The 477 data is going to have many records for each census block. A relate ...
Mike Hammett's user avatar
1 vote
2 answers
145 views

Layer Symbology based on child table value

I have a point layer (Dormouse) linked to a child geometry-less table (DormouseSurveyData) with a 1-n relationship. I am trying to set up the symbology of the point layer to change color dependent on ...
Nathan's user avatar
  • 157
0 votes
0 answers
64 views

How to edit two field have the same domain at the same time in ArcGIS?

I have two layers (Parcel and Building ) with fields that have the same domain, for example ; layer (Parcel) has fields with names ("Building status", "Land Use") with domains (...
sameh mahmoud's user avatar
1 vote
0 answers
130 views

Display Related Data in Popups for Grouped Layers

I am creating a web map from a map service that contains related data. I want to display the related data in my point feature popups. I thought it would be easy to pull in the related tables in Arcade ...
Kristen's user avatar
  • 11
2 votes
2 answers
957 views

Joining table to feature class based on two or more fields using ArcMap

I have a table and I would like to join it to a polygon feature class but based on two columns. As in if the polygon has the same values in in column A and column B it will join. If the table has the ...
xxxD's user avatar
  • 109
0 votes
0 answers
39 views

Creating hyperlink with relative path in related standalone table using ArcMap [duplicate]

I have a polygon feature class which has a related table (1:n Relationship) containing the relative path of pdf documents in a field. Using the Info-Tool to click in a polygon in ArcMap 10.7 I can see ...
Robert Buckley's user avatar
1 vote
2 answers
867 views

Rule-based symbology based on related layer in QGIS

I'm working with QGIS I have two layers: Layer 1: has the id and geom columns (multypolygon layer) Layer 2: has the id, gid and type columns (table layer). The value gid of layer 2 is the foreign ...
ali_zaga's user avatar
3 votes
0 answers
183 views

Enforce that all "Enforce expression constraints" of child tables are valid before I can save the parent feature

In QGIS 3.16 I set up a relation between two tables. In the child-table I set a constraint-expression and checked "Enforce expression constraints". If I add one or more features to the child-...
user191847's user avatar
1 vote
1 answer
622 views

How I can make a child table appear in the parent table of attributes in QGIS?

I used "relate" to connect a many to one child table to a parent table (addresses to land parcels, one parcel can have several parcels) and I see it in the "form view but it is not ...
Philippe Morgan's user avatar
1 vote
0 answers
171 views

Filter parent layer with child table in 1-N relation in QGIS

I have a layer with a related (1-N) table and I need to filter the parent layer with values of the child table. I have tried with the Query builder of the Provider feature filter in the layer ...
Raúl Casado's user avatar
  • 1,069
1 vote
1 answer
1k views

Performing many to one join in QGIS

I have read https://docs.qgis.org/2.18/en/docs/user_manual/working_with_vector/attribute_table.html#creating-one-or-many-to-many-relations and also many to one join in QGIS but I can't seem to be able ...
Philippe Morgan's user avatar
0 votes
1 answer
71 views

How to join/relate points to polygons by field

I am using ArcMap with a basic license. I have a layer of polygon parcels and a layer of point turnouts. The turnouts deliver water to the parcel, but are not located within the parcel. My parcels ...
Irrigation_GIS's user avatar
1 vote
1 answer
84 views

Join/relation not an available widget option in the attributes form?

I cannot figure out why, but, in a tree/planting projects database, I have a fairly simply data model where I have one polygon layer to symbolize the area/project (eg. Maple Oak Park, John Smith ...
Robert's user avatar
  • 43
2 votes
2 answers
795 views

Using ArcPy search cursor to relate .csv and .shp

I am using ArcMap 10.6.1. I'm trying to write a script that relates data from a .csv file to a utility pole shape file. Basically, we want the script to iterate through the pole # fields in each table ...
Mark1994's user avatar
1 vote
1 answer
695 views

Many to one relationship or join in QGIS

I have a road network layer that has a unique id "ID_2" for each road segment. I also have a table that contains the route for each bus network. Each row in this table contains the name of the bus and ...
Ganesh Ambi Ramakrishnan's user avatar
1 vote
0 answers
527 views

Container 'Control visibility by expression' for relations

I have two relations in a project on QGIS 3.10. They have the same field ('fid') of the parent but different fields ('topo_part';'topo_part_loc') of the same child. I want to see these relations in ...
Vitantotto's user avatar
0 votes
0 answers
26 views

How best to relate historical testing data to a shapefile?

I am tasked with bringing what has historically been only tracked in Excel into a shapefile. I am using ArcMap, but also have QGIS installed on my computer What these shapefiles will include is ...
sploog's user avatar
  • 294
1 vote
0 answers
171 views

Using 1:n table relationships in rule-based symbology

I would like to use the value of a field/attribute in a parent table as a filter in an expression used to display features in the child table. Specifically, I have a 1:n relationship in my project: ...
CedricJ's user avatar
  • 41
1 vote
1 answer
373 views

QGIS - Using Rule Based Labels With Related Tables

I have a two csv tables that have been related to eachother (RelatedResults): Table 1 = Locations which is loaded as points Which has the fields[ID] [Type] [X] [Y] Example: Point_1, Frogs, LAT, LONG ...
LeadStar's user avatar
0 votes
1 answer
48 views

Finding point from Layer B that matches point from Layer A using search radius

I have two point shapefiles of trees from two different surveys. I want to verify if data from Survey A matches data from Survey B. I want to create a search radius of 10m around each tree from ...
tree123456789's user avatar
3 votes
2 answers
129 views

Performing one-to-many join with address and crime data using ArcMap

Goal: I want to show the police calls coming from a parcel on ArcMap. So if you click on the parcel, it will show all the calls for the year. I want to join the address attribute from the parcel data ...
CZZ1997's user avatar
  • 31
4 votes
1 answer
507 views

Get Attributes from 1:n relation in QGIS as Expression to use in Atlas

I need to set up way signs for something like a "hiking-GIS". In the first step I made a network analysis (using QNEAT3) to find the distance from the signs ("Way Signs") to the available destinations ...
MartinMap's user avatar
  • 8,284
1 vote
0 answers
180 views

Making chart with related table using ArcGIS Pro

I have a feature class with some locations of drills. I also have a table with data how deep the drill went and some more technical data in it. I used relate on the feature class to connect the ...
jamlego's user avatar
  • 73
1 vote
0 answers
37 views

n:m relations of lines including directions

For trail planning and route signalization projects, I am looking for a solutions which allows me to connect "physical" trail segments (available as .gdb from authorities) with overlaying routes, ...
Kevkev770's user avatar
  • 375
1 vote
0 answers
40 views

Joining my spreadsheet data to my geodatabase file is not including all matching records

I have a map with roads, trails, and site gdb layers, and I have an Excel spreadsheet that I have imported with a list of the permitted companies for each of the designated roads and trails. I would ...
mtbsuggs's user avatar
1 vote
0 answers
398 views

Using related records added on Collector (for ArcGIS) to update original feature class values and symbology

I currently use Collector for ArcGIS to carry out tree inspections. The design consists of two parts - a feature class layer which contains a point for each tree including data such as its species, ...
Mima Letts's user avatar
0 votes
1 answer
52 views

Will my join remove my relate?

I have spatial data that has an existing related table with photo info. I have data from another separate table that I want to join and then field calculate to add to my spatial data, then I would ...
avlus1's user avatar
  • 11