MariaDB (MySQL-compatible) Spatial User Attributes

Readers: For information on the parameters in this dialog that are common to all readers, see:

Writers: For information on the parameters in this dialog that are common to all writers, see:

User attributes for this format are defined below.

Name

The name of the field to be written.

Valid values for field name include any character string devoid of SQL-offensive characters and less than 63 characters in length.

Type

The type of a column in a table. The valid values for the field type are listed below:

int

smallint

tinyint

mediumint

bigint

decimal(width, precision)

float(width, precision)

double(width, precision)

char(width)

varchar(width)

date

time

datetime

timestamp

year

tinyblob

blob

mediumblob

longblob

tinytext

text

mediumtext

longtext

Index

The type of index to create for the column.

The valid values for the index type are listed below:

  • BTree: B-Tree-based geometry index (default attribute index)
  • Hash: Hash-based geometry index
  • PrimaryKey: Any primary key or identity attribute