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