KML to SHP: Extract attributes from HTML "PopupInfo" field

Question

Hi all,

I have seen this question posted several times but I still haven't found a solution and it's looking like I'm going to have to turn to a script for the answer.  I downloaded a KML file and ran the KML to Layer tool in ArcGIS to convert it to a feature class.  All of the attributes I'm interested in are stored in HTML in a field called "popup" in my feature class.  Ideally, I would like to extract this information into separate fields (Name, Pond, etc...)  Any suggestions in how to do this?  I'm still fairly new to python but interested in learning more and this seems like a great opportunity.  Any help would be greatly appreciated!

Thanks,

Jason

coalplant_waste_in_tons_out.kml.zip

mabel2.gif

AdrianWelsh · Answer

Jason,

I had this question as well. There are some methods that help extract this data (like using ArcGIS Explorer and doing some importing and exporting, etc.). Though, it seems like the best 'answer' is to use the Data Interoperability Extension:

ArcGIS Data Interoperability | Overview