CALCULATING TOTAL AREA OF SERIES OF POLYGONS

[katie1983]

NEED TO CALCULATE TOTAL AREA. HOW DO I GO ABOUT CALCULATING AREA OF
NUMEROUS POLYGONS WITHOUT HAVING TO DO IT MANUALLY?

[Martin A Spiers]

Add (if you don't already have it) a column to contain the area
        Table > maintenance > table structure

Then update this with the area
        Table > update column >




replacing Ground_ID_2 with your table name, TOT_AREA with your column name, and choosing appropriate units.


Yours,

Martin Spiers
Senior Engineer
MWH
Kenburgh House,
Manor Row,
Bradford
BD1 4QU
Tel: 01274 718768
Fax: 01274 718799
email:  martin....@mwhglobal.com

katie1983 <katie...@gmail.com> Sent by: mapi...@googlegroups.com 09/10/2008 16:27 Please respond to mapi...@googlegroups.com

To MapInfo-L <mapi...@googlegroups.com> cc Subject [MI-L] CALCULATING TOTAL AREA OF SERIES OF POLYGONS

NEED TO CALCULATE TOTAL AREA.  HOW DO I GO ABOUT CALCULATING AREA OF
NUMEROUS POLYGONS WITHOUT HAVING TO DO IT MANUALLY?

"Disclaimer: This electronic communication and its attachments may contain confidential, proprietary and/or legally

privileged information which are for the sole use of the intended recipient. If you are not the intended recipient, any use,

distribution, or reproduction of this communication is strictly prohibited and may be unlawful; please contact the sender

and delete this communication. MWH does not warrant or make any representation regarding this transmission whatsoever nor

does it warrant that it is free from viruses or defects, correct or reliable. MWH is not liable for any loss or damage that

occurs as a result of this communication entering your computer network. The views expressed in this message are not

necessarily those of MWH. This communication cannot form a binding agreement unless that is the express intent of the

parties and they are authorized to make such an agreement. MWH reserves all intellectual property rights contained in this

transmission. MWH reserves the right to monitor any electronic communication sent or received by its employees.

This communication may come from a variety of legal entities within or associated with the MWH group. For a full list of

details for these entities please see our website at www.mwhglobal.com. Where business communications relate to the MWH UK

Limited entity, the registered office is Terriers House, 201 Amersham Rd, High Wycombe, HP13 5AJ Tel: 01494 526240 and the

company is registered in England as registration number 01188070. Where business communications relate to the MWH

Constructors Limited entity, the registered office is as above and the company is registered in England as registration number 04635724"

[katie1983]

That gives me the area of each polygon. I am looking for the total
area of all of the polygons added together. Any idea how to do that?



On Oct 9, 4:33 pm, "Martin A Spiers"

<Martin.A.Spi...@uk.mwhglobal.com> wrote:
> Add (if you don't already have it) a column to contain the area
>         Table > maintenance > table structure
>
> Then update this with the area
>         Table > update column >
>

> replacing Ground_ID_2 with your table name, TOT_AREA with your column
> name, and choosing appropriate units.
>
> Yours,
>
> Martin Spiers
> Senior Engineer
> MWH
> Kenburgh House,
> Manor Row,
> Bradford
> BD1 4QU
> Tel: 01274 718768
> Fax: 01274 718799

> email:  martin.a.spi...@mwhglobal.com
>
> katie1983 <katie.oh...@gmail.com>

> Sent by: mapi...@googlegroups.com
> 09/10/2008 16:27
> Please respond to
> mapi...@googlegroups.com
>
> To
> MapInfo-L <mapi...@googlegroups.com>
> cc
>
> Subject
> [MI-L] CALCULATING TOTAL AREA OF SERIES OF POLYGONS
>
> NEED TO CALCULATE TOTAL AREA.  HOW DO I GO ABOUT CALCULATING AREA OF
> NUMEROUS POLYGONS WITHOUT HAVING TO DO IT MANUALLY?
>
> "Disclaimer: This electronic communication and its attachments may contain confidential, proprietary and/or legally
>
> privileged information which are for the sole use of the intended recipient. If you are not the intended recipient, any use,
>
> distribution, or reproduction of this communication is strictly prohibited and may be unlawful; please contact the sender
>
> and delete this communication.  MWH does not warrant or make any representation regarding this transmission whatsoever nor
>
> does it warrant that it is free from viruses or defects, correct or reliable.  MWH is not liable for any loss or damage that
>
> occurs as a result of this communication entering your computer network.  The views expressed in this message are not
>
> necessarily those of MWH. This communication cannot form a binding agreement unless that is the express intent of the
>
> parties and they are authorized to make such an agreement.  MWH reserves all intellectual property rights contained in this
>
> transmission.  MWH reserves the right to monitor any electronic communication sent or received by its employees.
>
> This communication may come from a variety of legal entities within or associated with the MWH group.  For a full list of
>

> details for these entities please see our website atwww.mwhglobal.com.  Where business communications relate to the MWH UK

>
> Limited entity, the registered office is Terriers House, 201 Amersham Rd, High Wycombe, HP13 5AJ Tel: 01494 526240 and the
>
> company is registered in England as registration number 01188070.  Where business communications relate to the MWH
>
> Constructors Limited entity, the registered office is as above and the company is registered in England as registration number 04635724"
>

>  image_gif_part
> 9KViewDownload
>
>  image_gif_part
> 7KViewDownload

[Ben A Greenberg]

Use the Sum function in your select query

sum(area(obj,"SQ MI"))

[Martin A Spiers]

If you have the individual areas in a column, then
Query > Calculate statistics

If not, you can get this directly


Select Sum(Area(obj, "hectare")) from <yourtable> into Selection
Browse * From Selection

gives the total area of all the objects in <yourtable>

Yours,

Martin Spiers
Senior Engineer
MWH
Kenburgh House,
Manor Row,
Bradford
BD1 4QU
Tel: 01274 718768
Fax: 01274 718799

email:  martin....@mwhglobal.com

katie1983 <katie...@gmail.com> Sent by: mapi...@googlegroups.com 09/10/2008 16:42 Please respond to mapi...@googlegroups.com

To MapInfo-L <mapi...@googlegroups.com> cc Subject [MI-L] Re: CALCULATING TOTAL AREA OF SERIES OF POLYGONS

details for these entities please see our website at www.mwhglobal.com. Where business communications relate to the MWH UK

[katie1983]

Thanks for that, have my total area now all I need to do is calculate
the %area.

I'm guessing it's the total area divided by the individual area of
each polygon.

So I have a the total area 13,728,376 m.

I have a column that I need to update called %area.

Is there a way to automatically update this column?

On Oct 9, 4:47 pm, "Martin A Spiers"

<Martin.A.Spi...@uk.mwhglobal.com> wrote:
> If you have the individual areas in a column, then
> Query > Calculate statistics
>
> If not, you can get this directly
>

> Select Sum(Area(obj, "hectare")) from <yourtable> into Selection
> Browse * From Selection
>
> gives the total area of all the objects in <yourtable>
>
> Yours,
>
> Martin Spiers
> Senior Engineer
> MWH
> Kenburgh House,
> Manor Row,
> Bradford
> BD1 4QU
> Tel: 01274 718768
> Fax: 01274 718799

> 15KViewDownload- Hide quoted text -
>
> - Show quoted text -