You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@sedona.apache.org by pa...@apache.org on 2026/06/02 20:45:33 UTC

(sedona-db) branch main updated: feat(docs/reference/sql): Ensure geography functions are documented (#895)

This is an automated email from the ASF dual-hosted git repository.

paleolimbot pushed a commit to branch main
in repository https://gitbox.apache.org/repos/asf/sedona-db.git


The following commit(s) were added to refs/heads/main by this push:
     new c85b48529 feat(docs/reference/sql): Ensure geography functions are documented (#895)
c85b48529 is described below

commit c85b48529b1fc8409d642fb2745818afc3da8448
Author: Dewey Dunnington <de...@dunnington.ca>
AuthorDate: Tue Jun 2 15:45:27 2026 -0500

    feat(docs/reference/sql): Ensure geography functions are documented (#895)
---
 .../{st_boundary.qmd => s2_cellidfrompoint.qmd}    | 12 ++++----
 .../{st_dimension.qmd => s2_coveringcellids.qmd}   | 22 +++++--------
 docs/reference/sql/st_analyze_agg.qmd              | 12 ++++++--
 docs/reference/sql/st_area.qmd                     | 14 ++++++---
 docs/reference/sql/st_asbinary.qmd                 |  8 +++--
 docs/reference/sql/st_astext.qmd                   |  6 ++++
 docs/reference/sql/st_boundary.qmd                 | 10 ++++--
 docs/reference/sql/st_buffer.qmd                   | 36 ++++++++++++++++++++--
 docs/reference/sql/st_centroid.qmd                 | 18 +++++++++--
 docs/reference/sql/st_contains.qmd                 |  9 ++++++
 docs/reference/sql/st_convexhull.qmd               | 12 ++++++--
 docs/reference/sql/st_difference.qmd               |  9 ++++++
 docs/reference/sql/st_dimension.qmd                |  6 ++--
 docs/reference/sql/st_disjoint.qmd                 | 15 +++++++--
 docs/reference/sql/st_distance.qmd                 | 10 ++++--
 docs/reference/sql/st_dwithin.qmd                  | 26 +++++++++++++---
 docs/reference/sql/st_envelope.qmd                 | 30 ++++++++++++++++--
 docs/reference/sql/st_equals.qmd                   |  9 ++++++
 docs/reference/sql/st_force2d.qmd                  |  8 ++++-
 docs/reference/sql/st_force3d.qmd                  | 11 +++++--
 docs/reference/sql/st_force3dm.qmd                 | 11 +++++--
 docs/reference/sql/st_force4d.qmd                  | 20 +++++++++++-
 docs/reference/sql/st_geometryn.qmd                | 16 ++++++++--
 docs/reference/sql/st_geometrytype.qmd             |  6 ++--
 docs/reference/sql/st_geomfromwkt.qmd              |  1 +
 docs/reference/sql/st_interiorringn.qmd            | 15 +++++++++
 docs/reference/sql/st_intersects.qmd               | 15 +++++++--
 docs/reference/sql/st_isclosed.qmd                 | 10 +++---
 docs/reference/sql/st_iscollection.qmd             |  8 +++--
 docs/reference/sql/st_isempty.qmd                  |  8 +++--
 docs/reference/sql/st_length.qmd                   | 12 ++++++--
 docs/reference/sql/st_lineinterpolatepoint.qmd     | 13 ++++++--
 docs/reference/sql/st_linelocatepoint.qmd          |  8 ++---
 docs/reference/sql/st_linemerge.qmd                |  9 ++++++
 docs/reference/sql/st_maxdistance.qmd              | 14 ++++++---
 docs/reference/sql/st_mmax.qmd                     | 10 ++++--
 docs/reference/sql/st_mmin.qmd                     | 11 +++++--
 docs/reference/sql/st_normalize.qmd                | 19 +++++++++---
 docs/reference/sql/st_npoints.qmd                  | 24 +++++++++++++--
 .../sql/{st_dimension.qmd => st_nrings.qmd}        | 18 +++++------
 docs/reference/sql/st_numgeometries.qmd            | 10 ++++--
 .../{st_dimension.qmd => st_numinteriorrings.qmd}  | 18 +++++------
 .../sql/{st_dimension.qmd => st_numpoints.qmd}     | 32 +++++++++++++------
 docs/reference/sql/st_perimeter.qmd                | 12 ++++++--
 docs/reference/sql/st_pointn.qmd                   | 11 ++++++-
 .../{st_convexhull.qmd => st_pointonsurface.qmd}   | 15 ++++-----
 docs/reference/sql/st_points.qmd                   | 10 ++++--
 .../{st_segmentize.qmd => st_reduceprecision.qmd}  | 23 ++++++--------
 docs/reference/sql/st_reverse.qmd                  | 10 ++++--
 docs/reference/sql/st_segmentize.qmd               | 19 +++++++++---
 docs/reference/sql/st_simplify.qmd                 | 24 +++++++++++----
 docs/reference/sql/st_symdifference.qmd            | 15 +++++++--
 docs/reference/sql/st_union.qmd                    | 15 +++++++--
 docs/reference/sql/st_within.qmd                   | 13 ++++++--
 docs/reference/sql/st_x.qmd                        |  9 ++++--
 docs/reference/sql/st_xmax.qmd                     | 10 ++++--
 docs/reference/sql/st_xmin.qmd                     | 10 ++++--
 docs/reference/sql/st_y.qmd                        |  8 ++++-
 docs/reference/sql/st_ymax.qmd                     | 13 +++++++-
 docs/reference/sql/st_ymin.qmd                     | 13 +++++++-
 docs/reference/sql/st_zmax.qmd                     | 10 ++++--
 docs/reference/sql/st_zmin.qmd                     | 10 ++++--
 62 files changed, 643 insertions(+), 198 deletions(-)

diff --git a/docs/reference/sql/st_boundary.qmd b/docs/reference/sql/s2_cellidfrompoint.qmd
similarity index 66%
copy from docs/reference/sql/st_boundary.qmd
copy to docs/reference/sql/s2_cellidfrompoint.qmd
index 87038ee6c..50abee883 100644
--- a/docs/reference/sql/st_boundary.qmd
+++ b/docs/reference/sql/s2_cellidfrompoint.qmd
@@ -16,19 +16,19 @@
 # specific language governing permissions and limitations
 # under the License.
 
-title: ST_Boundary
-description: Returns the closure of the combinatorial boundary of this Geometry.
+title: S2_CellIdFromPoint
+description: Returns the S2 cell ID containing the given point geography at the maximum S2 level (30).
 kernels:
-  - returns: geometry
-    args: [geometry]
+  - returns: int64
+    args: [geography]
 ---
 
 ## Description
 
-For a polygon, the boundary is the exterior and interior rings; for a linestring it is the endpoints.
+Returns the 64-bit S2 cell ID at level 30 (the finest resolution) that contains the given point geography. Returns NULL for empty point geometries. This is useful for spatial indexing and efficient spatial queries.
 
 ## Examples
 
 ```sql
-SELECT ST_Boundary(ST_GeomFromWKT('POLYGON((1 1,0 0, -1 1, 1 1))'));
+SELECT S2_CellIdFromPoint(ST_GeogPoint(-64, 45));
 ```
diff --git a/docs/reference/sql/st_dimension.qmd b/docs/reference/sql/s2_coveringcellids.qmd
similarity index 56%
copy from docs/reference/sql/st_dimension.qmd
copy to docs/reference/sql/s2_coveringcellids.qmd
index acad06b09..499839e7b 100644
--- a/docs/reference/sql/st_dimension.qmd
+++ b/docs/reference/sql/s2_coveringcellids.qmd
@@ -16,29 +16,21 @@
 # specific language governing permissions and limitations
 # under the License.
 
-title: ST_Dimension
-description: Returns the dimension of the geometry.
+title: S2_CoveringCellIds
+description: Returns an array of S2 cell IDs that cover the given geography.
 kernels:
-  - returns: integer
-    args: [geometry]
+  - returns: array
+    args: [geography]
 ---
 
 ## Description
 
-Returns the inherent dimension of the geometry:
+Returns an array of 64-bit S2 cell IDs that form a covering of the given geography. A covering is a set of cells that completely contains the geography with minimal overlap. For a point, returns an array with a single cell ID. For empty geometries, returns an empty array.
 
-- 0 for points or multipoints
-- 1 for linestring or multilinestrings
-- 2 for polygons or multipolygons
-
-For geometry collections, returns the largest dimension among the components.
+This is useful for spatial indexing and efficient spatial queries. The returned cells may be at different S2 levels depending on the size and shape of the geography.
 
 ## Examples
 
 ```sql
-SELECT ST_Dimension(ST_GeomFromWKT('POLYGON ((0 0, 1 0, 0 1, 0 0))'));
-```
-
-```sql
-SELECT ST_Dimension(ST_Point(1.0, 2.0));
+SELECT S2_CoveringCellIds(ST_GeogFromWKT('LINESTRING (0 0, 1 1)'));
 ```
diff --git a/docs/reference/sql/st_analyze_agg.qmd b/docs/reference/sql/st_analyze_agg.qmd
index 587928d89..aebd3055f 100644
--- a/docs/reference/sql/st_analyze_agg.qmd
+++ b/docs/reference/sql/st_analyze_agg.qmd
@@ -17,10 +17,12 @@
 # under the License.
 
 title: ST_Analyze_Agg
-description: Computes the statistics of geometries for the input geometry.
+description: Computes the statistics of geometries for the input geometry or geography.
 kernels:
   - returns: struct
     args: [geometry]
+  - returns: struct
+    args: [geography]
 ---
 
 ## Description
@@ -29,7 +31,7 @@ kernels:
 its struct return type are:
 
 - `count`: Number of input geometries
-- `minx`, `miny`, `maxx`, `maxy`: Minimum bounding rectangle (envelope)
+- `minx`, `miny`, `maxx`, `maxy`: Minimum bounding rectangle (envelope). For geography, this represents geographical bounds such that minx may be greater than maxx where this represents more compact bounds (e.g., a small feature crossing the antimeridian).
 - `mean_size_in_bytes`
 - `mean_points_per_geometry`
 - `puntal_count`: Number of point or multipoint geometries
@@ -47,3 +49,9 @@ SELECT ST_Analyze_Agg(
     ST_GeomFromText('MULTIPOINT(1.1 101.1,2.1 102.1,3.1 103.1,4.1 104.1,5.1 105.1,6.1 106.1,7.1 107.1,8.1 108.1,9.1 109.1,10.1 110.1)')
   ) AS analyze
 ```
+
+```sql
+SELECT ST_Analyze_Agg(
+    ST_GeogFromText('MULTIPOINT(1.1 101.1,2.1 102.1,3.1 103.1,4.1 104.1,5.1 105.1,6.1 106.1,7.1 107.1,8.1 108.1,9.1 109.1,10.1 110.1)')
+  ) AS analyze
+```
diff --git a/docs/reference/sql/st_area.qmd b/docs/reference/sql/st_area.qmd
index 496f14d15..68f4a712b 100644
--- a/docs/reference/sql/st_area.qmd
+++ b/docs/reference/sql/st_area.qmd
@@ -17,18 +17,24 @@
 # under the License.
 
 title: ST_Area
-description: Returns the area of a geometry.
+description: Returns the area of a geometry or geography.
 kernels:
-  - returns: geometry
+  - returns: double
     args: [geometry]
+  - returns: double
+    args: [geography]
 ---
 
 ## Description
 
-`ST_Area()` Returns the area of a polygon or multi-polygon geometry.
+`ST_Area()` Returns the area of a polygon or multi-polygon. For geometry, returns the area in the units of the coordinate reference system (squared); for geography, returns the area in square meters, calculated on a spherical Earth model.
 
 ## Examples
 
 ```sql
-SELECT ST_Area(ST_GeomFromWKT('POLYGON ((0 0, 10 0, 10 10, 0 10, 0 0))'));
+SELECT ST_Area(ST_GeomFromWKT('POLYGON ((0 0, 1 0, 1 1, 0 1, 0 0))'));
+```
+
+```sql
+SELECT ST_Area(ST_GeogFromWKT('POLYGON ((0 0, 1 0, 1 1, 0 1, 0 0))'));
 ```
diff --git a/docs/reference/sql/st_asbinary.qmd b/docs/reference/sql/st_asbinary.qmd
index 5b933a6bc..f87451273 100644
--- a/docs/reference/sql/st_asbinary.qmd
+++ b/docs/reference/sql/st_asbinary.qmd
@@ -17,10 +17,12 @@
 # under the License.
 
 title: ST_AsBinary
-description: Converts a geometry to Well-Known Binary (WKB) format.
+description: Converts a geometry or geography to Well-Known Binary (WKB) format.
 kernels:
-  - returns: geometry
+  - returns: binary
     args: [geometry]
+  - returns: binary
+    args: [geography]
 ---
 
 ## Description
@@ -39,5 +41,5 @@ SELECT ST_AsBinary(ST_Point(1.0, 2.0));
 ```
 
 ```sql
-SELECT sd_simplifystorage(ST_AsBinary(ST_Point(1.0, 2.0)));
+SELECT ST_AsBinary(ST_GeogPoint(1.0, 2.0));
 ```
diff --git a/docs/reference/sql/st_astext.qmd b/docs/reference/sql/st_astext.qmd
index 185c62fca..79e7e5dbe 100644
--- a/docs/reference/sql/st_astext.qmd
+++ b/docs/reference/sql/st_astext.qmd
@@ -21,6 +21,8 @@ description: Returns the Well-Known Text string representation of a geometry or
 kernels:
   - returns: string
     args: [geometry]
+  - returns: string
+    args: [geography]
 ---
 
 ## Description
@@ -32,3 +34,7 @@ Alias: `ST_AsWKT`.
 ```sql
 SELECT ST_AsText(ST_Point(1.0, 2.0));
 ```
+
+```sql
+SELECT ST_AsText(ST_GeogPoint(1.0, 2.0));
+```
diff --git a/docs/reference/sql/st_boundary.qmd b/docs/reference/sql/st_boundary.qmd
index 87038ee6c..d87ec0718 100644
--- a/docs/reference/sql/st_boundary.qmd
+++ b/docs/reference/sql/st_boundary.qmd
@@ -17,10 +17,12 @@
 # under the License.
 
 title: ST_Boundary
-description: Returns the closure of the combinatorial boundary of this Geometry.
+description: Returns the closure of the combinatorial boundary of this geometry or geography.
 kernels:
   - returns: geometry
     args: [geometry]
+  - returns: geography
+    args: [geography]
 ---
 
 ## Description
@@ -30,5 +32,9 @@ For a polygon, the boundary is the exterior and interior rings; for a linestring
 ## Examples
 
 ```sql
-SELECT ST_Boundary(ST_GeomFromWKT('POLYGON((1 1,0 0, -1 1, 1 1))'));
+SELECT ST_Boundary(ST_GeomFromWKT('POLYGON((1 1, 0 0, -1 1, 1 1))'));
+```
+
+```sql
+SELECT ST_Boundary(ST_GeogFromWKT('POLYGON((1 1, 0 0, -1 1, 1 1))'));
 ```
diff --git a/docs/reference/sql/st_buffer.qmd b/docs/reference/sql/st_buffer.qmd
index 9cc176e8c..f99b187ca 100644
--- a/docs/reference/sql/st_buffer.qmd
+++ b/docs/reference/sql/st_buffer.qmd
@@ -18,8 +18,8 @@
 
 title: ST_Buffer
 description: >
-    Computes a geometry that represents all points whose distance from the input
-    geometry is less than or equal to a specified distance.
+    Computes a geometry or geography that represents all points whose distance from the input
+    is less than or equal to a specified distance.
 kernels:
   - returns: geometry
     args:
@@ -38,8 +38,31 @@ kernels:
         Space-separated `key=value` parameters. Supported parameters include `quad_segs`,
         `endcap`, `join`, `mitre_limit`, and `side`. These parameters are identical to
         the PostGIS buffer parameter strings.
+  - returns: geography
+    args:
+    - geography
+    - name: distance
+      type: float64
+  - returns: geography
+    args:
+    - geography
+    - name: distance
+      type: float64
+    - name: num_quad_segs
+      type: integer
+  - returns: geography
+    args:
+    - geography
+    - name: distance
+      type: float64
+    - name: params
+      type: string
 ---
 
+## Description
+
+For geography, the distance is specified in meters. The buffer is computed on the sphere, producing a result that considers polar regions and the antimeridian. Negative distances are supported for polygon inputs to shrink the polygon.
+
 ## Examples
 
 ```sql
@@ -79,3 +102,12 @@ df = sd.sql("SELECT *, ST_Buffer(geom, 1.0, 'quad_segs=2') AS result FROM input"
 ax = df.geom.plot(alpha=0.5)
 df.result.plot(ax=ax, facecolor='none', edgecolor='red')
 ```
+
+For geography, the distance is specified in meters:
+
+```sql
+SELECT ST_Buffer(
+  ST_GeogFromText('POLYGON ((10 10, 11 10, 10 11, 10 10))'),
+  1000
+);
+```
diff --git a/docs/reference/sql/st_centroid.qmd b/docs/reference/sql/st_centroid.qmd
index fa7e975f6..2970436f2 100644
--- a/docs/reference/sql/st_centroid.qmd
+++ b/docs/reference/sql/st_centroid.qmd
@@ -17,16 +17,30 @@
 # under the License.
 
 title: ST_Centroid
-description: Returns the centroid of a geometry.
+description: Returns the centroid of a geometry or geography.
 kernels:
   - returns: geometry
     args: [geometry]
+  - returns: geography
+    args: [geography]
 ---
 
+## Description
+
+For geography, the centroid is calculated using spherical geometry.
+
 ## Examples
 
+
+```sql
+SELECT ST_Centroid(
+  ST_GeomFromWKT('LINESTRING (-64 45, 52 8)')
+);
+```
+
+
 ```sql
 SELECT ST_Centroid(
-  ST_GeomFromWKT('POLYGON ((0 0, 10 0, 10 10, 0 10, 0 0))')
+  ST_GeogFromWKT('LINESTRING (-64 45, 52 8)')
 );
 ```
diff --git a/docs/reference/sql/st_contains.qmd b/docs/reference/sql/st_contains.qmd
index e897d09dc..92018d375 100644
--- a/docs/reference/sql/st_contains.qmd
+++ b/docs/reference/sql/st_contains.qmd
@@ -21,6 +21,8 @@ description: Returns true if geomA contains geomB.
 kernels:
   - returns: boolean
     args: [geometry, geometry]
+  - returns: boolean
+    args: [geography, geography]
 ---
 
 ## Description
@@ -35,3 +37,10 @@ SELECT ST_Contains(
     ST_Point(0.25, 0.25)
 ) AS val;
 ```
+
+```sql
+SELECT ST_Contains(
+    ST_GeogFromText('POLYGON ((0 0, 1 0, 1 1, 0 1, 0 0))'),
+    ST_GeogPoint(0.25, 0.25)
+) AS val;
+```
diff --git a/docs/reference/sql/st_convexhull.qmd b/docs/reference/sql/st_convexhull.qmd
index adcc003ff..688452757 100644
--- a/docs/reference/sql/st_convexhull.qmd
+++ b/docs/reference/sql/st_convexhull.qmd
@@ -17,10 +17,12 @@
 # under the License.
 
 title: ST_ConvexHull
-description: Returns the Convex Hull of polygon A.
+description: Returns the Convex Hull of a geometry or geography.
 kernels:
   - returns: geometry
     args: [geometry]
+  - returns: geography
+    args: [geography]
 ---
 
 ## Description
@@ -31,6 +33,12 @@ Returns the smallest convex polygon that encloses all points in the input geomet
 
 ```sql
 SELECT ST_ConvexHull(
-  ST_GeomFromText('POLYGON((175 150, 20 40, 50 60, 125 100, 175 150))')
+  ST_GeomFromText('MULTIPOINT ((0 0), (0 1), (1 0))')
+);
+```
+
+```sql
+SELECT ST_ConvexHull(
+  ST_GeogFromWKT('MULTIPOINT ((0 0), (0 1), (1 0))')
 );
 ```
diff --git a/docs/reference/sql/st_difference.qmd b/docs/reference/sql/st_difference.qmd
index 884bce536..c93b08432 100644
--- a/docs/reference/sql/st_difference.qmd
+++ b/docs/reference/sql/st_difference.qmd
@@ -21,6 +21,8 @@ description: Computes the difference between geomA and geomB.
 kernels:
   - returns: geometry
     args: [geometry, geometry]
+  - returns: geography
+    args: [geography, geography]
 ---
 
 ## Description
@@ -35,3 +37,10 @@ SELECT ST_Difference(
     ST_GeomFromText('POLYGON ((0 0, 10 0, 10 10, 0 10, 0 0))')
 ) AS val;
 ```
+
+```sql
+SELECT ST_Difference(
+    ST_GeogFromText('POLYGON ((1 1, 11 1, 11 11, 1 11, 1 1))'),
+    ST_GeogFromText('POLYGON ((0 0, 10 0, 10 10, 0 10, 0 0))')
+) AS val;
+```
diff --git a/docs/reference/sql/st_dimension.qmd b/docs/reference/sql/st_dimension.qmd
index acad06b09..3f4391bee 100644
--- a/docs/reference/sql/st_dimension.qmd
+++ b/docs/reference/sql/st_dimension.qmd
@@ -17,10 +17,12 @@
 # under the License.
 
 title: ST_Dimension
-description: Returns the dimension of the geometry.
+description: Returns the dimension of the geometry or geography.
 kernels:
   - returns: integer
     args: [geometry]
+  - returns: integer
+    args: [geography]
 ---
 
 ## Description
@@ -40,5 +42,5 @@ SELECT ST_Dimension(ST_GeomFromWKT('POLYGON ((0 0, 1 0, 0 1, 0 0))'));
 ```
 
 ```sql
-SELECT ST_Dimension(ST_Point(1.0, 2.0));
+SELECT ST_Dimension(ST_GeogFromWKT('POLYGON ((0 0, 1 0, 0 1, 0 0))'));
 ```
diff --git a/docs/reference/sql/st_disjoint.qmd b/docs/reference/sql/st_disjoint.qmd
index 33f644211..d457bb5a0 100644
--- a/docs/reference/sql/st_disjoint.qmd
+++ b/docs/reference/sql/st_disjoint.qmd
@@ -21,6 +21,8 @@ description: Returns true if geomA is disjoint from geomB.
 kernels:
   - returns: boolean
     args: [geometry, geometry]
+  - returns: boolean
+    args: [geography, geography]
 ---
 
 ## Description
@@ -31,7 +33,14 @@ Returns `true` if the two geometries do not share any points. This is the invers
 
 ```sql
 SELECT ST_Disjoint(
-    ST_Point(0.25, 0.25),
-    ST_GeomFromText('POLYGON ((0 0, 1 0, 0 1, 0 0))')
-) AS val;
+    ST_GeomFromText('POLYGON ((0 0, 1 0, 0 1, 0 0))'),
+    ST_GeomFromText('POLYGON ((2 2, 3 2, 2 3, 2 2))')
+);
+```
+
+```sql
+SELECT ST_Disjoint(
+    ST_GeogFromText('POLYGON ((0 0, 1 0, 0 1, 0 0))'),
+    ST_GeogFromText('POLYGON ((2 2, 3 2, 2 3, 2 2))')
+);
 ```
diff --git a/docs/reference/sql/st_distance.qmd b/docs/reference/sql/st_distance.qmd
index d44593f31..26e96fbae 100644
--- a/docs/reference/sql/st_distance.qmd
+++ b/docs/reference/sql/st_distance.qmd
@@ -21,16 +21,20 @@ description: Returns the distance between two geometries or geographies.
 kernels:
   - returns: double
     args: [geometry, geometry]
+  - returns: double
+    args: [geography, geography]
 ---
 
 ## Description
 
-Returns the 2D Cartesian (planar) distance between two geometries, in the units
-of the coordinate reference system. For geographic distance calculations, use
-`ST_DistanceSphere` or `ST_DistanceSpheroid`.
+For geometry, returns the 2D Cartesian (planar) distance between two geometries, in the units of the coordinate reference system. For geography, returns the spherical approximation of the geodesic distance between two geographies in meters.
 
 ## Examples
 
 ```sql
 SELECT ST_Distance(ST_Point(0, 0), ST_Point(1, 1));
 ```
+
+```sql
+SELECT ST_Distance(ST_GeogPoint(0, 0), ST_GeogPoint(1, 1));
+```
diff --git a/docs/reference/sql/st_dwithin.qmd b/docs/reference/sql/st_dwithin.qmd
index 1f182475d..51a656722 100644
--- a/docs/reference/sql/st_dwithin.qmd
+++ b/docs/reference/sql/st_dwithin.qmd
@@ -17,7 +17,7 @@
 # under the License.
 
 title: ST_DWithin
-description: Returns true if two geometries are within a specified distance of each other.
+description: Returns true if two geometries or geographies are within a specified distance of each other.
 kernels:
   - returns: boolean
     args:
@@ -25,14 +25,32 @@ kernels:
     - geometry
     - name: distance
       type: double
+  - returns: boolean
+    args:
+    - geography
+    - geography
+    - name: distance
+      type: double
 ---
 
+## Description
+
+For geography, the distance is specified in meters and represents the spherical approximation of the geodesic distance between the two geographies.
+
 ## Examples
 
 ```sql
 SELECT ST_DWithin(
-  ST_Point(0.25, 0.25),
-  ST_GeomFromText('POLYGON ((0 0, 1 0, 0 1, 0 0))'),
-  0.5
+    ST_Point(0, 0),
+    ST_Point(1, 1),
+    2
+);
+```
+
+```sql
+SELECT ST_DWithin(
+    ST_GeogPoint(0, 0),
+    ST_GeogPoint(1, 1),
+    200000
 );
 ```
diff --git a/docs/reference/sql/st_envelope.qmd b/docs/reference/sql/st_envelope.qmd
index 8f97a246b..acb457417 100644
--- a/docs/reference/sql/st_envelope.qmd
+++ b/docs/reference/sql/st_envelope.qmd
@@ -17,22 +17,46 @@
 # under the License.
 
 title: ST_Envelope
-description: Returns the bounding box (envelope) of a geometry as a new geometry.
+description: Returns the bounding box (envelope) of a geometry or geography as a new geometry.
 kernels:
   - returns: geometry
     args: [geometry]
+  - returns: geometry
+    args: [geography]
 ---
 
 ## Description
 
-Returns the minimum axis-aligned bounding box of a geometry. This is usually a polygon but can be a linestring for perfectly vertical or horizontal input.
+Returns the minimum axis-aligned bounding box of a geometry. This is usually a polygon but can be a linestring for perfectly vertical or horizontal input and is a point if the input is also a point. For geography, the return value is still a rectangular polygon geometry that represents the latitude and longitude range of the input. For geographies that span the antimeridian, a multipolygon is returned (one on each side of the antimeridian).
+
+Because of slight numerical inaccuracy of geographical calculations, the bounds are expanded slightly compared to the corresponding geometry envelope.
 
 ## Examples
 
+```sql
+SELECT ST_Envelope(ST_Point(1.0, 2.0));
+```
+
 ```sql
 SELECT ST_Envelope(ST_GeomFromWKT('LINESTRING(0 0, 3 4)'));
 ```
 
 ```sql
-SELECT ST_Envelope(ST_Point(1.0, 2.0));
+SELECT ST_Envelope(ST_GeogFromWKT('LINESTRING(0 0, 3 4)'));
+```
+
+```sql
+SELECT ST_Envelope(ST_GeomFromWKT('LINESTRING(170 3, -170 4)'));
+```
+
+```sql
+SELECT ST_Envelope(ST_GeogPoint(1.0, 2.0));
+```
+
+```sql
+SELECT ST_Envelope(ST_GeogFromWKT('LINESTRING(0 0, 3 4)'));
+```
+
+```sql
+SELECT ST_Envelope(ST_GeogFromWKT('LINESTRING(170 3, -170 4)'));
 ```
diff --git a/docs/reference/sql/st_equals.qmd b/docs/reference/sql/st_equals.qmd
index ff6ebbe86..0bb15a266 100644
--- a/docs/reference/sql/st_equals.qmd
+++ b/docs/reference/sql/st_equals.qmd
@@ -21,6 +21,8 @@ description: Returns true if geomA equals geomB.
 kernels:
   - returns: boolean
     args: [geometry, geometry]
+  - returns: boolean
+    args: [geography, geography]
 ---
 
 ## Description
@@ -35,3 +37,10 @@ SELECT ST_Equals(
     ST_GeomFromText('LINESTRING(1 1, 0 0)')
 );
 ```
+
+```sql
+SELECT ST_Equals(
+    ST_GeogFromText('LINESTRING(0 0, 1 1)'),
+    ST_GeogFromText('LINESTRING(1 1, 0 0)')
+);
+```
diff --git a/docs/reference/sql/st_force2d.qmd b/docs/reference/sql/st_force2d.qmd
index 50f996b4c..46ac3a11b 100644
--- a/docs/reference/sql/st_force2d.qmd
+++ b/docs/reference/sql/st_force2d.qmd
@@ -17,10 +17,12 @@
 # under the License.
 
 title: ST_Force2D
-description: Forces a geometry into a XY coordinate model.
+description: Forces a geometry or geography into a XY coordinate model.
 kernels:
   - returns: geometry
     args: [geometry]
+  - returns: geography
+    args: [geography]
 ---
 
 ## Description
@@ -32,3 +34,7 @@ Discards any Z and M values present (if any).
 ```sql
 SELECT ST_Force2D(ST_GeomFromWKT('POINT Z (1 2 3)'));
 ```
+
+```sql
+SELECT ST_Force2D(ST_GeogFromWKT('POINT Z (1 2 3)'));
+```
diff --git a/docs/reference/sql/st_force3d.qmd b/docs/reference/sql/st_force3d.qmd
index f8141d7b2..297c4059f 100644
--- a/docs/reference/sql/st_force3d.qmd
+++ b/docs/reference/sql/st_force3d.qmd
@@ -17,7 +17,7 @@
 # under the License.
 
 title: ST_Force3D
-description: Forces a geometry into a XYZ coordinate model with an optional Z value.
+description: Forces a geometry or geography into a XYZ coordinate model with an optional Z value.
 kernels:
   - returns: geometry
     args: [geometry]
@@ -26,6 +26,13 @@ kernels:
     - geometry
     - name: z
       type: double
+  - returns: geography
+    args: [geography]
+  - returns: geography
+    args:
+    - geography
+    - name: z
+      type: double
 ---
 
 ## Description
@@ -43,5 +50,5 @@ SELECT ST_Force3D(ST_GeomFromWKT('POINT (1 2)'));
 ```
 
 ```sql
-SELECT ST_Force3D(ST_GeomFromWKT('POINT Z (1 2 3)'), 10.0);
+SELECT ST_Force3D(ST_GeogFromWKT('POINT (1 2)'), 10.0);
 ```
diff --git a/docs/reference/sql/st_force3dm.qmd b/docs/reference/sql/st_force3dm.qmd
index 050b84053..8962b2d64 100644
--- a/docs/reference/sql/st_force3dm.qmd
+++ b/docs/reference/sql/st_force3dm.qmd
@@ -17,7 +17,7 @@
 # under the License.
 
 title: ST_Force3DM
-description: Forces a geometry into a XYM coordinate model with an optional M value.
+description: Forces a geometry or geography into a XYM coordinate model with an optional M value.
 kernels:
   - returns: geometry
     args: [geometry]
@@ -26,6 +26,13 @@ kernels:
     - geometry
     - name: m
       type: double
+  - returns: geography
+    args: [geography]
+  - returns: geography
+    args:
+    - geography
+    - name: m
+      type: double
 ---
 
 ## Description
@@ -43,5 +50,5 @@ SELECT ST_Force3DM(ST_GeomFromWKT('POINT (1 2)'));
 ```
 
 ```sql
-SELECT ST_Force3DM(ST_GeomFromWKT('POINT M (1 2 3)'), 10.0);
+SELECT ST_Force3DM(ST_GeogFromWKT('POINT (1 2)'), 10.0);
 ```
diff --git a/docs/reference/sql/st_force4d.qmd b/docs/reference/sql/st_force4d.qmd
index 24d284335..121834bab 100644
--- a/docs/reference/sql/st_force4d.qmd
+++ b/docs/reference/sql/st_force4d.qmd
@@ -17,7 +17,7 @@
 # under the License.
 
 title: ST_Force4D
-description: Forces a geometry into a XYZM coordinate model with optional Z and M values.
+description: Forces a geometry or geography into a XYZM coordinate model with optional Z and M values.
 kernels:
   - returns: geometry
     args: [geometry]
@@ -33,6 +33,20 @@ kernels:
       type: double
     - name: m
       type: double
+  - returns: geography
+    args: [geography]
+  - returns: geography
+    args:
+    - geography
+    - name: z
+      type: double
+  - returns: geography
+    args:
+    - geography
+    - name: z
+      type: double
+    - name: m
+      type: double
 ---
 
 ## Description
@@ -56,3 +70,7 @@ SELECT ST_Force4D(ST_GeomFromWKT('POINT (1 2)'));
 ```sql
 SELECT ST_Force4D(ST_GeomFromWKT('POINT ZM (1 2 3 4)'), 10.0, 20.0);
 ```
+
+```sql
+SELECT ST_Force4D(ST_GeogFromWKT('POINT ZM (1 2 3 4)'), 10.0, 20.0);
+```
diff --git a/docs/reference/sql/st_geometryn.qmd b/docs/reference/sql/st_geometryn.qmd
index ca7bc5d42..25071d98a 100644
--- a/docs/reference/sql/st_geometryn.qmd
+++ b/docs/reference/sql/st_geometryn.qmd
@@ -17,13 +17,18 @@
 # under the License.
 
 title: ST_GeometryN
-description: Returns the 0-based Nth geometry if the geometry is a GEOMETRYCOLLECTION, (MULTI)POINT, (MULTI)LINESTRING, MULTICURVE or (MULTI)POLYGON.
+description: Returns the 1-based Nth geometry if the geometry is a GEOMETRYCOLLECTION, (MULTI)POINT, (MULTI)LINESTRING, MULTICURVE or (MULTI)POLYGON.
 kernels:
   - returns: geometry
     args:
     - geometry
     - name: "n"
       type: integer
+  - returns: geography
+    args:
+    - geography
+    - name: "n"
+      type: integer
 ---
 
 ## Description
@@ -34,7 +39,14 @@ Returns NULL if the index is out of range.
 
 ```sql
 SELECT ST_GeometryN(
-    ST_GeomFromText('MULTIPOINT((1 2), (3 4), (5 6), (8 9))'),
+    ST_GeomFromText('MULTIPOINT ((1 2), (3 4), (5 6))'),
+    1
+);
+```
+
+```sql
+SELECT ST_GeometryN(
+    ST_GeogFromWKT('MULTIPOINT ((1 2), (3 4), (5 6))'),
     1
 );
 ```
diff --git a/docs/reference/sql/st_geometrytype.qmd b/docs/reference/sql/st_geometrytype.qmd
index 9b2ada2c3..a79d94f0a 100644
--- a/docs/reference/sql/st_geometrytype.qmd
+++ b/docs/reference/sql/st_geometrytype.qmd
@@ -17,10 +17,12 @@
 # under the License.
 
 title: ST_GeometryType
-description: Returns the type of a geometry.
+description: Returns the type of a geometry or geography.
 kernels:
   - returns: string
     args: [geometry]
+  - returns: string
+    args: [geography]
 ---
 
 ## Description
@@ -36,5 +38,5 @@ SELECT ST_GeometryType(ST_GeomFromWKT('POLYGON ((0 0, 1 0, 0 1, 0 0))'));
 ```
 
 ```sql
-SELECT ST_GeometryType(ST_Point(1.0, 2.0));
+SELECT ST_GeometryType(ST_GeogFromWKT('POLYGON ((0 0, 1 0, 0 1, 0 0))'));
 ```
diff --git a/docs/reference/sql/st_geomfromwkt.qmd b/docs/reference/sql/st_geomfromwkt.qmd
index 4d98ad742..e8291003f 100644
--- a/docs/reference/sql/st_geomfromwkt.qmd
+++ b/docs/reference/sql/st_geomfromwkt.qmd
@@ -34,6 +34,7 @@ kernels:
 ## Description
 
 An optional SRID or CRS can be provided as a second argument to set the spatial reference.
+
 Aliases: `ST_GeomFromText`, `ST_GeometryFromText`.
 
 ## Examples
diff --git a/docs/reference/sql/st_interiorringn.qmd b/docs/reference/sql/st_interiorringn.qmd
index 73bf3203b..b7c901d79 100644
--- a/docs/reference/sql/st_interiorringn.qmd
+++ b/docs/reference/sql/st_interiorringn.qmd
@@ -24,6 +24,11 @@ kernels:
     - geometry
     - name: "n"
       type: integer
+  - returns: geography
+    args:
+    - geography
+    - name: "n"
+      type: integer
 ---
 
 ## Description
@@ -44,3 +49,13 @@ SELECT
         1
     );
 ```
+
+```sql
+SELECT
+    ST_InteriorRingN(
+        ST_GeogFromText(
+            'POLYGON((0 0, 0 5, 5 5, 5 0, 0 0), (1 1, 2 1, 2 2, 1 2, 1 1), (1 3, 2 3, 2 4, 1 4, 1 3), (3 3, 4 3, 4 4, 3 4, 3 3))'
+        ),
+        1
+    );
+```
diff --git a/docs/reference/sql/st_intersects.qmd b/docs/reference/sql/st_intersects.qmd
index f215f3ca8..6e1ab201f 100644
--- a/docs/reference/sql/st_intersects.qmd
+++ b/docs/reference/sql/st_intersects.qmd
@@ -21,13 +21,22 @@ description: Returns true if geomA intersects geomB.
 kernels:
   - returns: boolean
     args: [geometry, geometry]
+  - returns: boolean
+    args: [geography, geography]
 ---
 
 ## Examples
 
 ```sql
 SELECT ST_Intersects(
-    ST_Point(0.25, 0.25),
-    ST_GeomFromText('POLYGON ((0 0, 1 0, 0 1, 0 0))')
-) AS val;
+    ST_Point(0.5, 0.5),
+    ST_GeomFromText('POLYGON ((0 0, 1 0, 1 1, 0 1, 0 0))')
+);
+```
+
+```sql
+SELECT ST_Intersects(
+    ST_GeogPoint(0.5, 0.5),
+    ST_GeogFromText('POLYGON ((0 0, 1 0, 1 1, 0 1, 0 0))')
+);
 ```
diff --git a/docs/reference/sql/st_isclosed.qmd b/docs/reference/sql/st_isclosed.qmd
index b2f1e10bf..7c05df021 100644
--- a/docs/reference/sql/st_isclosed.qmd
+++ b/docs/reference/sql/st_isclosed.qmd
@@ -21,6 +21,8 @@ description: Returns true if the LINESTRING start and end point are the same.
 kernels:
   - returns: boolean
     args: [geometry]
+  - returns: boolean
+    args: [geography]
 ---
 
 ## Description
@@ -30,13 +32,9 @@ Returns `true` if the LineString's start and end points are the same. For MultiL
 ## Examples
 
 ```sql
-SELECT ST_IsClosed(
-  ST_GeomFromText('LINESTRING(0 0, 1 1, 1 0, 0 0)')
-);
+SELECT ST_IsClosed(ST_GeomFromText('LINESTRING(0 0, 1 1, 1 0, 0 0)'));
 ```
 
 ```sql
-SELECT ST_IsClosed(
-  ST_GeomFromText('LINESTRING(0 0, 1 1, 1 0)')
-);
+SELECT ST_IsClosed(ST_GeogFromWKT('LINESTRING(0 0, 1 1, 1 0, 0 0)'));
 ```
diff --git a/docs/reference/sql/st_iscollection.qmd b/docs/reference/sql/st_iscollection.qmd
index e9b5dd3c8..1517d1cfc 100644
--- a/docs/reference/sql/st_iscollection.qmd
+++ b/docs/reference/sql/st_iscollection.qmd
@@ -17,10 +17,12 @@
 # under the License.
 
 title: ST_IsCollection
-description: Returns TRUE if the geometry type of the input is a geometry collection type.
+description: Returns true if the geometry or geography type of the input is a collection type.
 kernels:
   - returns: boolean
     args: [geometry]
+  - returns: boolean
+    args: [geography]
 ---
 
 ## Description
@@ -35,9 +37,9 @@ Returns TRUE if the geometry type of the input is a geometry collection type. Co
 ## Examples
 
 ```sql
-SELECT ST_IsCollection(ST_GeomFromText('MULTIPOINT(0 0, 6 6)'));
+SELECT ST_IsCollection(ST_GeomFromWKT('MULTIPOINT ((0 0), (1 1))'));
 ```
 
 ```sql
-SELECT ST_IsCollection(ST_GeomFromText('POINT(5 5)'));
+SELECT ST_IsCollection(ST_GeogFromWKT('MULTIPOINT ((0 0), (1 1))'));
 ```
diff --git a/docs/reference/sql/st_isempty.qmd b/docs/reference/sql/st_isempty.qmd
index b842fe192..eb29f1c75 100644
--- a/docs/reference/sql/st_isempty.qmd
+++ b/docs/reference/sql/st_isempty.qmd
@@ -17,18 +17,20 @@
 # under the License.
 
 title: ST_IsEmpty
-description: Returns true if the geometry is empty.
+description: Returns true if the geometry or geography is empty.
 kernels:
   - returns: boolean
     args: [geometry]
+  - returns: boolean
+    args: [geography]
 ---
 
 ## Examples
 
 ```sql
-SELECT ST_IsEmpty(ST_GeomFromWKT('POLYGON EMPTY'));
+SELECT ST_IsEmpty(ST_GeomFromWKT('POINT EMPTY'));
 ```
 
 ```sql
-SELECT ST_IsEmpty(ST_Point(1.0, 2.0));
+SELECT ST_IsEmpty(ST_GeogFromWKT('POINT EMPTY'));
 ```
diff --git a/docs/reference/sql/st_length.qmd b/docs/reference/sql/st_length.qmd
index 0d9e280b7..329a28966 100644
--- a/docs/reference/sql/st_length.qmd
+++ b/docs/reference/sql/st_length.qmd
@@ -17,18 +17,24 @@
 # under the License.
 
 title: ST_Length
-description: Returns the length of a geometry.
+description: Returns the length of a geometry or geography.
 kernels:
   - returns: double
     args: [geometry]
+  - returns: double
+    args: [geography]
 ---
 
 ## Description
 
-Returns the length of geom. This function only supports LineString, MultiLineString, and GeometryCollections containing linear geometries. Use ST_Perimeter for polygons.
+Returns the length of geom. This function only supports LineString, MultiLineString, and GeometryCollections containing linear geometries. Use ST_Perimeter for polygons. For geometry, returns the length in the units of the coordinate reference system; for geography, returns the spherical approximation of the geodesic length in meters.
 
 ## Examples
 
 ```sql
-SELECT ST_Length(ST_GeomFromWKT('LINESTRING(0 0, 10 0)'));
+SELECT ST_Length(ST_GeomFromWKT('LINESTRING (0 0, 0 1)'));
+```
+
+```sql
+SELECT ST_Length(ST_GeogFromWKT('LINESTRING (0 0, 0 1)'));
 ```
diff --git a/docs/reference/sql/st_lineinterpolatepoint.qmd b/docs/reference/sql/st_lineinterpolatepoint.qmd
index 4324dc0f4..ecb680284 100644
--- a/docs/reference/sql/st_lineinterpolatepoint.qmd
+++ b/docs/reference/sql/st_lineinterpolatepoint.qmd
@@ -24,14 +24,23 @@ kernels:
     - geometry
     - name: fraction
       type: double
+  - returns: geography
+    args:
+    - geography
+    - name: fraction
+      type: double
 ---
 
 ## Description
 
-Returns a point interpolated along a line. First argument must be a LINESTRING. Second argument is a double between 0 and 1 representing fraction of total linestring length the point has to be located.
+Returns a point interpolated along a line. First argument must be a LINESTRING. Second argument is a double between 0 and 1 representing fraction of total linestring length the point has to be located. For geography, the interpolation is computed using spherical interpolation between vertices.
 
 ## Examples
 
 ```sql
-SELECT ST_LineInterpolatePoint(ST_GeomFromWKT('LINESTRING(25 50, 100 125, 150 190)'), 0.2);
+SELECT ST_LineInterpolatePoint(ST_GeomFromWKT('LINESTRING (0 0, 1 1)'), 0.5);
+```
+
+```sql
+SELECT ST_LineInterpolatePoint(ST_GeogFromWKT('LINESTRING (0 0, 1 1)'), 0.5);
 ```
diff --git a/docs/reference/sql/st_linelocatepoint.qmd b/docs/reference/sql/st_linelocatepoint.qmd
index 48b1c7422..c74475636 100644
--- a/docs/reference/sql/st_linelocatepoint.qmd
+++ b/docs/reference/sql/st_linelocatepoint.qmd
@@ -20,18 +20,18 @@ title: ST_LineLocatePoint
 description: Returns the location of the closest point on a LineString as a fraction of its total length.
 kernels:
   - returns: double
-    args: [geometry, geometry]
+    args: [geography, geography]
 ---
 
 ## Description
 
-Returns a double between 0 and 1, representing the location of the closest point on the LineString as a fraction of its total length. The first argument must be a LINESTRING, and the second argument is a POINT geometry.
+Returns a double between 0 and 1, representing the location of the closest point on the LineString as a fraction of its total length. The first argument must be a LINESTRING, and the second argument is a POINT geometry or geography. For geography, the fraction is computed based on spherical interpolation between vertices.
 
 ## Examples
 
 ```sql
 SELECT ST_LineLocatePoint(
-    ST_GeogFromText('LINESTRING(0 0, 1 1, 2 2)'),
-    ST_GeogFromText('POINT(0 2)')
+    ST_GeogFromWKT('LINESTRING (0 0, 1 1, 2 2)'),
+    ST_GeogFromWKT('POINT (1 1)')
 );
 ```
diff --git a/docs/reference/sql/st_linemerge.qmd b/docs/reference/sql/st_linemerge.qmd
index 9d2ead339..5fe82380d 100644
--- a/docs/reference/sql/st_linemerge.qmd
+++ b/docs/reference/sql/st_linemerge.qmd
@@ -21,12 +21,21 @@ description: Merges a collection of potentially connected line segments into the
 kernels:
   - returns: geometry
     args: [geometry]
+  - returns: geography
+    args: [geography]
 ---
 
 ## Examples
 
+
 ```sql
 SELECT ST_LineMerge(
     ST_GeomFromWKT('MULTILINESTRING ((0 0, 1 0), (1 0, 1 1))')
 );
 ```
+
+```sql
+SELECT ST_LineMerge(
+    ST_GeogFromWKT('MULTILINESTRING ((0 0, 1 0), (1 0, 1 1))')
+);
+```
diff --git a/docs/reference/sql/st_maxdistance.qmd b/docs/reference/sql/st_maxdistance.qmd
index 996a2ee2f..a14909f5b 100644
--- a/docs/reference/sql/st_maxdistance.qmd
+++ b/docs/reference/sql/st_maxdistance.qmd
@@ -17,17 +17,21 @@
 # under the License.
 
 title: ST_MaxDistance
-description: Returns the maximum distance between any pair of points in two geometries.
+description: Returns the maximum distance between any pair of points in two geometries or geographies.
 kernels:
   - returns: double
-    args: [geometry, geometry]
+    args: [geography, geography]
 ---
 
+## Description
+
+For geography, returns the maximum distance in meters calculated using a spherical approximation.
+
 ## Examples
 
 ```sql
 SELECT ST_MaxDistance(
-    ST_GeogFromText('POLYGON ((10 10, 11 10, 10 11, 10 10))'),
-    ST_GeogFromText('POLYGON ((0 0, 1 0, 0 1, 0 0))')
-) AS val;
+    ST_GeogFromText('POLYGON ((0 0, 1 0, 0 1, 0 0))'),
+    ST_GeogFromText('POLYGON ((10 10, 11 10, 10 11, 10 10))')
+);
 ```
diff --git a/docs/reference/sql/st_mmax.qmd b/docs/reference/sql/st_mmax.qmd
index 780ce548c..61fd21fbd 100644
--- a/docs/reference/sql/st_mmax.qmd
+++ b/docs/reference/sql/st_mmax.qmd
@@ -17,14 +17,20 @@
 # under the License.
 
 title: ST_MMax
-description: Returns the maximum M (measure) value from a geometry's bounding box.
+description: Returns the maximum M (measure) value from a geometry or geography's bounding box.
 kernels:
   - returns: double
     args: [geometry]
+  - returns: double
+    args: [geography]
 ---
 
 ## Examples
 
 ```sql
-SELECT ST_MMax(ST_GeomFromWKT('POLYGON ((0 0, 1 0, 0 1, 0 0))'));
+SELECT ST_MMax(ST_GeomFromWKT('LINESTRING M (1 2 3, 5 6 7)'));
+```
+
+```sql
+SELECT ST_MMax(ST_GeogFromWKT('LINESTRING M (1 2 3, 5 6 7)'));
 ```
diff --git a/docs/reference/sql/st_mmin.qmd b/docs/reference/sql/st_mmin.qmd
index ccb0cc300..976a2fa8d 100644
--- a/docs/reference/sql/st_mmin.qmd
+++ b/docs/reference/sql/st_mmin.qmd
@@ -17,15 +17,20 @@
 # under the License.
 
 title: ST_MMin
-description: Returns the minimum M-coordinate (measure) of a geometry's bounding box.
+description: Returns the minimum M-coordinate (measure) of a geometry or geography's bounding box.
 kernels:
   - returns: double
     args: [geometry]
+  - returns: double
+    args: [geography]
 ---
 
 ## Examples
 
 ```sql
-SELECT ST_MMin(ST_GeomFromWKT('LINESTRING ZM (1 2 3 4, 5 6 7 8)'));
--- Returns: 4
+SELECT ST_MMin(ST_GeomFromWKT('LINESTRING M (1 2 3, 5 6 7)'));
+```
+
+```sql
+SELECT ST_MMin(ST_GeogFromWKT('LINESTRING M (1 2 3, 5 6 7)'));
 ```
diff --git a/docs/reference/sql/st_normalize.qmd b/docs/reference/sql/st_normalize.qmd
index 79bdd7ef8..3f44bf0ea 100644
--- a/docs/reference/sql/st_normalize.qmd
+++ b/docs/reference/sql/st_normalize.qmd
@@ -17,18 +17,27 @@
 # under the License.
 
 title: ST_Normalize
-description: Returns the geometry in its canonical form.
+description: Returns the geometry or geography in its canonical form.
 kernels:
   - returns: geometry
     args: [geometry]
+  - returns: geography
+    args: [geography]
 ---
 
+This function is mostly useful for testing and may rearrange vertices within a ring
+or interior rings within a polygon.
+
 ## Examples
 
 ```sql
-SELECT ST_AsText(
-  ST_Normalize(
-    ST_GeomFromWKT('POLYGON((10 10, 10 0, 0 0, 0 10, 10 10))')
-  )
+SELECT ST_Normalize(
+    ST_GeomFromWKT('POLYGON ((10 10, 10 0, 0 0, 0 10, 10 10))')
+);
+```
+
+```sql
+SELECT ST_Normalize(
+    ST_GeogFromWKT('POLYGON ((10 10, 10 0, 0 0, 0 10, 10 10))')
 );
 ```
diff --git a/docs/reference/sql/st_npoints.qmd b/docs/reference/sql/st_npoints.qmd
index 26a4f4893..9a7a3ea1d 100644
--- a/docs/reference/sql/st_npoints.qmd
+++ b/docs/reference/sql/st_npoints.qmd
@@ -17,10 +17,12 @@
 # under the License.
 
 title: ST_NPoints
-description: Returns the number of points of the geometry.
+description: Returns the number of points of the geometry or geography.
 kernels:
   - returns: integer
     args: [geometry]
+  - returns: integer
+    args: [geography]
 ---
 
 ## Description
@@ -31,6 +33,24 @@ Returns the total number of coordinate points in the geometry, counting all vert
 
 ```sql
 SELECT ST_NPoints(
-  ST_GeomFromText('LINESTRING (1 2, 3 4, 5 6)')
+  ST_GeomFromWKT('LINESTRING (1 2, 3 4, 5 6)')
+);
+```
+
+```sql
+SELECT ST_NPoints(
+  ST_GeomFromWKT('POLYGON ((0 0, 1 0, 1 1, 0 1, 0 0))')
+);
+```
+
+```sql
+SELECT ST_NPoints(
+  ST_GeogFromWKT('LINESTRING (1 2, 3 4, 5 6)')
+);
+```
+
+```sql
+SELECT ST_NPoints(
+  ST_GeogFromWKT('POLYGON ((0 0, 1 0, 1 1, 0 1, 0 0))')
 );
 ```
diff --git a/docs/reference/sql/st_dimension.qmd b/docs/reference/sql/st_nrings.qmd
similarity index 61%
copy from docs/reference/sql/st_dimension.qmd
copy to docs/reference/sql/st_nrings.qmd
index acad06b09..fcbd2b078 100644
--- a/docs/reference/sql/st_dimension.qmd
+++ b/docs/reference/sql/st_nrings.qmd
@@ -16,29 +16,25 @@
 # specific language governing permissions and limitations
 # under the License.
 
-title: ST_Dimension
-description: Returns the dimension of the geometry.
+title: ST_NRings
+description: Returns the total number of rings in a geometry or geography (both exterior and interior rings).
 kernels:
   - returns: integer
     args: [geometry]
+  - returns: integer
+    args: [geography]
 ---
 
 ## Description
 
-Returns the inherent dimension of the geometry:
-
-- 0 for points or multipoints
-- 1 for linestring or multilinestrings
-- 2 for polygons or multipolygons
-
-For geometry collections, returns the largest dimension among the components.
+Returns the total number of rings (exterior and interior) in a polygon or multipolygon. For a simple polygon, this is 1 plus the number of holes. For a multipolygon, it is the sum of all rings in all polygons. Returns 0 for non-polygon geometry types.
 
 ## Examples
 
 ```sql
-SELECT ST_Dimension(ST_GeomFromWKT('POLYGON ((0 0, 1 0, 0 1, 0 0))'));
+SELECT ST_NRings(ST_GeomFromText('POLYGON ((0 0, 0 1, 1 1, 1 0, 0 0))'));
 ```
 
 ```sql
-SELECT ST_Dimension(ST_Point(1.0, 2.0));
+SELECT ST_NRings(ST_GeogFromWKT('POLYGON ((0 0, 0 1, 1 1, 1 0, 0 0))'));
 ```
diff --git a/docs/reference/sql/st_numgeometries.qmd b/docs/reference/sql/st_numgeometries.qmd
index 9f4608f5a..a94f48a20 100644
--- a/docs/reference/sql/st_numgeometries.qmd
+++ b/docs/reference/sql/st_numgeometries.qmd
@@ -17,10 +17,12 @@
 # under the License.
 
 title: ST_NumGeometries
-description: Returns the number of geometries in a geometry collection.
+description: Returns the number of geometries in a geometry or geography collection.
 kernels:
   - returns: integer
     args: [geometry]
+  - returns: integer
+    args: [geography]
 ---
 
 ## Description
@@ -30,5 +32,9 @@ Returns the number of Geometries. If geometry is a GEOMETRYCOLLECTION (or MULTI*
 ## Examples
 
 ```sql
-SELECT ST_NumGeometries(ST_GeomFromWKT('LINESTRING (-29 -27, -30 -29.7, -45 -33)'));
+SELECT ST_NumGeometries(ST_GeomFromWKT('MULTIPOINT ((0 0), (1 1))'));
+```
+
+```sql
+SELECT ST_NumGeometries(ST_GeogFromWKT('MULTIPOINT ((0 0), (1 1))'));
 ```
diff --git a/docs/reference/sql/st_dimension.qmd b/docs/reference/sql/st_numinteriorrings.qmd
similarity index 58%
copy from docs/reference/sql/st_dimension.qmd
copy to docs/reference/sql/st_numinteriorrings.qmd
index acad06b09..5afb978d5 100644
--- a/docs/reference/sql/st_dimension.qmd
+++ b/docs/reference/sql/st_numinteriorrings.qmd
@@ -16,29 +16,27 @@
 # specific language governing permissions and limitations
 # under the License.
 
-title: ST_Dimension
-description: Returns the dimension of the geometry.
+title: ST_NumInteriorRings
+description: Returns the number of interior rings (holes) in a polygon geometry or geography.
 kernels:
   - returns: integer
     args: [geometry]
+  - returns: integer
+    args: [geography]
 ---
 
 ## Description
 
-Returns the inherent dimension of the geometry:
-
-- 0 for points or multipoints
-- 1 for linestring or multilinestrings
-- 2 for polygons or multipolygons
+Returns the number of interior rings (holes) in a polygon. For a polygon without holes, returns 0. For multipolygons, returns the number of interior rings in the first polygon. Returns NULL for non-polygon geometry types.
 
-For geometry collections, returns the largest dimension among the components.
+Alias: `ST_NumInteriorRing`.
 
 ## Examples
 
 ```sql
-SELECT ST_Dimension(ST_GeomFromWKT('POLYGON ((0 0, 1 0, 0 1, 0 0))'));
+SELECT ST_NumInteriorRings(ST_GeomFromText('POLYGON ((0 0, 0 10, 10 10, 10 0, 0 0), (1 1, 1 2, 2 2, 2 1, 1 1))'));
 ```
 
 ```sql
-SELECT ST_Dimension(ST_Point(1.0, 2.0));
+SELECT ST_NumInteriorRings(ST_GeogFromWKT('POLYGON ((0 0, 0 10, 10 10, 10 0, 0 0), (1 1, 1 2, 2 2, 2 1, 1 1))'));
 ```
diff --git a/docs/reference/sql/st_dimension.qmd b/docs/reference/sql/st_numpoints.qmd
similarity index 57%
copy from docs/reference/sql/st_dimension.qmd
copy to docs/reference/sql/st_numpoints.qmd
index acad06b09..9952d1a22 100644
--- a/docs/reference/sql/st_dimension.qmd
+++ b/docs/reference/sql/st_numpoints.qmd
@@ -16,29 +16,41 @@
 # specific language governing permissions and limitations
 # under the License.
 
-title: ST_Dimension
-description: Returns the dimension of the geometry.
+title: ST_NumPoints
+description: Returns the number of points of a linestring geometry or geography.
 kernels:
   - returns: integer
     args: [geometry]
+  - returns: integer
+    args: [geography]
 ---
 
 ## Description
 
-Returns the inherent dimension of the geometry:
+Returns the total number of coordinate points in a linestring geometry. Returns NULL for other geometry types. Use `ST_NPoints()` to calculate the number of vertices for all geometry types.
 
-- 0 for points or multipoints
-- 1 for linestring or multilinestrings
-- 2 for polygons or multipolygons
+## Examples
 
-For geometry collections, returns the largest dimension among the components.
+```sql
+SELECT ST_NumPoints(
+  ST_GeomFromWKT('LINESTRING (1 2, 3 4, 5 6)')
+);
+```
 
-## Examples
+```sql
+SELECT ST_NumPoints(
+  ST_GeomFromWKT('POLYGON ((0 0, 1 0, 1 1, 0 1, 0 0))')
+);
+```
 
 ```sql
-SELECT ST_Dimension(ST_GeomFromWKT('POLYGON ((0 0, 1 0, 0 1, 0 0))'));
+SELECT ST_NumPoints(
+  ST_GeogFromWKT('LINESTRING (1 2, 3 4, 5 6)')
+);
 ```
 
 ```sql
-SELECT ST_Dimension(ST_Point(1.0, 2.0));
+SELECT ST_NumPoints(
+  ST_GeogFromWKT('POLYGON ((0 0, 1 0, 1 1, 0 1, 0 0))')
+);
 ```
diff --git a/docs/reference/sql/st_perimeter.qmd b/docs/reference/sql/st_perimeter.qmd
index 7f1eca872..2f7238553 100644
--- a/docs/reference/sql/st_perimeter.qmd
+++ b/docs/reference/sql/st_perimeter.qmd
@@ -17,18 +17,24 @@
 # under the License.
 
 title: ST_Perimeter
-description: Calculates the 2D perimeter of a given geometry.
+description: Calculates the perimeter of a given geometry or geography.
 kernels:
   - returns: double
     args: [geometry]
+  - returns: double
+    args: [geography]
 ---
 
 ## Description
 
-This function calculates the 2D perimeter of a given geometry. It supports Polygon, MultiPolygon, and GeometryCollection geometries (as long as the GeometryCollection contains polygonal geometries). For other types, it returns 0. To measure lines, use ST_Length.
+This function calculates the perimeter of a given geometry or geography. It supports Polygon, MultiPolygon, and GeometryCollection geometries (as long as the GeometryCollection contains polygonal geometries). For other types, it returns 0. To measure lines, use ST_Length. For geography, returns the spherical approximation of the geodesic perimeter in meters.
 
 ## Examples
 
 ```sql
-SELECT ST_Perimeter(ST_GeomFromWKT('POLYGON((0 0, 10 0, 10 10, 0 10, 0 0))'));
+SELECT ST_Perimeter(ST_GeomFromWKT('POLYGON ((0 0, 1 0, 1 1, 0 1, 0 0))'));
+```
+
+```sql
+SELECT ST_Perimeter(ST_GeogFromWKT('POLYGON ((0 0, 1 0, 1 1, 0 1, 0 0))'));
 ```
diff --git a/docs/reference/sql/st_pointn.qmd b/docs/reference/sql/st_pointn.qmd
index deee2dd82..aadc46314 100644
--- a/docs/reference/sql/st_pointn.qmd
+++ b/docs/reference/sql/st_pointn.qmd
@@ -24,6 +24,11 @@ kernels:
     - geometry
     - name: "n"
       type: integer
+  - returns: geography
+    args:
+    - geography
+    - name: "n"
+      type: integer
 ---
 
 ## Description
@@ -33,5 +38,9 @@ Return the Nth point in a single linestring. Negative values are counted backwar
 ## Examples
 
 ```sql
-SELECT ST_PointN(ST_GeomFromText('LINESTRING(0 0, 1 2, 2 4, 3 6)'), 2);
+SELECT ST_PointN(ST_GeomFromText('LINESTRING (0 0, 1 2, 2 4)'), 2);
+```
+
+```sql
+SELECT ST_PointN(ST_GeogFromWKT('LINESTRING (0 0, 1 2, 2 4)'), 2);
 ```
diff --git a/docs/reference/sql/st_convexhull.qmd b/docs/reference/sql/st_pointonsurface.qmd
similarity index 64%
copy from docs/reference/sql/st_convexhull.qmd
copy to docs/reference/sql/st_pointonsurface.qmd
index adcc003ff..8b386552f 100644
--- a/docs/reference/sql/st_convexhull.qmd
+++ b/docs/reference/sql/st_pointonsurface.qmd
@@ -16,21 +16,22 @@
 # specific language governing permissions and limitations
 # under the License.
 
-title: ST_ConvexHull
-description: Returns the Convex Hull of polygon A.
+title: ST_PointOnSurface
+description: Returns a point guaranteed to lie on the surface of a geometry or geography.
 kernels:
-  - returns: geometry
-    args: [geometry]
+  - returns: geography
+    args: [geography]
 ---
 
 ## Description
 
-Returns the smallest convex polygon that encloses all points in the input geometry.
+Unlike ST_Centroid which does not necessarily intersect a geometry or geography, ST_PointOnSurface
+makes an attempt to find an interior point close to the middle (using deterministic heuristics).
 
 ## Examples
 
 ```sql
-SELECT ST_ConvexHull(
-  ST_GeomFromText('POLYGON((175 150, 20 40, 50 60, 125 100, 175 150))')
+SELECT ST_PointOnSurface(
+    ST_GeogFromWKT('POLYGON ((0 0, 4 0, 4 4, 0 4, 0 0), (1 1, 1 3, 3 3, 3 1, 1 1))')
 );
 ```
diff --git a/docs/reference/sql/st_points.qmd b/docs/reference/sql/st_points.qmd
index b721ab691..8d7ee27c3 100644
--- a/docs/reference/sql/st_points.qmd
+++ b/docs/reference/sql/st_points.qmd
@@ -17,10 +17,12 @@
 # under the License.
 
 title: ST_Points
-description: Returns a MultiPoint geometry consisting of all the coordinates of the input geometry.
+description: Returns a MultiPoint geometry consisting of all the coordinates of the input geometry or geography.
 kernels:
   - returns: geometry
     args: [geometry]
+  - returns: geography
+    args: [geography]
 ---
 
 ## Description
@@ -30,5 +32,9 @@ Returns a MultiPoint geometry consisting of all the coordinates of the input geo
 ## Examples
 
 ```sql
-SELECT ST_AsText(ST_Points(ST_GeomFromText('LINESTRING (2 4, 3 3, 4 2, 7 3)')));
+SELECT ST_Points(ST_GeomFromText('LINESTRING (2 4, 3 3, 4 2)'));
+```
+
+```sql
+SELECT ST_Points(ST_GeogFromWKT('LINESTRING (2 4, 3 3, 4 2)'));
 ```
diff --git a/docs/reference/sql/st_segmentize.qmd b/docs/reference/sql/st_reduceprecision.qmd
similarity index 60%
copy from docs/reference/sql/st_segmentize.qmd
copy to docs/reference/sql/st_reduceprecision.qmd
index 1ed6269b6..635731464 100644
--- a/docs/reference/sql/st_segmentize.qmd
+++ b/docs/reference/sql/st_reduceprecision.qmd
@@ -16,32 +16,27 @@
 # specific language governing permissions and limitations
 # under the License.
 
-title: ST_Segmentize
-description: Densifies a geometry by adding intermediate points along segments that exceed a maximum length.
+title: ST_ReducePrecision
+description: Reduces the coordinate precision of a geometry or geography to the specified grid size.
 kernels:
-  - returns: geometry
-    args:
-    - geometry
-    - name: max_segment_length
-      type: double
   - returns: geography
     args:
     - geography
-    - name: max_segment_length
+    - name: grid_size
       type: double
 ---
 
 ## Description
 
-Densifies a geometry by adding intermediate points along line segments that exceed
-the specified maximum segment length. Uses Euclidean (planar) distance for geometry.
-Points are added so that each resulting segment is no longer than `max_segment_length`.
+Rebuilds a new geometry after specifying all vertices to the specified size. Z and M values are preserved
+but not affected by the grid snapping. The implementation is similar to a unary union and is designed to
+output valid geometry (e.g., by avoiding creating new crossing edges when snapping vertices).
 
 ## Examples
 
 ```sql
-SELECT ST_Segmentize(
-    ST_GeomFromText('LINESTRING (0 0, 100 0)'),
-    25
+SELECT ST_ReducePrecision(
+    ST_GeogFromWKT('POINT (1.123456 2.654321)'),
+    0.01
 );
 ```
diff --git a/docs/reference/sql/st_reverse.qmd b/docs/reference/sql/st_reverse.qmd
index e715a2e14..c65ce86a4 100644
--- a/docs/reference/sql/st_reverse.qmd
+++ b/docs/reference/sql/st_reverse.qmd
@@ -17,14 +17,20 @@
 # under the License.
 
 title: ST_Reverse
-description: Returns the geometry with vertex order reversed.
+description: Returns the geometry or geography with vertex order reversed.
 kernels:
   - returns: geometry
     args: [geometry]
+  - returns: geography
+    args: [geography]
 ---
 
 ## Examples
 
 ```sql
-SELECT ST_Reverse(ST_GeomFromText('LINESTRING(0 0, 1 2, 2 4, 3 6)'));
+SELECT ST_Reverse(ST_GeomFromText('LINESTRING (0 0, 1 2, 2 4)'));
+```
+
+```sql
+SELECT ST_Reverse(ST_GeogFromWKT('LINESTRING (0 0, 1 2, 2 4)'));
 ```
diff --git a/docs/reference/sql/st_segmentize.qmd b/docs/reference/sql/st_segmentize.qmd
index 1ed6269b6..293685a87 100644
--- a/docs/reference/sql/st_segmentize.qmd
+++ b/docs/reference/sql/st_segmentize.qmd
@@ -33,15 +33,24 @@ kernels:
 
 ## Description
 
-Densifies a geometry by adding intermediate points along line segments that exceed
-the specified maximum segment length. Uses Euclidean (planar) distance for geometry.
-Points are added so that each resulting segment is no longer than `max_segment_length`.
+Densifies a geometry or geography by adding intermediate points along line segments
+that exceed the specified maximum segment length. For geometry, uses planar distance; for
+geography, uses the spherical approximation of the geodesic distance in meters and points
+are added along the great circle arc. In both cases, points are added so that each
+resulting segment is no longer than `max_segment_length`.
 
 ## Examples
 
 ```sql
 SELECT ST_Segmentize(
-    ST_GeomFromText('LINESTRING (0 0, 100 0)'),
-    25
+    ST_GeomFromText('LINESTRING (0 0, 0 10)'),
+    2
+);
+```
+
+```sql
+SELECT ST_Segmentize(
+    ST_GeogFromWKT('LINESTRING (0 0, 0 10)'),
+    100000
 );
 ```
diff --git a/docs/reference/sql/st_simplify.qmd b/docs/reference/sql/st_simplify.qmd
index 44444ae8b..85b6a30e2 100644
--- a/docs/reference/sql/st_simplify.qmd
+++ b/docs/reference/sql/st_simplify.qmd
@@ -17,26 +17,38 @@
 # under the License.
 
 title: ST_Simplify
-description: Simplifies an input geometry using the Douglas-Peucker algorithm.
+description: Simplifies an input geometry or geography using the Douglas-Peucker algorithm.
 kernels:
   - returns: geometry
     args:
     - geometry
     - name: tolerance
       type: double
+  - returns: geography
+    args:
+    - geography
+    - name: tolerance
+      type: double
 ---
 
 ## Description
 
-Simplifies a geometry using the Douglas-Peucker algorithm. The `tolerance` parameter controls the degree of simplification: higher values produce simpler geometries. This function may produce invalid geometries; use `ST_SimplifyPreserveTopology` when validity must be maintained.
+Simplifies a geometry or geography using the Douglas-Peucker algorithm. The `tolerance` parameter controls the degree of simplification: higher values produce simpler geometries. For geography, the tolerance is specified in meters and a different algorithm is used.
+
+This function may produce invalid geometries; use `ST_SimplifyPreserveTopology` when validity must be maintained.
 
 ## Examples
 
 ```sql
 SELECT ST_Simplify(
-    ST_GeomFromWKT('POLYGON((8 25, 28 22, 28 20, 15 11, 33 3, 56 30, 46 33,
-        46 34, 47 44, 35 36, 45 33, 43 19, 29 21, 29 22,
-        35 26, 24 39, 8 25))'),
-    10
+    ST_GeomFromWKT('LINESTRING (0 0, 0.5 0.1, 1 0, 1.5 0.1, 2 0)'),
+    0.2
+);
+```
+
+```sql
+SELECT ST_Simplify(
+    ST_GeogFromWKT('LINESTRING (0 0, 0.5 0.1, 1 0, 1.5 0.1, 2 0)'),
+    50000
 );
 ```
diff --git a/docs/reference/sql/st_symdifference.qmd b/docs/reference/sql/st_symdifference.qmd
index fb6cd61f7..1f59a9397 100644
--- a/docs/reference/sql/st_symdifference.qmd
+++ b/docs/reference/sql/st_symdifference.qmd
@@ -17,17 +17,26 @@
 # under the License.
 
 title: ST_SymDifference
-description: Returns the parts of geometries A and B that do not overlap.
+description: Returns the parts of geometries or geographies A and B that do not overlap.
 kernels:
   - returns: geometry
     args: [geometry, geometry]
+  - returns: geography
+    args: [geography, geography]
 ---
 
 ## Examples
 
 ```sql
 SELECT ST_SymDifference(
-    ST_GeomFromWKT('POLYGON((0 0, 2 0, 2 2, 0 2, 0 0))'),
-    ST_GeomFromWKT('POLYGON((1 0, 3 0, 3 2, 1 2, 1 0))')
+    ST_GeomFromWKT('POLYGON ((0 0, 2 0, 2 2, 0 2, 0 0))'),
+    ST_GeomFromWKT('POLYGON ((1 0, 3 0, 3 2, 1 2, 1 0))')
+);
+```
+
+```sql
+SELECT ST_SymDifference(
+    ST_GeogFromWKT('POLYGON ((0 0, 2 0, 2 2, 0 2, 0 0))'),
+    ST_GeogFromWKT('POLYGON ((1 0, 3 0, 3 2, 1 2, 1 0))')
 );
 ```
diff --git a/docs/reference/sql/st_union.qmd b/docs/reference/sql/st_union.qmd
index 866a66a12..aef47ee19 100644
--- a/docs/reference/sql/st_union.qmd
+++ b/docs/reference/sql/st_union.qmd
@@ -17,17 +17,26 @@
 # under the License.
 
 title: ST_Union
-description: Returns a geometry that represents the point set union of two geometries.
+description: Returns a geometry or geography that represents the point set union of two geometries or geographies.
 kernels:
   - returns: geometry
     args: [geometry, geometry]
+  - returns: geography
+    args: [geography, geography]
 ---
 
 ## Examples
 
 ```sql
 SELECT ST_Union(
-    ST_GeomFromWKT('POLYGON((0 0, 2 0, 2 2, 0 2, 0 0))'),
-    ST_GeomFromWKT('POLYGON((1 0, 3 0, 3 2, 1 2, 1 0))')
+    ST_GeomFromWKT('POLYGON ((0 0, 2 0, 2 2, 0 2, 0 0))'),
+    ST_GeomFromWKT('POLYGON ((1 0, 3 0, 3 2, 1 2, 1 0))')
+);
+```
+
+```sql
+SELECT ST_Union(
+    ST_GeogFromWKT('POLYGON ((0 0, 2 0, 2 2, 0 2, 0 0))'),
+    ST_GeogFromWKT('POLYGON ((1 0, 3 0, 3 2, 1 2, 1 0))')
 );
 ```
diff --git a/docs/reference/sql/st_within.qmd b/docs/reference/sql/st_within.qmd
index a05fb525e..7416fea6c 100644
--- a/docs/reference/sql/st_within.qmd
+++ b/docs/reference/sql/st_within.qmd
@@ -21,6 +21,8 @@ description: Returns true if A is completely inside B.
 kernels:
   - returns: boolean
     args: [geometry, geometry]
+  - returns: boolean
+    args: [geography, geography]
 ---
 
 ## Description
@@ -32,7 +34,14 @@ of `ST_Contains`: `ST_Within(A, B)` is equivalent to `ST_Contains(B, A)`.
 
 ```sql
 SELECT ST_Within(
-    ST_GeomFromWKT('POINT(1 1)'),
-    ST_GeomFromWKT('POLYGON((0 0, 2 0, 2 2, 0 2, 0 0))')
+    ST_GeomFromWKT('POINT (1 1)'),
+    ST_GeomFromWKT('POLYGON ((0 0, 2 0, 2 2, 0 2, 0 0))')
+);
+```
+
+```sql
+SELECT ST_Within(
+    ST_GeogFromWKT('POINT (1 1)'),
+    ST_GeogFromWKT('POLYGON ((0 0, 2 0, 2 2, 0 2, 0 0))')
 );
 ```
diff --git a/docs/reference/sql/st_x.qmd b/docs/reference/sql/st_x.qmd
index 71bb500b1..9ca89a4ec 100644
--- a/docs/reference/sql/st_x.qmd
+++ b/docs/reference/sql/st_x.qmd
@@ -17,10 +17,12 @@
 # under the License.
 
 title: ST_X
-description: Returns the X coordinate of the point, or NULL if not available.
+description: Returns the X coordinate (longitude for geography) of the point, or NULL if not available.
 kernels:
   - returns: double
     args: [geometry]
+  - returns: double
+    args: [geography]
 ---
 
 ## Description
@@ -31,5 +33,8 @@ Returns NULL for non-point geometries or NULL input.
 
 ```sql
 SELECT ST_X(ST_Point(-74.0060, 40.7128));
--- Returns: -74.006
+```
+
+```sql
+SELECT ST_X(ST_GeogPoint(-74.0060, 40.7128));
 ```
diff --git a/docs/reference/sql/st_xmax.qmd b/docs/reference/sql/st_xmax.qmd
index 33a0f73c9..469ffbf2e 100644
--- a/docs/reference/sql/st_xmax.qmd
+++ b/docs/reference/sql/st_xmax.qmd
@@ -17,14 +17,20 @@
 # under the License.
 
 title: ST_XMax
-description: Returns the maximum X coordinate of a geometry's bounding box.
+description: Returns the maximum X coordinate (longitude for geography) of a geometry or geography's bounding box.
 kernels:
   - returns: double
     args: [geometry]
+  - returns: double
+    args: [geography]
 ---
 
 ## Examples
 
 ```sql
-SELECT ST_XMax(ST_GeomFromText('LINESTRING(0 0, 5 4)'));
+SELECT ST_XMax(ST_GeomFromText('LINESTRING (0 0, 5 4)'));
+```
+
+```sql
+SELECT ST_XMax(ST_GeogFromWKT('LINESTRING (0 0, 5 4)'));
 ```
diff --git a/docs/reference/sql/st_xmin.qmd b/docs/reference/sql/st_xmin.qmd
index 6921ff82e..1d90da821 100644
--- a/docs/reference/sql/st_xmin.qmd
+++ b/docs/reference/sql/st_xmin.qmd
@@ -17,14 +17,20 @@
 # under the License.
 
 title: ST_XMin
-description: Returns the minimum X coordinate of a geometry's bounding box.
+description: Returns the minimum X coordinate (longitude for geography) of a geometry or geography's bounding box.
 kernels:
   - returns: double
     args: [geometry]
+  - returns: double
+    args: [geography]
 ---
 
 ## Examples
 
 ```sql
-SELECT ST_XMin(ST_GeomFromText('LINESTRING(0 0, 5 4)'));
+SELECT ST_XMin(ST_GeomFromText('LINESTRING (0 0, 5 4)'));
+```
+
+```sql
+SELECT ST_XMin(ST_GeogFromWKT('LINESTRING (0 0, 5 4)'));
 ```
diff --git a/docs/reference/sql/st_y.qmd b/docs/reference/sql/st_y.qmd
index 59df3f8cf..826278c14 100644
--- a/docs/reference/sql/st_y.qmd
+++ b/docs/reference/sql/st_y.qmd
@@ -17,10 +17,12 @@
 # under the License.
 
 title: ST_Y
-description: Returns the Y coordinate of the point, or NULL if not available.
+description: Returns the Y coordinate (latitude for geography) of the point, or NULL if not available.
 kernels:
   - returns: double
     args: [geometry]
+  - returns: double
+    args: [geography]
 ---
 
 ## Description
@@ -32,3 +34,7 @@ Returns NULL for non-point geometries or NULL input.
 ```sql
 SELECT ST_Y(ST_Point(-74.0060, 40.7128));
 ```
+
+```sql
+SELECT ST_Y(ST_GeogPoint(-74.0060, 40.7128));
+```
diff --git a/docs/reference/sql/st_ymax.qmd b/docs/reference/sql/st_ymax.qmd
index a42dc3788..cc4712031 100644
--- a/docs/reference/sql/st_ymax.qmd
+++ b/docs/reference/sql/st_ymax.qmd
@@ -17,14 +17,25 @@
 # under the License.
 
 title: ST_YMax
-description: Returns the maximum Y coordinate of a geometry's bounding box.
+description: Returns the maximum Y coordinate (latitude for geography) of a geometry or geography's bounding box.
 kernels:
   - returns: double
     args: [geometry]
+  - returns: double
+    args: [geography]
 ---
 
+## Description
+
+For geography, the maximum latitude is computed considering spherical geometry (e.g., the maximum latitude of a linestring that crosses the North Pole is 90).
+
 ## Examples
 
 ```sql
 SELECT ST_YMax(ST_GeomFromText('LINESTRING(0 0, 5 4)'));
 ```
+
+
+```sql
+SELECT ST_YMax(ST_GeogFromText('LINESTRING(0 0, 5 4)'));
+```
diff --git a/docs/reference/sql/st_ymin.qmd b/docs/reference/sql/st_ymin.qmd
index e95db7af1..5ca84562a 100644
--- a/docs/reference/sql/st_ymin.qmd
+++ b/docs/reference/sql/st_ymin.qmd
@@ -17,14 +17,25 @@
 # under the License.
 
 title: ST_YMin
-description: Returns the minimum Y coordinate of a geometry's bounding box.
+description: Returns the minimum Y coordinate (latitude for geography) of a geometry or geography's bounding box.
 kernels:
   - returns: double
     args: [geometry]
+  - returns: double
+    args: [geography]
 ---
 
+## Description
+
+For geography, the minimum latitude is computed considering spherical geometry (e.g., the minimum latitude of a linestring that crosses the South Pole is -90).
+
 ## Examples
 
 ```sql
 SELECT ST_YMin(ST_GeomFromText('LINESTRING(0 0, 5 4)'));
 ```
+
+
+```sql
+SELECT ST_YMin(ST_GeogFromText('LINESTRING(0 0, 5 4)'));
+```
diff --git a/docs/reference/sql/st_zmax.qmd b/docs/reference/sql/st_zmax.qmd
index 02cea7379..9b80adc5c 100644
--- a/docs/reference/sql/st_zmax.qmd
+++ b/docs/reference/sql/st_zmax.qmd
@@ -17,14 +17,20 @@
 # under the License.
 
 title: ST_ZMax
-description: Returns the maximum Z coordinate of a geometry's bounding box.
+description: Returns the maximum Z coordinate of a geometry or geography's bounding box.
 kernels:
   - returns: double
     args: [geometry]
+  - returns: double
+    args: [geography]
 ---
 
 ## Examples
 
 ```sql
-SELECT ST_ZMax(ST_GeomFromWKT('LINESTRING Z(1 3 4, 5 6 7)'));
+SELECT ST_ZMax(ST_GeomFromWKT('LINESTRING Z (1 3 4, 5 6 7)'));
+```
+
+```sql
+SELECT ST_ZMax(ST_GeogFromWKT('LINESTRING Z (1 3 4, 5 6 7)'));
 ```
diff --git a/docs/reference/sql/st_zmin.qmd b/docs/reference/sql/st_zmin.qmd
index 3c2a50733..ef18d0255 100644
--- a/docs/reference/sql/st_zmin.qmd
+++ b/docs/reference/sql/st_zmin.qmd
@@ -17,14 +17,20 @@
 # under the License.
 
 title: ST_ZMin
-description: Returns the minimum Z coordinate of a geometry's bounding box.
+description: Returns the minimum Z coordinate of a geometry or geography's bounding box.
 kernels:
   - returns: double
     args: [geometry]
+  - returns: double
+    args: [geography]
 ---
 
 ## Examples
 
 ```sql
-SELECT ST_ZMin(ST_GeomFromWKT('LINESTRING Z(1 3 4, 5 6 7)'));
+SELECT ST_ZMin(ST_GeomFromWKT('LINESTRING Z (1 3 4, 5 6 7)'));
+```
+
+```sql
+SELECT ST_ZMin(ST_GeogFromWKT('LINESTRING Z (1 3 4, 5 6 7)'));
 ```