Latest Contributions by KieranClark

I am receiving the following error when trying to use XY Table to Point in a Python Script: Traceback (most recent call last): File "C:\Users\kierc\projects\SubTelCableMap\01 Update Current Position.py", line 22, in <module> arcpy.XYTableToPoint_management(in_table=Ship_Positions_csv, out_feature_class=ShipLatestPosition, x_field="AIS.LONGITUDE", y_field="AIS.LATITUDE", z_field="", coordinate_system="GEOGCS['GCS_WGS_1984',DATUM['D_WGS_1984',SPHEROID['WGS_1984',6378137.0,298.257223563]],PRIMEM['Greenwich',0.0],UNIT['Degree',0.0174532925199433]];-400 -400 1000000000;-100000 10000;-100000 10000;8.98315284119521E-09;0.001;0.001;IsHighPrecision") File "C:\Program Files\ArcGIS\Pro\Resources\ArcPy\arcpy\management.py", line 3992, in XYTableToPoint raise e File "C:\Program Files\ArcGIS\Pro\Resources\ArcPy\arcpy\management.py", line 3989, in XYTableToPoint retval = convertArcObjectToPythonObject(gp.XYTableToPoint_management(*gp_fixargs((in_table, out_feature_class, x_field, y_field, z_field, coordinate_system), True))) File "C:\Program Files\ArcGIS\Pro\Resources\ArcPy\arcpy\geoprocessing\_base.py", line 511, in <lambda> return lambda *args: val(*gp_fixargs(args, True)) arcgisscripting.ExecuteError: Traceback (most recent call last): File "c:\program files\arcgis\pro\Resources\ArcToolbox\Scripts\XYTableToPoint.py", line 183, in <module> xy_table_to_points(in_table, output_fc, x_field, y_field, z_field, coordinate_system) File "c:\program files\arcgis\pro\Resources\ArcToolbox\Scripts\XYTableToPoint.py", line 158, in xy_table_to_points coord_values.append(row[scur.fields.index(val)]) ValueError: tuple.index(x): x not in tuple Failed to execute (XYTableToPoint).‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ Unfortunately, I'm having trouble understanding just what this error means. This script previously ran without trouble on a previous computer. I have kept all filenames and file paths the same. Even running a normal XY Table to Point tool within ArcGIS Pro fails to complete with the following error: Traceback (most recent call last): File "c:\program files\arcgis\pro\Resources\ArcToolbox\Scripts\XYTableToPoint.py", line 183, in <module> xy_table_to_points(in_table, output_fc, x_field, y_field, z_field, coordinate_system) File "c:\program files\arcgis\pro\Resources\ArcToolbox\Scripts\XYTableToPoint.py", line 158, in xy_table_to_points coord_values.append(row[scur.fields.index(val)]) ValueError: tuple.index(x): x not in tuple Failed to execute (XYTableToPoint).‍‍‍‍‍‍‍‍‍‍‍‍‍‍ Looking for any guidance here. The code for the Python script is as follows: # -*- coding: utf-8 -*- """Generated by ArcGIS ModelBuilder on: 2019-12-14 00:22:34 All ModelBuilder functionality may not be exported. Edits may be required for equivalency with the original model. """ import arcpy # To allow overwriting the outputs change the overwrite option to true. arcpy.env.overwriteOutput = True # Local variables: Ship_Positions_csv = r"C:\Users\kierc\projects\api\Ship_Positions.csv" ShipLatestPosition = r"C:\Users\kierc\Documents\ArcGIS\Projects\SubTelCableMap\SubTelCableMap.gdb\ShipLatestPosition" CurrentCableShipPositionTmp = r"C:\Users\kierc\Documents\ArcGIS\Projects\SubTelCableMap\SubTelCableMap.gdb\CurrentCableShipPositionTmp" Updated_Target_Dataset = CurrentCableShipPositionTmp CurrentCableShipPosition = r"C:\Users\kierc\Documents\ArcGIS\Projects\SubTelCableMap\SubTelCableMap.gdb\CurrentCableShipPosition" Updated_Input_With_Rows_Removed = CurrentCableShipPosition # Process: XY Table To Point tempEnvironment0 = arcpy.env.outputCoordinateSystem tempEnvironment0 = arcpy.env.outputCoordinateSystem arcpy.XYTableToPoint_management(in_table=Ship_Positions_csv, out_feature_class=ShipLatestPosition, x_field="AIS.LONGITUDE", y_field="AIS.LATITUDE", z_field="", coordinate_system="GEOGCS['GCS_WGS_1984',DATUM['D_WGS_1984',SPHEROID['WGS_1984',6378137.0,298.257223563]],PRIMEM['Greenwich',0.0],UNIT['Degree',0.0174532925199433]];-400 -400 1000000000;-100000 10000;-100000 10000;8.98315284119521E-09;0.001;0.001;IsHighPrecision") arcpy.env.outputCoordinateSystem = tempEnvironment0 # Process: Copy Features arcpy.CopyFeatures_management(in_features=ShipLatestPosition, out_feature_class=CurrentCableShipPositionTmp, config_keyword="", spatial_grid_1="", spatial_grid_2="", spatial_grid_3="") # Process: Delete Rows arcpy.DeleteRows_management(in_rows=CurrentCableShipPosition) # Process: Append arcpy.Append_management(inputs=r"C:\Users\kierc\Documents\ArcGIS\Projects\SubTelCableMap\SubTelCableMap.gdb\CurrentCableShipPositionTmp", target=Updated_Input_With_Rows_Removed, schema_type="TEST", field_mapping="", subtype="", expression="") ‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ This was originally made with Model Builder in Pro 2.4 and cleaned up/tweaked slightly by me after exporting to a editable Python file. Edit: For some reason, manually renaming the AIS.LATITUDE/AIS.LONGITUDE fields in my CSV file to simply LATITUDE/LONGITUDE allows the XY Table to Point tool to run successfully in ArcGIS Pro. I'm not sure why this would suddenly not work and I'd rather not having to add an additional step of renaming data fields. ... View more

I am looking for some guidance from some more experienced folks on how to optimize our online map: SubTel Cable Map  In particular, the Cable Ship Position History layer is causing some headache. Our goal is to track 45-50 ships 4 times a day with a 30 day history. However, we're only 2 weeks in and the layer is causing the load times to grind to a halt. I had to set the layer to be hidden until the user zooms in to a certain level in order to reduce map clutter, but as they zoom in an trigger the layer to display, it grinds everything to a halt for a long period of time. Ideally, I would like to not have to reduce the number of data points we capture so I'm looking for some other ways I can try to optimize or display this information. Any other performance/visualization optimizations that you might are also greatly appreciated. I am currently using Web App Builder Dev Edition 2.12, and the map is hosted through our ArcGIS Online portal. Please let me know if any additional information is needed. I am happy to answer but not quite sure what else might be relevant! Edit: I had originally tried to set it up so that the ship history layer was off until users clicked to enable it in the left hand Info Summary widget but this had the unfortunate side effect of not zooming to clicked entries in the ship history layer. ... View more

So I originally had this solved through this thread: Custom Attribute Expression in ArcGIS Online to Show Related Table Information  but since then I have learned a lot more about ArcGIS and have changed the way things are structured in my web map. I'm having trouble getting the Arcade expression updated to do the same thing. The following code produces the pop up information I want in ArcGIS Pro, but does not work once the map is published to the web: var cityname = $feature.City; // read out the city var sql = "tblLanding_EXPORT.City" + " = '" + cityname + "'"; // create query var table = FeatureSetByName($map,"LandingsWithCables_EXPORT"); // get access to table var related_records = Filter(table, sql); // filter the table for relevant records var cnt = Count(related_records); // determine the number of records found var result = ""; if (cnt == 0) { // no records found result = "No cable systems found"; } else { // we have related records, let's create the text to return result = cnt + " cable system(s) found:"; for (var record in related_records) { var txt = TextFormatting.NewLine + " - " + record.SystemName; // use the correct field name from the table result += txt; } } return result;‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ The web map can be found here: https://arcg.is/1vSTTC0  I think it's just a matter of getting the right variable/field/table names but for the life of me I can't figure out why it's not working when the map is put online. Any insight would be greatly appreciated. ... View more

I am receiving the following error when running a Python script to update a map for one of our Operations Dashboard: C:\Users\kierc\projects\XXXXX XXXXXXX Extension Survey\Batch Files for Script Scheduling>"C:\ArcGIS_Pro\Conda\Cloned_Envs\arcgispro-py3-subtel\python.exe" "C:\Users\kierc\projects\api\UpdateXXXXXMap.py" Creating SD file Traceback (most recent call last): File "C:\Users\kierc\projects\api\UpdateXXXXXMap.py", line 33, in <module> arcpy.mp.CreateWebLayerSDDraft(mp, sddraft, sd_fs_name, 'MY_HOSTED_SERVICES', 'FEATURE_ACCESS', True, True) File "C:\Program Files\ArcGIS\Pro\Resources\ArcPy\arcpy\mp.py", line 105, in CreateWebLayerSDDraft return _convertArcObjectToPythonObject(arcgisscripting._mapping.CreateWebLayerSDDraft(*_gp_fixargs([map_or_layers, out_sddraft, service_name, server_type, service_type, folder_name, overwrite_existing_service, copy_data_to_server, enable_editing, allow_exporting, enable_sync, summary, tags, description, credits, use_limitations], True))) RuntimeError‍‍‍‍‍‍‍‍ I have X'd out the actual name of the files as there is some potentially sensitive information associated with the names, but the character counts and spacing are preserved. Additionally, this is only an issue if I am logged out in ArcGIS Pro. However, logging in to ArcGIS Pro is not a full solution as I will need to be updating maps soon for multiple organizations. The following is the Python script I am using: import arcpy import os, sys from arcgis.gis import GIS ### Start setting variables # Set the path to the project prjPath = r'C:\Users\kierc\Documents\ArcGIS\Projects\XXXXXXXXXXXExt\XXXXXXXXXXXExt.aprx' # Update the following variables to match: # Feature service/SD name in arcgis.com, user/password of the owner account sd_fs_name = "XXXXX_XXXXXX_Extention_Inshore_Survey_WFL1" portal = "http://www.arcgis.com" # Can also reference a local portal user = "XXXXXXXXXXX" password = "XXXXXXXXXXXXX" # Set sharing options shrOrg = False shrEveryone = False shrGroups = "" ### End setting variables # Local paths to create temporary content relPath = r'C:\Users\kierc\projects\api\arcgistempcurrent' sddraft = os.path.join(relPath, "CurrentUpdate.sddraft") sd = os.path.join(relPath, "CurrentUpdate.sd") # Create a new SDDraft and stage to SD print("Creating SD file") arcpy.env.overwriteOutput = True prj = arcpy.mp.ArcGISProject(prjPath) mp = prj.listMaps()[0] arcpy.mp.CreateWebLayerSDDraft(mp, sddraft, sd_fs_name, 'MY_HOSTED_SERVICES', 'FEATURE_ACCESS', True, True) arcpy.StageService_server(sddraft, sd) print("Connecting to {}".format(portal)) gis = GIS(portal, user, password) # Find the SD, update it, publish /w overwrite and set sharing and metadata print("Search for original SD on portal…") sdItem = gis.content.search("{} AND owner:{}".format(sd_fs_name, user), item_type="Service Definition")[0] print("Found SD: {}, ID: {} n Uploading and overwriting…".format(sdItem.title, sdItem.id)) sdItem.update(data=sd) print("Overwriting existing feature service…") fs = sdItem.publish(overwrite=True) if shrOrg or shrEveryone or shrGroups: print("Setting sharing options…") fs.share(org=shrOrg, everyone=shrEveryone, groups=shrGroups) print("Finished updating: {} – ID: {}".format(fs.title, fs.id))‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ Once again, specific filenames have been X'd out with number of characters and any spacing preserved. This script successfully updates the map as intended when logged in to ArcGIS Pro. ... View more

Here is my use case: I have an operations Dashboard set up to display a bunch of data to a client outside of our company. We have viewer licenses for them. They need to be able to view all the data in the associated map layers in order for the Dashboard to be functional. However, we do not want them to be able to view all the layers and survey results in the Contents tab. We don't mind them seeing their data, but we're trying to keep the backend processes opaque. Currently, I have custom groups and a user role set up such that when they click the "My Groups" tab under "Content" it only shows the dashboard. This is great, and eventually what we want to restrict their view to. However, clicking "My Organization" still displays all the individual layers/features used to populate the dashboard. This is what I would like to remove, but I don't see a way around it as if the feature is not shared with them it doesn't appear in their Dashboard view. Hopefully I've made this clear, but please ask any clarifying questions if I haven't explained something well enough. ... View more