Latest Contributions by MikeMacRae

I am trying to learn how to iterate over a table stored as a feature service in my ArcGIS Online Content. I am just getting started with the Javascript API for ArcGIS so my knowledge isn't top level yet. What I am trying to do it dynamically update a URL using values from 2 columns in the table. I want to iterate through each row and grab the value from the 2 columns and inject them into a URL via concatenation. Drawing from my python background, it would be something like:   URL = www.mywebsite.com for row in cursor: URL + "\" + row[1] + "some_other_URL_string_stuff" + row[2]     I think what I need to do is use the following code to do so, but I am not sure how to reference the table in the script. I've tried setting the element ID to the GUID of the feature table but that doesn't seem to work. I've also tried the name. I've combed through the Javascript help docs, but they are difficult to navigate and I can't seem to find examples of what I am trying to do. I don't really know how to concatenate the values from the columns in the table using javascript.   var table = document.getElementById("mytab1"); for (var i = 0, row; row = table.rows[i]; i++) { //iterate through rows //rows would be accessed using the "row" variable assigned in the for loop for (var j = 0, col; col = row.cells[j]; j++) { //iterate through columns //columns would be accessed using the "col" variable assigned in the for loop } }     ... View more

I am working in Power BI Desktop. I have connected to our Oracle Spatial database as my Data Source. In my Oracle DB, we have some polygon feature classes. I want to add one of those feature classes to an 'ArcGIS for Power BI' map. To do this, one must drag a field from the feature class into the 'Location' field under the 'Visualizations' panel or the Lat/Long fields (for point data). Working with my polygon data, I don't have any fields to add, that store spatial information so I tried dragging the 'Geometry' field over.   My data does not populate. I tried updating the accuracy of the data using the options in the yellow banner at the bottom of the map (see image above), but that doesn't seem to do anything. So, my question is, how can I add polygon data to a map from a data source in Power BI for Desktop. ... View more

I started a report in Power BI for Desktop. I have an ArcGIS for Power BI account. I added an 'ArcGIS Map for Power BI' map to my report. When added, it asks you to log into your organizational account, which I have. I now have the following Screen: It appears that, in order to get the map to populate, one has to add some data from a Power BI datasource (drag a field to the 'Location' field under the 'Visualizations' panel) and then a map appears. Instead, I want to start by adding some data from my ArcGIS Account which is possible from the Analysis Tools widget in the map But in order to get a map to open, all I can figure is, you have to drag some data into the 'Location' field first. Is there any way to get a map to open without having to do this? Note: I tested by dragging some data to the 'Location' field just to get the map to open, thinking I could just remove it from the map afterwards, but there is no option to remove that data layer from the map:   ... View more

I had set a parameter in an ArcGIS custom tool to populate a list upon initialization in an ArcGIS Desktop tool. The parameter has the following properties: Data Type = String Required Input Multivalue = Yes Filter = Value List In the validator, I scripted some logic that builds a list in a certain order and is then passes it into the parameter using the following: valueList = ['Montreal', 'Toronto', 'Vancouver', 'British Columbia', 'Ontario', 'Quebec'] self.params[4].filter.list = valueList self.params[4].values = self.params[4].filter.list The list above is an example of how my list is constructed, where I wanted all the city names first and then the provinces after. The cities are in alphabetical order and then the provinces are. When I pass the list into the parameter, the parameter honors the order of the list. This in in the Desktop environment. I am migrating the tool into ArcGIS Pro/Python 3 using the same validator script and as I noted in a previous post that the behavior of multi value parameters have changed slightly. In the Desktop environment, the list would populate in the parameter along with check boxes next to each item so the user can toggle the items that want the tool to run on: In the Pro environment the parameter will populate the list, but in order for the user to choose the items from the list they want, there is a drop down button above the parameter that pops out the same list in a new menu where they have the option to toggle on or off the items (see highlighted button below). The second image shows the popout list. Now the issue is, the original list will populate in the order that I have set in the validator, however the popout list will only populate in alphabetical order. This is onerous for my users because the list I actually use is quite large and we want to have some of the more important items in the list at the top for ease of access and to prevent the users from scrolling through the list for these items when they are set in alphabetical order. Is there any way to change how the popout list orders the items from the list? Thanks   ... View more

I am updating a python tool from Desktop (python 2) to Pro (python 3). In my old tool, I scripted the validator class to make updates to some parameters based on user drive changes and choices. One of the parameters is: a string data type  accepts multiple values contains a filter The list is driven from a spreadsheet in the validator class when the tool initializes:     valueList = ~iterate over the spreadsheet and compile a list~ self.params[4].filter.list = valueList self.params[4].values = self.params[4].filter.list     The parameter in the old tool looks like this: Where the user can toggle on or off, which items from the list they want by either selecting or deselecting the check boxes or utilize the 'Select All/Unselect All' buttons. When the tool runs, it will process on the users choices in the list that are checked off and ignore anything that was not. In ArcGIS Pro, the parameter behaves a little differently. First, the appearance has changed: In the above image, the list is populated based on the same validator logic above, but does not have the check marks beside it (let's call this the main list). In order for the user to get the option to check off items from the list, they have to click on the dropdown button (highlighted yellow in the image above) which will pop out a submenu with the same list (lets call this the sub list) except here, the user can then check off the items they want. Issues with this: First, regardless of what the user has chosen in the sub list, the tool still runs on all items from the original list. Second, the main list doesn't get updated when the user makes choices in the sub list which leads me to believe this is causing issue #1. I have sorted the list in a customized way using the validator. The main list maintains this sorting but the sub list does not. It always populates the list in alphabetical order. It seems there is a disconnect I am missing between how these 2 lists communicate with each other in Pro. I've tried to test when the list is altered using the 'updateParameters' function in the validator, but it doesn't seem to pick up that the list has been altered by the users choices. Solution: Ideally, I want what I had in my Desktop tool. Basically, a pre-populated list that allows the user to choice which items that want and have the tool accept those choices and to maintain the sorting of the list I set in the validator.       ... View more