Latest Contributions by LisaD

This may not work with the topo file.  When I did the first step (adding in the X direction) my topo is now only showing a line centered around Africa and the United States does not appear. ... View more

One last thing - everything works now except the "clickable" sidebar.  The assignment calls for either getting an info window when you click the map or when you click the name in the sidebar.  I already have the clicking the map right but the over-achiever in me would like to get the sidebar to work.  My code is at the same page indicated above.  I know this has to do with the query and defining the query but I don't understand exactly what the query does so I can't work it out.  Any help would be appreciated. ... View more

I am attempting to use states as that third layer so the grid is not pulling data from the candidate layers.  I want it to pull from the 3rd layer for the sidebar and infoWindow. ... View more

I was able to get a little further last night.  However, I still have lines of code that make my map vanish (commented out of my code right now) and the table in my sidebar is not showing up.  What I would like is for a third layer that has all those states to be used for the sidebar.  Right now when you click a state an info window comes up based on that particular candidate layer.  I want it to pull from one layer.  I am not sure how right now.  I will check out your suggestions as well. http://www.personal.psu.edu/lud143/lesson5e.html ... View more

Thank you so much!  It worked but I had to move the makefeaturelayer to below the for statement and use delete_management to delete the feature layer before it goes into the next SP.  I can't wait to know as much Python as you people all know. ... View more

I appreciate the code - but being the novice that I am I can't get it to work.  Likely missing some small thing.  First let me show you the code I wrote last night with the addition of two of your lines from the code you gave me. import arcpy arcpy.env.overwriteOutput = True # set table path intable = "C:/Project/Project.gdb/DeltaWL" shapefile="C:/Project/Project.gdb/model_nodes" spField = "SP" deltaField="Delta" cellidField="Cell_ID" rows = arcpy.SearchCursor("C:/Project/Project.gdb/DeltaWL", "SP"=='1', "", "SP; Delta; Cell_ID") currentSP = "" fields= arcpy.ListFields(intable) fieldinfo = arcpy.FieldInfo() for row in rows:        if currentSP !=row.SP:               currentSP = row.SP               currentSP=row.getValue(spField)               queryString=currentSP               for field in fields:                      if field.name == "SP":                              fieldinfo.addField(field.name, "SP_"+str(currentSP), "VISIBLE", "")                      elif field.name == "ROW":                              fieldinfo.addField(field.name, field.name, "HIDDEN", "")                      elif field.name == "COL":                              fieldinfo.addField(field.name, field.name, "HIDDEN", "")                      elif field.name =="Delta":                              fieldinfo.addField(field.name, "Delta_"+str(currentSP), "VISIBLE", "")                      elif field.name =="Cell_ID":                              fieldinfo.addField(field.name, "Cell_ID", "VISIBLE", "")                                                  arcpy.MakeTableView_management (intable, "out_" +str(currentSP), "", "", fieldinfo)                      arcpy.AddJoin_management(shapefile,"ID", "out_" +str(currentSP), "Cell_ID","KEEP_COMMON")                                           #save feature layer with joined data                      arcpy.CopyFeatures_management(shapefile, "Joined_"+field)               print queryString               print "made table" ----- this now gives me the following error: The value cannot be a feature class ERROR 000840: The value is not a Raster Layer. ERROR 000840: The value is not a Raster Catalog Layer. ERROR 000840: The value is not a Mosaic Layer. WARNING 000970: The join field ID in the join table model_nodes is not indexed. To improve performance, we recommend that an index be created for the join field in the join table. Failed to execute (AddJoin). I tried the code you gave me and made a few modifications based on names and such: import arcpy arcpy.env.overwriteOutput = True from arcpy import env import os arcpy.env.workspace = r"C:\Project\Project.gdb" model_nodes = "model_nodes" spField="SP" dataTable = "DeltaWL" #Create list of feature classes in current workspace #ASSUMPTION: feature class layers share part of name with SP value: eg. layer_1 for SP=1 fcLst = arcpy.ListFeatureClasses() #loop through possible classes and for each create TableView for sp in range(1,11): #range (1 to 10)     whereClause = 'spField = ' + str(sp)     arcpy.MakeTableView_management(dataTable,"Delta_WL" +str(spField), whereClause)     #for corresponding feature class in workspace create Feature Layer     fcName = model_nodes + str(spField) #name of input Feature Class     if fcName in fcLst:         inputFLName = model_nodes + str(spField) #name of temporary Feature Layer         arcpy.MakeFeatureLayer_management(fcName, inputFLName)                 #join data from Table View with 'Add Join' tool         #"KEEP_COMMON" parameter cause preserving only maching records         arcpy.AddJoin_management(inputFLName,"ID", Delta_WL + str(spField), "Cell_ID","KEEP_COMMON")                 #save feature layer with joined data         arcpy.CopyFeatures_management(inputFLName, "Joined_"+fcName) print "Joined_" + fcName + " created" ---- with this I don't get an error - but nothing is added to my geodatabase.  What am I missing? ... View more

I used the maketableview_management command and the script did run.  Is there something I can print out that will tell me if a temporary table with the desired information was definitely made?  Otherwise I will just have to attempt a join with a shapefile to see if it did what I wanted it to do. ... View more

I would try making a tableview with a where clause. Make a list of your where clauses or create them on the fly depending on the complexity. You may have to convert your data to a different table type first, I don't believe csv is directly supported for this tool. I will try that and let you know.  I did not know about tableview. ... View more

I also got the impression at the What's new in 10 event hosted by ESRI that you could group multiple figures into one file.  In my group we use ArcMap to make all of our figures for groundwater modeling reports.  When we are done we can have 35 .mxd files in our project folder.  After one of my coworkers mentioned it at a meeting yesterday (works in a different group) I decided to check it out.  I was very disappointed to learn that this multiple feature created a grid of the map area and created maps for each section of the grid.  We have no use for that at all. Also at the Whats new in 10 event the ESRI people said they watched users to come up with this new version.  You really need to watch members of my unit because a lot of the changes we have found so far either don't help us or make things harder.  We don't digitize streets and roads and sewer lines.  We don't care about topology.  We use ArcMap for data analysis and figure making. ... View more