Latest Contributions by John_RMellor__GISP

‎03-23-2023

My name is John, I'm with Illinois Department of Transportation. We are looking for PROs and CONs for deploying Esri's Portal. If you have it, if you like it or if you don't, if it has helped your users and if so how it has helped. Also, anything you would want to share about your GIS architecture and where Portal fits in. Thank you in advance.

‎11-02-2020

I'm new to 3D / Scene / Globe and am trying to learn best practices. I'm looking for options/suggestions for the best way to bring in lidar point cloud data to display a map. Thanks for your help.

‎01-13-2020

James Tedrick‌ - Thank you - this worked exactly as how you described it. Now all I have to do if figure out how to open the sqlite file.

‎01-03-2020

I have version 3.7.60. I am testing how to recover the sqlite file from an iOS mobile device (an iPad) and open it on desktop. I have seen the document for recovering the data from the mobile device. There is a statement in the documentation about where to find the file on the mobile device (see attached). I can't seem to find the file on the mobile device, any help would be appreciated.

‎12-26-2019

I seem to have discovered that the issue was all records with the field name you wish to use must have non empty cells. I have resolved my issue.

‎12-24-2019

Jim, thanks for the response. Option 1, as you say, will be cumbersome because of the long list of Cities, this option would be difficult to maintain. Option 2, looks viable, but I need a way to say pick the list of cities, related to a county, related to the email address of the person signed in. If I skip to just say between the city and the person signed in (bypass the county) then that too becomes cumbersome and difficult to maintain. If I include the county, then that middle county section is the only place I have to update when a new inspector comes on board. How would I write a "pulldata" formula that says; "select one of a set of cities that are in a county where the county is assigned to the person signed in" ??

‎12-23-2019

I'm working in version 3.7.60; I have the cascade working as expected, but I want to shortcut the middle select question. In my attachments each Inspector has a single County, only one, so there is no need to select. Each County has more than one city. My desire is that the Inspector is picked up from the metadata (the AGOL login email address) and translate that to the choices of Cities. It is working by making the County a "select_one" choice and picking a County. But since there is only one county per Inspector is there a way to default County based on the AGOL login email address, in turn giving me only the applicable Cities to the logged in Inspector? I can set it to skip the County and associate the Inspector directly to the City, but then I will have to manually repeat the City list associated to the new Inspector. As I grow, this will be difficult to manually maintain. By keeping the middle question, I will only have to connect the Inspector to a County, then their City will auto associate. Much easier to maintain. So, my goal is to use the AGOL authentication to tell me what County to associate (and I like this to be hidden) and then show the list of Cities that only relates to the person signed in to AGOL. I welcome any help, comments, suggestions.

‎12-20-2019

You are correct. I've been staring at this all day. I appreciate your help.

‎12-20-2019

Hello all ! I am relatively new to Survey123 Connect and am trying something that I can't seem to get right. I'm trying to filter choices based on the AGOL login (email). I read several threads and tried many things, but I think I'm simply missing one piece. I have the login (email) passed through ok, but can't seem to get the choice filter to pick it up. I have highlighted examples attached - I believe I should have received two choices; "Los Angeles" and "New York" in a drop down selection. I appreciate the help. Thanks.

‎10-25-2019

We've used the query widget to build a query, but it didn't handle symbology for the results, as we believe Arcade can.

‎10-16-2019

Is there a way to convert a Query Widget into an Arcade Expression?

‎10-10-2019

I'm working with Survey123 ArcGIS for Connect. I'm trying to add a field to my survey as a currency field. I can't seem to find the where to put the currency style.

‎10-10-2019

In trying to repair a different app, I ran fsc /scannow from an Admin DOS prompt. After my machine Restarted, attribute assistant toolbar was working correctly. Don't know if the scan fixed it or not, but it's working now.

‎10-04-2019

I'm working with a hosted Feature Layer in ArcGIS Online. I want to have an attribute for a StartDate that defaults to the current date when a Feature is created. Then I want and attribute that is an EndDate and I want the EndDate to be 180 days from the StartDate. This is what I want the expression to say; var startdate= Date($feature["StartDate"]); var SixMonths= DateAdd($feature["EndDate"], 180, 'days'); return SixMonths; How can I automatically populate the EndDate when the StartDate is Not Null?

‎10-01-2019

I was incorrect, I do have this folder however I have to manually type to it. Meanwhile, yes, I have reached out to the Tech Support. We'll see what we can get done. Thanks for your help.

Online Status	Offline
Date Last Visited	a month ago

My Ideas

Latest Contributions by John_RMellor__GISP

Esri's Enterprise Portal

Lidar point cloud

Re: Survey123 Connect - sqlite recovery iOS

Survey123 Connect - sqlite recovery iOS

Re: Survey123 Connect - Cascading Sheets

Re: Survey123 Connect - Cascading Sheets

Survey123 Connect - Cascading Sheets

Re: Survey123 Connect v3.7.60 - Choice Filter

Survey123 Connect v3.7.60 - Choice Filter

Re: Query Widget to Arcade Expression

Query Widget to Arcade Expression

Currency field in Survey123

Re: Attribute Assistant Add-In toolbar error

Auto calculate a date in ArcGIS Online

Re: Attribute Assistant Add-In toolbar error

Esri's Enterprise Portal

Re: Convert a field to a hyperlink

Re: Address points not on actual structure , but a...

Re: Recommended specs for new GIS workstation

Re: Attribute Assistant Add-In toolbar error

Roads and Highways User Group (RHUG)

Imagery and Remote Sensing User Group