This practicum is a half day event that takes place on a Friday from 9am to 12:30pm.
Dates for fall 2014 will be posted at the end of the summer.
Registration fee is $10. Hot beverages (coffee & tea) and a tutorial booklet will be provided.
Graduate students, faculty and staff from throughout CUNY are eligible to register. Baruch undergrads must gain instructor permission prior to registering.
Prequisites: MUST have prior GIS experience and basic to intermediate computer skills
Each participant will have a PC, but since the software is free and open source, participants are welcome to bring and work off of their own laptops.
If you opt to do this, you should download and install both software packages on your laptop before the workshop begins. We will use the Spatialte GUI and QGIS 1.8, which you can download here.
Due to their small screen size and lack of processing power, small netbooks are not appropriate for this workshop.
Intro to Spatial Databases Using Open Source Software
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.
- Expand on their previous GIS experience by learning spatial SQL
- Gain competency with a specific geodatabase platform (Spatialite)
- Gain familiarity with a specific database resource (the NYC Geodatabase)
- Add geodatabase features and tables to GIS software for mapping and analysis
- Learn basic relational database principles and SQL
- Build on existing databases and create new ones for their own projects