Skip to content

Street Suffix

Type Registry

Street Suffix

geography.address.street_suffix

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

Domain geography›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://noon.sh/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"
}

Examples

StreetAvenueBoulevardRoad

Also known as

street_type

Types in geography