I am attempting to create a feature class off of some Minnesota Department of Transportation XML feeds. The first XML feed displays current incidents on roadways and provides all information about the incident as attributes in a single XML tag:
[INDENT]<active_incidents time_stamp="Tue May 17 10:09:07 CDT 2011">
I am having some trouble deciding what the most efficient workflow would be to parse this XML feed into a feature class off of which a service could be generated. The XML file (http://www.dot.state.mn.us/tmc/trafficinfo/incidents.xml) is updated every 30 seconds, and I would like the service to be as closely in synch with the xml file as possible.
I would appreciate any input on the most efficient way to continuously update (delete old records, insert new) a feature class and the best method for parsing this XML file.
I used the standard module ElementTree to parse XML for a GPX file as hinted by a Python demo at the conference. This is much easier than some of the older parsers such as SAX or DOM.