Difference between revisions of "Paris Code Sprint 2016 : PostGIS Agenda"

From OSGeo
Jump to navigation Jump to search
(add brin indexes subject)
Line 27: Line 27:
 
* Benchmarking of parallel query and parallel aggregate work from pgsql-hackers
 
* Benchmarking of parallel query and parallel aggregate work from pgsql-hackers
  
 +
* BRIN indexes implementation for PostGIS geometries
  
== Possible PostGIS function improvement and addition==
+
== Possible PostGIS function improvement and addition ==
  
 
* improvement
 
* improvement

Revision as of 09:00, 21 January 2016

Discussion and group review topics for the Paris Code Sprint 2016.

Discussion

  • Clustering functions: Aggregate or Window?
    • What naming convention
    • What to do with the existing aggregate functions
  • Expanded object headers, introduction and testing
    • How they work
    • Potential advantages, disadvantages
    • Discussion on clean implementation possibilities
    • Testing and benchmarks, is it worth it?
  • Alternate storage formats, beyond GSERIALIZED
    • Reasoning
    • How to add (version flags?)
    • Multiple co-existing formats?
  • Breaking raster out as postgis_raster extension
    • Implications / difficulties
  • GEOS improvements that would help PostGIS
  • PostgreSQL improvements that would help PostGIS
    • Parallel query, review experiments, plan and execute more
    • Feed back parallel query results to pgsql-hackers

Tasks

  • Benchmarking of expanded object headers test branch
  • Benchmarking of parallel query and parallel aggregate work from pgsql-hackers
  • BRIN indexes implementation for PostGIS geometries

Possible PostGIS function improvement and addition

  • improvement
    • st_pointN -> make a negative input count backward
    • st_setPoint -> make a negative input count backward
    • st_asText -> optionnal arg to limit digit number
    • st_centroid -> work on circular string (simply dump points, then classical centroid)
    • st_exteriorRing -> make it work on multipolygon, returns a collection
    • st_makeline -> make it work on multipoints
    • st_scale -> optionnal argument to define the center of scaling (allows to scale "in place")
    • st_split -> allow splitting (multi)line by (multi)point
  • slight addition
    • st_angle(P1,P2,P3)
    • st_MakeRing((multi) linestrings and/or points
    • st_DumpLines -> dump everything to line (rings in poly, lines in multilines, etc. )
    • st_DumpSegments -> dump segments (in the mathematical sense), that is every consecutive pairs of points in lines
  • big addition
    • generate grid (regular and hex)
    • st_snapToLine -> st_snap = snap vertex to vertex. This one = snap vertex to vertex or edge.
    • st_splitLineByPoint(line,point,tolerance) -> using curv absc, the only current way to not be sensible to precision issue (st_split doesnt work)
    • st_VariableBuffer(geomM) -> buffer on geometry, the radius is given by M of each vertex, linear transition between. A lots of uses
    • St_FindCurve(geom,radius_range,min_number_of_support_points,tolerance) -> in a classical geometry, find the point describing arcs
    • St_MakeArc(P1,P2,centre) and St_MakeArc(P1,P2,radius) -> create arcs (_not_ using 3 points on arc!)
    • St_OrientedBBox(geom) -> returns the oriented bbox of the geom (returns a geom and an angle)