List of recognized meanings¶

Here is the list of meanings that DSS recognizes.

Basic meanings ¶

Anything is valid for the “Text” meaning.

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

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

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

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:

Recognizes objects and arrays in JSON notation

Recognizes “long text made of words”

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

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

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

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

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

DSS recognizes a few other specific meanings