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.
49
questions
0
votes
1
answer
58
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 ...
- 21
0
votes
0
answers
11
views
Join a layer and a table to get a new layer 1-M
I need to join (1-M) a feature dataset (points) located in AGOL with a table (locally stored in a GDB) to get another feature dataset with as many elements as the table. I' working with ArcGIS Pro 3.
...
- 1,019
1
vote
1
answer
195
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 ...
- 520
1
vote
1
answer
67
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 ...
- 507
1
vote
0
answers
45
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 ...
- 41
0
votes
1
answer
155
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 ...
- 83
2
votes
0
answers
84
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 ...
- 61
3
votes
1
answer
181
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 ...
- 31
3
votes
1
answer
179
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 ...
3
votes
1
answer
81
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 ...
- 1,072
3
votes
3
answers
221
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 ...
- 301
0
votes
2
answers
377
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 ...
- 75
1
vote
0
answers
47
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 ...
- 11
1
vote
0
answers
10
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 ...
1
vote
1
answer
281
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 ...
- 75
4
votes
3
answers
2k
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 &...
- 41
1
vote
1
answer
117
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 ...
- 303
1
vote
1
answer
491
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 ...
- 623
1
vote
0
answers
21
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 ...
- 23
1
vote
0
answers
25
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 "...
- 51
11
votes
4
answers
803
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 ...
- 195
2
votes
2
answers
4k
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 ...
- 163
1
vote
2
answers
98
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,080
1
vote
1
answer
112
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 ...
3
votes
2
answers
118
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 ...
- 31
7
votes
1
answer
3k
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 ...
- 71
1
vote
1
answer
109
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 ...
- 129
1
vote
0
answers
392
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, ...
- 11
0
votes
1
answer
50
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 ...
- 11
0
votes
1
answer
336
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, ...
- 131
0
votes
3
answers
52
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 ...
- 33
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 ...
- 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 ...
0
votes
1
answer
75
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 ...
- 1
0
votes
0
answers
313
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 ...
- 11
2
votes
1
answer
122
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 ...
- 23
3
votes
0
answers
545
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,094
1
vote
0
answers
526
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
0
answers
356
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 ...
- 11
2
votes
1
answer
135
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 ...
- 2,982
11
votes
2
answers
10k
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 ...
- 111
4
votes
0
answers
163
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
1
answer
479
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 ...
- 49
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....
- 495
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 ...
- 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 ...
- 1,514
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 ...
- 9,419
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 ...
- 4,308
32
votes
7
answers
41k
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 ...
- 321