MeridianMERIDIAN

location

6 location types: 2 a sibling also accepts and reads alike, 2 in Meridian's open data.

6 types

The 6 location types

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

TypeSampleAlso accepted by
Country Code
country_code · VARCHAR
USstate_code
State/Province Code
state_code · VARCHAR
CAcountry_code
City Name
city · VARCHAR
New York—
Continent Name
continent · VARCHAR
North America—
Country Name
country · VARCHAR
United States—
Region / State
region · VARCHAR
California—

Which location type is it?

2 of 6 location types accept it, and read it alike.

City Name, Continent Name, Country Name and Region / State carry no pattern or format, so they have no rule to ask.

TypeReads it as
Country Code country_codeUS
State/Province Code state_codeUS

In Meridian's open data

Use it

CLI · DuckDB
$ printf '%s\n' 'US' 'FR' > column.txt
$ finetype infer -f column.txt --mode column

SELECT ft_profile(v) FROM (VALUES ('US'), ('FR')) t(v);

After FR, 2 types remain: country_code, state_code.

Type Registry