ArcGIS Desktop part 18 (getting information about objects 2: sql and selections) Video Lecture | Way to Learning GIS and ArcGIS - Data & Analytics

welcome one to the exercise number eight
B which contains selection processes or
selecting features by attribute in the
prior video we have learned how to
select features visually by choosing
locations in our case and in this
tutorial on this data viewer in this
project by selecting polygons that are
located here or parcels that are located
on the border or on a hole on the
crossing in the ending in this video
lecture to use SQL statements to select
four distinct features not only by one
attribute like the location or the
status Adams also on a manifold of
attributes so first of all we would like
to open the attribute tables and you can
see that there are a lot of features or
a lot of um attributes are available you
have shallow show only selected words
you would like to see all records so in
this case now records are shown and well
let's say client will come to you and
ask for some a house with three bedrooms
price less than 160 thousands maybe 150
thousands well let's say it has to be on
sale for sure so how to do that so in
this table view you will have a from so
there's a table there is a table and we
will adjust the visibility back and what
you can do now is you can select battery
so there are the stable options and you
would like to select Petra boots and
here you have the interface for your SQL
statements so you would like to create a
new selection because we don't have any
selected features in our case and there
are the attributes which are available
so begin by the F ID the land use the
zoning etc so first of all of course the
status of the parcel should be on sale
so what you will do is you would you
will select status and will first hand
get the unique values to that attribute
so click on get unique values now you
have no for not for sale and yes for
sale so what we will do is we will just
say double click status status should be
the same like yes well that is we can
apply that now every feature is selected
which is on sale of course the current
scheme has already shown that so they
graphs
well where is it table of contents and
there it is well that is not only the
one and only attribute we would like to
search for but there's also the question
of how to get more features no no
whatever done so once again window table
of contents stick with that there
open attribute table now we are in the
correct one so let's go back to select
by attributes we have we have used the
status to be on sale like all same as he
yes and you would like to have only
three or apartments or houses with three
bedrooms so and the bedroom number
should be let's say get unique the list
so there are a house with two three four
and five should be the same as three and
of course the price is important so the
sale price should be well now we are not
constrained to with the unique values
but the same price should be less than
100 so let's say one hundred sixty eight
thousand me blank over here you will
click on apply
and now there's only this the circuit
features available in our selection so
now we have I have just add a few not
only show all but show only selected
records and we can compare the sale
price sale price is below our value the
bedrooms number is of course the three
and the status is on sale so there is
our SQL statement which we have used and
you can play around with that
it's very useful for data analysis thank
you very much for watching