Show filters Hide filters

Refine your search

Publication Year
1-2 out of 2 results
Change view
  • Sort by:
24:04 FOSS4G, Open Source Geospatial Foundation (OSGeo) English 2015

PostgreSQL, batteries included

This presentations presents some advanced features of PostgreSQL involving third party tools integrated directly into the database, and allowing for more features, especially for spatial data management. PostgreSQL is a very versatile RDBMS, and has a lot of core features. What is less known is that it can be used as a data platform, integrating external modules to further expand the capabilities of data management. First of all, some contrib PostgreSQL modules of interest are shown, useful for geocoding : pg trgm allows for trigram indexing and search, allowing string comparison with a tolerance to typo errors fuzzystrmatch also allows fuzzy string comparison directly inside the database using soundex algorithms FTS, aka Full Text Search, is a powerful text indexing and search mechanism right inside PostgreSQL Then, we show the Foreign Data Wrapper tools, which allow access to and from remote data. oracle fdw now supports Oracle Spatial and PostGIS natively, and let you exchange data in heterogeneous systems ogr fdw is a foreign data wrapper dealing with OGR data sources : access all these vector data files directly from your spatial database Foreign Data Wrapper really makes PostgreSQL a data platform, enabling easy import and export of data, migration plan, and transparent heterogeneous data systems. Last, we present some advanced data processing capabilities using PostgreSQL development languages. Pl/R lets you leverage the power of the R statistics framework to do advanced analysis of your spatial data Pl/Py put all Python modules at your disposal, with unlimited power for data processing, communication and interaction with external systems All these tools, usually less known than PostgreSQL and PostGIS bulk features, further improve the data platform, with high connectivity and interoperability, and almost unlimited features in terms of data processing. PostgreSQL, PostGIS, and -free- batteries included !
  • Published: 2015
  • Publisher: FOSS4G, Open Source Geospatial Foundation (OSGeo)
  • Language: English
22:37 FOSS4G, Open Source Geospatial Foundation (OSGeo) English 2015

3D OpenSource software Stack

This presentations showcases the latest advances on building a full 3D Open Source GIS software stack.Some important cities have recently released their 3D models of textured buildings as Open Data : Bordeaux and Lyon in France, Geelong in Australia or Berlin in Germany among others. Meanwhile, new hardware and sensors for 3D data capture and interaction. We want to be able to store, analyze and visualize both 2D and 3D data with same Open Source tools.Among the processing we want to use 3D intersection, 3D Union, triangulation and a lot of other spatial analysis functions we already use in 2D. Other types of 3D data also need to be stored and processed like 3D Point clouds from Lidar data, or DEMs.With 3D data, an absolute must-have is a nice, fast and smooth rendering of features, and their associated textures. Visualization is a key element of a complete vertical software stack of 3D data management.This presentation will demonstrate the ability to setup and take advantage of a full FOSS4G 3D stack. This stack features various components, just like a 2D GIS stack.PostgreSQL and PostGIS now feature 3D data storage and processing GIS servers can now stream the data with Web Services Desktop applications allows 3D visualization ( QGIS and Horao plugin) WebGL application let the user configure a native browser 3D visualization These components improve over time, allowing more capabilities, be it for the analysis part in the database, or the visualisation part in the browser.
  • Published: 2015
  • Publisher: FOSS4G, Open Source Geospatial Foundation (OSGeo)
  • Language: English
out of 1 pages


   35 ms - page object
   20 ms - search
    0 ms - highlighting
    0 ms - highlighting/32057
    0 ms - highlighting/32121


AV-Portal 3.7.0 (943df4b4639bec127ddc6b93adb0c7d8d995f77c)