SELECT streetName
FROM sample_streets
WHERE streetShape.ST_Intersects(
NEW ST_Geometry('LINESTRING(2 2, 3 2, 4 1)')) = 1
ORDER BY streetName;
SELECT streetName
FROM sample_streets
WHERE streetShape.ST_Intersects(
NEW ST_Geometry('LINESTRING(2 2, 3 2, 4 1)')) = 1
ORDER BY streetName;