Latest Contributions by JasonSimpson

Thank you for the suggestion. An arcade element worked.  ... View more

Thank you. I indeed created an arcade expression with the dynamic field being a var.  ... View more

Has ESRI announced an official release date for the June 2024 update of EB? Thanks in advance.  ... View more

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.    ... View more

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.  ... View more

@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.  ... View more

Perfect. Thanks for your prompt response.  ... View more