Latest Contributions by ChrisPedrezuela

Hi guys, I have a python toolbox that I have developed and is running fine at my desktop. Its using scratchfolder and scratchGDB for writing out intermediate and final data. My toolbox has Tool1 and Tool2. At my desktop testing, after running Tool1, intermediate data is written on scratchGDB (scratchFOlder is used to create temporary SDE connection files). To run Tool2, it needs to check my scratch GDB and folder to be able to do further processing and write final data still to the scratchGDB. So on a desktop this is running smoothly, but my concern now is that the end goal I have is to publish it as a GP service, but as I understand, each run of a specific GP service(or tool), it creates its own job folder and its own scratch GDB. So looking at my two tools, once they are both GP services, they will have independent scratchfolder and GDB. Is there a way to use GP service 1 results as inputs to GP service 2 job? Or should I just merge my tools as one and save trouble figuring out this issue? Thanks again, Thanos  ... View more

def CreateBiDirectionalRoute(input_lines, _routes):             try:                 in_geo = [i for i in arcpy.da.SearchCursor(input_lines, ['ID', 'SHAPE@', 'SPEEDLIMIT'])]                 incur = arcpy.da.InsertCursor(nztm_routes, ['ROUTENAME', 'ROUTENUM', 'JOINFIELD', 'SHAPE@', 'SPEEDLIMIT'])                 for _geo in in_geo:                     incur.insertRow([_geo[0], 'A', str(_geo[0])+'-'+'A', _geo[1].projectAs(arcpy.SpatialReference(###), ###), _geo[2]])                 flip_features = arcpy.FlipLine_edit(input_lines)                 in_geo2 = [k for k in arcpy.da.SearchCursor(flip_features, ['ID', 'SHAPE@','SPEEDLIMIT'])]                 for _geo2 in in_geo2:                     incur.insertRow([_geo2[0], 'B', str(_geo2[0])+'-'+'B', _geo2[1].projectAs(arcpy.SpatialReference(###), ###), _geo2[2]])                 del incur             except arcpy.ExecuteError:                 arcpy.AddMessage(arcpy.GetMessages(2)) Hi guys, from the above code, if I use a versioned sde featureclass as inputlines, I get the error above based on line 7. Is there a work around to be able to use versioned fcs for this function of mine? Thanks ... View more

Since Collector app can edit related tables, can the same functionality be implemented when creating a web app from WAB? ... View more

Hi guys, I have a hosted feature service for data collection and I would like to setup a local copy within an sde database. Is there a standard process that can be called thru python for example? I know from ArcGIS online you can download the feature service and its related tables as a fgdb. But how can you do this automatically and as a scheduled task? Thanks, Thanos ... View more

Hi guys, This might be an old discussion topic and hopefully you guys can be able to point me to the right direction. I have a single sql table that has information of bus location logs for a given time period. I want to work out a flow that will run some calculations per bus per day. So it is a table with millions of records and I was thinking of breaking the table into separate ones per day to be manageable. I've queried a single day table and I got like 1k unique bus numbers. I am wondering if its ok to create a dictionary having the bus number as key and its value would be the list of all its location logs. Wondering if this is the most practical way to go about it. Cheers! ... View more

Hi guys, I'm new in creating add-ins and just trying to give it a shot. Currently the simple one I setup is not working for me. Basically the user enters an ID, then the button when clicked should change the definition query of a layer and the dataframe changes its extents to this lyr's extents. Just wanted to know where I went wrong. thanks, import arcpy import pythonaddins class EnterQPIDNumberCBox(object):     """Implementation for CreateQPIDMapExtent_addin.eqncombobox (ComboBox)"""     def __init__(self):         self.editable = True         self.enabled = True         self.dropdownWidth = 'WWWWWWWWWW'         self.width = 'WWWWWWWWWW'     def onSelChange(self, selection):         pass     def onEditChange(self, text):         global id_input         id_input = int(text)     def onFocus(self, focused):         pass     def onEnter(self):         self.items.append(id_input)         pass     def refresh(self):         pass class QPIDToolsExt(object):     """Implementation for CreateQPIDMapExtent_addin.qpextension (Extension)"""     def __init__(self):         # For performance considerations, please remove all unused methods in this class.         self.enabled = True     def activeViewChanged(self):         pass     def contentsChanged(self):         pass class ZoomToPropertyButton(object):     """Implementation for CreateQPIDMapExtent_addin.ztpbutton (Button)"""     def __init__(self):         self.enabled = True         self.checked = False     def onClick(self):         mxd = arcpy.mapping.MapDocument('CURRENT')         df =  arcpy.mapping.ListDataFrames(mxd)[0]         lyr = arcpy.mapping.ListLayers(mxd, '#', df)[0]         lyr.definitionQuery = "ID={0}".format(id_input)         ext = lyr.getExtension()         df.extent = ext         arcpy.RefreshActiveView() ... View more