AnsweredAssumed Answered

Writing SOAP returned results to table in file geodatabase

Question asked by geoffreywestgis on Jan 26, 2015

I have a script which prints the lat, lon of bus routes, how would I use arcpy to print this to a table in a file geodatabase?


Example of Output

45.266759 -75.741350

45.266221 -75.741675


45.311531 -75.739158

45.355146 -75.769231

45.412336 -75.718080




import xml.etree.ElementTree as ET
import urllib

u = urllib.urlopen('', 'appID=7a51d100&apiKey=5c5a8438efc643286006d82071852789&routeNo=95&stopNo=3044')
data =

f = open('route3044.xml', 'wb')

doc = ET.parse('route3044.xml')

for bus in doc.findall('.//{}Trip'):
   lat = bus.findtext('{}Latitude')
  lon = bus.findtext('{}Longitude')
   print lat, lon