I have a file geodatabase containing data for a drinking water distribution system. It contains five feature classes, four of which have data: Mains (line), Laterals (line), Hydrants (point), and Valves (point). I'm trying to use these four feature classes to generate features for my fifth class: Fittings (point). Wherever a line ends, if that point isn't already occupied by a valve or hydrant, there should be a fitting based on the following rules: 1 end-of-line = "Cap", 2 end-of-lines = "Bend", 3 end-of-lines = "Tee", and 4 end-of-lines = "Cross". (In reality it's a bit more complicated, but you get the point.) I've approached the problem from several directions including generating points at the end-of-line vertices, using a series of spatial queries, and creating a topology. So far, however, I only seem to get half way there. Any thoughts or suggestions would be greatly appreciated.