or do it all in a single SQL Statement:
Select FENCELINE.ID, VEGETATION.ID, CartesianObjectLen(FENCELINE.OBJ, "m")
"TOTAL_LEN", CartesianObjectLen(Overlap(VEGATATION.OBJ, FENCELINE.OBJ), "m")
"OVERLAP_LEN"
Where VEGATATION.OBJ Intersects FENCELINE.OBJ
This should work. If you add the percentage to the statement, I'm not sure
whether it still will work, but it would then look like this
Select FENCELINE.ID, VEGETATION.ID, CartesianObjectLen(FENCELINE.OBJ, "m")
"TOTAL_LEN", CartesianObjectLen(Overlap(VEGATATION.OBJ, FENCELINE.OBJ), "m")
"OVERLAP_LEN"
(CartesianObjectLen(Overlap(VEGATATION.OBJ, FENCELINE.OBJ), "m") /
CartesianObjectLen(FENCELINE.OBJ, "m") * 100) "PERCENTAGE"
Where VEGATATION.OBJ Intersects FENCELINE.OBJ
HTH,
Peter Horsb�ll M�ller
GIS Developer
Geographical Information & IT
COWI A/S
Odensevej 95
DK-5260 Odense S.
Denmark
Tel +45 6311 4900
Direct +45 6311 4908
Mob +45 5156 1045
Fax +45 6311 4949
E-mail [EMAIL PROTECTED]
http://www.cowi.dk/gis
-----Original Message-----
From: Stephen Chan [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 17, 2005 7:17 AM
To: Peter Hatton
Cc: [email protected]; [EMAIL PROTECTED]
Subject: Re: MI-L PERCENTAGE QUERY
Peter,
What you can do is save a copy of your line as a different file.
Open that file and place it in the map with your vegetation polygons
Make the new layer (file) editable and "Objects>Set Target"
Select all your Vegetation Boundaries and then "Objects>Split"
This will split your polyline up into the separate vegetation boundaries
Create a new column in the new line table to store distance and % of total
dist.
Perform a "Table>Update Column" using the Expr: ObjectLen(Obj) for the fence
distance in each vegetation polygon
Find out the total distance by double clicking on the original line and use
it for the Expr below
Perform a "Table>Update Column" using the Expr: ObjectLen(Obj) / TotalDist
for the fence percentage distance in each vegetation polygon
I hope this is of help
- Stephen Chan
On Thu, 17 Mar 2005 17:01:35 +1000, Peter Hatton <[EMAIL PROTECTED]> wrote:
>
> Hi all,
> can someone help me with the following
> .............................
> I have a
> polyline (
> fenceline) that intersects a number of vegetation polygons of differing
> vegetation types. I need to be able to determine the length of the polyline
> (fenceline) in each vegetation polygon, as a percentageof the total
> fenceline length. Hoping someone may be able to help me.
>
> Many thanks
> ............... regards
> Peter
>
> Peter HATTON
> GIS Officer
> Greater Taree City Council
> PO Box 482 TAREE 2430
> Ph 02 6592 5227
> Fax 02 6592 5380
> E-mail [EMAIL PROTECTED]
>
> This e-mail has been scanned for viruses by MCI's Internet Managed
> Scanning Services - powered by MessageLabs. For further information
> visit http://www.mci.com
>
> ---------------------------------------------------------------------
> List hosting provided by Directions Magazine | www.directionsmag.com |
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail:
> [EMAIL PROTECTED]
> Message number: 15702
>
>
---------------------------------------------------------------------
List hosting provided by Directions Magazine | www.directionsmag.com | To
unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Message number: 15703
---------------------------------------------------------------------
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Message number: 15704
