MeridianMERIDIAN

address

4 address types: none a sibling also accepts, 2 that decompose into parts.

4 types

The 4 address types

Each type's first registry sample, against every sibling's rule

TypeSampleAlso accepted by
Full Address
full_address · VARCHAR
123 Main Street, New York, NY 10001, USA—
Postal Code
postal_code · VARCHAR
10001—
Street Name
street_name · VARCHAR
Main Street—
Street Suffix
street_suffix · VARCHAR
Street—

Which address type is it?

Full Address, Postal Code, Street Name and Street Suffix carry no pattern or format, so they have no rule to ask.

Use it

CLI · DuckDB
$ printf '%s\n' '123 Main Street, New York, NY 10001, USA' '456 Oxford Street, London, W1C 1AX, UK' > column.txt
$ finetype infer -f column.txt --mode column

SELECT ft_profile(v) FROM (VALUES ('123 Main Street, New York, NY 10001, USA'), ('456 Oxford Street, London, W1C 1AX, UK')) t(v);

No address type's rule accepts 456 Oxford Street, London, W1C 1AX, UK.

Type Registry