Extract Features from a XML online document

Question

An Italian meteorological agency publishes this XML file (https://www.ambienteveneto.it/Dati/UltimaOra.xml) containing meteorological data, which updates every hour. The XML has a tag, followed by an ID (), a name (), and and tags containing the geographic coordinates of the gauge. Each Weather station can have multiple sensor (tag ), for each sensor the XML file records several values depending on the (frequency in minute) value. Each value () is linked to a date and time value . Is there a way to extract these data and use them in ArcGIS Online? I tried with Pipelines but this kind data is not compatible with the URL format types. Thanks in advance for any help!

RobertoRossi · Answer

Thank you @MobiusSnake

I'm not experienced with Python and Notebook, but @FrancescoFanelli , gave me some help with the code, so now I've to understand how to use ArcGIS Online Notebook and implement it.

If it works I will share here and mark as solution.

MobiusSnake · Answer

I would probably use an ArcGIS Online notebook, write some Python that parses the XML and creates point features in a hosted feature layer.  Depending on your requirements, you could either append records from each run (maintaining historical data), or delete all previous records in the layer so you just have the latest information.

Parsing XML is a pretty standard workflow for Python (nothing GIS-specific about it), for creating features in a feature layer there are several options but I'd recommend the edit_features method of the FeatureLayer class in the ArcGIS API for Python.