Latest Contributions by RandyKreuziger

Esri Geoportal Extension to Become Open Source According to the above link ESRI is suppose to make the code available by the end of September.  Anyone know the status on this? ... View more

I just got handed a hard drive with 25 years of landsat data for our state.  There are composite images so the processing has been dune but there can be multiple flights per year.  We already have 65 image services which eats up  system memory so I don't what to create another 70+ services for the landsat data.  Is anyone else out there running into system memory issue due to too many image services?  We are running ArcGIS Server with Image Server both at 9.3 on 2 different server. ... View more

When I upgraded to SDE 9.2 on SQL 2000 the DeleteFeatures_management geoprocessing tool would immediately delete all records at one time in a feature class.  So total time about 2 seconds.  Now I find that on SDE 9.3.1 it's gone back to the pre 9.2 behavior of deleting 1 record at a time.  What happened.  I changed my python script from pointing to a 9.2 SDE database to my new 9.3.1 and it has gone from 2 seconds to several hours for the deletefeatures command on a 1 million plus row feature class.                     if row.feattype == "table":                         gp.Deleterows_management(targetLayer)                                              else:                         gp.DeleteFeatures_management(targetLayer) ... View more

I have an SDE managed raster catalog.  An external user wants a county subset of the 3500 tiles that make up the 500GB catalog.  Is there a way to merge the Raster Catalog wireframe or foot prints with polygon layer?  I just want a list of tiles that are covered by two counties.  It is going to be a large number a tiles but I still have the TIFs on another hard drive.  If I can generate a list of tiles I'll convert that into a bat file that copies the original TIFs to an external hard drive then build a new raster catalog of the subset.  If there is an easier way to do this I'm all ears. ... View more

We are moving from an old SDE 9.2 / SQL 2000 server to servers running SDE 9.3.1 / SQL 2008.  Moving non-versioned databases has not been a problem but I haven't tried versioned SDE databases yet.  Should I insist that the SDE databases be unverioned before moving to the new servers?  On the old servers we used SQL logins but are moving to Windows Authentication on the new.  This leaves the versions orphaned in a way when they are restored/upgraded on the new server.  Or is this were sp_change_users_login is used? Thanks ... View more

(I posted this yesterday to the "ArcGIS Desktop - General" but this might be a better place.) I would like to retire an old but popular feature class of place locations replacing it an official GNIS feature class. Unfortunately, because the attribute names differ there is no way in ArcMap that I can see to borrow the symbology from the old feature class with the new one. Old Layer / New Layer PtName --> Feature_Name FClass --> Feature_Type I tried to import the symbology then tried changing the data source but neither worked because the attribute names are different. Any ideas? Does anyone know if this has been submitted as an enhancement? ... View more

We don't have the GeoPortal Toolkit and Metadata Explorer no longer works.  My users would like a document or something that lists all the feature classes in a Geodatabase by he primary keyword.  Has anyone written a program read through all the FCs in a GDB and write out specific meatadata elements.  Or a python program that can parse a directory of XML files and do that same thing would be great. ... View more

We are moving to new SQL/SDE servers so I was expecting the rasters saved in an SDE raster catalog to be a lot faster but that is not the case.  In fact they are slower but things aren't identical from system to system. Current system:  SQL 2000 / SDE 9.1, 1 CPU   5 year old server, Raster Catalog on a 5 year old SAN New system:      SQL 2008 / SDE 9.3.1,  2 CPU 4 Core,  Raster Catalog on new SAS drives The raster catalog in 9.1 was created using 1m resolution NAIP data tiled by quarter township and using LZ77 compression with an average tile size of 4950 rows by 7050 columns.  Newer imagery is now available so I loaded it as is but decided to using JPEG2000 compression (75) with all tiles being 8192 by 8192.  Using the new raster catalog in ArcMap doesn't seem that much slower than the old raster catalog but in ArcIMS applications it takes double the time to pan through the imagery.  So in ArcIMS where it takes 7 seconds to pan with the old service it now takes 14 seconds which is not acceptable.  The only reason this data is going into ArcSDE is to maintain legacy ArcIMS applications.  I used the JPEG2000 compression to save some disk space on the new system but I suspect that is where the slow down is occuring.  Any thoughts?  Thanks! ... View more

We are a SQL Server shop.  The business side of our IT shop likes to put out policies without vetting them beyond one or two people and they would like all database schema changes to be made only through T-SQL scripts provided to the DBAs.  So before the ink is dry I need to argue when and where ArcSDE databases are different.  SDE tables and feature classes cannot be created and/or modified through pure Transact-SQL scripts.  So I think they will then argue that all changes still need to be scripted and should be done in python.  There is a lot we can do through python arcgis scripting but are there still some things that can only be manipulated through ArcObjects in the realm of schema changes?  I'm wondering how many shops insist that only the DBA can make schema changes to their SDE database? It shouldn't matter but we are running SQL Server 2008 and SDE 9.3.1. ... View more