Latest Contributions by RandyKreuziger

What could Esri possibly do about this issue?  Stage a coup? -V Sorry, but I'm not the one who classified it as a bug it was ESRI. But why has ESRI made Geometry the default storage format at ArcSDE 10.1 pushing users towards the slower performing Microsoft spatial datatype in the first place?  I'd still like to know what ESRI's plan is with SDEBinary.  If it's going to be around for the next 3 years I'll stick with it. ... View more

It's not just spatial views, it's all tables which involve GEOMETRY/GEOGRAPHY objects, but these are an aspect of Microsoft's database implementation (and the difficulty of tuning it), not anything Esri has control over. - V I've noticed the horrible responce for Geometry verses SDEBindary.  Has ESRI said how long SDEBindary will continue to be a storage option?  There is a known bug NIM089293 from a year ago dealing with the draw time for the GEOMETRY spatial type verses the draw time for SDEBINARY.  Unfortunately, it's severity is "low."  In my experience that usually means it's not going to be fixed. ... View more

I've noticed a 147 character limit in the MXD Summary property.  I agree with the others that this sort of thing should be documented somewhere in the ESRI help files. ... View more

The for loop does away with the need for the "Next()" statements.  Also, arcpy if very case sensitive.  In the code below notice that AddRow is replaced by addRow.  Unfortunately, I don't have any 4 band imagery to test my script. # Import system modules import sys, string, os, arcpy arcpy.env.workspace = "H:/" tifList = arcpy.ListRasters("*.tif") for inTIFF in tifList:     print inTIFF     outTIFF = "E:/Rasters/NAIP2009/" + inTIFF     # Create a value table to hold the multivalue parameters for the Union_analysis     vtab = arcpy.CreateObject("ValueTable")      vtab.addRow(inTIFF + "\\Band_1")     vtab.addRow(inTIFF + "\\Band_2")     vtab.addRow(inTIFF + "\\Band_3")     # Process: Composite Bands...     print "Composite Bands 1 2 3 " + str(inTIFF)     arcpy.CompositeBands_management(vtab, outTIFF)   ... View more

Change the while loop into a for loop and it should work. ... View more

I have been trying to get the raster iterator to work but i cannot get it to maintain the original file name.  Script or model, either way it works, will work for me. I wrote the following 2 and a half years ago so you'll want to it to arcpy.  It retains the name of the original TIF but saves it to a different folder. # Import system modules import sys, string, os, arcgisscripting # Create the Geoprocessor object gp = arcgisscripting.create() # Load required toolboxes... gp.AddToolbox("C:/\Program Files (x86)/ArcGIS/ArcToolbox/Toolboxes/Data Management Tools.tbx") gp.workspace = "E:/Temp/FourBandNAIP" tifList = gp.ListRasters("*") inTIFF = tifList.Next() while inTIFF:     outTIFF = "E:/Rasters/NAIP2009/" + inTIFF     if gp.exists(outTIFF):         print "Skipping " + str(inTIFF)     else:         # Create a value table to hold the multivalue parameters for the Union_analysis         vtab = gp.CreateObject("ValueTable")          vtab.AddRow(inTIFF + "\\Band_1")         vtab.AddRow(inTIFF + "\\Band_2")         vtab.AddRow(inTIFF + "\\Band_3")         # Process: Composite Bands...         print "Composite Bands 1 2 3 " + str(inTIFF)         gp.CompositeBands_management(vtab, outTIFF)        inTIFF = tifList.Next() del gp ... View more

ArcGIS metadata is stored in the geodatabase system tables, so you cannot store ArcGIS metadata for objects that are not registered with ArcSDE or the geodatabase.  The views created through ArcGIS Desktop are database views and are not registered with ArcSDE or the geodatabase and, therefore, ArcGIS metadata cannot be stored for them. We realize this is a limitation that needs to be addressed before the admin commands are retired.  At present, though, the only way to store ArcGIS metadata for a view is to create it with the sdetable command as you described. Thank you kpeter for posting that.  I got the same news from Aleta at ESRI a week ago but forgot to update this thread.  It was very hard getting users to create metadata but now they expect it which is a good thing.  We've got a couple dozen SDE views that could be SQL views when we migrate to ArcSDE 10.1 later this month.  But, how are sites handling the metadata for SQL Views and Query Layers? ... View more

Crafty,   I've tried both Metadata Importer and Import Metadata.  Each fails with the same message Exception from HRESULT: 0x80042601   And when I select the "Description" tab in ArcCatalog for the views it doesn't display any of the Edit, Validate, Export, Import buttons.  Instead it displays The item's XML contains errors But you're saying views created using the "Create New View" support metadata? ... View more

Martin,   If your site is on maintenance you should call ESRI support and ask if it's been assigned to a tech.  If not, then they're not even working on it at this time. ... View more

This is a little testing on one of my 10.0 map services, and I think you'll get the picture:  >>> if mapServiceGrp0.supports("SERVICEPROPERTIES"): ...     for i, j in mapServiceGrp0.serviceProperties.iteritems(): ...         print "{0}:  {1}".format(i, j) ...         UserName:  ServiceType:  MapServer Connectionfile:  C:\Documents and Settings\whitley-wayne\Application Data\ESRI\Desktop10.0\ArcCatalog\mc-gisappserver (admin).ags URL:  Managerurl:  http://mc-gisapperver/arcgis/services Server:  mc-gisappserver Allowinsecuretokenurl:  0 Wayne, using your code from the first example still returns a URL without the map service name. I need the folder /map service name. We do go through a balancer but that shouldn't be a problem. UserName:  ServiceType:  MapServer Connectionfile:  C:\Users\kreuzrsk\AppData\Roaming\ESRI\Desktop10.0\ArcCatalog\arcgis on aimsw.xxx.wa.ags URL:  http://aimsw.xxx.wa.lcl/arcgis/services Server:  Allowinsecuretokenurl:  0 Anonymous:  -1 ... View more

Michael,   I'm gettting a URL back but it doesn't list the mapservice or the folder.  Here is what I get: http://aimsw.xxx.wa.lcl/arcgis/services According to the documentation the URL will be null if through a LAN [INDENT]URL �??Property displaying the URL to the service. If the connection to ArcGIS for Server is through a local area network (LAN), this value will be null[/INDENT] Could it be that ESRI is not making the map service name available through arcpy? ... View more

Just when I thought I had it :mad: With several users dead in the water we decided to recreate the missing Map Service so users could get into their MXDs while I work on the script.  That's created a new issue.  In my script I'm removing all broken Map Services, but now that a dummy Map Service is available there's no broken map services to delete.  So I need to delete a Map Service based on its name but I can't figure out how to find the orginal Map Service name. Both lyr.name and lyr.longName display the name from ArcMap's table of contents.  Several users have renamed the Map Service name after adding it to the map's TOC, so I'm unable to test for the original name. None of the service properties for a Map Service give the source map service name. print lyr.serviceProperties {u'UserName': u'', u'ServiceType': u'MapServer', u'Connectionfile': u'C:\\Users\\xxxx\\AppData\\Roaming\\ESRI\\Desktop10.0\\ArcCatalog\\arcgis on gisolymap01.ags', u'URL': u'http://gisolymap01/arcgis/services', u'Server': u'', u'Allowinsecuretokenurl': u'0', u'Anonymous': u'-1'} Any ideas? ... View more