Latest Contributions by TerryGustafson

I tried that but it deletes both rows. I only wanted to delete the last row in the array after the to_measure was set. ... View more

Sorry, I looked it up and I needed to use UpdateCursor but now I get the following error.. File " TypeError: deleteRow() takes no arguments (1 given) ... View more

I’m sure that will work but I keep getting a syntax error so must have a indent wrong. ... View more

I thought this might work but no dice.. table = "Export_Output_3" ridList = [] with arcpy.da.SearchCursor(table, ["RID"]) as cursor:     for row in cursor:         ridList.append(row[0]) del cursor ridList = set(ridList) for RID in ridList:     toMeasList = []     with arcpy.da.SearchCursor(table, ["RID", "to_MEAS"], "RID = '" + RID + "'") as cursor:         for row in cursor:             toMeasList.append(row[1])     del cursor     toMeasList.sort()     with arcpy.da.UpdateCursor(table, ["to_MEAS"], "RID = '" + RID + "'") as cursor:         for row in cursor:             row[0] = toMeasList[-1]             cursor.updateRow(row)     del cursor     toMeasList.sort()     with arcpy.da.UpdateCursor(table, ["OBJECTID"], "OBJECTID = '2'") as cursor:         for row in cursor:     row[1]             cursor.deleteRow(row)     del cursor ... View more

I have created a model that has a couple input parameters and the in_table is an output parameter. I put the model in a toolbox... I then run the tool and share it as a GP service. Then when I run the GP service it asks for the inputs which would be like begin C000001E and a reference marker i.e. 22 Here is a snap shot of the model and the GP service. Here is a link to the GP service that is created. You should be able to add this to ARCMAP and run it, add the following parameters first point Corridor = C000001E. RM = 22 end point Corridor = C000001E RM 23. You can leave the offsets at zero. It should return a table in the results tab. https://app.mdt.mt.gov/arcgis/rest/services/Testing/rs/GPServer not sure if any of this makes sense.. ... View more

Hey Jake, Is there any way to delete the last record in the table once the to_offset has been calculate?  I only want to generate the first segment 22.033 to 23.533 and remove the last record 0 to 23.533. ... View more

44.. Thank you.. ... View more

So if the script is just sitting in the model with no parameters, how does it know when to be executed? ... View more

It appears that the table to table tool does not like when the table is written to a local geodatabase. When I create a .dbf table it copies the data local. Is there something I can add in the script to get it to run on a dbf? When I set the table =”output.dbf” it returns the error it could not find the table “output.dbf” ... View more

Even when I use a table view the output table from the table to table tool does not create the output table correctly.. I think it has to do something with the “Merge Rule” but can’t figure that out. ... View more

I re-read it and I was trying to convert a table and not a table view. Going to try and convert the in memory table to a view and try it again. ... View more

I was wrong I thought that Table to table would work but it still creates the table in memory and then it seems to add all the fields to one record.. ... View more

Hang on I think I have it figured out. Sorry to keep buggin you and thanks for the help.. ... View more

So I’m an idiot. I tried finding information on exporting from memory and can’t seem to find anything on it. This page talks about in-memory but nothing about exporting from it. http://resources.arcgis.com/en/help/main/10.1/index.html#//002w0000005s000000 I also was looking at this but it seems to be for input of .csv or .txt. http://resources.arcgis.com/en/help/main/10.1/index.html#//001200000027000000 I have you done an export like this? ... View more