Skip to content

Full Address

Type Registry

Full Address

geography.address.full_address

Complete street address (number, street, city, postal code, country). Format and order locale-specific. May include apartment/suite numbers.

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, JA, ZH, KO, AR

Try it

CLI 
$ finetype infer -i "123 Main Street, New York, NY 10001, USA"
→ geography.address.full_address

DuckDB

Detect 
SELECT finetype('123 Main Street, New York, NY 10001, USA');
-- → 'geography.address.full_address'
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.full_address';

Struct Expansion

city: REGEXP_EXTRACT({col}, '([A-Z][a-z]+)(?:,|$)')
street_name: REGEXP_EXTRACT({col}, '^[0-9]+\s+(.+?),?\s+(?:[0-9]{5})?')
street_number: REGEXP_EXTRACT({col}, '^([0-9]+)')

JSON Schema

finetype schema geography.address.full_address 
{
  "$id": "https://noon.sh/schemas/geography.address.full_address",
  "$schema": "https://json-schema.org/draft/2020-12/schema",
  "description": "Complete street address (number, street, city, postal code, country). Format and order locale-specific. May include apartment/suite numbers.",
  "examples": [
    "123 Main Street, New York, NY 10001, USA",
    "456 Oxford Street, London, W1C 1AX, UK",
    "789 Rue de Rivoli, Paris, 75004, France"
  ],
  "maxLength": 500,
  "minLength": 10,
  "title": "Full Address",
  "type": "string"
}

Examples

123 Main Street, New York, NY 10001, USA456 Oxford Street, London, W1C 1AX, UK789 Rue de Rivoli, Paris, 75004, France

Also known as

addressstreet_address

Types in geography