Questions tagged [one-to-many]

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
0answers
37 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 ...
1
vote
0answers
8 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 ...
0
votes
1answer
59 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 ...
0
votes
0answers
45 views

Consolidating a one-to-many relationship table to one-to-one based on conditions in ArcPy

Below is an example subset of the attribute table for my data: As shown, I have multiple Point_IDs, and I would like to group them based on their unique value (i.e. Point-ID-1 and Point-ID-2). ...
4
votes
3answers
144 views

Joining/merging rows by attribute

I have a beautiful grid/polygon, 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 ...
1
vote
1answer
78 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 ...
0
votes
0answers
18 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
0answers
16 views

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

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
131 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
15 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 ...
1
vote
0answers
17 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 "...
10
votes
2answers
245 views

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

I have two feature Datasets. Both are Polygons. Dataset A has very big Areas and Dataset B just small ones. Now, B still overlaps in 2 or 3 Zones from Dataset A. I want to perform a spatial join and ...
1
vote
2answers
44 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 ...
1
vote
1answer
63 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 ...
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 ...
5
votes
1answer
804 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 ...
1
vote
1answer
86 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 ...
1
vote
0answers
242 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
41 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 ...
0
votes
1answer
212 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, ...
0
votes
3answers
47 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 ...
1
vote
1answer
1k 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 ...
2
votes
1answer
742 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
66 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 ...
0
votes
0answers
253 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 ...
2
votes
1answer
83 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 ...
3
votes
0answers
447 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 ...
1
vote
0answers
315 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 ...
1
vote
0answers
262 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 ...
2
votes
1answer
75 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 ...
10
votes
2answers
7k 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 ...
4
votes
0answers
146 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?
1
vote
1answer
443 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 ...
2
votes
2answers
1k 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 ...
5
votes
3answers
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 ...
9
votes
1answer
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 ...
6
votes
1answer
1k 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 ...
30
votes
6answers
37k 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 ...