Latest Contributions by StevenWorkman

‎05-10-2016

Thanks for all of the replies and help everyone. I was trying to do something similar to onchange event similar to javascript, but it looks like whenever I want to share this script with others, the hard coded values will need to be changed to match their data. I'll look more into it and let you all know what I find out.

‎05-06-2016

Thanks Dan. I have all of my parameters set up in my model. Maybe my question wasn't clear. I've updated the original question to show what I meant.

‎05-06-2016

Hi everyone. Is it possible to change the default value of a parameter if the user selects a different value before running the model? For example, if the user wants to change the distance in a distance parameter (from 20 feet to 50 feet), then the next time the user runs the model 50 feet will be the default value. Assume this user does not know how to alter the parameter defaults values in model builder itself. They just want to run the model. Any help will be appreciated. What I need to happen is after a user changes the parameter value in the model, when the model is run again, the new value is now the default value. Parameter set up in Model User runs opens the model and sees the default value of Rural or Urban Local Road Distance as 0: User wants to change the value of Rural or Urban Local Road Distance to 20: Model Runs.... Next time user opens the model the default value is now 20: Thanks!

‎03-16-2016

Thank you Jake. That worked!

‎03-16-2016

I am downloading it from ArcGIS online. Can I do a for loop inside that parameter to loop through each matching table? Since I sorted both lists, the items and the indexes are identical.

‎03-16-2016

Thanks Wes, I'll look into it. I haven't worked with field mappings before. There are about 40 tables with about 30 fields each, so yea it'll probably be pretty cumbersome to go that route.

‎03-16-2016

I'm working on a project where we are collecting data out in the field and downloading it from ArcGIS online. We have 4 different apps from where we download data and put them into 4 different geodatabases. The four databases are: Elec, Site, Mech, and Stru. I need to do weekly updates and join the data that's collected in the field to the tables we have in our master database. There are 40 different tables that need to be updated. I'm kind of a beginner in python but what I need to know is how to batch append records from multiple tables in multiple databases to a single database. I've tried to use python and model builder to do this, but the model is massive and there are too many parameters. I also have to run the model 4 times for each database we download the data from. I've started the script but am running into an error where the schema's aren't matching. I think what is happening is I'm not able to match the names of the items in two different lists. The lists (inputTablesJoin and outputTables) are identical and each matching table name has the same schema too. Here's my code: import arcpy import os workspace = "C:\data\Pump_Station_Inspections" inputTables = [] ## Walk through each folder containing the downloaded data and find tables (Elec, Site, Mech, and Stru) walk = arcpy.da.Walk(workspace, datatype = "Table") inputTablesJoin = [] ## Append tables to list for dirpath, dirnames, filenames in walk: for filename in filenames: inputTables.append(filename) inputTables.sort() ## Create a list of tables from the master geodatabase arcpy.env.workspace = "C:\data\Pump_Station_Inspections\InspectionsGISData.gdb" outputTables = arcpy.ListTables() outputTables.sort() for inputTable in inputTables: if inputTable in outputTables: inputTablesJoin.append(inputTable) for table in inputTablesJoin: arcpy.Append_management(table, outputTables) Any help will be much appreciated. Thanks!!

‎06-25-2015

@

‎05-18-2012

Thank you for the responses you guys.

‎05-17-2012

Hello everyone. Im a recent college grad who is now working for a state agency. They have presented a great opportunity for me to use statewide environmental data and develop a web map so the public can access information on our website. We are using Silverlight, and Visual Web Developer Express. Im really excited to dive into this, but I have no experience in this area of GIS. What would be the best way for someone to learn the API for Silverlight? What are the basics I should start with and how should I progress from there? Do I need to learn a programming language? Thanks for any help in advance. -Steven

‎05-01-2012

I made a few adjustments to the script and it runs without getting any errors. I highlighted the changes in red: import arcpy arcpy.env.workspace = "X:" ws = arcpy.ListWorkspaces("*","Folder") arcpy.env.overwriteOutput = True tempLayer = r"in_memory\templayer" field = "Label" value = "drillholes" where = "%s = '%s'" % (field,value) dhList = [] for w in ws: arcpy.env.workspace = w gdb = arcpy.ListWorkspaces("*", "Access") for fc in gdb: arcpy.env.workspace = fc fcl = arcpy.ListDatasets("*", "Feature") for fcc in fcl: arcpy.env.workspace = fcc fccl = arcpy.ListFeatureClasses("*", "All") for stil in fccl: arcpy.MakeFeatureLayer_management(stil, tempLayer, where) arcpy.SelectLayerByAttribute_management(tempLayer,"SUBSET_SELECTION") count = str(arcpy.GetCount_management(tempLayer).getOutput) if count > 0: dhList.append(stil) for item in dhList: print item The only problem now is the output is showing all of the feature classes in my directory instead only the feature classes that contain drillholes.

‎05-01-2012

That would probably be because there was no except statement added at the end. A simpler way to go about it might be to make a temp feature layer from each fc and do a select by attribute to see if get count returns anything. Ok. Ill try that method. You are saying that I need use MakeFeatureLayer_management (in_features, out_layer, where_clause, workspace, field_info) and make my in_features the list of layers (fccl). Does that need to be nested inside the loop? If you could, can you help me out with the code for that? Im a recent grad and am really new to this stuff. Thanks for any help. Heres what I have so far, but it isnt working. for w in ws: arcpy.env.workspace = w gdb = arcpy.ListWorkspaces("*", "Access") for fc in gdb: arcpy.env.workspace = fc fcl = arcpy.ListDatasets("*", "Feature") for fcc in fcl: arcpy.env.workspace = fcc fccl = arcpy.ListFeatureClasses("*", "All") for stil in fccl: arcpy.env.workspace = fccl stil = arcpy.SaveToLayerFile_management("fccl","fccl2","") Traceback (most recent call last): File "C:\Python26\ArcGIS10.0\Lib\site-packages\Pythonwin\pywin\framework\scriptutils.py", line 322, in RunScript debugger.run(codeObject, __main__.__dict__, start_stepping=0) File "C:\Python26\ArcGIS10.0\Lib\site-packages\Pythonwin\pywin\debugger\__init__.py", line 60, in run _GetCurrentDebugger().run(cmd, globals,locals, start_stepping) File "C:\Python26\ArcGIS10.0\Lib\site-packages\Pythonwin\pywin\debugger\debugger.py", line 655, in run exec cmd in globals, locals File "C:\Documents and Settings\WorkmanS\Desktop\Script5.py", line 16, in <module> arcpy.env.workspace = fccl File "C:\Program Files\ArcGIS\Desktop10.0\arcpy\arcpy\geoprocessing\_base.py", line 505, in set_ self[env] = val File "C:\Program Files\ArcGIS\Desktop10.0\arcpy\arcpy\geoprocessing\_base.py", line 557, in __setitem__ ret_ = setattr(self._gp, item, value) RuntimeError: <unprintable RuntimeError object>

‎04-30-2012

Not quite sure what you are asking. What about the attribute 'drillhole' in the 'Label' field do you want to know? The OID? Number of occurrences? Here's an example of identifying the row and then you can do what you want from there. field = "Label" value = "drillhole" for fc in fccl: try: s_curs = arcpy.SearchCursor(fc,"%s = '%s'" % (field,value),"","Label") for row in s_curs: # do something as each row should be a drillhole Thanks for you help Mathew. I am trying to find out which feature classes in a directory with 200+ folders has drillholes. I tried the code you gave me but this was what was returned: General function failure [ballinp_1] Too few parameters. Expected 1.

‎04-30-2012

Hello all. Im a novice when it comes to python. Im trying to use a search cursor to retrieve the specific value "drillhole" in the "Label" field of the attribute table for each feature class in a large directory. Here is my code: import arcpy arcpy.env.workspace = "X:" ws = arcpy.ListWorkspaces("*","Folder") for w in ws: arcpy.env.workspace = w gdb = arcpy.ListWorkspaces("*", "Access") for fc in gdb: arcpy.env.workspace = fc fcl = arcpy.ListDatasets("*", "Feature") for fcc in fcl: arcpy.env.workspace = fcc fccl = arcpy.ListFeatureClasses("*", "All") print fccl Is there a way to use the search cursor on the list "fccl" in order to loop through all of these feature datasets and return the value "drillhole"? Thanks for any help.

‎04-27-2012

Really appreciate the help you guys! Ill check back if I cant get this thing going.

Online Status	Offline
Date Last Visited	‎11-11-2020 02:24 AM

My Ideas

Latest Contributions by StevenWorkman

Re: Updating a Model Parameter Default Value after Model Run

Re: Updating a Model Parameter Default Value after Model Run

Updating a Model Parameter Default Value after Model Run

Re: Batch Append records from multiple tables to a master geodatabase?

Re: Batch Append records from multiple tables to a master geodatabase?

Re: Batch Append records from multiple tables to a master geodatabase?

Batch Append records from multiple tables to a master geodatabase?

Re: NHDPlusV2 Accumulate Attributes tool on 10.2

Re: Learning Silverlight, where to start??

Learning Silverlight, where to start??

Re: Using a search cursor for a list?

Re: Using a search cursor for a list?

Re: Using a search cursor for a list?

Using a search cursor for a list?

Re: need help with looping through .mdb, feature datasets, feature classes.