MeridianMERIDIAN

Street Suffix

geography.address.street_suffix

Street type abbreviation or suffix (St, Ave, Blvd, Rd, Ln, Way, Ct, Dr, etc.). Locale-specific.

Casts to
VARCHAR
Scope
Locale-specific
Locales
EN, EN_AU, EN_GB, EN_CA, EN_US, DE, FR, ES, IT, NL, PL, RU

Background

Origin

Wikipedia describes a street suffix as the part of a street or road name that describes what type of road it is.[1] Wikipedia notes that street suffixes are often abbreviated because they are commonly repeated between roads, giving St. for Street as an example.[1] Wikipedia notes that in some languages the street suffix precedes the name and is thus a street prefix, as in rue Pasteur.[1] Wikipedia notes that in Wales it is common to use Welsh-language suffixes, such as Ffordd, Heol and Stryd, which usually precede the name.[1]

In the United States, the Postal Service lists street suffixes in Appendix C1 of Publication 28, Postal Addressing Standards.[2] The edition of Publication 28 on the Postal Service's Postal Explorer site is dated October 2024.[3] The Appendix C1 table lists primary street suffix names, commonly used street suffixes or abbreviations, and the recommended official Postal Service standard suffix abbreviation.[2] The Publication 28 suffix table lists AV, AVE, AVEN, AVENU, AVENUE, AVN and AVNUE as commonly used forms of AVENUE, with AVE as the Postal Service standard suffix abbreviation.[2] When an address has two consecutive words that appear on the suffix table, Publication 28 abbreviates the second word as the suffix and treats the first word as part of the street name.[4]

The Federal Geographic Data Committee endorsed the United States Thoroughfare, Landmark, and Postal Address Data Standard in February 2011.[5] The United States Thoroughfare, Landmark, and Postal Address Data Standard has the document number FGDC-STD-016-2011.[5] The U.S. Census Bureau is the maintenance authority for FGDC-STD-016-2011.[5] In an XML example in Part 3 of FGDC-STD-016-2011, the address 123 Main Street is stored with Main as the StreetName and Street as the StreetNamePostType.[6]

Use

The Publication 28 suffix table gives CT as the Postal Service standard suffix abbreviation for COURT.[2] Canada Post says a French street type is printed before the street name when the street name isn't an ordinal number, and after it when the street name is an ordinal number.[7] Canada Post notes that sometimes the street type is also the street name, as in THE PARKWAY.[7]

Sources

  1. [1]Street suffixsecondary source
  2. [2]C1 Street Suffix Abbreviations | Postal Explorerstandard
  3. [3]Publication 28 - Postal Addressing Standards | Postal Explorerstandard
  4. [4]234 Suffixes | Postal Explorerstandard
  5. [5]United States Thoroughfare, Landmark, and Postal Address Data Standard — Federal Geographic Data Committeecatalogue entry
  6. [6]United States Thoroughfare, Landmark, and Postal Address Data Standard, Part 3: Address Data Classificationstandard
  7. [7]Addressing guidelines - Civic address | Canada Postdocumentation

Detection notes

v1 migration: Was address.street_suffix. Locale-specific for suffix naming and abbreviation conventions.

Use it

CLI · DuckDB
$ finetype infer -i "Street" --mode column
→ geography.address.street_suffix

SELECT ft_infer('Street');
-- → 'geography.address.street_suffix'
Cast expression
CAST({col} AS VARCHAR)

Schema

https://meridian.online/schemas/geography.address.street_suffix · Frictionless type string

finetype taxonomy geography.address.street_suffix -o json-schema

Aliases

street_type

Type Registry