Day: February 1, 2025

Show Only ...
Maps - Photos - Videos

Idaho

I was looking at this map and never realized how close much of North Idaho is to Spokane, Washington. I bet that is some of the appeal of state, especially the mountainous, rural and remote conservative country of that part of the nation. I am playing with interactive map, it's kind of fascinating.

Most Common Street Names in New York

What are the most common street names, as defined by the count of municipalities that have a street with this name in New York State?

Street NameIn this Many Municipalities
Unnamed Street834
Driveway817
Connecting Road443
Ramp369
Main Street360
Parking Lot332
Church Street317
Mill Street236
Elm Street221
Maple Avenue197
Pine Street178
High Street177
Center Street173
River Road167
School Street166
Prospect Street165
Park Avenue164
Maple Street163
Railroad Avenue155
Ridge Road150
Spring Street149
Smith Road148
Cemetery Road148
North Street145
Oak Street138
Washington Street137
South Street136
Park Street133
Grove Street131
West Main Street126
Water Street126
North Main Street122
John Street122
Chestnut Street120
Sunset Drive118
Orchard Street117
East Main Street117
Miller Road117
Highland Avenue115
4WD Road112
South Main Street109
River Street108
William Street108
Park Place107
Meadow Lane105
West Street105
Franklin Street105
Bridge Street104
Cross Road102
Liberty Street100

Here is the SQL I used by loading the NYS Streets database as a Parquet into DuckDB and querying:

1SELECT completestreetname, count() FROM (SELECT DISTINCT completestreetname, leftcitytownname FROM nys_sam_streets.parquet) GROUP BY completestreetname ORDER BY count() DESC LIMIT 50;