In class exercises

Part I - Slides

1. Go over examples in slides

CREATE TABLE citytest1 (
cid varchar(3) PRIMARY KEY,
name text,
geom geometry(point,4269));

INSERT INTO citytest1
VALUES ('NYC', 'New York', ST_GeomFromText('POINT(-74.0059 40.7127)',4269)),
('WDC', 'Washington', ST_GeomFromText('POINT(-77.0164 38.9047)',4269));

CREATE TABLE citytest2 (
cid varchar(3) PRIMARY KEY,
name text,
lon numeric(9,6),
lat numerc(9,6),
geom geometry(point,4269));

INSERT INTO citytest2
VALUES ('NYC', 'New York', -74.0059, 40.7127),
('WDC', 'Washington', -77.0164, 38.9047);

UPDATE citytest2
SET geom=ST_SetSRID(ST_Point(lon,lat),4269);

Part II - Boundless Tutorial

1. 1-2, 4-6 for getting started
2. 7-8 are SQL review
3. 9-10 Geometry

Part III - QGIS Overview

1. Adding files
2. Connecting to a database
3. Adding layers
4. Zooming and selecting
5. Viewing attributes
6. Selecting properties (symbols, labels, joins)
7. DB Manager
8. Spatial View