Latest Contributions by ThomasStanley-Jones

‎10-16-2014

I really want to be able to add breakpoints into a Python Add-In for debuggin purposes. Being able to look around at the variable values and see what's going on would save sooooooo much time. As it is, this can only be done with print statements in the code. But when you don't know what is going wrong, it's really hard to write a print statement that will tell you what you need to know without some experimentation. Every time a statement is changed, there is a 3-4 minute process of - compile the add-in, - install the add-in, - close Arc, - reopoen Arc, - run the add-in, - realize you misspelled the variable name, - repeat... Please find a way to use breakpoints in Python Add-ins!

‎10-16-2014

Is this being pushed further? With ArcGIS Pro coming out of the box with 3D, this will be extremely useful.

‎09-11-2014

I'm curious what pyodbc will give you. Arrays of the tables to use with Numpy? Do you use it to feed spatial objects into the arcpy tools? I used comtypes and ArcObjects to connect and get the data from SQLServer because then I can play with it in ArcObjects. I'm guessing pyodbc gives you an object that Arcpy can use.

‎09-11-2014

I use comtypes to interact with ArcObjects direcly. I've found it a lot less buggy than arcpy, although I don't do much more than retrieve data from our servers. def getConnection(): """ Creates and returns a connection to the Database @return: SdeWorkspace as ISqlWorkspace """ import comtypes.gen.esriSystem as esriSystem import comtypes.gen.esriDataSourcesGDB as esriDataSourcesGDB import comtypes.gen.esriGeoDatabase as esriGeodatabase # Set connection properties for OLE DB connection conprop = Snippets.NewObj(esriSystem.PropertySet, esriSystem.IPropertySet) conprop.SetProperty("INSTANCE", "sde:sqlserver:?????") conprop.SetProperty("DATABASE", "?????") conprop.SetProperty("AUTHENTICATION_MODE", "OSA") # Create workspace SDEWorkspaceFactory = Snippets.NewObj(esriDataSourcesGDB.SdeWorkspaceFactory, esriGeodatabase.IWorkspaceFactory) SDEWorkspace = SDEWorkspaceFactory.Open(conprop, 0) sqlworkspace = Snippets.CType(SDEWorkspace, esriGeodatabase.ISqlWorkspace) return sqlworkspace

‎08-07-2014

I think "ListLayers" returns a list. I'm assuming that you are only expecting one layer called "Dimensions" to be returned. Try changing this: arcpy.mapping.UpdateLayer(dFrame, upLyr, srcLyr, False) to this: arcpy.mapping.UpdateLayer(dFrame, upLyr[0], srcLyr, False)

‎08-07-2014

I'm obviously not familiar with the data your working with, but a few observations: - Have you tried putting in print() statements to see if the values are what you would expect? I would suggest putting a bunch of them between line 104 and 105 to print the various attributes of the "item" variable. Something might come to light there. - Also, I noticed that on line 45 you wrote edgeNet.Name = lines I think lines is a list, no? But sinkNet.Name = 'Sinks' sourceNet.Name = 'Sources' These are strings. Is this expected?

‎08-07-2014

What is the new error?

‎07-25-2014

This is probably what you're looking for: def findLabel(relatefieldoflayer): strWhereClause = '"&RelateFieldOfTable&" = \'{0}\''.format(relatefieldoflayer) strpTable = &PathToRelatedTable& cursor = arcpy.da.SearchCursor(strpTable, &LableField&, strWhereClause) result = "" for row in cursor: strLabel = str(row[0]) result += strLabel + "\n" return result.rstrip()

‎10-22-2013

I have also had this happen to me. Not on anything crucial though. I've usually noticed it when i try and delete a File Geodatabase with ArcCatalog 10.1. Can't say I've noticed it with 10.0. I would delete the FGDB and then it would show up as a folder with a .GDB extension. Couldn't delete it with ArcCatalog, and not even with Windows Explorer until I restarted my computer. This happened about half a dozen times before I realized what was going on. Now I only delete them with Windows Explorer.

‎04-24-2013

Huge timesaver for me if Esri implements this idea. I would be super excited about this one.

‎01-28-2013

Thank you for the idea, I hadn't thought of implemnting something this way. I need to be able to update the attributes during an editing session. To make this work I'll make a script tool with a button on the editing toolbar so when a group of lines has been created, -make sure they are selected -click on the button to run this script -choose the feature class -set the beginning number -set the interval -and run the tool Only the features that were selected will be updated. Yeah, this will work perfectly, thanks a lot!

‎01-26-2013

Hello, I'm trying to set up ArcMap 10.0 (ArcInfo License, SpatialAnalyst Extension) so that as I create new lines in a feature class, the value in a field will increase sequentially. I've been playing with the Attribute Assistant (very neat). It has a GENERATE_ID function that does what I want, but I can't control the sequence size. The value goes up by 1, but I want to make it go up by 300, or 50, depending on which kind of line I'm creating. As an example, the "LineNumber" field will equal "0", "300", and "600" if I draw 3 lines and set the sequence to be 300 and to start at 0. Does anyone know how I can do this with any available tool? Any input would be appreciated, Thanks!

‎11-16-2012

If anyone finds this thread, just wanted to let them know that the Geodatabase Diagrammer for ArcGIS 10 can be found here: http://resources.arcgis.com/gallery/file/arcobjects-net-api/details?entryID=F12ADF8F-1422-2418-34B2-C276C6BCCF98 or a slightly different implementation here (haven't tried this one): http://www.arcgis.com/home/item.html?id=a378b48be11b45b5bb25254643304cb7

‎10-11-2012

For those that see this still, I've refined the code a bit from above. Now if I'm getting values from a Multiple Parameter list in a custom tool I use this to get a clean list: >> cleanList = [param.replace("'","") for param in arcpy.GetParameterAsText(0).split(";")] I've never found any documentation on this from ESRI and it took a lot of time and frustration for me to figure this out as I wasn't a programmer before I started using ArcGIS.

‎07-19-2012

I struggled with this tool for many hours before I realized what was going wrong and why. The issue was with a space in the name of the Feature layers that were being chosen in a multivalue parameter. So this string would be returned: "'blah blah\blah';'meh meh\meh'". Then when I tried to split out the string with .split(";"), the extra quotes would stay with the string and the tool that this value was passed to would break. When there wasn't a space in the chosen parameters, I would get something like this: "blah;meh" and that would work fine. Do I need to make this check in all my code when I don't know what the users will choose? I haven't seen this in any of the examples in the help, so it caught me by surprise. How do other people deal with this? Here is the code that I came up with that works. import os import arcpy as ap lines = ap.GetParameterAsText(0).split(";") claims = ap.GetParameterAsText(1).replace("'","") claims = claims.split(";") for line in lines: for claim in claims: output = os.path.join(ap.GetParameterAsText(2),line + "_" + claim.split("\\")[1]) ap.Intersect_analysis([line, claim],output,"","","LINE")

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

My Ideas

Latest Contributions by ThomasStanley-Jones

Debug Python Add-Ins with Breakpoints

Re: Adding the functionality of 3D georeferencing of images such as sections for display in 3D such as Arcscene

Re: Is anyone else using python to directly interact with their DBMS?

Re: Is anyone else using python to directly interact with their DBMS?

Re: inconsistent Arcpy.Mapping behaviour

Re: Build Network Dataset with python comtypes and ArcObjects

Re: Build Network Dataset with python comtypes and ArcObjects

Re: python - label from a related table

Re: File Geodatabase Failure

Re: Layer Symbology should include Label settings

Re: Dynamic Value increase for each new line

Dynamic Value increase for each new line

Re: Geodatabase Design

Re: Multivalue Parameter in Custom tool adds extra quotes

Multivalue Parameter in Custom tool adds extra quotes

Multivalue Parameter in Custom tool adds extra quo...

Re: Build Network Dataset with python comtypes and...

Debug Python Add-Ins with Breakpoints

Re: python - label from a related table