AnsweredAssumed Answered

Select rows based on values in other columns

Question asked by TyceHerrman on Jan 14, 2020
Latest reply on Jan 14, 2020 by bixb0012

Hi all,

 

I'm not exactly sure how to ask this question coherently, so I've included some admittedly low-tech dummy data to illustrate what I'm looking to do.

 

For context, I'm working with a line shapefile and node shapefile representing NYC streets and any point where they intersect, respectively (link to data). The issue I'm trying to overcome is that there is a point in the node shapefile even if there isn't a real intersection in the world due to elevation differences (e.g., an overpass over a highway).

 

Each line segment has the NODEID the line starts at and ends at as attributes (NODEID_FROM, NODEID_TO). Each line segment also includes the corresponding node elevation at each node (NODELEVEL_FROM, NODELEVEL_TO) as a factor from A-Z with M being ground level. I want to ultimately get rid of any points that don't actually represent an intersection (i.e., the lines cross in 2D, but go over or under one another based on the node level attributes).

 

To begin, I made buffers around the nodes so that I could then spatially join the intersecting line segments to the buffer with a one to many join. In effect, I tie each nodeID to the street segment approaches. In the newly created feature class, I want to iterate through each NODEID and for every corresponding NODEID_FROM or NODEID_TO, compare the corresponding NODELEVEL_FROM to the NODELEVEL_TO. My assumption is that If there is more than one level factor, it's not a real intersection and represents lines that cross above or below each other. Below is some simplified dummy data of the buffers after the spatial join. In the dummy data, I'm looking for some way to select all the rows where NODEID = 1 because there are multiple node level factors for the corresponding NODEID_FROM and NODEID_TO attributes (both M and Q). It should not select any rows where NODEID = 2 because all the corresponding NODEID_FROM and NODEID_TO values have the same level factor (M).

 

I've tried thinking this through with using a search cursor or some numpy/pandas solution, but am coming up blank on how to even begin to tackle this. Also open to entirely different ways of solving the issue of throwing out "fake" intersections.

 

NODEIDNODEID_FROMNODEID_TONODELEVEL_FROMNODELEVEL_TO
11

37

MM
1291MQ
1851QM
114QM
2142MM
2152QM
2233MQ
2287MM

Outcomes