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
0
votes
1answer
14 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 ...
2
votes
0answers
38 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 ...
3
votes
1answer
54 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 ...
3
votes
1answer
62 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
1answer
44 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 ...
3
votes
3answers
131 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 ...
0
votes
2answers
66 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 ...
1
vote
0answers
43 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
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 ...
0
votes
1answer
81 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 ...
4
votes
3answers
339 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
88 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 ...
1
vote
1answer
218 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
17 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
365 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, B still overlaps in 2 or 3 Zones from Dataset A. I want to perform a spatial join and ...
1
vote
2answers
49 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
74 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
2answers
78 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 ...
6
votes
1answer
1k 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
93 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
322 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
44 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
262 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
48 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
892 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
68 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
268 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
89 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
482 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
347 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
288 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
83 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
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 ...
4
votes
0answers
149 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
456 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

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....
2
votes
2answers
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 ...
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
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 ...
31
votes
6answers
38k 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 ...