Employer Trip Reduction Profile Database

This Employer Trip Reduction Profile Database will allow you to see what types of incentives were offered to yield a particular change in Average Vehicle Ridership (AVR). AVR is the ratio of all employees affected by the trip reduction regulation to the number of vehicles carrying those employees.   In other words, employees who bike, walk and use transit appear in the numerator.

You will be shown a summary of one or more of the nearly 7,000 employer trip reduction plans obtained from Los Angeles, Phoenix and Tucson.  For confidentiality purposes, there are no identifiers as to the name or location of the given employer recorded in the database.  The changes reported were obtained from employers who filed at least two consecutive trip reduction plans over a several year period. 

You will be able to view each record that meet your criteria. The output will be sorted from largest change in AVR to smallest change that meet your criteria.  The total number of plans that meet your criteria will be shown below the first record as [1/####] where #### represents the total number of plans that meet you criteria.

If you would like to estimate the impact of your trip reduction program, please download CUTR_AVR trip reduction model. This model was developed under contract to the Florida Department of Transportation Research Center to estimate the impact of employer trip reduction programs based on actual employer experiences.

 

Enter the starting level of Average Vehicle Ridership (AVR). The system will retrieve all employers that have that AVR or greater for you to view the details. (i.e., By entering, "1.25" in the box to the right, you are telling the system that "I want to see all employer records that have a starting AVR of 1.25 or higher." " size="5">
Enter the minimum amount of change in AVR for which you would like to view the above employer profiles. The system will retrieve all employers that have the above AVR and the minimum change in AVR that you enter in the box to the right. (i.e., "I want to view only those employers with a starting AVR of at least 1.25 that have increased their AVR by 0.30 (from 1.25 to 1.55 or more).") " size="5">

 

<% fp_sQry="SELECT Format(COMBO.AVR,'#0.00') AS shortAVR, Format(COMBO.AVRCHG,'#0.##') AS shortAVRCHG, Format(COMBO.TOTSITE,'#,##0') AS empTOTSITE, Format(COMBO.PCT610*100,'##0.0') AS pctPCT610, CI05,CI06,I38,CI08,CI09,I53,CI03,CI02,I57,I3,I45,I46,I4,I5,I1,I2,I60,I58,I59,I39,I40,I41,I43,I44,I42,I54,I55,I56,CI04, Format(COMBO.CARPCT1*100,'##0.0') AS pctCARPCT1, Format(COMBO.CArPCT2*100,'##0.0') AS pctCArPCT2, Format(COMBO.CARPCT3*100,'##0.0') AS pctCARPCT3, Format(COMBO.CARPCT4*100,'##0.0') AS pctCARPCT4, Format(COMBO.CARPCT5*100,'##0.0') AS pctCARPCT5, Format(COMBO.CARPCT6*100,'##0.0') AS pctCARPCT6, Format(COMBO.TRANSPCT*100,'##0.0') AS pctTRANSPCT, Format(COMBO.BIKEPCT*100,'##0.0') AS pctBIKEPCT, Format(COMBO.WALKPCT*100,'##0.0') AS pctWALKPCT, Format(COMBO.IMP01*100,'##0.0') AS pctIMP01, Format(COMBO.IMP02*100,'##0.0') AS pctIMP02, Format(COMBO.IMP03*100,'##0.0') AS pctIMP03, Format(COMBO.IMP04*100,'##0.0') AS pctIMP04, Format(COMBO.IMP05*100,'##0.0') AS pctIMP05 FROM COMBO WHERE (AVR >= ::AVR:: AND AVRCHG >= ::AVRCHG:: AND CI02 = ::CI02:: AND CI03 = ::CI03:: AND CI04 >= ::CI04::) ORDER BY AVRCHG DESC,AVR ASC" fp_sDefault="AVR=1&AVRCHG=0&CI02=0&CI03=0&CI04=0" fp_sNoRecords="No records returned." fp_sDataConn="combo.mdb" fp_iMaxRecords=256 fp_iCommandType=1 fp_iPageSize=1 fp_fTableFormat=False fp_fMenuFormat=False fp_sMenuChoice="shortAVR" fp_sMenuValue="shortAVR" fp_iDisplayCols=47 fp_fCustomQuery=True BOTID=0 fp_iRegion=BOTID %>
Starting Average Vehicle Ridership (AVR): <%=FP_FieldVal(fp_rs,"shortAVR")%>
Minimum Change in AVR: <%=FP_FieldVal(fp_rs,"shortAVRCHG")%>
Total Number of Employees on Site: <%=FP_FieldVal(fp_rs,"empTOTSITE")%>

Percent of Work Force Reporting to Work Between 6 a.m. and 10 a.m.:
 <%=FP_FieldVal(fp_rs,"pctPCT610")%>

MODE SPLIT: 

Drive Alone: <%=FP_FieldVal(fp_rs,"pctCARPCT1")%>
2-Person Carpool: <%=FP_FieldVal(fp_rs,"pctCArPCT2")%>
3-Person Carpool: <%=FP_FieldVal(fp_rs,"pctCARPCT3")%>
4-Person Carpool: <%=FP_FieldVal(fp_rs,"pctCARPCT4")%>
5-Person Carpool: <%=FP_FieldVal(fp_rs,"pctCARPCT5")%>
6+ Person Carpool: <%=FP_FieldVal(fp_rs,"pctCARPCT6")%>
Transit: <%=FP_FieldVal(fp_rs,"pctTRANSPCT")%>
Bike: <%=FP_FieldVal(fp_rs,"pctBIKEPCT")%>
Walk: <%=FP_FieldVal(fp_rs,"pctWALKPCT")%>

IMP01: <%=FP_FieldVal(fp_rs,"pctIMP01")%>
IMP02:
 <%=FP_FieldVal(fp_rs,"pctIMP02")%>
IMP03:
 <%=FP_FieldVal(fp_rs,"pctIMP03")%>
IMP04:
 <%=FP_FieldVal(fp_rs,"pctIMP04")%>
IMP05:
 <%=FP_FieldVal(fp_rs,"pctIMP05")%>

Type of Incentive Incentive Present
Rideshare Matching (n=3,644) <%=FP_FieldVal(fp_rs,"CI05")%>
Alternative Mode Subsidies (n=3,227) <%=FP_FieldVal(fp_rs,"CI06")%>
Walk to Work Subsidies (n=454) <%=FP_FieldVal(fp_rs,"I38")%>
Telecommuting (n=1,058) <%=FP_FieldVal(fp_rs,"CI08")%>
Compressed Work Week (n=1,769) <%=FP_FieldVal(fp_rs,"CI09")%>
Other Compressed Work Week (n=675) <%=FP_FieldVal(fp_rs,"I53")%>
Flexible Work Arrangements (n=1,914) <%=FP_FieldVal(fp_rs,"CI03")%>
Guaranteed Ride Home (n=3,486) <%=FP_FieldVal(fp_rs,"CI02")%>
Company Vanpools (n=98) <%=FP_FieldVal(fp_rs,"I57")%>
Preferential Parking (n=2,721) <%=FP_FieldVal(fp_rs,"I3")%>
Higher Parking Costs for SOV (n=76) <%=FP_FieldVal(fp_rs,"I45")%>
Other Parking Strategies (n=116) <%=FP_FieldVal(fp_rs,"I46")%>
Bike Racks and Lockers (n=2,620) <%=FP_FieldVal(fp_rs,"I4")%>
Showers and Clothing Lockers (n=1,554) <%=FP_FieldVal(fp_rs,"I5")%>
Facility Improvements (n=33) <%=FP_FieldVal(fp_rs,"I1")%>
Other Facility Improvements (n=117) <%=FP_FieldVal(fp_rs,"I2")%>
Cafeteria, ATMs, Post-Office, etc. On-Site (n=1,019) <%=FP_FieldVal(fp_rs,"I60")%>
Child Care Service (n=597) <%=FP_FieldVal(fp_rs,"I58")%>
Other On-Site Services (n=920) <%=FP_FieldVal(fp_rs,"I59")%>
Auto Services (n=221) <%=FP_FieldVal(fp_rs,"I39")%>
Gift Certificates (n=304) <%=FP_FieldVal(fp_rs,"I40")%>
Free Meals (n=771) <%=FP_FieldVal(fp_rs,"I41")%>
Catalog Points (n=354) <%=FP_FieldVal(fp_rs,"I43")%>
Additional Time Off with Pay (n=153) <%=FP_FieldVal(fp_rs,"I44")%>
Other Non-Financial Incentives (n=127) <%=FP_FieldVal(fp_rs,"I42")%>
Other Services (n=2,655) <%=FP_FieldVal(fp_rs,"I54")%>
Prize Drawings (0) <%=FP_FieldVal(fp_rs,"I55")%>
Service (unspecified) (n=320) <%=FP_FieldVal(fp_rs,"I56")%>
Marketing  and Promotion (n=4,459)

<%=FP_FieldVal(fp_rs,"CI04")%>

# of Marketing Tactics # of Employers with that # of Tactics
0 2521
1 1073
2 850
3 699
4 586
5 386
6 300
7 170
8 92
9 66
10 61
11+ 176