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
* [http://www.postgresql.org/message-id/20178.1423598435@sss.pgh.pa.us 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 (hold off on talking about this until Regina comes)
** Implications / difficulties
* GEOS improvements that would help PostGIS
* Way to know/be sure a geometry is valid, without need to launch an IsValid test (SFCGAL initial purpose)
* Using FDW with PostGIS (hold off on talking about this until Regina comes)
** Functions pushdown
** Current limitations
* PostgreSQL improvements that would help PostGIS
** Parallel query, review experiments, plan and execute more (hold off on talking about this until Regina comes)
** Feed back parallel query results to pgsql-hackers
* [https://github.com/postgis/postgis/pulls Open pull requests from GitHub]
** Merge, modify, or reject
* Tickets with design implications
** https://trac.osgeo.org/postgis/ticket/2529
** https://trac.osgeo.org/postgis/ticket/3405
** https://trac.osgeo.org/postgis/ticket/3246
** https://trac.osgeo.org/postgis/ticket/3326
* Do we want to bundle example datasets w/PostGIS for docs, tutorials?
* Adding more checks to automated builds?
** valgrind (would need to add suppressions for GEOS leaks)
** gcov (identify untested or unused code paths)

== 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
* postgis/lwgeom_in_* move to liblwgeom dir (or any code that doesn't depend on Postgres?)

== 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
** st_asgml -> allow GML 3.2.1 support (not only namespace handle) http://portal.opengeospatial.org/files/?artifact_id=26765
** st_asgml (and st_geomfromgml) -> handle gml:Envelope
* 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)
** ST_KMeans -> window function - pramsey to integrate into 2.3 code base - https://github.com/pramsey/postgis/tree/kmeans

Paris Code Sprint 2016

2016-02-10T13:15:43Z

Dbaston: add organization

[[File:Logo-TOSPrint_Paris.png|600px|TOSPrint Paris 2016]]

=== Gold Sponsors ===

{| border=0 cellspacing=15 cellpadding=10
|
[[File:Logo-Oslandia.png|260px|Oslandia|link=http://www.oslandia.com/]]
 
http://www.oslandia.com/
|
[[File:Logo-CartoDB.png|360px|CartoDB|link=https://www.cartodb.com/]]
 
https://www.cartodb.com/
|
[[File:Logo-IGN.png|160px|IGN|link=http://www.ign.fr/]]
 
http://www.ign.fr/
|}

=== Silver Sponsors ===

{| border=0 cellspacing=15 cellpadding=10
|
[[File:Logo-GeoCue.jpg|260px|GeoCue|link=http://www.geocue.com/]]
 
http://www.geocue.com/
|}

=== Bronze Sponsors ===

{| border=0 cellspacing=15 cellpadding=10
|
[[File:Logo-rapidlasso.png|260px|RapidLasso|link=http://www.rapidlasso.com/]]
 
http://www.rapidlasso.com/
|
[[File:Logo-Ioda-net.png|200px|Ioda-net|link=http://www.ioda-net.ch/]]
 
http://www.ioda-net.ch/
|
[[File:Logo-Compass.png|320px|Compass|link=http://www.compass.ie/]]
 
http://www.compass.ie/
|}
{| border=0 cellspacing=15 cellpadding=10
|
[[File:Logo-Azavea.png|280px|Azavea|link=http://www.azavea.com/]]
 
http://www.azavea.com/
|
[[File:Logo-AtolCD.png|320px|AtolCD|link=https://www.atolcd.com/]]
 
https://www.atolcd.com/
|}

=== Venue Sponsor ===

{| border=0 cellspacing=15 cellpadding=10
|
[[File:Logo-Mozilla.png|320px|Mozilla Foundation|link=https://www.mozilla.org/en-US/foundation/]]
 
https://www.mozilla.org/en-US/foundation/
|}

=== Other/in-kind sponsors ===

{| border=0 cellspacing=15 cellpadding=10
|
[[File:Logo-Osgeo-fr.png|260px|OSGeo FR|link=http://osgeo.asso.fr/]]
 
http://osgeo.asso.fr/
|
[[File:OSGeo.png|260px|OSGeo|link=http://www.osgeo.org/]]
 
http://www.osgeo.org/
|}

== Purpose ==

Bring together project members to make decisions and tackle larger geospatial
problems as in previous years:

* [[Philadelphia Code Sprint 2015|Philadelphia]] (2015)
* [[Vienna Code Sprint 2014|Vienna]] (2014)
* [[Boston Code Sprint 2013|Boston]] (2013)
* [[IslandWood Code Sprint 2012|Island Wood (Seattle)]] (2012)
* [[Montreal Code Sprint 2011|Montreal]] (2011)
* [[New York Code Sprint 2010|New York City]] (2010)
* [[Toronto Code Sprint 2009|Toronto]] (2009)

== Dates and Times ==

Dates:
* Welcome event: evening of Mon, Feb 22
* Sprint: Tues, Feb 23 - Fri, Feb 26 (4 days)

== Place ==
* 16bis Boulevard Montmartre, 75009 Paris - Mozilla Foundation
* https://www.openstreetmap.org/node/2883451098
* Metro: Grand Boulevard or Richelieu Drouot

'''To be noticed: For security reason, you have to be registered (on this Wiki page) to be allowed to enter in Mozilla place.'''

== Project Plans ==
(i.e what do you wish/want/plan to work on during the sprint ?)

* [[Paris_Code_Sprint_2016_:_PostGIS_Agenda|PostGIS Agenda]]
* [[Paris Code Sprint 2016 : SFCGAL Agenda|SFCGAL Agenda]]
* [http://wiki.orfeo-toolbox.org/index.php/OSGeo_Paris_Code_Sprint_2016 OTB Agenda]
* [[Paris Code Sprint 2016 : GDAL Agenda|GDAL Agenda]]

== Participants ==

We are planning for attendance of ~50. Please add your name and the projects
you are planning to sprint and note the likeliness of your attendance.

{| style="border: solid grey 1px; width:100%" class="sortable"
|+ Participants
|-
| # || Participant || Country || Organization || Arrival || Departure || Project Work on || Attendance / Notes
|-
| 1 || [[User:Olivier.courtin|Olivier Courtin]] || FR || Oslandia || first day || last day || PostgreSQL/PostGIS || Definite
|-
| 2 || [[User:kalxas|Angelos Tzotsos]] || GR || Remote Sensing Laboratory, NTUA || first day || last day || OSGeo-Live, pycsw, OTB || Booked
|-
| 3 || [[User:Schpidi|Stephan Meissl]] || AT || Eox ||first day || last day || MapServer || Booked
|-
| <s> # </s> || <s>Markus Schütz</s> || <s>AT</s> || || <s>first day</s> || <s>last day</s> || <s>Potree</s> || <s>Interested but unlikely</s> can't make it :(
|-
| 4 || [[User:msmitherdc|Michael Smith]] || US || US Army Corps of Engineers || first day || last day || PDAL / MapServer || Booked - Hotel Aston
|-
| 5 || [[User:hobu|Howard Butler]] || US || Hobu || first day || last day || PDAL / MapServer || Booked
|-
| 6 || [[User:lucadelu|Luca Delucchi]] || IT || Fondazione Edmund Mach || first day || last day || GRASS, OSGeo-Live || Booked
|-
| 7|| [[User:rouault|Even Rouault]] || FR || Spatialys || first day || last day || GDAL, MapServer, Proj.4? || Definite
|-
| 8 || [[User:mloskot|Mateusz Łoskot]] || PL || CadCorp || first day || last day || GDAL, PostGIS || Highly likely
|-
| 9|| [[User:dmorissette|Daniel Morissette]] || CA || MapGears || first day || last day || MapServer, GDAL/OGR || Booked
|-
|<s> # </s>|| <s>[[User:ianturton|Ian Turton]]</s>||<s>UK</s>|| || <s>first day</s>|| <s>last day</s> || <s>GeoTools, GeoServer, GeoNetwork? </s>|| <s>likely if any others from Java tribe appear</s> Have to work :-(
|-
| 10|| [[User:Aandre|Adrien André]]|| FR || || first day|| last day || GRASS || Very likely
|-
| 11 || Jérémy Gaillard || FR || Oslandia || first day || last day || Cesium buildings || Definite
|-
| 12|| [[User:Tbonfort|Thomas Bonfort]]|| FR || Terriscope || first day|| last day || MapServer || Definite
|-
| 13|| [[User:VincentP|Vincent Picavet]] || FR || Oslandia || first day|| last day || PostGIS/3D viz & streaming || Definite
|-
| 14|| [[User:Mhugo|Hugo Mercier]] || FR || Oslandia || first day|| last day || PostGIS/SFCGAL || Definite
|-
| 15|| [[User:Vmo|Vincent Mora]] || FR || Oslandia || first day|| third day || PostGIS/SFCGAL, Cesium building || Definite
|-
| 16|| [[User:Oscarmartinezrubi|Oscar Martinez Rubi]] || SP || Netherlands eScience Center|| first day|| last day || Potree / PDAL || Booked
|-
| 17|| Maarten van Meersbergen || NL || Netherlands eScience Center || first day|| last day || Potree / PDAL || Booked
|-
| 18|| Andrew Bell || US || || first day|| last day || PDAL || Booked
|-
| 19|| Martin Isenburg || DE || RapidLasso || first day|| last day || LASzip / QGIS || Booked
|-
| 20|| Connor Manning || US || || first day|| last day || PDAL/Potree || Booked
|-
|21|| Victor Poughon||FR|| CNES || first day||third day||Orfeo-toolbox||Booked
|-
|22|| Bruno Friedman||CH || Ioda-net || First day||Last day||Mapserver, Postgis, Potree||Definite
|-
|23|| Julien Enselme||FR|| Ioda-net || First day||Last day||Mapserver, Postgis, Potree||Definite
|-
|24|| Yann Chemin || FR || IWMI || first day || last day || GRASS || Definite
|-
|25|| [[User:remanuele|Rob Emanuele]] || US || Azavea || first day || last day || GDAL (https://git.io/vzZQJ) || Likely
|-
|26|| Paul Blottiere || FR || Oslandia || Second day || Last day || QGIS || Highly Likely
|-
|27|| Paul Ramsey || CA || CartoDB || First day || Last day || PostGIS || Booked
|-
|28|| Guillaume Pasero || FR || CS || First day || Third day || Orfeo ToolBox || Booked
|-
|29|| [[User:remic|Rémi Cura]] || FR || Thales/IGN || First day || Last Day || PostGIS?/PGPointCloud?/PDAL?/Potree? || Booked
|-
|30|| [[User:rjuju|Julien Rouhaud]] || FR || Dalibo || First day || Last Day || PostgreSQL/PostGIS || Highly Likely
|-
|31|| [[User:Sloriot|Sebastien Loriot]] || FR || GeometryFactory || Second day || Third Day || CGAL || Highly Likely
|-
|32|| Ronan Dunklau || FR || Dalibo || First day || Last Day || PostgreSQL/PostGIS || Highly Likely
|-
|33|| Tom van Tilburg || NL || Geodan || First day || Last Day || PostGIS (docs)/pgpointcloud || Booked
|-
|34|| Dan Baston || US || Maponics || First day || Last Day || PostGIS || Booked
|-
| 35 || [[User:Larss|Lars Schylberg]] || SE || Saab AB || First day || Last day || MapServer(doc/demo) || Booked - Hotel Astotel
|-
|36|| Maxence Ahlouche || FR || || First day || Last Day || PostgreSQL/PostGIS || Highly Likely
|-
|37|| Fabian Schindler || AT || Eox || First day || Last Day || MapServer/EOxServer || Highly Likely
|-
|38|| [[User:Lars|Lars Lingner]] || DE || || First day || Last Day || MapServer/(doc/demo/translation) || Booked
|-
|39|| Seth Girvin || IR || Compass || First day || (At least) Second Day || MapServer || Highly Likely
|-
|40|| Mickael Borne || FR || IGN || First day || Last Day || PostGIS/SFCGAL || Definite
|-
|41|| Guiseppe Broccolo || IT || 2nd Quadrant || First day || Last Day || PostgreSQL/PostGIS || Highly Likely
|-
|42|| [[User:Marcu|Marc Ducobu]] || BE || Champs Libre || First day || Last Day || PostgreSQL/PostGIS || Highly Likely
|-
|43|| Paul Norman || CA || CartoDB || First day || Last Day || PostgreSQL/PostGIS || Booked
|-
|44|| Nicolas Ribot || FR || || First day || Last Day || PostgreSQL/PostGIS || Highly Likely
|-
|45|| Mathieu Brédif || FR || IGN || First day || 2nd Day (at least) || PGPointCloud/Potree/itowns || Definite
|-
|46|| Quoc Dinh Nguyen || FR || IGN || First day || Last Day || Potree/itowns || Definite
|}

== Communication ==

* Please join the mailing list: http://lists.osgeo.org/mailman/listinfo/tosprint
* IRC chat during the event: #tosprint Server: irc.freenode.net
* Twitter: #TOSprint ( https://twitter.com/search?q=tosprint )

== Costs ==

Participants should plan for the following costs:

* Travel to Paris
* Accommodation for four nights (including breakfast)

All other costs - food, outings and entertainment - should/will be covered by the sponsors

== Hotel and co ==

Center of Paris is indeed quite small, the sprint place quite central, and metro network quite dense. 
So no special need to be that close from the sprint place (anywhere else in Paris could also be fine, with less than 30-45' by tube).

However, nice hotels, quite close to the sprint place:
* http://www.astotel.com/hotel/hotel-le-34b/overview
* http://www.hotel20prieure.com/

A common way to find a discounted room in Paris is to use: booking.com

Paris is also well known to became an AirBNB city. 
Could be so a way to share (big) flat, among some sprinters.

And there's also hostels, for those who want/need to find a cheaper hosting solution.
* http://www.hostelworld.com/Paris

== Sponsors ==

We have three sponsorship levels:

* Gold: >= 2500 €
* Silver: 1500 €
* Bronze: 750 €

We encourage sponsors to support nutriment and entertainment for the
sprinters as they work hard and play hard for four or five productive days.
Contributions will be put towards lunch, snacks, and dinner costs for the
sprinters, and potentially bringing in sprinters who might otherwise be unable
to attend. Any surplus at the end of the event will be turned over to OSGeo or
used for a future code sprint.

Sponsors will receive the following honors:

* Your logo at the top of this page
* Mention in all of our public communication
* Our undying gratitude, which comes in handy when you least expect it (Remember that feature you wanted...)
* And as extra, for Silver and Gold: Kakemono in the event room (if you provide it)

To sponsor, please contact Olivier Courtin (olivier dot courtin at oslandia dot com) directly.

[[Category:Code Sprints]]
[[Category:C Tribe Code Sprint]]