Latest Contributions by StefanOffermann

Is there a solution to this problem? I am getting the error with Postgres 9.4 and ArcSDE 10.4.1 on my query: SELECT a.objectid AS aid, MAX(s."value") AS "maxvalue" FROM test_points AS a INNER JOIN test_areas AS s ON ST_Intersects(a.shape, s.shape) GROUP BY aid ... View more

So I made a python script for automatic updates of all feature classes in a geodatabase (also in feature datasets), my be this is helpful to others. import arcpy import codecs import os import xml.dom.minidom workspace = r'C:\data\geodatabase.gdb' # or path to sde-file temporaryXmlFile = r'C:\temp\xmlMetadataTransferFile.xml' def getAlias(featureClass):     return arcpy.Describe(featureClass).aliasName def createTemporaryXmlMetadataFile():     with open(temporaryXmlFile, 'w') as theFile:         theFile.write('<metadata />') def writeAliasToTemporaryXmlMetadataFile(alias):     xmlFile = open(temporaryXmlFile)     dom = xml.dom.minidom.parse(xmlFile)     titles = dom.getElementsByTagName("resTitle")     for title in titles:         title.firstChild.data = alias         title.setAttribute('Sync', 'FALSE')         with codecs.open(temporaryXmlFile, 'w', 'utf-8') as file2:             dom.writexml(file2)     def doUpdate(path):     arcpy.env.workspace = path     fcList = arcpy.ListFeatureClasses()     if fcList is None:         print '- WARN: No feature classes found'         return     for fc in fcList:         print '- Feature class: ' + fc         alias = getAlias(fc)         print '  Alias: ' + alias         createTemporaryXmlMetadataFile()         arcpy.SynchronizeMetadata_conversion(fc, "ALWAYS")         arcpy.MetadataImporter_conversion(fc, temporaryXmlFile)         writeAliasToTemporaryXmlMetadataFile(alias)         arcpy.MetadataImporter_conversion(temporaryXmlFile, fc)         arcpy.SynchronizeMetadata_conversion(fc, "ALWAYS") print 'Set resource title to alias name of all feature classes' doUpdate(workspace) fdsList = arcpy.ListDatasets("*", "Feature") if fdsList is None:     print '- WARN: No feature datasets found' else:     for fds in fdsList:         print 'Feature dataset: ' + fds         path = os.path.join(workspace, fds)         doUpdate(path)                 print 'done.' ‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ ... View more

Is not that I have to wait a long time, but check the execution time of both lines when executed separately in ArcGIS Pro 2.0 python window: arcpy.Describe('data') arcpy.da.Describe('data') Which one is a bit faster? 🙂 The second one has the "running progress dots", while the first one returns the describe object at once. ... View more

Is it possible that the the new is slower than the old one? May be because the new one is based on dictionaries which are filled right away, and the old one "lazy loads" property data? ... View more

Thanks you for the think, this answers my question! ... View more

Too bad this isn't possible... Did you notice the differences in the REST API docs between 10.1 and 10.4? The topic "Export Map" of "Map Service", the note of "dynamicLayer" parameter. 10.1.1: "If the layer source is a dataLayer based on a data table (table or queryTable dataSource), then set drawingInfo. In case of dataLayer based on raster data source only transparency in the drawingInfo is supported. renderer is unsupported at 10.1." Source: ArcGIS Server REST API  10.4.1: "If the layer source is a dataLayer based on a data table ( table or queryTable dataSource), then set drawingInfo." Source: https://localhost:6443/arcgis/sdk/rest/index.html#/Export_Map/02ss00000062000000/  (is this available online?) ... View more

Hello Joanne, thanks for your example, now I can use a raster file from a registered folder to use a dynamic raster file in my service. However, the renderer from the service is not used to diplay the image vie Export Map function. Instead, a black and white stretch is used for drawing the raster. Did you manage to use the symbology of the service for a dynamic raster in your map service? My Request looks like this: https://localhost:6443/arcgis/rest/services/DynRaster/MapServer/export?bbox=97540.59674654296,5160630.089092379,4117123.002818559,6932517.524568021&bboxSR=&layers=&layerDefs=&size=&imageSR=&format=png&transparent=false&dpi=&time=&layerTimeOptions=&dynamicLayers=[{"source":{"type": "dataLayer","dataSource":{"type": "raster","workspaceId": "RasterFolder","dataSourceName": "TAMM_01_1881_01s.tif"}}}]&gdbVersion=&mapScale=&rotation=&f=html This is the value for dynamicLayers, human-readable: [{   "source": {     "type": "dataLayer",     "dataSource": {       "type": "raster",       "workspaceId": "RasterFolder",       "dataSourceName": "TAMM_01_1881_01s.tif"     }   } }]‍‍‍‍‍‍‍‍‍‍ ... View more

I can ask my colleague at Esri Germany support to send you the case number with Esri Inc. ... View more

Is it a "normal" map service or a map service associated to an asynchronous geoprocessing service? In my case, it is the latter one. At this time, Esri Germany can reproduce the bug with ArcGIS server 10.2.2, while Esri Inc cannot reproduce it. Until now, we haven't found a difference in patch level or server operating system or anything, which can explain the bug. Esri Germany stated that an upgrade to ArcGIS server 10.4.1 may solve the problem. I am currently thinking about installing the newest version of ArcGIS server for the geoprocessing service, as Esri Inc cannot reproduce the bug and will likely not make a patch for our small user base. May be you have some more users to get some more weight in fixing the bug 🙂 ... View more

In my case, I think I am coming to the crux of the matter. The GP-Service has an associated Map-Service to display the results. The jobs directory of the GP-Service is configured to never clean up the results, so that the app can always view them via map service. I discovered that the map service never frees up his memory, so the ArcSOC process on ArcGIS Server is using more and more memory. When the soc reaches 800 MB of memory, it stops working and responds with errors. The only way to get back to normal is restarting the service and thus freeing the memory. I am currently working on the issue with Esri Germany Support. Btw, this problem occurs on ArcGIS Server 10.2, but I think 10.4.1 does not show this error. ... View more

Sorry for my delayed answer, in the meantime it worked (or seemed to work?), now the error is back. Jonathan Quinn: Can you verify the .msd exists in that location? Yes, the MSD file is existing in the folder. Also the FGDB referenced in the MSD is existing. Very hard to debug, I have no clue what is going wrong 😞 ... View more

What is "the map"? The MSD-File is existing on the disc, how can I check what is missing? The source data of all layers referenced in the MSD file (which is a FGDB) is accessible. ... View more