Latest Contributions by KathrynWesson

Hi everyone! I could really use some help with this, because I have no idea what I'm doing. Basically, I'm trying to create a SQL View in ArcCatalog that references four SDE feature classes of various pavement types. They were published as a feature service through ArcGIS Pro to our organization's Portal (e.g. they are hosted on our own servers, but I am not the author of the data) for multiple people to survey in Field Maps. I therefore want the View to be linked in such a way that it automatically "refreshes" to reflect any updates that are made to the parent feature classes. I was able to create a SQL View through ArcCatalog with the command UNION ALL to grab all records from the parent feature classes. Initially, the total number of records in the View matched the total number of records from all four parent feature classes. However, I noticed today that the View now has 1,241 more records than before. I'm quite sure no one but myself is looking at/making changes to the parent data, and all I've done is delete a single record from one of the parent feature classes to test that updates are translating. So, I'm not sure where this disparity is coming from. I wonder if I need to "Register with Geodatabase" to get my View to sync up properly. Apparently it needs an OBJECTID field with unique values. Here's where I run into issues; each parent feature class has its own OBJECTID field that starts with 1, so when I run the UNION ALL command on them, the OBJECTID field has duplicate values. How would I go about adding and populating an OBJECTID field with unique and sequential values to my SQL View through ArcCatalog? Here is what I have so far: The highlighted items in the Catalog tree are the four parent feature classes. The first portion of the View Definition seemingly works, but I'm struggling with the last two lines of the command (concerning the new field). How would I adjust my View Definition to add and populate this new unique identifier field? Any help would be greatly appreciated! ArcGIS Desktop 10.8.1 - ArcGIS Pro 2.6.1 - Portal for ArcGIS 10.8.1 (production server) - Portal for ArcGIS 10.9.1 (test sever) ... View more

Hi! Need some help fixing a code I found online and am trying to customize to my needs. I have a series of 90 map documents, where each one is a different school district and shows the railroad crossings within its boundaries. What I would like the code to do is iterate through each map document, select by location all crossings that intersect the school district within 150 feet, create a list of the ObjectIDs from those selected points, then throw that list of values into the layer's definition query. The list of crossings should therefore be unique to each map document. Here is what I have so far (not set up for iteration yet):     mxd = arcpy.mapping.MapDocument("CURRENT") df = arcpy.mapping.ListDataFrames(mxd, '')[0] for lyr in arcpy.mapping.ListLayers(mxd): if lyr.name == "Crossings": Point = lyr if lyr.name == "Current School District Boundaries": Polygon = lyr arcpy.SelectLayerByLocation_management(Point, "WITHIN_A_DISTANCE", Polygon, "150 Feet", "NEW_SELECTION") pointList = [] for row in arcpy.SearchCursor(Point): strrow = str(row.OBJECTID) pointList.append(strrow) txt_row = ','.join(pointList) row_list = '(' + txt_row + ')' for lyr in arcpy.mapping.ListLayers(mxd): if lyr.name == "Point": lyr.definitionQuery = ' "OBJECTID IN" + row_list ' arcpy.SelectLayerByAttribute_management(Point, "CLEAR_SELECTION") arcpy.SelectLayerByAttribute_management(Polygon, "CLEAR_SELECTION") arcpy.RefreshActiveView() arcpy.RefreshTOC() mxd.save()      I can see the code working when I run it, and it doesn't kick out any errors, but when I check the definition query, it hasn't updated. What am I doing wrong? Thanks in advance! ... View more

Can I hop back to ArcGIS Collector from Survey123, to the same feature I was editing, without the use of a URL? I'm looking for the equivalent of a "back button" (like what you see in smartphones when clicking a link within a webpage). Hoping there's a box that I can check in the Survey123 Connect settings instead of hitting the Home button and re-entering ArcGIS Collector through the Home screen. ... View more