Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

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

2
votes
0answers
25 views

From tables to file geodatabase with domains, relations, GlobalID and editor tracking

I have a number of tables exported from a file geodatabase that I need to convert back to a file geodatabase. The destination tables participate in relationship classes and have coded value domains. ...
0
votes
1answer
23 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 ...
1
vote
0answers
61 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
26 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
46 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
36 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
43 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 ...
3
votes
0answers
103 views

Using related layers/tables in background?

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 "clean"...
1
vote
1answer
60 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 ...
0
votes
0answers
18 views

How to connect point layers through their attributes/relations?

I have a project to use QGIS to track fishing activities (product goes from boat to fisheries to processors to factories...). All layers have coordinates and I managed to map them but now I´m trying ...
1
vote
1answer
202 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 ...
1
vote
0answers
64 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
21 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
65 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
0answers
21 views

Plot/Chart a related table in a pop up with ArcGIS Pro

I would like to plot a time series related to a line feature in a pop up. So when I click on a line, the associated time series should be plotted in a pop-up. Example: My line feature with only 1 ...
0
votes
1answer
56 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
48 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
23 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, ...
2
votes
1answer
63 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
21 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
0answers
54 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
66 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
38 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
24 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
117 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
62 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 ...
1
vote
1answer
97 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
181 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
75 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
50 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
22 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 ...
1
vote
2answers
2k 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
116 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
92 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
63 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 ...
3
votes
2answers
277 views

Relationship classes and feature classes with the same name

I've noticed that it is possible (at least in ArcGIS 10.1) having within a Personal geodatabase, a relationship class and a feature class/table with the same name!. This is my example: The above ...
4
votes
1answer
248 views

FME Error when writing to relationship class in ArcSDE Geodatabase writer type

I'm working in the FME workbench through ESRI Data Interoperability extension (ArcGIS 10.4.1). I'm writing to an SDE geodatabase with relationship classes established. When attempting to setup the ...
1
vote
2answers
5k views

Using relationship classes with ArcGIS Online?

I am using ArcInfo 10.4 to create geodatabase with a relationship class associating a point feature to a table with the goal of using it to collect inspection data in the table of the point features ...
0
votes
1answer
174 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 ...
1
vote
2answers
381 views

Link and auto-populate attribute table?

I am using ArcGIS 10.3.1. I have feature classes in a geodatabase. I am mapping noxious weed patches, and would like to auto-populate the ownership info, mailing address, etc. The "parcels" feature ...
0
votes
1answer
282 views

Related Tables can be viewed in my webmap but not in Collector

I have a related table set up in an ArcGIS webmap. I can view the related data (1:M) just fine in the webmap. However, when I try to view the related data in Collector, there is nothing there. Is ...
3
votes
0answers
203 views

Spatial Relationship in QGIS [closed]

I'd like to add a layer in QGIS, not just filtered by attribute, but using a spatial relationship. For example, visualize only river features that are within the state of São Paulo, Brazil. How ...
1
vote
1answer
656 views

Creating ArcGIS report with multiple related tables?

Is there a way to create a report in ArcGIS 10.3 that includes data from multiple related tables in a file geodatabase? I'll give an example using soil profile data. I have a point feature class ...
3
votes
2answers
2k views

Creating a Collector map that allows new records to be added to a related table while not allowing spatial features to be created or deleted?

I am trying to create inspection maps for Collector that are very similar to what can be found at this link: https://blogs.esri.com/esri/arcgis/2015/02/18/related-tables-exploring-new-ways-to-use-...
2
votes
1answer
757 views

Populate many-to-many intermediate table betwen two non spatial tables in ArcGIS

Is it possible to populate a many-to-many intermediate table between two non spatial tables in ArcGIS? The intermediate table shows in ArcMap, but the origin and destination tables do not show in ...
1
vote
0answers
85 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 ...
0
votes
0answers
174 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 ...
1
vote
1answer
754 views

Assigning feature symbology by categories with related table in ArcGIS Online?

I am making maps for Collector app with features and related tables. Is there a simple way to assign different symbol to features based on whether it has related records or not?
1
vote
0answers
110 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?
2
votes
0answers
67 views

Selecting rows of attributed relationship class (intermediate table) using relate table function [closed]

I have 2 classes: Owners Properties And 1 relation class (M-N) attributted In my ArcMAP (10.3.1) the intermediate table doesn't appear automatically (The table of relationed class appear). If I ...