I've got a problem with an Intersects query.... I have two tables: Roads, a table of LINE objects that represent a street network, and Nodes, a table of point objects which represent the intersection of all lines. There are no polyline objects in the Roads table, and the Nodes table represents a singular intersection (no intersection points will be repeated). I then run a query to determine all line objects that intersect the intersection node. For example:
SELECT Nodes.ID, Roads.ID FROM Roads, Nodes WHERE Nodes.Obj Intersects Roads.Obj When I run the query however, I'm getting all the roads that intersect the intersection node as well as other lines that AREN'T EVEN NEAR the intersection node. There appears to be a problem with the intersection operator when used in association with my line and point objects. Anyone else seen this before? - Ian
