[postgis-tickets] r14818 - r?\195?\169mi cura, user story for the web

nicklas.aven at jordogskog.no nicklas.aven at jordogskog.no
Mon Apr 4 12:39:37 PDT 2016


Author: nicklas
Date: 2016-04-04 12:39:37 -0700 (Mon, 04 Apr 2016)
New Revision: 14818

Added:
   web/_content/posts/2016/04-04_remi_cura.html
Log:
r?\195?\169mi cura, user story for the web

Added: web/_content/posts/2016/04-04_remi_cura.html
===================================================================
--- web/_content/posts/2016/04-04_remi_cura.html	                        (rev 0)
+++ web/_content/posts/2016/04-04_remi_cura.html	2016-04-04 19:39:37 UTC (rev 14818)
@@ -0,0 +1,30 @@
+--- 
+title: Rémi Cura, Phd and power usage 
+layout: post 
+category: casestudy
+tags: [academic, phd, power usage]
+author: Rémi Cura 
+---
+
+I used extensively postgis (+ecosystem) for my phd thesis, in several ways.
+The first is that PostGIS is a good steady horse (elephant?):
+a database is the perfect place to store a lot of very different information in the same place and put them in relation.
+For geospatial data, postgis means you always have a way to put data in relation (are they at the same place?).
+
+<!-- pagebreak -->
+
+1. So we have a vehicle with lots of sensors (camera, lidar, gps, etc.)
+Postgis is the perfect candidate to store metadata of all of this.
+For instance I would store the image position, the lidar points using pgpointcloud, the trajectory, the metadata,etc.
+Postgis advanced linear referencing capabilities means its possible to deal with the temporal aspect of the data as well.
+
+2. Second usage is PostGIS ecosystem.
+Postgis has a strong ecosystem, and that alone is a very good reason to use it. This ecosystem is even wider because so many tools can read/write into PostGIS.
+I mentionned pgpointcloud, but postgis_topology is the base of my work, and I also used pgrounting to perform graph analysis and road network reconstruction, and postgis raster to store and use some aerial images, as well as postgres extension (text analysis).
+
+3. Third usage : power user
+Now for the advanced part, postgis is so reliable and flexible it can be abused to perform all sort of nice things, especially in the field of automatism.
+In my phd I perform road generation for Paris fully in base, with a lot of call to postgis geometrical functions.
+
+Furthermore, PostGIS + trigger + any GIS can be made into [potent interactive system](https://www.youtube.com/watch?v=grlkUvvSf3w&t=5m36s)
+, and because of the whole transaction stuff, multi user [is facilitated](http://remi-c.github.io/interactive_map_tracking/).



More information about the postgis-tickets mailing list