Latest Contributions by AndrewVitale

I'm attempting to update a numeric field using an arcpy.da.UpdateCursor. I'm applying the update to a Feature Layer and Table, which participate in a One to Many Relationship. The Feature layer is quite large, with 1,219,495 Polygon records. The table has even more records at 4,735,679 rows. The update should only be applied if certain conditions are met. If the Child Table's Provider field has a value of "Optimum", it needs updated. If the Parent Feature's MaxDownload field is 1,000, it needs updated. I'm doing the queries first via SearchCursor, and saving the relevant IDs that satisfy the query. Then, in an edit session, I'm attempting to update the relevant fields using a where_clause to select the OIDs I need.     import datetime as dt import arcpy def log_it(msg): print(f"[{dt.datetime.now()}]: {msg}") return def query_str_in_list(field_name, values): vals = "'" + "', '".join(values) + "'" return f"{field_name} IN ({vals})" def query_int_in_list(field_name, values): vals = ", ".join([str(v) for v in values]) return f"{field_name} IN ({vals})" def main(): start_time = dt.datetime.now() print(f"Starting script at {start_time}") arcpy.env.workspace = r"C:\dev\arcgis\NYS-DPS\NysDpsBroadbandMap\2022-06-01_Analysis\2022-06-01_Analysis\NysDpsBroadbandMap.gdb" global_ids = [] provider_oids = [] with arcpy.da.SearchCursor( "StandardProviders", ["ParentGlobalID", "OBJECTID"], where_clause="Provider = 'Optimum'", ) as search_cursor: for row in search_cursor: global_ids.append(row[0]) provider_oids.append(row[1]) polygon_oids = [ row[0] for row in arcpy.da.SearchCursor( "StandardSummaryPolygons", ["OBJECTID"], where_clause=query_str_in_list("GlobalID", global_ids) + " AND MaxDownload = 1000", ) ] log_it( f"Beginning to edit {len(provider_oids)} Provider Records and {len(polygon_oids)} Polygon Records" ) with arcpy.da.Editor(arcpy.env.workspace) as edit_session: with arcpy.da.UpdateCursor( "StandardSummaryPolygons", ["OID@", "MaxDownload"], where_clause=query_int_in_list("OBJECTID", polygon_oids), ) as polygon_update_cursor: for idx, row in enumerate(polygon_update_cursor): log_it(f"{idx} Polygon Iterations") oid = row[0] if oid in polygon_oids: polygon_update_cursor.updateRow([oid, 940]) with arcpy.da.UpdateCursor( "StandardProviders", ["OID@", "Download"], where_clause=query_int_in_list("OBJECTID", provider_oids), ) as provider_update_cursor: for idx, row in enumerate(provider_update_cursor): log_it(f"{idx} Provider Iterations") oid = row[0] if oid in provider_oids: provider_update_cursor.updateRow([oid, 940]) end_time = dt.datetime.now() duration = end_time - start_time print(f"Finished at {end_time} after executing for {duration}") return if __name__ == "__main__": main()     The script is going quite slow, and it appears that the Polygon Feature Class is the root cause. When iterating through the cursor, each iteration is taking 2 seconds. Iterating through the table gives the performance I would expect. Here's a log snippet:   ## Parent Table Log (Polygon Features) Starting script at 2022-07-20 14:13:51.937132 [2022-07-20 14:13:59.535107]: Beginning to edit 276149 Provider Records and 212815 Polygon Records [2022-07-20 14:13:59.801700]: 0 Polygon Iterations [2022-07-20 14:14:01.015486]: 1 Polygon Iterations [2022-07-20 14:14:02.363565]: 2 Polygon Iterations [2022-07-20 14:14:03.780736]: 3 Polygon Iterations ## Child Table Log (Table Rows) [2022-07-20 14:19:10.037031]: 6740 Provider Iterations [2022-07-20 14:19:10.037031]: 6741 Provider Iterations [2022-07-20 14:19:10.038029]: 6742 Provider Iterations [2022-07-20 14:19:10.038029]: 6743 Provider Iterations     Am I simply running into physical limits due to the volume of the data? Are there any performance gains that could be implemented here? Thanks! ... View more

Hello, I'm trying to integrate an application with Survey123 using the documentation found here: https://doc.arcgis.com/en/survey123/reference/integratewithotherapps.htm In our application, users will be presented a map of features from a system of record (SOR). From there, they may decide they want to update that record with new information gathered from the field. For the field work, we're using ArcGIS Survey123, which has the benefit of isolating the field data in a Feature Service, allowing the field data to be reviewed before loading it into the SOR. The features from the system of record are polygons, many of which have been created by buffering points. Thus, they have too many vertices to be passed to the ArcGIS Survey123 field app in the URL using the `field:fieldName=This%20value` syntax. To get around this, we're using the /applyEdits endpoint of the S123 feature service to POST a new record with the data from the SOR from our JavaScript application. Once the new record  is created, we would like to use the globalid (or ObjectId) to open the field application to the newly created feature. This workflow seems to work well with the Survey123 Web App. Using the `?mode=edit&globalId=uuid` style query, the app opens up to the new feature. However, when I try to carry this same logic over to the Field App (which is what our requirements call for), the app keeps opening to an empty form. I've created a super-simple survey and shared it publicly to exemplify the issue in this CodePen: https://codepen.io/vitale232-the-vuer/project/editor/DNeRYO?open_file=index.html  FWIW, the S123 form we're trying to get to production has many repeats. However, we're not trying to carry over any of the repeat fields from the SOR. Does anyone know what's going wrong here? Why can't I open a feature that would be in the inbox without using the inbox? The documentation seems to imply that this is a viable solution. Thanks for reading! ... View more

Hey all, I've been trying to chase down an issue where the Basemap Gallery Widget in the 4.15 JS API is aborting requests, which results in an incomplete list of basemaps. The application we're developing is accessing data via our own Portal deployment, which is where the JS API should be searching for basemaps. Upon first load, often times the basemap gallery list will load successfully. However, refreshing the page will almost certainly create the issue using the example here. This is what it looks like when the basemap requests get aborted: Here's an example error: [esri.Basemap] #load() Failed to load basemap (title: 'Basemap', id: '1725208f67e-basemap-8') {name: "AbortError", message: "Aborted", details: undefined, dojoType: "cancel"}‍‍‍ Our application will be using WebMaps from the JS API instead of Maps. The issue seems to be worse when visualizing a WebMap rather than a Map. Further, the application we're developing is an Angular 8 app, and the issue seems to be worse when a new map is brought into the page from behind an `*ngIf` directive. If I understand ngIf correctly, this Angular directive totally removes the map <div> element from the page when the "if" condition is false. So, said another way, the issue may be worse when the map is dynamically added and/or removed from the page. I'm able to replicate this on Windows and Ubuntu in Chrome and Firefox. Also of note, I am not the Portal administrator, thus I'm unaware of how it was originally configured. I could likely get in touch with the admin if there's evidence pointing to a config issue. Here's a simple example that references our Portal instance and a public WebMap from the Portal. Just open up devtools, load the page, and chances are you'll see many of the basemaps' requests were aborted. If not, refresh the page and the issue should appear. <html> <head> <meta charset="utf-8" /> <meta name="viewport" content="initial-scale=1,maximum-scale=1,user-scalable=no" /> <!-- ArcGIS API for JavaScript, https://js.arcgis.com For more information about the basemaps-portal sample, read the original sample description at developers.arcgis.com. https://developers.arcgis.com/javascript/latest/sample-code/basemaps-portal/index.html --> <title>Portal Basemap Abort Errors</title> <link rel="stylesheet" href="https://js.arcgis.com/4.15/esri/themes/light/main.css" /> <script src="https://js.arcgis.com/4.15/"></script> <style> html, body, #viewDiv { padding: 0; margin: 0; height: 100%; width: 100%; } </style> <script> require([ "esri/config", "esri/WebMap", "esri/portal/Portal", "esri/views/MapView", "esri/widgets/BasemapGallery", "esri/widgets/Search", "esri/widgets/Expand", ], function( esriConfig, WebMap, Portal, MapView, BasemapGallery, Search, Expand, ) { esriConfig.portalUrl = "https://gistestportal.vhb.com/site"; const portal = new Portal(); portal .load() .then(function() { const zoomLevel = 11; const map = new WebMap({ portalItem: { id: 'ae1cb74010f34c16bf2c61941555ed23', } }); const view = new MapView({ container: "viewDiv", map: map, center: [-79.9959, 40.4406], zoom: zoomLevel, }); const basemapGallery = new BasemapGallery({ view: view }); const bgExpand = new Expand({ view: view, content: basemapGallery }); view.ui.add(bgExpand, "top-right"); }) .catch(function(error) { console.error(error); }); }); </script> </head> <body> <div id="viewDiv"></div> </body> </html> ‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ Any advice would be greatly appreciated! Thanks for your help. ... View more