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
1
vote
0answers
17 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
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, ...
1
vote
1answer
42 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
78 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 ...
1
vote
0answers
277 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
0answers
94 views

Deleting Relationship Class Programatically using ArcObjects?

I am having lots of trouble deleting the relationship that I create with this code. The last two lines below do not delete the relationship. I have tried many different things in an attempt to delete ...
1
vote
0answers
115 views

Editing relationship class in ArcGIS for Desktop?

I want to know if there's a way to edit the origin/destination class in Relationship class in arcgis after creating the Relationship class?
1
vote
0answers
48 views

Feature class, Inspection Table and Defect table - Relationship Classes [closed]

I have a file geodatabase with three elements in it. Lighting layer (assets) consisting of point items. Inspection table (containing inspection information for those assets) Defects Table (linked to ...
1
vote
1answer
163 views

M-N relationship class in geodatabase with existing linking table?

I have a parcel database with an M-N relationship (Parcels to Deeds). I have already created and populated a linking table. We have also set up two relationship classes in the geodatabase for the two ...
1
vote
0answers
163 views

Getting origin key to automatically populate foreign key while using relationship class in ArcGIS for Desktop? [closed]

I am using ArcGIS for Desktop, and I am attempting to create feature linked annotations for my cable system and I have set up a relationship between the two features so that any changes made to the ...
1
vote
1answer
225 views

Communicate relation between two table

At this time, I'm able to create a relation (1:M) between two table or geometries. After, I user Identify tool to exploit the relation. It is only possible to use this feature when your Identify tool ...
1
vote
0answers
184 views

Creating a weighted rating model/script for vector data [closed]

I'm using ArcMap and trying to create a model or script that can rate routes based on a weighted calculation of attributes. Right now the individual attributes don't have rating values which I could ...
1
vote
0answers
72 views

label based on related features

Esri's telecom data model has 2 geometric networks, one for infrastructure (manholes and conduits) and one for fiber cables. fiber cables are easily related to a section of conduit based on existing ...
1
vote
0answers
86 views

how to keep relationship between feature classes after intersection one of feature classes?

I have geodatabase with 3 feature classes. one of them is circuit polyline feature class and two polygon feature class. substation and division in geodatabase there is relationship between circuit ...
1
vote
0answers
387 views

Creating relationship class in ArcSDE?

I can not seem to create a relationship class in ArcSDE, or at least one that works. I am succseful in creating the class however ArcMap does not recongnize it (there are no related tables shown) and ...
0
votes
1answer
177 views

Representing multiple work visits to same location in ArcMap? [closed]

How can I get ArcMap to summarize and display multiple feature records for the same address location?
0
votes
1answer
64 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 ...
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
166 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 ...
0
votes
1answer
135 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
106 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
25 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
0
votes
2answers
361 views

Batch Renaming Relationship Classes using ArcPy

I'm trying to rename about 100 relationship classes in a Geodatabase. All the relationship classes are named under a naming convention and a standard part of that has changed, i.e: abc_feature1_rel ...
0
votes
1answer
37 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....
0
votes
1answer
87 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
1answer
73 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
129 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 ....
0
votes
1answer
679 views

Appending data in a relational database without changing the GUID

So I am building an ArcGIS relational geodatabase; one copy is stored online for users to enter data into and another copy is stored locally for minor processing and then to generate reports. The ...
0
votes
1answer
54 views

Relating tables based on a range of values?

I have a polygon shapefile of parcels with 2 fields that give a low and high address range. I would like to relate this to a point shapefile that has a specific address field for each point. The ...
0
votes
1answer
188 views

Error 000177: Failed to create relationship class in Python

I am trying to use python to create a relationship class between a feature class and dbf. I keep getting, "ERROR 000177: Relationship classes can only be created in the same database that ...
0
votes
1answer
342 views

Replace Domains of ArcGIS 10.1

I need to Replace the Domain on Field level on my Geodatabase. My Geodatabase having multiple features and tables where at each on field one Domain is assigned, I need to replace that Domain and ...
0
votes
2answers
337 views

Importing values into n:m relationship class of geodatabase?

I have an m:n relationship class in an ArcGIS 10.0 Geodatabase. The values for the association table already exist in another table. I would now like to import this table into the ArcGIS ...
0
votes
0answers
15 views

Relationship Class Table displays empty table

I'm trying to link 2 tables together using relationship classes (pre-defined within this datamodel). I've uploaded a picture which might be clearer, but here is the process I'm trying: Table named ...
0
votes
0answers
13 views

Related records not showing up in AGOL

I'm struggling whit AGOL and related tables. I've made a gdb in Arcmap and related a child table "test" to its parent feature class "ca" with the tool "Create relationship ...
0
votes
0answers
17 views

Editing relationship class with non spatial tables using ArcGIS Pro

I created a relationship class of two non spatial tables in ArcGIS Pro. Now I am trying to edit the new relationship class. However, since it is not spatial, I cannot select anything on the map. I ...
0
votes
0answers
23 views

Appending to feature and across related tables

I am currently attempting to append a table to a point feature in ArcPro, several of the table entries could be attached to related tables that are linked to the point feature by global ID in a 1:M ...
0
votes
0answers
60 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 ...
0
votes
0answers
93 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 ...
0
votes
0answers
30 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 ...
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, ...
0
votes
0answers
288 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 ...
0
votes
0answers
61 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 ...
0
votes
1answer
72 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 ...
0
votes
1answer
306 views

How can I register a table from an external source with a geodatabase so that I can create relationship classes?

I have two databases. The first is an enterprise geodatabase. The second is a SQL Server database that I have read only permissions to on another server. I am using ArcMap and ArcServer 10.4.1. I am ...
0
votes
0answers
219 views

Exporting subset of data but maintaining relationship class properties within new file geodatabase using ArcPy?

I have created a script tool that allows the user to choose a spatial extent and export several feature classes within that extent and (what is supposed to be) a related table to a new file ...
0
votes
0answers
100 views

Dynamically Create a Foreign Key for Relationship Classes

May be a relativity novice question but my research has turned up no direct answer. I have a feature class of land owner parcels that I would like to preserve its schema. I would like to add fields ...
0
votes
0answers
88 views

Assigning one-to-many polygon to .csv data in ArcGIS for Desktop?

So I am currently working with two separate files. One is a polygon feature class detailing a specific countries' subdistricts. These subdistricts are identified using a specific alpha-numeric code. ...
0
votes
1answer
867 views

Export geodatabase relationship to shapefile [duplicate]

I have a personal geodatabase with a polygon feature class with a one-to-many relationship to a table. What I want to do is to export to a shapefile with all the infornation associated in every ...
-1
votes
1answer
674 views

How to create a relationship class between a feature layer and a standalone table

I need to create a join between a shapefile and a table that have been added to the map, the issue seems to be with the memRelFact.Open("Table-Layer", (IObjectClass)fromTable, "...

1 2
3