topic Re: arcpy fieldmappings Problem (spatial join) in Geoprocessing Questions

arcpy fieldmappings Problem (spatial join)

SeldaSamiri — Wed, 03 Nov 2010 09:33:50 GMT

SORRY! Found the error myself, immediately as I saw my post... wrong feature in the spatialjoin command...
So ignore this post, please!

PS: No delete option here?

##--------------------------------------------------------------------------------------

Hi there,

I want to do a spatial join with a polyline feature (target) and a point feature. In the new polyline-feature all fields of both features should appear. With the default values I only get the fields of the target-feature (correctly) and the ID field of the join-feature. So I tried fieldmapping and added the tables manually like this:

fieldmappings = arcpy.FieldMappings()

fieldmappings.addTable(inputFC)

fieldmappings.addTable(PS_copy)

arcpy.SpatialJoin_analysis (inputFC, PS, outputFC, "#", "#", fieldmappings, "INTERSECT")

This results in a feature table with the right fields, but except of the ID field of the join-feature the other fields have the value 0.

What's wrong with my code?

If this is a stupid question, I'm sorry, I'm quite new to python-scripting...

Thanks!
Selda

Re: arcpy fieldmappings Problem (spatial join)

ChrisMathers — Wed, 03 Nov 2010 11:44:32 GMT

No there isnt a delete option so that problems, even if they are self resolved can help others. By the way if you arent making a change to your field map and just leaving it as the default, you could have just used "#" as that patameter. No need to create that object, add in two tables and then use the object as the parameter.

Re: arcpy fieldmappings Problem (spatial join)

SeldaSamiri — Fri, 05 Nov 2010 12:55:00 GMT

yes, thanx, if I use the correct feature it also works without the fieldmappings object 🙂

Re: arcpy fieldmappings Problem (spatial join)

SusanJones — Sat, 23 Jul 2011 03:16:02 GMT

there is a huge problem with replaceFieldMap() and arcpy.
I struggled for quite some time.
See the link http://forums.arcgis.com/threads/34881-replacefieldmap()-appears-broken-in-arcpy.

Susan