Meridianmeridian

Street Suffix

geography.address.street_suffix

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

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

Try it

CLI
$ finetype infer -i "Street"
→ geography.address.street_suffix

DuckDB

Detect
SELECT finetype('Street');
-- → 'geography.address.street_suffix'
Cast expression
CAST({col} AS VARCHAR)
Safe cast pipeline
-- Normalise and cast in one step
SELECT TRY_CAST(finetype_cast(my_column) AS VARCHAR) AS clean_value
FROM my_table
WHERE finetype(my_column) = 'geography.address.street_suffix';

JSON Schema

finetype schema geography.address.street_suffix
{
  "$id": "https://meridian.online/schemas/geography.address.street_suffix",
  "$schema": "https://json-schema.org/draft/2020-12/schema",
  "description": "Street type abbreviation or suffix (St, Ave, Blvd, Rd, Ln, Way, Ct, Dr, etc.). Locale-specific.",
  "enum": [
    "Street",
    "St",
    "Avenue",
    "Ave",
    "Boulevard",
    "Blvd",
    "Road",
    "Rd",
    "Lane",
    "Ln",
    "Way",
    "Court",
    "Ct",
    "Drive",
    "Dr",
    "Circle",
    "Place",
    "Plaza",
    "Square"
  ],
  "examples": [
    "Street",
    "Avenue",
    "Boulevard",
    "Road"
  ],
  "title": "Street Suffix",
  "type": "string",
  "x-finetype-broad-type": "VARCHAR",
  "x-finetype-transform": "CAST({col} AS VARCHAR)"
}

Examples

StreetAvenueBoulevardRoad

Aliases

street_type