Latest Contributions by JoeBorgione

I've always found that windows task scheduler works great until it doesn't...    ... View more

When you use a given field for the 'key' field in a relate, the values in both table need to be consistent.  I don't see the same values in K anywhere in the polygon fields. You can certainly set a relate between these two, but given the view of them, they don't have any common values between them in the respective Zone fields. ... View more

I shy away from joins when the word 'many' is used.  I prefer a relate or a relationship class. ... View more

I work for a municipal services district that takes care of the unincorporated townships in the county.  We represent them like any incorporated city. If a resident comes to us for a parcel address change, we file the change of address affidavit directly with the County Recorders office.  It's a fairly simple procedure.  Once it's recorded the other county entities like Assessor, Treasurer, etc are notified via the Recorders office. For assigning addresses in new developments, we have deployed the ESRI Address Data Management Solution. ... View more

see:  https://community.esri.com/ideas/16977  Xander Bakker‌; Attribute rules can't be applied to AGOL hosted feature layers, can they? ... View more

Take a look at this blog post from Bruce Harold‌: https://community.esri.com/community/arcgis-data-interoperability/blog/2019/09/26/using-odbc-data-sources-in-core-arcgis-pro  BTW, the personal geodatabse that was once available has gone the way of the dodo, for better or for worse. ... View more

How are you adding your excel spread sheet to AGOL?  I just created a simple spreadsheet that has 4 fields: Latitude, Longitude, Name and Type.  There are just two records, and I call it Locations.xls. In AGOL on my contents page, I click Add Item/ From Your computer and in the dialog, I navigate to my excel file. As I scroll down the dialog, AGOL is 'smart' enough to know that this is a Coordinates file, since I named the coordinate fields as such: Here are my two points and one of the popups associated with one: I'm not sure why you pop up is for an attachment; my suggestion is start over with a clean slate and try it again. ... View more

Your search cursors may be clobbering each other. I think I see what you are doing with two different SQL queries, but perhaps you could combine them into 1?  That might tidy things up a bit. It would be really helpful to: Show both of your queries Use the syntax highlighter as suggested below. Here is what your code looks like when doing so: #Set variable for yesterday's cumulative cases with arcpy.da.SearchCursor("Timelinetv", ("New_Cases", "Total_Cases"), SQLYesterday) as cursor: for row in cursor: ydaycase = (row[1]) #print "Yesterday's cumulative case number:" + str(ydaycase) #arcpy.AddMessage("Yesterday's cumulative case number:" + str(ydaycase)) with arcpy.da.SearchCursor("Timelinetv", ("New_Cases", "Total_Cases"), SQLToday) as cursor: for row in cursor: todaycase = (row[1]) #print "Today's cumulative case number:" + str(todaycase) #arcpy.AddMessage("Today's cumulative case number:" + str(todaycase)) newcase = todaycase - ydaycase print("Today's new case number: {}".format(newcase)) #arcpy.AddMessage("Today's new case number:" + str(newcase)) print (todaycase) print (ydaycase)‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ At least that's what I think it should look like... ... View more

Allison Hockey‌ - you might want to start a new thread.   I'm a little confused when you say that you access the data through portal but that you do not have enterprise.  There is a way to publish a feature layer from an enterprise geodatabase such that the attribute rules will fire. ... View more

Not sure what I was doing wrong initially, but I've been able to create an altertnames table and it works well. ... View more

Not sure what's going on, but here are some screen captures on how I do it with a plat map.  In the first screen capture you will see that I have the data I want to (Parcels) as well as my tif  (Plan.tif) in my table of contents.  The map is zoomed in to the area in which I will rectify the tif image. Next, I choose the Imagery tab and with the plan.tif selected in the table of contents I choose georeference and then fit to display.  It's not a bad match for me: Now I'm ready to add my control points. ... View more

Do you have appropriate data already displayed on your map?  By appropriate, I mean the GIS feature or features you intend to rectify your tiff image to. ... View more

Glad it worked.  As a matter of scripting style, I avoid using a + (plus) sign to concatenate variables.  For me the + sign is what you use when you are adding two or more numeric values. Since you are using 2.x Python, I'd recommend the format() function.  Once you start using 3.x you get the f string method which is even cooler. clipOutput = tempdata +'\Ogma_Clip' #becomes clipOutput = '{}\Ogma_Clip'.format(tempdata)‍‍‍‍‍ ... View more

Guess I missed that it's a function.  How are you calling the function?  Can you trap for <Null> values before hand, and then pass something like -999 to your function? ... View more