Questions tagged [one-to-many]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
1
vote
0answers
13 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
13 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 "...
7
votes
2answers
163 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
41 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
59 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 ...
1
vote
2answers
39 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
273 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
78 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
110 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
38 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
141 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
46 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
724 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
537 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
61 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
214 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
66 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
379 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
292 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
194 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 ...
1
vote
1answer
420 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 ...