Latest Contributions by JasonCyphers

In the natural gas industry, we pre-test pipe that is use to repair damages throughout the system.  We need a way to capture that pressure test information and relate it to the pipe so when the pipe is used for a repair days/weeks/months later, the field user can reference that they used that piece of pipe for the repair and our GIS can be updated with the repair information (including pressure test info). I've created a Survey123 form that the field user can use to submit the pressure test info, and a dashboard (more of a report view) the GIS editor would use to search for and retrieve the pressure test info when editing GIS; however, I'm struggling to find a simple solution to create a unique record number that can be related to the pipe. The plan was to have some sort of sequential number that the crew could write onto the pipe (PTP1, PTP2, etc.), but Survey123 doesn't support that functionality (yet).  UUID or some sort of date/time ID are a little too long, and there's no way to get the ObjectID to show up in the instance_name allowing the crew to submit a record, then switch over to their sent box to see that - something like: concat("PTP", " - ", ObjectID). Any suggestions on how to fulfill this need? ... View more

I have a point feature with a related table for inspections.  Within an operations dashboard, is there a way to show the number of points that haven't been inspected in over a year? Only way I can think to do it is by joining the point feature with the related table's data into a single feature layer (which I really don't want to do). ... View more

I have a form that captures the costs to install a pipe by boring it, vs. more expensive options.  So, it basically looks like this: Crew Time: ____________ Equipment Time: ____________ Bore Cost: (${crew_time}*125)+(${equipment_time}*50) Alternate Install Method: ____________ Alt Method Cost: if(selected(${alt_method},'Plow'),((${crew_time}*125)+(${equipment_time}*50)*2),if(selected(${alt_method},'Trench),((${crew_time}*125)+(${equipment_time}*50)*5),0)) Cost Savings: ${alt_method_cost}-${bore_cost} I'm having an issue with the cost savings calculation.  I'm guessing the cost savings calculation is being performed as soon as the Bore Cost field is getting calculated and populated, because the value always seems to come back as negative whatever the bore cost is.  It doesn't appear to be picking up the alt method cost. I've even tried adding another question after the alt method cost that the cost savings calculation would be dependent on before it executed the calculation - something like "if work_complete is yes, perform the calculation, if work_complete is no, perform the calculation; otherwise enter 0 as the value".  This keeps a value of 0 in the cost savings field until I check yes or no for the new question, but even then, it's not performing the calculation, it's just entering a negative bore cost value...it still doesn't appear to see the value of the alt method cost. Any ideas/solutions?   ... View more

I'm performing inspections via Survey123, storing the data in a related table in a feature service in our ArcGIS Portal.  I've added the feature service to our desktop GIS so personnel in the office, who utilize ArcMap, will have access to the inspections without having to go through portal. An issue I'm having is with date/time - Portal captures the correct time (Eastern Time, US), but when displayed in ArcMap, it appears to be UCT.  Any idea how to remedy this, so ArcMap shows eastern time or just no time at all...just the date? Portal date/time: ArcMap date/time for same record: ... View more

I'm trying to select parcels, from a feature service, that are within a boundary area (a separate feature service). Both are added to the map, and when I search and select the boundary layer from the widget, it's only selecting a handful of parcels within it...not all of them.  Any ideas? The widget works fine if I select the parcels using any of the drawing tools. ... View more