Latest Contributions by DouglasHall

Unfortunately, join and update cursor won't work. I wrote the following function to get around AddJoin_management and CalculateField_management. CalculateField_management kept failing on 100k record datasets. def JoinAndUpdateField(fcTblPrimary, strJoinFldPrimary, fcTblForeign, strJoinFldForeign, strUpdateFldPrimary, strUpdateFldForeign, methodToProcess=None): """ Joins two tables or feature classes or combination and updates one field from another with optional passed method to update the value further. The same result can be gotten with arcpy AddJoin_management and CalculateField_management, but CalculateField_management kept failing on 100k record datasets. Parameters ---------- fcTblPrimary : str Full path to a fc or table e.g. c:/proj/data.gdb/datasetA or c:/proj/USER@VECTOR.sde/datasetB or Database Connections/USER@VECTOR.sde/datasetC strJoinFldPrimary : str Field of primary table to join on fcTblForeign : str Full path to a fc or table to join to strJoinFldForeign : str Field of secondary table to join on strUpdateFldPrimary : str Field to update strUpdateFldForeign : str Field to get value from for the update methodToProcess : method Optional Method to process the strUpdateFldForeign field before updating """ dictValues = dict ([(key, val) for key, val in arcpy.da.SearchCursor (fcTblForeign, [strJoinFldForeign, strUpdateFldForeign])]) boolUseMethod = False if methodToProcess: boolUseMethod = True with arcpy.da.UpdateCursor(fcTblPrimary, [strJoinFldPrimary,strUpdateFldPrimary]) as cursor: for row in cursor: try: if boolUseMethod: row[1] = methodToProcess(dictValues[row[0]]) else: row[1] = dictValues[row[0]] except KeyError: pass cursor.updateRow(row) del cursor del dictValues ... View more

Further information from anonymous rogue GIS person, Background: I had domains created by old user accounts and couldn't delete. I setup an Oracle trace and deleted a test domain to see which SDE tables were affected. The trace showed the SDE tables SDE.GDB_ITEMS and sde_xml_doc1 being deleted from. Find your domains, using queries like above. Here is the online help reference for your type of database: Example: Finding domain owners using SQL—Help | ArcGIS Desktop . I recommend adding the GDB_ITEMS OBJECTID and DEFINITION column to the query. The DEFINITION column will be the key for  deleting in the table sde_xml_doc1. One thing is that the xml magic query for the owner column may not work. For example in Oracle, we don't have the arcgis extproc setup (it's the dll or so file to access shape columns...something like that). You should know which domains to delete even without the owner. Query for Oracle without the OWNER: select a.OBJECTID, a.name "DOMAIN_NAME", b.name "TYPE", a.definition FROM SDE.GDB_ITEMS a INNER JOIN SDE.GDB_ITEMTYPES b ON a.Type = b.UUID WHERE b.Name IN ('Coded Value Domain', 'Range Domain'); OBJECTID  DOMAIN_NAME    TYPE                      DEFINITION -------------------------------------------------------------------------------- 1921            test_domain          Coded Value Domain     181 So if you would like to risk corrupting the delicate web of SDE, make sure all tables/feature classes are no longer referencing the domain or deleted. Then something like this: DELETE FROM SDE.GDB_ITEMS WHERE OBJECTID = 1921; DELETE FROM SDE.sde_xml_doc1 WHERE SDE_XML_ID = 181; Commit; Embedded xml domains -- worst idea ever Esri!!! ... View more

Just FYI, I can't create and delete 3 insert cursors squentially without getting the following error. (Sequentially meaning that I'm creating and deleting the cursor before creating the next one). RuntimeError: workspace already in transaction mode Upon creating the third cursor and attempting to insertRow(), I get the error. It doesn't matter if I'm in the editing session or not. I can comment out any one of the 3 cursor insert blocks and the other 2 will work. Using a with clause or cursor = ..., doesn't matter with arcpy.da.InsertCursor('Points_Geom', ["PointID", 'SHAPE@XY']) as cursor:     cursor.insertRow((123458, (4364181.91, 263840.13))) or cursor = arcpy.da.InsertCursor('Points_Geom', ["PointID", 'SHAPE@XY']) cursor.insertRow((123458, (4364181.91, 263840.13))) del cursor ... View more

$top would be nice to have -- to limit results of a query ... View more

$top would be nice to have -- to limit results of a query ... View more

No it's not a public service... maybe I'll try and get it through the firewall and repost the question. ... View more

I've been doing a minimalist, across the screen, combined title and toolbar. Using jquery ui buttons and jquery ui theme roller. Click a button and then open a jquery ui dialog that floats on top of screen. - Doug at http://spatialexception.org //html     <div id="titleBar">         <div style="position: absolute; top: 10px; left: 10px; font-size: 200%; font-weight: bolder; font-family: Verdana, Arial; height: 30px; color: #0b93d5;">             Application Title         </div>         <div style="position: absolute; top: 10px; right: 3px;">             <button id="btnCustomTool"></button>             <button id="btnLayerLegend" style="margin-left: 25px"></button>             <button id="btnIdentify"></button>             <button id="btnFindAddress"></button>             <button id="btnMeasure"></button>             <button id="btnBasemap"></button>             <button id="btnInitialExtent"></button>             <button id="btnClearGraphics"></button>             <button id="btnAbout"></button>         </div>     </div>     <div id="map">     </div>     <div id="dialogFindAddress" class="vgisDialog vgisHidden">     </div>     .... //css #titleBar {     top: 0px;     height: 44px;     width: 100%;     z-index: 199;     background-color: #444444;     position: absolute; } #map {     width: 100%;     top: 44px;     bottom: 0px;     overflow: hidden;     position: absolute; } //javascript //Fix for jquery/dojo z index conflict dijit.popup._beginZIndex = 5000; $("#btnFindAddress").button({                 text: false,                 icons: { primary: 'ui-icon-contact' },                 label: 'Enter and locate a street address'             }).click(function () {                 $(this).blur().button('refresh');                 var $pane = $('#dialogFindAddress');                 if ($pane.dialog('isOpen')) {                     $pane.dialog('close');                 } else {                     $pane.removeClass('vgisHidden').dialog('open');                 }             }); $('#dialogFindAddress').dialog({                 autoOpen: false,                 width: 400,                 height: 175,                 position: 'bottom',                 title: 'Find Address',                 close: function (event, ui) {                     map.graphics.clear();                 }             }); ... View more

Hard to say what could be occurring, but a couple things to check -- 1. You may have already done this, but in Chrome debugger, set a break point to see if you are actually getting to map.graphics.remove() 2. Make sure that you are disconnect 'ing when through with functionality and then reconnecting as this functionality is started and stopped. //starting var mySelectedEvent = dojo.connect(resultGrid, 'onDeselected', function (rowId) {... //stopping if (mySelectedEvent) { dojo.disconnect(mySelectedEvent); } It does bring up the question to me, how does the graphics layer know which graphic to remove? How does it compare 2 graphics for equality? By reference? By spatial and then attribute  data both or one or the other other? 3. In your debugger, check out the map.graphics array to see what is in there, maybe you can loop through and find the graphic that way and pass it to remove(). <<< ---YOU KNOW WHAT -- I BET THIS IS ACTUALLY THE ANSWER. It's using an object reference to test for equality in the remove() function. When you are calling map.graphics.remove(layerResults.features[rowId]);, I bet it's not the same object reference as when added to graphics. If you can't figure it out, you can always map.graphics.clear() and then add the features, minus the deleted feature, back to the map. FYI, check out this snippet that for IdentifyTask that only returns layers in scale http://www.spatialexception.org/posts/arcgis-javascript-identifytask-returns-scale-dependent-layers ... View more

1. There is query parameter query.objectIds = [12345,23456]; that takes a simple array of objectIds, I assume it is semi-efficient. You could then add as graphics to map. See code below... 2. You may want to check out using a FeatureLayer service using MODE_SELECTION and then selectFeatures(query, selectionMethod?) var aObjectIds = []; aObjectIds.push(12345); aObjectIds.push(67890); detailQueryTask = new esri.tasks.QueryTask(mapServiceName); detailQuery = new esri.tasks.Query(); detailQuery.objectIds = aObjectIds; detailQuery.returnGeometry = true; detailQuery.outFields = ["*"]; detailQueryTask.execute(detailQuery, function (results) {     doSomething(results);         if (results.features !== undefined && results.features.length !== 0) {         zoomToPointFeaturesExtent(results);         highlightMonuments(results, "STYLE_SQUARE"); } function zoomToPointFeaturesExtent(results) {     var xtent,     xmin = results.features[0].geometry.x,     ymin = results.features[0].geometry.y,     xmax = results.features[0].geometry.x,     ymax = results.features[0].geometry.y;     dojo.forEach(results.features, function (feature) {         if (feature.geometry.x > xmax) { xmax = feature.geometry.x; }         if (feature.geometry.y > ymax) { ymax = feature.geometry.y; }         if (feature.geometry.x < xmin) { xmin = feature.geometry.x; }         if (feature.geometry.y < ymin) { ymin = feature.geometry.y; }     });     xtent = new esri.geometry.Extent(xmin, ymin, xmax, ymax, map.spatialReference);     map.setExtent(xtent, true); } function highlightMonuments(results, markerType) {     map.graphics.clear();     var symbol = new esri.symbol.SimpleMarkerSymbol();     symbol.setOutline(new esri.symbol.SimpleLineSymbol(esri.symbol.SimpleLineSymbol.STYLE_SOLID, new dojo.Color([0, 255, 255, 1.0]), 3));     symbol.setStyle(esri.symbol.SimpleMarkerSymbol[markerType]);     symbol.setColor(new dojo.Color([0, 255, 255, 0.0])); // hollow center, fully transparent     symbol.setSize(10);     var geom;     dojo.forEach(results.features, function (value) {         geom = value.geometry;         var graphic = new esri.Graphic(geom, symbol);         map.graphics.add(graphic);     }); } Show me some love with an answer? ... View more

We have a team of friendly developers that are very familiar with ArcGIS API and Esri technology generally -- Best of Luck! Douglas Hall Senior Software Developer VESTRA Resources, Inc. 5300 Aviation Drive, Redding, CA 96002 530.223.2585 dhall@vestra.com www.vestra.com "Over the past 20 years, we have helped hundreds of clients in federal, state, and local government as well as private firms use GIS to build and maintain critical systems, supporting public works, utilities, natural resources, and emergency preparedness applications." ... View more

***Just updated to add one more check and better variable naming*** Been dealing with this myself -- and it's different between jsapi 2.x and 3.x. Only what's showing on map will be identified on. Note the checking of subLayerIds for null, scale checking, after getting the visibleLayers from service. Solution is for jaspi 3.x function doIdentify(evt) {     var referenceLayer = new esri.layers.ArcGISDynamicMapServiceLayer(referenceMapServiceName, {id: 'referenceLayer'});     var aVisibleSubLayers = referenceLayer.visibleLayers,         aLayersInScale = [],         identifyParams = new esri.tasks.IdentifyParameters(),         identifyTask = new esri.tasks.IdentifyTask(referenceLayer.url);     //loop thru visible sublayers that are not group layers, then check within scale     if (referenceLayer.visible === true && aVisibleSubLayers.length !== 0 && aVisibleSubLayers[0] !== -1) {         dojo.forEach(referenceLayer.createDynamicLayerInfosFromLayerInfos(), function (dLayInfo) {             if (dLayInfo.subLayerIds === null && dojo.indexOf(aVisibleSubLayers, dLayInfo.id) !== -1 &&                     (dLayInfo.minScale === undefined || dLayInfo.minScale === 0 || map.getScale() <= dLayInfo.minScale) &&                     (dLayInfo.maxScale === undefined || dLayInfo.maxScale === 0 || map.getScale() >= dLayInfo.maxScale)) {                 aLayersInScale.push(dLayInfo.id);             }         });     }     if (aLayersInScale.length > 0) {         identifyParams.geometry = evt.mapPoint;         identifyParams.mapExtent = map.extent;         identifyParams.tolerance = 3;         identifyParams.returnGeometry = true;         identifyParams.layerIds = aLayersInScale;         identifyParams.layerOption = esri.tasks.IdentifyParameters.LAYER_OPTION_ALL;         identifyParams.width = map.width;         identifyParams.height = map.height;         identifyTask.execute(identifyParams, function(idResults) {             doSomethingWithIdentifyResults(idResults);         });     } } Bonus: Identifies on multiple services at once and return as one array using dojo.DeferredList dojo.require("dojo.DeferredList"); referenceLayer = new esri.layers.ArcGISDynamicMapServiceLayer(referenceMapServiceName, {id: 'referenceLayer'}); //Operational layers operationalLayer = new esri.layers.ArcGISDynamicMapServiceLayer(operationalMapServiceName, {id: 'operationalLayer'}); function executeIdentify(geom, serviceName, aLayerIds) {     var identifyParams = new esri.tasks.IdentifyParameters(),         identifyTask = new esri.tasks.IdentifyTask(serviceName);     identifyParams.geometry = geom;     identifyParams.mapExtent = map.extent;     identifyParams.tolerance = 3;     identifyParams.returnGeometry = true;     identifyParams.layerIds = aLayerIds;     identifyParams.layerOption = esri.tasks.IdentifyParameters.LAYER_OPTION_ALL;     identifyParams.width = map.width;     identifyParams.height = map.height;     return identifyTask.execute(identifyParams); } function doIdentify(evt) {     var geom = evt.mapPoint,         aLayersInScale,         aDeferreds = [],         deferredList,         currentScale = map.getScale(),         aVisibleSubLayers,         aAGSDynMapServicesToIdentify = [referenceLayer, operationalLayer];     map.graphics.clear();     identifyLayerKeyPrevious = undefined;     //loop thru dynamic services, then thru visible sublayers that are not group layers, then check within scale     dojo.forEach(aAGSDynMapServicesToIdentify, function (agsDynMapService) {         aVisibleSubLayers = agsDynMapService.visibleLayers;         if (agsDynMapService.visible === true && aVisibleSubLayers.length !== 0 && aVisibleSubLayers[0] !== -1) {             aLayersInScale = [];             dojo.forEach(agsDynMapService.createDynamicLayerInfosFromLayerInfos(), function (dLayInfo) {                 if (dLayInfo.subLayerIds === null && dojo.indexOf(aVisibleSubLayers, dLayInfo.id) !== -1 &&                         (dLayInfo.minScale === undefined || dLayInfo.minScale === 0 || currentScale <= dLayInfo.minScale) &&                         (dLayInfo.maxScale === undefined || dLayInfo.maxScale === 0 || currentScale >= dLayInfo.maxScale)) {                     aLayersInScale.push(dLayInfo.id);                 }             });             if (aLayersInScale.length > 0) {                 aDeferreds.push(executeIdentify(evt.mapPoint, agsDynMapService.url, aLayersInScale));             }         }     });     // create a deferred list to aggregate the state for multiple asynchronous identify queries     deferredList = new dojo.DeferredList(aDeferreds);     deferredList.then(function (aIdentifyResults) {         // "aIdentifyResults" is 2D array of results         // array [0] boolean true or false, success or failure of individual call         // array [1] is the array of identity results returned         doSomethingWithIdentifyResults(aIdentifyResults);     }); } ... View more

Thanks Detroit -- needed the section that creates an extent for a set of points! ... View more