Geospatial
MobilityDB
Managing mobility data in PostGIS
MobilityDB is an open source moving object database system (https://github.com/ULB-CoDE-WIT/MobilityDB). Its core function is to efficiently store and query mobility tracks, such as vehicle GPS trajectories. It is engineered up from PostgreSQL and PostGIS, providing spatiotemporal data management via SQL. It integrates with the postgreSQL eco-system allowing for complex architectures such as mobility stream processing and cloud deployments.
The presentation will explain the architecture of MobilityDB, its database types, indexes, and operations. An end to end example will be demonstrated, starting with data preparation, loading, transformation, querying, until visualization. This presentation will be of special interest to the PostgreSQL community, and to professionals in the transportation domain.
This presentation will build on our talks in PGConf.ru 2019, and FOSS4G Belgium 2019.
MobilityDB is an open source PostgreSQL extension that adds support for temporal and spatio-temporal objects to the PostgreSQL and PostGIS. MobilityDB implements the Moving Features specification from the Open Geospatial Consortium (OGC).
Features:
- Time types: Period, PeriodSet, and TimestampSet which, in addition of the the TimestampTz type provided by PostgreSQL, are used to represent time spans.
- Temporal types: tbool, tint, tfloat, and ttext which are based on the bool, int, float, and text types provided by PostgreSQL and are used to represent basic types that evolve on time.
- Spatio-temporal types: tgeompoint and tgeogpoint which are based on the geometry and geography types provided by PostGIS (restricted to 2D or 3D points) and are used to represent points that evolve on time.
- Range types: intrange and floatrange which are used to represent ranges of int and float values.
All these types have associated an extensive set of functions and operators. GiST and SP-GIST index support for these types are also provided.
Additional information
| Type | devroom |
|---|
More sessions
| 2/2/20 |
Project Name: Data Analysis and statistical tool suite (GSoC 2017) The primary goal of my project was to create OAT(Data analysis and statistics) extension in RESTFul Web API and OAT extension having data analysis and statistical tools for istSOS which is being used to automate the creation of statisticate documents using OAT library (FREEWAT) and harvesting the data from an istSOS server. Project Name: istSOS - Support of unit of conversion in istsos3 (GSoC 2018) The aim of my project primarily ...
|
| 2/2/20 |
The talk introduces STAC, the SpatioTemporal Asset Catalog specification. It aims to enable a cloud-native geospatial future by providing a common layer of metadata for better search and discovery. It is an emerging open standard to catalog and expose geospatial data from different sources either in a static or dynamic way. We’ll cover the core set of metadata fields for STAC Catalogs, Collections, and Items first, along with available extensions for describing different types of data (EO, ...
|
| 2/2/20 |
openEO is a new API specification for Earth Observation data cubes that supports data extraction, processing and viewing. Both the standard and its implementations are Open Source projects, which itself rely on Open Source libraries under the hood, such as GRASS GIS, GDAL, Geotrellis, Rasdaman, or provide a standardized interface to proprietary systems such as Google Earth Engine. Client implementations are available for JavaScript, R, Python, QGIS and web browsers. This talk will show an ...
|
| 2/2/20 |
GeoServer Basics Welcome to GeoServer, a popular web service for publishing your geospatial data using industry standards for vector, raster and mapping. Are you just getting started with GeoServer, or considering it for the first time? This presentation is here to help, introducing the basics of: Usage: Concepts used to connect to your data and publish as a spatial service. Context: What role GeoServer plays in your organization and what value the application provides. Community: How the ...
|
| 2/2/20 |
GeoNetwork Basics Welcome to GeoNetwork, a leading web service for keeping track of the spatial information used by your organization. Jody is an experienced open source community member, digging into what this technology offers, and how it is used. This presentation shares these findings with you, and touches on what makes GeoNetwork succeed: We look at what GeoNetwork is for, the business challenge it is faced with, and the amazing technical approach taken by the technology. For context we ...
|
| 2/2/20 |
So you are here at FOSDEM in Brussels. Also sightseeing? Geocaching? Tried to optimize your way along the sights or to find many caches without making it a hike? Then you've got the traveling salesman problem! Famous in computer science because finding the optimum is extremely difficult and finding good approximations can be done easily. Last year we had a talk about 3geonames.org where the Hilbert curve was mentioned to be used in name generation. When researching about this space curve it ...
|
| 2/2/20 |
Arabesque is a FLOSS web application dedicated to flow mapping and analysis. Using web technologies, it provides tools to the user to load O/D data. The user can easily modify filters parameters or add new ones. A default symbology is proposed but the user can define is own. Arabesque aims to provides a fast, lightweight framework to visualize and explore flow data with a special attention on graphics and symbology in order to produce beautiful and just flow maps. This presentation will be a ...
|
