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

1
vote
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: ...
0
votes
1answer
131 views

GUID field error when trying to Create a Local Copy

I am hosting our tree inventory data ArcGIS Online so that our Urban Forester can do tree inspections and create work recommendations to field maintenance staff. The database consists of multiple ...
3
votes
1answer
334 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 ...
1
vote
0answers
50 views

Getting origin key to automatically populate foreign key while using relationship class in ArcGIS for Desktop?

I am using ArcGIS for Desktop, and I am attempting to create feature linked annotations for my cable system and I have set up a relationship between the two features so that any changes made to the ...
6
votes
2answers
1k 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 ...
0
votes
1answer
53 views

Appending data in a relational database without changing the GUID

So I am building an ArcGIS relational geodatabase; one copy is stored online for users to enter data into and another copy is stored locally for minor processing and then to generate reports. The ...
8
votes
1answer
945 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 ...
3
votes
1answer
897 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 ...
7
votes
1answer
129 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' ...
0
votes
1answer
140 views

Foreign Key is not added to destination table after the creation of a relationship class

Let's say I have two tables A and B. The relationship between these two tables is as follows : A (1,*) <---- (1,1) B Now when I try to add a relationship class for these two tables on Arcatalog, ...
1
vote
2answers
302 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
80 views

Communicate relation between two table

At this time, I'm able to create a relation (1:M) between two table or geometries. After, I user Identify tool to exploit the relation. It is only possible to use this feature when your Identify tool ...
0
votes
0answers
116 views

CopyDatasets will not overwrite some datasets

I used a script from esri found here http://support.esri.com/en/knowledgebase/techarticles/detail/40831 to import all the feature datasets and feature classes from one file database to another. In the ...
3
votes
1answer
113 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 ...
0
votes
1answer
29 views

Relating tables based on a range of values?

I have a polygon shapefile of parcels with 2 fields that give a low and high address range. I would like to relate this to a point shapefile that has a specific address field for each point. The ...
1
vote
0answers
37 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 ...
2
votes
1answer
102 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
2answers
451 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
0answers
63 views

Assigning one-to-many polygon to .csv data in ArcGIS for Desktop?

So I am currently working with two separate files. One is a polygon feature class detailing a specific countries' subdistricts. These subdistricts are identified using a specific alpha-numeric code. ...
2
votes
0answers
57 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 ...
6
votes
1answer
948 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 ...
2
votes
1answer
572 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 ...
3
votes
2answers
132 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 ...
8
votes
2answers
1k 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 ...
0
votes
1answer
50 views

Error 000177: Failed to create relationship class in Python

I am trying to use python to create a relationship class between a feature class and dbf. I keep getting, "ERROR 000177: Relationship classes can only be created in the same database that ...
2
votes
0answers
56 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
2answers
1k 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 ...
0
votes
1answer
89 views

Export geodatabase relationship to shapefile [duplicate]

I have a personal geodatabase with a polygon feature class with a one-to-many relationship to a table. What I want to do is to export to a shapefile with all the infornation associated in every ...
1
vote
0answers
55 views

Using ArcGIS, can data relationships be created between separate geodatabase containers?

I have several ESRI geodatabases that contain specific detailed information around a central theme. Without revealing the specifics about the theme, each geodatabase has its own domain-driven ...
2
votes
2answers
225 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 ...
-1
votes
1answer
213 views

How to create a relationship class between a feature layer and a standalone table

I need to create a join between a shapefile and a table that have been added to the map, the issue seems to be with the memRelFact.Open("Table-Layer", (IObjectClass)fromTable, ...
6
votes
6answers
960 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 ...
2
votes
1answer
328 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
0answers
39 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
104 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
2answers
474 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 ...
1
vote
1answer
79 views

Can I create a more interactive relationship class for interaction between features?

Is it possible to be able to click on a point and see interacting tables? An example that I found on Google is this flight route map? http://www.ryanair.com/en/cheap-flight-destinations/ Edit: I am ...
1
vote
2answers
144 views

Batch Renaming Relationship Classes

I'm trying to rename about 100 relationship classes in a Geodatabase. All the relationship classes are named under a naming convention and a standard part of that has changed, i.e: abc_feature1_rel ...
0
votes
1answer
125 views

Replace Domains of ArcGIS 10.1

I need to Replace the Domain on Field level on my Geodatabase. My Geodatabase having multiple features and tables where at each on field one Domain is assigned, I need to replace that Domain and ...
8
votes
4answers
4k 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 ...
4
votes
2answers
106 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 ?
3
votes
1answer
404 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 ...
1
vote
0answers
43 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 ...
2
votes
1answer
272 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 ...
9
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 ...
2
votes
3answers
3k 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 ...
1
vote
2answers
147 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 ...
1
vote
1answer
288 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
0answers
139 views

Work around to create feature-linked annotation from standard annotation?

I have one standard annotation feature class that I have used to label the contract names of 6 feature classes. I'm in a tough position where I've been asked to remove a few hundred records from about ...
2
votes
1answer
182 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 ...