Hi,
Thought to just comment on the "don't know how you'd join all three =
tables within a single SQL".
Joining 3 tables in a single SQL proves to be powerful, time saving and =
does not clutter your disk with unecessary temporary files. The way to =
do this requires a syntax rule which I will
Hi Jacqui,
I don't know how you'd join all three tables within a single SQL, but
the following query should help calculating the overlap without doing
the cookie-cutter thing. You'll just have to run it twice - once for
hard veg and once for soft.
set area units "hectare"
select
Dear List
I have two tables, each consisting of several thousand polygons - one of
"hard" intertidal vegetation and the other of "soft" intertidal vegetation
and sediments. I have another table of bird count zones. I would like to
know if it is possible to use SQL to find out the precise hecta