> ## 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](/compatibility-modes/bigquery/overview). The `GEOGRAPHY` type is supported; see [Data types](/compatibility-modes/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).