Latest Contributions by BlakeTerhune

I think you have some errors in the output table you put together here, but I think this modified code should accomplish what you're after. I also rearranged some things so it only opens the insert cursor once. def main():     import arcpy     import os     # Local variables     sourcegdb = r"N:\TechTemp\BlakeT\Work\TEMP.gdb"     table_in = os.path.join(sourcegdb, "SegmentSequence")     # Create output table     arcpy.CreateTable_management(sourcegdb, "SegmentSequence_output")     table_out = os.path.join(sourcegdb, "SegmentSequence_output")     arcpy.AddField_management(table_out, "UniqueID", "SHORT")     arcpy.AddField_management(table_out, "Begin", "SHORT")     arcpy.AddField_management(table_out, "End", "SHORT")     arcpy.AddField_management(table_out, "SegmentItems", "TEXT", field_length=255)     # Identify observation groups     sqlprefix = "DISTINCT UniqueID"     sqlpostfix = "ORDER BY UniqueID"     observations = tuple(uid[0] for uid in arcpy.da.SearchCursor(table_in, ["UniqueID"], sql_clause=(sqlprefix, sqlpostfix)))     fields_out = ["UniqueID", "Begin", "End", "SegmentItems"]     with arcpy.da.InsertCursor(table_out, fields_out) as i_cursor:         for obsv in observations:             # Read item and (begin, end) into dictionary             fields_in = ["ItemID", "Begin", "End"]             where_clause = "UniqueID = {}".format(obsv)             itemsdict = {r[0]:(r[1], r[2]) for r in arcpy.da.SearchCursor(table_in, fields_in, where_clause)}             # Identify segments             allsegments = [i[0] for i in itemsdict.values()] + [i[1] for i in itemsdict.values()]             segments = tuple(sorted(set(allsegments)))             del allsegments             # Identify items in each segment             for enum, seg in enumerate(segments):                 try:                     begin = seg                     end = segments[enum + 1]                 except IndexError:                     break                 seg_items = [k for k, v in itemsdict.items() if v[0] <= begin and v[1] >= end]                 # Write segment items to output table                 row = (obsv, begin, end, str(seg_items).strip('[]'))                 i_cursor.insertRow(row) if __name__ == '__main__':     main() ... View more

Can you upload a copy of the actual input data table? ... View more

I knew there had to be a numpy solution too; unfortunately, I know squat about it. I also like your dictionary comprehension line with the search cursor better than mine. Thanks for posting, Xander Bakker  ... View more

This appears to be a duplicate post. The other thread has more responses. Dynamic segmentation with respect to a control factor ... View more

So it's kind of like this?                1004__________                     1003_____      1002______________________________ 1001_________________________ 1000_____     0    1    2    3    4    5    6    7 So the segment from 0 to 1 includes items 1000, 1001 1 to 2 includes items 1001, 1002 2 to 3 includes items 1001, 1002 3 to 4 includes items 1001, 1002, 1004 4 to 5 includes items 1001, 1002, 1003, 1004 5 to 6 includes items 1002 6 to 7 includes items 1002 But it looks like you dissolve the segments that have the same items. So 1-2 and 2-3 become 1-3? Same with 5-6 and 6-7 becoming 5-7? ... View more

In the output table, how did you get a Begin range value of 5 when there was no Begin value of 5 in the input table? ... View more

Are all of the the "Item ID" values unique in the source table? ... View more

There's no easy, built-in way to do this. Have you considered using Subtypes? You can have different default field values based on whatever is chosen for the subtype. ... View more

Check out the Intersect Help Topic, there are some helpful Python code examples at the bottom. The function can take all three of your output files as a list for input. ... View more

I think symbolizing your polygons by population with a fill using a graduated color ramp is the easiest way to visually identify which feature is greater or less than the other. Could you describe the overall goal here? Maybe there is a different way to approach your problem. ... View more

I typically use the method Tim Witt  described to just print whatever I want to the Python Interpreter window. If you're using Esri geoprocessing tools, you can also print the original Esri messages with GetMessages (arcpy)​. ... View more

ArcGIS Help 10.1 - Using in-memory workspace Just make sure you also delete your in-memory workspace afterwards to keep things clean. ... View more