StreetLight InSight® Support Center

How To Guide: Create An Internal/External (IIEE) Analysis With StreetLight InSight

This tutorial will show you how to easily create an Internal/External (IIEE) analysis using StreetLight InSight. This type of analysis allows you to calculate the share of trips which touch a Zone that are fully internal (II), fully external (EE), inbound (EI) or outbound (IE).

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

Step 1: Create Your Zone Sets

(If you want to skip this part, you can upload the “Maryland IIEE Zone” shapefile provided in the Supporting Documents.)

1a. You can create your first Zone Set one of two ways; by uploading the shapefile or by drawing the Zones. No matter how you choose to create your Zones, you will ultimately want two versions of every Zone.

This means you will have two different Zone Sets with identical geographies, but different designations. In one Zone Set, all of your Zones will be designated as "pass-through" Zones. In the other Zone Set, they will not be desginated as "pass-through" Zones.

1b. First, to create the Zones that are not marked “Zone is Pass Through,” upload a shapefile. When mapping the fields in your shapefile to StreetLight InSight, choose “Always No” under “Zone is Pass Through.” Click continue.

1c. Copy each Zone in that Zone Set using the "Double Paper" icon.

1d. Then, edit the copied Zone by clicking the pencil icon.

1e. Edit the name suffix from “nonPT – Copy” to “PT”. These suffixes are important for the pivot table in the spreadsheet, which we will go through later on this tutorial.

1f. Check the box to mark the Zone as a “yes” pass through.

1g. After the completing these steps, you should have two Zone Sets: one pass-through Zone Set, and one that is not pass-through.

Step 2: Set Up the IIEE as an ”Origin-Destination Analysis" Project

2a. Go to the Create Projects tab and create a Project named “Maryland IIEE Project.” Tag it appropriately. (For practice, use the “Test – Internal Use Only” tag). Then designate its Project Type as “O-D Analysis.”

2b. Under Available Zone Set, click “Maryland IIEE Zone” Zone Set to highlight it. Then, click the right arrow to assign it as Origin Zone Set and also Destination Zone Set. If necessary, adjust the day part, data period, and other parameters under the "Project Options" tab.

2c. Click “Confirm” and you’re off and running!

Step 3: View Results in StreetLight InSight

3a. Once your project is complete, download the Metrics to complete your IIEE analyses using Microsoft Excel. To download your Metrics, go 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.

3b. Select which files you want to download. For IIEE, you must select the “O-D Metrics CSVs.” The other downloads are optional. Click “Download” and a ZIP file will begin downloading.

3c. Open the folder and the CSVs and shapefiles you selected will be there. You will also have a README and Project files.

3b. Manipulate these CSV files to calculate the relative volume of Internal and External Trips in each Zone. To do this, follow the example in this Tutorial’s Supporting Files Excel file, which is named “Maryland_IIEE_Project_od_personal_EXAMPLE ANALYSIS.”

3c. Use a pivot table to make useful charts and graphs, like the one below.

If you need to scale to absolute counts instead of StreetLight Index or percentages, contact and we’ll show you how.

Don't See Your Question Answered Here?

Contact Us

Want the Latest StreetLight Data News?