parkingtic.jpg

The dreaded Portland parking ticket.

(Joseph Rose/The Oregonian/OregonLive)

What could you do with a database of every single Portland parking ticket written over nearly four years?

Pretty much anything you want. (Just try not to embarrass yourself.)

Here you go:

to load this Caspio

.

Officers dished out a little more than 900,000 citations between Jan. 1, 2011 and Dec. 1, 2014. As The Oregonian/OregonLive continues its series on how the city enforces parking laws, we've decided to offer up a searchable database of the 886,384 for which a license plate was listed.

You may not have made our list of the city's top parking culprits earlier this month. But if you're a repeat offender, you can punch in your plate number and find out where your collection of yellow envelopes ranks. Just look in the "rank" column. Easy enough.

But wait, there's more.

You can also search by vehicle make, date and location.

Here are a few curious info-nuggets that popped up during our data-crunching:

Texans appear to have a hard time figuring out the parking rules and such of Stumptown. After vehicles from Oregon (729,764 tickets), Washington (88,355) and California (23,964), those with Texas plates (3,745) were the most cited. Vehicles with Arizona plates were close behind with 3,614 tickets.

When it came to vehicle makes with the most tickets, the numbers essentially lined up with the most popular cars on the road. Toyotas received the most tickets (122,790), followed by Hondas (92,785), Fords (92,141), Chevrolets (58,467) and Subarus (57,717).

Of course, the case could be made that -- aside from frequently ticketed UPS and FedEx delivery truckers --

As an aside,

We'll let you loose now. Have fun. And don't forget to pay your parking fines.

-- Joseph Rose

503-221-8029

jrose@oregonian.com

@pdxcommute

-- Fedor Zarkhin

503-294-7674

fzarkhin@oregonian.com

@fedorzarkhin

-- Interactive database by Dave Cansler