MeridianMERIDIAN

Well-Known Text Geometry

OGC Well-Known Text (WKT) representation of geometry objects. Strings begin with a geometry type keyword (POINT, LINESTRING, POLYGON, MULTIPOINT, MULTILINESTRING, MULTIPOLYGON, GEOMETRYCOLLECTION) optionally followed by Z/M/ZM dimension suffix.

Well-Known Text Geometry

geography.format.wkt

OGC Well-Known Text (WKT) representation of geometry objects. Strings begin with a geometry type keyword (POINT, LINESTRING, POLYGON, MULTIPOINT, MULTILINESTRING, MULTIPOLYGON, GEOMETRYCOLLECTION) optionally followed by Z/M/ZM dimension suffix.

Domain
geography
Category
format
Casts to
VARCHAR
Scope
Universal

Try it

CLI
$ finetype infer -i "POINT (30 10)" --mode column
→ geography.format.wkt

DuckDB

Detect
SELECT ft_infer('POINT (30 10)');
-- → 'geography.format.wkt'
Cast expression
CAST({col} AS VARCHAR)
Safe cast pipeline
-- Normalise and cast in one step
SELECT TRY_CAST(ft_cast(my_column) AS VARCHAR) AS clean_value
FROM my_table
WHERE ft_infer(my_column) = 'geography.format.wkt';

JSON Schema

finetype taxonomy geography.format.wkt -o json-schema
{
  "$id": "https://meridian.online/schemas/geography.format.wkt",
  "$schema": "https://json-schema.org/draft/2020-12/schema",
  "description": "OGC Well-Known Text (WKT) representation of geometry objects. Strings begin with a geometry type keyword (POINT, LINESTRING, POLYGON, MULTIPOINT, MULTILINESTRING, MULTIPOLYGON, GEOMETRYCOLLECTION) optionally followed by Z/M/ZM dimension suffix.",
  "examples": [
    "POINT (30 10)",
    "LINESTRING (30 10, 10 30, 40 40)",
    "POLYGON ((30 10, 40 40, 20 40, 10 20, 30 10))",
    "MULTIPOINT ((10 40), (40 30), (20 20), (30 10))",
    "POINT EMPTY"
  ],
  "pattern": "^(POINT|LINESTRING|POLYGON|MULTI(POINT|LINESTRING|POLYGON)|GEOMETRYCOLLECTION)\\s*(Z|M|ZM)?\\s*(\\(|EMPTY)",
  "title": "Well-Known Text Geometry",
  "type": "string",
  "x-finetype-label": "geography.format.wkt",
  "x-finetype-pii": false
}

Examples

POINT (30 10)LINESTRING (30 10, 10 30, 40 40)POLYGON ((30 10, 40 40, 20 40, 10 20, 30 10))MULTIPOINT ((10 40), (40 30), (20 20), (30 10))POINT EMPTY

Aliases

well_known_text

Type Registry