Spatial Join Intersect

Question

Ultimately I want to attribute a lake with the fields from a stream that runs through the lake. There are several streams that end within the lake polygon so any of the spatial intersection tools will capture both the streams running through and ending in the lake.

How might I choose the stream that runs through the lake and use this for the Spatial Join? Python? Is there a spatial select tool i'm not aware of which will refine the intersect option?

IntersectLakes.pdf

HeathBrackett1 · Answer

You could also create a process that intersects the rivers with the outline of the lake (convert the polygon to line). The river that runs through the lake will intersect the lake line twice, which you can identify by dissolving the points based on river name (and summarizing the OID by COUNT).  That will ensure that you are identifying the river that runs through the lake.

Heath

jskinner · Answer

You could accomplish this with a python script.  Here is an example:import arcpy
from arcpy import env
env.overwriteOutput =1
env.workspace = r"C:	emp\python	est.gdb"

#create a one-to-many spatial join
arcpy.SpatialJoin_analysis("lakes", "rivers", "lakes_join", "JOIN_ONE_TO_MANY", "KEEP_ALL", "", "INTERSECT")

#create empty dictionary to store target_fid and shape length
dict = {}

#sort by river's shape length, iterate through each row, and populate dictionary with largest river length
rows = arcpy.SearchCursor("lakes_join", "", "", "", "SHAPE_LENGTH_1 A")
for row in rows:
    length = '%.14f' % row.SHAPE_LENGTH_1
    dict[row.TARGET_FID] = length

del row, rows

#delete all values that are not the larget river
for key in dict:
    print key, dict[key]
    arcpy.MakeFeatureLayer_management("lakes_join", "lakes_join_lyr", "TARGET_FID = " + str(key) + " AND NOT SHAPE_Length_1 = " + str(dict[key]))
    arcpy.DeleteFeatures_management("lakes_join_lyr")

print "finished"

JackieWoodruff · Answer

Thank you very much for your reply, Jake.

I found that using the Merge Rule chose the maximum value for the Shape_Length field except the values for the other fields are not from the same record. All of the other joined fields have values from the record with the smallest OBJECTID. I assume this is because it is the first result returned and this is the default method used for matching?

Do you have any other suggestions? My only other idea is to use the Merge Rule to find the longest length and then join the streams based on the shape_length.

Thanks!
Jackie