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

7
votes
1answer
839 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 ...
7
votes
4answers
2k views

Symbolising One-to-many relationships

I have a polygon feature class which has various extent areas with a name which is unique I also have a table (in an FGDB) that has the extent names with a score value. But there can be many score ...
6
votes
5answers
629 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
624 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 ...
6
votes
1answer
640 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 ...
5
votes
1answer
894 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
941 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
239 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 ...
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
1answer
158 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 ...
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 ...
4
votes
1answer
145 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 ...
3
votes
1answer
28 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
371 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
227 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
0answers
92 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' ...
2
votes
1answer
72 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
273 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
79 views

I made a Relationship Class(1-M). Its a street X our Address table. I can´t split the street. How to fix it?

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 ...
2
votes
1answer
545 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
1answer
431 views

Label one to many relationship class

Good day all, 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 ...
2
votes
2answers
273 views

Is it possible to create a join between a feature class and a table created with an 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
2answers
742 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
1answer
42 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 ...
2
votes
1answer
164 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 ...
2
votes
1answer
40 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
141 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
151 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
1k 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
2answers
56 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
46 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
0answers
219 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
265 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 ...
1
vote
3answers
2k views

creating unique ID-s for my file geodatabase

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 ...
1
vote
1answer
248 views

Can we create relationship classes based on a geometric network?

I have a point Feature Class and a polyline Feature class which I connected in a geometric network. I also need to connect them logically. In my theoretical model, an edge is defined by the two points ...
1
vote
1answer
147 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 ...
1
vote
1answer
49 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 ...
1
vote
1answer
126 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 ...
1
vote
1answer
359 views

fail to create relationship class

I am trying to make a relationship class between two tables, but I get this message at the end: " Failed to create the specified relationship class". Can you tell me why? Thanks, Ligia Sorry I ...
1
vote
1answer
410 views

Some related table fields not displaying in ArcPad 8

I have an issue that I have been struggling with and I'll try to explain without getting too confusing. I have an AXF that is displaying only some of the fields in a related table on the default ...
1
vote
0answers
46 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
71 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 ...
1
vote
1answer
72 views

Using IRelationshipClass

I have three feature classes [CircuitSource(A),CircuitBreaker(B),Sub-Station(C)]. In the Geodatabase A and B has a 1:1 relationship based on a primary field namely 'FEEDERID'. C and B has a 1:many ...
1
vote
0answers
79 views

Copying Features from One ArcMap window to another, without losing Related Tables

In our current workflow we are working in a Personal Geodatabase with few features and related tables , many persons will be working in different schemes. When we need to merge these schemes\Pgdb to ...
1
vote
0answers
185 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 ...
1
vote
0answers
189 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
2answers
202 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 ...
0
votes
1answer
137 views

geodatabase and relationship

I have two tables in a personal geodatabase and one of them has 13 records and 6 fields, the other has 118 records and 125 fields. There is a relationship class between the two tables where the first ...
0
votes
1answer
16 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
96 views

Editing many-to-many relationship classes with Javascript API

I am seeking some guidance on best practices when working with many-to-many relationship classes thru the ArcGIS Server Javascript API. I am designing a traffic count data management application. ...