Solved! Go to Solution.
Hi Richard,
I believe I am open to that... The data that I will be working with will be a temporary copy anyway, so there is no need to keep the attribute table uncluttered. Can you elaborate on hte process a bit?
What we're trying to do, in a nutshell, is create a model that will convert our segmented lines into unsegmented lines (so that AB1.1, AB1.2, AB1.3 simply becomes AB1). We need to keep some attributes from the inital segment and some from the end segment. All of the outputs and intermediate files will be a copy.
So for this step we just need to identify the last segment, grab some attributes, and apply them to the unsegmented geometry. Actually the process I was envisioning was more like: identify the last segment, delete all fields BUT the few we need, convert to midpoint, spatial join to the unsegmented geometry.
It's the "identify the last segment" part that I am having trouble with.
Thank you for the help!
Sean
Hi folks,
I am looking for a tool that I can use to select the highest value within a set of similar values.
The values are alphanumeric, and are essentially two parts merged into one field - a master ID to the left of a decimal and a segment ID to the right of the decimal. Each "master" has a different number of segments. I would like to select the feature with the higest segment ID for each unique master ID. There are roughly 5000 unique values in this field.
For instance, in a series of AB1.1, AB1.2, AB1.3, YZ4.1, YZ4.2, both AB1.3and YZ4.2 would be selected.
I would prefer to do this operation with the out-of-the- box functionality & GP tools, but could work with Python if necessary (I am an absolute novice). Any suggestions on how to approach this??
Thanks!!
Sean
Hi Richard,
I believe I am open to that... The data that I will be working with will be a temporary copy anyway, so there is no need to keep the attribute table uncluttered. Can you elaborate on hte process a bit?
What we're trying to do, in a nutshell, is create a model that will convert our segmented lines into unsegmented lines (so that AB1.1, AB1.2, AB1.3 simply becomes AB1). We need to keep some attributes from the inital segment and some from the end segment. All of the outputs and intermediate files will be a copy.
So for this step we just need to identify the last segment, grab some attributes, and apply them to the unsegmented geometry. Actually the process I was envisioning was more like: identify the last segment, delete all fields BUT the few we need, convert to midpoint, spatial join to the unsegmented geometry.
It's the "identify the last segment" part that I am having trouble with.
Thank you for the help!
Sean