FOSSLC is a non-profit organization that specializes in technology and know-how to record conferences with excellent quality. Click on the icons below to view great videos from communities we are actively involved with:

 

PostgreSQL

Content related to the PostgreSQL RDBMS.

LIDAR In PostgreSQL With Pointcloud

in Database, FOSS4G2013, PostgreSQL
PostgreSQL

How do you store massive point cloud data sets in a database for easy access, filtering and analysis?

Event: 
FOSS4G2013
Speaker: 
Paul Ramsey

PostGIS 2.0, the new stuff

in FOSS4G, FOSS4G2011, GIS, Programming, PostGIS, PostgreSQL, OSGeo
PostGISPostgreSQLOSGeo

Leo Hsu and Regina Obe are PostGIS spatial database consultants and are showing the latest coolest stuff in PostGIS 2.0.

Event: 
FOSS4G2011
Speaker: 
Leo Hsu
Regina Obe

Store, manipulate and analyze raster data within the PostgreSQL/PostGIS spatial database

in FOSS4G, FOSS4G2011, GIS, Programming, PostGIS, PostgreSQL, OSGeo
PostGISPostgreSQLOSGeo

Raster support is the new big feature of PostGIS 2.0. You can now store georeferenced, multiband, multiresolution, with nodata value raster coverages in the popular spatial database. A raster coverage is typically stored as a table of many tiles. You can load rasters in any format supported by GDAL and the list of raster tables is available to applications in a table named raster_columns. You can do raster/vector analysis doing intersections as you are used to do them with vector data stored in PostGIS. You can also do raster analysis in the raster way with a set of map algebra functions working one pixel at a time, on the neighborhood of a pixel, on two rasters, with expressions or custom user PL/pgSQL functions. All analysis takes nodata values into account unless specified. You can edit rasters pixel by pixel, many pixels at a time, using raster coordinates or georeferenced geometries. You can also convert PostGIS rasters to geometries or to any raster format supported by GDAL. You can also dump those rasters in the filesystem using the GDAL driver or display them in QGIS or svSIG. With raster, topology, routing and 3D capabilities, PostGIS is becoming a complete in-the-database GIS driven with the SQL language.

Event: 
FOSS4G2011
Speaker: 
Pierre Racine

Tips for the PostGIS Power User

in FOSS4G, FOSS4G2011, Video, PostGIS, PostgreSQL, OSGeo
PostGISPostgreSQLOSGeo

PostGIS, is an OGC standard spatial database system, and the most common spatial database in the world of open source geospatial. Most users of PostGIS know how to get data in and out, and to form common queries, but there is much more the database can do.

The PostGIS spatial database is a full GIS system, with a SQL interface. We will cover GIS operations like overlays and unions, database topics like partitioning and performance, spatial indexes, and core spatial database concepts like Dimensionally Extended 9 Intersection Model (DE-9IM). We will review the functionality of some obscure non-standard functions in PostGIS, and discuss new features like the "geography" type and how to use them in conjunction with existing standard functionality.

Event: 
FOSS4G2011
Speaker: 
Paul Ramsey