Parking citations in Oakland from 2019. Data has been cleaned of personal information but data entry errors still remain. Approximately ~92% of citation addresses matched when geocoded. Refer to Status and Score fields to determine estimated accuracy. Last updated: 11/25/2019
This dataset has the following 14 columns:
Column Name | API Column Name | Data Type | Description | Sample Values |
---|---|---|---|---|
the_geom | the_geom | point | {"coordinates":[165.99845616481772,-90],"type":"Point"} {"coordinates":[-122.20902670584867,37.71661208128684],"type":"Point"} {"coordinates":[-122.27082838320824,37.80769018732725],"type":"Point"} {"coordinates":[-122.29339773853286,37.81673165223706],"type":"Point"} {"coordinates":[-122.24608333570578,37.81006398813884],"type":"Point"} view top 100 | |
Status | status | text | Codes: Matched, Unmatched, and Tied. Tied indicates multiple addresses at different locations returned the same best match score | M T U view top 100 |
Score | score | number | Address match score | 100.0 0.0 90.92 98.96 92.43 view top 100 |
Match_address | match_addr | text | Address used to find location of Location | 1 AIRPORT DR 521 18TH ST 1701 20TH ST 3200 LAKESHORE AV 500 12TH ST view top 100 |
Longitude | x | number | Longitude in decimal degrees | 1.0 -122.209026706 -122.270828383 -122.293397739 -122.246083336 view top 100 |
Latitude | y | number | Latitude in decimal degrees | 1.0 37.7166120813 37.8076901873 37.8167316522 37.8100639881 view top 100 |
Ticket_Number | ticket_num | number | Ticket ID | 0 1815 837341791 2068 2079 view top 100 |
Ticket_Date | ticket_iss | calendar_date | Ticket date | 2019-01-14T00:00:00.000 2019-02-11T00:00:00.000 2019-11-12T00:00:00.000 2019-10-14T00:00:00.000 2019-09-05T00:00:00.000 view top 100 |
Ticket_Time | ticket_i_1 | text | Ticket time | 13:04 13:00 12:59 12:53 12:55 view top 100 |
Fine_Amount | fine_amoun | number | Citation fine amount | 66 58 83 73 103 view top 100 |
Violation_code | violation1 | text | Violation code (Oakland Municipal Code or California Vehicle Code) | 10.28.240 10.36.050 10.36.030B 10.40.020A1 5204 view top 100 |
Location | location | text | Address used to geocode | 521 18TH ST 1 AIRPORT DRIVE 4000 PIEDMONT LOT 1 AIRPORT DR 2875 VALLECITO PL view top 100 |
Meter_Indicated | meter_indi | text | Did violation occur at meter? | No Yes view top 100 |
Meter | meter | text | Meter ID | 10-13 OIC-1 10-14 10-11 PLOT-4 view top 100 |