HOME Free ArcGIS tools HOME Free functions of ET GeoWizards Free tools of ET GeoTools
 Easy Calculate 10how to perform field calculations without the field calculator in ArcGIS 10Source code in .NET included

Easy Calculate 5.0

 What's New Calculate Edit Field Draw Examples

EasyCalculate is a set of expressions (currently 110) for the ArcGIS field calculator. The expressions can be loaded in the Field Calculator and when executed calculate some spatial characteristics of the features, edit the shapes, add records to a target layer, draw graphics etc.

How to use:

1. Unzip the file in a directory
2. Right click on a field of a table ==> Calculate Values
3. In the Field Calculator dialog: click the Load button and select the appropriate CAL file
Some of the expressions require small changes in the code (adjustment of tolerances or field names). Places that require changes are clearly indicated in the code. The expressions that need
 some adjustment are indicated with in the Notes column of the table below
4. Make the changes in the code ( if needed).
5. Click OK to execute.

How to use the expressions programmatically:

See EasyCalculate Plus

New in EasyCalculate 5.0

 1. 15 new expressions added - 29 July 2004 2. All expressions are compatible with ArcGIS 9.x. In order to accommodate ArcGIS 8.x & 9.x some of the expressions have versions. The version of the expressions are indicated in the name. If the name ends with "9x" it will run only in ArcGIS 9.0 and above. If the name ends with "8x" it will run only in ArcGIS 8.x. If the name does not have "9x" or "8x" suffix, the expression will run on ArcGIS 8.x & 9.x 3. Some typo errors fixed. The new expressions  are indicated with in the Applies To column of the table below

Description of EasyCalculate functions

 Pl = Polyline Pg = Polygon Mp = Multipoint Pl_M = PolylineM Pl_Z = PolylineZ Tbl -  table

Notes:

1. The result values for the functions that return coordinates, length and area will be in the projection of the View Frame
2. For best results the fields should be from the types indicated in the table above
3. The expressions with indicated Field Type of SHAPE should be used only on the SHAPE field.  Caution: The changes are applied directly on the original data set. If the expressions are applied out of an Editing session the changes will be irreversible. If you however want to use these or similar expression out of an Editing session, make sure to create a backup of the original data set.
4. The calculation will be performed only on the selected records. If there is no selection - values for all the records will be calculated
• polyline_Get_X_MiddlePoint.cal, polyline_Get_X_MiddlePoint.cal and polylineGet_Angle.cal can be easily changed to return the characteristics for any other point of the polylines. Only the values of the dDistance and/or bAsRatio variables have to be changed in the Pre-Logic box of the Field Calculator.
 dDistance bAsRatio Description Default 0.5 True Middle Point (angle at Middle Point) Example 1 0.3 True Point (angle at Point) located on a distance 30% of the total length of the polyline from the start point along the polyline Example 2 10 False Point (angle at Point) on the polyline 10 map units from the start point of the polyline along the polyline
• shape_CountAllParts.cal and polygon_CountTrueParts.cal can be used together to find the polygons with holes or islands in a polygon data set. Use them on two different fields and then select all the records for which the results from the first expression are not equal to the results from the second one. The selected polygons will contain an island polygon or will have a hole.
• polygon_Thickness.cal can be used to identify the skinny polygons in a polygon data set. For polygons with close to circular shape the results will be close to 1. The thinner the polygons are, the smaller the ratio will be. Using this expression one can identify the sliver polygons which are normally very thin.
• field_DMS2DD.cal - A DMS string in virtually any format is accepted. Any character delimiter except "." (used as a decimal point) can be used. The letters "E", "W", "N" & "S" are used to determine the location of the Lat/Long coordinate. They can be used as delimiters, but the last occurrence of the letter in the DMS string will define the sign of the coordinate. The expression checks for validity of the DD coordinate - all the valid Longitudes should be between -180.00 and 180 degrees. If you want to check for Latitude validity you have to replace these values to -90.00 to 90 degrees. The records with string values that the expression could not standardize will be assigned a value of 0.00.
 Input string Standardized string Decimal Degrees 37 45 23 S 37 45 23 S -37.7564 37º45'23"N 37 45 23 N 37.7564 123456 12 34 56 12.5822 1234567 123 45 67 123.769 W?37?45?23 37 45 23 W -37.7564 37-23.123-s 37 23.123 0 s -37.3854

For any comments and enquiries contact: webmaster@ian-ko.com
Esri and all Esri products mentioned are trademarks of Environmental Systems Research Institute, Inc.