geodatabases

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 »

Tutorial Postgresql : Créer une table au sein d’une base de données

Tutorial 10 : Création d'une base de données

La création de table permet l’incorporation de données numérique ou textuelles. C’est à partir des tables que l’on définit les clés primaires et étrangères, les modalités de sélection des données… La maitrise de Postgresql permet un gain de temps considérable dans le choix des données en vu de l’analyse de données.

Read More »