GEOG281 Lecture Notes - Lecture 6: Sql, Database, Relational Database Management System

• School: University of Waterloo
• Department: Geography and Environmental Management
• Course: GEOG281
• Professor: Su Yin Tan

Document Summary

To transform data into useful informaion to saisfy the requirements or objecives of decision-makers at all levels of detail. View complex relaionships between data sets: make beter decisions. Spaial relaionships are important but diicult to measure. Diicult mathemaics: quanity vs. quality quesions, muliple objecives. Gis can address some (but not all) of these diiculies. The selecive display and retrieval of informaion from a database. The ability to query and retrieve data based on some user-deined criteria is a necessary feature of a gis. Data retrieval involves the capability of easily selecing data for graphic or atribute ediing, updaing, querying, analysis and/or display. Select features using atribute data (e. g. using sql) Results can be mapped or presented in convenional database form. Can be used to produce maps of subsets of the data or chloropleth maps. Clicking on features on the map to ind out their atribute values.