Geo search
geo_searchFind rows in a PostGIS-enabled table nearest to a specified longitude/latitude point. If PostGIS extension is not installed, reports unavailability.
Instructions
Find the rows nearest to a lon/lat point by PostGIS distance. Reports available=false if the postgis extension is not installed.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| limit | No | ||
| table | Yes | ||
| column | Yes | ||
| schema | Yes | ||
| database | No | Optional: target a configured secondary (read-only) database by name; omit for the primary. Call list_databases to see the configured ids. | |
| latitude | Yes | ||
| longitude | Yes |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| matches | Yes | ||
| available | Yes |