Podcast #128: We chat with Kent C Dodds about why he loves React and discuss what life was like in the dark days before Git. Listen now.

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
12
votes
2answers
4k views

To Use or Not to Use Relationship Classes?

I am building a government database from a massive amount of data. Now I am following the standard approach of the ESRI Local Government Data Model, but modified to fits the needs and wants of a ...
10
votes
4answers
3k views

With arcpy, how do I detect relationship classes in a file GDB (or can't I)?

I would like to be able to detect relationship classes in a file GDB. Because users of my script might have only an ArcView level license, they would not be able to manipulate the schema of a feature ...
9
votes
1answer
1k views

SQL Server Relationships in ArcSDE?

I am running ArcSDE 10 with SQL Server 2008 R2 Standard Edition. I am new to SDE and SQL Server, but I understand that SQL Server has the ability to create relationships between tables and maintain ...
8
votes
4answers
6k views

Symbolising One-to-many relationships using ArcGIS Desktop?

I have a polygon feature class which has various extent areas with a name which is unique I also have a table (in a file geodatabase) that has the extent names with a score value. But there can be ...
8
votes
1answer
1k views

Does arcpy have a method for accessing related records within a cursor?

I have a line feature class that represent sampling segments. I have a data table of field notes in the same Geodatabase that is connected to the feature class with a Relationship Class. Is there a ...
7
votes
1answer
203 views

How to split Relationship Class privileges between different users while maintaining referential integrity?

I am using a relationship class to maintain a one-to-many relationship between material sites (under Engineering's purview) and the material sites' sample status and content (under Materials' purview)....
6
votes
6answers
2k views

Where can I get (USA) county neighbour relationship data?

I need a graph where each node is a US county and each edge represents a border shared between counties. I do not particularly care about the absolute position or shape of each county (though that ...
6
votes
2answers
2k views

Creating polygons from one to many relationship of points using QGIS or PostGIS?

I have a set of polygons that are in a one to many relationship with points. The polygons are administrative boundaries and the points have information on companies and percentage of ownership . I ...
6
votes
1answer
2k views

Labeling one to many relationship class using ArcGIS for Desktop?

I’ve created a feature class with a one to many relationships to a table. One point many classes. However I want to label the point with the classes attributes. Esri wrote VB solution but it's ...
6
votes
1answer
5k views

Querying Data with a 1-Many Relationship Class

I have created a relationship class similar to the one I posted about in this question. Essentially, there is a point feature class representing a location of vegetation clearing with attributes ...
6
votes
1answer
4k views

How to let ArcGIS Server see related records in a geodatabase

I have an ArcSDE geodatabase which contains multiple relationship classes. If I add this layer to ArcMap, the relationship is automatically applied (eg, the Identify dialog allows me to drill-down to ...
6
votes
1answer
209 views

What is the OGC way of representing Related features?

I have a point shapefile of Persons (The point is located at the registered address of the person) and a polygon shapefile of parcels. There is an owner_id attribute in the parcels shapefile, which ...
6
votes
1answer
339 views

Using one-to-many relationship classe/tabl in ArcGIS Desktop for monitoring?

I have a water source feature class in my geodatabase that stores point locations and other non-changing information. I want to monitor these water sources year after year and keep track of the data ...
6
votes
1answer
852 views

Symbolize a layer based on it's related table (1:M relationship class)

I have a layer of polygons joined by a relationship class to a table by Field = DistrictIDNumber The Table has multiple entries for each polygon so it is a one to many relationship. Is there any way ...
5
votes
2answers
3k views

Is it possible to edit related tables in ArcGIS Online?

I would like to make an editable web map where the user can create a feature then fill in information in a related table all in ArcGIS Online. Is there any way to do this? So far, my research says ...
5
votes
1answer
252 views

Creating relationship classes

I am trying to create relationship classes in a Feature Dataset. The Relationship Class created successfully, I want when I update a record in the Origin table the Destination's would be updated, but ...
5
votes
1answer
1k views

Viewing relationship classes ties for multiple features

I've been working with a complex ArcGIS 9.3.1 geodatabase with multiple feature classes (FC's) interconnected by many relationship classes. My question: supposing I have a FC with features a,b,c and ...
4
votes
1answer
440 views

Accessing “many to many” relationship class using ArcGIS Identify?

I am trying to create a many to many relationship class in ArcGIS 10.0. When Identifying the features though, I don´t see the associated table values. Here is the Class schema: Destination Table ...
4
votes
1answer
310 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 ...
4
votes
1answer
2k views

Automatically update feature class based on another feature class in same geodatabase

I work at headquarters and there are 3 regions. Each region is responsible for their data and headquarters is responsible for merging the data and creating a national coverage. All regions and ...
4
votes
2answers
321 views

Rename Relationship Class labels

Is there a way to rename relationship class labels (forward and Backward labels) after I've created them ? or I have to delete them and create them again ?
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 ...
4
votes
0answers
105 views

Dealing with Null Values in Destination Table After Editing with ArcGIS Relationship Class?

I have an ArcGIS geodatabase that contains one origin feature class linked to multiple standalone tables by Simple one-to-many Relationship Classes. The foreign keys in the destination tables are all ...
3
votes
2answers
325 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 ...
3
votes
4answers
4k views

Creating unique IDs for file geodatabase using ArcGIS for Desktop?

I use ArcEditor licence level, ArcGIS 10.0 version, and we're talking about a file geodatabase. I have several feature classes (electric energy domain) and I want to connect them using relationship ...
3
votes
2answers
283 views

Loading data into file geodatabase without rebuilding relationship classes manually?

I have a file geodatabase with a few M-N composite relationships classes. Every few weeks or months I need to load new data into GDB tables; for this I need to delete the relationship classes, load ...
3
votes
1answer
146 views

Splitting street in Address table which participates in Relationship Class (1-M)?

I have a table "Addresses" and the Feature "streets". The feature "Streets" are lines. I need to do a relation with this table with this feature. What I do? I tried built a "relationship class". The ...
3
votes
2answers
2k views

Loading table in ArcMap gives Serious Application Error?

I am an ArcGis 10. ( ArcEditor licence) user and I have a problem when trying to load data with the Load Objects Tool in ArcMap. I want to load a table, but after I choose the input data (equipment....
3
votes
1answer
773 views

Copy two datasets that particpate in the same relationship class

I have an ArcSDE GDB that looks something like this: ++ GDB +++++ Dataset1 ++++++++ FeatureClass1 ++++++++ FeatureClass2 +++++ Dataset2 ++++++++ FeatureClass3 ++++++++ FeatureClass4 +++++ Table +++++ ...
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-...
3
votes
1answer
2k views

How to create Relationship Classes successfully

I'm new to ArcGIS and I'm making the first steps at this time. At the moment I've two different shapefiles. The first shapefile represents streets on a map with some detailed information in the ...
3
votes
1answer
93 views

Update geometry in ArcGIS Relationship class between point and lines

I have set up two relationship classes with a pipe (storm_pipe) and its structures (storm_struc). Each pipe has a from_struc_id and a to_struc_id, both of which point to a id in the storm_struc layer. ...
3
votes
1answer
1k views

How to build a relational database system with 4 tables in arcgis desktop?

I have been given data from an working online application which consists of a relational model. My aim is to recreate the model using Arcgis Desktop. I have the table "elements" containing Point ...
3
votes
0answers
104 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"...
3
votes
0answers
220 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 ...
3
votes
0answers
47 views

Shoehorning hierarchial data into ArcSDE for MS SQL Server?

I've been tasked with creating a set of tables to store hierarchical data within an ArcSDE. This is in reference to utility data, i.e, a set of valves, control panels, actuators, etc (each ...
3
votes
1answer
426 views

Accessing data stored in related tables from a network dataset

According to ESRI's transit data model, this implementation, and several thesis papers, any non-spatial information (such as public transport schedules, employee info, trips etc) which is not stored ...
3
votes
1answer
3k views

Many-to-Many relationship class table- automatically fill in?

Is there a way that the table of a many-to-many relationship class can automatically be filled in without me selecting the elements connected? So far I am using this method: http://support.esri.com/...
3
votes
0answers
363 views

Records in related table do not appear when using the 'Related Tables' button in attribute table

ArcMap 10 - Geodatabase with related tables & relationship classes. I've written a script that parses data between two databases. When I go into the attribute table of the point feature class and ...
2
votes
2answers
2k views

Does QGIS attribute edit form support “relationship” data?

Consider I have a geometry table having one-to-many relationship with a no-geometry table. When I create a feature (geometry), I would like to be able to add the relative no-geometry table data in the ...
2
votes
2answers
637 views

Identifying Features With a Relationship Class

I have a feature class which represents points where vegetation clearing has occurred. I also have a table which has a list of vegetation species which were cleared at each location and the amount of ...
2
votes
2answers
920 views

“ERROR 000840 | The value is not a Relationship Class”

I'm stumped here. I've seen this error in other posts but not quite in the same context. I'm trying to run the arcpy.management.CreateRelationshipClass() tool in ArcGIS 10.0. Absolutely everything I'...
2
votes
2answers
854 views

Creating relationship class with ArcPy using GlobalID?

I'm trying to create a relationship class with Python using a GlobalID. When I use Python it gives me the error: Failed to execute. Parameters are not valid. ERROR 000800: The value is not a ...
2
votes
1answer
108 views

Personal Geodatabase: Access speed up due the use of RelationshipClasses?

I've a special question about the effects of RelationshipClasses. For some reasons I've created a Personal Geodatabase and imported two features from Shape-Files and created an own table. For ...
2
votes
4answers
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 ...
2
votes
2answers
1k views

Can I achieve one-to-many relationship in QGIS custom forms?

My PostgreSQL database has ElectricLine geometry table which has one-to-many relationship with ElectricLineMaterial non-geometry (attribute only) table. This PostgreSQL table added as layer in QGIS 2....
2
votes
2answers
850 views

Creating join between feature class and table created with InMemoryWorkspaceFactory?

I'm trying to join a featureclass contained inside a pgdb with a table created with an InMemory Workspace. The in-memory table contains results that I want to use to define symbology on the ...
2
votes
1answer
71 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 ...
2
votes
1answer
163 views

ArcGIS Desktop 10.2.1 and one-to-many relationship

I've been struggling to link a feature of 450 municipalities and approximately 60,000 fires that have occurred over the last 15 years. I've attempted to make a relationship class. I can see the ...
2
votes
1answer
3k views

How load data into file geodatabase tables with relationship classes to non simple data?

Further to my earlier question (Loading data into file geodatabase without rebuilding relationship classes manually?), is there any way to load data into GDB tables with relationship classes to ...