Need to create points at ends of lines based on # of lines meeting @ point (1,2,3,4)?

Discussion created by atlantagis on Mar 7, 2013
Latest reply on Mar 11, 2013 by mdenil
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.