Mobile Food Facility

About Dataset Edit Project Scope This project analyzes the mobile food facility Permit dataset for the city, covering permits, vendor activity, shift patterns, and food orders. The goal is to understand operational trends, vendor performance, location usage, and the balance between cold trucks and hot food trucks. The analysis supports operational planning, permit management, and vendor insights. Data Field DayOrder: Number corresponding to day of week: 0=Sunday, 1=Monday, etc. DayOfWeekStr: Day of Week starttime: Start time endtime: End time permit: Permit number PermitLocation: Address or blocklot (parcel) number of location locationdesc: Description of street segment or intersection location Optionaltext: A description of food items sold locationid: number Location id of facility number scheduleid: Schedule id of facility start24: Start time in 24 hour end24: End time in 24 hour CNN: CNN of street segment or intersection location Addr_Date_Create: Date schedule record created Addr_Date_Modified: Date schedule record modified block: Block number lot text: Lot number ColdTruck: cold truck: Y or N Applicant: Name of permit holder X: CA State Plane III Y: CA State Plane III Latitude: WGS84 Longitude: WGS84 Location: Location formatted for mapping Outcome Q1: What are the overall activity metrics for mobile food facilities? Q2: Which days of the week have the highest order volume? Q3: How do cold trucks compare to hot trucks? Q4: Which applicants (vendors) are the most active in terms of orders? Q5: How do shifts distribute across days of the week? Q6: What is the average number of orders per location? Q7: How does order per location vary across the week? Q8: How many locations are associated with each permit on average? Q9: What are the peak start times for shifts? Q10: How many items are sold per day on average?