Google Season of Docs 2019

This page captures ideas and accomplishments for the PostGIS submission to the ​Google Season of Docs 2019.

PostgreSQL is also participating (​wiki).

Mentors

• Martin Davis (Crunchy Data)
• Regina Obe (Paragon Corporation)

Documentation Project Ideas

Content style review

Sugggested by: Martin Davis

Edit all content for prose style consistency, typos, spelling mistakes, etc.

Workbooks

Suggested by: Regina Obe

How to Workbooks that walk a user thru how to use each of the core pieces of PostGIS

• Geometry / Geography - Loading data (shp2pgsql, QGIS DbManager), querying data, viewing data in various tools (OpenJump, QGIS, pgAdmin4), performance tuning
• Topology - Converting existing data into topologies, building topogeometries, viewing data, and querying data
• Raster - Deciding on tiles sizes, Loading raster data with raster2pgsql, querying raster data alone, raster / geometry queries, converting raster to geometry, viewing raster data in QGIS

Format example SQL code and output

Suggested by: Darafei Praliaskouski

There are separate tags for screen output and SQL program listings. If we fix input to have no output then formatting can be applied to it, getting syntax highlighted and other validations.

• Syntax highlighting requires Java toolchain?
• Also format comments as lineannotation, or move into outside para
• Ensure SQL code uses spaces instead of tabs, and is wrapped so it doesn't scroll

Improve Docbook source formatting

Suggested by: Sandro Santilli

Format source to have 80-column limit, for better diffs

References

• ​Current documentation (generated from SVN trunk)
• ​Documentation tickets