Latest Contributions by DuncanHornby

‎01-31-2011

John, I use PyScripter as my Python development environment, it's very good. OK first you need to create your script and set it up as shown below: # Import system modules import sys, string, os, arcgisscripting # Create the Geoprocessor object gp = arcgisscripting.create(9.3) # Local variables...Try to get the iteration number that the model is on. IterationNum = gp.GetParameterAsText(0) # Do stuff... gp.addmessage("it = " + IterationNum) Now add your script to the tool box and ensure that it has a single parameter of type text. Create your model and set your model to run X times. Drag your script which is now a tool onto your model and expose the parameter and set it's value to %n%. Your script will then be able to use it but be aware that a string is passed to the script. Duncan

‎01-31-2011

Michael, If your dataset is a shapefile try setting this: arcpy.AddField_management(FootprintFC, "GeoAngle", "DOUBLE", "", "", "", "", "NULLABLE", "NON_REQUIRED", "") to arcpy.AddField_management(FootprintFC, "GeoAngle", "DOUBLE", "", "", "", "", "", "", "") Duncan

‎01-31-2011

Andrew, The raster you are "joining" the parcel data to, will it not double count all your parcel data? I'm think you'll have raster cells a quarter of a mile away as well as raster cells directly underneath your parcel so that parcel is counted for as many cells under or a quarter of a mile away? Anyway are these parcels non-overlapping (I know nothing about tax parcels)? If so would the Focal Statistics tool achieve what you want? You would rasterize your polygon layer with the value being the count field and then do a Focal statistic on it? The help file has lots of information about the different parameters of the tool. Just an idea, may be not what you want? Duncan

‎01-31-2011

The Feature Selection Iterator has been a long time coming for model builder and I use it regularly. Whilst it helps simplify models (we don't need to use Python for looping) I have noticed that it's performance can take a hit when there is a large selection. I run models that crunch large datasets and I often find that ArcGIS simply runs out of memory. A solution to this is to select a subset of my data and crunch in batches. OK it means I have to keep an eye on everything and restart the processing but it gets the job done. If I pre-select a lot of data I notice the Iterator takes much longer to run it's make featurelayer routine. So as a real work example I have a File Geodatabase point layer with 12,000 points each needs to be processed individually. If I chuck it at my model with no selection it eventually runs out of memory. If I select say 500 points then the iterator's make feature layer step takes about 9 seconds before it moves onto the next model process. If I select say 2000 points (this would not crash ArcGIS) it takes about 45 seconds to make feature layer.

‎01-28-2011

Change this line: pDatasetName.Name = strInputFileName to pDatasetName.Name = "Sheet1$" This assumes you have accepted the default sheet name. Duncan

‎01-26-2011

Is your Exel document formatted correctly? First row are headers Headers without spaces or illegal charaters Your XY fields are formatted as numbers No null data Duncan

‎01-26-2011

Fabrizio, You cannot create a raster in an InMemory workspace. If you look at the VBA Help file and search InMemoryWorkspaceFactory CoClass is states what it cannot support, rasters being one of them. Duncan

‎01-25-2011

You are almost there. The iterator creates an output variable in your model called value, you would have set that to your ID. You can use that in an inline substitution. Read help if you don't know what that is. Anyway I would then do: Add an ID field to summary table Use calculate to pass point id to this new field using inline substitution Append summary table to an existing empty table with exact same schema (same fields) Let the model run then join table to original point layer, et voia!

‎01-25-2011

Mono, I'm not understanding your logic. Are you saying you have a point layer (the facilities) then for each point you want to create a 1Km buffer then use that buffer to select polygons that have their centroids in the buffer? If so then the model needs rearranging. Start with the iterator, it's input is the point layer. This iterator then cycles through all the points 1 at time. That individual point feeds into a buffer tool the output being a single buffer, this then feeds into your select by location tool and the selected polygons feed into your summary tool. Duncan

‎01-25-2011

J, Looking at the Help it says that you need to provide an index position for you output parameter which you are not supplying as shown in your sample code. Duncan

‎01-24-2011

J, Are you aware of the AddFieldDelimiters method on the Geoprocessor? Duncan

‎01-24-2011

Robin, There is a tool in your ArcToolbox called Linear Direction Mean in the Spatial Statistics toolset. You could try running this tool setting the case field to a unique ID for each polyline (such as the ObjectID). Not tried it so I could be sending you off in the wrong direction (no pun intended). Duncan

‎01-24-2011

Sean, Why don't you use the summary statistics table but the output goes to an In_Memory table. You collate your information from the table display as you wish and then delete the In_Memory workspace and if you set the environment of the geoprocessor to not add to display they should never see it. Duncan

‎01-24-2011

Mono, You do not say which version of ArcGIS you are using. You need to tell us this so we can help you. If you are using ArcGIS 10 then there is the new and very useful Feature Selection iterator, this will help with you model logic. Information about this can be found here. Duncan

‎01-20-2011

Steve, What you are asking is not possible. The iterators work with FeatureClasses in their workspace. But to visualise a selection you are working with a FeatureLayer. If you look at the input requires of the SelectByAttribute tool that takes a FeatureLayer and not a FeatureClass. A tool to iterate over FeatureLayers does not exist. Duncan

Online Status	Offline
Date Last Visited	Wednesday

My Ideas

Latest Contributions by DuncanHornby

Re: making an if-then script for modelbuilder that is based on the model iteration nu

Re: Calculate Grid convergence error

Re: Spatial Joining Polygons to Raster Cells

Improve the performance of model builder feature selection iterator

Re: XYEventSourceName used for creating Excel to shapefile

Re: XYEventSourceName used for creating Excel to shapefile

Re: RasterConversionOpClass ToRasterDataset into Memory

Re: Model for sumarizing polygon stats near a facility

Re: Model for sumarizing polygon stats near a facility

Re: Python Output Parameter as String

Re: Python Output Parameter as String

Re: Calculate angle of each line in a polyline shapefile

Re: Display Statistics for Selected Features

Re: Model for sumarizing polygon stats near a facility

Re: Model Builder - Iterate Feature Classes

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