Latest Contributions by PhilLarkin1

Hi julie_powell-esristaff‌ The Measurement Widget didn't make it into 4.6. Will it be available in 4.7 and do you have an estimate on 7's release date? ... View more

After 4.5 years the answer from ESRI is....Meh.  ... View more

This thread is old, but maybe this will help someone. I couldn't get this function to work. It kept returning True instead of rows. From the help doc we know what a Boolean return means. This isn't particularly helpful if you know a stored procedure returns rows. But at least it is something.  ....for statements that do not return rows, it will return an indication of the success or failure of the statement (True for success; None for failure).‍‍‍‍‍‍‍‍‍‍‍‍‍ When i turned to pandas as an alternative I received a similar error message from sqlalchemy: File "C:\Program Files\ArcGIS\Pro\bin\Python\envs\arcgispro-py3\lib\site-packages\sqlalchemy\engine\result.py", line 1077, in _non_result     "This result object does not return rows. " sqlalchemy.exc.ResourceClosedError: This result object does not return rows. It has been closed automatically.‍‍‍‍‍‍‍‍‍‍‍‍ This led me to a stackoverflow comment that suggested using SET NO COUNT when working with stored procedures and sqlalchemy. I wondered if this might work with ArcSDESQLExecute. It didn't. But, it solved my problem with pandas. Here is an example if you want the result of a stored procedure and have hit a wall with this function. # Dependencies: ArcGIS PRO 1.4.1 (Python 3.5.4) #               Currently using python instance: C:\Program Files\ArcGIS\Pro\bin\Python\envs\arcgispro-py3\python.exe #               SQLAlchemy and pyodbc were added manually to arcgis pro interface import urllib import sqlalchemy as sa import pandas as pd #utilizing SET NOCOUNT sqlStatement = "SET NOCOUNT ON EXEC dbo.spPropCharaSelectByNBHD 312524" #connection string pointing to DSN created with ODBC Data Source Admin params = urllib.parse.quote_plus("DSN={yourDSNnameHERE};Trusted_Connection=yes") engine = sa.create_engine("mssql+pyodbc:///?odbc_connect=%s" % params) #create pandas dataframe current_source = pd.read_sql_query(sqlStatement,engine)‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ ... View more

Thanks for the API. It is helpful.  Here is some advice for those attempting to use .overwrite(). If you are passing a string file path, try pointing to the zipfile name while dropping the '.zip'. This worked for me.  C:\RootFolder\example.zip C:\RootFolder\example ... View more

I didn't try to leave the GP service parameter empty. Thanks for the info regarding WAB. I'll be watching for that. Since I have your attention, I'm curious if the team would reconsider limiting the extent of the feature query to the map extent. (See Lindsay's mention here: https://github.com/Esri/site-selector/issues/225#issue-178725345). This requires that the map be saved to the extent of the data. Users are then required to wait for the data to load. You might, as an alternative, consider handling the situation where the feature layer is not visible in the map. When I have turned off the layer in the map, the app does not show graphics. Just some ideas. Thanks for the app. ... View more

Hi Chris Is there a property -as there is for the display of GeoEnrichment attributes- to disable the download options? ... View more

To disable the download section you can comment out lines 4-13. This disables the creation of the divs. I have not tested this in a production environment, but seems to work in test.  From js\library\widgets\siteLocator\geoEnrichment.js _downloadDropDown: function (arrDwnloadDisplayFieldValue, node) { var outerDownloadDiv, selectDownloadList, innerDownloadDiv, innerDownloadLabel, selectedValue, sortContentDivDownload, i, selectForDownload, sortingDivDwnload, areaSortBuildingDownload = []; // create UI of download dropdown and element content of all tab /* if (this.workflowCount === 2) { outerDownloadDiv = domConstruct.create("div", { "class": " esriCTouterDownloadDiv" }, node); } else { outerDownloadDiv = domConstruct.create("div", { "class": "esriCTouterDownloadDivAttachment" }, node); } */‍‍‍‍‍‍‍‍‍‍‍‍‍ ... View more

Roughly line 98 in \ResidentialCompFinder\js\config.js EnableGeoEnrichmentService: false,‍ ... View more

This is not available at WAB 2.6 ... View more

Thanks for providing an explanation.  I hope you are able to prioritize improving performance for filters. The reason we went with Hub was to cut down on delivery time of public data requests for these large datasets. If we can't offset the time taken to deliver data there is a reduced need to use the product. Current performance is not at all ideal. This might be part of the reason some customers have opted to embed old-school and self-hosted FTP links in the description and file gdb download.  ... View more

Thanks for your reply, Daniel. I'm trying to understand what a reasonable amount of time to wait for a download should be. When I request JSON from the AGOL API with the same extent I get a 24MB file in 22 seconds. You can test from the URL below. A zipped shapefile with the same extent is 4-5MB. This should be a sub-second operation. Imagining myself as a user in this scenario: I'm probably leaving the page and contacting the data provider for a custom download option, or worse, abandoning the download request completely.  I'll check for improved speeds tomorrow. I'm still seeing 360 bytes / sec, which isn't acceptable. https://services1.arcgis.com/ozNll27nt9ZtPWOn/arcgis/rest/services/Elevation_Contours/FeatureServer/0/query?where=1%3D1&…  ... View more

Micah- Yes, the app does support filtering by extent.  Would you mind testing from the Hub Page link? ... View more