Latest Contributions by DuncanHornby

Chris, I'm not too hot on this subject but I've always understood dpi (dots per inch) as something that output devices use (printers/screens) so dpi has no meaning when you look at a raster and is probably why there is no interface that exposes such a property.  I came across this web page which tries to explain what dpi is. Your thread title also suggests you want to know about cell size, if so then use the interface IRasterInfo. Duncan ... View more

Well the logic is not that dissimilar. You still need to get a handle on the FeatureClass and use a FeatureCursor to query your dataset by setting the WhereClause. This would return the feature or "row" where you could extract the geometry and zoom to it. But you are opening up a can of worms here.  "Bob Street" is not the same as "bob st." or even "Bob Stret". Can you rely on your users entering the correct text? I can answer that now, no! I'm sure someone could add stuff to this thread about using regularly expressions? ... View more

Are you saying that you want drop-down lists of street names that the user can select? If so you want to be using a COMBOBOX not a TEXTBOX, the logic is: Get a handle on the Map (IMap) Get a handle on the layer (ILayer) Create a point of type IFeaturelayer to your Layer Get the Featureclass of the FeatureLayer Create a FeatureCursor over entire FeatureClass Step through Each Feature reading street name field Add the street name to a list ensuring it's not duplicated, you could use a dictionary for this Write the contents of the dictionary to a COMBOBOX ... View more

Steve, Well not sure whats going on then. Before your organization "neuters" you in their pursuit of "upgrade perfection" I would try the following. If you have access to a 9.3 machine I would use arc catalog to create a file based toolbox (a tbx file) and then use arc catalog to copy your models into it so you get them out of your file geodatabase. Hopefully version 10 then will see them. You should then be able to import them back into your upgraded v10 file geodatabase. Duncan ... View more

Patrick, Gut feeling is that it's probably an Excel thing. Are all you 1000's of worksheets in a consistent  format?  I recently had a problem with Excel and it turned out to be some bizarre Asian characters in a cell that looked perfectly normal. You don't indicate when it bombs out, has it done some processing then blows up or bombs out immediately? If you are using ArcGIS 10 may be you could use an iterator to loop rather than batch up a tool as at least this may give you a hint at what point it bombs out at? Duncan ... View more

v10 should see them. Was the toolbox a stand alone tbx file or a toolbox inside a geodatabase? If it is a tbx file is it actually in the same folder, can you see it in Windows explorer? ... View more

James, I think it's a geoprocessing memory leak issue. I have had all sorts of problems when I do lots of looping in Python using the geoprocessor.  There did not seem to be solution. The only improvement I could make was not to have any of the data in a personal geodatabase but as Shapefiles. This was especially true when doing lots of selections. Ultimately the code would crash as it ran out of memory so I had to run it in batches with me periodically closing down ArcMap. Rediculous really, you would have though they had fixed all that as it's been a continuing problem from 9.3. Duncan ... View more

Alex, May be I'm misunderstanding the models logic but I have a question? I'm assuming inputs Address2 and Select Features:Address are the same layer (may be a point layer)? You do a query selection on this and use this selection to select the parcels. Then you use an iterator which is grouping by recnum. Is recnum unique within the selection? If so then with each iteration you are writing recnum to the selection in the address layer and this I guessing is overwriting the value again? If this model is allowed to run to completion is the value written into Adress the very last recnum? Duncan ... View more

Linda, I had a play with the ITableWindow2 Interface in VBA and found using your code I too could crash ArcMap.  I then played around with the properties and found this combination to work: Public Sub x()     Dim pMXDOC As IMxDocument     Set pMXDOC = ThisDocument     Dim pmap As IMap     Set pmap = pMXDOC.FocusMap     Dim pl As ILayer     Set pl = pmap.Layer(0)     Dim pTW2 As ITableWindow2     Set pTW2 = New TableWindow     With pTW2         Set .Application = Application         Set .Layer = pl         .ShowAliasNamesInColumnHeadings = True         .TableSelectionAction = esriSelectFeatures         .Show True         .ShowSelected = True     End With End Sub I changed the selectionAction  but note I show the TableWindow THEN I show the selected... Duncan ... View more

Robin, You could get into using the GeoProcessor and calling existing tools through the Execute method, this avoids having to know every nuance of ArcObjects. If you want to use the ArcObjects approach then in VBA all you need to do to create a PERSONAL geodatabase is this: Public Sub test()     Dim pWSF As IWorkspaceFactory     Set pWSF = New AccessWorkspaceFactory     Dim pWSN As IWorkspaceName     Set pWSN = pWSF.Create("C:\temp", "pGDB_Test", Nothing, 0) End Sub Duncan ... View more

Jenny, The only thing I spotted with your code is this line: Set EditorEvents = Application.FindExtensionByName("ESRI Object Editor") All the code samples in help use: Dim pID as New UID pID = "esriEditor.Editor" Set m_pEditor = Application.FindExtensionByCLSID(pID) Set EditEvents = m_pEditor Duncan ... View more

You want to use the Interface IStandaloneTableCollection. ... View more

A work around to this problem is this: maintain your data in separate geodatabases or if you are using shapefiles separate folders then you are only ever editing a single workspace. Clunky but this stops you messing up your data. ... View more

Just want to add my "2 cents" to this thread. I have spent the last 2 hours trying to run a spatial join of points to points using the closest match option. Every time it crashed. I tried moving the data to a file geodatabase, to shapefiles, stripped down the fields to the bare minimum, removed domains, you name it I did it. I then asked someone in my office if they could run it to rule out this stupid roaming profile setup we have on our network. Hey presto it worked! AHHH! Anyway the only difference I noticed was that her geoprocessing tool ran as back ground task. I had turned that off along time ago as I think it's pointless and I find the dialog helpful to watch whats going on. So I out of desperation I turned this back on and it worked.  Seriously cheesed off about this... ... View more

It would be great if there was some method on arcpy that purged the memory even if it had a performance hit. If I'm doing large data crunching I'm not going to worry over a few seconds if the data crunching takes several hours.  I was imagining something like: arcpy.ClearMemory Then behind the scenes this would release cursors and objects that are out of scope etc. ... View more