Latest Contributions by JoshuaBixby

‎01-23-2023

It isn't just a comma or semicolon issue, the SearchCursor takes a list of strings, not a string of delimited fields.

‎01-23-2023

@TeresaDolan, thanks for the update. I will definitely try them out soon because it was a feature I relied on extensively.

‎01-19-2023

Is the polygon supposed to represent the areal coverage of the crown of a tree when they are mature? Tree crowns can be reasonably approximated by ellipses of different dimensions. Even if one wanted better representation of a tree crown than an ellipse, no tree crown in reality is going to have an "exact area."

‎01-19-2023

You can't find an easy way to do it because there is no easy way to do it. It is regularity that allows for consistent shape and size polygons to be created. Once regularity goes out the window, there are countless shapes that can meet the same size. In your case since talking about parcels, which generally are more regular (even the irregular ones) than not, I am guessing you are not looking for some amorphous blob that is 2400 sq m exactly. For anyone to offer suggestions, you will have to elaborate more on the constraints around "irregular."

‎01-16-2023

This is another good use case for my Idea for Esri to Add Python Regular Expression (re) Helpers to Calculate Field Dialog . Even without the "Helper" functions, you can still use re - Regular expression operations - Python 3 documentation by just importing the module in the code block: # Codeblock import re # Expression re.match(r"^\s*\d*", !FULLNAME!).group()

‎01-16-2023

As Dan already mentioned, this general approach will fail when there are other number sequences in the string. For example, an address like "100 South 900 West" will return "100900" with this approach.

‎01-16-2023

I just tried your example on Pro 3.0.3, and I get "An invalid SQL statement was used" error. I am able to create the tables and create the view, but I can't add it to a map. Are you able to script out your steps so I can try running the code exactly the same way because something in our workflows is obviously different if it works for you but I get an error.

‎01-16-2023

@Bud , regarding your specific query (excluding the LIMIT aspect of it), the query doesn't work because of limitations with SQL joins with file geodatabases. At least for the File Geodatabase API, Esri has always listed 2 known issues: GitHub - Esri/file-geodatabase-api: ... The File Geodatabase C++ API for Windows, MacOS and Linux Known Issues Concurrent access from Windows and Linux clients to the same File GeoDatabase can corrupt data. This combination should be avoided. SQL joins are not supported. It is likely that limitation in the FGDB API isn't just an FGDB API limitation, i.e., file geodatabases overall do not support SQL joins. Is a bullet point on a GitHub page sufficient documentation? I don't think so, I am guessing you don't think so, but it seems Esri does think so since they haven't materially improved their FGDB SQL documentation for many years.

‎01-16-2023

Using the pseudo-code directly from page I link to: # Codeblock def takewhile(predicate, iterable): for x in iterable: if predicate(x): yield x else: break # Expression "".join(takewhile(str.isdigit, !FULLNAME!))

‎01-16-2023

This isn't an issue with ArcGIS Pro, so maybe it is time to switch? Seriously though, the clock is ticking on ArcMap, and the clock long stopped for Python 2. For Python 2 (I would not recommend for Python 3), you could consider changing the default standard output to UTF-8 at the start of your script: import sys import codecs sys.stdout = codecs.getwriter("utf8")(sys.stdout) Prior to Python 3.6, Python used the ANSI APIs to interact with the Windows OS, which usually meant cp437 for English and many other locales. As you discovered, the euro symbol is not part of cp437, hence the error when trying to print or write from Python 2.7.14.

‎01-16-2023

Several ways to go about it depending on how clean and/or complicated the data are in text fields. You can use itertools.takewhile() or just adopt the pseudo-code from it.

‎01-12-2023

@JohannesLindner, I don't see people stumbling into the Helper functions, a user has to actively select it or type it in. If people are using Helper functions they know nothing about, that isn't a regular expression problem, that is a user problem. If potential audience size is a strong determining factor, how did ".as_integer_ratio" get put in the list? Also, Esri has introduced some hand-rolled Helpers like Sequential Number, which can have unexpected outcomes, so I can't see what issues there would be with adding a tried-and-true Python module.

‎01-12-2023

I have been working with QGIS more, and one aspect I find really handy with that Field Calculator is the support for a few common regular expression string functions (regexp_matches, regexp_replace, regex_substr) natively within the dialog. I think having something similar in ArcGIS Pro's Calculate Field would be useful, but I also realize the implementation in Pro could not take the same form as in QGIS. After thinking about how various functions are implemented in Calculate Field currently, I think the simplest way to make regular expression use easier would be to add a few "re" Helpers in the Calculate Field dialog similar to how "math" Helpers are added. I realize someone can import re into a code block and define a function there and use regular expression, but I also think having re.findall, re.split, and re.sub usable in the Expression block via a Helper would make using regular expression more accessible to more users. If this were to be considered, I know the likely outcome would be using "re" since it is a native/core library, but it does look like Pro already comes bundled with "regex", and I have to say I find "regex" much better at portable Unicode syntax than the "re" library.

‎01-10-2023

For two server roles, there definitely needs to be two authorization codes. Whether it is one license file with two codes or two license files with one code each is up to whoever is doing the licensing provisioning in My Esri.

‎01-05-2023

Thanks @JesseCloutier for the note, appreciate it. I know I have been significantly less active the past couple or few years, but I still try to engage when I can find time. There are several reasons I am less active, but one of them is the not-so-new platform that EC is on when it changed from GeoNet to EC. I know the older platform had its fair share of issues, but the loss of Jive Streams was probably the biggest. I find managing the streams of content on EC without Streams just too clunky, and I end up getting frustrated sifting chaff to find what I really want to focus on. I know you are too new to understand what I am talking about it, but I never miss an opportunity to bring up this missing functionality in EC currently. And no, EC subscriptions are a poor alternative. Cheers.

Online Status	Offline
Date Last Visited	Wednesday

My Ideas

Latest Contributions by JoshuaBixby

Re: How can I fix this SQL clause?

Re: The New My Esri Experience is Live!!

Re: create irregular shaped polygons to an exact area/size

Re: create irregular shaped polygons to an exact area/size

Re: Field Calc Integers from String

Re: Field Calc Integers from String

Re: SQL syntax in FGDB API should be supported in ArcGIS Pro FGDB queries

Re: SQL syntax in FGDB API should be supported in ArcGIS Pro FGDB queries

Re: Field Calc Integers from String

Re: arcpy: problem with coding

Re: Field Calc Integers from String

Re: Add Python Regular Expression (re) Helpers to Calculate Field Dialog

Add Python Regular Expression (re) Helpers to Calculate Field Dialog

Re: Installing ArcGIS Server multiple roles (GIS, Image) in a single machine for testing

Re: Our Thanks to Esri Community MVPs

Re: Regedit values to start up ArcGIS Pro as named...

Re: azure, arcgis enterprise 11.5 and poor browser...

Re: New ParameterArray container

Re: New ParameterArray container

Re: What is the fastest way to add a new machine t...

Esri Forestry Group (EFG)

Python Snippets