I'm looking for the best way to put records of past sewer inspections into our GIS. I have a file geodatabase feature class that is the sewers, represented by lines, and pretty much the only attributes right now are the lengths and the diameters of the pipes. I initially thought my task would be to add inspection dates to these pipe attributes, but now that I've seen the sewer TV records I understand that usually only a partial length of a pipe was inspected, so I'd like to represent which exact portions of lines were inspected. I can create a shapefile with lines representing sewer inspection locations showing the path of each actual sewer TV recording, but then I'm not sure what the next step would be to connect that information in a useful way to the pipe in which the partial inspection took place. Is dynamic segmentation something I could do with a Basic license (and as a beginner at this, with no knowledge of Python)? And do I even have enough information to attempt linear referencing if I just have the length of each polyline M? Can I get to/from measure fields from that?
