Latest Contributions by MichaelVolz

Thank you R.D. Harles and Chris I thought I could get a list of all the feature classes in the file geodatabase, irregardless of whether they were in a feature dataset, from the ListFeatureClasses method, but I was incorrect.  This is very useful information. ... View more

For the direct connection, you can install the Oracle Instant Client that is available with the ArcGIS Desktop software.  This is a light-weight Oracle Client install. ... View more

Sorry about that.  I copied your script call to MakeQueryTable_management in Google, but I did not pay enough attention that it found MakeQueryLayer_management instead. I would suggest simplifying your call to MakeQueryTable_management to get it working and then add your more complex calls one-by-one until you find out what the current problem is. I would also suggest some sort of logging or print statements to see if your variables are getting populated as expected. ... View more

Unless I'm reading something wrong, the documentation at the below link says Query layers will only work with enterprise databases.  A file geodatabase is not a valid input workspace. http://resources.arcgis.com/en/help/main/10.1/index.html#//001700000174000000 I hope this does not cause problems to get this data into SDE. ... View more

Chris: The script that I am currently using in production that uses Calculate field with an index is being replaced by a View as the data is being migrated to SDE.  This simplifies the entire process where no python script is required. Do you have the means to get your data into an SDE database and create views?  My organization has a Database Administrator which is allowing us to more into this simpler environment where no python script is required. ... View more

Can you not get this functionality from the Enhanced Search Widget already? ... View more

Caleb: I would be interested in the advanced material you have. How do I go about sending you a private message? Thank you. ... View more

Stefani: You can start with the below code from the following thread: http://forums.arcgis.com/threads/20158-Creating-a-multipolygon-polygon You would need to pass in the polygons from your existing shapefile instead of building the polygons from scratch.  That would require a loop through the shapefile where you extract the shape of each polygon. import arcpy # Create an Array object for the multi-part feature. array = arcpy.Array() # List of lists of coordinates. partList = [['1.0;1.0','1.0;10.0','10.0;10.0','10.0;1.0'],             ['20.0;20.0','20.0;30.0','30.0;30.0','30.0;20.0'],             ['-20.0;-20.0','-20.0;-30.0','-30.0;-30.0','-30.0;-20.0']] # For each part, create a sub-array and populate it with #   point objects for coordList in partList:     # Create an Array object for each part.     sub_array = arcpy.Array()     # For each coordinate set, create a point object and add the x- and     #   y-coordinates to the point object, then add the point object     #   to the array object.     for coordPair in coordList:         x, y = coordPair.split(";")         pnt = arcpy.Point(x,y)         sub_array.add(pnt)     # Add in the first point of the array again to close the polygon boundary     sub_array.add(sub_array.getObject(0))     # Add the sub-array to the main array     array.add(sub_array) # Create a multi-part polygon geometry object using the array object multiPartPolygon = arcpy.Polygon(array) # Use the geometry object to create a feature class arcpy.CopyFeatures_management(multiPartPolygon, "c:/temp/geomTest.shp") ... View more

Kim: You posted the following code to help find locks and errors: set log_file=logPath python myscript.py >> %log_file% 2>&1 if %errorlevel% neq 0 exit /b %errorlevel% Do you know the location of good documentation to explain the syntax that you are using (e.g. %log_file% - use of % and errorlevel and finally /b)?  I would like to use the code, but I do not completely understand the syntax so additional documentation would be great.  Thank you. ... View more

Just search for that field while looping through the feature classes and then perform a describe on that searched field. ... View more

Robert: Can you explain in detail how you were able to get the Bing key from Microsoft?  My organization has tried to get in touch with Microsoft about purchasing the key (for over a month), but no dice. A direct line phone number or E-mail to a support person at Microsoft would be great to get around the bureaucracy of such a large organization. ... View more

Jay: In theory I agree with you that locks on different feature classes should not impact other feature classes.  Unfortunately I'm not sure whether this works in practice as I do not have any python scripts running in parallel on the same file geodatabase for my Enterprise based scheduled tasks. ... View more

Chris: Caleb's script is far more advanced than the script I was working on originally with you.  At this point the only help I can provide you with is on the original script as I do not have the time to digest and understand Caleb's script. ... View more

At this point, why don't you just log an incident with an ESRI technical support analyst who can dedicate their time to solving your problem. ... View more