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 MunicipalitiesUnnamed Street834Driveway817Connecting Road443Ramp369Main Street360Parking Lot332Church Street317Mill Street236Elm Street221Maple Avenue197Pine Street178High Street177Center Street173River Road167School Street166Prospect Street165Park Avenue164Maple Street163Railroad Avenue155Ridge Road150Spring Street149Smith Road148Cemetery Road148North Street145Oak Street138Washington Street137South Street136Park Street133Grove Street131West Main Street126Water Street126North Main Street122John Street122Chestnut Street120Sunset Drive118Orchard Street117East Main Street117Miller Road117Highland Avenue1154WD Road112South Main Street109River Street108William Street108Park Place107Meadow Lane105West Street105Franklin Street105Bridge Street104Cross Road102Liberty Street100 Here is the SQL I used by loading the NYS Streets database as a Parquet into DuckDB and querying: view sourceprint?1SELECT completestreetname, count() FROM (SELECT DISTINCT completestreetname, leftcitytownname FROM nys_sam_streets.parquet) GROUP BY completestreetname ORDER BY count() DESC LIMIT 50;
Leave a Reply Cancel replyYour email address will not be published. Required fields are marked *Comment * Name * Email * Website Save my name, email, and website in this browser for the next time I comment. Ξ