I am working on a python application to download information from Waze that we receive in XML format. I have the part of the code written to download the file and name it based on the time and date. The problem that I have is automating the import of the XML file into a personal geodatabase. I am using pypyodbc to establish the connection to the database and the cursor for the SQL statement to import the xml data. The only example I have been able to find it for importing an Excel spreadsheet into Access. cnxn = pypyodbc . connect ( r 'Driver={Microsoft Access Driver (*.mdb, *.accdb)};' + r 'DBQ=C:\Users\Public\Database1.accdb' ) crsr = cnxn . cursor () crsr . execute ( r "SELECT * INTO fromExcel " + r "FROM [Excel 12.0 Xml;HDR=YES;IMEX=2;ACCDB=YES;DATABASE=C:\Users\Public\xlData.xlsx].[Sheet1$]" ) crsr . commit () crsr . close () cnxn . close () The part after "crsr.execute(" is where I am having problems with the syntax to set the name for the table. I cannot find much information on this part. Has anyone else dealt with this issue?

Although these examples work with a file geodatabase, they may give you some ideas. If the Waze xml uses the GPX format, you could use the GPX To Features tool. I use this script to convert a number of GPX files to features: import glob , os import arcpy import datetime gpxPath = r "C:\Path\to\gpx\directory" gdb = r 'C:\Path\to\file.gdb' arcpy . env . workspace = gdb os . chdir ( gpxPath ) print datetime . datetime . now ( ) for gpx in glob . glob ( "*.gpx" ) : gpxStr = filter ( str . isdigit , gpx ) gpxStr = 'GPX_' + gpxStr [ 2 : 8 ] + '_' + gpxStr [ 8 : ] # my filename included a date/time print gpxStr arcpy . GPXtoFeatures_conversion ( Input_GPX_File = gpxPath + gpx , Output_Feature_class = gpxStr ) for i in range ( 0 , arcpy . GetMessageCount ( ) ) : print arcpy . GetMessage ( i ) Many of my GPX files are created by the logging function built into the Bad Elf Pro GPS. The XML file includes some additional extensions that the GPXtoFeatures tool will not import. So I use the following to convert the XML into a feature, which uses steps outlined by James MacKay: # import Bad Elf track from GPX xml file and save as file geodatabase feature import xml . etree . ElementTree as ET import re import arcpy from arcpy import env # geodatabase and environment to use geoDB = r "C:\Path\To\file.gdb" env . workspace = geoDB ns = { 'gpx' : ' http://www.topografix.com/GPX/1/1 ' , 'elf' : ' http://bad-elf.com/xmlschemas ' } # name for feature layer from xml for trk in tree . findall ( 'gpx:trk' , ns ) : feature = trk . find ( 'gpx:name' , ns ) . text feature = 'BE_' + ' ' . join ( re . sub ( '[^0-9a-zA-Z ]' , '' , feature . strip ( ) ) . split ( ) ) # create feature print "\nCreating feature: " + feature geometry_type = "POINT" tree = ET . parse ( r"C : \Path\To\bad - elf . gpx' ) # xml file template = " #" has_m = "DISABLED" has_z = "DISABLED" spatial_reference = arcpy . SpatialReference ( "WGS 1984" ) arcpy . CreateFeatureclass_management ( geoDB , feature , geometry_type , template , has_m , has_z , spatial_reference ) # add fields arcpy . AddField_management ( feature , 'TimeString' , 'TEXT' , ' #','#','20','Date and Time','Nullable','NON_REQUIRED') arcpy . AddField_management ( feature , 'HDOP' , 'DOUBLE' , ' #','#','#','HDOP','Nullable','NON_REQUIRED') arcpy . AddField_management ( feature , 'Speed' , 'DOUBLE' , ' #','#','#','Speed','Nullable','NON_REQUIRED') arcpy . AddField_management ( feature , 'EleGPS' , 'DOUBLE' , ' #','#','#','GPS Elevation','Nullable','NON_REQUIRED') arcpy . AddField_management ( feature , 'EleBP' , 'DOUBLE' , ' #','#','#','BP Elevation','Nullable','NON_REQUIRED') arcpy . AddField_management ( feature , 'BP' , 'DOUBLE' , ' #','#','#','Barometric Pressure','Nullable','NON_REQUIRED') # open an insert cursor cursor = arcpy . da . InsertCursor ( feature , [ 'TimeString' , 'HDOP' , 'Speed' , 'EleGPS' , 'EleBP' , 'BP' , 'SHAPE@XY' ] ) # read xml and insert into feature for trkseg in tree . findall ( 'gpx:trk' , ns ) : for trkpt in trkseg . find ( 'gpx:trkseg' , ns ) : ts = trkpt . find ( 'gpx:time' , ns ) . text hd = float ( trkpt . find ( 'gpx:hdop' , ns ) . text ) sp = float ( trkpt . find ( 'gpx:extensions/elf:speed' , ns ) . text ) el = float ( trkpt . find ( 'gpx:ele' , ns ) . text ) be = float ( trkpt . find ( 'gpx:extensions/elf:baroEle' , ns ) . text ) bp = float ( trkpt . find ( 'gpx:extensions/elf:baroPress' , ns ) . text ) row = ( ts , hd , sp , el , be , bp , ( float ( trkpt . attrib [ 'lon' ] ) , float ( trkpt . attrib [ 'lat' ] ) ) ) print row cursor . insertRow ( row ) #delete the cursor to finish del cursor print "Done." Here's a sample of the Bad Elf XML used: <gpx xmlns="http://www.topografix.com/GPX/1/1" xmlns:gpxx="http://www.garmin.com/xmlschemas/GpxExtensions/v3" xmlns:gpxtpx="http://www.garmin.com/xmlschemas/TrackPointExtension/v1" xmlns:badelf="http://bad-elf.com/xmlschemas" version="1.1" creator="Bad Elf GPS Pro+ 2.1.44" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.topografix.com/GPX/1/1 http://www.topografix.com/GPX/1/1/gpx.xsd http://www.garmin.com/xmlschemas/GpxExtensions/v3 http://www.garmin.com/xmlschemas/GpxExtensionsv3.xsd http://www.garmin.com/xmlschemas/TrackPointExtension/v1 http://www.garmin.com/xmlschemas/TrackPointExtensionv1.xsd http://bad-elf.com/xmlschemas http://bad-elf.com/xmlschemas/GpxExtensionsV1.xsd"> Bad Elf GPS Pro+ 007 Bad Elf GPS Pro+ BE-GPS-2300 8.0.0 2.1.44 gps 95.8 2017-09-21T02:46:58Z START (2017-09-21T02:46:58Z) 2017-09-21T02:46:58Z 95.8 2017-09-21T02:46:58Z 1.2 0.77 74.10 1007.31 Hope this helps.

nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Importing an XML file into Access using Python

DavidDenham

I am working on a python application to download information from Waze that we receive in XML format. I have the part of the code written to download the file and name it based on the time and date. The problem that I have is automating the import of the XML file into a personal geodatabase. I am using pypyodbc to establish the connection to the database and the cursor for the SQL statement to import the xml data. The only example I have been able to find it for importing an Excel spreadsheet into Access.

<SPAN class="" style="color: #303336; border: 0px; font-weight: inherit; font-size: inherit;">cnxn </SPAN><SPAN class="" style="color: #303336; border: 0px; font-weight: inherit; font-size: inherit;">=</SPAN><SPAN class="" style="color: #303336; border: 0px; font-weight: inherit; font-size: inherit;"> pypyodbc</SPAN><SPAN class="" style="color: #303336; border: 0px; font-weight: inherit; font-size: inherit;">.</SPAN><SPAN class="" style="color: #303336; border: 0px; font-weight: inherit; font-size: inherit;">connect</SPAN><SPAN class="" style="color: #303336; border: 0px; font-weight: inherit; font-size: inherit;">(</SPAN><SPAN class="" style="color: #303336; border: 0px; font-weight: inherit; font-size: inherit;">&nbsp;&nbsp;&nbsp; r</SPAN><SPAN class="" style="color: #7d2727; border: 0px; font-weight: inherit; font-size: inherit;">'Driver={Microsoft Access Driver (*.mdb, *.accdb)};'</SPAN><SPAN class="" style="color: #303336; border: 0px; font-weight: inherit; font-size: inherit;"> </SPAN><SPAN class="" style="color: #303336; border: 0px; font-weight: inherit; font-size: inherit;">+</SPAN><SPAN class="" style="color: #303336; border: 0px; font-weight: inherit; font-size: inherit;">&nbsp;&nbsp;&nbsp; r</SPAN><SPAN class="" style="color: #7d2727; border: 0px; font-weight: inherit; font-size: inherit;">'DBQ=C:\Users\Public\Database1.accdb'</SPAN><SPAN class="" style="color: #303336; border: 0px; font-weight: inherit; font-size: inherit;">)</SPAN><SPAN class="" style="color: #303336; border: 0px; font-weight: inherit; font-size: inherit;">crsr </SPAN><SPAN class="" style="color: #303336; border: 0px; font-weight: inherit; font-size: inherit;">=</SPAN><SPAN class="" style="color: #303336; border: 0px; font-weight: inherit; font-size: inherit;"> cnxn</SPAN><SPAN class="" style="color: #303336; border: 0px; font-weight: inherit; font-size: inherit;">.</SPAN><SPAN class="" style="color: #303336; border: 0px; font-weight: inherit; font-size: inherit;">cursor</SPAN><SPAN class="" style="color: #303336; border: 0px; font-weight: inherit; font-size: inherit;">()</SPAN><SPAN class="" style="color: #303336; border: 0px; font-weight: inherit; font-size: inherit;">crsr</SPAN><SPAN class="" style="color: #303336; border: 0px; font-weight: inherit; font-size: inherit;">.</SPAN><SPAN class="" style="color: #303336; border: 0px; font-weight: inherit; font-size: inherit;">execute</SPAN><SPAN class="" style="color: #303336; border: 0px; font-weight: inherit; font-size: inherit;">(</SPAN><SPAN class="" style="color: #303336; border: 0px; font-weight: inherit; font-size: inherit;">&nbsp;&nbsp;&nbsp; r</SPAN><SPAN class="" style="color: #7d2727; border: 0px; font-weight: inherit; font-size: inherit;">"SELECT * INTO fromExcel "</SPAN><SPAN class="" style="color: #303336; border: 0px; font-weight: inherit; font-size: inherit;"> </SPAN><SPAN class="" style="color: #303336; border: 0px; font-weight: inherit; font-size: inherit;">+</SPAN><SPAN class="" style="color: #303336; border: 0px; font-weight: inherit; font-size: inherit;">&nbsp;&nbsp;&nbsp; r</SPAN><SPAN class="" style="color: #7d2727; border: 0px; font-weight: inherit; font-size: inherit;">"FROM [Excel 12.0 Xml;HDR=YES;IMEX=2;ACCDB=YES;DATABASE=C:\Users\Public\xlData.xlsx].[Sheet1$]"</SPAN><SPAN class="" style="color: #303336; border: 0px; font-weight: inherit; font-size: inherit;">)</SPAN><SPAN class="" style="color: #303336; border: 0px; font-weight: inherit; font-size: inherit;">crsr</SPAN><SPAN class="" style="color: #303336; border: 0px; font-weight: inherit; font-size: inherit;">.</SPAN><SPAN class="" style="color: #303336; border: 0px; font-weight: inherit; font-size: inherit;">commit</SPAN><SPAN class="" style="color: #303336; border: 0px; font-weight: inherit; font-size: inherit;">()</SPAN><SPAN class="" style="color: #303336; border: 0px; font-weight: inherit; font-size: inherit;">crsr</SPAN><SPAN class="" style="color: #303336; border: 0px; font-weight: inherit; font-size: inherit;">.</SPAN><SPAN class="" style="color: #303336; border: 0px; font-weight: inherit; font-size: inherit;">close</SPAN><SPAN class="" style="color: #303336; border: 0px; font-weight: inherit; font-size: inherit;">()</SPAN><SPAN class="" style="color: #303336; border: 0px; font-weight: inherit; font-size: inherit;">cnxn</SPAN><SPAN class="" style="color: #303336; border: 0px; font-weight: inherit; font-size: inherit;">.</SPAN><SPAN class="" style="color: #303336; border: 0px; font-weight: inherit; font-size: inherit;">close</SPAN><SPAN class="" style="color: #303336; border: 0px; font-weight: inherit; font-size: inherit;">()</SPAN>

The part after "crsr.execute(" is where I am having problems with the syntax to set the name for the table. I cannot find much information on this part. Has anyone else dealt with this issue?

Trouver plus de publications taguées avec

Accepted answers

RandyBurton

Although these examples work with a file geodatabase, they may give you some ideas.

If the Waze xml uses the GPX format, you could use the GPX To Features tool. I use this script to convert a number of GPX files to features:

<SPAN class="keyword token">import</SPAN> glob<SPAN class="punctuation token">,</SPAN> os
<SPAN class="keyword token">import</SPAN> arcpy
<SPAN class="keyword token">import</SPAN> datetime

gpxPath <SPAN class="operator token">=</SPAN> r<SPAN class="string token">"C:\Path\to\gpx\directory"</SPAN>
gdb <SPAN class="operator token">=</SPAN> r<SPAN class="string token">'C:\Path\to\file.gdb'</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>env<SPAN class="punctuation token">.</SPAN>workspace <SPAN class="operator token">=</SPAN> gdb

os<SPAN class="punctuation token">.</SPAN>chdir<SPAN class="punctuation token">(</SPAN>gpxPath<SPAN class="punctuation token">)</SPAN>
<SPAN class="keyword token">print</SPAN> datetime<SPAN class="punctuation token">.</SPAN>datetime<SPAN class="punctuation token">.</SPAN>now<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN>
<SPAN class="keyword token">for</SPAN> gpx <SPAN class="keyword token">in</SPAN> glob<SPAN class="punctuation token">.</SPAN>glob<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"*.gpx"</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; gpxStr <SPAN class="operator token">=</SPAN> filter<SPAN class="punctuation token">(</SPAN>str<SPAN class="punctuation token">.</SPAN>isdigit<SPAN class="punctuation token">,</SPAN> gpx<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; gpxStr <SPAN class="operator token">=</SPAN> <SPAN class="string token">'GPX_'</SPAN><SPAN class="operator token">+</SPAN>gpxStr<SPAN class="punctuation token">[</SPAN><SPAN class="number token">2</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="number token">8</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="operator token">+</SPAN><SPAN class="string token">'_'</SPAN><SPAN class="operator token">+</SPAN>gpxStr<SPAN class="punctuation token">[</SPAN><SPAN class="number token">8</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="comment token"># my filename included a date/time</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">print</SPAN> gpxStr
&nbsp;&nbsp;&nbsp; 
&nbsp;&nbsp;&nbsp; arcpy<SPAN class="punctuation token">.</SPAN>GPXtoFeatures_conversion<SPAN class="punctuation token">(</SPAN>Input_GPX_File<SPAN class="operator token">=</SPAN>gpxPath<SPAN class="operator token">+</SPAN>gpx<SPAN class="punctuation token">,</SPAN> Output_Feature_class<SPAN class="operator token">=</SPAN>gpxStr<SPAN class="punctuation token">)</SPAN> 
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">for</SPAN> i <SPAN class="keyword token">in</SPAN> range<SPAN class="punctuation token">(</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">,</SPAN>arcpy<SPAN class="punctuation token">.</SPAN>GetMessageCount<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">print</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>GetMessage<SPAN class="punctuation token">(</SPAN>i<SPAN class="punctuation token">)</SPAN>
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

Many of my GPX files are created by the logging function built into the Bad Elf Pro GPS. The XML file includes some additional extensions that the GPXtoFeatures tool will not import. So I use the following to convert the XML into a feature, which uses steps outlined by James MacKay‌:

<SPAN class="comment token"># import Bad Elf track from GPX xml file and save as file geodatabase feature</SPAN>

<SPAN class="keyword token">import</SPAN> xml<SPAN class="punctuation token">.</SPAN>etree<SPAN class="punctuation token">.</SPAN>ElementTree <SPAN class="keyword token">as</SPAN> ET
<SPAN class="keyword token">import</SPAN> re
<SPAN class="keyword token">import</SPAN> arcpy
<SPAN class="keyword token">from</SPAN> arcpy <SPAN class="keyword token">import</SPAN> env

<SPAN class="comment token"># geodatabase and environment to use</SPAN>
geoDB <SPAN class="operator token">=</SPAN> r<SPAN class="string token">"C:\Path\To\file.gdb"</SPAN>
env<SPAN class="punctuation token">.</SPAN>workspace <SPAN class="operator token">=</SPAN> geoDB

ns <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">{</SPAN> <SPAN class="string token">'gpx'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token"><SPAN>'</SPAN><A class="jive-link-external-small" href="https://community.esri.com/external-link.jspa?url=http%3A%2F%2Fwww.topografix.com%2FGPX%2F1%2F1" target="_blank">http://www.topografix.com/GPX/1/1</A><SPAN>'</SPAN></SPAN><SPAN class="punctuation token">,</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="string token">'elf'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token"><SPAN>'</SPAN><A class="jive-link-external-small" href="https://community.esri.com/external-link.jspa?url=http%3A%2F%2Fbad-elf.com%2Fxmlschemas" target="_blank">http://bad-elf.com/xmlschemas</A><SPAN>'</SPAN></SPAN> <SPAN class="punctuation token">}</SPAN>
<SPAN class="comment token"># name for feature layer from xml</SPAN>
<SPAN class="keyword token">for</SPAN> trk <SPAN class="keyword token">in</SPAN> tree<SPAN class="punctuation token">.</SPAN>findall<SPAN class="punctuation token">(</SPAN><SPAN class="string token">'gpx:trk'</SPAN><SPAN class="punctuation token">,</SPAN> ns<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; feature <SPAN class="operator token">=</SPAN> trk<SPAN class="punctuation token">.</SPAN>find<SPAN class="punctuation token">(</SPAN><SPAN class="string token">'gpx:name'</SPAN><SPAN class="punctuation token">,</SPAN> ns<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">.</SPAN>text
feature <SPAN class="operator token">=</SPAN> <SPAN class="string token">'BE_'</SPAN><SPAN class="operator token">+</SPAN><SPAN class="string token">' '</SPAN><SPAN class="punctuation token">.</SPAN>join<SPAN class="punctuation token">(</SPAN>re<SPAN class="punctuation token">.</SPAN>sub<SPAN class="punctuation token">(</SPAN><SPAN class="string token">'[^0-9a-zA-Z ]'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">''</SPAN><SPAN class="punctuation token">,</SPAN> feature<SPAN class="punctuation token">.</SPAN>strip<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">.</SPAN>split<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>

<SPAN class="comment token"># create feature</SPAN>
<SPAN class="keyword token">print</SPAN> <SPAN class="string token">"\nCreating feature: "</SPAN> <SPAN class="operator token">+</SPAN> feature
geometry_type <SPAN class="operator token">=</SPAN> <SPAN class="string token">"POINT"</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
tree <SPAN class="operator token">=</SPAN> ET<SPAN class="punctuation token">.</SPAN>parse<SPAN class="punctuation token">(</SPAN>r"C<SPAN class="punctuation token">:</SPAN>\Path\To\bad<SPAN class="operator token">-</SPAN>elf<SPAN class="punctuation token">.</SPAN>gpx'<SPAN class="punctuation token">)</SPAN> <SPAN class="comment token"># xml file</SPAN>

template <SPAN class="operator token">=</SPAN> "<SPAN class="comment token">#"</SPAN>
has_m <SPAN class="operator token">=</SPAN> <SPAN class="string token">"DISABLED"</SPAN>
has_z <SPAN class="operator token">=</SPAN> <SPAN class="string token">"DISABLED"</SPAN>
spatial_reference <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>SpatialReference<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"WGS 1984"</SPAN><SPAN class="punctuation token">)</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>CreateFeatureclass_management<SPAN class="punctuation token">(</SPAN>geoDB<SPAN class="punctuation token">,</SPAN> feature<SPAN class="punctuation token">,</SPAN> geometry_type<SPAN class="punctuation token">,</SPAN> template<SPAN class="punctuation token">,</SPAN> has_m<SPAN class="punctuation token">,</SPAN> has_z<SPAN class="punctuation token">,</SPAN> spatial_reference<SPAN class="punctuation token">)</SPAN>

<SPAN class="comment token"># add fields</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>AddField_management<SPAN class="punctuation token">(</SPAN>feature<SPAN class="punctuation token">,</SPAN><SPAN class="string token">'TimeString'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'TEXT'</SPAN><SPAN class="punctuation token">,</SPAN>'<SPAN class="comment token">#','#','20','Date and Time','Nullable','NON_REQUIRED')</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>AddField_management<SPAN class="punctuation token">(</SPAN>feature<SPAN class="punctuation token">,</SPAN><SPAN class="string token">'HDOP'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'DOUBLE'</SPAN><SPAN class="punctuation token">,</SPAN>'<SPAN class="comment token">#','#','#','HDOP','Nullable','NON_REQUIRED')</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>AddField_management<SPAN class="punctuation token">(</SPAN>feature<SPAN class="punctuation token">,</SPAN><SPAN class="string token">'Speed'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'DOUBLE'</SPAN><SPAN class="punctuation token">,</SPAN>'<SPAN class="comment token">#','#','#','Speed','Nullable','NON_REQUIRED')</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>AddField_management<SPAN class="punctuation token">(</SPAN>feature<SPAN class="punctuation token">,</SPAN><SPAN class="string token">'EleGPS'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'DOUBLE'</SPAN><SPAN class="punctuation token">,</SPAN>'<SPAN class="comment token">#','#','#','GPS Elevation','Nullable','NON_REQUIRED')</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>AddField_management<SPAN class="punctuation token">(</SPAN>feature<SPAN class="punctuation token">,</SPAN><SPAN class="string token">'EleBP'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'DOUBLE'</SPAN><SPAN class="punctuation token">,</SPAN>'<SPAN class="comment token">#','#','#','BP Elevation','Nullable','NON_REQUIRED')</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>AddField_management<SPAN class="punctuation token">(</SPAN>feature<SPAN class="punctuation token">,</SPAN><SPAN class="string token">'BP'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'DOUBLE'</SPAN><SPAN class="punctuation token">,</SPAN>'<SPAN class="comment token">#','#','#','Barometric Pressure','Nullable','NON_REQUIRED')</SPAN>

<SPAN class="comment token"># open an insert cursor</SPAN>
cursor <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>da<SPAN class="punctuation token">.</SPAN>InsertCursor<SPAN class="punctuation token">(</SPAN>feature<SPAN class="punctuation token">,</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="string token">'TimeString'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'HDOP'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'Speed'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'EleGPS'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'EleBP'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'BP'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'SHAPE@XY'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>

<SPAN class="comment token"># read xml and insert into feature</SPAN>
<SPAN class="keyword token">for</SPAN> trkseg <SPAN class="keyword token">in</SPAN> tree<SPAN class="punctuation token">.</SPAN>findall<SPAN class="punctuation token">(</SPAN><SPAN class="string token">'gpx:trk'</SPAN><SPAN class="punctuation token">,</SPAN> ns<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">for</SPAN> trkpt <SPAN class="keyword token">in</SPAN> trkseg<SPAN class="punctuation token">.</SPAN>find<SPAN class="punctuation token">(</SPAN><SPAN class="string token">'gpx:trkseg'</SPAN><SPAN class="punctuation token">,</SPAN> ns<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ts <SPAN class="operator token">=</SPAN> trkpt<SPAN class="punctuation token">.</SPAN>find<SPAN class="punctuation token">(</SPAN><SPAN class="string token">'gpx:time'</SPAN><SPAN class="punctuation token">,</SPAN> ns<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">.</SPAN>text
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; hd <SPAN class="operator token">=</SPAN> float<SPAN class="punctuation token">(</SPAN>trkpt<SPAN class="punctuation token">.</SPAN>find<SPAN class="punctuation token">(</SPAN><SPAN class="string token">'gpx:hdop'</SPAN><SPAN class="punctuation token">,</SPAN> ns<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">.</SPAN>text<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; sp <SPAN class="operator token">=</SPAN> float<SPAN class="punctuation token">(</SPAN>trkpt<SPAN class="punctuation token">.</SPAN>find<SPAN class="punctuation token">(</SPAN><SPAN class="string token">'gpx:extensions/elf:speed'</SPAN><SPAN class="punctuation token">,</SPAN> ns<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">.</SPAN>text<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; el <SPAN class="operator token">=</SPAN> float<SPAN class="punctuation token">(</SPAN>trkpt<SPAN class="punctuation token">.</SPAN>find<SPAN class="punctuation token">(</SPAN><SPAN class="string token">'gpx:ele'</SPAN><SPAN class="punctuation token">,</SPAN> ns<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">.</SPAN>text<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; be <SPAN class="operator token">=</SPAN> float<SPAN class="punctuation token">(</SPAN>trkpt<SPAN class="punctuation token">.</SPAN>find<SPAN class="punctuation token">(</SPAN><SPAN class="string token">'gpx:extensions/elf:baroEle'</SPAN><SPAN class="punctuation token">,</SPAN> ns<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">.</SPAN>text<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; bp <SPAN class="operator token">=</SPAN> float<SPAN class="punctuation token">(</SPAN>trkpt<SPAN class="punctuation token">.</SPAN>find<SPAN class="punctuation token">(</SPAN><SPAN class="string token">'gpx:extensions/elf:baroPress'</SPAN><SPAN class="punctuation token">,</SPAN> ns<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">.</SPAN>text<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; row <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">(</SPAN>ts<SPAN class="punctuation token">,</SPAN> hd<SPAN class="punctuation token">,</SPAN> sp<SPAN class="punctuation token">,</SPAN> el<SPAN class="punctuation token">,</SPAN> be<SPAN class="punctuation token">,</SPAN> bp<SPAN class="punctuation token">,</SPAN> <SPAN class="punctuation token">(</SPAN>float<SPAN class="punctuation token">(</SPAN>trkpt<SPAN class="punctuation token">.</SPAN>attrib<SPAN class="punctuation token">[</SPAN><SPAN class="string token">'lon'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN> float<SPAN class="punctuation token">(</SPAN>trkpt<SPAN class="punctuation token">.</SPAN>attrib<SPAN class="punctuation token">[</SPAN><SPAN class="string token">'lat'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">print</SPAN> row
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; cursor<SPAN class="punctuation token">.</SPAN>insertRow<SPAN class="punctuation token">(</SPAN>row<SPAN class="punctuation token">)</SPAN>

<SPAN class="comment token">#delete the cursor to finish</SPAN>
<SPAN class="keyword token">del</SPAN> cursor
<SPAN class="keyword token">print</SPAN> <SPAN class="string token">"Done."</SPAN>‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

Here's a sample of the Bad Elf XML used:

<?xml version="1.0" encoding="UTF-8" standalone="no" ?>
<gpx xmlns="http://www.topografix.com/GPX/1/1"
&nbsp;&nbsp;&nbsp;&nbsp; xmlns:gpxx="http://www.garmin.com/xmlschemas/GpxExtensions/v3"
&nbsp;&nbsp;&nbsp;&nbsp; xmlns:gpxtpx="http://www.garmin.com/xmlschemas/TrackPointExtension/v1"
&nbsp;&nbsp;&nbsp;&nbsp; xmlns:badelf="http://bad-elf.com/xmlschemas"
&nbsp;&nbsp;&nbsp;&nbsp; version="1.1"
&nbsp;&nbsp;&nbsp;&nbsp; creator="Bad Elf GPS Pro+ 2.1.44"
&nbsp;&nbsp;&nbsp;&nbsp; xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
&nbsp;&nbsp;&nbsp;&nbsp; xsi:schemaLocation="http://www.topografix.com/GPX/1/1 http://www.topografix.com/GPX/1/1/gpx.xsd http://www.garmin.com/xmlschemas/GpxExtensions/v3 http://www.garmin.com/xmlschemas/GpxExtensionsv3.xsd http://www.garmin.com/xmlschemas/TrackPointExtension/v1 http://www.garmin.com/xmlschemas/TrackPointExtensionv1.xsd http://bad-elf.com/xmlschemas http://bad-elf.com/xmlschemas/GpxExtensionsV1.xsd">
&nbsp; <metadata>
&nbsp;&nbsp;&nbsp; <extensions>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <badelf:modelNickname>Bad Elf GPS Pro+</badelf:modelNickname>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <badelf:modelSerialNumber>007</badelf:modelSerialNumber>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <badelf:modelName>Bad Elf GPS Pro+</badelf:modelName>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <badelf:modelNumber>BE-GPS-2300</badelf:modelNumber>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <badelf:modelHardwareRevision>8.0.0</badelf:modelHardwareRevision>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <badelf:modelFirmwareRevision>2.1.44</badelf:modelFirmwareRevision>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <badelf:elevationSource>gps</badelf:elevationSource>
&nbsp;&nbsp;&nbsp; </extensions>
&nbsp; </metadata>
&nbsp; <wpt lat="1.306545" lon="1.408652">
&nbsp;&nbsp;&nbsp; <ele>95.8</ele>
&nbsp;&nbsp;&nbsp; <time>2017-09-21T02:46:58Z</time>
&nbsp;&nbsp;&nbsp; <name>START (2017-09-21T02:46:58Z)</name>
&nbsp;&nbsp;&nbsp; </wpt>
&nbsp; <trk>
&nbsp;&nbsp;&nbsp; <name>2017-09-21T02:46:58Z</name>
&nbsp;&nbsp;&nbsp; <trkseg>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <trkpt lat="1.306545" lon="1.408652">
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <ele>95.8</ele>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <time>2017-09-21T02:46:58Z</time>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <hdop>1.2</hdop>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <extensions>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <badelf:speed>0.77</badelf:speed>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <badelf:baroEle>74.10</badelf:baroEle>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <badelf:baroPress>1007.31</badelf:baroPress>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </extensions>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </trkpt>
&nbsp;&nbsp;&nbsp; </trkseg>
&nbsp; </trk>
</gpx>‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

Hope this helps.

All comments

RandyBurton

Although these examples work with a file geodatabase, they may give you some ideas.

If the Waze xml uses the GPX format, you could use the GPX To Features tool. I use this script to convert a number of GPX files to features:

<SPAN class="keyword token">import</SPAN> glob<SPAN class="punctuation token">,</SPAN> os
<SPAN class="keyword token">import</SPAN> arcpy
<SPAN class="keyword token">import</SPAN> datetime

gpxPath <SPAN class="operator token">=</SPAN> r<SPAN class="string token">"C:\Path\to\gpx\directory"</SPAN>
gdb <SPAN class="operator token">=</SPAN> r<SPAN class="string token">'C:\Path\to\file.gdb'</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>env<SPAN class="punctuation token">.</SPAN>workspace <SPAN class="operator token">=</SPAN> gdb

os<SPAN class="punctuation token">.</SPAN>chdir<SPAN class="punctuation token">(</SPAN>gpxPath<SPAN class="punctuation token">)</SPAN>
<SPAN class="keyword token">print</SPAN> datetime<SPAN class="punctuation token">.</SPAN>datetime<SPAN class="punctuation token">.</SPAN>now<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN>
<SPAN class="keyword token">for</SPAN> gpx <SPAN class="keyword token">in</SPAN> glob<SPAN class="punctuation token">.</SPAN>glob<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"*.gpx"</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; gpxStr <SPAN class="operator token">=</SPAN> filter<SPAN class="punctuation token">(</SPAN>str<SPAN class="punctuation token">.</SPAN>isdigit<SPAN class="punctuation token">,</SPAN> gpx<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; gpxStr <SPAN class="operator token">=</SPAN> <SPAN class="string token">'GPX_'</SPAN><SPAN class="operator token">+</SPAN>gpxStr<SPAN class="punctuation token">[</SPAN><SPAN class="number token">2</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="number token">8</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="operator token">+</SPAN><SPAN class="string token">'_'</SPAN><SPAN class="operator token">+</SPAN>gpxStr<SPAN class="punctuation token">[</SPAN><SPAN class="number token">8</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="comment token"># my filename included a date/time</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">print</SPAN> gpxStr
&nbsp;&nbsp;&nbsp; 
&nbsp;&nbsp;&nbsp; arcpy<SPAN class="punctuation token">.</SPAN>GPXtoFeatures_conversion<SPAN class="punctuation token">(</SPAN>Input_GPX_File<SPAN class="operator token">=</SPAN>gpxPath<SPAN class="operator token">+</SPAN>gpx<SPAN class="punctuation token">,</SPAN> Output_Feature_class<SPAN class="operator token">=</SPAN>gpxStr<SPAN class="punctuation token">)</SPAN> 
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">for</SPAN> i <SPAN class="keyword token">in</SPAN> range<SPAN class="punctuation token">(</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">,</SPAN>arcpy<SPAN class="punctuation token">.</SPAN>GetMessageCount<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">print</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>GetMessage<SPAN class="punctuation token">(</SPAN>i<SPAN class="punctuation token">)</SPAN>
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

<SPAN class="comment token"># import Bad Elf track from GPX xml file and save as file geodatabase feature</SPAN>

<SPAN class="keyword token">import</SPAN> xml<SPAN class="punctuation token">.</SPAN>etree<SPAN class="punctuation token">.</SPAN>ElementTree <SPAN class="keyword token">as</SPAN> ET
<SPAN class="keyword token">import</SPAN> re
<SPAN class="keyword token">import</SPAN> arcpy
<SPAN class="keyword token">from</SPAN> arcpy <SPAN class="keyword token">import</SPAN> env

<SPAN class="comment token"># geodatabase and environment to use</SPAN>
geoDB <SPAN class="operator token">=</SPAN> r<SPAN class="string token">"C:\Path\To\file.gdb"</SPAN>
env<SPAN class="punctuation token">.</SPAN>workspace <SPAN class="operator token">=</SPAN> geoDB

ns <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">{</SPAN> <SPAN class="string token">'gpx'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token"><SPAN>'</SPAN><A class="jive-link-external-small" href="https://community.esri.com/external-link.jspa?url=http%3A%2F%2Fwww.topografix.com%2FGPX%2F1%2F1" target="_blank">http://www.topografix.com/GPX/1/1</A><SPAN>'</SPAN></SPAN><SPAN class="punctuation token">,</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="string token">'elf'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token"><SPAN>'</SPAN><A class="jive-link-external-small" href="https://community.esri.com/external-link.jspa?url=http%3A%2F%2Fbad-elf.com%2Fxmlschemas" target="_blank">http://bad-elf.com/xmlschemas</A><SPAN>'</SPAN></SPAN> <SPAN class="punctuation token">}</SPAN>
<SPAN class="comment token"># name for feature layer from xml</SPAN>
<SPAN class="keyword token">for</SPAN> trk <SPAN class="keyword token">in</SPAN> tree<SPAN class="punctuation token">.</SPAN>findall<SPAN class="punctuation token">(</SPAN><SPAN class="string token">'gpx:trk'</SPAN><SPAN class="punctuation token">,</SPAN> ns<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; feature <SPAN class="operator token">=</SPAN> trk<SPAN class="punctuation token">.</SPAN>find<SPAN class="punctuation token">(</SPAN><SPAN class="string token">'gpx:name'</SPAN><SPAN class="punctuation token">,</SPAN> ns<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">.</SPAN>text
feature <SPAN class="operator token">=</SPAN> <SPAN class="string token">'BE_'</SPAN><SPAN class="operator token">+</SPAN><SPAN class="string token">' '</SPAN><SPAN class="punctuation token">.</SPAN>join<SPAN class="punctuation token">(</SPAN>re<SPAN class="punctuation token">.</SPAN>sub<SPAN class="punctuation token">(</SPAN><SPAN class="string token">'[^0-9a-zA-Z ]'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">''</SPAN><SPAN class="punctuation token">,</SPAN> feature<SPAN class="punctuation token">.</SPAN>strip<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">.</SPAN>split<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>

<SPAN class="comment token"># create feature</SPAN>
<SPAN class="keyword token">print</SPAN> <SPAN class="string token">"\nCreating feature: "</SPAN> <SPAN class="operator token">+</SPAN> feature
geometry_type <SPAN class="operator token">=</SPAN> <SPAN class="string token">"POINT"</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
tree <SPAN class="operator token">=</SPAN> ET<SPAN class="punctuation token">.</SPAN>parse<SPAN class="punctuation token">(</SPAN>r"C<SPAN class="punctuation token">:</SPAN>\Path\To\bad<SPAN class="operator token">-</SPAN>elf<SPAN class="punctuation token">.</SPAN>gpx'<SPAN class="punctuation token">)</SPAN> <SPAN class="comment token"># xml file</SPAN>

template <SPAN class="operator token">=</SPAN> "<SPAN class="comment token">#"</SPAN>
has_m <SPAN class="operator token">=</SPAN> <SPAN class="string token">"DISABLED"</SPAN>
has_z <SPAN class="operator token">=</SPAN> <SPAN class="string token">"DISABLED"</SPAN>
spatial_reference <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>SpatialReference<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"WGS 1984"</SPAN><SPAN class="punctuation token">)</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>CreateFeatureclass_management<SPAN class="punctuation token">(</SPAN>geoDB<SPAN class="punctuation token">,</SPAN> feature<SPAN class="punctuation token">,</SPAN> geometry_type<SPAN class="punctuation token">,</SPAN> template<SPAN class="punctuation token">,</SPAN> has_m<SPAN class="punctuation token">,</SPAN> has_z<SPAN class="punctuation token">,</SPAN> spatial_reference<SPAN class="punctuation token">)</SPAN>

<SPAN class="comment token"># add fields</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>AddField_management<SPAN class="punctuation token">(</SPAN>feature<SPAN class="punctuation token">,</SPAN><SPAN class="string token">'TimeString'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'TEXT'</SPAN><SPAN class="punctuation token">,</SPAN>'<SPAN class="comment token">#','#','20','Date and Time','Nullable','NON_REQUIRED')</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>AddField_management<SPAN class="punctuation token">(</SPAN>feature<SPAN class="punctuation token">,</SPAN><SPAN class="string token">'HDOP'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'DOUBLE'</SPAN><SPAN class="punctuation token">,</SPAN>'<SPAN class="comment token">#','#','#','HDOP','Nullable','NON_REQUIRED')</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>AddField_management<SPAN class="punctuation token">(</SPAN>feature<SPAN class="punctuation token">,</SPAN><SPAN class="string token">'Speed'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'DOUBLE'</SPAN><SPAN class="punctuation token">,</SPAN>'<SPAN class="comment token">#','#','#','Speed','Nullable','NON_REQUIRED')</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>AddField_management<SPAN class="punctuation token">(</SPAN>feature<SPAN class="punctuation token">,</SPAN><SPAN class="string token">'EleGPS'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'DOUBLE'</SPAN><SPAN class="punctuation token">,</SPAN>'<SPAN class="comment token">#','#','#','GPS Elevation','Nullable','NON_REQUIRED')</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>AddField_management<SPAN class="punctuation token">(</SPAN>feature<SPAN class="punctuation token">,</SPAN><SPAN class="string token">'EleBP'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'DOUBLE'</SPAN><SPAN class="punctuation token">,</SPAN>'<SPAN class="comment token">#','#','#','BP Elevation','Nullable','NON_REQUIRED')</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>AddField_management<SPAN class="punctuation token">(</SPAN>feature<SPAN class="punctuation token">,</SPAN><SPAN class="string token">'BP'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'DOUBLE'</SPAN><SPAN class="punctuation token">,</SPAN>'<SPAN class="comment token">#','#','#','Barometric Pressure','Nullable','NON_REQUIRED')</SPAN>

<SPAN class="comment token"># open an insert cursor</SPAN>
cursor <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>da<SPAN class="punctuation token">.</SPAN>InsertCursor<SPAN class="punctuation token">(</SPAN>feature<SPAN class="punctuation token">,</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="string token">'TimeString'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'HDOP'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'Speed'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'EleGPS'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'EleBP'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'BP'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'SHAPE@XY'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>

<SPAN class="comment token"># read xml and insert into feature</SPAN>
<SPAN class="keyword token">for</SPAN> trkseg <SPAN class="keyword token">in</SPAN> tree<SPAN class="punctuation token">.</SPAN>findall<SPAN class="punctuation token">(</SPAN><SPAN class="string token">'gpx:trk'</SPAN><SPAN class="punctuation token">,</SPAN> ns<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">for</SPAN> trkpt <SPAN class="keyword token">in</SPAN> trkseg<SPAN class="punctuation token">.</SPAN>find<SPAN class="punctuation token">(</SPAN><SPAN class="string token">'gpx:trkseg'</SPAN><SPAN class="punctuation token">,</SPAN> ns<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ts <SPAN class="operator token">=</SPAN> trkpt<SPAN class="punctuation token">.</SPAN>find<SPAN class="punctuation token">(</SPAN><SPAN class="string token">'gpx:time'</SPAN><SPAN class="punctuation token">,</SPAN> ns<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">.</SPAN>text
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; hd <SPAN class="operator token">=</SPAN> float<SPAN class="punctuation token">(</SPAN>trkpt<SPAN class="punctuation token">.</SPAN>find<SPAN class="punctuation token">(</SPAN><SPAN class="string token">'gpx:hdop'</SPAN><SPAN class="punctuation token">,</SPAN> ns<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">.</SPAN>text<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; sp <SPAN class="operator token">=</SPAN> float<SPAN class="punctuation token">(</SPAN>trkpt<SPAN class="punctuation token">.</SPAN>find<SPAN class="punctuation token">(</SPAN><SPAN class="string token">'gpx:extensions/elf:speed'</SPAN><SPAN class="punctuation token">,</SPAN> ns<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">.</SPAN>text<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; el <SPAN class="operator token">=</SPAN> float<SPAN class="punctuation token">(</SPAN>trkpt<SPAN class="punctuation token">.</SPAN>find<SPAN class="punctuation token">(</SPAN><SPAN class="string token">'gpx:ele'</SPAN><SPAN class="punctuation token">,</SPAN> ns<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">.</SPAN>text<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; be <SPAN class="operator token">=</SPAN> float<SPAN class="punctuation token">(</SPAN>trkpt<SPAN class="punctuation token">.</SPAN>find<SPAN class="punctuation token">(</SPAN><SPAN class="string token">'gpx:extensions/elf:baroEle'</SPAN><SPAN class="punctuation token">,</SPAN> ns<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">.</SPAN>text<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; bp <SPAN class="operator token">=</SPAN> float<SPAN class="punctuation token">(</SPAN>trkpt<SPAN class="punctuation token">.</SPAN>find<SPAN class="punctuation token">(</SPAN><SPAN class="string token">'gpx:extensions/elf:baroPress'</SPAN><SPAN class="punctuation token">,</SPAN> ns<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">.</SPAN>text<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; row <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">(</SPAN>ts<SPAN class="punctuation token">,</SPAN> hd<SPAN class="punctuation token">,</SPAN> sp<SPAN class="punctuation token">,</SPAN> el<SPAN class="punctuation token">,</SPAN> be<SPAN class="punctuation token">,</SPAN> bp<SPAN class="punctuation token">,</SPAN> <SPAN class="punctuation token">(</SPAN>float<SPAN class="punctuation token">(</SPAN>trkpt<SPAN class="punctuation token">.</SPAN>attrib<SPAN class="punctuation token">[</SPAN><SPAN class="string token">'lon'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN> float<SPAN class="punctuation token">(</SPAN>trkpt<SPAN class="punctuation token">.</SPAN>attrib<SPAN class="punctuation token">[</SPAN><SPAN class="string token">'lat'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">print</SPAN> row
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; cursor<SPAN class="punctuation token">.</SPAN>insertRow<SPAN class="punctuation token">(</SPAN>row<SPAN class="punctuation token">)</SPAN>

<SPAN class="comment token">#delete the cursor to finish</SPAN>
<SPAN class="keyword token">del</SPAN> cursor
<SPAN class="keyword token">print</SPAN> <SPAN class="string token">"Done."</SPAN>‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

Here's a sample of the Bad Elf XML used:

<?xml version="1.0" encoding="UTF-8" standalone="no" ?>
<gpx xmlns="http://www.topografix.com/GPX/1/1"
&nbsp;&nbsp;&nbsp;&nbsp; xmlns:gpxx="http://www.garmin.com/xmlschemas/GpxExtensions/v3"
&nbsp;&nbsp;&nbsp;&nbsp; xmlns:gpxtpx="http://www.garmin.com/xmlschemas/TrackPointExtension/v1"
&nbsp;&nbsp;&nbsp;&nbsp; xmlns:badelf="http://bad-elf.com/xmlschemas"
&nbsp;&nbsp;&nbsp;&nbsp; version="1.1"
&nbsp;&nbsp;&nbsp;&nbsp; creator="Bad Elf GPS Pro+ 2.1.44"
&nbsp;&nbsp;&nbsp;&nbsp; xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
&nbsp;&nbsp;&nbsp;&nbsp; xsi:schemaLocation="http://www.topografix.com/GPX/1/1 http://www.topografix.com/GPX/1/1/gpx.xsd http://www.garmin.com/xmlschemas/GpxExtensions/v3 http://www.garmin.com/xmlschemas/GpxExtensionsv3.xsd http://www.garmin.com/xmlschemas/TrackPointExtension/v1 http://www.garmin.com/xmlschemas/TrackPointExtensionv1.xsd http://bad-elf.com/xmlschemas http://bad-elf.com/xmlschemas/GpxExtensionsV1.xsd">
&nbsp; <metadata>
&nbsp;&nbsp;&nbsp; <extensions>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <badelf:modelNickname>Bad Elf GPS Pro+</badelf:modelNickname>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <badelf:modelSerialNumber>007</badelf:modelSerialNumber>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <badelf:modelName>Bad Elf GPS Pro+</badelf:modelName>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <badelf:modelNumber>BE-GPS-2300</badelf:modelNumber>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <badelf:modelHardwareRevision>8.0.0</badelf:modelHardwareRevision>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <badelf:modelFirmwareRevision>2.1.44</badelf:modelFirmwareRevision>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <badelf:elevationSource>gps</badelf:elevationSource>
&nbsp;&nbsp;&nbsp; </extensions>
&nbsp; </metadata>
&nbsp; <wpt lat="1.306545" lon="1.408652">
&nbsp;&nbsp;&nbsp; <ele>95.8</ele>
&nbsp;&nbsp;&nbsp; <time>2017-09-21T02:46:58Z</time>
&nbsp;&nbsp;&nbsp; <name>START (2017-09-21T02:46:58Z)</name>
&nbsp;&nbsp;&nbsp; </wpt>
&nbsp; <trk>
&nbsp;&nbsp;&nbsp; <name>2017-09-21T02:46:58Z</name>
&nbsp;&nbsp;&nbsp; <trkseg>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <trkpt lat="1.306545" lon="1.408652">
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <ele>95.8</ele>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <time>2017-09-21T02:46:58Z</time>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <hdop>1.2</hdop>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <extensions>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <badelf:speed>0.77</badelf:speed>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <badelf:baroEle>74.10</badelf:baroEle>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <badelf:baroPress>1007.31</badelf:baroPress>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </extensions>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </trkpt>
&nbsp;&nbsp;&nbsp; </trkseg>
&nbsp; </trk>
</gpx>‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

Hope this helps.

JamesMacKay3

If you're planning on putting the XML into a feature class you should use geoprocessing tools like Create Feature Class and Add Field, then insert records using the arcpy.da.InsertCursor class. If you create your schema through an ODBC connection it won't be a proper feature class as it won't be in the GDB system tables.

(Edit: Even if your schema already exists you should still be using the InsertCursor to create records rather than through pyODBC - you can easily insert shapes with an insert cursor, I imagine it's possible using pyODBC but I'm sure it's a lot more difficult, and there are other factors to consider like spatial indexes.)

DavidDenham

I want to automate the import of the XML file into a personal geodatabase so that I can generate a feature class from the XML file. So I would appreciate any advise, but the connection is where I am getting stuck now. I have not been able to find any on how to handle to connection when importing a XML file.

RandyBurton

Do you have python code to read the XML, or are you just interested in the ODBC connection portion?

DavidDenham

Unfortunately we do not have a license for the Data Interoperability extension and I do not think that we can justify that for a single project. I am under the impression that the data belongs to Waze I do not believe that I can share it with the public. I will try to tell you what I can. This file is xml version 1.0 and it is from the Waze GeoRSS feed. When I import the data using the import xml file in Access it generates 2 table 1 called "channel" that contains information on the area covered by the data and another called "item" with contains the incident data with 15 text fields. Let me know if there is some other information that would help.

bharold

David, this is the sort of workflow Data Interoperability extension can tackle. If that is an option for you and you can share some XML we can advise more.

Rejoindre la conversation

Les membres connectés peuvent publier, suivre les mises à jour, et plus encore. Nouveau ici ? Inscrivez-vous gratuitement.

Liens rapides

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.