HarperDB
Search…
⌃K

geoCrosses

Determines if the geometries cross over each other. Returns boolean.

Syntax

geoCrosses(geo1, geo2)

Parameters

Parameter
Description
geo1
Required. GeoJSON geometry or feature.
geo2
Required. GeoJSON geometry or feature.

Example

Find all locations that cross over a highway.
SELECT *
FROM dev.locations
WHERE geoCrosses(
geo_data,
'{
"type": "Feature",
"properties": {
"name": "Highway I-25"
},
"geometry": {
"type": "LineString",
"coordinates": [
[-104.9139404296875,41.00477542222947],
[-105.0238037109375,39.715638134796336],
[-104.853515625,39.53370327008705],
[-104.853515625,38.81403111409755],
[-104.61181640625,38.39764411353178],
[-104.8974609375,37.68382032669382],
[-104.501953125,37.00255267215955]
]
}
}'
)
Last modified 2mo ago
© HarperDB. All Rights Reserved