geodatabases

Spatial Database Tips for PostGIS, Oracle, & SQL Server

Spatial Database Tips for PostGIS, Oracle, & SQL Server

Become a database dynamo with these productivity-boosting tips. Discover how to connect your spatial database with 325+ data sources – including tabular, raster and GIS – without any coding. You’ll see how to spatialize ordinary data, view it on a map, and learn about automated techniques for updates/deletes, edit/change detection, as well as data validation.

Read More »

PostGIS Feature Frenzy

PostGIS Feature Frenzy

What can you do with this PostGIS thing? This talk covers some basic and not­so­basic ways to use PostGIS/PostgreSQL to process spatial data, to build infrastructures, and to do crazy things with data. PostGIS has over 300 functions, which in turn can be used with the many features of the underlying PostgreSQL database. This talk covers some basic and not­so­basic ...

Read More »

Modern SQL in PostgreSQL

Modern SQL in PostgreSQL

SQL has gone out of fashion lately — partly due to the NoSQL movement, but mostly because SQL is often still used like 20 years ago. As a matter of fact, the SQL standard continued to evolve during the past decades resulting in the current release of 2011. In this session, we will go through the most important additions since ...

Read More »

Tracing PostgreSQL performance

Tracing PostgreSQL performance

“How could I trace a session in PostgreSQL” – this is quite a common question from an Oracle/DB2 DBA, who is new to Postgres. Usually we start to mumble something about systemtap/perf and pgstatbgwriter. Although these tools are great and useful, but they do not exactly meet this need, and besides, some of them are really difficult to use. In ...

Read More »

PostGIS function ST_buffer – using QGIS, PostGIS, and PostgreSQL

PostGIS function ST_buffer – using QGIS, PostGIS, and PostgreSQL

We will utilize the PostGIS function ST_buffer to determine which residential areas on the San Jacinto River on the downstream side would be affected by a dam breach or a substantial release from lake Conroe. We have had major flooding throughout Texas in the past few weeks and the lake Conroe dam has been getting repairs due to erosion and ...

Read More »

Mending Spatial Data with PostGIS

Mending Spatial Data with PostGIS

This presentation demonstrates common techniques to clean-up spatial data from a real-world data source. It will start with raw OSM data. Topics it’ll cover: Getting OSM data How to merge multilinestrings into single linestrings. Fill in gaps, snapping, reducing resolution Consolidating geometries with aggregate functions ST_Union, ST_MakeLine, ST_Collect based on both spatial and non-spatial attributes

Read More »

Explaining the Postgres Query Optimizer

Explaining the Postgres Query Optimizer

The optimizer is the “brain” of the database, interpreting SQL queries and determining the fastest method of execution. This talk uses the explain command to show how the optimizer interprets queries and determines optimal execution. The talk will assist developers and administrators in understanding how Postgres optimally executes their queries and what steps they can take to understand and perhaps ...

Read More »

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 »