geoCrosses
Determines if the geometries cross over each other. Returns boolean.
Syntax
geoCrosses(geo1, geo2)
Parameters
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]
]
}
}'
)