Latest Contributions by MaximeDemers

In my organization there is 2-3 people that are creating applications with webappbuilder.They are creating the applications on a server where webappbuilder developper is installed. When they are satisfied, they download the application files and copy it to another server for publishing on the internet. One of my roles in the organization is to develop custom widgets or extend existing with new functions, design, etc... I found it difficult to maintain all the customization in every applications they are creating. I have no problem to build widgets that will be generic enough to works in all application, but when I apply some change to those widgets, I found it painful to go in each applications and replace the code with the new version. Is there a way to force every applications to use the same widget code trunk in the server where webappbuilder developer is installled in order to keep them up-to-date automatically? Any thoughts or suggestions on this? P.S.: I have also some problem for testing, but I think I will open a new discussion on this ... View more

Hi, I am wondering why it's possible to add a relationshipClass from the catalog into a map in ArcMap 10.3 only when the cardinality is M-N (many-to-many). When I try to drag and drop other relationshipClass with cardinality (1-1 or 1-M) I have the following error: Could not add the specified data object to the map. Thanks for the info, Maxime ... View more

Hi, Is it possible to use relationships in popupTemplate with sublayers in MapImageLayer? I am doing the following but the related fields are not displayed. var layer = new MapImageLayer({ "url": "https://infogeo.education.gouv.qc.ca/arcgis/rest/services/SandBox_Maxime/TEST_LOISIRS/MapServer", "imageFormat": "png", "title": "Test loisirs", "sublayers": [ { id: 0, popupTemplate: { title: "Sites", outFields: ["*"], content: [ { type: "fields", fieldInfos: [ { fieldName: "id", visible: true, label: "Id" }, { fieldName: "relationships/0/trajet", visible: true, label: "Trajet" } ] } ] } } ] });‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ Does the relationships in popupTemplate only works with FeatureLayer? ... View more

I am working on a C# tool that is looping over polygons geometries vertices in order to create a list of deltas (distance) between vertices coordinates. The output is a json that will be consumed by a custom application. The output is a JSON containing a list of features objects which contains attributes and geometry deltas arrays like this one: {     "features": [         {             "attributes" : {"CD_MUNCP" : 00000, "NOM_MUNCP": "Name1"},             "geometry" : [[5767767, -834778, -10, 199, 99, 332, 9, -9], [5787767, -837709, 123, 33, -31, 121, 0, 12330]]         },         {             "attributes" : {"CD_MUNCP" : 00001, "NOM_MUNCP": "Name2"},             "geometry" : [[5784576, -831278, -190,  54, 0, -2, 5464, 789], [57354576, -837008, 66, 872, 3445, -879, -2, 22]]         },     ] }‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ The geometry deltas output is expected to be on this format: [[x0, y0, (x0-x1), (y0-y1), (x1-x2), (y1-y2)] Exterior rings and interior rings deltas are on the same level in the array: [[ExteriorRing1 deltas], [InteriorRing1 deltas], [ExteriorRing2 deltas], ...] I am using deltas instead of absolute coordinates to compact the size of the json output. This method has proven to be able to reduce size by more than 50% for huge geometry. I am using IEnumerable<> to create the geometry deltas because I thought it would be faster, but it appears this is not really compatible with JSON serialization (it takes very long to serialize) so I transform them using .ToList(); The most important thing with the code is the performance because it aims to be used in a custom GeoProcessing Service on ArcGIS Server. My tests prove that the bottleneck is the JSON serialization that takes more than 50% of the processing time. For instance for a big FeatureClass it could takes 1.5 seconds to create the deltas but 25 seconds to serialize it to JSON. Is there some optimizations or workarounds I can do to improve the performance? Any suggestions would be appreciated.     using System;     using System.Collections.Generic;     using fastJSON;     using ESRI.ArcGIS.ADF;     using ESRI.ArcGIS.Geodatabase;     using ESRI.ArcGIS.Geometry;     using ESRI.ArcGIS.esriSystem;         namespace DesktopConsoleApplication1     {         class Program         {             static void Main(string[] args)             {                 var watch = System.Diagnostics.Stopwatch.StartNew();                 Result result = new Result                 {                     features = CreateResultFeatures().ToList()                 };                 string output = JSON.ToJSON(result);                 watch.Stop();                 Console.WriteLine(watch.ElapsedMilliseconds);                 Console.ReadLine();             }                 public class Result             {                 public IEnumerable<ResultFeature> features { get; set; }             }                 public class ResultFeature             {                 public Dictionary<string, dynamic> attributes { get; set; }                 public IEnumerable<IEnumerable<int>> geometry { get; set; }             }                 public static IEnumerable<ResultFeature> CreateResultFeatures()             {                 IWorkspace gdbWorkspace = FileGdbWorkspaceFromPath(@"\\vnageop1\geod\Maxime\test.gdb");                 IFeatureWorkspace featureWorkspace = (IFeatureWorkspace)gdbWorkspace;                 IFeatureClass featureClass = featureWorkspace.OpenFeatureClass(@"GEO09E04_MUNCP_GEN");                 IQueryFilter queryFilter = new QueryFilterClass();                 queryFilter.SubFields = "CD_MUNCP, NOM_MUNCP, SHAPE";                     int cd_muncp_idx = featureClass.FindField("CD_MUNCP");                 int nom_muncp_idx = featureClass.FindField("NOM_MUNCP");                     using (ComReleaser comReleaser = new ComReleaser())                 {                     IFeatureCursor cursor = featureClass.Search(queryFilter, false);                     comReleaser.ManageLifetime(cursor);                     IFeature feature = null;                     while ((feature = cursor.NextFeature()) != null)                     {                         ResultFeature resultFeature = new ResultFeature                         {                             attributes = new Dictionary<string,dynamic>                             {                                 { "CD_MUNCP", Convert.ToString(feature.Value[cd_muncp_idx]) },                                 { "NOM_MUNCP", Convert.ToString(feature.Value[nom_muncp_idx]) }                             },                             geometry = PolygonToDeltas(feature.Shape as IPolygon4).ToList()                         };                         yield return resultFeature;                     }                 }             }                 public static IEnumerable<IEnumerable<int>> PolygonToDeltas(IPolygon4 polygon)             {                 IGeometryBag exteriorRingGeometryBag = polygon.ExteriorRingBag;                 IGeometryCollection exteriorRingGeometryCollection = exteriorRingGeometryBag as IGeometryCollection;                 for (int i = 0; i < exteriorRingGeometryCollection.GeometryCount; i++)                 {                     IGeometry exteriorRingGeometry = exteriorRingGeometryCollection.get_Geometry(i);                     IPointCollection exteriorRingPointCollection = exteriorRingGeometry as IPointCollection;                     yield return CreateDeltas(exteriorRingPointCollection);                         IGeometryBag interiorRingGeometryBag = polygon.get_InteriorRingBag(exteriorRingGeometry as IRing);                     IGeometryCollection interiorRingGeometryCollection = interiorRingGeometryBag as IGeometryCollection;                     for (int k = 0; k < interiorRingGeometryCollection.GeometryCount; k++)                     {                         IGeometry interiorRingGeometry = interiorRingGeometryCollection.get_Geometry(k);                         IPointCollection interiorRingPointCollection = interiorRingGeometry as IPointCollection;                         yield return CreateDeltas(interiorRingPointCollection );                     }                 }             }                 private static IEnumerable<int> CreateDeltas(IPointCollection pointCollection)             {                 int previous_x = (int)pointCollection.get_Point(0).X;                 int previous_y = (int)pointCollection.get_Point(0).Y;                 yield return previous_x;                 yield return previous_y;                 for (int i = 1; i < pointCollection.PointCount; i++)                 {                     int current_x = (int)pointCollection.get_Point(i).X;                     int current_y = (int)pointCollection.get_Point(i).Y;                     yield return previous_x - current_x;                     yield return previous_y - current_y;                     previous_x = current_x;                     previous_y = current_y;                 }             }         }     }‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ ... View more

Hi, I would like to know if a geoprocessing service that is using arcpy.da.SearchCursor can be subject to blind SQL injection if the where_clause parameter of the SearchCursor is one of the service parameter. Is there a possibility that injecting SQL in the where_clause parameter can affect the integrity of the source table especially by using the SLEEP() command? Thank you ... View more