Latest Contributions by DarrenWiens2

I'm pretty sure this is what you want: Make Query Table. You need a many-to-one join between your map layer (many) and data driven pages (one), based on Global ID being equal. ... View more

I don't know of a way to apply a Page Definition to a field other than the Page Name, but you should be able to join the DDP Layer to the Map Layer table to access the matching Page Names. Example: DDP Layer: Field1 (PageName), Field2 (Global ID) Map Layer: Field1 (Map Reference), Field2(Global ID) JOIN -> Map Layer: Map.Field1 (Map Reference), Map.Field2 (Global ID), DDP.Field2 (Global ID), DDP.Field1 (PageName) ... View more

Buffer should work only on selected points, if there is a selection (I'm using ArcGIS 10 - not sure if this is true in 9.3 and less). I don't see any way to avoid creating an intermediate layer, though (I just read this post, which describes the in-memory workspace, which may be ideal for your intermediates). Also, I'd suggest creating a model (or script) to run your workflow since you'll be going through several steps. You can always build the deletion of your intermediate files into the model if you want to avoid accumulating files. ... View more

It works for me, so my suggestion is to post your SQL statement and a subset of your data. ... View more

Just FYI, the Spatial Join tool (but not spatial join from the layer's right-click menu) will produce the same result as Intersect, using the points as the target layer, polygons as the join features, and the JOIN_ONE_TO_MANY option. ... View more

As far as I know, there is no way to use LIKE on a date field in ArcGIS (correct me if I'm wrong). You can use BETWEEN though. This example will return all dates in 2005 (actually you probably need to adjust the final time to get records from the last day). This works for me, you may have to adjust the date format. "DateField" BETWEEN date '2005-01-01 00:00:00' and date '2005-12-31 00:00:00' ... View more

I guess I might be thinking about your data wrong, but this is what I'm picturing: a polygon shapefile or feature class (vector, not raster), with one attribute column containing the land classification each polygon belongs to, and another column with the area of each polygon. In the Summary Statistics tool, choose the area column as the statistics field, SUM as the statistic, and land classification as the case field. This will sum the area of each land classification. ... View more

You can use the Summary Statistics tool (statistics field = area, case field = land class). Or, in the attribute table, right-click the land class column, choose summarize. Expand the area field and choose SUM. ... View more

If your river is a line (not polygon), you can choose LEFT or RIGHT under Side Type in the Buffer tool.. ... View more

SQUAREMETERS works for me the way you have it - but I'm using ArcGIS 10. Sorry to ask this, but you're not trying to calculate the area for a line feature class, are you? ... View more

If you have ArcInfo licensing, you can use the Feature to Line tool to make border lines, then Near to find the distances. ... View more

Doesn't the centroid give you the point object that you're looking for, which I assume you can access the coordinates by centroid.x, centroid.y? ... View more

If you want to access the actual cell values in the columns, use a cursor (like a SearchCursor). ... View more

The intersect tool takes multiple feature classes in the form of ["shapefile1.shp", "shapefile2.shp"] (quotes, brackets, and comma delimited). I'd try that. ... View more

1.) Since tree.find('.//abstract').text is a string, I think you should be able to use the usual replace method. (totally untested) tree.find('.//abstract').text = tree.find('.//abstract').text.replace("%SITEDESCR%", thesubvalue)  2.) I think you want to use the getchildren() method to create a list of the subelements under the <place> tag. Then, you can reference the children by the new index number. (again, untested - you can find lots of great Elementtree methods here.) ... View more