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
162
questions
0
votes
1
answer
27
views
Creating 1:1 relationship in ArcPy
I'm trying to build out a connected relationship between two tables. The requirements include the following:
A row shall be entered into the B table for every record in the A dataset. A 1:1 ...
1
vote
0
answers
112
views
How to add new row to a related table (with Relationship Class) in ArcGIS Pro using Pro attribute table
I have a FC called Schools.SDE.Schools and a Table called Schools.SDE.Maintenance and
there is a Relationship class between them called Schools.SDE.Schools_Maintenance
Now using the Attribute Pane I ...
0
votes
0
answers
27
views
Inherit feature color from another feature automatically with ArcMap
I'm working on a "Ftth" project and there are many repetitive tasks. So, I have to connect the house to the closure through a wire. Whenever I give a color to each closure, the link and the ...
1
vote
0
answers
139
views
Using GDAL 3.6 to convert file geodatabases domains, subtypes and relatioship classes into PostGIS
I am using GDAL 3.6.0, with the OpenFileGDB driver, to read a file geodatabase with domains, subtypes and relationship classes and need to convert them to PostGIS.
In the GDAL documentation, it is ...
3
votes
1
answer
858
views
Get attribute value from parent layer to child layer sharing same uniqueID
CONTEXT
My data consists of a Point-shp (parent layer), a table (child layer), and a 1-N relation between these layers. The point layer represents trees. In this point-layer there is an attribute ...
1
vote
1
answer
1k
views
Why create relationship class if still need to make join to see related attributes in layer using ArcGIS Pro
What is the point of creating a relationship class in ArcGIS Pro i.e. how can I "actually" make use of this relation?
When I add a layer to the map, suppose I want its label to show a field ...
2
votes
3
answers
268
views
Aggregating attributes from line to point using QGIS Expression
I have two feature classes: point and line. The purpose is to make geometrical relations between them. For instance, if points are on line then they automatically take attributes from a specific field ...
2
votes
1
answer
144
views
QGIS Check parent layer name
I have a no-geometry layer 'pictures' linked to several different parent layers. This means the project can have multiple photos attached to a point and all the photos for the project can be viewed at ...
0
votes
0
answers
122
views
Ensure constraints before opening value relation QField
My QGIS Project is made of many obligatory non-null fields and value relation widgets. While I'm able to use value relation widget along my forms in QGIS, in QField I need to fill all fields to be ...
1
vote
1
answer
872
views
List string values from multiple related tables in ArcGIS Pro popup
I have a polygon feature class (BIA tribal boundaries) with three relationship classes set up to relate to three separate tables, each with a 1:M cardinality from the feature class to the table. I ...
0
votes
1
answer
266
views
Service error code 1000
I am trying to use Esri Field Maps to conduct maintenance inspections of stormwater assets. I have multiple layers (i.e. catch basins, outfalls, ditches, etc) each related to a maintenance table ...
1
vote
0
answers
874
views
Relationship Classes with existing data in ArcGIS Online
I'm new to ArcGIS Online and am still getting used to the terminology, but GIS is not new to me at all; I'm always learning. I've recently migrated my work's GIS data to ArcGIS Online using ArcGIS Pro ...
0
votes
1
answer
645
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
1
answer
396
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
1
answer
246
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 ...
1
vote
0
answers
52
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
1
answer
428
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 ...
1
vote
0
answers
549
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
1
answer
83
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
1
answer
131
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
0
answers
44
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
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, ...
1
vote
1
answer
79
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
0
answers
333
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
1
answer
52
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
0
answers
205
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
1
answer
171
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
1
answer
1k
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
0
answers
595
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
1
answer
59
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
1
answer
712
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
0
answers
316
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
1
answer
201
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
1
answer
696
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
1
answer
368
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
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 ...
2
votes
0
answers
784
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
0
answers
58
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
0
answers
82
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' ...
1
vote
1
answer
320
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
1
answer
166
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
0
answers
26
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
1
answer
247
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
1
answer
31
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
1
answer
409
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
1
answer
237
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
1
answer
213
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
1
answer
54
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
1
answer
411
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
1
answer
87
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 ...