Meridianmeridian

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
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, 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

Expression
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://meridian.online/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",
  "x-finetype-broad-type": "VARCHAR",
  "x-finetype-transform": "CAST({col} AS VARCHAR)"
}

Examples

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

Aliases

addressstreet_address