Questions tagged [relationship-class]

A relationship class is an object in a geodatabase that stores information about a relationship between two feature classes, between a feature class and a nonspatial table, or between two nonspatial tables

Filter by
Sorted by
Tagged with
0
votes
1answer
21 views

Many to many relationship class with ArcGIS Desktop using only two table

In database discussions, for creating many to many relationship class we must create a third table to relate two other tables. However, in ArcGIS for creating many to many relationship class we just ...
1
vote
1answer
39 views

Using relationship classes in ArcPy

Is there any way to use relationship classes with ArcPy to access associated records? The ArcGIS Idea for there to be An Arcpy method for dealing with related records leads me to believe that there is ...
0
votes
1answer
69 views

Highlight all features associated with selected feature via relationship in ArcObjects C#

I am trying to highlight those features which are associated (via Relationship) to the selected feature in ArcObjects C#. public void IRelationship_Example(IFeature feature) { //assumes that only ...
0
votes
0answers
25 views

Importing feature class keeping relationship classes to annotation using ArcMap

I have a project I've been working on for a few years using 10.2 In the past I have been able to update the gdb by importing data from a shapefile to an existing feature class. ArcMap would tell me ...
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 ...
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 ...
0
votes
0answers
259 views

Combining fields from different related tables to configure an ArcGIS Field Maps Form

I am trying to create forms for field data collection in ArcGIS Field Maps. I have four different related tables which are related to four different feature layers. I would like to create one form ...
0
votes
0answers
17 views

Automatically loading PostGIS relations in QGIS [duplicate]

I am working with a PostgreSQL/PostGIS (version 12.3/3.0.1) database and I am using QGIS (version 3.10) to visualize and work with my data. In the database I have two schemas: schema for spatial data ...
1
vote
0answers
138 views

Using PostGIS relationships (M:N) in QGIS without loading all related tables in layertree

I am working with a PostgreSQL/PostGIS (version 12.3/3.0.1) database and I am using QGIS (version 3.10) to visualize and work with my data. In the database I have two schemas: schema for spatial data ...
0
votes
1answer
45 views

ArcGIS10.2 SDE relationship class referencing a deleted feature - how to clean up relationship class?

I am looking for a smart approach to cleaning up a relationship class, which consists of relationships that look at previously deleted objects. To illustrate, we have db.schema.SITE (spatial), db....
1
vote
1answer
69 views

How to read the relevant join information out of a MXD file (above all the name of the destination table attribute)

Goal: Read all joins within a MXD file and its relevant information. This should include: origin layer name, origin attribute name, destination table name, destination table attribute. To solve this,...
1
vote
0answers
24 views

Sorting Relation_Aggregation Expression Results in QGIS3

I am using a relation aggregation expression to grab a list of inflows from other sewersheds. Some sewersheds take on flows from more sewersheds than others so I approached it through a relation so ...
1
vote
0answers
323 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, ...
1
vote
1answer
57 views

Making one to many to many Attribute Relationships

I am making relationship between three tables in QGIS 3.8 version ("ACTIVE SITE","FUEL_TANK","REFUEL"). The primary key and the foreign key for the Tables are as follow the primary keys are "ACTIVE ...
1
vote
0answers
118 views

Automatically update records in layer based on changes in another

I am using QGIS and I have two layers the first one is "Reading" layer with the attribute details The second layer is "Reading_History" layer with the attribute details I want to use the expression ...
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
0answers
94 views

Projecting ArcGIS feature dataset containing relationship classes

I have a geodatabase with more then 50 feature classes and 60-70 tables. The feature classes are inside a feature dataset which is using a projected cooridnate system. There are 250+ relationship ...
1
vote
1answer
95 views

Setting up a relationship class between two feature classes

I am working on a project that involves a line feature class that represents roads and a point feature class that represents defects on the roads. I am trying to relate the point feature class to the ...
0
votes
1answer
527 views

Creating relationship class for many to many relationship

In Arcmap 10.7, I am trying to set up a relationship class that will link parcels to owners. The end goal is to be able select a parcel and see the owner, or multiple owners associated with it. Some ...
2
votes
0answers
445 views

Can relation reference in QGIS and QField be used to fill stochastic matrices?

I am a novice GIS user and am just seeing the potential for relations in my work. A problem I've come across and would like a solution to it. I have two stochastic matrices (risk matrices) that ...
1
vote
1answer
43 views

Adding relationshipClass into ArcMap map when cardinality is not M-N?

I am wondering why it's possible to add a relationshipClass from the catalog into a map in ArcMap 10.3 only when the cardinality is M-N (many-to-many). When I try to drag and drop other ...
1
vote
1answer
296 views

FME Writing Geo-database relationship classes

I am reading geodatabase using ESRI File reader and this geodatabase contains feature classes with relationship classes. I am trying to write them as it is to another geodatabase. The problem is ...
0
votes
0answers
152 views

Foreign key value in destination table is nullified when origin feature is deleted from ArcGIS relationship - workaround?

I have an SDE geodatabase in which I have an origin feature class with relationship classes to several destination feature classes and tables. When a feature is deleted from the origin table, the ...
2
votes
1answer
119 views

What differences exist between relates and relationship class in a geodatabase? [closed]

I am doing a project for my class and I was just wondering what differences exist between relates and relationship class in a geodatabase? And why and when would you use a relationship class over a ...
4
votes
1answer
198 views

Making layer private/hidden/invisible in QGIS Layers Panel without Python

I have postgresql/postgis database setup with one to many relationship. I can successfully set it up in QGIS but I would like to keep related tables hidden from Layers Panel to keep the project "...
1
vote
1answer
264 views

Making relationship class between feature class and Excel table with ArcGIS Desktop?

I have a feature class of parcels and an Excel table of other information related to those parcels. Goal: would like edits from an Excel table to get passed onto feature class. Problem: for a true ...
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
0answers
417 views

Copying tables results in duplication of some tables, feature classes and relationship classes

ArcGIS Pro 2.2.3. I have a file geodatabase called "supportSource.gdb" with 3 tables, 2 feature classes and 3 relationship classes. I just want to copy the contents of this file geodatabase to ...
0
votes
0answers
33 views

1 - 1 Composite relationship class set to notify "both" not updating origin when editing destination

I have two spatial feature classes and want to have the spatial edits reflected in both feature classes when editing either the origin or destination. I have set up a composite relationship with a 1-1 ...
2
votes
0answers
74 views

How to create a relationship without NULL tables?

I made a relation (1:n) between 2 tables. Not every element from the parent layer has a connection with features from the child layer. The relation is made between 'Tipo de Estrutura' Field and 'Est' ...
0
votes
1answer
196 views

Can I use the Search Widget on fields related to a featurelayer?

Is it possible to point the search widget to related records? For example, I have a featurelayer of spaces, which is related to a table of names based on the spaceID. I would like to be able to ...
0
votes
1answer
113 views

How to push objectIds' array to RelationshipQuery's object in ArcGIS API JavaScript 4.9?

I need to push array of the object IDs to RelationshipQuery's object using executeForIds that generates the array. I also used executeRelationshipQuery that executes the query. I don't not why, but ...
0
votes
0answers
24 views

Adding condition to relationship in ArcGIS Desktop?

I have the following data model: Each point and each line can be linked to many measurements (1-M relationship) I would like to add a condition in the relationship between MY_LINE and MEASUREMENTS, ...
3
votes
1answer
138 views

Creating Relationship Class- Adding new records to table

I am creating a relationship class inside an SDE Environment (SQL Server 2016). I have a point feature class and a related table. I am trying to add rows to the currently empty table based off ...
1
vote
1answer
25 views

Retire Dataset with Its Relationship Class

I need to retire datasets from our SDE databases to our Retirement Geodatabase. There are several relationship classes tied to these datasets. How can I export the feature class with its relationship ...
2
votes
1answer
202 views

Validate Features in ArcGIS Pro?

In ArcMap, I can easily enforce my geodatabase relationships rules (ex. one-to-one relationships) by selecting features and selecting, in the editor toolbar, the Validate Features button. I can then ...
0
votes
1answer
147 views

ArcMap not enforcing one to one relationship classes

I'm designing a data survey application. I created a fire hydrant feature class named devBorne_geom. This feature class contains only the geometry and cannot contain survey fields as I want them to ...
0
votes
1answer
143 views

Exporting Feature Classes in SDE to shapefiles and tables

How can I export feature classes and tables in SDE to shapefiles and tables? I am able to export the feature classes to shapefiles based on an extent. The problem I am running into is, I want to ...
0
votes
1answer
29 views

Changing cardinality of existing relationship class in enterprise geodatabase?

Is it possible to change the cardinality of an existing relationship class in enterprise geodatabase? I want to alter a 1-m relationship class to m-m
1
vote
1answer
272 views

Creating relationship class in QGIS for uploading to ArcGIS Online?

Since I don't have the advanced license for ArcGIS Pro, I'm trying to create relationship class in other programs. Would ArcGIS Online support relationship (O-M) created through another program (...
0
votes
1answer
68 views

Making maps with geodatabase? [closed]

For my master’s thesis I’m using ArcMap to create maps based on a large historical dataset. I’m mapping individual movements over long periods of time. I’m struggling to design the database and figure ...
2
votes
1answer
406 views

Aggregating attribute data with one-to-many relationship class in ArcMap?

I am using ArcMap 10.6. I am joining a table of public housing developments to a parcel map layer, and there is a one-to-many relationship between the parcels and developments: multiple buildings ...
0
votes
0answers
360 views

Can collector auto populate related feature ID field?

I have staff conducting hydrants inspections using ESRI ArcGIS collector. The hydrants have a unique ID. If I make a relationship class between hydrants and hydrant inspections, does Collector know to ...
1
vote
1answer
227 views

Passing selection through relates in ArcGIS ModelBuilder?

I have a layer of facilities and a feature that has three related layers (Point, Area, Line). I'm trying to automate extracting data from the Line layer that's related to a selected set of facilities ...
0
votes
0answers
71 views

Link the edges and the nodes with a relationship class table in a geometric network

I have a bus network in arcgis composed by: The Bus stops (points) The Bus lines (multilines) A relashionship table who link the stops and the line So the relationship (Many-to-Many) contains a ...
4
votes
0answers
23 views

Replacing polygon within composite relationship without deleting tabular record? [duplicate]

I have a geodatabase that contains a table, a point feature class, and a polygon feature class. Each record in the table has both a related point and a related polygon, so all one-to-one ...
2
votes
4answers
5k views

Related Tables in ArcGIS Online

I've created a relationship class in Desktop and published to ArcGIS Online as a service. The relationship still exists between my table and feature service but when I try to add one of the fields ...
0
votes
1answer
156 views

query doesn't return way based on related nodes

Way 445962072 has 5 related nodes. If I query on two of more of these nodes, the way isn't returned. The query I used is node(id:8093775,8093776)->.allnodes; way(bn.allnodes)->.ways; foreach ....
2
votes
1answer
156 views

Batch Rename Relationship Classes

Batch Renaming Relationship Classes I have consulted the post above, but found that the solution is out of date and no longer works. It suggests two options to initially get the list of relationship ...
0
votes
1answer
86 views

Validation of relationship cardinality not working as expected

I am using ArcGIS 10.2.1 with ArcFM extensions, and the ArcGIS validation tool. I have a feature class (poles) with several subtypes based on construction materials. It is related to a table via a ...