Latest Contributions by MicahBabinski

Zing!!! Love it. We just moved a whole Bureau off of them. ... View more

Sure! How about: def gdbInUse(input_file_geodatabase):     """     Determine whether any lock files exist in a file geodatabase     Returns boolean output - True or False     """     arcpy.env.workspace = input_file_geodatabase     lockList = arcpy.ListFiles("*lock*")     if lockList:         return True     else:         return False ? I'm thinking this could then be implemented in a script tool or extension using ArcObjects. Update: for an individual dataset, arcpy has a handy tool called Test Schema Lock that will return True if a schema lock can be acquired for a feature class, feature dataset, or table. Disclaimer: I'm not sure how this would work with personal geodatabase but I believe a similar method could be used to identify the record locking file that appears in the same folder as the .mdb when it is in use. I forget the extension for that type of file but have noticed it before when looking at a personal geodatabase in Windows explorer. Micah PS You had me at shrubbery. ... View more

Great, thank you Andrew! I imagine the URL parameter info will be particularly useful as we go forward. My colleague and I took some time to register each individual feature layer in AGOL and added to the Open Data group, so now we have finer control over tags and thumbnails. Would this cause problems down the road if we should decide to add layers to the Open Data service, re-ordering the index numbers of the layers? I'm still interested in querying by individual group; any additional info on that you could pass along would be fantastic. Warm Regards, Micah ... View more

Greetings Jose, A while back I developed a custom script tool which could be used in ModelBuilder to reorder the fields in a shapefile. The tool uses the GDAL/OGR library from OSGeo4W. If you are interested in diving in to custom Python script tools and open source, let me know and I can share my script. Micah ... View more

Well done! I'm a huge geonet fan. It's a great resource for people working with Esri software. ... View more

Greetings Nolan, A couple questions for you: 1. Does the service you'd like to overwrite have "Feature Access" enabled? In other words, does it need to be editable? 2. Is the service you'd like to overwrite published on your own on-premise ArcGIS Server, or on Esri's "My Hosted Services?" For an on-premise map service that does not require feature access, the following script (set up for a script tool but could be modified to be run stand-alone outside of ArcGIS), should get you there: # overwrite_service.py # Created: 3/11/2015 # Author:   Micah Babinski #           City of Portland #           Bureau of Technology Services #           [email protected] #           503.823.1091 # # Description: Overwrites an existing map service on ArcGIS Server # import arcpy import xml.dom.minidom as DOM # User parameters map_document = arcpy.GetParameterAsText(0) service_folder = arcpy.GetParameterAsText(1) service_name = arcpy.GetParameterAsText(2) # Create the MXD object and define the summary and tags arcpy.AddMessage("Creating an MXD object and retrieving the summary and tags.") mxd = arcpy.mapping.MapDocument(map_document) summary = mxd.summary tags = mxd.tags # Define the workspace path arcpy.AddMessage("Defining the workspace path.") workspace = arcpy.Describe(map_document).path + "\\" # Define the AGS connection arcpy.AddMessage("Defining the AGS connection file.") con = #r"Path to your arcgis server connection eg: GIS Servers\arcgis on myserver_6080 (admin)" # Create a variable representing the output service definition draft sddraft = workspace + service_name + '.sddraft' # Create a variable representing the output service draft sd = workspace + service_name + '.sd' # Create service definition draft arcpy.AddMessage("Creating the service definition draft.") analysis = arcpy.mapping.CreateMapSDDraft(mxd, sddraft, service_name, 'ARCGIS_SERVER', con, False, service_folder, summary, tags) # Set service type to esriServiceDefinitionType_Replacement arcpy.AddMessage("Setting the service type to be a replacement.") newType = 'esriServiceDefinitionType_Replacement' xml = sddraft doc = DOM.parse(xml) descriptions = doc.getElementsByTagName('Type') for desc in descriptions:     if desc.parentNode.tagName == 'SVCManifest':         if desc.hasChildNodes():             desc.firstChild.data = newType outXml = xml    f = open(outXml, 'w')     doc.writexml( f )     f.close() # Stage and upload the service if the sddraft analysis did not contain errors if analysis['errors'] == {}:     # Execute StageService     arcpy.AddMessage("Staging the service.")     arcpy.StageService_server(sddraft, sd)     # Execute UploadServiceDefinition     arcpy.AddMessage("Uploading the service.")     arcpy.UploadServiceDefinition_server(sd, con)     arcpy.AddMessage("Upload successful!") else:     # If the sddraft analysis contained errors, display them     arcpy.AddMessage("The following errors prevented overwriting of the service:")     arcpy.AddMessage(analysis['errors']) # Remove the sd draft and sd files arcpy.AddMessage("Cleaning up.") arcpy.Delete_management(sd) arcpy.Delete_management(sddraft) Now if you need feature access, it gets more complicated . I haven't figured out how to overwrite an on-premise editable feature service with Python yet, but I have asked about it on geonet. For overwriting an Esri-hosted feature service, there is a code sample here, but I haven't tested it yet. If you figure out how to overwrite the on-premise editable service, PLEASE let me know. Happy scripting! Micah ... View more

FYI, there is a geonet thread related to this topic. It can be accomplished using some ArcObjects integration with Python, but it would be wonderful if this idea were promoted and the functionality included in a future release of the software, ... View more

Hi Lance, Thanks for mentioning the Esri Idea related to this. I've promoted it and hope others will as well. ... View more

Things are slow right now at work so I found an answer to the second part of this question: how to get the file geodatabase table/feature class size. In Snippets.py, underneath the GetModifiedDate function, insert: def GetFileSize(gdb, tableName, featureDataset):     # Define a function which will convert bytes to a meaningful unit     def convert_bytes(bytes):         bytes = float(bytes)         if bytes >= 1099511627776:             terabytes = bytes / 1099511627776             size = '%.2f TB' % terabytes         elif bytes >= 1073741824:             gigabytes = bytes / 1073741824             size = '%.2f GB' % gigabytes         elif bytes >= 1048576:             megabytes = bytes / 1048576             size = '%.2f MB' % megabytes         elif bytes >= 1024:             kilobytes = bytes / 1024             size = '%.2f KB' % kilobytes         else:             size = '%.2 fb' % bytes         return size     # Setup     GetStandaloneModules()     InitStandalone()     import comtypes.gen.esriSystem as esriSystem     import comtypes.gen.esriGeoDatabase as esriGeoDatabase     import comtypes.gen.esriDataSourcesGDB as esriDataSourcesGDB     # Open the FGDB     pWS = Standalone_OpenFileGDB(gdb)     # Create empty Properties Set     pPropSet = NewObj(esriSystem.PropertySet, esriSystem.IPropertySet)     pPropSet.SetProperty("database", gdb)     # Cast the FGDB as IFeatureWorkspace     pFW = CType(pWS, esriGeoDatabase.IFeatureWorkspace)     # Get the info for a stand-alone table     if featureDataset == "standalone":         # Open the table         pTab = pFW.OpenTable(tableName)         # Cast the table to an IDatasetFileStat object         pDFS = CType(pTab, esriGeoDatabase.IDatasetFileStat)         # Return the size         return convert_bytes(pDFS.StatSize)     else:         # Open the feature class         pTab = pFW.OpenFeatureClass(tableName)         # Cast the table as a IDatasetFileStat         pDFS = CType(pTab, esriGeoDatabase.IDatasetFileStat)         # Return the size         return convert_bytes(pDFS.StatSize)       It's very similar to the GetModifiedDate function, but uses a different property of the IDatasetFileStat object. ...Really though, this information ought to be accessible via something like arcpy.Describe().modifiedDate arcpy.Describe().fileSize ... View more

Alas, no, the scripts were saved on a network share and the .tbx is on my C drive. Does that mean it can't be done? ... View more

Hi Matt, I don't mind at all. Thanks for the shout-out. Happy scripting! Micah ... View more

Hi Stephen, Is this something that could be accomplished with Feature Templates? Feature templates enable you to select default feature construction tools, attribute values, and symbology in an ArcMap editing environment. The different templates can be created to auto-populate certain attributes. Also, there is a setting in the editor toolbar at ArcMap 10.2 that can prompt users to enter attributes immediately after creating a feature. Also, feature templates and attribute editing are well integrated with domains (created in a geodatabase) and subtypes (created in a geodatabase feature class). Hope this helps! ... View more