Latest Contributions by JohnDye

I have a table that I've modified coming out of the Network Analyst OD Cost Matrix (If you've read my other post on getting a result object to a GDB Table, I am currently getting this out of ArcMap as a workaround). The table looks something like this like this, where the latter three fields are type 'Double' OriginID DestID Total_Length MarketShare Sum_MarketShare 112358924132 61124 1.24 24 55 112358924133 61124 1.36 26 44 112358924134 61124 1.54 32 64 112358924135 61124 1.72 54 109 112358924132 53856 1.36 21 55 112358924133 53856 .24 18 44 112358924134 53856 1.53 32 64 112358924135 53856 1.27 55 109 I need to calculate the 'Sum_MarketShare' field to determine the Sum off all market share for each unique Block Group set. ... View more

I have a table being returned from the Network Analyst OD Cost Matrix... I want to convert the result object to a GDB Table and I tried using this.. ODCM_Table = arcpy.na.Solve(outNALayer) #Solves the Origin-Destination Cost Matrix and produces the ODCM_Table arcpy.TableToTable_conversion(ODCM_Table, workspace + "\Default.gdb", "ODCM") # Thought this should convert result to GDB Table But it throws an error: Runtime error Traceback (most recent call last): File "<string>", line 1, in <module> File "c:\program files\arcgis\desktop10.1\arcpy\arcpy\conversion.py", line 1904, in TableToTable raise e ExecuteError: Failed to execute. Parameters are not valid. ERROR 000732: Input Rows: Dataset GPL0 does not exist or is not supported Failed to execute (TableToTable). I thought maybe the cause of the error was the formatting of the result object being held on the 'ODCM_Table' variable, so I printed it to see what it returns... print ODCM_Table GPL0 No problem I can see there. So how can I convert this result object to an actual table? ... View more

So, now I'm trying to split records into multiple feature datasets, based on the record's unique value. The end goal is to have a seperate feature dataset for each unique record. I'm getting some errors when trying to dynamically create the feature dataset though. I figured the easiest way to accomplish this would be through two seperate loops, one to create the Feature Datasets based on the uniqueVal and another to actually perform the split. workspace = arcpy.env.workspace = r"C:\Users\jdk588\Documents\New File Geodatabase.gdb" fc = r"C:\Users\jdk588\Documents\New File Geodatabase.gdb\Selected_CBSAs" uniqueSet = set([r[0] for r in arcpy.da.SearchCursor (fc, ["ID"])]) for uniqueVal in uniqueSet:      print "Creating Feature Dataset for CBSA " + uniqueVal + "..."      arcpy.CreateFeatureDataset_management(workspace, "CBSA_" + str(uniqueVal))      print "Successfully created CBSA " + str(uniqueVal) + " Feature Dataset." for uniqueVal in uniqueSet:      featureDataset = arcpy.ListDatasets("*" + str(uniqueVal), "Feature")      workspace = arcpy.env.workspace = featureDataset      print "Splitting CBSA " + str(uniqueVal) + "..."      arcpy.Select_analysis(fc, "CBSA_" + str(uniqueVal) + "_bdy", "ID = " + str(uniqueVal))      print "Success." Creation of the featuredatasets works fine and it creates them all. However in the second loop, I'm trying to load each feature into its own feature dataset using the Select_analysis tool, which means I need to set the workspace to the appropriate feature dataset with each iteration of the loop. I'm not understanding why it can't access the workspace. Runtime error Traceback (most recent call last): File "<string>", line 11, in <module> File "c:\program files (x86)\arcgis\desktop10.1\arcpy\arcpy\geoprocessing\_base.py", line 529, in set_ self[env] = val File "c:\program files (x86)\arcgis\desktop10.1\arcpy\arcpy\geoprocessing\_base.py", line 581, in __setitem__ ret_ = setattr(self._gp, item, value) RuntimeError: Object: Error in accessing environment <workspace> ... View more

Any ideas why I'm getting this error: Traceback (most recent call last): File "<string>", line 90, in execute File "c:\program files (x86)\arcgis\desktop10.1\arcpy\arcpy\analysis.py", line 98, in Select raise e ExecuteError: ERROR 000210: Cannot create output C:\Users\jdk588\Documents\New File Geodatabase.gdb\Cafe_27242.0 ERROR 000361: The name starts with an invalid character Failed to execute (Select). Failed to execute (Split). From this tool: class Toolbox(object):     def __init__(self):         """Define the toolbox (the name of the toolbox is the name of the         .pyt file)."""         self.label = "COF"         self.alias = "cof"         # List of tool classes associated with this toolbox         self.tools = [Split] class Split(object):     def __init__(self):         """Define the tool (tool name is the name of the class)."""         self.label = "Split by Unique Value"         self.description = "Splits an input featureclass into multiple feature classes by a unique value."         self.canRunInBackground = True     def getParameterInfo(self):         """Define workspace parameter"""         workspace = arcpy.Parameter(             displayName = "Workspace",             name = "in_workspace",             datatype = "DEWorkspace",             parameterType = "Required",             direction = "Input",)         """Apply workspace parameter filter"""         workspace.filter.list= ["Local Database"]         """Define in_featureclass parameter"""         in_featureclass = arcpy.Parameter(             displayName = "Feature Class to Split",             name = "in_fc",             datatype = "Feature Layer",             parameterType = "Required",             direction = "Input")         """Apply a Geometry Type Filter to in_featureclass"""         in_featureclass.filter.list = ["Point", "Polygon", "Polyline", "Multipoint"]         """Define unique field parameter"""         unique_field = arcpy.Parameter(             displayName = "Field containing Unique Values",             name = "unique_values",             datatype = "Field",             parameterType = "Required",             direction = "Input")         """Apply a dependency to unique field parameter"""         unique_field.parameterDependencies = [in_featureclass.name]         """Define outfc naming prefix parameter"""         pfx = arcpy.Parameter(             displayName = "Output Prefix",             name = "out_pfx",             datatype = "GPString",             parameterType = "Required",             direction = "Input")         params = [workspace, in_featureclass, unique_field, pfx]         return params     def isLicensed(self):         return True     def updateParameters(self, parameters):         return     def updateMessages(self, parameters):         return     def execute(self, parameters, messages):         """The source code of the tool."""         arcpy.env.workspace = parameters[0].valueAsText         fc = parameters[1].valueAsText         field = parameters[2].valueAsText         name = parameters[3].valueAsText         uniqueSet = set([r[0] for r in arcpy.da.SearchCursor (fc, [field])])         for uniqueVal in uniqueSet:             prefix = name + "_" + str(uniqueVal)             arcpy.AddMessage("Splitting " + str(uniqueVal) + "...")             arcpy.Select_analysis(fc, str(prefix), field + " = " + str(uniqueVal))             arcpy.AddMessage("Success.")         arcpy.AddMessage("All Unique Values successfully exported.") return It's obvious I'm missing something, but I don't know what. The value being entered in the pfx is just "Cafe" and it is taken as a GPString under the parameter and then converted to string again at 'name'. So...what gives? Why is the name invalid? And one more thing...why is it dropping that '.0" at the end of the name? The value its pulling from the field is '27240', where is the '.0' coming from?? ... View more