List of recognized meanings

Here is the list of meanings that DSS recognizes.

Basic meanings

Text

Anything is valid for the “Text” meaning.

Decimal

Recognizes “raw” decimals (like: 1234.32). Accepts negative and scientific notation

Integer

Recognizes “raw” integers (like: 1234). If the number is higher than 2147483647 or lower than -2147483648, use bigint type.

Boolean

This meaning recognizes a large number of possible values (true, false, yes, no, 1, 0, …)

Date / Dates (needs parsing)

The Date meaning only recognizes dates in the ISO-8601 format, ie dates like 2014-12-31T23:05:43.123Z

Note that the timezone information is mandatory for a valid Date

For all other kinds of dates the “Date (needs parsing)” meaning will be recognized. For more information, see:

Object / Array

Recognizes objects and arrays in JSON notation

Natural language

Recognizes “long text made of words”

Geospatial meanings

Latitude / Longitude

This meaning recognizes a large number of formats for expressing geometric coordinates.

Geopoint

This meaning recognizes a large number of formats for expressing a point in geometric coordinates (notably WKT)

Geometry

This meaning recognizes WKT format for geographic lines, polygons and multipolygons.

Country

The Country meaning recognizes country names (in English) and ISO Country codes

US State

This meaning recognizes both short codes and full names for USA states.

Web-specific meanings

  • IP Address (IPv4 and IPv6)

  • URL

  • HTTP Query String

  • User Agent

  • E-Mail address

Other meanings

DSS recognizes a few other specific meanings