> ## 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.

<AgentInstructions>

## Submitting Feedback

If you encounter incorrect, outdated, or confusing documentation on this page, submit feedback:

POST https://docs.firebolt.io/feedback

```json
{
  "path": "/reference-sql/functions-reference/geospatial/st_y",
  "feedback": "Description of the issue"
}
```

Only submit feedback when you have something specific and actionable to report.

</AgentInstructions>

> Reference material for ST_Y function

# ST_Y

Extracts the latitude coordinate of a `GEOGRAPHY` Point. Returns `NULL` for empty geography objects. Returns an error if the input is not a single Point (and not an empty `GEOGRAPHY` object).

## Syntax

```sql theme={"theme":{"light":"github-light","dark":"github-dark"}}
ST_Y(<object>)
```

## Parameters

| Parameter  | Description                                       | Supported input types |
| :--------- | :------------------------------------------------ | :-------------------- |
| `<object>` | The `GEOGRAPHY` Point to extract the latitude of. | `GEOGRAPHY`           |

## Return Type

`ST_Y` returns a value of type `DOUBLE PRECISION`.

## Example

The following code example constructs a Point in the `GEOGRAPHY` data type from longitude and latitude coordinates and extracts its latitude coordinate:

```sql theme={"theme":{"light":"github-light","dark":"github-dark"}}
SELECT ST_Y(ST_GEOGPOINT(-73.98551041593687, 40.75793403395676)) AS result
```

**Returns**

| result (DOUBLE PRECISION) |
| :------------------------ |
| 40.75793403395676         |
