Boolean Operators and Venn Diagrams Michael Halleen References - - PDF document

▶

Apr 09, 2023 27 likes •68 views

10/6/2009 Boolean Operators and Venn Diagrams Michael Halleen References ESRI Help, Wikipedia, Getting To Know ArcGIS, Introduction to Geographic Information Systems Boolean Logic It's a 0, or It' s a 1 Yes or No On or Off 1

SLIDE 1

10/6/2009 1

Boolean Operators and Venn Diagrams

Michael Halleen References ESRI Help, Wikipedia, Getting To Know ArcGIS,

Introduction to Geographic Information Systems

Boolean Logic It's a 0, or It' s a 1 Yes or No On or Off

SLIDE 2

10/6/2009 2

Boolean Logic is Suited to Computers Because Computers Use a 0 or 1 To Process Information. SQL, an Expression to Query Database's Is a Boolean Expression Basic SQL Query A Boolean Expression Has Operands and Operators Parcel.Id > 500 OperandOperatorOperand

SLIDE 3

10/6/2009 3

Boolean Operators =, >, <, =>, =<, <> Boolean Connectors NOT, AND, OR, XOR

Totl.Value >= 125000 AND Totl.Value <= 200000 AND Lot.Sq.Ft. > 10000 AND LotSq < 20000 AND LotId. NOT 500

SLIDE 4

10/6/2009 4

Venn Diagram A B C Venn Diagrams Show the Possible Relationships Between Sets “A” was Houses on 20000 sq. ft. Lots “B” was Houses less than $100,000 “C” was Houses greater than $100,000 “A,B,C”