Latest Contributions by DuncanHornby

‎07-07-2023

There are several ways to achieve this, the easiest would be with a few lines of python code. As you don't state in your question if python is an option I assume you are looking for a non-coding solution? The tool Feature Vertices To Points allows you to specify which vertices, in your case end-points that should be extracted. Then is a matter of creating a new field in your line dataset and populating it with a do I flip or do I not flip the line value. You achieve that by selecting the end points using your SUB point layer (select by layer tool) and using that selection to pass the selection back to you lines and update that field. Then a final step is select all lines using your field you want to run the flip tool on.

‎06-26-2023

@KoryKramer to support @Gene_Sipes idea jumping to selected row would massively improve my workflow. I am often looking an census data and having context of where it is in the table and the adjacent rows does actually matter. I find scrolling the table in ArcPro awful compared to ArcMap. In ArcMap I could grab the vertical scroll bar and drag quickly through thousands of rows. In ArcPro to attempt to achieve the same I have to click potentially hundreds of times. When you attempt to drag the vertical scroll bar the table view goes blank until you let go. So one can never see the selected row. In an idea world I would want the same performance I see in ArcMap but if that cannot be done in the modern 64 bit beast that ArcPro is then a jump to selected row as @Gene_Sipes suggests is the next best option. I'm aware of the go to row number option but that is sort of useless if you don't know which row is selected in a table of thousands of rows. So to prove the point, I have deliberately selected a row somewhere in the table, can you see it when I scroll the table. I already know your answer! The important thing to appreciate is the table goes blank when you scroll. I'm using an i7 laptop, RTX graphic card, 16GB of RAM so a fairly high-spec machine. Table view blanks when scrolling, so impossible to see the selected row

‎06-19-2023

The extent polygon and rasters all need to be in the same coordinate system. You don't actually state that information, so my guess that is your problem.

‎06-15-2023

Fred, This is a partial solution. It certainly gets you to the dialog @Bud wants to be in but he is asking for it to open up in SQL mode, not the clunky but arguably more user friendly drop downs mode. I feel this is best solved by it being an option that someone can turn on/off. For example the horrendous grouping of model outputs that was introduced in version 2.9 (I think) which breaks all sorts of downstream processing logic was "solved" by introducing an option under the ModelBuilder tab for turning it on/off. May be we can have a default drop down or SQL mode under Table options?

‎06-13-2023

Latest version of ArcPro 3.1.2 allows you to add elevation datasets to Elevation Surfaces, you can remove the dataset but currently it is not possible to remove the Elevation Surfaces node in the TOC tree. Please add the ability to remove that too. Example is shown below. Example showing how you cannot remove the Elevation Surfaces node

‎06-11-2023

Select_2 is a result object, so meaningless in the context of deleting features. If you look at the help file on the Delete Features tool, what does it take as input for the only parameter it takes? Not a result object but a Feature Layer. You need to understand what the parameter section of the help file is tell you. So to delete the features selected by the SelectlayerByLocation tool you need to feed in the layer which in your code is Seed_Inspection_Pool. Before you run the delete tool you should always check the number of selected is what you expect.

‎06-07-2023

I have been working on a large conversion of an ArcMap AddIn into a python atbx toolbox. So far so good. I know when looking at the tool property I can encrypt the tool to protect the source code by clicking on this button: But my atbx Toolbox has many tools so I was looking at arcpy.EncryptPYT() as a way of automating the encryption of the tools in the toolbox. This does not work, I assume its for a pyt tool but there appears to be no equivalence for atbx toolboxes. Either expand the capability of arcpy.EncryptPYT() and arcpy.DecryptPYT() to work with atbx toolboxes or add new functions to arcpy that can encrypt python tools in an atbx toolbox. For the record all my python is embedded in the atbx for convenience and I will have to manually go through all tools setting the encryption password, a less than ideal situation.

‎06-07-2023

So what is your underlying data store? A File GeoDatabase, Oracle, or even a shapefile? I've always understood the SQL used by say a File GeoDatabase is some variant of the full capability of the SQL language and what you are asking may not be even possible. You could try and explore using Arcade as away of bringing in the logic you require to disable/enable labelling. That has a great range of date manipulating functions. It seems to me the SQL query component is for filtering out data but you could probably return "nothing" as a label which would be effectively the same outcome?

‎06-06-2023

With my test data written to in-memory: I can use the following SQL query to limit the data: myDates > timestamp '2023-06-06 16:00:00' And myDates < timestamp '2023-06-07 04:00:00' What expression you settle on is as I understand dictated by the underlying database you are storing your data within.

‎06-06-2023

If you want to convert each pixel to a polygon then a way to do it is: Use the raster to point Use Minimum Bounding Geometry (circle) Minimum Bounding Geometry (envelope) on the circles you just created. But why in your case you are getting stacked points from converting a raster to points that is another issue. Sounds like some extent setting, suggest you do the workflow I suggest above in a new ArcPro project so you are 100% sure you have not left some setting turned on.

‎05-24-2023

Using ArcGIS Pro 3.1.1. The Table to Table has been deprecated and ArcGIS Pro tells us we must be using the Export Table tool. When I export a standalone table to a CSV format, the output rather irritatingly includes an OID_ field. But it's never an optional to turn off in the field mapping section of the tool nor does the tool honour field visibility (e.g. I hide the ObjectID field in the table view) Now if I was exporting the data to say another file format such as dBase or even another geodatabase table then the inclusion of the OID field is logical but I'm not exporting to such format, I'm exporting to a text format that is comma separated. Now personally I would never be using a CSV but the statisticians I am generating data for require the data to be in CSV format and the OID_ field is meaningless in this context as there is another ID field within the data. I want the Export Table tool to honour field visibility and not create an OID_ field when exporting to CSV or at least give me the chance to exclude it.

‎04-28-2023

When creating a label expression or doing a field calculate the user interface provides access to a wide range of functions which you can select from, I show as way of example the Round() function that I want to use in a label expression. Notice the tooltip provides a rather pointless tip, the function name of the function I have selected. Many functions take more than one argument and no one should be expected to know every argument for every function and what order they need to be in. My idea is simply to improve what the tool tip is showing. In the case of the Round() function it should be listing the parameters as discussed here. What would make this even more useful is if it provided an example of the function being used, this would be helpful for people who are less familiar with scripting and calling functions.

‎04-23-2023

I wouldn't say they are a substitute for docstrings, if anything you've got to really want these hints and go to the effort of typing it all in knowing that the compiler ignores it all. I think they help with developing code because it seems that VSCode picks up on it all and shows them up as intellisense, which I like. But as you say well populated docstrings and lots of commenting in code should be the default to any project. Anything less just encourages sloppy and impenetrable code.

‎04-22-2023

Hello python gurus I'm hoping to get a little guidance on best practise. So I'm developing a fairly extensive set of geoprocessing tools in a toolbox (atbx) using python. For my own sanity I have decided to improve the readability of my code by employing hinting in my function parameters. Here is a short article that covers the topic. I have looked at a few of the system script tools and ESRI developers don't seem to employ hinting so there are no examples to work from, hence me coming here. This is not something I have done before in python and coming from a VB background seems to me like a very useful improvement to my code. I've always preferred strongly typed languages when coding. So I'm happy with setting basic built-in types for example in the past I might have done: def mytest(age, name): text = "Hello " + name + ", you are" + str(age) return text But with hinting used I now write my function as: def mytest(age: int, name: str) -> str: text = "Hello " + name + ", you are" + str(age) return text So my question is how do I hint for arcpy objects, say for a layer, spatial reference or polyline? Imagine I had some function like this: def dostuff(mylayer, sr, arr): # Nonsene example showing the variety of arcpy objects I might pass into a function arcpy.AddField_management(mylayer, "SiteID", "LONG") myPolyline = arcpy.Polyline(arr, sr, False, True) return myPolyline What would be the correct hinting syntax to be used for my dostuff() function which is passing in arcpy objects or even a class object I might have created?

‎04-20-2023

@LeonS your example is a good addition to the issues of entering enumerated domain information. I have to say I have found those warning messages next to useless. As you say you don't know which field they are warning you about and they provide no advice on what the values should be and under what scenario they should be used.

Online Status	Offline
Date Last Visited	yesterday

My Ideas

Latest Contributions by DuncanHornby

Re: how to change the direction for the line feature of endpoint to the SUB point feature at a time in Arcgis pro

Re: Attribute Table - "Scroll to Selected Record" Button

Re: Clipping Rasters in ModelBuilder

Re: Open definition query in SQL mode via CTRL + right-click

Allow users to remove Elevation Surfaces from TOC in a map

Re: Arcpy Delete Features

Make arcpy.EncryptPYT() and arcpy.DecryptPYT() work with atbx toolboxes

Re: Label in SQL calculate time Now + 12 hours

Re: Label in SQL calculate time Now + 12 hours

Re: Raster to Polygon (and Point) issue

Export Table tool should not create OID_ field when exporting to CSV format

Improve tooltips on functions in label expressions\field calculates

Re: Best practise in python type hinting for arcpy objects?

Best practise in python type hinting for arcpy objects?

Re: Improve ArcGIS Pro UI for entering Enumerated Domain into metadata

Re: ArcGIS Pro symbology issue/bug(?)

Re: Can I draw a graphic line to be a certain leng...

Re: Modelbuilder - Get Field Value tool won't list...

Re: Is the new ArcGIS Pro 3.6 model builder comple...

Re: Extract by Attribute Won't Work

ArcGIS Arcade

Coordinate Reference Systems