CIS 520:Software Engineering

Parking Citation, City of Los Angeles

Submitted to Dr. Jongwook Woo

Submitted by: Pratik BhayaniAkshay Ahirrao

Nishant Gupta

California State University, Los Angeles

Table of Content

• Parking Citation, City of Los Angeles

• About Project

• Major Violations

• What have we used

• Hive Queries

• Graphs and Final Results

• Conclusion

• Data analysis is done on Parking Citations for city of Los Angeles.

• Data analysis is done using HDInsight Cluster (Microsoft Azure), HiveQL

• Analyzed data is visualized using Tableau, Power BI and PowerView In Excel in the form of Charts, Graphs and Maps.

ABOUT PROJECT

Major Violations

Parking Violation Includes Offences Such AS..

1. No Parking/ Street Clean

2. Meter Exp.

3. Display of Tabs

4. Parked over Time Limit

5. Stop Stand Prohibit

6. Handicap/ No DP ID

Big Data Life-Cycle

Flow Chart

6

• Microsoft Azure

• Cloudberry Explorer

• Tableau

• PowerView in Excel

• Power BI

What Have We Used

Data Analysis

Data Analysis is Done On..

1. Violation Description.

2. Fine Amount.

3. RP State Plate.

4. Tickets Issue Date & Time

5. Location

Details

Platform : Microsoft Azure HDInsight Cluster Type : HadoopCluster OS : Windows Server 2012 R2 DatacenterNodes : 4 Data nodes CPU : 4 CoresMemory : 14 GB

Dataset Size

1.02 GB

HDInsight Cluster on Microsoft Azure

Data Uploading Using CloudBerry Explorer

Loading Data to Table

Raw Data Output using Power Query

Query 2 – Issue Date

Query to Find Number of parking citation daywise

Output of Query 2

Query to find peak time when citations are high

Query 3 – Issue Time

Output of Query 3

Query to find count of each Violation Description

Query 4 – Violation Description

Output of Query 4

Query to find total fine amount for each violation

Query 5 – Fine Amount

Output of Query 5

Query to find Citations made by visitors from other states

Query 6 – RP StatePlate

Output of Query 6

Query to find specific area in LA for maximum citations by other registered state plates

Query 7 – Location

Output of Query 7

Query to find ‘No Park/Street Clean’ quarter wise.

Query 8 – VD – No Park Street Clean

Output of Query 8

Query to find ‘Meter Expiry’ quarter wise.

Query 9 – VD – Meter Expiry

Output of Query 9

Public Parking Available - LA

Some Facts

• Any vehicle that has been parked on a city street or highway for 72 hours or more can be reported as an abandoned vehicle.  (Parking in alleys is illegal at all times)

• LADOT operates 118 public parking facilities throughout the City of Los Angeles with more than 11,500 parking spaces.

• Traffic officers issue about 2.5 million citations each year.

Source Citation: http://www.ladot.lacity.org/WhatWeDo/Parking/index.htm

Conclusion

1. Highest number of citations are in the month of August which is approx. 250000 per year.

2. Highest citations are faced during morning 8.00 am to 12 noon.

3. No Park Street Clean and Meter Expiry together contribute about 50% of total Citations every year.

4. Highest number of Citations among visitors is from State of Arizona.

References

• https://www.lacity.org/• http://www.tutorialspoint.com/hive/hive_data_types.htm• https://docs.treasuredata.com/articles/hive• http://www.ladot.lacity.org/whatwedo/parking/parkingtickets/

index.htm• https://data.lacity.org/dataset/Parking-Citations/t4h6-r362

LINKS

• GITHUB Link: (Code Only) https://gist.github.com/pratsdbrat/9b9ccf6b3e97180676bc

• Dataset Link: (Datasize – 1.02 GB) https://data.lacity.org/dataset/Parking-Citations/t4h6-r362

Thank YouQ & A