Finding the area of a shape

The Area function is used to calculate the area of a given geography.

To use the Area function:

  • Open a browse on the schema with the geography you want to find the area for by right clicking on it and selecting Open Browse

  • Right click and select Add Column

  • Type AREA( into the Expressions box

  • Double click on the Master table and select the Boundary column then click on Paste

  • Finally, finish the expression with ,3)

Note: 3=Miles. If you want Kilometers, type 1, and if you want Meters, type 2

  • The expression should look something like this:

AREA(MASTER.BOUNDARY, 3)

PreviousUsing a Correlation TokenNextFinding the longitude and latitude of a point

Last updated