KML to Layer without PopupInfo html tags?

Question

Is there a way to import a KML(KMZ) without having any popups bring in their associated tags <td/>, etc.?  Or does anyone have a simple solution (field calculator, python, etc.) to strip these tags out in the attribute table?

We have people taking notes in an iOS app, which exports as a KMZ but the imported KMZ keeps the tags and the text in the resultant layer file.

Thanks!

BugPie · Answer

Hey Bruce,

That is great insight. Thanks for helping me solve this once and for all.

I know this is all in the help docs, but sometimes they get too convoluted and this is a much easier forum to get right to the solution.

Happy mapping, Cheers!

bharold · Answer

Hi

If the KML/Z file has a schema object then the Data Interoperability extension will create a feature class with a properly typed schema with attributes.  If you have to resort to Python then you'll need to parse the HTML with something like BeautifulSoup.

BugPie · Answer

Any news on this front?

We have this great KML file with all sorts of very useful data in the HTML popup. However it's all stored in the popup field in the converted point file and can not be read unless copied and pasted into a text editor of some kind.

Looking for a python script or something to get this info out of the single field the proper attribute table format using multiple columns. I believe it's currently stored as HTML-formatted code stored in a text field.

How do you parse through this stuff!?!?! How have people been accomplishing this task?