Class GEOMETRY

A column storing Geometry information. It is only available in PostgreSQL (with PostGIS), MariaDB or MySQL.

GeoJSON is accepted as input and returned as output.

In PostGIS, the GeoJSON is parsed using the PostGIS function STGeomFromGeoJSON. In MySQL it is parsed using the function STGeomFromText.

Therefore, one can just follow the GeoJSON spec for handling geometry objects. See the following examples:

Fallback policy: If this type is not supported, an error will be raised.

Example: Defining a Geometry type attribute

DataTypes.GEOMETRY
DataTypes.GEOMETRY('POINT')
DataTypes.GEOMETRY('POINT', 4326)

Example: Create a new point

const point = { type: 'Point', coordinates: [-76.984722, 39.807222]}; // GeoJson format: [lng, lat]

User.create({username: 'username', geometry: point });

Example: Create a new linestring

const line = { type: 'LineString', 'coordinates': [ [100.0, 0.0], [101.0, 1.0] ] };

User.create({username: 'username', geometry: line });

Example: Create a new polygon

const polygon = { type: 'Polygon', coordinates: [
                [ [100.0, 0.0], [101.0, 0.0], [101.0, 1.0],
                  [100.0, 1.0], [100.0, 0.0] ]
                ]};

User.create({username: 'username', geometry: polygon });

Example: Create a new point with a custom SRID

const point = {
  type: 'Point',
  coordinates: [-76.984722, 39.807222], // GeoJson format: [lng, lat]
  crs: { type: 'name', properties: { name: 'EPSG:4326'} }
};

User.create({username: 'username', geometry: point })

Hierarchy (view full)

ABSTRACT<GeoJson>
- GEOMETRY
  - GEOGRAPHY

Constructors

constructor

new GEOMETRY(type?, srid?): GEOMETRY
Parameters
- Optional type: GeoJsonType
  Type of geometry data
- Optional srid: number
  SRID of type
Returns GEOMETRY
Overrides ABSTRACT.constructor
- Defined in packages/core/src/abstract-dialect/data-types.ts:2572
new GEOMETRY(options): GEOMETRY
Parameters
- options: GeometryOptions
Returns GEOMETRY
Overrides AbstractDataType<GeoJson>.constructor
- Defined in packages/core/src/abstract-dialect/data-types.ts:2573

Properties

`Private` #dialect

#dialect: undefined | AbstractDialect<object, object>

`Readonly` options

options: GeometryOptions

usageContext

usageContext: undefined | DataTypeUseContext

Where this DataType is being used.

Methods

`Protected` _checkOptionSupport

_checkOptionSupport(dialect): void
Override this method to emit an error or a warning if the Data Type, as it is configured, is not compatible with the current dialect.
Parameters
- dialect: AbstractDialect<object, object>
  The dialect using this data type.
Returns void
Overrides ABSTRACT._checkOptionSupport
- Defined in packages/core/src/abstract-dialect/data-types.ts:2586

`Protected` _construct

_construct<Constructor>(...args): this
Type Parameters
- Constructor extends (new () => ABSTRACT<any>)
Parameters
- Rest ...args: ConstructorParameters<Constructor>
Returns this
Inherited from ABSTRACT._construct
- Defined in packages/core/src/abstract-dialect/data-types.ts:159

`Protected` _getDialect

_getDialect(): AbstractDialect<object, object>
Returns AbstractDialect<object, object>
Inherited from ABSTRACT._getDialect
- Defined in packages/core/src/abstract-dialect/data-types.ts:108

acceptsNull

acceptsNull(): boolean
Whether this DataType wishes to handle NULL values itself. This is almost exclusively used by JSON and JSONB which serialize null as the JSON string 'null'.

Returns boolean
Inherited from ABSTRACT.acceptsNull
- Defined in packages/core/src/abstract-dialect/data-types.ts:177

areValuesEqual

areValuesEqual(value, originalValue): boolean
Parameters
- value: GeoJson
- originalValue: GeoJson
Returns boolean
Inherited from ABSTRACT.areValuesEqual
- Defined in packages/core/src/abstract-dialect/data-types.ts:169

`Private` attachUsageContext

attachUsageContext(usageContext): this
Private
Parameters
- usageContext: DataTypeUseContext
Returns this
Inherited from ABSTRACT.attachUsageContext
- Defined in packages/core/src/abstract-dialect/data-types.ts:353

belongsToDialect

belongsToDialect(dialect): boolean
Parameters
- dialect: AbstractDialect<object, object>
Returns boolean
Inherited from ABSTRACT.belongsToDialect
- Defined in packages/core/src/abstract-dialect/data-types.ts:291

clone

clone(): this
Returns a copy of this DataType, without usage context. Designed to re-use a DataType on another Model.

Returns this
Inherited from ABSTRACT.clone
- Defined in packages/core/src/abstract-dialect/data-types.ts:333

escape

escape(value): string
Escapes a value for the purposes of inlining it in a SQL query. The resulting value will be inlined as-is with no further escaping.
Parameters
- value: GeoJson
  The value to escape.
Returns string
Inherited from ABSTRACT.escape
- Defined in packages/core/src/abstract-dialect/data-types.ts:219

getBindParamSql

getBindParamSql(value, options): string
This method is called when AbstractQueryGenerator needs to add a bind parameter to a query it is building. This method allows for customizing both the SQL to add to the query, and convert the bind parameter value to a DB-compatible value.

If you only need to prepare the bind param value, implement toBindableValue instead.

This method must return the SQL to add to the query. You can obtain a bind parameter ID by calling BindParamOptions#bindParam with the value associated to that bind parameter.

An example of a data type that requires customizing the SQL is the GEOMETRY data type.
Parameters
- value: GeoJson
  The value to bind.
- options: BindParamOptions
  Options.
Returns string
Inherited from ABSTRACT.getBindParamSql
- Defined in packages/core/src/abstract-dialect/data-types.ts:245

getDataTypeId

getDataTypeId(): string
Returns string
Inherited from ABSTRACT.getDataTypeId
- Defined in packages/core/src/abstract-dialect/data-types.ts:97

parseDatabaseValue

parseDatabaseValue(value): unknown
Called when a value is retrieved from the Database, and its DataType is specified. Used to normalize values from the database.

Note: It is also possible to do an initial parsing of a Database value using AbstractDialect#registerDataTypeParser. That normalization uses the type ID from the database instead of a Sequelize Data Type to determine which parser to use, and is called before this method.
Parameters
- value: unknown
  The value to parse.
Returns unknown
Inherited from ABSTRACT.parseDatabaseValue
- Defined in packages/core/src/abstract-dialect/data-types.ts:191

sanitize

sanitize(value): unknown
Used to normalize a value when Model#set is called. That is, when a user sets a value on a Model instance.
Parameters
- value: unknown
Returns unknown
Inherited from ABSTRACT.sanitize
- Defined in packages/core/src/abstract-dialect/data-types.ts:201

toBindableValue

toBindableValue(value): unknown
Converts a JS value to a value compatible with the connector library for this Data Type. Unlike escape, this value does not need to be escaped. It is passed separately to the database, which will handle escaping.
Parameters
- value: GeoJson
  The value to convert.
Returns unknown
Inherited from ABSTRACT.toBindableValue
- Defined in packages/core/src/abstract-dialect/data-types.ts:257

toDialectDataType

toDialectDataType(dialect): this
Returns this DataType, using its dialect-specific subclass.
Parameters
- dialect: AbstractDialect<object, object>
Returns this
Inherited from ABSTRACT.toDialectDataType
- Defined in packages/core/src/abstract-dialect/data-types.ts:300

toSql

toSql(): string
Returns a SQL declaration of this data type. e.g. 'VARCHAR(255)', 'TEXT', etc…

Returns string
Overrides ABSTRACT.toSql
- Defined in packages/core/src/abstract-dialect/data-types.ts:2609

toString

toString(): string
Returns string
Inherited from ABSTRACT.toString
- Defined in packages/core/src/abstract-dialect/data-types.ts:261

validate

validate(value): asserts value is GeoJson
Checks whether the JS value is compatible with (or can be converted to) the SQL data type. Throws if that is not the case.
Parameters
- value: unknown
Returns asserts value is GeoJson
Overrides ABSTRACT.validate
- Defined in packages/core/src/abstract-dialect/data-types.ts:2594

withUsageContext

withUsageContext(usageContext): this
Parameters
- usageContext: DataTypeUseContext
Returns this
Inherited from ABSTRACT.withUsageContext
- Defined in packages/core/src/abstract-dialect/data-types.ts:339

`Static` getDataTypeId

getDataTypeId(): string
Returns string
Inherited from ABSTRACT.getDataTypeId
- Defined in packages/core/src/abstract-dialect/data-types.ts:93

`Static` toString

toString(): string
Returns string
Inherited from ABSTRACT.toString
- Defined in packages/core/src/abstract-dialect/data-types.ts:270

Class GEOMETRY

Example: Defining a Geometry type attribute

Example: Create a new point

Example: Create a new linestring

Example: Create a new polygon

Example: Create a new point with a custom SRID

Hierarchy (view full)

Index

Constructors

Properties

Methods

Constructors

constructor

Parameters

Returns GEOMETRY

Parameters

Returns GEOMETRY

Properties

Private #dialect

Readonly options

usageContext

Methods

Protected _checkOptionSupport

Parameters

Returns void

Protected _construct

Type Parameters

Parameters

Returns this

Protected _getDialect

Returns AbstractDialect<object, object>

acceptsNull

Returns boolean

areValuesEqual

Parameters

Returns boolean

Private attachUsageContext

Parameters

Returns this

belongsToDialect

Parameters

Returns boolean

clone

Returns this

escape

Parameters

Returns string

getBindParamSql

Parameters

Returns string

getDataTypeId

Returns string

parseDatabaseValue

Parameters

Returns unknown

sanitize

Parameters

Returns unknown

toBindableValue

Parameters

Returns unknown

toDialectDataType

Parameters

Returns this

toSql

Returns string

toString

Returns string

validate

Parameters

Returns asserts value is GeoJson

withUsageContext

Parameters

Returns this

Static getDataTypeId

Returns string

Static toString

Returns string

Settings

Member Visibility

`Private` #dialect

`Readonly` options

`Protected` _checkOptionSupport

`Protected` _construct

`Protected` _getDialect

`Private` attachUsageContext

`Static` getDataTypeId

`Static` toString