Latest Contributions by DuncanHornby

‎10-17-2011

Josh What you are asking is fairly easy, you could even knock up a form quickly in VBA. But you should consider something else if stream lining data entry (and thus quality) is your prime concern, you should be using Domains. One thing that will improve your data entry is to have your dataset as a FeatureClass in a GeoDatabase. You can then set domains on the beetle and release fields. You cannot do this for Shapefiles. This would control exactly what goes into those fields. Little drop downs appear on the Table in those fields. Duncan

‎10-17-2011

All, I can't find the interface that allows me to change the default geodatabase of an existing MXD, does it even exist? I found this thread but the Interface seems to be related to changing the default geodatabase at the Application level not an existing MXD. Our network structure forces us to have a roaming profile with my documents there. This has serious detrimental affects on the performance of ArcMap and any geo-processing tools (very slow) but we found out that by setting the MXD's default database to one on the C:\ drive the tools speed up significantly. So I was looking for a way to batch process the update of this map document property but I am unable to find are hook into it! Any ideas? Duncan

‎10-17-2011

Tony, The problem is your FeatureClassToFeatureClass tool. In your code you create a string called expression. First thing to note is that this line is wrong expression = "ACCOUNT", "OwnerName", "Address", "City" , "State", "ZipCode" it is creating a list object. I am assuming your intention is to limit the fields to the final dataset to these? This would be the field mapping parameter not the where clause parameter. expression = "ACCOUNT,Ownername,Address" would create a single string. Secondly the parameter order of FeatureClassToFeatureClass is incorrect. If you read the help on this tool it is where clause then field mapping. As you want to limit the fields you need to specify the where clause which I assume is nothing so a simple "" should suffice. So before you do anything fire up help and study the parameter order and their specifications to get the code working. Duncan

‎10-17-2011

James, It would help us to help you if you post up your model. Duncan

‎10-17-2011

Frank, I don't program in Java, may be others do but I think it would help if you post up your code so the Java gurus can have a look at it? Duncan

‎10-10-2011

It looks like you are almost there. All you need to do is create the attribute fields you wish to populate in your output dataset. You do this by using the AddField tool and do that after you have called the createfeatureclass tool. You already have the code to extract data from your input file so you simply extract your attributes and write these to your new output row which you are calling feat. If you can't work out how to do that then upload a sample of your input file so people can see what fields you are wanting to pass to your output dataset. Duncan

‎10-10-2011

Have you tried contacting the Author of this script, they would have the best chance in correcting the error? You can contact them from the Arcscript page.

‎10-10-2011

Search help for "RemoveLayer" it's a method in the arcpy mapping module.

‎10-10-2011

Alex, Below is some VBA code that I think achieves what you are asking. Interestingly it does not seem to adjust the setting in the dataframe > Properties > General > Units(display) drop down. Duncan Public Sub test() Dim pMXDoc As IMxDocument Set pMXDoc = ThisDocument Dim pLatLonFormat As ILatLonFormat2 Set pLatLonFormat = New LatLonFormat With pLatLonFormat .ShowDirections = True .ShowZeroMinutes = True .ShowZeroSeconds = True End With Dim pReportUnitFormat2 As IReportUnitFormat2 Set pReportUnitFormat2 = pMXDoc pReportUnitFormat2.CoordinateReadoutUnits = esriDecimalDegrees Set pReportUnitFormat2.CoordinateReadoutLatLonFormat = pLatLonFormat End Sub

‎10-03-2011

I would like to see a simple addition to the context menu in the Table of Contents. If you click on the little button List by Source in the TOC you see your layers organised by their source location. Some of my layers use Domains on fields to control the entry of data. Domains are stored at the GeoDatabase level. The only way to view these are to go the GeoDatabase in the Catalog window and enter the properties window of the GeoDatabase. You cannot get to this properties window from the TOC when in List by Source mode. So I would like to see a new option when one right clicks on the geodatabase in the TOC (when in List by Source mode) to open location in the Catalog Window at which point I can drill down into the properties and edit my Domain. At the moment I have to manually open Catalog and navigate to the appropriate location where the GeoDatabase is and most of my MXD's are linking to multipe GeoDatabases across multiple drives.

‎09-15-2011

Bruce, I've found the whole AXF root personally a bit flakey and have in the past lost data with it corrupting itself and refusing to check data back in. One silver lining is that ArcPad studio can now export the contents to a shapefile. So if your checking in is bombing out for what ever reason you can potentially recover the data from the AXF file by exporting it to a Shapefile. This will presumably negate any useful checking in/out you did. To export to shapefile open the AXF database in ArcStudio, expand the FeatureLayers and right click on the Layer and choose export... I think this has been a very useful and life saving addition to ArcStudio. Duncan

‎09-15-2011

I've just been working on a project developing a custom data capture project on a Trimble YUMA. My only problem with it was the 32Gb solid state Hard drive was not enough space, after Windows 7 and all the other software (Arcpad etc.) I was left with "only" 20Gb of space. I needed to supply the field surveyor with a huge amount of raster imagery for much of the Scottish coastline. The solution was to put that all on a 400GB USB drive and the surveyor has to bite the bullet and deal with the faff of manually deleting and copying folders when they moved to their next survey block.

‎09-15-2011

Open Arctoolbox window, right click on the root ArcToolbox and select environments... Duncan

‎09-14-2011

Hi Steve, I've looked at your code and there appears to be some nutty situation where you are looping through every 5th vertex of each polygon and repeating the loop. I think this is where your code is going amiss. So I've cleaned up the code for you and have reposted it. You also create objects then never use them... I've removed them too! You placed code that only needs to called once inside the loop so these have been moved out. As I don't have your data I was unable to test this code. Duncan

‎09-12-2011

All, I had been thinking of a work around all weekend to this problem so I came into the office with a way of resolving this problem, fired up help and was just doing some casual searching when I spotted AddItemsFromTable. So during design time we have a property of the ComboBox called listtable but during runtime it's called AddItemsFromTable. So my apologies to all for asking this question as I'm not used to objects having different names for the same property... Code is below. Duncan Sub PopulateCombobox ' Get file path of APM file then use this to create a path to dBase file Dim fp fp = MAP.FilePath Dim i i = instrrev(fp,"\") fp = left(fp,i) & "SpeciesList.dbf" ' Get control and refresh Dim p Set p = ThisEvent.Object Dim c Set c = p.Controls Dim sc Set sc = c.Item("cmbxSpecies") sc.Clear sc.AddItemsFromTable fp,"Species","Species" End Sub

Online Status	Offline
Date Last Visited	Monday

My Ideas

Latest Contributions by DuncanHornby

Re: Editing form (Beginners Questions of using VB.NET)

How to programatically change the default geodatabase of an MXD

Re: Help with Feature Class To Feature Class

Re: Model Builder %value% add layer to map

Re: Extract raster cells by polygon using Java ArcObjects

Re: Create a line with attributes based on origin and destination points with Python

Re: Huff Model

Re: Remove a Layer usinng Python

Re: Set map units or override units to DMS

Open dataset location in the Catalog Window

Re: Problems checking in ArcPad data

Re: ArcPad 10 with Trimble YUMA

Re: Default Raster Mask for Raster Calculator

Re: Slow code ... can anyone help me make it faster?

Re: How to programatically refresh a combobox listtable?

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?

ArcGIS Arcade

Coordinate Reference Systems