We're glad you want to work with the open data files available in our data catalogue. This page has a few tips and tricks to use. Of course, we aren't officially endorsing anything you find here as the "tool of choice" or "best tool", etc. We're simply trying to offer some workarounds and insight on how to get into and use our data! For now, we have these tips showing in a carousel format. As we provide more items, we'll change that up.
Let's use our community and crowd source this assistance page to the max!
If you spot something confusing in an explanation or have another tool that can do work arounds, or have a work around ... let us know!!!
We want to make this page as useful and current as we possibly can for users ... you! We hope to add video tutorials and more as we morph this into something special for users.
Contact us with edits, new details, new tools, workarounds and suggestions at: firstname.lastname@example.org
Here's a link that will give you SEVEN potential JSON viewing tools:
But, wew've had some good luck with this one in particular:
Here are the steps that worked for us:
1) Load your data or find the JSON data set of your choice. We did a simple copy and paste
2) Click the formatting button at the top left side of the page, which reads: "Format JSON data with proper indentation and line feeds"
3) Click the button pointing to the right, in order to "copy code to tree editor"
and be amazed at the data which turns into something more tangible in front of you!
XML and XLS files are compatible, but unique.
To convert xml (which is more of a programming language sort of file type) to excel (everybody's favourite spreadsheet generator):
1) Save the xml file to your desktop (right click & save-as)
2) Open a fresh/blank excel doc
3) Click the data tab at the top of the page
4) Click the "From other sources" button along that menu bar
5) Click "From xml data import"
(NOTE: a box will pop open prompting you to pick your data source when you click xml data import!)
6) Navigate to your desktop "folder" & select the xml file you saved to your desktop back in step 1
7) It should open in excel (just click OK to whatever random pop up boxes or prompts appear after you select your xml file)
1) Open a new/blank excel file
2) Find and CLICK the Microsoft office button (in the very top left corner of excel)
3) From the drop-down menu that appears, select "Open"
4) A dialogue box will pop up, and from there select "Text Files" (*.prn,*.txt,*.csv) from the drop-down list in the lower right-hand corner
5) Find the file you're looking for and double click
If you are opening a .csv file, Excel will open it in a new workbook right away.
If you are opening a text (.txt) file, the Import Text Wizard will start running in Excel
Permit Parking Questions:
If you have questions about Permit Parking (related to the availability of permit parking, or the specific locations or maps for permit parking zones), please contact the Permit Parking unit, who work for Transportation Services.
You can reach Permit Parking by email at email@example.com
Temporary Permit Parking Staff may be reached by phone at 416-392-7873 from Monday to Friday between 8:30am and 4:15pm.
Building Permit Questions:
If you have questions about a Building Permit, your best bet is to contact the Toronto Building Office directly.
The best first point of contact is by phone. Toronto Building Staff can be reached directly at 416-397-5330 from Monday to Friday between 8:30am and 4:30pm.
The phone number above is for their general customer service staff, which is the fastest way to get pointed in the right direction. Toronto Building customer service staff may forward you to another department or recommend another number to call.