This practicum is a half day event that takes place on a Friday from 9am to 12:30pm.
Dates for Spring 2016:
Registration fee is $5. A tutorial booklet will be provided.
Current CUNY graduate students, faculty, and staff, and Baruch & Lehman undergrads, are eligible to register.
Prequisites: MUST have prior GIS experience and basic to intermediate computer skills
Each participant will be provided with a PC that has QGIS 2.8 and Spatialite GUI 1.7 pre-installed. For the sake of simplicity we ask that participants not bring their own laptops for this session. The software is free and open source, and everyone will be shown where it can be accessed and downloaded for future use.
Are you looking to expand your GIS skills? This practicum introduces participants to spatial databases as containers for organizing geographic information and tools for evaluating spatial relationships. The workshop introduces relational and spatial database concepts using the NYC Geodatabase, a resource for mapping neighborhood-level data. Participants will learn how to add database features and tables to GIS software, write SQL and spatial SQL queries in a database environment, and build their own databases.
Specifically we'll cover how spatial databases function and are structured and will learn the following operations: joining tables to features, calculating distances and area, geographic selection and evaluation, geoprocessing, and importing data from different sources.