Appendix A. MobilityDB Reference

Table of Contents

MobilityDB Types
Set and Span Types
Input and Output
Constructors
Conversions
Accessors
Transformations
Spatial Reference System
Set Operations
Bounding Box Operations
Distance Operations
Comparisons
Aggregations
Box Types
Input and Output
Constructors
Conversions
Accessors
Transformations
Spatial Reference System
Splitting Operations
Set Operations
Bounding Box Operations
Comparisons
Aggregations
Temporal Types
Input and Output
Constructors
Conversions
Accessors
Transformations
Modifications
Restrictions
Comparisons
Miscellaneous
Temporal Alphanumeric Types
Conversions
Accessors
Transformations
Restrictions
Boolean Operations
Mathematical Operations
Text Operations
Temporal Geometry Types
Functions on Geometries
Input and Output
Conversions
Accessors
Transformations
Restrictions
Spatial Reference System
Bounding Box Operations
Distance Operations
Ever and Always Relationships
Spatiotemporal Relationships
Operations for Temporal Types: Analytics Operations
Simplification
Reduction
Similarity
Extended Kalman Filter
Splitting Operations
Multidimensional Tiling
Aggregation
Temporal Poses and Pose Chains
Static Poses and Pose Chains
Pose Chain Composition
Temporal Poses and Pose Chains
OGC GeoPose v1.0 Support
Temporal Network Points
Static Network Types
Temporal Network Points
Temporal Circular Buffers
Static Circular Buffers
Temporal Circular Buffers
Temporal Rigid Geometries
Input and Output
Constructors
Conversions
Accessors
Traversed Area
Spatial Functions
Motion Metrics
Transformations
Modifications
Restrictions
Distance Operations
Similarity
Bounding Box Operations
Ever and Always Relationships
Spatiotemporal Relationships
Comparisons
Tiles
Bounding Boxes
Aggregations
Temporal JSON
JSONB Set Operations
Input and Output
Constructors
Conversions
Accessors
Transformations
Temporal JSON Operations
Restrictions
Bounding Box Operations
Comparisons
Aggregations
Temporal Cell Index Types
Input and Output
Constructors
Conversions
Accessors
Transformations
Modifications
Restrictions
Static Geometry Coverage
Inspection
Hierarchy
Latitude and Longitude Conversions
Bounding Box Operations
Metric Functions
Set-Returning Functions
Ever and Always Relationships
Spatiotemporal Relationships
Comparisons
Aggregations
H3-Specific Operations
QUADBIN-Specific Operations
S2-Specific Operations
Temporal Point Clouds
Point Cloud Schemas
Static Point Clouds
Point Cloud Sets
Point Cloud Bounding Boxes
Temporal Point Cloud Points
Temporal Point Cloud Patches
Aggregations
Indexes
Raster Sampling
Sampling Operator
Raster Accessors
Raquet / QUADBIN Sampling
Raquet Serialization
Raquet Accessors and Comparison
Restriction and Predicate Operators

MobilityDB Types

MobilityDB defines four template types that act as type constructors over base types. These template types are set, span, spanset, and temporal. Table A.1, “MobilityDB current instantiations of template types” shows the types defined over these template types. Furthermore, MobilityDB defines two bounding box types, namely, tbox and stbox.

Table A.1. MobilityDB current instantiations of template types

Base TypesTemplate Types
setspanspansettemporal
booltbool
texttextsetttext
jsonbjsonbsettjsonb
integerintsetintspanintspansettint
bigintbigintsetbigintspanbigintspansettbigint
floatfloatsetfloatspanfloatspansettfloat
datedatesetdatespandatespanset
timestamptztstzsettstzspantstzspanset
geometrygeomsettgeompoint, tgeometry
geographygeogsettgeogpoint, tgeography
poseposesettpose, trgeometry
posechainposechainsettposechain
npointnpointsettnpoint
cbuffercbuffersettcbuffer
h3indexh3indexsetth3index
quadbinquadbinsettquadbin
s2cells2cellsetts2cell
pcpointpcpointsettpcpoint
pcpatchpcpatchsettpcpatch