|
POST
|
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
03-14-2022
11:57 AM
|
0
|
5
|
5247
|
|
POST
|
One of my layers is still labeling well outside of the clipped data frame extent, and I'm not sure why. Yes, I'm using the Standard Label Engine and would prefer to stick with that -- surely there is a way to make the labels be included in this setting without having to use the Maplex Label Engine?! See below: Any help is much appreciated!
... View more
01-11-2022
02:42 PM
|
0
|
8
|
2382
|
|
POST
|
I'm having issues with Enterprise 10.8.1 Map Viewer (Classic) and photo attachments in the pop-up. Within the pop-up configuration, I have checked the "Show feature attachments as links" box. Additionally, there is a custom symbology Arcade expression embedded in the feature layer when I bring it into the map. However, when I edit this custom symbology Arcade expression, or change anything about the symbology, it seems to make the photo attachments disappear and the "Show feature attachments as links" option is gone. Nothing else with the feature layer changes except this symbology. Furthermore, if I try to undo the symbology changes (reverting back to the original symbology Arcade expression, getting out of the map without saving, removing the symbology entirely, etc) it does not fix the issue. The option to "Show feature attachments as links" is still gone, as are the attachments. I'm not sure if it's specifically because I'm changing the symbology, but I can add the feature layer to a new map and the attachments will be visible again. I then try to input the new symbology expression and sometimes the attachments are still there -- sometimes they're not -- but when I save and refresh the map, the attachments then definitely disappear. Is this a bug? Has anyone experienced this, and if so, found a workaround? This is what I see before making changes to the symbology: This is what it looks like after making changes to the symbology: Any help is much appreciated!
... View more
09-22-2021
09:51 AM
|
0
|
0
|
755
|
|
POST
|
Darn, I'd hoped there might have been a way to do this with simple line features to avoid the process of creating a network. Thank you, though!
... View more
08-27-2021
12:31 PM
|
0
|
0
|
1234
|
|
POST
|
If I have several lines intersecting at the same vertex (i.e. a 4-way intersection), and I need to adjust the location of said vertex, is there a way to move it and have all of the intersecting lines follow? Currently, our method is to select each intersecting line and move them one at a time, since Editor doesn't allow vertex editing of more than one selected feature. Any advice is appreciated!
... View more
08-27-2021
09:48 AM
|
0
|
2
|
1252
|
|
POST
|
Wasn't it already converted to string on line 17, though? I don't "speak" Python at all, so I'm sorry if I don't grasp the concept. Anyway, there were a couple of commands in @RandyBurton 's answer that I did not have in my original code, but once I included those, it worked. Thanks for your time and effort helping me out!
... View more
03-26-2021
06:51 AM
|
0
|
0
|
5603
|
|
POST
|
Thank you for your help! @RandyBurton had a line in his solution code that worked for me. I was using this code in the Python window via ArcMap 10.8.1 and wanted to avoid creating a new layer (in memory or otherwise) in the TOC. I'm also not very proficient at Python so I apologize if my question or replies don't make sense. Thanks again!
... View more
03-26-2021
06:41 AM
|
0
|
0
|
5604
|
|
POST
|
Yes, that worked! Thank you so much! Haven't set it up to iterate yet, but for anyone else who comes across this, here is my updated code that worked for my situation: 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 = []
with arcpy.da.SearchCursor(Point,['OBJECTID']) as cursor:
for row in cursor:
pointList.append(str(row[0]))
defQuery = "Purpose = 1 AND OBJECTID IN ({})".format(",".join(pointList))
for lyr in arcpy.mapping.ListLayers(mxd):
if lyr.name == "Crossings":
lyr.definitionQuery = defQuery
arcpy.SelectLayerByAttribute_management(Point, "CLEAR_SELECTION")
arcpy.SelectLayerByAttribute_management(Polygon, "CLEAR_SELECTION")
arcpy.RefreshActiveView()
arcpy.RefreshTOC()
mxd.save()
... View more
03-26-2021
06:35 AM
|
0
|
0
|
5604
|
|
POST
|
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
03-22-2021
02:36 PM
|
0
|
6
|
5718
|
|
POST
|
We are trying to configure two URLs for an ArcGIS Collector map to automatically open a Survey123 form while out in the field. One link opens and passes the data to the Survey123 website and the other is supposed to open and pass the data to the Survey123 app. The link is working as planned for the website, but not for the app. Here are the URLs that we're using: Website - https://survey123.arcgis.com/share/xxxxxxxxxxxxxxxxxxxxxxxxx9524ed8?mode=edit&globalId={globalid} App - arcgis-survey123://?itemID=xxxxxxxxxxxxxxxxxxxxxxxxx9524ed8&mode=edit&globalId={globalid} I've x-ed out part of the survey ID in both links just for security reasons, so please don't pay attention to that part. Can anyone tell us why we can't get the data to passthrough successfully to the Survey123 app, and how we would go about fixing the URL (if that's even the problem) to get it to do so? Thanks in advance!
... View more
01-15-2021
02:41 PM
|
0
|
1
|
1228
|
|
POST
|
Definitely, thanks! This was just a small detail that was at the back of my mind.
... View more
01-08-2021
07:42 AM
|
1
|
0
|
1906
|
|
POST
|
The hyperlink method is what I'm currently using, but I was just wondering if there's a simpler way that's pre-programmed into Survey123. I'm going to assume there is not. Thank you very much for your response!
... View more
01-08-2021
06:05 AM
|
1
|
0
|
1915
|
|
POST
|
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
01-07-2021
02:54 PM
|
1
|
4
|
2120
|
|
IDEA
|
Thank you for this excellent information, @AlixVezina !
... View more
12-14-2020
07:00 AM
|
0
|
0
|
3585
|
|
IDEA
|
@AlixVezina , in my position as a DOT GIS Analyst, I set up a lot of datasets in ArcMap that I then publish to AGOL for our contractors and engineers (some who have minimal GIS experience) to take over and manage autonomously both in the office and out in the field. A common method of identifying places along a road in this industry is with a Mileage Reference Marker + Displacement system, which we can derive using XY data. Unfortunately, I don’t find the existing options of getting coordinates across any of the platforms intuitive at all. It requires a lot of background setup or diving several steps into a widget to update and refresh the geometry. I would prefer a widget equivalent of right-clicking a field in ArcMap and using the Calculate Geometry tool. For example, we have inspectors go out into the field with an iPad and use ArcGIS Collector to drop points at locations where a roadway needs to be repaired. Then one of our engineers back in the office will export those points to a table using Web AppBuilder and draw up contract plans based on the collected information. After the project is completed, we have a maintenance crew navigate back out to the site and confirm its status. It would be helpful if the engineer could just click a button to fill the coordinate fields so that we could then convert them into Mileage Reference Marker + Displacement units within Web AppBuilder (we have an internal tool developed by our IT office to do this translation). That way, the maintenance crew can easily identify and revisit the area for review. I’ve used ArcGIS Pro to add GNSS fields to the dataset and then published to our server. This seems to sync well with Collector points that are dropped (it will automatically update these fields when a new point is created), but if I use Web AppBuilder to create a point then the GNSS fields aren’t populated. Going forward, I can configure the Smart Editor widget’s Attribute Actions to automatically update the GNSS fields if a new point is created within Web AppBuilder, but any existing points that were created in Web AppBuilder before I configured the Smart Editor widget won’t update, even if I Edit Geometry. I could also fall back on the Arcade option and use the Geometry function to customize an expression. This would create another field for the coordinates, though, so I’d end up with two sets of fields for Latitude/Longitude. Ultimately, I think more coordinate collection compatibility between Web AppBuilder and Collector would be great. I’m open to other solutions, as I’m sure it’s quite possible there’s an obvious answer staring me in the face! Thank you for considering this idea!
... View more
12-10-2020
06:48 AM
|
0
|
0
|
3633
|
| Title | Kudos | Posted |
|---|---|---|
| 1 | 2 weeks ago | |
| 1 | 08-04-2025 06:07 AM | |
| 1 | 07-23-2025 09:57 AM | |
| 1 | 06-26-2025 11:06 AM | |
| 1 | 05-08-2025 08:02 AM |
| Online Status |
Offline
|
| Date Last Visited |
2 weeks ago
|