Show filters Hide filters

Refine your search

Publication Year
1-2 out of 2 results
Change view
  • Sort by:
23:33 FOSS4G, Open Source Geospatial Foundation (OSGeo) English 2014
Found in:

Gimme some YeSQL ! - and a GIS -

So long NoSQL, here is YeSQL !Not long ago, PostgreSQL was the the most advanced OpenSource relational database. With the latest version 9.4, it became an over-powerful mutant : the most advanced OpenSource Object-Oriented relational and/or non-relational, Spatial, SQL and/or NoSQL database. For the sake of simplicity, let us call it a YeSQL database.This presentation will introduce you to the feature galore of PostgreSQL, giving insights into the latest improvements from a user point of view. Of course some GIS inclination will drive this talk, and show you how you can take advantage of spatial extensions together with PostgreSQL core features.PostgreSQL 9.4 is an important milestone for various reason : a lot of new outstanding features, and core improvements which prefigure a whole world of new use cases. The main feature from a user perspective, giving PostgreSQL this YeSQL title, is probably the new JSONB storage. A fine marriage between the Hstore extension and JSON support, it literally transforms PostgreSQL into a document database (think MongoDB in PostgreSQL without data losses).We will therefore present great PostgreSQL 9.4 features, and some ways to use them with spatial data, leveraging the latest PostGIS and PointCloud extensions :* Exclusion constraints* KNN search* Lateral joins* Window functions* (writeable) (recursive) CTE* Automatic updateable views* Materialized views* JSON, more JSON, JSON indexing, JSON proceduresÉ* Foreign Data Wrappers* Logical decoding and future applications* More JSON ? GeoJSON ?The feature set available to PostgreSQL users is growing with every release, as are performances. And the spatial part of it is not lagging behind. It is a must-use platform for data management, data infrastructures. And a GIS.
  • Published: 2014
  • Publisher: FOSS4G, Open Source Geospatial Foundation (OSGeo)
  • Language: English
23:24 FOSS4G, Open Source Geospatial Foundation (OSGeo) English 2014
Found in:

OpenSource GIS surveying - water application

It became possible lately to deploy a full OpenSource application stack for field surveying. This presentation describes a water distribution and waste-water management project from a technical point of view, with a strong integration of mobile tools within an industrialized GIS.This projects features a GIS part, with a centralized reference data storage leveraging PostgreSQL/PostGIS, and uses QGIS as a user interface. This combination allows to manage custom data with high volumes efficiently. The project also includes an important mobile side. Implemented on a rugged tablet, a custom tool has been setup to capture and enrich field data. The software is based on ROAM, a new OpenSource software designed for field survey. The tablet is connected on a 3G/4G network and takes advantage of a GNSS antenna to increase GPS precision. It also features an autonomous offline data management module, so as to be able to work in bad network access conditions. The tablet also embeds all required data for greater efficiency. One specificity of this project is the implementation of a synchronization tool between the data used in mobile situation and the reference data, in a multi-user environment.This synchronization tool, developed with PostGIS and SpatiaLite, let users manage data history, data modifications, data merges, offline mode, as well as branches, for parallel versions of the same data. The latter enables the design of evolution scenarios of the network. A classic issue of the surveying work in mobile situation is therefore solved, being able to work in a disconnected mode with multiple land surveying teams smoothly, while keeping data traceability.The project currently evolves towards water simulation integration, interconnection with SCADA industrial systems, and sensor data automated integration (through webservices).All These components therefore constitute a full software package, fully opensource. The various components can be used for other applications than water management. The new features developed thanks to this project can solve mobile GIS issues, and optimize the TCO of GIS solutions for industrial projects, for real-world critical applications.
  • Published: 2014
  • Publisher: FOSS4G, Open Source Geospatial Foundation (OSGeo)
  • Language: English
out of 1 pages


   58 ms - page object
   21 ms - search
   29 ms - highlighting
   29 ms - highlighting/31592
   26 ms - highlighting/31604


AV-Portal 3.8.0 (dec2fe8b0ce2e718d55d6f23ab68f0b2424a1f3f)