Append_management and data within a list

JasonKolbow — Fri, 11 May 2012 17:57:35 GMT

Hello all,

I have a KML file that I've parsed through to obtain some values that get returned as a list. I need this list to append into a table, all as one row entry. As it stands currently I'm unable to append data unless its one entry from the list in its own row within a table. I hope that you guys can shed some insight on this issue. Near the top you'll find a nested loop for my list called "record" - I've commented out 2 lines of code because I'm a bit stuck on what to do at this point. I've attached the KML file in Text Form if you want to try this on your local PC's.

import arcpy  file = r"\\finch\gis\temp\kml\DowsonRansom.kml" f = open(file, 'r') dest = r'C:\Documents and Settings\jmkolb\Desktop\test.gdb\TEST' recordNumber = 0  for line in f:     # Strips leading and trailing spaces from file lines     r = line.strip()      # Checks line integrity for < to start string, assigns variable t1     t1 = r.startswith("<")     t2 = r.endswith(">")      if line.find("<Placemark>") > 0:         if recordNumber <> 0:             record = [Description, Target, RowSpacing, StandCount, Name, CoordinateX, CoordinateY] #photolist]             # Process: Create Table             #arcpy.CreateTable_management(in_memory, "tbl", "'C:\\Documents and Settings\\jmkolb\\Desktop\\test.gdb\\TEST'", "")             # Process: Append             #arcpy.Append_management("record", dest, "NO_TEST", "Name \"Name\" true true false 255 Text 0 0 ,First,#,record[4],Name,-1,-1;FolderPath \"FolderPath\" true true false 255 Text 0 0 ,First,#;SymbolID \"SymbolID\" true true false 4 Long 0 0 ,First,#;AltitudeMode \"AltitudeMode\" true true false 2 Short 0 0 ,First,#;Snippet \"Snippet\" true true false 268435455 Text 0 0 ,First,#;PopupInfo \"PopupInfo\" true true false 268435455 Text 0 0 ,First,#;Description \"Description\" true true false 50 Text 0 0 ,First,#,record[0],Description,-1,-1;Target \"Target\" true true false 50 Text 0 0 ,First,#,record[1],Target,-1,-1;Row_Spacing \"Row_Spacing\" true true false 50 Text 0 0 ,First,#,record[2],Row_Spacing,-1,-1;Stand_Count \"Stand_Count\" true true false 50 Text 0 0 ,First,#,record[3],Stand_Count,-1,-1;Lat \"Lat\" true true false 8 Double 0 0 ,First,#,record[5],Lat,-1,-1;Long \"Long\" true true false 8 Double 0 0 ,record[6],Long,-1,-1", "")          CoordinateX =  ""         CoordinateY =  ""         Name = ""         Description = ""         Target = ""         RowSpacing = ""         StandCount = ""         photolist = []         recordNumber = recordNumber + 1      Attribute = ""     Value = ""      # Checks to see if the line starts and ends with Open and Closing Karrots     if t1 == True and t2 == True:         if line.find("<SimpleData name") > 0:             # Looks for "name=", and pulls the entry between name=" and "><, and its corresponding value from the CDATA tag             Attribute = line[line.find("name=") + 6: line.find("><")-1]             Value = line[line.find("CDATA")+6:line.find("]]></SimpleData>")]             if Attribute == "Description":                 Description = Value             elif Attribute == "Target":                 Target = Value             elif Attribute == "Row Spacing":                 RowSpacing = Value             elif Attribute == "Stand Count":                 StandCount = Value             elif Attribute == "PDFMaps_photos":                 photolist = line.split('"')                 # Sorts the list                 photolist.sort()                 # Reverses sort so Field Name is in position 0                 photolist.reverse()                 # Returns list                 photolist = photolist[:photolist.index('PDFMaps_photos')]                 # Sorts list so Field Name is in position 0                 photolist.sort()                 Attribute = photolist         # Looks for Coordinate tag  in the line         if line.find("<coordinates>") > 0:             # Grabs the value after <coordinates>, splitting by comma for a list             CoordinateX =  line[line.find("<coordinates>")+13:].split(",")[0]             # Grabs the 2nd value in the list after finding <coordinates>             CoordinateY =  line[line.find("<coordinates>")+13:].split(",")[1]             #print "X:",CoordinateX, "Y:",CoordinateY            # Looks for <name> in the line         if line.find("<name>") > 0:             # Pulls the value between CDATA[ and ]]></name>             Name = line[line.find("CDATA")+6:line.find("]]></name>")]             #print "NAME",Name      else:       # Looks for <SimpleData name value within line that doesn't close with >       if line.find("<SimpleData name") > 0:         midline = " "         # Looks in the open line to find the value between name= and ><, and prints it         Attribute = line[line.find("name=") + 6: line.find("><")-1]         # Finds the value for the attribute just found in above line         multiLines = line[line.find("CDATA")+6:].strip()       # Looks in the open line to find the close karrot       elif line.find("]]></SimpleData>") > 0:         multiLine = multiLines + midline.replace('\n'," ") + line[:line.find("]]></SimpleData>")]         #Decision to use multiple line (2 or less) or multiLines (3 or more) for Description         if len(multiLine) > len(multiLines):             Description = multiLine         else:             Description = multiLines       # For all lines that do not have an open or close karrot       else:         midline = midline + line f.close()

Re: Append_management and data within a list

KimOllivier — Sun, 13 May 2012 20:17:06 GMT

Try the elementTree module for handling XML. It is much easier to use to extract out elements into Python dictionaries and lists.

Re: Append_management and data within a list

JasonKolbow — Mon, 14 May 2012 17:00:57 GMT

Thanks for the suggestion Kim. At this point, I've got no issue with having the data I need extracted from the XML. My issue is with taking that data and utilizing an Append of some kind to insert all of the data into one row of a feature or table. Since there can be multiple JPG items within the XML tags, I've had to make a list, within a list to extract those values. That being said, would you think I could use an alternative method to push this data into a feature class or table with the arcpy toolset?

Thanks again for your answer, I'll give it a shot with other XML files I may receive.

Jason

Re: Append_management and data within a list

JasonKolbow — Mon, 14 May 2012 18:56:21 GMT

I ended up using a insert cursor to fix my issue. formatting for it is at the following link Search Cursor Help With this I was able to insert an entire list into one row.

topic Re: Append_management and data within a list in Python Questions

Append_management and data within a list

Re: Append_management and data within a list

Re: Append_management and data within a list

Re: Append_management and data within a list