Bocher Erwan

ST_MapAlgebra

1

Write an operator plus a function to execute map algebra syntax on a raster. The idea is to use the ScriptEngine api of Java into JAI operator. The JAI syntax...

Add a function to enhance the spatial resolution of a composite georaster. See http://www.lac.inpe.br/JIPCookbook/6320-howto-pansharpening.jsp

ST_GeneratePoints

1

Add postgis function ST_GeneratePoints https://postgis.net/docs/ST_GeneratePoints.html

Implements the ST_SnapToGrid function to reduce the geometry precision.

ST_FillSinks

2

Must be re-implemented using the same approach than ST_D8FlowAccumulation.

Hydrological functions optimization

2

The idea is to find a better way to improve the flow accumulation and watershed functions that are slow.

GeoTIFF reader and writer

4

Implement a Geotiff driver to read and write GeoTIFF file.

ST_WorldFileImageWrite

4

ST_WorldFileImageWrite will have the following signature ``` sql ST_WorldFileImageWrite(RASTER, '/tmp/toto.png') ``` Usages ``` sql SELECT ST_WorldFileImageWrite(the_raster, '/tmp/toto.png') from myRasterTable limit 1; ``` ``` sql SELECT ST_WorldFileImageWrite(the_raster,concat( concat( '/tmp/toto_', pkValue), '.png'))...

ST_WorldFileImageRead

1

ST_WorldFileImageRead is used to read an image with its world file (ESRI representation). The function will have the following signature ``` sql ST_WorldFileImageRead( 'filePath') ST_WorldFileImageRead( 'filePath', 'tableName') ``` Usages ```...

Set 6 georeference parameters in a single call to a Raster data type. The signature will be ``` sql raster ST_SetGeoReference(raster rast, double precision upperleftx, double precision upperlefty, double precision...