shrug-l: Joins and Relates

[Tripp Corbin]

John,

Joins should only be used when the cardinality is one to one or many to one.
Otherwise ArcGIS will only join the first record it finds that matches. With
cardinalities of one to many or many to many you should use a relate. This
will allow you to link the two tables and see the related records. 

 

Once you set up the relate, you will be able to use the Related Tables
button in the Table window to see the related TRS records. 

 

Other things to consider when using a join or a relate:

1.       Fields must be the same type but the actual field names may be
different

2.       Field values must be exact including capitalization and spaces

 

Hope this helps. 

 

Tripp Corbin, MCP, CFM, GISP | Chief Executive Officer
 <http://www.egisassociates.com/> eGIS Associates, Inc.

 <mailto:tcorbin at egisassociates.com> tcorbin at egisassociates.com |
www.egisassociates.com 

678-710-9710 ext 21 | 866-304-3864 Fax

Esri Certified Desktop Professional | Esri Certified Enterprise System
Design Associate

 

From: shrug-l-bounces at lists.dep.state.fl.us
[mailto:shrug-l-bounces at lists.dep.state.fl.us] On Behalf Of Sykes, John
Sent: Tuesday, July 7, 2015 2:02 PM
To: shrug-l at lists.dep.state.fl.us
Subject: shrug-l: Joins and Relates

 

OK, I am misunderstanding something.

 

I have a map layer of the Public Land Survey System (PLSS) with the
Township, Range and Section (TRS) for the whole state.

 

I have an Excel table with company names and their associated Township,
Range and Section (TRS).

 

I want to join the company table to the PLSS layer, so that each section
that a company (or multiple companies) is/are located in is highlighted.

 

Two problems keep coming up.

 

1.       The join seems to find the first company that matches the PLSS TRS
then ignores any other companies in the same TRS.

2.       One of the companies keeps coming up twice in the resulting join
with the same TRS (don't know if it is significant, but it is the last
company in the Excel list).  I checked and it is only in the Excel table
once.

 

So I start with 43 companies, and end up with 39, including the duplicate,
in the joined table.

 

So the question is, how to do a join with a one (target table) to many (join
list) relationship????

 

 

-- John

 

 

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.dep.state.fl.us/pipermail/shrug-l/attachments/20150707/4731ec34/attachment.htm