Create a "Spatial Functions and Operators" reference page

[rmloveland]

Richard Loveland (rmloveland) commented:

We will need to let users know what spatial functions we support. There is (and will be) a list of auto-generated function docs at Geospatial functions but it's too sparse to really use unless you already know how to use them (typical auto-generated docs paradox).

Therefore, we ought to consider creating a separate page called 'Spatial Functions and Operators' that includes:

• A list showing every spatial function on this one page (yay), with links to separate pages for each function (TBD whether to have them be sections here or create separate pages -- I lean towards the former)
• Generate images of coverings, polygons, etc., a la PostGIS (STRETCH)
• Note that for 20.2, we will not have any of the geometry operators listed in https://postgis.net/docs/manual-3.0/reference.html#Operators
• Note that for 20.2, will not return correct answers to the following troubleshooting functions - Oliver says they will only return =true=:
  • PostGIS_AddBbox
  • PostGIS_DropBbox
  • PostGIS_HasBbox
  • (See bottom of https://postgis.net/docs/manual-3.0/reference.html for docs on these)
• Be sure to document the limitations of AddGeometryColumn, which are tracked in:
  • geo: AddGeometryColumn does not support use_typmod=false cockroach#49402
  • geo: AddGeometryColumn does not support non-constant arguments cockroach#49448
• The functions should be presented in the following order:
  • Indexing functions (meaning index-accelerated? I think)
  • I/O functions (AsEWKT, FromEWKT)
  • Whatever functions appear in the PostGIS tutorial (as much of it as we support)
  • ... followed by everything else

Jira Issue: DOC-623