Spatial Join not populating

2Quiker

I have two feature classes "Par" which is the large boundary(Red line) and "Par1" which is just parcels (black lines). The issues is I only get one single parcel populated with my current code. In the example attached, there are 6 parcels within the red boundary and I need all 6 of those parcels to be in the "PARCELS" field. I have the following code and on line 23 I have indicated that I want to use the Join as the merge rule. The "PARCEL" field on line 23 is the Data source field in Par1 that has each parcel. As far as the map options I have tried, INTERSECT, HAVE_THEIR_CENTER_IN, CONTAINS, WITHIN and it's the same results. I am assuming I am over looking something but I am not sure what it is...

import sys, arcpy, os, fnmatch
from arcpy import env
from datetime import datetime as d
startTime = d.now()
start_time = time.time()


print ('Started')
arcpy.env.overwriteOutput = True
arcpy.env.qualifiedFieldNames = False

arcpy.env.workspace = r"C:\Temp\Scratchworkspace.gdb"

fc_Delete = ["BlahTest"]

Par = "C:/Temp/Diss_Par.shp"
Par1 = "C:/Temp/Parcels.shp"

FieldMapString = '''

PIN "PIN" true true false 13 Text 0 0 ,First,#, {0}, PIN,-1,-1;
ACRES "ACRES" true true false 4 Double 0 0  ,First,#, {0}, ACRES,-1,-1;
PARCELS "PARCELS" true true false 200 Text 0 0 ,Join,#, {0}, PARCEL,-1,-1
'''

def Layers1(Par1):
    fieldmappings = arcpy.FieldMappings()
    fieldmappings.loadFromString(FieldMapString)
    return fieldmappings

def main(args=None):
        if args is None:
                args = sys.argv

arcpy.SpatialJoin_analysis(Par, Par1, "BlahTest", "JOIN_ONE_TO_ONE", "KEEP_ALL",Layers1(Par1), "HAVE_THEIR_CENTER_IN")
print (" Spatial Join Finished")
print ('(Elapsed time: ' + str(d.now() - startTime)[:-3] + ')')
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

SpatialJoinExample.png

RandyBurton

I took another look at your code and noticed the SpatialJoin is making a call to the Layers1 function for the field mapping.  It is being passed the Par1 variable, but the function is not using it.  This may be part of the problem.

While I don't completely understand field mapping, I did some testing and have the following test code that may be of help.  I created a block layer with an ID field called BLOCK.  I created a parcels layer with a text ID field called PIN.  (I don't like working with shape files, so I used a file geodatabase.  The joined layer, once created, could be dumped to a shape file.) The features and the join table created look like the following.

Here's my test code.  Hope it helps.

<SPAN class="keyword token">import</SPAN> arcpy

blocks <SPAN class="operator token">=</SPAN> r<SPAN class="string token">"C:\Test\Test.gdb\test_blocks"</SPAN>
<SPAN class="comment token"># only field used from blocks was the id field "BLOCK"</SPAN>
parcels <SPAN class="operator token">=</SPAN> r<SPAN class="string token">"C:\Test\Test.gdb\test_parcels"</SPAN>
<SPAN class="comment token"># only field used from parcels was the id field "PIN"</SPAN>
joined <SPAN class="operator token">=</SPAN> r<SPAN class="string token">"C:\Test\Test.gdb\test_sj"</SPAN>
<SPAN class="comment token"># the joined feature will also contain fields created during the spatial join</SPAN>

<SPAN class="comment token"># use {0} for blocks and {1} for parcels in field mapping string</SPAN>
<SPAN class="comment token"># for PIN field, parcels uses a text field of 12 characters, this was lengthened in the fms to 200</SPAN>
<SPAN class="comment token">#   so the joined values would fit</SPAN>
fms <SPAN class="operator token">=</SPAN> <SPAN class="string token">""</SPAN>"
BLOCK <SPAN class="string token">"BLOCK"</SPAN> true true false <SPAN class="number token">12</SPAN> Text <SPAN class="number token">0</SPAN> <SPAN class="number token">0</SPAN> <SPAN class="punctuation token">,</SPAN>First<SPAN class="punctuation token">,</SPAN><SPAN class="comment token">#,{0},BLOCK,-1,-1;</SPAN>
PIN <SPAN class="string token">"PIN"</SPAN> true true false <SPAN class="number token">200</SPAN> Text <SPAN class="number token">0</SPAN> <SPAN class="number token">0</SPAN> <SPAN class="punctuation token">,</SPAN>Join<SPAN class="punctuation token">,</SPAN><SPAN class="string token">","</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="punctuation token">{</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">}</SPAN><SPAN class="punctuation token">,</SPAN>PIN<SPAN class="punctuation token">,</SPAN><SPAN class="operator token">-</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="operator token">-</SPAN><SPAN class="number token">1</SPAN>
<SPAN class="string token">""</SPAN>"<SPAN class="punctuation token">.</SPAN>format<SPAN class="punctuation token">(</SPAN>blocks<SPAN class="punctuation token">,</SPAN> parcels<SPAN class="punctuation token">)</SPAN>

arcpy<SPAN class="punctuation token">.</SPAN>SpatialJoin_analysis<SPAN class="punctuation token">(</SPAN>
    target_features <SPAN class="operator token">=</SPAN> blocks<SPAN class="punctuation token">,</SPAN>
    join_features <SPAN class="operator token">=</SPAN> parcels<SPAN class="punctuation token">,</SPAN>
    out_feature_class <SPAN class="operator token">=</SPAN> joined<SPAN class="punctuation token">,</SPAN>
    join_operation <SPAN class="operator token">=</SPAN> <SPAN class="string token">"JOIN_ONE_TO_ONE"</SPAN><SPAN class="punctuation token">,</SPAN>
    join_type <SPAN class="operator token">=</SPAN> <SPAN class="string token">"KEEP_ALL"</SPAN><SPAN class="punctuation token">,</SPAN>
    field_mapping <SPAN class="operator token">=</SPAN> fms<SPAN class="punctuation token">,</SPAN>
    match_option<SPAN class="operator token">=</SPAN><SPAN class="string token">"INTERSECT"</SPAN><SPAN class="punctuation token">,</SPAN>
    search_radius<SPAN class="operator token">=</SPAN><SPAN class="string token">""</SPAN><SPAN class="punctuation token">,</SPAN>
    distance_field_name<SPAN class="operator token">=</SPAN><SPAN class="string token">""</SPAN><SPAN class="punctuation token">)</SPAN>‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>