Vehicles for Hire

dashboard.edmonton.ca | Last Updated 7 Nov 2018

Tags: vehicles for hire

This dataset has the following 12 columns:

Column NameAPI Column NameData TypeDescriptionSample Values
IDidnumber
Date_Timedate_timecalendar_date
Monthquartertext
Yearyearnumber
Number of Commercial PTP Dispatchersnumber_of_commercial_ptp_dispatchersnumberNumber of Commercial PTP Dispatchers (Uber and Tapp Car in General) Posse Job Type: TaxiLimoBusinessLicence 1 Filter: Commercial PTP Data should be pulled by issue date for the last 2 years
Number of Regional PTP Dispatchersnumber_of_regional_ptp_dispatchersnumberNumber of Regional PTP Dispatchers Posse Job Type: TaxiLimoBusinessLicence 1 Filter: Regional PTP Data should be pulled by issue date for the last 2 years and only the jobs in issued status should be counted.
Number of General Dispatchersnumber_of_general_dispatchersnumberPosse Job Type:TaxiLimoBusinessLicence 1 Filter : Include the following categories or (all categories excluding Regional and Commercial PTP) (i) General (ii) Exclusive (iii) Taxi (iv) Limo (v) Shuttle Data should be pulled by issue date for the last two years and only the jobs in issued status should be counted.
Number of Commercial PTP Driversnumber_of_commercial_ptp_driversnumberNumber of Commercial PTP Drivers Posse Job Type: TaxiLimoChaffeurDriversLic 2 Filter: CommercialPTP Data should be pulled by 'Created Date' for the last 2 years and only those licence in issued status, should be counted.
Number of PTP Vehiclesnumber_of_ptp_vehiclesnumberNumber of PTP Vehicles Posse Job Type: VehicleLicense 3 Filter: Include the following categories (i) Regioinal PTP (Data should be pulled by issueddate for this filter-(Last 2 years)) (ii) Commercial PTP (Data should be pulled by createddate for this filter, as this category is not issued and is in new status- Last 2 years ) After extracting data in excel remove the duplicates first using both provincial plate + vin #, and then create a pivot table to exclude cancelled applications
Number of General Drivers (Active Drivers)number_of_general_drivers_active_driversnumberNumber of General Drivers (Active Drivers) Posse Job Type: TaxiLimoChaffeurDriversLic 2(Issued for last 2 years-with issued, renewed or temporary status only) Pull this data again Filter: Include the following categories (i) Taxi (ii) Limo (iii) Shuttle (iv) Regional PTP (v) General (vi) Class A (vii) Class B Eventually the following categories will be amalgamated to General Licence category as soon as the licences issued before the bylaw changes get renewed. (i) Shuttle (ii) Class A (iii) Class B (iv) Limo Data should be pulled by 'Created Date' and only those licence in issued status, should be counted.
Number of Taxi Plates (Vehicles)number_of_taxi_plates_vehicles_3numberNumber of Taxi Plates (Vehicles) Posse Job Type: VehicleLicense Date should be pulled for last 2 years Filter: Include the following categories: (i) Taxi (ii) Accessible (iii) NT Accessible (iv) Limited Categories not included (i) Regional PTP & (ii) Limo
Active taxi and private transportation provider vehiclesactive_taxi_and_private_transportation_provider_vehiclesnumberSum of number of PTP vehicles and number of taxi plates