Extensions and Tools Developed by DPR's Permit Mapping Developers Group

• Calculate Acreage Extension, (download self-extracting zip file: calcacre1_avx.zip, zipped size = 3K)--modified from ESRI's original script calcacre.ave by Rosemary Neal of DPR's Pest Management and Licensing Branch. Allows the user to calculate the area, perimeter, and acreage of polygons. The conversion factor for calculating acreages is set to 0.000022956 (Sq. Ft. to acres).

• Polygon Acreage Extension, (download self-extracting zip file: ply_area3_avx.zip, zipped size = 4K)--developed by Rosemary Neal of DPR's Pesticide Enforcement Branch. Calculates the areas of polygons in acres. The extension adds a tool to the View GUI. When the tool is activated the user clicks on the chosen polygon and the acreage is calculated and reported in the status bar at the bottom of the ArcView window. If the Part B RMPP table is joined to the crop boundary shapefile, the tool will also display the acreage reported on the permit.

• Add Lat./Long. Extension (download self-extracting zip file: addll1_avx.zip, zipped size = 4K)--developed by Rosemary Neal of DPR's Pesticide Enforcement Branch. Adds the latitude and longitude coordinates of point and polygon shapefiles to their attribute tables. Polygon centroids are calculated for polygon shapes. Shapefile source data can be in any projection/coordinate system. Output units are in decimal degrees.

• Polygon-to-Point Extension (download self-extracting zip file: p2p1_avx.zip, zipped size = 3K)--developed by Rosemary Neal of DPR's Pesticide Enforcement Branch. Adds a new menu choice entitled "Convert polygon to point..." to the "Theme "menu in a view. The extension converts the selected features of a polygon theme into a point theme of the polygon centroids and associated attributes. If no features are selected the whole shapefile will be converted. The polygon shapefile must have a field that contains a unique identifier (e.g. pmtsiteid). If no such field is present, unique record numbers can be created using ArcView's sample script addrecno.ave.

• Point Data Entry Extension (download self-extracting zip file: pde1b_avx.zip, zipped size = 4K)--developed by Rosemary Neal of DPR's Pesticide Enforcement Branch for the Yolo CAC. The extension creates point representations of permitted sites, with user supplied attributes for permit and siteid.

• Point-to-Polygon Extension (download self-extracting zip file: pt2py3_avx.zip, zipped size = 5K)--developed by Rosemary Neal of DPR's Pesticide Enforcement Branch for the Yolo CAC. Performs a spatial join of point attributes to polygon features, creating a new polygon shapefile that contains the point shapefile's attributes. This operation is not available using ArcView's Geoprocessing Extension. The polygon shapefile must have a field containing a unique identifier. If no such field is present, unique record numbers can be created using ArcView's sample script addrecno.ave.

• Reporting Features Within a Buffer Zone Extension, January, 2001 (download self-extracting zip file: sbg2a.avx.zip, zipped size = 4K)--developed by Rosemary Neal of DPR's Pest Management and Licensing Branch. Allows users to generate features within a specified buffer zone and generate a Quick Report. The extension adds two buttons to the View GUI. The "Buffer and Select" button allows the user to specify a buffering distance (in feet, yards, or miles) of a selected feature. Features of the same theme that fall within the buffer zone are then selected. The "Quick Report" button allows the user to generate a quick report of the selected features without having to add the Crystal Reports Extension.

• Sorting Tables by Multiple Columns Extension (download self-extracting zip file: sort1.avx.zip, zipped size = 4K)--developed by Mark Cederholm piersen@primenet.com. Sorts a table document by one or more columns. Each column may be sorted in ascending or descending order. If the sorted table is not to be exported to a new file, the underlying VTab must be editable because the script adds a temporary sort field.

• Search Extension (3.x) (download self-extracting zip file: search4_avx.zip, zipped size = 5K)--developed by Rosemary Neal of DPR's Pest Management and Licensing Branch for ArcView 3.x. The extension allows the user to search for Permitted Field Borders, Assessor Parcels, and/or geocoded Streets (US Streets with Zone) through a simple interface. Once located, ArcView will zoom to the selected feature. ReadMe file included.

• KGIS_NOI Project/Extension (3.x) (download self-extracting zip file: kgis_noi_1.zip, zipped size = 286K)--developed by Rosemary Neal of DPR's Pest Management and Licensing Branch for ArcView 3.x. This version of the KGIS Notice of Intent extension has been developed from original code developed by the Office of the Kern County Agricultural Commissioner. The extension adds a spatial component to processing Notices of Intent. This software is designed to rapidly locate field boundaries and perform a spatial analysis of each new site for proximity to sensitive areas. This software works in conjunction with either the Restricted Materials Permit Program (RMPP) or the Restricted Materials Management System (RMMS). KGIS_NOI provides the spatial component, analysis, and link to the tabular data. Permit data are accessed via Open Database Connectivity (ODBC) software, and pulled into the GIS for NOI processing. Critical resources are required and discussed in the documentation. A Power Point presenation is included.

• Build Image Catalog (8.x) Build Image Catalog (download self-extracting zip file: BuildImCat.zip, zipped size = 15K) developed by Trent Hare, USGS, is a DLL plug-in which will build an Image Catalog for any type of image that ArcMap supports. Images are loaded and unloaded in ArcMap depending on the extent, thus minimizing redraw time. The readme file has been modified by Rosemary Neal to include step-by-step user instructions.

• Merge and Append Shapefiles (3.x) Merge and Append Shapefile Extension, (download self-extracting zip file: mrgappd1_avx.zip, zipped size = 5K)--developed by Rosemary Neal of DPR's Pest Management and Licensing Branch. Allows the user to merge two shapefiles and retain the attributes from both. The extension is a combination of two Scripts, Table.Append and View.MergeThemesClick.

Extensions and Tools Available from ESRI's ArcScripts Website

Tools

• Duplicate Record Tagger (download self-extracting zip file: dup.zip, zipped size = 4K)--developed by Mark Cedarholm searches for duplicate records in a Table document based on user specified field(s). The Duplicate Record Tagger selects the duplicate records in a table, which then can either be removed by deletion, or the selected records can be switched to create a new shapefile/table without the duplicates.

• View.Select All and Switch Selection--Ruth Henry Bowers of Magnolia Geographic Services, Inc., Houston, Texas, has provided users with scripts for Select All (download self-extracting zip file: viewselectall_ave.zip, zipped size = 1K) and Switch Selection (download self-extracting zip file: viewswitchsel_ave.zip, zipped size = 1K) buttons in the view GUI, and saved us all a task on our "to do" list.

• Smart Identify Tool (download self-extracting zip file: smartid_ave.zip, zipped size = 1K)--developed by an ArcView user can be used to replace the existing script attached to the Apply Property of the Identify Tool in the View GUI, resulting in a smarter tool which actually reports the linked data. The Smart Identify Tool allows the user to click on features of a shapefile, displaying the linked records in the identify box if a linkage between the active shapefile and another table exists.

• Display Latitude and Longitude Tool (download self-extracting zip file: displaypoint.zip, zipped size = 3K)--developed by Troy Fontenot from CRA Services, Baton Rouge, LA, calculates the Lat./Long. coordinates of a point in a view no matter which projection your data is in. When using the tool the user is prompted to click on the location in the view and then select the appropriate projection information from the subsequent dialog box. The calculated Lat./Long. coordinates are placed on the view as a graphic.

• ArcView Projector Extension--Information regarding problems experienced when reprojecting shapefiles from the Teale Albers Projection using the ArcView extension may be obtained from the California Spatial Information Library.

• Copy Features Extension (download self-extracting zip file: copyfeat_avx.zip, zipped size = 4K)--developed by Stephen Lead (ESRI Australia), allows users to copy features from one theme to another, provided they are the same shape type.

• Copy/Move/Rotate Extension (download self-extracting zip file: copy_move_rotate.zip, zipped size = 26K)--developed by personnel at the City of Scottsdale, Arizona, enables users to copy, move and rotate selected shapes within a theme using either specified absolute or relative coordinates, or by clicking and dragging the mouse. A word of warning, changes are made to the existing shapefile and there is no UNDO. Recommendation -Work On a Copy of your Shapefile!

• Extensive Selection Tools Extension (download self-extracting zip file: zselected.zip, zipped size = 46K)--developed by Howie Sternberg of the State of Connecticut, Department of Environmental Protection, contains a suite of over twenty useful selection tools. Features can be selected in active themes by drawing points, rectangles, polygons, circles, lines and polylines, buffered rectangles, polygons, circles, lines and polylines; and rectangles and polygons of user specified dimensions.

• NADCON Extension (download self-extracting zip file: nadcon.zip, zipped size = 265K)--developed by Mark Cederholm (plp@pierssen.com/), the NADCON extension is an Avenue implementation of NOAA's NADCON program; it transforms lat/long shapefiles from NAD27 to NAD83and vice versa. Data must be in decimal degrees. Read the documentation!

• MapTips Extension (download self-extracting zip file: zmaptips.zip, zipped size = 59K)--developed by Howie Sternberg of the State of Connecticut, Department of Environmental Protection, displays the theme label that moves with the mouse pointer in a view. The extension adds a tool menu to the View GUI consisting of four tools, which (1 & 2) map tip single or multiple features of the active theme with the label field, (3) map tip two or more active themes with label fields, and (4) label all active themes with their label field when you click.