I'm interested in using your R script to reformat a KML (SHP) file in order to create columns for "Ranch", "Lot", and "Grower" from the attached file. Would you be able to help me revise your script so it will work with this file?
I believe this should be the correct answer (Abhalla2 provided) unless there is a better way. Reading the KML as an XML will allow you to access the additional data. You may need to add logic in your load script to transform/normalize the data, but I've never had issues going this route.