MeridianMERIDIAN

Measurement Unit

Unit of measurement (meter, kilogram, second, Joule, etc.). May be written as symbol (m, kg, s) or full name (meter, kilogram). Broad categorization.

Measurement Unit

representation.scientific.measurement_unit

Unit of measurement (meter, kilogram, second, Joule, etc.). May be written as symbol (m, kg, s) or full name (meter, kilogram). Broad categorization.

Domain
representation
Category
scientific
Casts to
VARCHAR
Scope
broad_words

Try it

CLI
$ finetype infer -i "meter"
→ representation.scientific.measurement_unit

DuckDB

Detect
SELECT finetype('meter');
-- → 'representation.scientific.measurement_unit'
Cast expression
LOWER(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) = 'representation.scientific.measurement_unit';

JSON Schema

finetype schema representation.scientific.measurement_unit
{
  "$id": "https://meridian.online/schemas/representation.scientific.measurement_unit",
  "$schema": "https://json-schema.org/draft/2020-12/schema",
  "description": "Unit of measurement (meter, kilogram, second, Joule, etc.). May be written as symbol (m, kg, s) or full name (meter, kilogram). Broad categorization.",
  "enum": [
    "meter",
    "kilogram",
    "second",
    "ampere",
    "kelvin",
    "mole",
    "candela",
    "hertz",
    "newton",
    "joule",
    "watt",
    "pascal",
    "degree_celsius",
    "liter",
    "gram",
    "m",
    "kg",
    "s",
    "A",
    "K",
    "mol",
    "cd",
    "Hz",
    "N",
    "J",
    "W",
    "Pa",
    "°C",
    "L",
    "g"
  ],
  "examples": [
    "meter",
    "kilogram",
    "second",
    "m",
    "kg",
    "Joule",
    "J"
  ],
  "title": "Measurement Unit",
  "type": "string",
  "x-finetype-broad-type": "VARCHAR",
  "x-finetype-transform": "LOWER(CAST({col} AS VARCHAR))"
}

Examples

meterkilogramsecondmkgJouleJ

Aliases

unit

Type Registry