ArcGIS Desktop part 20 (getting information about objects 4: joins between tables) Video Lecture | Way to Learning GIS and ArcGIS - Data & Analytics

welcome everyone to exercise number 9 a
in this exercise I would like to show
you how to combine informations about on
one hand a spatial phone like a
shapefile and on the other hand
something like a table maybe you will
find that in an old database or you have
created it prior to a pro to your own
spatial project so the question is how
to make a join of these both tables and
what I'm saying about these both tables
you need to be aware that each shapefile
like in our exes example here in number
9 a there is a shapefile called pits 75
you will find something like an
attribute table and this attribute table
is consists or consists out of first of
all a shape information like well we
have about 606 points in this chafer but
also information like these attributes
you have seen before in the prior prior
exercises so we have textual information
we have numeric information and what is
quite important for shape fold in every
case is something like an identifier so
um a value or a number which just
belongs to this feature on this object
normally this is this is done
automatically by ArcGIS by adjusting
this F ID feature identifier I also
called like that number which is just as
you can see a straight natural number
process from 1 2 up to 605 but there's a
second unique identifying that shaffer
this is called ID number and I would
like to say to you if you're a if you
will create a shape file which you can
learn of
in a few videos um always use maybe an
own identifier you will you can create
it for yourself it's not that hard to do
that as you can imagine but use that one
so what we will do now we will um or in
the book it is sad that we are in the
position of some kind of yeah analyst
then these are Pitts and these pets are
more there as you can see here the
status is abundant so we need to monitor
them and each pit has some kind of
problem you the the the user or the the
owner of the pit has to has to react on
so um we have this one this information
we don't have any possibility to see
whether it is an easy to deal with pit
or it is some kind of well maybe there's
something really strange going on that
one so what we will do is we will create
or we will open a data table where we
have this information already in so
let's go on to this at button just wait
a second
there we are well this is not the
correct folder well we have to stay here
ArcGIS toriel exercise is number nine a
it is we will go into data folder and
let's say we have the Pitts
shape on our remedial reactions well I
think this is a table we are looking for
so we will choose that button and what
what has changed now prior we have been
into this table of content view so we
can only see the visual information like
the shape falls pits navigatable of
waterways and Louisiana parishes
let me just check something if we have
some bookmarks at work we have a
bookmark south on Louisiana so this is
the southern part of Louisiana what we
will do is we will go into that list for
my source view and there the our table
comes up so we can have a look in the
table and as you can see we have a lot
of we have a lot more information
available for each side or for each pit
as we had prior and as you can see here
the item ID number as a title suggests
is the same identifier as we have in the
pits so we can go there here as well
well unfortunately it will open in the
new and new tab here so we can switch
between them and as you can see they are
Gen ID number should be or ya should be
the same so as we have said we would
like to join these both tables and for
this joint there are several
possibilities first of all the easiest
way to join the tables you have the same
amount of elements on the left side like
in the remedial actions table as in the
pits table and each ID number is also
present in the other type other than
other table just by the amount of one so
just one element in each that means you
have a one to one join and this is not
the case in our as you can see we have
the original source is the chef up at
seventy-five we have about six hundred
and six objects and their own remedial
actions we only have 472 objects so this
could be a little bit a problem
otherwise if you if you can find each
element in that table in our shapefile
we know we don't have a problem or we
don't really have a problem because
if you cannot find that number like this
one here like this in our pizza you can
vote you cannot have a chain you cannot
have a link between them but yeah what
is the point you have here more elements
like in the middle actions
so for each every element you cannot
find in information the remedial actions
table you will only get no values so not
on the these values are initial or not
filled or how you might may call them
so how to do that by hand well it's very
easy you could just click on or all
right do a right click on pit 75 it
doesn't it doesn't matter if you're in
this view list by source only lists by
drawing order sewer mode so right click
and choose where is it selection no
joins and relates of course so there
there's a possibility to do to it just
join where and to make it relate so
often in my in my seminars it was ask
okay well what's the difference between
them well it isn't it isn't probably SAP
properly sad and the in the book I would
say that the job will stick to the book
in that case say if you have notice not
so many elements that will fit to one
element in the source the source in our
case is a shapefile you should do a join
if there are more than just one or two
elements in the target table like
removal actions here and then you should
go with the relate so we will first on
first hand we will go with a join as you
can see you remove joins there are no
joints available so you'll click on join
and now we are present all now we are
looking on the dialogue join lets you
apparent additional data to this layers
attribute table so you can for example
symbolize the layout features using this
data so what is the purpose of it we
would like to use information in the
other table
to be shown on our map due to the fact
that the shape has some geometric
information about that and for about
that feature so what we will do will
choose a field in this layer that he the
John will be based on so what is it in
this layer means that you able regarding
to the pit 75 so we will have the ID
number choose a table to join to this
land we will use the only table which is
available in or the only real table
which is available remedial actions and
we will go with the ID number as well we
will also keep all records and we will
not stick with the keep only matching
record so that means a record and the
target table doesn't have a match and
drawn the record is removed from the
resulting target table so that means
that you will throw out some information
out of the window and you don't want to
do that because it would like to see
whether there are may be actions plans
or action plans needed in the case of
our remove and in our we have some kind
of monitoring project or whatever you
might want to call it so we will keep
all records and well we'll go with it ok
button and there is a warning something
like that you would like to create an
index index is always fine because it
increases the process speed in your
daily work so we will use use more
choice and do not show this dialog again
which is not that normal to go with a
with a with this button but we will do
that in our case now so well that's it
as you can see there has nothing change
what a surprise but let's have a look in
the attribute table here so what you can
see now is not the attribute table is
much brighter broader broad yeah wider
like more elements can be shown so you
have you old informations parish
and content and so on and then you have
here the information from the old fall
same ID number which means you will have
the the same is the same information and
what is quite interesting is that you
will find also the or original ID which
means that this is original at the
original F ID in the table so that's
quite important or quite interesting if
you would like to keep an eye on your
own you or join so what else shall we do
now
we should go with a good representation
of the action plans so know once again
go to the attribute table
what ID number X's land access water
contaminated in whatever well there is
something called clean up so what needs
to be done and we will use this
information as some autumn make it
visually accessible to the viewer of map
so we'll also go to layout view well is
there a layer we available although that
looks I won't say it looks nice but it's
fine for the moment we'll also go to the
properties of the feature if you're not
used to that and just look in the prior
videos and we will go to symbology
you'll say we have some categories and
the category in our case is the cleanup
we will add all values and you can see
wrong we will choose the color scheme no
we cannot see anything as you can see
you'll once again go back we will choose
another color M original color ramp and
we will create or we will adjust the
value on D
the pointer size let's see well this is
just one so we will go with all pointers
to do sighs this is fine so much points
by value in this field
oh well let's stick with that maybe
change your singles I cannot believe
that we have to arrange each point for
itself no no that's not that good so
what we will do is we will just create a
map where each point is drawn regularly
except the point where they have
something like vacuum and remove to a
permitted facility on-site biological
treatment so which is something like the
worst case or and we will also create
repair or removal of structure to get an
over overview so we will create new
color scheme same for just always same
color well let's change this color to
another slightly different so what you
can see now is that we have some kind of
clustering here in the southeastern part
along the Mississippi where remove
repair or removal of structure is needed
as an action yet all the other pits are
quite fine
well there's one still one problem where
we don't have a match so what we will
use is we will use the same size of the
pointer what we will stick with the
yellow color scheme as you can see this
is there's certain clustering here in
the South on part of Louisiana so this
is it we have now created join between
these both informations and you can also
remove that join by using remove joins
with a table owned I will do that what I
would like you to do is to export the
whole as a new safe or safer
so you can export the whole shape the
whole old shape hull with a new table as
a new shapefile due to the fact if you
would like to recreate that joint or you
would like to add this old Schaeffer to
a new project or something
the join will not be recreated as well
so using that export data to create a
new shapefile and you will go with all
the information which is currently
available in your shape or in your new
shapefile so as you can see well you
will know you know how to do that so
this is the case thank you very much for
watching enjoy our next video some to
relate and see you goodbye