Latest Contributions by VincentLaunstorfer

Nothing special in the Arcade expression, just trying to parse a date field in order to display previous day (Recent) features differently than others (Historic): var date_text = $feature.DATETIME //Parsing DATETIME date var datetime_list = Split(date_text, "T") var date_list = Split(datetime_list[0], "-") var year_val = date_list[0] var month_val = date_list[1] var day_val = date_list[2] //Caution: months are 0 to 11 var movement = Date(year_val, month_val-1, day_val) //Current day var display=Today() var yesterday=DateDiff(display, movement, 'days') decode(yesterday, 1,'Recent','Historic') ... View more

In addition to the JSON issue mentioned, is there a reason why the JSON do not show up in Portal? It is strange! Same layer published to ArcGIS Online, JSON file is accessible, but not in Portal... ... View more

Thanks for the solution to modify symbology of hosted Feature in ArcGIS Online. I am trying to micmic a hatch symbol fill over a fill symbol fill (multi-layers symbol),  as follow: ArcGIS Pro symbol When shared to ArcGIS Online, only the first 2 layers displays. It looks like the plain yellow fill is not in the  JSON file. In drawingInfo for uniqueValue renderer, initially I have: {"symbol":{"type":"esriSFS","style":"esriSFSBackwardDiagonal","color":[255,85,0,255],"outline":{"type":"esriSLS","style":"esriSLSSolid","color":[255,85,0,255],"width":0.5}},"value":"Sample","label":"Sample"} And I am trying to add an extra “layer” in the symbology for the plain yellow fill: "type":"esriSFSSolid","color":[255,255,153,255] When updating the drawingInfo code, it gives: {"symbol":{"type":"esriSFS","style":"esriSFSBackwardDiagonal","color":[255,85,0,255],"type":"esriSFSSolid","color":[255,255,153,255],"outline":{"type":"esriSLS","style":"esriSLSSolid","color":[255,85,0,255],"width":0.5}},"value":"Sample","label":"Sample"} When hitting Update Service Definition button, it looks ok with a message “Updated Feature Service”… but when returning to the drawingInfo code, the changes do not appear. I also tried to change the "lastEditDate" to null to validate the change, but it did not work either. Finally, I noticed a message “Note: This operation is only supported via POST” in the top of the JSON page. Would it cause the drawingInfo not to update? Any help appreciated ... View more

Hi all, Thanks for your help. 1. Unfortunately, the Repair Geometry did not help because dangles are probably too large and not actually geometry problem 2. The Planarize is a good start but it only works for simple self-intersection and/or dangle. Anything more complex need a manual fix, as shown below. 3. The Topology rule... I tried to adjust the XY Cluster Tolerance to 0.001 degree to match my self-intersection but I received an unknown error... This is all I managed to test this week... As the Repair Self Intersection tool in the Topographic Production extension needs extra licensing, I wonder if there would be a similar tool in QGIS (but I am not as experienced in QGIS!) ... View more

True, it is in Cartography Tools, meant for visual representation. I wonder how the similar Polygon to Centerline in the Topographic Production Tools would behave... Similar algorithm or smarter? I cannot try it as it requires an extension! Also, the Collapse Hydro Polygon is new in Pro 2.9 and perhaps not perfect (yet!) https://pro.arcgis.com/en/pro-app/latest/tool-reference/topographic-production/polygon-to-centerline.htm   ... View more

Thanks Dan. I double-checked again the parameters but nothing really to deal with dangles in sharp bends. To me, it looks like the Collapse Hydro Polygon tool is confused in sharp bends as you can see here below. Small bends are ok Vs dangles in sharp bends! I guess the algorythm tries to follow the shape of the polygon to the further possible way but ends up thw wrong way, and then retries the centerline in a better direction... If this makes sense. This may explain why centerline always ends the wrong way at polygons ends, as below. In the tool notes, there are some warnings/limitations about possible confusion with certain complex polygon (which to me is not the case here). For info, polygons are not multipart. Sharp Bends Polygon Ends   ... View more

Hi George, a while ago, you managed to forward my question above to a broader audience... How to you do that? Is there topic completely transferred to the more targeted community that way? Thanks ... View more

Thanks. Fortunately, my SQL-client does not allow to create duplicate column names in a view... Although, this is an important point, if there is any duplicate OBJECTID, the layer usually draws but it is not possible to open the attribute table. To come back to my initial issue, I forgot to mention that if I create a table (not a view) with same SQL query, it does work and display correctly in ArcGIS Pro. As I said, my SQL has 2 LEFT JOIN and a nested decode (about 10) statment in SELECT to fetch data in the LEFT JOIN tables... Probably too heavy for ArcGIS Pro to execute the query and receive results to display... If I create the same views without the nested decode, the layer displays but slowly. To me, it is like ArcGIS Pro not 'patient' enought to receive results to display. I have to admit I am stuck with complex queries. I will have to create tables on a regular basis in the scheduler and create views on them. ... View more