Latest Contributions by ClaudineSicker

How can I export a file geodatabase to csv table using python running a script from inside a map document. Got the following code from Mathew Coyle off this forum and ran it but it did not work for me. Other ideas? import arcpy from os import path as p fc = "C:\\Test\\Test.gdb\\Test1" CSVFile =  "C:\\Test\\Test1" def TableToCSV(fc,CSVFile):          fields = [f.name for f in arcpy.ListFields(fc) if f.type <> 'Geometry']     with open(CSVFile, 'w') as f:         f.write(','.join(fields)+'\n') #csv headers         with arcpy.da.SearchCursor(fc, fields) as cursor:             for row in cursor:                 f.write(','.join([str(r) for r in row])+'\n')     print 'Created %s Successfully' %p.basename(CSVFile) ... View more

I want to copy a geodatabase table (Test) to a dbf table (Test.dbf) but am struggling with the field mapping. I have about ten fields but only want to export the City and Zip fields into the new Test.dbf file. I can get it to write all the fields to the new dbf file but am struggling with exporting just two. Help seemed to indicate this was possible but provided no examples. Here is what I have: arcpy.TableToTable_conversion("Test","C:\\TestData","Test.dbf",,(["City"],["Zip"])) What am I doing wrong???????? ... View more

Running as python script within toolbox in ArcGIS 10.1.  Trying to say that if file is empty, populate the fields "TypeName","PERCENTAGE", "Region" with the following values: nameVariable, 0, "Georgia", otherwise, populate the table fields "Region" with "Georgia" and the field "TypeName" with "Goldfish". I cannot seem to populate the TypeName field with a variable. What am I doing wrong. I have spent two days on this and I cannot figure it out! # Geonet conversion put code in a single line.  Below is another user's attempt to get python indentation # fixed to make sense of the "answer".  Should be good thru line 20....not sure after that. import os.path import arcpy import arcgisscripting  myList = ("Fish", "Reptile","Aracnid", "Other") geoLoc = "C:\\Data\\TempData.gdb\\"  for variablefile in myList:   #  Assigning variables        species = geoLoc + (variablefile)+ "_Buffer"    # setting nameVariable       if variablefile == "Fish":     nameVariable = "Goldfish"   elif variablefile == "Reptile":     nameVariable = "Tree frog"   elif variablefile == "Aracnid":     nameVariable = "Black widow"   else:     nameVariable = "Household pet"   addRow =arcpy.da.InsertCursor(species,("TypeName","PERCENTAGE", "Region"))   result = int(arcpy.GetCount_management(species).getOutput(0))   if result == 0:     addRow.insertRow((nameVariable, 0, "Georgia"))   else:     arcpy.CalculateField_management(species, "Region", "\"Georgia\"", "PYTHON", "")     arcpy.CalculateField_management(species, "TypeName", 'nameVariable', "PYTHON", "")     #arcpy.CalculateField_management(species, "Name", "\"Goldfish\"", "PYTHON", "")  Works but doesn't use variable name     exit  I get the following error message:  ExecuteError: ERROR 000539: Error running expression: commonName  Traceback (most recent call last):    File "<expression>", line 1, in <module>  NameError: name 'commonName' is not defined  Pretty sure it is failing at nameVariable (bold).  Thanks in advance. Question from Mar 8, 2013 6:51 PM Message was edited by: Timothy Hales Formatted Code Block Message was edited by: Timothy Hales ... View more

I am using ArcGIS 10.1 and have created a script that checks to see if a file geodatabase table is empty. It is a table with no spatial referencing. The code I have thus far can add rows to tables that already have a record in it, but it will not add a new row to an empty table. Can this be done? Would it be better accomplished if it were a dbf file rather than a geodatabase table? Snippet of code looks like this:     addRow =arcpy.da.InsertCursor(Variable1,("Frequency", "Used", "Region"))     result = arcpy.GetCount_management(Variable1)     print result     print addRow     if result == 0:     [indent]addRow.insertRow((0, "Locally", 3))[/indent]      else:     [indent]do something else[/indent] result and addRow printouts are correct. Prior tests taking out the if, else statements and just running the addRow.insertRow statement showed that tables that have at least one record get appended with a new row. So I am of the opinion that I cannot add a new row using this approach. Any other ideas as to how I can add a row to an empty table. Many thanks. ... View more

I have the following script to be used inside ArcMap 10.1. It prompts the user for a shape file, creates a 2 mile buffer around it and then puts the buffered shapefile into a layer group. I want to then zoom to the buffer file. I tried to use pan to selected but since since I do not really have the buffer file selected, it is not working. Anybody know how to zoom/pan to a layer using python? Below is what I have working so far. I just need the code to zoom/pan to the extents of the "Two Mile Buffer" layer.  Thank you in advance Claudine     import os.path     import arcpy      mxd = arcpy.mapping.MapDocument("CURRENT")     dirPath = os.path.dirname(mxd.filePath)     arcpy.env.overwriteOutput = True      df = arcpy.mapping.ListDataFrames(mxd, "Layers")[0]     tocLayer = arcpy.mapping.ListLayers(mxd, "Buffer Layers", df)[0]     project = arcpy.GetParameterAsText(0)     buffer_shp = dirPath + "\\buffer.shp"      arcpy.Buffer_analysis(project, buffer_shp, "2 Miles", "FULL", "ROUND", "ALL", "")      twoMileBuffer_shp = arcpy.mapping.Layer(buffer_shp)     twoMileBuffer_shp.name = "Two Mile Buffer"     arcpy.mapping.AddLayerToGroup(df, tocLayer, twoMileBuffer_shp, "AUTO_ARRANGE") ... View more