StreetLight InSight® Support Center

How To Guide: Make an Origin-Destination Matrix in StreetLight InSight

This tutorial will show you how to easily create an Origin-Destination (O-D) Matrix using StreetLight InSight.

For this tutorial, we’re going to create an O-D Matrix for all the ZIP Codes in Madison, WI. We want a traditional “full” matrix, where the origin Zones are the same as the destination Zones, and we’re looking at the true origin and destination of each trip - that is, where the trip actually starts and actually ends.

However, you can use the flow described here to create O-D Matrices where the origin and destination Zones are different from each other, and where the origin and destination Zones are road segments.

streetlight insight supportThis tutorial contains supporting files. Please click here to download them.

Step 1: Designate Your Zones

1a. Go to the Manage Travel Projects section by clicking the tab on the left. Then click “Add Zone Set.”

Most O-D projects rely on pre-existing geographies. Get a shapefile of your geographies and ZIP them into a compressed folder. Click here to download a demo shapefile of all the ZIP Codes in Madison, which is in the supporting files for this tutorial.

You can use any type of geography in any SRID. Of course, if you’d like to draw your Zones, click “Draw New Zone” instead of uploading a shapefile. To follow along on this tutorial, click “Upload Shapefile” and select your shapefile from the browser.

Once you click “Open,” you will see a module that allows you to match the fields in your shapefile to StreetLight InSight’s fields. Because we are creating an Origin-Destination Matrix that analyzes Area Zones, remember to set the “Pass Through” option to “Always No.” (“Pass through” Zones usually designate road segments. For this Matrix, we’re interested in trips that start and end in Area Zones, not trips that pass through them.)

Once you press “continue” you’ll have a final chance to edit the names or borders of any Zones. To do so, click on the edit pencil icon next to the Zone before you save the Zone Set.

Now you can see your Zone Set saved in your Zone Set library. As long as you haven’t used it yet in a project, you can edit it by clicking the edit icon in the Actions column. You can also view it, duplicate it, download it as a shapefile, and more.

Step 2: Create and Run an Origin-Destination Project

2a. Go to the Create Projects tab and create a project.

Name the project “Madison Summer 2016 O-D.” Since this a tutorial, use the “Select a Project Tag” dropdown to select “Demo/Sample.” In the “Select a Project Type” dropdown, select O-D Analysis. You can type a description of the project in the description box with any information you want to remember.

2b. All Zone Sets that have been created in your account appear in the “Available Zone Sets” box. Select “madison_zips,” then use the arrow buttons to add it to the Origin Zone Set box and the Destination Zone Set box. Since this is a classic O-D Matrix, we will use the same Zone Set for both origins and destinations. However, you can also use different Zone Sets for each, and add multiple Zone Sets to each category.

2c. For this O-D project, you only want to know about Summer of 2016. So in the Project Options box, click “Edit” under Data Period.

This opens up a module that allows you to select which months to analyze. There are many other customizable options, which you can select if needed. For this tutorial, select May, June, and July 2016. Then click “Save.”

2d. Click “confirm” and you’re off and running!

Step 3: View Results in StreetLight InSight

Projects will take anywhere from a few seconds to a few hours to run, depending on their size and complexity. This tutorial Project should take less than 3 minutes to run, but it will depend on the number of Projects currently being processed in our system. You can check on the progress of your project by looking in the “Running Projects” Tab. Once the Project is complete, it will show up in the “All Projects” tab.

3a. Click on the “Visualize Travel Projects” section (the icon is a graph on the left-hand side of the app). Then select your Project in the “Select a Project” box by clicking Madison Summer 2016 O-D. You can visualize the top destination for any origin by clicking an Origin Zone, for example, ZIP code 53562 (see image below). If you want to include trips internal to the Origin Zones, check the “Include Origin = Destination” box.

You can click on any Zone to see the key data. StreetLight presents O-D results in two ways – as a percentage and as a StreetLight Trip Index. For example, if you click on ZIP code 53579, the info box tells you that 5.7% of trips that originate in 53562 end up in 53579. The StreetLight Trip Index is a number does not represent number of trips or vehicles. Rather, the values represent the relative amount of trips and are consistent for all projects by vehicle type within the StreetLight InSight app (personal and commercial Indices can’t be combined or compared).

3b. See how behavior varies by time of day by clicking on the clock icon in the Visualization Options Module. Rotate through different types of day by clicking the day parts.

Step 4: Download Metrics

4a. To download the Metrics and make your own analyses in Microsoft Excel, navigate to the Manage Projects section. Then click the “All Projects” tab. Each of your completed projects should be visible. Click on the “Download” icon in the Actions Column.

4b. Select which files you want to download. For O-D projects, the critical download is the O-D csv. You can choose the other options as you see fit. Click here to download the file selected below, which is named “Madison OD Personal Example Analysis” and is contained in the Supporting Files for this tutorial.

4c. Open the folder you’ve downloaded to view the csv and shapefiles you selected. You can manipulate these csv files as you like. You will also have two helpful README files. This table, contained in “Madison OD Personal Example Analysis” shows the most popular pairs of origins and destinations.

You can use the index to create percentages.

Don't See Your Question Answered Here?

Contact Us

Want the Latest StreetLight Data News?