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:

 

OSGeo

Content related to the Open Source Geospatial (OSGeo) Foundation, Projects, and Community.

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

PostGIS Replication

in FOSS4G, FOSS4G2011, Video, OSGeo
OSGeo

Database replication allows you to distribute spatial queries to multiple servers increasing the scalability and fault-tolerance of your database.

Two popular methods of replicating PostGIS databases are PostgreSQL 9.0's hot-standby replication and the Slony-I replication system. This talk will explain why you want to replicate your PostGIS databases and provide an overview of both Slony-I and hot-standby. The talk will explain the key features and limitations of each and help you choose which technology is appropriate for your situation.

 

Event: 
FOSS4G2011
Speaker: 
Steve Singer

Tutorial: PyWPS

in FOSS4G, FOSS4G2011, Video, OSGeo
OSGeo

WPS is a Python implementation of OGC's WPS 1.0.0 protocol on the server side. PyWPS development started in 2006 and was first presented in FOSS4G 2006 at Lausanne. Originally it was written with direct support for GRASS GIS modules, however it is not limited to GRASS only, any sort of GIS functionality written in Python will be served as a WPS. PyWPS distribution does not include any processes by default. The user has to program his or her custom ones and add them to PyWPS instance. The tutorial will start by focusing on installation and configuration of PyWPS on the server, how to construct custom WPS processes with help of GRASS GIS, GDAL/OGR, R and Shapely, to deploy custom process into a PyWPS instance. First part will conclude with examples covering basic logging while the process is running and debugging of non working processes. Second part, will be web oriented presenting PyWPS's Java Script based WPS client (using OpenLayers web mapping library), that is able to parse Capabilities and ProcessDescription documents from WPS server, generating an HTML form for input data. After submitting the form with all inputs set, Execute operation on given data is then requested and the final response will be displayed on the map. To conclude the tutorial, special features of PyWPS will be demonstrated, like running PyWPS in Java environment, using Jython as Python interpreter and Apache Tomcat as server. PyWPS together with UMN MapServer - how to make data outputs from PyWPS to be accessed using standard OGC OWS services from the client, so that the resulting maps can be (for example) downloaded with OGC WCS to local disc or displayed in mapping application with OGC WMS directly, service orchestration will be demonstrated and explained using PyWPS's WSDL process interface using Taverna workbench. Finally a special focus will be given to the new WPS-GRASS bridge interface that allows easy porting of GRASS processes into PyWPS, and integration into QGIS WPS plugin.

Event: 
FOSS4G2011
Speaker: 
Jachym Cepicky

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