transportation operations group 1 paso del norte regional mobility information system challenges and...
TRANSCRIPT
Transportation Operations Group
1
Paso Del Norte Regional Mobility Information System Challenges and Opportunities
Center for International Intelligent Transportation Research
TBWG Data WorkshopDetroit, MichiganJune 4, 2008
Rajat Rajbhandari Texas Transportation InstituteEl Paso, Texas
2
Agenda
Defining Goals and Objectives of the System
Developing Framework for the System
Designing and Implementing the System
Challenges and Opportunities
Creating a Sustainable System
Future of PDN Regional Mobility Information System
Video Demonstration of PDN RMIS Website
3
Defining Goals and Objectives of the SystemAnnual Traffic Delay in the El Paso Area
0
1000
2000
3000
4000
5000
6000
7000
8000
1982 1984 1986 1988 1990 1992 1994 1996 1998 2000 2002
Annu
al D
elay
(per
son-
hour
s in
thou
sand
s)
Traffic Congestion
Annual Volume of Trucks Entering into United States from mexico through POEs in El Paso Only
0
200
400
600
800
1000
1994 1995 1996 1997 1998 1999 2000 2001 2002 2003 2004
Truc
ks (i
n Th
ousa
nds)
All POEs in El Paso
BOTA Only
Border Congestion
4
Defining Goals and Objectives of the System
Raising awareness of the need for data collection planning
Increasing amount of transportation data being collected
Increasing quality of transportation data being collected
Increasing recognition of the value of data
Encouraging similar efforts in other areas of transportation
Adopted From: Closing the Data Gap: Guidelines for Quality Advanced Traveler Information System (ATIS) Data Version 1.0, ITS America and U.S. Department of Transportation, September 2000.
Creating a centralized transportation data archive
and
Providing advanced traveler information
5
Defining Objectives of the System
Provide a common medium to store and relay multi-modal transportation data
ADVANCED TRAVELER INFORMATION
Incident Information
Roadway Conditions
Border Crossing Information
Weather Alerts
ARCHIVED TRANSPORTATION DATA
Long and Short Range Planning
Model Calibration
Performance Monitoring
6
Defining Objectives of the System
Vehicle Sensors
TransVista
El Paso MPO
Sun Metro (Bus Dispatch, Kiosks)
City of El Paso/PD/FD
Local Media, Traveling Public,
Commercial Vehicle Operators
Customs and Border Protection
Motorist Information
TxDOT Design and Planning
Border Wait Times
Incidents
IMIPBorder Crossing
Images
NOAAWeather
Dynamic Message Signs
Highway Advisory Radio
CCTV
Internet
Internet
Internet
Internet
Internet
Number of Lanes OpenPDN Regional
Mobility Information
System
Aggregated Traffic Data
Aggregated Traffic Data
Transit Location Transit Ridership
Traveler Information
Internet
7
Developing Framework of the System
Outlining “vision” to determine data needs and priorities
Determining and defining the region (boundaries) and roadways
Identifying data types produced by stakeholders
Considering local factors regarding traffic and border crossing needs
Estimating procurement costs and synchronizing strategies with funding profile
Adopted From: Closing the Data Gap: Guidelines for Quality Advanced Traveler Information System (ATIS) Data Version 1.0, ITS America and U.S. Department of Transportation, September 2000.
8
Developing Framework of the System
Weather Incidents
TrafficSpeed CBP Inspection
Lanes OpenRFID Border
Crossing Time
Travel Time HAZMAT
Information
CameraSnapshots
Archived InformationArchived Information
Planners, Engineers, Researchers
Motorists, Freight Carriers and Shippers
Real-Time InformationReal-Time Information
Extract Traffic and Border Crossing Data fromDiverse Data Sources
Extract Traffic and Border Crossing Data fromDiverse Data Sources
CBP Border Crossing Delay
TIER 1DATA EXTRACTION
TIER 2 DATA FUSION
TIER 3 DATA DISSEMINATION
9
Designing and Implementing the System
Identifying the overall needs and purpose of mobility information system
Identifying stakeholders in the region
Identifying desired outcomes from the system according to stakeholder needs
Identifying sources and types of data availability
Defining and designing conceptual operation of the system
Phase I – 2006 Scoping and Needs
Phase I –2006Scoping and Needs
Phase I –2006Scoping and Needs
Phase II – 2007Design and Build
Phase II – 2007Design and Build
Phase III – 2008O & M and Expansion
Phase III – 2008O & M and Expansion
10
Designing and Implementing the System
Establishing a systems architecture (3-tier architecture)
Defining interfaces between data sources and the system
Developing functional requirements of the system
Defining processes for data extraction, fusion and dissemination
Procuring of software and hardware
Phase II – 2007 Design and Build
Phase II – 2007Design and Build
Phase II – 2007Design and Build
Phase I – 2006Scoping and Needs
Phase I – 2006Scoping and Needs Phase III – 2008
O & M and Expansion
Phase III – 2008O & M and Expansion
11
Designing and Implementing the System
Data Extraction Data Fusion Data Dissemination
Data Extraction Process
Data Filter and Aggregation
Extraction
Filter
Data Storage Data Delivery
SQL Reporting Service
Data Use
Web-Based User Interface
Aggregation
Cross Border Wait
Time
Convert to XML Data Format
Microwave Vehicle Sensors
Internet
Internet
Internet
Border Crossing Images
Internet
Internet
Extract IMIP Border Images
Extract Raw Vehicle Detector
Data
Extract Hourly Weather Data from NOAA
Extract Incident Data from EP
Extract Border Wait Times and
Lanes Open from CBP
HS Threat Level
AdvisoryInternet
Extract Homeland Security Threat Level Advisory
Aggregated Traffic Data
Hourly Weather
DataHourly
Incident Data
Stored Procedures
SQL Server Agents
SSIS Packages
Phase II – 2007 Design and Build
12
Designing and Implementing the System
Traffic Data
Border Crossing Time Data
Weather Data
Incident Data
CBP Border Crossing Delay
HS Threat LevelAdvisoryCBP Inspection
Lanes Open
HAZMAT Crossing Data
Dimensions
Segment ID
Sensor ID
Route ID
Port of Entry ID
Inspection Lane ID
Event ID
Date and Time ID
Phase II – 2007 Design and Build
13
Designing and Implementing the System
Phase II – 2007 Design and Build
Amber Alerts
Vehicle Sensors
Highway Speed
Traffic Images
Traffic Incidents
Airport Info
Weather Alerts
DMS Messages
Border Crossing Delay from CBP
Inspection Lanes Open
Threat Advisory Level
IMIP Border Images
14
Designing and Implementing the System
Phase II – 2007 Design and Build
Dashboard Reports
Performance Monitoring
Congestion Monitoring
Micro and Macroscopic Calibration Tools
Data Mining Tools
Aggregated Volume and Speed
Summary Statistics of Border Crossing Delay
from CBP
Data Mining Tools for Border Crossing
15
Designing and Implementing the System
Data Type Archive Period Archive Frequency Display Frequency
Traffic and Truck Volume and Speed 2 years 30 seconds 1 minute
Segment Travel Time, Other Performance Indices 2 years 1, 15, 60 minutes
24 hours 1 minute
Highway Surveillance Camera Snapshots 1 week and purged then after 30 minutes 1 minute
DMS Messages None None 20 minutes
Incident Location 2 years 60 minutes 20 minutes
NOAA Weather 2 years 60 minutes 60 minutes
CBP – Inspection Lanes Open 1.5 years 60 minutes 60 minutes
CBP – Border Crossing Delay 1.5 years 60 minutes 60 minutes
Homeland Security Threat Level Advisory 1 month 60 minutes 60 minutes
Border Images None 5 minutes 60 minutes
Phase II – 2007 Design and Build
16
Designing and Implementing the System
Calibrating the system to verify system performance
Modifying system components until acceptable performance is achieved
Maintaining and monitoring the performance of the system
Providing enhancements according to operational experience
Adding processes and functions to maintain the system
Expansion of PDN RMIS by– Integrating with border crossing information– Integrating with HAZMAT monitoring system
Phase III – 2008 O & M and Expansion
Phase III – 2008O & M and Expansion
Phase III – 2008O & M and Expansion
Phase I – 2006Scoping and Needs
Phase I – 2006Scoping and Needs Phase II – 2007
Design and Build
Phase II – 2007Design and Build
17
Designing and Implementing the System
RMIS
Location of 16 cameras installed by Instituto Municipal de Investigacion y
Planeacion at US/Mexico Border
Terminal at BorerComm
Secure FTP Access
Phase III – 2008 O & M and Expansion
18
Designing and Implementing the System
RMIS
RFID Readers Being Installed by TTI
RFID Readers Being Installed by DPS
Bridge of the Americas, El Paso, Texas
Wireless Modems
Dedicated Terminal
Phase III – 2008 O & M and Expansion
19
Challenges and Opportunities
Overcoming Constraints with Innovative Ideas
Request Direct Access to Data Source
Willing to Help, But Time Consuming
Find Alternative Ways to Extract Data
Applications to Automatically
Read Agency Websites
Commitment from Agencies
Read and Parse Incident Reports from
City of El Paso WebsiteIncident
Data
Read and Parse Border Crossing Delay from
CBP WebsiteCBP Border
Crossing Delay
Read and Parse Number of Inspection Lanes Open from
CBP WebsiteCBP Inspection
Lanes Open
20
Challenges and Opportunities
Overcoming Constraints with Innovative IdeasTransVista FTMS
Server collects traffic data from sensors
TTI HostTTI SQL Server
Modem, PCAnywhere, Standalone Applications
TTI Web Server
Interactive Reports of Aggregate Data and
Performance Measures
Advanced Traveler Information
FTMS Server Pushes Raw Data to TTI
Processes and stores raw data
TTI initially requested a more efficient WIRELESS
connection
21
Challenges and Opportunities
Creating a Value-Added System
Traffic Information
Value of PDN Regional Mobility Information
Border Crossing Information
Value of PDN Regional Mobility Information
+
+
HAZMAT Information
Value of PDN Regional Mobility Information
+
+
22
Challenges and Opportunities
Creating New Opportunities – By Providing Tools to Identify Cause-Effect
Visibility = Visibility in MilesAvgSp = Average Speed of Vehicles in MPHAvgVol = Volume of Vehicles
Agg Volume = Aggregate VolumeAvg Speed Miles = Average Speed in MPH
23
Challenges and Opportunities
Creating New Opportunities – By Providing Tools for Reality Mining
N u m b er o f C o m m erc ia l V eh ic le In s p ec tio n L an es O p en an d D elay at B rid g e o f th e A m eric as , E l P as o , T ex as d u rin g th e Week o f D ec em b er 12, 2007 as R ep o rted b y C B P
0
5
10
15
20
25
30
35
12/1
0-6a
m
12/1
0-11
am
12/1
0-4p
m
12/1
0-9a
m
12/1
0-11
am
12/1
0-3p
m
12/1
1-7a
m
12/1
1-9a
m
12/1
1-3p
m
12/1
1-5p
m
12/1
1-N
oon
12/1
1-3p
m
12/1
2-8a
m
12/1
2-5p
m
12/1
2-4p
m
12/1
2-7a
m
12/1
2-10
am
12/1
2-N
oon
12/1
2-5p
m
12/1
3-10
am
12/1
3-10
am
12/1
3-7a
m
12/1
3-8a
m
12/1
3-2p
m
12/1
3-4p
m
12/1
4-7a
m
12/1
4-7a
m
12/1
4-10
am
12/1
4-4p
m
Del
ay (
Min
ute
s)
0
1
2
3
4
5
Lan
es O
pen
D elay on S tandard L anes
D elay on F as t L anes
F as t L anes O pen
S tandard L anes O pen
24
Challenges and Opportunities
Creating New Opportunities – By Providing Tools for Reality Mining
S tan d ard D ev iatio n o f D elay at B rid g e o f th e A m eric as , E l P as o , T ex as D u rin g th e Week o f D ec em b er 12, 2007 as R ep o rted b y C B P
0
2
4
6
8
10
S tandard F A S T
T yp e o f In sp e c tio n L a n e s
Stan
dard
Dev
iatio
n (M
inut
es)
FAST lanes are 4 times more reliable than Standard lanes
25
Challenges and Opportunities
Creating New Opportunities– By Providing Platform to Add New Information
RMIS
RFID Readers Being Installed by NMSU through EPA Grant
Santa Teresa Port of Entry, New Mexico
Send Real-Time Hazmat Information to First
Responders in New Mexico, El Paso, and Juarez
Wireless Modems
Dedicated Terminal
26
Challenges and Opportunities
Commercial Border Crossing Time
Measurement
RFID-Based
Measures border crossing time of commercial vehicles
Transmits information to freight operators and shippers
RFID-Based
Measures border crossing time of commercial vehicles
Transmits information to freight operators and shippers
++
Non-Commercial Border Crossing Time
Measurement
RFID-Based
Measures border crossing time of non-commercial vehicles
Transmits information to motorists crossing the border
RFID-Based
Measures border crossing time of non-commercial vehicles
Transmits information to motorists crossing the border
==
Creating New Opportunities – By Developing State–of–the–Art System
International Border Crossing Information System
International Border Crossing Information System
Border Crossing Information System
Provides real time border crossing information to agencies and public
Provides historical information to planners and researchers
Consistently and objectively measures border crossing performance
Provides real time border crossing information to agencies and public
Provides historical information to planners and researchers
Consistently and objectively measures border crossing performance
==
27
Challenges and Opportunities
FHWA
UTCMCIITR
Commercial Border Wait Time
Measurement
Border Crossing Information System
Leveraging New Funds
El Paso RFID Non-Commercial
Border Wait Time Measurement
City of El Paso
SWUTCEstimating Benefits of
Advanced Border Crossing Data
SWUTC HAZMAT Information System
International Border Crossing Information System
International Border Crossing Information System
PDN Regional Mobility Information System
28
Creating a Sustainable System
Sustain growth of storage space– Efficiency of the system
Sustain growth of transaction load– Licensing issues– Growth of users
Sustain growth of data marts– Effect on storage capacity– Increases complexity
Sustain stakeholder support– Keep stakeholders involved
Data Warehouse Estimated Growth
0
50
100
150
200
250
300
2008 2009 2010 2011
YearSt
orag
e Re
quire
men
t in
Giga
Byt
es
29
Future of PDN Regional Mobility Information System
Who will operate and maintain the system in the long run?
– How to obtain funding to operate and maintain the system.
– How to charge fee to users?
Could public-private partnership be a solution? Need to resolve institutional and technical issues, such as
– Intellectual property rights
– Access to data sources
– Market analysis of user fee
TTI is working on a project to perform a CROSS-CUTTING study on how Traffic Management Centers and Consortiums across U.S. handle INSTITUITIONAL issues
30
PDN Regional Mobility Information System Demo
31
Contact Information
Rajat Rajbhandari, Ph.D., P.E.Associate Research EngineerTexas Transportation Institute4050 Rio Bravo, Suite 151El Paso, TexasPhone: 915.532.3759Email: [email protected]: http://tti.tamu.eduRMIS: http://www.eptraffic.com