Short answer: Jordan Metzner says LA offers parking data via Excel, queries and APIs, which he mapped with Mapbox, coding mostly in Cursor and Codex. He says brown, purple and gold cars rarely get tickets, but they are uncommon.
Watch this answer from Episode 15 (starts at 3:10) · Episode 15 notes and transcript
From Episode 15: Sora 2 Took Over AI Video + Our New Parking Data Tool, starting at 3:10.
Jordan Metzner [3:10]: I've manipulated the data from the city before to looking at parking data at LAX and a few of these other APIs. And thanks to a company called Travis, which has the contract with the city of LA, there's pretty much access to the data through Excel, queries, as well as APIs. So I thought it'd be fun to take the LA parking data. I queried the API. I did this last week, so data might be a little bit stale. And essentially show a map of where parking tickets are being issued in LA. So I did that here. And here's the city of Los Angeles. And you'll notice there's some pockets kind of where there's no parking tickets, like, for example, in Beverly Hills or Santa Monica. These actually happen to be autonomous cities within the city of Los Angeles, and so this actually makes a lot of sense. What you can see here is, like, the different officers. So, if you kind of find the officer now this officer l four, let's say officer fifty three, you can see kind of, he's been working the Valley area and, as far north up till here, as far east and west all the way over here. But you can see plenty of pockets kind of where, these officers are actually, not really penetrating. And, this is Ventura Boulevard, so, obviously, there's the most amount of tickets being happened on a Main Avenue. And we can go through kind of different officers and see, where they're giving their tickets.
Jordan Metzner [4:34]: I also have like an officer leader board here, so you can kinda see which officers are driving the most amount of revenue. I've also actually added well, I mean, You gotta understand, these are officers writing tickets.
Sam Nadler [4:49]: I'm just kidding. They're doing their jobs.
Jordan Metzner [4:50]: Yeah. They're doing their job. Yeah. But, obviously officer fifty six is in the lead here with 329 tickets, 55 with a 141. Again, this could be some data discrepancy just in how I brought the data in. But it looks like, in general, officers are written, I think in, like, over this time period about a 150 tickets or so per officer. And then I also have it segmented out by, vehicle type vehicle color, excuse me. I have violation type. I have the different agencies, so we can see kind of, like, does the downtown area versus other areas. And then I also have some date range selectors as well. Something interesting with the colors I started to notice, obviously, black, white, and gray are the most ticketed cars, but they're probably also the most popular colors. And so I was trying to see, are there any car colors that, like, don't get tickets very often? Brown, purple, and gold cars just don't get tickets very often, but they're also, not very popular car colors. So, I don't know if the solution to avoid parking tickets is to get a brown car, but, the data would lead you to believe that that would be true. So, yeah, this is called Tix LAX, like I mentioned, all supported by LA parking meter data straight from the city of Los Angeles.
Jordan Metzner [6:11]: And then, yeah, using Mapbox here, I coded almost all of it using Cursor and Codex. OpenAI's Codex five. And, yeah, happy to answer any questions, Sam.
