solidDB Help : Programming : solidDB geohash functions : Using geohash functions
  
Using geohash functions
The functions listed here can be called by using the following methods:
▪ SQL statements
▪ solidDB API (SA) calls
The following table describes how to address use cases by using SQL and by using the API.
 
Use Case
ODBC / SQL
SA
Writing data
Convert coordinates to geohashes by using the GEO* SQL functions.
Write the geohash values by using the VARCHAR datatype.
Convert coordinates to geohashes by using the SaGeo* C-functions. For exact function interfaces see the header file include\sa.h.
Write the geohash values by using the VARCHAR datatype.
Reading data
Find data either regularly or by getting a set of matching geohash values by using the GEO_INSIDE predicate.
Find data by using regular SA functions. Neighboring geohash blocks, or multiple geohash blocks within borders, must be implemented by the application
For details about using geohash functions in SQL statements, including examples, see Geohash SQL functions.
For details about using solidDB API (SA) geohash functions, see Geohash SA functions.
Go up to
solidDB geohash functions