Geospatial Data Collection and Database Design

Undergraduate

Geospatial data are continuously being collected in real-time and in large quantities, at different scales and for different purposes. This course will explore fundamental database concepts in non-spatial contexts (entity-relationship model, object-oriented database design) and introduce spatial considerations (geometric objects, topology, connectivity) when creating geodatabases. Methods for building effective relational and spatial databases using modern geospatial and non-geospatial software, as well as query-based languages such as SQL. Data capture equipment and tools, such as UAVs (drones), total survey stations, GPS, and online spatial catalogues (including census, climate, and municipal) will be utilized to collect and import spatial and aspatial data into geodatabases. Data quality and assurance, database management systems and geodatabase enterprise solutions, mining of big spatial data, implications of data sharing, and construction of metadatabases will also be discussed. (Prerequisite: ESCI-1151.) (2 lecture, 2 laboratory hours per week.) ESCI 2705. Applied Geophysics Fundamental physical properties and parameters of matter, including density, conductivity, radioactivity, magnetism, dielectric constant and seismic velocity. Theory and principles of geophysical techniques used to assess and monitor near-surface variations in physical properties, including resistivity imaging, electromagnetic mapping, magnetometry, ground penetrating radar, and seismic imaging. Applications 630 Winter 2027 Undergraduate Calendar will focus on environmental problems, but may include geological, forensic, and archaeological studies. May be offered as a full-time two-week course during Inter/Summer session, or as a lecture and laboratory course during the Fall semester. (Prerequisite: ESCI-2111 or consent of instructor.) (MATH 1720/1760 and PHYS 1310/1410 recommended.)