-
Type:
Bug
-
Status: Resolved
-
Priority:
Minor
-
Resolution: Fixed
-
Affects Version/s: None
-
Fix Version/s: None
-
Component/s: How-tos / Tutorials
The current NXQL documentation for using an ES Hint for geo queries with geo_bounding_box instructs the following:
-- Use ES for GeoQuery based on geo_bounding location in a bounding box; first param is top_left, followed by bottom_right point SELECT * FROM Document WHERE /*+ES: OPERATOR(geo_bounding_box) */ osm:location IN ('40.73, -74.1', '40.01, -71.12')
This does not return the target document when tested. The format should use the left_bottom and right_top coordinates given in the form (lon, lat) as the following:
-- Use ES for GeoQuery based on geo_bounding location in a bounding box; first param is left_bottom, followed by right_top point SELECT * FROM Document WHERE /*+ES: OPERATOR(geo_bounding_box) */ osm:location IN ('-74.1, 40.01', '-71.12, 40.73')
- links to