I'll try to explain this is as simply as possible. I've figured out how to create this table in SQL, no problem. But I'd like to have this done in python as part of a larger model.
I have a feature class that has points with two fields: "routename" and "miles". Each point represents a vertex on the route and the "miles" is its M value.
I have another table that represents lines. It has "routename", a field for startMile and a field for endMile and another field that has a characteristic specific to that section of route. Sometimes these can overlap. Sections of route can have multiple different characteristics (but not be the exact same start and end point).
I would like to create a new point feature class that has all the points that fall within each range (startMile to endMile), with their routename and the characteristic. I want to find the points in the first table where fcA.routename = tableB.routename AND (fcA.miles >= tableB.startMile AND tableA.miles
I have a feature class that has points with two fields: "routename" and "miles". Each point represents a vertex on the route and the "miles" is its M value.
I have another table that represents lines. It has "routename", a field for startMile and a field for endMile and another field that has a characteristic specific to that section of route. Sometimes these can overlap. Sections of route can have multiple different characteristics (but not be the exact same start and end point).
I would like to create a new point feature class that has all the points that fall within each range (startMile to endMile), with their routename and the characteristic. I want to find the points in the first table where fcA.routename = tableB.routename AND (fcA.miles >= tableB.startMile AND tableA.miles