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

learn more… | top users | synonyms

8
votes
2answers
2k 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 ...
8
votes
2answers
967 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 ...
8
votes
4answers
3k 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 ...
7
votes
1answer
837 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 ...
7
votes
1answer
573 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 ...
6
votes
6answers
847 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
1answer
809 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
219 views

One-to-many relationship classe(s)/table(s) used for monitoring

I realize that this may be a bit simplistic for this blog, so I apologize in advance. However, for someone with a working knowledge of ArcGIS, I've had issues figuring this out on my own. I have a ...
5
votes
1answer
2k 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 ...
5
votes
2answers
1k views

Creating polygons from a one to many relationship of points

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 ...
5
votes
1answer
187 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 ...
5
votes
0answers
116 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' ...
4
votes
1answer
2k 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 ...
3
votes
1answer
100 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
105 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
128 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 ...
3
votes
1answer
324 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 ...
3
votes
1answer
230 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
1answer
546 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 ...
3
votes
1answer
47 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 ...
3
votes
1answer
636 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 shape files. The first shape file represents streets on a map with some detailed information in the ...
3
votes
1answer
305 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 ...
2
votes
3answers
2k 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 ...
2
votes
2answers
340 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 ...
2
votes
1answer
263 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
93 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
2answers
666 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
votes
1answer
48 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
295 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 ...
2
votes
1answer
158 views

One to Many / Many to Many

I have a sanitary sewer line feature class where each line has a unique identifier. I have a table that lists the date a line was cleaned. It may have been cleaned multiple times so I can have ...
2
votes
1answer
231 views

Editing many-to-many relationship classes with ArcGIS API for JavaScript?

I am seeking some guidance on working with many-to-many relationship classes thru the ArcGIS Server Javascript API. I am designing a traffic count data management application. Count data locations are ...
2
votes
2answers
79 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 ?
2
votes
1answer
787 views

Benefits of relationship classes and how they can be accessed in c#

At the moment I've a personal geodatabase with two imported feature classes from shape files and an own created table. This table has columns for the IDs of the elements in the two feature classes. ...
2
votes
2answers
401 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
177 views

ArcGIS: Can you add attributes to a relationship class at a later date?

I have a relationship class that could use a new attribute (or two or three). I have looked for a way to do this in ArcCatalog and have not discovered it yet. I have: Opened the Relationship ...
2
votes
2answers
982 views

create relationship class with stand alone python script

I have created a relationship class in arc catalog using the same arguments I'm using below, however if I try and create it using the script below I get: arcgisscripting.ExecuteError: ERROR ...
2
votes
2answers
175 views

Create a raster from file geodatabase featureclass based on a field from a related table

I have a USDA Statsgo soil polygon featureclass stored in a file geodatabase along with an attribute table; I have a one-to-one relationship class defined based on the soil type field. When I bring ...
2
votes
1answer
42 views

Change Which FeatureClass a RelationshipClass Points at

When you use ArcGIS' Project tool it creates a new featureclass. This is awesome, unless the featureclass you projected had been related to twenty-some tables. All of those relationships still point ...
2
votes
1answer
165 views

Relationships in ArcGIS Server 9.3.1

I am working on a viewer in which I would like to show two related feature classes. If I select a feature of the first one, the related features of the second one should be selected too. I found a ...
2
votes
2answers
164 views

How to view/edit attributed relationship data in Identify/Attributes dialog in ArcMap?

Is there any extension or standard option to view/edit attributed relationship records attributes using standard ArcMap attribute editor dialog? Same to question about identify dialog :) Thanks
2
votes
1answer
2k 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: ...
2
votes
0answers
34 views

Creating a weighted rating model/script for vector data

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 ...
2
votes
0answers
35 views

Link two destination objects in FME

I have an object 'building' which is represented into multiple feature classes (point, line ) in esri file geodatabase. Is there a way to copy an attribute in one class to an attribute of another ...
2
votes
0answers
90 views

How to Bulk “Add Selected” Attributes to a Relationship Class ~ 40000 Records

I have 2 Feature Classes (FC's) and 1 Relationship class. FC1 and FC2 share a common field with almost 40,000 matching records. For each matching record (i.e. when the matching records from FC1 ...
2
votes
0answers
36 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 ...
2
votes
0answers
103 views

Maintain Relationship Class between Feature Class and Attribute Table after primary key attribute is changed

I have a File Geoedatabase Feature Class with Polygon features of agricultural LAND_PARCELS. Each land parcel has a unique PARCEL_ID. The land parcel Feature Class needs to be related to a table ...
2
votes
0answers
269 views

ArcGIS Server 10.0, Rest Service not showing relashionship class

It's the first time that I am using Relationship Classes for a web mapping project. Everything seems to be set-up properly, meaning I can get the related info out of ArcMap and ArcCatalog when ...
2
votes
0answers
267 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 ...
1
vote
2answers
764 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 ...