Chicago Traffic Signals Database - PowerPoint by kpr16177

VIEWS: 81 PAGES: 19

									  Chicago Traffic Signals Database


Presented by:
Abraham Emmanuel
Traffic Management Authority –
Office of Emergency Management and Communication (OEMC)
City of Chicago




                                                          1
                               Overview

   26,000 intersections (Approximately)
   2,800 + signals
   24 Interconnects (480 signals)
   Three agencies
          Chicago Department of Transportation
          Bureau of Electricity
          Office of Emergency Management – Traffic Management Authority.

 Few Signals maintained by IDOT


                                                                        2
              Overview (Cont)

 Some form of electronic data repository
  existed since 1996.
 Not up-to-date since 2003
 New system developed in 2006 based on the
  legacy data.



                                              3
                          Challenge

 No one to one mapping between signals and intersections.


Signal A




  Signal B     Signal C                     Signal A




                                                             4
           Separated Signal from the
           Geography (intersection)

                          Intersection X
           Signal 1A

Signal 1

           Signal 1B
                       Intersection Y
           Signal 1C
                                           Intersection Z




Signal 2

           Signal 2A             Intersection W




                                                            5
     Linked Signals to City Intersections using Lat/Log




Chicago
Intersections


Chicago Intersections

                                                      6
                  End Product




City of Chicago
Signalized
Intersections




                                7
What data is collected?




                          8
A Lot of Information…




                        9
Timing & Timing Plans…




                         10
Links to Video & Still Images…




                                 11
Cable & Foundation Plans…




                            12
Intersection Details…
Maps & Aerial Images…




                        13
…And Can Track Work Order.




                             14
                  Technology

 Microsoft Access front-end interface

 Oracle Express Back End

 ArcView GIS for mapping



                                         15
                    Future Plans

Migrate to an Oracle 10g database.
Develop HTML/JAVA front-end for data sharing
across departments.
Link with…
      •The Traffic Crash database
      • ADT database
      • Surveillance Cameras
Provide up-to-date signal status information to
citizens through the City of Chicago website.
                                                   16
     Once completed the system should
     facilitate comprehensive traffic analysis




Top Crash
Intersections without
a traffic signal




                                             17
Questions?




   Chicago Signal
   Interconnect




                    18
                          Contact Information..

Traffic Management Authority - Office of Emergency Management & Communication
120 N Racine, Suite 200
Chicago, IL 60607


David Zavattero
Deputy Director
dzavattero@cityofchicago.org
(312) 743-7372


Abraham Emmanuel
Principal Systems Programmer
aemmanuel@cityofchicago.org
(312) 743-7381

                                                                                19

								
To top