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

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