Latest Contributions by JasonSimpson

‎03-11-2024

Are we no longer able to download built web applications for deployment or am I missing something? I am attempting to migrate from our organization's internal GIS site which is hosted on our local server to a configurable app which I would like to be hosted on our server as well. Our current web application was built with the Web App Builder and I have always download the app after modifications and then our IT dept. deploys it. I do not see a download buttong when rebuilding our internal site app with configurable apps despite documentation on ESRI states I should see a download button after selecting a configurable app. The image below is what I get when trying to create a configurable application. Thanks for any assistance or insight on this.

‎08-28-2023

Can someone help me? I've had a waze feed running consistently for a couple years now, but the feed suddenly stopped in july. After researching the issue, Ive noticed that a URL feed has changed. After making the proper changes, I am still receiving an error when running the script in PRO. Below is the script. import xml.etree.ElementTree as ET import urllib.request import arcpy from datetime import datetime namespaces = {'georss' : 'http://www.georss.org/georss', 'linqmap':'http://www.linqmap.com' } tree = ET.ElementTree(file=urllib.request.urlopen('https://www.waze.com/partnerhub-api/partners/1103703####/waze-feeds/5e9eb202-2341-46d9-ad87-ee7c0ca4###?format=1')) root = tree.getroot() channel_head = [] fcp = "https://services7.arcgis.com/RL8aZgZHmJOdyN##/arcgis/rest/services/Waze_Points/FeatureServer/0" fcl = "https://services7.arcgis.com/RL8aZgZHmJOdyN##/arcgis/rest/services/Waze_Lines/FeatureServer/0" for member in root.findall('channel/item'): channel = [] Title = member.find('title').text.upper() try: point = member.find('georss:point', namespaces) line = member.find('georss:line', namespaces) except: pass print('Fail Stage 0') if point != None: try: Date = member.find('pubDate').text DateReported = datetime.strptime(Date, '%a %b %d %H:%M:%S %z %Y') if len(member.findall('linqmap:city', namespaces)) > 0: City = member.find('linqmap:city', namespaces).text else: City = '' if len(member.findall('linqmap:street', namespaces)) > 0: Street = member.find('linqmap:street', namespaces).text else: Street = '' if len(member.findall('linqmap:subtype', namespaces)) > 0 and member.find('linqmap:subtype', namespaces).text is not None: Subtype = member.find('linqmap:subtype', namespaces).text.replace('_', ' ').capitalize() else: Subtype = '' UUID = member.find('linqmap:uuid', namespaces).text Reliability = member.find('linqmap:reliability', namespaces).text if len(member.findall('linqmap:reportDescription', namespaces)) > 0: Description = member.find('linqmap:reportDescription', namespaces).text else: Description = '' Type = member.find('linqmap:type', namespaces).text.replace('_', ' ').capitalize() #point = member.find('georss:point', namespaces).text.replace(' -', ',-').split(',') point = member.find('georss:point', namespaces).text.replace(' -',',-').split(',') row = Subtype, Type, Title, DateReported, City, Street, UUID, Reliability, Description, float(point[1]),float(point[0]) cursor = arcpy.da.InsertCursor(fcp, ["ReportSubtype","ReportType","Title","DateReported","City","Street","UUID","Reliability","Description","SHAPE@X","SHAPE@Y"]) cursor.insertRow(row) del cursor print('stage 1') except: pass print('fail Stage 1') elif line != None: if Title != 'IRREGULARITY': try: Date = member.find('pubDate').text DateReported = datetime.strptime(Date, '%a %b %d %H:%M:%S %z %Y') if len(member.findall('linqmap:city', namespaces)) > 0: City = member.find('linqmap:city', namespaces).text else: City = '' if len(member.findall('linqmap:startNode', namespaces)) > 0: StartNode = member.find('linqmap:startNode', namespaces).text else: StartNode = '' if len(member.findall('linqmap:endNode', namespaces)) > 0: EndNode = member.find('linqmap:endNode', namespaces).text else: EndNode = '' if len(member.findall('linqmap:reportDescription', namespaces)) > 0: Description = member.find('linqmap:reportDescription', namespaces).text else: Description = '' if len(member.findall('linqmap:street', namespaces)) > 0: Street = member.find('linqmap:street', namespaces).text else: Street = '' UUID = member.find('linqmap:uuid', namespaces).text Type = member.find('linqmap:type', namespaces).text.replace('_', ' ').capitalize() Length = member.find('linqmap:length', namespaces).text Level = member.find('linqmap:level', namespaces).text line = member.find('georss:line', namespaces).text.replace('\n', '').replace(' ', '],[').replace('],[-',', -').split('],[') Speed = member.find('linqmap:speed', namespaces).text Delay = member.find('linqmap:delay', namespaces).text cur = arcpy.da.InsertCursor(fcl, ["Speed","Delay","Title","ReportType","DateReported","City","Street","Length","ReportLevel","UUID","StartNode","EndNode","Description","SHAPE@"]) array = arcpy.Array() for coords in line: xy = coords.split(', ') array.add(arcpy.Point(xy[1], xy[0])) cur.insertRow([Speed,Delay,Title,Type,DateReported,City,Street,Length,Level,UUID,StartNode,EndNode,Description,arcpy.Polyline(array)]) del cur print('stage 2') except: pass print('fail Stage 2') else: try: Date = member.find('updateDate').text DateReported = datetime.strptime(Date, '%a %b %d %H:%M:%S %z %Y') if len(member.findall('linqmap:city', namespaces)) > 0: City = member.find('linqmap:city', namespaces).text else: City = '' if len(member.findall('linqmap:startNode', namespaces)) > 0: StartNode = member.find('linqmap:startNode', namespaces).text else: StartNode = '' if len(member.findall('linqmap:endNode', namespaces)) > 0: EndNode = member.find('linqmap:endNode', namespaces).text else: EndNode = '' if len(member.findall('linqmap:reportDescription', namespaces)) > 0: Description = member.find('linqmap:reportDescription', namespaces).text else: Description = '' if len(member.findall('linqmap:street', namespaces)) > 0: Street = member.find('linqmap:street', namespaces).text else: Street = '' UUID = member.find('linqmap:id', namespaces).text Type = member.find('linqmap:type', namespaces).text.replace('_', ' ').capitalize() Length = member.find('linqmap:length', namespaces).text Level = member.find('linqmap:trend', namespaces).text line = member.find('georss:line', namespaces).text.replace('\n', '').replace(' ', '],[').replace('],[-',', -').split('],[') Speed = member.find('linqmap:speed', namespaces).text Delay = member.find('linqmap:delaySeconds', namespaces).text cur = arcpy.da.InsertCursor(fcl, ["Speed","Delay","Title","ReportType","DateReported","City","Street","Length","ReportLevel","UUID","StartNode","EndNode","Description","SHAPE@"]) array = arcpy.Array() for coords in line: xy = coords.split(', ') array.add(arcpy.Point(xy[1], xy[0])) cur.insertRow([Speed,Delay,Title,Type,DateReported,City,Street,Length,Level,UUID,StartNode,EndNode,Description,arcpy.Polyline(array)]) del cur print('stage 3') except: pass print('fail Stage 3') else: print('Error') And this is the error I am receiving when ran in PRO Script2 ===================== Parameters ===================== Messages Start Time: Monday, August 28, 2023 9:46:17 AM Traceback (most recent call last): File "C:\Users\jsimpson\Desktop\WazeAug23.py", line 7, in <module> tree = ET.ElementTree(file=urllib.request.urlopen('https://www.waze.com/partnerhub-api/partners/11037037395/waze-feeds/5e9eb202-2341-46d9-ad87-ee7c0ca4e04b?format=1')) File "C:\Program Files\ArcGIS\Pro\bin\Python\envs\arcgispro-py3\Lib\xml\etree\ElementTree.py", line 540, in __init__ self.parse(file) File "C:\Program Files\ArcGIS\Pro\bin\Python\envs\arcgispro-py3\Lib\xml\etree\ElementTree.py", line 580, in parse self._root = parser._parse_whole(source) xml.etree.ElementTree.ParseError: not well-formed (invalid token): line 1, column 0 Failed script Script2... Failed to execute (Script2). Failed at Monday, August 28, 2023 9:46:18 AM (Elapsed Time: 0.91 seconds) Any help is appreciated.

‎09-21-2022

I have the entire process working and has been working for over a year. Cannot express how efficient and effective this setup is. Our stormwater team loves it. If you'd like to ask any questions, contact me at jsimpson@salemva.gov.

‎09-06-2022

Good afternoon. I have set up a map in which I took a feature class and joined it with a relationship table in AGOL. I wrote a bit of arcade code to make sure all data from the relationship table shows. However my issue is I would like to filter out all points that has no relationship table data to join with my points feature. So long story short, I would only like to show points with relationship data and leave out those who don't. Would any of you be able to provide me with a bit of direction on how I should handle such a task. My code is below with certain parts marked out. Thanks.

‎04-12-2022

One of our inspectors approached me today and asked if there is a way to display repeats in Survey123 connect in descending order, from newest date to latest date. Is this possible?

‎01-03-2022

Good afternoon, I am running into an issue when labeling on the new map viewer. For some reason, my arcade script is adding zeros onto a currency field. Below is my script. Can anyone advise me on what I may be doing wrong. Thanks. Below is my scripts if ($feature.Change > 0 ) {return Text($feature["Change"], '$##,###,###' + ' - '+ Round(($feature["F__Change"])*100,2)+ "%")} This turns a value of $1,900 into $190,000

‎08-19-2021

@Anonymous User Sorry for the delay. So the geopoint question is in the parent layer. So essentially this is an inspection form in which each site may have multiple inspection visits(repeat layer). I need the geopoint in the parent label to remain the same. I have brought the points into ArcPro and moved them to the proper location only to have them return back to where the point was originally set. This has happened to me several times. A few questions about setting it to read only. 1. Does the question become read-only after out inspectors insert the initial point? 2. If our inspectors were to make a mistake placing the point, would I still have the ability to bring the data into ArcPro and move to the correct location? Thanks in advance.

‎08-11-2021

I have a survey in which has repeats. The repeats represent each inspection visit for a site. There have been several times in which our inspectors have created a new inspection visit and have moved the geopoint(I believe its tracking their location). Is there anyway to not allow edits of the geopoint once it has been initially set? I have deleted the allowUpdates=true from the esri parameters field, but I am still able to go in and change the geopoint of existing surveys. I would like to eliminate the ability to move a geopoint to a wrong location. Thanks in advance.

‎08-07-2021

I resolved this issue. Where you place actions in Power Automate is extremely important. I had grouped my send email action with the http call, and append to array actions, therefore an email was sent after each attachment was added to the image array. I ended up copying the email action, deleting that action, and pasting the send email as an independent action in the flow.

‎08-06-2021

I have created a flow via power automate similar to Ismael, but a major issue has popped up. When a survey with attachments is submitted, power automate sends out an email for every attachment in the array. For example, the first email has the first attachment, the second email has the first two, the third has the first three and so forth. Has anyone experienced this behavior, or is my flow wrong? Thanks.

‎06-16-2021

Perfect. Thanks for your prompt response.

‎06-16-2021

I am trying to populate a comment box with a specific comment based off the answer from a multiple choice question. There are three total choices for the multiple choice, Compliant, Non-Compliant, No Comment. The formula I have come up with is below. (if(selected(${VSMPSWPPP_SWPPP_MS1},'Compliant'), 'In Compliance',if(selected(${VSMPSWPPP_SWPPP_MS1},'Non-Compliant'), 'Non-Compliant Comment'), if(selected(${VSMPSWPPP_SWPPP_MS1}'N/A'), 'SWPPP Not Inspected'))))

‎04-07-2021

My organization is in the process of switching from an asset management centered inspection form for land disturbing projects to an extensive Survey123 form. With the use of power automate, I have been able to match and improve what our inspectors have gotten use to with the previous software. One issue I am having trouble figuring out is how to notify a group of people if the status of the job changes. For instance, my organization issues Stop Work Orders. I have configured a trigger to send an email to management when the Stop Work Order is issued. I simply run a conditional statement of Job Status is equal to Stop Work Order along with another statement that takes repeats into account. What I am trying to figure out is the best way to notify the same group when the Stop Work Order is changed back to Active. There has been some discussion about our inspectors typing an email to notify management when the status is back to active, but that scares me a bit due to the fact that it brings human error into play. Would anyone have an idea on how I should approach this? Thanks in advance.

‎02-23-2021

Oh ok. I see. I would look into the convert HTML to pdf feature in power automate. I have not used it, but I know the option exists. Sorry I couldn't be of more assistance.

‎02-23-2021

I am in the final steps of my email flow via Power Automate. It was a long road because I had to learn a little about that capabilities of Power Automate. Apparently sending attachments are not straight forward in flow, but the good guys at ESRI have created a tutorial on how to send attachments. The good, this tutorial is straight forward. The bad, you would need Power Automate Premium to complete this task. I have researched work arounds for this, but at the end of the day, I submitted a request for Premium to be added to my account. Tutorial link is below. Tutorial

Online Status	Offline
Date Last Visited	‎03-11-2024 02:01 PM

My Ideas

Latest Contributions by JasonSimpson

Download and deploy web app

Re: Python Script to ingest Waze data into ArcGIS Online

Re: Power Automate Email.

Filtering based off relationship table

Repeat Order

Labeling and an extra zero

Re: Geopoint Edits

Geopoint Edits

Re: Power Automate, attachment and multiple emails

Power Automate, attachment and multiple emails

Re: Survey123 Formula

Survey123 Formula

Field change power automate

Re: Send email with attachment of submitted survey via Microsoft Power Automate

Re: Send email with attachment of submitted survey via Microsoft Power Automate

Labeling and an extra zero

Survey123 Formula

Re: Survey123 Formula

Re: Send email with attachment of submitted survey...

Re: Send email with attachment of submitted survey...