Skip to main content
Version: Streamsheets 3.0

OPENWEATHER.GEO.COORDINATES

Premium

Converts a location specified by name or zip/post code into geographical coordinates. Please refer to geocoding API for more information about available options (as of 2021-05-17).

Syntax

=OPENWEATHER.GEO.COORDINATES(City, [State], [Country], [Limit], [ResponseTarget])

Arguments

NameTypeDescription
CityStringCity name to get geographical coordinates for
State (optional)StringState code in ISO 3166 format
Country (optional)StringCountry code in ISO 3166 format
Limit (optional)NumberLimits the number of locations in response. Max limit is 5.
ResponseTarget (optional)TargetSpecify inbox, outbox, cell or cell-range to write response to

Return

TypeDescription
Boolean,Result,ErrorRequest result if no target is specified or TRUE. In case of an error the corresponding error-code is returned.

Examples

AB
1cityCologne
2limit2
3
4zipE14
5countryGB
FormulaResultComment
=OPENWEATHER.GEO.COORDINATES("Cologne")
Resolve geo coordinates for specified city
=OPENWEATHER.GEO.COORDINATES(B1,,,B2)
Same as before but using JSON to specify city name and set result limit to 2