Skip to main content

Documentation Index

Fetch the complete documentation index at: https://docs.wherobots.com/llms.txt

Use this file to discover all available pages before exploring further.

Geocodes an address string into a structured result containing the location geometry, a confidence score, and the scoring algorithm used. This function performs forward geocoding, converting a textual address or place name into geographic coordinates.

​
Signatures

ST_Geocode(location: String)

​
Parameters

​
location
String
required
The address or place name to geocode.

​
Return type

A struct containing:
  • location: The matched location string.
  • geometry: The point geometry of the geocoded location.
  • score: A confidence score for the match.
  • score_algorithm: The algorithm used to compute the score.

​
Examples

SELECT ST_Geocode('1600 Pennsylvania Avenue NW, Washington, DC')

SELECT result.geometry, result.score
FROM (SELECT ST_Geocode('San Francisco, CA') AS result)