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.
56
questions
0
votes
0
answers
21
views
Join/relate with one to many relation
Took GIS in undergrad 10 years ago and now trying to relearn some skills for my job in urban planning. Working in ArcGIS Pro, I've got a standalone table of historic permit data that I'd like to join ...
2
votes
0
answers
19
views
Setting QGIS one-to-many relations strength to "Composition" with the "Discover Relations" feature
How do I get QGIS to automatically detect the relationship strength in the "Discover Relations" feature mentioned in QGIS documentation cpt. 16.4.2.1 One to many (1-N) relations (https://...
- 14.7k
1
vote
0
answers
67
views
Creating One-to-Many relationships in Geopackages
The question is not new but still there is no clear answer.
A very detailed expression of the question was given by nr_aus (https://gis.stackexchange.com/users/165549/nr-aus)
at:
Creating ...
- 174
1
vote
1
answer
63
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-...
- 31
0
votes
1
answer
86
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 ...
1
vote
0
answers
59
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 ...
- 229
1
vote
0
answers
43
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 ...
- 882
3
votes
1
answer
245
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 - ...
- 51
0
votes
1
answer
207
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
1
vote
1
answer
329
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 ...
- 518
2
votes
1
answer
92
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 ...
- 567
1
vote
0
answers
55
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 ...
- 71
0
votes
1
answer
293
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 ...
- 79
2
votes
0
answers
144
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
250
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
249
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
114
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,092
3
votes
3
answers
300
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 ...
- 375
0
votes
2
answers
884
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 ...
- 85
1
vote
0
answers
53
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
12
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
1
answer
520
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 ...
- 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 &...
- 41
1
vote
1
answer
137
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
705
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 ...
- 633
1
vote
0
answers
24
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 ...
- 33
1
vote
0
answers
37
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
12
votes
4
answers
1k
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 ...
- 305
1
vote
3
answers
6k
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 ...
- 161
1
vote
2
answers
108
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,100
1
vote
1
answer
120
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
137
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
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 ...
- 71
1
vote
1
answer
117
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 ...
- 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, ...
- 11
0
votes
1
answer
53
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
368
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
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 ...
- 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
82
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
340
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
143
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
569
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,182
1
vote
0
answers
599
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
381
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
148
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 ...
- 3,183
11
votes
2
answers
12k
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
167
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
489
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