Latest Contributions by DaleHoneycutt

Shapefiles do not support null values.  See Geoprocessing considerations for shapefile outputs.  You need to export to a geodatabase table. ... View more

I'd start with the Make XY Event Layer tool to create a point feature class of you X & Y data.  Then use the Buffer tool to create your circles, using the point layer created by Make XY Event Layer ... View more

Perhaps the Eliminate tool? ... View more

Assuming your feature class is called "MyPolys".  Run the Intersect tool with MyPolys as the input.  The output feature class (default name would be MyPolys_Intersect) will be the polygons that overlap each other. If you want to remove these overlaps from MyPolys, run the Erase tool with MyPolys as input and MyPolys_Intersect as the Erase Features. ... View more

Let's assume your feature class is called "MyPolys". Run the Intersect tool.  You'll have only one input feature class, MyPolys.  This will create a new feature class with the default name of "MyPolys_Intersect". Open the attribute table of MyPolys_Intersect and sort it on the FID_MyPolys field (the original object id of MyPolys).  You'll see that there are multiple entries for each original MyPolys polygons. To calculate percentage overlap, you'll want to add a field containing the original area of the MyPolys polygon.  Use the Join Field tool for this.  Your input table is MyPolys_Intersect, the Input Join Field is FID_MyPolys, the join table is MyPolys, and the Output join field is OBJECTID.  For fields to join, choose Shape_area. After Join Field executes, you'll have a shape_area field and a shape_area_1 field. (If you're viewing the table in arcmap, turn field aliases off... both these fields have an alias of "shape_area". You're ready finish your calculation of percent overlap.  Use Add Field to add a new field called "Percent_overlap".  Use Calculate Field to calculate Percent_overlap = shape_area / shape_area_1. If you want more information, such as the IDs of the overlapped polygons, run Intersect, but enter MyPolys twice.  This will overlay MyPolys on top of itself.  The output table table will list each unique combination of overlaps.  You'll want to ignore any entry that lists itself.  That is, select for FID_MyPolys <> FID_MyPolys_1 ... View more

The Append or Merge tool ought to do the trick of appending the rows output from Summary Statistics.  As far as adding the iteration number, I would think that the rows would be added in iteration order -- that is, the object id of the row (in the merged table) would be the same as the iteration number (You'll need to experiment).  Otherwise, you could add a field to the output of Summary Statistics and use Calculate Field to calculate it to the iteration number.  You'd use variable substitution for this, as in '%n%'.  See A quick tour of using in-line variable substitution for more info ... View more

Curtis: yep, good point ... View more

Have a look at this blog article. Although it doesn't specifically address your problem, it shows how to deal with null values and multiple fields. ... View more

Use the Copy Features geoprocessing tool.  It's in the Data Management toolbox > Features toolset. ... View more

The ability to create script tools ("embed them in a toolbox") has been around since 9.0.  If you're on 9.3, you can start with this help topic : An overview of creating script tools ... View more

Are you running the script as a stand-alone script or as a script tool?  In order to use layers, you need a script tool that's running 'inside' arcmap.  See An overview of creating script tools for an explanation of script tools vs. stand-alone scripts. Other than the above, I don't know why it's not working. ... View more

Sorry: use a forward slash instead of a backward slash, as in "Infrastructure/Streets" ... View more

If your group layer name is "Infrastructure" and a layer w/in that group layer is "Streets", then you can find the group in Python with "Infrastructure\Streets" ... View more

Spatial Join honors the output coordinate system geoprocessing environment setting.  See Output Coordinate System and A quick tour of geoprocessing environments ... View more

There's a entry on the model and script tool gallery that outputs an html file report from an input feature class or table.  You could use this in your model to output an html file (or excel spreadsheet).  The file won't open automatically... you'll have to go to the results window and right-click the output and select Open. ... View more