GPHY384, lectures 8&9
GPHY384, lectures 8&9 GPHY 384
Popular in Advanced GIS and Spatial Analysis
Popular in Earth Sciences
verified elite notetaker
This 2 page Class Notes was uploaded by Sarah Massar on Friday February 12, 2016. The Class Notes belongs to GPHY 384 at Montana State University taught by Stuart Challenger in Fall 2015. Since its upload, it has received 44 views. For similar materials see Advanced GIS and Spatial Analysis in Earth Sciences at Montana State University.
Reviews for GPHY384, lectures 8&9
Report this Material
What is Karma?
Karma is the currency of StudySoup.
You can buy or earn more Karma at anytime and redeem it for class notes, study guides, flashcards, and more!
Date Created: 02/12/16
GPHY384 Lecture 8&9 2/09&11 Lecture 8 2/09 SQL: +SQL- Structure query language -used to define and select certain attributes in a dataset -need to have three words -Select, From, Where Example: SELECT <column> FROM <table> WHERE <Boolean expression> +Boolean expression- something that is either “on/off” or “yes/no” or “true/false” +Boolean connectors- and/or -an SQL is done by opening the attribute table, clicking on the desired column, and then selecting SQL from the top menu. So the column will already be defined and will appear as an * - (SELECT * FROM attribute of roads WHERE) will already be in the system -2 types of stings: text and numeric -Text strings are surrounded by single quotes, numeric is not: -Numeric: WHERE length=1 -Text: WHERE ‘name=I-90’ -With connectors: WHERE “Stream_NAME” = ‘Bozeman Creek’ or “Stream_NAME” = ‘E Gallatin’ -Census data is text, even though it is written with numbers, because the number ‘0’ proceeds many of the numbers and it would be omitted in numeric form Ex. State FIP code is 30 and County FIP is 035. Together they make 30035. If it were in numeric the 0 would be omitted and it would be 3035, which is not correct NOTE: There needs to be spaces in between every expression in the SQL Lecture 9 2/11 GIS: -Can think of GIS standing for two things: 1. Geographic Information Systems a. System- All of the components of things we are working with i. hardware, software, data, warmware 2. Geographic Information Sciences a. Science- knowledge that requires study b. GIS has many supporting sciences i. Geodesy, Computer Science, Cartography, Geography, Math/Stats +Applications- -Data development/management -data query -data manipulation -data distribution -data visualization -data distribution -GIS(systems and sciences) supports and gives the capability to do applications +Applied Sciences and Disciplines -land use planning -hydro/geological modeling -soil mapping/modeling -The needs of applied sciences and disciplines drives the creation of applications -Software developers shouldn’t be making applications just because they can. They should be made because there is a need for them
Are you sure you want to buy this material for
You're already Subscribed!
Looks like you've already subscribed to StudySoup, you won't need to purchase another subscription to get this material. To access this material simply click 'View Full Document'