Course Content - MapInfo SQL for Data Analysis

Exercise 1

Introduce SQL concepts of “Where Condition”, “Order By” and Area calculation

Exercise 2

Introduce “Group By” and “Select Columns”
Aliasing column names in output

Exercise 3

Introduce “exclusion” concepts with <> operand and “Not Like” operand

Exercise 4

Spatial query with two tables
Observe effects of “Group By” versus double “Group By” queries
Generate a complex query utilizing both spatial and attribute data
Discuss precedence

Exercise 5

Table > Update Column exercise utilizing SQL queries and temporary tables

Exercise 6

Examine various string functions and their application to SQL
Select and Update Table commands

Exercise 7

Complete an exercise using a one-to-many join (Table A – Table B – Table C)
Note how “joins” must be structured and possible errors

Exercise 8

Generate a buffer of a set radius and select spatial data points contained within that buffer that meet a certain criteria (selected by SQL)

Exercise 9

Investigate object centroids and select all data falling within a polygon
Determine area of polygons within that boundary via Area function

Exercise 10

Register a raster image against vector data
Discuss accuracy issues and possible remedies

Exercise 11

Create a database of sample locations in Excel, import the table into MapInfo, create points, and manually digitize a few more points to the table

Exercise 12

Take assay data and join it to the table created in Exercise 11
Convert character data to numerical data with Val() function
Discuss table join and update issues; illustrate solutions
Determine and flag samples that do not have associated assays.