nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Script de Python para ingerir datos de Waze en ArcGIS Online

Anonymous User

<\/HEAD>

Como parte del Waze Connected Citizen Program (CCP)<\/A>, los socios obtienen acceso a congestiones de tráfico e incidentes en tiempo real reportados a través de la aplicación Waze (en formatos XML y JSON). Ya existen técnicas y documentación<\/A> sobre cómo consumir estos datos en una plataforma ArcGIS usando GeoEvent.<\/P>

<\/P>

En este blog, describiré una técnica para consumir estos datos en ArcGIS Online mediante Python y el Programador de Tareas de Windows. El

script inicial de Python<\/A> fue desarrollado por Joel Meier<\/A> que modifiqué para ajustarlo al flujo de trabajo propuesto. También una mención especial a mis colegas Edmund Hall<\/A> y Louis Tian<\/A> quienes me ayudaron a depurar. Y por último, pero no menos importante, quiero agradecer a Andrew Stauffer<\/A> por ayudarnos como socio y sacar el máximo provecho del Waze CCP<\/A>.<\/P>

<\/P>

Creando capas de entidades en ArcGIS Online para almacenar información de Tráfico<\/H2>Inicie sesión en ArcGIS Online > página Mi Contenido, haga clic en Crear > Capa de Entidad, elija Desde URL<\/EM> y escriba la URL exacta de la plantilla de capa de entidad puntual. Luego, repita el mismo proceso para la capa de entidad lineal. Esto creará nuevas capas de entidad vacías con el esquema requerido (nombres de campos, tipos y referencia espacial)<\/EM>.<\/P>Plantilla de Capa de Entidad Puntual<\/STRONG><\/SPAN><\/P>https:\/\/services1.arcgis.com\/E5n4f1VY84i0xSjy\/arcgis\/rest\/services\/WazeTrafficAlertsEmpty\/FeatureServer<\/A><\/SPAN><\/P>
Plantilla de Capa de Entidad Lineal<\/STRONG><\/SPAN><\/P>
https:\/\/services1.arcgis.com\/E5n4f1VY84i0xSjy\/arcgis\/rest\/services\/WazeTrafficJamsEmpty\/FeatureServer<\/A><\/SPAN><\/P><\BLOCKQUOTE>
Alternativamente, visite
https:\/\developers.arcgis.com/layers/new<\ /A> para crear capas de entidades con geometría Puntual y Lineal (WKID = 4326) con los siguientes campos.<\ /SPAN><\ /P><\ P ><\ /SPAN ><\ /P >

Capa de Entidad Puntual<\ /SPAN ><\ /H4 >OBJECTID (tipo: esriFieldTypeOID, alias: OBJECTID, Tipo SQL: sqlTypeOther, longitud: 0, nulo: falso, editable: falso)<\ /STRONG ><\ /EM ><\ /SPAN ><\ /LI >DateReported (tipo: esriFieldTypeDate, alias: DateReported, Tipo SQL: sqlTypeTimestamp2, longitud: 0, nulo: verdadero, editable: verdadero)<\ /EM ><\ /SPAN ><\ /LI >Title (tipo: esriFieldTypeString, alias: Title, Tipo SQL: sqlTypeOther, longitud: 25, nulo: verdadero, editable: verdadero)<\ /EM ><\ /SPAN ><\ /LI >ReportType (tipo: esriFieldTypeString, alias: ReportType, Tipo SQL: sqlTypeOther, longitud: 25, nulo: verdadero, editable: verdadero)<\ /EM ><\ /SPAN ><\ /LI >ReportSubtype (tipo: esriFieldTypeString, alias: ReportSubtype, Tipo SQL: sqlTypeOther, longitud: 50, nulo: verdadero, editable: verdadero)<\ /EM ><\ /SPAN ><\ /LI >Street (tipo: esriFieldTypeString, alias: Street, Tipo SQL: sqlTypeOther, longitud: 256, nulo: verdadero, editable: verdadero)<\ /EM ><\ /SPAN ><\ /LI >City (tipo: esriFieldTypeString, alias: City, Tipo SQL: sqlTypeOther, longitud: 50, nulo: verdadero, editable: verdadero)<\ /EM ><\ /SPAN ><\ /LI >Description (tipo : esriFieldTypeString , alias : Description , Tipo SQL : sqlTypeOther , longitud : 1024 , nulo : verdadero , editable : verdadero )< \ / EM > < \ / SPAN > < \ / LI > < LI > Reliability ( tipo : esriFieldTypeInteger , alias : Reliability , Tipo SQL : sqlTypeOther , nulo : verdadero , editable : verdadero )< \ / EM > < \ / SPAN > < \ / LI > < LI > UUID ( tipo : esriFieldTypeString , alias : UUID , Tipo SQL : sqlTypeOther , longitud : 100 , nulo : verdadero , editable : verdadero )< \ / EM > < \ / SPAN > < \ / LI > < \ / UL > < UL style = "padding : 0px 0px 0px 30px ; "> < LI style = "margin : 0.2em 0px ; "> CreationDate ( tipo : esriFieldTypeDate , alias : CreationDate , Tipo SQL : sqlTypeOther , longitud : 8 , nulo : verdadero , editable : falso ) < \ / STRONG > < \ / EM > < \ / SPAN > < \ / LI > < LI style = "margin : 0.2em 0px ; "> Creator ( tipo : esriFieldTypeString , alias : Creator , Tipo SQL : sqlTypeOther , longitud : 128 , nulo : verdadero , editable : falso ) < \ / STRONG > < \ / EM > < \ / SPAN > < \ / LI > < LI style = "margin : 0.2em 0px ; "> EditDate ( tipo : esriFieldTypeDate , alias : EditDate , Tipo SQL : sqlTypeOther , longitud : 8 , nulo : verdadero , editable : falso ) < \ / STRONG > < \ / EM > < \ / SPAN > < \ / LI > < LI style = "margin : 0.2em 0px ; "> Editor ( tipo : esriFieldTypeString , alias : Editor , Tipo SQL : sqlTypeOther , longitud : 128 , nulo : verdadero , editable : falso ) < \ / STRONG > < \ / EM > < \ / SPAN > < \ / LI > < \ / UL > < \ / STRONG > campos pre-poblados< \ / EM > < \ / SPAN > < \ / P > < H4 id = "toc-hId-621495556" id = "toc-hId-621495556">Capa de Entidad Lineal< \ / SPAN > < \ / H4 > < UL > < LI > OBJECTID ( tipo : esriFieldTypeOID , alias : OBJECTID , Tipo SQL : sqlTypeOther , longitud : 0 , nulo : falso , editable : falso ) < \ / STRONG > < \ / EM > < \ / SPAN > </ LI> </ UL> Descripción, Tipo SQL: sqlTypeOther, longitud: 1024, nullable: true, editable: true)<\/EM><\/SPAN><\/LI>UUID (type: esriFieldTypeDouble, alias: UUID, SQL Type: sqlTypeOther, nullable: true, editable: true)<\/EM><\/SPAN><\/LI><\/UL>ShapeLength (type: esriFieldTypeDouble, alias: ShapeLength, SQL Type: sqlTypeDouble, nullable: true, editable: false)<\/STRONG><\/EM><\/SPAN><\/LI>CreationDate (type: esriFieldTypeDate, alias: CreationDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)<\/STRONG><\/EM><\/SPAN><\/LI>Creator (type: esriFieldTypeString, alias: Creator, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)<\/STRONG><\/EM><\/SPAN><\/LI>EditDate (type: esriFieldTypeDate, alias: EditDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)<\/STRONG><\/EM><\/SPAN><\/LI>Editor (type: esriFieldTypeString, alias: Editor, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)<\/STRONG><\/EM><\/SPAN><\/LI><\/UL>*<\/STRONG>campos pre-poblados<\/EM><\/SPAN><\/P>Por favor asegúrese de usar los nombres exactos de campo y tipos<\/EM><\/STRONG>, (alternativamente tendría que ajustar el script).<\/SPAN><\/P>Una vez que las capas de entidades estén configuradas, por favor habilite la edición<\/STRONG> y configúrelas a PRIVATE<\/STRONG>.<\/SPAN><\/P>Por favor consulte "Waze Feed Technical Specifications [Get Waze Data]"<\/EM><\/STRONG> desde el Portal del Partner<\/A> para definiciones exactas sobre descripciones de campos.<\/P><\/BLOCKQUOTE>
<\/P>

Configurando el script de Python<\/H4>Reemplace las secciones de comentario (líneas 6, 9 y 10)<\/SPAN><\/EM> con su propio feed XML y URLs para sus capas de entidades de punto y línea.<\/P>importar<\/SPAN> xml.<\/SPAN>etree.<\/SPAN>ElementTree como<\/SPAN> ET importar<\/SPAN> urllib.<\/SPAN>request importar<\/SPAN> arcpy desde<\/SPAN> datetime importar<\/SPAN> datetime namespaces =<\/SPAN> {<\/ token">.<\/SPAN>find(<\/SPAN>'linqmap:subtype'<\/SPAN>,<\/SPAN> namespaces)<\/SPAN>.<\/SPAN>text no es<\/SPAN> None<\/SPAN>:<\/SPAN> Subtype =<\/SPAN> member.<\/SPAN>find(<\/SPAN>'linqmap:subtype'<\/SPAN>,<\/SPAN> namespaces)<\/SPAN>.<\/SPAN>text.<\/SPAN>replace(<\/SPAN>'_'<\/SPAN>,<\/SPAN> ' '<\/SPAN>)<\/SPAN>.<\/SPAN>capitalize(<\/SPAN>)<\/span> else<\/span>:<\/span> Subtype =<\/span> ''<\/span> UUID =<\/span> member.<\/span>find(<\/span>'linqmap:uuid'<\/span>,<\/span> namespaces)<\/span>.<\/span>text Reliability =<\/span> member.<\/span>find(<\/span>'linqmap:reliability'<\/span>,<\/span> namespaces)<\/span>.<\/span>text if<\/span> len(<\/span>member.<\/span>findall(<\/span>'linqmap:reportDescription'<\/span>,<\/span> namespaces)<\/span>)<\/span> ><\/span> 0<\/span>:<\/span> Description =<\/span> member.<\/span>find(<\/span>'linqmap:reportDescription'<\/span>,<\/span> namespaces)<\/span>.<\/span>text else<\/span>:<\/span> Description =<\/span> ''<\/span> Type =<\/span> member.<\/span>find(<\/span>'linqmap:type'<\/span>,<\/span> namespaces)<\/span>.<\/span>text.<\/span>replace(<\/span>'_'<\/span>,<\/span> ' '<\/span>)<\/span>.<\/span>capitalize(<\/pan>) point <class="operatortoken">=</pan>member.find('georss:point',namespaces).text.replace(' -',',-').split(' ') row <class="operatortoken">=</pan>Subtype,Type,Title,DateReported,City,Street,UUID,Reliability,Description,float(point[1] ) , float ( point[0] ) cursor <class="operatortoken" >=</ pan> arcpy.da.InsertCursor(fcp, ["ReportSubtype", "ReportType", "Title", "DateReported", "City", "Street", "UUID", "Reliability", "Description", "SHAPE@X", "SHAPE@Y"]) cursor.insertRow(row) del cursor print('etapa 1') except: pass print('fallo Etapa 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(<\/SPAN>member.<\/SPAN>findall(<\/SPAN>'linqmap:endNode'<\/SPAN>,<\/SPAN> namespaces)<\/SPAN>)<\/SPAN> ><\/SPAN> 0<\/SPAN>:<\/SPAN> EndNode =<\/SPAN> member.<\/SPAN>find(<\/SPAN>'linqmap:endNode'<\/SPAN>,<\/SPAN> namespaces)<\/SPAN>.<\/SPAN>text else<\/SPAN>:<\/SPAN> EndNode =<\/SPAN> ''<\/SPAN> if<\/SPAN> len(<\/SPAN>member.<\/SPAN>findall(<\/SPAN>'linqmap:reportDescription'<\/SPAN>,<\/SPAN> namespaces)<\/SPAN>)<\/SPAN> ><\/SPAN> 0<\/SPAN>:<\/SPAN> Description =<\/SPAN> member.<\/span>find(<\/span>'linqmap:reportDescription'<\/span>,<\/span> namespaces)<\/span>.<\/span>text else<\/span>:<\/span> Description =<\/span> ''<\/span> if<\/span> len(<\/span>member.<\/span>findall(<\/span>'linqmap:street'<\/span>,<\/span> namespaces)<\/span>)<\/span> ><\/span> 0<\/span>:<\/span> Street =<\/span> member.<\/span>find(<\/span>'linqmap:street'<\/span>,<\/span> namespaces)<\/span>.<\/span>text else<\/span>:<\/span> Street =<\/span> ''<\/span> UUID =<\/span> member.<\/span>find(<\/span>'linqmap:uuid'<\/span>,<\/span> namespaces)<\/span>.<\/</pan></translation>} token">'etapa 2'<\/SPAN>)<\/SPAN> excepto<\/SPAN>:<\/SPAN> pasar<\/SPAN> imprimir<\/SPAN>(<\/SPAN>'falló Etapa 2'<\/SPAN>)<\/SPAN> sino<\/SPAN>:<\/SPAN> intentar<\/SPAN>:<\/SPAN> Fecha =<\/SPAN> miembro.<\/SPAN>encontrar(<\/SPAN>'updateDate'<\/SPAN>)<\/SPAN>.<\/SPAN>texto FechaReportada =<\/SPAN> datetime.<\/SPAN>strptime(<\/SPAN>Fecha, <\/SPAN>'%a %b %d %H:%M:%S %z %Y'<\/SPAN>)<\/SPAN> si<\/SPAN> len(<\/SPAN>miembro.<\/SPAN>encontrartodos(<\/SPAN>'linqmap:city'<\/Span>, namespaces)<\/Span>) > 0<\/Span>:<\/Span> Ciudad =<\/Span> miembro.<\/Span>encontrar(<\/Span>'linqmap:city'<\/Span>, namespaces)<\/Span>.texto sino<\/Span>:<\/Span> Ciudad =<\/Span> ''<\/Span> si<\/Span> len(<\/Span>miembro.<\/Span>encontrartodos(<\/Span>'linqmap:startNode'<\/Span>, namespaces)<\/Span>) > 0<\/Span>:<\/Span> NodoInicio =<\/Span> miembro.<\/span>encontrar('linqmap:startNode', namespaces).texto sino: NodoInicio = '' si len(miembro.encontrartodos('linqmap:endNode', namespaces)) > 0: NodoFin = miembro.encontrar('linqmap:endNode', namespaces).texto sino: NodoFin = '' si len(miembro.encontrartodos('linqmap:reportDescription', namespaces)) > 0: Descripción = miembro.encontrar('linqmap:reportDescription', namespaces).texto sino: Descripción ,"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,Título,Tipo,DateReported,Ciudad,Calle,Longitud,Nivel,UUID,NodoInicio,NodoFin,Descripción,arcpy.Polyline(array)]) del cur print('etapa 3') except: pass print('fallo Etapa 3') else: print('Error')‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍<\/SPAN>‍<\/SPAN>‍<\/SPAN>‍<\/SPAN>‍<\/SPAN>‍<\/SPAN>‍<\/SPAN>‍<\/SPAN>‍<\/SPAN>‍<\/SPAN>‍<\/SPAN>‍<\/SPAN>‍<\/SPAN>‍<\/SPAN>‍<\/SPAN>‍<\/SPAN>‍<\/SPAN>‍<\/SPAN>‍<\/SPAN>‍<\/SPAN>‍<\/SPAN>‍<\/SPAN>‍<\/SPAN>‍<\/SPAN>‍<\/SPAN>‍<\/SPAN>‍<\/SPAN>‍<\/SPAN>‍<\/SPAN>‍<\/SPAN>‍<\/SPAN>‍

Programando el script

Una vez que el script de Python está en funcionamiento, use Windows Task Scheduler para ejecutar el script en intervalos de tiempo específicos, lo que añadirá nuevas características a las capas de entidades de ArcGIS Online (esta técnica mantendrá un historial de toda la información de tráfico desde la primera vez que ejecute el script).

Captura de pantalla de la capa de entidades de atascos de tráfico

Mostrando Información de Tráfico en Vivo

Para mostrar información de tráfico en vivo - cree vistas de capas de entidades y defina sus características para mostrar solo las características creadas en los últimos x minutos, siendo x la frecuencia con la que ha configurado el script de Python para ejecutarse.

He configurado el script de Python para ejecutarse cada 4 minutos - posteriormente las vistas de capas de entidades para mostrar características creadas en los últimos 4 minutos.

Definir características para mostrar información de tráfico en vivo

Una vez configurado, puede compartir estas vistas públicamente y mostrarlas en aplicaciones orientadas al público.

A continuación se muestran enlaces a nuestras vistas de capas de entidades y un mapa que muestra estas características junto con cierres de carreteras/aceras.

Alertas de Tráfico en Vivo - Excluyendo Cierres de Carreteras
Atascos de Tráfico en Vivo

Mapa de Cierres de Carreteras/Acera en Canberra - Incluyendo Tráfico en Vivo*

*haga clic aquí para saber más sobre nuestro proceso de solicitud para trabajos en carreteras/aceras

Enviar correo electrónico a personas específicas cuando se reporte un Accidente

Usé el método siguiente, alternativamente podría usar scripts similares en Python o crear su propio script en Python para activar un correo electrónico cuando se agreguen nuevas características a una capa de entidades.

Ejecute el script de correo electrónico que prefiera sobre una nueva vista de capa de entidades alojada (tipo geometría = punto), que solo muestre Accidentes (ReportType = "Accident"), donde DateReported fue en los últimos x minutos.

Definir características para mostrar solo accidentes durante un intervalo específico de tiempo

Y finalmente, configure Windows Task Scheduler para capturar cualquier nueva característica (accidentes) que ocurra en los últimos x minutos.

Espero que pueda aprovechar estos flujos de trabajo para adaptarlos a sus propias necesidades comerciales. Y por favor, no dude en compartir sus pensamientos, comentarios o preguntas en la sección de comentarios abajo.

¡Saludos! - Gee Fernando

Encuentra más publicaciones etiquetadas con

Comentarios

TrafficOpsGIS

Would anyone be willing to post their most up to date python script. Have not been able to run mine successfully for a couple months now. Thank you

TrafficOpsGIS

@daniel_marincounty Nice work, thank you for sharing.

TrafficOpsGIS

@JasonSimpson Waze changed their Feed URL format a few months back. Here you may find details on new format which you will need to upload your new format version on the Waze Partner Hub.

Please log in to the Partner Hub and use the new links for your feeds under “Get data from Waze” > “Waze data feed” (see image below)
The old URLs will be deprecated by end of May 2023

Screenshot 2023-03-14 at 13.23.532470×1604 226 KB

If you’re not sure, here are examples of how the URLs look like:

Old URLs:

New URL:

https://www.waze.com/partnerhub-api/partners/11697892328/waze-feeds/58c6486b-430e-4835-83a2-8a6e12593d96?format=1 14

JasonSimpson

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.

daniel_marincounty

I was able to copy @TrafficOpsGIS script into my own notebook and create the layers using the manual directions. However, it doesn't work when I run it in a notebook for some reason. If I run it as a .py it works 🙂 feel free to copy

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('##URL'))

root = tree.getroot()
channel_head = []
fcp = "##URL"
fcl = "##URL"
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')

daniel_marincounty

The links to create the feature layers no longer work. Are there new ones?

TrafficOpsGIS

Final Final pt3 pt3 pt2 pt2 pt1 pt1

@RosyChawla2 , @MichelleNino Here is the script I use. See images 1-4 for complete script. Hope you are able to replicate. I run it directly in ArcPro Notebook. Please let me know if you have any questions on.

RosyChawla2

Hi All,

This script is exactly what we need at our county to be able to display data we get from Waze Connected Citizen Program. After proper indentation I tried running it with ArcPy 3.0 as well as ArcPy 2.7 Unfortunately I was not able to get it going.

Will appreciate any help.

Thanks,

-Rosy

MichelleNino

@TrafficOpsGIS Hello! I would like to know if you've tried to run this script with python3.0? Or have you modified this code according to your needs?

Thank you!

Michelle

TrafficOpsGIS

Can confirm that with some formatting for Python3.0 that this workflow does indeed still work! Thank you all for all your shared information!

TrafficOpsGIS

Does this workflow still work? Thank you

MarkCandland

I used this awesome article to get a nice dashboard up and running but after it running a couple months (and data piling up) I started running into performance issues. I thought it was the amount of records, so I created a new feed to test. That feed with far fewer records is having the same issue.

Anyone else experiencing some draw speed issues? it seems like the data is updating quickly (in my lists) but the map updates painfully slow.

Thanks

Mark

EmergencyManagement

Hello Geethaka Fernando We followed your instructions with your provided python link. Had to fix some formatting errors as when it was pasted it didn't indent correctly. I'm running into the issue that this script, when ran in python versions 2.7.12 & 3.8.2 both can not find the library / module urllib.requests. Is there a specific version of python I need to download to get this to work? Thanks

PaulRobinson1

Geethaka,

I'm Executive Director of a non-profit organization that exists to accelerate innovation and business growth around coastal resilience solutions.We're offering up to $500,000 to create a next generation traffic app that offers drivers real-time flooding and re-routing information.

If you're interested in learning more, visit riseresilience.org for more details, or email paulrobinson@riseresilience.org

Regards,

Paul Robinson

ErnestoCarreras2

Geethaka Fernando‌ thanks for this amazing script!!! I have a question regarding the DateReported and Length data. In the Waze documentation, it says the data is collected in UTC and kmh. Is the processed data in this format? I am asking because if that is the case, I would like to convert the data to my local time zone, as well as kmh to mph. Thanks!

ZairaRosas

Hey! Can anyone help me?

I'm getting no error running the script, but it's kind of strange because I live in northen hemisphere but my XML data has the "world-georss" on the url, so I ran both possible scripts (the script on the post and the script with solution that Geethaka Fernando gave to Eric Shreve ) and both worked... I even tried with and witout the "/0" at the end of the layer url and BOTH worked hahaha... What I mean by saying that all of this worked is that I got no errors running the script (I run it from the ArcGIS Pro IDLE) but no data is displaying on the "Data" tab from My Content / Waze Layers into ArcGIS Online... I don't know what else to do! Please, any one can help me???

I would really appreciate it!

PatriceCase1

This is a fantastic tutorial, thank you for sharing this!

GeneSipes1

Does anyone know of a way to modify the script so that it doesn't copy over duplicate rows every time the script is ran? I have two feature layers, one that holds all of the data, and is accumulated over time as the script is ran every 5 minutes, and another with a filter showing only the events that have been reported in the last 10 minutes. I am noticing that events are getting copied over multiple times and the data set is growing very fast. Thanks!

GeneSipes1

I was able to execute the python script, but I am getting the below error. Can you elaborate on how the script is supposed to access and edit the feature layer?

fail Stage 1
cannot open 'https://services1.arcgis.com/Hug9pbs2TYetbCha/arcgis/rest/services/Waze_Point_Feature_Layer/FeatureServer'

Ok, I figured this one out. I needed to use the individual feature service with its index number at the end. Like this:

https://services1.arcgis.com/Hug9pbs2TYetbCha/arcgis/rest/services/Waze_Point_Feature_Layer/FeatureServer/0

Anonymous User

Hello Gene, when I originally wrote this script it was for python 2.7 and it looks like from that error Noorhaizarinie Zaini gets is from trying to run it in python3. The parse function in python3 is different in some regard. you could try changing

to

tree <SPAN class="" style="color: #a67f59; background: rgba(255, 255, 255, 0.5); border: 0px; font-weight: inherit; margin: 0px; padding: 0px;">=</SPAN> ET<SPAN class="" style="color: #999999; border: 0px; font-weight: inherit; margin: 0px; padding: 0px;">.fromstring</SPAN><SPAN class="" style="color: #999999; border: 0px; font-weight: inherit; margin: 0px; padding: 0px;">(</SPAN>file<SPAN class="" style="color: #a67f59; background: rgba(255, 255, 255, 0.5); border: 0px; font-weight: inherit; margin: 0px; padding: 0px;">=</SPAN>urllib<SPAN class="" style="color: #999999; border: 0px; font-weight: inherit; margin: 0px; padding: 0px;">.</SPAN>request<SPAN class="" style="color: #999999; border: 0px; font-weight: inherit; margin: 0px; padding: 0px;">.</SPAN>urlopen<SPAN class="" style="color: #999999; border: 0px; font-weight: inherit; margin: 0px; padding: 0px;">(</SPAN>'<SPAN class="" style="color: slategray; border: 0px; font-weight: inherit; margin: 0px; padding: 0px;">##URL for XML waze connection##'))</SPAN>tree <SPAN class="" style="color: #a67f59; background: rgba(255, 255, 255, 0.5); border: 0px; font-weight: inherit;">=</SPAN> ET<SPAN class="" style="color: #999999; border: 0px; font-weight: inherit;">.</SPAN>ElementTree<SPAN class="" style="color: #999999; border: 0px; font-weight: inherit;">(</SPAN>file<SPAN class="" style="color: #a67f59; background: rgba(255, 255, 255, 0.5); border: 0px; font-weight: inherit;">=</SPAN>urllib<SPAN class="" style="color: #999999; border: 0px; font-weight: inherit;">.</SPAN>request<SPAN class="" style="color: #999999; border: 0px; font-weight: inherit;">.</SPAN>urlopen<SPAN class="" style="color: #999999; border: 0px; font-weight: inherit;">(</SPAN>'<SPAN class="" style="color: slategray; border: 0px; font-weight: inherit;">##URL for XML waze connection##'))

</SPAN>

I am at the UC so I dont have a test environment to see if this works but I'm fairly certian it has to do with that line of code reading the xml from the url.

GeneSipes1

Hello Gee, I love this write up, thanks for sharing? Are you at the UC this year? If so I would love to meet up and see if you can help me quickly set this up. I have made my feature layers and altered the script, but I get the same error that Noorhaizarinie Zaini gets when executing it from Pro.

Thanks!

GeneSipes1

I got the same error. Did you get it solved?

NoorhaizarinieZaini1

Thanks Gee.

But could you please help me on this. I've run this script using ArcGIS Pro, but there are errors like the one below.

How to fix it?

Geethaka Fernando

https://community.esri.com/groups/departments-of-transportation/blog/2018/10/31/python-script-to-ingest-waze-data-to-arcgis-online

Error when run with ArcGIS Pro

NuozhouFu

Thanks for sharing the code! BTW, is it the only way to use Waze data by becoming a CCP member?

Anonymous User

Thanks Jonathan Pollack‌,

Have a look at this post - https://community.esri.com/groups/departments-of-transportation/blog/2019/02/04/traffic-study-reports-utilising-waze-data-and-arcgis-insights

Sometime in the near future, I'll update the script to ONLY ingest data into AGOL, when something changes in the XML feed.

Gee

deleted-user-8TVt6oc0ewsX

Great job on this! Has anyone done anything to deal with duplicate records getting created as the data gets consumed and loaded into AGOL? Maybe filter by date or some other field when ingesting the data? Any ideas?

Anonymous User

All good Joel.

In terms of error handling, the only thing I changed was - ability to handle missing elements and self closing tags.

For Example

<SPAN class="keyword token">if</SPAN> len<SPAN class="punctuation token">(</SPAN>member<SPAN class="punctuation token">.</SPAN>findall<SPAN class="punctuation token">(</SPAN><SPAN class="string token">'linqmap:subtype'</SPAN><SPAN class="punctuation token">,</SPAN> namespaces<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="operator token">></SPAN> <SPAN class="number token">0</SPAN> <SPAN class="operator token">and</SPAN> member<SPAN class="punctuation token">.</SPAN>find<SPAN class="punctuation token">(</SPAN><SPAN class="string token">'linqmap:subtype'</SPAN><SPAN class="punctuation token">,</SPAN> namespaces<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">.</SPAN>text <SPAN class="keyword token">is</SPAN> <SPAN class="operator token">not</SPAN> None<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; Subtype <SPAN class="operator token">=</SPAN> member<SPAN class="punctuation token">.</SPAN>find<SPAN class="punctuation token">(</SPAN><SPAN class="string token">'linqmap:subtype'</SPAN><SPAN class="punctuation token">,</SPAN> namespaces<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">.</SPAN>text<SPAN class="punctuation token">.</SPAN>replace<SPAN class="punctuation token">(</SPAN><SPAN class="string token">'_'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">' '</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">.</SPAN>capitalize<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN>
<SPAN class="keyword token">else</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; Subtype <SPAN class="operator token">=</SPAN> <SPAN class="string token">''</SPAN>‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

And, I haven't come across any errors since changing this

Gee

Anonymous User

Seeing people use this makes me wish I put some actual error handling in here

Anonymous User

You need to have ArcGIS Pro or ArcMap installed to use the module arcpy

And if you intend on using ArcMap, you'll have to amend the syntax slightly to cater for Python 2.x

Alternatively, you could look into using the ArcGIS API for Python

Gee

OriGudes3

Thanks, does it have to be ArcGIS Pro?

Únete a la Conversación

Los miembros registrados pueden publicar, seguir actualizaciones y más. ¿Nuevo aquí? Regístrate para una cuenta gratuita.

Iniciar Sesión
Registrarse

Enlaces Rápidos

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.