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
988 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
1answer
709 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
4answers
3k 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
666 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
700 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
178 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
1k 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
306 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
169 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
517 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 ...
4
votes
2answers
79 views

Is there a way to save Geoprocesing results?

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 ...
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
121 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
232 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
32 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
427 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
250 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
102 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
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
1answer
80 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
393 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
84 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
83 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
60 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
140 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
1answer
601 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
301 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
790 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
88 views

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

Further to my earlier question Is there any way to load data into GDB tables with relationship classes to composite data as geometric network with out making them simple first ? I have FGDB with few ...
2
votes
2answers
51 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
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
147 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
155 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
76 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
0answers
81 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
213 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
229 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
417 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
1answer
271 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
150 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 ...
1
vote
1answer
173 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
71 views

How can I delete relationship classes?

ArcGIS 10.2.2 Standard I'm looking for a code sample that can delete all relationship classes from a database, including inside Feature Datasets. I've searched ESRI's site and only found a ...
1
vote
1answer
137 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
397 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
415 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
23 views

label based on related features

Esri's telecom data model has 2 geometric networks, one for infrastructure (manholes and conduits) and one for fiber cables. fiber cables are easily related to a section of conduit based on existing ...
1
vote
2answers
56 views

Interpolation with z-values taken from a related table

This is a follow-up question (organizing attribute table: multiple sets of variables per point). I am working with ArcGIS 10.1, advanced license. My aim was to build a points layer, each point being ...