ArcGIS Desktop part 30 (analyzing feature relationships 9: field calculator) Video Lecture | Way to Learning GIS and ArcGIS - Data & Analytics

welcome everyone to this new exercise in
this video I would like to show you on
first hand hadees did definition query
as you can see here on the screen so we
are we are now at the exercise number
12c of the book getting to know ArcGIS
tum and not only the definition query
but also a way to recalculate fields in
your attribute table using the field
calculator therefore we will start with
the exercise 12c and as you can see we
have here the final output out of the
last video which is something like the
Union out of every input we have created
and we can easily address areas where we
can harvest trees that are part of these
lease they are defined by a special
label you can easily define that not by
clicking labeling itself which will show
that default label I don't know what
does this at the moment now it's a lease
IT so by using the I think it's the cut
area let's fan out standard no cut area
no cut area it is you can easily see
that there are areas where you are
allowed to cut trees these are defined
by W minus 1 and each area where you
have the value because in then 0 is part
of either buffer zone around around our
streams or rivers or it is part of an
area around bird's nest we are not
allowed to harvest trees so what we will
use is we will use this information in a
definition query so go to definition
query Y we can also check with
Boldin so these are available inputs
here are some elements you can use for
your for your query so our query and we
will use the fi denote cut area and as
we have seen in the map these all we
will only use values which are the same
as minus 1 so use that and take this one
ok so what you can see now is or are
just areas where you are allowed to cut
trees or to harvest trees as you can see
here we have this circle are areas where
the way the birds nests where and we
have here the river sections we are not
allowed to cut them so um what else can
I do now um well first of all we have
some problems due to the Union feature
of function because there was something
like a stand value or value per meter
I think attribute available here value
per meter which is only copied out of
the original stands value or a stand
feature so this isn't or we cannot use
that anymore so we have to do
recalculate this one using shape area
and the value per meter so let's do that
right click on value per meter you would
like to create or you would like to
recalculate this one so value per meter
and now we need to recover it stand
value of course sorry for that so stand
when you filled calculator you will use
the value per meter multiplied by the
shape area and divide that by 1 million
to keep your value in millions so this
is then this stand
well you normally if you are not in an
editing session you will get some
problem here
but as you can see the calculation was
done very quickly and we have
recalculated the stand values we can
check that by opening the old stands
layer right click on it and check for
the attribute table there you have the
stand value or we have to choose or
select only these IDs that are the same
as F okay
that was a problem click on apply' say
close and choose on the choose only show
selected so we have the object object ID
1093 we have a standard of five point
three eight million and we will now use
this object ID which is the stand ID
here that was probably something like
1093
once again use select attributes and
this was the stand ID
it was the same as 109 3-0 of everything
is selected so that was not that easy
we won't check once again maybe we will
sit for 1055 once again select by
attributes stand ID is the same as 1055
click on the ply and you have here the
stand value of 0.5 87 and in the new
step on the newsstand values a little
bit lower
it is 0.4 8 million so this particular
cell here has a lower standard you as it
was before
let's check for geometry there is a
geometry as you can see and we will now
use this new or the old stands layer
above it and as you can see here we have
a little cutoff on the left-hand side of
that of that polygon which is now not
available for cutting trees and so the
stand value has decreased here you can
easily use the final version here for
that and right-clicking and saying
export this feature no export selected
features maybe not only this polygon but
maybe follow them and yeah that's it for
the moment thank you very much for
watching stay tuned for exercise number
13