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
0 answers
38 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 ...
user avatar
0 votes
1 answer
30 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 ...
user avatar
2 votes
0 answers
44 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 ...
user avatar
  • 61
3 votes
1 answer
93 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 ...
user avatar
  • 31
3 votes
1 answer
84 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 ...
user avatar
3 votes
1 answer
53 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
3 votes
3 answers
150 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 ...
user avatar
  • 131
0 votes
2 answers
137 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 ...
user avatar
  • 65
1 vote
0 answers
45 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 ...
user avatar
1 vote
0 answers
9 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 ...
user avatar
1 vote
1 answer
133 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 ...
user avatar
  • 65
4 votes
3 answers
648 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 &...
user avatar
  • 41
1 vote
1 answer
97 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 ...
user avatar
  • 269
1 vote
1 answer
331 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 ...
user avatar
1 vote
0 answers
18 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 ...
user avatar
1 vote
0 answers
18 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 "...
user avatar
  • 31
11 votes
4 answers
496 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 ...
user avatar
  • 195
1 vote
2 answers
80 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 ...
user avatar
  • 1,060
1 vote
1 answer
88 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 ...
user avatar
3 votes
2 answers
95 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 ...
user avatar
  • 31
6 votes
1 answer
2k 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 ...
user avatar
  • 61
1 vote
1 answer
100 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 ...
user avatar
  • 129
1 vote
0 answers
356 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, ...
user avatar
0 votes
1 answer
47 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 ...
user avatar
0 votes
1 answer
299 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, ...
user avatar
  • 131
0 votes
3 answers
50 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 ...
user avatar
1 vote
1 answer
2k 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 ...
user avatar
  • 19
3 votes
1 answer
998 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 ...
user avatar
0 votes
1 answer
70 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 ...
user avatar
  • 1
0 votes
0 answers
286 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 ...
user avatar
  • 11
2 votes
1 answer
102 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 ...
user avatar
3 votes
0 answers
499 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 ...
user avatar
  • 1,044
1 vote
0 answers
381 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 ...
user avatar
1 vote
0 answers
327 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 ...
user avatar
  • 11
2 votes
1 answer
90 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 ...
user avatar
  • 2,761
10 votes
2 answers
8k 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 ...
user avatar
  • 101
4 votes
0 answers
150 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?
user avatar
1 vote
1 answer
471 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 ...
user avatar
2 votes
2 answers
1k 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....
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 ...
user avatar
  • 721
5 votes
3 answers
2k 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 ...
user avatar
  • 1,504
10 votes
1 answer
4k views

One to Many Relationship in QGIS with PostGIS

Does anyone know of any tool that can do a One-to-Many relationship in QGIS? I have my data in a PostGIS database. I would like to be able to query spatial layers that are related to spatial or ...
user avatar
  • 9,203
6 votes
1 answer
2k views

Can Spatial Joins be used to perform One-to-Many Closest joins?

My situation appears rather simple, but it has given me headaches more than once already. I have a set of points and a set of polylines. I would like to use a spatial join to join the attributes of ...
user avatar
  • 4,308
32 votes
7 answers
39k views

Joining multiple records to single feature using QGIS

I'm trying to create a join/relate in QGIS where I have a shapefile of buildings and to that I would like to join a non-spatial table (.csv-file) containing people who work in each building. So I have ...
user avatar
  • 321