Latest Contributions by DuncanHornby

Justin, As I understand it a Feature is nothing more than a row in a table where one of the fields just happens to hold a geometry rather than all fields being non-spatial data. So I don't see why you can't have a row (feature) where all values are set to NULL, this should still be a valid row in your table (featureclass). Anybody out there do correct me if I am wrong? So you dataset is a "simple" shapefile and when you issue a delete is sets everything to NULL but does does not remove the row from the table? Maybe you could post up your code for us to see? Duncan ... View more

Mele, I've never used it but have a go at using the Interface IDatasetEdit? Duncan ... View more

You could try to run the MXD through MXD Doctor? I suggest you back up the file before you do that just in case it blitzes it. It's a tool under the Desktop Tools group if you are using version 10. Duncan ... View more

Justin, I'm surprised the pFeature.Delete did not work which suggests to me the source of your problem is something else, what format is your data store as? If it's ArcSDE then maybe some weird locking is going on?  I would try you code on a small sample of say a shapefile? Duncan ... View more

The lack of an index in the Help is driving me nuts, I cannot understand their reasoning behind removing it. Their logic assumes that you have exisiting knowledge of what ESRI names a topic/tool/processing step so you just type it in. It also assumes that we are all cuturally the same and use the same combinations of words to mean the same thing. I rarely use free text search I almost always do my searching throught the index as once I know a location I can drill down to that part of the Help I need. ... View more

May be a bit late in this discussion but I was playing around with creating in_memory workspaces in VBA (ArcGIS 9.3). Here is my code. Public Sub InMemoryExample() ' Description: Sample code showing how an in memory table can be created ' Create Workspacefactory Dim pWorkSpaceFactory As IWorkspaceFactory2 Set pWorkSpaceFactory = New InMemoryWorkspaceFactory ' Create Workspace Dim pWorkspaceName As IWorkspaceName2 Set pWorkspaceName = pWorkSpaceFactory.Create("", "MyInMemoryWorkspace", Nothing, 0) ' Get a handle on Name Dim pName As IName Set pName = pWorkspaceName ' Get a handle on FeatureWorkspace Dim pFeatureWorkspace As IFeatureWorkspace Set pFeatureWorkspace = pName.Open ' Now create a fields object and add some fields to it ' Create Fields object and set the number of fields Dim pFields As IFields Set pFields = New Fields Dim pFieldsEdit As IFieldsEdit Set pFieldsEdit = pFields pFieldsEdit.FieldCount = 2 ' Create objectID field Dim pField As IField Set pField = New Field Dim pFieldEdit As IFieldEdit Set pFieldEdit = pField With pFieldEdit .Name = "OBJECTID" .Type = esriFieldTypeOID End With Set pFieldsEdit.Field(0) = pField ' Create Type field Set pField = New Field Set pFieldEdit = pField With pFieldEdit .Editable = True .Name = "VegType" .Type = esriFieldTypeString .Length = 4 .AliasName = "Vegetation Type Code" End With Set pFieldsEdit.Field(1) = pField ' Create Table Dim pTable As ITable Set pTable = pFeatureWorkspace.CreateTable("MyInMemTable", pFields, Nothing, Nothing, "") ' Create a sample row and add data Dim pRow As IRow Set pRow = pTable.CreateRow With pRow .Value(1) = "WOOD" .Store End With ' Add table to map document Dim pMXD As IMxDocument Set pMXD = ThisDocument Dim pMap As IMap Set pMap = pMXD.FocusMap Dim pStandAloneTableCollection As IStandaloneTableCollection Set pStandAloneTableCollection = pMap Dim pStandAloneTable As IStandaloneTable Set pStandAloneTable = New StandaloneTable Set pStandAloneTable.Table = pTable pStandAloneTableCollection.AddStandaloneTable pStandAloneTable pMXD.UpdateContents End Sub Duncan ... View more

Ryan, You could convert your raster to a point dataset and then do a spatial join setting join type to JOIN_ONE_TO_MANY. You will create a featureclass with the polyline duplicated for every point that joins to it, then do you summary stats grouped by the polyline ID. Duncan ... View more

Anna, You want to assign each node in the network it's "valency". I'm assuming you've used productivity suit to import the data into a file geodatabase? Do a spatial join using the geoprocessing tool of roadlinks (RdLk) intersecting nodes (RdNd) setting join operation to JOIN_ONE_TO_MANY This creates a dataset with a row for each polyline intersecting a node You can then use the Frequency tool or summary statistics tool to count TARGET_FID, this will count the number of times a node was selected. This gives you a table where for each OBJECTID (refered to as TARGET_FID) has a count. Duncan ... View more

You could make a button in ArcCatalog and then attach the code in this example to achieve this... ... View more

Bill, I think you are using the wrong tool. You want to be using the Select tool found in Analysis Tools > Extract toolbox. Duncan ... View more

Bart, Sounds like you have found a bug? Alternatively (although not tested by me) is you could create the event layer using the arcpy.MakeXYEventLayer_management tool from the table as you know what the table is called and never have the need to "enter" the MXD? Just an idea... Duncan ... View more

Here is a sample of how to set up the IGeoProcessor, in this example they are calling a custom tool but it could equally be a standard esri tool. You just need to be careful in the order you add the tools parameters to the array object, this must be the same as how you would fill in the tool. Duncan ... View more

Craig, The lines of code 187 & 188 you are suggesting is python code which is not VB. I have 9.3 and the CreateObject function on line 187 works fine for me so this makes me wonder if ESRI have done something behind the scenes in 9.3.1. Can someone clarify this? ESRI want us to use the new way of creating a GeoProcessor object, the IGeoProcessor. You can still call the standard tools using this new interface you just do it differently. I find it actually easier to use, as the intellisense works. Do a search on the old forum for IGeoProcessor and you'll see lots of examples of how to construct it and invoke tools with it. Duncan ... View more