Latest Contributions by KimberlyGarbade

@VinceAngelo would you do this via the Service Broker in SQL Server for example, or would you have to use something like FME Workbench, since you need SDE in the middle when talking to Feature classes in an enterprise GDB? ... View more

@KenBuja That return Concatenate made me think python MUST have something similar and sure enough... thank you for that: test = "1,2,2,1,3,3,3,3,4,5,1,5,10" test2 = [] for x in test.split(","): test2.append(x) myset = sorted(set(test2),key=int) test = ','.join(myset) print(test) #returns 1,2,3,4,5,10 #String on numbers sorted as numbers ... View more

Did it work with so many values?... It worked when I tested it on 20 or so values, but I've never created a domain that long before.... an image of the Excel I saved as .csv and imported is below.   ... View more

The ',' is a parameter of the concatenate function, but the way you have it above your passing it to sort and sort doesn't know what to do with it. Try return concatenate(Sort(array1),',') This will sort your array values as strings (i.e. '1,10,11,2,3,33,4').  ... View more

I apologize for reiterating, but Printing to a PDF format will create a pdf file.       ... View more

They suggest some fixes here, but sounds like you've tried most of those  https://support.esri.com/en/technical-article/000023776 Have you tried printing to pdf instead of exporting?   ... View more

I have very similar code for the exceptions and lower and upper, but I like your if subDict.has_key approach better than my for x in approach so I'm stealing that. 🙂   ... View more

All O' names in this example, but ideally a solution that can be applied to all names that start with more than just a capital letter (I.E. Mc, O', St., etc)  I have thousands of comment fields that were traditionally all caps. We are transitioning to sentence case. The comments have a lot of street and person names embedded, so we wind up with things like "June paton stated it was 100 ft of rpc along the west side of 1st st." ... sure you can read it, but it looks wrong. I've corrected a bunch with "exception" lists (basically search and replace pairs of if you find this replace it with this) but names are proving difficult since Bill and water bill are two different things.   ... View more

I see the value of what you are saying.  I was hoping to use something like this, but its running up against the limits of my understanding of regular expressions in Python. I'm just so close I don't want to give up on it. import re instring = "RYAN O'NEAL AND JERRY O'CONNELL WERE ON CONAN O'BRIEN." print("Original: " + instring) instring = instring.capitalize() print("Sentence Case: " + instring) if re.search(r"\b"+"O'"+'[a-z]', instring, re.IGNORECASE): instring = re.sub("(^'O'|['])\s*([a-zA-Z])", lambda p: p.group(0).upper(), instring) print("Correct O\' names: " + instring)   It gets me here (so close but yet so far).   ... View more

I would create it in Excel.  Export to .csv and then use: Table To Domain (Data Management)—ArcGIS Pro | Documentation ... View more

If you check: That the two input layers are in the same spatial reference, That polygons in GT_10_Acre_File_Merge actually do fall completely within the bounds of the Geogia_Counties_Single_Part polygon file and; That both files do not have coordinate geometry errors.  and it all checks out (and I suspect it will) I would try using the one-to-many option.   The resulting Spatial Join file will have County Polygons showing one row for each 10_Acre_Merge_Polygon that falls within it. If everything checks out and this doesn't work then I can't fathom why no results.... maybe try switching up you inputs for example below show all of the smaller polygons that are completely within a larger polygon.       ... View more

I think this should work if you use a python function (instead of print you'll want to use return.... I didn't have ArcPro available to test it so I used the python playground at W3Schools).  A little more python could sort the ouput: test = "1,2,2,1,3,3,3,3,4,5,1,5,10" test2 = [] test3 = "" z = 1 for x in test.split(","): test2.append(x) myset = set(test2) for y in myset: if z == 1: test3 = y else: test3 = test3+","+y z = z + 1 print(test3)   ... View more

This question kept me thinking and maybe this would work, but you would need to code it in python. I'll also say it doesn't make sense to write all this code unless you've got thousands of points or are going to do this frequently (I wouldn't do it it this was a one time project with a hundred point for instance). You would also need to provide the script a centerline for the road and two point IDs; one for both the "Left" and "Right" side starting points (The points on either side of the roadway at one end of the roadway;   These could also be calculated based on the From node of the centerline, but it would add a lot of code, probably easier to just enter the IDs). 1) Either create a new "EdgeOfPavement" line file manually or have your code create it. 2) Buffer the Left side of the input centerline  3) Using Select by Location, select all the points that fall within the Left buffer polygon.  Create a temporary "LeftPoints2Analzye" feature class to put them in.  4) Select the Left starting point from this feature class (if should be a member) and use it to create a new feature class called "CurrentPoint"). 5) Delete the "CurrentPoint" from "LeftPoints2Analyze". 6) Run a spatial join using the nearest option to find the closest point in LeftPoints2Analyze to "CurrentPoint". 7) Add a line to EdgeOfPavement between the Current Point and the nearest point 😎Make the nearest point the next CurrentPoint and run steps 5-7 again.  Loop until all of the left points have been processed. This should give you the Left side of the roadway in "EdgeOfPavement".  Then you can repeat for the right side. I know its a long way to go, but its all I can think of....  ... View more

A few links that might help. Not sure the first one does what you want since it just shows the "volume" below a predefined elevation. https://pro.arcgis.com/en/pro-app/2.8/tool-reference/3d-analyst/surface-volume.htm If you actually want to.predict flooding then that is much more complex. You can use Spatial Analyst extension tools.  https://learn.arcgis.com/en/projects/predict-floods-with-unit-hydrographs/ ... View more