Geographic Information Systems (GIS)

Registration

This practicum is a half day event that takes place on a Friday from 9am to 12:30pm. 

No future workshop is planned at this time.

Registration fee is $5. A tutorial booklet will be provided.

Current CUNY graduate students, faculty, and staff, and Baruch undergrads are eligible to register.

Prequisites: MUST have prior GIS experience and basic to intermediate computer skills

Laptops

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.

Course Materials

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.

Objectives

Participants will:

  • 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

    Geospatial Data Librarian

    Frank Donnelly
    Contact:
    Newman Library
    151 E 25th Street
    Box H-0520
    New York, NY 10010

    (646) 312-1657
    Website / Blog Page