geodatabases

MySQL 5.7: a GIS Reborn

MySQL 5.7: a GIS Reborn

MySQL is reemerging within the spatial world in version 5.7 as we replace much of the old foundation by incorporating Boost.Geometry, by adding R-tree index support to the InnoDB engine, and by adding a number of helper functions (e.g. ST_Distance_Sphere). We’ve also begun paving the way for even more functionality moving forward, such as Projections and Geography. This video will walk ...

Read More »

PostgreSQL Performance Presentation

PostgreSQL Performance Presentation

This presentation will take a look at the performance changes in the development version of PostgreSQL. A selection of features, some proposed and some already committed, are evaluated using synthetic open source workloads. One of the workloads used is the former OSDL’s Database Test 3 that consists of business oriented ad-hob queries with concurrent data modification. Some of these proposed ...

Read More »

Magical PostGIS in three brief movements

Magical PostGIS in three brief movements

Everyone knows you can query a bounding box or even spatially join tables in PostGIS, but what about more advanced magic? This short symphony of PostGIS examples will look at using advanced features of PostGIS and PostgreSQL to accomplish surprising results: Using full text search to build a spatially interactive web form. Using raster functionality to look into the future. ...

Read More »

Writing better PostGIS queries

Writing better PostGIS queries

This presentation will demonstrate ways to take most advantage of spatial indexes, SQL constructs, and PostGIS specific functions. For these exercises we’ll be using PostGIS 2.1+ and PostgreSQL 9.3+ . We’ll demonstrate common cases people often do inefficiently. This presentation demonstrates the following 1) Various SQL constructs including ANTI join, LEFT, RIGHT, EXISTS, LATERAL, CASE clauses, aggregates 2) What common ...

Read More »

What can PostGIS do ?

What can PostGIS do ?

What can PostGIS do? What features does it have? What has changed in recent versions? What new features are upcoming in future releases? This talk will cover the history and development of the PostGIS spatial database server.

Read More »