Latest Contributions by DuncanHornby

‎05-03-2013

Daniel, Below is a screen shot of a single event offset to the right in ArcGIS 10.1. If you negate the offset figure it will draw on the left. Duncan

‎05-03-2013

Jim's solution is good but it does not work with all data formats (i.e. Shapefiles) see this thread. Maybe try something like this: pQueryFilterDefinition.PostfixClause = "ORDER BY Town" using IQueryFilterDefinition2 interface.

‎04-29-2013

Xavier, It might help people if you upload a before and after image of what you are attempting?

‎04-29-2013

I'm not aware of any ability to lock a layer internally to stop a user from editing the properties of a Layer.

‎04-11-2013

I like this idea I can see myself using such functionality. The problem is how do you define "empty"? If there was a string field in a GeoDatabase you could have <Null> entries or they could all be set as "". But <Null> is not supported in Shapefiles. What about other storage formats? A numeric field field in a shapefile must have a number, add a new numeric field to a shapefile and they are all set to zero. But what if you are using zero as a meaningful value say in a binary flag field? I like the idea of dropping "empty" fields but more thought needs to go into defining what empty means.

‎04-05-2013

Oyle, I'm just thinking off the top of my head here. You have a DTM and 2 points, your FROM point and your TO point both at the same elevation. You could do this: Create a FeatureClass containing a single polyline created by you connecting the 2 points Call the Polyline to Raster GeoProcessing tool to create a raster where your line is 1 and background is nodata Call the Extract by Mask and extract out the elevation pixels under your mask Run the Extract by attribute geoprocessing tool extracting pixels >= your FROM point elevation. Optionally convert the raster back into polylines if required. If you used the geo processing tool Points To Line you could actually achieve all this is modelbuilder in a matter of minutes without the need to write any code...

‎04-05-2013

Li, If you are looking to return the distance between geometries then have a look at the IProximityOperator Interface.

‎04-04-2013

I agree it would be very useful for ArcCatalog to report what version an mxd is. This could be in the properties or a mandatory field in the metadata. There are many users still using older versions of ArcGIS which need to be supported. But this idea will only help people in the future as ESRI won't be going back to 9.1 and adding new functionality.

‎03-25-2013

I know this is 3 years too late 😄 but I was just trying to do the same thing in VB .net. Anyway here is my code developed in VB .net for ArcGIS 10.1 hope it helps others. Duncan Sub ReloadTableCache(ByRef pTable As ITable) ' QI to IDataset so we can get Table name Dim pDataset As IDataset pDataset = DirectCast(pTable, IDataset) ' Get a handle on open tables Dim pTableWindow As ITableWindow3 pTableWindow = New TableWindowClass Dim pSet As ISet = Nothing pTableWindow.FindOpenTableWindows(pSet) If pSet Is Nothing Then Exit Sub ' No tables open, bail out ' Search open tables and reload cache if table if found pSet.Reset() Dim pStandaloneTable As IStandaloneTable Dim pTW As ITableWindow3 pTW = DirectCast(pSet.Next, ITableWindow3) Do While Not pTW Is Nothing pStandaloneTable = pTW.StandaloneTable If pStandaloneTable.Name = pDataset.Name Then ' Matching table found, reload cache Dim pTableControl As ITableControl pTableControl = pTW.TableControl pTableControl.RemoveAndReloadCache() Exit Do End If pTW = DirectCast(pSet.Next, ITableWindow3) Loop End Sub

‎03-23-2013

I'm guessing that you need a forward slash between your database path and the feature-class name?

‎03-23-2013

Chris, I note you specified version 9.3. You can program your task either in VBA or Python. If you wanted to write in Python (you might want to to this if you intend to use the code in newer versions of ArcGIS) then forget about the command line console and get yourself pyscripter, its free and really good. In your example you have 10 * 100 combinations which through brute force is probably quite quick. But if your real datasets have thousands of points then you'll have millions of combinations. I guess the smarter way to do it is use a select by location tool with a maximum distance so you are only ever processing a subset. You could run the entire script outside arcgis in pyscripter or wire it all up to a script tool interface and expose your code as geo-processing tool in arctoolbox. Duncan

‎03-23-2013

Bruce, Just thinking out aloud here. So on the second run of the code the intersect tool does not report any error and it does not create the in_memory dataset? Are the layers changing, or are they the same layers but with a different selection on them? Also does one of the layers have the calcacres field? Duncan

‎03-15-2013

All, FYI I resolved the problem, it appears to be with the way I was deleting the dBase file. Originally I was deleting the table using the following code: My.Computer.FileSystem.DeleteFile(sFullPath) I changed this to the more verbose method using ArcObjects: Dim pWorkspaceFactory As IWorkspaceFactory pWorkspaceFactory = New ShapefileWorkspaceFactoryClass Dim pFeatureWorkspace As IFeatureWorkspace pFeatureWorkspace = pWorkspaceFactory.OpenFromFile(sPath, 0) pTable = pFeatureWorkspace.OpenTable(Me.TextBox1.Text) Dim pDataset As IDataset pDataset = DirectCast(pTable, IDataset) If pDataset.CanDelete Then ' Delete and clean up pDataset.Delete() pTable = Nothing pTable = Nothing pFeatureWorkspace = Nothing pWorkspaceFactory = Nothing End If This has resolved my problem.

‎03-14-2013

Just an idea but you could just call the Identity GeoProcessing Tool? This does assume you and your users have Arc/Info (Advanced) license level.

‎03-14-2013

All, I have developed an AddIn for ArcMap 10.1 using VB .net 2010. My tool writes data it creates to a dBase file which gets loaded into the TOC. During processing the tool can create up to 25 fields. Sometimes a user will need to rebuild this table with its initial set of 3 fields (by selecting a button on toolbar). When the user clicks on the create table button my code searches for the table in the TOC and removes it with the following code: pStandAloneTableCollection.RemoveStandaloneTable(pStandAloneTable) pMXDocument.UpdateContents() The code then continues by deleting the existing dBase file and then recreates with the default set of 3 fields. This all works fine. The table is loaded back into the TOC with the following code: pStandAloneTable = New StandaloneTableClass pStandAloneTable.Table = pTable pStandAloneTable.Name = Me.TextBox1.Text pStandAloneTableCollection.AddStandaloneTable(pStandAloneTable) pMXDocument.UpdateContents() If I then go to the Table in ArcMap and open it I see all the previous fields (with zero values) and not an attribute table with just 3 fields. It's as if ArcMap has held onto the schema of the table it had removed, any ideas on how to force a refresh? Duncan

Online Status	Offline
Date Last Visited	2 weeks ago

My Ideas

Latest Contributions by DuncanHornby

Re: Please help with offset linear referencing events.. it is very urgent!

Re: How to sort items in combobox?

Re: Line simplification

Re: Preventing users from changing Definition Query

Re: Delete empty fields in Attribute Table

Re: Fly collision detection

Re: code for distance between points

Re: MXD Version Reporter

Re: Update View of Attribute Table in ArcMap (Reload Cache)

Re: Python Script Set Dataset permission Error

Re: beginner command/scripting/python help, 9.3

Re: Geoprocessing Tool Failing in VBA Code

It was how I was deleting the table.

Re: Intersecting Featurelayer with geometry

ArcMap retains fields of removed Table.

Re: GeoPackage (GPKG) versus File Geodatabase (GDB...

Re: GeoPackage (GPKG) versus File Geodatabase (GDB...

Re: Dissolve polygons only within a given distance...

Re: How do I remove purple border around chart?

Re: How do I remove purple border around chart?

Coordinate Reference Systems

ArcGIS Arcade