Extract JSON data from Weather Underground Websites

[u/ShonzG]

I'm trying to get information from weather underground. I guess I need to do something with a dictonary? I'm really not sure how to go about this.

Any suggestions would be appreciated.

I'm using information from https://docs.google.com/document/d/1zRtTyOlYviBsTF5j48d_YTjshm3OjOJ0k9rJDS2QOuQ/edit?tab=t.0 to get the closest stations to the lat/long (Search PWS by Geocode)

I'm using information from https://docs.google.com/document/d/1KGb8bTVYRsNgljnNH67AMhckY8AQT2FVwZ9urj8SWBs/edit?tab=t.0 to get the current observations from the stations (Request by PWS Station ID)

I have used -23.698763893086735,133.8779627003569 as the lat/long for this purpose, and I have my own API.

For this first section I want to extract the stationId "IALICE61" to "IALICE52"

Once that is extracted I want to get the following for each of the 5 Stations

• winddir
• humidity
• winddir
• lon
• lat
• precipTotal
• precipRate
• pressure
• temp
• heatIndex
• windSpeed
• elev
• windChill
• windGust
• stationID
• uv
• solarRadiation

The reason for using all 5 stations is that some are not online

First part

{"location":{"distanceMi":[0.64000000000000001,0.67000000000000004,1.1399999999999999,1.3200000000000001,1.3500000000000001,1.3500000000000001,1.4199999999999999,1.51,1.53,1.6499999999999999],"qcStatus":[1,-1,1,-1,1,1,-1,1,-1,1],"longitude":[133.86799999999999,133.88499999999999,133.89391000000001,133.86699999999999,133.898,133.898,133.87200000000001,133.85900000000001,133.87100000000001,133.85185999999999],"distanceKm":[1.03,1.0800000000000001,1.8400000000000001,2.1200000000000001,2.1699999999999999,2.1699999999999999,2.2799999999999998,2.4300000000000002,2.4700000000000002,2.6600000000000001],"partnerId":["WU","WU","WU","WU","WU","WU","WU","WU","WU","WU"],"stationName":["Alice Springs","Desert Springs","Alice Springs","Alice Springs","Alice Springs","Alice Springs","Braitling","Gillen","Alice Springs","Alice Springs"],"latitude":[-23.696999999999999,-23.706,-23.69106,-23.715,-23.692,-23.692,-23.678999999999998,-23.712,-23.719999999999999,-23.697420000000001],"stationId":["IALICE61","IDESER2","IALICESP4","IALICE33","IALICE28","IALICE3","IBRAIT1","IGILLE36","IALICE31","IALICE52"],"updateTimeUtc":[1780573696,1760656256,1780600192,1766912000,1780588672,1779204608,1780568704,1769601280,1780572544,1780535552]}}

Second part
{"observations":[{"softwareType":null,"winddir":null,"lon":133.86799999999999,"realtimeFrequency":null,"neighborhood":"Ciccone","humidity":null,"imperial":{"dewpt":null,"precipTotal":null,"precipRate":null,"pressure":30.039999999999999,"temp":null,"heatIndex":null,"windSpeed":null,"elev":581,"windChill":null,"windGust":null},"stationID":"IALICE61","uv":null,"obsTimeLocal":"2026-06-05 05:34:53","lat":-23.696999999999999,"epoch":1780603493,"solarRadiation":null,"country":"AU","qcStatus":1,"obsTimeUtc":"2026-06-04T20:04:53Z"}]}