1 / 21

Using Data = Being a Better Regulator

Using Data = Being a Better Regulator. IATR Conference September 2009 Andrew Salkin First Deputy Commission New York City Taxi and Limousine Commission. Role of a Regulator. Setting Standards (Policy) Communicating Standards Enforcing Standards Making your office work (Operations).

nico
Download Presentation

Using Data = Being a Better Regulator

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Using Data =Being a Better Regulator IATR Conference September 2009 Andrew Salkin First Deputy Commission New York City Taxi and Limousine Commission

  2. Role of a Regulator • Setting Standards (Policy) • Communicating Standards • Enforcing Standards • Making your office work (Operations)

  3. Using Data • Data You Already Have • Working with your Partner’s Data • Creating New Data

  4. Data You Already Have • TLC Story: • Mainframe (TAMIS): • Data is entered to create Licenses and Summonses • Creation of a Data Warehouse: • Nightly re-creation of Mainframe Data • Viewed via Access • Training

  5. Data You Already Have User Unfriendly User Friendly TLC Mainframe TLC Data Warehouse (SQL Environment) Basic License Info Basic Licensee Info Summons/Court Info Receipt Info Nightly Uploads

  6. Data You Already Have • General License Information: • Policy: • How many of each license type? • How this changes over time?

  7. Data You Already Have

  8. Working with your partner’s data • NYS DMV Data: • Vehicle Inspection Records • Vehicle Insurance Records • Licensee Status

  9. Working with your partner’s data User Unfriendly TLC Mainframe User Friendly TLC Data Warehouse (SQL Environment) NYS DMV Extracts Vehicle Insurance Info Vehicle Inspection Info Suspended License List Driver Points Surrendered Plates Scheduled Uploads

  10. Working with your partner’s data • Vehicle Inspection Records: • TLC Rule: • All For-Hire Vehicles must get inspected every four months • Historical Enforcement: • Field enforcement only - if we see you we will summons you • Working with Data • Found typically 12,000 vehicles were failing to maintain compliance with four month standard • Actions: • Rewrite rules to clearly state standard • New rules that required For-Hire Vehicles to report to TLC inspection facility

  11. Working with your partner’s data • Insurance Records: • TLC Rule: • All vehicles must have minimum levels of insurance • Historical Enforcement: • Verified policy information upon license renewal or once every two years • Working with Data: • Began to check insurance records weekly against NY State DMV records • Found typically 300 vehicles had issues weekly (or 15,000+ per year) • Actions • Rewrite rules to clearly state standard • Proactively checking records weekly to verify insurance requirements

  12. Creating New Data • T-PEP Data: • Electronic Trip Information • Policy: • Detailed Taxi Service Information • Compliance: • Suspended Vehicles and Drivers

  13. Working with your partner’s data User Unfriendly TLC Mainframe User Friendly TLC Data Warehouse (SQL Environment) NYS DMV Extract T-PEP Data Electronic Trip Sheet Data Monthly Uploads

  14. Creating New Data – Service Stats

  15. Creating New Data – Service Stats

  16. Creating New Data – Tracking Trips Example of Analysis: E 72nd St. Area 3 weeks in January 2009 Monday – Friday, 6 – 10am

  17. Creating New Data – Tracking Trips Example of Analysis: W 72nd St. Area 3 weeks in January 2009 Monday – Friday, 6 – 10am

  18. Creating New Data - Compliance • Suspended Taxis Operating • Suspended Taxi Drivers Operating vehicles

  19. Sharing your data Data Set TLC Data Warehouse (SQL Environment) TLC Mainframe NYS DMV Extract T-PEP Data Data Updated on the Web Daily Weekly Court Schedule Licensed Vehicles Pending Summonses Licensed Drivers Licensed Bases Bad DMV Status

  20. Using Data in the future • Adding new data sets to the warehouse • Automatically generating summonses based on standards • Handheld Enforcement Capabilities • Building on in-vehicle technology and tracking

  21. Using Data =Being a Better Regulator

More Related