> ## Documentation Index
> Fetch the complete documentation index at: https://docs.firebolt.io/llms.txt
> Use this file to discover all available pages before exploring further.

# Geography functions

> BigQuery geography functions supported in BigQuery compatibility mode.

<span className="feature-tag">Preview</span>

BigQuery [geography functions](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/geography_functions) available in [BigQuery compatibility mode](/reference-sql/bigquery/overview). The `GEOGRAPHY` type is supported; see [Data types](/reference-sql/bigquery/data-types) and the Firebolt [GEOGRAPHY type](/reference-sql/data-types/geography).

| Function | Support |
| :- | :- |
| [`ST_GEOGPOINT`](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/geography_functions#st_geogpoint) | Supported |
| [`ST_GEOGFROMTEXT`](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/geography_functions#st_geogfromtext) | Supported |
| [`ST_GEOGFROMGEOJSON`](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/geography_functions#st_geogfromgeojson) | Supported |
| [`ST_GEOGFROMWKB`](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/geography_functions#st_geogfromwkb) | Supported |
| [`ST_ASTEXT`](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/geography_functions#st_astext) | Supported |
| [`ST_ASBINARY`](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/geography_functions#st_asbinary) | Supported |
| [`ST_ASGEOJSON`](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/geography_functions#st_asgeojson) | Supported |
| [`ST_CONTAINS`](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/geography_functions#st_contains) | Supported |
| [`ST_COVERS`](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/geography_functions#st_covers) | Supported |
| [`ST_INTERSECTS`](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/geography_functions#st_intersects) | Supported |
| [`ST_DISTANCE`](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/geography_functions#st_distance) | Supported |
| [`ST_X`](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/geography_functions#st_x) | Supported |
| [`ST_Y`](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/geography_functions#st_y) | Supported |

Other BigQuery `ST_*` functions are not yet available in this mode. For the full set of Firebolt geospatial functions, see the [geospatial functions reference](/reference-sql/functions-reference/geospatial/st_geogfromtext).


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.