Transportation

Show Only ...
Maps - Photos - Videos

Model Year of Registered Motor Vehicles in New York, December 2025

|

There are fewer and fewer motor vehicles from 2011 and earlier left on the roads at this point..

It's good one for one's brain to practice window functions in SQL, lest I get rusty at such things. And yes, the first thing I did with all big data I get is put into a parquet and query it with duckdb. This turns the 12.5 million records into a much smaller table and calculates the percents using a SQL window function:

SELECT County, "Model Year", count(*) as Count,
             count(*)/sum(count(*)) OVER (PARTITION BY County) AS Percent
             FROM '~/Downloads/vehregdec25.parquet'
             WHERE "Record Type"='VEH' AND County != 'OUT-OF-STATE'
             GROUP BY County, "Model Year";

And here is the R script to making the graph in ggplot: Model Year of Registered Vehicles.R

Model Year of Registered Motor Vehicles in New York, December 2025 [Expires December 1 2026]

NPR

|

Trump wants the U.S. to build tiny cars. Will they take off? : NPR

That news came in the middle of a press conference about the Trump administration relaxing fuel economy rules — a change that will make it easier for Americans to buy more of the big, fuel-guzzling trucks and SUVs that car buyers love.

Trump's endorsement surprised, delighted and somewhat confused American kei car enthusiasts.

It is not actually illegal to build tiny cars for the U.S. auto market. The problem is that kei cars built for foreign countries don't meet U.S. safety standards, so you can't import them unless you're willing to buy an antique. And companies could build tiny cars to U.S. standards, but given the American preference for big vehicles, they simply don't.

NYSDOT Rest Areas Across NY

|

This helpful interactive map shows NYS DOT rest areas along the major interstates (excluding the New York Thruway) with bathrooms. A few of these rest areas are closed, but it will give you an idea which facilities are open. Tomorrow, I will do a map of Thruway Rest Stops. I was originally going to combine these into one map, but it turns out the DOT and Thruway Authority record information on their Rest Areas in a very different format.