Latest Contributions by MaximeDemers

‎10-03-2018

Thank you for the link, that helps a lot. I read: Standardized queries are applied to the entire ArcGIS Server site; they cannot be enabled for some services and disabled for others. So if it's turned on on the server, standardized queries are being used for the where_clause in a arcpy.da.SearchCursor in a Geoprocessing Service right? That do not just applied to standardized queries of MapServices right?

‎10-03-2018

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

‎09-24-2018

Hello Thomas Edghill, The point of my request is the following. To be able to publish a geoprocessing service to ArcGIS Server, you have to run it first in ArcGIS Desktop. The parameter values you defined in ArcGIS Desktop for the service will automatically become the default parameter values published on ArcGIS Server. That behavior is not really logical according to me. You don't necessary want to publish the parameters values that was used for testing the service during the publication process. Sometimes, you don't want default parameter values at all. I hope that will clarify my point. Thank you very much for your interest in this idea. Maxime Demers

‎09-07-2018

Hello Joshua, Thank you for the information about the blob field! Do you have an idea why storing unicode in text field works?

‎09-07-2018

I got an SystemError : error return without exception set error when trying to write a unicode into a blob field into a table inside a FGDB using arcpy.da.UpdateCursor with ArcGIS v10.3 for instance: import arcpy value = u"a unicode string! with some accent éàèû" with arcpy.da.UpdateCursor(r"c:\\my_fgdb.fgdb\my_table", ["blob_field"], where_clause="FID = '0') as cursor: for row in cursor: row[0] = value cursor.updateRow(row)‍‍‍‍‍‍‍ I know blob can store string, but is it normal it cannot store unicode?

‎09-04-2018

After some testing, I confirm that using layer (.lyr) as the in_table parameter in arcpy.da.SearchCursor is much faster than using the path to the feature class. However, to be able to use fields name tokens such SHAPE@ or SHAPE@JSON you have to create a new layer class with the arcpy.mapping module. For instance: layer_path = r"c:\\temp\\myLayer.lyr" with arcpy.da.SearchCursor(arcpy.mapping.Layer(layer_path), ["*"]) as cursor: for row in cursor: print row‍‍‍‍‍

‎09-04-2018

Hi, Is it possible to use the SHAPE@ or SHAPE@JSON fields tokens in arcpy.da.SearchCursor with a layer (.lyr) as the in_table parameter with ArcGIS 10.3? When I try it, I got the following error: RuntimeError: A column was specified that does not exist. If I use the path to the feature class as the in_table parameter, it works.

‎08-31-2018

That's interesting! I'll try using layers as input rather than paths to datasets

‎08-07-2018

Hi, I have some geoprocessing services published to ArcGIS Server. I have noticed that every time a request is made, a great amount of time (1 to 3 seconds) is needed to establish the connection to the Geodatabase Entreprise workspace. For instance, if I use a SearchCursor in a GP Service, a lot of time is spent setting arcpy.env.workspace. It's not faster to define the workspace in the SearchCursor in_table parameter. I would like to know if it's possible to define a default workspace at the service instances level in order that when a service instance is created, the connection to a Geodatabase Entreprise workspace is made and kept open until the instance is closed? Thank you!

‎06-06-2018

Thank you for your answer Doug Browning Is survey123 is available with Arcgis Server? Collector looks interesting, but the Android version have many negative comments on Google Store. Also, as other Esri products, Collector is developed in a very general purpose. I'll give ArcGIS Runtime SDK for Android a try for an app that will cover our specific needs.

‎05-31-2018

I am interested in building a mobile application that would allow users to edit and add data to a map (hosted as a mapService on ArcGIS Server) in offline mode, using the mobile device GPS and forms for data. What tools, products and technologies are needed to develop such app? I know this would be quite difficult to answer with such few details, but all information would be welcome. Is using an android and iOS html5/javascript framework combined with ArcGIS Javascript API is enough or will we need to use tools like Android Studio with ArcObject SDK ? I think the Collector app would be close to what we need, but some features are missing like complex forms to populate the features datatable. Is it possible to extend the Collector app?

‎04-10-2018

Hi, I am trying to create a tool to automatize the update of roads source used in a Network Dataset. In short, I want to truncate the roads feature class and append the new roads data into it. Finally, I want to rebuild the Network Dataset. When I try to edit the roads feature class, I encounter errors because arcpy can't edit a feature class used by a Network Dataset. Is there a strategy I could try to achieve what I am trying to do? Note: The Network Dataset is stored in Geodatabase Enterprise (SDE)

‎03-09-2018

Hi, I encounter a non-explicit error when using arcpy.GenerateServiceAreas with those parameters: Maximum_Facilities Maximum_Number_of_Breaks This is how I can reproduce the error: import arcpy, os arcpy.env.overwriteOutput = True featureSet = { "geometryType": "esriGeometryPoint", "spatialReference": { "wkid": 3857, }, "fields": [ { "name": "Name", "alias": "Name", "type": "esriFieldTypeString" }, ], "features" : [ { "geometry" : { "x" : -7929427, "y" : 5910701 }, "attributes" : { "Name": "Foo" } } ] } facilities = arcpy.AsShape(feature_set, True) Network_Dataset_Path = os.path.join(r"\\vnageop1", "geod", "Geobase", "Network Analyst", "Reseau routier - AQ.gdb", "NetworkAnalystAQ", "NetworkAnalystAQ_ND") arcpy.GenerateServiceAreas_na(facilities, "10", "Meters", Network_Dataset_Path, "in_memory/ServiceAreasOutput", Maximum_Facilities=10, Maximum_Number_of_Breaks=5)‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ The error is the following: Traceback (most recent call last): File "G:\testNA.py", line 34, in <module> arcpy.GenerateServiceAreas_na(facilities, "10", "Meters", NA_Path, "in_memory/ServiceAreasOutput", Maximum_Facilities=10) File "c:\app\arcgis\desktop10.3\arcpy\arcpy\na.py", line 3878, in GenerateServiceAreas raise e ExecuteError: A python error occurred. Failed to execute (GenerateServiceAreas). If I remove the Maximum_Facilities and Maximum_Number_of_Breaks parameters, I have a correct output. What could be the problem?

‎02-08-2018

Ok sorry about that Robert, I am not super familiar with the javascript API. Thank you for your help anyway, it was really appreciated. Have a good day!

‎02-08-2018

Ok yes! In v3.23 you don't have to create a new IdentifyTask when using mapService, you just have to define the infoTemplates parameter of the ArcGISDynamicMapServiceLayer object and the API handles the request automatically, and it uses a query not an identify. ArcGISDynamicMapServiceLayer | API Reference | ArcGIS API for JavaScript 3.23 I will do the same in v4.6, I will use QueryTask instead of IdentifyTask, I think that will solve my problem.

Online Status	Offline
Date Last Visited	‎07-13-2026 10:21 AM

My Ideas

Latest Contributions by MaximeDemers

Re: Blind SQL injection for Geoprocessing service using arcpy.da.SearchCursor

Blind SQL injection for Geoprocessing service using arcpy.da.SearchCursor

Re: Give the possibility to remove default value for geoprocessing services parameters

Re: FGDB - Error when writing unicode into blob field

FGDB - Error when writing unicode into blob field

Re: ArcGIS Server - Define a default workspace for every service instances

Use SHAPE@ tokens in arcpy.da.SearchCursor with layer (.lyr)

Re: ArcGIS Server - Define a default workspace for every service instances

ArcGIS Server - Define a default workspace for every service instances

Re: What is needed to develop ArcGIS Mobile application (android and/or iOS)

What is needed to develop ArcGIS Mobile application (android and/or iOS)

ArcPy - Update/modify Network Dataset roads source

Arcpy - GenerateServiceAreas_na throw error when using some parameters

Re: javascript API 4.6 - IdentifyTask - get attributes names instead of attributes alias in result

Re: javascript API 4.6 - IdentifyTask - get attributes names instead of attributes alias in result

ArcGIS Javascript API 3.x documentation

Status with plans

Re: Licence Manager version for CityEngine

Re: Cache problem with Scene Layer in AGOL

Re: How to get the dataset name from feature class...