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
1
vote
0answers
16 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 ...
0
votes
2answers
31 views

Joining a table to a feature class based on two or more fields

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 ...
0
votes
0answers
30 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 ...
1
vote
2answers
82 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 ...
0
votes
0answers
149 views

Combining fields from different related tables to configure an ArcGIS Field Maps Form

I am trying to create forms for field data collection in ArcGIS Field Maps. I have four different related tables which are related to four different feature layers. I would like to create one form ...
2
votes
0answers
31 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-...
0
votes
0answers
19 views

Making one-to-many polygon interactive map using ArcGIS Pro

I have a polygon shapefile of all war zone. Each war zone has a list of allies and rivals. In which case it is a one-to-many relationship. The goal is to make an interactive map that will allow you to ...
0
votes
1answer
159 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 ...
1
vote
0answers
37 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 ...
0
votes
1answer
74 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 ...
0
votes
1answer
17 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 ...
0
votes
0answers
47 views

Relationship Class Table displays empty table

I'm trying to link 2 tables together using relationship classes (pre-defined within this datamodel). I've uploaded a picture which might be clearer, but here is the process I'm trying: Table named ...
1
vote
1answer
31 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 ...
1
vote
2answers
175 views

Using arcpy search cursor to relate a .csv and a .shp?

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 and determine which pole ...
1
vote
1answer
184 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 ...
1
vote
0answers
126 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 ...
0
votes
0answers
25 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 ...
1
vote
0answers
66 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: ...
1
vote
1answer
122 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 ...
0
votes
1answer
38 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 ...
2
votes
2answers
59 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 ...
3
votes
1answer
215 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 ...
1
vote
0answers
69 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 ...
1
vote
0answers
25 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, ...
1
vote
0answers
24 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 ...
1
vote
0answers
286 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, ...
0
votes
1answer
30 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 ...
1
vote
1answer
26 views

Splitting lines: Options for managing IDs and related records

I have roads in a feature class (Oracle 10.3 geodatabase). Roads are split into separate lines where they intersect. This is an established business rule that cannot be changed. Each road has ...
3
votes
0answers
96 views

QGIS 3 embedded forms - zoom or pan to child features

I have two tables and a relation defined on them via an 'in-between-table' (many-to-many relationship) like this: This gives me nice embedded forms like shown below: What I would like to achieve is ...
2
votes
0answers
58 views

Possible bottleneck in QGIS 1:n relation?

I've set up a 1:n relation linking two layers of the same geopackage. That are about 200k polygons in parcels and 700k rows in owners (non spatial). Now it works as expected but it is painstakingly ...
1
vote
0answers
47 views

Creating ArcGIS Online webapp builder Cemetery search?

I created an ArcGIS Online webapp builder app for a cemetery project. I loaded a relationship class into ArcGIS Online that relates plot polygons to a table of interred individuals. It is a 1 to many ...
0
votes
1answer
427 views

Creating relationship class for many to many relationship

In Arcmap 10.7, I am trying to set up a relationship class that will link parcels to owners. The end goal is to be able select a parcel and see the owner, or multiple owners associated with it. Some ...
0
votes
1answer
85 views

1:n relations in label expressions & general syntax

I've got a colleague who wants to create a (concatenated) label based on a 1:n relation between some shapes and related tables. They asked me if this was possible in QGIS - and I think it should. I ...
4
votes
1answer
227 views

Labeling polygons with the number of related table entries in QGIS

Using QGIS 3.6.1 I have a layer with areas and a table with entries related to the areas: A relation is defined like this: What I would like to achieve is to label the areas with the number of ...
1
vote
2answers
713 views

Displaying attribute value from related layer in QGIS Atlas?

I work on QGIS 3.4.4 Madeira. I have two related layers in my project :"towns" (polygon) and "interest points" (points), the common field is "town name". In the Atlas, my cover layer is "towns". I ...
2
votes
1answer
105 views

What differences exist between relates and relationship class in a geodatabase? [closed]

I am doing a project for my class and I was just wondering what differences exist between relates and relationship class in a geodatabase? And why and when would you use a relationship class over a ...
4
votes
1answer
990 views

Selecting through one-to-many relationship

I'm trying to make a species distribution project where I can select a species from a non-spatial list of species and the selection would highlight (select) all the counties to which the species has ...
2
votes
1answer
797 views

Exporting one to many relation in QGIS to new shapefile?

I am using QGIS 3.4.1-Madeira. I have a base layer map that represents areas as polygons. I have created a CSV file with many entries of different NGO projects, and each one is coded with the ID of ...
0
votes
1answer
107 views

How to push objectIds' array to RelationshipQuery's object in ArcGIS API JavaScript 4.9?

I need to push array of the object IDs to RelationshipQuery's object using executeForIds that generates the array. I also used executeRelationshipQuery that executes the query. I don't not why, but ...
1
vote
1answer
55 views

Copying attributed relationship with ArcPy?

Is there a way using arcpy to copy an attributed relationship and only the attributed relationship ? I can recreate a non attributed relationship with: arcpy.CreateRelationshipClass_management(arg1,...
3
votes
3answers
779 views

QGIS: relations in label expressions

In my project I have a many-to-one relationship. For example I have a vector layer "Towns" and a data layer "TownsInfo". Each town record consists of "Name" and "Id". Each TownsInfo record consist ...
1
vote
0answers
65 views

Best way to relate PostgreSQL table to layer [closed]

There is an online PostgreSQL database (non-spatial) with water monitoring data which is regularly being updated, in another side is a spatial layer of rivers (for example) which should be represented ...
2
votes
1answer
84 views

Transfer geometry from shapefile to related table?

We would like to contact our volunteers based on their geographic location. We settled on zip codes as a reasonable proxy for location, and now have a table with volunteer contact information and zip ...
0
votes
1answer
742 views

How to display related records in popup using ArcGIS Javascript API?

I am attempting to display related fields in a popup window. I've created a GraphicsLayer, consisting of features from the results of a QueryTask. Upon adding the features to the GraphicsLayer, I am ...
1
vote
1answer
1k views

Taking data from related table and populating feature attribute table in ArcGIS Desktop?

Our forester wants trees symbolized red if they haven't been trimmed, green if they've been trimmed. Trimming info is maintained in the Tree_Maint table, which is a one to many related table to our ...
0
votes
1answer
67 views

Making maps with geodatabase? [closed]

For my master’s thesis I’m using ArcMap to create maps based on a large historical dataset. I’m mapping individual movements over long periods of time. I’m struggling to design the database and figure ...
1
vote
2answers
114 views

Selective attributes not displaying in GeoCortex Essential Manager

I'm having trouble with Geocortex Essential Manager displaying the full set of attributes for a particular feature. Specifically, I have a parcels dataset and 4 related tables. I recently added a new ...
0
votes
0answers
90 views

Generating Mapbook with Dynamic Text based on Attributes from Related Table?

I have a series of individual parcels with multiple soil sample points on each parcel. I need a way to communicate the soil sample information to the landowners. There are about 500 parcels so I need ...
1
vote
0answers
76 views

Change polygon color over time by number of events in polygon

In ArcGIS Desktop 10.5.1, I have a layer of XY events with a date field, and a layer of polygons. I have spatial joined the points so that each event is associated with a polygon. I want to show the ...
1
vote
0answers
89 views

Symbology based on related table ArcMap10.5

I have a parcels layer and related table of water meters. I did labeling of water meters IDs and I pulled it from the related table through the script. Can I symbolize polygons based on related table ...