Viewing JSON/XML Data

Status
Not open for further replies.

KI5IRE

Member
Premium Subscriber
Joined
Jun 28, 2016
Messages
412
Location
Oklahoma City, OK
I am trying to figure out how to turn a JSON/XML link into a data/map format for easier viewing.

The Tulsa Fire Department publishes their active calls on their OpenData portal in JSON/XML format, but does not have an actual viewer that they made, just the raw data.

I am trying to create a simple viewer that would be in a format of a data table and/or a map of the data that would update automatically, similar to the one that the San Antonio Fire Department uses here: Active SAFD Calls. How do I do this? I have no idea honestly how JSON or XML works or of what I am trying to do is even possible.

Here is the JSON link: https://www.cityoftulsa.org/apps/opendata/tfd_dispatch.jsn

Here is the XML link: https://www.cityoftulsa.org/apps/opendata/tfd_dispatch.xml
 

ShawnInPaso

Member
Premium Subscriber
Joined
Sep 28, 2008
Messages
398
Well for starters you can import either XML or JSON into MS-Excel. I downloaded the xml data from the link you provided, takes just a moment to have it displayed. Excel can also grab the data automatically online every xx minutes, basically building a huge file after a period of time.

EDIT to add: if you really get into it, excel makes it easy to make the lat/long into a clickable link that shows the location on google maps.

How to Import XML to Excel
  1. Step 1) Create a new workbook in Excel. Open a new workbook. Click on the DATA tab on the ribbon bar. ...
  2. Step 2) Select the XML as Data source. Then click on “From XML Data Import”
  3. Step 3) Locate and select the XML file. Now select the XML File to Excel sheet.
MS-Access (a database program) can do the same thing which provides stronger manipulation and reportinging of the data.

Sure wish our local FD produced data like this.
XML.jpg
 
Status
Not open for further replies.
Top