CSC220 Schedule 2010

Back to Main Page

---

Main Project

• Main Page for the Project

Weekly Schedule

Week	Topics	Reading
Week 1 9/08	Wednesday 9/08 Introduction and syllabus Overview of the project Some pictures Google Maps example (Generated by walkmeter) What we'll use this semester Sources of information Linux shells what is a shell (see wikipedia)? different choices: Bourne shell, C shell, Z shell, Korn shell, Bash (Bourne Again) shell The Bash shell default shell for Mac, GNU operation system, and many Linux variants has been ported to MS-DOS configuration files: .bash_profile, .bashrc important commands: ls rm cat cd pwd grep, -i, -l, -v, -A, -B wc chmod chown head & tail tail -f history watch	Unix Shells (on wikipedia) Bash Beginners Guide All about redirection with Bash
Week 2 9/13	Mon 9/13 Lab 1: playing with bash pipes and redirection, stdout, stderr sort Wed 9/15 How to change your login shell automatically cut cat programming, bash scripts variables for loops Lab 2 An example script illustrating features we will not cover in class, but that are important and useful. Another example illustrating how to test file system-parameters. Lab #1 (Mon) Lab #2 (Wed) Homework #1 and Solution Programs	A good reference: The GNU Bash manual
Week 3 9/20	Monday 9/20 Crontab Example (Cron Syntax) php architecture of a Web Server Apache public_html chmod a+r, chmod a+rx phpinfo.php: simple test fibonacci1.php: generates fibonacci numbers fibonacci2.php: fibonacci numbers in a list fibonacci3.php: fibonacci numbers in a table fibonacci4.php: fibonacci numbers in a while loop fibonacci5.php: only the even fibonaccis. Wednesday 9/22 phpinfo() test using Php as interpreter (on hadoop110) Arrays in php: sample programs Lab 3 Lab #3 on Php Homework #2 and Solution Programs	THE MAIN PHP REFERENCE Definition of a Web Server Definition of a Web Browser List of TCP and UDP Ports The TCP Protocol the UDP Protocol The main reference on HTML forms Difference between Post and Get methods References on how to write HTML forms
Week 4 9/27	Monday 9/27 HTML Forms form1.htm processform1.php echoform.php (a simple php file to test forms) form2.htm : a form displaying many different input options. Lab 4 Php functions dealing with arrays and strings Testing tricks and warnings. Example: the strpos() function Creating Php functions Exercise: processing KML coordinates. Lab #4 on Forms Mini assignment for Wed 9/29: create an organizational chart for the project. What needs to happen? What tools will be needed? How/where is the data stored? How is the data observed? Homework #3 and Solution programs	Php tutorials: a good place from where to start investigating Php array-operations Php string-operations
Week 5 10/04	Monday 10/04 Project overview. See pictures here. Below, a video created by Jon for the class. Thanks Jon! Wednesday 10/06 Robustness form that reloads themselves: example, link Another example Catching email messages programmatically. Python Example Notes on DBMS Homework #4 and Solutions	Php htmlspecialchars() function Introduction to databases and MySql on Google.code MySql Tutorial on dev.mysql.com Chapter 1 (required reading) and Chapter 2 of Garcia-Molina, Ullman and Widom's Database Systems book. Instamapper: discovery of the week, found by Jon.
Week 6 10/11	Monday Fall Break Wednesday Lab 5 Food for thought... Lab 5 on MySQL Homework 5 and Solutions	MySQL Tutorial: an e-book with some good information. Check it out.
Week 7 10/18	Monday 10/18 Something to play with: MySql Workbench, a GUI for MySql Anatomy of a query <=== good reading! More notes on DBMS Exercises Wednesday Difference between joins (inner and outer) Views Indexes Feedback on Homework #4 Thursday -- Take-home Midterm Exam, available here!	Anatomy of a SQL query Joins Joining tables Indexes Creating an Index How MySQL uses Indexes B-Trees (used for indexes) Views Creating a View Using a View
Week 8 10/25	Monday 10/25 A word about the Solution for Homework 5 Indexes B-Trees PRIMARY INDEX INDEX UNIQUE FULL TEXT Lab 6 Wednesday 10/27 Php + MySql mysql_connect() mysql_select_db() mysql_query() mysql_fetch_array() mysql_close() mysqlSkel.php A simple php program that interacts with a mysql database. Warning: this program is not robust! formSkel.php A self-reloading form that interacts with a mysql database. Warning: this code is not robust! Lab 7 Lab 6 Lab 7 Homework 6 and a Solution Programs
Week 9 11/01	Monday 11/01 Mysql Injection Examples http://unixwiz.net/techtips/sql-injection.html mysql_real_escape_string to the rescue! Final Project: Discussion Uploading/Downloading text files uploadFile0.htm: the form uploadFile1.php : the php that processes the form Wednesday 11/03 GPS demo by Jon Caris Homework 7
Week 10 11/08	Monday 11/08 Presentation on GIS file formats by Jon Caris. Main reference is here File uploads: uploadFile1.htm and uploadFile1.php uploadFile2.htm and uploadFile2.php uploadFile3.htm and uploadFile3.php Blobs: storage for binary data Wednesday 11/10 Presentation on Processing and data visualization by Eitan Mendelowitz Eitan's sketches Some examples with potential usefulness for our project: patterns... follow... pulses... animator... puff... reflection... Web Access from a Processing Script Homework 8 <--- due 11/19 Additional Information from Jon: Jon's wiki: http://smithgisclasses.pbworks.com/w/page/32286115/CSC220 Example of GoogleMap Animations GPX to Google Maps animation (very, very cool!) : http://www.chrislacy.net/map/current/index.html uTrack- online GPX track report generator (very cool): http://utrack.crempa.net/ Mike Williams - Google Maps API Tutorial: http://econym.org.uk/gmap/example_cartrip.htm London Tube (looks promising) Website: http://traintimes.org.uk:81/map/tube/?from=map;to=tube Code at github: https://github.com/dracos/underground-live-map Christchurch Earthquake Map: http://www.christchurchquakemap.co.nz/	Processing.org: the main reference and point of entry!
Week 11 11/15	Monday 11/15 Food for thought: Visualization of Wikileaks in Processing by Mike Dewar. Mike says This is a visualisation of activity in Afghanistan from 2004 to 2009 based on the Wikileaks data set. Here we’re thinking of activity as the number of events logged in a small region of the map over a 1 month window. These events consist of all the different types of activity going on in Afghanistan. The intensity of the heatmap represents the number of events logged. The colour range is from 0 to 60+ events over a one month window. We cap the colour range at 60 events so that low intensity activity involving just a handful of events can be seen – in lots of cases there are many more than 60 events in one particular region. The heatmap is constructed for every day in the period from 2004-2009, and the movie runs at 10 days per second. Storing uploaded files on server: in database or in subdirectories? Random subdirectories, md5 hashing, in general, and with md5. Php $_SESSION, and Php examples Cookie Example and link Passing parameters to applets Snapshots from Today's Class Wednesday 11/17	setcookie() function Tutorial on cookies
Week 12 11/22	Monday 11/22 Wednesday 11/24 -- Thanksgiving Break
Week 13 11/29	Monday 11/29 Wednesday 12/1
Week 14 12/06	Monday 12/06 Wednesday 12/08
Week 15 12/13	Monday -- Last Class

Links and Resources

Bash Shell

• Bash Beginners Guide

Linux Utilities

• Good information on Grep (Thanks Sharon!)

MySQL

• MySQL Tutorial ebook.
• Examples of Common Queries on dev.mysql.com
• Select Syntax on dev.mysql.com
• Counting rows with count()

Maps/GIS

• The State of Mapping APIs, Adam DuVander, O'Reilly Radar, 7 Sept. 2010.

• Directions for installing Google Earth under Fedora.

Tips & Tricks

• How to change your login shell automatically

Miscellaneous Information

• 

(c) D. Thiebaut 2010, Dept. Computer Science, Smith College.