ESRI Virtual CampusGIS PracticumSpatial DB Practicum
This is the "Spatial DB Practicum" page of the "Geographic Information Systems (GIS)" guide.
Alternate Page for Screenreader Users
Skip to Page Navigation
Skip to Page Content

Geographic Information Systems (GIS)  

GIS is an integrated collection of software and data used to visualize and organize geographic data, conduct geographic analysis, and create maps.
Last Updated: Jul 2, 2014 URL: Print Guide RSS Updates

Spatial DB Practicum Print Page


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.



    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

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

      Room 421 - (646) 312-1657
      Send Email
      Subject Expertise:
      Geography, GIS, Demography

      Loading  Loading...