Questions tagged [one-to-many]

1:n. Each row in one table is linked (or related) to one, or more, rows in another table using a "key" column.

Filter by
Sorted by
Tagged with
1 vote
1 answer
25 views

Why am I getting the message "Cannot add child feature: primary keys are not available" in QField?

In QGIS, I have set up a one-to-many relation with a "plot" layer (parent) - a UUID field as the primary key - and a "stems" layer (child). I am attempting to set up another one-to-...
Georgia Slim's user avatar
0 votes
1 answer
76 views

Joint feature QGIS 1 a N

I have 3 tables, a linear table of sections, a non geometric table of bus lines, and a intermediate table between both, with relations N:M. In the intermediate table I have the ID of sections table ...
pablo.olivares's user avatar
1 vote
0 answers
41 views

QGIS values from 1:n related table to parent attribute table

I'm confused since I don't really get the difference between a form and a table in QGIS. I've successfully created multiple one to many relations between my parent shapefile and child excel sheets ...
edge's user avatar
  • 229
1 vote
0 answers
29 views

Join all results from a one to many join in ArcGIS Pro

I want to join all possible results (up to 5 counties intersect ZIP codes) from ZIP_County_Intersect to be populated as the null County fields in ZIP_County_Dissolve. These results are coming from ...
rachel.passer's user avatar
2 votes
1 answer
144 views

QGIS Atlas pictures from one-to-many relation child layer

The situation: I create a project in QGIS. I use this project in a Data collection App, so that for each points I make several pictures. The project is as follow: a point layer (parent layer, point - ...
GeoTr's user avatar
  • 21
0 votes
1 answer
135 views

ArcGIS Join Field not adhering to field mapping merge rules in one-to-many join

I am trying to join records from Table B (join table) to Table A (input table) in ArcGIS Pro using the Join Field tool. This is a one-to-many join such that there are multiple records in Table B that ...
David 's user avatar
  • 21
1 vote
1 answer
284 views

QField - adding picture module

I'm trying to enable a QField project to take pictures of the features represented by a point layer. In the QGis project I've set a 1:N relation between the point layer and a table using the Relations ...
HyPhens's user avatar
  • 516
1 vote
1 answer
79 views

Filtering missing corresponding values in 1 to N relationship in QGIS

I have two tables set up in a 1 to N relationship with the field "UE". Table 1 is a parent. 'Table 2' is a child. I want to filter all entities in table2 that don't have a corresponding ...
tonyduky's user avatar
  • 547
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
1 answer
248 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
2 votes
0 answers
117 views

Showing multiple individuals for same polygon using QGIS

In QGIS: My data lists individuals only by zip code, not a more specific location. Those individuals are one of three categories. I have successfully completed a one-to-many join so that the attribute ...
Matthew's user avatar
  • 61
3 votes
1 answer
222 views

Selecting features based on one to many relation in QGIS 3

There are two layers: [1] one is a polygon layer with an "ID", [2] the other one is a table with one or many owners for each "ID". My goal is to select every polygon owned by a ...
BenJ's user avatar
  • 31
3 votes
1 answer
223 views

How to label parcels with multiple parcel owners in QGIS?

I have GeoPackage file with parcels (polygons) and an Excel table with parcel owners. As one parcel can have multiple parcel owners I established a one to many relationship. Now I wish to label the ...
Bojan Petkovic's user avatar
3 votes
1 answer
107 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 ...
Felippe M.'s user avatar
  • 1,082
3 votes
3 answers
286 views

Counting points in polygon and printing out each placing

Here is my sample table for further description: I have a original point layer: ID Name X(latitude) Y(longtitude) ID1 Dog A 1 ID2 Cat A 1 ID3 Bird B 1 ID4 Cat A 2 ID5 Cat B 1 ID6 Dog A 1 Those ...
Cookie's user avatar
  • 355
0 votes
2 answers
643 views

QField: change display label of entered features

I'm experimenting with the QField app to visit trees regularly and monitor them over time. The tree inspections is a table related to a shapefile with the tree locations, so that every visit is ...
Nick's user avatar
  • 85
1 vote
0 answers
52 views

Joining or relating multiple data in one single data using QGIS

I do not know how to solve this problem using QGIS. I have tried several ways but it did not work out. I have a lot of data, I have one coordinate system for each location, for example Alor setar ...
NUR SYAHIRAH's user avatar
1 vote
0 answers
11 views

Carrying attribution from several points to single underlaying polygon to create copies of polygon with unique attribution using ArcGIS Pro

I am using ArcGIS Pro to manipulate some property parcels data. I have a parcels polygon layer with the parcel geometry, and a points (PINs) layer with the property attribution information. Most ...
Kristin Dillard's user avatar
0 votes
1 answer
419 views

Collecting multiple entries for single GPS-location with QField

My goal is to collect data on trees where the same trees are visited multiple times, using QField. While each tree will have a unique ID, we have to use the GPS-coordinates of the trees plotted on a ...
Nick's user avatar
  • 85
4 votes
3 answers
3k views

Merging rows by mutual attribute in QGIS

I have a grid as polygons, each square having its own "ID", and several observations for each square. But, I have three categories of observation, each with its own row, matching the same &...
GManono's user avatar
  • 41
1 vote
1 answer
134 views

Concatenating names of the districts and the numbers of the sections in the polygonal layer of streets based on intersection

In QGIS 3.14 I want for a layer with street contours (polygons) to record the names of the areas through which the street passes and the numbers of cadastral plots through which it passes. If a street ...
Ivan M's user avatar
  • 303
1 vote
1 answer
624 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
22 views

Labeling a joined (one to many) layer with the number of feature joined to it in ArcGIS Online

Using ArcGIS Online, I performed a one to many join with a buildings layer (one) and a table of internal cameras (many). This produced a layer showing buildings and allows me to scroll though all the ...
Ryan Bobo's user avatar
1 vote
0 answers
36 views

Create multiple features from a single field

I have a point feature class showing addresses where trees were planted. A single row in the attribute table represents a single address. I have a field in the attribute table called "...
haltead's user avatar
  • 51
12 votes
4 answers
951 views

One-to-many spatial join with results in one row in QGIS

I have two feature Datasets. Both are Polygons. 'Dataset A' has very big Areas and 'Dataset B' just small ones. Now, 'Dataset B' still overlaps in 2 or 3 Zones from 'Dataset A'. I want to perform a ...
Skane's user avatar
  • 305
2 votes
2 answers
5k views

How to make an ArcGIS Pro one-to-many table join?

From what I have been able to find in the ArcGIS Pro documentation via Google search for one-to-many table joins the only method other than using python (which I am not great at) would be the Query ...
Therow's user avatar
  • 163
1 vote
2 answers
101 views

Many to one join in Carto

I have two datasets: A point shapefile of companies (each row/record is a unique company) A list of awards given to those companies (each row is a unique award, but since companies can win multiple ...
Kristen G.'s user avatar
  • 1,080
1 vote
1 answer
118 views

Summarizing Attribute Table Based on Condition

I have a one-to-many joined table (i.e. duplicated AssetIDs with other different attributes), and I would like to consolidate the table (20 records) into one single record. However, when using ...
LearningGIS101'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
7 votes
1 answer
4k views

QGIS and 1-to-many relationship

I am using QGIS 3.10.0 I am attempting to join a spatial vector layer to a non-spatial layer (CSV). Each polygon on the spatial layer has a unique id attribute. The CSV also has this id attribute ...
jcrow's user avatar
  • 71
1 vote
1 answer
112 views

One to Many Relationships concerning Attribute Tables and Domains in ArcMap

I am drawing in and inventorying signalized intersection assets and when it comes to the conduit and wiring some of the conduits (most) have 2+ cable/wire conduits in them. For example, the record ...
cheff_'s user avatar
  • 139
1 vote
0 answers
399 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

Formatting data for 1:many relationship

I am currently working on a way of efficiently displaying information relating to tree inspections (using ArcGIS Desktop to then upload onto arcgis online so that the data can be accessed and added to ...
Mima Letts's user avatar
0 votes
1 answer
358 views

QGIS one to many join issue

I already asked in previous question QGIS table join issue, how to join shape file data and CSV data which contain multiple SAME ID for one object? Shape file contains columns: object id, area, ...
Julija M's user avatar
  • 131
0 votes
3 answers
54 views

Copying polygon feature class with 405 features for each matching owner entity?

I have 425 polygon features that I need to duplicate in relationship to 5907 owner entities that are contained inside an excel sheet I converted to a table. So each polygon represents a lease record ...
Lost_In_GIS's user avatar
1 vote
1 answer
3k views

Adding related table to ArcGIS Online feature layer

I'm trying to figure out how to add a relationship class (related table one-to-many) to a feature layer within AGOL. I do not have ArcGIS Desktop or Server (do have QGIS but I don't think that will ...
Eric's user avatar
  • 19
3 votes
1 answer
1k 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 ...
Hannah Pruitt's user avatar
0 votes
1 answer
79 views

Spatial Joining One to Many?

I am trying to create groups based on a primary object as its centroid. Groups are defined as all objects within a certain distance from a primary object. I am currently using spatial join in a ...
A22's user avatar
  • 1
0 votes
0 answers
336 views

Spatial joining one to many within distance using ArcMap?

I have two datasets, the dataset A contains the main information, I want to join all the points from dataset A to all the points in dataset B within 150 meters. From dataset B I need to keep two ...
kat's user avatar
  • 11
2 votes
1 answer
135 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 ...
cmarschner's user avatar
3 votes
0 answers
564 views

Using feature's one-to-many statistics as graduated color symbology in ArcGIS Online application?

I've made a task oriented ArcGIS Online application that I like to improve: The application is about filling a numeric score field in a table for each row. Each row in the table is related to a ...
EranGeo's user avatar
  • 1,162
1 vote
0 answers
587 views

Join multiple Points to Polygon and concatenate joined point values of column into Polygon column

My data: Points: ID HN Street 1 5 Examplestreet 2 6 Examplestreet 3 2 Otherstreet 4 2 Anotherstreet Polygons: Name Firstpolygon Secondpolygon Otherpolygon ...
Max Mustermann's user avatar
1 vote
0 answers
377 views

Looping through data to perform one to many join in ArcPy?

I want to join the attribute tables of two feature classes in ArcGIS and populate the fields from one table to another. This is a one to many join and there are duplicate rows of data in the join ...
mfn's user avatar
  • 11
2 votes
1 answer
145 views

Generating lines from one polygon to group of polygons (one-to-many network) using QGIS

I have a polygon layer where every polygon has a unique "ID", and another polygon layer where those unique "ID"s can be found in a column in a one-to-many relation. I would like to ...
Encomium's user avatar
  • 3,113
11 votes
2 answers
11k views

One-to-many joins in QGIS [duplicate]

I am looking for a possibility to make a one-to-many table-join in QGIS. I have a shapefile with postal codes and would like to join them with survey results (more than one). In other words, there is ...
MTwain's user avatar
  • 111
4 votes
0 answers
165 views

One-to-many labels in QGIS [closed]

The one-to-many relations in QGIS is OK with forms, works great. But how to labels or chart data with this one-to-many relations?
martin fafard's user avatar
1 vote
1 answer
485 views

Joining one-to-many using ArcPy? [closed]

I have a feature class that contains polygon features with a unique ID column. This shapefile is to be joined with a CSV table that I've exported to a file geodatabase table. The unique identifier in ...
Sebastian's user avatar
3 votes
2 answers
2k views

Achieving one-to-many relationship in QGIS custom forms

My PostgreSQL database has ElectricLine geometry table which has one-to-many relationship with ElectricLineMaterial non-geometry (attribute only) table. This PostgreSQL table added as layer in QGIS 2....
vasudevanp's user avatar
2 votes
2 answers
2k views

Performing relate in ModelBuilder for one to many relationship?

I'm not sure how to do this as I don't' think there are any ModelBuilder tools for this task. I'm not real savvy with Python but basically I want to relate field1 in table A to field2 in table B with ...
Steve's user avatar
  • 773
5 votes
3 answers
3k views

Copying dbf data into shapefile using ArcPy?

How do I perform a one-to-many join in a python script, from a dbf to a shapefile? I saw (Greg Krakow's method) using QGIS, but I can't use it (I'm working on it, but QGIS is not yet recognize as an ...
fgcarto's user avatar
  • 1,524